SQL-079: clsWorkerInjuryClaim¶

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

Classification¶

Field	Value
SQL ID	SQL-079
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsWorkerInjuryClaim`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:ClaimID`	Input	Unknown	—	Passed from clsWorkerInjuryClaim via BeforeRetrieve.

Tables¶

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

Sample SQL¶

Select
    CL_INJURY_CLAIM.ACTIVE_CLAIM_FLAG as ActiveClaimFlag,
    CL_INJURY_CLAIM.AGE_DOI_YEARS as AgeDoiYears,
    CL_INJURY_CLAIM.CLAIM_ID as ClaimID,
    CL_INJURY_CLAIM.CLAIM_STATUS_CODE as ClaimStatusCode,
    CL_INJURY_CLAIM.DISABILITY_DATE as DisabilityDate,
    CL_INJURY_CLAIM.EDUCATION_YEARS as EducationYears,
    CL_INJURY_CLAIM.EMPR_RELATIVE_FLAG as EmprRelativeFlag,
    CL_INJURY_CLAIM.EXPOSURE_CODE as ExposureCode,
    CL_INJURY_CLAIM.GED_FLAG_CODE as GedFlagCode,
    CL_INJURY_CLAIM.HEALTH_INSURANCE_GROUP_NUM as HealthInsuranceGroupNum,
    CL_INJURY_CLAIM.HEALTH_INSURANCE_ID as HealthInsuranceID,
    CL_INJURY_CLAIM.HEALTH_INSURANCE_PROV_NAME as HealthInsuranceProvName,
    CL_INJURY_CLAIM.INJ_OCCUPATIONAL_DISEASE_CODE as InjOccupationalDiseaseCode,
    CL_INJURY_CLAIM.INJURY_DATE as InjuryDate,
    CL_INJURY_CLAIM.INMATE_NUM as InmateNum,
    CL_INJURY_CLAIM.INTERESTED_PARTY_FLAG_CODE as InterestedPartyFlagCode,
    CL_INJURY_CLAIM.JURISDICTION_CODE as JurisdictionCode,
    CL_INJURY_CLAIM.TIN_AUTHORIZED_USE_FLAG as TinAuthorizedUseFlag,
    CL_INJURY_CLAIM.UPDATE_DATE as UpdateDate,
    CL_INJURY_CLAIM.UPDATE_NUM as UpdateNum,
    CL_INJURY_CLAIM.UPDATE_USER as UpdateUser,
    CL_INJURY_CLAIM.WORKER_ID as WorkerID,
    CL_INJURY_CLAIM.FULLY_FRAUDULENT_FLAG as FullyFraudulentFlag
From CL_INJURY_CLAIM
WHERE
    CL_INJURY_CLAIM.CLAIM_ID = :ClaimID

Operations and processes¶

clsWorkerInjuryClaim BeforeRetrieve

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