Meter Read Upload Staging
You must create an upload staging record for each meter that was read. The name of this table is CI_MR_STAGE_UP. The following table describes each column on this table.
|
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. |