Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AbsenceEventsSeq | int | 4 | null |
|
|
|||
| AbsenceEventTypeCode | varchar | 15 | null |
|
|
|||
| AbsenceEventTypeDesc | varchar | 30 | √ | null |
|
|
||
| AbsenceEventTypeSynergyMeaning | 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 |
|
|
||
| AbsenceTypeCode | varchar | 15 | null |
|
|
|||
| AbsenceTypeDesc | varchar | 30 | √ | null |
|
|
||
| AbsenceTypeCountAsAbsenceFlag | bit | 1 | √ | null |
|
|
||
| AbsenceTypeSynergyMeaning | varchar | 15 | √ | null |
|
|
||
| AbsenceReasonCode | varchar | 15 | null |
|
|
|||
| SchoolInOutStatus | varchar | 5 | null |
|
|
|||
| NoteReceivedFlag | bit | 1 | null |
|
|
|||
| ContactMadeFlag | bit | 1 | null |
|
|
|||
| ApprovedFlag | bit | 1 | null |
|
|
|||
| ReportedByID | int | 4 | √ | null |
|
|
||
| EventComment | varchar | 100 | null |
|
|
|||
| AbsencePeriodCode | varchar | 15 | null |
|
|
|||
| FileYear | smallint | 2 | null |
|
|
|||
| FileSemester | smallint | 2 | null |
|
|
|||
| ActualSemester | smallint | 2 | null |
|
|
|||
| FileSemesterStartDate | datetime | 16,3 | √ | null |
|
|
||
| FileSemesterEndDate | datetime | 16,3 | √ | null |
|
|
||
| CurrentFileSemesterFlag | bit | 1 | null |
|
|
|||
| NoteMadeFlag | bit | 1 | null |
|
|
Table contained 0 rows