Hourly Fact Table - T_TRIASSETANALYTICHFACT
You must have data loaded into the hourly fact table T_TRIASSETANALYTICHFACT in order to use the analytic rules.
- Module
- triMetricFact
- Business object
- triAssetAnalyticHFact
- Display name
- Asset Analytic Hourly
| 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. This 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. 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 (T_TRIENERGYTYPE.SPEC_ID) |
54247649 |
| TRIDIMGEOGRAPHYTX | VARCHAR2(150) | Geography. Required. Reference to City specified on asset record (T_TRIBUILDING. TRICITYTX 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. Reference to Specification Class specified on asset record (T_TRIBUILDINGEQUIPMENT.TRISPECCLASSCL) |
Air Handlers |
| TRIDIMSPECIFICATIONCLAOBJID | NUMBER (20,0) | ref Specification Class (T_TRIBUILDINGEQUIPMENT.TRISPECCLASSCLOBJID) |
3055758 |
| TRIFACTCOOLANTFLOWLMNU | NUMBER (32,12) | Cooling Liquid Flow In Liters Per Minute | 10.4 |
| TRIFACTCOOLINGVALVEPCT | NUMBER (32,12) | Cooling Valve Percentage. The percentage open of the cooling valve, where 100% represents completely open and 0% represents completely closed |
9.3 |
| TRIFACTECONOMIZERMODEN | NUMBER (32,12) | 0 or 1. Economizer Mode Economizer Mode setting for this device. 0 represents it’s not currently running in economizer more, 1 represents it is currently running in economizer. |
1 |
| TRIFACTENERGYUSENU | NUMBER (32,12) | This is energy use, in kWh of this device for this hour. This should match the value in triAssetEnergyUseHFact. | 10 |
| TRIFACTENEGYUSEREPORTEDNU | NUMBER (32,12) | Energy Use Reported by a meter device. | 1014 |
| TRIFACTEXHAUSTFANCURRE | NUMBER (32,12) | Exhaust Fan Current In Amperes | 79.8 |
| TRIFACTEXHAUSTFANOUTPU | NUMBER (32,12) | Exhaust Fan Output Percentage | 80 |
| TRIFACTEXHAUSTFANSTATU | NUMBER (32,12) | Exhaust Fan Status 0 represents OFF and 1 represents ON |
0 |
| TRIFACTHEATINGVALVEPCT | NUMBER (32,12) | Heating Valve Percentage. This is the percentage open of the valve, where 100% represents completely open and 0% represents completely closed |
76.3 |
| TRIFACTHUMIDIFIERVALVE | NUMBER (32,12) | Humidifier Valve Percentage This is the percentage open of the valve, where 100% represents completely open and 0% represents completely closed |
53 |
| TRIFACTINSCHEDULENU | NUMBER (32,12) | 0 or 1. This value should be set to the results of querying the Scheduler for the Asset, set to 1 if the Asset on schedule, and 0 if off schedule | 1 |
| TRIFACTISAVAILABLENU | NUMBER (32,12) | 0 or 1. This value should be set to the results of querying the Asset Status in TRIRIGA, set to 1 if status is ‘Available’ | 1 |
| TRIFACTISCALCULATEDRUN | NUMBER (32,12) | 0 or 1. This value should be set to 0 if the
asset is not intended to be running and 1 if it is intended to be
running. Example algorithm per Specification of a device. Air Handling (TRIFACTSUPPLYFANSTATUS = 1) OR (TRIFACTSUPPLYFANSTATUS = null AND TRIFACTSUPPLYFANCURREN >= 1) OR (TRIFACTSUPPLYFANSTATUS = null AND TRIFACTSUPPLYFANCURREN = null AND TRIFACTSUPPLYFANOUTPUT >= 1) Chill Water (TRIFACTPOWERUSAGEWNU > 25000) OR (TRIFACTPOWERUSAGEWNU = null AND TRIFACTISAVAILABLENU = 1) |
1 |
| TRIFACTISMAINTENANCEMO | NUMBER (32,12) | 0 or 1. This value should be set to the results of querying the Asset Status in TRIRIGA, set to 1 if status is ‘Offline for Maintenance’ else 0 | 0 |
| TRIFACTMIXAIRTEMPCNU | NUMBER (32,12) | Mixed Air Temperature In Celsius | 19.2 |
| TRIFACTOCCUPIEDCOMMAND | NUMBER (32,12) | 0 or 1. Occupied Command. 0 means the space serviced by this device is unoccupied, and 1 means the space is occupied |
1 |
| TRIFACTOUTSIDEAIRDAMPE | NUMBER (32,12) | Outside Air Damper Minimum Percentage | 31.9 |
| TRIFACTOUTSIDEAIRDAMPE1 | NUMBER (32,12) | Outside Air Damper Percentage | 79.5 |
| TRIFACTOUTSIDEAIRTEMPC | NUMBER (32,12) | Outside Air Temperature In Celsius | 23.2 |
| TRIFACTOUTSIDEENTHALPY | NUMBER (32,12) | Outside Enthalpy In Joules Per Kilogram | 71.7 |
| TRIFACTOUTSIDEHUMIDITY | NUMBER (32,12) | Outside Humidity Percentage | 81.7 |
| TRIFACTPOWERUSAGEWNU | NUMBER (32,12) | Power Usage In Watts | 836.8 |
| TRIFACTPREHEATVALVEPCT | NUMBER (32,12) | Preheat Valve Percentage This is the percentage open of the valve, where 100% represents completely open and 0% represents completely closed. |
48.1 |
| TRIFACTREHEATVALVEPCTN | NUMBER (32,12) | Reheat Valve Percentage This is the percentage open of the valve, where 100% represents completely open and 0% represents completely closed. |
48.1 |
| TRIFACTRETURNAIRCOPPM | NUMBER (32,12) | Return Air CO2 In Parts Per Million | 81.8 |
| TRIFACTRETURNAIRTEMPCN | NUMBER (32,12) | Return Air Temperature In Celsius | 25.8 |
| TRIFACTRETURNCOOLANTTE | NUMBER (32,12) | Return Cooling Temperature In Celsius | 18.8 |
| TRIFACTRETURNFANOUTPUT | NUMBER (32,12) | Return Fan Output Percentage | 81.9 |
| TRIFACTSTEAMVALVEPCTNU | NUMBER (32,12) | Steam Valve Percentage This is the percentage open of the valve, where 100% represents completely open and 0% represents completely closed. |
15.9 |
| TRIFACTSUPPLYAIRTEMPCN | NUMBER (32,12) | Supply Air Temperature In Celsius | 17.2 |
| TRIFACTSUPPLYAIRTEMPSP | NUMBER (32,12) | Supply Air Temperature Setpoint In Celsius | 13.5 |
| TRIFACTSUPPLYCOOLANTTE | NUMBER (32,12) | Supply Cooling Temperature In Celsius | 10.2 |
| TRIFACTSUPPLYCOOLANTTE1 | NUMBER (32,12) | Supply Cooling Temperature Setpoint In Celsius | 10.9 |
| TRIFACTSUPPLYFANCURREN | NUMBER (32,12) | Supply Fan Current In Amperes | 79.6 |
| TRIFACTSUPPLYFANOUTPUT | NUMBER (32,12) | Supply Fan Output Percentage | 81.9 |
| TRIFACTSUPPLYFANSTATUS | NUMBER (32,12) | Supply Fan Status | 0 |
| TRIFACTSUPPLYRELHUMIDI | NUMBER (32,12) | Supply Relative Humidity Percentage | 35.9 |
| TRIFACTSUPPLYRELHUMIDI1 | NUMBER (32,12) | Supply Relative Humidity Setpoint Percentage | 66.6 |
| TRIFACTZONERELHUMIDITY | NUMBER (32,12) | Zone Relative Humidity Percentage | 34 |
| TRIFACTZONETEMPCNU | NUMBER (32,12) | Zone Air Temperature In Celsius | 19.2 |
| 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 |
| TRISPECIFICATIONSUBTYP | VARCHAR2(150) | Sub Type Specification Class. Reference to Specification Class specified on asset record (T_TRIBUILDINGEQUIPMENT.TRISPECCLASSCL) |
VAV |
| TRIWRITETIMETX | VARCHAR2(16) | Write Time. Required. This is the starting time for the interval which this data represents. The format is 1YYMMDDHH0000000. For example 1140101020000000 represents January 1, 2014 02:00:000, so this row represents January 1, 2014 02:00:000 thru January 1, 2014 02:59:999. |
1140204020000000 |