PEROFFER_D (Historical table)
PEROFFER_D contains the half-hourly period details of daily bids and rebids, to be used in conjunction with DAYOFFER_D. 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_D is a child table of DAYOFFER_D.
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_D_LCX |
nonclustered |
LASTCHANGED |
| PEROFFER_D_NDX2 |
nonclustered |
DUID, LASTCHANGED |
| PEROFFER_D_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_D_DUID_LASTCHANGED |
nonclustered |
DUID, LASTCHANGED |
| IX_PEROFFER_D_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_PEROFFER_D |
clustered, unique, primary key |
SETTLEMENTDATE, DUID, OFFERDATE, VERSIONNO, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PEROFFER_D_LCX |
nonclustered |
LASTCHANGED |
| PEROFFER_D_NDX2 |
nonclustered |
DUID, LASTCHANGED |
| PEROFFER_D_PK |
clustered, unique, primary key |
SETTLEMENTDATE, DUID, OFFERDATE, VERSIONNO, PERIODID |