ACAD_PROG_OWNER

(SQL Table)
Index Back

Academic Prog Ownr Tbl

The Academic Program Table defines all academic programs that an institution offers. Students are admitted to Academic Programs.

  • 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

    Default Value: OPR_DEF_TBL_CS.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 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization

    Prompt Table: ACAD_ORG_TBL_VW

    5 PERCENT_OWNED Number(7,3) DECIMAL(6,3) NOT NULL Percent Owned