SAIF.Application.Claim.Legal SQL catalog

This page indexes all SQL statements and package calls documented for this library.

Create operations

SQL ID	Description	Type	Tables	Business object
SQL-001	pk80001_LEGALNET.insertLetterRequest	StoredProc	N/A — Stored procedure	LegalManagerBase

Read operations

SQL ID	Description	Type	Tables	Business object
SQL-002	Retrieve active adjuster lookup list	Inline	ADP_EMPLOYEE	clsAttorneyTableManager
SQL-003	ALJ / Board / FJ person list	Inline	LEGAL_PERSON, LEGAL_PERSON_TYPE	clsAttorneyTableManager
SQL-004	SAIF attorney code list	Inline	ADP_EMPLOYEE, ATTORNEY_PROFILE	clsAttorneyTableManager
SQL-005	Hearing location code list	Inline	HEARING_LOCATION_CODE	clsAttorneyTableManager
SQL-006	Policy name code list	Inline	POLICY	clsAttorneyTableManager
SQL-007	Attorney-assignment maintenance table list	Inline	LEGAL_CODE_TABLE	clsAttorneyTableManager
SQL-008	Hearing location code list	Inline	HEARING_LOCATION_CODE	clsHearingLocationManager
SQL-009	pk80001_legalNet.getHeader	StoredProc	N/A — Stored procedure	clsLegalData
SQL-010	Other-firm type code list	Inline	OTHER_FIRM_TYPE_CODE	clsLegalPersonManager
SQL-011	Person-maintenance view code list	Inline	LEGAL_CODE_TABLE	clsLegalPersonManager
SQL-012	Legal person type code list	Inline	LEGAL_PERSON_TYPE_CODE	clsLegalPersonManager
SQL-013	Opposing/outside attorney firm list	Inline	OTHER_FIRM, DUAL	clsOtherPartiesManager
SQL-014	Opposing/outside attorney person list	Inline	LEGAL_PERSON, LEGAL_PERSON_TYPE, DUAL	clsOtherPartiesManager
SQL-015	Employer / insurer firm list	Inline	OTHER_FIRM, DUAL	clsOtherPartiesManager
SQL-016	Appeal number / review level list for a case	StringBuilder/concatenation	APPEAL, REVIEW_LEVEL_CODE, DUAL	clsOutcomeManager
SQL-017	Assigned attorney's manager email	Inline scalar	DUAL (function body opaque)	clsScheduleManager
SQL-018	Legal secretary employee ID for an attorney	Inline scalar	ATTORNEY_PROFILE	clsSummaryManager
SQL-019	Allowed case status codes for the current case	StringBuilder/concatenation	CASE_STATUS_CODE	clsUpdateCaseManager

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Security and authorization
• Configuration
• Database tables
• Procedures
• API reference

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• SAIF.Application.Claim.Legal\LegalManagerBase.vb
• SAIF.Application.Claim.Legal\clsAttorneyTableManager.vb
• SAIF.Application.Claim.Legal\clsHearingLocationManager.vb
• SAIF.Application.Claim.Legal\clsLegalPersonManager.vb
• SAIF.Application.Claim.Legal\clsLegalData.vb
• SAIF.Application.Claim.Legal\LegalNet\clsOtherPartiesManager.vb
• SAIF.Application.Claim.Legal\LegalNet\clsOutcomeManager.vb
• SAIF.Application.Claim.Legal\LegalNet\clsScheduleManager.vb
• SAIF.Application.Claim.Legal\LegalNet\clsSummaryManager.vb
• SAIF.Application.Claim.Legal\LegalNet\clsUpdateCaseManager.vb