STND_MTGPAT_TBL(SQL Table) |
Index Back |
|---|---|
Standard Meeting PatternThis table is designed to expedite class schedule meeting pattern entry. If a Standard Meeting Pattern code has been entered in the Schedule of Classes panelgroup, the days of week in the Class Meeting Pattern Table will default to the values indicated in this table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | ACAD_GROUP |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Group
Prompt Table: ACAD_GROUP_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | STND_MTG_PAT |
Character(4) | VARCHAR2(4) NOT NULL | Standard Meeting Pattern |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: STND_MTGPAT_TBL.DESCR |
| 7 | MON | Character(1) | VARCHAR2(1) NOT NULL |
Monday
Y/N Table Edit Default Value: N |
| 8 | TUES | Character(1) | VARCHAR2(1) NOT NULL |
Tuesday
Y/N Table Edit Default Value: N |
| 9 | WED | Character(1) | VARCHAR2(1) NOT NULL |
Wednesday
Y/N Table Edit Default Value: N |
| 10 | THURS | Character(1) | VARCHAR2(1) NOT NULL |
Thursday
Y/N Table Edit Default Value: N |
| 11 | FRI | Character(1) | VARCHAR2(1) NOT NULL |
Friday
Y/N Table Edit Default Value: N |
| 12 | SAT | Character(1) | VARCHAR2(1) NOT NULL |
Saturday
Y/N Table Edit Default Value: N |
| 13 | SUN | Character(1) | VARCHAR2(1) NOT NULL |
Sunday
Y/N Table Edit Default Value: N |
| 14 | NORM_DURATION | Number(3,0) | SMALLINT NOT NULL | Normal Class Duration |