EM_PYCY_SUM_VW

(SQL View)
 Index Back

EBPP-PayCycl Mgr Currt PayCycl

EBPP-Added 2000/10/04-Last Mod 2000/10/19 by Matthias Davet View used on the level 1 of the EM_PYCYCL_STAT page.

SELECT b.pay_cycle , b.pay_cycle_seq_num , a.oprid , c.currency_pymnt , SUM(c.paid_amt) , COUNT(*) ,MAX(b.pymnt_dt) ,c.business_unit FROM ps_pycycl_stat b , PS_PYCYCL_DATA c , ps_sec_pycycl_opr a WHERE a.pay_cycle = b.pay_cycle 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,c.business_unit

  • 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
    7 PYMNT_DT Date(10) DATE Payment Date
    8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit