GP_RUNCTL_VW02

(SQL View)
Index Back

Retrieve emplID for payroll PR

This 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