SQL-011: Investigation request date

This document describes SQL-011, the investigation request date statement or call used by SAIF.Business.

Classification

Field	Value
SQL ID	SQL-011
Operation type	Read
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	ClaimServices
Criteria property	N/A
Lifecycle method	InvestigationRequestdate

Parameters

This SQL statement has no explicit parameters in the provided findings.

Tables

Table	Access	Columns used
INVESTIGATION	SELECT	See sample SQL and source implementation.

Sample SQL

SELECT MIN(create_date) FROM investigation WHERE claim_id = :claimid

Operations and processes

• Claim authorization and visibility checks

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Business\SAIF.Business\ClaimServices.vb