SQL-050: Retrieve Provider Ineligibility Period

Retrieves provider ineligibility period data from Oracle.

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
:IneligibilityPeriodID	Input	Decimal	N/A	Value from MyCriteria.IneligibilityPeriodID

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_INELIG_PERIOD_SEQ_NUM = :IneligibilityPeriodID

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

Sources

• Business\SAIF.Business.Provider\clsProviderIneligibilityPeriod.vb