CLASS_SRCH_MTG

(SQL View)
 Index Back

Class Search Mtg Pattern

Meeting pattern scroll for results and detail.

SELECT CRSE_ID , CRSE_OFFER_NBR , STRM , SESSION_CODE , CLASS_SECTION , CLASS_MTG_NBR , MEETING_TIME_START , MEETING_TIME_END ,MON ,TUES ,WED ,THURS ,FRI ,SAT ,SUN ,FACILITY_ID ,START_DT ,END_DT ,CRS_TOPIC_ID ,DESCR FROM PS_CLASS_MTG_PAT

  • Related Language Record: CLASSSRCHMTGLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    2 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    3 STRM Character(4) VARCHAR2(4) NOT NULL Term
    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_MTG_NBR Number(2,0) SMALLINT NOT NULL Class Meeting Pattern Nbr
    7 MEETING_TIME_START Time(15) TIMESTAMP Meeting Start Time
    8 MEETING_TIME_END Time(15) TIMESTAMP Meeting End Time
    9 MON Character(1) VARCHAR2(1) NOT NULL Monday
    10 TUES Character(1) VARCHAR2(1) NOT NULL Tuesday
    11 WED Character(1) VARCHAR2(1) NOT NULL Wednesday
    12 THURS Character(1) VARCHAR2(1) NOT NULL Thursday
    13 FRI Character(1) VARCHAR2(1) NOT NULL Friday
    14 SAT Character(1) VARCHAR2(1) NOT NULL Saturday
    15 SUN Character(1) VARCHAR2(1) NOT NULL Sunday
    16 FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Facility ID
    17 START_DT Date(10) DATE Start Date
    18 END_DT Date(10) DATE end date
    19 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
    20 DESCR Character(30) VARCHAR2(30) NOT NULL Description