Skip to content

SQL-013: Read operation

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

Classification

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

Parameters

Parameter Direction Type Max length Description
— — — — No bound parameters detected in source.

Tables

Table Access Columns used
CBP_AUDIT_ADJUSTMENT_TYPE READ _

Sample SQL

select * 
FROM cbp_audit_adjustment_type

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\AuditSupport\mdlCBPSupportingData.vb