CFD_TCFDD_POSITION

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 POSN_CODE CHARACTER VARYING(10) 10
2 EFF_STRT_DATE TIMESTAMP 8
3 POSN_TITLE CHARACTER VARYING(30) 30
4 POSN_CMPY_CODE CHARACTER VARYING(10) 10
5 POSN_CMPY_DESC CHARACTER VARYING(30) 30
6 POSN_DIV_CODE CHARACTER VARYING(10) 10
7 POSN_DIV_DESC CHARACTER VARYING(30) 30
8 POSN_DEPT_CODE CHARACTER VARYING(10) 10
9 POSN_DEPT_DESC CHARACTER VARYING(30) 30
10 POSN_SUB_DEPT_CODE CHARACTER VARYING(10) 10
11 POSN_SUB_DEPT_DESC CHARACTER VARYING(30) 30
12 POSN_SCTN_CODE CHARACTER VARYING(10) 10
13 POSN_SCTN_DESC CHARACTER VARYING(30) 30
14 POSN_SUB_SCTN_CODE CHARACTER VARYING(10) 10
15 POSN_SUB_SCTN_DESC CHARACTER VARYING(30) 30
16 POSN_ESTBMNT_CODE CHARACTER VARYING(10) 10
17 POSN_SALARY_GRP_CODE CHARACTER VARYING(10) 10
18 POSN_SALARY_GRP_DESC CHARACTER VARYING(30) 30
19 POSN_GRADE_CODE CHARACTER VARYING(10) 10
20 POSN_STAT_CODE CHARACTER VARYING(10) 10
21 POSN_STAT_DESC CHARACTER VARYING(30) 30
22 POSN_WRK_HOUR_PER_WK NUMERIC(18,2) 19
23 POSN_OPEN_FTE NUMERIC(18,2) 19
24 POSN_END_DATE TIMESTAMP 8
25 MGR_POSN_CODE CHARACTER VARYING(10) 10
26 NXT_MGR_POSN_CODE CHARACTER VARYING(10) 10
27 MGMT_HRCHY_1_CODE CHARACTER VARYING(10) 10
28 MGMT_HRCHY_2_CODE CHARACTER VARYING(10) 10
29 MGMT_HRCHY_3_CODE CHARACTER VARYING(10) 10
30 MGMT_HRCHY_4_CODE CHARACTER VARYING(10) 10
31 POSN_LVL_NUM NUMERIC(18,2) 19
32 CC_CODE CHARACTER VARYING(10) 10
33 INSERT_UID CHARACTER VARYING(10) 10
34 INSERT_DATE TIMESTAMP 8
35 UPD_UID CHARACTER VARYING(10) 10
36 UPD_DATE TIMESTAMP 8
37 EFF_END_DATE TIMESTAMP 8
38 DATA_LOAD_DATE TIMESTAMP 8
39 SNPSHT_DATE TIMESTAMP 8
40 SRC_SYS_ID CHARACTER VARYING(10) 10
41 LOAD_ID BIGINT 8
42 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
43 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
44 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
45 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8