SEV_SCHLCD_SRC2

(SQL View)
 Index Back

SEVIS Schoold Cd Srch2

SEV_SCHLCD_SRC2 is a security view used by several SEVIS components to allow users to access only records from the Student Career Term and the School Codes that they are allowed to see.

SELECT A.EMPLID , F.SEV_SCHOOL_CD , E.OPRID , B.NAME , B.SEX , B.BIRTHDATE , B.BIRTHDATE_MSK , B.CAMPUS_ID , B.NATIONAL_ID , B.NATIONAL_ID_MSK , B.NID_COUNTRY , B.NATIONAL_ID_TYPE , B.NID_DESCRSHORT , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH , A.INSTITUTION , A.ACAD_CAREER FROM PS_STDNT_CAR_TERM A , PS_PEOPLE_SRCH B , PS_SEV_SCHLCD_SCTY E , PS_SEV_SCH_INS_TBL F WHERE B.EMPLID = A.EMPLID AND E.ACCESS_CD = 'Y' AND (E.SEV_SCHOOL_CD = F.SEV_SCHOOL_CD OR E.SEV_SCHOOL_CD = 'ALL') AND F.INSTITUTION = A.INSTITUTION AND F.ACAD_CAREER = A.ACAD_CAREER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

2 SEV_SCHOOL_CD Character(15) VARCHAR2(15) NOT NULL SEVIS School Code

Default Value: OPR_DEF_TBL_CS.SEV_SCHOOL_CD

Prompt Table: SEV_SCH_SCTY_PR

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 NAME Character(50) VARCHAR2(50) NOT NULL Name
5 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
6 BIRTHDATE Date(10) DATE Date of Birth
7 BIRTHDATE_MSK Character(10) VARCHAR2(10) NOT NULL Date of Birth
8 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID
9 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
10 NATIONAL_ID_MSK Character(20) VARCHAR2(20) NOT NULL National ID
11 NID_COUNTRY Character(3) VARCHAR2(3) NOT NULL National ID Country
12 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
13 NID_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL NID Short Description
14 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
15 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
16 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
17 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