Campus Café Tables

Some commonly used tables in the Campus Cafe student information system.

Table Name	Purpose	Notes
STBIOS	Student biographical
RGENRL	Base transcript record. Students enrolled in a course, final grades, etc.
STPARM	Code values used throughout the system.	Beware of fixed-width columns (`char`).
RGCRSE	Course listing with assigned instructors (up to two).

Table Name	Purpose	Notes
ATSENT	Attendance Entries	Existence of a row indicates attendance marked. `[ABSENT] = Y` indicates absent. `[PARAMETER_VALUE]` column stores reason/excuse codes from `STPARM` code `ATINFR`.
ATEXCP	Attendance Exceptions, i.e. holidays
ATSCHD	Scheduled class meetings? Uncertain.
ATSSUM	Not used?
ATTEND	Some kind of audit log for `ATSENT`?