ACAD_SUBP_SFVW2

(SQL View)
 Index Back

Academic Sub Plan Vw

An Academic Sub Plan is a focus within an academic plan. An example of a subplan might be an American history concentration within the history major (plan).

select a.institution, a.acad_plan, a.acad_sub_plan, a.descr from PS_ACAD_SUBPLN_TBL a where a.effdt = (select max(b.effdt) from PS_ACAD_SUBPLN_TBL b where b.institution = a.institution and b.acad_plan = a.acad_plan and b.acad_sub_plan = a.acad_sub_plan and b.effdt <= %currentdatein)

  • Related Language Record: ACADSUBPSFVW2LN

    • # 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_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
    3 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description