--- title: "SQL-022: CriteriaBase" summary: Update statement for CriteriaBase. status: draft owner: SAIF Doc Gen last_reviewed: 2026-07-28 library: SAIF.Business.Claim.Entry reference_type: package --- # SQL-022: CriteriaBase This statement supports `CriteriaBase` by executing a Update operation through inline. ## Classification | Field | Value | | --- | --- | | **SQL ID** | SQL-022 | | **Operation type** | Update | | **Execution method** | Inline SQL | | **Database** | Oracle | | **Schema** | [unqualified]** | | **Command type** | Text | | **Business object** | `CriteriaBase` | | **Criteria property** | `UpdateSQL` | | **Lifecycle method** | `BeforeUpdate` | ## Parameters | Parameter | Direction | Type | Max length | Description | | --- | --- | --- | --- | --- | | `:CityName` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:CountyCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:StateCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:ZipCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:ZipCodeExt` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:ActiveClaimFlag` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:AgeDoiYears` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:ClaimStatusCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:ClaimTypeCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:CoverageCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:EmploymentInjuryCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:EmprProvidedShiftCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:EmprProvidedWorkerAreaTxt` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:EmprProvPayrollClassCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:EmprProvPayrollSubCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:EmprProvWorkerDeptDescr` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:ExposureCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:FederalInjuryLocationCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:FormCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:HardwareCausedFlag` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:HighSeasFlag` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:InitialTreatmentDate` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:InjuredONPremisesCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:InjuryDate` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:InjurySourceCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:InjOccupationalDiseaseCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:InmateNum` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:InmateSupervisorKnowDate` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:InpatientFlag` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:InterestedPartyFlag` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:JurisdictionCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:KnowledgeDate` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:LeaveWorkDate` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:LeaveWorkTime` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:McoEligibilityReasonCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:McoEligibilityStatusCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:McoID` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:MultipleWorkerFlag` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:PersonCausedFlag` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:PolicyNum` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:PolicySubCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:PrimaryBodyPartCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:PrimaryBodySideCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:PrimaryInjuryNatureCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:Received801Date` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:ReceivedDate` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:SaifClaimChkValue` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:SaifClaimNum` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:SaifEventDescr` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:SaifProvPayrollClassCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:SaifProvPayrollSubCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:TinAuthorizedUseFlag` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:UpdateUser` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:WorkerID` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:WorkerDepartmentDescr` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:WorkerHireDate` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:WorkerOccupationDescr` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:WorkerTenureDay` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:WorkerTenureMonth` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:WorkerTenureYear` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:ClaimRespCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:InjuryTime` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:PreferredWorkerId` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:ShiftStartTime` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:ShiftEndTime` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:ClaimScore` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:MultipleEmprFlag` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:ClaimID` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | | `:UpdateNum` | Input | Unknown | — | Passed from CriteriaBase via BeforeUpdate. | ## Tables | Table | Access | Columns used | | --- | --- | --- | | [CL_INJURY_CLAIM](../database-tables.md#cl_injury_claim) | Update | Not enumerated directly in the stage findings.** | ## Sample SQL ```sql Update CL_INJURY_CLAIM SET ACTIVE_CLAIM_FLAG = :ActiveClaimFlag, AGE_DOI_YEARS = :AgeDoiYears, CITY_NAME = :CityName, CLAIM_STATUS_CODE = :ClaimStatusCode, CLAIM_TYPE_CODE = :ClaimTypeCode, CLAIM_RESP_CODE = :ClaimRespCode, COUNTY_CODE = :CountyCode, COVERAGE_CODE = :CoverageCode, EMPLOYMENT_INJURY_CODE = :EmploymentInjuryCode, EMPR_PROVIDED_SHIFT_CODE = :EmprProvidedShiftCode, EMPR_PROVIDED_WORKER_AREA_TXT = :EmprProvidedWorkerAreaTxt, EMPR_PROV_PAYROLL_CLASS_CODE = :EmprProvPayrollClassCode, EMPR_PROV_PAYROLL_SUB_CODE = :EmprProvPayrollSubCode, EMPR_PROV_WORKER_DEPT_DESCR = :EmprProvWorkerDeptDescr, EXPOSURE_CODE = :ExposureCode, FEDERAL_INJURY_LOCATION_CODE = :FederalInjuryLocationCode, FORM_CODE = :FormCode, HARDWARE_CAUSED_FLAG_CODE = :HardwareCausedFlag, HIGH_SEAS_FLAG = :HighSeasFlag, INITIAL_TREATMENT_DATE = TRUNC(:InitialTreatmentDate), INMATE_NUM = :InmateNum, INMATE_SUPERVISOR_KNOW_DATE = TRUNC(:InmateSupervisorKnowDate), INJURED_ON_PREMISES_CODE = :InjuredONPremisesCode, INJURY_DATE = TRUNC(:InjuryDate), INJURY_SOURCE_CODE = :InjurySourceCode, INJURY_TIME = :InjuryTime, INJ_OCCUPATIONAL_DISEASE_CODE = :InjOccupationalDiseaseCode, INPATIENT_FLAG_CODE = :InpatientFlag, INTERESTED_PARTY_FLAG_CODE = :InterestedPartyFlag, JURISDICTION_CODE = :JurisdictionCode, KNOWLEDGE_DATE = TRUNC(:KnowledgeDate), LEAVE_WORK_DATE = TRUNC(:LeaveWorkDate), LEAVE_WORK_TIME = :LeaveWorkTime, MCO_ELIGIBILITY_REASON_CODE = :McoEligibilityReasonCode, MCO_ELIGIBILITY_STATUS_CODE = :McoEligibilityStatusCode, MCO_ID = :McoID, MULTIPLE_EMPR_FLAG = :MultipleEmprFlag, MULTIPLE_WORKER_FLAG_CODE = :MultipleWorkerFlag, PERSON_CAUSED_FLAG_CODE = :PersonCausedFlag, POLICY_NUM = :PolicyNum, POLICY_SUB_CODE = :PolicySubCode, PREFERRED_WORKER_ID = :PreferredWorkerId, PRIMARY_BODY_PART_CODE = :PrimaryBodyPartCode, PRIMARY_BODY_SIDE_CODE = :PrimaryBodySideCode, PRIMARY_INJURY_NATURE_CODE = :PrimaryInjuryNatureCode, RECEIVED_801_DATE = TRUNC(:Received801Date), RECEIVED_DATE = TRUNC(:ReceivedDate), SAIF_CLAIM_CHK_VALUE = :SaifClaimChkValue, SAIF_CLAIM_NUM = :SaifClaimNum, SAIF_EVENT_DESCR = :SaifEventDescr, SAIF_PROV_PAYROLL_CLASS_CODE = :SaifProvPayrollClassCode, SAIF_PROV_PAYROLL_SUB_CODE = :SaifProvPayrollSubCode, SHIFT_START_TIME = :ShiftStartTime, SHIFT_END_TIME = :ShiftEndTime, STATE_CODE = :StateCode, TIN_AUTHORIZED_USE_FLAG = :TinAuthorizedUseFlag, UPDATE_DATE = SYSDATE, UPDATE_NUM = UPDATE_NUM + 1, UPDATE_USER = :UpdateUser, WORKER_DEPARTMENT_DESCR = :WorkerDepartmentDescr, WORKER_ID = :WorkerId, WORKER_HIRE_DATE = TRUNC(:WorkerHireDate), WORKER_OCCUPATION_DESCR = :WorkerOccupationDescr, WORKER_TENURE_DAY = :WorkerTenureDay, WORKER_TENURE_MONTH = :WorkerTenureMonth, WORKER_TENURE_YEAR = :WorkerTenureYear, ZIP_CODE = :ZipCode, ZIP_CODE_EXT = :ZipCodeExt, CLAIM_SCORE = :ClaimScore WHERE CL_INJURY_CLAIM.CLAIM_ID = :ClaimID AND CL_INJURY_CLAIM.UPDATE_NUM = :UpdateNum ``` ## Operations and processes - [CriteriaBase BeforeUpdate](../operations/update-claim.md) > **Note:** Statements marked with `**` could not be confirmed; treat them as unknown until verified. ## Sources - `Business/SAIF.Business.Claim.Entry/clsClaimEntry.vb`