SP_DEPYCL_OPRVW

(SQL View)
 Index Back

Security view for Pay Cycle


SELECT d.oprid , a.pay_cycle , a.descr FROM PS_PYCYCL a , PS_PYCYCL_stat b , ps_sec_pycycl_opr d WHERE a.pay_cycle = b.pay_cycle AND b.pay_cycle = d.pay_cycle AND b.pay_run_ap_status IN ('C', '2', 'N', 'D') AND b.PAY_CYCLE_SEQ_NUM = ( SELECT MAX(PAY_CYCLE_SEQ_NUM) FROM PS_PYCYCL_stat c WHERE b.pay_cycle = c.pay_cycle)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description