clsClaimEmployeeWorkAddress

clsClaimEmployeeWorkAddress owns the single work-address record for an injured employee on a claim, synthesizing a clean default record (county code '0', UPDATE_NUM = 0) when no row yet exists.

Purpose

• Provides full create/retrieve/update/delete of the claim employee work-address row (SQL-005, SQL-018, SQL-043, SQL-058).
• Synthesizes a new clean record in AfterRetrieve when no row exists for the claim, rather than surfacing a not-found condition.*

Context

• Namespace: SAIF.Business.Claim
• Assembly/package: SAIF.Business.Claim.dll

Public members

Member	Signature	Purpose
Criteria.InsertSQL	ReadOnly Property InsertSQL As String	Inserts the address row (SQL-005).
Criteria.RetrieveSQL	ReadOnly Property RetrieveSQL As String	Retrieves the address row for a claim (SQL-018).
Criteria.UpdateSQL	ReadOnly Property UpdateSQL As String	Updates all address fields, guarded by optimistic concurrency (SQL-043).
Criteria.DeleteSQL	ReadOnly Property DeleteSQL As String	Deletes the address row, guarded by optimistic concurrency (SQL-058).

Behavioral notes

• DB-contention errors are raised via After* hooks when RowsAffected <> 1 (BR-012).

Constraints and usage notes

• Callers relying on a not-found signal from Retrieve should instead check whether the synthesized default values (e.g., COUNTY_CODE = '0') are present.*

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Related documentation

• Library index
• API reference index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Database tables
• SQL catalog

Sources

• SAIF.Business.Claim/clsClaimEmployeeWorkAddress.vb