Skip to content

SQL-064: clsDisabilityAuthActivityCollection

This statement supports clsDisabilityAuthActivityCollection by executing a Read operation through inline.

Classification

Field Value
SQL ID SQL-064
Operation type Read
Execution method Inline SQL
Database Oracle
Schema [unqualified]**
Command type Text
Business object clsDisabilityAuthActivityCollection
Criteria property RetrieveInjuryDateSQL
Lifecycle method GetInjuryDate

Parameters

Parameter Direction Type Max length Description
:ClaimID Input Unknown — Passed from clsDisabilityAuthActivityCollection via GetInjuryDate.

Tables

Table Access Columns used
CL_INJURY_CLAIM Read Not enumerated directly in the stage findings.**

Sample SQL

Select CL_INJURY_CLAIM.INJURY_DATE AS InjuryDate From CL_INJURY_CLAIM Where CL_INJURY_CLAIM.CLAIM_ID = :ClaimID

Operations and processes

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.

Sources

  • Business/SAIF.Business.Claim.Maintenance/clsDisabilityAuthActivityCollection.vb