SQL-PINE-01 Ineligibility period by ID

Retrieves a single PROVIDER_INELIG_PERIOD record by its surrogate key, returning the start/termination dates, reason code, and owning provider location.

Classification

Field	Value
SQL ID	SQL-PINE-01
Operation type	Read
Execution method	Inline SQL (BOF criteria constant)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsProviderIneligibilityPeriod
Criteria property	RetrieveSQL
Lifecycle method	BeforeRetrieve / AfterRetrieve

Parameters

Parameter	Direction	Type	Max length	Description
:IneligibilityPeriodID	Input	Decimal	N/A	PROVIDER_INELIG_PERIOD_SEQ_NUM

Tables

Table	Access	Columns used
PROVIDER_INELIG_PERIOD	SELECT	EFF_DATE, EXP_DATE, PROVIDER_INELIG_PERIOD_SEQ_NUM, PROVIDER_INELIG_REASON_CODE, PROVIDER_LOCATION_SEQ_NUM, UPDATE_DATE, UPDATE_NUM, UPDATE_USER

Sample SQL

-- Ineligibility period by ID
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

Operations and processes

• Load provider ineligibility periods

Business rules

• BR-PINE-001: Open-ended ineligibility period
• BR-DATE-001: Date-window effectiveness

Sources

• SAIF.Business.View.Provider/clsProviderIneligibilityPeriod.vb