CAL_RUN_IDEMPLIDGP_RUNCTL_VW04(SQL View) |
Index Back |
|---|---|
Retrieve emplID for absence PRThis view retrieves emplIDs for absence pay runs. Used in SQR run control to retrieve emplIDs for absence pay runs associated with the entered Calendar Group ID |
| SELECT DISTINCT PPS.CAL_RUN_ID , PPS.EMPLID , N.NAME FROM PS_GP_PYE_PRC_STAT PPS , PS_PERSON_NAME N WHERE PPS.CALC_TYPE = 'A' AND PPS.EMPLID = N.EMPLID AND PPS.SEL_STAT IN ('A','I') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |