SQL-008: Create operation
This document records the SQL used by Criteria in SAIF.Business.Claim.Bill.
Classification
Field
Value
SQL ID SQL-008
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
:BillIDInput
Number
N/A
Binds BillID from active calling code or Oracle signature.
:CbpServiceCodeInput
String
N/A
Binds CbpServiceCode from active calling code or Oracle signature.
:BillServiceTypeCodeInput
String
N/A
Binds BillServiceTypeCode from active calling code or Oracle signature.
:BillProcedureIDInput
Number
N/A
Binds BillProcedureID from active calling code or Oracle signature.
:PrimaryProcedureCodeInput
String
N/A
Binds PrimaryProcedureCode from active calling code or Oracle signature.
:ProcedureDateInput
Date
N/A
Binds ProcedureDate from active calling code or Oracle signature.
:UpdateUserInput
Date
N/A
Binds UpdateUser from active calling code or Oracle signature.
:UpdateDateInput
Date
N/A
Binds UpdateDate from active calling code or Oracle signature.
Tables
Table
Access
Columns used
CBP_BILL_PROCEDURE CREATE
B, BILL_ID, BILL_PROCEDURE_SEQ_NUM, BILL_SERVICE_TYPE_CODE, C, CBP_BILL_PROCEDURE, CBP_SERVICE_CODE, D, I, ID, P, PRIMARY_PROCEDURE_CODE
Sample SQL
Insert into CBP_BILL_PROCEDURE ( BILL_ID , CBP_SERVICE_CODE , BILL_SERVICE_TYPE_CODE , BILL_PROCEDURE_SEQ_NUM , PRIMARY_PROCEDURE_CODE , PROCEDURE_DATE , UPDATE_USER , UPDATE_NUM , UPDATE_DATE )
VALUES ( : BillID , : CbpServiceCode , : BillServiceTypeCode , : BillProcedureID , : PrimaryProcedureCode , : ProcedureDate , : UpdateUser , 0 , : UpdateDate )
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\Core\clsBillProcedure.vb