SQL-001: INSERT PROVIDER_EOB_INTERFACE

INSERT PROVIDER_EOB_INTERFACE.

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
:ProviderSeqNum	Input	Decimal	N/A	Provider key persisted to PROVIDER_EOB_INTERFACE.PROVIDER_SEQ_NUM.
:ProviderLocationSeqNum	Input	Decimal	N/A	Provider-location key persisted to PROVIDER_EOB_INTERFACE.PROVIDER_LOCATION_SEQ_NUM.
:ExtUserTypeSeqNum	Input	clsSmartDecimal	N/A	External user type; empty/zero forces paperless flag logic in BeforeInsert.
:PaperlessEOBFlag	Input	String	5	'Y' when an ext user type exists; otherwise 'N'.
:DefaultPrimaryFlag	Input	String	5	Always initialized to 'N' by the caller.
: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.

Tables

Table	Access	Columns used
PROVIDER_EOB_INTERFACE	CREATE	See sample SQL.

Sample SQL

INSERT INTO PROVIDER_EOB_INTERFACE (
    PROVIDER_SEQ_NUM,
    PROVIDER_LOCATION_SEQ_NUM,
    EXT_USER_TYPE_SEQ_NUM,
    PAPERLESS_EOB_FLAG,
    DEFAULT_TO_PRIMARY_FLAG,
    UPDATE_DATE,
    UPDATE_USER,
    UPDATE_NUM
) VALUES (
    :ProviderSeqNum,
    :ProviderLocationSeqNum,
    :ExtUserTypeSeqNum,
    :PaperlessEOBFlag,
    :DefaultPrimaryFlag,
    :UpdateDate,
    :UpdateUser,
    :UpdateNum
)

Operations and processes

• EOB preference management

Business rules

• BR-01: PaperlessEOBFlag is set to Y only when ExtUserTypeSeqNum is populated.
• BR-02: DefaultPrimaryFlag is initialized to N on new EOB creation.
• BR-03: EOB insert must affect exactly one row.

Sources

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