Operation Details
Description: Method for reading boarder evidence and the participantRoleID of the boarder.
Sterotype: ns
SQL 
SELECT
  Boarder.evidenceID,
  Boarder.caseParticipantRoleID,
  Boarder.residenceType,
  Boarder.numberOfMeals,
  Boarder.amountPaid,
  Boarder.paymentFrequency,
  Boarder.inclInAppInd,
  Boarder.comments,
  Boarder.versionNo,
  Boarder.startDate,
  Boarder.endDate,
  CaseParticipantrole.participantRoleID
INTO
  :evidenceID,
  :caseParticipantRoleID,
  :residenceType,
  :numberOfMeals,
  :amountPaid,
  :paymentFrequency,
  :inclInAppInd,
  :comments,
  :versionNo,
  :startDate,
  :endDate,
  :participantRoleID 
FROM
  Boarder,
  CaseParticipantrole 
WHERE Boarder.evidenceID = :evidenceID 
  AND CaseParticipantrole.caseParticipantRoleID = Boarder.caseParticipantRoleID