SQL-015 Employer insurer firm list¶

Inline (const EMPTYPELISTSQL → GetCodeCollection) for clsOtherPartiesManager.

Classification¶

Field	Value
SQL ID	SQL-015
Operation type	Read
Execution method	Inline (const EMPTYPELISTSQL → GetCodeCollection)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsOtherPartiesManager`
Criteria property	N/A
Lifecycle method	EmployerList property getter

Tables¶

Table	Access	Columns used
OTHER_FIRM	SELECT	See database table section
DUAL	SELECT	See database table section

Sample SQL¶

SELECT
  '0',
  ' '
FROM dual
UNION
SELECT
  to_char(OTHER_FIRM_SEQ_NUM) As code,
  Firm_Name As code_descr
FROM OTHER_FIRM
WHERE OTHER_FIRM_TYPE_CODE IN ('INS', 'EMP')

Sources¶

clsOtherPartiesManager.vb