CLASS_TBL_RE_VW

(SQL View)
 Index Back

Class Tbl Related Section View

This Class Table view is used as an edit table for the Related Class Number fields in the Enrollment Request Table. Only Class Sections with the same Course ID, Course Offer Number, Term, Session Code and Associated Class as the main enrollment Class Section are selected.

SELECT B.INSTITUTION ,B.STRM ,A.CLASS_NBR ,B.CLASS_NBR ,B.SUBJECT ,B.CATALOG_NBR ,B.SESSION_CODE ,B.SSR_COMPONENT ,B.CLASS_SECTION ,B.DESCR FROM PS_CLASS_TBL A , PS_CLASS_TBL B WHERE A.CRSE_ID=B.CRSE_ID AND A.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND A.STRM = B.STRM AND A.SESSION_CODE = B.SESSION_CODE AND B.CLASS_TYPE <> 'E' AND A.CLASS_NBR <> B.CLASS_NBR AND (B.ASSOCIATED_CLASS = 9999 OR A.ASSOCIATED_CLASS = B.ASSOCIATED_CLASS) AND B.CLASS_SECTION <> A.AUTO_ENROLL_SECT_1 AND B.CLASS_SECTION <> A.AUTO_ENROLL_SECT_2 AND B.CLASS_STAT = 'A'

  • Related Language Record: CLASSTBLREVWLNG

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

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: TERM_TBL

    3 CLASS_NBR_REQ Number(5,0) INTEGER NOT NULL Class Nbr
    4 RELATE_CLASS_NBR Number(5,0) INTEGER NOT NULL Related Class Nbr
    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 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
    1=Regular Academic Session
    10W=10 Week
    12W=Twelve Week
    4W1=Four Week - First
    4W2=Four Week - Second
    4W3=Four Week - Third
    4W4=Four Week - Fourth
    6W1=Six Week - First
    6W2=Six Week - Second
    8W1=Eight Week - First
    8W2=Eight Week - Second
    A11=Medical Period 1, 4 Weeks
    A12=Medical Period 1, 8 Weeks
    A13=Medical Pd 1, 12 Weeks
    A21=Medical Period 2, 4 Weeks
    A22=Medical Period 2, 8 Weeks
    A23=Medical Period 2, 12 Week
    FYR=Full Year
    MIN=Mini Session
    OEE=Open Entry/Open Exit
    SM1=Semester 1
    SM2=Semester 2
    8 SSR_COMPONENT Character(3) VARCHAR2(3) NOT NULL Course Component.
    CLN=Clinical
    CON=Continuance
    DIS=Discussion
    FLD=Field Studies
    IND=Independent Study
    LAB=Laboratory
    LEC=Lecture
    PRA=Practicum
    RSC=Research
    SEM=Seminar
    SUP=Supervision
    THE=Thesis Research
    TUT=Tutorial
    9 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description