Skip to content

DB-CLL-041 — Insert a legal schedule entry

Classification

Field Value
SQL ID DB-CLL-041
Operation type I
Execution method StoredProc
Database Oracle (Case Management)
Schema [unqualified]**
Command type Stored procedure call
Business object clsLegalSchedule
Criteria property InsertSQL
Lifecycle method BeforeInsert

Parameters

Name Direction Type Default Description
LegalCaseID Input NUMBER N/A Owning legal case identifier
ScheduleDate Input DATE N/A Scheduled date
ScheduleTypeCode Input VARCHAR2 N/A Type of schedule entry

Tables

Table Access Columns/Notes
LEGAL_SCHEDULE INSERT LegalCaseID, ScheduleDate, ScheduleTypeCode, plus remaining schedule-detail/create-audit columns (inferred*)

Sample SQL

EXEC pk80001_legalnet.insertSchedule(:LegalCaseID, :ScheduleDate, :ScheduleTypeCode,
  :CreateUser, :CreateDate);  -- proc name inferred*

Operations and processes

Business rules

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

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