BUS_UNIT_FA_VW

(SQL View)
 Index Back

Business Unit for Awards

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.

Select institution ,acad_prog ,effdt ,campus ,business_unit from PS_HOME_CAMPUS_TBL

  • 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_PRIMARY Character(5) VARCHAR2(5) NOT NULL Primary Academic Program
    3 EFFDT Date(10) DATE NOT NULL Effective 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