Select
AGE_DOI_YEARS as AgeDoiYears,
CITY_NAME as CityName,
CLAIM_ID as ClaimID,
CLAIM_RESP_CODE as ClaimRespCode,
CLAIM_STATUS_CODE as ClaimStatusCode,
CLAIM_TYPE_CODE as ClaimTypeCode,
COVERAGE_CODE as CoverageCode,
COUNTY_CODE as CountyCode,
EMPLOYMENT_INJURY_CODE as EmploymentInjuryCode,
EMPR_PROVIDED_SHIFT_CODE as EmprProvidedShiftCode,
EMPR_PROVIDED_WORKER_AREA_TXT as EmprProvidedWorkerAreaTxt,
EMPR_PROV_PAYROLL_CLASS_CODE as EmprProvPayrollClassCode,
EMPR_PROV_PAYROLL_SUB_CODE as EmprProvPayrollSubCode,
EMPR_PROV_WORKER_DEPT_DESCR as EmprProvWorkerDeptDescr,
EXPOSURE_CODE as ExposureCode,
FEDERAL_INJURY_LOCATION_CODE as FederalInjuryLocationCode,
FORM_CODE as FormCode,
HARDWARE_CAUSED_FLAG_CODE as HardwareCausedFlag,
HIGH_SEAS_FLAG as HighSeasFlag,
INITIAL_TREATMENT_DATE as InitialTreatmentDate,
INJURED_ON_PREMISES_CODE as InjuredONPremisesCode,
INJURY_DATE as InjuryDate,
INJURY_SOURCE_CODE as InjurySourceCode,
INJURY_TIME as InjuryTime,
INJ_OCCUPATIONAL_DISEASE_CODE as InjOccupationalDiseaseCode,
INMATE_NUM as InmateNum,
INMATE_SUPERVISOR_KNOW_DATE as InmateSupervisorKnowDate,
INPATIENT_FLAG_CODE as InpatientFlag,
INTERESTED_PARTY_FLAG_CODE as InterestedPartyFlag,
JURISDICTION_CODE as JurisdictionCode,
KNOWLEDGE_DATE as KnowledgeDate,
LEAVE_WORK_DATE as LeaveWorkDate,
LEAVE_WORK_TIME as LeaveWorkTime,
MCO_ELIGIBILITY_REASON_CODE as McoEligibilityReasonCode,
MCO_ELIGIBILITY_STATUS_CODE as McoEligibilityStatusCode,
MCO_ID as McoID,
MULTIPLE_EMPR_FLAG as MultipleEmprFlag,
MULTIPLE_WORKER_FLAG_CODE as MultipleWorkerFlag,
PERSON_CAUSED_FLAG_CODE as PersonCausedFlag,
POLICY_NUM as PolicyNum,
POLICY_SUB_CODE as PolicySubCode,
PREFERRED_WORKER_ID as PreferredWorkerId,
PRIMARY_BODY_PART_CODE as PrimaryBodyPartCode,
PRIMARY_BODY_SIDE_CODE as PrimaryBodySideCode,
PRIMARY_INJURY_NATURE_CODE as PrimaryInjuryNatureCode,
RECEIVED_801_DATE as Received801Date,
RECEIVED_DATE as ReceivedDate,
SAIF_CLAIM_CHK_VALUE as SaifClaimChkValue,
SAIF_CLAIM_NUM as SaifClaimNum,
SAIF_EVENT_DESCR as SaifEventDescr,
SAIF_PROV_PAYROLL_CLASS_CODE as SaifProvPayrollClassCode,
SAIF_PROV_PAYROLL_SUB_CODE as SaifProvPayrollSubCode,
SHIFT_START_TIME as ShiftStartTime,
SHIFT_END_TIME as ShiftEndTime,
STATE_CODE as StateCode,
TIN_AUTHORIZED_USE_FLAG as TinAuthorizedUseFlag,
UPDATE_DATE as UpdateDate,
UPDATE_NUM as UpdateNum,
UPDATE_USER as UpdateUser,
WORKER_DEPARTMENT_DESCR as WorkerDepartmentDescr,
WORKER_HIRE_DATE as WorkerHireDate,
WORKER_ID as WorkerID,
WORKER_OCCUPATION_DESCR as WorkerOccupationDescr,
WORKER_TENURE_DAY as WorkerTenureDay,
WORKER_TENURE_MONTH as WorkerTenureMonth,
WORKER_TENURE_YEAR as WorkerTenureYear,
ZIP_CODE as ZipCode,
ZIP_CODE_EXT as ZipCodeExt,
CLAIM_SCORE as ClaimScore
From CL_INJURY_CLAIM
WHERE
CLAIM_ID = :ClaimID