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

Data in this table is:

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