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