Table: STPASA_CASESOLUTION

STPASA_CASESOLUTION

Name

STPASA_CASESOLUTION

Comment

STPASA_CASESOLUTION holds one record containing results pertaining to each entire solution


Description

STPASA_CASESOLUTION is public data.

Source

STPASA_CASESOLUTION is updated each STPASA run (i.e. every 2 hours).

Volume

Rows per day: 12

Mb per month: <1


Primary Key Columns

Name

RUN_DATETIME


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

RUN_DATETIME

DATE

X

Unique Timestamp Identifier for this study

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 if no assessment, 1 for 10%, 2 for 50%, 3 for 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 if no assessment, 1 for 10%, 2 for 50%, 3 for 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 if no assessment, 1 for 10%, 2 for 50%, 3 for 90%

INTERCONNECTORFLOWPENALTY

NUMBER(12,3)

 

The penalty for non-zero interconnector flow

LASTCHANGED

DATE

 

Date and time the record was created or modified

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