P5MIN_CASESOLUTION
The five-minute predispatch (P5Min) is a MMS system providing projected dispatch for 12 Dispatch cycles (one hour). The 5-minute Predispatch cycle runs every 5-minutes to produce a dispatch and pricing schedule to a 5-minute resolution covering the next hour, a total of twelve periods. P5MIN_CASESOLUTION shows one record containing results pertaining to the entire solution.
Package
P5MIN
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
Unique Timestamp Identifier for this study |
| STARTINTERVAL_DATETIME |
varchar(20) |
datetime2(0) (not nullable) |
Date and Time of first interval in study |
| TOTALOBJECTIVE |
numeric(27, 10) |
numeric(27, 10) |
The Objective function from the LP |
| NONPHYSICALLOSSES |
numeric(1, 0) |
bit |
Flag to indicate non-physical losses occurred in this study |
| TOTALAREAGENVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Sum of Regional Energy balance violations |
| TOTALINTERCONNECTORVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Sum of Interconnector violations of standing data limits |
| TOTALGENERICVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Sum of Generic Constraint violations |
| TOTALRAMPRATEVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Sum of Unit Ramp Rate violations |
| TOTALUNITMWCAPACITYVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Sum of unit capacity violations |
| TOTAL5MINVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Sum of regional 5 min FCAS violations |
| TOTALREGVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Sum of regional regulation FCAS violations |
| TOTAL6SECVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Sum of regional 6 sec FCAS violations |
| TOTAL60SECVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Sum of regional 60 sec FCAS violations |
| TOTALENERGYCONSTRVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Sum of unit energy constrained violations |
| TOTALENERGYOFFERVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Sum of unit offer violations |
| TOTALASPROFILEVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Sum of unit FCAS profile offer violations |
| TOTALFASTSTARTVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Sum of unit Fast start profile violations |
| LASTCHANGED |
datetime(3) |
datetime2(0) (not nullable) |
Last changed date and time of this record |
| INTERVENTION |
numeric(2, 0) |
bit |
Flag to indicate if this Predispatch case includes an intervention pricing run: 0 = case does not include an intervention pricing run, 1 = case does include an intervention pricing run. This field has a default value of 0 and is not nullable |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| P5MIN_CASESOLUTION_LCX |
nonclustered |
LASTCHANGED |
| P5MIN_CASESOLUTION_PK |
clustered, unique, primary key |
RUN_DATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_P5MIN_CASESOLUTION_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_P5MIN_CASESOLUTION |
clustered, unique, primary key |
RUN_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_P5MIN_CASESOLUTION_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_P5MIN_CASESOLUTION |
clustered, unique, primary key |
RUN_DATETIME |