SAIF.Business.View.Provider database tables

This page catalogs database tables accessed by this library.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
MCO_PROVIDER	Oracle	[unqualified]**	R	MCO enrollment and fee-rate rows for a provider location.	clsMCOProviderList
PROVIDER	Oracle	[unqualified]**	R	Provider master rows keyed by provider sequence number and primary tax ID.	clsProvider
PROVIDER_ADDRESS	Oracle	[unqualified]**	R	Address rows associated with provider locations.	clsProviderAddress
PROVIDER_DCBS_COST_CHARGE	Oracle	[unqualified]**	R	DCBS cost-charge rows for provider locations.	clsDCBSCostChargeList
PROVIDER_IDENTITY	Oracle	[unqualified]**	R	Alternate identity values used by provider search.	clsProviderSearch
PROVIDER_INELIG_PERIOD	Oracle	[unqualified]**	R	Provider-location ineligibility periods.	clsProviderIneligibilityPeriod
PROVIDER_LOCATION	Oracle	[unqualified]**	R	Provider location demographic, contact, and classification rows.	clsProviderAddress
PROVIDER_RELATIONSHIP	Oracle	[unqualified]**	R	Parent/child relationships between provider locations.	clsProviderRelationshipCollection
PROVIDER_SERVICE	Oracle	[unqualified]**	R	Service assignments for provider locations.	clsProviderSearch
PROVIDER_SERVICE_CODE	Oracle	[unqualified]**	R	Reference descriptions and specialty mappings for provider service codes.	clsProviderServiceList
PROVIDER_SERVICE_CONTRACT	Oracle	[unqualified]**	R	Provider-location service contracts.	clsProviderServiceContractList
PROVIDER_TAX_ID	Oracle	[unqualified]**	R	Provider tax-ID and registered-name rows.	clsProvider
PROVIDER_TYPE_CODE	Oracle	[unqualified]**	R	Provider type reference-data rows.	clsProviderSearch

MCO_PROVIDER

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	MCO enrollment and fee-rate rows for a provider location.
Access pattern	direct SQL
CRUD operations	Read
Key columns used	PROVIDER_LOCATION_SEQ_NUM, MCO_PLAN_ID, EFF_DATE, EXP_DATE
Sequence	N/A
Related tables	PROVIDER_LOCATION
Business objects	clsMCOProviderList, clsProviderSearch

Operations referencing this table

• Search providers
• Retrieve MCO provider enrollments

Business rules referencing this table

• BR-003: Provider search dynamic join filtering

SQL referencing this table

• SQL-002: Provider location MCO enrollments
• SQL-015: Provider search by dynamic criteria

---

PROVIDER

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Provider master rows keyed by provider sequence number and primary tax ID.
Access pattern	direct SQL
CRUD operations	Read
Key columns used	PROVIDER_SEQ_NUM, PRIMARY_TAX_ID
Sequence	N/A
Related tables	PROVIDER_LOCATION, PROVIDER_TAX_ID
Business objects	clsProvider, clsProviderCollection

Operations referencing this table

• Retrieve provider by ID
• Retrieve provider by primary tax ID
• Retrieve provider collection

Business rules referencing this table

• None documented

SQL referencing this table

• SQL-003: Provider by provider ID
• SQL-004: Provider by primary tax ID
• SQL-007: Provider collection by dynamic filter

---

PROVIDER_ADDRESS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Address rows associated with provider locations.
Access pattern	direct SQL
CRUD operations	Read
Key columns used	PROVIDER_LOCATION_SEQ_NUM, PROVIDER_ADDRESS_SEQ_NUM, PROVIDER_ADDRESS_CODE, CITY_NAME, STATE_CODE, ZIP_CODE
Sequence	N/A
Related tables	PROVIDER_LOCATION
Business objects	clsProviderAddress, clsProviderAddressCollection, clsProviderSearch

Operations referencing this table

• Retrieve provider addresses
• Search providers

Business rules referencing this table

• BR-003: Provider search dynamic join filtering

SQL referencing this table

• SQL-005: Provider address by location
• SQL-006: Provider address collection by location
• SQL-015: Provider search by dynamic criteria

---

PROVIDER_DCBS_COST_CHARGE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	DCBS cost-charge rows for provider locations.
Access pattern	direct SQL
CRUD operations	Read
Key columns used	PROVIDER_LOCATION_SEQ_NUM, EFF_DATE, EXP_DATE, COST_CHARGE_FACTOR
Sequence	N/A
Related tables	PROVIDER_LOCATION
Business objects	clsDCBSCostChargeList

Operations referencing this table

• Retrieve DCBS cost charges

Business rules referencing this table

• None documented

SQL referencing this table

- SQL-001: Provider location DCBS cost charges

PROVIDER_IDENTITY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Alternate identity values used by provider search.
Access pattern	direct SQL
CRUD operations	Read
Key columns used	PROVIDER_LOCATION_SEQ_NUM, IDENTITY_VALUE
Sequence	N/A
Related tables	PROVIDER_LOCATION
Business objects	clsProviderSearch

Operations referencing this table

• Search providers

Business rules referencing this table

• BR-003: Provider search dynamic join filtering

SQL referencing this table

- SQL-015: Provider search by dynamic criteria

PROVIDER_INELIG_PERIOD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Provider-location ineligibility periods.
Access pattern	direct SQL
CRUD operations	Read
Key columns used	PROVIDER_INELIG_PERIOD_SEQ_NUM, PROVIDER_LOCATION_SEQ_NUM, PROVIDER_INELIG_REASON_CODE
Sequence	N/A
Related tables	PROVIDER_LOCATION
Business objects	clsProviderIneligibilityPeriod, clsProviderIneligibilityPeriodCollection

Operations referencing this table

• Retrieve provider ineligibility period
• Retrieve provider ineligibility periods

Business rules referencing this table

• None documented

SQL referencing this table

• SQL-008: Provider ineligibility period by ID
• SQL-009: Provider ineligibility periods by location

---

PROVIDER_LOCATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Provider location demographic, contact, and classification rows.
Access pattern	direct SQL
CRUD operations	Read
Key columns used	PROVIDER_LOCATION_SEQ_NUM, PROVIDER_SEQ_NUM, PROVIDER_TYPE_CODE
Sequence	N/A
Related tables	MCO_PROVIDER, PROVIDER, PROVIDER_ADDRESS, PROVIDER_DCBS_COST_CHARGE, PROVIDER_IDENTITY, PROVIDER_INELIG_PERIOD, PROVIDER_RELATIONSHIP, PROVIDER_SERVICE, PROVIDER_SERVICE_CONTRACT, PROVIDER_TYPE_CODE
Business objects	clsProviderAddress, clsProviderLocation, clsProviderLocationCollection, clsProviderRelationshipCollection, clsProviderSearch

Operations referencing this table

• Retrieve provider addresses
• Retrieve provider location
• Retrieve provider locations by provider
• Retrieve provider locations by type
• Retrieve child provider relationships
• Retrieve parent provider relationships
• Search providers

Business rules referencing this table

• BR-003: Provider search dynamic join filtering

SQL referencing this table

• SQL-005: Provider address by location
• SQL-006: Provider address collection by location
• SQL-010: Provider location by ID
• SQL-011: Provider locations by provider
• SQL-012: Provider locations by type
• SQL-013: Child provider relationships by location
• SQL-014: Parent provider relationships by location
• SQL-015: Provider search by dynamic criteria

---

PROVIDER_RELATIONSHIP

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Parent/child relationships between provider locations.
Access pattern	direct SQL
CRUD operations	Read
Key columns used	PROVIDER_LOCATION_SEQ_NUM, PARENT_PROVIDER_LOC_SEQ_NUM, PROVIDER_RELATIONSHIP_CODE
Sequence	N/A
Related tables	PROVIDER_LOCATION
Business objects	clsProviderRelationshipCollection

Operations referencing this table

• Retrieve child provider relationships
• Retrieve parent provider relationships

Business rules referencing this table

• None documented

SQL referencing this table

• SQL-013: Child provider relationships by location
• SQL-014: Parent provider relationships by location

---

PROVIDER_SERVICE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Service assignments for provider locations.
Access pattern	direct SQL
CRUD operations	Read
Key columns used	PROVIDER_LOCATION_SEQ_NUM, PROVIDER_SERVICE_CODE, PRIMARY_SERVICE_FLAG
Sequence	N/A
Related tables	PROVIDER_LOCATION, PROVIDER_SERVICE_CODE
Business objects	clsProviderSearch, clsProviderServiceList

Operations referencing this table

• Search providers
• Retrieve provider services

Business rules referencing this table

• BR-003: Provider search dynamic join filtering

SQL referencing this table

• SQL-015: Provider search by dynamic criteria
• SQL-017: Provider services by location

---

PROVIDER_SERVICE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Reference descriptions and specialty mappings for provider service codes.
Access pattern	direct SQL
CRUD operations	Read
Key columns used	CODE, CODE_DESCR, DCBS_PROVIDER_SPECIALTY_CODE
Sequence	N/A
Related tables	PROVIDER_SERVICE
Business objects	clsProviderServiceList

Operations referencing this table

• Retrieve provider services

Business rules referencing this table

• None documented

SQL referencing this table

- SQL-017: Provider services by location

PROVIDER_SERVICE_CONTRACT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Provider-location service contracts.
Access pattern	direct SQL
CRUD operations	Read
Key columns used	PROV_SERVICE_CONTRACT_SEQ_NUM, PROVIDER_LOCATION_SEQ_NUM, MCO_PLAN_ID
Sequence	N/A
Related tables	PROVIDER_LOCATION
Business objects	clsProviderServiceContractList

Operations referencing this table

• Retrieve provider service contracts

Business rules referencing this table

• BR-002: Provider service contract expiration window

SQL referencing this table

- SQL-016: Provider service contracts by location

PROVIDER_TAX_ID

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Provider tax-ID and registered-name rows.
Access pattern	direct SQL
CRUD operations	Read
Key columns used	PROVIDER_SEQ_NUM, TAX_ID, REGISTERED_NAME
Sequence	N/A
Related tables	PROVIDER
Business objects	clsProvider, clsProviderCollection, clsProviderSearch, clsProviderTaxIDCollection

Operations referencing this table

• Retrieve provider by ID
• Retrieve provider by primary tax ID
• Retrieve provider collection
• Search providers
• Retrieve provider tax IDs

Business rules referencing this table

• BR-003: Provider search dynamic join filtering
• BR-004: Provider tax ID retrieve-only access

SQL referencing this table

• SQL-003: Provider by provider ID
• SQL-004: Provider by primary tax ID
• SQL-007: Provider collection by dynamic filter
• SQL-015: Provider search by dynamic criteria
• SQL-018: Provider tax IDs by provider

---

PROVIDER_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Provider type reference-data rows.
Access pattern	direct SQL
CRUD operations	Read
Key columns used	CODE, CODE_DESCR, CLAIM_PROFILE_FLAG, DCBS_PROVIDER_TYPE_CODE
Sequence	N/A
Related tables	PROVIDER_LOCATION
Business objects	clsProviderSearch, clsProviderType, clsProviderTypeCollection

Operations referencing this table

• Search providers
• Retrieve provider type
• Retrieve provider type collection

Business rules referencing this table

• BR-001: Provider type read-only criteria
• BR-003: Provider search dynamic join filtering

SQL referencing this table

• SQL-015: Provider search by dynamic criteria
• SQL-019: Provider type by code
• SQL-020: Provider type catalog

Table relationship diagram

The following diagram shows relationships between tables used by this library.

erDiagram
    PROVIDER ||--o{ PROVIDER_TAX_ID : "PRV.PRIMARY_TAX_ID = TAX.TAX_ID"
    PROVIDER ||--o{ PROVIDER_LOCATION : "PROVIDER_LOCATION.PROVIDER_SEQ_NUM = PROVIDER.PROVIDER_SEQ_NUM"
    PROVIDER_LOCATION ||--o{ PROVIDER_ADDRESS : "pa.PROVIDER_LOCATION_SEQ_NUM = ppl.PROVIDER_LOCATION_SEQ_NUM"
    PROVIDER_LOCATION ||--o{ PROVIDER_INELIG_PERIOD : "PROVIDER_INELIG_PERIOD.PROVIDER_LOCATION_SEQ_NUM = PROVIDER_LOCATION.PROVIDER_LOCATION_SEQ_NUM"
    PROVIDER_LOCATION ||--o{ PROVIDER_RELATIONSHIP : "pr.PROVIDER_LOCATION_SEQ_NUM = pl.PROVIDER_LOCATION_SEQ_NUM"
    PROVIDER_LOCATION ||--o{ PROVIDER_RELATIONSHIP : "pr.PARENT_PROVIDER_LOC_SEQ_NUM = parentPL.PROVIDER_LOCATION_SEQ_NUM"
    PROVIDER_LOCATION ||--o{ PROVIDER_TYPE_CODE : "PL.PROVIDER_TYPE_CODE = TYPE.CODE"
    PROVIDER_LOCATION ||--o{ PROVIDER_IDENTITY : "PL.PROVIDER_LOCATION_SEQ_NUM = ID.PROVIDER_LOCATION_SEQ_NUM"
    PROVIDER ||--o{ PROVIDER_TAX_ID : "PL.PROVIDER_SEQ_NUM = T.PROVIDER_SEQ_NUM"
    PROVIDER_LOCATION ||--o{ PROVIDER_SERVICE : "PL.PROVIDER_LOCATION_SEQ_NUM = SVC.PROVIDER_LOCATION_SEQ_NUM"
    PROVIDER_SERVICE_CODE ||--o{ PROVIDER_SERVICE : "PROVIDER_SERVICE_CODE.CODE = PROVIDER_SERVICE.PROVIDER_SERVICE_CODE"
    PROVIDER_LOCATION ||--o{ MCO_PROVIDER : "PL.PROVIDER_LOCATION_SEQ_NUM = MP.PROVIDER_LOCATION_SEQ_NUM"
    PROVIDER_LOCATION ||--o{ PROVIDER_SERVICE_CONTRACT : "PROVIDER_SERVICE_CONTRACT.PROVIDER_LOCATION_SEQ_NUM = PROVIDER_LOCATION.PROVIDER_LOCATION_SEQ_NUM"
    PROVIDER_LOCATION ||--o{ PROVIDER_DCBS_COST_CHARGE : "PROVIDER_DCBS_COST_CHARGE.PROVIDER_LOCATION_SEQ_NUM = PROVIDER_LOCATION.PROVIDER_LOCATION_SEQ_NUM"

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• SQL catalog
• API reference

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Business\SAIF.Business.View.Provider\clsDCBSCostCharge.vb
• Business\SAIF.Business.View.Provider\clsMCOProvider.vb
• Business\SAIF.Business.View.Provider\clsProvider.vb
• Business\SAIF.Business.View.Provider\clsProviderAddress.vb
• Business\SAIF.Business.View.Provider\clsProviderAddressCollection.vb
• Business\SAIF.Business.View.Provider\clsProviderCollection.vb
• Business\SAIF.Business.View.Provider\clsProviderIneligibilityPeriod.vb
• Business\SAIF.Business.View.Provider\clsProviderIneligibilityPeriodCollection.vb
• Business\SAIF.Business.View.Provider\clsProviderLocation.vb
• Business\SAIF.Business.View.Provider\clsProviderLocationCollection.vb
• Business\SAIF.Business.View.Provider\clsProviderRelationshipCollection.vb
• Business\SAIF.Business.View.Provider\clsProviderSearch.vb
• Business\SAIF.Business.View.Provider\clsProviderServiceContract.vb
• Business\SAIF.Business.View.Provider\clsProviderServices.vb
• Business\SAIF.Business.View.Provider\clsProviderTaxIDCollection.vb
• Business\SAIF.Business.View.Provider\clsProviderType.vb
• Business\SAIF.Business.View.Provider\clsProviderTypeCollection.vb