LMS_SCENARIO_IDPrompt Table: GB_GROUP_SEC_VW
Prompt Table: LMS_WRK_PD_TBL
LMS_SCENARIO(SQL Table) |
Index Back |
|---|---|
Scenario RecordSalary Forecasting: This record is used to store scenarion definition. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LMS_SCENARIO_ID |
Character(10) | VARCHAR2(10) NOT NULL | LMS - Scenario Id |
| 2 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GB_GROUP_SEC_VW |
| 3 | LMS_WRK_PERIOD_ID | Character(10) | VARCHAR2(10) NOT NULL |
Working Periods ID
Prompt Table: LMS_WRK_PD_TBL |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 5 | DESCRLONG | Long Character | CLOB | Long Description |