SEV_XFM_PPL_SCH

(SQL View)
 Index Back

SEVIS F M People 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. This view will only select people with a Visa Type of F-1 or M-1.

SELECT A.OPRCLASS ,A.EMPLID ,A.NAME ,A.SEX ,A.BIRTHDATE ,A.BIRTHDATE_MSK ,A.CAMPUS_ID ,B.NATIONAL_ID ,B.NATIONAL_ID_MSK ,B.COUNTRY ,B.NATIONAL_ID_TYPE ,B.NID_DESCRSHORT ,A.LAST_NAME_SRCH ,A.FIRST_NAME_SRCH FROM PS_PEOPLE_SRCH A , PS_PERS_NID_MSK_VW B , PS_SEV_VISATYPE_VW D WHERE A.OPRCLASS = B.OPRCLASS AND A.EMPLID = B.EMPLID AND D.EMPLID = A.EMPLID AND (D.SEV_VISA_TYPE = '01' OR D.SEV_VISA_TYPE = '02')

  • Related Language Record: SEV_XFM_PPL_SLN

    • # 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: PEOPLE_SRCH

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