Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AbsenceEventSeq | int | 4 | null |
|
|
|||
| AbsenceEventsSeq | int | 4 | null |
|
|
|||
| AbsenceEventMasterAbsenceEventsSeq | int | 4 | √ | null |
|
|
||
| AbsenceEventTypeCode | varchar | 15 | null |
|
|
|||
| AbsenceEventTypeDescription | varchar | 30 | √ | null |
|
|
||
| AbsenceEventTypeSortSeq | int | 4 | √ | null |
|
|
||
| AbsenceEventTypeSynergyMeaning | varchar | 15 | √ | null |
|
|
||
| AbsenceEventTypeShortPrefix | varchar | 30 | √ | null |
|
|
||
| AbsenceEventTypeShortSuffix | varchar | 30 | √ | null |
|
|
||
| AbsenceEventDateTime | datetime | 16,3 | null |
|
|
|||
| AbsenceEventDate | datetime | 16,3 | √ | null |
|
|
||
| AbsenceEventTime | datetime | 16,3 | √ | null |
|
|
||
| AbsenceEventSchoolInOutStatus | varchar | 5 | null |
|
|
|||
| AbsenceEventComment | varchar | 100 | null |
|
|
|||
| AbsenceEventSystemGeneratedFlag | bit | 1 | null |
|
|
|||
| AbsenceEventSystemProcessNumber | int | 4 | null |
|
|
|||
| AbsenceEventCreatedByID | int | 4 | √ | null |
|
|
||
| AbsenceEventCreatedDate | datetime | 16,3 | √ | null |
|
|
||
| AbsenceEventModifiedByID | int | 4 | √ | null |
|
|
||
| AbsenceEventModifiedDate | datetime | 16,3 | √ | null |
|
|
||
| AbsenceEventAbsenceTypeCode | varchar | 15 | null |
|
|
|||
| AbsenceEventAbsenceTypeDescription | varchar | 30 | √ | null |
|
|
||
| AbsenceEventAbsenceTypeSynergyMeaning | varchar | 15 | √ | null |
|
|
||
| AbsenceEventAbsenceTypeCountAsAbsenceFlag | bit | 1 | √ | null |
|
|
||
| AbsenceEventAbsenceTypeExternalSystemType | varchar | 10 | √ | null |
|
|
||
| AbsenceEventAbsenceTypeExternalSystemCode | varchar | 20 | √ | null |
|
|
||
| AbsenceEventAbsenceTypeSortSeq | int | 4 | √ | null |
|
|
||
| AbsenceEventAbsenceReasonCode | varchar | 15 | null |
|
|
|||
| AbsenceEventAbsenceReasonDescription | varchar | 30 | √ | null |
|
|
||
| AbsenceEventEnteredInAdvanceFlag | bit | 1 | null |
|
|
|||
| AbsenceEventNoteReceivedFlag | bit | 1 | null |
|
|
|||
| AbsenceEventContactMadeFlag | bit | 1 | null |
|
|
|||
| AbsenceEventContactReceivedFlag | bit | 1 | null |
|
|
|||
| AbsenceEventApprovedFlag | bit | 1 | null |
|
|
|||
| AbsenceEventReportedByID | int | 4 | √ | null |
|
|
||
| AbsenceEventReportedByIDName | varchar | 100 | √ | null |
|
|
||
| AbsenceEventReportedByName | varchar | 200 | null |
|
|
|||
| AbsenceEventsLeavingWithID | int | 4 | √ | null |
|
|
||
| AbsenceEventsLeavingWithIDName | varchar | 100 | √ | null |
|
|
||
| AbsenceEventPeriodCode | varchar | 15 | null |
|
|
|||
| AbsenceEventPeriodDescription | varchar | 30 | √ | null |
|
|
||
| AbsenceEventSortSeq | int | 4 | √ | null |
|
|
||
| AbsenceEventPeriodNumber | int | 4 | √ | null |
|
|
||
| AbsenceEventPeriodSynergyMeaning | varchar | 15 | √ | null |
|
|
||
| FileYear | smallint | 2 | null |
|
|
|||
| StudentID | int | 4 | null |
|
|
|||
| StudentSurname | varchar | 30 | null |
|
|
|||
| StudentGiven1 | varchar | 20 | null |
|
|
|||
| StudentGiven2 | varchar | 50 | null |
|
|
|||
| StudentPreferred | varchar | 20 | null |
|
|
|||
| StudentGender | varchar | 15 | null |
|
|
|||
| StudentBirthDate | datetime | 16,3 | √ | null |
|
|
||
| StudentMailName | varchar | 100 | null |
|
|
|||
| StudentYearLevel | smallint | 2 | √ | null |
|
|
||
| StudentYearLevelSort | smallint | 2 | null |
|
|
|||
| StudentYearLevelDescription | varchar | 30 | √ | null |
|
|
||
| StudentYearLevelCoordinator | varchar | 30 | √ | null |
|
|
||
| YearLevelCoordinatorID | int | 4 | √ | null |
|
|
||
| StudentEntryDate | datetime | 16,3 | √ | null |
|
|
||
| StudentLeavingDate | datetime | 16,3 | √ | null |
|
|
||
| StudentForm | varchar | 15 | null |
|
|
|||
| StudentFormDescription | varchar | 30 | √ | null |
|
|
||
| StudentFormHomeRoom | varchar | 15 | √ | null |
|
|
||
| StudentFormStaffName | varchar | 100 | √ | null |
|
|
||
| StudentFormStaffID | int | 4 | √ | null |
|
|
||
| StudentStatus | varchar | 3 | null |
|
|
|||
| StudentStatusDescription | varchar | 30 | √ | null |
|
|
||
| StudentStatusSynergyMeaning | varchar | 30 | √ | null |
|
|
||
| StudentCampus | varchar | 3 | null |
|
|
|||
| StudentCampusDescription | varchar | 30 | √ | null |
|
|
||
| StudentCampusHeadOfCampus | varchar | 30 | √ | null |
|
|
||
| StudentHouse | varchar | 5 | null |
|
|
|||
| StudentHouseDescription | varchar | 30 | √ | null |
|
|
||
| StudentHouseHeadOfHouse | varchar | 100 | √ | null |
|
|
||
| StudentHouseHeadOfHouseID | int | 4 | √ | null |
|
|
||
| StudentTutor | varchar | 15 | null |
|
|
|||
| StudentTutorDescription | varchar | 30 | √ | null |
|
|
||
| StudentTutorHomeRoom | varchar | 15 | √ | null |
|
|
||
| StudentTutorName | varchar | 100 | √ | null |
|
|
||
| StudentTutorID | int | 4 | √ | null |
|
|
||
| StudentBoarder | varchar | 3 | null |
|
|
|||
| StudentBoarderDescription | varchar | 30 | √ | null |
|
|
||
| StudentBoarderSynergyMeaning | varchar | 30 | √ | null |
|
|
||
| StudentBoardingHouse | varchar | 15 | null |
|
|
|||
| StudentFamilyPosition | smallint | 2 | null |
|
|
|||
| AbsenceEventNoteMadeFlag | bit | 1 | null |
|
|
|||
| StudentSubSchool | varchar | 15 | √ | null |
|
|
Table contained 0 rows