SQL-032: Criteria¶

This statement supports Criteria by executing a Update operation through storedproc.

Classification¶

Field	Value
SQL ID	SQL-032
Operation type	Update
Execution method	Stored procedure
Database	Oracle
Schema	[unqualified]**
Command type	StoredProcedure
Business object	`Criteria`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:EaipPeriodID`	Input	Number	N/A	Binds EaipPeriodID from active calling code or Oracle signature.
`:CLAIMID`	Input	Number	N/A	Binds CLAIMID from active calling code or Oracle signature.
`:EAIPUSER`	Input	String	N/A	Binds EAIPUSER from active calling code or Oracle signature.
`:CLAIMACTIVITYDATE`	Input	Date	N/A	Binds CLAIMACTIVITYDATE from active calling code or Oracle signature.
`:EaipPeriodEffectiveDate`	Input	Date	N/A	Binds EaipPeriodEffectiveDate from active calling code or Oracle signature.
`:EaipPeriodExpirationDate`	Input	Date	N/A	Binds EaipPeriodExpirationDate from active calling code or Oracle signature.
`:EndReasonCode`	Input	String	N/A	Binds EndReasonCode from active calling code or Oracle signature.
`:EAIPSTATUSCODE`	Input	String	N/A	Binds EAIPSTATUSCODE from active calling code or Oracle signature.
`:EAIPSTATUSDATE`	Input	Date	N/A	Binds EAIPSTATUSDATE from active calling code or Oracle signature.
`:EAIPPERIODNOTETEXT`	Input	String	N/A	Binds EAIPPERIODNOTETEXT from active calling code or Oracle signature.
`:REGULARJOBDUTIESTEXT`	Input	String	N/A	Binds REGULARJOBDUTIESTEXT from active calling code or Oracle signature.
`:ModifiedJobDutiesText`	Input	String	N/A	Binds ModifiedJobDutiesText from active calling code or Oracle signature.
`:AggravationPolicyID`	Input	Number	N/A	Binds AggravationPolicyID from active calling code or Oracle signature.
`:AggravationProviderLocationID`	Input	Number	N/A	Binds AggravationProviderLocationID from active calling code or Oracle signature.
`:AggravationWcdID`	Input	Number	N/A	Binds AggravationWcdID from active calling code or Oracle signature.
`:InterruptsClaimNumber`	Input	Number	N/A	Binds InterruptsClaimNumber from active calling code or Oracle signature.
`:InterruptedClaimNumber`	Input	Number	N/A	Binds InterruptedClaimNumber from active calling code or Oracle signature.
`:InterruptedEffectiveDate`	Input	Date	N/A	Binds InterruptedEffectiveDate from active calling code or Oracle signature.
`:InterruptedExpirationDate`	Input	Date	N/A	Binds InterruptedExpirationDate from active calling code or Oracle signature.
`:EarliestExpenseReceiveDate`	Input	Date	N/A	Binds EarliestExpenseReceiveDate from active calling code or Oracle signature.
`:CREATEUSER`	Input	String	N/A	Binds CREATEUSER from active calling code or Oracle signature.
`:CREATEDATE`	Input	Date	N/A	Binds CREATEDATE from active calling code or Oracle signature.
`:UPDATEUSER`	Input	Date	N/A	Binds UPDATEUSER from active calling code or Oracle signature.
`:UPDATEDATE`	Input	Date	N/A	Binds UPDATEDATE from active calling code or Oracle signature.
`:UPDATENUM`	Input	Date	N/A	Binds UPDATENUM from active calling code or Oracle signature.
`:LastUpdateNum`	Input	Date	N/A	Binds LastUpdateNum from active calling code or Oracle signature.
`:PURCHASEJUSTIFICATION`	Input	String	N/A	Binds PURCHASEJUSTIFICATION from active calling code or Oracle signature.
`:EaipPeriodID`	Input	Number	N/A	Binds EaipPeriodID from active calling code or Oracle signature.
`:LastUpdateNum`	Input	Date	N/A	Binds LastUpdateNum from active calling code or Oracle signature.

Tables¶

Table	Access	Columns used
`EAIP_PERIOD*`	Update*	EaipPeriodID, CLAIMID, EAIPUSER, CLAIMACTIVITYDATE, EaipPeriodEffectiveDate, EaipPeriodExpirationDate, EndReasonCode, EAIPSTATUSCODE, EAIPSTATUSDATE, EAIPPERIODNOTETEXT, REGULARJOBDUTIESTEXT, ModifiedJobDutiesText, AggravationPolicyID, AggravationProviderLocationID, AggravationWcdID, InterruptsClaimNumber, InterruptedClaimNumber, InterruptedEffectiveDate, InterruptedExpirationDate, EarliestExpenseReceiveDate, CREATEUSER, CREATEDATE, UPDATEUSER, UPDATEDATE, UPDATENUM, LastUpdateNum, PURCHASEJUSTIFICATION, EaipPeriodID, LastUpdateNum*

Sample SQL¶

Pk82500_eaip.eaip_period_update(:EaipPeriodID, :CLAIMID, :EAIPUSER, :CLAIMACTIVITYDATE, :EaipPeriodEffectiveDate, :EaipPeriodExpirationDate, :EndReasonCode, :EAIPSTATUSCODE, :EAIPSTATUSDATE, :EAIPPERIODNOTETEXT, :REGULARJOBDUTIESTEXT, :ModifiedJobDutiesText, :AggravationPolicyID, :AggravationProviderLocationID, :AggravationWcdID, :InterruptsClaimNumber, :InterruptedClaimNumber, :InterruptedEffectiveDate, :InterruptedExpirationDate, :EarliestExpenseReceiveDate, :CREATEUSER, :CREATEDATE, :UPDATEUSER, :UPDATEDATE, :UPDATENUM, :LastUpdateNum, :PURCHASEJUSTIFICATION, :EaipPeriodID, :LastUpdateNum)

-- Procedure body resides in Oracle.

Operations and processes¶

Criteria update

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.EAIP\Period\clsPeriod.vb