SCTN_CMBND_5_VW

(SQL View)
 Index Back

Sections Combined

Sections Combined tracks Class Sections that are combined within an Academic Institution, Term and Session Code. Each set of combined class sections share the same Sections Combined Id.

SELECT A.INSTITUTION , A.STRM , A.SESSION_CODE , A.SCTN_COMBINED_ID , A.CLASS_NBR , B.DESCR , B.ROOM_CAP_REQUEST , B.ENRL_CAP , B.ENRL_TOT , B.WAIT_CAP , B.WAIT_TOT , B.SKIP_MTGPAT_EDIT FROM PS_SCTN_CMBND A ,PS_SCTN_CMBND_TBL B WHERE A.INSTITUTION = B.INSTITUTION AND A.STRM = B.STRM AND A.SESSION_CODE = B.SESSION_CODE AND A.SCTN_COMBINED_ID = B.SCTN_COMBINED_ID

  • Related Language Record: SCTNCMBND5VWLNG

  • Parent record: SCTN_CMBND_TBL

    • # 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_VAL_TBL

    3 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

    Default Value: 1

    4 SCTN_COMBINED_ID Character(4) VARCHAR2(4) NOT NULL Combined Sections ID
    5 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr

    Prompt Table: CLASS_TBL_2_VW

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 ROOM_CAP_REQUEST Number(4,0) SMALLINT NOT NULL Requested Room Capacity
    8 ENRL_CAP Number(4,0) SMALLINT NOT NULL Enrollment Capacity
    9 ENRL_TOT Number(4,0) SMALLINT NOT NULL Enrollment Total
    10 WAIT_CAP Number(4,0) SMALLINT NOT NULL Wait List Capacity
    11 WAIT_TOT Number(4,0) SMALLINT NOT NULL Wait List Total
    12 SKIP_MTGPAT_EDIT Character(1) VARCHAR2(1) NOT NULL Skip Mtg Pattern & Instr Edit flag

    Y/N Table Edit