Table Description
Case Appeal: A request, made by a party to a case, to change a decision on that case.

This table holds a type of case event. Events are displayed in an events calendar for viewing by the user.

Example

John Smith was in receipt of a program called 'sickness benefit'. Following a review of the case by the organization, it was decided to cease payment to John Smith on the basis that it was a fraudulent claim. John Smith initiates an appeal against this decision.
Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Case::Entity Objects::CaseAppeal::CaseAppeal
Controlling File: core\model\Packages\Case\Case Appeal_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (16)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
appealIDkeynoUnique reference number assigned by the system to a Case Appeal record.APPEAL_ID SVR_INT64
caseIDdetailsnoCaseID of the CaseHeader in respect of which this CaseAppeal was enteredCASE_ID SVR_INT64
serviceSupplierIDdetailsyesThe Concern Role ID of the Service Supplier providing this Appeal.CONCERN_ROLE_ID SVR_INT64
concernCaseRoleIDdetailsnoUnique ID of the ConcernCaseRole created for the CaseAppeal.CONCERN_CASE_ROLE_ID SVR_INT64
contactdetails Free text used to record the name, address and telephone number of the User/Person/Department/Agency to contact in relation to the Appeal.APPEAL_CONTACT SVR_STRING<50>
typeCodedetails Code value to indicate the type of Appeal.CASE_APPEAL_TYPE_CODECaseAppealTypeSVR_STRING<10>
startDatedetails Commencement Date of Appeal.CURAM_DATE SVR_DATE
endDatedetails Expiry Date of Appeal.CURAM_DATE SVR_DATE
notificationDatedetails Date Organization was notified that an Appeal has commenced.CURAM_DATE SVR_DATE
outcomeCodedetails Code value to denote the result of the Case Appeal.CASE_APPEAL_OUTCOME_CODECaseAppealOutcomeSVR_STRING<10>
statusCodedetails Code value to denote the status of the Appeal.CASE_APPEAL_STATUS_CODECaseAppealStatusSVR_STRING<10>
documentRefNodetails Reference number to locate the physical document.DOCUMENT_REFERENCE_NUMBER SVR_STRING<16>
expectCompleteDatedetails Estimated End Date for the Case Event.CURAM_DATE SVR_DATE
reasonTextdetails The details of the reason for this appeal.REASON_TEXT SVR_STRING<200>
fileReferenceNodetails Reference number to locate the physical file.FILE_REFERENCE_NUMBER SVR_STRING<32>
ticketIDdetails The ID for the ticket generated for the AppealWM_TICKET_ID SVR_INT64
Foreign Keys (3)
ChildParent
CaseAppeal.caseIDCaseHeader.caseID
CaseAppeal.concernCaseRoleIDCaseParticipantRole.caseParticipantRoleID
CaseAppeal.serviceSupplierIDServiceSupplier.concernRoleID
Indices (2)
Index NameAttributes
CAppealCaseIDIdxcaseID
CaseAppealIdxconcernCaseRoleID, serviceSupplierID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
searchByCaseIDreadmulti Search Case Appeals by Case ID. 
searchByCaseIDAndStatusnsmulti Search Case Appeals by Case ID and Status.SQL
Related Pages (5)