HOME_CAMPUS_TBL

(SQL Table)
 Index Back

Home Campus Table

Home Campus Table maintains basic location info re Academic Programs within Institutions. A row in this table represents a campus where an Academic Program could be offered.

  • Parent record: ACAD_PROG_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Prompt Table: ACAD_PROG_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: CAMPUS_TBL

    5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_SF_VW

    6 CAMPUS_FA Character(5) VARCHAR2(5) NOT NULL FA Campus

    Default Value: HOME_CAMPUS_TBL.CAMPUS

    Prompt Table: CAMPUS_TBL

    7 CAMPUS_REGISTRAR Character(5) VARCHAR2(5) NOT NULL Registrar Campus

    Default Value: HOME_CAMPUS_TBL.CAMPUS

    Prompt Table: CAMPUS_TBL

    8 CAMPUS_ADVISEMENT Character(5) VARCHAR2(5) NOT NULL Advisement Campus

    Default Value: HOME_CAMPUS_TBL.CAMPUS

    Prompt Table: CAMPUS_TBL