Table: BILLINGPRIORADJUSTMENTS

BILLINGPRIORADJUSTMENTS

Name

BILLINGPRIORADJUSTMENTS

Comment

BILLINGPRIORADJUSTMENTS sets out prior period adjustments and associated interest inserted in subsequent Final Statements arising from Revision Statement postings.


Description

BILLINGPRIORADJUSTMENTS data is confidential to the relevant participant.

Source

BILLINGPRIORADJUSTMENTS is populated on the posting of a Final billing run only.

Volume

Approximately two records inserted per week.

Note

Actual adjustment payable is ADJAMOUNT - PERAMOUNT + INTEREST AMOUNT.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

ADJBILLRUNNO

ADJCONTRACTYEAR

ADJWEEKNO

BILLRUNNO

CONTRACTYEAR

PARTICIPANTID

WEEKNO


Index Columns

Name

LASTCHANGED


Index Columns

Name

PARTICIPANTID

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTYEAR

NUMBER(4,0)

X

Settlement year.

WEEKNO

NUMBER(3,0)

X

Settlement week number.

BILLRUNNO

NUMBER(3,0)

X

Billing run number.

ADJCONTRACTYEAR

NUMBER(4,0)

X

ContractYear of the posted revision statement inserted to the Final Statement

ADJWEEKNO

NUMBER(3,0)

X

WeekNo of the posted revision statement inserted to the Final Statement

ADJBILLRUNNO

NUMBER(3,0)

X

Bill run number of the posted revision statement inserted to the Final Statement

PARTICIPANTID

VARCHAR2(10)

X

Participant ID

PREVAMOUNT

NUMBER(15,5)

 

Statement total of the previous posted revision statement inserted to the Final Statement.

ADJAMOUNT

NUMBER(15,5)

 

Adjusted amount.

IRN

NUMBER(15,5)

 

Interest rate applied to the revision adjustment

IRP

NUMBER(15,5)

 

unused; always null

INTERESTAMOUNT

NUMBER(15,5)

 

Interest amount.

LASTCHANGED

DATE

 

Last changed.

IRSR_PREVAMOUNT

NUMBER(15,5)

 

unused; always null

IRSR_ADJAMOUNT

NUMBER(15,5)

 

unused; always null

IRSR_INTERESTAMOUNT

NUMBER(15,5)

 

unused; always null