Skip to content

MTPASA_CASESOLUTION (Historical table)

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.

Package

HISTORICAL_TABLES

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
RUN_DATETIME datetime(3) 🔑 datetime2(0) 🔑 Date processing of the run begins. Generated from the solution file caseid
RUN_NO numeric(3, 0) 🔑 smallint 🔑 Unique run id. Generated from the solution file caseid
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 = no assessment, 1 = 10%, 2 = 50%, 3 = 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 = no assessment, 1 = 10%, 2 = 50%, 3 = 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 = no assessment, 1 = 10%, 2 = 50%, 3 = 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
RUNTYPE varchar(50) varchar(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 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)
MTPASA_CASESOLUTION_LCX nonclustered LASTCHANGED
MTPASA_CASESOLUTION_PK clustered, unique, primary key RUN_DATETIME, RUN_NO

GR-MMS data model indexes

Index name Index type Index columns (in order)
IX_MTPASA_CASESOLUTION_LASTCHANGED nonclustered LASTCHANGED
PK_MTPASA_CASESOLUTION clustered, unique, primary key RUN_DATETIME, RUN_NO

Historical-MMS data model indexes

Index name Index type Index columns (in order)
MTPASA_CASESOLUTION_LCX nonclustered LASTCHANGED
MTPASA_CASESOLUTION_PK clustered, unique, primary key RUN_DATETIME, RUN_NO