SETRPOWERPAYMENT
SETRPOWERPAYMENT shows specific payment details for Reactive power 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 |
| EBP |
numeric(15, 5) |
numeric(15, 5) |
Eligible Bid Price |
| RRP |
numeric(15, 5) |
numeric(15, 5) |
Regional Reference Price |
| MVARAPRICE |
numeric(15, 5) |
numeric(15, 5) |
Availability price per MVAr of RP absorption capability |
| MVAREPRICE |
numeric(15, 5) |
numeric(15, 5) |
Enabling Price |
| MVARGPRICE |
numeric(15, 5) |
numeric(15, 5) |
Availability price per MVAr of RP generation capability |
| CCPRICE |
numeric(15, 5) |
numeric(15, 5) |
Compensation Cap |
| SYNCCOMPENSATION |
numeric(1, 0) |
tinyint |
Sync Compensation Flag |
| MTA |
numeric(15, 5) |
numeric(15, 5) |
Reactive Power Absorption Capability (MVAr) |
| MTG |
numeric(15, 5) |
numeric(15, 5) |
Reactive Power Generation Capability (MVAr) |
| BLOCKSIZE |
numeric(4, 0) |
smallint |
Block size of unit |
| AVAFLAG |
numeric(1, 0) |
tinyint |
Availability Flag |
| CLEAREDMW |
numeric(15, 5) |
numeric(15, 5) |
Cleared MW of unit |
| UNCONSTRAINEDMW |
numeric(15, 5) |
numeric(15, 5) |
Unconstrained MW of unit |
| AVAILABILITYPAYMENT |
numeric(15, 5) |
numeric(15, 5) |
Availability Payment |
| ENABLINGPAYMENT |
numeric(15, 5) |
numeric(15, 5) |
Enabling Payment |
| CCPAYMENT |
numeric(15, 5) |
numeric(15, 5) |
Compensation Payment |
| 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_REBATE |
numeric(18, 8) |
numeric(18, 8) |
The rebate amount if MegaVar (MVAr) is below the threshold. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SETRPOWERPAYMENT_LCX |
nonclustered |
LASTCHANGED |
| SETRPOWERPAYMENT_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, CONTRACTID, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_SETRPOWERPAYMENT_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_SETRPOWERPAYMENT |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, CONTRACTID, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SETRPOWERPAYMENT_LCX |
nonclustered |
LASTCHANGED |
| SETRPOWERPAYMENT_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, CONTRACTID, PERIODID |