SQL-017: Provider services by location

This statement supports the clsProviderServiceList retrieval path by reading provider-domain data from Oracle tables and projecting the result into business objects or DTO lists.

Classification

Field	Value
SQL ID	SQL-017
Operation type	Read
Execution method	StringBuilder-assembled
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsProviderServiceList
Criteria property	N/A - direct query
Lifecycle method	Constructor

Parameters

Parameter	Direction	Type	Max length	Description
:ProviderLocationID	Input	Decimal	N/A	Filters services to one provider location.

Tables

Table	Access	Columns used
PROVIDER_SERVICE_CODE	SELECT	CODE, CODE_DESCR, DCBS_PROVIDER_SPECIALTY_CODE
PROVIDER_SERVICE	SELECT	PROVIDER_LOCATION_SEQ_NUM, PROVIDER_SERVICE_CODE, PRIMARY_SERVICE_FLAG

Sample SQL

SELECT
  PROVIDER_SERVICE_CODE.CODE AS ServiceCode,
  PROVIDER_SERVICE_CODE.CODE_DESCR AS ServiceDescription,
  PROVIDER_SERVICE_CODE.DCBS_PROVIDER_SPECIALTY_CODE AS DCBSSpecialtyCode,
  PROVIDER_SERVICE.PRIMARY_SERVICE_FLAG AS PrimaryServiceFlag
FROM PROVIDER_SERVICE_CODE, PROVIDER_SERVICE
WHERE PROVIDER_SERVICE.PROVIDER_LOCATION_SEQ_NUM = :ProviderLocationID
  AND PROVIDER_SERVICE_CODE.CODE = PROVIDER_SERVICE.PROVIDER_SERVICE_CODE

Operations and processes

• Retrieve provider services

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Database tables
• SQL catalog
• API reference

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Business\SAIF.Business.View.Provider\clsProviderServices.vb