SET_NMAS_RECOVERY_RBF
SET_NMAS_RECOVERY_RBF publishes the RBF for NSCAS non testing payments on a half hourly basis. This Table may also be used for NSCAS and Type 1 transitional services procured by AEMO under the ISF framework during 2025 and prior to the implementation of all system changes. During this time descriptions in these tables may not be correct.
Package
SETTLEMENT_DATA
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Settlement Date |
| VERSIONNO |
numeric(3, 0) |
smallint |
Settlement run number |
| PERIODID |
numeric(3, 0) |
smallint |
Settlements Trading Interval. |
| 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 |
| PAYMENTTYPE |
varchar(20) |
varchar(20) |
The type of payment being recovered. Valid values are: - AVAILABILITY - ENABLEMENT - COMPENSATION |
| 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 Payment Amount to recover from all benefitting regions |
| RECOVERY_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Total recovery amount for the period for the 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) |
| PK_SET_NMAS_RECOVERY_RBF |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PERIODID, SERVICE, CONTRACTID, PAYMENTTYPE, REGIONID |
| SET_NMAS_RECOVERY_RBF_LCX |
nonclustered |
LASTCHANGED |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_SET_NMAS_RECOVERY_RBF_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_SET_NMAS_RECOVERY_RBF |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PERIODID, SERVICE, CONTRACTID, PAYMENTTYPE, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_NMAS_RECOVERY_RBF |
nonclustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PERIODID, SERVICE, CONTRACTID, PAYMENTTYPE, REGIONID |
| SET_NMAS_RECOVERY_RBF_CCI |
clustered, columnstore |
n/a |