SP_PYRSRT_NONV2

(SQL View)
 Index Back

Restartable Pay Cycle Runs


SELECT DISTINCT a.pay_cycle , b.descr FROM ps_pycycl_stat a , ps_pycycl b WHERE a.pay_cycle = b.pay_cycle AND (a.pay_run_ap_status = 'C' OR (a.pay_run_ap_status = 'X' AND NOT EXISTS ( SELECT 'X' FROM PS_PYCYCL_STATRPT C WHERE C.PAY_CYCLE = A.PAY_CYCLE AND C.PAY_CYCLE_SEQ_NUM = A.PAY_CYCLE_SEQ_NUM AND C.PAY_RUN_AP_STATUS IN ('U', 'V', 'X', 'Y', 'Z')))) AND b.active_flag<> 'I'

  • Parent record: PYCYCL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description