|
Name |
|
|
Comment |
STPASA_CASESOLUTION holds one record containing results pertaining to each entire solution |
|
STPASA_CASESOLUTION is public data. Source STPASA_CASESOLUTION is updated each STPASA run (i.e. every 2 hours). Volume Rows per day: 12 Mb per month: <1 |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
RUN_DATETIME |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Unique Timestamp Identifier for this study |
|
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 demand forecast used for capacity adequacy assessment. 0 if no assessment, 1 for 10%, 2 for 50%, 3 for 90% |
|
MAXSURPLUSRESERVEOPTION |
NUMBER(12,3) |
|
Not populated as of 2005 End of Year Release; was the demand forecast used for assessment of Maximum surplus Reserve. 0 if no assessment, 1 for 10%, 2 for 50%, 3 for 90% |
|
MAXSPARECAPACITYOPTION |
NUMBER(12,3) |
|
Not populated as of 2005 End of Year Release; was the demand forecast used for assessment of Maximum Spare Capacity. 0 if no assessment, 1 for 10%, 2 for 50%, 3 for 90% |
|
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 |
STPASA_CONSTRAINTSOLUTION shows binding and violated constraint results from the capacity evaluation, including the RHS value. |
|
STPASA_CONSTRAINTSOLUTION is public data. Source STPASA_CONSTRAINTSOLUTION is updated each STPASA run (i.e. every 2 hours). Volume Rows per day: 19000 (est.) Mb per month: 90 |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONSTRAINTID |
|
INTERVAL_DATETIME |
|
RUN_DATETIME |
|
RUNTYPE |
|
STUDYREGIONID |
|
Name |
|
LASTCHANGED |
|
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 |
STPASA run, identified by the nominal start time 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 |
STPASA_INTERCONNECTORSOLN shows the results of the capacity evaluation for Interconnectors, including the calculated limits for the interval. |
|
STPASA_INTERCONNECTORSOLN is public so is available to all participants. Source STPASA_INTERCONNECTORSOLN is updated each STPASA run (i.e. every 2 hours). Volume Rows per day: 576 Mb per month: 4 |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
INTERCONNECTORID |
|
INTERVAL_DATETIME |
|
RUN_DATETIME |
|
RUNTYPE |
|
STUDYREGIONID |
|
Name |
|
LASTCHANGED |
|
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 |
STPASA_REGIONSOLUTION shows the results of the regional capacity, maximum surplus reserve and maximum spare capacity evaluations for each period of the study.Note that the RELIABILITY_LRC and OUTAGE_LRC Run Types are no longer reported from 31 July 2025. |
|
STPASA_REGIONSOLUTION is public so is available to all participants. Source STPASA_REGIONSOLUTION is updated each STPASA run (i.e every 2 hours). Volume Rows per day: 480 Mb per month: 8 |
|
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 nominal start time 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) |
|
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 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 RELIABILITY_LRC and OUTAGE_LRC runs, UIGF is the POE90 forecast. For the LOR Run, UIGF is the POE50 forecast. Note that the RELIABILITY_LRC and OUTAGE_LRC Run Types are discontinued from 31 July 2025. |
|
RUNTYPE |
VARCHAR2(20) |
X |
Type of run. Values are RELIABILITY_LRC, OUTAGE_LRC and LOR. Note that the STPASA RELIABILITY_LRC and OUTAGE_LRC Run Types are 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 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 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 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 (MW) 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.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 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.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. |
|
|
|