ADM_WEB_PLN_LNG

(SQL View)
 Index Back

Rel Lang Academic Plan View

This is the related language view used by ADM_WEB_PLN_TBL. This Academic Plan Table View is used as a prompt table that selects all plans that are associated with an Academic Program as well as plans that are shared across all Academic Programs within an Institution. This is used by Web Prospect Create.

SELECT c.institution , b.acad_prog , a.acad_plan , c.language_cd , c.effdt , c.descr FROM PS_ACAD_PLAN_TBL a ,ps_acad_prog_tbl b ,ps_acad_plan_lang c WHERE a.institution = b.institution AND a.institution = c.institution AND a.acad_plan = c.acad_plan AND a.effdt = c.effdt AND (a.acad_prog = b.acad_prog OR (a.acad_prog = ' ' AND a.acad_career = b.acad_career)) AND c.effdt = ( SELECT MAX(d.effdt) FROM ps_acad_plan_lang d WHERE d.institution = a.institution AND d.acad_plan = a.acad_plan AND d.effdt <= %CurrentDateIn)

  • Related Language Record for ADM_WEB_PLN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    3 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

    Prompt Table: ACAD_PLAN_TBL

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description