SQL-002 Adjuster code list¶

Inline (const ADJUSTERLISTSQL → GetCodeCollection) for clsAttorneyTableManager.

Classification¶

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

Tables¶

Table	Access	Columns used
ADP_EMPLOYEE	SELECT	See database table section

Sample SQL¶

SELECT
  EMPLID As code,
  LAST_NAME || ', ' || decode(nvl(preferred_name, ' '), ' ', FIRST_NAME, preferred_name) AS code_descr
FROM ADP_EMPLOYEE
WHERE (EMPL_STATUS = 'A')
  AND (DESCR = 'Claims Adjuster'
    OR DESCR = 'Senior Technical Adjuster'
    OR DESCR = 'Senior Lead Adjuster')

Operations and processes¶

Attorney table maintenance — adjuster picklist

Sources¶

SAIF.Application.Claim.Legal\clsAttorneyTableManager.vb