SSF_SAH_RES_VW

(SQL View)
Index Back

SA-HELP Run Control page

View to display Defaults from Loan Defaults page for SA-HELP.

SELECT B.OPRCLASS ,A.BUSINESS_UNIT ,A.EMPLID ,B.NATIONAL_ID ,B.CAMPUS_ID ,B.LAST_NAME_SRCH ,B.FIRST_NAME_SRCH FROM PS_SSF_SAH_RES A ,PS_PEOPLE_SRCH B WHERE A.EMPLID = B.EMPLID GROUP BY B.OPRCLASS, A.BUSINESS_UNIT ,A.EMPLID , B.NATIONAL_ID, B.CAMPUS_ID ,B.LAST_NAME_SRCH ,B.FIRST_NAME_SRCH

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
5 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID
6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
7 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name