FCT_CFO_HR_FTE_AGG_INSIGHT

Database

INSNZP01_R12

Schema

R12PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 Cal_Year BIGINT 8
2 Cal_Year_Month BIGINT 8
3 Year0 BIGINT 8
4 Fin_Year_Month BIGINT 8
5 Level_01_Code CHARACTER VARYING(150) 150
6 Level_02_Code CHARACTER VARYING(150) 150
7 Level_03_Code CHARACTER VARYING(150) 150
8 Level_04_Code CHARACTER VARYING(150) 150
9 Employee_Group_C CHARACTER VARYING(10) 10
10 Employee_Class_C NATIONAL CHARACTER VARYING(250) 250
11 Mtd_Actual_Fte NUMERIC(38,6) 19
12 Mtd_Projected_Ac DOUBLE PRECISION 8
13 Prev_Month_Act NUMERIC(38,6) 19
14 Ytd_Actual NUMERIC(38,6) 19
15 Fy_Actual NUMERIC(38,6) 19
16 Fy_Actual1 NUMERIC(38,6) 19
17 Pcp_Mtd_Actual NUMERIC(38,6) 19
18 Mtd_Budget_Fte DOUBLE PRECISION 8
19 Prev_Month_Bud DOUBLE PRECISION 8
20 Ytd_Budget DOUBLE PRECISION 8
21 Fy_Budget DOUBLE PRECISION 8
22 Fy_Budget1 DOUBLE PRECISION 8
23 Pcp_Mtd_Budget DOUBLE PRECISION 8
24 Mtd_Forecast_Fte DOUBLE PRECISION 8
25 Prev_Month_Fst DOUBLE PRECISION 8
26 Ytd_Forecast DOUBLE PRECISION 8
27 Fy_Forecast DOUBLE PRECISION 8
28 Fy_Forecast1 DOUBLE PRECISION 8
29 Pcp_Mtd_Forecast DOUBLE PRECISION 8
30 Mtd_Strategic_Partner_HC DOUBLE PRECISION 8
31 Prev_Month_Strategic_Partner_HC DOUBLE PRECISION 8
32 Ytd_Strategic_Partner_HC DOUBLE PRECISION 8
33 Fy_Strategic_Partner_HC DOUBLE PRECISION 8
34 Fy_Strategic_Partner_HC1 DOUBLE PRECISION 8