CDADMINFLDNMTP
The CDADMINFLDNMTP table contains the valid values for the native key field name type code and its descriptions.
This table is used by the following domain.
| Name | Comment | Datatype | Null Option | Is PK |
|---|---|---|---|---|
| LANG_TP_CD | Identifies a spoken language, such as English, French, Spanish, or German. When used as part of the primary key of a code value lookup table, the Language Type Code also represents the language of the code name. | BIGINT | Not Null | Yes |
| 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 | Not Null | Yes |
| NAME | A short, meaningful label for the value of the type code. | VARCHAR(120) | Not Null | No |
| DESCRIPTION | Description provides extra information, which can be used either as an additional definition of the type code value or as free form comments used by the user to provide further meaning to the type code. | VARCHAR(255) | Null | No |
| ADMIN_SYS_TP_CD | Uniquely identifies the administrative source system for a contract. Examples include Ingenium, Alltel, Huon, and so forth. | BIGINT | Not Null | No |
| SIZE_NUM | The length or number of digits used by the native key field. | DECIMAL(2,0) | Null | No |
| DATATYPE_NAME | The name of the datatype for the native key field. | VARCHAR(40) | Null | No |
| DISPLAYED_IND | Indicates whether this is the native key field to be displayed to the user. | CHAR(1) | Null | No |
| PRESENT_SEQ_NUM | The order by which the contract's administrative source system understands the native key fields. | SMALLINT | Null | No |
| EXPIRY_DT | The date that the type code is no longer valid. | 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 |