SQL-010: clsProviderEFTCollection¶

SELECT PROVIDER_EFT_INTERFACE by provider.

Classification¶

Field	Value
SQL ID	SQL-010
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	Unqualified in SQL text
Command type	Text
Business object	`clsProviderEFTCollection`
Criteria property	`N/A — direct SQL`
Lifecycle method	`GetProviderEFTColl`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:ProviderSeqNum`	Input	String	30	Provider identifier converted to upper-case text before SqlHelper.NewParm.

Tables¶

Table	Access	Columns used
PROVIDER_EFT_INTERFACE	READ	See sample SQL.

Sample SQL¶

SELECT
    EFT.PROVIDER_SEQ_NUM AS ProviderSeqNum,
    EFT.PROVIDER_LOCATION_SEQ_NUM AS ProviderLocationSeqNum,
    'N' AS IsNewEFTFlag,
    EFT.EXT_USER_TYPE_SEQ_NUM AS ExtUserTypeSeqNum,
    EFT.EFF_DATE AS EffDate,
    EFT.EXP_DATE AS ExpDate,
    EFT.DEFAULT_TO_PRIMARY_FLAG AS DefaultToPrimaryFlag,
    EFT.UPDATE_DATE AS UpdateDate,
    EFT.UPDATE_NUM AS UpdateNum,
    EFT.UPDATE_USER AS UpdateUser
FROM PROVIDER_EFT_INTERFACE EFT
WHERE EFT.PROVIDER_SEQ_NUM = :ProviderSeqNum

Operations and processes¶

Provider EFT collection retrieval

Sources¶

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