LMS_WRK_PERIOD_IDPrompt Table: LMS_WRK_PD_TBL
LMS_EVENT_IDPrompt Table: LMS_EVENT_TBL
LMS_EVENT_L_VW(SQL View) |
Index Back |
|---|---|
Leave Events EventSalary Forcasting: This view returns only Leave Events from record LMS_EVENT_TBL |
| SELECT LMS_WRK_PERIOD_ID , LMS_EVENT_ID FROM PS_LMS_EVENT_TBL WHERE LMS_EVENT_TYPE = 'L' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LMS_WRK_PERIOD_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Working Periods ID
Prompt Table: LMS_WRK_PD_TBL |
| 2 | LMS_EVENT_ID |
Character(12) | VARCHAR2(12) NOT NULL |
LMS Event Id
Prompt Table: LMS_EVENT_TBL |