SETLSHEDPAYMENT
SETLSHEDPAYMENT shows specific payment details for load shed services by period. 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 No. |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Participant Identifier |
| CONTRACTID |
varchar(10) |
varchar(10) |
AS Contract Identifier |
| PERIODID |
numeric(3, 0) |
smallint |
Settlements Trading Interval. |
| DUID |
varchar(10) |
varchar(10) |
Dispatchable Unit Identifier |
| REGIONID |
varchar(10) |
varchar(10) |
Region Identifier |
| TLF |
numeric(7, 5) |
numeric(7, 5) |
Transmission Loss Factor |
| RRP |
numeric(15, 5) |
numeric(15, 5) |
Regional Reference Price |
| LSEPRICE |
numeric(15, 5) |
numeric(15, 5) |
Load Shed Enabling Price |
| MCPPRICE |
numeric(15, 5) |
numeric(15, 5) |
Minimum Compensation Price |
| LSCR |
numeric(4, 0) |
smallint |
Load Shed Control Range |
| LSEPAYMENT |
numeric(15, 5) |
numeric(15, 5) |
Load Shed Enabling Payment |
| CCPAYMENT |
numeric(15, 5) |
numeric(15, 5) |
Compensation Payment |
| CONSTRAINEDMW |
numeric(15, 5) |
numeric(15, 5) |
Cleared MW of unit at time of load shed usage |
| UNCONSTRAINEDMW |
numeric(15, 5) |
numeric(15, 5) |
Unconstrained MW of unit at time of load shed usage |
| ALS |
numeric(15, 5) |
numeric(15, 5) |
Amount of load shed |
| INITIALDEMAND |
numeric(15, 5) |
numeric(15, 5) |
Initial demand of unit at time of load shed usage |
| FINALDEMAND |
numeric(15, 5) |
numeric(15, 5) |
Final demand of unit at time of load shed usage |
| CONTRACTVERSIONNO |
numeric(3, 0) |
smallint |
AS Contract Version No. |
| OFFERDATE |
datetime(3) |
datetime2(0) |
Re-offer offer date |
| OFFERVERSIONNO |
numeric(3, 0) |
smallint |
Re-Offer Version No. |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| AVAILABILITYPAYMENT |
numeric(16, 6) |
numeric(16, 6) |
Payment amount for the Load Shed Availability service |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SETLSHEDPAYMENT_LCX |
nonclustered |
LASTCHANGED |
| SETLSHEDPAYMENT_NDX2 |
nonclustered |
PARTICIPANTID |
| SETLSHEDPAYMENT_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, CONTRACTID, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_SETLSHEDPAYMENT_LASTCHANGED |
nonclustered |
LASTCHANGED |
| IX_SETLSHEDPAYMENT_PARTICIPANTID |
nonclustered |
PARTICIPANTID |
| PK_SETLSHEDPAYMENT |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, CONTRACTID, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SETLSHEDPAYMENT_LCX |
nonclustered |
LASTCHANGED |
| SETLSHEDPAYMENT_NDX2 |
nonclustered |
PARTICIPANTID |
| SETLSHEDPAYMENT_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, CONTRACTID, PERIODID |