Upload Read Characteristics
You must create a meter read characteristic upload staging record for each characteristic that you want to link to the meter read. The name of this table is CI_​MR_​STGUP_​CHAR. 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 must correspond with the prime key of the related CI_​MR_​STAGE_​UP record.
CHAR_​TYPE_​CD
8
Y
A/N
This must correspond with a characteristic type that is defined as valid for meter read upload staging. Refer to Setting Up Characteristic Types & Their Values for more information
SEQ_​NUM
3
Y
N
This should be set to 1 unless you have multiple values for a given meter read upload staging and characteristic type.
ADHOC_​CHAR_​VAL
254
N
A/N
Populate this field if your characteristic type is ad-hoc or file location.
CHAR_​VAL
16
N
A/N
Populate this field if your characteristic type is predefined
CHAR_​VAL_​FK1 -
CHAR_​VAL_​FK5
50 (each)
N
A/N
Populate these fields if your characteristic type is a foreign key reference. Up to five columns of 50 bytes each are provided to accommodate compound keys.