Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
ID | int | 4 | null |
|
|
|||
AbsenceDate | datetime | 16,3 | √ | null |
|
|
||
AbsencePeriod | varchar | 15 | null |
|
|
|||
AbsencePeriodSort | int | 4 | √ | null |
|
|
||
AbsenceType | varchar | 15 | null |
|
|
|||
AdvanceNotifiedFlag | bit | 1 | null |
|
|
|||
ApprovedFlag | bit | 1 | null |
|
|
|||
NoteReceivedFlag | bit | 1 | null |
|
|
|||
LateArrivalFlag | int | 4 | null |
|
|
|||
LateArrivalTime | varchar | 5 | √ | null |
|
|
||
Description | varchar | 100 | null |
|
|
|||
RelatedAttendanceSeq | int | 4 | null |
|
|
|||
AbsenceSeq | int | 4 | null |
|
|
|||
SystemProcessNumber | int | 4 | null |
|
|
|||
ReasonCode | varchar | 15 | null |
|
|
|||
NonAttendancePeriodCount | int | 4 | null |
|
|
|||
PhonedFlag | bit | 1 | null |
|
|
|||
EarlyDepartureTime | varchar | 5 | √ | null |
|
|
||
CreatedDate | datetime | 16,3 | √ | null |
|
|
||
LoginName | varchar | 50 | √ | null |
|
|
||
AbsencesSeq | int | 4 | null |
|
|
|||
NoteMadeFlag | bit | 1 | null |
|
|
|||
SynergyMeaning | varchar | 15 | √ | null |
|
|
Table contained 0 rows