PROCESSINGACTIVITY
An entry in the PROCESSINGACTIVITY table defines the relationship between a processing activity and a processing purpose. A processing purpose can be associated with several processing activities.
This table is used by the following domain: Party Domain
Field | Description | Data Type | Null Option | Is PK |
---|---|---|---|---|
PROC_ACT_ID | The primary key of the processing activity. | BIGINT | Not null | Yes |
PROC_PURP_ID | References the processing purpose that this processing activity is associated with. It is the PROC_PURP_ID value of the appropriate PROCESSINGPURPOSE table. | BIGINT | Not null | No |
PROC_ACT_TP_CD | References the processing activity type that this processing activity is based on. Examples for processing activity types are collection or distribution. It is the PROC_ACT_TP_CD value of the appropriate CDPROCACTTP table. | BIGINT | Not null | No |
START_DT | The date and time when the processing activity becomes valid. | TIMESTAMP | Not null | No |
END_DT | The date and time when the processing activity is no longer valid. | TIMESTAMP | Null | No |
LAST_UPDATE_USER | The name of the user who last updated the processing activity. | VARCHAR(20) | Null | No |
LAST_UPDATE_DT | The time stamp of the last update. | TIMESTAMP | Not null | No |
LAST_UPDATE_TX_ID | The transaction that updated the processing activity. A unique ID is generated. | BIGINT | Null | No |