Operation Details
Description: Retrieve the NPCR indicator, Dependent indicator and participantRoleID of the related person.
Sterotype: ns
SQL 
SELECT
  HouseholdRelationship.nonParentCareRelInd,
  HouseholdRelationship.dependentInd,
  ConcernRoleRelationship.relConcernRoleID
INTO
  :nonParentCareRelativeInd,
  :dependentInd,
  :relParticipantRoleID 
FROM
  HouseholdRelationship,
  ConcernRole,
  ConcernRoleRelationship 
WHERE HouseholdRelationship.evidenceID = :evidenceID 
  AND ConcernRoleRelationship.concernRoleRelationshipID = HouseholdRelationship.concernRoleRelationshipID 
  AND ConcernRole.concernRoleID = ConcernRoleRelationship.relConcernRoleID