SQL-015 to SQL-039: Insert (create) operations¶

This page documents all 25 Create-type SQL operations (SQL-015 through SQL-039). Stored-procedure inserts have their body retrieval marked unavailable for this run (Legends CLI offline); see Procedures.

SQL-015 clsAppeal¶

clsAppeal — StoredProc operation against pk80001_legalnet.insertAppeal.

Classification¶

Field	Value
SQL ID	SQL-015
Operation type	StoredProc
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAppeal`
Criteria property	`N/A`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

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

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.insertAppeal(...)
-- 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-016 clsAppealExtension¶

clsAppealExtension — StoredProc operation against pk80001_legalnet.insertAppealExtension.

Classification¶

Field	Value
SQL ID	SQL-016
Operation type	StoredProc
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAppealExtension`
Criteria property	`N/A`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-017 clsAttorneyConflict.Criteria.InsertSQL¶

clsAttorneyConflict.Criteria.InsertSQL — Insert operation against ATTORNEY_CONFLICT.

Classification¶

Field	Value
SQL ID	SQL-017
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneyConflict`
Criteria property	`InsertSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
ATTORNEY_CONFLICT	INSERT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-018 clsAttorneyPolicyAssignment.Criteria.InsertSQL¶

clsAttorneyPolicyAssignment.Criteria.InsertSQL — Insert operation against ATTORNEY_POLICY_ASSIGNMENT.

Classification¶

Field	Value
SQL ID	SQL-018
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneyPolicyAssignment`
Criteria property	`InsertSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
ATTORNEY_POLICY_ASSIGNMENT	INSERT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-019 clsAttorneyProfile¶

clsAttorneyProfile — StoredProc operation against pk80001_legalnet.insertAttyProfile.

Classification¶

Field	Value
SQL ID	SQL-019
Operation type	StoredProc
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAttorneyProfile`
Criteria property	`N/A`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-020 clsAttorneySchedule.Criteria.InsertSQL¶

clsAttorneySchedule.Criteria.InsertSQL — Insert operation against ATTORNEY_SCHEDULE.

Classification¶

Field	Value
SQL ID	SQL-020
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneySchedule`
Criteria property	`InsertSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
ATTORNEY_SCHEDULE	INSERT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-021 clsAttorneyWorkerAssignment.Criteria.InsertSQL¶

clsAttorneyWorkerAssignment.Criteria.InsertSQL — Insert operation against ATTORNEY_WORKER_ASSIGNMENT.

Classification¶

Field	Value
SQL ID	SQL-021
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneyWorkerAssignment`
Criteria property	`InsertSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
ATTORNEY_WORKER_ASSIGNMENT	INSERT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-022 clsCaseCost.Criteria.InsertSQL¶

clsCaseCost.Criteria.InsertSQL — Insert operation against CASE_COST.

Classification¶

Field	Value
SQL ID	SQL-022
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsCaseCost`
Criteria property	`InsertSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
CASE_COST	INSERT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-023 clsCaseNote¶

clsCaseNote — StoredProc operation against pk80001_legalnet.case_note_insert.

Classification¶

Field	Value
SQL ID	SQL-023
Operation type	StoredProc
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsCaseNote`
Criteria property	`N/A`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

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

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.case_note_insert(...)
-- 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-024 clsCaseOutcome¶

clsCaseOutcome — StoredProc operation against pk80001_legalnet.InsertCaseOutcome.

Classification¶

Field	Value
SQL ID	SQL-024
Operation type	StoredProc
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsCaseOutcome`
Criteria property	`N/A`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

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

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.InsertCaseOutcome(...)
-- 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-025 clsCaseStatusHistory.Criteria.InsertSQL¶

clsCaseStatusHistory.Criteria.InsertSQL — Insert operation against CASE_STATUS_HISTORY.

Classification¶

Field	Value
SQL ID	SQL-025
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsCaseStatusHistory`
Criteria property	`InsertSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
CASE_STATUS_HISTORY	INSERT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-026 clsHearingLocation.Criteria.InsertSQL¶

clsHearingLocation.Criteria.InsertSQL — Insert operation against HEARING_LOCATION.

Classification¶

Field	Value
SQL ID	SQL-026
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsHearingLocation`
Criteria property	`InsertSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
HEARING_LOCATION	INSERT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-027 clsHearingLocationInfo.Criteria.InsertSQL¶

clsHearingLocationInfo.Criteria.InsertSQL — Insert operation against HEARING_LOCATION.

Classification¶

Field	Value
SQL ID	SQL-027
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsHearingLocationInfo`
Criteria property	`InsertSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
HEARING_LOCATION	INSERT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-028 clsLegalCase¶

clsLegalCase — StoredProc operation against pk80001_legalnet.InsertLegalCase.

Classification¶

Field	Value
SQL ID	SQL-028
Operation type	StoredProc
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLegalCase`
Criteria property	`N/A`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

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

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.InsertLegalCase(...)
-- 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-029 clsLegalCaseEvaluation¶

clsLegalCaseEvaluation — StoredProc operation against pk80001_legalnet.InsertLCE.

Classification¶

Field	Value
SQL ID	SQL-029
Operation type	StoredProc
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLegalCaseEvaluation`
Criteria property	`N/A`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-030 clsLegalFileLocation¶

clsLegalFileLocation — StoredProc operation against pk80001_legalnet.insertFileLocation.

Classification¶

Field	Value
SQL ID	SQL-030
Operation type	StoredProc
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLegalFileLocation`
Criteria property	`N/A`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-031 clsLegalPerson.Criteria.InsertSQL¶

clsLegalPerson.Criteria.InsertSQL — Insert operation against LEGAL_PERSON.

Classification¶

Field	Value
SQL ID	SQL-031
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalPerson`
Criteria property	`InsertSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
LEGAL_PERSON	INSERT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-032 clsLegalPersonType.Criteria.InsertSQL¶

clsLegalPersonType.Criteria.InsertSQL — Insert operation against LEGAL_PERSON_TYPE.

Classification¶

Field	Value
SQL ID	SQL-032
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalPersonType`
Criteria property	`InsertSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
LEGAL_PERSON_TYPE	INSERT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-033 clsLegalSchedule¶

clsLegalSchedule — StoredProc operation against pk80001_legalnet.insertSchedule.

Classification¶

Field	Value
SQL ID	SQL-033
Operation type	StoredProc
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLegalSchedule`
Criteria property	`N/A`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

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

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.insertSchedule(...)
-- 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-034 clsOtherFirm.Criteria.InsertSQL¶

clsOtherFirm.Criteria.InsertSQL — Insert operation against OTHER_FIRM.

Classification¶

Field	Value
SQL ID	SQL-034
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOtherFirm`
Criteria property	`InsertSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
OTHER_FIRM	INSERT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-035 clsOtherLegalParty.Criteria.InsertSQL¶

clsOtherLegalParty.Criteria.InsertSQL — Insert operation against LEGAL_CASE_EMPLOYER.

Classification¶

Field	Value
SQL ID	SQL-035
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOtherLegalParty`
Criteria property	`InsertSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
LEGAL_CASE_EMPLOYER	INSERT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-036 clsOutcomeIssue.Criteria.InsertSQL¶

clsOutcomeIssue.Criteria.InsertSQL — Insert operation against OUTCOME_ISSUE.

Classification¶

Field	Value
SQL ID	SQL-036
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOutcomeIssue`
Criteria property	`InsertSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
OUTCOME_ISSUE	INSERT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-037 clsOutcomeStaff.Criteria.InsertSQL¶

clsOutcomeStaff.Criteria.InsertSQL — Insert operation against OUTCOME_STAFF.

Classification¶

Field	Value
SQL ID	SQL-037
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOutcomeStaff`
Criteria property	`InsertSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
OUTCOME_STAFF	INSERT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-038 clsOutOFTownRotationAssgn.Criteria.InsertSQL¶

clsOutOFTownRotationAssgn.Criteria.InsertSQL — Insert operation against OUT_OF_TOWN_ROTATION_ASSGN.

Classification¶

Field	Value
SQL ID	SQL-038
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOutOFTownRotationAssgn`
Criteria property	`InsertSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
OUT_OF_TOWN_ROTATION_ASSGN	INSERT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-039 clsRequestIssue.Criteria.InsertSQL¶

clsRequestIssue.Criteria.InsertSQL — Insert operation against REQUEST_ISSUE.

Classification¶

Field	Value
SQL ID	SQL-039
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsRequestIssue`
Criteria property	`InsertSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
REQUEST_ISSUE	INSERT	See Sample SQL below

Sample SQL¶

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

Sources¶

SAIF.Business.Claim.Legal\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.