PEROFFER (Historical table)
PEROFFER contains the half-hourly period details of daily bids and rebids, to be used in conjunction with DAYOFFER. These views provide period varying details such as rate of change up (ROCUP), rate of change down (ROCDOWN) and band quantities (BANDAVAIL from 1 to 10). PEROFFER is a child table of DAYOFFER.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Market date starting at 04:00am |
| DUID |
varchar(10) |
varchar(10) |
Dispatchable Unit identifier |
| OFFERDATE |
datetime(3) |
datetime2(0) |
Offer date made |
| PERIODID |
numeric(3, 0) |
smallint |
Period identifier |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version number of offer |
| SELFDISPATCH |
numeric(12, 6) |
numeric(12, 6) |
Not used |
| MAXAVAIL |
numeric(12, 6) |
numeric(12, 6) |
Maximum plant availability |
| FIXEDLOAD |
numeric(12, 6) |
numeric(12, 6) |
Fixed unit output MW. A value of zero means no fixed load so the unit is dispatched according to bid and market (rather than zero fixed load) |
| ROCUP |
numeric(6, 0) |
smallint |
MW/min for raise |
| ROCDOWN |
numeric(6, 0) |
smallint |
MW/Min for lower |
| BANDAVAIL1 |
numeric(6, 0) |
smallint |
Availability at price band 1 |
| BANDAVAIL2 |
numeric(6, 0) |
smallint |
Availability at price band 2 |
| BANDAVAIL3 |
numeric(6, 0) |
smallint |
Availability at price band 3 |
| BANDAVAIL4 |
numeric(6, 0) |
smallint |
Availability at price band 4 |
| BANDAVAIL5 |
numeric(6, 0) |
smallint |
Availability at price band 5 |
| BANDAVAIL6 |
numeric(6, 0) |
smallint |
Availability at price band 6 |
| BANDAVAIL7 |
numeric(6, 0) |
smallint |
Availability at price band 7 |
| BANDAVAIL8 |
numeric(6, 0) |
smallint |
Availability at price band 8 |
| BANDAVAIL9 |
numeric(6, 0) |
smallint |
Availability at price band 9 |
| BANDAVAIL10 |
numeric(6, 0) |
smallint |
Availability at price band 10 |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| PASAAVAILABILITY |
numeric(12, 0) |
smallint |
The physical plant capability including any capability potentially available within 24 hours. |
| MR_CAPACITY |
numeric(6, 0) |
smallint |
Mandatory Restriction Offer amount |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PEROFFER_LCX |
nonclustered |
LASTCHANGED |
| PEROFFER_NDX2 |
nonclustered |
DUID, LASTCHANGED |
| PEROFFER_PK |
clustered, unique, primary key |
SETTLEMENTDATE, DUID, OFFERDATE, VERSIONNO, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_PEROFFER_DUID_LASTCHANGED |
nonclustered |
DUID, LASTCHANGED |
| IX_PEROFFER_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_PEROFFER |
clustered, unique, primary key |
SETTLEMENTDATE, DUID, OFFERDATE, VERSIONNO, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PEROFFER_LCX |
nonclustered |
LASTCHANGED |
| PEROFFER_NDX2 |
nonclustered |
DUID, LASTCHANGED |
| PEROFFER_PK |
clustered, unique, primary key |
SETTLEMENTDATE, DUID, OFFERDATE, VERSIONNO, PERIODID |