CONTRACTLOADSHED
CONTRACTLOADSHED shows Governor contract details used in the settlement and dispatch of this service. Note: services are dispatched as 6 and 60 raise Frequency Control Ancillary Services (FCAS). Mandatory requirements and breakpoint details are not used for load shed. 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
ANCILLARY_SERVICES
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTID |
varchar(10)  |
varchar(10) |
Contract Identifier |
| VERSIONNO |
numeric(3, 0) |
smallint |
Contract Version No. |
| STARTDATE |
datetime(3) |
datetime2(0) |
Starting Date of Contract |
| ENDDATE |
datetime(3) |
datetime2(0) |
Termination Date of Contract |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Unique participant identifier |
| DUID |
varchar(10) |
varchar(10) |
Dispatchable Unit ID |
| LSEPRICE |
numeric(6, 2) |
numeric(6, 2) |
The load shed enabling price for this contract |
| MCPPRICE |
numeric(12, 2) |
numeric(12, 2) |
Minimum Compensation price |
| TENDEREDPRICE |
numeric(6, 2) |
numeric(6, 2) |
Price Tendered for Compensation per Trading interval - Not used since 13/12/1998 |
| LSCR |
numeric(6, 2) |
numeric(6, 2) |
Load Shed Control Range |
| ILSCALINGFACTOR |
numeric(15, 5) |
numeric(15, 5) |
SPD scaling factor for load shed vs dispatched, (1 = dispatched) |
| LOWER60SECBREAKPOINT |
numeric(9, 6) |
numeric(9, 6) |
Not used |
| LOWER60SECMAX |
numeric(9, 6) |
numeric(9, 6) |
Not used |
| LOWER6SECBREAKPOINT |
numeric(9, 6) |
numeric(9, 6) |
Not used |
| LOWER6SECMAX |
numeric(9, 6) |
numeric(9, 6) |
Not used |
| RAISE60SECBREAKPOINT |
numeric(9, 6) |
numeric(9, 6) |
Not used |
| RAISE60SECCAPACITY |
numeric(9, 6) |
numeric(9, 6) |
Not used |
| RAISE60SECMAX |
numeric(9, 6) |
numeric(9, 6) |
Maximum 60 second raise |
| RAISE6SECBREAKPOINT |
numeric(9, 6) |
numeric(9, 6) |
Not used |
| RAISE6SECCAPACITY |
numeric(9, 6) |
numeric(9, 6) |
Not used |
| RAISE6SECMAX |
numeric(9, 6) |
numeric(9, 6) |
Limit Equation Raise 6 Second Maximum MW |
| PRICE6SECRAISEMANDATORY |
numeric(16, 6) |
numeric(16, 6) |
Not used |
| QUANT6SECRAISEMANDATORY |
numeric(9, 6) |
numeric(9, 6) |
Not used |
| PRICE6SECRAISECONTRACT |
numeric(16, 6) |
numeric(16, 6) |
Contract Price for 6 Second Raise |
| QUANT6SECRAISECONTRACT |
numeric(9, 6) |
numeric(9, 6) |
Contract Quantity for 6 Second Raise |
| PRICE60SECRAISEMANDATORY |
numeric(16, 6) |
numeric(16, 6) |
Not used |
| QUANT60SECRAISEMANDATORY |
numeric(9, 6) |
numeric(9, 6) |
Not used |
| PRICE60SECRAISECONTRACT |
numeric(16, 6) |
numeric(16, 6) |
Not used |
| QUANT60SECRAISECONTRACT |
numeric(9, 6) |
numeric(9, 6) |
Not used |
| PRICE6SECLOWERMANDATORY |
numeric(16, 6) |
numeric(16, 6) |
Not used |
| QUANT6SECLOWERMANDATORY |
numeric(9, 6) |
numeric(9, 6) |
Not used |
| PRICE6SECLOWERCONTRACT |
numeric(16, 6) |
numeric(16, 6) |
Not used |
| QUANT6SECLOWERCONTRACT |
numeric(9, 6) |
numeric(9, 6) |
Not used |
| PRICE60SECLOWERMANDATORY |
numeric(16, 6) |
numeric(16, 6) |
Not used |
| QUANT60SECLOWERMANDATORY |
numeric(9, 6) |
numeric(9, 6) |
Not used |
| PRICE60SECLOWERCONTRACT |
numeric(16, 6) |
numeric(16, 6) |
Not used |
| QUANT60SECLOWERCONTRACT |
numeric(9, 6) |
numeric(9, 6) |
Not used |
| AUTHORISEDBY |
varchar(15) |
varchar(15) |
User Name |
| AUTHORISEDDATE |
datetime(3) |
datetime2(0) |
Date Contract was Authorised |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| DEFAULT_TESTINGPAYMENT_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The NMAS default payment amount |
| SERVICE_START_DATE |
datetime(3) |
datetime2(0) |
The NMAS Testing Service Start Date |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| CONTRACTLOADSHED_LCX |
nonclustered |
LASTCHANGED |
| CONTRACTLOADSHED_NDX2 |
nonclustered |
PARTICIPANTID |
| CONTRACTLOADSHED_PK |
clustered, unique, primary key |
CONTRACTID, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_CONTRACTLOADSHED_LASTCHANGED |
nonclustered |
LASTCHANGED |
| IX_CONTRACTLOADSHED_PARTICIPANTID |
nonclustered |
PARTICIPANTID |
| PK_CONTRACTLOADSHED |
clustered, unique, primary key |
CONTRACTID, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| CONTRACTLOADSHED_LCX |
nonclustered |
LASTCHANGED |
| CONTRACTLOADSHED_NDX2 |
nonclustered |
PARTICIPANTID |
| CONTRACTLOADSHED_PK |
clustered, unique, primary key |
CONTRACTID, VERSIONNO |