MTG_TMPL

(SQL Table)
Index Back

Event Meeting Template

MTG_TMPL is used to record types and the duration of a particular meeting for an event type.

  • Parent Record Of MTG_RSRCE_TMPL MTG_STAFF_TMPL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CAMPUS_EVENT_TYPE Character(4) VARCHAR2(4) NOT NULL Event Type

    Prompt Table: EVENT_TYPE_TBL

    2 EVENT_TYP_TMPL_NBR Number(4,0) SMALLINT NOT NULL Event Meeting Number
    3 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
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: MTG_TMPL.DESCR