| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
Date processing of the run begins |
| RUN_NO |
numeric(3, 0) |
smallint |
Unique run id. Generated from the solution file caseid |
| ENERGYBLOCK |
datetime(3) |
datetime2(0) |
Sunday at start of the week for this solutions energy block. Generated from the solution file energy block |
| DAY |
datetime(3) |
datetime2(0) |
Day this solution is for. Generated from the solution file periodid |
| LDCBLOCK |
numeric(3, 0) |
smallint |
LDC block this solution is for. Generated from the solution file periodid |
| REGIONID |
varchar(10) |
varchar(10) |
The unique region identifier |
| RUNTYPE |
varchar(20) |
varchar(20) |
Type of run. Values are RELIABILITY_LRC and OUTAGE_LRC |
| DEMAND10 |
numeric(12, 2) |
numeric(12, 2) |
Input value for 10% probability demand |
| RESERVEREQ |
numeric(12, 2) |
numeric(12, 2) |
Not used from 21/05/2010. Prior to 21/05/2010: Input reserve requirement |
| CAPACITYREQ |
numeric(12, 2) |
numeric(12, 2) |
Not used from 21/05/2010. Prior to 21/05/2010: CA Demand + Reserve Requirement |
| ENERGYREQDEMAND10 |
numeric(12, 2) |
numeric(12, 2) |
Sum of: (Region Period Demand - given Demand10)/PeriodLength(sum by Energy Block, entered in first period of energy block, GWh) |
| UNCONSTRAINEDCAPACITY |
numeric(12, 0) |
int |
Region energy unconstrained MW capacity subject to network security constraints |
| CONSTRAINEDCAPACITY |
numeric(12, 0) |
int |
Region energy constrained MW capacity subject to energy and network security constraints |
| NETINTERCHANGEUNDERSCARCITY |
numeric(12, 2) |
numeric(12, 2) |
Calculated in capacity adequacy evaluation: Export if > 0, Import if < 0. |
| SURPLUSCAPACITY |
numeric(12, 2) |
numeric(12, 2) |
Regional surplus capacity MW, +/- values indicate surplus/deficit capacity |
| SURPLUSRESERVE |
numeric(12, 2) |
numeric(12, 2) |
Not used from 21/05/2010. Prior to 21/05/2010: Regional reserve surplus. +/-0 values indicate surplus/deficit reserve |
| RESERVECONDITION |
numeric(1, 0) |
tinyint |
The regional reserve condition: 0 = Adequate, 1 = LRC |
| MAXSURPLUSRESERVE |
numeric(12, 2) |
numeric(12, 2) |
The Maximum generation (MW) that could be withdrawn from this region without incurring a Low Reserve Condition. |
| MAXSPARECAPACITY |
numeric(12, 2) |
numeric(12, 2) |
The Maximum Spare Capacity evaluated for this region in this period. Calculated for each region in turn |
| LORCONDITION |
numeric(1, 0) |
tinyint |
The LOR Condition determined from the Maximum Spare Capacity value: 0 = no condition, 1 = LOR1 condition, 2 = LOR2 condition, 3 = LOR3 condition |
| AGGREGATECAPACITYAVAILABLE |
numeric(12, 2) |
numeric(12, 2) |
Sum of MAXAVAIL quantities offered by all Scheduled Generators in a given Region for a given PERIODID. |
| AGGREGATESCHEDULEDLOAD |
numeric(12, 2) |
numeric(12, 2) |
Sum of MAXAVAIL quantities bid by of all Scheduled Loads in a given Region for a given PERIODID. |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Date the solution was loaded |
| AGGREGATEPASAAVAILABILITY |
numeric(12, 0) |
int |
Sum of PASAAVAILABILITY quantities offered by all Scheduled Generators in a given Region for a given PERIODID. |
| CALCULATEDLOR1LEVEL |
numeric(16, 6) |
numeric(16, 6) |
Region Reserve Level for LOR1 used. Can be static value or calculated value if an interconnector is a credible contingency |
| CALCULATEDLOR2LEVEL |
numeric(16, 6) |
numeric(16, 6) |
Region Reserve Level for LOR2 used. Can be static value or calculated value if an interconnector is a credible contingency |
| MSRNETINTERCHANGEUNDERSCARCITY |
numeric(12, 2) |
numeric(12, 2) |
Net interconnector flow from the region for this interval from the MSR assessment |
| LORNETINTERCHANGEUNDERSCARCITY |
numeric(12, 2) |
numeric(12, 2) |
Net interconnector flow from the region for this interval from the LOR assessment |
| TOTALINTERMITTENTGENERATION |
numeric(15, 5) |
numeric(15, 5) |
Allowance made for non-scheduled generation in the demand forecast (MW). |
| DEMAND50 |
numeric(12, 2) |
numeric(12, 2) |
Input value for 50% probability demand |
| DEMAND_AND_NONSCHEDGEN |
numeric(15, 5) |
numeric(15, 5) |
Sum of Cleared Scheduled generation, imported generation (at the region boundary) and allowances made for non-scheduled generation (MW). |
| UIGF |
numeric(12, 2) |
numeric(12, 2) |
Regional aggregated Unconstrained Intermittent Generation Forecast of Semi-scheduled generation (MW). |
| SEMISCHEDULEDCAPACITY |
numeric(12, 2) |
numeric(12, 2) |
Aggregate Regional UIGF availability |
| LOR_SEMISCHEDULEDCAPACITY |
numeric(12, 2) |
numeric(12, 2) |
Aggregate Regional UIGF availability for LOR |
| DEFICITRESERVE |
numeric(16, 6) |
numeric(16, 6) |
Regional reserve deficit (MW) |
| MAXUSEFULRESPONSE |
numeric(12, 2) |
numeric(12, 2) |
The Maximum market response (MW) needed for the region to eliminate a Low Reserve Condition (LRC) |
| MURNETINTERCHANGEUNDERSCARCITY |
numeric(12, 2) |
numeric(12, 2) |
Net interconnector flow from the region for this interval from the MRR assessment |
| LORTOTALINTERMITTENTGENERATION |
numeric(15, 5) |
numeric(15, 5) |
Allowance made for non-scheduled generation in the LOR assessment |
| ENERGYREQDEMAND50 |
numeric(12, 2) |
numeric(12, 2) |
Sum of: (Region Period Demand - given Demand50)/PeriodLength (sum by Energy Block, entered in first period of energy block, GWh) |