CLASS_TBL_VW1

(SQL View)
 Index Back

Class Table View

The Class Table View is a view of the Class Table for prompt selection based on term and class number (which is an alternate key).

SELECT A.INSTITUTION ,A.STRM ,A.CLASS_NBR ,A.ACAD_GROUP ,A.STRM ,A.SUBJECT ,A.CATALOG_NBR ,A.SESSION_CODE ,A.CLASS_SECTION ,A.ACAD_CAREER ,A.SSR_COMPONENT ,A.CRSE_ID ,A.CRSE_OFFER_NBR ,A.ENRL_STAT ,A.CLASS_STAT ,A.CLASS_TYPE ,A.ASSOCIATED_CLASS ,A.AUTO_ENROLL_SECT_1 ,A.AUTO_ENROLL_SECT_2 ,A.RESECTION ,A.CONSENT ,A.ENRL_CAP ,A.WAIT_CAP ,A.MIN_ENRL ,A.ENRL_TOT ,A.WAIT_TOT ,A.ACAD_ORG ,A.CAMPUS_EVENT_NBR ,A.ROOM_CAP_REQUEST ,C.DESCR ,A.STDNT_SPEC_PERM ,A.START_DT ,A.END_DT ,A.CAMPUS ,A.INSTRUCTION_MODE ,A.LMS_URL ,A.SCHEDULE_PRINT ,A.CRS_TOPIC_ID ,A.COMBINED_SECTION FROM PS_CLASS_TBL A , PS_TERM_TBL B , PS_CRSE_CATALOG C WHERE B.INSTITUTION = A.INSTITUTION AND B.STRM = A.STRM AND B.ACAD_CAREER = A.ACAD_CAREER AND C.CRSE_ID = A.CRSE_ID AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_CRSE_CATALOG C1 WHERE C1.CRSE_ID = C.CRSE_ID AND C1.EFFDT <= B.TERM_BEGIN_DT)

  • Related Language Record: CLASS_TBL_VW1LN

    • # 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 Number(5,0) INTEGER NOT NULL Class Nbr
    4 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group

    Default Value: OPR_DEF_TBL_CS.ACAD_GROUP

    Prompt Table: ACAD_GROUP_TBL

    5 TERM_ALT Character(4) VARCHAR2(4) NOT NULL Term Alternate Key

    Default Value: STDNT_CAREER.STRM

    Prompt Table: TERM_TBL

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

    Default Value: OPR_DEF_TBL_CS.SUBJECT

    Prompt Table: SUBJECT_TBL

    7 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    8 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
    9 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
    10 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
    11 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
    12 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    13 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    14 ENRL_STAT Character(1) VARCHAR2(1) NOT NULL Enrollment Status
    C=Closed
    O=Open
    W=Wait List
    15 CLASS_STAT Character(1) VARCHAR2(1) NOT NULL Class Status
    A=Active
    S=Stop Further Enrollment
    T=Tentative Section
    X=Cancelled Section
    16 CLASS_TYPE Character(1) VARCHAR2(1) NOT NULL Class Type
    E=Enrollment Section
    N=Non-Enrollment Section
    17 ASSOCIATED_CLASS Number(4,0) SMALLINT NOT NULL Associated Class
    18 AUTO_ENROLL_SECT_1 Character(4) VARCHAR2(4) NOT NULL 1st Auto Enroll Section
    19 AUTO_ENROLL_SECT_2 Character(4) VARCHAR2(4) NOT NULL 2nd Auto Enroll Section
    20 RESECTION Character(4) VARCHAR2(4) NOT NULL Resection to Section
    21 CONSENT Character(1) VARCHAR2(1) NOT NULL Used by Course Catalog, Class Table, and Class Permissions.
    D=Department Consent Required
    I=Instructor Consent Required
    N=No Special Consent Required
    22 ENRL_CAP Number(4,0) SMALLINT NOT NULL Enrollment Capacity
    23 WAIT_CAP Number(4,0) SMALLINT NOT NULL Wait List Capacity
    24 MIN_ENRL Number(4,0) SMALLINT NOT NULL Minimum Enrollment Number
    25 ENRL_TOT Number(4,0) SMALLINT NOT NULL Enrollment Total
    26 WAIT_TOT Number(4,0) SMALLINT NOT NULL Wait List Total
    27 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
    28 CAMPUS_EVENT_NBR Character(9) VARCHAR2(9) NOT NULL Event ID
    29 ROOM_CAP_REQUEST Number(4,0) SMALLINT NOT NULL Requested Room Capacity
    30 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    31 STDNT_SPEC_PERM Character(1) VARCHAR2(1) NOT NULL Student Specific Permissions
    32 START_DT Date(10) DATE Start Date
    33 END_DT Date(10) DATE end date
    34 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
    35 INSTRUCTION_MODE Character(2) VARCHAR2(2) NOT NULL Instruction Mode
    36 LMS_URL Character(254) VARCHAR2(254) NOT NULL LMS class URL
    37 SCHEDULE_PRINT Character(1) VARCHAR2(1) NOT NULL Schedule Print
    A=All
    N=No
    Y=Yes
    38 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
    39 COMBINED_SECTION Character(1) VARCHAR2(1) NOT NULL Combined Section
    C=Combined Section
    S=Combined Section Skip Mtg Pat