SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
SCENARIOPrompt Table: BD_SCENARIO_TBL
SCENARIO_ALL_VW(SQL View) |
Index Back |
|---|---|
All Scenarios ViewAll values with the most current effective date in BD_SCENARIO_TBL |
| SELECT a.setid , a.scenario , a.descr , a.descrshort FROM PS_BD_SCENARIO_TBL a WHERE a.effdt = ( SELECT MAX(b.effdt) FROM PS_BD_SCENARIO_TBL b WHERE a.setid = b.setid AND a.scenario = b.scenario) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | SCENARIO |
Character(10) | VARCHAR2(10) NOT NULL |
A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca
Prompt Table: BD_SCENARIO_TBL |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |