ZCH_CLNS_LOC_RECORDS_GT
ZCH_CLNS_LOC_RECORDS_GT table is used by ESS
Details
-
Schema: FUSION
-
Object owner: ZCH
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RECORD_ID | NUMBER | 18 | Yes | Record id | |
| COUNTRY | VARCHAR2 | 10 | COUNTRY | ||
| RECORD_VERSION | NUMBER | 18 | Yes | Record version | |
| UNIQUE_NAME_SUFFIX | VARCHAR2 | 540 | Unique name suffix | ||
| USAGE_STATUS_CODE | VARCHAR2 | 30 | Usage status code | ||
| VALIDATION_MSG_CODE | VARCHAR2 | 30 | Validation message code | ||
| VALIDATION_MSG_TEXT | VARCHAR2 | 240 | Validation message text | ||
| PARENT_RECORD_ID | NUMBER | 18 | The identifier of parent record for this address. | ||
| RECORD_TYPE | VARCHAR2 | 20 | Yes | The record type is the name of the verification type such as Phone, Email or Address. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| ZCH_CLNS_LOC_RECORDS_GT_N1 | Non Unique | USAGE_STATUS_CODE |
| ZCH_CLNS_LOC_RECORDS_GT_PK | Unique | RECORD_ID |