Operation Details
Description: Operation to return ParticipantRoleID, ParticipantRoleName, DateOfBirth, MaritalStatus, Gender and CaseParticipantRoleID
Sterotype: ns
SQL 
SELECT
  HouseholdMember.evidenceID,
  HouseholdMember.caseParticipantRoleID,
  HouseholdMember.citizenStatus,
  CaseParticipantRole.participantRoleID,
  ConcernRole.concernRoleName,
  Person.dateOfBirth,
  Person.maritalStatusCode,
  Person.gender
INTO
  :evidenceID,
  :caseParticipantRoleID,
  :citizenStatus,
  :participantRoleID,
  :participantRoleName,
  :dateOfBirth,
  :maritalStatus,
  :gender 
FROM
  HouseholdMember,
  CaseParticipantRole,
  ConcernRole,
  Person 
WHERE HouseholdMember.evidenceID = :evidenceID 
  AND CaseParticipantRole.caseParticipantRoleID = HouseholdMember.caseParticipantRoleID 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID 
  AND Person.concernRoleID = CaseParticipantRole.participantRoleID