MTPASA_LOLPRESULT

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

Package

MTPASA

Public

Column	Official MMS Datatype	GR-MMS Datatype	Comment
RUN_DATETIME	datetime(3)	datetime2(0)	Date processing of the run begins.
RUN_NO	numeric(4, 0)	smallint	Unique run id.
RUNTYPE	varchar(20)	varchar(20)	Type of run. Always LOLP
DAY	datetime(3)	datetime2(0)	Day this result is for
REGIONID	varchar(20)	varchar(20)	The unique region identifier
WORST_INTERVAL_PERIODID	numeric(3, 0)	smallint	The half hourly interval period with the highest LOLP, or highest region demand if LOLP = 0 for all intervals (1..48)
WORST_INTERVAL_DEMAND	numeric(12, 2)	numeric(12, 2)	The Abstract Operational Demand for the worst interval in this region (MW)
WORST_INTERVAL_INTGEN	numeric(12, 2)	numeric(12, 2)	The half hourly aggregate intermittent generation for the worst interval in this region (MW)
WORST_INTERVAL_DSP	numeric(12, 2)	numeric(12, 2)	The half hourly aggregate demand side participation for the worst interval period in this region (MW)
LOSSOFLOADPROBABILITY	numeric(8, 5)	numeric(8, 5)	Loss of Load Probability for the worst interval in this region
LOSSOFLOADMAGNITUDE	varchar(20)	varchar(20)	Loss of Load Magnitude for the worst interval in this region. Values are LOW, MEDIUM, HIGH
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Index name	Index type	Index columns (in order)
MTPASA_LOLPRESULT_PK	clustered, unique, primary key	RUN_DATETIME, RUN_NO, RUNTYPE, DAY, REGIONID

Index name	Index type	Index columns (in order)
PK_MTPASA_LOLPRESULT	clustered, unique, primary key	RUN_DATETIME, RUN_NO, RUNTYPE, DAY, REGIONID

Index name	Index type	Index columns (in order)
MTPASA_LOLPRESULT_PK	clustered, unique, primary key	RUN_DATETIME, RUN_NO, RUNTYPE, DAY, REGIONID