Column Name | Length | Req'd | Data Type | Comments |
BCHG_UP_ID | 30 | Y | Char | This is the foreign key to the billable charge upload staging record. |
SP_ID | 10 | Y | Char | Note, if USAGE_FLG is calculation, you can set this field to 0 if you do not know the SP ID. The only thing that's important is that the combination of BCHG_UP_ID, SP_ID and SEQNO are unique. |
SEQNO | 5 | Y | Number | This should be a value greater than zero. See SP_ID comment for more information. This is typically the sequence number of the register on the meter. |
END_READ_DTTM | 26 | Y | DateTime | This is the date and time of the end read |
END_REG_READ_ID | 12 | N | Char | This field must reference an existing register read ID if USAGE_FLG is anything other than a calculation. |
END_REG_READING | 9.6 | Y | Number | This is the reading of the end read. |
FINAL_REG_QTY | 12.6 | Y | Number | This is the final amount of the reading (this is the amount of billable consumption the read detail contributed to the entire billed consumption). |
FINAL_SQI | 8 | N | Char | The service quantity identifier of the FINAL_REG_QTY. If specified, it must reference a valid value on CI_SQI. Note, at least one of the following fields should be specified: FINAL_SQI, FINAL_UOM_CD. |
FINAL_TOU_CD | 8 | N | Char | The time-of-use code of the FINAL_REG_QTY. If specified, it must reference a valid value on CI_TOU. |
FINAL_UOM_CD | 4 | N | Char | The unit of measure of the FINAL_REG_QTY. If specified, it must reference a valid value on CI_UOM. Note, at least one of the following fields should be specified: FINAL_SQI, FINAL_UOM_CD. |
HOW_TO_USE_FLG | 2 | Y | Char | See the field description in the data dictionary for the valid values (CI_BCHG_UP_READ). |
MSR_PEAK_QTY_SW | 1 | Y | Char | Y or N |
MSR_QTY | 12.6 | Y | Number | This is the difference between END_REG_READING and START_REG_READING for subtractive registers. |
REG_CONST | 6.6 | Y | Number | This is the register's constant (the value used to adjust the measured quantity due to something associated with the physical meter). Set this to a value of 1 if it is not known. |
SQI_CD | 30 | N | Varchar | The service quantity identifier of END_REG_READING and START_REG_READING. If specified, it must reference a valid value on CI_SQI. Note, at least one of the following fields should be specified: SQI_CD, TOU_CD, UOM_CD. |
START_READ_DTTM | 26 | Y | DateTime | This is the date and time of the start reading. |
START_REG_READ_ID | 12 | Y | Char | This field must reference an existing register read ID if USAGE_FLG is anything other than a calculation. |
START_REG_READING | 9.6 | Y | Number | This is the reading of the start read. |
TOU_CD | 30 | N | Char | The time-of-use code of END_REG_READING and START_REG_READING. If specified, it must reference a valid value on CI_TOU. |
UOM_CD | 30 | Y | Char | The unit of measure of END_REG_READING and START_REG_READING. |
USAGE_FLG | 2 | Y | Char | See the field description in the data dictionary for the valid values (CI_BCHG_UP_READ). |
USE_PCT | 3 | Y | Number | This is the percentage of the consumption that was billed (this will typically be 100). |