SQL-106: clsAccidentInjury

This statement supports clsAccidentInjury by executing a Delete operation through inline.

Classification

Field	Value
SQL ID	SQL-106
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsAccidentInjury
Criteria property	DeleteTD3DayWaitSQL
Lifecycle method	BeforeUpdate

Parameters

Parameter	Direction	Type	Max length	Description
:CityName	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:CountyCode	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:StateCode	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:ZipCode	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:ZipCodeExt	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:UpdateUser	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:ExposureCode	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:EmploymentInjuryCode	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:InitialTreatmentDate	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:InjuredOnPremisesCode	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:InjuryDate	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:InjurySourceCode	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:InjuryTime	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:InPatientFlagCode	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:FederalInjuryLocationCode	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:HardwareCausedFlagCode	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:HighSeasFlag	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:MultipleWorkerFlagCode	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:PersonCausedFlagCode	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:SaifEventDescr	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:ClaimID	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.
:UpdateNum	Input	Unknown	—	Passed from clsAccidentInjury via BeforeUpdate.

Tables

Table	Access	Columns used
CL_CLAIM_TD_THREE_DAY_WAIT	Delete	Not enumerated directly in the stage findings.**

Sample SQL

Delete From CL_CLAIM_TD_THREE_DAY_WAIT Where CL_CLAIM_TD_THREE_DAY_WAIT.CLAIM_ID = :ClaimID

Operations and processes

• clsAccidentInjury 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/clsAccidentInjury.vb