pvAttendancesAll


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StaffScheduleFlag bit 1 √ null
AttendanceSeq int 4 √ null
AttendanceMasterSeq int 4 √ null
StaffScheduleStudentClassesSeq int 4 √ null
StaffScheduleSeq int 4 √ null
FileType varchar 5 null
FileYear int 4 null
FileSemester int 4 null
ClassCampus varchar 3 null
ClassCode varchar 15 null
ID int 4 null
AttendanceDate datetime 16,3 null
AttendancePeriod tinyint 1 √ null
PossibleAbsenceCode varchar 15 null
PossibleDescription varchar 100 √ null
AttendedFlag bit 1 √ null
StaffID int 4 null
ModifiedDate datetime 16,3 √ null
ModifiedByID int 4 √ null
ModifiedBy varchar 50 √ null
PossibleReasonCode varchar 15 null
UserFlag1 int 4 null
UserFlag2 int 4 null
UserFlag3 int 4 null
UserFlag4 int 4 null
UserFlag5 int 4 null
LateArrivalFlag int 4 null
LatearrivalTime datetime 16,3 √ null
LateArrivalTimeStr varchar 20 √ null
EarlyDepartureFlag int 4 null
EarlyDepartureTime datetime 16,3 √ null
EarlyDepartureTimeStr varchar 20 √ null
AbsenceEventsSeq int 4 √ null
NonAttendCreatedAbsenceEventsFlag int 4 null
AttendanceDateTimeFrom datetime 16,3 √ null
AttendanceDateTimeTo datetime 16,3 √ null
AttendanceDayNumber int 4 √ null
ClassCancelledFlag int 4 null
AbsenceTypeCode varchar 15 √ null
EventComment varchar 100 √ null
AbsenceReasonCode varchar 15 √ null
AbsenceReasonDescription varchar 30 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views