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