Billable Charge Read Details Upload Staging Layout

You must create a billable charge read details upload record for each read detail to be uploaded. The name of this table is CI_​BCHG_​UP_​READ. The following table describes each column on this table. Refer to "pass through" charges for more information about how this type of information is used.

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