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.