MARKET_SUSPEND_SCHEDULE
Trading prices that will apply in the event of a market suspension event updated weekly.
Package
FORCE_MAJEURE
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| EFFECTIVEDATE |
datetime(3)  |
datetime2(0) |
Calendar date from when this record set is effective |
| DAY_TYPE |
varchar(20) |
varchar(20) |
Distinguishes which record set to apply - at time of writing this was Business or Non-business day but may change in the future depending on outcome of consultation |
| REGIONID |
varchar(20) |
varchar(20) |
Region affected. |
| PERIODID |
numeric(3, 0) |
smallint |
48 intervals for a day, midnight base (equates to 00:30 - 00:00) |
| ENERGY_RRP |
numeric(15, 5) |
numeric(15, 5) |
Energy Price applied for this period for this Day Type |
| R6_RRP |
numeric(15, 5) |
numeric(15, 5) |
Raise 6Sec contingency Price applied for this period for this Day Type |
| R60_RRP |
numeric(15, 5) |
numeric(15, 5) |
Raise 60Sec contingency Price applied for this period for this Day Type |
| R5_RRP |
numeric(15, 5) |
numeric(15, 5) |
Raise 5Min contingency Price applied for this period for this Day Type |
| RREG_RRP |
numeric(15, 5) |
numeric(15, 5) |
Raise Regulation contingency Price applied for this period for this Day Type |
| L6_RRP |
numeric(15, 5) |
numeric(15, 5) |
Lower 6Sec contingency Price applied for this period for this Day Type |
| L60_RRP |
numeric(15, 5) |
numeric(15, 5) |
Lower 60Sec contingency Price applied for this period for this Day Type |
| L5_RRP |
numeric(15, 5) |
numeric(15, 5) |
Lower 5Min contingency Price applied for this period for this Day Type |
| LREG_RRP |
numeric(15, 5) |
numeric(15, 5) |
Lower Regulation Price applied for this period for this Day Type |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| L1_RRP |
numeric(15, 5) |
numeric(15, 5) |
Lower 1Sec contingency Price applied for this period for this Day Type |
| R1_RRP |
numeric(15, 5) |
numeric(15, 5) |
Raise 1Sec contingency Price applied for this period for this Day Type |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MARKET_SUSPEND_SCHEDULE_PK |
clustered, unique, primary key |
EFFECTIVEDATE, DAY_TYPE, REGIONID, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MARKET_SUSPEND_SCHEDULE |
clustered, unique, primary key |
EFFECTIVEDATE, DAY_TYPE, REGIONID, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MARKET_SUSPEND_SCHEDULE_PK |
clustered, unique, primary key |
EFFECTIVEDATE, DAY_TYPE, REGIONID, PERIODID |