 INSERT INTO hibernateproperty (`instance`,`scope`,`entity`,`property`,`dbTable`,`dbColumn`,`dbType`,`dbLength`,`dbPrecision`,`dbScale`,`dbOrder`,`hibernateProperty`,`hibernateType`,`hibernateClass`,`hibernateNotNull`,`modified`) VALUES('lava','crms','Visit','waitListDate','Visit','WListDate','smalldatetime',NULL,16,0,15,'waitListDate','timestamp',NULL,'No','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','Visit','visitDescrip','Visit','VShortDesc','varchar',64,NULL,NULL,16,'visitDescrip','string',NULL,'No','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','Visit','ageAtVisit','Visit','AgeAtVisit','smallint',NULL,5,0,17,'ageAtVisit','short',NULL,'No','2009-01-24 21:25:56');
-
+INSERT INTO `list` (`ListName`,`scope`,`NumericKey`,`modified`) VALUES('AbsentPresent','crms',1,'2009-05-12 14:10:23');
 INSERT INTO `list` (`ListName`,`scope`,`NumericKey`,`modified`) VALUES('CaregiverMaritalStatus','crms',0,'2009-01-24 20:57:59');
 INSERT INTO `list` (`ListName`,`scope`,`NumericKey`,`modified`) VALUES('ConsentType','crms',0,'2009-01-24 20:57:59');
 INSERT INTO `list` (`ListName`,`scope`,`NumericKey`,`modified`) VALUES('ContactMethods','crms',0,'2009-01-24 20:57:59');

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 `listvalues` (`ListID`,`ValueKey`,`ValueDesc`,`OrderID`,`modified`) SELECT `ListID`,'8','HMONG',0,'2009-01-24 20:57:59' FROM `list` where `ListName`='RACE';
INSERT INTO `listvalues` (`ListID`,`ValueKey`,`ValueDesc`,`OrderID`,`modified`) SELECT `ListID`,'9','KOREAN',0,'2009-01-24 20:57:59' FROM `list` where `ListName`='RACE';
INSERT INTO `listvalues` (`ListID`,`ValueKey`,`ValueDesc`,`OrderID`,`modified`) SELECT `ListID`,'99','REFUSED TO STATE/UNKNOWN',0,'2009-01-24 20:57:59' FROM `list` where `ListName`='RACE';
INSERT INTO `listvalues` (`ListID`,`ValueKey`,`ValueDesc`,`OrderID`,`modified`) SELECT `ListID`,'-1','Patient Factor',0,'2009-01-24 20:57:59' FROM `list` where `ListName`='SkipErrorCodes';
INSERT INTO `listvalues` (`ListID`,`ValueKey`,`ValueDesc`,`OrderID`,`modified`) SELECT `ListID`,'-2','Situational Factor',0,'2009-01-24 20:57:59' FROM `list` where `ListName`='SkipErrorCodes';
INSERT INTO `listvalues` (`ListID`,`ValueKey`,`ValueDesc`,`OrderID`,`modified`) SELECT `ListID`,'-3','Alternate Test Given',0,'2009-01-24 20:57:59' FROM `list` where `ListName`='SkipErrorCodes';
