Operation Details
Description: Operation to return the participant role id, participant role name, marital status, gender, and date of birth of the household member.
Sterotype: ns
SQL 
SELECT
  CaseParticipantRole.participantRoleID,
  ConcernRole.concernRoleName,
  Person.dateOfBirth,
  Person.maritalStatusCode,
  Person.gender,
  Person.dateOfDeath
INTO
  :participantRoleID,
  :participantRoleName,
  :dateOfBirth,
  :maritalStatus,
  :gender,
  :dateOfDeath 
FROM
  HouseholdMember,
  CaseParticipantRole,
  ConcernRole,
  Person 
WHERE HouseholdMember.evidenceID = :evidenceID 
  AND CaseParticipantRole.caseParticipantRoleID = HouseholdMember.caseParticipantRoleID 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID 
  AND Person.concernRoleID = CaseParticipantRole.participantRoleID