pvAbsenceEvents


Columns

Column Type Size Nulls Auto Default Children Parents Comments
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
LinkedID int 4 √ null
DueAbsenceEventsSeq int 4 √ null
DueEventDateTime datetime 16,3 √ null
DueEventDate datetime 16,3 √ null
StartEventDateTime datetime 16,3 √ null
StartEventDate datetime 16,3 √ null
StartEventTime datetime 16,3 √ null
OutDateTimeStr varchar 51 √ null
InDateTimeStr varchar 51 √ null
LateArrivalFlag bit 1 √ null
DetailedDescription nvarchar 948 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views