SQL-018 Legal secretary employee ID for an attorney

Inline scalar (SqlHelper.ScalarQuery(Of String)) for clsSummaryManager.

Classification

Field	Value
SQL ID	SQL-018
Operation type	Read
Execution method	Inline scalar (SqlHelper.ScalarQuery(Of String))
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsSummaryManager
Criteria property	N/A
Lifecycle method	GetLegalSecretaryID()

Parameters

Parameter	Direction	Type	Max length	Description
:ID	Input	String (VARCHAR2)	11	Attorney employee ID (PROFILE_EMPLID) whose secretary is being looked up

Tables

Table	Access	Columns used
ATTORNEY_PROFILE	SELECT	See database table section

Sample SQL

SELECT
  secretary_emplid
FROM attorney_profile
WHERE profile_emplid = :ID

Operations and processes

• Case summary display — legal secretary resolution

Sources

• SAIF.Application.Claim.Legal\LegalNet\clsSummaryManager.vb