INT_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 QTR_NO CHARACTER VARYING(1) 1
9 MAX_MONTH INTEGER 4
10 MAX_MONTH_QTR INTEGER 4
11 MAX_QTR CHARACTER VARYING(1) 1
12 FISCAL_YEAR CHARACTER VARYING(25) 25
13 REPORTING_AMOUNT NUMERIC(38,6) 19
14 CUMULATIVE_REPORTING_AMOUNT NUMERIC(38,6) 19
15 FTE NUMERIC(38,6) 19
16 SCOPE_1_EMISSIONS NUMERIC(38,4) 19
17 SCOPE_2_EMISSIONS NUMERIC(38,4) 19
18 SCOPE_3_EMISSIONS NUMERIC(38,4) 19
19 INDIRECT_EMISSIONS NUMERIC(38,4) 19
20 CUMULATIVE_SCOPE_1_EMISSIONS NUMERIC(38,4) 19
21 CUMULATIVE_SCOPE_2_EMISSIONS NUMERIC(38,4) 19
22 CUMULATIVE_SCOPE_3_EMISSIONS NUMERIC(38,4) 19
23 CUMULATIVE_INDIRECT_EMISSIONS NUMERIC(38,4) 19