p.setCompoundHeadMiddleName(getRsString(rs, colCompoundheadMiddleName));
p.setCompoundHeadLastName(getRsString(rs, colCompoundheadLastName));
p.setVillageName(getRsString(rs, colVillageName));
p.setMaritalStatus((Person.MaritalStatus) ValueMap.MARITAL_STATUS.getVal().get(getRsString(rs, colMaritalStatusName)));
p.setPersonIdentifierList(personIdentifierList.loadNext(dbPersonId));
p.setFingerprintList(fingerprintList.loadNext(dbPersonId));
p.setConsentSigned((Person.ConsentSigned) ValueMap.CONSENT_SIGNED.getVal().get(getRsString(rs, colConsentSigned)));
p.setLastRegularVisit(Visit.getVisit(rs.getDate(colVisitRegDate), getRsString(rs, colVisitOneDate),getRsString(rs, colVisitRegFacility)));
p.setLastOneOffVisit(Visit.getVisit(rs.getDate(colVisitRegAddress), getRsString(rs, colVisitOneAddress),getRsString(rs, colVisitRegFacility)));
PersonMatch per = new PersonMatch(p);
per.setDbPersonId(dbPersonId);