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.