PROCESSINGPURPOSE
The PROCESSINGPURPOSE table defines the purposes that the personal data of an individual can be processed for.
This table is used by the following domain: Party Domain
| Field | Description | Data Type | Null Option | Is PK |
|---|---|---|---|---|
| PROC_PURP_ID | The primary key of the processing purpose. | BIGINT | Not null | Yes |
| PROC_PURP_TP_CD | References the processing purpose type that this processing purpose is based on. Examples for processing purpose types are marketing and analysis. It is the PROC_PURP_TP_CD value of the appropriate CDPROCPURPTP table. | BIGINT | Not null | No |
| DEFAULT_TIME | Holds the default validity period of consent referencing this processing purpose, according
to ISO 8601. Note: It is the responsibility of the user creating the consent to set the end date of
the consent equal to its start date plus the DEFAULT_TIME.
|
VARCHAR(100) | Null | No |
| ANONYMIZATION | Indicates whether the data to be processed must be pseudonymized, that is, processed in such
a manner that the personal data can no longer be attributed to a specific individual without the use
of additional information. It can be either of the following numbers:
|
BIGINT | Null | No |
| START_DT | The date and time when the processing purpose becomes valid. | TIMESTAMP | Not null | No |
| END_DT | The date and time when the processing purpose is no longer valid. | TIMESTAMP | Null | No |
| LAST_UPDATE_USER | The name of the user who last updated the processing purpose. | 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 purpose. A unique ID is generated. | BIGINT | Null | No |