NATIVEKEY
The NATIVEKEY table provides the link between the system Contract ID and the external administrative system Contract ID.
This table is used by the following domains.
Name | Comment | Datatype | Null Option | Is PK |
---|---|---|---|---|
NATIVE_KEY_ID | A unique, system-generated key that identifies a contract native key in the system. | BIGINT | Not Null | Yes |
ADMIN_CONTRACT_ID | The actual text or number that is used in the administrative source system to identify a contract. | VARCHAR(150) | Null | No |
CONTRACT_ID | A unique, system-generated key that identifies a contract component in the system. | BIGINT | Not Null | No |
ADMIN_FLD_NM_TP_CD | Identifies the field name that the native key refers to, for example, policy number, policy suffix, account number, branch, and so forth. | BIGINT | 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 |
CONTRACT_COMP_IND | Describes which table the native key applies to. If the contract component indicator is 'Y', the native key applies to the Contract Component. If the contract indicator is not 'Y', the native key applies to the Contract. The contract ID is the value from the Contract Component (the contract component ID). | CHAR(1) | Null | No |