ACAD_PR_OV_LNVW

(SQL View)
 Index Back

Rel Lang Program Career View

The Academic Program Table Related Language View lists academic programs for an institution by academic career. This view is used as a prompt/edit table to restrict Academic Program within Institution, Academic Career. This view is also used to retrieve the Academic Level Rule to use in term statistics calculations.

SELECT A.INSTITUTION , A.ACAD_CAREER , A.ACAD_PROG , A.EFFDT , L.LANGUAGE_CD , L.DESCR FROM PS_ACAD_PROG_TBL A , PS_ACAD_PROG_LANG L WHERE A.INSTITUTION = L.INSTITUTION AND A.ACAD_PROG = L.ACAD_PROG AND A.EFFDT = L.EFFDT

  • Related Language Record for ACAD_PR_OV_VW

    • # 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_OVRD Character(4) VARCHAR2(4) NOT NULL In What-If Requirements Analysis, the target Career for the model.
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VETM=Veterinary Medicine
    3 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Prompt Table: ACAD_PROG_TBL

    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description