SQL-005 Insert a new claim employee work address¶

Inserts a new employee work address record for a claim, including a synthesized county-code default.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`ClaimID`	Input	Decimal	—	Claim identifier (PK component)
`AddressLine1`	Input	String	40	Employee work address line 1
`AddressLine2`	Input	String	40	Employee work address line 2
`City`	Input	String	20	City
`StateCode`	Input	String	2	State code
`ZipCode`	Input	String	5	ZIP code
`ZipCodeExtension`	Input	String	4	ZIP+4 extension
`CountyCode`	Input	String	5	County code (defaults to '0' for synthesized rows)
`UpdateNum`	Input	Decimal	—	Optimistic-concurrency counter, seeded at 0
`UpdateUser`	Input	String	30	Auditing user

Tables¶

Table	Access	Columns used
CL_CLAIM_EMPLOYEE_WORK_ADDRESS	INSERT	CLAIM_ID, ADDRESS_LINE_1_TEXT, ADDRESS_LINE_2_TEXT, CITY_NAME, STATE_CODE, ZIP_CODE, ZIP_CODE_EXTENSION, COUNTY_CODE, UPDATE_NUM, UPDATE_USER_ID, UPDATE_DATE

Sample SQL¶

-- Insert a new claim employee work address
Insert Into CL_CLAIM_EMPLOYEE_WORK_ADDRESS
       (CLAIM_ID,
        ADDRESS_LINE_1_TEXT,
        ADDRESS_LINE_2_TEXT,
        CITY_NAME,
        STATE_CODE,
        ZIP_CODE,
        ZIP_CODE_EXTENSION,
        COUNTY_CODE,
        UPDATE_NUM,
        UPDATE_USER_ID,
        UPDATE_DATE)
Values (:ClaimID,
        :AddressLine1,
        :AddressLine2,
        :City,
        :StateCode,
        :ZipCode,
        :ZipCodeExtension,
        :CountyCode,
        :UpdateNum,
        :UpdateUser,
        SYSDATE)

Business rules¶

BR-012: Optimistic concurrency contention check

Sources¶

SAIF.Business.Claim/clsClaimEmployeeWorkAddress.vb