SEV_PRG_INS_VW

(SQL View)
 Index Back

SEVIS Prog Sponsor Institution

This is a view of the distinct Institutions from the SEV_PRG_INS_TBL

SELECT DISTINCT SEV_PRG_NBR , INSTITUTION FROM PS_SEV_PRG_INS_TBL

  • Parent record: SEV_SCHL_CD_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SEV_PRG_NBR Character(9) VARCHAR2(9) NOT NULL SEVIS Program Number
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL