GVT_PAY_RUNIDVW

(SQL View)
 Index Back

PAM SPS Pay Run Id


SELECT DISTINCT A.RUN_ID , A.DESCR FROM PS_PAY_RUN_TBL A WHERE NOT EXISTS ( SELECT 'X' FROM PS_GVT_SCHED_DEFN B WHERE B.RUN_ID = A.RUN_ID) AND EXISTS( SELECT 'X' FROM PS_PAY_CALENDAR C WHERE C.RUN_ID = A.RUN_ID AND C.GVT_TRES_RUN <> 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description