Skip to content

SQL-007: Criteria

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

Classification

Field Value
SQL ID SQL-007
Operation type Create
Execution method Stored procedure
Database Oracle
Schema [unqualified]**
Command type StoredProcedure
Business object Criteria
Criteria property InsertSQL
Lifecycle method BeforeInsert

Parameters

Parameter Direction Type Max length Description
:ZipCode Input Unknown — Passed from Criteria via BeforeInsert.
:UpdateUser Input Unknown — Passed from Criteria via BeforeInsert.
:UpdateNum Input Unknown — Passed from Criteria via BeforeInsert.
:UpdateDate Input Unknown — Passed from Criteria via BeforeInsert.
:TotalTransactionAmt Input Unknown — Passed from Criteria via BeforeInsert.
:MedicalIndemnityDisplayCode Input Unknown — Passed from Criteria via BeforeInsert.
:IssueDate Input Unknown — Passed from Criteria via BeforeInsert.
:InitiatorUser Input Unknown — Passed from Criteria via BeforeInsert.
:FinancialTransTypeCode Input Unknown — Passed from Criteria via BeforeInsert.
:FinancialTransStatusCode Input Unknown — Passed from Criteria via BeforeInsert.
:EntryDate Input Unknown — Passed from Criteria via BeforeInsert.
:ClaimID Input Unknown — Passed from Criteria via BeforeInsert.
:ClaimFinancialTransSeqNum Input Unknown — Passed from Criteria via BeforeInsert.
:TransferTransID Input Unknown — Passed from Criteria via BeforeInsert.
:TransactionRemarkTxt Input Unknown — Passed from Criteria via BeforeInsert.
:TailCoverageFlagCode Input Unknown — Passed from Criteria via BeforeInsert.
:SupportOrderID Input Unknown — Passed from Criteria via BeforeInsert.
:SpecialHandlingCode Input Unknown — Passed from Criteria via BeforeInsert.
:SettlementFullPartCode Input Unknown — Passed from Criteria via BeforeInsert.
:ScheduledPaymentFlag Input Unknown — Passed from Criteria via BeforeInsert.
:AwardNum Input Unknown — Passed from Criteria via BeforeInsert.
:RushPaymentID Input Unknown — Passed from Criteria via BeforeInsert.
:ReductionID Input Unknown — Passed from Criteria via BeforeInsert.
:ProviderTypeCode Input Unknown — Passed from Criteria via BeforeInsert.
:ProviderLocationSeqNum Input Unknown — Passed from Criteria via BeforeInsert.
:PreferredWorkerPrgFlgCode Input Unknown — Passed from Criteria via BeforeInsert.
:PolicyNum Input Unknown — Passed from Criteria via BeforeInsert.
:PmsAccountSubcd Input Unknown — Passed from Criteria via BeforeInsert.
:PaymentTransactionTypeCode Input Unknown — Passed from Criteria via BeforeInsert.
:PaymentTextID Input Unknown — Passed from Criteria via BeforeInsert.
:PaymentMethodCode Input Unknown — Passed from Criteria via BeforeInsert.
:PaymentID Input Unknown — Passed from Criteria via BeforeInsert.
:PayeeTin Input Unknown — Passed from Criteria via BeforeInsert.
:PayeeFullName Input Unknown — Passed from Criteria via BeforeInsert.
:OwnMotionProgramFlagCode Input Unknown — Passed from Criteria via BeforeInsert.
:NceProgramFlagCode Input Unknown — Passed from Criteria via BeforeInsert.
:MedicallyStationaryFlagCode Input Unknown — Passed from Criteria via BeforeInsert.
:LegalOrderTypeCode Input Unknown — Passed from Criteria via BeforeInsert.
:JurisdictionCode Input Unknown — Passed from Criteria via BeforeInsert.
:InjuryDate Input Unknown — Passed from Criteria via BeforeInsert.
:HwrProgramFlagCode Input Unknown — Passed from Criteria via BeforeInsert.
:FederalBenefitFlag Input Unknown — Passed from Criteria via BeforeInsert.
:Federal8FFlag Input Unknown — Passed from Criteria via BeforeInsert.
:ExpenseID Input Unknown — Passed from Criteria via BeforeInsert.
:CoverageTypeCode Input Unknown — Passed from Criteria via BeforeInsert.
:ClaimTypeCode Input Unknown — Passed from Criteria via BeforeInsert.
:ClaimStatusCode Input Unknown — Passed from Criteria via BeforeInsert.
:ClaimPersonID Input Unknown — Passed from Criteria via BeforeInsert.
:ClaimPayeeTypeCode Input Unknown — Passed from Criteria via BeforeInsert.
:BillID Input Unknown — Passed from Criteria via BeforeInsert.
:BenefitPaymentSubNum Input Unknown — Passed from Criteria via BeforeInsert.
:AttorneyBalanceID Input Unknown — Passed from Criteria via BeforeInsert.
:ApproverUser Input Unknown — Passed from Criteria via BeforeInsert.
:AddressUpdaterUser Input Unknown — Passed from Criteria via BeforeInsert.
:AddressLine5 Input Unknown — Passed from Criteria via BeforeInsert.
:AddressLine4 Input Unknown — Passed from Criteria via BeforeInsert.
:AddressLine3 Input Unknown — Passed from Criteria via BeforeInsert.
:AddressLine2 Input Unknown — Passed from Criteria via BeforeInsert.
:AddressLine1 Input Unknown — Passed from Criteria via BeforeInsert.
:RushCheckFlag Input Unknown — Passed from Criteria via BeforeInsert.
:CashCardID Input Unknown — Passed from Criteria via BeforeInsert.
:SettlementOrderDate Input Unknown — Passed from Criteria via BeforeInsert.
:DirectDepositAccountID Input Unknown — Passed from Criteria via BeforeInsert.
:RowsAffected Input Unknown — Passed from Criteria via BeforeInsert.

Tables

Table Access Columns used
CL_FINANCIAL_TRANS_TYPE_CODE Create Not enumerated directly in the stage findings.**
CL_FINANCIAL_TRANS_DTL Create Not enumerated directly in the stage findings.**
CL_RECOVERY_TYPE_CODE Create Not enumerated directly in the stage findings.**
CL_FINANCIAL_TRANS Create Not enumerated directly in the stage findings.**

Sample SQL

pk82343_financial_trans.cl_financial_tran_insert(:ZipCode, :UpdateUser, :UpdateNum, :UpdateDate, :TotalTransactionAmt, :MedicalIndemnityDisplayCode, :IssueDate, :InitiatorUser, :FinancialTransTypeCode, :FinancialTransStatusCode, :EntryDate, :ClaimID, :ClaimFinancialTransSeqNum, :TransferTransID, :TransactionRemarkTxt, :TailCoverageFlagCode, :SupportOrderID, :SpecialHandlingCode, :SettlementFullPartCode, :ScheduledPaymentFlag, :AwardNum, :RushPaymentID, :ReductionID, :ProviderTypeCode, :ProviderLocationSeqNum, :PreferredWorkerPrgFlgCode, :PolicyNum, :PmsAccountSubcd, :PaymentTransactionTypeCode, :PaymentTextID, :PaymentMethodCode, :PaymentID, :PayeeTin, :PayeeFullName, :OwnMotionProgramFlagCode, :NceProgramFlagCode, :MedicallyStationaryFlagCode, :LegalOrderTypeCode, :JurisdictionCode, :InjuryDate, :HwrProgramFlagCode, :FederalBenefitFlag, :Federal8FFlag, :ExpenseID, :CoverageTypeCode, :ClaimTypeCode, :ClaimStatusCode, :ClaimPersonID, :ClaimPayeeTypeCode, :BillID, :BenefitPaymentSubNum, :AttorneyBalanceID, :ApproverUser, :AddressUpdaterUser, :AddressLine5, :AddressLine4, :AddressLine3, :AddressLine2, :AddressLine1, :RushCheckFlag, :CashCardID, :SettlementOrderDate, :DirectDepositAccountID, :RowsAffected)

Operations and processes

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

Sources

  • Business/SAIF.Business.Claim.Payment/FinancialTransaction/clsFinancialTrans.vb