TRUNCATE TABLE pal_MedicalCondition
SET IDENTITY_INSERT [dbo].[pal_MedicalCondition] ON 


INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (1, 1, N'Broken Bone', 1, 1, 1)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (2, 1, N'Cancer', 1, 1, 1)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (3, 1, N'Cerebral Vascular', 1, 1, 1)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (4, 1, N'Diabetes', 1, 1, 1)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (5, 1, N'Disability', 1, 1, 1)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (6, 1, N'Dislocations', 1, 1, 1)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (7, 1, N'Heart Attack', 1, 1, 1)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (8, 1, N'HIV/AIDS', 1, 1, 1)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (9, 1, N'Osteo Arthritis', 1, 1, 1)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (10, 1, N'Rheumatoid Arthritis', 1, 1, 1)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (11, 1, N'Tumors', 1, 1, 1)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (12, 2, N'Injuries', 1, 1, 1)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (13, 2, N'Surgeries', 1, 2, 1)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (14, 2, N'Childhood Diseases', 1, 3, 1)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (15, 2, N'Adult Diseases', 1, 4, 1)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (16, 3, N'Smoking', 1, 1, 1)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (17, 3, N'Alcohol Consumption', 1, 2, 1)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (18, 3, N'Recreational Drug Use', 1, 3, 1)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (19, 1, N'Other Serious Condition(s)', 1, 25, 1)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (20, 1, N'Broken Bone', 1, 1, 2)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (21, 1, N'Cancer', 1, 1, 2)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (22, 1, N'Cerebral Vascular', 1, 1, 2)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (23, 1, N'Diabetes', 1, 1, 2)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (24, 1, N'Disability', 1, 1, 2)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (25, 1, N'Dislocations', 1, 1, 2)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (27, 1, N'HIV/AIDS', 1, 1, 2)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (30, 1, N'Tumors', 1, 1, 2)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (31, 2, N'Injuries', 1, 1, 2)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (32, 2, N'Surgeries', 1, 2, 2)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (33, 2, N'Childhood Diseases', 1, 3, 2)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (34, 2, N'Adult Diseases', 1, 4, 2)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (35, 3, N'Smoking', 1, 1, 2)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (36, 3, N'Alcohol Consumption', 1, 2, 2)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (37, 3, N'Recreational Drug Use', 1, 3, 2)

INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (38, 1, N'Other Serious Condition(s)', 1, 25, 2)

SET IDENTITY_INSERT [dbo].[pal_MedicalCondition] OFF

TRUNCATE TABLE pal_MedicalPatientType
SET IDENTITY_INSERT [dbo].[pal_MedicalPatientType] ON 


INSERT [dbo].[pal_MedicalPatientType] ([recId], [patientType]) VALUES (1, N'Adult')

INSERT [dbo].[pal_MedicalPatientType] ([recId], [patientType]) VALUES (2, N'Paediatric')

SET IDENTITY_INSERT [dbo].[pal_MedicalPatientType] OFF

TRUNCATE TABLE pal_MedicalSymptom
SET IDENTITY_INSERT [dbo].[pal_MedicalSymptom] ON 


INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (1, N'ADD / ADHD', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (2, N'Allergies', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (3, N'Asthma', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (4, N'Back Curvature', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (5, N'Back Pain (Lower)', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (6, N'Back Pain (Middle)', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (7, N'Back Pain (Upper)', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (8, N'Bed Wetting', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (9, N'Blood Pressure (High)', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (10, N'Blood Pressure (Low)', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (11, N'Blurred Vision', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (12, N'Chest Pain', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (13, N'Colon Trouble', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (14, N'Convulsions / Epilepsy', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (15, N'Depression', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (16, N'Diarrhea / Constipation', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (17, N'Difficulty Breathing', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (18, N'Digestive Problems', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (19, N'Dizziness', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (20, N'Double Vision', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (21, N'Eating Disorder', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (22, N'Fainting', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (23, N'Foot or Knee Problems', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (24, N'Frequent Colds / Flu', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (25, N'Gall Bladder Trouble', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (26, N'Headache', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (27, N'Hearing Loss', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (28, N'Heart Problems', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (29, N'Heartburn', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (30, N'Hepatitis (A,B,C)', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (31, N'Hip Pain', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (32, N'Impotence / Sexual Dysfunction', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (33, N'Irritable', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (34, N'Jaw Pain / TMJ', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (35, N'Kidney Trouble', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (36, N'Learning Disability', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (37, N'Liver Trouble', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (38, N'Loss of Balance', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (39, N'Lung Problems', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (40, N'Menopausal Problems', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (41, N'Menstrual Problem', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (42, N'Mood Changes', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (43, N'Neck Pain', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (44, N'Numbness / Tingling (Arms/Hands/Fingers)', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (45, N'Numbness / Tingling (Legs/Feet/Toes)', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (46, N'Pain when Cough / Sneeze', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (47, N'Pregnant', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (48, N'Premenstrual Syndrome (PMS)', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (49, N'Prostate Problems', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (50, N'Ringing in Ears', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (51, N'Scoliosis', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (52, N'Shoulder Pain', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (53, N'Sinus / Drainage Problem', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (54, N'Skin Problems', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (55, N'Swollen / Painful Joints', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (56, N'Tremors', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (57, N'Trouble Sleeping / Insomnia', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (58, N'Ulcers', 1, 1)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (59, N'Allergies', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (60, N'Anemia', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (61, N'Arm Problems', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (62, N'Asthma', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (63, N'Backaches', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (64, N'Bed Wetting', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (65, N'Behavioral Problems', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (66, N'Chronic Earaches', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (67, N'Colds / Flu', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (68, N'Colic', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (69, N'Constipation', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (70, N'Diarrhea', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (71, N'Digestive Disorders', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (72, N'Dizziness', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (73, N'Fainting', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (74, N'Growing Pains', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (75, N'Headaches', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (76, N'Heart Trouble', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (77, N'Hypertension', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (78, N'Joint Problems', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (79, N'Muscle Pain', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (80, N'Neck Problems', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (81, N'Orthopedic Problems', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (82, N'Poor Appetite', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (83, N'Poor Posture', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (84, N'Scoliosis', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (85, N'Sinus Trouble', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (86, N'Sleeping Problems', 1, 2)

INSERT [dbo].[pal_MedicalSymptom] ([recId], [symptom], [isActive], [patientType]) VALUES (87, N'Walking Trouble', 1, 2)

SET IDENTITY_INSERT [dbo].[pal_MedicalSymptom] OFF

TRUNCATE TABLE pal_MedicalTraumaticEvent
SET IDENTITY_INSERT [dbo].[pal_MedicalTraumaticEvent] ON 


INSERT [dbo].[pal_MedicalTraumaticEvent] ([recId], [patientType], [traumaticEvent], [isActive]) VALUES (1, 2, N'Down Stairs', 1)

INSERT [dbo].[pal_MedicalTraumaticEvent] ([recId], [patientType], [traumaticEvent], [isActive]) VALUES (2, 2, N'From Bed or Couch', 1)

INSERT [dbo].[pal_MedicalTraumaticEvent] ([recId], [patientType], [traumaticEvent], [isActive]) VALUES (3, 2, N'From Changing Table', 1)

INSERT [dbo].[pal_MedicalTraumaticEvent] ([recId], [patientType], [traumaticEvent], [isActive]) VALUES (4, 2, N'From Crib', 1)

INSERT [dbo].[pal_MedicalTraumaticEvent] ([recId], [patientType], [traumaticEvent], [isActive]) VALUES (5, 2, N'From High Chair', 1)

INSERT [dbo].[pal_MedicalTraumaticEvent] ([recId], [patientType], [traumaticEvent], [isActive]) VALUES (6, 2, N'In Baby Walker', 1)

INSERT [dbo].[pal_MedicalTraumaticEvent] ([recId], [patientType], [traumaticEvent], [isActive]) VALUES (7, 2, N'Off Bicycle', 1)

INSERT [dbo].[pal_MedicalTraumaticEvent] ([recId], [patientType], [traumaticEvent], [isActive]) VALUES (8, 2, N'Off Monkey Bars', 1)

INSERT [dbo].[pal_MedicalTraumaticEvent] ([recId], [patientType], [traumaticEvent], [isActive]) VALUES (9, 2, N'Off Skateboard / Skates', 1)

INSERT [dbo].[pal_MedicalTraumaticEvent] ([recId], [patientType], [traumaticEvent], [isActive]) VALUES (10, 2, N'Off Slide', 1)

INSERT [dbo].[pal_MedicalTraumaticEvent] ([recId], [patientType], [traumaticEvent], [isActive]) VALUES (11, 2, N'Off Swing', 1)

SET IDENTITY_INSERT [dbo].[pal_MedicalTraumaticEvent] OFF

