SEV_SCH_OFF_VW

(SQL View)
 Index Back

SEVIS School Code Official

This record is a child to SEV_SCHL_CD_TBL. It contains the School Officials associated with a particular School Code.

SELECT A.SEV_SCHOOL_CD , A.SEV_DSO_EMPLID , B.NAME FROM PS_SEV_SCH_OFF_TBL A , PS_PERSONAL_VW B WHERE A.SEV_DSO_EMPLID = B.EMPLID

  • Parent record: SEV_SCHL_CD_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SEV_SCHOOL_CD Character(15) VARCHAR2(15) NOT NULL SEVIS School Code

    Prompt Table: SEV_SCHL_CD_TBL

    2 SEV_DSO_EMPLID Character(11) VARCHAR2(11) NOT NULL SEVIS School Official Emplid

    Prompt Table: PEOPLE_SRCH

    3 NAME Character(50) VARCHAR2(50) NOT NULL Name