CAMPUS_EVENT

(SQL Table)
 Index Back

Campus Event Table

Campus Event Table tracks all events that need to be scheduled, that is, a facility needs to be reserved for it. Initially, the only valid event is a course. Each course (within a given term, session, section) is represented by a unique Event Number.

  • Related Language Record: CAMPUS_EVNT_LNG

  • Parent Record Of CAMPUS_EVNT_ATT CAMPUS_EVNT_CHK CAMPUS_MTG CAMPUS_MTG3_VW CAMPUS_MTG4_VW CAMPUS_MTG_LANG CAMPUS_MTG_VW CMP_EVNT_ATT_LN EVENT_ATT_VW EVENT_ATT_VWLNG EVENT_MTG EVENT_MTG_LNG

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: CAMPUS_EVENT.DESCR

    5 CAMPUS_EVENT_TYPE Character(4) VARCHAR2(4) NOT NULL Event Type

    Prompt Table: MTG_EVNT_TYP_VW

    6 EVENT_MANAGER Character(11) VARCHAR2(11) NOT NULL Event Manager

    Prompt Table: PEOPLE_SRCH

    7 PRIMARY_MEETING Number(4,0) SMALLINT NOT NULL Primary Meeting

    Prompt Table: EVENT_MTG

    8 ATTENDEE_NBR_LST Number(6,0) INTEGER NOT NULL Last Attendee NBr Assigned
    9 COMMENTS Long Character CLOB Comment