cPermanent.dbo.TutorSession table
Each record represents a tutor’s session. The record contains all information about the session except who the tutee was.
DW Field | Description or Sample |
Term |
|
TutorId | Banner Id of the tutor |
sessionNumber | Incremental number – to act as unique number for the primary key of Term + TutorId + sessionNumber |
sessionWalkin | ‘Y’ if the session was started for a “walk-in” student |
sessionSubject | Subject + Course Number being tutored |
sessionDate | Date of session |
sessionStartTime | Start time of session |
sessionEndTime | End time of session |
sessionApproved | Always ‘Y’ |
sessionShortSubject | Subject being tutored |