CFD_TCFDD_SUPER_EMPLOYEE_DTL

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_SYS_CODE CHARACTER VARYING(10) 10
2 EMP_DTL_NUM BIGINT 8
3 EFF_STRT_DATE TIMESTAMP 8
4 EMPR_GRP_NUM BIGINT 8
5 EMPR_GRP_ID BIGINT 8
6 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
7 EMPR_INTN_REF_NUM CHARACTER VARYING(10) 10
8 EMP_STRT_DATE TIMESTAMP 8
9 EMP_END_DATE TIMESTAMP 8
10 EMP_SALARY_AMT NUMERIC(18,2) 19
11 VESTING_OVRDE_FLG CHARACTER VARYING(1) 1
12 PRE86_OVRDE_FLG CHARACTER VARYING(1) 1
13 CORP_TO_PERS_STAT_ID BIGINT 8
14 CORP_TO_PERS_STAT_CODE CHARACTER VARYING(1) 1
15 EFF_END_DATE TIMESTAMP 8
16 DATA_LOAD_DATE TIMESTAMP 8
17 SNPSHT_DATE TIMESTAMP 8
18 SRC_SYS_ID CHARACTER VARYING(5) 5
19 LOAD_ID BIGINT 8
20 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
21 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
22 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
23 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8