CLSTMNENRVW_LNG

(SQL View)
 Index Back

Static Course List View/Enroll

Use this view to search for courselists by institution. This version has the Enrollment alternate keys first.

Select Distinct A.Institution ,A.Acad_Group ,A.Subject ,A.Catalog_Nbr ,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_ENR_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_GROUP_SRCH Character(5) VARCHAR2(5) NOT NULL Academic Group
    3 SUBJECT_SRCH Character(8) VARCHAR2(8) NOT NULL Subject Area
    4 CATALOG_NBR_SRCH Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    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