Table Description
Case Closure: The closure date, reason and comments for a case.

This table holds a type of case event. Events are displayed in an events calendar for viewing by the user.

Example

User Ronan Rooney closes a case for John Smith as it was determined that John Smith was no longer eligible to receive payment.

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::Core::Reference Model::Case::Entity Objects::Case Closure::CaseClosure
Controlling File: core\model\Packages\Case\Case Closure_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
LAST_UPDATED_FIELDyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
caseClosureIDkeynoID for the case closure recordCASE_CLOSURE_ID SVR_INT64
caseIDdetailsnothe ID of the caseCASE_ID SVR_INT64
closureDatedetails the date of closureCURAM_DATE SVR_DATE
reasonCodedetails the reason for the case closure, from code table CaseCloseReasonCASE_CLOSE_REASON_CODECaseCloseReasonSVR_STRING<10>
recordStatusdetails record status from the code table RecordStatusRECORD_STATUS_CODERecordStatusSVR_STRING<10>
actualOutcomedetails Code value to denote the result of the case.OUTCOME_ACHIEVED_CODEOutcomeAchievedSVR_STRING<10>
notesIDdetailsyesthe ID of the closure noteNOTES_ID SVR_INT64
Foreign Keys (1)
ChildParent
CaseClosure.caseIDCaseHeader.caseID
Indices (1)
Index NameAttributes
CaseClosureIdxcaseID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchForPendingnsmulti Method which reads records whose closure date is before the date supplied and whose associated case has the status suppliedSQL
modifyReasonCodensmodify Modifies reason code. 
countNumberOfPendingCasesbyStatusns ount all the records of cases by cases status.SQL
Related Pages (249)
Acknowledge Receipts (Appeal_acknowledgeReceipts)
Acknowledge Receipts (Appeal_acknowledgeReceiptsAppellant)
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)
Adjourn Hearing (Appeal_adjournHearing)
Adjourn Hearing (Appeal_adjournHearingForIC)
Adjourn Hearing (Appeal_adjournHearingReview)
Approve Resolution (Appeal_approveDecision)
Approve Resolution (Appeal_approveResolution)
Cancel Appeal Hearing (Appeal_cancelHearingCase)
Cancel Hearing Case (Appeal_cancelHearingIssueCase)
Cancel Hearing Review (Appeal_cancelHearingReview)
Cancel Judicial Review (Appeal_cancelJudicialReview)
Close an Appeal Case (Appeal_close)
Close Judicial Review (Appeal_closeJudicialReview)
Close Judicial Review (Appeal_closeJudicialReview1)
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)
New Appellant (Appeal_createAppellant)
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 Interpreter (Appeal_createInterpreter)
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)
Attach Statement (Appeal_createStatement)
New Third Party (Appeal_createThirdParty)
New Witness (Appeal_createWitness)
New Case Appeal (Appeal_createWizard)
Remove Appellant (Appeal_deleteAppellant)
Edit Hearing Representative Fee (Appeal_IC_modifyHearingReviewRepresentativeFee)
Edit Fee (Appeal_IC_modifyRepresentativeFee)
Edit Appeal Case Closure Details (Appeal_modifyClosureDetails)
Edit Hearing Representative Fee (Appeal_modifyRepresentativeFee)
Edit Witness (Appeal_modifyWitnessFromList)
Edit Witness (Appeal_modifyWitnessFromListIC)
Edit Witness (Appeal_modifyWitnessFromView)
Edit Witness (Appeal_modifyWitnessFromViewIC)
New Case Appeal (Appeal_newCaseAppeal)
New Appeal (Appeal_nextStageAppeal)
Remove Third Party (Appeal_removeThirdParty)
Reschedule Desk-Based Hearing (Appeal_rescheduleDeskHearing)
New Desk-Based Hearing (Appeal_scheduleDeskHearing)
New Desk-Based Hearing (Appeal_scheduleIssueDeskHearing)
Submit Resolution (Appeal_submitDecision)
Submit Resolution For Approval (Appeal_submitResolutionForApproval)
Reject Appealed Case (AppealedCase_rejectCase)
New Program Appeal (AppealWizard_createAppeal)
New Determination Appeal (AppealWizard_DeterminationCreateAppeal)
New Pro Forma Communication (Application_createProFormaCommunication)
Sample Benefit Home (BenefitSample_home)
Home (BenefitSampleOverpayment_home)
New Email Communication (Case_createEmailCommunication)
New Free Form Communication (Case_createFreeFormCommunication)
Create Pro Forma Communication: (Case_createProForma)
New Pro Forma Communication (Case_createProFormaCommunication)
New Pro Forma Communication (Case_createProFormaCommunication1)
New Referral (Case_createReferral)
Edit Referral (Case_modifyReferralFromList)
Edit Referral (Case_modifyReferralFromView)
Record Communication (Case_recordCommunication)
Issue Home (Case_viewIssuesTransaction)
Home (CashAssistance_productDeliveryHome)
Home (CHIPPremiums_productHome)
Add Member (CHIPProduct_addAssistanceGroupMember)
Add Member (CHIPProduct_addBenefitGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Assistance (CHIPProduct_listAssistanceGroupMember)
Assistance (CHIPProduct_listBenefitGroupMember)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
Close Case (CHIPProductDelivery_close)
Modify Case Closure (CHIPProductDelivery_modifyClose)
Reactivate Case (CHIPProductDelivery_reactivate)
View Case Closure (CHIPProductDelivery_viewClose)
Home (CREOLECA_productDeliveryHome)
Home (CREOLEFA_productDeliveryHome)
Home (CREOLEMA_productDeliveryHome)
Home (DefaultIC_home)
Related Cases (DefaultIC_listCaseRelationship)
Close Case (DefaultICProduct_close)
Home (DefaultICProduct_home)
Print Pro Forma Communication (ExternalParty_confirmModifyPrintForProFormaCommunication)
Print Pro Forma Communication (ExternalParty_confirmModifyPrintForProFormaCommunication1)
Edit External Party (ExternalParty_modifyExternalParty)
Edit Pro Forma Communication (ExternalParty_modifyProFormaCommunicationFromView1)
Register External Party (ExternalParty_register)
Cancel Payment (Financial_cancelPayment)
Cancel Payment (Financial_cancelPayment1)
Cancel Issued Payment (Financial_cancelPaymentInstrument)
Reverse Instruction (Financial_createInstructionReversal)
Reverse Details (Financial_createLineItemReversal)
Invalidate Payment (Financial_invalidatePayment)
Home (FoodStamps_productDeliveryHome)
Home (HCRChildrenHealthInsurancePlan)
Home (HCREmergencyMedicaidHome)
Home (HCREmployerSponsoredInsuraceHome)
Home (HCRExemptionHome)
Home (HCRIC_home)
Home (HCRInsuranceAssistance)
Check Retroactive Medicaid Eligibility (HCRRetroactiveMedicaid_confirmCheckEligibilty)
Home (HCRStateBasicHealthPlanPDHome)
Home (HCRUnassistedQualifiedHealthPlanHome)
Home (ICBenefitUnderPayment_home)
Home (ICInvestigationSample_home)
Close Case (ICProductSample_close)
Home (ICProductSample_home)
Close Case (ICSportingGrantSample_close)
Home (ICSportingGrantSample_home)
Confirm Appointment: (IncomeScreening_confirmAppointment)
Close Case: (IncomeSupportScreening_close)
Confirm Appointment: (IncomeSupportScreening_createAppointment)
Eligibility Summary Communication: (IncomeSupportScreening_generateEligibilitySummaryComm)
New Program Appeal (IntakeAppealWizard_createAppeal)
New Referral (IntegratedCase_createReferral)
Edit Referral (IntegratedCase_modifyReferralFromList)
Edit Referral (IntegratedCase_modifyReferralFromView)
- (Investigation_homeTabDetails)
Investigation_homeTabDetailsPreview
Close Investigation (InvestigationDelivery_close)
Change Closure Details (InvestigationDelivery_modifyClose)
View Case Closure (InvestigationDelivery_viewClose)
Home (InvestigationSample_home)
Cancel Sanction (ISP_cancelSanctionEvidence)
Cancel Disregard (ISP_cancelSanctionOverride)
Retroactive Program Summary (ISP_createRetroactiveProgram)
New Sanction (ISP_createSanctionEvidence)
New Disregard (ISP_createSanctionOverride)
Edit Sanction (ISP_modifySanctionEvidence_fromList)
Edit Sanction (ISP_modifySanctionEvidence_fromView)
Edit Disregard (ISP_modifySanctionOverride_fromList)
Modify Sanction Override Details: (ISP_modifySanctionOverride_fromView)
Case Home (ISP_productHome)
Deny Spend Down Period (ISP_reasonSpendDownNotMet)
Check Retroactive Medical Assistance Eligibility (ISPCheckRetroactiveEligibilityPDHomeFromMenu)
Close Case (ISPSpendDown_closeProgram)
Medical Assistance with Spend Down Program Summary (ISPSpendDown_createProgram)
Create Program (ISPSpendDown_createRetroactiveProgram)
Reuse Program (ISPSpendDown_reuseProgram)
Reuse Program (ISPSpendDown_reuseRetroactiveProgram)
Approve Resolution (IssueDelivery_approveResolution)
Close Issue (IssueDelivery_close)
Home (IssueDelivery_home)
Issue Home (IssueDelivery_homeForAppeal)
Change Closure Details (IssueDelivery_modifyClosureDetails)
Submit Resolution for Approval (IssueDelivery_submitResolutionForApproval)
Issue Closure Details (IssueDelivery_viewClosureDetails)
Issue Closure Details (IssueDelivery_viewClosureDetailsViewOnly)
Close Case (LegalAction_close)
Schedule Hearing (LegalAction_scheduleHearing)
Liability Overbilling Home (LiabilityOverbilling_home)
Sample Liability Home (LiabilitySample_home)
Sample Liability Home: (LiabilitySample_tabDetails)
Print Pro Forma Communication (Participant_confirmModifyPrintForProFormaCommunication)
Print Pro Forma Communication (Participant_confirmModifyPrintForProFormaCommunication1)
Preview Pro Forma Communication (Participant_confirmPreviewForProFormaCommunication)
Print Pro Forma Communication (Participant_confirmPrintForProFormaCommunication)
New Free Form Communication (Participant_createFreeFormCommunication)
Reverse Line Item (Participant_createLineItemReversal)
New Pro Forma Communication (Participant_createProFormaCommunication)
New Pro Forma Communication (Participant_createProFormaCommunication1)
Edit Pro Forma Communication (Participant_modifyProFormaCommunicationFromList1)
Edit Pro Forma Communication (Participant_modifyProFormaCommunicationFromView1)
Edit Pro Forma Communication (Participant_modifySentProFormaCommunicationFromList)
Edit Pro Forma Communication (Participant_modifySentProFormaCommunicationFromView)
View Pro Forma Communication (Participant_viewProFormaCommunication)
Home (PaymentCorrection_home)
Benefit Underpayment Home (PDBenefitUnderPayment_home)
Close Case (ProductDelivery_close)
Edit Case Closure (ProductDelivery_modifyClose)
Case Closure Details (ProductDelivery_pendingClosureDetailsTransaction)
Reactivate Case (ProductDelivery_reactivate)
Reassess (ProductDelivery_reassessBenefit)
View Case Closure (ProductDelivery_viewClose)
View Case Closure (ProductDelivery_viewCloseInline)
View Case Closure (ProductDelivery_viewCloseViewOnly)
Home (ProviderManagement_investigationHome)
- (ProviderManagement_viewProviderInvestigationTabDetails)
Register External Party (RegisterExternalParty_registerWizard)
New Disregard (SanctionAssessment_createDisregard_CREOLE)
New Sanction (SanctionAssessment_createSanction_CREOLE)
Edit Sanction (SanctionAssessment_modifySanction)
Edit Recommendation Disregard (SanctionAssessment_modifySanctionOverride)
Close Case (Screening_closeCase)
Clone Service Plan (ServicePlanDelivery_clone)
Close Service Plan (ServicePlanDelivery_close)
Modify Plan Closure Details (ServicePlanDelivery_modifyClose)
Modify Plan Closure Details (ServicePlanDelivery_modifyClose1)
Close Service Plans (ServicePlanGroupDelivery_close)
Print Pro Forma Communication (SocalEnterpriseFolder_confirmPrintProFormaCommunication)
New Pro Forma Communication (SocialEnterpriseFolder_createProFormaCommunication)
Edit Pro Forma Communication (SocialEnterpriseFolder_modifyProFormaCommunication)
Modify Pro Forma Communication: (SocialEnterpriseFolder_modifyProFormaCommunicationFromView)
Home (StreamlinedMedicaid_home)
Close Case (TBBCCProductDelivery_close)
Modify Case Closure (TBBCCProductDelivery_modifyClose)
Reactivate Case (TBBCCProductDelivery_reactivate)
View Case Closure (TBBCCProductDelivery_viewClose)