SQL-016: Read operation

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

Classification

Field	Value
SQL ID	SQL-016
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
:AwardNum	Input	Number	N/A	Binds AwardNum from active calling code or Oracle signature.

Tables

Table	Access	Columns used
CL_BENEFIT_PAYMENT	READ	A, AND, APPROVER_USER, B, BENEFIT_PAYMENT_SEQ_NUM, BENEFIT_STATUS_CODE, BENEFIT_TYPE_CODE, C, CLAIM_ID, CL_BENEFIT_PAYMENT, D, F

Sample SQL

Select CL_BENEFIT_PAYMENT.APPROVER_USER as ApproverUser, CL_BENEFIT_PAYMENT.BENEFIT_PAYMENT_SEQ_NUM as BenefitPaymentSeqNum, CL_BENEFIT_PAYMENT.BENEFIT_STATUS_CODE as BenefitStatusCode, CL_BENEFIT_PAYMENT.BENEFIT_TYPE_CODE as BenefitTypeCode, CL_BENEFIT_PAYMENT.CLAIM_ID as ClaimID, CL_BENEFIT_PAYMENT.INITIATOR_USER as InitiatorUser, CL_BENEFIT_PAYMENT.ISSUE_DATE as IssueDate, CL_BENEFIT_PAYMENT.REVOLVING_FUND_FLAG as RevolvingFundFlag, CL_BENEFIT_PAYMENT.SAIF_AWARD_NUM as AwardNum, CL_BENEFIT_PAYMENT.SETTLEMENT_TOTAL_AMT as SettlementTotalAmt, CL_BENEFIT_PAYMENT.UPDATE_DATE as UpdateDate, CL_BENEFIT_PAYMENT.UPDATE_NUM as UpdateNum, CL_BENEFIT_PAYMENT.UPDATE_USER as UpdateUser 
FROM CL_BENEFIT_PAYMENT 
WHERE CL_BENEFIT_PAYMENT.SAIF_AWARD_NUM = :AwardNum 
  AND

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\clsAwardBenefitPaymentCollection.vb