SQL-014: clsProviderEFT

UPDATE PROVIDER_EFT_INTERFACE.

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
:ExtUserTypeSeqNum	Input	clsSmartDecimal	N/A	External user type after SetExtUserTypeSeqNum.
:UpdateDate	Input	Date	N/A	Audit timestamp.
:UpdateUser	Input	String	30	Audit user.
:EffDate	Input	clsSmartDate	N/A	EFT effective date; defaults to Today.Date when Date.MinValue.
:ExpDate	Input	clsSmartDate	N/A	EFT expiration date.
:DefaultToPrimaryFlag	Input	String	1	Default-to-primary indicator.
:ProviderSeqNum	Input	Decimal	N/A	Provider key in WHERE.
:ProviderLocationSeqNum	Input	Decimal	N/A	Provider-location key in WHERE.

Tables

Table	Access	Columns used
PROVIDER_EFT_INTERFACE	UPDATE	See sample SQL.

Sample SQL

UPDATE PROVIDER_EFT_INTERFACE
SET EXT_USER_TYPE_SEQ_NUM = :ExtUserTypeSeqNum,
    EFF_DATE = :EffDate,
    EXP_DATE = :ExpDate,
    DEFAULT_TO_PRIMARY_FLAG = :DefaultToPrimaryFlag,
    UPDATE_DATE = :UpdateDate,
    UPDATE_NUM = UPDATE_NUM + 1,
    UPDATE_USER = :UpdateUser
WHERE PROVIDER_EFT_INTERFACE.PROVIDER_SEQ_NUM = :ProviderSeqNum
  AND PROVIDER_EFT_INTERFACE.PROVIDER_LOCATION_SEQ_NUM = :ProviderLocationSeqNum

Operations and processes

• EFT record management
• EFT payment location assignment

Business rules

• BR-10: Unassigning EFT expires the record and revokes authorization.
• BR-13: EFT update increments update number only on success.
• BR-16: EFT updates default missing effective dates to today.

Sources

• Business\SAIF.Business.Provider.PaymentPreference\clsProviderEFT.vb