SAIF.Application.Claim.Legal SQL catalog

This page indexes all 24 application-layer SQL statements and stored-procedure calls in this library, grouped by CRUD type. This library has no IBusinessCriteria implementations, so every Business object cell below is N/A (Application layer); the calling AppManager class is noted in each statement's own document instead.

Create operations

SQL ID	Description	Type	Tables	Business object
SQL-001	Insert a new legal letter request	Stored Proc	N/A — stored procedure	N/A (Application layer)

Read operations

SQL ID	Description	Type	Tables	Business object
SQL-002	Retrieve claims adjuster code list	Inline	ADP_EMPLOYEE	N/A (Application layer)
SQL-003	Retrieve administrative law judge (ALJ) list	Inline	LEGAL_PERSON, LEGAL_PERSON_TYPE	N/A (Application layer)
SQL-004	Retrieve attorney list with names	Inline	ADP_EMPLOYEE, ATTORNEY_PROFILE	N/A (Application layer)
SQL-005	Retrieve attorney schedule type codes	Inline	ATTORNEY_SCHEDULE_TYPE_CODE	N/A (Application layer)
SQL-006	Retrieve hearing duration code list	Inline	DURATION_CODE	N/A (Application layer)
SQL-007	Retrieve hearing location code list	Inline	HEARING_LOCATION_CODE	N/A (Application layer)
SQL-008	Retrieve distinct policy name list	Inline	POLICY	N/A (Application layer)
SQL-009	Retrieve attorney-assignment maintenance table list	Inline	LEGAL_CODE_TABLE	N/A (Application layer)
SQL-010	Retrieve duration code list (hearing location screen)	Inline	DURATION_CODE	N/A (Application layer)
SQL-011	Retrieve hearing location code list (hearing location screen)	Inline	HEARING_LOCATION_CODE	N/A (Application layer)
SQL-012	Retrieve legal case header by case number	Stored Proc	N/A — stored procedure	N/A (Application layer)
SQL-013	Retrieve other-firm type code list	Inline	OTHER_FIRM_TYPE_CODE	N/A (Application layer)
SQL-014	Retrieve legal code tables for person maintenance	Inline	LEGAL_CODE_TABLE	N/A (Application layer)
SQL-015	Retrieve legal person type code list	Inline	LEGAL_PERSON_TYPE_CODE	N/A (Application layer)
SQL-016	Retrieve attorney firm list for other parties	Inline	OTHER_FIRM, DUAL	N/A (Application layer)
SQL-017	Retrieve attorney person list for other parties	Inline	LEGAL_PERSON, LEGAL_PERSON_TYPE	N/A (Application layer)
SQL-018	Retrieve employer/insurer firm list for other parties	Inline	OTHER_FIRM, DUAL	N/A (Application layer)
SQL-019	Retrieve appeal hearing level list by case	Inline	APPEAL, REVIEW_LEVEL_CODE, DUAL	N/A (Application layer)
SQL-020	Retrieve assigned attorney's manager email address	Inline (scalar function)	DUAL	N/A (Application layer)
SQL-021	Retrieve legal secretary employee ID by attorney	Inline	ATTORNEY_PROFILE	N/A (Application layer)
SQL-022	Retrieve attorney firm list for case update	Inline	OTHER_FIRM	N/A (Application layer)
SQL-023	Retrieve attorney person list for case update	Inline	LEGAL_PERSON, LEGAL_PERSON_TYPE	N/A (Application layer)
SQL-024	Retrieve case status codes by prior status	Inline	CASE_STATUS_CODE	N/A (Application layer)

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Database tables
• API reference

Sources

• 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\LegalManagerBase.vb
• SAIF.Application.Claim.Legal\LegalNet\clsOtherPartiesManager.vb
• SAIF.Application.Claim.Legal\LegalNet\clsOutcomeManager.vb
• SAIF.Application.Claim.Legal\LegalNet\clsUpdateCaseManager.vb
• SAIF.Application.Claim.Legal\LegalNet\clsSummaryManager.vb
• SAIF.Application.Claim.Legal\LegalNet\clsScheduleManager.vb