SQL-003: US_CLAIM_UNIT insert

This SQL statement implements the US_CLAIM_UNIT insert data-access path for clsClaimUnit in SAIF.Business.UnitStat. It participates in the create lifecycle handled by BeforeInsert.

Classification

Field	Value
SQL ID	SQL-003
Operation type	Create
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsClaimUnit
Criteria property	InsertSQL
Lifecycle method	BeforeInsert

Parameters

Parameter	Direction	Type	Max length	Description
:ClaimID	Input	Decimal/SmartDecimal	N/A	Claim identifier bound from the business object or criteria.
:PolicyUnitSeqNum	Input	Decimal/SmartDecimal	N/A	Policy unit primary key / parent foreign key.
:ValueCode	Input	String	1	Claim unit valuation code.
:ActiveUnitFlag	Input	String	1	Active/inactive unit flag.
:UpdateUser	Input	String/SmartString	30	User ID written to audit columns or used as a filter.
:UpdateDate	Input	Date/SmartDate	N/A	Audit timestamp written during insert or update.
:UpdateNumber	Input	Decimal	N/A	Optimistic concurrency/version counter.
:ReportedClosedFlag	Input	String	1	Tracks whether the claim has already been reported closed.
:ReportedFatalFlag	Input	String	1	Tracks whether the claim has already been reported fatal.
:FinalDenialDate	Input	SmartDate	N/A	Final denial date for the claim unit.
:PreferredWorkerFlag	Input	String	1	Preferred worker indicator.

Tables

Table	Access	Columns used
US_CLAIM_UNIT	CREATE	See sample SQL

Sample SQL

Insert into US_CLAIM_UNIT (

    US_POLICY_UNIT_SEQ_NUM,

    CLAIM_ID,

    ACTIVE_UNIT_FLAG,

    VALUE_CODE,

    UPDATE_USER,

    UPDATE_DATE,

    UPDATE_NUM,

    REPORTED_FATAL_FLAG,

    REPORTED_CLOSED_FLAG,

    FINAL_DENIAL_DATE,

    PREFERRED_WORKER_FLAG

) Values (

    :PolicyUnitSeqNum,

    :ClaimID,

    :ActiveUnitFlag,

    :ValueCode,

    :UpdateUser,

    :UpdateDate,

    :UpdateNumber,

    :ReportedFatalFlag,

    :ReportedClosedFlag,

    :FinalDenialDate,

    :PreferredWorkerFlag

)

Operations and processes

• Claim unit maintenance

Business rules

• BR-US-002: Claim unit policy unit sequence number must be greater than zero
• BR-US-003: Claim unit claim ID must be greater than zero
• BR-US-018: ActiveUnitFlag for claim units defaults to Y

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Business\SAIF.Business.UnitStat\clsClaimUnit.vb