CLSTMNADVTVWLNG

(SQL View)
 Index Back

Static Course List View/Advis

This view is a copy of view CLST_MN_ADV_VW in which institution is not a key. It is being used temporarily by the panel RQ_COURSE_LIST because the original view (above) was malfunctioning in a prompt. When the prompt problem is solved, then this view should be deleted.

Select A.Acad_Career ,A.Acad_Prog ,A.Acad_Plan ,A.Acad_Sub_Plan ,B.Course_List ,B.LANGUAGE_CD ,B.Descr from PS_CLST_MAIN_TBL A, PS_CLST_MAIN_LANG B where A.RQRMNT_USEAGE <> 'STD' AND A.COURSE_LIST = B.COURSE_LIST AND A.EFFDT = B.EFFDT

  • Related Language Record for CLST_MN_ADVT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACAD_CAREER_SRCH Character(4) VARCHAR2(4) NOT NULL Academic Career
    2 ACAD_PROG_SRCH Character(5) VARCHAR2(5) NOT NULL Academic Program
    3 ACAD_PLAN_SRCH Character(10) VARCHAR2(10) NOT NULL Academic Plan
    4 ACAD_SUBPLN_SRCH Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan
    5 COURSE_LIST Character(9) VARCHAR2(9) NOT NULL Course List
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description