LMS_WRK_PERIOD_IDPrompt Table: LMS_WRK_PD_TBL
LMS_ELEMNT_PD_TYPEPrompt Table: LMS_FREQUENC_VW
LMS_ACTIVATION_DTLMS_ACTIVATION(SQL Table) |
Index Back |
|---|---|
Activation date recordSalary Forcasting: This record does the link between working periods and dates at which an event can occur. |
| # | 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_ELEMNT_PD_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Type of Elementary Period
Prompt Table: LMS_FREQUENC_VW |
| 3 | LMS_ACTIVATION_DT |
Date(10) | DATE NOT NULL | Triggering Period |