ACAD_PLAN_TBXLN

(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 the related language record for ACAD_PLAN_TBXVW

SELECT DISTINCT A.INSTITUTION , B.ACAD_CAREER , A.ACAD_PLAN , A1.LANGUAGE_CD , A.EFFDT , A1.DESCR FROM PS_ACAD_PLAN_TBL A , PS_ACAD_PLAN_LANG A1 , PS_ACAD_PROG_TBL B WHERE A.INSTITUTION = B.INSTITUTION AND (A.ACAD_PROG = B.ACAD_PROG OR (A.ACAD_PROG = ' ' AND A.ACAD_CAREER = B.ACAD_CAREER)) AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ACAD_PROG_TBL B1 WHERE B.INSTITUTION = B1.INSTITUTION AND B.ACAD_PROG = B1.ACAD_PROG AND B1.EFFDT <= A.EFFDT) AND A.INSTITUTION = A1.INSTITUTION AND A.ACAD_PLAN = A1.ACAD_PLAN AND A.EFFDT = A1. EFFDT

  • Related Language Record for ACAD_PLAN_TBXVW

    • # 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_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
    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