Destination Field |
Source Field |
Comments |
---|---|---|
OAC_OBJECT |
OBJECT |
|
OAC_OBJECT_ORG |
OBJECT_ORG |
|
OAC_COMMODITY |
Parameter Commodity |
Convert the parameter value to upper case. |
OAC_DATE |
Date Recorded |
Remove the time component. |
OAC_USAGE |
If the design usage matches the DailyUsageUOM then determine usage as follows: Determine Electric Sub-meter Interval for the equipment Expected Records = 1440 / Electric Sub-meter Interval On = Count records where Equipment_On = ‘+’ Usage = On / Expected Records If the design usage matches the HourlyUsageUOM then determine usage by following the same steps as for the daily UOM but add one more step as follows: Usage = Usage * 24 |
|
OAC_ACTUALCONSUMPTION |
Actual consumption is the sum of ENERGY_KWH |
|
OAC_DESIGNUSAGEUOM |
Copy from associated design consumption record for this equipment, commodity and date. |
|
OAC_UPDATED |
System Date |
Remove time component |
OAC_LOADFACTOR |
Copy from associated design consumption record for this equipment, commodity and date. If no value is found default to 100. Do not include this field in updates. Note: The update exclusion is to support users updating the Loadfactor manually, without the system then overwriting this manual entry later when the alert runs again. |