GCIS_HST_TCIST_CONTACTREL

Database

SDSNZS01_GCM

Schema

CDCPADM_GCM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CONT_REL_ID BIGINT 8
2 REL_TP_CD BIGINT 8
3 REL_DESC CHARACTER VARYING(255) 255
4 START_DT TIMESTAMP 8
5 END_DT TIMESTAMP 8
6 TO_CONT_ID INTEGER 4
7 FROM_CONT_ID INTEGER 4
8 CREATE_DT TIMESTAMP 8
9 CREATE_USER CHARACTER VARYING(20) 20
10 LAST_UPDATE_DT TIMESTAMP 8
11 LAST_UPDATE_USER CHARACTER VARYING(20) 20
12 REL_ASSIGN_TP_CD BIGINT 8
13 LAST_UPDATE_TX_ID BIGINT 8
14 END_REASON_TP_CD BIGINT 8
15 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
16 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
17 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
18 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8