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

Sample 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

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

Sources

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