Daily Fact Table - T_TRIASSETENERGYUSEDFACT
You must have data loaded into the daily fact table T_TRIASSETENERGYUSEDFACT in order to use the daily energy use reports.
- Module
- triMetricFact
- Business object
- triAssetEnergyUseDFact
- Display name
- Asset Energy Use Daily
| Column name | Data type | Description | Example value |
|---|---|---|---|
| TRIAGENTHOSTNAMETX | VARCHAR2(400) | Agent Hostname. Hostname where agent is running |
walleperf03 |
| TRIAGENTINSTANCETX | VARCHAR2(400) | Agent Instance. Instance name for the agent |
oBIXTest201 |
| TRIASSEMBLYLINETX | VARCHAR2(150) | AssemblyLine. Name of the AssemblyLine that created this row |
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 = T_TRISPACE. TRIPARENTBUILDINGTXOBJID) |
CH |
| TRIDIMGEOGRAPHYTXOBJID | NUMBER (20,0) | ref
Geography. Required. (T_TRIBUILDING.TRIGEOGRAPHYLOOKUPTXOBJID where T_TRIBUILDING.SYS_OBJECTID = T_TRISPACE. TRIPARENTBUILDINGTXOBJID) |
54320390 |
| TRIDIMLOCATIONTX | VARCHAR2(150) | Location. Required. Reference to Building specified on asset record (T_TRISPACE.TRIPARENTBUILDINGTX where T_TRISPACE.SYS_OBJECTID = T_TRIBUILDINGEQUIPMENT.LOCATIONNAMEOBJID) |
ITEO Test CH Bldg 3 |
| TRIDIMLOCATIONTXOBJID | NUMBER (20,0) | ref Location. Required. (T_TRISPACE. TRIPARENTBUILDINGTXOBJID where T_TRISPACE.SYS_OBJECTID = T_TRIBUILDINGEQUIPMENT.LOCATIONNAMEOBJID) |
54320849 |
| TRIDIMSPECIFICATIONCLA | VARCHAR2(150) | Specification
Class. Required. Reference to Specification Class specified on asset record (T_TRIBUILDINGEQUIPMENT.TRISPECCLASSCL) |
Air Handlers |
| TRIDIMSPECIFICATIONCLAOBJID | NUMBER (20,0) | ref Specification Class. Required. (T_TRIBUILDINGEQUIPMENT.TRISPECCLASSCLOBJID) |
3055758 |
| TRIFACTENERGYUSENU | NUMBER (32,12) | Energy Use. Required. Result from energy use calculation. The field represents the daily energy use for the device in kWH. |
0.8368 |
| TRIENERGYUSEREPORTEDNU | NUMBER (32,12) | Energy Use Reported by a meter device. | 11999 |
| 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 |
79:AHU255:BMS |
| TRISAMPLESACTUALNU | NUMBER (32,12) | Samples – Actual. The number of samples that were collected in the current interval (Day). Use to determine if we have enough samples for a complete interval. |
96 |
| TRISAMPLESMAXIMUMNU | NUMBER (32,12) | Samples – Maximum. The maximum number of samples that could be collected in the current interval (Day). For example sample is taken every 15 minute * 24 hours a day = 96 |
96 |
| 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 1, 2014 23:59:59:999. |
1140204000000000 |