AbsenceEventsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
AbsenceEventsHistorySeq int identity 4 √ null
AbsenceEventsSeq int 4 √ null
MasterAbsenceEventsSeq int 4 √ null
SupersededByAbsenceEventsSeq int 4 √ null
AbsenceEventTypeCode varchar 15 √ null
ID int 4 √ null
EventDateTime datetime 16,3 √ null
EventDate datetime 16,3 √ null
EventTime datetime 16,3 √ null
CreatedByID int 4 √ null
CreatedDate datetime 16,3 √ null
ModifiedByID int 4 √ null
ModifiedDate datetime 16,3 √ null
AbsenceTypeCode varchar 15 √ null
AbsenceReasonCode varchar 15 √ null
SchoolInOutStatus varchar 5 √ null
EnteredInAdvanceFlag bit 1 √ null
SystemGeneratedFlag bit 1 √ null
SystemProcessNumber int 4 √ null
NoteReceivedFlag bit 1 √ null
ContactMadeFlag bit 1 √ null
ApprovedFlag bit 1 √ null
ReportedByID int 4 √ null
ReportedByName varchar 200 √ null
EventComment varchar 100 √ null
LeavingWithID int 4 √ null
AbsencePeriodCode varchar 15 √ null
ContactReceivedFlag bit 1 √ null
MasterEndAbsenceEventsSeq int 4 √ null
NoteMadeFlag bit 1 √ null
TerminalCode varchar 15 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_AbsenceEventsHistory_AbsenceEventsHistorySeq Primary key Asc AbsenceEventsHistorySeq
AK_AbsenceEventsHistory_AbsenceEventsSeq Performance Asc AbsenceEventsSeq