Table: MTPASA_CASESOLUTION

MTPASA_CASESOLUTION

Name

MTPASA_CASESOLUTION

Comment

MTPASA_CASESOLUTION is obsolete from 2017 End of Year DM4.27 Release.
MTPASA_CASESOLUTION holds one record for each entire solution.
Change Notice 379 announced the replacement of the MT PASA data model so all MTPASAxxx tables become obsolete, replaced by MTPASA_xxx tables.


Description

MTPASA_CASESOLUTION is public data.

Source

MTPASA_CASESOLUTION is updated each MTPASA run (i.e. weekly).

Volume

Rows per week: 1

Rows per month: 5

Monthly space increment is based on storing all the MT PASA solutions. To store only the latest solution, divide these figures by 5 (number of weeks per month rounded up).


Primary Key Columns

Name

RUN_DATETIME

RUN_NO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

RUN_DATETIME

DATE

X

Date processing of the run begins. Generated from the solution file caseid

RUN_NO

NUMBER(3,0)

X

Unique run id. Generated from the solution file caseid

PASAVERSION

VARCHAR2(10)

 

Version of the PASA solver used to solve this case

RESERVECONDITION

NUMBER(1,0)

 

Low Reserve Condition (LRC) flag for the case (1 - LRC in the case, 0 - No LRCs in the case) for capacity run

LORCONDITION

NUMBER(1,0)

 

Lack of Reserve Condition (LOR) flag for the case indicates the most severe condition in the case (3 = LOR3, 2 = LOR2, 1 = LOR1, 0 = No LOR)

CAPACITYOBJFUNCTION

NUMBER(12,3)

 

Objective Function from the Capacity Adequacy run

CAPACITYOPTION

NUMBER(12,3)

 

Not populated as of 2005 End of Year Release; was the demand forecast used for capacity adequacy assessment: 0 = no assessment, 1 = 10%, 2 = 50%, 3 = 90%

MAXSURPLUSRESERVEOPTION

NUMBER(12,3)

 

Not populated as of 2005 End of Year Release; was the demand forecast used for assessment of Maximum surplus Reserve: 0 = no assessment, 1 = 10%, 2 = 50%, 3 = 90%

MAXSPARECAPACITYOPTION

NUMBER(12,3)

 

Not populated as of 2005 End of Year Release; was the demand forecast used for assessment of Maximum Spare Capacity: 0 = no assessment, 1 = 10%, 2 = 50%, 3 = 90%

INTERCONNECTORFLOWPENALTY

NUMBER(12,3)

 

The penalty for non-zero interconnector flow

LASTCHANGED

DATE

 

Date and time the record was created or modified

RUNTYPE

VARCHAR2(50)

 

Discontinued in Dec 2005; was description of the constraints included in this run, being either System Normal and Planned Outage Constraints or System Normal Constraints Only

RELIABILITYLRCDEMANDOPTION

NUMBER(12,3)

 

Specifies the Probability of Exceedence (POE) demand forecast for Reliability LRC assessment (0 if no assessment, 10 for 10%, 50 for 50%, 90 for 90%)

OUTAGELRCDEMANDOPTION

NUMBER(12,3)

 

Specifies the Probability of Exceedence (POE) demand forecast for outage LRC assessment (0 if no assessment, 10 for 10%, 50 for 50%, 90 for 90%)

LORDEMANDOPTION

NUMBER(12,3)

 

Specifies the Probability of Exceedence (POE) demand forecast for LOR assessment (0 if no assessment, 10 for 10%, 50 for 50%, 90 for 90%)

RELIABILITYLRCCAPACITYOPTION

VARCHAR2(10)

 

Generation Availability to be used in Reliability LRC run (either PASA or MARKET)

OUTAGELRCCAPACITYOPTION

VARCHAR2(10)

 

Generation Availability to be used in Outage LRC run (either PASA or MARKET)

LORCAPACITYOPTION

VARCHAR2(10)

 

Generation Availability to be used in LOR run (either PASA or MARKET)

LORUIGFOPTION

NUMBER(3,0)

 

UIGF POE forecast availability used for this option

RELIABILITYLRCUIGFOPTION

NUMBER(3,0)

 

UIGF POE forecast availability used for this option

OUTAGELRCUIGFOPTION

NUMBER(3,0)

 

UIGF POE forecast availability used for this option