Table Description
Appeal Process: The appeal process definition for any type of case.

An appeal process is composed of one or more appeal stages. In addition, a single case can have one or more appeal processes, each with a different start date. Both the number of appeal stages and the type of appeal which can be held at each stage of appeal case be configured.

Example

An organization defines an appeals process for an issue which has arisen on an unemployment insurance product. Three levels are assigned to the issue. A hearing review case is designated as the first level of appeal, a judicial review case as the second level of appeal and 'any' type of appeal as the final appeal level.

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::Appeals::Service Layer::entity::IssueAppealProcess::AppealProcess::AppealProcess
Controlling File: Appeal\model\Packages\Service Layer\entity\IssueAppealProcess\IssueAppealProcess_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
appealProcessIDkeynoUnique reference number assigned by the system for an appeal process record.APPEAL_PROCESS_ID SVR_INT64
caseTypeIDdetails Unique reference of the case for which this appeal process has been created.CASE_TYPE_ID SVR_INT64
caseTypedetails The type of case to which this appeal process applies.CASE_TYPE_CODECaseTypeCodeSVR_STRING<10>
startDatedetails Date on which the appeal process becomes effective.CURAM_DATE SVR_DATE
recordStatusdetails Status of the appeal process record. The values are Active or Canceled. Logical deletion is supported.RECORD_STATUSRecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
AppealStageConfiguration.appealProcessIDAppealProcess.appealProcessID
Indices (2)
Index NameAttributes
IND_1896425732caseTypeID
IND_41253745startDate
Operations (12)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: appealProcessID
AUTO_ID_KEY: APLPROS
Standard Operation 
readAllnkreadmulti   
readread Standard Operation 
modifymodify Standard Operation 
readIssueProcessnsread Reads the Appeal Processes on an issue. 
searchIssueProcessnsmulti Lists the Appeal Processes on an issue.SQL
readStartDateAndStatusDetailsnsread Reads the record status and start date of the appeal process. 
countActiveAppealProcessesLaterDatens  SQL
modifyRecordStatusnsmodify   
readProcessIDByCaseTypeIDAndStartDatens  SQL
insertAppealProcessinsert This method expects appealProcessID to be set by the caller, if not set it delegates the call to insert() which is modeled to auto generate primary key field (appealProcessID). It's preferred to call insertAppealProcess only in scenario's where caller wants to set the value of primary key by itself. 
readProcessIDByCaseTypeStartDateAndStatusnsread Reads the Appeal Process identifier using CaseType, CaseTypeID, StartDate and recordStatus. 
Related Pages (124)
Add Case to Hearing Case (Appeal_addHearingCase)
Add Case to Hearing Case (Appeal_addHearingCaseIC)
Add Case to Hearing Case (Appeal_addHearingCaseObject)
Add Hearing Review (Appeal_addHearingReviewCase)
Add Hearing Review (Appeal_addHearingReviewCaseIC)
Add Hearing Review (Appeal_addHearingReviewIssueCase)
Add Hearing Review (Appeal_addHearingReviewIssueCaseIC)
Add Hearing Review (Appeal_addHearingReviewObjectCase)
Add Issue to Hearing Case (Appeal_addIssueToHearingCase)
Add Issue to Hearing Review (Appeal_addIssueToHearingReview)
Add Issue to Judicial Review (Appeal_addIssueToJudicialReview)
Add Case to Judicial Review (Appeal_addJudicialReviewCase)
Add Case to Judicial Review (Appeal_addJudicialReviewCaseIC)
Add Case to Judicial Review (Appeal_addJudicialReviewIssueCase)
Add Case to Judicial Review (Appeal_addJudicialReviewIssueCaseIC)
Add Case to Judicial Review (Appeal_addJudicialReviewObjectCase)
Add Appealable Items to Case (Appeal_addObjectsToCase)
Adjourn Hearing (Appeal_adjournHearing)
Adjourn Hearing (Appeal_adjournHearingForIC)
Adjourn Hearing (Appeal_adjournHearingReview)
Continue Hearing (Appeal_continueHearing)
Continue Hearing (Appeal_continueHearingReviewHearing)
New Hearing (Appeal_createHearingCaseMultipleCases)
New Hearing (Appeal_createHearingCaseMultipleCasesIC)
New Hearing (Appeal_createHearingCaseObjectMultipleCases)
New Hearing Review (Appeal_createHearingReviewMultipleCases)
New Hearing Review (Appeal_createHearingReviewMultipleCasesIC)
New Hearing Review (Appeal_createHearingReviewObjectMultipleCases)
New Hearing Case (Appeal_createIssueHearingCaseMultipleCases)
New Hearing Case (Appeal_createIssueHearingCaseMultipleCasesIC)
New Hearing Review (Appeal_createIssueHearingReviewMultipleCases)
New Hearing Review (Appeal_createIssueHearingReviewMultipleCasesIC)
New Judicial Review (Appeal_createIssueJudicialReviewMultipleCases)
New Judicial Review (Appeal_createIssueJudicialReviewMultipleCasesIC)
New Judicial Review (Appeal_createJudicialReviewMultipleCases)
New Judicial Review (Appeal_createJudicialReviewMultipleCasesIC)
New Judicial Review (Appeal_createJudicialReviewObjectMultipleCases)
New Case Appeal (Appeal_createProductAppeal)
New Case Appeal (Appeal_createProductAppealParticipants)
New Case Appeal (Appeal_createWizard)
Appeal_enterAppellantAndRespondentForHearingCase
Appeal_enterAppellantAndRespondentForHearingCaseIC
New Hearing (Appeal_enterAppellantAndRespondentForHearingCaseObject)
Appeal_enterAppellantAndRespondentForHearingReview
Appeal_enterAppellantAndRespondentForHearingReviewIC
New Hearing Review (Appeal_enterAppellantAndRespondentForHearingReviewObject)
Enter Appellant And Respondent (Appeal_enterAppellantAndRespondentForIssueHearingCase)
Enter Appellant And Respondent (Appeal_enterAppellantAndRespondentForIssueHearingCaseIC)
Enter Appellant And Respondent (Appeal_enterAppellantAndRespondentForIssueHearingReview)
Enter Appellant And Respondent (Appeal_enterAppellantAndRespondentForIssueHearingReviewIC)
Enter Appellant And Respondent (Appeal_enterAppellantAndRespondentForIssueJudicialReview)
Enter Appellant And Respondent (Appeal_enterAppellantAndRespondentForIssueJudicialReviewIC)
Appeal_enterAppellantAndRespondentForJudicialReview
Appeal_enterAppellantAndRespondentForJudicialReviewIC
New Judicial Review (Appeal_enterAppellantAndRespondentForJudicialReviewObject)
- (Appeal_hearingCaseHomeForICTabDetails)
Appeal_hearingCaseHomeForICTabDetailsPreview
- (Appeal_hearingCaseHomeTabDetails)
- (Appeal_hearingReviewHomeForICTabDetails)
- (Appeal_hearingReviewHomeTabDetails)
- (Appeal_judicialReviewHomeForICTabDetails)
Appeal_judicialReviewHomeTabDetails
Appeals (Appeal_listAppealCaseCombinedList)
Appeals (Appeal_listAppealCaseForIC)
Appeals (Appeal_listAppealTypesForIC)
Edit Appealed Case (Appeal_modifyAppealedCase)
Edit Appealed Case (Appeal_modifyAppealedCaseForIC)
Edit Appealed Issue (Appeal_modifyAppealedIssueCaseForIC)
Edit Appealed Case (Appeal_modifyAppealedIssuesForIC)
Edit Appealed Case (Appeal_modifyFromViewHearingCaseAppealedCase)
Edit Appealed Case (Appeal_modifyFromViewHearingCaseAppealedCaseForIC)
Edit Appealed Case (Appeal_modifyFromViewHearingReviewAppealedCase)
Edit Appealed Case (Appeal_modifyFromViewHearingReviewAppealedCaseIC)
Edit Appealed Case (Appeal_modifyFromViewJudicialReviewAppealedCase)
Edit Appealed Case (Appeal_modifyFromViewJudicialReviewAppealedCaseIC)
Edit Hearing (Appeal_modifyHearingCase)
Edit Hearing Review (Appeal_modifyHearingReview)
Edit Judicial Review (Appeal_modifyJudicialReview)
New Case Appeal (Appeal_newCaseAppeal)
New Appeal (Appeal_nextStageAppeal)
Reopen Hearing Case (Appeal_reopenHearingCase)
Reopen Hearing Case (Appeal_reopenHearingIssueCase)
Select Appeal Decision to Appeal (Appeal_selectDecisionToAppealForJudicialReviewObject)
Select Appeal Decision to Appeal (Appeal_selectDecisionToAppealObject)
Add Determination Appeal (AppealDetermination_createAppeal)
Approve Appealed Case (AppealedCase_approveCase)
Delete Appeal Process (AppealProcessAdmin_cancelAppealProcess)
AppealProcessAdmin_listProcesses
New Appeal Process Assignment (AppealProcessAdminWizard_assignCaseTypes)
New Appeal Process Confirmation (AppealProcessAdminWizard_confirm)
New Program Appeal (AppealWizard_createAppeal)
New Determination Appeal (AppealWizard_DeterminationCreateAppeal)
New Determination Appeal (AppealWizard_DeterminationSelectParticipants)
New Program Appeal (AppealWizard_selectParticipants)
Appeals (Application_listAppeals)
ApplicationContextPanel
Appeals (BenefitSample_listAppealCombinedList)
CAProductHomeDetails
CGISSApplicationContextPanel
CGISSApplicationContextPanel1
CHIPProductHomeDetails
CREOLECAProductHomeDetails
CREOLECHIPProductHomeDetails
CREOLEFAProductHomeDetails
CREOLEMAProductHomeDetails
FAProductHomeDetails
New Program Appeal (IntakeAppealWizard_createAppeal)
New Program Appeal (IntakeAppealWizard_selectParticipants)
Appeals (ISP_listAppeals)
ISPCaseHomeDetails
New Appeal Process (Issue_createAppealProcess)
New Stage (Issue_createAppealStage)
Appeal Processes (Issue_listAppealProcesses)
Edit Appeal Stage (Issue_modifyAppealStage)
Remove Appeal Process (Issue_removeAppealProcess)
Remove Appeal Stage (Issue_removeAppealStage)
View Appeal Process (Issue_viewAppealProcess)
Appeals (LiabilitySample_listAppealCombinedList)
LIFCProductHomeDetails
LTCProductHomeDetails
ProductHomeDetails
RefugeeProductHomeDetails
SpendDownProductHomeDetails
TBBCCProductHomeDetails