Column Name | Length | Req'd | Data Type | Comments |
MR_STAGE_UP_ID | 12 | Y | A/N | This is the unique identifier of the meter read upload staging record. This key is a sequential number so you can use a database function to assign the value when populating the table. |
BADGE_NBR | 30 | N | A/N | If specified, this must correspond with a badge number on one of your meters. See the MTR_CONFIG_ID note below for how this field can be used. Also see the note under MTR_ID_NBR if you plan to use the meter's alternate ID's rather than the badge number to identify the meter being read. |
MTR_CONFIG_ID | 10 | See note | A/N | This must correspond with a meter configuration number on one of your meters. You may leave this column blank if BADGE_NBR or MTR_ID_TYPE_CD / MTR_ID_NBR is populated. |
READ_DTTM | 15 | Y | DateTime | The date and time of the meter read. |
MR_UP_STATUS_FLG | 2 | Y | A/N | This must be set to P for Pending. |
MR_ID | 12 | N | N | Leave this column blank. It will be assigned by the system when it creates a meter read record. |
MR_SOURCE_CD | 12 | N | A/N | The source of the meter read. |
GEO_TYPE_CD | 8 | N | A/N | See the description of the GEO_VAL field. |
GEO_VAL | 50 | N | A/N | This field along with GEO_TYPE_CD are used to uniquely identify the service point at which the meter read takes places. These fields are only necessary if you have duplicate BADGE_NBR's and you have uniquely identified your service points (with a unique GEO_TYPE_CD and GEO-VAL - e.g., a universal id). It's important to note that you must also specify the BADGE_NBR along with the GEO_TYPE_CD and GEO_VAL. |
MTR_ID_TYPE_CD | 5 | N | A/N | See the description of the MTR_ID_NBR field. |
MTR_ID_NBR | 30 | N | A/N | This field along with MTR_ID_TYPE_CD are used to uniquely identify the meter being read. These fields are only necessary if you do not use the meter's BADGE_NBR's or the meter's MTR_CONFIG_ID to identify the meter. If specified, this must correspond with a meter ID type / value associated with one of your meters. |
USE_ON_BILL_SW | 1 | Y | A/N | Indicates if the read can be used on a bill. Valid values are Y or N. Note, if the register read's REVIEW_HILO_SW is Y and if the register read fails high/low review, the USE_ON_BILL_SW may be set to N if the Use High/Low Failures on Bill is turned on in the installation record. |
MTR_READER_ID | 20 | N | A/N | The ID of the meter reader identified by the Meter Read Source, if supplied. |