CFD_TCFDD_PERSON

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRSN_NUM CHARACTER VARYING(10) 10
2 EFF_STRT_DATE TIMESTAMP 8
3 PRSN_LST_NAM CHARACTER VARYING(20) 20
4 PRSN_PREFRD_NAM CHARACTER VARYING(20) 20
5 EMAIL_ADDR CHARACTER VARYING(100) 100
6 SALARY_GRP_CODE CHARACTER VARYING(10) 10
7 SALARY_GRP_DESC CHARACTER VARYING(50) 50
8 INTN_POST_CODE CHARACTER VARYING(10) 10
9 STD_WRK_HOUR_PER_WK NUMERIC(18,2) 19
10 JND_DATE TIMESTAMP 8
11 CNTRCT_END_DATE TIMESTAMP 8
12 LEAVE_ACR_UNT_TYP_DESC CHARACTER VARYING(50) 50
13 ANN_LEAVE_ACRD_BAL NUMERIC(18,2) 19
14 ANN_LEAVE_ACRD_DATE TIMESTAMP 8
15 LONG_SERV_LEAVE_BAL NUMERIC(18,2) 19
16 SICK_LEAVE_BAL BIGINT 8
17 TRMNTN_DATE TIMESTAMP 8
18 GRADE_CODE CHARACTER VARYING(10) 10
19 GRADE_DESC CHARACTER VARYING(50) 50
20 EMPMT_STAT_CODE CHARACTER VARYING(10) 10
21 EMPMT_STAT_DESC CHARACTER VARYING(50) 50
22 HLDY_ZONE_NUM CHARACTER VARYING(4) 4
23 POSN_CODE CHARACTER VARYING(10) 10
24 INSERT_UID CHARACTER VARYING(10) 10
25 INSERT_DATE TIMESTAMP 8
26 UPD_UID CHARACTER VARYING(10) 10
27 UPD_DATE TIMESTAMP 8
28 EFF_END_DATE TIMESTAMP 8
29 DATA_LOAD_DATE TIMESTAMP 8
30 SNPSHT_DATE TIMESTAMP 8
31 SRC_SYS_ID CHARACTER VARYING(10) 10
32 LOAD_ID BIGINT 8
33 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
34 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
35 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
36 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8