SQL-013: clsProviderEOB¶

UPDATE PROVIDER_EOB_INTERFACE.

Classification¶

Field	Value
SQL ID	SQL-013
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	Unqualified in SQL text
Command type	Text
Business object	`clsProviderEOB`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:ProviderSeqNum`	Input	Decimal	N/A	Provider key in both SET and WHERE.
`:ProviderLocationSeqNum`	Input	Decimal	N/A	Provider-location key in both SET and WHERE.
`:ExtUserTypeSeqNum`	Input	clsSmartDecimal	N/A	External user type.
`:PaperlessEOBFlag`	Input	String	5	Current paperless preference.
`:DefaultPrimaryFlag`	Input	String	5	Current default-to-primary preference.
`:UpdateDate`	Input	Date	N/A	Audit timestamp.
`:UpdateUser`	Input	String	30	Audit user.
`:UpdateNum`	Input	Decimal	N/A	Optimistic-concurrency token required by WHERE UPDATE_NUM = :UpdateNum.

Tables¶

Table	Access	Columns used
PROVIDER_EOB_INTERFACE	UPDATE	See sample SQL.

Sample SQL¶

UPDATE PROVIDER_EOB_INTERFACE
SET PROVIDER_SEQ_NUM = :ProviderSeqNum,
    PROVIDER_LOCATION_SEQ_NUM = :ProviderLocationSeqNum,
    EXT_USER_TYPE_SEQ_NUM = :ExtUserTypeSeqNum,
    PAPERLESS_EOB_FLAG = :PaperlessEOBFlag,
    DEFAULT_TO_PRIMARY_FLAG = :DefaultPrimaryFlag,
    UPDATE_DATE = :UpdateDate,
    UPDATE_NUM = UPDATE_NUM + 1,
    UPDATE_USER = :UpdateUser
WHERE PROVIDER_EOB_INTERFACE.PROVIDER_SEQ_NUM = :ProviderSeqNum
  AND PROVIDER_EOB_INTERFACE.PROVIDER_LOCATION_SEQ_NUM = :ProviderLocationSeqNum
  AND UPDATE_NUM = :UpdateNum

Operations and processes¶

EOB preference management

Business rules¶

BR-04: EOB updates enforce optimistic concurrency.

Sources¶

Business\SAIF.Business.Provider.PaymentPreference\clsProviderEOB.vb