Skip to content

SQL-026: clsAccidentInjury

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

Classification

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

Parameters

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

Tables

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

Sample SQL

Select
    CLM.CLAIM_ID as ClaimID,
    CLM.CLAIM_STATUS_CODE as ClaimStatusCode,
    CLM.CLAIM_TYPE_CODE as ClaimTypeCode,
    CLM.COUNTY_CODE as CountyCode,
    CLM.CITY_NAME as CityName,
    CLM.DISABILITY_DATE as DisabilityDate,
    CLM.EMPLOYMENT_INJURY_CODE as EmployementInjuryCode,
    CLM.EXPOSURE_CODE as ExposureCode,
    CLM.FEDERAL_INJURY_LOCATION_CODE as FederalInjuryLocationCode,
    CLM.HARDWARE_CAUSED_FLAG_CODE as HardwareCausedFlagCode,
    CLM.HIGH_SEAS_FLAG as HighSeasFlag,
    CLM.INITIAL_TREATMENT_DATE as InitialTreatmentDate,
    CLM.INJURED_ON_PREMISES_CODE as InjuredOnPremisesCode,
    CLM.INJURY_DATE as InjuryDate,
    CLM.INJURY_SOURCE_CODE as InjurySourceCode,
    CLM.INJURY_TIME as InjuryTime,
    CLM.INPATIENT_FLAG_CODE as InpatientFlagCode,
    CLM.INJ_OCCUPATIONAL_DISEASE_CODE as InjOccupationalDiseaseCode,
    CLM.JURISDICTION_CODE as JurisdictionCode,
    CLM.KNOWLEDGE_DATE as KnowledgeDate,
    CLM.LEAVE_WORK_DATE as LeaveWorkDate,
    CLM.MULTIPLE_WORKER_FLAG_CODE as MultipleWorkerFlagCode,
    CLM.PERSON_CAUSED_FLAG_CODE as PersonCausedFlagCode,
    CLM.POLICY_NUM as PolicyNum,
    CLM.RECEIVED_801_DATE as Received801Date,
    CLM.SAIF_CLAIM_NUM as SaifClaimNum,
    CLM.SAIF_CLAIM_CHK_VALUE as SaifClaimChkValue,
    CLM.SAIF_EVENT_DESCR as SaifEventDescr,
    CLM.RECEIVED_DATE as ReceivedDate,
    CLM.SAIF_EVENT_DESCR as SaifEventDescr,
    STATE_CODE as StateCode,
    CLM.WORKER_ID as WorkerID,
    CLM.UPDATE_DATE as UpdateDate,
    CLM.UPDATE_NUM as UpdateNum,
    CLM.UPDATE_USER as UpdateUser,
    ZIP_CODE as ZipCode,
    ZIP_CODE_EXT as ZipCodeExt,
    WKR.BIRTH_DATE as BirthDate,
    WKR.DEATH_DATE as DeathDate
From CL_INJURY_CLAIM CLM, CL_CLAIM_PERSON WKR
WHERE
    CLM.CLAIM_ID = :ClaimID AND
    CLM.WORKER_ID = WKR.PERSON_ID

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