LMS_SCENARIO_IDLMS_SCENARIO_DTTMLMS_EVENT_IDLMS_CATEGORY_CDLMS_EVN_EFF_RES(SQL Table) |
Index Back |
|---|---|
LMS - Event Effects Result TblLMS - Salary Forecating Event Effects Result Table |
| # | 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 | LMS_CATEGORY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Category Code |
| 5 | LMS_LEVEL_EFF_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Level Effect |
| 6 | LMS_MASS_EFF_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Mass Effect |
| 7 | LMS_CAROVR_EFF_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Carry-over Effect |