SQL-006 Policy name code list

Inline (const POLICYNAMESQL → GetCodeCollection) for clsAttorneyTableManager.

Classification

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

Tables

Table	Access	Columns used
POLICY	SELECT	See database table section

Sample SQL

SELECT DISTINCT
  to_char(POLICY_NUM) As code,
  POLICY_NAME As code_descr
FROM POLICY
ORDER BY code_descr

Operations and processes

• Attorney policy assignment maintenance

Sources

• clsAttorneyTableManager.vb