LMS_SCENARIO_IDLMS_SCENARIO_DTTMLMS_EFF_RES(SQL Table) |
Index Back |
|---|---|
LMS - Result tableSalary Forcasting: This record contains results of a salary forecasting simulation. |
| # | 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_LEVEL_EFF_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Level Effect |
| 4 | LMS_MASS_EFF_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Mass Effect |
| 5 | LMS_CAROVR_EFF_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Carry-over Effect |
| 6 | LMS_COUNT_EFF_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Headcount Effect |
| 7 | LMS_STRUCT_EFF_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Structure Effect |
| 8 | LMS_NORIA_EFF_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Noria Effect |