SQL-018: Read operation

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

Classification

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

Tables

Table	Access	Columns used
CL_CLAIM_EMPLOYEE_WORK_ADDRESS	READ	A, ADDRESS_LINE, C, CITY_NAME, CLAIM_ID, CL_CLAIM_EMPLOYEE_WORK_ADDRESS, COUNTY_CODE, D, E, F, FOREIGN_ADDRESS_FLAG, ID

Sample SQL

Select CL_CLAIM_EMPLOYEE_WORK_ADDRESS.ADDRESS_LINE1 as AddressLine1, CL_CLAIM_EMPLOYEE_WORK_ADDRESS.ADDRESS_LINE2 as AddressLine2, CL_CLAIM_EMPLOYEE_WORK_ADDRESS.ADDRESS_LINE3 as AddressLine3, CL_CLAIM_EMPLOYEE_WORK_ADDRESS.ADDRESS_LINE4 as AddressLine4, CL_CLAIM_EMPLOYEE_WORK_ADDRESS.CITY_NAME as CityName, CL_CLAIM_EMPLOYEE_WORK_ADDRESS.CLAIM_ID as ClaimID, CL_CLAIM_EMPLOYEE_WORK_ADDRESS.COUNTY_CODE as CountyCode, CL_CLAIM_EMPLOYEE_WORK_ADDRESS.FOREIGN_ADDRESS_FLAG as ForeignAddressFlag, CL_CLAIM_EMPLOYEE_WORK_ADDRESS.STATE_CODE as StateCode, CL_CLAIM_EMPLOYEE_WORK_ADDRESS.UPDATE_DATE as UpdateDate, CL_CLAIM_EMPLOYEE_WORK_ADDRESS.UPDATE_NUM as UpdateNum, CL_CLAIM_EMPLOYEE_WORK_ADDRESS.UPDATE_USER as UpdateUser, CL_CLAIM_EMPLOYEE_WORK_ADDRESS.ZIP_CODE as ZipCode, CL_CLAIM_EMPLOYEE_WORK_ADDRESS.ZIP_CODE_EXT as ZipCodeExt 
FROM CL_CLAIM_EMPLOYEE_WORK_ADDRESS 
WHERE CL_CLAIM_EMPLOYEE_WORK_ADDRESS.CLAIM_ID = :ClaimID

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