GP_RUNCTL_VW02(SQL View) |
Index Back |
---|---|
Retrieve emplID for payroll PRThis view retrieves emplIDs for payroll pay runs. Used in SQR run control to retrieve emplIDs for payroll pay runs associated with the entered Calendar Group ID. |
SELECT DISTINCT PPS.CAL_RUN_ID , PPS.EMPLID , D.NAME FROM PS_GP_PYE_PRC_STAT PPS , PS_PERSON_NAME D WHERE PPS.CALC_TYPE = 'P' AND PPS.EMPLID = D.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 |