PYCYCL_STAT_VW2

(SQL View)
 Index Back

PayCycle Mgr Current PayCycles


SELECT b.pay_cycle , b.pay_cycle_seq_num , b.pay_run_ap_status , b.commit_status , a.pay_thru_dt , a.pymnt_dt , b.oprid , a.descr , b.pay_run_dt , b.dscnt_alrt_flg , b.neg_bal_flg , b.cnv_err_flg , bad_curr_flg , process_instance FROM PS_PYCYCL a , PS_PYCYCL_stat b WHERE a.pay_cycle = b.pay_cycle AND b.pay_cycle_seq_num = ( SELECT MAX(c.pay_cycle_seq_num) FROM PS_PYCYCL_stat c WHERE c.pay_cycle = b.pay_cycle)

  • 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: PYCYCL

    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 COMMIT_STATUS Number(2,0) SMALLINT NOT NULL Commit Status
    5 PAY_THRU_DT Date(10) DATE Pay Through Date
    6 PYMNT_DT Date(10) DATE Payment Date
    7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 PAY_RUN_DT Date(10) DATE Payment Run Date
    10 DSCNT_ALRT_FLG Character(1) VARCHAR2(1) NOT NULL Discount Alert
    N=No discounts lost
    Y=Discounts will be lost
    11 NEG_BAL_FLG Character(1) VARCHAR2(1) NOT NULL Negative Balances
    N=No negative balances
    Y=Negative supplier balance(s)
    12 CNV_ERR_FLG Character(1) VARCHAR2(1) NOT NULL Conversion Error
    N=No conversion errors
    Y=Currency conversion error
    13 BAD_CURR_FLG Character(1) VARCHAR2(1) NOT NULL Wrong Currency
    N=Payment currencies OK
    Y=Wrong payment currency
    14 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance