CDI_TCFDD_CUSTOMER_AUX_EMP

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_SYS_CODE CHARACTER VARYING(10) 10
2 BRND_CODE CHARACTER VARYING(10) 10
3 PRDT_SYS_CUST_NUM CHARACTER VARYING(30) 30
4 EFF_STRT_DATE TIMESTAMP 8
5 BRND_ID BIGINT 8
6 EMP_TYP_ID BIGINT 8
7 EMP_TYP_CODE CHARACTER VARYING(4) 4
8 EMP_TRMNTN_DATE TIMESTAMP 8
9 EMP_BNFT_END_DATE TIMESTAMP 8
10 EFF_END_DATE TIMESTAMP 8
11 DATA_LOAD_DATE TIMESTAMP 8
12 SNPSHT_DATE TIMESTAMP 8
13 SRC_SYS_ID CHARACTER VARYING(5) 5
14 LOAD_ID BIGINT 8
15 EMP_STRT_DATE TIMESTAMP 8
16 PARTNER_EMP_NUM CHARACTER VARYING(20) 20
17 STAFF_OFFER_ELGBLTY_ID BIGINT 8
18 STAFF_OFFER_ELGBLTY_CODE CHARACTER VARYING(20) 20
19 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
20 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
21 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
22 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8