SET_NMAS_RECOVERY
SET_NMAS_RECOVERY sets out the NSCAS recovery data for payments other than testing 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
Private
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. |
| PARTICIPANTID |
varchar(20) |
varchar(20) |
The Participant from whom the amount is recovered |
| SERVICE |
varchar(10) |
varchar(10) |
The type of NSCAS service. Current value values are: - REACTIVE - LOADSHED - RESTART |
| 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 |
| PARTICIPANT_ENERGY |
numeric(18, 8) |
numeric(18, 8) |
The Participant energy in MWh for the period. NULL Value for Settlement Dates post IESS rule effective date. |
| REGION_ENERGY |
numeric(18, 8) |
numeric(18, 8) |
The RegionId energy in MWh for the period. NULL Value for Settlement Dates post IESS rule effective date. |
| RECOVERY_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Total recovery amount for the period for the PARTICIPANTID and REGIONID. For Settlement dates prior to the IESS rule effective date Sum of RECOVERY_AMOUNT_CUSTOMER + RECOVERY_AMOUNT_GENERATOR and Post IESS it is sum of RECOVERYAMOUNT_ACE + RECOVERYAMOUNT_ASOE. |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The Last Updated date and time |
| PARTICIPANT_GENERATION |
numeric(18, 8) |
numeric(18, 8) |
Participant Generator Energy in the benefitting region. NULL Value for Settlement Dates post IESS rule effective date. |
| REGION_GENERATION |
numeric(18, 8) |
numeric(18, 8) |
The generator energy in the benefitting region. NULL Value for Settlement Dates post IESS rule effective date. |
| RECOVERY_AMOUNT_CUSTOMER |
numeric(18, 8) |
numeric(18, 8) |
The recovery amount allocated to customers. NULL Value for Settlement Dates post IESS rule effective date. |
| RECOVERY_AMOUNT_GENERATOR |
numeric(18, 8) |
numeric(18, 8) |
The recovery amount allocated to generators. NULL Value for Settlement Dates post IESS rule effective date. |
| PARTICIPANT_ACE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The ACE MWh value for the Participant used in the Recovery Amount Calculation. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| PARTICIPANT_ASOE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The ASOE MWh value for the Participant used in the Recovery Amount Calculation. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| RECOVERYAMOUNT_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Recovery dollar amount for the Participant for the NMAS Contract Id calculated using the ACE MWh values for eligible services. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| RECOVERYAMOUNT_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The Recovery dollar amount for the Participant for the NMAS Contract Id calculated using the ASOE_MWh values for eligible services. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| REGION_ACE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Regional ACE MWh value used in the Recovery Amount Calculation. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| REGION_ASOE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Regional ASOE MWh value used in the Recovery Amount Calculation. NULL Value for Settlement Dates prior to the IESS rule effective date. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_NMAS_RECOVERY |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PERIODID, PARTICIPANTID, SERVICE, CONTRACTID, PAYMENTTYPE, REGIONID |
| SET_NMAS_RECOVERY_LCX |
nonclustered |
LASTCHANGED |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_SET_NMAS_RECOVERY_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_SET_NMAS_RECOVERY |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PERIODID, PARTICIPANTID, SERVICE, CONTRACTID, PAYMENTTYPE, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_NMAS_RECOVERY |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PERIODID, PARTICIPANTID, SERVICE, CONTRACTID, PAYMENTTYPE, REGIONID |
| SET_NMAS_RECOVERY_LCX |
nonclustered |
LASTCHANGED |