SQL-104: clsWorkerInjuryClaim¶

This statement supports clsWorkerInjuryClaim by executing a Update operation through inline.

Classification¶

Field	Value
SQL ID	SQL-104
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsWorkerInjuryClaim`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:AgeDoiYears`	Input	Unknown	—	Passed from clsWorkerInjuryClaim via BeforeUpdate.
`:EducationYears`	Input	Unknown	—	Passed from clsWorkerInjuryClaim via BeforeUpdate.
`:EmprRelativeFlag`	Input	Unknown	—	Passed from clsWorkerInjuryClaim via BeforeUpdate.
`:GedFlagCode`	Input	Unknown	—	Passed from clsWorkerInjuryClaim via BeforeUpdate.
`:InterestedPartyFlagCode`	Input	Unknown	—	Passed from clsWorkerInjuryClaim via BeforeUpdate.
`:TinAuthorizedUseFlag`	Input	Unknown	—	Passed from clsWorkerInjuryClaim via BeforeUpdate.
`:FullyFraudulentFlag`	Input	Unknown	—	Passed from clsWorkerInjuryClaim via BeforeUpdate.
`:HealthInsuranceGroupNum`	Input	Unknown	—	Passed from clsWorkerInjuryClaim via BeforeUpdate.
`:HealthInsuranceID`	Input	Unknown	—	Passed from clsWorkerInjuryClaim via BeforeUpdate.
`:HealthInsuranceProvName`	Input	Unknown	—	Passed from clsWorkerInjuryClaim via BeforeUpdate.
`:InmateNum`	Input	Unknown	—	Passed from clsWorkerInjuryClaim via BeforeUpdate.
`:UpdateUser`	Input	Unknown	—	Passed from clsWorkerInjuryClaim via BeforeUpdate.
`:ClaimID`	Input	Unknown	—	Passed from clsWorkerInjuryClaim via BeforeUpdate.
`:UpdateNum`	Input	Unknown	—	Passed from clsWorkerInjuryClaim 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
    AGE_DOI_YEARS = :AgeDoiYears,
    EDUCATION_YEARS = :EducationYears,
    EMPR_RELATIVE_FLAG = :EmprRelativeFlag,
    GED_FLAG_CODE = :GedFlagCode,
    HEALTH_INSURANCE_GROUP_NUM = :HealthInsuranceGroupNum,
    HEALTH_INSURANCE_ID = :HealthInsuranceID,
    HEALTH_INSURANCE_PROV_NAME = :HealthInsuranceProvName,
    INMATE_NUM = :InmateNum,
    INTERESTED_PARTY_FLAG_CODE = :InterestedPartyFlagCode,
    TIN_AUTHORIZED_USE_FLAG = :TinAuthorizedUseFlag,
    FULLY_FRAUDULENT_FLAG = :FullyFraudulentFlag,
    UPDATE_DATE = SYSDATE,
    UPDATE_NUM = UPDATE_NUM + 1,
    UPDATE_USER = :UpdateUser
WHERE
    CLAIM_ID = :ClaimID AND
    UPDATE_NUM = :UpdateNum

Operations and processes¶

clsWorkerInjuryClaim BeforeUpdate

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Business/SAIF.Business.Claim.Maintenance/clsWorkerInjuryClaim.vb