clsClaimWorkReleaseStatus¶
clsClaimWorkReleaseStatus owns a work-release-status history row for a claim, retrieving only the latest row via a correlated max(seq) subquery and enforcing level-two date validation.
Purpose¶
- Provides full create/retrieve/update/delete of work-release-status rows (SQL-002, SQL-006, SQL-020, SQL-044, SQL-059).
- Enforces that the work-release date is valid at rule-check level two (BR-004) and that work-release status data is present (BR-005).
Context¶
- Namespace:
SAIF.Business.Claim - Assembly/package:
SAIF.Business.Claim.dll
Public members¶
| Member | Signature | Purpose |
|---|---|---|
Criteria.RetrieveSQL |
ReadOnly Property RetrieveSQL As String |
Retrieves only the latest work-release-status row via a correlated max(seq) subquery (SQL-020). |
ValidWorkReleaseDate |
Public Function ValidWorkReleaseDate() As Boolean |
Enforces BR-004 at RuleCheckLevel.LevelTwo. |
HasData |
Public Function HasData() As Boolean |
Enforces BR-005. |
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-release-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/clsClaimWorkReleaseStatus.vb