DIM_CUST_H_SOURCE_CUST_AUX_EMP

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_SYS_CUST_NUM CHARACTER VARYING(30) 30
5 PRDT_SYS_CUST_NUM_CDI CHARACTER VARYING(30) 30
6 EMP_TYP_CODE CHARACTER VARYING(4) 4
7 EMP_TRMNTN_DATE TIMESTAMP 8
8 EMP_BNFT_END_DATE TIMESTAMP 8
9 EMP_STRT_DATE TIMESTAMP 8
10 PARTNER_EMP_NUM CHARACTER VARYING(20) 20
11 STAFF_OFFER_ELGBLTY_CODE CHARACTER VARYING(20) 20
12 SRC_SYS_ID CHARACTER VARYING(5) 5
14 EFF_STRT_DATE TIMESTAMP 8
15 EFF_END_DATE TIMESTAMP 8
16 IS_RECORD_CURRENT CHARACTER VARYING(3) 3
17 IS_RECORD_DELETED CHARACTER VARYING(3) 3
18 SNPSHOT_DATE TIMESTAMP 8