tMedicalIncidentsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
AuditAction varchar 30 √ null
Seq int identity 4 √ null
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
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 ('')

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
AK_tMedicalIncidentsHistory_ID Performance Asc/Asc ID + IncidentDate