| IncidentSeq |
int identity |
4 |
|
√ |
null |
|
|
|
| ID |
int |
4 |
|
|
null |
|
|
|
| ModifiedDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| ModifiedBy |
varchar |
50 |
√ |
|
('') |
|
|
|
| IncidentDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| IncidentType |
varchar |
15 |
|
|
('') |
|
|
|
| Diagnosis |
varchar |
2147483647 |
√ |
|
null |
|
|
|
| Despatch |
varchar |
2147483647 |
√ |
|
null |
|
|
|
|
varchar |
2147483647 |
√ |
|
null |
|
|
|
| FollowUpFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| FollowUp |
varchar |
2147483647 |
√ |
|
null |
|
|
|
| FollowUpDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| TimeIn |
varchar |
5 |
|
|
('') |
|
|
|
| TimeOut |
varchar |
5 |
|
|
('') |
|
|
|
| TreatedByDetails |
varchar |
2147483647 |
√ |
|
null |
|
|
|
| InjuryDetails |
varchar |
2147483647 |
√ |
|
null |
|
|
|
| ScaleOfInjuryCode |
varchar |
15 |
|
|
('') |
|
|
|
| HowInjurySustained |
varchar |
2147483647 |
√ |
|
null |
|
|
|
| InjuryActionTakenCode |
varchar |
15 |
|
|
('') |
|
|
|
| InjuryMedicationSubscribedDetails |
varchar |
2147483647 |
√ |
|
null |
|
|
|
| InjuryFollowUpDetails |
varchar |
2147483647 |
√ |
|
null |
|
|
|
| InjuryReferrelCode |
varchar |
15 |
|
|
('') |
|
|
|
| InjuryWitnessesDetails |
varchar |
2147483647 |
√ |
|
null |
|
|
|
| NotificationSentWithStudentFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| ParentPhonedNotificationFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| ParentPhonedNotificationDetails |
varchar |
255 |
√ |
|
('') |
|
|
|
| ParentMailedNotificationFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| ParentMailedNotificationDetails |
varchar |
255 |
√ |
|
('') |
|
|
|
| GuardianPhonedNotificationFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| GuardianPhonedNotificationDetails |
varchar |
255 |
√ |
|
('') |
|
|
|
| GuardianMailedNotificationFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| GuardianMailedNotificationDetails |
varchar |
255 |
√ |
|
('') |
|
|
|
| HeadOfHousePhonedNotificationFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| HeadOfHousePhonedNotificationDetails |
varchar |
255 |
√ |
|
('') |
|
|
|
| HeadOfHouseMailedNotificationFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| HeadOfHouseMailedNotificationDetails |
varchar |
255 |
√ |
|
('') |
|
|
|
| HeadOfHouseEMailedNotificationFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| HeadOfHouseEMailedNotificationDetails |
varchar |
255 |
√ |
|
('') |
|
|
|
| DirectorOfStudentsNotificationFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| DirectorOfStudentsNotificationDetails |
varchar |
255 |
√ |
|
('') |
|
|
|
| HeadOfSchoolNotificationFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| HeadOfSchoolNotificationDetails |
varchar |
255 |
√ |
|
('') |
|
|
|
| HeadmasterNotificationFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| HeadmasterNotificationDetails |
varchar |
255 |
√ |
|
('') |
|
|
|
| WorkcoverClaimSubmittedFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| WorkcoverClaimSubmittedDetails |
varchar |
255 |
√ |
|
('') |
|
|
|
| FollowupActionDetails |
varchar |
2147483647 |
√ |
|
null |
|
|
|
| InjuryMedicationSubscribedDescription |
varchar |
2147483647 |
√ |
|
null |
|
|
|
| VenueCode |
varchar |
15 |
|
|
('') |
|
|
|