SAIF.Business.Claim.Legal SQL catalog¶

This page indexes all 205 SQL statements and stored-procedure calls in this library, grouped by CRUD type. Given the scale of this library, closely-related statements are grouped onto shared detail pages by CRUD type; every SQL ID still has its own labeled subsection with full classification, parameters, tables, sample SQL and sources on the linked page.

Sequence operations¶

SQL ID	Description	Sequence	Tables	Business object
SQL-001	Acquire next appeal sequence value	`APPEAL_SEQ_NUM`	DUAL	`clsAppeal`
SQL-002	Acquire next attorney conflict sequence value	`ATTORNEY_CONFLICT_SEQ_NUM`	DUAL	`clsAttorneyConflict`
SQL-003	Acquire next attorney policy assignment sequence value	`ATTY_POLICY_ASSGN_SEQ_NUM`	DUAL	`clsAttorneyPolicyAssignment`
SQL-004	Acquire next attorney schedule sequence value	`ATTORNEY_SCHEDULE_SEQ_NUM`	DUAL	`clsAttorneySchedule`
SQL-005	Acquire next attorney worker assignment sequence value	`ATTORNEY_WORKER_ASSGN_SEQ_NUM`	DUAL	`clsAttorneyWorkerAssignment`
SQL-006	Acquire next print control sequence value	`xprint_control_seq`	DUAL	`clsCreateFile`
SQL-007	Acquire next hearing location sequence value	`HEARING_LOCATION_SEQ_NUM`	DUAL	`clsHearingLocation`
SQL-008	Acquire next legal case sequence value	`LEGAL_CASE_SEQ_NUM`	DUAL	`clsLegalCase`
SQL-009	Acquire next legal person sequence value	`LEGAL_PERSON_SEQ_NUM`	DUAL	`clsLegalPerson`
SQL-010	Acquire next legal person type sequence value	`LEGAL_PERSON_SEQ_NUM`	DUAL	`clsLegalPersonType`
SQL-011	Acquire next schedule sequence value	`SCHEDULE_SEQ_NUM`	DUAL	`clsLegalSchedule`
SQL-012	Acquire next other firm sequence value	`OTHER_FIRM_SEQ_NUM`	DUAL	`clsOtherFirm`
SQL-013	Acquire next outcome staff sequence value	`OUTCOME_STAFF_SEQ_NUM`	DUAL	`clsOutcomeStaff`
SQL-014	Acquire next out-of-town rotation sequence value	`OUT_OF_TOWN_ROTATION_SEQ_NUM`	DUAL	`clsOutOFTownRotationAssgn`

23 additional sequences (Appeal_SEQ, Case_Cost_SEQ, case_note_seq, and others) are obtained through the BOF helper GetNextSeqNum("<name>") rather than explicit CreateSQL text and are not individually numbered — see SQL-001 to SQL-014 for the full list.

Create operations¶

SQL ID	Description	Type	Tables	Business object
SQL-015	Insert a new appeal	Stored Proc	`pk80001_legalnet.insertAppeal`	`clsAppeal`
SQL-016	Insert a new appeal extension	Stored Proc	`pk80001_legalnet.insertAppealExtension`	`clsAppealExtension`
SQL-017	Insert a new attorney conflict record	Inline	ATTORNEY_CONFLICT	`clsAttorneyConflict`
SQL-018	Insert a new attorney policy assignment	Inline	ATTORNEY_POLICY_ASSIGNMENT	`clsAttorneyPolicyAssignment`
SQL-019	Insert a new attorney profile	Stored Proc	`pk80001_legalnet.insertAttyProfile`	`clsAttorneyProfile`
SQL-020	Insert a new attorney schedule entry	Inline	ATTORNEY_SCHEDULE	`clsAttorneySchedule`
SQL-021	Insert a new attorney worker assignment	Inline	ATTORNEY_WORKER_ASSIGNMENT	`clsAttorneyWorkerAssignment`
SQL-022	Insert a new case cost record	Inline	CASE_COST	`clsCaseCost`
SQL-023	Insert a new case note	Stored Proc	`pk80001_legalnet.case_note_insert`	`clsCaseNote`
SQL-024	Insert a new case outcome	Stored Proc	`pk80001_legalnet.InsertCaseOutcome`	`clsCaseOutcome`
SQL-025	Insert a new case status history record	Inline	CASE_STATUS_HISTORY	`clsCaseStatusHistory`
SQL-026	Insert a new hearing location	Inline	HEARING_LOCATION	`clsHearingLocation`
SQL-027	Insert hearing location info	Inline	HEARING_LOCATION	`clsHearingLocationInfo`
SQL-028	Insert a new legal case	Stored Proc	`pk80001_legalnet.InsertLegalCase`	`clsLegalCase`
SQL-029	Insert a new legal case evaluation	Stored Proc	`pk80001_legalnet.InsertLCE`	`clsLegalCaseEvaluation`
SQL-030	Insert a new legal file location	Stored Proc	`pk80001_legalnet.insertFileLocation`	`clsLegalFileLocation`
SQL-031	Insert a new legal person	Inline	LEGAL_PERSON	`clsLegalPerson`
SQL-032	Insert a new legal person type	Inline	LEGAL_PERSON_TYPE	`clsLegalPersonType`
SQL-033	Insert a new legal schedule	Stored Proc	`pk80001_legalnet.insertSchedule`	`clsLegalSchedule`
SQL-034	Insert a new other firm	Inline	OTHER_FIRM	`clsOtherFirm`
SQL-035	Insert a new other legal party	Inline	LEGAL_CASE_EMPLOYER	`clsOtherLegalParty`
SQL-036	Insert a new outcome issue	Inline	OUTCOME_ISSUE	`clsOutcomeIssue`
SQL-037	Insert a new outcome staff entry	Inline	OUTCOME_STAFF	`clsOutcomeStaff`
SQL-038	Insert a new out-of-town rotation assignment	Inline	OUT_OF_TOWN_ROTATION_ASSGN	`clsOutOFTownRotationAssgn`
SQL-039	Insert a new request issue	Inline	REQUEST_ISSUE	`clsRequestIssue`

Read operations¶

Reads span two detail pages: business-object/collection reads (SQL-040 to SQL-119, 80 statements) and cached code-table reads (SQL-120 to SQL-150, 31 statements). Representative entries:

SQL ID	Description	Type	Tables	Business object
SQL-086	Retrieve a legal case by sequence number	Stored Proc	`pk80001_legalnet.getLegalCase`	`clsLegalCase`
SQL-101	Retrieve a legal schedule	Stored Proc	`pk80001_legalnet.getSchedule`	`clsLegalSchedule`
SQL-072	Execute a legal-case search	Stored Proc	`pk80001_legalnet.CaseSearch`	`clsCaseSearch`
SQL-052	Retrieve attorney conflicts joined with adjuster/provider/policy/legal-person data	Inline	ATTORNEY_CONFLICT, ADP_EMPLOYEE, PROVIDER_LOCATION, POLICY, LEGAL_PERSON	`clsAttorneyConflictCollection`
SQL-102	Look up a case for letter generation	Inline	LEGAL.VW_CASES	`clsLetterRequest`
Code-table SQL group	Load cached code-table lookups (31 statements)	Inline (SQL-132 Stored Proc)	Various `code` tables, `ADP_EMPLOYEE`, `PROVIDER_LOCATION`, `LEGAL_PERSON`	`mdlCodeTables` cache classes

See the two linked pages for the complete list of all 111 Read operations.

Update operations¶

Documented in full on SQL-151 to SQL-183 (33 statements). Representative entries:

SQL ID	Description	Type	Tables	Business object
SQL-168	Update an existing legal case	Stored Proc	`pk80001_legalnet.UpdateLegalCase`	`clsLegalCase`
SQL-174	Update an existing legal schedule	Stored Proc	`pk80001_legalnet.updateSchedule`	`clsLegalSchedule`
SQL-154	Update an existing attorney conflict record	Inline	ATTORNEY_CONFLICT	`clsAttorneyConflict`

Delete operations¶

Documented in full on SQL-184 to SQL-205 (22 statements). Representative entries:

SQL ID	Description	Type	Tables	Business object
SQL-195	Delete a legal case	Stored Proc	`pk80001_legalnet.DeleteLegalCase`	`clsLegalCase`
SQL-185	Delete an attorney conflict record	Inline	ATTORNEY_CONFLICT	`clsAttorneyConflict`
SQL-200	Delete a legal schedule	Stored Proc	`pk80001_legalnet.deleteSchedule`	`clsLegalSchedule`

Sources¶

SAIF.Business.Claim.Legal\LegalNet\*, SAIF.Business.Claim.Legal\TableMaint\*, SAIF.Business.Claim.Legal\Print\* (see individual SQL detail pages for exact per-statement file/line citations)