DB-CLL-030 — Retrieve a single other-legal-party record¶

Classification¶

Field	Value
SQL ID	DB-CLL-030
Operation type	R
Execution method	Text
Database	Oracle (Case Management)
Schema	[unqualified]**
Command type	Inline text SQL
Business object	clsOtherLegalParty
Criteria property	RetrieveSQL
Lifecycle method	AfterRetrieve

Parameters¶

Name	Direction	Type	Default	Description
LegalCaseID	Input	NUMBER	N/A	Legal case identifier the other-party row belongs to

Tables¶

Table	Access	Columns/Notes
LEGAL_CASE_EMPLOYER	SELECT	LEGAL_CASE_SEQ_NUM, all LEGAL_CASE_EMPLOYER columns

Sample SQL¶

Select
  LEGAL_CASE_EMPLOYER.LEGAL_CASE_EMPLOYER_SEQ_NUM as OtherPartyID,
  LEGAL_CASE_EMPLOYER.LEGAL_CASE_SEQ_NUM as LegalCaseID,
  LEGAL_CASE_EMPLOYER.EMPLOYER_OTHER_FIRM_SEQ_NUM as EmployerOtherFirmSeqNum,
  LEGAL_CASE_EMPLOYER.ATTORNEY_OTHER_FIRM_SEQ_NUM as AttorneyOtherFirmSeqNum,
  LEGAL_CASE_EMPLOYER.ATTORNEY_LEGAL_PERSON_SEQ_NUM as AttorneyLegalPersonSeqNum,
  LEGAL_CASE_EMPLOYER.EMPLOYER_DISCOVERY_FLAG as EmployerDiscoveryFlag,
  LEGAL_CASE_EMPLOYER.ATTORNEY_DISCOVERY_FLAG as AttorneyDiscoveryFlag
From
  LEGAL_CASE_EMPLOYER
Where
  LEGAL_CASE_EMPLOYER.LEGAL_CASE_SEQ_NUM = :LegalCaseID

Operations and processes¶

Manage other legal parties and request issues

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsOtherLegalParty.vb