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 for the full retrieved source.

Sample 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

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)