SQL-PTYP-01 Provider type by code

Retrieves a single PROVIDER_TYPE_CODE record by its code, returning the flags that drive downstream behavior such as claim profile requirements, diagnosis requirement, mandatory MCO enrollment, and self-registration eligibility.

Classification

Field	Value
SQL ID	SQL-PTYP-01
Operation type	Read
Execution method	Inline SQL (BOF criteria constant)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsProviderType
Criteria property	RetrieveSQL
Lifecycle method	BeforeRetrieve / AfterRetrieve

Parameters

Parameter	Direction	Type	Max length	Description
:Code	Input	String	5	PROVIDER_TYPE_CODE.CODE

Tables

Table	Access	Columns used
PROVIDER_TYPE_CODE	SELECT	CLAIM_PROFILE_FLAG, CODE, CODE_DESCR, DCBS_PROVIDER_TYPE_CODE, DIAGNOSIS_REQUIRED_FLAG, MANDATORY_MCO_FLAG, MEDICAL_AUDIT_FLAG, SELF_REGISTRATION_FLAG, SERVICE_PROV_RESTRICT_FLAG, UPDATE_DATE, UPDATE_NUM, UPDATE_USER

Sample SQL

-- Provider type by code
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
WHERE PROVIDER_TYPE_CODE.CODE = :Code

Operations and processes

• Load provider type

Business rules

• BR-PLOC-003: Valid provider type code

Sources

• SAIF.Business.View.Provider/clsProviderType.vb