SAIF.Business.View.Provider SQL catalog¶
This page indexes all SQL statements and stored procedure calls in this library, grouped by CRUD type.
The library is read-only: every CreateSQL, InsertSQL, UpdateSQL, and DeleteSQL property
throws ApplicationException, so only Read (SELECT) statements exist and no sequences are used.
Read operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-DCBS-01 | Retrieve DCBS cost-charge factors for a provider location | StringBuilder-assembled | PROVIDER_DCBS_COST_CHARGE | clsDCBSCostChargeList |
| SQL-MCO-01 | Retrieve MCO plan enrollments for a provider location | StringBuilder-assembled | MCO_PROVIDER | clsMCOProviderList |
| SQL-PRV-01 | Retrieve a single provider by its surrogate ID | Inline | PROVIDER, PROVIDER_TAX_ID | clsProvider |
| SQL-PRV-01b | Retrieve a single provider by its primary tax ID | Inline | PROVIDER, PROVIDER_TAX_ID | clsProvider |
| SQL-PADR-01 | Retrieve formatted mailing address details for a provider location | Inline | PROVIDER_LOCATION, PROVIDER_ADDRESS | clsProviderAddressCollection |
| SQL-PRV-02 | Retrieve multiple providers matching a tax-ID list | Inline (concatenated) | PROVIDER, PROVIDER_TAX_ID | clsProviderCollection |
| SQL-PRV-02b | Retrieve providers using a caller-supplied WHERE predicate | Inline (concatenated) | PROVIDER, PROVIDER_TAX_ID | clsProviderCollection |
| SQL-PINE-01 | Retrieve a single provider ineligibility period by ID | Inline | PROVIDER_INELIG_PERIOD | clsProviderIneligibilityPeriod |
| SQL-PINE-02 | Retrieve all ineligibility periods for a provider location | Inline | PROVIDER_INELIG_PERIOD | clsProviderIneligibilityPeriodCollection |
| SQL-PLOC-01 | Retrieve a single provider location by its surrogate ID | Inline | PROVIDER_LOCATION | clsProviderLocation |
| SQL-PLOC-02 | Retrieve all locations for a given provider | Inline | PROVIDER_LOCATION | clsProviderLocationCollection |
| SQL-PLOC-03 | Retrieve all locations having a given provider type code | Inline | PROVIDER_LOCATION | clsProviderLocationCollection |
| SQL-PREL-01 | Retrieve child provider locations related to a parent location | Inline | PROVIDER_LOCATION, PROVIDER_RELATIONSHIP | clsProviderRelationshipCollection |
| SQL-PREL-02 | Retrieve parent provider locations related to a child location | Inline | PROVIDER_LOCATION, PROVIDER_RELATIONSHIP | clsProviderRelationshipCollection |
| SQL-SRCH-01 | Search provider locations by name, address, tax ID, and other optional criteria | StringBuilder-assembled | PROVIDER_LOCATION, PROVIDER_TYPE_CODE, PROVIDER_ADDRESS, PROVIDER_TAX_ID, PROVIDER_IDENTITY, PROVIDER_SERVICE, MCO_PROVIDER | N/A (Application layer) |
| SQL-PSVC-02 | Retrieve service contracts for a provider location within an optional date window | StringBuilder-assembled | PROVIDER_SERVICE_CONTRACT | N/A (Application layer) |
| SQL-PSVC-01 | Retrieve service codes and descriptions offered by a provider location | StringBuilder-assembled | PROVIDER_SERVICE_CODE, PROVIDER_SERVICE | N/A (Application layer) |
| SQL-PTAX-01 | Retrieve all tax ID records for a provider | Inline | PROVIDER_TAX_ID | clsProviderTaxIDCollection |
| SQL-PTYP-01 | Retrieve a single provider type definition by its code | Inline | PROVIDER_TYPE_CODE | clsProviderType |
| SQL-PTYP-02 | Retrieve the full list of provider type definitions, sorted by description | Inline | PROVIDER_TYPE_CODE | clsProviderTypeCollection |
Related documentation¶
- Index
- Overview
- Architecture
- Dependencies
- Operations and processes
- Business rules
- Database tables
- API reference
Sources¶
- SAIF.Business.View.Provider/clsDCBSCostCharge.vb
- SAIF.Business.View.Provider/clsMCOProvider.vb
- SAIF.Business.View.Provider/clsProvider.vb
- SAIF.Business.View.Provider/clsProviderAddress.vb
- SAIF.Business.View.Provider/clsProviderAddressCollection.vb
- SAIF.Business.View.Provider/clsProviderCollection.vb
- SAIF.Business.View.Provider/clsProviderIneligibilityPeriod.vb
- SAIF.Business.View.Provider/clsProviderIneligibilityPeriodCollection.vb
- SAIF.Business.View.Provider/clsProviderLocation.vb
- SAIF.Business.View.Provider/clsProviderLocationCollection.vb
- SAIF.Business.View.Provider/clsProviderRelationshipCollection.vb
- SAIF.Business.View.Provider/clsProviderSearch.vb
- SAIF.Business.View.Provider/clsProviderServiceContract.vb
- SAIF.Business.View.Provider/clsProviderServices.vb
- SAIF.Business.View.Provider/clsProviderTaxIDCollection.vb
- SAIF.Business.View.Provider/clsProviderType.vb
- SAIF.Business.View.Provider/clsProviderTypeCollection.vb