Operation Details
Description: Retrieves a list of employment details and the employer industry type for the specified concern role.
Sterotype: nsmulti
SQL 
SELECT
  Employment.employmentID,
  Employment.concernRoleID,
  Employment.employerConcernRoleID,
  Employment.fromDate,
  Employment.toDate,
  Employment.occupationType,
  Employment.primaryCurrentInd,
  Employer.industryType
INTO
  :employmentID,
  :concernRoleID,
  :employerConcernRoleID,
  :fromDate,
  :toDate,
  :occupationType,
  :primaryCurrentInd,
  :employerIndustryType 
FROM
  Employment 
  
  LEFT OUTER JOIN
  
  Employer 
  ON Employment.employerConcernRoleID = Employer.concernRoleID 
WHERE Employment.concernRoleID = :concernRoleID