BILLINGPRIORADJUSTMENTS
BILLINGPRIORADJUSTMENTS sets out prior period adjustments and associated interest inserted in subsequent Final Statements arising from Revision Statement postings.
Package
BILLING_RUN
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
Settlement year. |
| WEEKNO |
numeric(3, 0) |
smallint |
Settlement week number. |
| BILLRUNNO |
numeric(3, 0) |
smallint |
Billing run number. |
| ADJCONTRACTYEAR |
numeric(4, 0) |
smallint |
ContractYear of the posted revision statement inserted to the Final Statement |
| ADJWEEKNO |
numeric(3, 0) |
smallint |
WeekNo of the posted revision statement inserted to the Final Statement |
| ADJBILLRUNNO |
numeric(3, 0) |
smallint |
Bill run number of the posted revision statement inserted to the Final Statement |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Participant ID |
| PREVAMOUNT |
numeric(15, 5) |
numeric(15, 5) |
Statement total of the previous posted revision statement inserted to the Final Statement. |
| ADJAMOUNT |
numeric(15, 5) |
numeric(15, 5) |
Adjusted amount. |
| IRN |
numeric(15, 5) |
numeric(15, 5) |
Interest rate applied to the revision adjustment |
| IRP |
numeric(15, 5) |
numeric(15, 5) |
unused; always null |
| INTERESTAMOUNT |
numeric(15, 5) |
numeric(15, 5) |
Interest amount. |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last changed. |
| IRSR_PREVAMOUNT |
numeric(15, 5) |
numeric(15, 5) |
unused; always null |
| IRSR_ADJAMOUNT |
numeric(15, 5) |
numeric(15, 5) |
unused; always null |
| IRSR_INTERESTAMOUNT |
numeric(15, 5) |
numeric(15, 5) |
unused; always null |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLINGPRIORADJMNTS_NDX_LCHD |
nonclustered |
LASTCHANGED |
| BILLINGPRIORADJUSTMENTS_NDX2 |
nonclustered |
PARTICIPANTID, LASTCHANGED |
| BILLINGPRIORADJUSTMENTS_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, ADJCONTRACTYEAR, ADJWEEKNO, ADJBILLRUNNO, PARTICIPANTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_BILLINGPRIORADJUSTMENTS_LASTCHANGED |
nonclustered |
LASTCHANGED |
| IX_BILLINGPRIORADJUSTMENTS_PARTICIPANTID_LASTCHANGED |
nonclustered |
PARTICIPANTID, LASTCHANGED |
| PK_BILLINGPRIORADJUSTMENTS |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, ADJCONTRACTYEAR, ADJWEEKNO, ADJBILLRUNNO, PARTICIPANTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLINGPRIORADJMNTS_NDX_LCHD |
nonclustered |
LASTCHANGED |
| BILLINGPRIORADJUSTMENTS_NDX2 |
nonclustered |
PARTICIPANTID, LASTCHANGED |
| BILLINGPRIORADJUSTMENTS_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, ADJCONTRACTYEAR, ADJWEEKNO, ADJBILLRUNNO, PARTICIPANTID |