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