SEV_EMPL_SRCH

(SQL View)
 Index Back

SEVIS Empl Srch

SEV_EMPL_SRCH is a security view used by the Employment Authorization component to allow users to access only records from Employment Authorization that contain the School Codes that they are cleared to see.

SELECT B.OPRCLASS , A.EMPLID , A.SEV_SCHOOL_CD , C.OPRID , B.NAME , B.SEX , B.BIRTHDATE , B.BIRTHDATE_MSK , B.CAMPUS_ID , E.NATIONAL_ID , E.NATIONAL_ID_MSK , E.COUNTRY , E.NATIONAL_ID_TYPE , E.NID_DESCRSHORT , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH FROM PS_SEV_EMPL_AUTH A , PS_PEOPLE_SRCH B , PS_SEV_SCHLCD_SCTY C , PS_PERS_NID_MSK_VW E WHERE B.OPRCLASS = E.OPRCLASS AND C.ACCESS_CD = 'Y' AND A.EMPLID = B.EMPLID AND (C.SEV_SCHOOL_CD = A.SEV_SCHOOL_CD OR C.SEV_SCHOOL_CD = 'ALL') AND A.EMPLID = E.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: SEV_XFM_PPL_SCH

3 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

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