Operation Details
Description: Retrieves a list of Prospect Employer Snapshot details for the specified concernRoleID.
Sterotype: nsmulti
SQL 
SELECT
  prospectEmployerSnapshotID,
  tradingName,
  numberPermanentStaff,
  registeredName,
  companyType,
  creationDateTime,
  statusCode,
  industryType,
  numberCasualStaff
INTO
  :prospectEmployerSnapshotID,
  :tradingName,
  :numberPermanentStaff,
  :registeredName,
  :companyType,
  :creationDateTime,
  :statusCode,
  :industryType,
  :numberCasualStaff 
FROM
  ProspectEmployerSnapshot 
WHERE concernRoleID = :concernRoleID 
ORDER BY creationDateTime DESC