Operation Details
Description: Retrieves a list of Employer Snapshot details for the specified concernRoleID.
Sterotype: nsmulti
SQL 
SELECT
  concernRoleID,
  registeredName,
  tradingName,
  industryType,
  companyType,
  businessDesc,
  specialInterestCode,
  exemptionInd,
  statusCode,
  comments,
  primaryAlternateID,
  numberPermanentStaff,
  numberCasualStaff,
  pinNumber,
  paymentFrequency,
  nextPaymentDate,
  currencyType,
  methodOfPmtCode,
  employerSnapshotID,
  creationDateTime
INTO
  :concernRoleID,
  :registeredName,
  :tradingName,
  :industryType,
  :companyType,
  :businessDesc,
  :specialInterestCode,
  :exemptionInd,
  :statusCode,
  :comments,
  :primaryAlternateID,
  :numberPermanentStaff,
  :numberCasualStaff,
  :pinNumber,
  :paymentFrequency,
  :nextPaymentDate,
  :currencyType,
  :methodOfPmtCode,
  :employerSnapshotID,
  :creationDateTime 
FROM
  EmployerSnapshot 
WHERE concernRoleID = :concernRoleID 
ORDER BY creationDateTime DESC