DB-CLL-044 — Resolve a secretary ALJ display name for a schedule entry

Classification

Field	Value
SQL ID	DB-CLL-044
Operation type	R
Execution method	Text
Database	Oracle (Case Management)
Schema	[unqualified]**
Command type	Inline text SQL
Business object	clsLegalSchedule
Criteria property	n/a (custom method)
Lifecycle method	n/a

Parameters

Name	Direction	Type	Default	Description
SecretaryEmplid	Input	VARCHAR2	N/A	Employee ID of the secretary/ALJ to resolve a display name for

Tables

Table	Access	Columns/Notes
LEGAL_SCHEDULE	SELECT	join key
ADP_EMPLOYEE	SELECT	display name columns

Sample SQL

Select
  ADP_EMPLOYEE.EMPLOYEE_NAME
From
  ADP_EMPLOYEE
Where
  ADP_EMPLOYEE.EMPLID = :SecretaryEmplid

Operations and processes

• Manage legal schedule and hearing calendar

Business rules

• BR-CLM-LGL-005
• BR-CLM-LGL-025

Sources

• SAIF.Business.Claim.Legal\LegalNet\clsLegalSchedule.vb