ADM_WEB_PLN_VW

(SQL View)
 Index Back

Academic Plan Table View

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 a.institution , b.acad_prog , a.acad_plan , a.effdt , a.eff_status , a.descr , a.acad_career FROM PS_ACAD_PLAN_TBL a ,ps_acad_prog_tbl b WHERE (%CurrentDateIn <= a.SSR_LAST_PRS_DT OR a.SSR_LAST_PRS_DT IS NULL) AND a.institution = b.institution AND (a.acad_prog = b.acad_prog OR (a.acad_prog = ' ' AND a.acad_career = b.acad_career)) AND a.effdt = ( SELECT MAX(c.effdt) FROM PS_ACAD_PLAN_TBL c WHERE c.institution = a.institution AND c.acad_plan = a.acad_plan AND c.effdt <= %CurrentDateIn)

  • Related Language Record: ADM_WEB_PLN_LNG

    • # 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 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine