OFFERAGCDATA
OFFERAGCDATA shows availability reoffers of Automatic Generation Control.
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 offer |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version no of record |
| PERIODID |
numeric(3, 0) |
smallint |
Market day trading interval number |
| AVAILABILITY |
numeric(4, 0) |
smallint |
Availability flag (0 or 1) |
| UPPERLIMIT |
numeric(4, 0) |
smallint |
Upper control limit. This is used by SPD. |
| LOWERLIMIT |
numeric(4, 0) |
smallint |
Lower control limit MW. This is used by SPD. |
| 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 |
| AGCUP |
numeric(3, 0) |
smallint |
AGC Ramp Rate Up. This is used by SPD. |
| AGCDOWN |
numeric(3, 0) |
smallint |
AGC Ramp Rate Down. This is used by SPD. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| OFFERAGCDATA_LCX |
nonclustered |
LASTCHANGED |
| OFFERAGCDATA_NDX2 |
nonclustered |
CONTRACTID |
| OFFERAGCDATA_PK |
clustered, unique, primary key |
CONTRACTID, EFFECTIVEDATE, VERSIONNO, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_OFFERAGCDATA_CONTRACTID |
nonclustered |
CONTRACTID |
| IX_OFFERAGCDATA_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_OFFERAGCDATA |
clustered, unique, primary key |
CONTRACTID, EFFECTIVEDATE, VERSIONNO, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| OFFERAGCDATA_LCX |
nonclustered |
LASTCHANGED |
| OFFERAGCDATA_NDX2 |
nonclustered |
CONTRACTID |
| OFFERAGCDATA_PK |
clustered, unique, primary key |
CONTRACTID, EFFECTIVEDATE, VERSIONNO, PERIODID |