GCIS_TCIST_HPS

Database

SDSNZS01_GCM

Schema

CDCPADM_GCM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PROD_SYS_NAME CHARACTER VARYING(10) 10
2 PROD_SYS_ID CHARACTER VARYING(3) 3
3 TRUSTED_IND CHARACTER VARYING(1) 1
4 UPDATEABLE_IND CHARACTER VARYING(1) 1
5 USERENTERED CHARACTER VARYING(10) 10
6 TIMESTAMPENTERED TIMESTAMP 8
7 USERWRITTEN CHARACTER VARYING(10) 10
8 TIMESTAMPWRITTEN TIMESTAMP 8
9 USE_COUNT INTEGER 4
10 MULT_SYS_CUSTID_FL CHARACTER VARYING(1) 1
11 DEDUP_FLAG CHARACTER VARYING(1) 1
12 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
13 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
14 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
15 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8