 INSERT INTO `listvalues` (`ListID`,`ValueKey`,`ValueDesc`,`OrderID`,`modified`) SELECT `ListID`,'DIVORCED',NULL,0,'2009-01-24 20:57:59' FROM `list` where `ListName`='CaregiverMaritalStatus';
 INSERT INTO `listvalues` (`ListID`,`ValueKey`,`ValueDesc`,`OrderID`,`modified`) SELECT `ListID`,'MARRIED',NULL,0,'2009-01-24 20:57:59' FROM `list` where `ListName`='CaregiverMaritalStatus';
 INSERT INTO `listvalues` (`ListID`,`ValueKey`,`ValueDesc`,`OrderID`,`modified`) SELECT `ListID`,'SINGLE',NULL,0,'2009-01-24 20:57:59' FROM `list` where `ListName`='CaregiverMaritalStatus';
-INSERT INTO `listvalues` (`ListID`,`ValueKey`,`ValueDesc`,`OrderID`,`modified`) SELECT `ListID`,'GENERAL','Generic Consent',0,'2009-09-11 14:15:00' FROM `list` where `ListName`='ConsentType';
 INSERT INTO `listvalues` (`ListID`,`ValueKey`,`ValueDesc`,`OrderID`,`modified`) SELECT `ListID`,'Email',NULL,0,'2009-01-24 20:57:59' FROM `list` where `ListName`='ContactMethods';
 INSERT INTO `listvalues` (`ListID`,`ValueKey`,`ValueDesc`,`OrderID`,`modified`) SELECT `ListID`,'Fax',NULL,0,'2009-01-24 20:57:59' FROM `list` where `ListName`='ContactMethods';
 INSERT INTO `listvalues` (`ListID`,`ValueKey`,`ValueDesc`,`OrderID`,`modified`) SELECT `ListID`,'Letter',NULL,0,'2009-01-24 20:57:59' FROM `list` where `ListName`='ContactMethods';

INSERT INTO viewproperty (`messageCode`,`locale`,`instance`,`scope`,`prefix`,`entity`,`property`,`section`,`context`,`style`,`required`,`label`,`maxLength`,`size`,`indentLevel`,`attributes`,`list`,`listAttributes`,`propOrder`,`quickHelp`,`modified`) VALUES('*.patient.testingLanguage','en','lava','crms',NULL,'Patient','testingLanguage','Language Details','i','suggest','No','Testing Language',25,NULL,0,'','patient.patientLanguage',NULL,16,'','2009-01-24 21:28:51');
INSERT INTO viewproperty (`messageCode`,`locale`,`instance`,`scope`,`prefix`,`entity`,`property`,`section`,`context`,`style`,`required`,`label`,`maxLength`,`size`,`indentLevel`,`attributes`,`list`,`listAttributes`,`propOrder`,`quickHelp`,`modified`) VALUES('*.patient.transLanguage','en','lava','crms',NULL,'Patient','transLanguage','Language Details','i','suggest','No','Interpreter Type',25,NULL,0,'','patient.patientLanguage',NULL,16,'','2009-01-24 21:28:51');
INSERT INTO viewproperty (`messageCode`,`locale`,`instance`,`scope`,`prefix`,`entity`,`property`,`section`,`context`,`style`,`required`,`label`,`maxLength`,`size`,`indentLevel`,`attributes`,`list`,`listAttributes`,`propOrder`,`quickHelp`,`modified`) VALUES('*.patient.vaInsur','en','lava','crms',NULL,'Patient','vaInsur','Insurance Details','i','range','No','VAinsur',NULL,NULL,0,'','generic.yesNoDK',NULL,16,'','2009-01-24 21:28:51');
INSERT INTO viewproperty (`messageCode`,`locale`,`instance`,`scope`,`prefix`,`entity`,`property`,`section`,`context`,`style`,`required`,`label`,`maxLength`,`size`,`indentLevel`,`attributes`,`list`,`listAttributes`,`propOrder`,`quickHelp`,`modified`) VALUES('*.patient.enterBy','en','lava','crms',NULL,'Patient','enterBy','Record Management','i','suggest','No','Entered By',NULL,NULL,0,'','patient.staffList',NULL,17,'','2009-01-24 21:28:51');
INSERT INTO viewproperty (`messageCode`,`locale`,`instance`,`scope`,`prefix`,`entity`,`property`,`section`,`context`,`style`,`required`,`label`,`maxLength`,`size`,`indentLevel`,`attributes`,`list`,`listAttributes`,`propOrder`,`quickHelp`,`modified`) VALUES('*.patient.insurLongTerm','en','lava','crms',NULL,'Patient','insurLongTerm','Insurance Details','i','range','No','InsurLongTerm',NULL,NULL,0,'','generic.yesNoDK',NULL,17,'','2009-01-24 21:28:51');
INSERT INTO viewproperty (`messageCode`,`locale`,`instance`,`scope`,`prefix`,`entity`,`property`,`section`,`context`,`style`,`required`,`label`,`maxLength`,`size`,`indentLevel`,`attributes`,`list`,`listAttributes`,`propOrder`,`quickHelp`,`modified`) VALUES('*.patient.dupNameFlag','en','lava','crms',NULL,'Patient','dupNameFlag','Record Management','i','scale','Yes','Dup Name Warning',NULL,NULL,0,'','generic.yesNoZero',NULL,18,'','2009-01-24 21:28:51');
INSERT INTO viewproperty (`messageCode`,`locale`,`instance`,`scope`,`prefix`,`entity`,`property`,`section`,`context`,`style`,`required`,`label`,`maxLength`,`size`,`indentLevel`,`attributes`,`list`,`listAttributes`,`propOrder`,`quickHelp`,`modified`) VALUES('*.patient.other','en','lava','crms',NULL,'Patient','other','Insurance Details','i','range','No','Other',NULL,NULL,0,'','generic.yesNoDK',NULL,18,'','2009-01-24 21:28:51');

INSERT INTO viewproperty (`messageCode`,`locale`,`instance`,`scope`,`prefix`,`entity`,`property`,`section`,`context`,`style`,`required`,`label`,`maxLength`,`size`,`indentLevel`,`attributes`,`list`,`listAttributes`,`propOrder`,`quickHelp`,`modified`) VALUES('*.consent.caregiverId','en','lava','crms',NULL,'consent','caregiverId','','i','range','No','Surrogate Consent',NULL,NULL,0,'','patient.caregivers',NULL,3,'','2009-01-24 21:28:51');
INSERT INTO viewproperty (`messageCode`,`locale`,`instance`,`scope`,`prefix`,`entity`,`property`,`section`,`context`,`style`,`required`,`label`,`maxLength`,`size`,`indentLevel`,`attributes`,`list`,`listAttributes`,`propOrder`,`quickHelp`,`modified`) VALUES('*.consent.projName','en','lava','crms',NULL,'consent','projName','','i','range','Yes','Project',NULL,NULL,0,'','enrollmentStatus.patientProjects',NULL,4,'','2009-01-24 21:28:51');
INSERT INTO viewproperty (`messageCode`,`locale`,`instance`,`scope`,`prefix`,`entity`,`property`,`section`,`context`,`style`,`required`,`label`,`maxLength`,`size`,`indentLevel`,`attributes`,`list`,`listAttributes`,`propOrder`,`quickHelp`,`modified`) VALUES('*.consent.consentType','en','lava','crms',NULL,'consent','consentType','','i','range','Yes','Consent Type',NULL,40,0,'','consent.consentTypes',NULL,5,'','2009-01-24 21:28:51');
INSERT INTO viewproperty (`messageCode`,`locale`,`instance`,`scope`,`prefix`,`entity`,`property`,`section`,`context`,`style`,`required`,`label`,`maxLength`,`size`,`indentLevel`,`attributes`,`list`,`listAttributes`,`propOrder`,`quickHelp`,`modified`) VALUES('*.consent.hipaa','en','lava','crms',NULL,'consent','hipaa',NULL,'i','range','No','HIPAA',NULL,NULL,0,NULL,'generic.yesNoZero',NULL,NULL,'HIPAA','2011-03-17 12:46:26');
INSERT INTO viewproperty (`messageCode`,`locale`,`instance`,`scope`,`prefix`,`entity`,`property`,`section`,`context`,`style`,`required`,`label`,`maxLength`,`size`,`indentLevel`,`attributes`,`list`,`listAttributes`,`propOrder`,`quickHelp`,`modified`) VALUES('*.consent.consentTypeBlock','en','lava','crms',NULL,'consent','consentTypeBlock',NULL,'c','string','No','Consent Type',NULL,NULL,0,NULL,NULL,NULL,NULL,'Consent Type','2011-03-17 12:47:44');
INSERT INTO viewproperty (`messageCode`,`locale`,`instance`,`scope`,`prefix`,`entity`,`property`,`section`,`context`,`style`,`required`,`label`,`maxLength`,`size`,`indentLevel`,`attributes`,`list`,`listAttributes`,`propOrder`,`quickHelp`,`modified`) VALUES('*.consent.consentDate','en','lava','crms',NULL,'consent','consentDate','','i','date','Yes','Consent Date',NULL,NULL,0,'','',NULL,6,'','2009-01-24 21:28:51');
INSERT INTO viewproperty (`messageCode`,`locale`,`instance`,`scope`,`prefix`,`entity`,`property`,`section`,`context`,`style`,`required`,`label`,`maxLength`,`size`,`indentLevel`,`attributes`,`list`,`listAttributes`,`propOrder`,`quickHelp`,`modified`) VALUES('*.consent.expirationDate','en','lava','crms',NULL,'consent','expirationDate','','i','date','No','Expiration Date',NULL,NULL,0,'','',NULL,7,'','2009-01-24 21:28:51');
INSERT INTO viewproperty (`messageCode`,`locale`,`instance`,`scope`,`prefix`,`entity`,`property`,`section`,`context`,`style`,`required`,`label`,`maxLength`,`size`,`indentLevel`,`attributes`,`list`,`listAttributes`,`propOrder`,`quickHelp`,`modified`) VALUES('*.consent.withdrawlDate','en','lava','crms',NULL,'consent','withdrawlDate','','i','date','No','Withdrawal Date',NULL,NULL,0,'','',NULL,8,'','2009-01-24 21:28:51');
