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. |