Table: MTPASA_REGIONSUMMARY

MTPASA_REGIONSUMMARY

Name

MTPASA_REGIONSUMMARY

Comment

Region Results summary over aggregation periods.


Description

MTPASA_REGIONSUMMARY is public data.


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