---
title: "SQL-002: Create operation"
summary: SQL-002 documentation for SAIF.Business.Claim.Bill.
status: draft
owner: Technical Writer
last_reviewed: 2026-07-28
library: SAIF.Business.Claim.Bill
reference_type: package
---

# SQL-002: Create operation

This document records the SQL used by `Criteria` in `SAIF.Business.Claim.Bill`.

## Classification

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

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:BillPaymentSeqNum` | Input | Number | N/A | Binds BillPaymentSeqNum from active calling code or Oracle signature. |
| `:BillID` | Input | Number | N/A | Binds BillID from active calling code or Oracle signature. |
| `:ClaimID` | Input | Number | N/A | Binds ClaimID from active calling code or Oracle signature. |
| `:ProviderLocSeqNum` | Input | Number | N/A | Binds ProviderLocSeqNum from active calling code or Oracle signature. |
| `:TaxIDDisplayDescr` | Input | Number | N/A | Binds TaxIDDisplayDescr from active calling code or Oracle signature. |
| `:ProviderTypeCode` | Input | Number | N/A | Binds ProviderTypeCode from active calling code or Oracle signature. |
| `:WorkerID` | Input | Number | N/A | Binds WorkerID from active calling code or Oracle signature. |
| `:PayeeTypeCode` | Input | String | N/A | Binds PayeeTypeCode from active calling code or Oracle signature. |
| `:TransactionAmt` | Input | Number | N/A | Binds TransactionAmt from active calling code or Oracle signature. |
| `:WorkerPayReasonCode` | Input | String | N/A | Binds WorkerPayReasonCode from active calling code or Oracle signature. |
| `:SpecialHandlingCode` | Input | String | N/A | Binds SpecialHandlingCode from active calling code or Oracle signature. |
| `:IssueDate` | Input | Date | N/A | Binds IssueDate from active calling code or Oracle signature. |
| `:TransactionFromDate` | Input | Date | N/A | Binds TransactionFromDate from active calling code or Oracle signature. |
| `:TransactionThruDate` | Input | Date | N/A | Binds TransactionThruDate from active calling code or Oracle signature. |
| `:ChargeableCostFlag` | Input | String | N/A | Binds ChargeableCostFlag from active calling code or Oracle signature. |
| `:McoFeeFlag` | Input | String | N/A | Binds McoFeeFlag from active calling code or Oracle signature. |
| `:BillPaymentCategoryCode` | Input | String | N/A | Binds BillPaymentCategoryCode from active calling code or Oracle signature. |
| `:FederalDataFlag` | Input | String | N/A | Binds FederalDataFlag from active calling code or Oracle signature. |
| `:ApproverUser` | Input | String | N/A | Binds ApproverUser from active calling code or Oracle signature. |
| `:InitiatorUser` | Input | String | N/A | Binds InitiatorUser from active calling code or Oracle signature. |
| `:ProcessCode` | Input | String | N/A | Binds ProcessCode from active calling code or Oracle signature. |
| `:PrintEobFlag` | Input | String | N/A | Binds PrintEobFlag from active calling code or Oracle signature. |
| `:EbillFlag` | Input | String | N/A | Binds EbillFlag from active calling code or Oracle signature. |
| `:ProcessDate` | Input | Date | N/A | Binds ProcessDate from active calling code or Oracle signature. |
| `:MessageText` | Input | String | N/A | Binds MessageText from active calling code or Oracle signature. |
| `:UpdateUser` | Input | Date | N/A | Binds UpdateUser from active calling code or Oracle signature. |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [CBP_BILL_PAYMENT_REQUEST](../database-tables.md#cbp_bill_payment_request) | CREATE | A, APPROVER_USER, B, BILL_ID, BILL_PAYMENT_CATEGORY_CODE, BILL_PAYMENT_SEQ_NUM, C, CBP_BILL_PAYMENT_REQUEST, CHARGEABLE_COST_FLAG, CLAIM_ID, D, E |

## Sample SQL

```sql
Insert into CBP_BILL_PAYMENT_REQUEST ( BILL_PAYMENT_SEQ_NUM, BILL_ID, CLAIM_ID, PROVIDER_LOC_SEQ_NUM, TAX_ID_DISPLAY_DESCR, PROVIDER_TYPE_CODE, WORKER_ID, PAYEE_TYPE_CODE, TRANSACTION_AMT, WORKER_PAY_REASON_CODE, SPECIAL_HANDLING_CODE, ISSUE_DATE, TRANSACTION_FROM_DATE, TRANSACTION_THRU_DATE, CHARGEABLE_COST_FLAG, MCO_FEE_FLAG, BILL_PAYMENT_CATEGORY_CODE, FEDERAL_DATA_FLAG, APPROVER_USER, INITIATOR_USER, PROCESS_CODE, PRINT_EOB_FLAG, EBILL_FLAG, PROCESS_DATE, UPDATE_DATE, UPDATE_NUM, MESSAGE_TEXT, UPDATE_USER ) 
VALUES ( :BillPaymentSeqNum, :BillID, :ClaimID, :ProviderLocSeqNum, :TaxIDDisplayDescr, :ProviderTypeCode, :WorkerID, :PayeeTypeCode, :TransactionAmt, :WorkerPayReasonCode, :SpecialHandlingCode, :IssueDate, :TransactionFromDate, :TransactionThruDate, :ChargeableCostFlag, :McoFeeFlag, :BillPaymentCategoryCode, :FederalDataFlag, :ApproverUser, :InitiatorUser, :ProcessCode, :PrintEobFlag, :EbillFlag, :ProcessDate, SYSDATE, 0, :MessageText, :UpdateUser)
```

> **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.Bill\clsCBPBillPaymentRequest.vb`