Table Description
Product Appeal Process: The appeal process definition for a product.

A product appeal process is composed of one or more stages. In addition, a single product 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 are configured on the product.

Example

An organization defines an appeals process for an unemployment insurance product. Three levels are assigned to the product. 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.

Model Details
Location in Model: Logical View::MetaModel::Curam::Appeals::Service Layer::entity::ProductAppealProcess::ProductAppealProcess::ProductAppealProcess
Controlling File: Appeal\model\Packages\Service Layer\entity\ProductAppealProcess\ProductAppealProcess\ProductAppealProcess_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
productAppealProcessIDkeynoUnique ID for a product appeal process record.PRODUCT_APPEAL_PROCESS_ID SVR_INT64
productIDdetails Unique ID of the associated product. Links the appeal process to the related product.PRODUCT_ID SVR_INT64
startDatedetails Date on which a product appeal process becomes effective.CURAM_DATE SVR_DATE
recordStatusdetails Status of the product appeal process record. The values are 'Active' or 'Cancelled'.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Indices (2)
Index NameAttributes
IND__1811866174startDate
IND__733917988productID
Operations (13)
OperationStereotypeOptionsDescriptionSQL
insertinsertPRE_DATA_ACCESS: yes
Creates a new appeals process for a product. 
readAllnkreadmulti   
readread Standard Operation 
modifymodify Standard Operation 
searchActiveByProductAndStartDatensreadmultiPRE_DATA_ACCESS: yes
Search for active processes for the specified product and start date. 
modifyRecordStatusnsmodify Modifies the recordStatus for a product appeal process record. 
readProcessnsread Returns the summary details for a product appeal process. 
readStartDateAndStatusDetailsnsread Returns the start date and recordStatus for a particular product appeal process. 
searchByProductnsmulti Returns all appeals process for a product including the first stage in the appeal process if any.SQL
validateInsert  Validates the start date for a product appeal process. 
readProductIDStartDatensread Returns the start data and product for a specified product appeal process. 
readProcessIDByProductAndStartDatensPRE_DATA_ACCESS: yes
 
 SQL
insertProductAppealProcessinsert Creates a new appeals process for a product and it should be used only if the user is passing the primary id. It doesn't do any validation before inserting the record. 
Related Pages (126)
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 Appeal Process (Appeal_createAppealProcess)
New Stage (Appeal_createAppealStage)
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)
Appeal Processes (Appeal_listAppealProcesses)
Appeals (Appeal_listAppealTypesForIC)
Appeal Processes (Appeal_listBenefitAppealProcesses)
Appeal Processes (Appeal_listLiabilityAppealProcesses)
Edit Appealed Case (Appeal_modifyAppealedCase)
Edit Appealed Case (Appeal_modifyAppealedCaseForIC)
Edit Appealed Issue (Appeal_modifyAppealedIssueCaseForIC)
Edit Appealed Case (Appeal_modifyAppealedIssuesForIC)
Edit Appeal Stage (Appeal_modifyAppealStage)
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)
Remove Appeal Process (Appeal_removeAppealProcess)
Remove Appeal Stage (Appeal_removeAppealStage)
Reopen Hearing Case (Appeal_reopenHearingCase)
Reopen Hearing Case (Appeal_reopenHearingIssueCase)
Select Appeal Decision to Appeal (Appeal_selectDecisionToAppealForJudicialReviewObject)
Select Appeal Decision to Appeal (Appeal_selectDecisionToAppealObject)
View Appeal Process (Appeal_viewAppealProcess)
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
Appeals (LiabilitySample_listAppealCombinedList)
LIFCProductHomeDetails
LTCProductHomeDetails
ProductHomeDetails
RefugeeProductHomeDetails
SpendDownProductHomeDetails
TBBCCProductHomeDetails