IDENTIFIER
The IDENTIFIER table provides an additional way of distinguishing a contact that is natural to them. For example: social security number, driver's license number, or passport number.
This table is used by the following domains.
Name | Comment | Datatype | Null Option | Is PK |
---|---|---|---|---|
IDENTIFIER_ID | A unique, system-generated key that identifies a party identification in the system. | BIGINT | Not Null | Yes |
ID_STATUS_TP_CD | Identifies the status of the identifier provided by the party. For example: "applied for," "expired," "certified," and so forth. | BIGINT | Null | No |
CONT_ID | A unique, system-generated key that identifies a party in the system. | BIGINT | Not Null | No |
ID_TP_CD | Identifies the type of identifier provided by the party. For example: "social security number," "passport," "driver's license number," and so forth. | BIGINT | Not Null | No |
REF_NUM | The actual identifier text provided by a party. For example, if the Identification Type Code indicates a social security number was provided, then this column contains the actual 9 characters. | VARCHAR(50) | Null | No |
START_DT | The date when this record becomes active. | TIMESTAMP | Not Null | No |
END_DT | The date when this record becomes inactive. | TIMESTAMP | Null | No |
EXPIRY_DT | The date on which the particular identification expires, such as a Passport expiry date. | TIMESTAMP | Null | No |
LAST_UPDATE_DT | When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. | TIMESTAMP | Not Null | No |
LAST_UPDATE_USER | The ID of the user who last updated the data. | VARCHAR(20) | Null | No |
LAST_UPDATE_TX_ID | A unique, system-generated key that identifies the specific transaction within the log system that either created, updated, or deleted the data row. | BIGINT | Null | No |
ASSIGNED_BY | Used to associate a particular contract role to a particular identifier. For example: an employee number can be used as an identifier on a group contract. | BIGINT | Null | No |
IDENTIFIER_DESC | Provides extra space for information that can be used for an additional definition or as free form comments to provide further meaning. | VARCHAR(255) | Null | No |
ISSUE_LOCATION | The issue location of the identification item. | VARCHAR(30) | Null | No |
LAST_USED_DT | The date that this data was last used. There is no business logic associated with this field. | TIMESTAMP | Null | No |
LAST_VERIFIED_DT | The date that this data was last verified. There is no business logic associated with this field. | TIMESTAMP | Null | No |
SOURCE_IDENT_TP_CD | Identifies the type for the source identifier. | BIGINT | Null | No |