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

GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (1, 1, N'Broken Bone', 1, 1, 1)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (2, 1, N'Cancer', 1, 1, 1)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (3, 1, N'Cerebral Vascular', 1, 1, 1)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (4, 1, N'Diabetes', 1, 1, 1)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (5, 1, N'Disability', 1, 1, 1)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (6, 1, N'Dislocations', 1, 1, 1)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (7, 1, N'Heart Attack', 1, 1, 1)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (8, 1, N'HIV/AIDS', 1, 1, 1)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (9, 1, N'Osteo Arthritis', 1, 1, 1)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (10, 1, N'Rheumatoid Arthritis', 1, 1, 1)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (11, 1, N'Tumors', 1, 1, 1)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (12, 2, N'Injuries', 1, 1, 1)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (13, 2, N'Surgeries', 1, 2, 1)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (14, 2, N'Childhood Diseases', 1, 3, 1)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (15, 2, N'Adult Diseases', 1, 4, 1)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (16, 3, N'Smoking', 1, 1, 1)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (17, 3, N'Alcohol Consumption', 1, 2, 1)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (18, 3, N'Recreational Drug Use', 1, 3, 1)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (19, 1, N'Other Serious Condition(s)', 1, 25, 1)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (20, 1, N'Broken Bone', 1, 1, 2)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (21, 1, N'Cancer', 1, 1, 2)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (22, 1, N'Cerebral Vascular', 1, 1, 2)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (23, 1, N'Diabetes', 1, 1, 2)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (24, 1, N'Disability', 1, 1, 2)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (25, 1, N'Dislocations', 1, 1, 2)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (27, 1, N'HIV/AIDS', 1, 1, 2)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (30, 1, N'Tumors', 1, 1, 2)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (31, 2, N'Injuries', 1, 1, 2)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (32, 2, N'Surgeries', 1, 2, 2)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (33, 2, N'Childhood Diseases', 1, 3, 2)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (34, 2, N'Adult Diseases', 1, 4, 2)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (35, 3, N'Smoking', 1, 1, 2)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (36, 3, N'Alcohol Consumption', 1, 2, 2)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (37, 3, N'Recreational Drug Use', 1, 3, 2)
GO
INSERT [dbo].[pal_MedicalCondition] ([recId], [conditionType], [condition], [isActive], [sequence], [patientType]) VALUES (38, 1, N'Other Serious Condition(s)', 1, 25, 2)
GO
SET IDENTITY_INSERT [dbo].[pal_MedicalCondition] OFF
GO

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

GO
INSERT [dbo].[pal_MedicalPatientType] ([recId], [patientType]) VALUES (1, N'Adult')
GO
INSERT [dbo].[pal_MedicalPatientType] ([recId], [patientType]) VALUES (2, N'Paediatric')
GO
SET IDENTITY_INSERT [dbo].[pal_MedicalPatientType] OFF
GO

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

GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (1, 1, N'ADD / ADHD', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (2, 1, N'Allergies', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (3, 1, N'Asthma', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (4, 1, N'Back Curvature', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (5, 1, N'Back Pain (Lower)', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (6, 1, N'Back Pain (Middle)', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (7, 1, N'Back Pain (Upper)', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (8, 1, N'Bed Wetting', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (9, 1, N'Blood Pressure (High)', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (10, 1, N'Blood Pressure (Low)', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (11, 1, N'Blurred Vision', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (12, 1, N'Chest Pain', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (13, 1, N'Colon Trouble', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (14, 1, N'Convulsions / Epilepsy', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (15, 1, N'Depression', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (16, 1, N'Diarrhea / Constipation', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (17, 1, N'Difficulty Breathing', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (18, 1, N'Digestive Problems', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (19, 1, N'Dizziness', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (20, 1, N'Double Vision', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (21, 1, N'Eating Disorder', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (22, 1, N'Fainting', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (23, 1, N'Foot or Knee Problems', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (24, 1, N'Frequent Colds / Flu', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (25, 1, N'Gall Bladder Trouble', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (26, 1, N'Headache', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (27, 1, N'Hearing Loss', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (28, 1, N'Heart Problems', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (29, 1, N'Heartburn', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (30, 1, N'Hepatitis (A,B,C)', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (31, 1, N'Hip Pain', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (32, 1, N'Impotence / Sexual Dysfunction', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (33, 1, N'Irritable', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (34, 1, N'Jaw Pain / TMJ', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (35, 1, N'Kidney Trouble', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (36, 1, N'Learning Disability', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (37, 1, N'Liver Trouble', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (38, 1, N'Loss of Balance', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (39, 1, N'Lung Problems', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (40, 1, N'Menopausal Problems', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (41, 1, N'Menstrual Problem', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (42, 1, N'Mood Changes', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (43, 1, N'Neck Pain', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (44, 1, N'Numbness / Tingling (Arms/Hands/Fingers)', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (45, 1, N'Numbness / Tingling (Legs/Feet/Toes)', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (46, 1, N'Pain when Cough / Sneeze', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (47, 1, N'Pregnant', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (48, 1, N'Premenstrual Syndrome (PMS)', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (49, 1, N'Prostate Problems', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (50, 1, N'Ringing in Ears', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (51, 1, N'Scoliosis', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (52, 1, N'Shoulder Pain', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (53, 1, N'Sinus / Drainage Problem', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (54, 1, N'Skin Problems', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (55, 1, N'Swollen / Painful Joints', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (56, 1, N'Tremors', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (57, 1, N'Trouble Sleeping / Insomnia', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (58, 1, N'Ulcers', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (59, 2, N'Allergies', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (60, 2, N'Anemia', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (61, 2, N'Arm Problems', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (62, 2, N'Asthma', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (63, 2, N'Backaches', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (64, 2, N'Bed Wetting', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (65, 2, N'Behavioral Problems', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (66, 2, N'Chronic Earaches', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (67, 2, N'Colds / Flu', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (68, 2, N'Colic', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (69, 2, N'Constipation', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (70, 2, N'Diarrhea', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (71, 2, N'Digestive Disorders', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (72, 2, N'Dizziness', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (73, 2, N'Fainting', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (74, 2, N'Growing Pains', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (75, 2, N'Headaches', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (76, 2, N'Heart Trouble', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (77, 2, N'Hypertension', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (78, 2, N'Joint Problems', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (79, 2, N'Muscle Pain', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (80, 2, N'Neck Problems', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (81, 2, N'Orthopedic Problems', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (82, 2, N'Poor Appetite', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (83, 2, N'Poor Posture', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (84, 2, N'Scoliosis', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (85, 2, N'Sinus Trouble', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (86, 2, N'Sleeping Problems', 1)
GO
INSERT [dbo].[pal_MedicalSymptom] ([recId], [patientType], [symptom], [isActive]) VALUES (87, 2, N'Walking Trouble', 1)
GO
SET IDENTITY_INSERT [dbo].[pal_MedicalSymptom] OFF
GO
