clsClaimWorkStatus

clsClaimWorkStatus owns a return-to-work status history row for a claim, hard-coding the initial work-status code on insert and retrieving only the latest row via a correlated max(seq) subquery.

Purpose

• Provides full create/retrieve/update/delete of work-status rows (SQL-003, SQL-007, SQL-021, SQL-045, SQL-060).
• Enforces that the work-status date is not later than the current date (BR-003).

Context

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

Public members

Member	Signature	Purpose
Criteria.InsertSQL	ReadOnly Property InsertSQL As String	Inserts a new row with WORK_STATUS_CODE hard-coded to '1' (SQL-007).
Criteria.RetrieveSQL	ReadOnly Property RetrieveSQL As String	Retrieves only the latest work-status row via a correlated max(seq) subquery (SQL-021).
Criteria.UpdateSQL	ReadOnly Property UpdateSQL As String	Updates the effective date using a :UpdateNum + 1 increment form that differs from the UPDATE_NUM + 1 form used elsewhere in the library (SQL-045).*
ValidWorkStatusDate	Public Function ValidWorkStatusDate() As Boolean	Enforces BR-003.

Behavioral notes

• DB-contention errors are raised via After* hooks on insert/update/delete (BR-012).

Constraints and usage notes

• Only the most recent work-status row per claim is retrievable through this object; full history requires a separate query.

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/clsClaimWorkStatus.vb