LMS_SCENARIO_IDLMS_SCENARIO_DTTMLMS_EVENT_IDLMS_SC_EVT_HIST(SQL Table) |
Index Back |
|---|---|
Scenario History RecordSalary Forecasting: This record is used to keep track of previous scenario definitions for comparaison purpose. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LMS_SCENARIO_ID |
Character(10) | VARCHAR2(10) NOT NULL | LMS - Scenario Id |
| 2 | LMS_SCENARIO_DTTM |
DateTime(26) | TIMESTAMP NOT NULL | Scenario Run DateTime |
| 3 | LMS_EVENT_ID |
Character(12) | VARCHAR2(12) NOT NULL | LMS Event Id |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 5 | LMS_ACTIVATION_DT | Date(10) | DATE | Triggering Period |