Monthly Fact Table - T_TRIASSETENERGYUSEMFACT
You must have data loaded into the monthly fact table T_TRIASSETENERGYUSEMFACT in order to use the monthly energy use reports.
- Module
- triMetricFact
- Business object
- triAssetEnergyUseMFact
- Display name
- Asset Energy Use Monthly
| Column name | Data type | Description | Example value |
|---|---|---|---|
| TRIAGENTHOSTNAMETX | VARCHAR2(400) | The hostname on which the code that interfaces to the BMS is running. The field can be helpful if you need to debug the data flow. | walleperf03 |
| TRIAGENTINSTANCETX | VARCHAR2(400) | If there are multiple programs interfacing to different BMSs on the same host then this field allows additional identifying information to be specified. The field can be helpful if you need to debug the data flow. | oBIXTest201 |
| TRIASSEMBLYLINETX | VARCHAR2(150) | Identifies what created the row and is used to help you debug the data flow. | triAssetHourlyFactLoad |
| TRICAPTUREDDT | NUMBER (32,0) | Captured Date and Time.
Required. Date and Time associated from the external database for this record. The number of seconds that has elapsed since January 1, 1970. Need to be in a uniform time zone (GMT). |
1391479200000 |
| TRICONTROLNUMBERCN | VARCHAR2(1000) | Control Number. System generated field. The field is automatically generated but a value is not required. |
100000001 |
| TRICREATEDDT | NUMBER (32,0) | Created Date and Time. Date and Time when this record was inserted in TRIRIGA®. The number of seconds that have elapsed since January 1, 1970. TRIRIGA's time zone use for debug. |
1391520579359 |
| TRIDIMASSETTX | VARCHAR2(150) | Asset. Required. Asset associated with Energy Use data (T_TRIBUILDINGEQUIPMENT.TRINAMETX) |
ITEO Test CH Asset 3-2-15 |
| TRIDIMASSETTXOBJID | NUMBER (20,0) | ref Asset. Required. (T_TRIBUILDINGEQUIPMENT.SYS_OBJECTID) |
54323333 |
| TRIDIMENERGYTYPETX | VARCHAR2(150) | Energy Type. Required. Reference to Energy Type from triEnergyType object (T_TRIENERGYTYPE.TRINAMETX). The Energy Type can be found in TRIRIGA under Classification in TRIRIGA. |
Electric |
| TRIDIMENERGYTYPETXOBJID | NUMBER (20,0) | ref
Energy Type Required. (T_TRIENERGYTYPE.SPEC_ID) |
54247649 |
| TRIDIMGEOGRAPHYTX | VARCHAR2(150) | Geography. Required. Reference to City specified on asset record (T_TRIBUILDING.TRIGEOGRAPHYLOOKUPTX where T_TRIBUILDING.SYS_OBJECTID = XXXXXX T_TRISPACE. TRIPARENTBUILDINGTXOBJID) |
CH |
| TRIDIMGEOGRAPHYTXOBJID | NUMBER (20,0) | ref
Geography. Required. (T_TRIBUILDING.TRIGEOGRAPHYLOOKUPTXOBJID where T_TRIBUILDING.SYS_OBJECTID = XXXXXX T_TRISPACE. TRIPARENTBUILDINGTXOBJID) |
54320390 |
| TRIDIMLOCATIONTX | VARCHAR2(150) | Location. Required. Reference to Building specified on asset record (T_TRISPACE.TRIPARENTBUILDINGTX where T_TRISPACE.SYS_OBJECTID = XXXXXX T_TRIBUILDINGEQUIPMENT.LOCATIONNAMEOBJID) |
ITEO Test CH Bldg 3 |
| TRIDIMLOCATIONTXOBJID | NUMBER (20,0) | ref Location. Required. (T_TRISPACE. TRIPARENTBUILDINGTXOBJID where T_TRISPACE.SYS_OBJECTID = XXXXXX T_TRIBUILDINGEQUIPMENT.LOCATIONNAMEOBJID) |
54320849 |
| TRIDIMSPECIFICATIONCLA | VARCHAR2(150) | Specification
Class. Reference to Specification Class specified on asset record (T_TRIBUILDINGEQUIPMENT.TRISPECCLASSCL) |
Air Handlers |
| TRIDIMSPECIFICATIONCLAOBJID | NUMBER (20,0) | ref Specification Class (T_TRIBUILDINGEQUIPMENT.TRISPECCLASSCLOBJID) |
3055758 |
| TRIFACTENERGYUSENU | NUMBER (32,12) | Energy Use. Required. Result from energy use calculation. The field represents the monthly energy use for the device in kWH. |
11999 |
| TRIENERGYUSEREPORTEDNU | NUMBER (32,12) | Energy Use Reported by a meter device. | 11999 |
| TRIFACTPEAKELECTRICALD | NUMBER (32,12) | Peak
Electrical Demand. Required for Peak Electric Energy Demand Report Result from peak demand calculation. The field represents the maximum monthly energy use for the device in kWH. |
500 |
| TRINAMEPLATEIDTX | VARCHAR2(150) | Nameplate
ID. Required. Uniquely identify on asset record in TRIRIGA. (Nameplate should uniquely exist in T_TRIBUILDINGEQUIPMENT.TRINAMEPLATEIDTX) |
oBIX-0255 |
| TRINODETX | VARCHAR2(150) | Node. Identifier from BMS that represents
unique asset. The field can be helpful if you need to debug the data flow. |
79:AHU255:BMS |
| TRISAMPLESACTUALNU | NUMBER (32,12) | Samples - Actual. The number of samples that were collected in the current interval (Month). Customer determines what percent of the maximum samples is enough for the reports and analytics. |
1393 |
| TRISAMPLESMAXIMUMNU | NUMBER (32,12) | Samples - Maximum. The maximum number of samples that could be collected in the current interval (Month). For example sample is taken every 15 minute * 24 hours a day * 31 days a month = 2976 |
2976 |
| TRIWRITETIMETX | VARCHAR2(16) | Write Time. Required. This is the starting time for the interval which this data represents. The format is 1YYMMDD000000000. For example 1140101000000000 represents January 1 2014 00:00:000 so this row represents January 1 2014 00:00:000 thru Jan 31 2014 23:59:59:999. |
1140101000000000 |