CLSTMNADVVWLANG

(SQL View)
 Index Back

Static Course List View/Advis

Use this view to search for courselists by institution

Select Distinct A.Institution ,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_ADV_VW SAA_CLST_LKP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 ACAD_CAREER_SRCH Character(4) VARCHAR2(4) NOT NULL Academic Career
    3 ACAD_PROG_SRCH Character(5) VARCHAR2(5) NOT NULL Academic Program
    4 ACAD_PLAN_SRCH Character(10) VARCHAR2(10) NOT NULL Academic Plan
    5 ACAD_SUBPLN_SRCH Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan
    6 COURSE_LIST Character(9) VARCHAR2(9) NOT NULL Course List
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description