DB-CLL-058 — Look up a case number for a printed letter

Classification

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

Parameters

Name	Direction	Type	Default	Description
LegalCaseID	Input	NUMBER	N/A	Legal case identifier used to look up the case number

Tables

Table	Access	Columns/Notes
LEGAL.vw_cases	SELECT	case number lookup

Sample SQL

Select
  vw_cases.case_number
From
  LEGAL.vw_cases
Where
  vw_cases.legal_case_seq_num = :LegalCaseID

Operations and processes

• Print a legal letter

Business rules

• BR-CLM-LGL-020
• BR-CLM-LGL-021
• BR-CLM-LGL-022
• BR-CLM-LGL-023

Sources

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