MTPASA_CONSTRAINTRESULT
Constraint results for Binding or Violating Constraints.
Package
MTPASA
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
Date processing of the run begins. |
| RUN_NO |
numeric(4, 0) |
smallint |
Unique run id. |
| RUNTYPE |
varchar(20) |
varchar(20) |
Type of run. Always RELIABILITY |
| DEMAND_POE_TYPE |
varchar(20) |
varchar(20) |
Demand POE type used. Value is POE10 |
| DAY |
datetime(3) |
datetime2(0) |
Day this result is for |
| CONSTRAINTID |
varchar(20) |
varchar(20) |
The unique identifier for the constraint. Only binding or violating constraints are reported |
| EFFECTIVEDATE |
datetime(3) |
datetime2(0) |
The effective date of the constraint used |
| VERSIONNO |
numeric(3, 0) |
smallint |
The version of the constraint used |
| PERIODID |
numeric(3, 0) |
smallint |
Half hourly period reported, selected as period of maximum NEM scheduled demand (calculated as maximum of scheduled demands, averaged across iterations and reference years) |
| PROBABILITYOFBINDING |
numeric(8, 5) |
numeric(8, 5) |
Proportion of a constraint binding, across iterations and reference years |
| PROBABILITYOFVIOLATION |
numeric(8, 5) |
numeric(8, 5) |
Proportion of a constraint violating, across iterations and reference years |
| CONSTRAINTVIOLATION90 |
numeric(12, 2) |
numeric(12, 2) |
The 90th percentile violation degree for this constraint, across iterations and reference years (MW) |
| CONSTRAINTVIOLATION50 |
numeric(12, 2) |
numeric(12, 2) |
The 50th percentile violation degree for this constraint, across iterations and reference years (MW) |
| CONSTRAINTVIOLATION10 |
numeric(12, 2) |
numeric(12, 2) |
The 10th percentile violation degree for this constraint, across iterations and reference years (MW) |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_CONSTRAINTRESULT_PK |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO, RUNTYPE, DEMAND_POE_TYPE, DAY, CONSTRAINTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MTPASA_CONSTRAINTRESULT |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO, RUNTYPE, DEMAND_POE_TYPE, DAY, CONSTRAINTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_CONSTRAINTRESULT_PK |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO, RUNTYPE, DEMAND_POE_TYPE, DAY, CONSTRAINTID |