SQL-184 to SQL-205: Delete operations¶

This page documents all 22 Delete-type SQL operations (SQL-184 through SQL-205). Stored-procedure deletes have their body retrieval marked unavailable for this run (Legends CLI offline); see Procedures.

SQL-184 clsAppeal¶

clsAppeal — stored procedure call against pk80001_legalnet.DeleteAppeal.

Classification¶

Field	Value
SQL ID	SQL-184
Operation type	Delete
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAppeal`
Criteria property	`N/A`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.DeleteAppeal(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsAppeal.vb

SQL-185 clsAttorneyConflict.Criteria.DeleteSQL¶

clsAttorneyConflict.Criteria.DeleteSQL — inline DELETE against ATTORNEY_CONFLICT.

Classification¶

Field	Value
SQL ID	SQL-185
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneyConflict`
Criteria property	`DeleteSQL`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
ATTORNEY_CONFLICT	DELETE	See Sample SQL below

Sample SQL¶

-- Delete against ATTORNEY_CONFLICT
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against ATTORNEY_CONFLICT in this library.*

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb

SQL-186 clsAttorneyPolicyAssignment.Criteria.DeleteSQL¶

clsAttorneyPolicyAssignment.Criteria.DeleteSQL — inline DELETE against ATTORNEY_POLICY_ASSIGNMENT.

Classification¶

Field	Value
SQL ID	SQL-186
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneyPolicyAssignment`
Criteria property	`DeleteSQL`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
ATTORNEY_POLICY_ASSIGNMENT	DELETE	See Sample SQL below

Sample SQL¶

-- Delete against ATTORNEY_POLICY_ASSIGNMENT
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against ATTORNEY_POLICY_ASSIGNMENT in this library.*

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneyPolicyAssignment.vb

SQL-187 clsAttorneySchedule.Criteria.DeleteSQL¶

clsAttorneySchedule.Criteria.DeleteSQL — inline DELETE against ATTORNEY_SCHEDULE.

Classification¶

Field	Value
SQL ID	SQL-187
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneySchedule`
Criteria property	`DeleteSQL`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
ATTORNEY_SCHEDULE	DELETE	See Sample SQL below

Sample SQL¶

-- Delete against ATTORNEY_SCHEDULE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against ATTORNEY_SCHEDULE in this library.*

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneySchedule.vb

SQL-188 clsAttorneyWorkerAssignment.Criteria.DeleteSQL¶

clsAttorneyWorkerAssignment.Criteria.DeleteSQL — inline DELETE against ATTORNEY_WORKER_ASSIGNMENT.

Classification¶

Field	Value
SQL ID	SQL-188
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneyWorkerAssignment`
Criteria property	`DeleteSQL`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
ATTORNEY_WORKER_ASSIGNMENT	DELETE	See Sample SQL below

Sample SQL¶

-- Delete against ATTORNEY_WORKER_ASSIGNMENT
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against ATTORNEY_WORKER_ASSIGNMENT in this library.*

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneyWorkerAssignment.vb

SQL-189 clsCaseCost.Criteria.DeleteSQL¶

clsCaseCost.Criteria.DeleteSQL — inline DELETE against CASE_COST.

Classification¶

Field	Value
SQL ID	SQL-189
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsCaseCost`
Criteria property	`DeleteSQL`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
CASE_COST	DELETE	See Sample SQL below

Sample SQL¶

-- Delete against CASE_COST
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against CASE_COST in this library.*

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsCaseCost.vb

SQL-190 clsCaseNote¶

clsCaseNote — stored procedure call against pk80001_legalnet.case_note_delete.

Classification¶

Field	Value
SQL ID	SQL-190
Operation type	Delete
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsCaseNote`
Criteria property	`N/A`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.case_note_delete(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsCaseNote.vb

SQL-191 clsCaseOutcome¶

clsCaseOutcome — stored procedure call against pk80001_legalnet.DeleteCaseOutcome.

Classification¶

Field	Value
SQL ID	SQL-191
Operation type	Delete
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsCaseOutcome`
Criteria property	`N/A`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.DeleteCaseOutcome(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsCaseOutcome.vb

SQL-192 clsCaseStatusHistory.Criteria.DeleteSQL¶

clsCaseStatusHistory.Criteria.DeleteSQL — inline DELETE against CASE_STATUS_HISTORY.

Classification¶

Field	Value
SQL ID	SQL-192
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsCaseStatusHistory`
Criteria property	`DeleteSQL`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
CASE_STATUS_HISTORY	DELETE	See Sample SQL below

Sample SQL¶

-- Delete against CASE_STATUS_HISTORY
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against CASE_STATUS_HISTORY in this library.*

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsCaseStatusHistory.vb

SQL-193 clsHearingLocation.Criteria.DeleteSQL¶

clsHearingLocation.Criteria.DeleteSQL — inline DELETE against HEARING_LOCATION.

Classification¶

Field	Value
SQL ID	SQL-193
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsHearingLocation`
Criteria property	`DeleteSQL`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
HEARING_LOCATION	DELETE	See Sample SQL below

Sample SQL¶

-- Delete against HEARING_LOCATION
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against HEARING_LOCATION in this library.*

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsHearingLocation.vb

SQL-194 clsHearingLocationInfo.Criteria.DeleteSQL¶

clsHearingLocationInfo.Criteria.DeleteSQL — inline DELETE against HEARING_LOCATION.

Classification¶

Field	Value
SQL ID	SQL-194
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsHearingLocationInfo`
Criteria property	`DeleteSQL`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
HEARING_LOCATION	DELETE	See Sample SQL below

Sample SQL¶

-- Delete against HEARING_LOCATION
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against HEARING_LOCATION in this library.*

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsHearingLocationInfo.vb

SQL-195 clsLegalCase¶

clsLegalCase — stored procedure call against pk80001_legalnet.DeleteLegalCase.

Classification¶

Field	Value
SQL ID	SQL-195
Operation type	Delete
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLegalCase`
Criteria property	`N/A`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.DeleteLegalCase(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsLegalCase.vb

SQL-196 clsLegalCaseEmployer.Criteria.DeleteSQL¶

clsLegalCaseEmployer.Criteria.DeleteSQL — inline DELETE against LEGAL_CASE_EMPLOYER.

Classification¶

Field	Value
SQL ID	SQL-196
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalCaseEmployer`
Criteria property	`DeleteSQL`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
LEGAL_CASE_EMPLOYER	DELETE	See Sample SQL below

Sample SQL¶

-- Delete against LEGAL_CASE_EMPLOYER
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against LEGAL_CASE_EMPLOYER in this library.*

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsLegalCaseEmployer.vb

SQL-197 clsLegalFileLocation¶

clsLegalFileLocation — inline DELETE against LEGAL_FILE_LOCATION.

Classification¶

Field	Value
SQL ID	SQL-197
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalFileLocation`
Criteria property	`N/A`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
LEGAL_FILE_LOCATION	DELETE	See Sample SQL below

Sample SQL¶

-- Delete against LEGAL_FILE_LOCATION
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against LEGAL_FILE_LOCATION in this library.*

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsLegalFileLocation.vb

SQL-198 clsLegalPerson.Criteria.DeleteSQL¶

clsLegalPerson.Criteria.DeleteSQL — inline DELETE against LEGAL_PERSON.

Classification¶

Field	Value
SQL ID	SQL-198
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalPerson`
Criteria property	`DeleteSQL`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
LEGAL_PERSON	DELETE	See Sample SQL below

Sample SQL¶

-- Delete against LEGAL_PERSON
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against LEGAL_PERSON in this library.*

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsLegalPerson.vb

SQL-199 clsLegalPersonType.Criteria.DeleteSQL¶

clsLegalPersonType.Criteria.DeleteSQL — inline DELETE against LEGAL_PERSON_TYPE.

Classification¶

Field	Value
SQL ID	SQL-199
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalPersonType`
Criteria property	`DeleteSQL`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
LEGAL_PERSON_TYPE	DELETE	See Sample SQL below

Sample SQL¶

-- Delete against LEGAL_PERSON_TYPE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against LEGAL_PERSON_TYPE in this library.*

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsLegalPersonType.vb

SQL-200 clsLegalSchedule.deleteSchedule¶

clsLegalSchedule.deleteSchedule — stored procedure call against pk80001_legalnet.deleteSchedule.

Classification¶

Field	Value
SQL ID	SQL-200
Operation type	Delete
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLegalSchedule`
Criteria property	`N/A`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.deleteSchedule(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsLegalSchedule.vb

SQL-201 clsOtherFirm.Criteria.DeleteSQL¶

clsOtherFirm.Criteria.DeleteSQL — inline DELETE against OTHER_FIRM.

Classification¶

Field	Value
SQL ID	SQL-201
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOtherFirm`
Criteria property	`DeleteSQL`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
OTHER_FIRM	DELETE	See Sample SQL below

Sample SQL¶

-- Delete against OTHER_FIRM
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against OTHER_FIRM in this library.*

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsOtherFirm.vb

SQL-202 clsOtherLegalParty.Criteria.DeleteSQL¶

clsOtherLegalParty.Criteria.DeleteSQL — inline DELETE against LEGAL_CASE_EMPLOYER.

Classification¶

Field	Value
SQL ID	SQL-202
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOtherLegalParty`
Criteria property	`DeleteSQL`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
LEGAL_CASE_EMPLOYER	DELETE	See Sample SQL below

Sample SQL¶

-- Delete against LEGAL_CASE_EMPLOYER
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against LEGAL_CASE_EMPLOYER in this library.*

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsOtherLegalParty.vb

SQL-203 clsOutcomeIssue.Criteria.DeleteSQL¶

clsOutcomeIssue.Criteria.DeleteSQL — inline DELETE against OUTCOME_ISSUE.

Classification¶

Field	Value
SQL ID	SQL-203
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOutcomeIssue`
Criteria property	`DeleteSQL`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
OUTCOME_ISSUE	DELETE	See Sample SQL below

Sample SQL¶

-- Delete against OUTCOME_ISSUE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against OUTCOME_ISSUE in this library.*

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsOutcomeIssue.vb

SQL-204 clsOutcomeStaff.Criteria.DeleteSQL¶

clsOutcomeStaff.Criteria.DeleteSQL — inline DELETE against OUTCOME_STAFF.

Classification¶

Field	Value
SQL ID	SQL-204
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOutcomeStaff`
Criteria property	`DeleteSQL`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
OUTCOME_STAFF	DELETE	See Sample SQL below

Sample SQL¶

-- Delete against OUTCOME_STAFF
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against OUTCOME_STAFF in this library.*

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsOutcomeStaff.vb

SQL-205 clsOutOFTownRotationAssgn.Criteria.DeleteSQL + clsRequestIssue.Criteria.DeleteSQL¶

clsOutOFTownRotationAssgn.Criteria.DeleteSQL + clsRequestIssue.Criteria.DeleteSQL — inline DELETE against OUT_OF_TOWN_ROTATION_ASSGN, REQUEST_ISSUE.

Classification¶

Field	Value
SQL ID	SQL-205
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOutOFTownRotationAssgn`
Criteria property	`DeleteSQL`
Lifecycle method	`BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
OUT_OF_TOWN_ROTATION_ASSGN	DELETE	See Sample SQL below

Sample SQL¶

-- Delete against OUT_OF_TOWN_ROTATION_ASSGN, REQUEST_ISSUE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against OUT_OF_TOWN_ROTATION_ASSGN, REQUEST_ISSUE in this library.*

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsOutOFTownRotationAssgn.vb, LegalNet\clsRequestIssue.vb

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

See per-SQL-ID Sources subsections above for exact .vb file/line citations.