SAIF.Business.View.Provider business rules

This page captures business rules enforced by this library.

BR-001: Provider type read-only criteria

Field	Value
Statement	Provider type criteria exposes retrieval only and rejects create, insert, update, and delete SQL accessors.
Trigger	A caller requests a non-retrieve SQL property from provider type criteria.
Enforcement	clsProviderType.Criteria throws ApplicationException(clsConstants.Messages.InvalidSQLProperty) for non-retrieve SQL properties.
Outcome	Provider type reference data can be read but not modified through this library.
Confidence	Verified
Tables	PROVIDER_TYPE_CODE
SQL	SQL-019, SQL-020
Source	Business\SAIF.Business.View.Provider\clsProviderType.vb Business\SAIF.Business.View.Provider\clsProviderTypeCollection.vb
---
## BR-002: Provider service contract expiration window

Field	Value
Statement	Provider service contracts are active only when EXP_DATE is null or later than SYSDATE - :Offset.
Trigger	A caller constructs a provider service contract list.
Enforcement	clsProviderServiceContractList.New appends the expiration predicate in SQL-016.
Outcome	Expired contracts outside the offset grace window are excluded from results.
Confidence	Verified
Tables	PROVIDER_SERVICE_CONTRACT
SQL	SQL-016
Source	Business\SAIF.Business.View.Provider\clsProviderServiceContract.vb
---
## BR-003: Provider search dynamic join filtering

Field	Value
Statement	Provider search adds joins and predicates only for filters the caller supplies.
Trigger	A caller invokes searchForProvider() with populated search criteria.
Enforcement	clsProviderSearch.searchForProvider() conditionally appends joins and predicates inside SQL-015.
Outcome	Search results are narrowed only by supplied criteria.
Confidence	Verified
Tables	PROVIDER_LOCATION, PROVIDER_TYPE_CODE, PROVIDER_ADDRESS, PROVIDER_TAX_ID, PROVIDER_IDENTITY, PROVIDER_SERVICE, MCO_PROVIDER
SQL	SQL-015
Source	Business\SAIF.Business.View.Provider\clsProviderSearch.vb
---
## BR-004: Provider tax ID retrieve-only access

Field	Value
Statement	Provider tax ID data is exposed through a retrieve-only collection contract.*
Trigger	A caller requests provider tax IDs through GetProviderTaxIDs(...).
Enforcement	clsProviderTaxIDCollection.Criteria inherits clsRetrieveOnlyBusinessCriteria and sets only retrieve SQL.*
Outcome	Provider tax ID rows can be read but are not modified through this component.
Confidence	Inferred
Tables	PROVIDER_TAX_ID
SQL	SQL-018
Source	Business\SAIF.Business.View.Provider\clsProviderTaxIDCollection.vb

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Database tables
• SQL catalog
• API reference

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts.

Sources

• Business\SAIF.Business.View.Provider\clsProviderSearch.vb
• Business\SAIF.Business.View.Provider\clsProviderServiceContract.vb
• Business\SAIF.Business.View.Provider\clsProviderTaxIDCollection.vb
• Business\SAIF.Business.View.Provider\clsProviderType.vb
• Business\SAIF.Business.View.Provider\clsProviderTypeCollection.vb