Skip to content

BILLADJUSTMENTS (Historical table)

Package

HISTORICAL_TABLES

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
CONTRACTYEAR numeric(4, 0) 🔑 smallint 🔑 AEMO Contract Year number starting in week containing 1st January
WEEKNO numeric(3, 0) 🔑 smallint 🔑 -
PARTICIPANTID varchar(10) 🔑 varchar(10) 🔑 Unique participant identifier
ADJCONTRACTYEAR numeric(4, 0) 🔑 smallint 🔑 The contract year of the new revised billing run for this adjustment
ADJWEEKNO numeric(3, 0) 🔑 smallint 🔑 Week number of the new revised billing run for this adjustment
ADJBILLRUNNO numeric(3, 0) 🔑 smallint 🔑 Billing run number of the new revised billing run for this adjustment
BILLRUNNO numeric(3, 0) smallint The sequential number of a billing run
PARTICIPANTTYPE varchar(10) varchar(10) Participant type Generator/Customer
PREVAMOUNT numeric(16, 6) numeric(16, 6) Prior account
ADJAMOUNT numeric(16, 6) numeric(16, 6) The total bill figure for the new revised billing run
LASTCHANGED datetime(3) datetime2(0) -
LRS numeric(15, 5) numeric(15, 5) -
PRS numeric(15, 5) numeric(15, 5) -
OFS numeric(15, 5) numeric(15, 5) -
IRN numeric(15, 5) numeric(15, 5) Interest rate applying to the new amount
IRP numeric(15, 5) numeric(15, 5) Interest rate applying to the principal amount
INTERESTAMOUNT numeric(15, 5) numeric(15, 5) The total interest payable for this adjustment

Official MMS data model indexes

Index name Index type Index columns (in order)
BILLADJUSTMENTS_LCX nonclustered LASTCHANGED
BILLADJUSTMENTS_NDX2 nonclustered PARTICIPANTID
BILLADJUSTMENTS_PK clustered, unique, primary key CONTRACTYEAR, WEEKNO, ADJCONTRACTYEAR, ADJWEEKNO, ADJBILLRUNNO, PARTICIPANTID

GR-MMS data model indexes

Index name Index type Index columns (in order)
IX_BILLADJUSTMENTS_LASTCHANGED nonclustered LASTCHANGED
IX_BILLADJUSTMENTS_PARTICIPANTID nonclustered PARTICIPANTID
PK_BILLADJUSTMENTS clustered, unique, primary key CONTRACTYEAR, WEEKNO, ADJCONTRACTYEAR, ADJWEEKNO, ADJBILLRUNNO, PARTICIPANTID

Historical-MMS data model indexes

Index name Index type Index columns (in order)
BILLADJUSTMENTS_LCX nonclustered LASTCHANGED
BILLADJUSTMENTS_NDX2 nonclustered PARTICIPANTID
BILLADJUSTMENTS_PK clustered, unique, primary key CONTRACTYEAR, WEEKNO, ADJCONTRACTYEAR, ADJWEEKNO, ADJBILLRUNNO, PARTICIPANTID