CWK_ENVIZI_ENTITY
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | START_PERIOD | CHARACTER VARYING(50) | 50 |
| 2 | END_PERIOD | CHARACTER VARYING(50) | 50 |
| 3 | ASSOCIATE | CHARACTER VARYING(50) | 50 |
| 4 | LEVEL_1_GROUP_1 | CHARACTER VARYING(50) | 50 |
| 5 | LEVEL_2_GROUP_1 | CHARACTER VARYING(50) | 50 |
| 6 | LEVEL_3_GROUP_1 | CHARACTER VARYING(50) | 50 |
| 7 | LEVEL_1_GROUP_2 | CHARACTER VARYING(50) | 50 |
| 8 | LEVEL_2_GROUP_2 | CHARACTER VARYING(50) | 50 |
| 9 | LEVEL_3_GROUP_2 | CHARACTER VARYING(50) | 50 |
| 10 | COUNTRY | CHARACTER VARYING(50) | 50 |
| 11 | REGION | CHARACTER VARYING(50) | 50 |
| 12 | LOCATION | CHARACTER VARYING(50) | 50 |
| 13 | LOCATION_REFERENCE | CHARACTER VARYING(50) | 50 |
| 14 | CATEGORY | CHARACTER VARYING(50) | 50 |
| 15 | DATA_TYPE | CHARACTER VARYING(50) | 50 |
| 16 | ITEM_TYPE | CHARACTER VARYING(50) | 50 |
| 17 | ACCOUNT_STYLE_COMPONENT | CHARACTER VARYING(100) | 100 |
| 18 | SUB_TYPE | CHARACTER VARYING(50) | 50 |
| 19 | ITEM_NUMBER | CHARACTER VARYING(50) | 50 |
| 20 | ACCOUNT_REF_METER_NAME | CHARACTER VARYING(50) | 50 |
| 21 | SUPPLIER | CHARACTER VARYING(50) | 50 |
| 22 | READER_NOTES | CHARACTER VARYING(50) | 50 |
| 23 | OPENED_ON | CHARACTER VARYING(50) | 50 |
| 24 | REPLACED_ON | CHARACTER VARYING(50) | 50 |
| 25 | OCCURRED_ON | CHARACTER VARYING(50) | 50 |
| 26 | UNITS | CHARACTER VARYING(50) | 50 |
| 27 | TOTAL_DATA | NUMERIC(15,4) | 19 |
| 28 | USE_TYPE | CHARACTER VARYING(50) | 50 |
| 29 | USE | CHARACTER VARYING(50) | 50 |
| 30 | USE_PERCENT | NUMERIC(15,4) | 19 |
| 31 | GROUP_MEMBERSHIP_PERCENT | NUMERIC(15,4) | 19 |
| 32 | ACTUAL_REPORTED_QTY | NUMERIC(15,4) | 19 |
| 33 | ESTIMATED_REPORTED_QTY | NUMERIC(15,4) | 19 |
| 34 | ACCRUED_REPORTED_QTY | NUMERIC(15,4) | 19 |
| 35 | TOTAL_REPORTING_AMOUNT | NUMERIC(15,4) | 19 |
| 36 | ENERGY_CONSUMED_GJ | NUMERIC(15,4) | 19 |
| 37 | ENERGY_PRODUCED_GJ | NUMERIC(15,4) | 19 |
| 38 | TOTAL_GJ | NUMERIC(15,4) | 19 |
| 39 | SCOPE_1_CO2E_T | NUMERIC(15,4) | 19 |
| 40 | SCOPE_2_CO2E_T | NUMERIC(15,4) | 19 |
| 41 | SCOPE_3_CO2E_T | NUMERIC(15,4) | 19 |
| 42 | OTHER_CO2E_T | NUMERIC(15,4) | 19 |
| 43 | TOTAL_CO2E_T | NUMERIC(15,4) | 19 |
| 44 | ACTUAL_COST | NUMERIC(15,4) | 19 |
| 45 | ESTIMATED_COST | NUMERIC(15,4) | 19 |
| 46 | ACCRUED_COST | NUMERIC(15,4) | 19 |
| 47 | TOTAL_COST | NUMERIC(15,4) | 19 |
| 48 | COST_UNIT | CHARACTER VARYING(50) | 50 |
| 49 | GROUP_BY | CHARACTER VARYING(60) | 60 |
| 50 | ACCOUNT_METER_LINK | CHARACTER VARYING(10) | 10 |
| 51 | MONTH_NAME | CHARACTER VARYING(10) | 10 |
| 52 | QUARTER_NAME | CHARACTER VARYING(10) | 10 |
| 53 | FISCAL_YEAR | CHARACTER VARYING(25) | 25 |
| 54 | CO2_KGCO2E_UNIT | NUMERIC(15,4) | 19 |
| 55 | CH4_KGCO2E_UNIT | NUMERIC(15,4) | 19 |
| 56 | N2O_KGCO2E_UNIT | NUMERIC(15,4) | 19 |
| 57 | DIRECT_CO2E_KGCO2E_UNIT | NUMERIC(15,4) | 19 |
| 58 | INDIRECT_CO2E_KGCO2E_UNIT | NUMERIC(15,4) | 19 |
| 59 | UPLIFT | NUMERIC(15,4) | 19 |
| 60 | DIRECT_CO2E_T | NUMERIC(15,4) | 19 |
| 61 | INDIRECT_CO2E_T | NUMERIC(15,4) | 19 |
| 62 | DATA_DATE | TIMESTAMP | 8 |
| 63 | LOAD_ID | INTEGER | 4 |
| 64 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 65 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 66 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 67 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |