PDPASA_FNM_CONSTRAINTSOLUTION
PDPASA_FNM_CONSTRAINTSOLUTION shows manual or thermal constraint (created by PASA), including marginal value, violation degree, LHS and RHS.
Package
PDPASA
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run |
| RUNTYPE |
varchar(20) |
varchar(20) |
Run Type (BASE, RELIABILITY, WARNING) |
| INTERVAL_DATETIME |
datetime(3) |
datetime2(0) |
End date time of the interval |
| CONSTRAINTID |
varchar(100) |
varchar(100) |
Constraint identifier, either manual constraint (synonymous with GenConID) or thermal constraint created by PASA with format ''BASE_'' or ''_ |
| MARGINALVALUE |
numeric(20, 5) |
numeric(20, 5) |
Constraint Marginal Value ($/MW) |
| VIOLATIONDEGREE |
numeric(15, 5) |
numeric(15, 5) |
Constraint Violation Degree (MW) |
| LHS |
numeric(15, 5) |
numeric(15, 5) |
Constraint LHS (MW) |
| RHS |
numeric(15, 5) |
numeric(15, 5) |
Constraint RHS (MW) |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Date time this record was created |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PDPASA_FNM_CONSTRAINTS_PK |
clustered, unique, primary key |
RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, CONSTRAINTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PDPASA_FNM_CONSTRAINTS_PK |
clustered, unique, primary key |
RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, CONSTRAINTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PDPASA_FNM_CONSTRAINTS_PK |
clustered, unique, primary key |
RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, CONSTRAINTID |