FCT_SUSTAINABILITY_EMISSIONS_FTE_V

Database

INSNZP01_R12

Schema

R12PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 LEVEL_3_GROUP_1 CHARACTER VARYING(50) 50
2 REGION CHARACTER VARYING(50) 50
3 CATEGORY CHARACTER VARYING(50) 50
4 MOD_UNITS CHARACTER VARYING(50) 50
5 MONTH_NAME CHARACTER VARYING(10) 10
6 MONTH_NO INTEGER 4
7 QUARTER_NAME CHARACTER VARYING(9) 9
8 MAX_MONTH INTEGER 4
9 MAX_MONTH_QTR INTEGER 4
10 MAX_QTR CHARACTER VARYING(1) 1
11 FISCAL_YEAR CHARACTER VARYING(25) 25
12 PRIOR_YEAR_FISCAL_YEAR CHARACTER VARYING(25) 25
13 PRIOR_YEAR_QUARTER_NAME CHARACTER VARYING(9) 9
14 REPORTING_AMOUNT NUMERIC(38,6) 19
15 FTE NUMERIC(38,6) 19
16 CUMULATIVE_REPORTING_AMOUNT NUMERIC(38,6) 19
17 ANNUALIZED_SUM NUMERIC(38,6) 19
18 CONSUMPTION_INTENSITY NUMERIC(38,6) 19
19 PRIOR_YEAR_REPORTING_AMOUNT NUMERIC(38,6) 19
20 PRIOR_YEAR_CONSUMPTION_INTENSITY NUMERIC(38,6) 19
21 PRIOR_YEAR_CUMULATIVE_REPORTING_AMOUNT NUMERIC(38,6) 19
22 TARGET NUMERIC(38,6) 19
23 SCOPE_1_EMISSIONS NUMERIC(38,4) 19
24 SCOPE_2_EMISSIONS NUMERIC(38,4) 19
25 SCOPE_1_2_EMISSIONS NUMERIC(38,4) 19
26 SCOPE_3_INDIRECT_EMISSIONS NUMERIC(38,4) 19
27 CUMULATIVE_SCOPE_1_EMISSIONS NUMERIC(38,4) 19
28 CUMULATIVE_SCOPE_2_EMISSIONS NUMERIC(38,4) 19
29 CUMULATIVE_SCOPE_1_2_EMISSIONS NUMERIC(38,4) 19
30 CUMULATIVE_SCOPE_3_INDIRECT_EMISSIONS NUMERIC(38,4) 19
31 PRIOR_YEAR_SCOPE_1_EMISSIONS NUMERIC(38,4) 19
32 PRIOR_YEAR_SCOPE_2_EMISSIONS NUMERIC(38,4) 19
33 PRIOR_YEAR_SCOPE_1_2_EMISSIONS NUMERIC(38,4) 19
34 PRIOR_YEAR_SCOPE_3_INDIRECT_EMISSIONS NUMERIC(38,4) 19
35 EMISSIONS_TARGET NUMERIC(38,7) 19
36 CUMULATIVE_EMISSIONS_TARGET NUMERIC(38,7) 19
37 MAX_YR CHARACTER VARYING(25) 25
38 MAX_QTR_YR CHARACTER VARYING(9) 9
39 FLAG_REGION INTEGER 4