SP_DEPYCL_CLSVW

(SQL View)
 Index Back

Security View for Pay Cycle


SELECT d.oprclass , a.pay_cycle , a.descr FROM PS_PYCYCL a , PS_PYCYCL_stat b , ps_sec_pycycl_cls 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 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
2 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description