BILLING_NMAS_TST_RECVRY_RBF

BILLING_NMAS_TEST_RECVRY_RBF sets out the NSCAS / SRAS Testing Payment recovery data for the posted billing week.

Package

BILLING_RUN

Visibility

Public

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
CONTRACTYEAR	numeric(4, 0)	smallint	AEMO Contract Year number starting in week containing 1 January
WEEKNO	numeric(3, 0)	smallint	Week no within the contract year. Week no 1 is the week containing 1 January
BILLRUNNO	numeric(3, 0)	smallint	The current Billing RunNo for the week
SERVICE	varchar(10)	varchar(10)	The type of NSCAS service. Current value values are: - REACTIVE - LOADSHED
CONTRACTID	varchar(10)	varchar(10)	The NMAS Contract Id
REGIONID	varchar(10)	varchar(10)	The region from where the amount is recovered
RBF	numeric(18, 8)	numeric(18, 8)	The Benefitting Factor for the RegionId
PAYMENT_AMOUNT	numeric(18, 8)	numeric(18, 8)	The total Testing Payment Amount to recover from all benefitting regions
RECOVERY_AMOUNT	numeric(18, 8)	numeric(18, 8)	The Testing Payment amount to recover from RegionId
LASTCHANGED	datetime(3)	datetime2(0)	The Last Updated date and time

Official MMS data model indexes

Index name	Index type	Index columns (in order)
BILLING_NMAS_TST_RCVRY_RBF_LCX	nonclustered	LASTCHANGED
PK_BILLING_NMAS_TST_RECVRY_RBF	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, SERVICE, CONTRACTID, REGIONID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_BILLING_NMAS_TST_RECVRY_RBF_LASTCHANGED	nonclustered	LASTCHANGED
PK_BILLING_NMAS_TST_RECVRY_RBF	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, SERVICE, CONTRACTID, REGIONID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
BILLING_NMAS_TST_RCVRY_RBF_LCX	nonclustered	LASTCHANGED
PK_BILLING_NMAS_TST_RECVRY_RBF	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, SERVICE, CONTRACTID, REGIONID