DB-CLL-061 — Check referential-integrity blockers before delete¶

Classification¶

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

Parameters¶

Name	Direction	Type	Default	Description
LegalPersonID	Input	NUMBER	N/A	Legal person identifier reused across all three UNION branches

Tables¶

Table	Access	Columns/Notes
ATTORNEY_CONFLICT	SELECT	ATTORNEY_LEGAL_PERSON_SEQ_NUM
OUTCOME_STAFF	SELECT	OUTCOME_STAFF_PERSON_SEQ_NUM
LEGAL_PERSON_TYPE	SELECT	LEGAL_PERSON_SEQ_NUM

Sample SQL¶

Select
  Count(*)
From
  (
  Select
    ATTORNEY_LEGAL_PERSON_SEQ_NUM
  From
    ATTORNEY_CONFLICT
  Where
    ATTORNEY_CONFLICT.ATTORNEY_LEGAL_PERSON_SEQ_NUM = :LegalPersonID
  Union All
  Select
    OUTCOME_STAFF_PERSON_SEQ_NUM
  From
    OUTCOME_STAFF
  Where
    OUTCOME_STAFF.OUTCOME_STAFF_PERSON_SEQ_NUM = :LegalPersonID
  Union All
  Select
    LEGAL_PERSON_SEQ_NUM
  From
    LEGAL_PERSON_TYPE
  Where
    LEGAL_PERSON_TYPE.LEGAL_PERSON_SEQ_NUM = :LegalPersonID
  )

Operations and processes¶

Manage attorney and legal-person reference data

Business rules¶

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsLegalPerson.vb