SQL-003: INSERT PROVIDER_EFT_INTERFACE

INSERT PROVIDER_EFT_INTERFACE.

Classification

Field	Value
SQL ID	SQL-003
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	Unqualified in SQL text
Command type	Text
Business object	clsProviderEFT
Criteria property	InsertSQL
Lifecycle method	BeforeInsert

Parameters

Parameter	Direction	Type	Max length	Description
:ExtUserTypeSeqNum	Input	clsSmartDecimal	N/A	External user type; populated via SetExtUserTypeSeqNum when needed.
:EffDate	Input	clsSmartDate	N/A	EFT effective date.
:ExpDate	Input	clsSmartDate	N/A	EFT expiration date.
:DefaultToPrimaryFlag	Input	String	1	Direct-deposit default-to-primary indicator.
:UpdateDate	Input	Date	N/A	Audit timestamp written by BeforeInsert.
:UpdateUser	Input	String	30	BOF user ID from DataPortalInfo.UserID.
:UpdateNum	Input	Decimal	N/A	Starts at 1 on insert.
:ProviderSeqNum	Input	Decimal	N/A	Provider key.
:ProviderLocationSeqNum	Input	Decimal	N/A	Provider-location key.

Tables

Table	Access	Columns used
PROVIDER_EFT_INTERFACE	CREATE	See sample SQL.

Sample SQL

INSERT INTO PROVIDER_EFT_INTERFACE (
    PROVIDER_SEQ_NUM,
    PROVIDER_LOCATION_SEQ_NUM,
    EXT_USER_TYPE_SEQ_NUM,
    EFF_DATE,
    EXP_DATE,
    DEFAULT_TO_PRIMARY_FLAG,
    UPDATE_DATE,
    UPDATE_USER,
    UPDATE_NUM
) VALUES (
    :ProviderSeqNum,
    :ProviderLocationSeqNum,
    :ExtUserTypeSeqNum,
    :EffDate,
    :ExpDate,
    :DefaultToPrimaryFlag,
    :UpdateDate,
    :UpdateUser,
    :UpdateNum
)

Operations and processes

• EFT record management
• EFT payment location assignment

Business rules

• BR-08: Replacing active EFT authorization revokes the existing authorization first.
• BR-11: External user type selection depends on expiry and admin context.
• BR-12: EFT insert must succeed before child payment preference save.

Sources

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