---
title: "SQL-007: Criteria"
summary: Create statement for Criteria.
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-07-28
library: SAIF.Business.Claim.Payment
reference_type: package
---

# 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](../database-tables.md#cl_financial_trans_type_code) | Create | Not enumerated directly in the stage findings.** |
| [CL_FINANCIAL_TRANS_DTL](../database-tables.md#cl_financial_trans_dtl) | Create | Not enumerated directly in the stage findings.** |
| [CL_RECOVERY_TYPE_CODE](../database-tables.md#cl_recovery_type_code) | Create | Not enumerated directly in the stage findings.** |
| [CL_FINANCIAL_TRANS](../database-tables.md#cl_financial_trans) | Create | Not enumerated directly in the stage findings.** |

## Sample SQL

```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

- [Criteria BeforeInsert](../operations/financial-transaction-and-remark-management.md)

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

## Sources

- `Business/SAIF.Business.Claim.Payment/FinancialTransaction/clsFinancialTrans.vb`