FCT_CFO_HR_FTE_AGG1_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 Level_05_Code CHARACTER VARYING(150) 150
10 Level_06_Code CHARACTER VARYING(150) 150
11 Level_07_Code CHARACTER VARYING(150) 150
12 Level_08_Code CHARACTER VARYING(150) 150
13 Level_09_Code CHARACTER VARYING(150) 150
14 Level_10_Code CHARACTER VARYING(150) 150
15 Mtd_Actual_Fte NUMERIC(38,6) 19
16 Mtd_Projected_Ac DOUBLE PRECISION 8
17 Prev_Month_Act NUMERIC(38,6) 19
18 Ytd_Actual NUMERIC(38,6) 19
19 Fy_Actual NUMERIC(38,6) 19
20 Fy_Actual1 NUMERIC(38,6) 19
21 Pcp_Mtd_Actual NUMERIC(38,6) 19
22 Mtd_Budget_Fte DOUBLE PRECISION 8
23 Prev_Month_Bud DOUBLE PRECISION 8
24 Ytd_Budget DOUBLE PRECISION 8
25 Fy_Budget DOUBLE PRECISION 8
26 Fy_Budget1 DOUBLE PRECISION 8
27 Pcp_Mtd_Budget DOUBLE PRECISION 8
28 Mtd_Forecast_Fte DOUBLE PRECISION 8
29 Prev_Month_Fst DOUBLE PRECISION 8
30 Ytd_Forecast DOUBLE PRECISION 8
31 Fy_Forecast DOUBLE PRECISION 8
32 Fy_Forecast1 DOUBLE PRECISION 8
33 Pcp_Mtd_Forecast DOUBLE PRECISION 8
34 Mtd_Strategic_Partner_HC DOUBLE PRECISION 8
35 Prev_Month_Strategic_Partner_HC DOUBLE PRECISION 8
36 Ytd_Strategic_Partner_HC DOUBLE PRECISION 8
37 Fy_Strategic_Partner_HC DOUBLE PRECISION 8
38 Fy_Strategic_Partner_HC1 DOUBLE PRECISION 8