OFFERRPOWERDATA

OFFERRPOWERDATA shows reoffers of reactive power capability and settlement measurements. 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

ASOFFER

Visibility

Private

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
CONTRACTID	varchar(10)	varchar(10)	Contract Version No.
EFFECTIVEDATE	datetime(3)	datetime2(0)	Contract Version No.
VERSIONNO	numeric(3, 0)	smallint	Version No. of Re-Offer
PERIODID	numeric(3, 0)	smallint	Market trading interval
AVAILABILITY	numeric(3, 0)	smallint	Availability of service
MTA	numeric(6, 0)	int	Reactive Power Absorption Capability (MVar)
MTG	numeric(6, 0)	int	Reactive Power Generation Capability (MVar)
AUTHORISEDDATE	datetime(3)	datetime2(0)	Date Contract was Authorised
AUTHORISEDBY	varchar(15)	varchar(15)	User Name
FILENAME	varchar(40)	varchar(40)	File name of Re-Offer file
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
OFFERRPOWERDATA_LCX	nonclustered	LASTCHANGED
OFFERRPOWERDATA_NDX2	nonclustered	CONTRACTID
OFFERRPOWERDATA_PK	clustered, unique, primary key	CONTRACTID, EFFECTIVEDATE, VERSIONNO, PERIODID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_OFFERRPOWERDATA_CONTRACTID	nonclustered	CONTRACTID
IX_OFFERRPOWERDATA_LASTCHANGED	nonclustered	LASTCHANGED
PK_OFFERRPOWERDATA	clustered, unique, primary key	CONTRACTID, EFFECTIVEDATE, VERSIONNO, PERIODID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
OFFERRPOWERDATA_LCX	nonclustered	LASTCHANGED
OFFERRPOWERDATA_NDX2	nonclustered	CONTRACTID
OFFERRPOWERDATA_PK	clustered, unique, primary key	CONTRACTID, EFFECTIVEDATE, VERSIONNO, PERIODID