| PREDISPATCHSEQNO |
varchar(20) |
int  |
Unique identifier of predispatch run in the form YYYYMMDDPP with 01 at 04:30 |
| REGIONID |
varchar(10) |
varchar(10) |
Unique region 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 |
| RRPEEP1 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 1 |
| RRPEEP2 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 2 |
| RRPEEP3 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 3 |
| RRPEEP4 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 4 |
| RRPEEP5 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 5 |
| RRPEEP6 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 6 |
| RRPEEP7 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 7 |
| RRPEEP8 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 8 |
| RRPEEP9 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 9 |
| RRPEEP10 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 10 |
| RRPEEP11 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 11 |
| RRPEEP12 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 12 |
| RRPEEP13 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 13 |
| RRPEEP14 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 14 |
| RRPEEP15 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 15 |
| RRPEEP16 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 16 |
| RRPEEP17 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 17 |
| RRPEEP18 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 18 |
| RRPEEP19 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 19 |
| RRPEEP20 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 20 |
| RRPEEP21 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 21 |
| RRPEEP22 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 22 |
| RRPEEP23 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 23 |
| RRPEEP24 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 24 |
| RRPEEP25 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 25 |
| RRPEEP26 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 26 |
| RRPEEP27 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 27 |
| RRPEEP28 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 28 |
| LASTCHANGED |
datetime(3) |
datetime2(0) (not nullable) |
Last date and time record changed |
| RRPEEP29 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 29 |
| RRPEEP30 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 30 |
| RRPEEP31 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 31 |
| RRPEEP32 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 32 |
| RRPEEP33 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 33 |
| RRPEEP34 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 34 |
| RRPEEP35 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 35 |
| INTERVENTION_ACTIVE |
numeric(1, 0) |
tinyint |
Flag to indicate if the sensitivity run contains an active intervention constraint: 0 = No, 1 = Yes |
| RRPEEP36 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 36 |
| RRPEEP37 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 37 |
| RRPEEP38 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 38 |
| RRPEEP39 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 39 |
| RRPEEP40 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 40 |
| RRPEEP41 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 41 |
| RRPEEP42 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 42 |
| RRPEEP43 |
numeric(15, 5) |
numeric(15, 5) |
Regional Energy Price for scenario 43 |
| RUNNO |
numeric(3, 0) |
- |
- |
| PERIODID |
varchar(20) |
- |
- |