CLASS_TBL_VW

(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.WAITLIST_DAEMON ,A.AUTO_ENRL_WAITLIST ,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 ,A.DESCR ,A.STDNT_SPEC_PERM ,A.START_DT ,A.END_DT ,A.CAMPUS ,A.INSTRUCTION_MODE ,A.CRS_TOPIC_ID FROM PS_CLASS_TBL A

  • Related Language Record: CLASS_TBL_LV

    • # 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 WAITLIST_DAEMON Character(2) VARCHAR2(2) NOT NULL WAITLIST DAEMON SWITCH
    C=Candidates Still on Wait List
    N=No processing needed
    R=Yes - initiated by Reserve Cap
    Y=Yes-needs processing
    19 AUTO_ENRL_WAITLIST Character(1) VARCHAR2(1) NOT NULL Auto Enroll from Wait List
    20 AUTO_ENROLL_SECT_1 Character(4) VARCHAR2(4) NOT NULL 1st Auto Enroll Section
    21 AUTO_ENROLL_SECT_2 Character(4) VARCHAR2(4) NOT NULL 2nd Auto Enroll Section
    22 RESECTION Character(4) VARCHAR2(4) NOT NULL Resection to Section
    23 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
    24 ENRL_CAP Number(4,0) SMALLINT NOT NULL Enrollment Capacity
    25 WAIT_CAP Number(4,0) SMALLINT NOT NULL Wait List Capacity
    26 MIN_ENRL Number(4,0) SMALLINT NOT NULL Minimum Enrollment Number
    27 ENRL_TOT Number(4,0) SMALLINT NOT NULL Enrollment Total
    28 WAIT_TOT Number(4,0) SMALLINT NOT NULL Wait List Total
    29 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
    30 CAMPUS_EVENT_NBR Character(9) VARCHAR2(9) NOT NULL Event ID
    31 ROOM_CAP_REQUEST Number(4,0) SMALLINT NOT NULL Requested Room Capacity
    32 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    33 STDNT_SPEC_PERM Character(1) VARCHAR2(1) NOT NULL Student Specific Permissions
    34 START_DT Date(10) DATE Start Date
    35 END_DT Date(10) DATE end date
    36 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
    37 INSTRUCTION_MODE Character(2) VARCHAR2(2) NOT NULL Instruction Mode
    38 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID