CAMPUS_MTG3_VW

(SQL View)
 Index Back

Campus Meeting view

Campus Meeting Table consists of daily load information for all campus facilities. It makes the task of finding out what is going on in a facility on any given day trivial. This table should never be directly updated by users. It is populated as rows are updated either in the Event Meeting Table or the Class Meeting Pattern Table.

SELECT campus_event_nbr , event_mtg_nbr , campus_mtg_nbr , facility_id , meeting_dt , day_of_wk , meeting_time_start , meeting_time_end , contact_minutes , class_mtg_nbr , campus_mtg_type , descr , descrshort , campus_mtg_loc , sched_campus_mtg , class_exam_seq FROM PS_CAMPUS_MTG

  • Parent record: CAMPUS_EVENT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CAMPUS_EVENT_NBR Character(9) VARCHAR2(9) NOT NULL Event ID

    Prompt Table: CAMPUS_EVENT

    2 EVENT_MTG_NBR Number(4,0) SMALLINT NOT NULL Event Meeting Nbr
    3 CAMPUS_MTG_NBR Number(4,0) SMALLINT NOT NULL Event Meeting Nbr
    4 FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Facility ID

    Prompt Table: FACILITY_TBL

    5 MEETING_DT Date(10) DATE Meeting Date
    6 DAY_OF_WK Character(1) VARCHAR2(1) NOT NULL Day of the Week
    1=Sunday
    2=Monday
    3=Tuesday
    4=Wednesday
    5=Thursday
    6=Friday
    7=Saturday
    7 MEETING_TIME_START Time(15) TIMESTAMP Meeting Start Time
    8 MEETING_TIME_END Time(15) TIMESTAMP Meeting End Time
    9 CONTACT_MINUTES Number(4,0) SMALLINT NOT NULL Contact Minutes
    10 CLASS_MTG_NBR Number(2,0) SMALLINT NOT NULL Class Meeting Pattern Nbr
    11 CAMPUS_MTG_TYPE Character(4) VARCHAR2(4) NOT NULL Campus Meeting Type
    CRSE=Course
    DISC=Discussion Group
    EXAM=Class Examination
    FAIR=Recruiting Fair
    INFO=Information Session
    INTV=Interview
    MTG=Meeting
    RCPT=Reception
    SMNR=Seminar
    TOUR=Campus Tour
    WRKS=Workshop
    12 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    13 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    14 CAMPUS_MTG_LOC Character(1) VARCHAR2(1) NOT NULL Campus Meeting Location
    C=Campus Facility
    E=External Org Facility
    O=Other Facility
    15 SCHED_CAMPUS_MTG Character(1) VARCHAR2(1) NOT NULL Scheduled Campus Meeting

    Y/N Table Edit

    16 CLASS_EXAM_SEQ Number(2,0) SMALLINT NOT NULL Class Exam Sequence Nbr