FCT_VOC_HR_INSIGHTS

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 EMPLOYEE_NUMBER CHARACTER VARYING(50) 50
2 STAFF_FIRST_NAME CHARACTER VARYING(100) 100
3 STAFF_SURNAME CHARACTER VARYING(100) 100
4 EMPLOYEE_FTE NUMERIC(18,6) 19
5 TERMINATED_FLAG CHARACTER VARYING(10) 10
6 POSITION_TITLE CHARACTER VARYING(256) 256
7 POSITION_START_DATE DATE 4
8 CURRENT_POSITION_END_DATE DATE 4
9 DIVISION_NAME CHARACTER VARYING(100) 100
10 DEPARTMENT_NAME CHARACTER VARYING(100) 100
11 TEAM_NAME CHARACTER VARYING(100) 100
12 TEAM_LABEL_CASCADE CHARACTER VARYING(100) 100
13 DEPARTMENT_COST_CENTRE CHARACTER VARYING(100) 100
14 HR_EFF_STRT_DATE DATE 4
15 HR_EFF_END_DATE DATE 4
16 REPORT_DATE DATE 4
17 BRANCH_ID NUMERIC(31,0) 19
18 DOM_CODE CHARACTER VARYING(100) 100
19 BRANCH_NAME CHARACTER VARYING(250) 250
20 HUB_NAME CHARACTER VARYING(100) 100
21 TYPE_OF_LOCATION CHARACTER VARYING(100) 100
22 COST_CTR NUMERIC(31,0) 19
23 ORACLE_CC NUMERIC(31,0) 19
24 BRANCH_EFF_STRT_DATE CHARACTER VARYING(50) 50
25 BRANCH_EFF_END_DATE CHARACTER VARYING(50) 50