SS_STUDY_MTG_LN

(SQL View)
 Index Back

Class Meeting View2

(This view is used to populate the Student Enrollment Inquiry.) This Class Table view is used for prompting in the Enrollment Request Panelgroup. Only Class Sections in Student Enrollment are selected.

SELECT b.emplid ,b.acad_career ,a.institution ,a.strm ,a.subject ,a.catalog_nbr ,b.associated_class ,a.class_nbr ,c.class_mtg_nbr ,d.language_cd ,d.descr FROM PS_CLASS_TBL a , ps_stdnt_enrl b , ps_class_mtg_pat c , PS_CLASS_TBL_lang d WHERE a.strm = b.strm AND a.class_nbr = b.class_nbr AND b.stdnt_enrl_status <> 'D' AND a.crse_id = c.crse_id AND a.crse_offer_nbr = c.crse_offer_nbr AND a.strm = c.strm AND a.session_code = c.session_code AND a.class_section = c.class_section AND a.crse_id = d.crse_id AND a.crse_offer_nbr = d.crse_offer_nbr AND a.strm = d.strm AND a.session_code = d.session_code AND a.class_section = d.class_section

  • Related Language Record for SS_STUDY_MTG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    4 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_TBL

    5 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Prompt Table: SUBJECT_TBL

    6 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    7 ASSOCIATED_CLASS Number(4,0) SMALLINT NOT NULL Associated Class
    8 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    9 CLASS_MTG_NBR Number(2,0) SMALLINT NOT NULL Class Meeting Pattern Nbr
    10 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    11 DESCR Character(30) VARCHAR2(30) NOT NULL Description