DISPATCH_CONSTRAINT_FCAS_OCD
FCAS constraint solution from OCD re-run.
Package
DISPATCH
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Dispatch interval that the prices were loaded to |
| INTERVENTION |
numeric(2, 0) |
bit |
Intervention 0/1 |
| CONSTRAINTID |
varchar(20) |
varchar(20) |
ConstraintID/GenconID |
| VERSIONNO |
numeric(3, 0) |
smallint |
VersionNo |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The datetime that the record was last changed |
| RHS |
numeric(15, 5) |
numeric(15, 5) |
RHS from OCD re-run |
| MARGINALVALUE |
numeric(15, 5) |
numeric(15, 5) |
marginalvalue from OCD re-run |
| VIOLATIONDEGREE |
numeric(15, 5) |
numeric(15, 5) |
The violation degree of this constraint in the solution result |
| RUNNO |
numeric(3, 0) |
tinyint |
Dispatch run no; always 1 |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCH_CONSTRNT_FCAS_OCD_PK |
clustered, unique, primary key |
SETTLEMENTDATE, RUNNO, INTERVENTION, CONSTRAINTID, VERSIONNO |
| DISPATCH_CONSTRNT_FCASOCD_LCX |
nonclustered |
LASTCHANGED |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_DISPATCH_CONSTRAINT_FCAS_OCD_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_DISPATCH_CONSTRAINT_FCAS_OCD |
clustered, unique, primary key |
SETTLEMENTDATE, INTERVENTION, RUNNO, CONSTRAINTID, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCH_CONSTRNT_FCAS_OCD_PK |
clustered, unique, primary key |
SETTLEMENTDATE, RUNNO, INTERVENTION, CONSTRAINTID, VERSIONNO |
| DISPATCH_CONSTRNT_FCASOCD_LCX |
nonclustered |
LASTCHANGED |