vStudentMedicalIncidents


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IncidentSeq int 4 null
ID int 4 null
ModifiedDate datetime 16,3 √ null
ModifiedBy varchar 50 √ null
IncidentDate datetime 16,3 √ null
IncidentType varchar 15 null
IncidentDescription varchar 100 √ null
Diagnosis varchar 2147483647 √ null
Despatch varchar 2147483647 √ null
Comment varchar 2147483647 √ null
FollowUpFlag bit 1 null
FollowUp varchar 2147483647 √ null
FollowUpDate datetime 16,3 √ null
TimeIn varchar 5 null
TimeOut varchar 5 null
TreatedByDetails varchar 2147483647 √ null
InjuryDetails varchar 2147483647 √ null
ScaleOfInjuryCode varchar 15 null
HowInjurySustained varchar 2147483647 √ null
InjuryActionTakenCode varchar 15 null
InjuryMedicationSubscribedDetails varchar 2147483647 √ null
InjuryFollowUpDetails varchar 2147483647 √ null
InjuryReferrelCode varchar 15 null
InjuryWitnessesDetails varchar 2147483647 √ null
NotificationSentWithStudentFlag bit 1 null
ParentPhonedNotificationFlag bit 1 null
ParentPhonedNotificationDetails varchar 255 √ null
ParentMailedNotificationFlag bit 1 null
ParentMailedNotificationDetails varchar 255 √ null
GuardianPhonedNotificationFlag bit 1 null
GuardianPhonedNotificationDetails varchar 255 √ null
GuardianMailedNotificationFlag bit 1 null
GuardianMailedNotificationDetails varchar 255 √ null
HeadOfHousePhonedNotificationFlag bit 1 null
HeadOfHousePhonedNotificationDetails varchar 255 √ null
HeadOfHouseMailedNotificationFlag bit 1 null
HeadOfHouseMailedNotificationDetails varchar 255 √ null
HeadOfHouseEMailedNotificationFlag bit 1 null
HeadOfHouseEMailedNotificationDetails varchar 255 √ null
DirectorOfStudentsNotificationFlag bit 1 null
DirectorOfStudentsNotificationDetails varchar 255 √ null
HeadOfSchoolNotificationFlag bit 1 null
HeadOfSchoolNotificationDetails varchar 255 √ null
HeadmasterNotificationFlag bit 1 null
HeadmasterNotificationDetails varchar 255 √ null
WorkcoverClaimSubmittedFlag bit 1 null
WorkcoverClaimSubmittedDetails varchar 255 √ null
FollowupActionDetails varchar 2147483647 √ null
InjuryMedicationSubscribedDescription varchar 2147483647 √ null
VenueCode varchar 15 null
RestrictedActivitiesSeq int 4 √ null
RestrictedFlag bit 1 √ null
RestrictedDays int 4 √ null
RestrictedEndDate datetime 16,3 √ null
ReviewDate datetime 16,3 √ null
Comments varchar 1000 √ null
RestrictedModifiedBy int 4 √ null
RestrictedModifiedDate datetime 16,3 √ null
Studentid int 4 null
StudentContactAddress1 varchar 40 √ null
StudentContactAddress2 varchar 40 √ null
StudentContactAddress3 varchar 40 √ null
StudentContactState varchar 5 √ null
StudentContactPostCode varchar 5 √ null
StudentContactSuburb varchar 40 √ null
StudentContactHomeState varchar 5 √ null
StudentContactHomeCountryCode varchar 5 √ null
StudentContactHomePostCode varchar 5 √ null
StudentContactHomeSuburb varchar 40 √ null
StudentContactHomeAddress1 varchar 40 √ null
StudentContactHomeAddress2 varchar 40 √ null
StudentContactHomeAddress3 varchar 40 √ null
StudentContactType varchar 3 √ null
StudentContactDescription varchar 30 √ null
StudentContactLivesWithFlag bit 1 √ null
StudentContactPrimaryOnlyFlag bit 1 √ null
StudentContactNormalMailFlag bit 1 √ null
StudentContactValidAddress bit 1 √ null
StudentContactReportsFlag bit 1 √ null
StudentContactParentFlag bit 1 √ null
StudentLeavingDate datetime 16,3 √ null
StudentLeavingReason varchar 3 √ null
Status varchar 3 √ null
StatusDescription varchar 30 √ null
StatusNextYear varchar 3 √ null
StatusNextYearDescription varchar 30 √ null
StudentCampus varchar 3 √ null
StudentEntryDate datetime 16,3 √ null
StudentEntryCampus varchar 3 null
StudentEntryYearLevel smallint 2 √ null
StudentReturningDate datetime 16,3 √ null
StudentCampusDescription varchar 30 √ null
YearLevel smallint 2 √ null
YearLevelSort smallint 2 √ null
StudentYearLevelDescription varchar 30 √ null
House varchar 5 √ null
Form varchar 15 √ null
StudentFormDescription varchar 30 √ null
StudentFormHomeroom varchar 15 √ null
StudentFormHomeroomTeacher varchar 100 √ null
Tutor varchar 15 √ null
Boarder varchar 3 √ null
BoardingHouse varchar 15 √ null
BoarderSynergyMeaning varchar 30 √ null
DebtorID int 4 null
FullFeeFlag bit 1 null
EnglishSecondFlag bit 1 null
IntendsTertiaryFlag bit 1 null
StudentApplicationDate datetime 16,3 √ null
StudentMedicalAlertFlag bit 1 null
StudentSpecialNeedsFlag bit 1 null
StudentStudyAtHomeFlag bit 1 null
StudentTSIFlag bit 1 null
StudentESLProficiencyLevel varchar 15 null
StudentESLListeningLevelCode varchar 15 √ null
StudentESLSpeakingLevelCode varchar 15 √ null
StudentESLReadingLevelCode varchar 15 √ null
StudentESLWritingLevelCode varchar 15 √ null
NameInternal varchar 100 √ null
NameExternal varchar 100 √ null
LegalFullName varchar 150 √ null
Surname varchar 30 √ null
Preferred varchar 20 √ null
PreferredFormal varchar 20 √ null
Given1 varchar 20 √ null
Given2 varchar 50 √ null
StudentName varchar 51 √ null
StudentBirthDate datetime 16,3 √ null
StudentGender varchar 15 √ null
StudentReligionCode varchar 5 √ null
StudentReligionDescription varchar 40 √ null
StudentParishCode varchar 5 √ null
StudentParishDescription varchar 50 √ null
LegalPhotoWebFlag bit 1 √ null
LegalPhotoPromFlag bit 1 √ null
LegalPublicationFlag bit 1 √ null
StudentContactID int 4 √ null
StudentContactSpouseID int 4 √ null
StudentContactMailName varchar 100 √ null
StudentContactMailSalutation varchar 100 √ null
StudentContactAddressComma varchar 200 √ null
StudentContactAddressFull varchar 200 √ null
StudentContactAddressDPID varchar 8 √ null
StudentContactAddressSortPlanNumber varchar 3 √ null
StudentContactHomeAddressComma varchar 200 √ null
StudentContactHomeAddressFull varchar 200 √ null
StudentContactHomeAddressSameFlag bit 1 √ null
StudentContactEmail varchar 100 √ null
StudentContactMobilePhone varchar 15 √ null
StudentContactDefaultMobilePhone varchar 15 √ null
StudentContactCountryCode varchar 5 √ null
StudentContactCountryDesc varchar 40 √ null
StudentContactMailFlag bit 1 √ null
StudentContactRaffleFlag bit 1 √ null
StudentContactDeceasedFlag bit 1 √ null
StudentContactTitle varchar 30 √ null
StudentContactNameInternal varchar 100 √ null
StudentContactNameExternal varchar 100 √ null
StudentContactLegalFullName varchar 150 √ null
StudentContactSurname varchar 30 √ null
StudentContactPreferred varchar 20 √ null
StudentContactPreferredFormal varchar 20 √ null
StudentContactOccupCompany varchar 50 √ null
StudentContactOccupType varchar 50 √ null
StudentContactOccupDescription varchar 120 √ null
StudentContactOccupCode varchar 15 √ null
StudentContactOccupPhone varchar 15 √ null
StudentContactOccupFax varchar 15 √ null
StudentContactDefaultEmailCode varchar 1 √ null
StudentContactOccupEmail varchar 100 √ null
StudentContactOccupMobilePhone varchar 15 √ null
StudentContactSpouseTitle varchar 30 √ null
StudentContactSpouseNameInternal varchar 100 √ null
StudentContactSpouseNameExternal varchar 100 √ null
StudentContactSpouseLegalFullName varchar 150 √ null
StudentContactSpouseSurname varchar 30 √ null
StudentContactSpousePreferred varchar 20 √ null
StudentContactSpousePreferredFormal varchar 20 √ null
StudentContactSpouseOccupCompany varchar 50 √ null
StudentContactSpouseOccupType varchar 50 √ null
StudentContactSpouseOccupDescription varchar 120 √ null
StudentContactSpouseOccupPhone varchar 15 √ null
StudentContactSpouseOccupFax varchar 15 √ null
StudentContactSpouseOccupEmail varchar 100 √ null
StudentContactSpouseEmail varchar 100 √ null
StudentContactSpouseDefaultEmailCode varchar 1 √ null
StudentContactSpouseMobilePhone varchar 15 √ null
StudentContactSpouseDefaultMobilePhone varchar 15 √ null
StudentContactSpouseOccupMobilePhone varchar 15 √ null
StudentContactHomePhone varchar 15 √ null
StudentContactHomePhoneAlt varchar 15 √ null
StudentContactHomeFax varchar 15 √ null
FileYear smallint 2 √ null
FileSemester smallint 2 √ null
BarCode varchar 20 √ null
StudiesCode varchar 15 null
TimetableCode varchar 15 null
ValidAddressFlag bit 1 √ null
CurrentSemesterOnlyFlag int 4 null
StudentFamilyPosition smallint 2 √ null
StudentCountryOfBirthCode varchar 5 √ null
StudentCountryOfBirthDescription varchar 40 √ null
StudentHomeLanguageCode varchar 5 √ null
StudentHomeLanguageDescription varchar 100 √ null
StudentContactCountryOfBirthCode varchar 5 √ null
StudentContactCountryOfBirthDescription varchar 40 √ null
StudentContactHomeLanguageCode varchar 5 √ null
StudentContactHomeLanguageDescription varchar 100 √ null
StudentContactSpouseCountryOfBirthCode varchar 5 √ null
StudentContactSpouseCountryOfBirthDescription varchar 40 √ null
StudentContactSpouseHomeLanguageCode varchar 5 √ null
StudentContactSpouseHomeLanguageDescription varchar 100 √ null
StudentSubSchool varchar 15 √ null
StudentEntrySubSchool varchar 15 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views