FCT_CFO_HR_FTE_SUMMARY_HIST_INSIGHT

Database

INSNZP01_R12

Schema

R12PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 RPT_LEVEL_IND CHARACTER VARYING(2) 2
2 RPT_LEVEL_TYPE CHARACTER VARYING(8) 8
3 RPT_LEVEL_NAME CHARACTER VARYING(240) 240
4 RPT_LEVEL_CODE CHARACTER VARYING(150) 150
5 RPT_SUB_LEVEL_TYPE CHARACTER VARYING(8) 8
6 RPT_SUB_LEVEL_NAME CHARACTER VARYING(240) 240
7 RPT_SUB_LEVEL_CODE CHARACTER VARYING(150) 150
8 CAL_YEAR_MONTH CHARACTER VARYING(200) 200
9 CAL_MONTH_LAB CHARACTER VARYING(200) 200
10 CAL_MONTH_PREV CHARACTER VARYING(200) 200
11 MOVEMENT_TYPE CHARACTER VARYING(27) 27
12 PERMANENT_MTD NUMERIC(38,6) 19
13 PERMANENT_MTD_PREV NUMERIC(38,6) 19
14 CONTRACTOR_MTD NUMERIC(38,6) 19
15 CONTRACTOR_MTD_PREV NUMERIC(38,6) 19
16 MTD_ACTUAL_FTE NUMERIC(38,6) 19
17 PREV_MONTH_ACT NUMERIC(38,6) 19
18 MTD_ACTUAL_MVMT NUMERIC(38,6) 19
19 YTD_ACTUAL_FTE NUMERIC(38,6) 19
20 MTD_PROJECTED_FTE DOUBLE PRECISION 8
21 FY_ACTUAL_FTE NUMERIC(38,6) 19
22 MTD_BUDGET_FTE DOUBLE PRECISION 8
23 YTD_BUDGET_FTE DOUBLE PRECISION 8
24 FY_BUDGET_FTE DOUBLE PRECISION 8
25 MTD_FORECAST_FTE DOUBLE PRECISION 8
26 YTD_FORECAST_FTE DOUBLE PRECISION 8
27 FY_FORECAST_FTE DOUBLE PRECISION 8
28 NEW_HIRES NUMERIC(38,6) 19
29 INTERNAL_TRANSFER NUMERIC(38,6) 19
30 SECONDMENT NUMERIC(38,6) 19
31 MATERNITY_LEAVE_LWOP NUMERIC(38,6) 19
32 EMPLOYEE_INITIATED_TURNOVER NUMERIC(38,6) 19
33 REDUNDANCY NUMERIC(38,6) 19
34 CHANGE_IN_HOURS NUMERIC(38,6) 19
35 CONTRACTORS_MOVEMENT NUMERIC(38,6) 19
36 OTHERS_MOVEMENT NUMERIC(38,6) 19
37 FTE_PAID_MAT_LEAVE NUMERIC(38,6) 19
38 OPS_FTE NUMERIC(38,6) 19
39 PLR_FTE NUMERIC(38,6) 19