Operation Details
Description: Searches and returns a list of all Providers that match the user name entered, ordered by Reference Number.
Sterotype: nsmulti
SQL 
SELECT
  Provider.providerConcernRoleID,
  Provider.providerEnquiryID,
  Provider.physicalCapacity,
  Provider.paymentFrequency,
  Provider.methodOfPayment,
  Provider.currencyType,
  Provider.reservationGracePeriod,
  Provider.recordStatus,
  Provider.overrideMDRInd,
  Provider.preferredSEMethod,
  Provider.areasSvdInfoTxtID,
  Provider.clientInfoTextID,
  Provider.name,
  Provider.nameUpper,
  Provider.versionNo,
 Provider.enrollmentDateTime,
  Provider.endDateTime
INTO
  :providerConcernRoleID,
  :providerEnquiryID,
  :physicalCapacity,
  :paymentFrequency,
  :methodOfPayment,
  :currencyType,
  :reservationGracePeriod,
  :recordStatus,
  :overrideMDRInd,
  :preferredSEMethod,
  :areasSvdInfoTxtID,
  :clientInfoTextID,
  :name,
  :nameUpper,
  :versionNo,
 :enrollmentDateTime,
  :endDateTime
FROM
  Provider,
  ConcernRole,
  AdministrationConcernRole,
  AdministrationRole 
WHERE ConcernRole.concernRoleID = Provider.providerConcernRoleID 
  AND AdministrationRole.userName = :userName 
  AND AdministrationRole.statusCode = :statusCode 
  AND AdministrationRole.administrationRoleID = AdministrationConcernRole.administrationRoleID 
  AND AdministrationConcernRole.concernRoleID = Provider.providerConcernRoleID 
ORDER BY ConcernRole.primaryAlternateID