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	Create	Not enumerated directly in the stage findings.**

Sample 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

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

Sources

• Business/SAIF.Business.Claim.Entry/clsClaimEntry.vb