SAIF.Business.Provider database tables¶
This page catalogs Oracle tables accessed by SAIF.Business.Provider.
Table catalog¶
| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
|---|---|---|---|---|---|
| CBP_NOTE | Oracle | [unqualified]** | CDRU | Stores notes attached to provider data. | clsNote |
| CBP_NOTE_TYPE_CODE | Oracle | [unqualified]** | R | Stores data used by clsNote. | clsNote |
| CBP_SERVICE_CODE | Oracle | [unqualified]** | R | Stores CBP service code metadata used for service lookup. | clsCBPService |
| CBP_SERVICE_DESCRIPTION | Oracle | [unqualified]** | R | Stores effective-dated descriptions for CBP service codes. | clsCBPService |
| CBP_SERVICE_TYPE_CODE | Oracle | [unqualified]** | R | Stores data used by clsCBPServiceType. | clsCBPServiceType |
| MCO_PLAN | Oracle | [unqualified]** | CDRU | Stores managed care organization plan definitions. | clsMCOPlan |
| MCO_PROVIDER | Oracle | [unqualified]** | CDRU | Associates provider locations with managed care organization plans. | clsProviderMCOMembership |
| PROVIDER | Oracle | [unqualified]** | CDRU | Stores the root provider record and the provider-level primary tax identifier. | clsProvider |
| PROVIDER_ADDRESS | Oracle | [unqualified]** | CDRU | Stores effective-dated provider location addresses. | clsProviderAddress |
| PROVIDER_ADDRESS_CODE | Oracle | [unqualified]** | CDRU | Stores data used by clsProviderAddressCode. | clsProviderAddressCode |
| PROVIDER_CONTACT | Oracle | [unqualified]** | CDRU | Stores provider location contacts and communication details. | clsProviderContact |
| PROVIDER_CONTACT_CODE | Oracle | [unqualified]** | CDRU | Stores data used by clsProviderContactCode. | clsProviderContactCode |
| PROVIDER_DCBS_COST_CHARGE | Oracle | [unqualified]** | CDRU | Stores data used by clsProviderDcbsCostCharge. | clsProviderDcbsCostCharge |
| PROVIDER_IDENTITY | Oracle | [unqualified]** | CDRU | Stores external identifier values such as National Provider IDs. | clsProviderIdentity |
| PROVIDER_IDENTITY_CODE | Oracle | [unqualified]** | CDRU | Stores data used by clsProviderIdentityCode. | clsProviderIdentityCode |
| PROVIDER_INELIG_PERIOD | Oracle | [unqualified]** | CDRU | Stores effective-dated provider ineligibility periods. | clsProviderIneligibilityPeriod |
| PROVIDER_INELIG_REASON_CD | Oracle | [unqualified]** | CDRU | Stores data used by clsProviderIneligibilityReasonCode. | clsProviderIneligibilityReasonCode |
| PROVIDER_LOCATION | Oracle | [unqualified]** | CDRU | Stores provider location, name, approval, communication, and status fields. | clsProviderLocation |
| PROVIDER_RELATIONSHIP | Oracle | [unqualified]** | CDRU | Stores provider-to-provider relationship links and effective dates. | clsProviderRelationship |
| PROVIDER_RELATIONSHIP_CODE | Oracle | [unqualified]** | CDRU | Stores data used by clsProviderRelationshipCode. | clsProviderRelationshipCode |
| PROVIDER_SERVICE | Oracle | [unqualified]** | CDRU | Stores service assignments for provider locations. | clsProviderService |
| PROVIDER_SERVICE_CODE | Oracle | [unqualified]** | CDRU | Stores data used by clsProviderServiceCode. | clsProviderServiceCode |
| PROVIDER_SERVICE_CONTRACT | Oracle | [unqualified]** | CDU | Stores provider service contract rates and effective dates. | clsProviderServiceContract |
| PROVIDER_SERVICE_TYPE | Oracle | [unqualified]** | CDRU | Stores data used by clsProviderServiceType. | clsProviderServiceType |
| PROVIDER_TAX_ID | Oracle | [unqualified]** | CDRU | Stores provider tax IDs, registered names, and TIN mailing-address information. | clsProviderTaxID |
| PROVIDER_TYPE_CODE | Oracle | [unqualified]** | CDRU | Stores data used by clsProviderType, clsProviderTypeCode, clsProviderTypeCollection, clsProviderUtility. | clsProviderType |
CBP_NOTE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores notes attached to provider data. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | CBP_NOTE_SEQ_NUM, NOTE_TYPE_CODE, PROVIDER_SEQ_NUM, PROVIDER_LOCATION_SEQ_NUM, UPDATE_NUM |
| Sequence | N/A |
| Related tables | See operations, rules, and SQL sections below. |
| Business objects | clsNote |
Operations referencing this table¶
Business rules referencing this table¶
SQL referencing this table¶
CBP_NOTE_TYPE_CODE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores data used by clsNote. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Read |
| Key columns used | Primary key and foreign-key columns surfaced by the owning business object criteria. |
| Sequence | N/A |
| Related tables | None identified |
| Business objects | clsNote |
SQL referencing this table¶
CBP_SERVICE_CODE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores CBP service code metadata used for service lookup. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Read |
| Key columns used | Primary key and foreign-key columns surfaced by the owning business object criteria. |
| Sequence | N/A |
| Related tables | None identified |
| Business objects | clsCBPService |
SQL referencing this table¶
CBP_SERVICE_DESCRIPTION¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores effective-dated descriptions for CBP service codes. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Read |
| Key columns used | Primary key and foreign-key columns surfaced by the owning business object criteria. |
| Sequence | N/A |
| Related tables | None identified |
| Business objects | clsCBPService |
SQL referencing this table¶
CBP_SERVICE_TYPE_CODE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores data used by clsCBPServiceType. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Read |
| Key columns used | Primary key and foreign-key columns surfaced by the owning business object criteria. |
| Sequence | N/A |
| Related tables | None identified |
| Business objects | clsCBPServiceType |
SQL referencing this table¶
MCO_PLAN¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores managed care organization plan definitions. |
| Access pattern | BOF criteria SQL and application-layer direct SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | MCO_PLAN_ID, MCO_CERT_NUM, EFF_DATE, EXP_DATE, UPDATE_NUM |
| Sequence | MCO_PLAN_ID_NEXTVAL |
| Related tables | None identified |
| Business objects | clsMCOPlan, clsProviderUtility |
SQL referencing this table¶
- SQL-016: Insert M C O Plan
- SQL-040: Retrieve M C O Plan
- SQL-064: Update M C O Plan
- SQL-086: Delete M C O Plan
MCO_PROVIDER¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Associates provider locations with managed care organization plans. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | PROVIDER_LOCATION_SEQ_NUM, MCO_PLAN_ID, EFF_DATE, EXP_DATE, UPDATE_NUM |
| Sequence | N/A |
| Related tables | See operations, rules, and SQL sections below. |
| Business objects | clsProviderMCOMembership |
Operations referencing this table¶
SQL referencing this table¶
- SQL-029: Insert Provider M C O Membership
- SQL-054: Retrieve Provider M C O Membership
- SQL-077: Update Provider M C O Membership
- SQL-099: Delete Provider M C O Membership
PROVIDER¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores the root provider record and the provider-level primary tax identifier. |
| Access pattern | BOF criteria SQL and application-layer direct SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | PROVIDER_SEQ_NUM, PRIMARY_TAX_ID, UPDATE_NUM |
| Sequence | PROVIDER_SEQ_NUM_NEXTVAL |
| Related tables | See operations, rules, and SQL sections below. |
| Business objects | clsProvider, clsProviderUtility |
Operations referencing this table¶
Business rules referencing this table¶
SQL referencing this table¶
- SQL-018: Insert Provider
- SQL-042: Retrieve Provider
- SQL-066: Update Provider
- SQL-088: Delete Provider
PROVIDER_ADDRESS¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores effective-dated provider location addresses. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | PROVIDER_ADDRESS_SEQ_NUM, PROVIDER_LOCATION_SEQ_NUM, PROVIDER_ADDRESS_CODE, EFF_DATE, EXP_DATE, UPDATE_NUM |
| Sequence | PROVIDER_ADDRESS_SEQ_NUM_NEXTVAL |
| Related tables | See operations, rules, and SQL sections below. |
| Business objects | clsProviderAddress |
Operations referencing this table¶
Business rules referencing this table¶
- BR-001: Search requires at least one criterion
- BR-002: Search ZIP code must be numeric
- BR-007: Address effective periods must not overlap
- BR-008: Domestic addresses require city, state, and ZIP data
SQL referencing this table¶
- SQL-019: Insert Provider Address
- SQL-043: Retrieve Provider Address
- SQL-067: Update Provider Address
- SQL-089: Delete Provider Address
PROVIDER_ADDRESS_CODE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores data used by clsProviderAddressCode. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | Primary key and foreign-key columns surfaced by the owning business object criteria. |
| Sequence | N/A |
| Related tables | None identified |
| Business objects | clsProviderAddressCode |
SQL referencing this table¶
- SQL-020: Insert Provider Address Code
- SQL-044: Retrieve Provider Address Code
- SQL-068: Update Provider Address Code
- SQL-090: Delete Provider Address Code
PROVIDER_CONTACT¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores provider location contacts and communication details. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | PROVIDER_CONTACT_SEQ_NUM, PROVIDER_LOCATION_SEQ_NUM, PROVIDER_CONTACT_CODE, UPDATE_NUM |
| Sequence | PROVIDER_CONTACT_SEQ_NUM_NEXTVAL |
| Related tables | See operations, rules, and SQL sections below. |
| Business objects | clsProviderContact |
Business rules referencing this table¶
SQL referencing this table¶
- SQL-021: Insert Provider Contact
- SQL-045: Retrieve Provider Contact
- SQL-069: Update Provider Contact
- SQL-091: Delete Provider Contact
PROVIDER_CONTACT_CODE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores data used by clsProviderContactCode. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | Primary key and foreign-key columns surfaced by the owning business object criteria. |
| Sequence | N/A |
| Related tables | None identified |
| Business objects | clsProviderContactCode |
SQL referencing this table¶
- SQL-022: Insert Provider Contact Code
- SQL-046: Retrieve Provider Contact Code
- SQL-070: Update Provider Contact Code
- SQL-092: Delete Provider Contact Code
PROVIDER_DCBS_COST_CHARGE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores data used by clsProviderDcbsCostCharge. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | Primary key and foreign-key columns surfaced by the owning business object criteria. |
| Sequence | N/A |
| Related tables | None identified |
| Business objects | clsProviderDcbsCostCharge |
SQL referencing this table¶
- SQL-023: Insert Provider Dcbs Cost Charge
- SQL-047: Retrieve Provider Dcbs Cost Charge
- SQL-071: Update Provider Dcbs Cost Charge
- SQL-093: Delete Provider Dcbs Cost Charge
PROVIDER_IDENTITY¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores external identifier values such as National Provider IDs. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | PROVIDER_IDENTITY_SEQ_NUM, PROVIDER_LOCATION_SEQ_NUM, PROVIDER_IDENTITY_CODE, IDENTITY_VALUE, UPDATE_NUM |
| Sequence | N/A |
| Related tables | See operations, rules, and SQL sections below. |
| Business objects | clsProviderIdentity |
Operations referencing this table¶
Business rules referencing this table¶
SQL referencing this table¶
- SQL-024: Insert Provider Identity
- SQL-048: Retrieve Provider Identity
- SQL-072: Update Provider Identity
- SQL-094: Delete Provider Identity
PROVIDER_IDENTITY_CODE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores data used by clsProviderIdentityCode. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | Primary key and foreign-key columns surfaced by the owning business object criteria. |
| Sequence | N/A |
| Related tables | None identified |
| Business objects | clsProviderIdentityCode |
SQL referencing this table¶
- SQL-025: Insert Provider Identity Code
- SQL-049: Retrieve Provider Identity Code
- SQL-073: Update Provider Identity Code
- SQL-095: Delete Provider Identity Code
PROVIDER_INELIG_PERIOD¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores effective-dated provider ineligibility periods. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | PROVIDER_INELIG_PERIOD_SEQ_NUM, PROVIDER_LOCATION_SEQ_NUM, PROVIDER_INELIG_REASON_CODE, EFF_DATE, EXP_DATE |
| Sequence | N/A |
| Related tables | None identified |
| Business objects | clsProviderIneligibilityPeriod, clsProviderIneligibilityPeriodCollection |
SQL referencing this table¶
- SQL-026: Insert Provider Ineligibility Period
- SQL-050: Retrieve Provider Ineligibility Period
- SQL-051: Retrieve Provider Ineligibility Period Collection
- SQL-074: Update Provider Ineligibility Period
- SQL-096: Delete Provider Ineligibility Period
PROVIDER_INELIG_REASON_CD¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores data used by clsProviderIneligibilityReasonCode. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | Primary key and foreign-key columns surfaced by the owning business object criteria. |
| Sequence | N/A |
| Related tables | None identified |
| Business objects | clsProviderIneligibilityReasonCode |
SQL referencing this table¶
- SQL-027: Insert Provider Ineligibility Reason Code
- SQL-052: Retrieve Provider Ineligibility Reason Code
- SQL-075: Update Provider Ineligibility Reason Code
- SQL-097: Delete Provider Ineligibility Reason Code
PROVIDER_LOCATION¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores provider location, name, approval, communication, and status fields. |
| Access pattern | BOF criteria SQL and application-layer direct SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | PROVIDER_LOCATION_SEQ_NUM, PROVIDER_SEQ_NUM, PROVIDER_TYPE_CODE, PRIMARY_LOCATION_FLAG, UPDATE_NUM |
| Sequence | PROVIDER_LOCATION_SEQ_NUM_NEXTVAL |
| Related tables | See operations, rules, and SQL sections below. |
| Business objects | clsProviderLocation, clsProviderRelationship, clsProviderUtility |
Operations referencing this table¶
Business rules referencing this table¶
- BR-001: Search requires at least one criterion
- BR-003: Only one primary location is allowed
- BR-004: Provider type is required for a location
- BR-005: Business locations require a business name
- BR-006: Individual locations require a last name
- BR-013: Relationship participants must exist and be distinct
SQL referencing this table¶
- SQL-028: Insert Provider Location
- SQL-053: Retrieve Provider Location
- SQL-055: Retrieve Provider Relationship
- SQL-076: Update Provider Location
- SQL-098: Delete Provider Location
PROVIDER_RELATIONSHIP¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores provider-to-provider relationship links and effective dates. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | PROVIDER_LOCATION_SEQ_NUM, PARENT_PROVIDER_LOC_SEQ_NUM, PROVIDER_RELATIONSHIP_CODE, EFF_DATE, EXP_DATE, UPDATE_NUM |
| Sequence | N/A |
| Related tables | See operations, rules, and SQL sections below. |
| Business objects | clsProviderRelationship |
Operations referencing this table¶
Business rules referencing this table¶
- BR-013: Relationship participants must exist and be distinct
- BR-014: Relationship dates must be valid and non-overlapping
SQL referencing this table¶
- SQL-030: Insert Provider Relationship
- SQL-055: Retrieve Provider Relationship
- SQL-078: Update Provider Relationship
- SQL-100: Delete Provider Relationship
PROVIDER_RELATIONSHIP_CODE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores data used by clsProviderRelationshipCode. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | Primary key and foreign-key columns surfaced by the owning business object criteria. |
| Sequence | N/A |
| Related tables | None identified |
| Business objects | clsProviderRelationshipCode |
SQL referencing this table¶
- SQL-031: Insert Provider Relationship Code
- SQL-056: Retrieve Provider Relationship Code
- SQL-079: Update Provider Relationship Code
- SQL-101: Delete Provider Relationship Code
PROVIDER_SERVICE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores service assignments for provider locations. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | Primary key and foreign-key columns surfaced by the owning business object criteria. |
| Sequence | N/A |
| Related tables | See operations, rules, and SQL sections below. |
| Business objects | clsProviderService |
Operations referencing this table¶
SQL referencing this table¶
- SQL-032: Insert Provider Service
- SQL-057: Retrieve Provider Service
- SQL-080: Update Provider Service
- SQL-102: Delete Provider Service
PROVIDER_SERVICE_CODE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores data used by clsProviderServiceCode. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | Primary key and foreign-key columns surfaced by the owning business object criteria. |
| Sequence | N/A |
| Related tables | None identified |
| Business objects | clsProviderServiceCode |
SQL referencing this table¶
- SQL-033: Insert Provider Service Code
- SQL-058: Retrieve Provider Service Code
- SQL-081: Update Provider Service Code
- SQL-103: Delete Provider Service Code
PROVIDER_SERVICE_CONTRACT¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores provider service contract rates and effective dates. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Create, Update, Delete |
| Key columns used | Primary key and foreign-key columns surfaced by the owning business object criteria. |
| Sequence | N/A |
| Related tables | None identified |
| Business objects | clsProviderServiceContract |
SQL referencing this table¶
- SQL-034: Insert Provider Service Contract
- SQL-082: Update Provider Service Contract
- SQL-104: Delete Provider Service Contract
PROVIDER_SERVICE_TYPE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores data used by clsProviderServiceType. |
| Access pattern | BOF criteria SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | Primary key and foreign-key columns surfaced by the owning business object criteria. |
| Sequence | N/A |
| Related tables | None identified |
| Business objects | clsProviderServiceType |
SQL referencing this table¶
- SQL-035: Insert Provider Service Type
- SQL-059: Retrieve Provider Service Type
- SQL-083: Update Provider Service Type
- SQL-105: Delete Provider Service Type
PROVIDER_TAX_ID¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores provider tax IDs, registered names, and TIN mailing-address information. |
| Access pattern | BOF criteria SQL and application-layer direct SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | TAX_ID, PROVIDER_SEQ_NUM, PRIMARY_TAX_ID_FLAG, EFF_DATE, EXP_DATE, UPDATE_NUM |
| Sequence | N/A |
| Related tables | See operations, rules, and SQL sections below. |
| Business objects | clsProviderTaxID, clsProviderUtility |
Operations referencing this table¶
Business rules referencing this table¶
- BR-011: TIN values must be nine numeric digits and unique
- BR-012: Only one primary TIN is allowed per provider
SQL referencing this table¶
- SQL-036: Insert Provider Tax I D
- SQL-060: Retrieve Provider Tax I D
- SQL-084: Update Provider Tax I D
- SQL-106: Delete Provider Tax I D
PROVIDER_TYPE_CODE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** |
| Purpose | Stores data used by clsProviderType, clsProviderTypeCode, clsProviderTypeCollection, clsProviderUtility. |
| Access pattern | BOF criteria SQL and application-layer direct SQL |
| CRUD operations | Create, Read, Update, Delete |
| Key columns used | CODE, CODE_DESCR, UPDATE_NUM |
| Sequence | N/A |
| Related tables | See operations, rules, and SQL sections below. |
| Business objects | clsProviderType, clsProviderTypeCode, clsProviderTypeCollection, clsProviderUtility |
Operations referencing this table¶
Business rules referencing this table¶
SQL referencing this table¶
- SQL-037: Insert Provider Type Code
- SQL-061: Retrieve Provider Type
- SQL-062: Retrieve Provider Type Code
- SQL-063: Retrieve Provider Type Collection
- SQL-085: Update Provider Type Code
- SQL-107: Delete Provider Type Code
Table relationship diagram¶
The following diagram shows the primary table relationships surfaced by provider-domain CRUD and lookup SQL.
erDiagram
PROVIDER ||--o{ PROVIDER_LOCATION : "has"
PROVIDER ||--o{ PROVIDER_TAX_ID : "owns"
PROVIDER_LOCATION ||--o{ PROVIDER_ADDRESS : "uses"
PROVIDER_LOCATION ||--o{ PROVIDER_CONTACT : "uses"
PROVIDER_LOCATION ||--o{ PROVIDER_IDENTITY : "uses"
PROVIDER_LOCATION ||--o{ PROVIDER_SERVICE : "offers"
PROVIDER_LOCATION ||--o{ PROVIDER_RELATIONSHIP : "links"
PROVIDER_LOCATION ||--o{ MCO_PROVIDER : "enrolls"
MCO_PLAN ||--o{ MCO_PROVIDER : "defines"
PROVIDER_RELATIONSHIP }o--|| PROVIDER_RELATIONSHIP_CODE : "typed by"
PROVIDER_ADDRESS }o--|| PROVIDER_ADDRESS_CODE : "typed by"
PROVIDER_CONTACT }o--|| PROVIDER_CONTACT_CODE : "typed by"
PROVIDER_IDENTITY }o--|| PROVIDER_IDENTITY_CODE : "typed by"
PROVIDER_INELIG_PERIOD }o--|| PROVIDER_INELIG_REASON_CD : "reason"
Related documentation¶
- Index
- Overview
- Architecture
- Dependencies
- Operations and processes
- Business rules
- SQL catalog
- API reference
- Configuration
Note: Statements marked with
**could not be confirmed; treat as unknown until verified.
Sources¶
Business\SAIF.Business.Provider\clsNote.vbBusiness\SAIF.Business.Provider\clsNote.vbBusiness\SAIF.Business.Provider\clsCBPService.vbBusiness\SAIF.Business.Provider\clsCBPService.vbBusiness\SAIF.Business.Provider\clsCBPServiceType.vbBusiness\SAIF.Business.Provider\clsMCOPlan.vbBusiness\SAIF.Business.Provider\clsProviderUtility.vbBusiness\SAIF.Business.Provider\clsProviderMCOMembership.vbBusiness\SAIF.Business.Provider\clsProvider.vbBusiness\SAIF.Business.Provider\clsProviderUtility.vbBusiness\SAIF.Business.Provider\clsProviderAddress.vbBusiness\SAIF.Business.Provider\clsProviderAddressCode.vbBusiness\SAIF.Business.Provider\clsProviderContact.vbBusiness\SAIF.Business.Provider\clsProviderContactCode.vbBusiness\SAIF.Business.Provider\clsProviderDcbsCostCharge.vbBusiness\SAIF.Business.Provider\clsProviderIdentity.vbBusiness\SAIF.Business.Provider\clsProviderIdentityCode.vbBusiness\SAIF.Business.Provider\clsProviderIneligibilityPeriod.vbBusiness\SAIF.Business.Provider\clsProviderIneligibilityPeriodCollection.vbBusiness\SAIF.Business.Provider\clsProviderIneligibilityReasonCode.vbBusiness\SAIF.Business.Provider\clsProviderLocation.vbBusiness\SAIF.Business.Provider\clsProviderRelationship.vbBusiness\SAIF.Business.Provider\clsProviderUtility.vbBusiness\SAIF.Business.Provider\clsProviderRelationship.vbBusiness\SAIF.Business.Provider\clsProviderRelationshipCode.vbBusiness\SAIF.Business.Provider\clsProviderService.vbBusiness\SAIF.Business.Provider\clsProviderServiceCode.vbBusiness\SAIF.Business.Provider\clsProviderServiceContract.vbBusiness\SAIF.Business.Provider\clsProviderServiceType.vbBusiness\SAIF.Business.Provider\clsProviderTaxID.vbBusiness\SAIF.Business.Provider\clsProviderUtility.vbBusiness\SAIF.Business.Provider\clsProviderType.vbBusiness\SAIF.Business.Provider\clsProviderTypeCode.vbBusiness\SAIF.Business.Provider\clsProviderTypeCollection.vbBusiness\SAIF.Business.Provider\clsProviderUtility.vb