ACAD_PROG_V3LNG

(SQL View)
 Index Back

Academic Program Table View

The Academic Program Table View lists all active academic programs that an institution has ever offered regardless of effective date.

SELECT A.INSTITUTION ,B.ACAD_CAREER , A.ACAD_PROG , c.language_cd , A.DESCR FROM PS_ACAD_PROG_TBL A , PS_ACAD_CAR_TBL B , PS_ACAD_PROG_LANG C WHERE A.INSTITUTION = C.INSTITUTION AND A.ACAD_PROG = C.ACAD_PROG AND A.INSTITUTION = B.INSTITUTION AND A.ACAD_CAREER = B.ACAD_CAREER AND B.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_ACAD_CAR_TBL X WHERE X.INSTITUTION = B.INSTITUTION AND X.ACAD_CAREER=B.ACAD_CAREER AND X.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record for ACAD_PROG_TBLV3

    • # 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_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description