SCE_IDDefault Value: OVERHEAD
Prompt Table: RTBL_CATS_VW
RTBL_SCE_DTLVW(SQL View) |
Index Back |
|---|---|
Scenario dataScenario details |
| SELECT SCE_ID ,RTBL_SCENARIO ,DESCRIPTION_RTB ,CATEGORY_SCENARIO ,'ANCHR_SCE' SCENARIO FROM PS_RTBL_SCENARIO UNION SELECT SCE_ID ,RTBL_SCENARIO ,DESCRIPTION_RTB ,CATEGORY_SCENARIO ,'COMP_SCE1' SCENARIO FROM PS_RTBL_SCENARIO UNION SELECT SCE_ID ,RTBL_SCENARIO ,DESCRIPTION_RTB ,CATEGORY_SCENARIO ,'COMP_SCE2' SCENARIO FROM PS_RTBL_SCENARIO |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCE_ID |
Character(10) | VARCHAR2(10) NOT NULL | ID |
| 2 | RTBL_SCENARIO | Character(18) | VARCHAR2(18) NOT NULL | Scenario Name |
| 3 | DESCRIPTION_RTB | Character(40) | VARCHAR2(40) NOT NULL | Description |
| 4 | CATEGORY_SCENARIO | Character(50) | VARCHAR2(50) NOT NULL |
Category
Default Value: OVERHEAD Prompt Table: RTBL_CATS_VW |
| 5 | 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 |