Incident Database Project

Injury/Illness Severity Lookup Table

Outdoor Ed — Fri, 06 Feb 2009 05:02:25 GMT

Current Revision posted to Incident Database Project by Outdoor Ed on 2/6/2009 12:02:25 AM

Severity Level for the Injury or Illness

SeverityID	SeverityLevel	SeverityType	SeverityDescription	SampleInjury	SampleIllness	SamplePropertyDamage	SampleEnvironmentalDamage	SampleEmotionalDamage	Active
1	1	1 - Minor	Minor	Splinters, insect bites, stings	Minor irritant	Minor cost	Littering	Temporary embarrassment	<input id="ctl00_MainColumn_GridView6_ctl02_ctl00" name="ctl00$MainColumn$GridView6$ctl02$ctl00" checked="checked" disabled="disabled" type="checkbox">
2	2	2 - Moderate	Moderate	Lacerations, frostnip, minor burns, mild concussion	Mild flu, migraine	<$50	Minor damage to environment that will quickly recover	Temporary embarrassment with peers	<input id="ctl00_MainColumn_GridView6_ctl03_ctl00" name="ctl00$MainColumn$GridView6$ctl03$ctl00" checked="checked" disabled="disabled" type="checkbox">
3	3	3 - Serious	Serious	Fractures, dislocations, frostbite, major burn	Flu, gastroenteritis, vomiting	>$100	Scorched campsite, plant damage	Shown up in front of group	<input id="ctl00_MainColumn_GridView6_ctl04_ctl00" name="ctl00$MainColumn$GridView6$ctl04$ctl00" checked="checked" disabled="disabled" type="checkbox">
4	4	4 - Severe	Severe	Arterial bleeding, severe hypo/hyperthermia	Infection or illness causing loss of consciousness, serious medical emergency	>$500	Burnt shrubs, cut life branches to burn, washed group dishes in stream, etc	Does not want to participate again in this session	<input id="ctl00_MainColumn_GridView6_ctl05_ctl00" name="ctl00$MainColumn$GridView6$ctl05$ctl00" checked="checked" disabled="disabled" type="checkbox">
5	5	5 - Critical	Critical	Spinal damage, concussion	Major illness requiring hospitalisation	>$2,000	Walked through sensitive ecological area destroying some plant life	Wants to leave group. A lot of work to bring back in.	<input id="ctl00_MainColumn_GridView6_ctl06_ctl00" name="ctl00$MainColumn$GridView6$ctl06$ctl00" checked="checked" disabled="disabled" type="checkbox">
6	6	6 - Unsurvivable	Unsurvivable	Single death	Single death	>$8,000	Destroyed/killed some example of flora/fauna	Leaves group and requires on site counseling	<input id="ctl00_MainColumn_GridView6_ctl07_ctl00" name="ctl00$MainColumn$GridView6$ctl07$ctl00" checked="checked" disabled="disabled" type="checkbox">
7	7	7 - Major impact	Major impact on individual(s) that would mean they were unable to continue with large parts of the programme	Arterial bleeding, severe hypo/hyperthermia	Infection or illness causing loss of consciousness, serious medical emergency	>$20,000	Killed, destroyed or polluted small area of environment	Therapy/counseling required by professional	<input id="ctl00_MainColumn_GridView6_ctl08_ctl00" name="ctl00$MainColumn$GridView6$ctl08$ctl00" disabled="disabled" type="checkbox">
8	8	8 - Life changing effect	Life changing effect on individual(s) or death	Spinal damage, concussion	Major illness requiring hospitalisation	>$50,000	Killed example of protected species	Long term therapy required after incident	<input id="ctl00_MainColumn_GridView6_ctl09_ctl00" name="ctl00$MainColumn$GridView6$ctl09$ctl00" disabled="disabled" type="checkbox">
9	9	9 - Life changing effect	Life changing effect on individual(s) or death	Single death	Single Death	> $250,000	Fire or pollution etc resulting in area of wilderness being destroyed	Suicide because of incident	<input id="ctl00_MainColumn_GridView6_ctl10_ctl00" name="ctl00$MainColumn$GridView6$ctl10$ctl00" disabled="disabled" type="checkbox">
10	10	10 - Life changing effect	Life changing effect on individual(s) or death	Multiple fatality	Multiple fatality	> $1,000,000	Killed example of protected species

Illness Information Lookup Table

Outdoor Ed — Fri, 06 Feb 2009 05:00:31 GMT

Current Revision posted to Incident Database Project by Outdoor Ed on 2/6/2009 12:00:31 AM

Illness information. Multiple selections are possible. This is a separate Child Table of the Person Table. With each record in the Illness Table is an Anatomical Location and a Severity Level show in the tables above.

IllnessTypeID	IllnessType	SortOrder
1	Abdominal pain	1
2	Allergic reaction - localized	2
3	Altitude - AMS	3
4	Apparent food-related Illness	4
5	Chest pain or cardiac condition	5
6	Dehydration	6
7	Diarrhea	7
8	Eye infection	8
9	Flu symptoms/common cold	9
10	Heat illness	10
11	Hypothermia	11
12	Nausea or vomiting	12
13	Nonspecific fever illness	13
14	Urinary tract infection	14
15	Allergic reaction - systemic	15
16	Altitude - HAPE	16
17	Altitude - HACE	17
18	Heat Exhaustion	18
19	Heat Cramps	19
20	Heat Stroke	20
21	Hyponatremia	21
22	Upper Respiratory - congestion	22
23	Upper Respiratory - other	23
24	Nonspecific fever	24
25	Skin infection	25
26	Ear infection	26
27	Gastrointestinal problem without diarrhea	27

Injury Information Lookup Table

Outdoor Ed — Fri, 06 Feb 2009 04:57:54 GMT

Current Revision posted to Incident Database Project by Outdoor Ed on 2/5/2009 11:57:54 PM

Injury information. Multiple selections are possible. This is a separate Child Table of the Person Table. With each record in the Injury Table is an Anatomical Location and a Severity Level shown in the tables below.

InjuryTypeID	InjuryType	Active	SortOrder
1	Blister(s)		1
2	Burn		2
3	Dental		3
4	Dislocation		4
5	Eye Injury		5
6	Fracture		6
7	Frostbite		7
8	Head Injury (change in consciousnes)		8
9	Head Injury (no change in consciousnes)		9
10	Immersion Foot		10
11	Ligament Sprain		11
12	Muscle Strain		12
13	Near Drowning or Immersion		13
14	Soft Tissue (bruse, wound, abrasion)		14
15	Sunburn	<	15
16	Tendonitis		16
17	Drowning		17
18	Bruise, contusion		18
19	Laceration		19
20	Skin abrasions		20

Anatomical Location Lookup Table

Outdoor Ed — Fri, 06 Feb 2009 04:55:18 GMT

Current Revision posted to Incident Database Project by Outdoor Ed on 2/5/2009 11:55:18 PM

Anatomical Location for the injury or illness (this table is used for both injuries and illnesses)

AnatomicalLocationID	AnatomicalLocation	SortOrder
1	Abdomen	1
2	Ankle	2
3	Chest	3
4	Elbow	4
5	Eye	5
6	Face	6
7	Foot	7
8	Forearm	8
9	Hand/Fingers	9
10	Head	10
11	Hip	11
12	Knee	12
13	Lower Back	13
14	Lower Leg	14
15	Neck	15
16	Pelvis	16
17	Shoulder	17
18	Thigh	18
19	Toe	19
20	Upper Arm	20
21	Upper Back	21
22	Wrist	22
23	Systemic	23
24	Not Applicable	24

Medical Care Information Lookup Table

Outdoor Ed — Fri, 06 Feb 2009 04:52:31 GMT

Current Revision posted to Incident Database Project by Outdoor Ed on 2/5/2009 11:52:31 PM

Medical Care information

MedicalCareID	MedicalCare	SortOrder
1	None	1
2	Outpatient	3
3	Emergency Room/Clinic	4
4	Hospital Admission	5
5	Home Care	2

Evacuation Type Lookup Table

Outdoor Ed — Fri, 06 Feb 2009 04:50:53 GMT

Current Revision posted to Incident Database Project by Outdoor Ed on 2/5/2009 11:50:53 PM

Evacuation Type Lookup Table

incident database

Evacuation Type information

EvacuationTypeID	EvacuationType	SortOrder
1	None Required	1
2	Unassisted	2
3	Assisted	3
4	Litter	4
5	Vehicle	5
6	Helicopter/Plane	6
7	Boat	7

Evacuation Type Lookup Table

Outdoor Ed — Fri, 06 Feb 2009 04:50:29 GMT

Revision 1 posted to Incident Database Project by Outdoor Ed on 2/5/2009 11:50:29 PM

Evacuation Type information

EvacuationTypeID	EvacuationType	SortOrder
1	None Required	1
2	Unassisted	2
3	Assisted	3
4	Litter	4
5	Vehicle	5
6	Helicopter/Plane	6
7	Boat	7

Person Status Lookup Table

Outdoor Ed — Fri, 06 Feb 2009 04:49:09 GMT

Current Revision posted to Incident Database Project by Outdoor Ed on 2/5/2009 11:49:09 PM

Person Status information

PersonStatusID	PersonStatus	SortOrder
1	Client/Participant	1
2	Instructor/Staff	2
3	Parent	4
4	Bystander	5
5	Entire Group	3

Person Lookup Tables

Outdoor Ed — Fri, 06 Feb 2009 04:47:51 GMT

Current Revision posted to Incident Database Project by Outdoor Ed on 2/5/2009 11:47:51 PM

Person Lookup Tables

incident database

Person Information Lookup Tables
These are the values for lookup tables that link directly to the People Table and the values for the Child Tables that relate directly to the People Table for those instances where there are multiple selections available.

The International Incident Database design is a copyright of Copyright © 2000 - 2009 Outdoor Ed LLC. All rights reserved.

Person Lookup Tables

Outdoor Ed — Fri, 06 Feb 2009 04:47:32 GMT

Revision 2 posted to Incident Database Project by Outdoor Ed on 2/5/2009 11:47:32 PM

Person Lookup Tables

incident database

This section

Person Information Lookup Tables

These are the values for lookup tables that link directly to the People Table and the values for the Child Tables that relate directly to the People Table for those instances where there are multiple selections available.

Person Lookup Tables

Outdoor Ed — Fri, 06 Feb 2009 04:46:35 GMT

Revision 1 posted to Incident Database Project by Outdoor Ed on 2/5/2009 11:46:35 PM

This section

Contributing Factors Lookup Table

Outdoor Ed — Fri, 06 Feb 2009 04:44:22 GMT

Current Revision posted to Incident Database Project by Outdoor Ed on 2/5/2009 11:44:22 PM

Contributing Factors Lookup Table

incident database

Contributing Factors

This is the Contributing Factors. Multiple selections are possible. This is a separate Child Table of the Incident Table.

ContributingFactorID	ContributingFactor	Active	SortOrder
1	Altitude		1
2	Avalanche		2
3	Animal Encounter		3
4	Carelessness		4
5	Cold Exposure	/td>		5
6	Dehydration		6
7	Equipment		7
8	Exceeded ability		8
9	Exhaustion		9
10	Fall on rock		10
11	Fall on snow		11
12	Fall/slip on trail		12
13	Falling tree/branch		13
14	Fitness/ability		14
15	Hygiene - poor		15
16	Immersion/submersion		16
17	Instruction		17
18	Inattention		18
19	Loose Rock		19
20	Misbehavior		20
21	Missing/lost		21
22	Not following instructions		22
23	Overuse injury		23
24	Plant poisoning/toxicity/contact		24
25	Technique - poor		25
26	Preexisting medical condition		26
27	Psychological issue		27
28	Rock fall	<		28
29	Screening - improper		29
30	Sun		30
31	Supervision - inadequate	<		31
32	Technical system failure		32
33	Unknown		33
34	Visibility - poor		34
35	Weather		35
36	Cultural Misunderstanding		36
37	Failure to follow instructions		37
38	Inexperience		38
39	Poor Judgment		39
40	Intoxication (alcohol/drugs)		40
41	Lightning		41
42	Insect(s)		42

Contributing Factors Lookup Table

Outdoor Ed — Fri, 06 Feb 2009 04:43:15 GMT

Revision 1 posted to Incident Database Project by Outdoor Ed on 2/5/2009 11:43:15 PM

Contributing Factors

This is the Contributing Factors. Multiple selections are possible. This is a separate Child Table of the Incident Table.

ContributingFactorID	ContributingFactor	Active	SortOrder
1	Altitude		1
2	Avalanche		2
3	Animal Encounter		3
4	Carelessness		4
5	Cold Exposure	/td>	5
6	Dehydration		6
7	Equipment		7
8	Exceeded ability		8
9	Exhaustion		9
10	Fall on rock		10
11	Fall on snow		11
12	Fall/slip on trail		12
13	Falling tree/branch		13
14	Fitness/ability		14
15	Hygiene - poor		15
16	Immersion/submersion		16
17	Instruction		17
18	Inattention		18
19	Loose Rock		19
20	Misbehavior		20
21	Missing/lost		21
22	Not following instructions		22
23	Overuse injury		23
24	Plant poisoning/toxicity/contact		24
25	Technique - poor		25
26	Preexisting medical condition		26
27	Psychological issue		27
28	Rock fall	<	28
29	Screening - improper		29
30	Sun		30
31	Supervision - inadequate	<	31
32	Technical system failure		32
33	Unknown		33
34	Visibility - poor		34
35	Weather		35
36	Cultural Misunderstanding		36
37	Failure to follow instructions		37
38	Inexperience		38
39	Poor Judgment		39
40	Intoxication (alcohol/drugs)		40
41	Lightning		41
42	Insect(s)		42

Damage Type Lookup Table

Outdoor Ed — Fri, 06 Feb 2009 04:40:10 GMT

Current Revision posted to Incident Database Project by Outdoor Ed on 2/5/2009 11:40:10 PM

Damage Type

This is the Damage Type. Multiple selections are possible. This is a separate Child Table of the Incident Table.

DamageTypeID	DamageType	SortOrder
1	None	1
2	Program Equipment	2
3	Personal Equipment	3
4	Vehicle	4
5	Other	5

Damage Severity Lookup Table

Outdoor Ed — Fri, 06 Feb 2009 04:38:59 GMT

Current Revision posted to Incident Database Project by Outdoor Ed on 2/5/2009 11:38:59 PM

Damage Severity

This is the Damage Severity Level

DamageSeverityID	DamageSeverity	Active	SortOrder
1	None		1
2	Minor Cost		2
3	Moderate Cost		3
4	Major Cost	<	4
5	Catastrophic Cost		5

Incident Severity Lookup Table

Outdoor Ed — Fri, 06 Feb 2009 04:37:11 GMT

Current Revision posted to Incident Database Project by Outdoor Ed on 2/5/2009 11:37:11 PM

Incident Severity

This is the Incident Severity Level

SeverityID	SeverityLevel	SeverityType	SeverityDescription	SampleInjury	SampleIllness	SamplePropertyDamage	SampleEnvironmentalDamage	SampleEmotionalDamage	Active
1	1	1 - Minor	Minor	Splinters, insect bites, stings	Minor irritant	Minor cost	Littering	Temporary embarrassment	<input id="ctl00_MainColumn_GridView10_ctl02_ctl00" name="ctl00$MainColumn$GridView10$ctl02$ctl00" checked="checked" disabled="disabled" type="checkbox">
2	2	2 - Moderate	Moderate	Lacerations, frostnip, minor burns, mild concussion	Mild flu, migraine	<$50	Minor damage to environment that will quickly recover	Temporary embarrassment with peers	<input id="ctl00_MainColumn_GridView10_ctl03_ctl00" name="ctl00$MainColumn$GridView10$ctl03$ctl00" checked="checked" disabled="disabled" type="checkbox">
3	3	3 - Serious	Serious	Fractures, dislocations, frostbite, major burn	Flu, gastroenteritis, vomiting	>$100	Scorched campsite, plant damage	Shown up in front of group	<input id="ctl00_MainColumn_GridView10_ctl04_ctl00" name="ctl00$MainColumn$GridView10$ctl04$ctl00" checked="checked" disabled="disabled" type="checkbox">
4	4	4 - Severe	Severe	Arterial bleeding, severe hypo/hyperthermia	Infection or illness causing loss of consciousness, serious medical emergency	>$500	Burnt shrubs, cut life branches to burn, washed group dishes in stream, etc	Does not want to participate again in this session	<input id="ctl00_MainColumn_GridView10_ctl05_ctl00" name="ctl00$MainColumn$GridView10$ctl05$ctl00" checked="checked" disabled="disabled" type="checkbox">
5	5	5 - Critical	Critical	Spinal damage, concussion	Major illness requiring hospitalisation	>$2,000	Walked through sensitive ecological area destroying some plant life	Wants to leave group. A lot of work to bring back in.	<input id="ctl00_MainColumn_GridView10_ctl06_ctl00" name="ctl00$MainColumn$GridView10$ctl06$ctl00" checked="checked" disabled="disabled" type="checkbox">
6	6	6 - Unsurvivable	Unsurvivable	Single death	Single death	>$8,000	Destroyed/killed some example of flora/fauna	Leaves group and requires on site counseling	<input id="ctl00_MainColumn_GridView10_ctl07_ctl00" name="ctl00$MainColumn$GridView10$ctl07$ctl00" checked="checked" disabled="disabled" type="checkbox">
7	7	7 - Major impact	Major impact on individual(s) that would mean they were unable to continue with large parts of the programme	Arterial bleeding, severe hypo/hyperthermia	Infection or illness causing loss of consciousness, serious medical emergency	>$20,000	Killed, destroyed or polluted small area of environment	Therapy/counseling required by professional	<input id="ctl00_MainColumn_GridView10_ctl08_ctl00" name="ctl00$MainColumn$GridView10$ctl08$ctl00" disabled="disabled" type="checkbox">
8	8	8 - Life changing effect	Life changing effect on individual(s) or death	Spinal damage, concussion	Major illness requiring hospitalisation	>$50,000	Killed example of protected species	Long term therapy required after incident	<input id="ctl00_MainColumn_GridView10_ctl09_ctl00" name="ctl00$MainColumn$GridView10$ctl09$ctl00" disabled="disabled" type="checkbox">
9	9	9 - Life changing effect	Life changing effect on individual(s) or death	Single death	Single Death	> $250,000	Fire or pollution etc resulting in area of wilderness being destroyed	Suicide because of incident	<input id="ctl00_MainColumn_GridView10_ctl10_ctl00" name="ctl00$MainColumn$GridView10$ctl10$ctl00" disabled="disabled" type="checkbox">
10	10	10 - Life changing effect	Life changing effect on individual(s) or death	Multiple fatality	Multiple fatality	> $1,000,000	Killed example of protected species

Wind Speed Lookup Table

Outdoor Ed — Fri, 06 Feb 2009 04:35:22 GMT

Current Revision posted to Incident Database Project by Outdoor Ed on 2/5/2009 11:35:22 PM

Wind Speed

This is the Wind speed at the time of the incident

WindSpeedID	BeaufortForce	Knots	MPH	KPH	WMOClassification
1	0	0 knots	0 mph	0 kph	Calm
2	1	1-3 knots	1-3 mph	1-6 kph	Light Air
3	2	4-6 knots	4-7 mph	7-11 kph	Light Breeze
4	3	7-10 knots	8-12 mph	12-19 kph	Gentle Breeze
5	4	11-16 knots	13-18 mph	20-29 kph	Moderate Breeze
6	5	17-21 knots	19-24 mph	30-39 kph	Fresh Breeze
7	6	22-27 knots	25-31 mph	40-50 kph	Strong Breeze
8	7	28-33 knots	32-38 mph	51-62 kph	Near Gale
9	8	34-40 knots	39-46 mph	63-75 kph	Gale
10	9	41-47 knots	47-54 mph	76-87 kph	Strong Gale
11	10	48-55 knots	55-63 mph	88-102 kph	Storm
12	11	56-63 knots	64-72 mph	103-117 kph	Violent Storm
13	12	>63 knots	>72 mph	>117 kph	Hurricane

Incident Database Lookup Tables

Outdoor Ed — Fri, 06 Feb 2009 04:33:40 GMT

Current Revision posted to Incident Database Project by Outdoor Ed on 2/5/2009 11:33:40 PM

Incident Database Lookup Tables

incident database

Incident Database Lookup Tables

These are the basic lookup tables for the Incidents Table.

Incident Category Lookup Table

Outdoor Ed — Fri, 06 Feb 2009 04:32:46 GMT

Current Revision posted to Incident Database Project by Outdoor Ed on 2/5/2009 11:32:46 PM

Incident Category Lookup Table

incident database

Incident Categories

IncidentCategoryID	IncidentCategory	IncidentCategoryDescription	Active	SortOrder
1	Close Call	A situation where damage or injury could have occurred but did not.		1
2	Incident	A situation where damage or injury did occur.		2

Incident Type Lookup Table

Outdoor Ed — Fri, 06 Feb 2009 04:32:33 GMT

Current Revision posted to Incident Database Project by Outdoor Ed on 2/5/2009 11:32:33 PM

Incident Type Lookup Table

incident database

Incident Type

IncidentTypeID	IncidentType	SortOrder
1	Injury	1
2	Illness	2
3	Motivational/Behavioral	3
4	Psychological	4
5	Fatality	5
6	Crime	6
7	Harassment	7
8	Sexual Contact	8