SQL-002: PK83548_PROVIDER_CORR_HIST.EFT_CORR_HIST¶

PK83548_PROVIDER_CORR_HIST.EFT_CORR_HIST.

Classification¶

Field	Value
SQL ID	SQL-002
Operation type	Create
Execution method	Stored procedure
Database	Oracle
Schema	`WCIS_DBA`
Command type	StoredProcedure
Business object	`clsProviderEFT`
Criteria property	`N/A — direct proc call`
Lifecycle method	`CreateHistory`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:in_PROVIDER_LOCATION_SEQ_NUM`	Input	PROVIDER_EFT_INTERFACE.PROVIDER_LOCATION_SEQ_NUM%TYPE	N/A	Provider location copied into history row.
`:in_PROVIDER_SEQ_NUM`	Input	PROVIDER_EFT_INTERFACE.PROVIDER_SEQ_NUM%TYPE	N/A	Provider identifier used for both history insert and TIN-address lookup.
`:in_EXT_USER_TYPE_SEQ_NUM`	Input	PROVIDER_EFT_INTERFACE.EXT_USER_TYPE_SEQ_NUM%TYPE	N/A	External user type copied into history row.
`:in_CORRESPONDENCE_DATE`	Input	PROVIDER_EFT_INTERFACE.UPDATE_DATE%TYPE	N/A	History correspondence date supplied by clsProviderEFT.UpdateDate.
`:in_EFF_DATE`	Input	PROVIDER_EFT_INTERFACE.EFF_DATE%TYPE	N/A	EFT effective date passed to FETCH_TIN_ADDRESS and inserted into history.
`:in_EXP_DATE`	Input	PROVIDER_EFT_INTERFACE.EXP_DATE%TYPE	N/A	EFT expiration date; caller forces DB null with ModifyParmValue when empty.
`:in_UPDATE_USER`	Input	PROVIDER_EFT_INTERFACE.UPDATE_USER%TYPE	N/A	User stored in PROVIDER_CORR_HIST.CREATE_USER.

Tables¶

Table	Access	Columns used
PROVIDER_CORR_HIST	CREATE	See sample SQL.
PROVIDER_TAX_ID	CREATE	See sample SQL.
PROVIDER	CREATE	See sample SQL.
PROVIDER_EFT_INTERFACE	TYPE reference	See sample SQL.

Sample SQL¶

BEGIN
    PK83548_PROVIDER_CORR_HIST.EFT_CORR_HIST(
        in_PROVIDER_LOCATION_SEQ_NUM => :in_PROVIDER_LOCATION_SEQ_NUM,
        in_PROVIDER_SEQ_NUM => :in_PROVIDER_SEQ_NUM,
        in_EXT_USER_TYPE_SEQ_NUM => :in_EXT_USER_TYPE_SEQ_NUM,
        in_CORRESPONDENCE_DATE => :in_CORRESPONDENCE_DATE,
        in_EFF_DATE => :in_EFF_DATE,
        in_EXP_DATE => :in_EXP_DATE,
        in_UPDATE_USER => :in_UPDATE_USER
    );
END;

Operations and processes¶

EFT correspondence history

Sources¶

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