 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('*.visit.visitNote','en','lava','crms',NULL,'Visit','visitNote','','i','text','No','Visit Notes',NULL,NULL,0,'rows="5" cols="35"','',NULL,9,'','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('*.visit.visitDescrip','en','lava','crms',NULL,'Visit','visitDescrip','','c','string','No','Description',NULL,NULL,0,'','',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('*.visit.ageAtVisit','en','lava','crms',NULL,'Visit','ageAtVisit','','c','numeric','No','Age At Visit',NULL,NULL,0,'','',NULL,17,'','2009-01-24 21:28:51');
-
 INSERT INTO hibernateproperty (`instance`,`scope`,`entity`,`property`,`dbTable`,`dbColumn`,`dbType`,`dbLength`,`dbPrecision`,`dbScale`,`dbOrder`,`hibernateProperty`,`hibernateType`,`hibernateClass`,`hibernateNotNull`,`modified`) VALUES('lava','crms','caregiver','id','Caregiver','CareID','int',NULL,10,0,1,'id','long',NULL,'Yes','2009-01-24 21:25:56');
 INSERT INTO hibernateproperty (`instance`,`scope`,`entity`,`property`,`dbTable`,`dbColumn`,`dbType`,`dbLength`,`dbPrecision`,`dbScale`,`dbOrder`,`hibernateProperty`,`hibernateType`,`hibernateClass`,`hibernateNotNull`,`modified`) VALUES('lava','crms','caregiver','patient','Caregiver','PIDN','int',NULL,10,0,2,'patient','many-to-one','edu.ucsf.memory.lava.model.Patient','Yes','2009-01-24 21:25:56');
 INSERT INTO hibernateproperty (`instance`,`scope`,`entity`,`property`,`dbTable`,`dbColumn`,`dbType`,`dbLength`,`dbPrecision`,`dbScale`,`dbOrder`,`hibernateProperty`,`hibernateType`,`hibernateClass`,`hibernateNotNull`,`modified`) VALUES('lava','crms','caregiver','lastName','Caregiver','Lname','varchar',25,NULL,NULL,3,'lastName','string',NULL,'Yes','2009-01-24 21:25:56');

INSERT INTO `list` (`ListName`,`scope`,`NumericKey`,`modified`) VALUES('VisitType','crms',0,'2009-01-24 20:57:59');
INSERT INTO `list` (`ListName`,`scope`,`NumericKey`,`modified`) VALUES('YesNoScale_NoCorrect','crms',1,'2009-01-24 20:57:59');
INSERT INTO `list` (`ListName`,`scope`,`NumericKey`,`modified`) VALUES('YesNoScale_YesCorrect','crms',1,'2009-01-24 20:57:59');

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`,'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.age','en','lava','crms',NULL,'Patient','age','ID and Core Demographics','c','numeric','No','Age',NULL,NULL,0,'','',NULL,10,'','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.multRace3','en','lava','crms',NULL,'Patient','multRace3','Racial Demographics','i','range','No','Multiple Race 3',NULL,NULL,0,'','generic.race',NULL,10,'','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.desRace','en','lava','crms',NULL,'Patient','desRace','Racial Demographics','i','range','No','Race that Best Describes',NULL,NULL,0,'','generic.race',NULL,11,'','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.gender','en','lava','crms',NULL,'Patient','gender','ID and Core Demographics','i','range','Yes','Gender',NULL,NULL,0,'','generic.gender',NULL,11,'','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.hand','en','lava','crms',NULL,'Patient','hand','ID and Core Demographics','i','range','No','Handedness',NULL,NULL,0,'','patient.handedness',NULL,12,'','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.mrgStat','en','lava','crms',NULL,'Patient','mrgStat','Personal History/Current Arrangements','i','range','No','Marital Status',NULL,NULL,0,'','patient.maritalStatus',NULL,12,'','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.sexualOrient','en','lava','crms',NULL,'Patient','sexualOrient','Personal History/Current Arrangements','i','range','No','Sexual Orientation/Identity',NULL,NULL,0,'','patient.sexualOrientation',NULL,12,'','2009-01-24 21:28:51');
