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

Data in this table is:

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)