|
Name |
|
|
Comment |
BILLINGPRIORADJUSTMENTS sets out prior period adjustments and associated interest inserted in subsequent Final Statements arising from Revision Statement postings. |
|
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. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
ADJBILLRUNNO |
|
ADJCONTRACTYEAR |
|
ADJWEEKNO |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
LASTCHANGED |
|
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 |
|
|
|