DB-CLL-010 — Insert a new appeal record
Classification
Field
Value
SQL ID
DB-CLL-010
Operation type
I
Execution method
StoredProc
Database
Oracle (Case Management)
Schema
[unqualified]**
Command type
Stored procedure call
Business object
clsAppeal
Criteria property
InsertSQL
Lifecycle method
BeforeInsert
Parameters
Name
Direction
Type
Default
Description
AppealID
ReturnValue
NUMBER
N/A
New appeal identifier assigned on insert
LegalCaseID
Input
NUMBER
N/A
Owning legal case identifier
AppealDate
Input
DATE
N/A
Date the appeal was filed
AppealTypeCode
Input
VARCHAR2
N/A
Type of appeal
FiledByCode
Input
VARCHAR2
N/A
Code identifying who filed the appeal
ReviewLevelCode
Input
VARCHAR2
N/A
Review level for the appeal
HearingLocationSeqNum
Input
NUMBER
N/A
Hearing location identifier
ScheduleDate
Input
DATE
N/A
Scheduled hearing/review date
DecisionDate
Input
DATE
N/A
Date a decision was rendered
DecisionCode
Input
VARCHAR2
N/A
Decision outcome code
ExtensionDate
Input
DATE
N/A
Extension date, if granted
Tables
Table
Access
Columns/Notes
APPEAL INSERT
19 columns (inferred*)
Sample SQL
EXEC pk80001_legalNet . insertAppeal (: AppealID OUT , : LegalCaseID , : AppealDate , : AppealTypeCode ,
: FiledByCode , : ReviewLevelCode , : HearingLocationSeqNum , : ScheduleDate , : DecisionDate ,
: DecisionCode , : ExtensionDate , : Comments , : CreateUser , : CreateDate ,
: SummaryText , : RequestTypeCode , : PetitionerRespondentCode , : UpdateUser , : UpdateDate ); -- final 5 params inferred from remaining appeal-detail columns*
Operations and processes
Business rules
Sources
SAIF.Business.Claim.Legal\LegalNet\clsAppeal.vb