Operation Details
Description: Reads a prospect household member, returning the caseParticipantRoleID, name, and date of birth.
Sterotype: ns
SQL 
SELECT
  HouseholdMember.evidenceID,
  HouseholdMember.caseParticipantRoleID,
  ConcernRole.concernRoleName,
  ProspectPerson.dateOfBirth,
  ProspectPerson.maritalStatusCode,
  HouseholdMember.veteranStatus,
  HouseholdMember.migrantFWorkerInd,
  HouseholdMember.ssnStatus,
  ConcernRole.concernRoleID,
  ConcernRole.primaryAlternateID
INTO
  :evidenceID,
  :caseParticipantRoleID,
  :participantName,
  :dateOfBirth,
  :maritalStatusCode,
  :veteranStatus,
  :migrantFWorkerInd,
  :ssnStatus,
  :participantRoleID,
  :alternateID 
FROM
  HouseholdMember,
  CaseParticipantRole,
  ConcernRole,
  ProspectPerson 
WHERE HouseholdMember.evidenceID = :evidenceID 
  AND CaseParticipantRole.caseParticipantRoleID = HouseholdMember.caseParticipantRoleID 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID 
  AND ProspectPerson.concernRoleID = CaseParticipantRole.participantRoleID