Skip to content

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


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


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


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

SQL referencing this table


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


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


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


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


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


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


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


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


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

SQL referencing this table


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

SQL referencing this table


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


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


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


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


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


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

SQL referencing this table


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


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"

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

Sources

  • Business\SAIF.Business.Provider\clsNote.vb
  • Business\SAIF.Business.Provider\clsNote.vb
  • Business\SAIF.Business.Provider\clsCBPService.vb
  • Business\SAIF.Business.Provider\clsCBPService.vb
  • Business\SAIF.Business.Provider\clsCBPServiceType.vb
  • Business\SAIF.Business.Provider\clsMCOPlan.vb
  • Business\SAIF.Business.Provider\clsProviderUtility.vb
  • Business\SAIF.Business.Provider\clsProviderMCOMembership.vb
  • Business\SAIF.Business.Provider\clsProvider.vb
  • Business\SAIF.Business.Provider\clsProviderUtility.vb
  • Business\SAIF.Business.Provider\clsProviderAddress.vb
  • Business\SAIF.Business.Provider\clsProviderAddressCode.vb
  • Business\SAIF.Business.Provider\clsProviderContact.vb
  • Business\SAIF.Business.Provider\clsProviderContactCode.vb
  • Business\SAIF.Business.Provider\clsProviderDcbsCostCharge.vb
  • Business\SAIF.Business.Provider\clsProviderIdentity.vb
  • Business\SAIF.Business.Provider\clsProviderIdentityCode.vb
  • Business\SAIF.Business.Provider\clsProviderIneligibilityPeriod.vb
  • Business\SAIF.Business.Provider\clsProviderIneligibilityPeriodCollection.vb
  • Business\SAIF.Business.Provider\clsProviderIneligibilityReasonCode.vb
  • Business\SAIF.Business.Provider\clsProviderLocation.vb
  • Business\SAIF.Business.Provider\clsProviderRelationship.vb
  • Business\SAIF.Business.Provider\clsProviderUtility.vb
  • Business\SAIF.Business.Provider\clsProviderRelationship.vb
  • Business\SAIF.Business.Provider\clsProviderRelationshipCode.vb
  • Business\SAIF.Business.Provider\clsProviderService.vb
  • Business\SAIF.Business.Provider\clsProviderServiceCode.vb
  • Business\SAIF.Business.Provider\clsProviderServiceContract.vb
  • Business\SAIF.Business.Provider\clsProviderServiceType.vb
  • Business\SAIF.Business.Provider\clsProviderTaxID.vb
  • Business\SAIF.Business.Provider\clsProviderUtility.vb
  • Business\SAIF.Business.Provider\clsProviderType.vb
  • Business\SAIF.Business.Provider\clsProviderTypeCode.vb
  • Business\SAIF.Business.Provider\clsProviderTypeCollection.vb
  • Business\SAIF.Business.Provider\clsProviderUtility.vb