CONTRACTREACTIVEPOWER
CONTRACTREACTIVEPOWER shows Reactive Power contract details used in the settlement and dispatch of this service. 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 |
| SYNCCOMPENSATION |
varchar(1) |
varchar(1) |
Sync Compensation Flag - Y for SYNCCOMP |
| MVARAPRICE |
numeric(10, 2) |
numeric(10, 2) |
Availability price per MVAr of RP absorption capability |
| MVAREPRICE |
numeric(10, 2) |
numeric(10, 2) |
Enabling price |
| MVARGPRICE |
numeric(10, 2) |
numeric(10, 2) |
Availability price per MVAr of RP generation capability |
| CCPRICE |
numeric(10, 2) |
numeric(10, 2) |
Compensation Cap |
| MTA |
numeric(10, 2) |
numeric(10, 2) |
Reactive Power Absorption Capability (MVAr) |
| MTG |
numeric(10, 2) |
numeric(10, 2) |
Reactive Power Generation Capability (MVAr) |
| MMCA |
numeric(10, 2) |
numeric(10, 2) |
Minimum Capability for MVAr Absorption required by Code |
| MMCG |
numeric(10, 2) |
numeric(10, 2) |
Minimum Capability for MVAr Generation required by Code |
| EU |
numeric(10, 2) |
numeric(10, 2) |
Estimated Power consumption of unit when operating on SYNCCOMP |
| PP |
numeric(10, 2) |
numeric(10, 2) |
Estimated Price for supply |
| BS |
numeric(10, 2) |
numeric(10, 2) |
Block Size of Unit |
| 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 |
| AVAILABILITY_MWH_THRESHOLD |
numeric(18, 8) |
numeric(18, 8) |
The MWh the unit must produce in a trading interval to be eligible for an excess-to-gen availability payment |
| MVAR_THRESHOLD |
numeric(18, 8) |
numeric(18, 8) |
The threshold value for MegaVar (MVAr) to check whether the service is fully available. |
| REBATE_CAP |
numeric(18, 8) |
numeric(18, 8) |
The maximum capped amount for the rebate payment. |
| REBATE_AMOUNT_PER_MVAR |
numeric(18, 8) |
numeric(18, 8) |
The per MVAR rebate amount used to calculate the rebate payment. |
| ISREBATEAPPLICABLE |
numeric(1, 0) |
tinyint |
Used to check whether the contract is eligible for rebate. For new NSCAS contracts to apply new payment methodology this flag is 1. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| CONTRACTREACTIVEPOWE_NDX2 |
nonclustered |
PARTICIPANTID |
| CONTRACTREACTIVEPOWER_LCX |
nonclustered |
LASTCHANGED |
| CONTRACTREACTIVEPOWER_PK |
clustered, unique, primary key |
CONTRACTID, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_CONTRACTREACTIVEPOWER_LASTCHANGED |
nonclustered |
LASTCHANGED |
| IX_CONTRACTREACTIVEPOWER_PARTICIPANTID |
nonclustered |
PARTICIPANTID |
| PK_CONTRACTREACTIVEPOWER |
clustered, unique, primary key |
CONTRACTID, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| CONTRACTREACTIVEPOWE_NDX2 |
nonclustered |
PARTICIPANTID |
| CONTRACTREACTIVEPOWER_LCX |
nonclustered |
LASTCHANGED |
| CONTRACTREACTIVEPOWER_PK |
clustered, unique, primary key |
CONTRACTID, VERSIONNO |