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 | ('') |
|
|
|||
| AbsenceReasonCode | varchar | 15 | ('') |
|
|
|||
| SchoolInOutStatus | varchar | 5 | ('') |
|
|
|||
| EnteredInAdvanceFlag | bit | 1 | ((0)) |
|
|
|||
| SystemGeneratedFlag | bit | 1 | ((0)) |
|
|
|||
| SystemProcessNumber | int | 4 | ((0)) |
|
|
|||
| NoteReceivedFlag | bit | 1 | ((0)) |
|
|
|||
| ContactMadeFlag | bit | 1 | ((0)) |
|
|
|||
| ApprovedFlag | bit | 1 | ((0)) |
|
|
|||
| ReportedByID | int | 4 | √ | null |
|
|
||
| ReportedByName | varchar | 200 | ('') |
|
|
|||
| EventComment | varchar | 100 | ('') |
|
|
|||
| LeavingWithID | int | 4 | √ | null |
|
|
||
| ContactReceivedFlag | bit | 1 | √ | null |
|
|
||
| MasterEndAbsenceEventsSeq | int | 4 | √ | null |
|
|
||
| NoteMadeFlag | bit | 1 | ((0)) |
|
|
|||
| AbsencePeriodCode | varchar | 15 | √ | null |
|
|
||
| DeletedByID | int | 4 | √ | null |
|
|
||
| DeletedDate | datetime | 16,3 | √ | null |
|
|
||
| TerminalCode | varchar | 15 | √ | null |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_AbsenceEventsDeleted | Primary key | Asc | AbsenceEventsSeq |