SQL-009: Provider ineligibility periods by location

This statement supports the clsProviderIneligibilityPeriodCollection retrieval path by reading provider-domain data from Oracle tables and projecting the result into business objects or DTO lists.

Classification

Field	Value
SQL ID	SQL-009
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsProviderIneligibilityPeriodCollection
Criteria property	RetrieveSQL
Lifecycle method	BeforeRetrieve

Parameters

Parameter	Direction	Type	Max length	Description
:ProviderLocationID	Input	Decimal	N/A	Retrieves all ineligibility periods for one provider location.

Tables

Table	Access	Columns used
PROVIDER_INELIG_PERIOD	SELECT	PROVIDER_INELIG_PERIOD_SEQ_NUM, PROVIDER_LOCATION_SEQ_NUM, PROVIDER_INELIG_REASON_CODE

Sample SQL

SELECT
  PROVIDER_INELIG_PERIOD.EFF_DATE AS StartDate,
  PROVIDER_INELIG_PERIOD.EXP_DATE AS TerminationDate,
  PROVIDER_INELIG_PERIOD.PROVIDER_INELIG_PERIOD_SEQ_NUM AS IneligibilityPeriodID,
  PROVIDER_INELIG_PERIOD.PROVIDER_INELIG_REASON_CODE AS IneligibilityReasonCode,
  PROVIDER_INELIG_PERIOD.PROVIDER_LOCATION_SEQ_NUM AS ProviderLocationID,
  PROVIDER_INELIG_PERIOD.UPDATE_DATE AS UpdateDate,
  PROVIDER_INELIG_PERIOD.UPDATE_NUM AS UpdateNum,
  PROVIDER_INELIG_PERIOD.UPDATE_USER AS UpdateUser
FROM PROVIDER_INELIG_PERIOD
WHERE PROVIDER_INELIG_PERIOD.PROVIDER_LOCATION_SEQ_NUM = :ProviderLocationID

Operations and processes

• Retrieve provider ineligibility periods

Related documentation

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

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

Sources

• Business\SAIF.Business.View.Provider\clsProviderIneligibilityPeriodCollection.vb