Operation Details
Description: This method will determine if a specified participant is a member of a particular household and return the identifier for the household evidence if the participant is a member.
Sterotype: ns
SQL 
SELECT
  ISHouseholdEvidence.isHouseholdEvidenceID
INTO
  :isHouseholdEvidenceID 
FROM
  ISHouseholdEvidence,
  CaseEvidenceGroup,
  CaseEvidenceGroupLink 
WHERE CaseEvidenceGroup.caseEvidenceGroupID = :caseEvidenceGroupID 
  AND ISHouseholdEvidence.participantRoleID = :participantRoleID 
  AND CaseEvidenceGroupLink.caseEvidenceGroupID = CaseEvidenceGroup.caseEvidenceGroupID 
  AND CaseEvidenceGroupLink.relatedID = ISHouseholdEvidence.isHouseholdEvidenceID