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
Table 1. Daily Fact Table - T_TRIASSETENERGYUSEDFACT
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