FCT_CFO_HR_FTE_INSIGHT_BK0906

Database

INSNZP01_R12

Schema

R12PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 EMPLOYEE_GROUP_CODE CHARACTER VARYING(10) 10
2 EMPLOYEE_GROUP_NAME CHARACTER VARYING(50) 50
3 EMPLOYEE_CLASS_CODE NATIONAL CHARACTER VARYING(250) 250
4 EMPLOYEE_CLASS_NAME CHARACTER VARYING(266) 266
5 COST_CENTRE_CODE CHARACTER VARYING(103) 103
6 PERIODDETAIL CHARACTER VARYING(200) 200
7 PERIOD_NAME CHARACTER VARYING(6) 6
8 CAL_YEAR CHARACTER VARYING(4) 4
9 CAL_MONTH CHARACTER VARYING(2) 2
10 CAL_YEAR_MONTH CHARACTER VARYING(200) 200
11 FIN_YEAR CHARACTER VARYING(4) 4
12 FIN_MONTH CHARACTER VARYING(2) 2
13 FIN_YEAR_MONTH CHARACTER VARYING(6) 6
14 MTD_ACTUAL_FTE NUMERIC(38,6) 19
15 MTD_PROJECTED_ACTUAL_FTE DOUBLE PRECISION 8
16 PREV_MONTH_ACT NUMERIC(38,6) 19
17 YTD_ACTUAL NUMERIC(38,6) 19
18 FY_ACTUAL NUMERIC(38,6) 19
19 FY_ACTUAL1 NUMERIC(38,6) 19
20 PCP_MTD_ACTUAL NUMERIC(38,6) 19
21 MTD_BUDGET_FTE DOUBLE PRECISION 8
22 PREV_MONTH_BUD DOUBLE PRECISION 8
23 YTD_BUDGET DOUBLE PRECISION 8
24 FY_BUDGET DOUBLE PRECISION 8
25 FY_BUDGET1 DOUBLE PRECISION 8
26 PCP_MTD_BUDGET DOUBLE PRECISION 8
27 MTD_FORECAST_FTE DOUBLE PRECISION 8
28 PREV_MONTH_FST DOUBLE PRECISION 8
29 YTD_FORECAST DOUBLE PRECISION 8
30 FY_FORECAST DOUBLE PRECISION 8
31 FY_FORECAST1 DOUBLE PRECISION 8
32 PCP_MTD_FORECAST DOUBLE PRECISION 8
33 STRATEGIC_PARTNER_HEADCOUNT DOUBLE PRECISION 8
34 PREV_MONTH_STRATEGIC_PARTNER_HEADCOUNT DOUBLE PRECISION 8
35 YTD_STRATEGIC_PARTNER_HEADCOUNT DOUBLE PRECISION 8
36 FY_STRATEGIC_PARTNER_HEADCOUNT DOUBLE PRECISION 8
37 FY_STRATEGIC_PARTNER_HEADCOUNT1 DOUBLE PRECISION 8
38 PCP_MTD_STRATEGIC_PARTNER_HEADCOUNT DOUBLE PRECISION 8