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.


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