SQL-009: clsProviderEFTCollection¶

SELECT all PROVIDER_EFT_INTERFACE rows.

Classification¶

Field	Value
SQL ID	SQL-009
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	`GetAllEFTsColl`

Parameters¶

Parameter	Direction	Type	Max length	Description
`—`	—	—	—	No parameters; returns every row in PROVIDER_EFT_INTERFACE.

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

Operations and processes¶

Provider EFT collection retrieval

Sources¶

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