DIM_CUST_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
2 PRDT_SYS_CODE CHARACTER VARYING(3) 3
4 PRDT_SYS_CODE_CDI CHARACTER VARYING(3) 3
5 PRDT_SYS_CUST_NUM_CDI CHARACTER VARYING(30) 30
6 EMP_TYP_CODE CHARACTER VARYING(1) 1
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(30) 30
11 STAFF_OFFER_ELGBLTY_CODE CHARACTER VARYING(1) 1
12 SRC_SYS_ID CHARACTER VARYING(3) 3