PYCYCL_RSTRT_V2

(SQL View)
 Index Back

Restartable Pay Cycle Runs


SELECT a.pay_cycle , a.pay_cycle_seq_num , a.pay_run_ap_status , a.oprid , a.pay_run_dt FROM ps_pycycl_stat a WHERE (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'))))

  • 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 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number
    3 PAY_RUN_AP_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Run Status
    1=Exceptions found
    2=Nothing to process
    3=Process running
    6=Rejected
    7=Selected/Staged
    8=Waiting for Certification
    C=Completed
    D=Reset
    E=Error
    K=Restarted
    N=New
    R=Selected
    U=Created
    V=Trial Register Approved
    X=Printed
    Y=Confirmed
    Z=Positive Payment Formatted
    4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    5 PAY_RUN_DT Date(10) DATE Payment Run Date