GPAU_RCPYE2_VW

(SQL View)
Index Back

Paygroup View

Paygroup View

SELECT DISTINCT B.CAL_RUN_ID , B.EMPLID , C.NAME FROM PS_GP_PYE_PRC_STAT B , PS_PERSON_NAME C WHERE B.EMPLID = C.EMPLID

# 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