SQL-033: InvestigationRepositoryExtensions.GetClaimId

This statement is a read operation invoked through Inline (Session.CreateSqlQuery). Executed by InvestigationRepositoryExtensions.GetClaimId.

Classification

Field	Value
SQL ID	SQL-033
Operation type	Read
Execution method	Inline (Session.CreateSqlQuery)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	InvestigationRepositoryExtensions
Criteria property	N/A — no IBusinessCriteria
Lifecycle method	GetClaimId

Parameters

Parameter	Direction	Type	Max length	Description
:investigationId	Input	long (SetParameter<long>)	N/A	Investigation case number (INVESTIGATION_SEQ_NUM)

Tables

Table	Access	Columns used
INVESTIGATION	Read	See Sample SQL

Sample SQL

Source: Data/SAIF.Data.NHibernate/Repositories/Investigations/InvestigationRepositoryExtensions.cs:47

SELECT inv.claim_id
FROM investigation inv
WHERE investigation_seq_num = :investigationId

Operations and processes

• Investigation subject and claim

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

Sources

• Data/SAIF.Data.NHibernate/Repositories/Investigations/InvestigationRepositoryExtensions.cs:47