SQL-051: Retrieve Provider Ineligibility Period Collection

Retrieves provider ineligibility period collection data from Oracle.

Classification

Field	Value
SQL ID	SQL-051
Operation type	Read
Execution method	Inline
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	Value from MyCriteria.ProviderLocationID

Tables

Table	Access	Columns used
PROVIDER_INELIG_PERIOD	SELECT	See business-object criteria for key columns.

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

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

Sources

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