Operation Details
Description: Read all the Household Relationship Records based on the case evidence group id
Sterotype: nsmulti
SQL 
SELECT
  ConcernRoleRelationship.concernRoleID,
  ConcernRoleRelationship.concernRoleType,
  ConcernRoleRelationship.relConcernRoleID,
  ConcernRoleRelationship.relConcernRoleType,
  ConcernRoleRelationship.relationshipType,
  ISHholdRshipEvidence.nonParentCaretakerRelInd,
  ISHholdRshipEvidence.recipISHholdRshipEvidenceID,
  ConcernRoleRelationship.statusCode
INTO
  :participantRoleID,
  :participantRoleType,
  :relParticipantRoleID,
  :relParticipantRoleType,
  :relationshipType,
  :nonParentCaretakerRelInd,
  :recipISHholdRshipEvidenceID,
  :statusCode 
FROM
  ISHholdRshipEvidence,
  CaseEvidenceGroup,
  CaseEvidenceGroupLink,
  ConcernRoleRelationship 
WHERE CaseEvidenceGroup.caseEvidenceGroupID = :caseEvidenceGroupID 
  AND CaseEvidenceGroup.caseEvidenceGroupID = CaseEvidenceGroupLink.caseEvidenceGroupID 
  AND CaseEvidenceGroupLink.relatedID = ISHholdRshipEvidence.isHholdRshipEvidenceID 
  AND ISHholdRshipEvidence.participantRoleRshipID = ConcernRoleRelationship.concernRoleRelationshipID 
  AND ConcernRoleRelationship.statusCode = statusCode