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