Skip to content

PDPASA_CASESOLUTION

The top-level table identifying a PDPASA case, reporting options applied in the case and summary results.

Package

PDPASA

Visibility

Public

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
RUN_DATETIME datetime(3) 🔑 datetime2(0) 🔑 Case identifier by the time the case was run
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 Probability of Exceedance (POE) demand forecast used for capacity adequacy (LRC) assessment. 0 if no assessment, 1 for 10% POE, 2 for 50% POE, 3 for 90% POE.
MAXSURPLUSRESERVEOPTION numeric(12, 3) numeric(12, 3) Not populated as of 2005 End of Year Release; was the Probability of Exceedance (POE) demand forecast used for assessment of Maximum surplus Reserve. 0 if no assessment, 1 for 10% POE, 2 for 50% POE, 3 for 90% POE
MAXSPARECAPACITYOPTION numeric(12, 3) numeric(12, 3) Not populated as of 2005 End of Year Release; was the Probability of Exceedance (POE) demand forecast used for assessment of Maximum Spare Capacity. 0 if no assessment, 1 for 10% POE, 2 for 50% POE, 3 for 90% POE
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)
PDPASA_CASESOLUTION_LCX nonclustered LASTCHANGED
PDPASA_CASESOLUTION_PK clustered, unique, primary key RUN_DATETIME

GR-MMS data model indexes

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

Historical-MMS data model indexes

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