Name |
|
Comment |
MTPASA solution header table |
MTPASA_CASERESULT is public data. Holds one Record for entire solution |
Name |
Comment |
Value |
Visibility |
|
Public |
Name |
RUN_DATETIME |
RUN_NO |
Name |
Data Type |
Mandatory |
Comment |
RUN_DATETIME |
DATE |
X |
Date processing of the run begins. |
RUN_NO |
NUMBER(4) |
X |
Unique run id. |
PLEXOS_VERSION |
VARCHAR2(20) |
|
Version of PLEXOS used |
LASTCHANGED |
DATE |
|
Last date and time record changed |
Name |
|
Comment |
Constraint results for Binding or Violating Constraints |
MTPASA_CONSTRAINTRESULT is public data.
|
Name |
Comment |
Value |
Visibility |
|
Public |
Name |
CONSTRAINTID |
DAY |
DEMAND_POE_TYPE |
RUN_DATETIME |
RUN_NO |
RUNTYPE |
Name |
Data Type |
Mandatory |
Comment |
RUN_DATETIME |
DATE |
X |
Date processing of the run begins. |
RUN_NO |
NUMBER(4) |
X |
Unique run id. |
RUNTYPE |
VARCHAR2(20) |
X |
Type of run. Always RELIABILITY |
DEMAND_POE_TYPE |
VARCHAR2(20) |
X |
Demand POE type used. Value is POE10 |
DAY |
DATE |
X |
Day this result is for |
CONSTRAINTID |
VARCHAR2(20) |
X |
The unique identifier for the constraint. Only binding or violating constraints are reported |
EFFECTIVEDATE |
DATE |
|
The effective date of the constraint used |
VERSIONNO |
NUMBER(3,0) |
|
The version of the constraint used |
PERIODID |
NUMBER(3,0) |
|
Half hourly period reported, selected as period of maximum NEM scheduled demand (calculated as maximum of scheduled demands, averaged across iterations and reference years) |
PROBABILITYOFBINDING |
NUMBER(8,5) |
|
Proportion of a constraint binding, across iterations and reference years |
PROBABILITYOFVIOLATION |
NUMBER(8,5) |
|
Proportion of a constraint violating, across iterations and reference years |
CONSTRAINTVIOLATION90 |
NUMBER(12,2) |
|
The 90th percentile violation degree for this constraint, across iterations and reference years (MW) |
CONSTRAINTVIOLATION50 |
NUMBER(12,2) |
|
The 50th percentile violation degree for this constraint, across iterations and reference years (MW) |
CONSTRAINTVIOLATION10 |
NUMBER(12,2) |
|
The 10th percentile violation degree for this constraint, across iterations and reference years (MW) |
LASTCHANGED |
DATE |
|
Last date and time record changed |
Name |
|
Comment |
Constraint Summary results over aggregation periods |
MTPASA_CONSTRAINTSUMMARY is public data. |
Name |
Comment |
Value |
Visibility |
|
Public |
Name |
AGGREGATION_PERIOD |
CONSTRAINTID |
DAY |
DEMAND_POE_TYPE |
RUN_DATETIME |
RUN_NO |
RUNTYPE |
Name |
Data Type |
Mandatory |
Comment |
RUN_DATETIME |
DATE |
X |
Date processing of the run begins. |
RUN_NO |
NUMBER(4) |
X |
Unique run id. |
RUNTYPE |
VARCHAR2(20) |
X |
Type of run. Always RELIABILITY |
DEMAND_POE_TYPE |
VARCHAR2(20) |
X |
Demand POE type used. Value is POE10 |
DAY |
DATE |
X |
Day this result is for |
CONSTRAINTID |
VARCHAR2(20) |
X |
The unique identifier for the constraint. Only binding or violating constraints are reported |
EFFECTIVEDATE |
DATE |
|
The effective date of the constraint used |
VERSIONNO |
NUMBER(3,0) |
|
The version of the constraintID |
AGGREGATION_PERIOD |
VARCHAR2(20) |
X |
Period data is aggregated over. Values are PEAK, SHOULDER, OFFPEAK. PEAK = 14:00-19:59, SHOULDER = 07:00-13:59 and 20:00-21:59, OFFPEAK = 22:00-06:59 |
CONSTRAINTHOURSBINDING |
NUMBER(12,2) |
|
Constraint hours binding or violating for period, averaged across iterations and reference years |
LASTCHANGED |
DATE |
|
Last date and time record changed |
Name |
|
Comment |
Offered PASA Availability of the scheduled generator DUID for each day over the Medium Term PASA period. The data in this table is input data to the MT PASA process it is not part of the MTPASA solution. The availability does not reflect any energy limitations in the MT PASA offers |
Name |
Comment |
Value |
Visibility |
|
Public |
Name |
DAY |
DUID |
PUBLISH_DATETIME |
REGIONID |
Name |
Data Type |
Mandatory |
Comment |
PUBLISH_DATETIME |
DATE |
X |
Date Time the report was published. |
DAY |
DATE |
X |
Date on which the PASA availability of DUID applies. |
REGIONID |
VARCHAR2(20) |
X |
NEM Region. |
DUID |
VARCHAR2(20) |
X |
NEM DUID. |
PASAAVAILABILITY |
NUMBER(12,0) |
|
Offered PASA Availability of Scheduled generator DUID for the day. |
LATEST_OFFER_DATETIME |
DATE |
|
Date Time of the latest offer used for DUID for this date. |
LASTCHANGED |
DATE |
|
Last date and time record changed |
CARRYOVERSTATUS |
NUMBER(1,0) |
|
Status of a reported capacity value (e.g. 1 for Yes, 0 for No) |
PASAUNITSTATE |
VARCHAR2(20) |
|
The unit state value |
PASARECALLTIME |
NUMBER(4) |
|
The recall time value |
Name |
|
Comment |
Interconnector results for interval of max demand per day |
MTPASA_INTERCONNECTORRESULT is public data. |
Name |
Comment |
Value |
Visibility |
|
Public |
Name |
DAY |
DEMAND_POE_TYPE |
INTERCONNECTORID |
RUN_DATETIME |
RUN_NO |
RUNTYPE |
Name |
Data Type |
Mandatory |
Comment |
RUN_DATETIME |
DATE |
X |
Date processing of the run begins. |
RUN_NO |
NUMBER(4) |
X |
Unique run id. |
RUNTYPE |
VARCHAR2(20) |
X |
Type of run. Always RELIABILITY |
DEMAND_POE_TYPE |
VARCHAR2(20) |
X |
Demand POE type used. Value is POE10 |
DAY |
DATE |
X |
Day this result is for |
INTERCONNECTORID |
VARCHAR2(20) |
X |
The unique identifier for the interconnector |
PERIODID |
NUMBER(3,0) |
|
Half hourly period reported, selected as period of maximum NEM scheduled demand (calculated as maximum of scheduled demands, averaged across iterations and reference years) |
FLOW90 |
NUMBER(12,2) |
|
The 90th percentile for flows, across iterations and reference years. Positive values indicate exporting, negative values indicate importing (MW) |
FLOW50 |
NUMBER(12,2) |
|
The 50th percentile for flows, across iterations and reference years. Positive values indicate exporting, negative values indicate importing (MW) |
FLOW10 |
NUMBER(12,2) |
|
The 10th percentile for flows, across iterations and reference years. Positive values indicate exporting, negative values indicate importing (MW) |
PROBABILITYOFBINDINGEXPORT |
NUMBER(8,5) |
|
Proportion of iterations and reference years with interconnector constrained when exporting |
PROBABILITYOFBINDINGIMPORT |
NUMBER(8,5) |
|
Proportion of iterations and reference years with interconnector constrained when importing |
CALCULATEDEXPORTLIMIT |
NUMBER(12,2) |
|
Calculated Interconnector limit of exporting energy on the basis of invoked constraints and static interconnector export limit, averaged across iterations and reference years |
CALCULATEDIMPORTLIMIT |
NUMBER(12,2) |
|
Calculated Interconnector limit of importing energy on the basis of invoked constraints and static interconnector import limit, averaged across iterations and reference years |
LASTCHANGED |
DATE |
|
Last date and time record changed |
Name |
|
Comment |
Results for Loss of Load Probability (LOLP) run per day |
MTPASA_LOLPRESULT is public data. |
Name |
Comment |
Value |
Visibility |
|
Public |
Name |
DAY |
REGIONID |
RUN_DATETIME |
RUN_NO |
RUNTYPE |
Name |
Data Type |
Mandatory |
Comment |
RUN_DATETIME |
DATE |
X |
Date processing of the run begins. |
RUN_NO |
NUMBER(4) |
X |
Unique run id. |
RUNTYPE |
VARCHAR2(20) |
X |
Type of run. Always LOLP |
DAY |
DATE |
X |
Day this result is for |
REGIONID |
VARCHAR2(20) |
X |
The unique region identifier |
WORST_INTERVAL_PERIODID |
NUMBER(3,0) |
|
The half hourly interval period with the highest LOLP, or highest region demand if LOLP = 0 for all intervals (1..48) |
WORST_INTERVAL_DEMAND |
NUMBER(12,2) |
|
The Abstract Operational Demand for the worst interval in this region (MW) |
WORST_INTERVAL_INTGEN |
NUMBER(12,2) |
|
The half hourly aggregate intermittent generation for the worst interval in this region (MW) |
WORST_INTERVAL_DSP |
NUMBER(12,2) |
|
The half hourly aggregate demand side participation for the worst interval period in this region (MW) |
LOSSOFLOADPROBABILITY |
NUMBER(8,5) |
|
Loss of Load Probability for the worst interval in this region |
LOSSOFLOADMAGNITUDE |
VARCHAR2(20) |
|
Loss of Load Magnitude for the worst interval in this region. Values are LOW, MEDIUM, HIGH |
LASTCHANGED |
DATE |
|
Last date and time record changed |
Name |
|
Comment |
The tracking table to assist in versioning of the region-aggregate offered PASA Availability data published to the MTPASA_REGIONAVAILABILITY table. |
Name |
Comment |
Value |
Visibility |
|
Public |
Name |
PUBLISH_DATETIME |
Name |
Data Type |
Mandatory |
Comment |
PUBLISH_DATETIME |
DATE |
X |
Date Time the report was published. |
STARTDATE |
DATE |
|
First date of the report inclusive. |
ENDDATE |
DATE |
|
Last date of the report inclusive. |
LATEST_OFFER_DATETIME |
DATE |
|
Date Time of the latest offer used in the report. |
Name |
|
Comment |
Stores the Region-aggregate offered PASA Availability of scheduled generators for each day over the Medium Term PASA period. The data in this table is an aggregate of input data to the MT PASA process it is not part of the MTPASA solution. The aggregate availability does not reflect any energy limitations in the MT PASA offers. |
MTPASA_REGIONAVAILABILITY is public data. |
Name |
Comment |
Value |
Visibility |
|
Public |
Name |
DAY |
PUBLISH_DATETIME |
REGIONID |
Name |
Data Type |
Mandatory |
Comment |
PUBLISH_DATETIME |
DATE |
X |
Date Time the report was published. |
DAY |
DATE |
X |
Date on which the aggregation applies. |
REGIONID |
VARCHAR2(20) |
X |
NEM Region. |
PASAAVAILABILITY_SCHEDULED |
NUMBER(12,0) |
|
Aggregate of the offered PASA Availability for all Scheduled generators in this region. |
LATEST_OFFER_DATETIME |
DATE |
|
Date Time of the latest offer used in the aggregation for this region and date. |
ENERGYUNCONSTRAINEDCAPACITY |
NUMBER(12,0) |
|
Region energy unconstrained MW capacity |
ENERGYCONSTRAINEDCAPACITY |
NUMBER(12,0) |
|
Region energy constrained MW capacity |
NONSCHEDULEDGENERATION |
NUMBER(12,2) |
|
Allowance made for non-scheduled generation in the demand forecast (MW) |
DEMAND10 |
NUMBER(12,2) |
|
10% probability demand (ex non-scheduled demand) |
DEMAND50 |
NUMBER(12,2) |
|
50% probability demand (ex non-scheduled demand) |
ENERGYREQDEMAND10 |
NUMBER(12,2) |
|
Total weekly operational as generated consumption (POE 10) |
ENERGYREQDEMAND50 |
NUMBER(12,2) |
|
Total weekly operational as generated consumption (POE 50) |
LASTCHANGED |
DATE |
|
Last date and time record changed |
DEMAND10MIN |
NUMBER(12,2) |
|
Minimum of the Operational Load as Generated (OPGEN) peaks that occur in all ref years for the P10 traces (MW). |
DEMAND10MAX |
NUMBER(12,2) |
|
Maximum of the Operational Load as Generated (OPGEN) peaks that occur in all ref years for the P10 traces (MW). |
DEMAND50MIN |
NUMBER(12,2) |
|
Minimum of the Operational Load as Generated (OPGEN) peaks that occur in all ref years for the P50 traces (MW). |
DEMAND50MAX |
NUMBER(12,2) |
|
Maximum of the Operational Load as Generated (OPGEN) peaks that occur in all ref years for the P50 traces (MW). |
CARRYOVERCAPACITY |
NUMBER(12,0) |
|
Split of the CARRYOVER component of aggregate capacity vs the currently reported capacity. |
Name |
|
Comment |
Region results for Unserved Energy (USE) |
MTPASA_REGIONITERATION is public data. |
Name |
Comment |
Value |
Visibility |
|
Public |
Name |
AGGREGATION_PERIOD |
DEMAND_POE_TYPE |
PERIOD_ENDING |
REGIONID |
RUN_DATETIME |
RUN_NO |
RUNTYPE |
USE_ITERATION_ID |
Name |
Data Type |
Mandatory |
Comment |
RUN_DATETIME |
DATE |
X |
Date processing of the run begins. |
RUN_NO |
NUMBER(4) |
X |
Unique run id. |
RUNTYPE |
VARCHAR2(20) |
X |
Type of run. Always RELIABILITY |
DEMAND_POE_TYPE |
VARCHAR2(20) |
X |
Demand POE type used. Value is POE10 or POE50 |
AGGREGATION_PERIOD |
VARCHAR2(20) |
X |
Period data is aggregated over. Values are YEAR |
PERIOD_ENDING |
DATE |
X |
Datetime of day at end of period (i.e. last day of year reported) |
REGIONID |
VARCHAR2(20) |
X |
The unique region identifier |
USE_ITERATION_ID |
NUMBER(5) |
X |
Iteration ID, only produced for iterations showing unserved energy>0 |
USE_ITERATION_EVENT_NUMBER |
NUMBER(12,2) |
|
Number of half hours showing unserved energy over year, for iteration |
USE_ITERATION_EVENT_AVERAGE |
NUMBER(12,2) |
|
Average unserved energy event size for iteration over year (MW) |
LASTCHANGED |
DATE |
|
Last date and time record changed |
Name |
|
Comment |
Region results for interval of max demand per day. |
MTPASA_REGIONRESULT is public data. |
Name |
Comment |
Value |
Visibility |
|
Public |
Name |
DAY |
DEMAND_POE_TYPE |
REGIONID |
RUN_DATETIME |
RUN_NO |
RUNTYPE |
Name |
Data Type |
Mandatory |
Comment |
RUN_DATETIME |
DATE |
X |
Date processing of the run begins. |
RUN_NO |
NUMBER(4) |
X |
Unique run id. |
RUNTYPE |
VARCHAR2(20) |
X |
Type of run. Always RELIABILITY |
DEMAND_POE_TYPE |
VARCHAR2(20) |
X |
Demand POE type used. Value is POE10 |
DAY |
DATE |
X |
Day this result is for |
REGIONID |
VARCHAR2(20) |
X |
The unique region identifier |
PERIODID |
NUMBER(3,0) |
|
Half hourly period reported, selected as period of maximum NEM scheduled demand (calculated as maximum of scheduled demands, averaged across iterations and reference years) |
DEMAND |
NUMBER(12,2) |
|
Demand value from selected half hourly interval (MW) |
AGGREGATEINSTALLEDCAPACITY |
NUMBER(12,2) |
|
The total installed capacity of all generation (MW) |
NUMBEROFITERATIONS |
NUMBER(12,2) |
|
Total number of iterations and reference years performed |
USE_NUMBEROFITERATIONS |
NUMBER(12,2) |
|
Number of iterations and reference years with unserved energy>0 |
USE_MAX |
NUMBER(12,2) |
|
Maximum unserved energy, across iterations and reference years (MW) |
USE_UPPERQUARTILE |
NUMBER(12,2) |
|
Upper quartile unserved energy, across iterations and reference years (MW) |
USE_MEDIAN |
NUMBER(12,2) |
|
Median unserved energy, across iterations and reference years (MW) |
USE_LOWERQUARTILE |
NUMBER(12,2) |
|
Lower quartile unserved energy, across iterations and reference years (MW) |
USE_MIN |
NUMBER(12,2) |
|
Minimum unserved energy, across iterations and reference years (MW) |
USE_AVERAGE |
NUMBER(12,2) |
|
Average unserved energy, across iterations and reference years (MW) |
USE_EVENT_AVERAGE |
NUMBER(12,2) |
|
Average unserved energy event size, across iterations and reference years (MW) |
TOTALSCHEDULEDGEN90 |
NUMBER(12,2) |
|
The 90th percentile for scheduled generation across iterations and reference years (MW) |
TOTALSCHEDULEDGEN50 |
NUMBER(12,2) |
|
The 50th percentile for scheduled generation across iterations and reference years (MW) |
TOTALSCHEDULEDGEN10 |
NUMBER(12,2) |
|
The 10th percentile for scheduled generation across iterations and reference years (MW) |
TOTALINTERMITTENTGEN90 |
NUMBER(12,2) |
|
The 90th percentile for intermittent generation, across iterations and reference years (MW) |
TOTALINTERMITTENTGEN50 |
NUMBER(12,2) |
|
The 50th percentile for intermittent generation, across iterations and reference years (MW) |
TOTALINTERMITTENTGEN10 |
NUMBER(12,2) |
|
The 10th percentile for intermittent generation, across iterations and reference years (MW) |
DEMANDSIDEPARTICIPATION90 |
NUMBER(12,2) |
|
The 90th percentile for demand side participation, across iterations and reference years (MW) |
DEMANDSIDEPARTICIPATION50 |
NUMBER(12,2) |
|
The 50th percentile for demand side participation, across iterations and reference years (MW) |
DEMANDSIDEPARTICIPATION10 |
NUMBER(12,2) |
|
The 10th percentile for demand side participation, across iterations and reference years (MW) |
LASTCHANGED |
DATE |
|
Last date and time record changed |
TOTALSEMISCHEDULEGEN90 |
NUMBER(12,2) |
|
The 90% percentile for semi-scheduled generation across iterations and reference years (MW) |
TOTALSEMISCHEDULEGEN50 |
NUMBER(12,2) |
|
The 50% percentile for semi-scheduled generation across iterations and reference years (MW) |
TOTALSEMISCHEDULEGEN10 |
NUMBER(12,2) |
|
The 10% percentile for semi-scheduled generation across iterations and reference years (MW) |
TOTALAVAILABLEGENMIN |
NUMBER(12,2) |
|
Minimum available capacity, across iterations and reference years (MW). |
TOTALAVAILABLEGEN10 |
NUMBER(12,2) |
|
The 10% percentile for available capacity, across iterations and reference years (MW). |
TOTALAVAILABLEGEN50 |
NUMBER(12,2) |
|
The 50% percentile for available capacity, across iterations and reference years (MW). |
TOTALAVAILABLEGEN90 |
NUMBER(12,2) |
|
The 90% percentile for available capacity, across iterations and reference years (MW). |
TOTALAVAILABLEGENMAX |
NUMBER(12,2) |
|
Maximum available capacity, across iterations and reference years (MW). |
Name |
|
Comment |
Region Results summary over aggregation periods. |
MTPASA_REGIONSUMMARY is public data. |
Name |
Comment |
Value |
Visibility |
|
Public |
Name |
AGGREGATION_PERIOD |
DEMAND_POE_TYPE |
PERIOD_ENDING |
REGIONID |
RUN_DATETIME |
RUN_NO |
RUNTYPE |
Name |
Data Type |
Mandatory |
Comment |
RUN_DATETIME |
DATE |
X |
Date processing of the run begins. |
RUN_NO |
NUMBER(4) |
X |
Unique run id. |
RUNTYPE |
VARCHAR2(20) |
X |
Type of run. Always RELIABILITY |
DEMAND_POE_TYPE |
VARCHAR2(20) |
X |
Demand POE type used. Value are POE10, POE50 |
AGGREGATION_PERIOD |
VARCHAR2(20) |
X |
Period data is aggregated over. Values are YEAR, MONTH |
PERIOD_ENDING |
DATE |
X |
Datetime of day at end of period (i.e. last day of month or year reported) |
REGIONID |
VARCHAR2(20) |
X |
The unique region identifier |
NATIVEDEMAND |
NUMBER(12,2) |
|
Native demand calculated from Operational As Generated trace supplied by Energy Forecasting |
USE_PERCENTILE10 |
NUMBER(12,2) |
|
Unserved energy period amount at the 10th percentile of iterations and reference years (MWh) |
USE_PERCENTILE20 |
NUMBER(12,2) |
|
Unserved energy period amount at the 20th percentile of iterations and reference years (MWh) |
USE_PERCENTILE30 |
NUMBER(12,2) |
|
Unserved energy period amount at the 30th percentile of iterations and reference years (MWh) |
USE_PERCENTILE40 |
NUMBER(12,2) |
|
Unserved energy period amount at the 40th percentile of iterations and reference years (MWh) |
USE_PERCENTILE50 |
NUMBER(12,2) |
|
Unserved energy period amount at the 50th percentile of iterations and reference years (MWh) |
USE_PERCENTILE60 |
NUMBER(12,2) |
|
Unserved energy period amount at the 60th percentile of iterations and reference years (MWh) |
USE_PERCENTILE70 |
NUMBER(12,2) |
|
Unserved energy period amount at the 70th percentile of iterations and reference years (MWh) |
USE_PERCENTILE80 |
NUMBER(12,2) |
|
Unserved energy period amount at the 80th percentile of iterations and reference years (MWh) |
USE_PERCENTILE90 |
NUMBER(12,2) |
|
Unserved energy period amount at the 90th percentile of iterations and reference years (MWh) |
USE_PERCENTILE100 |
NUMBER(12,2) |
|
Unserved energy period amount at the 100th percentile of iterations and reference years (MWh) |
USE_AVERAGE |
NUMBER(12,2) |
|
Average period unserved energy across iterations and reference years (MWh) |
NUMBEROFITERATIONS |
NUMBER(12,2) |
|
Total number of iterations and reference years performed |
USE_NUMBEROFITERATIONS |
NUMBER(12,2) |
|
Number of iterations and reference years showing unserved energy |
USE_EVENT_MAX |
NUMBER(12,2) |
|
Maximum unserved energy event size across all half hourly intervals and iterations and reference years that have unserved energy>0 (MW) |
USE_EVENT_UPPERQUARTILE |
NUMBER(12,2) |
|
Upper quartile unserved energy event size across all half hourly intervals and iterations and reference years that have unserved energy>0 (MW) |
USE_EVENT_MEDIAN |
NUMBER(12,2) |
|
Median unserved energy event size across all half hourly intervals and iterations and reference years that have unserved energy>0 (MW) |
USE_EVENT_LOWERQUARTILE |
NUMBER(12,2) |
|
Lower quartile unserved energy event size across all half hourly intervals and iterations and reference years that have unserved energy>0 (MW) |
USE_EVENT_MIN |
NUMBER(12,2) |
|
Minimum unserved energy event size across all half hourly intervals and iterations and reference years that have unserved energy>0 (MW) |
WEIGHT |
NUMBER(16,6) |
|
Fixed Values of 0.696 for 50 POE and 0.304 for 10 POE. |
USE_WEIGHTED_AVG |
NUMBER(16,6) |
|
Weighted average USE per region = (USE_AVERAGE_POE10/NATIVE_DEMAND_POE_10*WEIGHT_POE_10 + USE_AVERAGE_POE50/NATIVE_DEMAND_POE_50*WEIGHT_POE_50)*100 |
LRC |
NUMBER(12,2) |
|
LRC Condition reported (Value=1) if USE_WEIGHTED_AVG >= 0.002% otherwise (Value=0) |
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
|
|