Operation Details
Description: Method to return a list of all Employment Snapshot Records for an EmploymentID.
Sterotype: nsmulti
SQL 
SELECT
  EmploymentSnapshot.employerConcernRoleID,
  Employer.tradingName,
  employerconcernrole.concernRoleType,
  EmploymentSnapshot.occupationType,
  EmploymentSnapshot.fromDate,
  EmploymentSnapshot.toDate,
  EmploymentSnapshot.status,
  EmploymentSnapshot.primaryCurrentInd,
  EmploymentSnapshot.employmentSnapshotID,
  EmploymentSnapshot.creationDateTime
INTO
  :employerConcernRoleID,
  :employerName,
  :employerType,
  :occupationType,
  :fromDate,
  :toDate,
  :status,
  :primaryCurrentInd,
  :employmentSnapshotID,
  :creationDateTime 
FROM
  EmploymentSnapshot,
  Employer,
  ConcernRole employerconcernrole 
WHERE EmploymentSnapshot.employmentID = :employmentID 
  AND EmploymentSnapshot.employerConcernRoleID = Employer.concernRoleID 
  AND employerconcernrole.concernRoleID = EmploymentSnapshot.employerConcernRoleID 
ORDER BY creationDateTime DESC