MTG_TMPL(SQL Table) |
Index Back |
|---|---|
Event Meeting TemplateMTG_TMPL is used to record types and the duration of a particular meeting for an event type. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(4) | VARCHAR2(4) NOT NULL |
Event Type
Prompt Table: EVENT_TYPE_TBL |
|
| 2 | 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 |