SAIF.Business.View.Provider SQL catalog¶
This page indexes all SQL statements used by this library. Every discovered statement is a read operation.
Read operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-001 | Provider location DCBS cost charges | StringBuilder | PROVIDER_DCBS_COST_CHARGE | clsDCBSCostChargeList |
| SQL-002 | Provider location MCO enrollments | StringBuilder | MCO_PROVIDER | clsMCOProviderList |
| SQL-003 | Provider by provider ID | Inline | PROVIDER, PROVIDER_TAX_ID | clsProvider |
| SQL-004 | Provider by primary tax ID | Inline | PROVIDER, PROVIDER_TAX_ID | clsProvider |
| SQL-005 | Provider address by location | Inline | PROVIDER_LOCATION, PROVIDER_ADDRESS | clsProviderAddress |
| SQL-006 | Provider address collection by location | Inline | PROVIDER_LOCATION, PROVIDER_ADDRESS | clsProviderAddressCollection |
| SQL-007 | Provider collection by dynamic filter | Inline | PROVIDER, PROVIDER_TAX_ID | clsProviderCollection |
| SQL-008 | Provider ineligibility period by ID | Inline | PROVIDER_INELIG_PERIOD | clsProviderIneligibilityPeriod |
| SQL-009 | Provider ineligibility periods by location | Inline | PROVIDER_INELIG_PERIOD | clsProviderIneligibilityPeriodCollection |
| SQL-010 | Provider location by ID | Inline | PROVIDER_LOCATION | clsProviderLocation |
| SQL-011 | Provider locations by provider | Inline | PROVIDER_LOCATION | clsProviderLocationCollection |
| SQL-012 | Provider locations by type | Inline | PROVIDER_LOCATION | clsProviderLocationCollection |
| SQL-013 | Child provider relationships by location | Inline | PROVIDER_LOCATION, PROVIDER_RELATIONSHIP | clsProviderRelationshipCollection |
| SQL-014 | Parent provider relationships by location | Inline | PROVIDER_LOCATION, PROVIDER_RELATIONSHIP | clsProviderRelationshipCollection |
| SQL-015 | Provider search by dynamic criteria | StringBuilder | PROVIDER_LOCATION, PROVIDER_TYPE_CODE, PROVIDER_ADDRESS, PROVIDER_TAX_ID, PROVIDER_IDENTITY, PROVIDER_SERVICE, MCO_PROVIDER | clsProviderSearch |
| SQL-016 | Provider service contracts by location | StringBuilder | PROVIDER_SERVICE_CONTRACT | clsProviderServiceContractList |
| SQL-017 | Provider services by location | StringBuilder | PROVIDER_SERVICE_CODE, PROVIDER_SERVICE | clsProviderServiceList |
| SQL-018 | Provider tax IDs by provider | Inline | PROVIDER_TAX_ID | clsProviderTaxIDCollection |
| SQL-019 | Provider type by code | Inline | PROVIDER_TYPE_CODE | clsProviderType |
| SQL-020 | Provider type catalog | Inline | PROVIDER_TYPE_CODE | clsProviderTypeCollection |
Related documentation¶
- Index
- Overview
- Architecture
- Dependencies
- Operations and processes
- Business rules
- Database tables
- API reference
Sources¶
Business\SAIF.Business.View.Provider\clsDCBSCostCharge.vbBusiness\SAIF.Business.View.Provider\clsMCOProvider.vbBusiness\SAIF.Business.View.Provider\clsProvider.vbBusiness\SAIF.Business.View.Provider\clsProviderAddress.vbBusiness\SAIF.Business.View.Provider\clsProviderAddressCollection.vbBusiness\SAIF.Business.View.Provider\clsProviderCollection.vbBusiness\SAIF.Business.View.Provider\clsProviderIneligibilityPeriod.vbBusiness\SAIF.Business.View.Provider\clsProviderIneligibilityPeriodCollection.vbBusiness\SAIF.Business.View.Provider\clsProviderLocation.vbBusiness\SAIF.Business.View.Provider\clsProviderLocationCollection.vbBusiness\SAIF.Business.View.Provider\clsProviderRelationshipCollection.vbBusiness\SAIF.Business.View.Provider\clsProviderSearch.vbBusiness\SAIF.Business.View.Provider\clsProviderServiceContract.vbBusiness\SAIF.Business.View.Provider\clsProviderServices.vbBusiness\SAIF.Business.View.Provider\clsProviderTaxIDCollection.vbBusiness\SAIF.Business.View.Provider\clsProviderType.vbBusiness\SAIF.Business.View.Provider\clsProviderTypeCollection.vb