CLSS_TBSEVW2_LN

(SQL View)
 Index Back

Class Table Student Enrl View

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.CLASS_NBR ,AL.LANGUAGE_CD ,AL.DESCR FROM PS_CLASS_TBL A , PS_CLASS_TBL_LANG AL , PS_STDNT_ENRL B , PS_TERM_TBL C , PS_CRSE_CATALOG D WHERE AL.CRSE_ID = A.CRSE_ID AND AL.CRSE_OFFER_NBR = A.CRSE_OFFER_NBR AND AL.STRM = A.STRM AND AL.SESSION_CODE = A.SESSION_CODE AND AL.CLASS_SECTION = A.CLASS_SECTION AND A.STRM = B.STRM AND A.CLASS_NBR = B.CLASS_NBR AND C.INSTITUTION = A.INSTITUTION AND C.ACAD_CAREER = A.ACAD_CAREER AND C.STRM = A.STRM AND D.CRSE_ID = A.CRSE_ID AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_CRSE_CATALOG D1 WHERE D1.CRSE_ID = D.CRSE_ID AND D1.EFFDT <= C.TERM_BEGIN_DT) AND D.EFF_STATUS = 'A'

  • Related Language Record for CLSS_TBL_SE_VW2

    • # 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 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description