|
Name |
|
|
Comment |
The top-level table identifying a PDPASA case, reporting options applied in the case and summary results |
|
PDPASA_CASESOLUTION is public data. Source PDPASA_CASESOLUTION is updated each PDPASA run (i.e. half-hourly). Volume Rows per day: 48 Mb per month: <1 |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
RUN_DATETIME |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Case identifier by the time the case was run |
|
PASAVERSION |
VARCHAR2(10) |
|
Version of the PASA solver used to solve this case |
|
RESERVECONDITION |
NUMBER(1,0) |
|
Low Reserve Condition (LRC) flag for the case (1 - LRC in the case, 0 - No LRCs in the case) for capacity run |
|
LORCONDITION |
NUMBER(1,0) |
|
Lack of Reserve Condition (LOR) flag for the case indicates the most severe condition in the case (3 = LOR3, 2 = LOR2, 1 = LOR1, 0 = No LOR) |
|
CAPACITYOBJFUNCTION |
NUMBER(12,3) |
|
Objective Function from the Capacity Adequacy run |
|
CAPACITYOPTION |
NUMBER(12,3) |
|
Not populated as of 2005 End of Year Release; was the Probability of Exceedance (POE) demand forecast used for capacity adequacy (LRC) assessment. 0 if no assessment, 1 for 10% POE, 2 for 50% POE, 3 for 90% POE. |
|
MAXSURPLUSRESERVEOPTION |
NUMBER(12,3) |
|
Not populated as of 2005 End of Year Release; was the Probability of Exceedance (POE) demand forecast used for assessment of Maximum surplus Reserve. 0 if no assessment, 1 for 10% POE, 2 for 50% POE, 3 for 90% POE |
|
MAXSPARECAPACITYOPTION |
NUMBER(12,3) |
|
Not populated as of 2005 End of Year Release; was the Probability of Exceedance (POE) demand forecast used for assessment of Maximum Spare Capacity. 0 if no assessment, 1 for 10% POE, 2 for 50% POE, 3 for 90% POE |
|
INTERCONNECTORFLOWPENALTY |
NUMBER(12,3) |
|
The penalty for non-zero interconnector flow |
|
LASTCHANGED |
DATE |
|
Date and time the record was created or modified |
|
RELIABILITYLRCDEMANDOPTION |
NUMBER(12,3) |
|
Specifies the Probability of Exceedence (POE) demand forecast for Reliability LRC assessment (0 if no assessment, 10 for 10%, 50 for 50%, 90 for 90%) |
|
OUTAGELRCDEMANDOPTION |
NUMBER(12,3) |
|
Specifies the Probability of Exceedence (POE) demand forecast for outage LRC assessment (0 if no assessment, 10 for 10%, 50 for 50%, 90 for 90%) |
|
LORDEMANDOPTION |
NUMBER(12,3) |
|
Specifies the Probability of Exceedence (POE) demand forecast for LOR assessment (0 if no assessment, 10 for 10%, 50 for 50%, 90 for 90%) |
|
RELIABILITYLRCCAPACITYOPTION |
VARCHAR2(10) |
|
Generation Availability to be used in Reliability LRC run (either PASA or MARKET) |
|
OUTAGELRCCAPACITYOPTION |
VARCHAR2(10) |
|
Generation Availability to be used in Outage LRC run (either PASA or MARKET) |
|
LORCAPACITYOPTION |
VARCHAR2(10) |
|
Generation Availability to be used in LOR run (either PASA or MARKET) |
|
LORUIGFOption |
NUMBER(3,0) |
|
UIGF POE forecast availability used for this option |
|
ReliabilityLRCUIGFOption |
NUMBER(3,0) |
|
UIGF POE forecast availability used for this option |
|
OutageLRCUIGFOption |
NUMBER(3,0) |
|
UIGF POE forecast availability used for this option |
|
Name |
|
|
Comment |
PDPASA_CONSTRAINTSOLUTION shows binding and violated constraint results from the capacity evaluation, including the RHS value. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONSTRAINTID |
|
INTERVAL_DATETIME |
|
RUN_DATETIME |
|
RUNTYPE |
|
STUDYREGIONID |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Unique Timestamp Identifier for this study |
|
INTERVAL_DATETIME |
DATE |
X |
The unique identifier for the interval within this study |
|
CONSTRAINTID |
VARCHAR2(20) |
X |
Constraint identifier (synonymous with GenConID) |
|
CAPACITYRHS |
NUMBER(12,2) |
|
The RHS value in the capacity evaluation. |
|
CAPACITYMARGINALVALUE |
NUMBER(12,2) |
|
Capacity adequacy assessment marginal value, 0 if not binding |
|
CAPACITYVIOLATIONDEGREE |
NUMBER(12,2) |
|
Capacity adequacy assessment violation degree for generic constraint; 0 if not violating |
|
LASTCHANGED |
DATE |
|
Last changed date of this record |
|
RUNTYPE |
VARCHAR2(20) |
X |
Type of run. Values are RELIABILITY_LRC, OUTAGE_LRC and LOR. |
|
STUDYREGIONID |
VARCHAR2(20) |
X |
Primary Region for LP Solve (or MARKET if none). |
|
Name |
|
|
Comment |
PDPASA_INTERCONNECTORSOLN shows the results of the capacity evaluation for Interconnectors, including the calculated limits for the interval. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
INTERCONNECTORID |
|
INTERVAL_DATETIME |
|
RUN_DATETIME |
|
RUNTYPE |
|
STUDYREGIONID |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Unique Timestamp Identifier for this study |
|
INTERVAL_DATETIME |
DATE |
X |
The unique identifier for the interval within this study |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Interconnector Identifier |
|
CAPACITYMWFLOW |
NUMBER(12,2) |
|
Interconnector loading level (MW) that can be reached in case of capacity scarcity in neighbouring regions subject to network and energy constraints |
|
CAPACITYMARGINALVALUE |
NUMBER(12,2) |
|
Capacity adequacy assessment marginal value, 0 if not binding |
|
CAPACITYVIOLATIONDEGREE |
NUMBER(12,2) |
|
Capacity adequacy assessment violation degree for interconnector capacity; 0 if not violating |
|
CALCULATEDEXPORTLIMIT |
NUMBER(12,2) |
|
Calculated Interconnector limit of exporting energy on the basis of invoked constraints and static interconnector export limit |
|
CALCULATEDIMPORTLIMIT |
NUMBER(12,2) |
|
Calculated Interconnector limit of importing energy on the basis of invoked constraints and static interconnector import limit. Note unlike the input interconnector import limit this is a directional quantity and should be defined with respect to the interconnector flow. |
|
LASTCHANGED |
DATE |
|
Last changed date of this record |
|
RUNTYPE |
VARCHAR2(20) |
X |
Type of run. Values are RELIABILITY_LRC, OUTAGE_LRC and LOR. |
|
EXPORTLIMITCONSTRAINTID |
VARCHAR2(20) |
|
ID of the constraint that sets the Interconnector Export Limit |
|
IMPORTLIMITCONSTRAINTID |
VARCHAR2(20) |
|
ID of the constraint that sets the Interconnector Import Limit |
|
STUDYREGIONID |
VARCHAR2(20) |
X |
Primary Region for LP Solve (or MARKET if none). |
|
Name |
|
|
Comment |
The PDPASA region solution data |
|
PDPASA_REGIONSOLUTION is public so is available to all participants. Source PDPASA_REGIONSOLUTION is updated each PDPASA run (i.e. half-hourly). Volume Rows per day: 32000 Notes LRC Determination SURPLUSRESERVE is the surplus reserve in a region based on meeting the demand plus the reserve requirement in all regions simultaneously. Note that any surplus above the network restrictions and system reserve requirements is reported in the region it is generated, thus a surplus of zero can mean that a region is importing to meet a requirement or that it has exported all surplus to meet an adjacent region’s requirement.
The PASA processes also calculate a regionally optimised surplus called the Maximum LRC Surplus (MAXSURPLUSRESERVE) being a figure on how much generation could be brought to this region subject to meeting requirements in other regions.
LOR Determination MAXSPARECAPACITY is a regionally optimised figure representing the surplus generation able to be brought to a region subject to meeting the demand in all other regions.
Participants are directed to the first half hour of the Predispatch PASA (PDPASA) reports as NEMMCO's latest reserve determination for a given half hour. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
INTERVAL_DATETIME |
|
REGIONID |
|
RUN_DATETIME |
|
RUNTYPE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Case identifier by the time the case was run |
|
INTERVAL_DATETIME |
DATE |
X |
End date time of the interval |
|
REGIONID |
VARCHAR2(10) |
X |
Region identifier |
|
DEMAND10 |
NUMBER(12,2) |
|
10% Probability of Exceedance demand forecast |
|
DEMAND50 |
NUMBER(12,2) |
|
50% Probability of Exceedance demand forecast |
|
DEMAND90 |
NUMBER(12,2) |
|
90% Probability of Exceedance demand forecast |
|
RESERVEREQ |
NUMBER(12,2) |
|
Region reserve requirement (MW) |
|
CAPACITYREQ |
NUMBER(12,2) |
|
Capacity required to meet the demand and reserve levels in the capacity adequacy assessment. |
|
ENERGYREQDEMAND50 |
NUMBER(12,2) |
|
Energy (GWh) required for this energy block based on the 50% probability of exceedance demand. Listed in the first interval of the energy block. |
|
UNCONSTRAINEDCAPACITY |
NUMBER(12,0) |
|
Aggregate generator capability from Non Energy Constrained plant including restrictions due to network constraints from the capacity adequacy (LRC) assessment. |
|
CONSTRAINEDCAPACITY |
NUMBER(12,0) |
|
Aggregate generator capability from Energy Constrained plant including restrictions due to network constraints |
|
NETINTERCHANGEUNDERSCARCITY |
NUMBER(12,2) |
|
Net interconnector flow from the region for this interval from the capacity adequacy (LRC) assessment. |
|
SURPLUSCAPACITY |
NUMBER(12,2) |
|
Surplus capacity (MW) above the demand, scheduled load and net interchange in this region from the capacity adequacy (LRC) assessment. |
|
SURPLUSRESERVE |
NUMBER(12,2) |
|
Surplus reserve (MW) above the demand, scheduled load, net interchange and reserve requirement in this region from the capacity adequacy (LRC) assessment. |
|
RESERVECONDITION |
NUMBER(1,0) |
|
Low Reserve Condition (LRC) flag for this region in this interval (1 - LRC, 0 - No LRC) |
|
MAXSURPLUSRESERVE |
NUMBER(12,2) |
|
Maximum surplus reserve (MW) above the demand + reserve requirement able to be sourced to this region while meeting demand + reserve requirements in other regions. |
|
MAXSPARECAPACITY |
NUMBER(12,2) |
|
Maximum spare capacity (MW) above the demand able to be sourced to this region while meeting demands in other regions. |
|
LORCONDITION |
NUMBER(1,0) |
|
Lack of Reserve Condition (LOR) flag for this region and interval (3 = LOR3, 2 = LOR2, 1 = LOR1, 0 = No LOR) |
|
AGGREGATECAPACITYAVAILABLE |
NUMBER(12,2) |
|
Sum of MAXAVAIL quantities offered by all Scheduled units and Availability of all semi-scheduled units limited by MAXAVAIL 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 time the record was created or modified changed |
|
AGGREGATEPASAAVAILABILITY |
NUMBER(12,0) |
|
Sum of PASAAVAILABILITY for all scheduled generating units and the Unconstrained Intermittent Generation Forecasts (UIGF) for all semi-scheduled generating units in a given Region for a given PERIODID. |
|
RUNTYPE |
VARCHAR2(20) |
X |
Type of run. Values are RELIABILITY_LRC, OUTAGE_LRC and LOR. |
|
ENERGYREQDEMAND10 |
NUMBER(12,2) |
|
Energy (GWh) required for this energy block based on the 10% probability of exceedance demand. Listed in the first interval of the energy block |
|
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). |
|
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) |
|
Constrained generation forecast for semi-scheduled units for the region. For RELIABILITY_LRC run semi-scheduled generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run semi-scheduled generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. |
|
LOR_SemiScheduledCapacity |
NUMBER(12,2) |
|
Constrained generation forecast for semi-scheduled units for the region for the LOR run. Semi-scheduled generation is constrained by both System Normal and Outage constraints, and incorporate MAXAVAIL limits. |
|
LCR |
NUMBER(16,6) |
|
Largest Credible Risk. MW value for highest credible contingency |
|
LCR2 |
NUMBER(16,6) |
|
Two Largest Creditable Risks. MW value for highest two credible contingencies. |
|
FUM |
NUMBER(16,6) |
|
Forecasting Uncertainty Measure. MW value of reserve calculated as defined in the Reserve Level Declaration Guidelines |
|
SS_SOLAR_UIGF |
Number(12,2) |
|
Unconstrained Intermittent Generation Forecast for solar for the region. For RELIABILITY_LRC and OUTAGE_LRC run this is the POE90 forecast (determined by LRCUIGFOption in CaseSolution). For LOR run this is the POE50 forecast |
|
SS_WIND_UIGF |
Number (12,2) |
|
Unconstrained Intermittent Generation Forecast for wind for the region. For RELIABILITY_LRC and OUTAGE_LRC run this is the POE90 forecast (determined by LRCUIGFOption in CaseSolution). For LOR run this is the POE50 forecast |
|
SS_SOLAR_CAPACITY |
Number (12,2) |
|
Constrained generation forecast for solar for the region. For RELIABILITY_LRC run solar generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run solar generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. |
|
SS_WIND_CAPACITY |
Number (12,2) |
|
Constrained generation forecast for wind for the region. For RELIABILITY_LRC run wind generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run wind generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. |
|
SS_SOLAR_CLEARED |
Number (12,2) |
|
Constrained generation forecast for solar for the region. For RELIABILITY_LRC run solar generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run solar generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. |
|
SS_WIND_CLEARED |
Number (12,2) |
|
Constrained generation forecast for wind for the region. For RELIABILITY_LRC run wind generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run wind generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. |
|
WDR_AVAILABLE |
NUMBER(12,2) |
|
Regional aggregated Wholesale Demand Response (WDR) availability in MW. |
|
WDR_PASAAVAILABLE |
NUMBER(12,2) |
|
Regional aggregated Wholesale Demand Response (WDR) PASA availability in MW. |
|
WDR_CAPACITY |
NUMBER(12,2) |
|
Regional aggregated Wholesale Demand Response (WDR) capacity in MW. |
|
|
|