SQL-020: Provider type catalog

This statement supports the clsProviderTypeCollection 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-020
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsProviderTypeCollection
Criteria property	RetrieveSQL
Lifecycle method	BeforeRetrieve

Parameters

Parameter	Direction	Type	Max length	Description
—	—	—	—	No bind variables; retrieves the full provider type code table ordered by description.

Tables

Table	Access	Columns used
PROVIDER_TYPE_CODE	SELECT	CODE, CODE_DESCR, CLAIM_PROFILE_FLAG, DCBS_PROVIDER_TYPE_CODE

Sample SQL

SELECT
  PROVIDER_TYPE_CODE.CLAIM_PROFILE_FLAG AS ClaimProfileFlag,
  PROVIDER_TYPE_CODE.CODE AS Code,
  PROVIDER_TYPE_CODE.CODE_DESCR AS CodeDescription,
  PROVIDER_TYPE_CODE.DCBS_PROVIDER_TYPE_CODE AS DcbsProviderTypeCode,
  PROVIDER_TYPE_CODE.DIAGNOSIS_REQUIRED_FLAG AS DiagnosisRequiredFlag,
  PROVIDER_TYPE_CODE.MANDATORY_MCO_FLAG AS MandatoryMcoFlag,
  PROVIDER_TYPE_CODE.MEDICAL_AUDIT_FLAG AS MedicalAuditFlag,
  PROVIDER_TYPE_CODE.SELF_REGISTRATION_FLAG AS SelfRegistrationFlag,
  PROVIDER_TYPE_CODE.SERVICE_PROV_RESTRICT_FLAG AS ServiceProvRestrictFlag,
  PROVIDER_TYPE_CODE.UPDATE_DATE AS UpdateDate,
  PROVIDER_TYPE_CODE.UPDATE_NUM AS UpdateNum,
  PROVIDER_TYPE_CODE.UPDATE_USER AS UpdateUser
FROM PROVIDER_TYPE_CODE
ORDER BY CODE_DESCR

Operations and processes

• Retrieve provider type collection

Business rules

• BR-001: Provider type read-only criteria

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\clsProviderTypeCollection.vb