SQL-008 Hearing location code list

Inline (const LOCATIONCODESQL → GetCodeCollection) for clsHearingLocationManager.

Classification

Field	Value
SQL ID	SQL-008
Operation type	Read
Execution method	Inline (const LOCATIONCODESQL → GetCodeCollection)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsHearingLocationManager
Criteria property	N/A
Lifecycle method	LocationCode property getter

Tables

Table	Access	Columns used
HEARING_LOCATION_CODE	SELECT	See database table section

Sample SQL

SELECT
  code,
  code_descr
FROM HEARING_LOCATION_CODE
ORDER BY code_descr

Sources

• SAIF.Application.Claim.Legal\clsHearingLocationManager.vb