BILLINGFEES

BILLINGFEES presents pool fees applied to the statement, per billing run.

Package

BILLING_RUN

Visibility

Private

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	Week no within the contract year. Week no 1 is the week containing 1st January
BILLRUNNO	numeric(3, 0)	smallint	Unique run no within a given contract year and week no
PARTICIPANTID	varchar(10)	varchar(10)	Unique participant identifier
MARKETFEEID	varchar(10)	varchar(10)	Market fee identifier
PARTICIPANTCATEGORYID	varchar(10)	varchar(10)	The participant category pertaining to the market fee recovery. Corresponds to the PARTICIPANTCATEGORYID column of the SETMARKETFEES table.
RATE	numeric(15, 5)	numeric(15, 5)	Market fee rate
ENERGY	numeric(16, 6)	numeric(16, 6)	Energy, in MWh
VALUE	numeric(15, 5)	numeric(15, 5)	Fee in $
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
BILLINGFEES_LCX	nonclustered	LASTCHANGED
BILLINGFEES_NDX2	nonclustered	PARTICIPANTID
BILLINGFEES_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, MARKETFEEID, PARTICIPANTCATEGORYID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_BILLINGFEES_LASTCHANGED	nonclustered	LASTCHANGED
IX_BILLINGFEES_PARTICIPANTID	nonclustered	PARTICIPANTID
PK_BILLINGFEES	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, MARKETFEEID, PARTICIPANTCATEGORYID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
BILLINGFEES_LCX	nonclustered	LASTCHANGED
BILLINGFEES_NDX2	nonclustered	PARTICIPANTID
BILLINGFEES_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, MARKETFEEID, PARTICIPANTCATEGORYID