International Incident Database Lookup Table Values

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

Incident Category

Categories of Incidents

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

Here is how the dropdown list will display

Incident Type

Types of Incidents

IncidentTypeID	IncidentType	Active	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
9	Property Damage		9

Here is how the dropdown list will display

Incident Review Status

Incident Review Status

IncidentReviewStatusID	IncidentReviewStatus	Active	SortOrder
1	Review Not Required		1
2	Requires Review		2
3	Under Review		3
4	Review Completed		4

Here is how the dropdown list will display

Grid Type

Grid Reference Type

GridTypeID	GridType	Active	SortOrder
1	None		1
2	Latitude Longitude		2
3	UTM		3

Here is how the dropdown list will display

Map Datum Type

Map Datum Type

MapDatumID	MapDatum	Active	SortOrder
1	None Selected		1
2	NAD87		2
3	NAD23		3

Here is how the dropdown list will display

Activity Type

Activity Type

ActivityTypeID	ActivityType	Active	SortOrder
1	Backpacking		1
2	Camping		2
3	Canoeing		3
4	Caving		4
5	Cooking		5
6	Cycling		6
7	Dog sledding		7
8	Glacier travel		8
9	Hiking (no pack)		9
10	Horseback riding		10
11	Independent travel		11
12	Initiative game		12
13	Mountaineering		13
14	Portage		14
15	Rafting		15
16	Rappelling		16
17	River crossing		17
18	River kayaking		18
19	Rock climbing		19
20	Ropes course		20
21	Running		21
22	Sailing		22
23	Sea kayaking		23
24	Service project		24
25	Skiing (Telemark, downhill)		25
26	Ski touring		26
27	Snowboarding		27
28	Snow/Ice Climbing		28
29	Snowshoeing		29
30	Solo		30
31	Swim/Dip		31
32	Transportation		32
33	Bike Touring		33
34	Biking (day only)		34
35	Biking - Mountain		35
36	Sportyak		36
37	Urban Activity		37
38	Unaccompanied travel		38

Here is how the dropdown list will display. One question is should this be single choice for activity or multiple choices. In the first case it will be part of the Incident Table; in the second case it would require a child table related to the parent Incident Table.

Type of Environment(s)

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

EnvironmentTypeID	EnvironmentType	Active	SortOrder
1	River		1
2	Lake		2
3	Ocean		3
4	Forest		4
5	Mountain		5
6	Cliff		6
7	Glacier		7
8	Snow/Ice		8
9	Desert		9
10	Urban		10
11	Suburban		11
12	Farm		12
13	Road		13

Here is how the listbox will display.

(multiple selections permitted)

Environmental Conditions

These are the Environmental Conditions during the incident. Multiple selections are possible. This is a separate Child Table of the Incident Table.

EnvironmentalConditionID	EnvironmentalCondition	Active	SortOrder
1	Wet		1
2	Dry		2
3	Snow		3
4	Ice		4
5	Trail		5
6	Rock		6
7	Uneven		7
8	Flat		8
9	Sloped		9
10	Water - Calm		10
11	Water - Swift		11
12	Water - Rough		12
13	Water - Choppy		13
14	Water - High Waves		14
15	Water - Rapids		15

Here is how the listbox will display.

(multiple selections permitted)

Weather Conditions

These are the Weather Conditions during the incident. Multiple selections are possible. This is a separate Child Table of the Incident Table.

WeatherConditionID	WeatherCondition	Active	SortOrder
1	Clear		1
2	Rain		2
3	Snow		3
4	Sleet		4
5	Lighting		5
6	Fog		6
7	Wind		7

Here is how the listbox will display.

(multiple selections permitted)

Wind Speed

This is the Wind speed at the time of the incident

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

Here is how the dropdownlist will display.

Incident Severity

This is the Incident Severity Level

SeverityID	SeverityLevel	SeverityType	SeverityDescription	SampleInjury	SampleIllness	SamplePropertyDamage	SampleEnvironmentalDamage	SampleEmotionalDamage	Active
1	0	Not Known	Not Known	Not Known	Not Known	Not Known	Not Known	Not Known
2	1	1 - Minor	Minor	Splinters, insect bites, stings	Minor irritant	Minor cost	Littering	Temporary embarrassment
3	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
4	3	3 - Serious	Serious	Fractures, dislocations, frostbite, major burn	Flu, gastroenteritis, vomiting	>$100	Scorched campsite, plant damage	Does not want to participate again in this session
5	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
6	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.
7	6	6 - Unsurvivable	Unsurvivable	Single death	Single death	>$8,000	Destroyed/killed some example of flora/fauna	Leaves group and requires on site counseling
8	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
9	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
10	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
12	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	Multiple fatality

Here is how the dropdownlist will display.

Damage Severity

This is the Damage Severity Level

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

Here is how the dropdownlist will display.

Damage Type

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

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

Here is how the listbox will display.

(multiple selections permitted)

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		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

Here is how the listbox will display.

(multiple selections permitted)