Dataset: Utility Meter Reading
Dataset name:
ds_utility_meter_readings
Description
Utility meter readings
Fields in this dataset
Name | Field Name | Description | Field Type | Field Example |
---|---|---|---|---|
Meter Reading ID |
id
|
The primary identifier for this record. | number | 5 |
Utility Meter Reading Instance |
instance
|
The instance this transaction relates to. | number | 8 |
Utility Meter Reading Source |
source
|
The source of the data - user or connection. | text | |
Utility Transactions Meter Reading |
utility_reading
|
The value of the meter reading | number | |
Utility Transactions Meter Read Date |
utility_reading_date
|
The date on which the meter was read | date | |
Utility Transactions Estimated |
utility_reading_estimated
|
Boolean indicating whether the meter reading is estimated. | varchar | Y/N |
Utility Transactions Read By |
utility_reading_read_by
|
How the meter was read | varchar | Auto |
Meter Reading Type |
utility_reading_type
|
The type of meter reading (helps to distinguish on mixed bills). | varchar | |
Utility Transactions Metering Unit |
utility_reading_unit
|
The units read by the meter | text | kWh |