Billable Charge Calculation Details Upload Staging Layout

You must create a billable charge read details upload record for each calculation 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

Leave this column blank. It is not used.

SEQNO

5

Y

Number

This should be a value greater than zero.

END_​READ_​DTTM

26

Y

DateTime

This is the date and time of the end quantity

END_​REG_​READ_​ID

12

N

Char

Leave this column blank. It is not used.

END_​REG_​READING

9.6

Y

Number

This is the end quantity.

FINAL_​REG_​QTY

12.6

Y

Number

This is the final quantity

FINAL_​SQI

8

N

Char

The rate 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

Quantity. This is the difference between end quantity and start quantity.

REG_​CONST

6.6

Y

Number

This is the constant value used to adjust the quantity. Set this to a value of 1 if it is not known.

SQI_​CD

8

N

The rate quantity identifier of end quantity and start quantity. 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 quantity.

START_​REG_​READ_​ID

12

Y

Char

Leave this column blank. It is not used.

START_​REG_​READING

9.6

Y

Number

This is the start quantity

TOU_​CD

8

N

Char

The time-of-use code of end quantity and start quantity. If specified, it must reference a valid value on CI_​TOU.

UOM_​CD

4

Y

Char

The unit of measure of end quantity and start quantity.

USAGE_​FLG

2

Y

Char

Leave this column blank. It is not used.

USE_​PCT

3

Y

Number

This is the percentage of the quantity that was billed (this will typically be 100).