GCIS_TCIST_GROUPINGASSOC

Database

SDSNZS01_GCM

Schema

CDCPADM_GCM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 GROUPING_ASSOC_ID BIGINT 8
2 INSTANCE_PK INTEGER 4
3 GROUPING_ID BIGINT 8
4 DESCRIPTION CHARACTER VARYING(255) 255
5 EFFECT_START_DT TIMESTAMP 8
6 EFFECT_END_DT TIMESTAMP 8
7 LAST_UPDATE_USER CHARACTER VARYING(20) 20
8 LAST_UPDATE_DT TIMESTAMP 8
9 LAST_UPDATE_TX_ID BIGINT 8
10 CREATED_BY CHARACTER VARYING(20) 20
11 CREATE_DT TIMESTAMP 8
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