DB-CLL-011 — Update an existing appeal record¶

Classification¶

Field	Value
SQL ID	DB-CLL-011
Operation type	U
Execution method	StoredProc
Database	Oracle (Case Management)
Schema	[unqualified]**
Command type	Stored procedure call
Business object	clsAppeal
Criteria property	UpdateSQL
Lifecycle method	BeforeUpdate

Parameters¶

Name	Direction	Type	Default	Description
AppealID	Input	NUMBER	N/A	Appeal identifier to update
LegalCaseID	Input	NUMBER	N/A	Owning legal case identifier
UpdateUser	Input	VARCHAR2	N/A	User performing the update
UpdateDate	Input	DATE	N/A	Update timestamp

Tables¶

Table	Access	Columns/Notes
APPEAL	UPDATE	19 columns (inferred*)

Sample SQL¶

EXEC pk80001_legalNet.updateAppeal(:AppealID, :LegalCaseID, :AppealDate, :AppealTypeCode,
  :FiledByCode, :ReviewLevelCode, :HearingLocationSeqNum, :ScheduleDate, :DecisionDate,
  :DecisionCode, :ExtensionDate, :Comments, :UpdateUser, :UpdateDate,
  :SummaryText, :RequestTypeCode, :PetitionerRespondentCode);  -- final 5 params inferred from remaining appeal-detail columns*

Operations and processes¶

Manage appeals and appeal extensions

Business rules¶

BR-CLM-LGL-005

Sources¶

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