|
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 |
This report delivers available capacity, PASA availability and given recall period for all scheduled resources. Note that for an MNSP, DUID = LINKID in the MNSP_INTERCONNECTOR table |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
DUID |
|
INTERVAL_DATETIME |
|
RUN_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
PDPASA run, identified by the first half hour ended interval of the run |
|
INTERVAL_DATETIME |
DATE |
X |
Half hour ended interval |
|
DUID |
VARCHAR2(20) |
X |
NEM Dispatchable Unit Identifier |
|
GENERATION_MAX_AVAILABILITY |
NUMBER(12,6) |
|
Available Capacity for a scheduled generating unit, semi-scheduled generating unit, BDU (Gen side), WDR or MNSP. |
|
GENERATION_PASA_AVAILABILITY |
NUMBER(12,0) |
|
PASA Availability for a scheduled generating unit, BDU (Gen side), WDR or MNSP. Null for a semi-scheduled generating unit. |
|
GENERATION_RECALL_PERIOD |
NUMBER(8,3) |
|
Recall Period associated with the PASA Availability for a scheduled generating unit, BDU (Gen side), WDR or MNSP. Null for a semi-scheduled generating unit. |
|
LOAD_MAX_AVAILABILITY |
NUMBER(12,6) |
|
Available Capacity for a scheduled load or BDU(Load side). |
|
LOAD_PASA_AVAILABILITY |
NUMBER(12,0) |
|
PASA Availability for a scheduled load or BDU(Load side). |
|
LOAD_RECALL_PERIOD |
NUMBER(8,3) |
|
Recall Period associated with the PASA Availability for a scheduled load or BDU(Load side). |
|
LASTCHANGED |
DATE |
|
Report Creation Date Time |
|
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 dataNote that the OUTAGE_LRC Run Type is no longer reported from 31 July 2025. |
|
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 |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the 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) |
|
Reserve Requirement (MW). This field is not populated after 30 July 2025. |
|
CAPACITYREQ |
NUMBER(12,2) |
|
Demand + Reserve requirements (MW). This field is not populated after 30 July 2025. |
|
ENERGYREQDEMAND50 |
NUMBER(12,2) |
|
Sum of: (Region Demand50)/Period (sum by trading day, entered in first period of trading day, GWh) |
|
UNCONSTRAINEDCAPACITY |
NUMBER(12,0) |
|
Aggregate generation + WDR capacity from Non-Energy Constrained plant subjected to restrictions due to network constraints |
|
CONSTRAINEDCAPACITY |
NUMBER(12,0) |
|
Aggregate generation + WDR capacity from Energy Constrained plant subjected to restrictions due to network constraints |
|
NETINTERCHANGEUNDERSCARCITY |
NUMBER(12,2) |
|
Net export (MW) out of this region in the LOR evaluation. Export if 0, Import if 0. This value is the same as LORNETINTERCHANGEUNDERSCARCITY. |
|
SURPLUSCAPACITY |
NUMBER(12,2) |
|
Regional surplus capacity (MW), +/- values indicate surplus/deficit capacity respectively. This value reflects Regional LOR reserve. |
|
SURPLUSRESERVE |
NUMBER(12,2) |
|
Regional surplus reserve (MW). This value also reflects Regional LOR reserve. Note: For LOR runs, RESERVEREQ requirement input is not used. |
|
RESERVECONDITION |
NUMBER(1,0) |
|
Regional reserve condition from LRC run. This field is not populated after 30 July 2025. |
|
MAXSURPLUSRESERVE |
NUMBER(12,2) |
|
Maximum Surplus Reserve (MW) evaluated for this region from LRC runs. This field is no longer populated. |
|
MAXSPARECAPACITY |
NUMBER(12,2) |
|
Maximum Spare Capacity (MW) evaluated for this region. Calculated for each region in turn. This value reflects Regional LOR reserve. |
|
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 this record was created |
|
AGGREGATEPASAAVAILABILITY |
NUMBER(12,0) |
|
Sum of PASAAVAILABILITY for all scheduled generating units and scheduled bidirectional units (Gen side) with a Recall_Period = 24 hours plus the sum of Unconstrained Intermittent Generation Forecasts (UIGF) for all semi-scheduled generating units. For the OUTAGE_LRC run, UIGF is the POE90 forecast. For the LOR Run, UIGF is the POE50 forecast. Note that the OUTAGE_LRC Run Type is discontinued from 31 July 2025. |
|
RUNTYPE |
VARCHAR2(20) |
X |
Type of run. Values are OUTAGE_LRC and LOR. Note that the PDPASA OUTAGE_LRC Run Type is discontinued from 31 July 2025, with only the LOR Run Type reported. |
|
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. This field is no longer populated. |
|
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 (MW) for semi-scheduled units for the region. For OUTAGE_LRC run and LOR run, semi-scheduled generation is constrained by both System Normal and Outage constraints. All run types (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 Credible 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 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 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 OUTAGE_LRC run and LOR run. solar generation is constrained by both System Normal and Outage constraints. All run types (OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. |
|
SS_WIND_CAPACITY |
Number (12,2) |
|
Constrained generation forecast for wind for the region. For OUTAGE_LRC run and LOR run, wind generation is constrained by both System Normal and Outage constraints. All run types (OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. |
|
SS_SOLAR_CLEARED |
Number (12,2) |
|
Constrained generation forecast (MW) for solar for the region. For OUTAGE_LRC run and LOR run, solar generation is constrained by both System Normal and Outage constraints. All run types (OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. This value is the same as SS_SOLAR_CAPACITY. |
|
SS_WIND_CLEARED |
Number (12,2) |
|
Constrained generation forecast (MW) for wind for the region. For OUTAGE_LRC run and LOR run, wind generation is constrained by both System Normal and Outage constraints. All run types (OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. This value is the same as SS_WIND_CAPACITY. |
|
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. |
|
|
|