EM_PYCY_SUM2_VW

(SQL View)
 Index Back

View of Paycycle w/o security

View of Pay Cycles awaiting approval without referring to Paycycle/ User security

SELECT b.pay_cycle , b.pay_cycle_seq_num , a.oprid , c.currency_pymnt , SUM(c.paid_amt) , COUNT(*) FROM ps_pycycl_stat b , PS_PYCYCL_DATA c , ps_sec_bu_opr a WHERE c.business_unit = a.business_unit AND b.pay_cycle_seq_num=( SELECT MAX(ss1.pay_cycle_seq_num) FROM ps_pycycl_stat ss1 WHERE ss1.pay_cycle=b.pay_cycle ) AND b.pay_run_ap_status IN ('R','1') AND c.pay_cycle = b.pay_cycle AND c.pay_cycle_seq_num = b.pay_cycle_seq_num AND NOT EXISTS ( SELECT 'X' FROM psprcsrqst r WHERE r.runcntlid=b.pay_cycle AND runstatus IN ('5','6','7') ) GROUP BY b.pay_cycle, b.pay_cycle_seq_num, a.oprid, c.currency_pymnt

  • 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    4 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
    5 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
    6 NUM_OF_VOUCHERS Number(8,0) INTEGER NOT NULL Sched Pymnts