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