DB-CLL-062 — Check whether a hearing location has active schedule rows

Classification

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

Parameters

Name	Direction	Type	Default	Description
HearingLocationID	Input	NUMBER	N/A	Hearing location identifier being checked for delete

Tables

Table	Access	Columns/Notes
HEARING_LOCATION	SELECT	HEARING_LOCATION_SEQ_NUM
SCHEDULE	SELECT	referencing rows

Sample SQL

Select
  Count(*)
From
  SCHEDULE
Where
  SCHEDULE.HEARING_LOCATION_SEQ_NUM = :HearingLocationID

Operations and processes

• Manage hearing locations

Business rules

• BR-CLM-LGL-012
• BR-CLM-LGL-013

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\clsHearingLocation.vb