PYCYCL_EMAIL_VW

(SQL View)
 Index Back

Restartable Pay Cycle Runs


SELECT DISTINCT a.pay_cycle ,a.pay_cycle_seq_num ,'C' ,a.oprid ,a.pay_run_dt FROM ps_pycycl_stat a WHERE a.pay_run_ap_status = 'C' OR (a.pay_run_ap_status = 'N' AND a.pay_cycle IN ( SELECT b.pay_cycle FROM PS_PYCYCL_STATRPT b WHERE a.pay_cycle = b.pay_cycle AND a.pay_cycle_seq_num = b.pay_cycle_seq_num AND b.pay_run_ap_status = 'C'))

  • 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