PYCYCL_RESET_VW

(SQL View)
 Index Back

Pay Cycle Reset


select a.pay_cycle, a.pay_cycle_seq_num, b.descr, a.pay_run_ap_status, a.pay_thru_dt, a.pymnt_dt, a.oprid, a.pay_run_dt, a.accounting_dt, a.commit_status from PS_PYCYCL_stat a, PS_PYCYCL b where a.pay_run_ap_status in ('R','U') and a.pay_cycle = b.pay_cycle and a.commit_status = 0

  • 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    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
    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 PAY_RUN_DT Date(10) DATE Payment Run Date
    9 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
    10 COMMIT_STATUS Number(2,0) SMALLINT NOT NULL Commit Status