SQL-093: CriteriaBase

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

Classification

Field	Value
SQL ID	SQL-093
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
:BenefitPaymentID	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:LastUpdateNumber	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:InitiatorUser	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:ApproverUser	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:BenefitStatusCode	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:IssueDate	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:RevolvingFundFlag	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:ChargeableCostFlag	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:AdditionTOCompFlag	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:RushCheckFlag	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:DcsFullPartCode	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:FederalTypeCode	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:LegalOrderTypeCode	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:OrderApprovedDate	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:MonthlyStatAmount	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:MonthlyRetroReserveAmount	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:MonthlyBenefitAmount	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:LastCalcDate	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:NextFromDate	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:NextThruDate	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:NextIssueDate	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:PenaltyFlag	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:SettlementTotalAmount	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.
:StructuredSettlementFlag	Input	Unknown	—	Passed from CriteriaBase via BeforeUpdate.

Tables

Table	Access	Columns used
CL_BENEFIT_PAYMENT	Update	Not enumerated directly in the stage findings.**

Sample SQL

Update CL_BENEFIT_PAYMENT
SET
    ISSUE_DATE = :IssueDate,
    INITIATOR_USER = :InitiatorUser,
    APPROVER_USER = :ApproverUser,
    REVOLVING_FUND_FLAG = :RevolvingFundFlag,
    SETTLEMENT_TOTAL_AMT = :SettlementTotalAmount,
    BENEFIT_STATUS_CODE = :BenefitStatusCode,
    UPDATE_NUM = UPDATE_NUM + 1,
    UPDATE_DATE = SYSDATE,
    UPDATE_USER = :UpdateUser,
    DCS_FULL_PART_CODE = :DcsFullPartCode,
    FEDERAL_TYPE_CODE = :FederalTypeCode,
    LEGAL_ORDER_TYPE_CODE = :LegalOrderTypeCode,
    ORDER_APPROVED_DATE = :OrderApprovedDate,
    STRUCTURED_SETTLEMENT_FLAG = :StructuredSettlementFlag,
    CHARGEABLE_COST_FLAG = :ChargeableCostFlag,
    PENALTY_FLAG = :PenaltyFlag,
    ADDITION_TO_COMP_FLAG = :AdditionTOCompFlag,
    RUSH_CHECK_FLAG = :RushCheckFlag,
    MONTHLY_STAT_AMT = :MonthlyStatAmount,
    MONTHLY_RETRO_RESERVE_AMT = :MonthlyRetroReserveAmount,
    MONTHLY_BENEFIT_AMT = :MonthlyBenefitAmount,
    LAST_CALC_DATE = :LastCalcDate,
    NEXT_FROM_DATE = :NextFromDate,
    NEXT_THRU_DATE = :NextThruDate,
    NEXT_ISSUE_DATE = :NextIssueDate
WHERE
    CL_BENEFIT_PAYMENT.BENEFIT_PAYMENT_SEQ_NUM = :BenefitPaymentID AND
    CL_BENEFIT_PAYMENT.UPDATE_NUM = :LastUpdateNumber

Operations and processes

• CriteriaBase BeforeUpdate

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

Sources

• Business/SAIF.Business.Claim.Payment/Payments/clsPaymentBase.vb