Skip to content

DB-CLL-047 — Insert a new legal case header record

Classification

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

Parameters

Name Direction Type Default Description
LegalCaseID ReturnValue NUMBER N/A New legal case identifier
ClaimID Input NUMBER N/A Claim number the legal case is associated with
CaseStatusCode Input VARCHAR2 N/A Current case status code
NatureCode Input VARCHAR2 N/A Nature/type of the legal case
FiledDate Input DATE N/A Date the case was filed
HearingLocationSeqNum Input NUMBER N/A Hearing location identifier
AttorneyLegalPersonSeqNum Input NUMBER N/A Assigned attorney legal-person identifier
AttorneyOtherFirmSeqNum Input NUMBER N/A Assigned attorney's firm identifier
AdjusterEmplid Input VARCHAR2 N/A Adjuster employee ID
ScheduleDate Input DATE N/A Scheduled hearing date

Tables

Table Access Columns/Notes
LEGAL_CASE INSERT ~39 columns

Sample SQL

EXEC pk80001_legalnet.InsertLegalCase(:LegalCaseID OUT, :ClaimID, :CaseStatusCode, :NatureCode,
  :FiledDate, :HearingLocationSeqNum, :AttorneyLegalPersonSeqNum, :AttorneyOtherFirmSeqNum,
  :AdjusterEmplid, :ScheduleDate, :ReviewLevelCode, :RequestTypeCode, :RequestedByCode,
  :OrderTypeCode, :PetitionerRespondentCode, :MailDate, :MailOARFlag, :FileCreateDate,
  :HearingSeqNum, :CreateUser, :CreateDate, :CaseTypeCode, :AppealFlag, :ConsolidatedFlag,
  :CommentText, :DecisionDate, :DecisionCode, :ExtensionDate, :OARFlag, :OARDate,
  :SecretaryEmplid, :ALJLegalPersonSeqNum, :ClosedDate, :ClosedFlag, :PriorityFlag,
  :ExpeditedFlag, :LastActivityDate, :ReconIssueFlag, :OtherStatusText);  -- final 21 params inferred from remaining legal-case detail columns*; 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\clsLegalCase.vb