SQL-063: Retrieve Provider Type Collection¶
Retrieves provider type collection data from Oracle.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-063 |
| Operation type | Read |
| Execution method | Inline |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsProviderTypeCollection |
| Criteria property | RetrieveSQL |
| Lifecycle method | BeforeRetrieve |
Parameters¶
No parameters. This statement does not accept bind input.
Tables¶
| Table | Access | Columns used |
|---|---|---|
| PROVIDER_TYPE_CODE | SELECT | See business-object criteria for key columns. |
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
Note: Statements marked with
**could not be confirmed; treat as unknown until verified.
Sources¶
Business\SAIF.Business.Provider\clsProviderTypeCollection.vb