Data dictionary
Last updated May 27, 2026
Key conventions:
- Columns prefixed with _ (underscore) are numeric measure columns. The underscore is part of the actual column name in the database.
- DatabaseName and ownerInfo appear in nearly all views (multi-tenant infrastructure). They are omitted from individual tables below for brevity but are always present unless noted.
- A parallel Reporting_Private schema exists with camelCase column names for API/internal use. It is not documented here.
View inventory (47 views)
| # | View | Domain | Columns | Doc Status |
|---|---|---|---|---|
| 1 | Account_Custom_Fields | Custom Fields | 5 | Documented |
| 2 | Accounts | Core | 33 | Documented (with discrepancies) |
| 3 | Bill_Custom_Fields | Custom Fields | 5 | Documented |
| 4 | Bill_Line_Items | Billing | 18 | Documented (with discrepancies) |
| 5 | Bill_Properties | Billing | 49 | Documented (with discrepancies) |
| 6 | Billing_Period_Month | Calendar | 23 | Undocumented |
| 7 | Bills_By_Meter | Billing | 54 | Documented (with discrepancies) |
| 8 | Building_Groups | Hierarchy | 4 | Documented |
| 9 | Calendar_Month | Calendar | 32 | Documented |
| 10 | Collections | Hierarchy | 7 | Documented |
| 11 | Commodities | Core | 5 | Documented |
| 12 | Cost_Avoidance | Cost | 25 | Documented (with discrepancies) |
| 13 | Cost_Category_Names | Cost | 4 | Documented |
| 14 | Cost_Centers | Hierarchy | 5 | Documented |
| 15 | Emission_Record_Calendarized | Emissions | 9 | Documented |
| 16 | Emission_Record_Properties | Emissions | 31 | Documented |
| 17 | Emissions_Sources | Emissions | 26 | Documented (with discrepancies) |
| 18 | EnergyProject_Custom_Fields | Custom Fields | 5 | Documented |
| 19 | EnergyProjects | Projects | 24 | Documented |
| 20 | ENERGYSTAR_Submissions | Projects | 8 | Undocumented |
| 21 | Flag_Assignee | Flags | 5 | Documented |
| 22 | Flag_Event | Flags | 9 | Documented |
| 23 | Flag_Issue | Flags | 6 | Documented |
| 24 | Flag_Properties | Flags | 12 | Documented |
| 25 | GHG_By_Meter | Emissions | 8 | Undocumented |
| 26 | GL_Records | GL | 23 | Documented |
| 27 | GL_Subcode_Names | GL | 4 | Documented |
| 28 | Interval_Data | Interval | 9 | Documented |
| 29 | Line_Item_Types | Billing | 6 | Documented |
| 30 | Meter_Channels | Interval | 7 | Documented |
| 31 | Meter_Custom_Fields | Custom Fields | 5 | Documented |
| 32 | Meter_Groups | Hierarchy | 4 | Documented |
| 33 | Meters | Core | 35 | Documented (with discrepancies) |
| 34 | Model_Metadata | System | 2 | Undocumented |
| 35 | Model_Updated_Date | System | 1 | Undocumented |
| 36 | Place_Custom_Fields | Custom Fields | 5 | Documented |
| 37 | Places | Core | 33 | Documented |
| 38 | Scope_Category | Emissions | 2 | Undocumented |
| 39 | Time_Zones | Reference | 4 | Documented |
| 40 | Topmost_Collections | Hierarchy | 7 | Documented |
| 41 | Topmost_Cost_Centers | Hierarchy | 8 | Documented |
| 42 | Topmost_Places | Hierarchy | 12 | Documented |
| 43 | Units | Reference | 6 | Documented |
| 44 | Vendor_Custom_Fields | Custom Fields | 5 | Documented |
| 45 | Vendors | Core | 4 | Documented |
| 46 | Weather_Daily_Temperature | Weather | 6 | Documented |
| 47 | Weather_Stations | Weather | 4 | Undocumented |
Core entity views
Accounts
| Column | Type | Description |
|---|---|---|
| Account - Number | varchar(50) | Unique account number per vendor |
| Account - Name | varchar(50) | Descriptive name for account |
| Vendor Code and Account Code | varchar(67) | Composite key (undocumented) |
| Cost Center - Code | varchar(32) | Cost center assignment (undocumented) |
| Active | bit | Is account currently active? |
| Chargeback - Bill Calculation | bit | Bills calculated for this account as part of a bill calculation? |
| Chargeback - Bill Split Master | bit | Bills from this account split to others? (Docs call this "Bill Split Source") |
| Chargeback - Bill Split Recipient | bit | Account receives bills from a split? (Docs call this "Bill Split Destination") |
| Accruals Enabled | bit | Can accrual bills be created? |
| Customer - Code | varchar(16) | Unique customer identifier (user-defined) |
| Customer | varchar(32) | Customer name |
| Created Date | date | Date account was created |
| Created by User | varchar(65) | Username of creator |
| Created by Name | varchar(32) | Full name of creator |
| Last Updated Date | date | Last date account was updated |
| Last Updated by User | varchar(65) | Username of last updater |
| Last Updated by Name | varchar(32) | Full name of last updater |
| _Deposit Amount | money | Deposit amount (note underscore prefix) |
| Deposit Note | varchar(255) | Note regarding account deposit |
| Deposit Paid - Date | date | Date of account deposit |
| Deposit Returned - Date | date | Date deposit was returned |
| Memo | nvarchar(max) | Account memo (docs say text) |
| Service Begin - Date | date | First date of service |
| Service End - Date | date | Last date of service |
| Service Address - Line 1 | nvarchar(100) | First address line |
| Service Address - Line 2 | nvarchar(100) | Second address line |
| Service Address - City | nvarchar(100) | City |
| Service Address - State | nvarchar(100) | State |
| Service Address - Postal Code | nvarchar(32) | Postal code |
| Service Address - Country | nvarchar(64) | Country |
| Vendor Code | varchar(16) | Vendor identifier (undocumented) |
Vendors
| Column | Type | Description |
|---|---|---|
| Vendor - Code | varchar(16) | Unique vendor identifier (user-defined) |
| Vendor | varchar(50) | Vendor name |
Places
| Column | Type | Description |
|---|---|---|
| Place - Code | varchar(32) | Unique place identifier |
| Place | varchar(50) | Place name/description |
| Place Type - Code | varchar(16) | Unique place type identifier |
| Place Type | varchar(32) | Place type name/description |
| Building or Organization | varchar(12) | Is this place treated as a building or organization? |
| Weather Station | nvarchar(10) | Weather station unique identifier |
| Weather Station - City | nvarchar(100) | Weather station city |
| Weather Station - State | nvarchar(100) | Weather station state |
| Weather Station - Country | nvarchar(64) | Weather station country |
| Build Date | date | Date building was built |
| Parent Place - Code | varchar(32) | Unique identifier for parent place |
| Primary Use - Code | varchar(64) | Primary use code |
| Primary Use | varchar(64) | Primary use name |
| Include in ENERGY STAR | int | Is building submitted to ENERGY STAR? |
| _Floor Area - Current | int | Floor area effective now (note underscore prefix) |
| Floor Area - Current - Unit | nvarchar(32) | Unit of current floor area |
| Created Date | date | Date created |
| Created by User | varchar(65) | Creator username |
| Created by Name | varchar(32) | Creator full name |
| Last Updated Date | date | Last update date |
| Last Updated by User | varchar(65) | Last updater username |
| Last Updated by Name | varchar(32) | Last updater full name |
| Address - Line 1 | nvarchar(100) | Address line 1 |
| Address - Line 2 | nvarchar(100) | Address line 2 |
| Address - City | nvarchar(100) | City |
| Address - State | nvarchar(100) | State |
| Address - Postal Code | nvarchar(32) | Postal code |
| Address - Country | nvarchar(64) | Country |
| Latitude | decimal | Latitude |
| Longitude | decimal | Longitude |
| placeID | int | Numeric place ID (undocumented) |
Meters
| Column | Type | Description |
|---|---|---|
| Meter - Code | varchar(32) | Unique meter identifier (user-defined) |
| Meter | varchar(50) | Meter name/description |
| Commodity - Code | varchar(16) | Commodity code |
| Logical Device ID | int | Internal device ID (undocumented) |
| Place - Code | varchar(32) | Place assignment |
| Place - ID | int | Numeric place ID (undocumented) |
| Primary Use - Code | varchar(64) | Primary use code |
| Primary Use | varchar(64) | Primary use name |
| Bill Entry Note | varchar(64) | Bill entry note |
| Included in Cost Avoidance | int | Is meter included in cost avoidance calculations? |
| Included in ENERGY STAR | int | Is meter included in ENERGY STAR submissions? |
| Active | bit | Is meter currently active? |
| Serial Number | varchar(255) | Serial number |
| Chargeback - Bill Calculation | bit | Bills calculated for this meter? |
| Chargeback - Bill Split Master | bit | Bills from this meter split to others? (Docs: "Bill Split Source") |
| Chargeback - Bill Split Recipient | bit | Meter receives bills from a split? (Docs: "Bill Split Destination") |
| Created Date | date | Date created |
| Created by User | varchar(65) | Creator username |
| Created by Name | varchar(32) | Creator full name |
| Last Updated Date | date | Last update date |
| Last Updated by User | varchar(65) | Last updater username |
| Last Updated by Name | varchar(32) | Last updater full name |
| Address - Line 1 | nvarchar(100) | Address line 1 |
| Address - Line 2 | nvarchar(100) | Address line 2 |
| Address - City | nvarchar(100) | City |
| Address - State | nvarchar(100) | State |
| Address - Postal Code | nvarchar(32) | Postal code |
| Address - Country | nvarchar(64) | Country |
| Latitude | decimal | Latitude |
| Longitude | decimal | Longitude |
| Data Access Release Status | varchar(64) | Data access release status (undocumented) |
| Aggregate Count | int | Aggregate count (undocumented) |
| timeZoneCode | varchar(255) | Time zone code (undocumented) |
Commodities
| Column | Type | Description |
|---|---|---|
| Commodity - Code | varchar(16) | Unique code (unique within an owner) |
| Commodity | varchar(32) | Friendly name |
| Commodity Category | nvarchar(32) | Category the commodity belongs to |
Units
| Column | Type | Description |
|---|---|---|
| Unit - Code | varchar(16) | Unique code |
| Unit | nvarchar(32) | Friendly name |
| Unit Type - Code | varchar(16) | Unit type identifier |
| Unit Type | varchar(32) | Unit type name |
Billing views
Bill_Properties
| Column | Type | Description |
|---|---|---|
| Bill - ID | int | Unique bill identifier |
| Billing Period | numeric | Billing period in YYYYMM (undocumented) |
| Accounting Period | numeric | Accounting period (YYYYMM format) |
| Accounting Year | int | Accounting period year |
| Accounting Month | int | Accounting month |
| First Day | date | First day of bill |
| Last Day - Inclusive | date | End of bill (inclusive) |
| Last Day - Exclusive | date | End of bill (exclusive - day after last day) |
| Created Date | date | Date bill was recorded |
| Created Datetime | datetime | Date/time bill was recorded |
| Created by User | varchar(65) | Username of who entered the bill |
| Created by Name | varchar(32) | Full name of who entered the bill |
| Last Updated Date | date | Last time bill was updated |
| Last Updated by User | varchar(65) | Last updater username |
| Last Updated by Name | varchar(32) | Last updater full name |
| Due Date | date | Due date from vendor |
| Statement Date | date | Statement date |
| Invoice Number | varchar(32) | Invoice number from vendor |
| Estimated Bill | bit | Is an estimated bill |
| Batch | varchar(255) | Unique batch identifier |
| Control Code | varchar(255) | Control code (docs call this "Management") |
| Accrual Bill | bit | Is an accrual bill |
| Accrual Bill - Reversed | bit | Is reversed accrual |
| Accrual Bill - Reversed Date | date | Date reversed |
| Approved | bit | Bill has been approved |
| Approved Date | date | Date approved |
| Approved by User | varchar(65) | Approver username |
| Approved by Name | varchar(32) | Approver full name |
| Bill Source | varchar(20) | System-created or entered |
| Bill Split | bit | Has been split by chargeback engine |
| Bill Split Date | date | Date split |
| Check Number | varchar(32) | Check number |
| Check Date | date | Check date |
| Check Cleared Date | date | Date check cleared |
| Transaction Reference | varchar(32) | Accounting system reference |
| Creation Method - Code | varchar(16) | Creation method code |
| Creation Method | varchar(32) | Creation method name |
| Held from Accounting Export | bit | Not available for export |
| Exported to AP | bit | Has been exported to AP |
| Exported to AP - Date | date | Date exported to AP |
| Exported to AP by User | varchar(65) | AP exporter username |
| Exported to AP by Name | varchar(32) | AP exporter full name |
| Exported to GL | bit | Has been exported to GL |
| Exported to GL - Date | date | Date exported to GL |
| Exported to GL by User | varchar(65) | GL exporter username |
| Exported to GL by Name | varchar(32) | GL exporter full name |
| Voided | bit | Bill has been voided |
Bill_Line_Items
| Column | Type | Description |
|---|---|---|
| Bill - ID | int | Bill identifier (undocumented) |
| Billing Period | numeric | Billing period YYYYMM (undocumented) |
| Meter - Code | varchar(32) | Meter code (undocumented) |
| General Ledger ID | varchar(255) | GL identifier (undocumented) |
| Display Order | int | Order line item appeared on bill |
| Line Item Type - Code | varchar(16) | Line item type code (undocumented) |
| Caption | varchar(100) | Caption from line item |
| _Informational Value | numeric | Informational value on line item |
| Informational Value - Unit Code | varchar(16) | Unit code for informational value |
| _Bill_Line_Items_Value | numeric | Countable value on line item |
| Value - Unit Code | varchar(16) | Unit code for value |
| _Informational Cost | money | Informational cost on line item |
| Informational Cost - Unit Code | varchar(16) | Unit code for informational cost |
| _Bill_Line_Items_Cost | money | Countable cost on line item |
| Cost - Unit Code | varchar(16) | Unit code for cost |
| Vendor Code and Account Code | varchar(67) | Composite key (undocumented) |
Bills_By_Meter
| Column | Type | Description |
|---|---|---|
| Bill - ID | int | Bill identifier (undocumented) |
| First Day | date | First day of bill |
| Last Day - Inclusive | date | End of bill (inclusive) |
| Last Day - Exclusive | date | End of bill (exclusive) |
| _Length | int | Total days of use recorded on bill |
| YYYYMM | numeric | Calendar month YYYYMM (undocumented) |
| Vendor Code and Account Code | varchar(67) | Composite key (undocumented) |
| logicalDeviceCode | varchar(32) | Meter device code (undocumented) |
| General Ledger ID | varchar(255) | GL identifier (undocumented) |
| _Bills_By_Meter_Cost | money | Cost from bill directly assigned to meter |
| _Bills_By_Meter_Cost - Includes Account Share | money | Proportional share of account costs |
| Cost - Currency Code | varchar(16) | Currency code |
| Cost - Currency | nvarchar(32) | Currency name/symbol |
| _Bills_By_Meter_Use | numeric | Use value (common units) |
| Use - Unit Code | varchar(16) | Common use unit code |
| Use - Unit | nvarchar(32) | Common use unit name |
| _Bills_By_Meter_Energy Use | numeric | Use value (global energy units) |
| Energy Use - Unit Code | varchar(16) | Global use unit code |
| Energy Use - Unit | nvarchar(32) | Global use unit name |
| _Bills_By_Meter_Use in Meter Units | numeric | Use value in meter's native units |
| Use in Meter Units - Unit Code | varchar(16) | Meter unit code |
| Use in Meter Units - Unit | nvarchar(32) | Meter unit name |
| _Bills_By_Meter_Demand - Actual Reading | numeric | Actual demand recorded during period |
| Demand - Actual Reading - Unit Code | varchar(16) | Actual demand unit code |
| Demand - Actual Reading - Unit | nvarchar(32) | Actual demand unit name |
| _Bills_By_Meter_Demand - Billed Value | numeric | Billed demand value |
| Demand - Billed Value - Unit Code | varchar(16) | Billed demand unit code |
| Demand - Billed Value - Unit | nvarchar(32) | Billed demand unit name |
| _Bills_By_Meter_Demand | numeric | Calculated demand (greater of actual/billed) |
| Demand - Unit Code | varchar(16) | Demand unit code |
| Demand - Unit | nvarchar(32) | Demand unit name |
| _Bills_By_Meter_Weather Normalized Use in Meter Units | numeric | Weather normalized use (meter units) |
| _Bills_By_Meter_Weather Normalized Use | numeric | Weather normalized use (common units) |
| _Bills_By_Meter_Weather Normalized Energy Use | numeric | Weather normalized use (global energy units) |
| _Cost Standard Deviation | numeric | Standard deviation of cost |
| _Cost R Squared | numeric | R squared value for cost |
| _Use Standard Deviation | numeric | Standard deviation of use |
| _Use R Squared | numeric | R squared value for use |
| _Demand Standard Deviation | numeric | Standard deviation of demand |
| _Demand R Squared | numeric | R squared value for demand |
| Vendor Role | varchar(23) | Vendor role |
| Rate Schedule | varchar(255) | Rate schedule |
| _Bills_By_Meter_Cost_category1 | money | Cost Category 01 |
| _Bills_By_Meter_Cost_category2 | money | Cost Category 02 |
| _Bills_By_Meter_Cost_category3 | money | Cost Category 03 |
| _Bills_By_Meter_Cost_category4 | money | Cost Category 04 |
| _Bills_By_Meter_Cost_category5 | money | Cost Category 05 |
| _Bills_By_Meter_Cost_category6 | money | Cost Category 06 |
| _Bills_By_Meter_Cost_category7 | money | Cost Category 07 |
| _Bills_By_Meter_Cost_category8 | money | Cost Category 08 |
| _Bills_By_Meter_Cost_category9 | money | Cost Category 09 |
| _Bills_By_Meter_Cost_category10 | money | Cost Category 10 |
Line_Item_Types
| Column | Type | Description |
|---|---|---|
| Line Item Type - Code | varchar(16) | Unique identifier for line item type |
| Line Item Type | varchar(32) | Name of line item type |
| Charge Type | varchar(6) | Charge, refund, or ignore |
| Line Item Category | varchar(16) | Category (Usage, Demand, Charge, etc.) |
Calendar views
Calendar_Month
| Column | Type | Description |
|---|---|---|
| YYYYMM | int | Month/year integer key (undocumented) |
| First Day of Month | date | First day of month |
| First Day of Following Month | date | First day of next month |
| First Day of Prior Month | date | First day of prior month |
| Last Day of Month | date | Last day of month |
| Days in Month | tinyint | Number of days |
| Calendar Month - Number | tinyint | Month integer (1-12) |
| Calendar Month - Name | nvarchar(9) | Full month name (e.g., January) |
| Calendar Month - Short Name | nvarchar(3) | Three-letter month (e.g., Jan) |
| Calendar Year | smallint | Year integer |
| Calendar Quarter - Number | tinyint | Quarter integer (1-4) |
| Calendar Quarter - Q# YYYY | nvarchar(7) | Quarter as Q# YYYY |
| Calendar Quarter - YYYY-Q# | varchar(7) | Quarter as YYYY-Q# |
| Calendar Month - MMYYYY | nvarchar(6) | MMYYYY format |
| Calendar Month - YYYY-MM | nvarchar(7) | YYYY-MM format |
| Calendar Month - MM-YYYY | nvarchar(7) | MM-YYYY format |
| Calendar Month - YYYYMM with Slash | nvarchar(7) | YYYY/MM format |
| Calendar Month - MMYYYY with Slash | nvarchar(7) | MM/YYYY format |
| Calendar Month - YYYYMM with Dot | nvarchar(7) | YYYY.MM format |
| Calendar Month - MMYYYY with Dot | nvarchar(7) | MM.YYYY format |
| Billing Period | int | Billing period YYYYMM |
| Billing Period MMM YYYY | nvarchar(8) | Billing period as MMM YYYY |
| Fiscal Method | varchar(17) | Fiscal year determination method |
| Fiscal Year | int | Fiscal year |
| Fiscal Month | int | Month within fiscal year |
| Fiscal Period | int | Fiscal period YYYYMM |
| Fiscal Year - First Calendar Month | int | First calendar month of fiscal year |
| Fiscal Year - Last Calendar Month | int | Last calendar month of fiscal year |
| Fiscal Quater - Number | int | Fiscal quarter integer |
| Fiscal Quater - Q# YYYY | nvarchar(7) | Fiscal quarter as Q# YYYY |
Billing_Period_Month (Undocumented)
| Column | Type | Description |
|---|---|---|
| YYYYMM | int | Month/year integer key |
| First Day of Month | date | First day of month |
| First Day of Following Month | date | First day of next month |
| First Day of Prior Month | date | First day of prior month |
| Last Day of Month | date | Last day of month |
| Days in Month | tinyint | Number of days |
| Billing Month - Number | tinyint | Billing month integer |
| Billing Month - Name | nvarchar(9) | Full billing month name |
| Billing Month - Short Name | nvarchar(3) | Three-letter billing month |
| Billing Year | smallint | Billing year integer |
| Billing Quarter - Number | tinyint | Billing quarter integer |
| Billing Quarter - Q# YYYY | nvarchar(7) | Billing quarter as Q# YYYY |
| Billing Quarter - YYYY-Q# | varchar(7) | Billing quarter as YYYY-Q# |
| Billing Month - MMYYYY | nvarchar(6) | MMYYYY format |
| Billing Month - YYYY-MM | nvarchar(7) | YYYY-MM format |
| Billing Month - MM-YYYY | nvarchar(7) | MM-YYYY format |
| Billing Month - YYYYMM with Slash | nvarchar(7) | YYYY/MM format |
| Billing Month - MMYYYY with Slash | nvarchar(7) | MM/YYYY format |
| Billing Month - YYYYMM with Dot | nvarchar(7) | YYYY.MM format |
| Billing Month - MMYYYY with Dot | nvarchar(7) | MM.YYYY format |
| Billing Period | int | Billing period YYYYMM |
| Billing Period MMM YYYY | nvarchar(8) | Billing period as MMM YYYY |
Cost views
Cost_Avoidance
| Column | Type | Description |
|---|---|---|
| Bill - ID | int | Bill identifier (undocumented) |
| YYYYMM | numeric | Calendar month (undocumented) |
| First Day | datetime | First day of bill |
| Last Day - Exclusive | datetime | End of bill (exclusive) |
| _Length | int | Total days of use |
| Vendor Code and Account Code | varchar(67) | Composite key (undocumented) |
| Meter - Code | varchar(32) | Meter code (undocumented) |
| Commodity - Code | varchar(16) | Commodity code (undocumented) |
| _Cost | money | Cost from bill assigned to meter |
| _BATCC Cost | money | Baseline adjusted to current conditions cost |
| _Use | numeric | Use value (common units) |
| _BATCC Use | numeric | BATCC use (common units) |
| _Energy Use | numeric | Use value (global energy units) |
| _BATCC Energy Use | numeric | BATCC use (global energy units) |
| Use - Unit Code | varchar(16) | Common use unit code |
| Use - Unit | nvarchar(32) | Common use unit name |
| Energy Use - Unit Code | varchar(16) | Global use unit code |
| Energy Use - Unit | nvarchar(32) | Global use unit name |
| _Cost Avoided | money | Cost avoided (difference of Cost and BATCC Cost) |
| _Use Avoided | numeric | Use avoided (common units) |
| _Energy Use Avoided | numeric | Energy use avoided (global energy units) |
| Cost - Currency | varchar(16) | Currency name/symbol |
| Cost - Currency Code | nvarchar(32) | Currency code |
Cost_Category_Names
| Column | Type | Description |
|---|---|---|
| Cost Category Reference | varchar(8000) | Reference to cost category field |
| Cost Category Name | varchar(255) | Cost category name |
Cost_Centers
| Column | Type | Description |
|---|---|---|
| Cost Center - Code | varchar(32) | Unique cost center identifier |
| Cost Center | varchar(32) | Cost center name |
| Parent Cost Center - Code | varchar(32) | Parent cost center identifier |
Hierarchy views
Collections
| Column | Type | Description |
|---|---|---|
| ownerID | int | Tenant ID |
| Collection | nvarchar(50) | Collection name |
| Collection (Code) | nvarchar(32) | Collection identifier (docs use dash: "Collection - Code") |
| Parent Collection (Code) | nvarchar(32) | Parent collection identifier |
| Parent Collection | nvarchar(50) | Parent collection name |
Building_Groups
| Column | Type | Description |
|---|---|---|
| Building Group | varchar(255) | Building group name |
| Place - Code | varchar(32) | Place code (undocumented) |
Meter_Groups
| Column | Type | Description |
|---|---|---|
| Meter Group | varchar(255) | Meter group name |
| Meter - Code | varchar(32) | Meter code |
Topmost_Collections
| Column | Type | Description |
|---|---|---|
| ownerID | int | Tenant ID |
| Topmost Collection - Code | nvarchar(32) | Top-level collection code |
| Topmost Collection | nvarchar(50) | Top-level collection name |
| Child Collection - Code | nvarchar(32) | Child collection code |
| Child Collection | nvarchar(50) | Child collection name |
Topmost_Cost_Centers
| Column | Type | Description |
|---|---|---|
| Topmost Cost Center - Code | varchar(32) | Top-level cost center code |
| Topmost Cost Center | varchar(32) | Top-level cost center name |
| Child Cost Center - Code | varchar(32) | Child cost center code (undocumented) |
| Child Cost Center | varchar(32) | Child cost center name (undocumented) |
The help center only documents Topmost columns, not the Child columns.
Topmost_Places
| Column | Type | Description |
|---|---|---|
| Topmost Place - Code | varchar(32) | Top-level place code |
| Topmost Place | varchar(50) | Top-level place name |
| Topmost Place Type - Code | varchar(16) | Top-level place type code |
| Topmost Place Type | varchar(32) | Top-level place type name |
| Child Place - Code | varchar(32) | Child place code |
| Child Place | varchar(50) | Child place name |
| Child Place Type - Code | varchar(16) | Child place type code |
| Child Place Type | varchar(50) | Child place type name |
This view has two additional columns (Child Place Type - Code, Child Place Type) not documented in the help center.
Custom field views
All custom field views follow a consistent pattern: infrastructure columns + entity key + field name/value pair.
Account_Custom_Fields
| Column | Type | Description |
|---|---|---|
| Vendor Code and Account Code | varchar(67) | Account composite key (undocumented) |
| Custom Field Name | varchar(32) | Name of custom field |
| Custom Field Value | nvarchar(max) | Value (docs say varchar(255)) |
Bill_Custom_Fields
| Column | Type | Description |
|---|---|---|
| Bill - ID | int | Bill identifier |
| Custom Field Name | varchar(32) | Name of custom field |
| Custom Field Value | nvarchar(max) | Value of custom field |
Meter_Custom_Fields
| Column | Type | Description |
|---|---|---|
| Meter - Code | varchar(32) | Meter identifier |
| Custom Field Name | varchar(32) | Name of custom field |
| Custom Field Value | nvarchar(max) | Value of custom field |
Place_Custom_Fields
| Column | Type | Description |
|---|---|---|
| Place - Code | varchar(32) | Place identifier |
| Custom Field Name | varchar(32) | Name of custom field |
| Custom Field Value | nvarchar(max) | Value of custom field |
Vendor_Custom_Fields
| Column | Type | Description |
|---|---|---|
| Vendor - Code | varchar(16) | Vendor identifier |
| Custom Field Name | varchar(32) | Name of custom field |
| Custom Field Value | nvarchar(max) | Value of custom field |
EnergyProject_Custom_Fields
| Column | Type | Description |
|---|---|---|
| Energy Project - Code | varchar(128) | Energy project identifier |
| Custom Field Name | varchar(32) | Name of custom field |
| Custom Field Value | nvarchar(max) | Value of custom field |
Emissions views
Emission_Record_Calendarized
| Column | Type | Description |
|---|---|---|
| OwnerID | int | Tenant ID |
| YearMonth | numeric | Calendar month of tracked emissions |
| Emissions | decimal | Quantity of source GHG gas emitted |
| Emissions Type | nvarchar(64) | Source GHG gas emitted |
| Emissions Unit | varchar(16) | Measurement unit |
| CO2e Metric Ton | numeric | Equivalent CO2 in metric tons |
| Emissions Record - ID | int | Emissions record identifier |
Emission_Record_Properties
| Column | Type | Description |
|---|---|---|
| OwnerID | int | Tenant ID |
| Emissions Record - ID | int | Unique record identifier |
| Emissions Source - Code | nvarchar(32) | Emissions source code |
| First Day | date | Begin date |
| Last Day - Exclusive | date | End date (exclusive) |
| Last Day - Inclusive | date | End date (inclusive) |
| Created Date | date | Date record entered |
| Created Datetime | datetimeoffset | Date/time record entered |
| Created by User | varchar(65) | Creator username |
| Created by Name | varchar(32) | Creator full name |
| Last Updated Date | date | Last update date |
| Last Updated Datetime | datetimeoffset | Last update date/time |
| Last Updated by User | varchar(65) | Last updater username |
| Last Updated by Name | varchar(32) | Last updater full name |
| Vendor - Code | varchar(16) | Vendor code |
| Emission Record Type | nvarchar(32) | Record type |
| GHG Scope | nvarchar(64) | GHG scope |
| Scope Category | nvarchar(64) | Scope category |
| GHG Factor Name | nvarchar(128) | GHG factor name |
| Quantity | numeric | Quantity of material/activity |
| Quantity - Unit Code | varchar(16) | Unit of measure |
| Cost | money | Associated cost |
| Cost - Currency Code | varchar(16) | Currency code |
| Cost - Currency | nvarchar(32) | Currency name |
| CO2e Metric Ton | numeric | Equivalent CO2 in metric tons |
| Note | nvarchar(255) | Note |
| Bill - ID | int | Bill identifier (if applicable) |
| Creation Method | nvarchar(32) | Creation method (Manual, Imported, From EUM Bill, etc.) |
| YearMonth | int | Calendar month (undocumented) |
Emissions_Sources
Updated May 2026 per ECAP-32565 — corrected GHG factor join logic, added Default GHG Factor Name.
| Column | Type | Description |
|---|---|---|
| ownerID | int | Tenant ID |
| Active | bit | Is source currently active? |
| Emissions Source | nvarchar(64) | Source name |
| Emissions Source (Code) | nvarchar(32) | Source code (docs use dash notation) |
| Location - City | nvarchar(100) | City |
| Location - Country | nvarchar(64) | Country |
| Location - Line 1 | nvarchar(100) | Address line 1 |
| Location - Line 2 | nvarchar(100) | Address line 2 |
| Location - Line 3 | nvarchar(100) | Address line 3 |
| Created By | int | Creator ID (docs say varchar — actually int) |
| Created By (Username) | varchar(32) | Creator username |
| Created Date | datetimeoffset | Date created |
| Modified By | int | Last modifier ID (docs say varchar — actually int) |
| Modified By (Username) | varchar(32) | Last modifier username |
| Modified Date | datetimeoffset | Last modified date |
| Location - Latitude | decimal | Latitude |
| Location - Longitude | decimal | Longitude |
| Parent Collection | int | Parent collection ID (docs say varchar — actually int) |
| Parent Collection (Code) | nvarchar(32) | Parent collection code |
| Type (Commodity) | varchar(32) | Commodity type |
| Default Scope Category | nvarchar(64) | Default GHG scope category. Resolved via CROSS APPLY against EmissionSourceScopeCategoryFactor — picks the default row if one exists, otherwise falls back to the first available row by ID |
| Default GHG Factor | decimal | Hardcoded to 0.0 as of ECAP-32565. Previously pulled the numeric factor value from the legacy ghgFactor table, but that join was incorrect. Retained for backward compatibility in existing reports |
| Default GHG Factor Name | string | Name/description of the GHG factor assigned to this emission source. Sourced from GHGasFactor.ghGasFactorInfo. Added in ECAP-32565 |
| Linked Meter (Code) | varchar(32) | Linked meter code (if applicable) |
Scope_Category (Undocumented)
No infrastructure columns (DatabaseName/ownerInfo) in this view.
| Column | Type | Description |
|---|---|---|
| GHG Scope | nvarchar(64) | GHG scope name |
| Scope Category | nvarchar(64) | Scope category name |
GHG_By_Meter (Undocumented)
No infrastructure columns (DatabaseName/ownerInfo) in this view.
| Column | Type | Description |
|---|---|---|
| Meter - Code | varchar(32) | Meter identifier |
| Month | numeric | Billing period |
| _Emission | decimal | Emission quantity |
| Emission Type | varchar(64) | GHG gas type |
| Emission Unit | varchar(16) | Measurement unit |
| _CO2 Metric Ton Equivalent | decimal | CO2 equivalent in metric tons |
| GHG Scope | varchar(7) | GHG scope |
| Scope Description | varchar(32) | Scope description |
Flag views
Flag_Properties
| Column | Type | Description |
|---|---|---|
| Flag - ID | int | Unique flag identifier (docs call this "FlagId") |
| Bill - ID | int | Bill identifier |
| Status | varchar(32) | Flag status (e.g., resolved, unresolved) |
| Created Date | datetime | Flag creation date |
| Created by User | varchar(65) | Creator username |
| Created by Name | varchar(32) | Creator full name |
| Last Updated Date | datetime | Last update date (docs call this "Last Update Date") |
| Last Updated by User | varchar(65) | Last updater username |
| Last Updated by Name | varchar(32) | Last updater full name |
| Cost Recovery | money | Cost recovery amount (undocumented) |
Flag_Issue
| Column | Type | Description |
|---|---|---|
| Flag - ID | int | Flag identifier |
| Flag Type | varchar(32) | Flag type (e.g., Audit Exception, Late Fee) — docs call this "Flag Type Info" |
| Flag Issue Type | varchar(64) | Issue type (e.g., Total Cost Mismatch) — docs call this "Flag Issue Type Info" |
| Flag Issue Category | varchar(32) | Issue category (e.g., Bill Entry, Outlier) |
Flag_Assignee
| Column | Type | Description |
|---|---|---|
| Flag - ID | int | Flag identifier |
| Assigned to User | varchar(65) | Assignee username |
| Assigned to Name | varchar(32) | Assignee full name |
Flag_Event
| Column | Type | Description |
|---|---|---|
| Flag - ID | int | Flag identifier |
| Created Date | datetime | Event creation date |
| Created By User | varchar(65) | Creator username |
| Created By Name | varchar(32) | Creator full name |
| Description | varchar(max) | Event description |
| Comment | varchar(max) | Comments entered |
| Event Action | varchar(32) | Action taken on the flag |
GL views
GL_Records
| Column | Type | Description |
|---|---|---|
| General Ledger ID | varchar(255) | Unique GL record identifier |
| General Ledger - Sub Code 01 through 20 | varchar(25) | Values for subcode fields 01–20 |
GL_Subcode_Names
| Column | Type | Description |
|---|---|---|
| General Ledger Sub Code Reference | varchar(17) | Reference to subcode field name |
| General Ledger Sub Code Name | varchar(32) | Friendly name for subcode |
Interval data views
Interval_Data
| Column | Type | Description |
|---|---|---|
| Meter Code - Data Type - Interval | varchar(59) | Combined meter/data type/interval key |
| Reading Timestamp | datetimeoffset | Time of reading in meter's time zone |
| Previous Reading Timestamp | datetimeoffset | Time of preceding reading |
| _Value | decimal | Calculated value of the reading |
| Value - Unit | varchar(16) | Unit code for reading's value |
| Estimated Reading | bit | Is an estimated reading |
| YYYYMM | nvarchar(6) | Calendar month (undocumented) |
Meter_Channels
| Column | Type | Description |
|---|---|---|
| Meter Code - Data Type - Interval | varchar(59) | Combined identifier (unique per owner) |
| Meter - Code | varchar(32) | Meter code |
| Data Type - Code | varchar(16) | Data type code |
| Data Type | varchar(32) | Data type name |
| Interval | varchar(9) | Interval between readings |
Project views
EnergyProjects
| Column | Type | Description |
|---|---|---|
| Energy Project ID | int | Unique project identifier (docs say int64) |
| Energy Project Type ID | int | Project type identifier |
| Energy Project - Code | varchar(128) | Project code by place (docs say string) |
| Installation Begin Date | datetime | Installation begin date |
| Installation Begin Period | varchar(6) | Begin period YYYYMM |
| Installation End Date | datetime | Installation end date |
| Installation Cost | money | Installation cost (docs say double) |
| Energy Savings | numeric | Energy savings amount (undocumented) |
| Cost Savings | money | Cost savings amount |
| Utility Rebate | money | Utility rebate amount |
| Funding Source | varchar(32) | Funding source |
| Project Manager | varchar(32) | Project manager |
| Note | varchar(255) | Project note |
| Cost Saving Unit Code | varchar(16) | Cost savings unit code |
| Cost Saving Unit Info | nvarchar(32) | Cost savings unit info |
| Cost Unit Display Name | nvarchar(64) | Cost unit display name |
| Energy Saving Unit Code | varchar(16) | Energy saving unit code |
| Energy Saving Unit Name | nvarchar(64) | Energy saving unit name |
| Energy Saving Unit Info | nvarchar(32) | Energy saving unit info |
| Project Type Code | varchar(16) | Project type code |
| Project Type Info | varchar(32) | Project type info |
| Place - Code | varchar(32) | Place code |
ENERGYSTAR_Submissions (Undocumented)
| Column | Type | Description |
|---|---|---|
| OwnerID | int | Tenant ID |
| Owner | varchar(50) | Customer/tenant name |
| Place - Code | varchar(32) | Place identifier |
| Meter - Code | varchar(32) | Meter identifier |
| Submission Date | datetimeoffset | Submission timestamp |
| Calendar Period | int | Calendar period YYYYMM |
| energyStarTaskID | int | ENERGY STAR task ID |
Weather views
Weather_Daily_Temperature
| Column | Type | Description |
|---|---|---|
| Weather Station | varchar(32) | Weather station name |
| Temperature Date | date | Date of temperature reading |
| _Mean Daily Temperature | decimal | Mean daily temperature (note underscore prefix) |
| YYYYMM | nvarchar(6) | Calendar month (undocumented; replaces documented "Temperature Month Year") |
Weather_Stations (Undocumented)
| Column | Type | Description |
|---|---|---|
| Weather Station | varchar(32) | Weather station name |
| Weather Data Depot Link | nvarchar(max) | Link to Weather Data Depot |
Reference and system views
Time_Zones
No infrastructure columns (DatabaseName/ownerInfo) in this view.
| Column | Type | Description |
|---|---|---|
| Time Zone - Code | varchar(255) | Unique time zone identifier |
| Time Zone | varchar(255) | Descriptive time zone identifier |
| _UTC Hour Offset | numeric | Hours ahead/behind UTC (note underscore prefix) |
| Daylight Saving Time Observed | bit | Is DST observed? |
Model_Metadata (Undocumented)
No infrastructure columns. This is the only base table (not a view) in either schema.
| Column | Type | Description |
|---|---|---|
| variableName | nvarchar(50) | Configuration variable name |
| variableValue | nvarchar(100) | Configuration variable value |
Model_Updated_Date (Undocumented)
Replaces the documented (but nonexistent) Last_Refresh_Timestamp view.
| Column | Type | Description |
|---|---|---|
| Model Updated Date | nvarchar(100) | Date when model was last updated |