SF_OPT_FEE_SRCH

(SQL View)
Index Back

Optional Fees ID Search


SELECT DISTINCT B.EMPLID ,A.INSTITUTION ,C.OPRID ,B.NAME FROM PS_STDNT_CAR_TERM A , PS_SCC_PRI_NAME_VW B , PSOPRDEFN C WHERE A.EMPLID = B.EMPLID AND B.EMPLID = C.EMPLID

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