Table Description
IssueDelivery: A issue delivery is used to store specific data regarding the issue. All other data in relation to the issue can be stored on the caseHeader entity.

Issues can be used to record and manage information in relation to discrepancies in evidence which arise during case processing. They will be created as a new case type and as such can use the majority of existing entities to store data relating to the issue and use existing case management functionality to manage it.

Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Service Layer::IssueDelivery::Entity::IssueDelivery
Controlling File: core\model\Packages\Reference Model\Service Layer\IssueDelivery\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
caseIDkeynoUnique reference number of the case header record created for the issue.CASE_ID SVR_INT64
relatedCaseIDdetailsnoUnique reference number of the case header record for the related case, i.e. the case on which the issue was raised.CASE_ID SVR_INT64
issueConfigurationIDdetailsnoUnique reference number of the configuration in administration upon which the issue delivery case is based.ISSUE_CONFIGURATION_ID SVR_INT64
issueTypedetailsnoThe type of Issue e.g. Earned Income, Pension.ISSUE_CONFIGURATION_TYPEIssueConfigurationTypeSVR_STRING<10>
resolutionStatusdetailsyesThe current status of the resolution on the issue.RESOLUTION_STATUS_CODEResolutionStatusCodeSVR_STRING<10>
Indices (1)
Index NameAttributes
RelatedCaseIDIdxrelatedCaseID
Operations (17)
OperationStereotypeOptionsDescriptionSQL
insertinsertPOST_DATA_ACCESS: yes
This method is used to insert the Issue Delivery case details 
readread This method is used to read the Issue Delivery case details 
modifymodifyPOST_DATA_ACCESS: yes
This method is used to modify the Issue Delivery case details 
readResolutionStatusnsread Retrieves the resolution status recorded against the specified Issue Delivery case 
modifyResolutionStatusnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
This method modifies the resolution status. 
readVersionNonsread This method reads the version number for the specified issue. 
searchByRelatedCaseIDnsmulti This method retrieves a list of issue details using the related case ID, i.e. the ID of the related case on which the issues were created.SQL
searchByParticipantRoleIDIssueCaseTypeCodensmultiPRE_DATA_ACCESS: yes
 
Retrieves a list of issue cases for an Integrated Case Member.SQL
readHomePageIDIssueTypeCaseRefns Reads the home page identifier, issue type and case reference for a Issue Delivery case.SQL
readIssueTypensread This method returns the issue type of the specified issue delivery case. 
searchByIntegratedCaseIDnsmulti Retrieves the Issue details for the Integrated Case.SQL
readRelatedCaseIDnsread This method is used to retrieve the related case ID, i.e. the ID of the case which raised this issue. 
searchByConcernRoleIDnsmulti Returns all issue deliveries for a specified concern role.SQL
searchByIssueCaseRefRelatedCaseRefConcernRoleIDnsmultiPRE_DATA_ACCESS: yes
 
Operation to return issue cases based on the optional search criteria entered. At least one search criteria must be entered (can enter all the three fields). Case Reference can be an Integrated Case or a Product Delivery case. In case of Integrated Case all the Issues that exists on the Integrated Cases are displayed. In the case of Product Delivery case all the Issues that are applied to Product Delivery are displayed. If all or a combination of the search criteria are entered then the result is narrowed down. SQL
searchIssueDelByRelatedCaseIDnsmulti This method retrieves a list of issue details using the related case ID.SQL
readIssueTabDetailsns  SQL
searchActiveByRelatedCaseIDnsmulti Returns a list of the active issues related to the given case ID.SQL
Related Pages (209)
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)
Approve Resolution (Appeal_approveResolution)
Close an Appeal Case (Appeal_close)
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)
Select Microsoft Word Template (Appeal_createMSWord)
New Case Appeal (Appeal_createProductAppeal)
Add Resolution (Appeal_createResolution)
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_listAppealCaseIC)
Status history of the Issue Resolution (Appeal_listResolutionStatusHistory)
Edit Appealed Case (Appeal_modifyAppealedCase)
Edit Appealed Case (Appeal_modifyAppealedCaseForIC)
Edit Appealed Issue (Appeal_modifyAppealedIssueCaseForIC)
Edit Appealed Case (Appeal_modifyAppealedIssuesForIC)
Edit Appeal Case Closure Details (Appeal_modifyClosureDetails)
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 Issue (Appeal_modifyIssueFromView)
Edit Judicial Review (Appeal_modifyJudicialReview)
New Case Appeal (Appeal_newCaseAppeal)
New Appeal (Appeal_nextStageAppeal)
Reject Resolution (Appeal_rejectResolution)
Reopen Hearing Case (Appeal_reopenHearingCase)
Reopen Hearing Case (Appeal_reopenHearingIssueCase)
Add Issue (Appeal_searchIssue)
Search Issue (Appeal_searchIssueForHearingReview)
Search Issue (Appeal_searchIssueForJudicialReview)
Submit Resolution For Approval (Appeal_submitResolutionForApproval)
Status Details (Appeal_viewStatusDetails)
Add Determination Appeal (AppealDetermination_createAppeal)
Approve Appealed Case (AppealedCase_approveCase)
New Program Appeal (AppealWizard_createAppeal)
New Determination Appeal (AppealWizard_DeterminationCreateAppeal)
New MS Word Communication (Application_createMSWordCommunicationCaseMember)
Create Pro Forma Communication: (Application_selectProForma)
New Pro Forma Communication (Application_selectProFormaType)
Existing Cases (BenefitSample_existingCaseList)
New Microsoft Word Communication (Case_createMSWordCommunication)
New Microsoft Word Communication (Case_createMSWordCommunicationCaseMember)
Create Pro Forma Communication: (Case_selectProForma)
Create Pro Forma Communication: (Case_selectProFormaType)
New Pro Forma Communication (Case_selectProFormaType1)
Issue Home (Case_viewIssuesTransaction)
- (CHIPDecision_context)
New Product Delivery (DefaultIC_existingCaseList)
Issue Cases (DefaultIC_listIssue)
DefaultIC_tabDetails
DefaultIC_tabDetailsPreview
Existing Cases (DefaultICMember_existingCaseList)
Issues (DefaultICMember_listIssue)
Issues (DefaultICProduct_listIssue)
- (DefaultICProduct_tabDetails)
DefaultICProduct_tabDetailsPreview
- (EmergencyMedicaidDecision_context)
Issue Cases (Employer_listIssue)
- (ESIDecision_context)
- (ExemptionDecision_context)
Existing Cases (ICMember_existingCaseList)
Issues (ICMember_listIssue)
Existing Cases (ICSample_existingCaseList)
Issue Cases (ICSampleSportingGrant_listIssue)
Issues (ICSportingGrantSample_listIssue)
- (InsuranceAssistanceDecision_context)
Intake_quickSearch
New Program Appeal (IntakeAppealWizard_createAppeal)
IntegratedCase_tabDetails
IntegratedCase_tabDetailsPreview
Edit Resolution (InvestigationDelivery_modifyResolution)
Appeals: (ISProduct_listAppeal)
Edit Resolution (IssueAppeal_modifyResolution)
Add Evidence (IssueDelivery_addEvidence)
Add Evidence (IssueDelivery_addEvidenceForIC)
Add Evidence (IssueDelivery_addEvidenceForProductDelivery)
Approve Resolution (IssueDelivery_approveResolution)
Close Issue (IssueDelivery_close)
Create Issue (IssueDelivery_createIssue)
New Issue Case (IssueDelivery_createIssueForICWizard)
New Issue Case (IssueDelivery_createIssueForPDWizard)
Add Resolution (IssueDelivery_createResolution)
Events: (IssueDelivery_eventCalendar)
Events (IssueDelivery_eventCalendar1)
Events (IssueDelivery_eventCalendarForAppeal)
Home (IssueDelivery_home)
Issue Home (IssueDelivery_homeForAppeal)
Resolution Approval Requests (IssueDelivery_listApprovalRequest)
Resolution Approval Requests (IssueDelivery_listApprovalRequestForAppeal)
Attachments (IssueDelivery_listAttachment)
Attachments (IssueDelivery_listAttachmentForAppeal)
Events (IssueDelivery_listEvent)
Events (IssueDelivery_listEventForAppeal)
Notes: (IssueDelivery_listNote)
Notes (IssueDelivery_listNote1)
Notes (IssueDelivery_listNoteForAppeal)
Related Cases (IssueDelivery_listRelatedCases)
Related Cases (IssueDelivery_listRelatedCasesForAppeal)
Resolution Status History (IssueDelivery_listResolutionStatusHistory)
Tasks (IssueDelivery_listTask)
Tasks (IssueDelivery_listTaskForAppeal)
Transaction History (IssueDelivery_listTransactionLog)
User Roles (IssueDelivery_listUserRole)
User Roles (IssueDelivery_listUserRoleForAppeal)
Modify Resolution Approval Request (IssueDelivery_modifyApprovalRequestFromList)
Modify Resolution Approval Request (IssueDelivery_modifyApprovalRequestFromView)
Change Closure Details (IssueDelivery_modifyClosureDetails)
Edit Issue (IssueDelivery_modifyIssueFromList)
Edit Issue (IssueDelivery_modifyIssueFromView)
Edit Resolution (IssueDelivery_modifyResolution)
Reject Resolution (IssueDelivery_rejectResolution)
Submit Resolution for Approval (IssueDelivery_submitResolutionForApproval)
- (IssueDelivery_tabDetails)
View Resolution Approval Request (IssueDelivery_viewApprovalRequest)
View Resolution Approval Request (IssueDelivery_viewApprovalRequestViewOnly)
Issue Closure Details (IssueDelivery_viewClosureDetails)
Issue Closure Details (IssueDelivery_viewClosureDetailsViewOnly)
View Resolution Status History (IssueDelivery_viewStatusDetails)
New Microsoft Word Decision Attachment (LegalAction_createMSWord)
Existing Cases (LiabilitySample_existingCaseList)
Organization_applicationSearch
My Items of Interest (Organization_listBookmarkedCases)
Cases Owned As A User (Organization_listCaseByCurrentUser)
Cases Owned By My Organization Units (Organization_listCasesForOrgUnit)
Cases Owned By My Positions (Organization_listCasesForPosition)
Recently Approved Cases (Organization_listRecentApprovedCaseForUser)
Organization_listRecentApprovedCaseForUser1
Recently Assigned Ownership Cases (Organization_listRecentAssignedCaseForUser)
Organization_listRecentAssignedCaseForUser1
Organization_listRecentViewedCaseForUser
Organization_listUserBookmark
My Items of Interest (Organization_listUserBookmarkedCases)
My Cases (Organization_userCaseHome)
OutcomePlan_applicationSearch
New Microsoft Word Communication (Participant_createMSWordCommunication)
New Microsoft Word Communication (Participant_createMSWordCommunicationWithNoMandatoryAddress)
New Pro Forma Communication (Participant_selectProFormaType)
Issue Cases (Person_listIssue)
Issues (Person_listIssueForDuplicate)
- (ProductDelivery_tabDetails)
ProductDelivery_tabDetailsPreview
New Pro Forma Communication (SocialEnterpriseFolder_selectProFormaType)
- (StateBasicPlanDecision_context)
- (StreamlineMedicaidDecision_context)
Supervisor_casesHome
(Supervisor_caseTabDetails)
Reassign Cases (Supervisor_reassignCasesForUserWithSearch)
- (UQHPDecision_context)
Cases Owned By My Work Queues (WorkAllocation_listCasesForWorkQueue)