SQL-DCBS-01 Provider DCBS cost charges¶

Retrieves the DCBS cost-charge factor history for a given provider location, including effective and expiration dates, so the caller can determine the applicable rate for a date-window calculation.

Classification¶

Field	Value
SQL ID	SQL-DCBS-01
Operation type	Read
Execution method	Inline SQL (StringBuilder-assembled) via `SqlHelper.ResultSetQuery`
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	N/A (Application layer)
Criteria property	N/A
Lifecycle method	N/A
Application class	`clsDCBSCostChargeList`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:ProviderLocationID`	Input	Decimal	N/A	Provider location surrogate key

Tables¶

Table	Access	Columns used
PROVIDER_DCBS_COST_CHARGE	SELECT	`PROVIDER_LOCATION_SEQ_NUM`, `EFF_DATE`, `EXP_DATE`, `COST_CHARGE_FACTOR`

Sample SQL¶

-- Provider DCBS cost charges
SELECT
  PROVIDER_LOCATION_SEQ_NUM AS ProviderLocationID,
  EFF_DATE                  AS EffectiveDate,
  EXP_DATE                  AS ExpirationDate,
  COST_CHARGE_FACTOR        AS CostChargeFactor
FROM PROVIDER_DCBS_COST_CHARGE
WHERE PROVIDER_LOCATION_SEQ_NUM = :ProviderLocationID

Operations and processes¶

Load DCBS cost charge factors

Business rules¶

BR-DATE-001: Date-window effectiveness

Sources¶

SAIF.Business.View.Provider/clsDCBSCostCharge.vb