Skip to content

SQL-023: Read operation

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

Classification

Field Value
SQL ID SQL-023
Operation type Read
Execution method Inline
Database Oracle
Schema [unqualified]**
Command type Text
Business object Criteria
Criteria property RetrieveSQL
Lifecycle method BeforeRetrieve

Parameters

Parameter Direction Type Max length Description
:BillID Input Number N/A Binds BillID from active calling code or Oracle signature.

Tables

Table Access Columns used
CBP_BILL_PROCEDURE READ B, BILL_ID, BILL_PROCEDURE_SEQ_NUM, BILL_SERVICE_TYPE_CODE, C, CBP_BILL_PROCEDURE, CBP_SERVICE_CODE, D, F, ID, N, P

Sample SQL

Select CBP_BILL_PROCEDURE.BILL_ID as BillID, CBP_BILL_PROCEDURE.CBP_SERVICE_CODE as CbpServiceCode, CBP_BILL_PROCEDURE.BILL_SERVICE_TYPE_CODE as BillServiceTypeCode, CBP_BILL_PROCEDURE.BILL_PROCEDURE_SEQ_NUM as BillProcedureID, CBP_BILL_PROCEDURE.PRIMARY_PROCEDURE_CODE as PrimaryProcedureCode, CBP_BILL_PROCEDURE.PROCEDURE_DATE as ProcedureDate, CBP_BILL_PROCEDURE.UPDATE_USER as UpdateUser, CBP_BILL_PROCEDURE.UPDATE_NUM as UpdateNumber, CBP_BILL_PROCEDURE.UPDATE_DATE as UpdateDate 
FROM CBP_BILL_PROCEDURE 
WHERE CBP_BILL_PROCEDURE.BILL_ID = :BillID

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