SSR_STDNT_CL_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.crse_id ,a.crse_offer_nbr ,a.strm ,a.session_code ,a.class_section ,a.class_nbr ,a.strm ,a.subject ,a.catalog_nbr ,a.acad_group ,a.acad_career ,a.institution ,a.ssr_component ,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 ,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: SSRSTDNTCLVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

    Prompt Table: CRSE_CATALOG

    2 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr

    Prompt Table: CRSE_OFFER

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

    Prompt Table: TERM_TBL

    4 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
    5 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
    6 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    7 TERM_ALT Character(4) VARCHAR2(4) NOT NULL Term Alternate Key

    Prompt Table: TERM_TBL

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

    Prompt Table: SUBJECT_TBL

    9 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    10 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group

    Prompt Table: ACAD_GROUP_TBL

    11 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

    Prompt Table: ACAD_CAR_SCRTY

    12 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTN_SCRTY

    13 COMPONENT Character(8) VARCHAR2(8) NOT NULL Sal package - Package Component
    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 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID