SQL-040 to SQL-119: Read operations — business objects and collections¶

This page documents all 80 Read-type SQL operations for business objects and collections (SQL-040 through SQL-119). Code-table read statements (SQL-120 through SQL-150) are documented on a separate page. Stored-procedure reads have their body retrieval marked unavailable for this run (Legends CLI offline); see Procedures.

SQL-040 clsAcknowledgeList.GetList¶

clsAcknowledgeList.GetList — stored procedure call retrieving from pk80001_legalnet.getAcknowledgeList.

Classification¶

Field	Value
SQL ID	SQL-040
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAcknowledgeList`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

SAIF.Business.Claim.Legal\Print\clsAcknowledgeList.vb

SQL-041 clsAppeal.Criteria.RetrieveSQL¶

clsAppeal.Criteria.RetrieveSQL — stored procedure call retrieving from pk80001_legalnet.getAppeal.

Classification¶

Field	Value
SQL ID	SQL-041
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAppeal`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.getAppeal(...)
-- 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-042 clsAppealExtension collection¶

clsAppealExtension collection — stored procedure call retrieving from pk80001_legalnet.getAppeal (extension cursor).

Classification¶

Field	Value
SQL ID	SQL-042
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAppealExtension collection`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.getAppeal (extension cursor)(...)
-- 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-043 clsAssignmentProcess.CalendarReview¶

clsAssignmentProcess.CalendarReview — stored procedure call retrieving from pk80005_assignment.CalendarReview.

Classification¶

Field	Value
SQL ID	SQL-043
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAssignmentProcess`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-044 clsAssignmentProcess.calendar_review¶

clsAssignmentProcess.calendar_review — stored procedure call retrieving from pk80005_assignment.calendar_review.

Classification¶

Field	Value
SQL ID	SQL-044
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAssignmentProcess`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-045 clsAssignmentProcess.get_assign_list¶

clsAssignmentProcess.get_assign_list — stored procedure call retrieving from pk80005_assignment.get_assign_list.

Classification¶

Field	Value
SQL ID	SQL-045
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAssignmentProcess`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-046 clsAssignmentProcess.get_assign_results¶

clsAssignmentProcess.get_assign_results — stored procedure call retrieving from pk80005_assignment.get_assign_results.

Classification¶

Field	Value
SQL ID	SQL-046
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAssignmentProcess`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-047 clsAssignmentProcess.get_results¶

clsAssignmentProcess.get_results — stored procedure call retrieving from pk80005_assignment.get_results.

Classification¶

Field	Value
SQL ID	SQL-047
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAssignmentProcess`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-048 clsAssignmentProcess.max_result_seq¶

clsAssignmentProcess.max_result_seq — stored procedure call retrieving from pk80005_assignment.max_result_seq.

Classification¶

Field	Value
SQL ID	SQL-048
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAssignmentProcess`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-049 clsAssignmentProcess.getOutlookFields¶

clsAssignmentProcess.getOutlookFields — stored procedure call retrieving from pk80005_assignment.getOutlookFields.

Classification¶

Field	Value
SQL ID	SQL-049
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAssignmentProcess`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-050 clsAssignmentProcess.getConsolFileLocation¶

clsAssignmentProcess.getConsolFileLocation — stored procedure call retrieving from pk80005_assignment.getConsolFileLocation.

Classification¶

Field	Value
SQL ID	SQL-050
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAssignmentProcess`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-051 clsAttorneyConflict.Criteria.RetrieveSQL¶

clsAttorneyConflict.Criteria.RetrieveSQL — inline SELECT retrieving from ATTORNEY_CONFLICT.

Classification¶

Field	Value
SQL ID	SQL-051
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneyConflict`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
ATTORNEY_CONFLICT	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-052 clsAttorneyConflictCollection.GetAttorneyConflicts¶

clsAttorneyConflictCollection.GetAttorneyConflicts — inline SELECT retrieving from ATTORNEY_CONFLICT + joins.

Classification¶

Field	Value
SQL ID	SQL-052
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneyConflictCollection`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
ATTORNEY_CONFLICT	SELECT	See Sample SQL below
ADP_EMPLOYEE	SELECT	See Sample SQL below
PROVIDER_LOCATION	SELECT	See Sample SQL below
POLICY	SELECT	See Sample SQL below
LEGAL_PERSON	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-053 clsAttorneyConflict.getAttorneyConflictHearings¶

clsAttorneyConflict.getAttorneyConflictHearings — stored procedure call retrieving from pk80005_assignment.getAttorneyConflictHearings.

Classification¶

Field	Value
SQL ID	SQL-053
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAttorneyConflict`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-054 clsAttorneyConflict.getAttorneyPastHearings¶

clsAttorneyConflict.getAttorneyPastHearings — stored procedure call retrieving from pk80005_assignment.getAttorneyPastHearings.

Classification¶

Field	Value
SQL ID	SQL-054
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAttorneyConflict`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-055 clsAttorneyPolicyAssignment.Criteria.RetrieveSQL¶

clsAttorneyPolicyAssignment.Criteria.RetrieveSQL — inline SELECT retrieving from ATTORNEY_POLICY_ASSIGNMENT.

Classification¶

Field	Value
SQL ID	SQL-055
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneyPolicyAssignment`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
ATTORNEY_POLICY_ASSIGNMENT	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-056 clsAttorneyPolicyAssignmentCollection.GetAttorneyPolicyAssignments¶

clsAttorneyPolicyAssignmentCollection.GetAttorneyPolicyAssignments — inline SELECT retrieving from ATTORNEY_POLICY_ASSIGNMENT + joins.

Classification¶

Field	Value
SQL ID	SQL-056
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneyPolicyAssignmentCollection`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
ATTORNEY_POLICY_ASSIGNMENT	SELECT	See Sample SQL below
ADP_EMPLOYEE	SELECT	See Sample SQL below
POLICY	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-057 clsAttorneyProfile.Criteria.RetrieveSQL¶

clsAttorneyProfile.Criteria.RetrieveSQL — stored procedure call retrieving from pk80001_legalnet.getAttyProfile.

Classification¶

Field	Value
SQL ID	SQL-057
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAttorneyProfile`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.getAttyProfile(...)
-- 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-058 clsAttorneyProfile (qualified read)¶

clsAttorneyProfile (qualified read) — inline SELECT retrieving from legal.attorney_profile.

Classification¶

Field	Value
SQL ID	SQL-058
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneyProfile (qualified read)`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
LEGAL.ATTORNEY_PROFILE	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-059 clsAttorneySchedule.Criteria.RetrieveSQL¶

clsAttorneySchedule.Criteria.RetrieveSQL — inline SELECT retrieving from ATTORNEY_SCHEDULE.

Classification¶

Field	Value
SQL ID	SQL-059
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneySchedule`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
ATTORNEY_SCHEDULE	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-060 clsAttorneyScheduleCollection.GetAttorneySchedules¶

clsAttorneyScheduleCollection.GetAttorneySchedules — inline SELECT retrieving from ATTORNEY_SCHEDULE + ADP_EMPLOYEE.

Classification¶

Field	Value
SQL ID	SQL-060
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneyScheduleCollection`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
ATTORNEY_SCHEDULE	SELECT	See Sample SQL below
ADP_EMPLOYEE	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-061 clsAttorneySchedule.getAttorneyScheduleConflict¶

clsAttorneySchedule.getAttorneyScheduleConflict — stored procedure call retrieving from pk80005_assignment.getAttorneyScheduleConflict.

Classification¶

Field	Value
SQL ID	SQL-061
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAttorneySchedule`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-062 clsAttorneyWorkerAssignment.Criteria.RetrieveSQL¶

clsAttorneyWorkerAssignment.Criteria.RetrieveSQL — inline SELECT retrieving from ATTORNEY_WORKER_ASSIGNMENT.

Classification¶

Field	Value
SQL ID	SQL-062
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneyWorkerAssignment`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
ATTORNEY_WORKER_ASSIGNMENT	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-063 clsAttorneyWorkerAssignmentCollection.GetAttorneyWorkerAssignments¶

clsAttorneyWorkerAssignmentCollection.GetAttorneyWorkerAssignments — inline SELECT retrieving from ATTORNEY_WORKER_ASSIGNMENT + ADP_EMPLOYEE.

Classification¶

Field	Value
SQL ID	SQL-063
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneyWorkerAssignmentCollection`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
ATTORNEY_WORKER_ASSIGNMENT	SELECT	See Sample SQL below
ADP_EMPLOYEE	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-064 clsAttorneyWorkerAssignment.GetWorkerAtty¶

clsAttorneyWorkerAssignment.GetWorkerAtty — stored procedure call retrieving from pk80001_legalnet.GetWorkerAtty.

Classification¶

Field	Value
SQL ID	SQL-064
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAttorneyWorkerAssignment`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-065 clsAttorneyWorkerAssignment.getWrkrAssignedAtty¶

clsAttorneyWorkerAssignment.getWrkrAssignedAtty — stored procedure call retrieving from pk80001_legalnet.getWrkrAssignedAtty.

Classification¶

Field	Value
SQL ID	SQL-065
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAttorneyWorkerAssignment`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-066 clsBoardLog.GetBoardLog¶

clsBoardLog.GetBoardLog — stored procedure call retrieving from pk80001_legalnet.getBoardLog.

Classification¶

Field	Value
SQL ID	SQL-066
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsBoardLog`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-067 clsCaseCost.Criteria.RetrieveSQL¶

clsCaseCost.Criteria.RetrieveSQL — inline SELECT retrieving from CASE_COST.

Classification¶

Field	Value
SQL ID	SQL-067
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsCaseCost`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
CASE_COST	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-068 clsCaseCostCollection.Criteria.MyRetrieveSQL¶

clsCaseCostCollection.Criteria.MyRetrieveSQL — inline SELECT retrieving from CASE_COST.

Classification¶

Field	Value
SQL ID	SQL-068
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsCaseCostCollection`
Criteria property	`MyRetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
CASE_COST	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-069 clsCaseNote.Criteria.RetrieveSQL¶

clsCaseNote.Criteria.RetrieveSQL — stored procedure call retrieving from pk80001_legalnet.GetCaseNote.

Classification¶

Field	Value
SQL ID	SQL-069
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsCaseNote`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.GetCaseNote(...)
-- 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-070 clsCaseOutcome.Criteria.RetrieveSQL¶

clsCaseOutcome.Criteria.RetrieveSQL — stored procedure call retrieving from pk80001_legalnet.GetCaseOutcome.

Classification¶

Field	Value
SQL ID	SQL-070
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsCaseOutcome`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.GetCaseOutcome(...)
-- 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-071 clsCaseOutcomeCollection.Criteria.MyRetrieveSQL¶

clsCaseOutcomeCollection.Criteria.MyRetrieveSQL — inline SELECT retrieving from CASE_OUTCOME cursor projection.

Classification¶

Field	Value
SQL ID	SQL-071
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsCaseOutcomeCollection`
Criteria property	`MyRetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-072 clsCaseSearch.CaseSearch¶

clsCaseSearch.CaseSearch — stored procedure call retrieving from pk80001_legalnet.CaseSearch.

Classification¶

Field	Value
SQL ID	SQL-072
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsCaseSearch`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-073 clsCaseSearch.findCase¶

clsCaseSearch.findCase — stored procedure call retrieving from pk80001_legalnet.findCase.

Classification¶

Field	Value
SQL ID	SQL-073
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsCaseSearch`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-074 clsCaseStatusHistory.Criteria.RetrieveSQL¶

clsCaseStatusHistory.Criteria.RetrieveSQL — inline SELECT retrieving from CASE_STATUS_HISTORY.

Classification¶

Field	Value
SQL ID	SQL-074
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsCaseStatusHistory`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
CASE_STATUS_HISTORY	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-075 clsCaseStatusHistoryCollection.Criteria.MyRetrieveSQL¶

clsCaseStatusHistoryCollection.Criteria.MyRetrieveSQL — inline SELECT retrieving from CASE_STATUS_HISTORY.

Classification¶

Field	Value
SQL ID	SQL-075
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsCaseStatusHistoryCollection`
Criteria property	`MyRetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
CASE_STATUS_HISTORY	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-076 clsConsolidations.getConsolidatedCases¶

clsConsolidations.getConsolidatedCases — stored procedure call retrieving from pk80001_legalnet.getConsolidatedCases.

Classification¶

Field	Value
SQL ID	SQL-076
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsConsolidations`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-077 clsConsolidations.checkOtherCases¶

clsConsolidations.checkOtherCases — stored procedure call retrieving from pk80001_legalnet.checkOtherCases.

Classification¶

Field	Value
SQL ID	SQL-077
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsConsolidations`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-078 clsCreateFile.createFileList¶

clsCreateFile.createFileList — stored procedure call retrieving from pk80001_legalnet.createFileList.

Classification¶

Field	Value
SQL ID	SQL-078
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsCreateFile`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

SAIF.Business.Claim.Legal\Print\clsCreateFile.vb

SQL-079 clsHearingLocation.Criteria.RetrieveSQL¶

clsHearingLocation.Criteria.RetrieveSQL — inline SELECT retrieving from HEARING_LOCATION + HEARING_LOCATION_CODE.

Classification¶

Field	Value
SQL ID	SQL-079
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsHearingLocation`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
HEARING_LOCATION	SELECT	See Sample SQL below
HEARING_LOCATION_CODE	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-080 clsHearingLocationCollection.GetHearingLocations¶

clsHearingLocationCollection.GetHearingLocations — inline SELECT retrieving from HEARING_LOCATION + HEARING_LOCATION_CODE.

Classification¶

Field	Value
SQL ID	SQL-080
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsHearingLocationCollection`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
HEARING_LOCATION	SELECT	See Sample SQL below
HEARING_LOCATION_CODE	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-081 clsHearingLocation.CanDeleteLocation¶

clsHearingLocation.CanDeleteLocation — inline SELECT retrieving from SCHEDULE count guard.

Classification¶

Field	Value
SQL ID	SQL-081
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsHearingLocation`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
SCHEDULE	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-082 clsHearingLocationInfo.Criteria.RetrieveSQL¶

clsHearingLocationInfo.Criteria.RetrieveSQL — stored procedure call retrieving from pk80001_legalnet.getHearingInfo.

Classification¶

Field	Value
SQL ID	SQL-082
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsHearingLocationInfo`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-083 clsHearingLocationInfoCollection.Criteria.MyRetrieveSQL¶

clsHearingLocationInfoCollection.Criteria.MyRetrieveSQL — inline SELECT retrieving from HEARING_LOCATION.

Classification¶

Field	Value
SQL ID	SQL-083
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsHearingLocationInfoCollection`
Criteria property	`MyRetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
HEARING_LOCATION	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-084 clsHearingLocationInfo.get_hearingID¶

clsHearingLocationInfo.get_hearingID — stored procedure call retrieving from pk80001_legalnet.get_hearingID.

Classification¶

Field	Value
SQL ID	SQL-084
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsHearingLocationInfo`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-085 clsImageAlerts.SelectImageAlertsHist¶

clsImageAlerts.SelectImageAlertsHist — stored procedure call retrieving from pk80001_legalnet.SelectImageAlertsHist.

Classification¶

Field	Value
SQL ID	SQL-085
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsImageAlerts`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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

SQL-086 clsLegalCase.Criteria.RetrieveSQL¶

clsLegalCase.Criteria.RetrieveSQL — stored procedure call retrieving from pk80001_legalnet.getLegalCase.

Classification¶

Field	Value
SQL ID	SQL-086
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLegalCase`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.getLegalCase(...)
-- 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-087 clsLegalCase.get_asgn_atty¶

clsLegalCase.get_asgn_atty — stored procedure call retrieving from pk80001_legalnet.get_asgn_atty.

Classification¶

Field	Value
SQL ID	SQL-087
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLegalCase`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.get_asgn_atty(...)
-- 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-088 clsLegalCase.get_case_issue_text¶

clsLegalCase.get_case_issue_text — stored procedure call retrieving from pk80001_legalnet.get_case_issue_text.

Classification¶

Field	Value
SQL ID	SQL-088
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLegalCase`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.get_case_issue_text(...)
-- 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-089 clsLegalCaseEmployer.Criteria.RetrieveSQL¶

clsLegalCaseEmployer.Criteria.RetrieveSQL — inline SELECT retrieving from LEGAL_CASE_EMPLOYER + OTHER_FIRM x2 + LEGAL_PERSON.

Classification¶

Field	Value
SQL ID	SQL-089
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalCaseEmployer`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
LEGAL_CASE_EMPLOYER	SELECT	See Sample SQL below
OTHER_FIRM	SELECT	See Sample SQL below
LEGAL_PERSON	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-090 clsLegalCaseEmployerCollection retrieve¶

clsLegalCaseEmployerCollection retrieve — inline SELECT retrieving from LEGAL_CASE_EMPLOYER + joins.

Classification¶

Field	Value
SQL ID	SQL-090
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalCaseEmployerCollection retrieve`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
LEGAL_CASE_EMPLOYER	SELECT	See Sample SQL below
OTHER_FIRM	SELECT	See Sample SQL below
LEGAL_PERSON	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-091 clsLegalCaseEvaluation.Criteria.RetrieveSQL¶

clsLegalCaseEvaluation.Criteria.RetrieveSQL — stored procedure call retrieving from pk80001_legalnet.getLCE.

Classification¶

Field	Value
SQL ID	SQL-091
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLegalCaseEvaluation`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.getLCE(...)
-- 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-092 clsLegalCaseEvaluationCollection.Criteria.MyRetrieveSQL¶

clsLegalCaseEvaluationCollection.Criteria.MyRetrieveSQL — inline SELECT retrieving from LEGAL_CASE_EVALUATION.

Classification¶

Field	Value
SQL ID	SQL-092
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalCaseEvaluationCollection`
Criteria property	`MyRetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
LEGAL_CASE_EVALUATION	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-093 clsLegalFileLocation.Criteria.RetrieveSQL¶

clsLegalFileLocation.Criteria.RetrieveSQL — stored procedure call retrieving from pk80001_legalnet.getFileLocation.

Classification¶

Field	Value
SQL ID	SQL-093
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLegalFileLocation`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.getFileLocation(...)
-- 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-094 clsLegalFileLocationCollection.Criteria.MyRetrieveSQL¶

clsLegalFileLocationCollection.Criteria.MyRetrieveSQL — inline SELECT retrieving from LEGAL_FILE_LOCATION.

Classification¶

Field	Value
SQL ID	SQL-094
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalFileLocationCollection`
Criteria property	`MyRetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
LEGAL_FILE_LOCATION	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-095 clsLegalPerson.Criteria.RetrieveSQL¶

clsLegalPerson.Criteria.RetrieveSQL — inline SELECT retrieving from LEGAL_PERSON.

Classification¶

Field	Value
SQL ID	SQL-095
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalPerson`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
LEGAL_PERSON	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-096 clsLegalPersonCollection.GetLegalPersons¶

clsLegalPersonCollection.GetLegalPersons — inline SELECT retrieving from LEGAL_PERSON.

Classification¶

Field	Value
SQL ID	SQL-096
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalPersonCollection`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
LEGAL_PERSON	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-097 clsLegalPerson delete-guard¶

clsLegalPerson delete-guard — inline SELECT retrieving from SUBPOENA_RECIPIENT (NOT EXISTS).

Classification¶

Field	Value
SQL ID	SQL-097
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalPerson delete-guard`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
SUBPOENA_RECIPIENT	SELECT	See Sample SQL below
LEGAL_PERSON	SELECT	See Sample SQL below

Sample SQL¶

-- Read against SUBPOENA_RECIPIENT (NOT EXISTS)
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against SUBPOENA_RECIPIENT (NOT EXISTS) in this library.*

Sources¶

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

SQL-098 clsLegalPersonList.GetLegalPersonList¶

clsLegalPersonList.GetLegalPersonList — inline SELECT retrieving from LEGAL_PERSON + LEGAL_PERSON_TYPE + LEGAL_PERSON_TYPE_CODE.

Classification¶

Field	Value
SQL ID	SQL-098
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalPersonList`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
LEGAL_PERSON	SELECT	See Sample SQL below
LEGAL_PERSON_TYPE	SELECT	See Sample SQL below
LEGAL_PERSON_TYPE_CODE	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-099 clsLegalPersonType.Criteria.RetrieveSQL¶

clsLegalPersonType.Criteria.RetrieveSQL — inline SELECT retrieving from LEGAL_PERSON_TYPE.

Classification¶

Field	Value
SQL ID	SQL-099
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalPersonType`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
LEGAL_PERSON_TYPE	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-100 clsLegalPersonTypeCollection.GetLegalPersonTypes¶

clsLegalPersonTypeCollection.GetLegalPersonTypes — inline SELECT retrieving from LEGAL_PERSON_TYPE + LEGAL_PERSON + code table.

Classification¶

Field	Value
SQL ID	SQL-100
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalPersonTypeCollection`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
LEGAL_PERSON_TYPE	SELECT	See Sample SQL below
LEGAL_PERSON	SELECT	See Sample SQL below
LEGAL_PERSON_TYPE_CODE	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-101 clsLegalSchedule.Criteria.RetrieveSQL¶

clsLegalSchedule.Criteria.RetrieveSQL — stored procedure call retrieving from pk80001_legalnet.getSchedule.

Classification¶

Field	Value
SQL ID	SQL-101
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLegalSchedule`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.getSchedule(...)
-- 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-102 clsLetterRequest case lookup¶

clsLetterRequest case lookup — inline SELECT retrieving from LEGAL.vw_cases.

Classification¶

Field	Value
SQL ID	SQL-102
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLetterRequest case lookup`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
LEGAL.VW_CASES	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

SAIF.Business.Claim.Legal\Print\clsLetterRequest.vb:730

SQL-103 clsLetterRequest.SelectLetterRequests¶

clsLetterRequest.SelectLetterRequests — stored procedure call retrieving from pk82289_legalnet_letters.SelectLetterRequests.

Classification¶

Field	Value
SQL ID	SQL-103
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLetterRequest`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

SAIF.Business.Claim.Legal\Print\clsLetterRequest.vb:1197

SQL-104 clsLetterRequest.SelectLetter¶

clsLetterRequest.SelectLetter — stored procedure call retrieving from pk82289_legalnet_letters.SelectLetter.

Classification¶

Field	Value
SQL ID	SQL-104
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLetterRequest`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

SAIF.Business.Claim.Legal\Print\clsLetterRequest.vb:1203

SQL-105 clsLetterRequest.GetWorkerInfo¶

clsLetterRequest.GetWorkerInfo — stored procedure call retrieving from pk82289_legalnet_letters.GetWorkerInfo.

Classification¶

Field	Value
SQL ID	SQL-105
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLetterRequest`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

SAIF.Business.Claim.Legal\Print\clsLetterRequest.vb:1211

SQL-106 clsMailDate.mailDateList¶

clsMailDate.mailDateList — stored procedure call retrieving from pk80001_legalnet.mailDateList.

Classification¶

Field	Value
SQL ID	SQL-106
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsMailDate`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

SAIF.Business.Claim.Legal\Print\clsMailDate.vb

SQL-107 clsOtherFirm.Criteria.RetrieveSQL¶

clsOtherFirm.Criteria.RetrieveSQL — inline SELECT retrieving from OTHER_FIRM.

Classification¶

Field	Value
SQL ID	SQL-107
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOtherFirm`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
OTHER_FIRM	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-108 clsOtherFirmCollection.GetOtherFirms¶

clsOtherFirmCollection.GetOtherFirms — inline SELECT retrieving from OTHER_FIRM + OTHER_FIRM_TYPE_CODE.

Classification¶

Field	Value
SQL ID	SQL-108
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOtherFirmCollection`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
OTHER_FIRM	SELECT	See Sample SQL below
OTHER_FIRM_TYPE_CODE	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-109 clsOtherLegalParty.Criteria.RetrieveSQL¶

clsOtherLegalParty.Criteria.RetrieveSQL — inline SELECT retrieving from LEGAL_CASE_EMPLOYER + joins.

Classification¶

Field	Value
SQL ID	SQL-109
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOtherLegalParty`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
LEGAL_CASE_EMPLOYER	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-110 clsOtherLegalPartyCollection.Criteria.MyRetrieveSQL¶

clsOtherLegalPartyCollection.Criteria.MyRetrieveSQL — inline SELECT retrieving from LEGAL_CASE_EMPLOYER + joins.

Classification¶

Field	Value
SQL ID	SQL-110
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOtherLegalPartyCollection`
Criteria property	`MyRetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
LEGAL_CASE_EMPLOYER	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-111 clsOutcomeIssue.Criteria.RetrieveSQL¶

clsOutcomeIssue.Criteria.RetrieveSQL — inline SELECT retrieving from OUTCOME_ISSUE.

Classification¶

Field	Value
SQL ID	SQL-111
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOutcomeIssue`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
OUTCOME_ISSUE	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-112 clsOutcomeIssueCollection.Criteria.MyRetrieveSQL¶

clsOutcomeIssueCollection.Criteria.MyRetrieveSQL — inline SELECT retrieving from OUTCOME_ISSUE + OUTCOME_ISSUE_CODE.

Classification¶

Field	Value
SQL ID	SQL-112
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOutcomeIssueCollection`
Criteria property	`MyRetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
OUTCOME_ISSUE	SELECT	See Sample SQL below
OUTCOME_ISSUE_CODE	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-113 clsOutcomeStaff.Criteria.RetrieveSQL¶

clsOutcomeStaff.Criteria.RetrieveSQL — inline SELECT retrieving from OUTCOME_STAFF.

Classification¶

Field	Value
SQL ID	SQL-113
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOutcomeStaff`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
OUTCOME_STAFF	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-114 clsOutcomeStaffCollection.Criteria.MyRetrieveSQL¶

clsOutcomeStaffCollection.Criteria.MyRetrieveSQL — inline SELECT retrieving from OUTCOME_STAFF.

Classification¶

Field	Value
SQL ID	SQL-114
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOutcomeStaffCollection`
Criteria property	`MyRetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
OUTCOME_STAFF	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-115 clsOutOFTownRotationAssgn.Criteria.RetrieveSQL¶

clsOutOFTownRotationAssgn.Criteria.RetrieveSQL — inline SELECT retrieving from OUT_OF_TOWN_ROTATION_ASSGN.

Classification¶

Field	Value
SQL ID	SQL-115
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOutOFTownRotationAssgn`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
OUT_OF_TOWN_ROTATION_ASSGN	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-116 clsOutOFTownRotationAssgnCollection.GetOutOfTownRotationAssgns¶

clsOutOFTownRotationAssgnCollection.GetOutOfTownRotationAssgns — inline SELECT retrieving from OUT_OF_TOWN_ROTATION_ASSGN + ADP_EMPLOYEE.

Classification¶

Field	Value
SQL ID	SQL-116
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOutOFTownRotationAssgnCollection`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
OUT_OF_TOWN_ROTATION_ASSGN	SELECT	See Sample SQL below
ADP_EMPLOYEE	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-117 clsRequestIssue.Criteria.RetrieveSQL¶

clsRequestIssue.Criteria.RetrieveSQL — inline SELECT retrieving from REQUEST_ISSUE.

Classification¶

Field	Value
SQL ID	SQL-117
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsRequestIssue`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
REQUEST_ISSUE	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

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

SQL-118 clsRequestIssueCollection.Criteria.MyRetrieveSQL¶

clsRequestIssueCollection.Criteria.MyRetrieveSQL — inline SELECT retrieving from REQUEST_ISSUE + REQUEST_ISSUE_CODE.

Classification¶

Field	Value
SQL ID	SQL-118
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsRequestIssueCollection`
Criteria property	`MyRetrieveSQL`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

Table	Access	Columns used
REQUEST_ISSUE	SELECT	See Sample SQL below
REQUEST_ISSUE_CODE	SELECT	See Sample SQL below

Sample SQL¶

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

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsRequestIssue.vb:549

SQL-119 clsSAIFAttorney.getSAIFAtty¶

clsSAIFAttorney.getSAIFAtty — stored procedure call retrieving from pk80001_legalnet.getSAIFAtty.

Classification¶

Field	Value
SQL ID	SQL-119
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsSAIFAttorney`
Criteria property	`N/A`
Lifecycle method	`BeforeRetrieve` (or equivalent collection-load method)

Tables¶

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

Sample SQL¶

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

Sources¶

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