Billable Charge Upload Staging Layout

Column Name

Length

Req'd

Data Type

Comments

BCHG_​UP_​ID

30

Y

Char

This is the unique identifier of the record. This value does NOT have to be a random number, but it does need to be unique. If your process that inserts records on this table is capable of calling a routine, call ProgramCIPZKEYG and it will supply a 12 digit random number for you.

BCHG_​UP_​STAT_​FLG

2

Y

Char

This must be set to P for Pending.

NT_​XID_​CD

30

N

Char

This is the external system id of the sender of the billable charge. See the description of the SA_​EXT_​REFT_​ID field for how this field is used to determine the billable charge's SA_​ID.

SA_​EXT_​REF_​ID

36

N

Varchar2

This field along with NT_​XID_​CD are used to uniquely identify the service agreement against which the billable charge will be stored. These two fields are used to identify a SA relationship record; the SA relationship record, in turn, has a sub SA and it is this SA that the billable charge will be linked to. Note well: these fields are only necessary if you do not know the billable charge SA ID. Refer to Maintaining SA Relationships for more information.

BCHG_​EXT_​REF_​ID

50

N

Varchar2

This is the identifier of the billable charge in the sender's system.

CRE_​DTTM

26

N

Date/Time

The date and time the upload staging row was inserted (this can be used for audit purposes).

START_​DT

10

Y

Date

The start date of the period encompassed by the billable charge.

END_​DT

10

Y

Date

The end date of the billable charge period.

DESCR_​ON_​BILL

254

Y

Varchar2

This is the description that should prefix the charges on the printed bill.

SA_​ID

10

See note

Char

This must correspond with a SA ID of a billable charge service agreement. You may leave this column blank if NT_​XID_​CD and SA_​EXT_​REF_​ID are populated.

BILLABLE_​CHG_​ID

12

N

Char

Leave this column blank. It will be assigned by the system when it creates a billable charge record.