Operation Details
Description: Reads a student record and returns the participant name and their caseParticipantRoleID.
Sterotype: ns
SQL 
SELECT
  Student.caseParticipantRoleID,
  ConcernRole.concernRoleName,
  ConcernRole.primaryAlternateID
INTO
  :caseParticipantRoleID,
  :participantName,
  :alternateID 
FROM
  Student,
  CaseParticipantRole,
  ConcernRole 
WHERE Student.evidenceID = :evidenceID 
  AND CaseParticipantRole.caseParticipantRoleID = Student.caseParticipantRoleID 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID