| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CRSE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Course ID
Prompt Table:
CRSE_CATALOG
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
SSR_COMPONENT |
Character(3) |
VARCHAR2(3) NOT NULL |
Course Component.
CLN=Clinical
CON=Continuance
DIS=Discussion
FLD=Field Studies
IND=Independent Study
LAB=Laboratory
LEC=Lecture
PRA=Practicum
RSC=Research
SEM=Seminar
SUP=Supervision
THE=Thesis Research
TUT=Tutorial
|
| 4 |
CLASS_ATTEND_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Attendance Type
CONF=Conference
CONS=Instructor Consultation
FLD=Field Trip
MTG=Class Meeting
STDY=Study Group
|
| 5 |
INSTRUCTION_MODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Instruction Mode
Prompt Table:
INSTRUCT_MODE
|
| 6 |
ATTEND_PRESENT_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Present
Y/N Table Edit
Default Value: Y
|
| 7 |
ATTEND_REASON_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Reason
Y/N Table Edit
Default Value: Y
|
| 8 |
ATTEND_TARDY_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Tardy
Y/N Table Edit
Default Value: Y
|
| 9 |
ATTEND_LEFT_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Left Early
Y/N Table Edit
Default Value: Y
|
| 10 |
ATTEND_CONTACT_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Contact Minutes
Y/N Table Edit
Default Value: Y
|
| 11 |
ATTEND_TIME_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use To and From Time
Y/N Table Edit
Default Value: Y
|
| 12 |
ATTEND_TMPLT_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Template Date / Time
Y/N Table Edit
Default Value: N
|