SQL-010: CriteriaBase

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

Classification

Field	Value
SQL ID	SQL-010
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	CriteriaBase
Criteria property	InsertSQL
Lifecycle method	BeforeInsert

Parameters

Parameter	Direction	Type	Max length	Description
:BenefitPaymentID	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:BenefitTypeCode	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:ClaimID	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:InitiatorUser	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:ApproverUser	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:BenefitStatusCode	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:IssueDate	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:RevolvingFundFlag	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:ChargeableCostFlag	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:AdditionTOCompFlag	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:RushCheckFlag	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:AwardNumber	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:DcsFullPartCode	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:FederalTypeCode	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:LegalOrderTypeCode	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:OrderApprovedDate	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:MonthlyStatAmount	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:MonthlyRetroReserveAmount	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:MonthlyBenefitAmount	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:LastCalcDate	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:NextFromDate	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:NextThruDate	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:NextIssueDate	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:PenaltyFlag	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:SettlementTotalAmount	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.
:StructuredSettlementFlag	Input	Unknown	—	Passed from CriteriaBase via BeforeInsert.

Tables

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

Sample SQL

Insert into CL_BENEFIT_PAYMENT (
    BENEFIT_PAYMENT_SEQ_NUM,
    CLAIM_ID,
    SAIF_AWARD_NUM,
    ISSUE_DATE,
    INITIATOR_USER,
    APPROVER_USER,
    REVOLVING_FUND_FLAG,
    SETTLEMENT_TOTAL_AMT,
    BENEFIT_STATUS_CODE,
    BENEFIT_TYPE_CODE,
    UPDATE_NUM,
    UPDATE_DATE,
    UPDATE_USER,
    DCS_FULL_PART_CODE,
    FEDERAL_TYPE_CODE,
    LEGAL_ORDER_TYPE_CODE,
    ORDER_APPROVED_DATE,
    STRUCTURED_SETTLEMENT_FLAG,
    CHARGEABLE_COST_FLAG,
    PENALTY_FLAG,
    ADDITION_TO_COMP_FLAG,
    RUSH_CHECK_FLAG,
    MONTHLY_STAT_AMT,
    MONTHLY_RETRO_RESERVE_AMT,
    MONTHLY_BENEFIT_AMT,
    LAST_CALC_DATE,
    NEXT_FROM_DATE,
    NEXT_THRU_DATE,
    NEXT_ISSUE_DATE
) VALUES (
    :BenefitPaymentID,
    :ClaimID,
    :AwardNumber,
    :IssueDate,
    :InitiatorUser,
    :ApproverUser,
    :RevolvingFundFlag,
    :SettlementTotalAmount,
    :BenefitStatusCode,
    :BenefitTypeCode,
    :UpdateNumber,
    :UpdateDate,
    :UpdateUser,
    :DcsFullPartCode,
    :FederalTypeCode,
    :LegalOrderTypeCode,
    :OrderApprovedDate,
    :StructuredSettlementFlag,
    :ChargeableCostFlag,
    :PenaltyFlag,
    :AdditionTOCompFlag,
    :RushCheckFlag,
    :MonthlyStatAmount,
    :MonthlyRetroReserveAmount,
    :MonthlyBenefitAmount,
    :LastCalcDate,
    :NextFromDate,
    :NextThruDate,
    :NextIssueDate
)

Operations and processes

• CriteriaBase BeforeInsert

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

Sources

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