SQL-047: Retrieve Provider Dcbs Cost Charge

Retrieves provider dcbs cost charge data from Oracle.

Classification

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

Parameters

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

Tables

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

Sample SQL

Select PROVIDER_DCBS_COST_CHARGE.PROVIDER_LOCATION_SEQ_NUM as ProviderLocationSeqNum, PROVIDER_DCBS_COST_CHARGE.EFF_DATE as EffDate, PROVIDER_DCBS_COST_CHARGE.COST_CHARGE_FACTOR as CostChargeFactor, PROVIDER_DCBS_COST_CHARGE.EXP_DATE as ExpDate, PROVIDER_DCBS_COST_CHARGE.UPDATE_USER as UpdateUser, PROVIDER_DCBS_COST_CHARGE.UPDATE_NUM as UpdateNum, PROVIDER_DCBS_COST_CHARGE.UPDATE_DATE as UpdateDate From PROVIDER_DCBS_COST_CHARGE Where PROVIDER_DCBS_COST_CHARGE.PROVIDER_LOCATION_SEQ_NUM = :ProviderLocationSeqNum and PROVIDER_DCBS_COST_CHARGE.EFF_DATE = :OriginalEffDate

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

Sources

• Business\SAIF.Business.Provider\clsProviderDcbsCostCharge.vb