---
title: "SQL-010: CriteriaBase"
summary: Create statement for CriteriaBase.
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-07-28
library: SAIF.Business.Claim.Entry
reference_type: package
---

# SQL-010: CriteriaBase

This statement supports `CriteriaBase` by executing a Create operation through inline.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-010 |
| **Operation type** | Create |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | [unqualified]** |
| **Command type** | Text |
| **Business object** | `CriteriaBase` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | `BeforeInsert` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:CityName` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:CountyCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:StateCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:ZipCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:ZipCodeExt` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:ActiveClaimFlag` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:AgeDoiYears` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:ClaimID` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:ClaimStatusCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:ClaimTypeCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:CoverageCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:EmploymentInjuryCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:EmprProvidedShiftCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:EmprProvidedWorkerAreaTxt` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:EmprProvPayrollClassCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:EmprProvPayrollSubCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:EmprProvWorkerDeptDescr` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:ExposureCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:FormCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:FederalInjuryLocationCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:HardwareCausedFlag` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:HighSeasFlag` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:InitialTreatmentDate` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:InmateNum` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:InmateSupervisorKnowDate` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:InjuredONPremisesCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:InjuryDate` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:InjurySourceCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:InjOccupationalDiseaseCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:InpatientFlag` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:InterestedPartyFlag` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:JurisdictionCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:KnowledgeDate` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:LeaveWorkDate` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:LeaveWorkTime` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:McoEligibilityReasonCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:McoEligibilityStatusCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:McoID` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:MultipleWorkerFlag` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:PersonCausedFlag` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:PolicyNum` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:PolicySubCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:PrimaryBodyPartCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:PrimaryBodySideCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:PrimaryInjuryNatureCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:Received801Date` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:ReceivedDate` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:SaifClaimChkValue` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:SaifClaimNum` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:SaifEventDescr` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:SaifProvPayrollClassCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:SaifProvPayrollSubCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:TinAuthorizedUseFlag` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:UpdateUser` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:WorkerDepartmentDescr` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:WorkerHireDate` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:WorkerID` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:WorkerOccupationDescr` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:WorkerTenureDay` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:WorkerTenureMonth` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:WorkerTenureYear` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:ClaimRespCode` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:InjuryTime` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:ShiftStartTime` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:ShiftEndTime` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:PreferredWorkerId` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:ClaimScore` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |
| `:MultipleEmprFlag` | Input | Unknown | — | Passed from CriteriaBase via BeforeInsert. |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [CL_INJURY_CLAIM](../database-tables.md#cl_injury_claim) | Create | Not enumerated directly in the stage findings.** |

## Sample SQL

```sql
Insert into CL_INJURY_CLAIM (
    ACTIVE_CLAIM_FLAG,
    AGE_DOI_YEARS,
    AWARD_AUTO_RECALCULATION_FL_CD,
    CDA_FLAG,
    CITY_NAME,
    CLAIM_ID,
    CLAIM_RESP_CODE,
    CLAIM_STATUS_CODE,
    CLAIM_TYPE_CODE,
    COUNTY_CODE,
    COVERAGE_CODE,
    DISABILITY_DATE,
    EDUCATION_YEARS,
    EMPLOYMENT_INJURY_CODE,
    EMPR_PROVIDED_SHIFT_CODE,
    EMPR_PROVIDED_WORKER_AREA_TXT,
    EMPR_PROV_PAYROLL_CLASS_CODE,
    EMPR_PROV_PAYROLL_SUB_CODE,
    EMPR_PROV_WORKER_DEPT_DESCR,
    EMPR_RELATIVE_FLAG,
    EXPOSURE_CODE,
    FEDERAL_INJURY_LOCATION_CODE,
    FORM_CODE,
    GED_FLAG_CODE,
    HANDICAP_WORKER_RESERVE_FLAG,
    HARDWARE_CAUSED_FLAG_CODE,
    HEALTH_INSURANCE_GROUP_NUM,
    HEALTH_INSURANCE_ID,
    HEALTH_INSURANCE_PROV_NAME,
    HIGH_SEAS_FLAG,
    INITIAL_TREATMENT_DATE,
    INJURED_ON_PREMISES_CODE,
    INJURY_DATE,
    INJURY_EVENT_CODE,
    INJURY_SOURCE_CODE,
    INJURY_TIME,
    INJ_OCCUPATIONAL_DISEASE_CODE,
    INMATE_NUM,
    INMATE_SUPERVISOR_KNOW_DATE,
    INPATIENT_FLAG_CODE,
    INTERESTED_PARTY_FLAG_CODE,
    JURISDICTION_CODE,
    KNOWLEDGE_DATE,
    LAST_RESERVE_REVIEW_DATE,
    LAST_RESERVE_REVIEW_USER,
    LAST_VOC_RESERVE_REVIEW_DATE,
    LAST_VOC_RESERVE_REVIEW_USER,
    LEAVE_WORK_DATE,
    LEAVE_WORK_TIME,
    COMPENSABILITY_RESP_CODE,
    MCO_ELIGIBILITY_REASON_CODE,
    MCO_ELIGIBILITY_STATUS_CODE,
    MCO_ID,
    MULTIPLE_EMPR_FLAG,
    MULTIPLE_EMPR_WAGE_AMT,
    MULTIPLE_WORKER_FLAG_CODE,
    NCE_DATA_FLAG,
    OWCP_CLAIM_NUM,
    OWCP_SERVICE_OFFICE_CODE,
    PERSON_CAUSED_FLAG_CODE,
    POLICY_NUM,
    POLICY_SUB_CODE,
    PREFERRED_WORKER_ID,
    PRIMARY_BODY_PART_CODE,
    PRIMARY_BODY_SIDE_CODE,
    PRIMARY_INJURY_NATURE_CODE,
    RECEIVED_801_DATE,
    RECEIVED_DATE,
    REQUEST_TYPE_CODE,
    SAIF_CLAIM_CHK_VALUE,
    SAIF_CLAIM_NUM,
    SAIF_EVENT_DESCR,
    SAIF_PROV_PAYROLL_CLASS_CODE,
    SAIF_PROV_PAYROLL_SUB_CODE,
    SHIFT_END_TIME,
    SHIFT_START_TIME,
    STATE_CODE,
    TIN_AUTHORIZED_USE_FLAG,
    UPDATE_DATE,
    UPDATE_NUM,
    UPDATE_USER,
    VOCATIONAL_RESP_CODE,
    WCD_CLAIM_NUM,
    WORKER_DEPARTMENT_DESCR,
    WORKER_HIRE_DATE,
    WORKER_ID,
    WORKER_OCCUPATION_DESCR,
    WORKER_TENURE_DAY,
    WORKER_TENURE_MONTH,
    WORKER_TENURE_YEAR,
    ZIP_CODE,
    ZIP_CODE_EXT,
    CLAIM_SCORE
) VALUES (
    :ActiveClaimFlag,
    :AgeDoiYears,
    NULL,
    'N',
    :CityName,
    :ClaimID,
    :ClaimRespCode,
    :ClaimStatusCode,
    :ClaimTypeCode,
    :CountyCode,
    :CoverageCode,
    NULL,
    0,
    :EmploymentInjuryCode,
    :EmprProvidedShiftCode,
    :EmprProvidedWorkerAreaTxt,
    :EmprProvPayrollClassCode,
    :EmprProvPayrollSubCode,
    :EmprProvWorkerDeptDescr,
    'N',
    :ExposureCode,
    :FederalInjuryLocationCode,
    :FormCode,
    NULL,
    'N',
    :HardwareCausedFlag,
    NULL,
    NULL,
    NULL,
    :HighSeasFlag,
    TRUNC(:InitialTreatmentDate),
    :InjuredONPremisesCode,
    TRUNC(:InjuryDate),
    '0',
    :InjurySourceCode,
    :InjuryTime,
    :InjOccupationalDiseaseCode,
    :InmateNum,
    TRUNC(:InmateSupervisorKnowDate),
    :InpatientFlag,
    :InterestedPartyFlag,
    :JurisdictionCode,
    TRUNC(:KnowledgeDate),
    NULL,
    ' ',
    NULL,
    ' ',
    TRUNC(:LeaveWorkDate),
    :LeaveWorkTime,
    NULL,
    :McoEligibilityReasonCode,
    :McoEligibilityStatusCode,
    :McoID,
    :MultipleEmprFlag,
    NULL,
    :MultipleWorkerFlag,
    'N',
    ' ',
    '0',
    :PersonCausedFlag,
    :PolicyNum,
    :PolicySubCode,
    :PreferredWorkerId,
    :PrimaryBodyPartCode,
    :PrimaryBodySideCode,
    :PrimaryInjuryNatureCode,
    TRUNC(:Received801Date),
    TRUNC(:ReceivedDate),
    'I',
    :SaifClaimChkValue,
    :SaifClaimNum,
    :SaifEventDescr,
    :SaifProvPayrollClassCode,
    :SaifProvPayrollSubCode,
    :ShiftEndTime,
    :ShiftStartTime,
    :StateCode,
    :TinAuthorizedUseFlag,
    SYSDATE,
    0,
    :UpdateUser,
    NULL,
    ' ',
    :WorkerDepartmentDescr,
    TRUNC(:WorkerHireDate),
    :WorkerID,
    :WorkerOccupationDescr,
    :WorkerTenureDay,
    :WorkerTenureMonth,
    :WorkerTenureYear,
    :ZipCode,
    :ZipCodeExt,
    :ClaimScore
)
```

## Operations and processes

- [CriteriaBase BeforeInsert](../operations/insert-claim.md)

> **Note:** Statements marked with `**` could not be confirmed; treat them as unknown until verified.

## Sources

- `Business/SAIF.Business.Claim.Entry/clsClaimEntry.vb`