---
title: "Investigation subject and claim"
summary: Operation implemented by InvestigationRepositoryExtensions
status: draft
owner: SAIF.Core documentation team
last_reviewed: 2026-09-24
library: SAIF.Data.NHibernate
reference_type: package
operation_id: "OP-SDN-15"
trigger: "See steps below"
---


# Investigation subject and claim

Investigation subject and claim is implemented by `InvestigationRepositoryExtensions` and is documented as OP-SDN-15 in the Stage 1 analysis.

| Field | Value |
| --- | --- |
| **Operation ID** | OP-SDN-15 |
| **Trigger** | See steps below |
| **Primary components** | `InvestigationRepositoryExtensions` |

## Steps

1. `GetSubjectName(caseNumber)`: raw Oracle SQL ([SQL-032](../sql/SQL-032-investigation-repository-extensions-get-subject-name.md)) across `investigation`, subject, person, company, `provider_location` and `policy`, using `nvl` fallbacks.
   - Rule: [SDN-BR-050](../business-rules.md#sdn-br-050-investigation-subject-name-resolves-via-person%2C-company-or-provider-location%2C-with-nvl-fallbacks).
2. `GetClaimId(caseNumber)`: raw Oracle SQL ([SQL-033](../sql/SQL-033-investigation-repository-extensions-get-claim-id.md)).

## Process flow

The following diagram visualizes this operation's control flow.

```mermaid
flowchart TD
	Start(["Investigation subject and claim"]) --> S1["`InvestigationRepositoryExtensions`"]
	S1 --> S2{"Rules satisfied?"}
	S2 -->|Yes| EndOk([Result returned])
	S2 -->|No| EndErr([Exception / empty result])
```

## Related documentation
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [SQL catalog](../sql/index.md)
- [Database tables](../database-tables.md)

## Sources
- `Data/SAIF.Data.NHibernate/Repositories/Investigations/InvestigationRepositoryExtensions.cs`