Operation Details
Description: Retrieves a list of administrators for the specified concern role.
Sterotype: nsmulti
SQL 
SELECT
  AdministrationConcernRole.startDate,
  AdministrationConcernRole.endDate,
  AdministrationRole.statusCode,
  AdministrationConcernRole.typeCode,
  AdministrationConcernRole.administrationConcernRoleID,
  OrgObjectLink.userName,
  OrgObjectLink.orgObjectType,
  OrgObjectLink.orgObjectReference
INTO
  :startDate,
  :endDate,
  :statusCode,
  :typeCode,
  :administrationConcernRoleID,
  :userName,
  :orgObjectType,
  :orgObjectReference 
FROM
  AdministrationRole,
  AdministrationConcernRole,
  OrgObjectLink 
WHERE concernRoleID = :concernRoleID 
  AND AdministrationRole.administrationRoleID = AdministrationConcernRole.administrationRoleID 
  AND AdministrationRole.orgObjectLinkID =OrgObjectLink.orgObjectLinkID 
ORDER BY statusCode ASC,
  startDate DESC