For Electric Meters:
Column | Encompass CSV Fields | Definition |
A | Device # | Omnimeter Serial Number |
B | Ver. # | Omnimeter Version (v.3, v.4, v.5) |
C | Meter/Group Name | Name of the meter or group in Encompass. |
D | Recipient Email | Where the report was emailed. |
E | Timezone | The timezone adjustment for data in Encompass. Set in the Encompass account settings. |
F | Report Date/Time | When the report was generated. |
G | Cost Per Unit ($) | Cost per kWh |
H | Meter Type | Electric, Water, Gas, or undefined pulse meter |
I | Beginning Timestamp | The date and time at the beginning of the reported time period. |
J | End Timestamp | The date and time at the end of the reported time period. |
K | Good Reads | The number of good real time reads in the reported time period. |
L | Total kWh Difference (usage) | The amount of Total kWh that incremented during the reported time period. This is Total kWh Max minus Total kWh Min. |
M | Difference (Usage) Cost | The cost for the kWh that incremented during the reported time period. Determined by applying the Cost Per Unit to the Total kWh Difference. |
N | Total kWh Max (Lifetime) | The Maximum Total kWh reading during the reported time period, which is the reading at the end of the period. |
O | Total kWh Min | The Minimum Total kWh reading during the reported time period, which is the reading at the beginning of the period. |
P | Net kWh | The Net of Forward and Reverse kWh, for when current is sometime flowing in both directions (energy generation and consumption). |
Q | Line 1 Total kWh Max | The Maximum Total kWh reading on Line 1 during the reported time period, which is the reading at the end of the period. |
R | Line 1 Total kWh Min | The Minimum Total kWh reading on Line 1 during the reported time period, which is the reading at the beginning of the period. |
S | Line 1 Total kWh Difference (usage) | The amount of Total kWh on Line 1 that incremented during the reported time period. This is L1 Total kWh Max minus L1 Total kWh Min. |
T | Line 2 Total kWh Max | The Maximum Total kWh reading on Line 2 during the reported time period, which is the reading at the end of the period. |
U | Line 2 Total kWh Min | The Minimum Total kWh reading on Line 2 during the reported time period, which is the reading at the beginning of the period. |
V | Line 2 Total kWh Difference (usage) | The amount of Total kWh on Line 2 that incremented during the reported time period. This is L2 Total kWh Max minus L2 Total kWh Min. |
W | Line 3 Total kWh Max | The Maximum Total kWh reading on Line 3 during the reported time period, which is the reading at the end of the period. |
X | Line 3 Total kWh Min | The Minimum Total kWh reading on Line 2 during the reported time period, which is the reading at the beginning of the period. |
Y | Line 3 Total kWh Difference (usage) | The amount of Total kWh on Line 3 that incremented during the reported time period. This is L3 Total kWh Max minus the L3 Total kWh Min. |
Z | Net kWh Difference | The Net of Forward and Reverse kWh for the reported time period, for when current is sometime flowing in both directions (energy generation and consumption) |
AA | Total Reverse kWh | The Maximum Reverse kWh Reading during the reported time period, which is the reading at the end of the period. |
AB | Reverse kWh Difference (Generation) | The amount of Reverse kWh that incremented during the reported time period. This is Reverse kWh Max minus Reverse kWh Min. |
AC | Reverse kWh Difference (Earnings) | The Reverse kWh Difference multiplied by the Cost Per Unit. |
AD | Line 1 Cost kWh | The Line 1 Reverse kWh Difference multiplied by the Cost Per Unit. |
AE | Line 1 Reverse kWh Max | The Maximum Reverse kWh reading on Line 1 during the reported time period, which is the reading at the end of the period. |
AF | Line 1 Reverse kWh Min | The Minimum Reverse kWh reading on Line 1 during the reported time period, which is the reading at the beginning of the period. |
AG | Line 1 Reverse kWh Difference (usage) | The amount of Reverse kWh on Line 1 that incremented during the reported time period. This is L1 Reverse kWh Max minus L1 Reverse kWh Min. |
AH | Line 1 Net kWh | The Line 1 Net of Forward kWh minus Reverse kWh, for when current is sometime flowing in both directions (energy generation and consumption). |
AI | Line 2 Cost kWh | The Line 2 Reverse kWh Difference multiplied by the Cost Per Unit. |
AJ | Line 2 Reverse kWh Max | The Maximum Reverse kWh reading on Line 2 during the reported time period, which is the reading at the end of the period. |
AK | Line 2 Reverse kWh Min | The Minimum Reverse kWh reading on Line 2 during the reported time period, which is the reading at the beginning of the period. |
AL | Line 2 Reverse kWh Difference (usage) | The amount of Reverse kWh on Line 2 that incremented during the reported time period. This is L2 Reverse kWh Max minus L2 Reverse kWh Min. |
AM | Line 2 Net kWh | The Line 2 Net of Forward kWh minus Reverse kWh, for when current is sometime flowing in both directions (energy generation and consumption). |
AN | Line 3 Cost kWh | The Line 3 Reverse kWh Difference multiplied by the Cost Per Unit. |
AO | Line 3 Reverse kWh Max | The Maximum Reverse kWh reading on Line 3 during the reported time period, which is the reading at the end of the period. |
AP | Line 3 Reverse kWh Min | The Minimum Reverse kWh reading on Line 3 during the reported time period, which is the reading at the beginning of the period. |
AQ | Line 3 Reverse kWh Difference (usage) | The amount of Reverse kWh on Line 3 that incremented during the reported time period. This is L3 Reverse kWh Max minus L3 Reverse kWh Min. |
AR | Line 3 Net kWh | The Line 3 Net of Forward kWh minus Reverse kWh, for when current is sometime flowing in both directions (energy generation and consumption). |
AS | Reverse kWh Max | The Maximum Reverse kWh reading during the reported time period, which is the reading at the end of the period. |
AT | Reverse kWh Min | The Minimum Reverse kWh reading during the reported time period, which is the reading at the end of the period. |
AU | Reverse kWh Difference (usage) | The amount of Reverse kWh that incremented during the reported time period. This is Reverse kWh Max minus Reverse kWh Min. |
AV | Forward kWh Max | The Maximum Forward kWh reading during the reported time period, which is the reading at the end of the period. |
AW | Forward kWh Min | The Minimum Forward kWh reading during the reported time period, which is the reading at the end of the period. |
AX | Forward kWh Difference (usage) | The amount of Forward kWh that incremented during the reported time period. This is Forward kWh Max minus Forward kWh Min. |
AY | Period 1 Max Total kWh TOU | TOU1 (Time Of Use Period 1) Maximum Total kWh reading for the reported time, which is the reading at the end of the period. |
AZ | Period 1 Min Total kWh TOU | TOU1 (Time Of Use Period 1) Minimum Total kWh reading for the reported time, which is the reading at the beginning of the period. |
BA | Period 1 Difference (usage) Total kWh TOU | TOU1 (Time Of Use Period 1) Total kWh that incremented during the reported time. This value is the difference between the Max and Min TOU1 values. |
BB | Period 2 Max Total kWh TOU | TOU2 (Time Of Use Period 2) Maximum Total kWh reading for the reported time, which is the reading at the end of the period. |
BC | Period 2 Min Total kWh TOU | TOU2 (Time Of Use Period 2) Minimum Total kWh reading for the reported time, which is the reading at the beginning of the period. |
BD | Period 2 Difference (usage) Total kWh TOU | TOU2 (Time Of Use Period 2) Total kWh that incremented during the reported time. This value is the difference between the Max and Min TOU2 values. |
BE | Period 3 Max Total kWh TOU | TOU3 (Time Of Use Period 3) Maximum Total kWh reading for the reported time, which is the reading at the end of the period. |
BF | Period 3 Min Total kWh TOU | TOU3 (Time Of Use Period 3) Minimum Total kWh reading for the reported time, which is the reading at the beginning of the period. |
BG | Period 3 Difference (usage) Total kWh TOU | TOU3 (Time Of Use Period 3) Total kWh that incremented during the reported time. This value is the difference between the Max and Min TOU3 values. |
BH | Period 4 Max Total kWh TOU | TOU4 (Time Of Use Period 4) Maximum Total kWh reading for the reported time. |
BI | Period 4 Min Total kWh TOU | TOU4 (Time Of Use Period 4) Minimum Total kWh reading for the reported time. |
BJ | Period 4 Difference (usage) Total kWh TOU | TOU4 (Time Of Use Period 4) Total kWh that incremented during the reported time. This value is the difference between the Max and Min TOU4 values. |
BK | Period 1 Max Reverse kWh TOU | TOU1 (Time Of Use Period 1) Maximum Reverse kWh reading for the reported time, which is the reading at the end of the period. |
BL | Period 1 Min Reverse kWh TOU | TOU1 (Time Of Use Period 1) Maximum Reverse kWh reading for the reported time, which is the reading at the beginning of the period. |
BM | Period 1 Difference (usage) Reverse kWh TOU | TOU1 (Time Of Use Period 1) Reverse kWh that incremented during the reported time. This value is the difference between the Max and Min TOU1 values. |
BN | Period 2 Max Reverse kWh TOU | TOU2 (Time Of Use Period 2) Maximum Reverse kWh reading for the reported time, which is the reading at the end of the period. |
BO | Period 2 Min Reverse kWh TOU | TOU2 (Time Of Use Period 2) Maximum Reverse kWh reading for the reported time, which is the reading at the beginning of the period. |
BP | Period 2 Difference (usage) Reverse kWh TOU | TOU2 (Time Of Use Period 2) Reverse kWh that incremented during the reported time. This value is the difference between the Max and Min TOU1 values. |
BQ | Period 3 Max Reverse kWh TOU | TOU3 (Time Of Use Period 3) Maximum Reverse kWh reading for the reported time, which is the reading at the end of the period. |
BR | Period 3 Min Reverse kWh TOU | TOU3 (Time Of Use Period 3) Maximum Reverse kWh reading for the reported time, which is the reading at the beginning of the period. |
BS | Period 3 Difference (usage) Reverse kWh TOU | TOU3 (Time Of Use Period 3) Reverse kWh that incremented during the reported time. This value is the difference between the Max and Min TOU1 values. |
BT | Period 4 Max Reverse kWh TOU | TOU4 (Time Of Use Period 4) Maximum Reverse kWh reading for the reported time, which is the reading at the end of the period. |
BU | Period 4 Min Reverse kWh TOU | TOU4 (Time Of Use Period 4) Maximum Reverse kWh reading for the reported time, which is the reading at the beginning of the period. |
BV | Period 4 Difference (usage) Reverse kWh TOU | TOU4 (Time Of Use Period 4) Reverse kWh that incremented during the reported time. This value is the difference between the Max and Min TOU1 values. |
BW | Total Watts Min | The minimum Total Watts reading during the reported time period. |
BX | Total Watts Min Time | The timestamp of the minimum Total Watts reading during the reported time period. |
BY | Total Watts Max | The maximum Total Watts reading during the reported time period. |
BZ | Total Watts Max Time | The timestamp of the Maximum Total Watts reading during the reported time period. |
CA | Total Watts Average | The Average Total Watts reading during the reported time period. |
CB | Line 1 Watts Min | The Line 1 Minimum Watts reading during the reported time period. |
CC | Line 1 Watts Min Time | The timestamp of the Line 1 Minimum Watts reading during the reported time period. |
CD | Line 1 Watts Max | The Line 1 Maximum Watts reading during the reported time period. |
CE | Line 1 Watts Max Time | The timestamp of the Line 1 Maximum Watts reading during the reported time period. |
CF | Line 1 Watts Average | The Line 1 Average Watts reading during the reported time period. |
CG | Line 2 Watts Min | The Line 2 Minimum Watts reading during the reported time period. |
CH | Line 2 Watts Min Time | The timestamp of the Line 2 Minimum Watts reading during the reported time period. |
CI | Line 2 Watts Max | The Line 2 Maximum Watts reading during the reported time period. |
CJ | Line 2 Watts Max Time | The timestamp of the Line 2 Maximum Watts reading during the reported time period. |
CK | Line 2 Watts Average | The Line 2 Average Watts reading during the reported time period. |
CL | Line 3 Watts Min | The Line 3 minimum Total Watts reading during the reported time period. |
CM | Line 3 Watts Min Time | The timestamp of the Line 3 minimum Total Watts reading during the reported time period. |
CN | Line 3 Watts Max | The Line 3 Maximum Watts reading during the reported time period. |
CO | Line 3 Watts Max Time | The timestamp of the Line 3 Maximum Watts reading during the reported time period. |
CP | Line 3 Watts Average | The Line 3 Average Watts reading during the reported time period. |
CQ | Line 1 Volts Min | The Line 1 Minimum Volts reading during the reported time period. |
CR | Line 1 Volts Min Time | The timestamp of the Line 1 Minimum Volts reading during the reported time period. |
CS | Line 1 Volts Max | The Line 1 Maximum Volts reading during the reported time period. |
CT | Line 1 Volts Max Time | The timestamp of the Line 1 Maximum Volts reading during the reported time period. |
CU | Line 1 Volts Average | The Line 1 Average Volts reading during the reported time period. |
CV | Line 2 Volts Min | The Line 2 Minimum Volts reading during the reported time period. |
CW | Line 2 Volts Min Time | The timestamp of the Line 2 Minimum Volts reading during the reported time period. |
CX | Line 2 Volts Max | The Line 2 Maximum Volts reading during the reported time period. |
CY | Line 2 Volts Max Time | The timestamp of the Line 2 Maximum Volts reading during the reported time period. |
CZ | Line 2 Volts Average | The Line 2 Average Volts reading during the reported time period. |
DA | Line 3 Volts Min | The Line 3 Minimum Volts reading during the reported time period. |
DB | Line 3 Volts Min Time | The timestamp of the Line 3 Minimum Volts reading during the reported time period. |
DC | Line 3 Volts Max | The Line 3 Maximum Volts reading during the reported time period. |
DD | Line 3 Volts Max Time | The timestamp of the Line 3 Maximum Volts reading during the reported time period. |
DE | Line 3 Volts Average | The Line 3 Average Volts reading during the reported time period. |
DF | Line 1 Amps Min | The Line 1 Minimum Amperage reading during the reported time period. |
DG | Line 1 Amps Min Time | The timestamp of the Line 1 Minimum Amperage reading during the reported time period. |
DH | Line 1 Amps Max | The Line 1 Maximum Amperage reading during the reported time period. |
DI | Line 1 Amps Max Time | The timestamp of the Line 1 Maximum Amperage reading during the reported time period. |
DJ | Line 1 Amps Average | The Line 1 Average Amperage reading during the reported time period. |
DK | Line 2 Amps Min | The Line 2 Minimum Amperage reading during the reported time period. |
DL | Line 2 Amps Min Time | The timestamp of the Line 2 Minimum Amperage reading during the reported time period. |
DM | Line 2 Amps Max | The Line 2 Maximum Amperage reading during the reported time period. |
DN | Line 2 Amps Max Time | The timestamp of the Line 2 Maximum Amperage reading during the reported time period. |
DO | Line 2 Amps Average | The Line 2 Average Amperage reading during the reported time period. |
DP | Line 3 Amps Min | The Line 3 Minimum Amperage reading during the reported time period. |
DQ | Line 3 Amps Min Time | The timestamp of the Line 3 Minimum Amperage reading during the reported time period. |
DR | Line 3 Amps Max | The Line 3 Maximum Amperage reading during the reported time period. |
DS | Line 3 Amps Max Time | The timestamp of the Line 3 Maximum Amperage reading during the reported time period. |
DT | Line 3 Amps Average | The Line 3 Average Amperage reading during the reported time period. |
DU | Line 1 Power Factor Min | The Line 1 Minimum Power Factor reading during the reported time period. |
DV | Line 1 Power Factor Max | The Line 1 Maximum Power Factor reading during the reported time period. |
DW | Line 1 Power Factor Max Time | The timestamp of the Line 1 Maximum Power Factor reading during the reported time period. |
DX | Line 1 Power Factor Average | The Line 1 Average Power Factor eading during the reported time period.r |
DY | Line 2 Power Factor Min | The Line 2 Minimum Power Factor reading during the reported time period. |
DZ | Line 2 Power Factor Max | The Line 2 Maximum Power Factor reading during the reported time period. |
EA | Line 2 Power Factor Max Time | The timestamp of the Line 2 Maximum Power Factor reading during the reported time period. |
EB | Line 2 Power Factor Average | The Line 2 Average Power Factor reading during the reported time period. |
EC | Line 3 Power Factor Min | The Line 3 Minimum Power Factor reading during the reported time period. |
ED | Line 3 Power Factor Max | The Line 3 Maximum Power Factor reading during the reported time period. |
EE | Line 3 Power Factor Max Time | The timestamp of the Line 3 Maximum Power Factor reading during the reported time period. |
EF | Line 3 Power Factor Average | The Line 3 Average Power Factor reading during the reported time period. |
EG | Net Total Watts Min | The minimum reading for Net Total Watts for the reported time period, for when current is sometime flowing in both directions (power generation and consumption) |
EH | Net Total Watts Min Time | The timestamp of the minimum Net Total Watts reading during the reported time period. |
EI | Net Total Watts Max | The maximum Net Total Watts reading during the reported time period. |
EJ | Net Total Watts Max Time | The timestamp of the Maximum Net Total Watts reading during the reported time period. |
EK | Net Total Watts Average | The Average Net Total Watts reading during the reported time period. |
EL | Line 1 Net Watts Min | The Line 1 Minimum Net Watts reading during the reported time period. |
EM | Line 1 Net Watts Min Time | The timestamp of the Line 1 Minimum Net Watts reading during the reported time period. |
EN | Line 1 Net Watts Max | The Line 1 Maximum Net Watts reading during the reported time period. |
EO | Line 1 Net Watts Max Time | The timestamp of the Line 1 Maximum Net Watts reading during the reported time period. |
EP | Line 1 Net Watts Average | The Line 1 Average Net Watts reading during the reported time period. |
EQ | Line 2 Net Watts Min | The Line 2 Minimum Net Watts reading during the reported time period. |
ER | Line 2 Net Watts Min Time | The timestamp of the Line 1 Minimum Net Watts reading during the reported time period. |
ES | Line 2 Net Watts Max | The Line 2 Maximum Net Watts reading during the reported time period. |
ET | Line 2 Net Watts Max Time | The timestamp of the Line 2 Maximum Net Watts reading during the reported time period. |
EU | Line 2 Net Watts Average | The Line 2 Average Net Watts reading during the reported time period. |
EV | Line 3 Net Watts Min | The Line 3 Minimum Net Watts reading during the reported time period. |
EW | Line 3 Net Watts Min Time | The timestamp of the Line 1 Minimum Net Watts reading during the reported time period. |
EX | Line 3 Net Watts Max | The Line 3 Maximum Net Watts reading during the reported time period. |
EY | Line 3 Net Watts Max Time | The timestamp of the Line 3 Maximum Net Watts reading during the reported time period. |
EZ | Line 3 Net Watts Average | The Line 3 Average Net Watts reading during the reported time period. |
FA | Total VAR Min | The minimum Total Reactive Power reading during the reported time period. V.4 and v.5 Meters only. |
FB | Total VAR Max | The maximum Total Reactive Power reading during the reported time period. V.4 and v.5 Meters only. |
FC | Total VAR Max Time | The timestamp of the maximum Total Reactive Power reading during the reported time period. V.4 and v.5 Meters only. |
FD | Total VAR Average | The average Total Reactive Power reading during the reported time period. V.4 and v.5 Meters only. |
FE | Total kVARh Max | The maximum Total Reactive Energy reading during the reported time period. V.4 and v.5 Meters only. |
FF | Total kVARh Min | The minimum Total Reactive Energy reading during the reported time period. V.4 and v.5 Meters only. |
FG | Total kVARh Difference (usage) | The amount of Total Reactive Energy that incremented during the reported time period. V.4 and v.5 Meters only. |
FH | Line 1 Min Total VAR | The minimum Total Reactive Energy reading on Line 1 during the reported time period. V.4 and v.5 Meters only. |
FI | Line 1 Max Total VAR | The maximum Total Reactive Energy reading on Line 1 during the reported time period. V.4 and v.5 Meters only. |
FJ | Line 1 Max Time Total VAR | The timestamp of the maximum Total Reactive Energy reading on Line 1, during the reported time period. V.4 and v.5 Meters only. |
FK | Line 1 Average Total VAR | The average Total Reactive Energy reading on Line 1 during the reported time period. V.4 and v.5 Meters only. |
FL | Line 2 Min Total VAR | The minimum Total Reactive Energy reading on Line 2 during the reported time period. V.4 and v.5 Meters only. |
FM | Line 2 Max Total VAR | The maximum Total Reactive Energy reading on Line 2 during the reported time period. V.4 and v.5 Meters only. |
FN | Line 2 Max Time Total VAR | The timestamp of the maximum Total Reactive Energy reading on Line 2, during the reported time period. V.4 and v.5 Meters only. |
FO | Line 2 Average Total VAR | The average Total Reactive Energy reading on Line 2 during the reported time period. V.4 and v.5 Meters only. |
FP | Line 3 Min Total VAR | The minimum Total Reactive Energy reading on Line 3 during the reported time period. V.4 and v.5 Meters only. |
FQ | Line 3 Max Total VAR | The maximum Total Reactive Energy reading on Line 3 during the reported time period. V.4 and v.5 Meters only. |
FR | Line 3 Max Time Total VAR | The timestamp of the maximum Total Reactive Energy reading on Line 3, during the reported time period. V.4 and v.5 Meters only. |
FS | Line 3 Average Total VAR | The average Total Reactive Energy reading on Line 3 during the reported time period. V.4 and v.5 Meters only. |
FT | Line Frequency Max | The maximum Line Frequency reading during the reported time period. V.4 and v.5 Meters only. |
FU | Line Frequency Min | The minimum Line Frequency reading during the reported time period. V.4 and v.5 Meters only. |
FV | Line Frequency Max Time | The timestamp of the maximum Line Frequency reading during the reported time period. V.4 and v.5 Meters only. |
FW | Line Frequency Min Time | The timestamp of the minimum Line Frequency reading during the reported time period. V.4 and v.5 Meters only. |
FX | Line Frequency Avg | The average Line Frequency reading during the reported time period. V.4 and v.5 Meters only. |
FY | Group Cost | The calculated cost for all of the usage, for all of the meters in the group, for the reported time period. Row FT for v.3 meters. |
For Water, Gas, and Pulse Meters:
Column | Encompass CSV Fields | Definition |
A | Device # | Omnimeter Serial Number |
B | Ver. # | Omnimeter Version (v.4 or v.5) |
C | Meter/Group Name | Name of the meter or group in Encompass. |
D | Recipient Email | Where the report was emailed. |
E | Timezone | The timezone adjustment for data in Encompass. Set in the Encompass account settings. |
F | Report Date/Time | When the report was generated. |
G | Cost Per Unit ($) | Cost per unit of water, gas, or pulse. |
H | Meter Type | Water, Gas, or Pulse. |
I | Beginning Timestamp | The date and time at the beginning of the reported time period. |
J | End Timestamp | The date and time at the end of the reported time period. |
K | Good Reads | The number of good real time reads in the reported time period. |
L | Difference (Usage) Cost | The cost for the amount of water, gas, or pulses that incremented during the reported time period. Determined by applying the Cost Per Unit to the Pulse Count Difference (usage) in Units |
M | Pulse Count | The lifetime pulse count for a given meter. |
N | Pulse Count Min | The Minimum Pulse Count reading during the reported time period, which is the reading at the beginning of the period. |
O | Pulse Count Max | The Maximum Pulse Count reading during the reported time period, which is the reading at the end of the period. |
P | Pulse Count Difference (Usage) | The of pulses that incremented during the reported time period. |
Q | Pulse Count Difference (Usage) in Units | The of pulses that incremented during the reported time period, converted to units of water or gas. |
R | Pulse Unit Type | The units of water or gas. |
S | Pulse Count Delta Min | The smallest increment of pulse during the reported time period. |
T | Line Frequency Max | The maximum Line Frequency reading during the reported time period. |
U | Line Frequency Min | The minimum Line Frequency reading during the reported time period. |
V | Line Frequency Max Time | The timestamp of the maximum Line Frequency reading during the reported time period. |
W | Line Frequency Min Time | The timestamp of the minimum Line Frequency reading during the reported time period. |
X | Line Frequency Avg | The average Line Frequency reading during the reported time period. |
Y | Group Cost | The calculated cost for all of the usage, for all of the meters in the group, for the reported time period. |