OFFERLSHEDDATA
OFFERLSHEDDATA shows reoffers of load shed including available load shed quantity. 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 identifier |
| EFFECTIVEDATE |
datetime(3) |
datetime2(0) |
Market date of reoffer |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version No of reoffer |
| PERIODID |
numeric(3, 0) |
smallint |
Market day trading interval number |
| AVAILABLELOAD |
numeric(4, 0) |
smallint |
Available load |
| AUTHORISEDDATE |
datetime(3) |
datetime2(0) |
Authorised date |
| AUTHORISEDBY |
varchar(15) |
varchar(15) |
Authorised by |
| FILENAME |
varchar(40) |
varchar(40) |
Name of reoffer 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) |
| OFFERLSHEDDATA_LCX |
nonclustered |
LASTCHANGED |
| OFFERLSHEDDATA_PK |
clustered, unique, primary key |
CONTRACTID, EFFECTIVEDATE, VERSIONNO, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_OFFERLSHEDDATA_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_OFFERLSHEDDATA |
clustered, unique, primary key |
CONTRACTID, EFFECTIVEDATE, VERSIONNO, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| OFFERLSHEDDATA_LCX |
nonclustered |
LASTCHANGED |
| OFFERLSHEDDATA_PK |
clustered, unique, primary key |
CONTRACTID, EFFECTIVEDATE, VERSIONNO, PERIODID |