DB-CLL-032 — Retrieve the full hearing-location lookup list¶

Classification¶

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

Parameters¶

No bound parameters were identified for this statement.

Tables¶

Table	Access	Columns/Notes
HEARING_LOCATION	SELECT	all rows, no filter

Sample SQL¶

Select
  HEARING_LOCATION.HEARING_LOCATION_SEQ_NUM as HearingLocationID,
  HEARING_LOCATION.HEARING_LOCATION_CODE as HearingLocationCode,
  HEARING_LOCATION.LOCATION_NAME as LocationName
From
  HEARING_LOCATION

Operations and processes¶

Manage hearing locations

Business rules¶

Sources¶

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