Table Description
ISP Case Decision Set Processing: A case decision set for each eligibility determination request for a case.

The case decision set processing entity is used to categorize and store additional information related to the decision results for each eligibility determination request for a case. The decisions for each eligibility determination request are grouped within a CaseDecisionSet record.

Example

When an eligibility determination request is initiated to check eligibility for all medical assistance programs a is inserted for the case with an eligibilityExecutionMode of 'Check Eligibility'. When a retroactive eligibility determination request is initiated a record is inserted for the integrated case with an eligibilityExectionMode of 'Retroactive Check Eligibility'.

These records are then used, for example, to ensure that the correct previous decisions are superseded as part of the eligibility determination processing. They are also used to filter the list of decisions displayed in, for example, the view retroactive eligibility decision list pages.

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::Income Support Product::Service Layer::entity::Processing::ISPCaseDecisionSetProc::ISPCaseDecisionSetProc
Controlling File: ISProduct\model\Service Layer\entity\Processing\ISPCaseDecisionSetProc\ISPCaseDecisionSetProc_cat.efx
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
caseDecisionSetProcIDkeynoSystem generated unique identifier for an ISP case decision set processing.INTERNAL_ID SVR_INT64
caseIDdetailsnoThe unique ID of the case to which the ISPCaseDecisionSetProc refers.CASE_ID SVR_INT64
caseDecisionSetInstanceIDdetails Unique ID for this instance of the case eligibility check process in order to allow the linking of case decisions for the different assistance unit combinations on the case in a number of case decision set records.CASE_DECISION_SET_INSTANCE_ID SVR_INT64
eligibilityExecutionModedetails The execution mode of the eligibility check, for example 'Renewal' and 'Retroactive check eligibility'.MA_ELIGIBILITY_EXECUTION_MODEEligibilityExecutionModeSVR_STRING<10>
applicationDatedetails Date on which application is made.CURAM_DATE SVR_DATE
Foreign Keys (1)
ChildParent
ISPCaseDecisionSetProc.caseIDCaseHeader.caseID
Indices (2)
Index NameAttributes
caseDecisionSetProcIDXcaseDecisionSetInstanceID
IND_676942564caseID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
readDetailsByCaseIDAndInstanceIDnsread Reads one row of details by case id and instance id. 
readAppDateAndEligibilityExModeByCaseDecisionIDns Returns the application date and the eligibility execution mode fields for the provided case decision id.SQL
Related Pages (23)
Intake Home (ApplicationHome)
Intake Home (ApplicationHomeDetails)
Program Summary (Eligibility_createProgram)
Eligibility Checks (Eligibility_listExistingEligibleResults)
Eligibility Checks (Eligibility_listExistingEligibleResultsForIC)
Check Retroactive Spend Down Eligibility (ISP_checkSpendDownRetroactiveEligibility)
Retroactive Program Summary (ISP_createRetroactiveProgram)
Eligibility Results (ISP_ListEligibilityResults)
Retroactive Medical Assistance Eligibility Results (ISP_listRetroactiveMedicalAssistanceEligibilityResults)
Retroactive Periods (ISP_listRetroactivePeriods)
Sanction Recommendation Results (ISP_ListSanctionAssessmentResults)
Retroactive Medical Assistance Eligibility Result (ISP_viewCurrentRetroactiveMedicalAssistanceEligibilityResults)
Retroactive Spend Down Eligibility Result (ISP_viewCurrentRetroactiveSpendDownEligibilityResults)
Retroactive Medical Assistance Ineligible Results (ISP_viewIneligibleRetroactiveDecisions)
Retroactive Spend Down Ineligible Results (ISP_viewIneligibleRetroactiveSpendDownDecisions)
Medical Assistance with Spend Down Eligibility Result (ISP_viewMedicalAssistanceWithSDEligibilityDetails)
Retroactive Medical Assistance Eligibility Result (ISP_viewRetroactiveMedicalAssistanceEligibilityDetails)
Medical Assistance with Spend Down Retroactive Eligibility Result (ISP_viewRetroactiveMedicalAssistanceWithSDEligibilityDetails)
Retroactive Spend Down Eligibility Result (ISP_viewRetroactiveSpendDownMedicalAssistanceEligibilityDetails)
Medical Assistance with Spend Down Program Summary (ISPSpendDown_createProgram)
Create Program (ISPSpendDown_createRetroactiveProgram)
Reuse Program (ISPSpendDown_reuseProgram)
Reuse Program (ISPSpendDown_reuseRetroactiveProgram)