SQL-013 Opposingoutside attorney firm list¶

Inline (const ATTORNEYLISTSQL → GetCodeCollection) for clsOtherPartiesManager.

Classification¶

Field	Value
SQL ID	SQL-013
Operation type	Read
Execution method	Inline (const ATTORNEYLISTSQL → GetCodeCollection)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsOtherPartiesManager`
Criteria property	N/A
Lifecycle method	AttorneyList 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 ('ATTY', 'OUTC')

Sources¶

SAIF.Application.Claim.Legal\LegalNet\clsOtherPartiesManager.vb