INSTITUTIONPrompt Table: INSTITUTION_TBL
STRMPrompt Table: TERM_VAL_TBL
CLASS_NBRATTEND_TMPLT_NBRCONF=Conference
CONS=Instructor Consultation
FLD=Field Trip
MTG=Class Meeting
STDY=Study Group
Prompt Table: ATTEND_TYPE_VW
SSR_FC_ATNDTMPL(SQL View) |
Index Back |
|---|---|
Class Attendance Template View |
| SELECT INSTITUTION , STRM , CLASS_NBR , ATTEND_TMPLT_NBR , CAMPUS_MTG_NBR , CLASS_MTG_NBR , CLASS_ATTEND_TYPE , CLASS_ATTEND_DT , ATTEND_TO_TIME , ATTEND_FROM_TIME , CONTACT_MINUTES FROM PS_ATTEND_TMPLT |
| # | 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 | STRM |
Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: TERM_VAL_TBL |
| 3 | CLASS_NBR |
Number(5,0) | INTEGER NOT NULL | Class Nbr |
| 4 | ATTEND_TMPLT_NBR |
Number(4,0) | SMALLINT NOT NULL | Attendance Template Nbr |
| 5 | CAMPUS_MTG_NBR | Number(4,0) | SMALLINT NOT NULL | Event Meeting Nbr |
| 6 | CLASS_MTG_NBR | Number(2,0) | SMALLINT NOT NULL | Class Meeting Pattern Nbr |
| 7 | 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 Prompt Table: ATTEND_TYPE_VW |
| 8 | CLASS_ATTEND_DT | Date(10) | DATE NOT NULL | Attendance Date |
| 9 | ATTEND_TO_TIME | Time(15) | TIMESTAMP | Attendance To Time |
| 10 | ATTEND_FROM_TIME | Time(15) | TIMESTAMP | Attendance From Time |
| 11 | CONTACT_MINUTES | Number(4,0) | SMALLINT NOT NULL | Contact Minutes |