CFD_TCFDD_SUPER_EMPLOYER_GRP_DTL

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 EMPR_GRP_ID BIGINT 8
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 EMPR_GRP_NUM BIGINT 8
4 EMPR_NUM BIGINT 8
5 EMPR_ID BIGINT 8
6 EMPR_GRP_NAM CHARACTER VARYING(40) 40
7 CORP_PLN_FLG CHARACTER VARYING(1) 1
8 DATA_LOAD_DATE TIMESTAMP 8
9 SNPSHT_DATE TIMESTAMP 8
10 SRC_SYS_ID CHARACTER VARYING(5) 5
11 LOAD_ID BIGINT 8
12 AGGRESSIVE_LOAD_IND CHARACTER VARYING(1) 1
13 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
14 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
15 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
16 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8