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 Status

Person Status information.

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

This is how the dropdown list will display

Evacuation Type

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

This is how the dropdown list will display

Medical Care Information

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

This is how the dropdownlist will display

Injury Information

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	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 consciousness)	8
9	Head Injury (no change in consciousness)	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

This is how the dropdown list will display

Injury/Illness Anatomical Location

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

AnatomicalLocationID	AnatomicalLocation	SortOrder
1	None Indentified	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

This is how the dropdown list will display

Injury/Illness Severity

Severity Level for the injury or illness

SeverityID	SeverityLevel	SeverityType	SeverityDescription	SampleInjury	SampleIllness	SamplePropertyDamage	SampleEnvironmentalDamage	SampleEmotionalDamage
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

This is how the dropdown list will display

Illness Information

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

This is how the dropdown list will display