Operation Details
Description: Reads a members current alternateID of type SSN by the caseParticipantRoleID.
Sterotype: ns
SQL 
SELECT
  MAX(ConcernRoleAlternateID.alternateID)
INTO
  :alternateID 
FROM
  CaseParticipantRole,
  ConcernRoleAlternateID 
WHERE CaseParticipantRole.caseparticipantroleid = :caseParticipantRoleID 
  AND CaseParticipantRole.participantRoleID = ConcernRoleAlternateID.concernRoleID 
  AND ConcernRoleAlternateID.typeCode = :typeCode 
  AND ConcernRoleAlternateID.statusCode = :status 
  AND ConcernRoleAlternateID.startDate <= :date 
  AND 
  (
    ConcernRoleAlternateID.endDate >= :date 
    OR ConcernRoleAlternateID.endDate IS NULL 
  )