Operation Details
Description: Reads a household member record returning the participant name and the caseParticipantRoleID.
Sterotype: ns
SQL 
SELECT
  HouseholdMember.caseParticipantRoleID,
  ConcernRole.concernRoleName
INTO
  :caseParticipantRoleID,
  :participantName 
FROM
  HouseholdMember,
  CaseParticipantRole,
  ConcernRole 
WHERE HouseholdMember.evidenceID = :evidenceID 
  AND CaseParticipantRole.caseParticipantRoleID = HouseholdMember.caseParticipantRoleID 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID