PYCYCL_STAT_VW

(SQL View)
 Index Back

AP-View to see paycycle status


SELECT b.pay_cycle , a.descr , b.pay_cycle_seq_num , b.pay_run_ap_status FROM PS_PYCYCL a , PS_PYCYCL_stat b WHERE a.pay_cycle = b.pay_cycle AND a.active_flag <> 'I'

  • Related Language Record: PYCYCL_STAT_LG

  • Parent record: PYCYCL

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

    Prompt Table: SP_PYCYCL_NONVW

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number
    4 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