---
title: "SQL-024: External client e-mail lookup (legacy path)"
summary: Look up an external client e-mail address (legacy path).
status: draft
owner: SAIF Doc Gen
last_reviewed: "2026-08-17"
library: SAIF.Business.View.Policy
reference_type: package
---

# SQL-024: External client e-mail lookup (legacy path)

`clsTeamAssignment` uses this call to resolve an external client's e-mail address for a team assignment via a SQL Server stored procedure (legacy path).

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-024 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | SQL Server (BDS database `eisD0P11`) |
| **Schema** | `dbo` |
| **Command type** | StoredProcedure |
| **Business object** | `clsTeamAssignment` |
| **Criteria property** | N/A (ad hoc, literal `SQLStatement`) |
| **Lifecycle method** | `InitializeEmailAddress` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `@idNum` | Input | `char` | 100 | User or mail identifier used to look up an external client's e-mail address. |
| `@clientLastName` | Input | `char` | 255 | Last name derived from the assignment's full name, used as a secondary lookup key. |

## Tables

| Table | Database | Access |
| --- | --- | --- |
| `Net_Registrant` | SQL Server, three-part name `EIS_PROD.dbo.Net_Registrant` | Read (`SELECT TOP 1 *`, filtered and ordered) |

See [cp_external_client_lookup](../procedures/cp_external_client_lookup.md) for the full retrieved source.

## Sample SQL

```sql
-- Actual T-SQL source retrieved from SQL Server (database eisD0P11) via Legends CLI
select top 1 *
from EIS_PROD.dbo.Net_Registrant reg
where
rtrim(reg.ID_NUM)=rtrim(@idNum)
and rtrim(reg.USER_LAST_NAM)=rtrim(@clientLastName)
and reg.ACTIVE_FL='Y'
AND reg.TEST_USER_FL='N'
order by reg.UPDATE_DATE desc
```

## Operations and processes

- [Retrieve supporting policy aggregates](../operations/retrieve-supporting-policy-aggregates.md)

> **Note:** Statements marked with `*` were inferred from code structure, naming
> conventions, or contextual evidence where direct confirmation was not available
> in source artifacts.

## Sources

- `Business/SAIF.Business.View.Policy/clsTeamAssignment.vb`
- SQL Server BDS database `eisD0P11`: `dbo.cp_external_client_lookup` (retrieved via Legends CLI `legends sqlserver query`)