Table: MTPASA_CASERESULT

MTPASA_CASERESULT

Name

MTPASA_CASERESULT

Comment

MTPASA solution header table


Description

MTPASA_CASERESULT is public data.

Holds one Record for entire solution


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

RUN_DATETIME

RUN_NO


Content

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


Table: MTPASA_CONSTRAINTRESULT

MTPASA_CONSTRAINTRESULT

Name

MTPASA_CONSTRAINTRESULT

Comment

Constraint results for Binding or Violating Constraints


Description

MTPASA_CONSTRAINTRESULT is public data.

 


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

CONSTRAINTID

DAY

DEMAND_POE_TYPE

RUN_DATETIME

RUN_NO

RUNTYPE


Content

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


Table: MTPASA_CONSTRAINTSUMMARY

MTPASA_CONSTRAINTSUMMARY

Name

MTPASA_CONSTRAINTSUMMARY

Comment

Constraint Summary results over aggregation periods


Description

MTPASA_CONSTRAINTSUMMARY is public data.


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

AGGREGATION_PERIOD

CONSTRAINTID

DAY

DEMAND_POE_TYPE

RUN_DATETIME

RUN_NO

RUNTYPE


Content

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


Table: MTPASA_DUIDAVAILABILITY

MTPASA_DUIDAVAILABILITY

Name

MTPASA_DUIDAVAILABILITY

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


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

DAY

DUID

PUBLISH_DATETIME

REGIONID


Content

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


Table: MTPASA_INTERCONNECTORRESULT

MTPASA_INTERCONNECTORRESULT

Name

MTPASA_INTERCONNECTORRESULT

Comment

Interconnector results for interval of max demand per day


Description

MTPASA_INTERCONNECTORRESULT is public data.


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

DAY

DEMAND_POE_TYPE

INTERCONNECTORID

RUN_DATETIME

RUN_NO

RUNTYPE


Content

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


Table: MTPASA_LOLPRESULT

MTPASA_LOLPRESULT

Name

MTPASA_LOLPRESULT

Comment

Results for Loss of Load Probability (LOLP) run per day


Description

MTPASA_LOLPRESULT is public data.


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

DAY

REGIONID

RUN_DATETIME

RUN_NO

RUNTYPE


Content

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


Table: MTPASA_REGIONAVAIL_TRK

MTPASA_REGIONAVAIL_TRK

Name

MTPASA_REGIONAVAIL_TRK

Comment

The tracking table to assist in versioning of the region-aggregate offered PASA Availability data published to the MTPASA_REGIONAVAILABILITY table.


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

PUBLISH_DATETIME


Content

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.


Table: MTPASA_REGIONAVAILABILITY

MTPASA_REGIONAVAILABILITY

Name

MTPASA_REGIONAVAILABILITY

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.


Description

MTPASA_REGIONAVAILABILITY is public data.


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

DAY

PUBLISH_DATETIME

REGIONID


Content

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.


Table: MTPASA_REGIONITERATION

MTPASA_REGIONITERATION

Name

MTPASA_REGIONITERATION

Comment

Region results for Unserved Energy (USE)


Description

MTPASA_REGIONITERATION is public data.


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

AGGREGATION_PERIOD

DEMAND_POE_TYPE

PERIOD_ENDING

REGIONID

RUN_DATETIME

RUN_NO

RUNTYPE

USE_ITERATION_ID


Content

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


Table: MTPASA_REGIONRESULT

MTPASA_REGIONRESULT

Name

MTPASA_REGIONRESULT

Comment

Region results for interval of max demand per day.


Description

MTPASA_REGIONRESULT is public data.


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

DAY

DEMAND_POE_TYPE

REGIONID

RUN_DATETIME

RUN_NO

RUNTYPE


Content

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).


Table: MTPASA_REGIONSUMMARY

MTPASA_REGIONSUMMARY

Name

MTPASA_REGIONSUMMARY

Comment

Region Results summary over aggregation periods.


Description

MTPASA_REGIONSUMMARY is public data.


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

AGGREGATION_PERIOD

DEMAND_POE_TYPE

PERIOD_ENDING

REGIONID

RUN_DATETIME

RUN_NO

RUNTYPE


Content

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