RS_WM_WRKR_DEL(SQL View) |
Index Back |
|---|---|
Ineligible Worker view |
| SELECT A.EMPLID , A.EFFDT FROM %Table(RS_WRKR_EFFDT) A WHERE A.SYSTEM_SOURCE = 'WM' AND %EffdtCheck(RS_WRKR_EFFDT Z, A, %CURRENTDATEIN) AND A.WRKR_INELIGIBLE = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EFFDT | Date(10) | DATE | Effective Date |