Table Description
Appeal Stage Configuration: A level within an appeal process.

An appeal process is made up of one or more appeal stages. An appeal stage can be defined as a specific type of appeal case. This means that only an appeal case of that type can be created for that stage of appeal. Alternatively, a generic value of Any can be selected which means that any type of appeal case can be created for this stage of appeal.

Example

An organization defines an appeal process for an issue on an income support product and defines the first stage of appeal to be a hearing case, the second stage of appeal to be also a hearing case and the third level of appeal to be 'any' type of appeal.

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::AppealStageConfiguration::AppealStageConfiguration
Controlling File: Appeal\model\Packages\Service Layer\entity\IssueAppealProcess\IssueAppealProcess_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
appealStageConfIDkeynoUnique reference number assigned by the system to an appeal stage record.APPEAL_STAGE_CONFIGURATION_ID SVR_INT64
appealProcessIDdetailsnoUnique reference number of the associated appeal process. Links the stage to the related case appeal process.APPEAL_PROCESS_ID SVR_INT64
parentStageConfIDdetails Unique reference number of the appeal stage which directly precedes the current appeal stage. It identifies the order within which the current appeal stage fits among all of the appeal stages defined for a case appeal process. An empty value means that it is the first appeal stage for an appeal process.APPEAL_STAGE_CONFIGURATION_ID SVR_INT64
appealTypeCodedetails Type of appeal case which can be held for an appeal stage. This can be a specific appeal type code (i.e. hearing case, hearing review case or judicial review case) or any appeal type. APPEAL_TYPE_CODEAppealStageAppealTypeSVR_STRING<10>
recordStatusdetails Status of an appeal stage record. The values are Active or Canceled.RECORD_STATUSRecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
AppealStageConfiguration.appealProcessIDAppealProcess.appealProcessID
Indices (1)
Index NameAttributes
IND__1770403485appealProcessID
Operations (12)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: appealStageConfID
AUTO_ID_KEY: APLPROS
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
removeremove Standard Operation 
searchIssueStagesnsreadmulti Finds the Appeal stages on an Issue. 
readLastStageIDns Reads the last Appeal stage on an Issue.SQL
modifyIssueStagensmodify Modifies an Appeal Stage on an Issue. 
modifyRecordStatusnsmodify Cancel Appeal Stage Configuration - Set record status to Deleted. 
readStatusAndProcessIDnsread Reads the AppealProcessID and record Status associated with an appealStageID 
searchActiveStageParentByProcessAndTypensmulti  SQL
insertAppealStageConfigurationinsert This method expects appealStageConfID to be set by the caller, if not set it delegates the call to insert() which is modeled to auto generate primary key field (appealStageConfID). It's preferred to call insertAppealStageConfiguration only in scenario's where caller wants to set the value of primary key by itself. 
searchActiveAppealStagesnsreadmulti   
Related Pages (128)
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)
Remove Appeal Stage (AppealProcessAdmin_cancelAppealStage)
Remove Time Constraint (AppealProcessAdmin_cancelTimeConstraint)
Add Stage (AppealProcessAdmin_createAppealStage)
List Of Stages (AppealProcessAdmin_listAppealProcessStages)
Appeal Process Time Constraints (AppealProcessAdmin_listAppealProcessTimeConstraints)
AppealProcessAdmin_listProcesses
Edit Time Constraints Configuration (AppealProcessAdmin_modifyAllTimeConstraints)
Edit Stage (AppealProcessAdmin_modifyAppealStage)
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)
Edit Appeal Stage (Issue_modifyAppealStage)
Remove Appeal Stage (Issue_removeAppealStage)
View Appeal Process (Issue_viewAppealProcess)
View Appeal Stage (Issue_viewAppealStage)
Appeals (LiabilitySample_listAppealCombinedList)
LIFCProductHomeDetails
LTCProductHomeDetails
ProductHomeDetails
RefugeeProductHomeDetails
SpendDownProductHomeDetails
TBBCCProductHomeDetails