SP_WTH_RP_OPRVW

(SQL View)
Index Back

Wthd_calc_rpt prompt view


SELECT DISTINCT b.oprid , a.pay_cycle , a.pay_cycle_seq_num , a.wthd_decl_date FROM PS_WTHD_CALC_RPT a , ps_sec_pycycl_opr b WHERE a.pay_cycle = b.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 AE_PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL App Engine Pay Cycle
3 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number
4 WTHD_DECL_DATE Date(10) DATE withholding declaration date