QUIK_ENRL_SRCH

(SQL View)
 Index Back

Student Search View

Common view used when searching for/selecting a person for display/update. This view should be used as the basis for all other views which go against people. The PeopleCode contained on this view is important for any other view which is based on this one - the searching/formatting for names and setting the carry id is done with this code.

SELECT D.OPRCLASS , A.ENRL_REQUEST_ID , B.EMPLID , B.INSTITUTION , B.ACAD_CAREER , B.STRM , D.NAME , D.SEX , D.BIRTHDATE , D.BIRTHDATE_MSK , D.CAMPUS_ID , D.NATIONAL_ID , D.NATIONAL_ID_MSK , D.NID_COUNTRY , D.NATIONAL_ID_TYPE , D.NID_DESCRSHORT , D.LAST_NAME_SRCH , D.FIRST_NAME_SRCH FROM PS_ENRL_REQ_HEADER A , PS_ENRL_REQ_DETAIL B , PS_STDNT_CAR_TERM C , PS_PEOPLE_SRCH D WHERE (A.ENRL_REQ_SOURCE = 'E' OR A.ENRL_REQ_SOURCE = 'QE') AND A.ENRL_REQUEST_ID = B.ENRL_REQUEST_ID AND B.EMPLID = C.EMPLID AND B.EMPLID = D.EMPLID AND B.ACAD_CAREER = C.ACAD_CAREER AND B.INSTITUTION = C.INSTITUTION AND B.STRM = C.STRM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
2 ENRL_REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Enrollment Request ID
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

5 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
6 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: TERM_TBL

7 NAME Character(50) VARCHAR2(50) NOT NULL Name
8 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
9 BIRTHDATE Date(10) DATE Date of Birth
10 BIRTHDATE_MSK Character(10) VARCHAR2(10) NOT NULL Date of Birth
11 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID
12 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
13 NATIONAL_ID_MSK Character(20) VARCHAR2(20) NOT NULL National ID
14 NID_COUNTRY Character(3) VARCHAR2(3) NOT NULL National ID Country
15 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
16 NID_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL NID Short Description
17 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
18 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name