Skip to content

STPASA_CASESOLUTION

STPASA_CASESOLUTION holds one record containing results pertaining to each entire solution.

Package

STPASA_SOLUTION

Visibility

Public

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
RUN_DATETIME datetime(3) 🔑 datetime2(0) 🔑 Unique Timestamp Identifier for this study
PASAVERSION varchar(10) varchar(10) Version of the PASA solver used to solve this case
RESERVECONDITION numeric(1, 0) tinyint Low Reserve Condition (LRC) flag for the case (1 - LRC in the case, 0 - No LRCs in the case) for capacity run
LORCONDITION numeric(1, 0) tinyint 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 numeric(12, 3) numeric(12, 3) Objective Function from the Capacity Adequacy run
CAPACITYOPTION numeric(12, 3) numeric(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 numeric(12, 3) numeric(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 numeric(12, 3) numeric(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 numeric(12, 3) numeric(12, 3) The penalty for non-zero interconnector flow
LASTCHANGED datetime(3) datetime2(0) Date and time the record was created or modified
RELIABILITYLRCDEMANDOPTION numeric(12, 3) numeric(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 numeric(12, 3) numeric(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 numeric(12, 3) numeric(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 varchar(10) varchar(10) Generation Availability to be used in Reliability LRC run (either PASA or MARKET)
OUTAGELRCCAPACITYOPTION varchar(10) varchar(10) Generation Availability to be used in Outage LRC run (either PASA or MARKET)
LORCAPACITYOPTION varchar(10) varchar(10) Generation Availability to be used in LOR run (either PASA or MARKET)
LORUIGFOPTION numeric(3, 0) smallint UIGF POE forecast availability used for this option
RELIABILITYLRCUIGFOPTION numeric(3, 0) smallint UIGF POE forecast availability used for this option
OUTAGELRCUIGFOPTION numeric(3, 0) smallint UIGF POE forecast availability used for this option

Official MMS data model indexes

Index name Index type Index columns (in order)
CASESOLUTION_PK clustered, unique, primary key RUN_DATETIME
STPASA_CASESOLUTION_LCX nonclustered LASTCHANGED

GR-MMS data model indexes

Index name Index type Index columns (in order)
IX_STPASA_CASESOLUTION_LASTCHANGED nonclustered LASTCHANGED
PK_STPASA_CASESOLUTION clustered, unique, primary key RUN_DATETIME

Historical-MMS data model indexes

Index name Index type Index columns (in order)
CASESOLUTION_PK clustered, unique, primary key RUN_DATETIME
STPASA_CASESOLUTION_LCX nonclustered LASTCHANGED