| PREDISPATCHSEQNO |
varchar(20) |
int  |
Unique identifier of predispatch run in the form YYYYMMDDPP with 01 at 04:30 |
| INTERCONNECTORID |
varchar(10) |
varchar(10) |
Unique interconnector identifier |
| INTERVENTION |
numeric(2, 0) |
bit |
Flag to indicate if this result set was sourced from the pricing run (INTERVENTION=0) or the physical run (INTERVENTION=1). In the event that there is not intervention in the market, both pricing and physical runs correspond to INTERVENTION=0 |
| DATETIME |
datetime(3) |
datetime2(0) |
Period date and time |
| INTERVENTION_ACTIVE |
numeric(1, 0) |
tinyint |
Flag to indicate if the sensitivity run contains an active intervention constraint: 0 = No, 1 = Yes |
| MWFLOW1 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 1 |
| MWFLOW2 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 2 |
| MWFLOW3 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 3 |
| MWFLOW4 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 4 |
| MWFLOW5 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 5 |
| MWFLOW6 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 6 |
| MWFLOW7 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 7 |
| MWFLOW8 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 8 |
| MWFLOW9 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 9 |
| MWFLOW10 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 10 |
| MWFLOW11 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 11 |
| MWFLOW12 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 12 |
| MWFLOW13 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 13 |
| MWFLOW14 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 14 |
| MWFLOW15 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 15 |
| MWFLOW16 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 16 |
| MWFLOW17 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 17 |
| MWFLOW18 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 18 |
| MWFLOW19 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 19 |
| MWFLOW20 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 20 |
| MWFLOW21 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 21 |
| MWFLOW22 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 22 |
| MWFLOW23 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 23 |
| MWFLOW24 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 24 |
| MWFLOW25 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 25 |
| MWFLOW26 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 26 |
| MWFLOW27 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 27 |
| MWFLOW28 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 28 |
| MWFLOW29 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 29 |
| MWFLOW30 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 30 |
| MWFLOW31 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 31 |
| MWFLOW32 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 32 |
| MWFLOW33 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 33 |
| MWFLOW34 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 34 |
| MWFLOW35 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 35 |
| MWFLOW36 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 36 |
| MWFLOW37 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 37 |
| MWFLOW38 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 38 |
| MWFLOW39 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 39 |
| MWFLOW40 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 40 |
| MWFLOW41 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 41 |
| MWFLOW42 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 42 |
| MWFLOW43 |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
MW flow for given Interconnector for scenario 43 |
| LASTCHANGED |
datetime(3) |
datetime2(0) (not nullable) |
Last date and time record changed |
| RUNNO |
numeric(3, 0) |
- |
- |
| PERIODID |
varchar(20) |
- |
- |