Operation Details
Description: Reads the employmentID, concernRoleID, start and end dates of the employment record corresponding to a paid-employment instance.
Sterotype: ns
SQL 
SELECT
  Employment.employmentID,
  Employment.concernRoleID,
  PaidEmployment.caseParticipantRoleID,
  Employment.fromDate,
  Employment.toDate,
  Employment.occupationType
INTO
  :employmentID,
  :concernRoleID,
  :caseParticipantRoleID,
  :fromDate,
  :toDate,
  :occupationType 
FROM
  PaidEmployment,
  Employment 
WHERE PaidEmployment.evidenceID = :evidenceID 
  AND Employment.employmentID = PaidEmployment.employmentID