|
Name |
|
|
Comment |
STPASA_CASESOLUTION holds one record containing results pertaining to each entire solution |
|
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 |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
RUN_DATETIME |
|
Name |
|
LASTCHANGED |
|
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 |
|
|
|