D:AppealRelationship

Table Description

Appeal Relationship: A link between an appeal case and a case that is under appeal.

An appeal relationship record is created for each case under appeal. An appeal case can have one or more appeal relationship records associated with it.

Example

Linda Smith applies for sickness benefit with an organization. It is calculated that Linda is entitled to $40 a week. Linda is dissatisfied with this rate of payment and submits a request for appeal to the organization.

A user creates an appeal case in the system. An appeal relationship record is also created on the system for Linda's sickness benefit product delivery case. The appeal relationship record is linked to the appeal case.

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::Appeal::AppealRelationship::AppealRelationship
Controlling File:	Appeal\model\Packages\Service Layer\entity\Appeal\AppealRelationship\AppealRelationship_cat.efx

Table Options

ALLOW_OPTIMISTIC_LOCKING

yes

Attributes (18)

Attribute	Stereotype	Nullable	Description	Domain Definition	Codetable	DDL Type
appealRelationshipID	key	no	Unique ID for the appeal relationship record.	APPEAL_RELATIONSHIP_ID		SVR_INT64
appealCaseID	details	no	Unique ID of the associated appeal case. Links the appealed case to the related appeal case.	CASE_ID		SVR_INT64
caseID	details	no	Unique ID of the case header record that is created for the appeal case.	CASE_ID		SVR_INT64
priorAppealCaseID	details	yes	Unique ID of the associated prior appeal case where a resolution from that appeal case is being appealed.	CASE_ID		SVR_INT64
receivedDate	details		Date on which the request for appeal for the appealed case was received by the organization.	CURAM_DATE		SVR_DATE
receiptMethod	details		Method by which the request for appeal was made.	APPEAL_RECEIPT_METHOD_CODE	AppealReceiptMethod	SVR_STRING<10>
receiptNoticeIndicator	details		This shows whether or not the receipt of the request for appeal for the appealed case has been acknowledged.	CURAM_INDICATOR		SVR_BOOLEAN
appealedDecisionDate	details		Date on which the decision being appealed became effective.	CURAM_DATE		SVR_DATE
reasonCode	details	no	Reason for the request for appeal for the appealed case.	APPEAL_REASON_CODE	AppealReason	SVR_STRING<10>
emergencyCode	details	yes	Type of emergency, if any.	APPEAL_EMERGENCY_CODE	AppealEmergency	SVR_STRING<10>
timelyIndicator	details		This indicates whether or not the request for appeal was received in a timely manner.	CURAM_INDICATOR		SVR_BOOLEAN
registrationDate	details		Date on which the appealed case was added by a user to the appeal case in the system.	CURAM_DATE		SVR_DATE
continueBenefitsIndicator	details		This shows whether or not the appellant wishes to continue benefits while the appeal is being processed for the appealed case.	CURAM_INDICATOR		SVR_BOOLEAN
deadlineDate	details		Date for the implementation of a decision for the appealed case. This deadline is different to the overall appeal deadline date which is recorded on the Appeal entity. There is an implementation deadline date for each appealed case on an appeal case.	CURAM_DATE		SVR_DATE
resolutionCode	details		Decision resolution for the appealed case. The default value for this attribute is 'not decided'. When an appealed case is decided at a hearing, the hearing official/reviewer can record a decision resolution of either 'accepted', 'rejected' or 'remanded' for the case.	DECISION_RESOLUTION_CODE	DecisionResolution	SVR_STRING<10>
comments	details		Free-form textual comments that are entered by the user.	COMMENTS		SVR_STRING<300>
recordStatus	details	no	Status of the appeal relationship record. The values are 'Active' or 'Cancelled'.	RECORD_STATUS_CODE	RecordStatus	SVR_STRING<10>
statusCode	details		Status code of the appealed case. When a case is added to an appeal case it must be 'approved' or 'rejected' by a user with supervisor rights. With the exception of the first appealed case, an appealed case has to be manually approved before being actively considered as part of the overall appeal case.	APPEAL_RELATIONSHIP_STATUS	AppealRelationshipStatus	SVR_STRING<10>

Foreign Keys (1)

Child	Parent
AppealRelationship.appealCaseID	Appeal.caseID

Indices (2)

Index Name	Attributes
AppealCaseStatusIdx	appealCaseID, recordStatus
ApIdCsIdStsIdx	appealCaseID, caseID, recordStatus

Operations (74)

Operation	Stereotype	Options	Description	SQL
insert	insert	AUTO_ID: appealRelationshipID PRE_DATA_ACCESS: yes	Standard Operation
read	read		Standard Operation
validate			Validates that the details being entered on the AppealRelationship record are accurate and consistent.
searchOutstandingReceiptNoticeDetailsByAppealCase	nsreadmulti	PRE_DATA_ACCESS: yes	Returns all the outstanding receipt notice details for an appeal case.
countOutstandingReceiptNoticesByAppealCase	ns	PRE_DATA_ACCESS: yes	Count all appealed cases which have not had their receipt notice generated.	SQL
readByAppealCaseAndCaseAndStatus	nsread		Determine if the case is already appealed for the current appeal
searchActiveAppealByCase	nsmulti	PRE_DATA_ACCESS: yes	Determine if the appealed case is already on an active appeal case.	SQL
searchActiveAppealByCaseAndPriorAppealCase	nsmulti	PRE_DATA_ACCESS: yes	Determine if the appealed case and prior case combination is already on an active appeal case.	SQL
searchActiveDecisionsByAppealCase	nsmulti	PRE_DATA_ACCESS: yes	Retrieve the list of decisions for the appeal case	SQL
searchActiveDecisionsByCaseAndAppealType	nsmulti	PRE_DATA_ACCESS: yes	Retrieve the list of appeal decisions where the implementation case was an appealed case. Only want CLOSED appeal cases. Only want ACTIVE appealed records.	SQL
searchReasonByAppealCase	nsreadmulti		Retrieves the reason codes for all appeals associated with the specified appeal case.
searchActiveCaseOwnerByAppealCase	nsmulti	PRE_DATA_ACCESS: yes	Returns the case owner and caseID for all implementation cases directly appealed on an appeal case.	SQL
searchActivePriorCaseOwnerByAppealCase	nsmulti	PRE_DATA_ACCESS: yes	Returns the case owner and prior appeal caseID for all prior appeal cases appealed on an appeal case.	SQL
searchActiveAppealByCaseAndAppealType	nsmulti	PRE_DATA_ACCESS: yes	Determine if the appealed case and type combination is already on an active appeal case.	SQL
searchActiveAssessmentsByProductDeliveryAndAppealType	nsmulti	PRE_DATA_ACCESS: yes	Determine if there are any active appeals where an assessment for the product delivery is being appealed for the current appeal level.	SQL
searchAppealedCaseDetailsByAppealCase	nsmulti		Returns all the appealed cases for the given appealCaseID	SQL
readSummary	ns		Returns the appealed case details for a particular appealed case.	SQL
modifyReceiptNoticeIndicator	nsmodify		Modifies the receipt notice indicator of the appealed case
modifyRecordStatus	nsmodify		Modifies the record status of the appealed case
modifyDetails	nsmodify	OPTIMISTIC_LOCKING: yes PRE_DATA_ACCESS: yes	Modifies the details of an appealed case
readForModifyAppealedCase	ns		Returns the details needed for display on the modify appealed case page.	SQL
readForValidateModify	nsread		Returns the details needed for the validation before modifying an appealed case.
validateModify			validates the appealed case details to be modified
readForRemove	ns		Returns the details needed to remove the appealed case from the appeal successfully	SQL
countActiveAppealedCasesByAppealCase	ns	PRE_DATA_ACCESS: yes	Counts the number of active appealed cases which exist for an appeal case.	SQL
readResolutionAndRecordStatus	nsread		Returns the resolution code and the record status of the appealed case.
countActiveByAppealIntegratedCase	ns	PRE_DATA_ACCESS: yes	Returns any active appealed cases for the same appeal where the integrated case ID for the appealed case is the integrated Case ID for the appeal.	SQL
countActiveAppealByPriorAppealCase	ns	PRE_DATA_ACCESS: yes	Counts the number of active prior appeal cases the appealed case is already on.	SQL
countActiveAppealByCase	ns	PRE_DATA_ACCESS: yes	Counts the number of active appeal cases the appealed case is already on.	SQL
modifyStatusCode	nsmodify		Modifies the statusCode for an appeal relationship record.
readAppealCaseID	nsread		Returns the appealCaseID for an appeal relationship record.
readStatusAndRecordStatus	nsread		Returns the statusCode and the recordStatusCode for an appeal relationship record.
readResolution	ns		Returns the resolution, caseID and case reference for an appealed case.	SQL
readResolutionPriorAppeal	ns		Returns the resolution code for an appealed case together with the caseID, the caseReference for the caseID, priorAppealCaseID and the case reference for the prior appeal case.	SQL
searchActiveResolutionDetailsByAppealCase	nsmulti	PRE_DATA_ACCESS: yes	Returns the resolution details for each appealed case for an appeal case. Only active and approved appeal relationship records are returned.	SQL
readResolutionForModify	ns		Reads the appeal relationship resolution details for modification where the appealed case is not a decision on a prior appeal case.	SQL
readResolutionPriorAppealForModify	ns		Reads the appeal relationship resolution details for modification where the a decision on a prior appeal case is being appealed.	SQL
modifyResolution	nsmodify		Updates the resolutionCode for the appeal relationship record.
readAppealCaseAndAppealStatus	ns		Reads the appealCaseID and the overall appeal case status for the appeal relationship record.	SQL
searchActiveResolutionByAppealCase	nsreadmulti	PRE_DATA_ACCESS: yes	Returns all appeal relationship resolution codes for an appeal case. Only active and approved appealed cases are retrieved.
searchActiveBenefitPriorAppealAndCaseTypeByAppealCase	nsmulti	PRE_DATA_ACCESS: yes	Returns the priorAppealCaseID, caseID, caseType for the caseID, continueBenefitsIndicator, appealRelationshipID and versionNo for all active appealed cases for an appeal.	SQL
modifyOutstandingReceiptNoticeIndicatorByAppealCase	nsmodify	NO_SQL: no PRE_DATA_ACCESS: yes	Updates all outstanding receipt notices for a given appeal case.
readReceiptNoticeDetails	nsread		Reads the details for creating a receipt notice for an appealed case.
readMinActiveApprovedDeadlineDateByAppealCase	ns	PRE_DATA_ACCESS: yes	Returns the earliest deadline date from the all of the active and approved AppealRelationship records for an appeal case.	SQL
modifyRecordStatusAndStatusCode	nsmodify		Modifies the statusCode and the recordStatus for an appeal relationship record.
readCaseIDCaseTypeAndContinueBenefits	ns		Determine the caseID, caseType and continueBenefitsIndicator for an appealed case.	SQL
searchActiveDecisionsByCase	nsmulti	PRE_DATA_ACCESS: yes	Return all prior appeal case decisions for the specified case. Only want ACTIVE records and CLOSED appeal cases.	SQL
readPriorAppealByAppealCaseAndCase	nsread	PRE_DATA_ACCESS: yes	Reads the prior appeal case ID of an appealed case.
readAppealCaseIDAndAppellantType	ns		Returns the appealCaseID and the appellant type code for the given appeal relationship.	SQL
countActiveByAppealCaseAndResolution	ns	PRE_DATA_ACCESS: yes	Returns the number of appeal relationship records for an appeal case which have the specified resolution. Only active records are considered.	SQL
readAppealCaseRejectionDetails	nsread		Returns details needed for the appeal case rejection.
readActiveAppealDecisionDate	ns	PRE_DATA_ACCESS: yes	Returns the earliest decision date from all the appeal relationships associated with the given appeal.	SQL
searchDeadlineDetailsByAppealCase	nsmulti	PRE_DATA_ACCESS: yes	Returns the CaseID and Deadline Date for each appealed case which is associated with the specified appeal.	SQL
searchEarliestDeadlineDetails	nsmulti	PRE_DATA_ACCESS: yes	Returns the earliest deadline date for all of the active and approved AppealRelationship records for an appeal case. Can return more than one record when deadline dates are the same.	SQL
searchCaseIDForAppeal	nsmulti		Returns the caseID for all cases which are associated with a specified appeal case.	SQL
searchAppealedCaseResolutionDetails	nsmulti	PRE_DATA_ACCESS: yes	Returns resolution details for each appealed case on a specified appeal. Only active and approved appealed cases are retrieved.	SQL
countActiveAndApprovedAppealedCasesByAppealCase	ns	PRE_DATA_ACCESS: yes	Counts the number of approved and active appealed cases which exist for an appeal case.	SQL
searchActiveAppealedCaseDetailsByAppealCase	nsmulti	PRE_DATA_ACCESS: yes	Returns all the active appealed cases for the given appealCaseID	SQL
searchActiveDeadlineDetailsByAppealCase	nsmulti	PRE_DATA_ACCESS: yes	Returns the deadline details of all the active appealed cases of a concrete appeal case.	SQL
modifyDeadlineDate	nsmodify		Modifies the deadline value of the selected appeal relationship.
searchPriorAppealCaseIDAndCaseIDForAppealCase	nsmulti	NO_SQL: no		SQL
getProductID	nsmulti		Retrieve the products for the specified case	SQL
searchProductDeliveryIDByAppealCase	nsmulti			SQL
validateIssueModify			validates the issue appealed case details to be modified
searchIssueCaseByAppeal	nsmulti			SQL
countActiveAppealedIssuesOnAppealCase	ns			SQL
searchIssueAppealedCaseDetailsByAppealCase	nsmulti			SQL
searchAppealedIssueCaseDetailsByAppealCase	nsmulti			SQL
countAppealedIssuesOnAppealCase	ns		retrieves the number of appealed issues on an appeal case.	SQL
searchProductDeliveryByAppealCaseID	nsmulti			SQL
readAppealedCaseTypeByAppealCaseID	ns		Retrieves the case type code of the Appealed case(either Product Delivery or Issue Delivery) on which the Appeal case is created.	SQL
readTimelyIndicator	nsread		Reads the Timely Indicator for the appeal.
searchByAppealCaseAndStatus	nsreadmulti
searchByAppealCase	nsreadmulti

Related Pages (303)

Acknowledge Receipts (Appeal_acknowledgeReceipts)
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)
Add Resolution to Appealed Items (Appeal_addResolutionToAppealedItems)
Adjourn Hearing (Appeal_adjournHearing)
Adjourn Hearing (Appeal_adjournHearingForIC)
Adjourn Hearing (Appeal_adjournHearingReview)
Approve Resolution (Appeal_approveDecision)
Cancel Appeal Hearing (Appeal_cancelHearingCase)
Cancel Hearing Case (Appeal_cancelHearingIssueCase)
Cancel Hearing Review (Appeal_cancelHearingReview)
Cancel Judicial Review (Appeal_cancelJudicialReview)
Close Judicial Review (Appeal_closeJudicialReview)
Close Judicial Review (Appeal_closeJudicialReview1)
Complete Hearing (Appeal_completeDeskHearing)
Complete Hearing (Appeal_completeHearing)
Complete Hearing (Appeal_completeHearingForIC)
Complete Hearing (Appeal_completeHearingReviewHearing)
Confirm Location Hearing (Appeal_confirmExternalLocationHearingIC)
Confirm Hearing Review (Appeal_confirmHearing_HearingReviewForIC)
Confirm Hearing Review (Appeal_confirmHearingReviewHearing)
Confirm Hearing Review (Appeal_confirmHearingReviewHearingForIC)
Confirm Home Hearing (Appeal_confirmHomeHearing)
Confirm Home Hearing (Appeal_confirmHomeHearingIC)
Confirm Home Hearing (Appeal_confirmHomeHearingType)
Confirm Home Hearing (Appeal_confirmHomeHearingTypeIC)
Confirm Location Hearing (Appeal_confirmIssueExternalLocationHearingIC)
Confirm Location Hearing (Appeal_confirmIssueLocationHearingIC)
Confirm Location Hearing (Appeal_confirmLocationHearing)
Confirm Location Hearing (Appeal_confirmLocationHearingIC)
Confirm Phone Hearing (Appeal_confirmPhoneHearing)
Confirm Phone Hearing (Appeal_confirmPhoneHearingIC)
Confirm Phone Hearing (Appeal_confirmPhoneHearingType)
Confirm Phone Hearing (Appeal_confirmPhoneHearingTypeIC)
Confirm Reschedule External Location Hearing (Appeal_ConfirmReScheduleExternalLocationHearingIC)
Confirm Reschedule Hearing Review Hearing (Appeal_confirmRescheduleHearingReviewHearing)
Confirm Reschedule Hearing Review Hearing (Appeal_confirmRescheduleHearingReviewHearingForIC)
Confirm Reschedule Home Hearing (Appeal_confirmRescheduleHomeHearing)
Confirm Reschedule Home Hearing (Appeal_confirmRescheduleHomeHearingIC)
Confirm Reschedule Location Hearing (Appeal_confirmRescheduleLocationHearing)
Reschedule Hearing (Appeal_confirmRescheduleLocationHearingIC)
Confirm Reschedule Telephone Hearing (Appeal_confirmReschedulePhoneHearing)
Reschedule Telephone Hearing (Appeal_confirmReschedulePhoneHearingIC)
Confirm Reschedule Hearing Review Hearing (Appeal_confirmRescheduleReviewHearingDateTimeForIC)
Continue Hearing (Appeal_continueHearing)
Continue Hearing (Appeal_continueHearingReviewHearing)
Edit Document (Appeal_controlMSWord)
New Decision (Appeal_createDecision)
New Decision Attachment (Appeal_createDecisionAttachment)
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 Decision Attachment (Appeal_createIssueDecisionAttachment)
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)
Select Microsoft Word Template (Appeal_createMSWord)
New Case Appeal (Appeal_createProductAppeal)
New Case Appeal (Appeal_createProductAppealParticipants)
New Hearing Representative (Appeal_createRepresentative)
New Witness (Appeal_createWitness)
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)
Hearing Home (Appeal_hearingCaseDeskHearingHome)
Home (Appeal_hearingCaseDeskHearingHomeForIC)
Hearing Home (Appeal_hearingCaseHearingHomeDetails)
Home (Appeal_hearingCaseHearingHomeForIC)
Home (Appeal_hearingCaseHearingHomeViewOnly)
Appeal_hearingCaseHomeDetailsForIC
Home (Appeal_hearingCaseHomeForIC)
Home (Appeal_hearingCaseHomeForICAndCancelledInd)
- (Appeal_hearingCaseHomeForICTabDetails)
Appeal_hearingCaseHomeForICTabDetailsPreview
- (Appeal_hearingCaseHomeTabDetails)
Hearing Case (Appeal_hearingCaseHomeViewOnly)
Appeal_hearingReviewHomeForEvent
Home (Appeal_hearingReviewHomeForIC)
- (Appeal_hearingReviewHomeForICTabDetails)
- (Appeal_hearingReviewHomeTabDetails)
Hearing Review (Appeal_hearingReviewHomeViewOnly)
Hearing Review Home (Appeal_hearingReviewIssueHomeForIC)
Hearing Review Home (Appeal_hearingReviewIssueHomeViewOnly)
Hearing Home (Appeal_IC_hearingReviewHearingHome)
Hearing Home (Appeal_IC_hearingReviewHearingHomeDetails)
Hearing Home (Appeal_IC_hearingReviewHearingHomeViewOnly)
User Attendees (Appeal_IC_listHearingAttendee)
Case Reopen History (Appeal_IC_listHearingCaseIssueReopenHistory)
Case Reopen History (Appeal_IC_listHearingCaseReopenHistory)
Hearing Reviewers (Appeal_IC_listHearingReviewer)
Hearing Representatives (Appeal_IC_listHearingReviewRepresentative)
Representatives (Appeal_IC_listRepresentative)
Home (Appeal_judicialReviewHomeForEvent)
Home (Appeal_judicialReviewHomeForIC)
- (Appeal_judicialReviewHomeForICTabDetails)
Appeal_judicialReviewHomeTabDetails
Home (Appeal_judicialReviewHomeViewOnly)
Judicial Review Home (Appeal_judicialReviewIssueHomeForIC)
Judicial Review Home (Appeal_judicialReviewIssueHomeViewOnly)
Select Hearing Participant (Appeal_listActiveParticipantsIC)
Appeals (Appeal_listAppealCaseCombinedList)
Appeals (Appeal_listAppealCaseForIC)
Appeals (Appeal_listAppealTypesForIC)
Appellants (Appeal_listAppellantsForIC)
Attendees (Appeal_listAttendeeIC)
Case Decision Rejections (Appeal_listDecisionRejectionsForIC)
Appealed Cases (Appeal_listHearingCaseAppealedCases)
Appealed Cases (Appeal_listHearingCaseAppealedCasesForIC)
Appealed Issues (Appeal_listHearingCaseAppealedIssueCasesForIC)
Appealed Issues (Appeal_listHearingCaseAppealedIssuesForIC)
Hearings (Appeal_listHearingCaseHearingForIC)
Appealed Cases (Appeal_listHearingCaseIssueAppealedCasesForIC)
Hearings (Appeal_listHearingCaseIssueHearingForIC)
Third Parties (Appeal_listHearingCaseIssueThirdPartiesForIC)
Appealed Cases (Appeal_listHearingReviewAppealedCases)
Appealed Cases (Appeal_listHearingReviewAppealedCasesForIC)
Appealed Issues (Appeal_listHearingReviewAppealedIssueCasesForIC)
Appealed Issues (Appeal_listHearingReviewAppealedIssuesForIC)
Appellants (Appeal_listHearingReviewAppellants)
Case Decision Rejections (Appeal_listHearingReviewDecisionRejectionForIC)
Hearings (Appeal_listHearingReviewHearingForIC)
Appealed Cases (Appeal_listHearingReviewIssueAppealedCasesForIC)
Appellants (Appeal_listHearingReviewIssueAppellants)
Case Decision Rejections (Appeal_listHearingReviewIssueDecisionRejectionForIC)
Hearings (Appeal_listHearingReviewIssueHearingForIC)
Transcription Requests (Appeal_listHearingReviewTranscriptionIC)
Interpreters (Appeal_listInterpreterIC)
Appellants (Appeal_listIssueAppellantsForIC)
Case Decision Rejections (Appeal_listIssueDecisionRejectionsForIC)
Items Under Appeal (Appeal_listItemsUnderAppeal)
Appealed Cases (Appeal_listJudicialReviewAppealedCases)
Appealed Cases (Appeal_listJudicialReviewAppealedCasesForIC)
Appealed Issues (Appeal_listJudicialReviewAppealedIssueCasesForIC)
Appealed Issues (Appeal_listJudicialReviewAppealedIssuesForIC)
Appellants (Appeal_listJudicialReviewAppellants)
Appealed Cases (Appeal_listJudicialReviewIssueAppealedCasesForIC)
Appellants (Appeal_listJudicialReviewIssueAppellants)
Appeal Objects (Appeal_listObjectsByAppeal)
Appeal_listParticipantAttendeeIC
Interpreters (Appeal_listParticipantInterpreterIC)
Participant Phone Numbers (Appeal_listParticipantPhoneNumbersIC)
Phone Contacts (Appeal_listPhoneNumberIC)
Third Parties (Appeal_listThirdPartiesForIC)
Transcription Requests (Appeal_listTranscriptionIC)
Witnesses (Appeal_listWitnessIC)
Manage Decision (Appeal_manageDecision)
Manage Decision (Appeal_manageHearingCaseDecisionDetailsForIC)
Manage Decision (Appeal_manageHearingCaseDecisionForIC)
Manage Decision (Appeal_manageHearingCaseDecisionViewOnly)
Manage Decision (Appeal_manageHearingCaseIssueDecisionForIC)
Decisions (Appeal_manageHearingReviewDecisionForIC)
Manage Decision (Appeal_manageHearingReviewDecisionViewOnly)
Manage Decision (Appeal_manageHearingReviewIssueDecisionForIC)
Manage Decision (Appeal_manageJudicialReviewDecision)
Manage Decision (Appeal_manageJudicialReviewDecisionForIC)
Manage Decision (Appeal_manageJudicialReviewIssueDecisionForIC)
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 Microsoft Word Decision Attachment (Appeal_modifyInternalAttachment)
Edit Resolution (Appeal_modifyIssueResolution)
Edit Resolution (Appeal_modifyIssueResolutionPriorAppeal)
Edit Judicial Review (Appeal_modifyJudicialReview)
Edit Resolution (Appeal_modifyResolution)
Edit Resolution (Appeal_modifyResolutionPriorAppeal)
New Case Appeal (Appeal_newCaseAppeal)
New Appeal (Appeal_nextStageAppeal)
Remove Appealed Case (Appeal_removeHearingCaseAppealedCase)
Remove Appealed Case (Appeal_removeHearingCaseAppealedCaseForIC)
Remove Appealed Issue (Appeal_removeHearingCaseAppealedIssueCaseForIC)
Remove Appealed Issue (Appeal_removeHearingCaseAppealedIssuesForIC)
Remove Appealed Case (Appeal_removeHearingReviewAppealedCase)
Remove Appealed Case (Appeal_removeHearingReviewAppealedCaseForIC)
Remove Appealed Issue (Appeal_removeHearingReviewAppealedIssueCaseForIC)
Remove Appealed Issue (Appeal_removeHearingReviewAppealedIssuesForIC)
Remove Appealed Case (Appeal_removeJudicialReviewAppealedCase)
Remove Appealed Case (Appeal_removeJudicialReviewAppealedCaseForIC)
Remove Appealed Issue (Appeal_removeJudicialReviewAppealedIssueCaseForIC)
Remove Appealed Issue (Appeal_removeJudicialReviewAppealedIssuesForIC)
Reopen Hearing Case (Appeal_reopenHearingCase)
Reopen Hearing Case (Appeal_reopenHearingIssueCase)
Reschedule Desk-Based Hearing (Appeal_rescheduleDeskHearing)
New Desk-Based Hearing (Appeal_scheduleDeskHearing)
New Desk-Based Hearing (Appeal_scheduleIssueDeskHearing)
Select Appeal Decision to Appeal (Appeal_selectDecisionToAppeal)
Select Prior Appeal Decision (Appeal_selectDecisionToAppealForHearingCase)
Select Prior Appeal Decision (Appeal_selectDecisionToAppealForHearingCaseIC)
Select Prior Appeal Decision (Appeal_selectDecisionToAppealForHearingCaseObject)
Select Appeal Decision to Appeal (Appeal_selectDecisionToAppealForHearingReview)
Select Prior Appeal Decision (Appeal_selectDecisionToAppealForHearingReviewIC)
Select Prior Appeal Decision (Appeal_selectDecisionToAppealForIssueHearingCase)
Select Prior Appeal Decision (Appeal_selectDecisionToAppealForIssueHearingCaseIC)
Select Appeal Decision to Appeal (Appeal_selectDecisionToAppealForIssueHearingReview)
Select Prior Appeal Decision (Appeal_selectDecisionToAppealForIssueHearingReviewIC)
Select Appeal Decision to Appeal (Appeal_selectDecisionToAppealForIssueJudicialReview)
Select Prior Appeal Decision (Appeal_selectDecisionToAppealForIssueJudicialReviewIC)
Select Appeal Decision to Appeal (Appeal_selectDecisionToAppealForJudicialReview)
Select Prior Appeal Decision (Appeal_selectDecisionToAppealForJudicialReviewIC)
Select Appeal Decision to Appeal (Appeal_selectDecisionToAppealForJudicialReviewObject)
Select Appeal Decision to Appeal (Appeal_selectDecisionToAppealObject)
Submit Resolution (Appeal_submitDecision)
View Appealed Case (Appeal_viewHearingCaseAppealedCase)
View Appealed Case (Appeal_viewHearingCaseAppealedCaseForIC)
View Appealed Issue (Appeal_viewHearingCaseAppealedIssueCaseForIC)
View Appealed Issue (Appeal_viewHearingCaseAppealedIssuesForIC)
View Appealed Case (Appeal_viewHearingReviewAppealedCase)
View Appealed Case (Appeal_viewHearingReviewAppealedCaseForIC)
View Appealed Issue (Appeal_viewHearingReviewAppealedIssueCaseForIC)
View Appealed Issue (Appeal_viewHearingReviewAppealedIssuesForIC)
View Decision Attachment (Appeal_viewInternalAttachment)
View Resolution (Appeal_viewIssueResolution)
View Resolution (Appeal_viewIssueResolutionPriorAppeal)
View Appealed Case (Appeal_viewJudicialReviewAppealedCase)
View Appealed Case (Appeal_viewJudicialReviewAppealedCaseForIC)
View Appealed Issue (Appeal_viewJudicialReviewAppealedIssueCaseForIC)
View Appealed Issue (Appeal_viewJudicialReviewAppealedIssuesForIC)
View Resolution (Appeal_viewResolution)
View Resolution (Appeal_viewResolutionPriorAppeal)
Add Determination Appeal (AppealDetermination_createAppeal)
Add Determination Appeal (AppealDetermination_listDeterminationAppeals)
Approve Appealed Case (AppealedCase_approveCase)
Appealed Case Rejections (AppealedCase_listHearingCaseRejectionReason)
Appealed Case Rejections (AppealedCase_listHearingCaseRejectionReasonForIC)
Appealed Case Rejections (AppealedCase_listHearingReviewRejectionReason)
Appealed Case Rejections (AppealedCase_listHearingReviewRejectionReasonForIC)
Reject Appealed Case (AppealedCase_rejectCase)
New Program Appeal (AppealWizard_createAppeal)
New Determination Appeal (AppealWizard_DeterminationCreateAppeal)
New Determination Appeal (AppealWizard_DeterminationSelectParticipants)
New Determination Appeal (AppealWizard_listDeterminations)
New Program Appeal (AppealWizard_selectParticipants)
Appeals (Application_listAppeals)
Items Under Appeal (Application_listItemsUnderAppeal)
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 Microsoft Word Decision Attachment (LegalAction_createMSWord)
Schedule Hearing (LegalAction_scheduleHearing)
Appeals (LiabilitySample_listAppealCombinedList)
LIFCProductHomeDetails
LTCProductHomeDetails
ProductHomeDetails
RefugeeProductHomeDetails
SpendDownProductHomeDetails
TBBCCProductHomeDetails

Database Table: AppealRelationship