SF_DUE_CHG_SRCH

(SQL View)
Index Back

Due Charge ID Search


SELECT A.EMPLID ,B.OPRID ,A.NAME FROM PS_SCC_PRI_NAME_VW A , PSOPRDEFN B WHERE A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 NAME Character(50) VARCHAR2(50) NOT NULL Name