GCIS_HST_TCIST_GROUPINGASSOC_HIST

Database

SDSNZS01_GCM

Schema

CDCPADM_GCM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 AUDIT_ID INTEGER 4
2 GROUPING_ASSOC_ID BIGINT 8
3 INSTANCE_PK INTEGER 4
4 GROUPING_ID BIGINT 8
5 DESCRIPTION CHARACTER VARYING(255) 255
6 EFFECT_START_DT TIMESTAMP 8
7 EFFECT_END_DT TIMESTAMP 8
8 LAST_UPDATE_USER CHARACTER VARYING(20) 20
9 LAST_UPDATE_DT TIMESTAMP 8
10 LAST_UPDATE_TX_ID BIGINT 8
11 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
12 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
13 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
14 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8