Table Description
ISP Case Decision Summary Processing: A summary of case decisions that are made when a check eligibility request is processed.

This case decision summary processing entity is used to store summary decision details for each rule set executed as part of an eligibility determination request.

Each case decision summary can be associated with a specific concern role; where multiple concern roles are associated with a rule set execution a summary record can be created for each concern role. The summary details are used to assess household eligibility for program rule sets previously executed within the eligibility determination request. This records for each eligibility determination request are cleared on completion of the determination request processing.

Example

A household contains a family unit with a mother, father and dependent child. The eligibility determination rules execution for the LIFC program returns the family unit as eligible and mandatory for LIFC. Three summary decision records are inserted for each of the eligible household members for this rule set execution. These records are then used as part of the cascading requirements for eligibility determination to filter out household members who are eligible for other programs; in this case the eligible LIFC household members would not be assessed for ABD program eligibility as they have already been determined as eligible for LIFC.

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::ISPCaseDecisionSummaryProc::ISPCaseDecisionSummaryProc
Controlling File: ISProduct\model\Service Layer\entity\Processing\ISPCaseDecisionSummaryProc\ISPCaseDecisionSummaryProc_cat.efx
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
caseDecisionSummaryProcIDkeynoSystem generated unique identifier for an ISCaseDecisionSumPoc.INTERNAL_ID SVR_INT64
caseIDdetailsnoThe unique ID of the case to which the ISCaseDecisionSumPoc record refers.CASE_ID SVR_INT64
concernRoleIDdetailsnoThe unique ID a participant is given in a particular role within a case.CONCERN_ID SVR_INT64
tagValuedetails Contains the objective tag and associated values in a tab delimited string. This value is used as an identifier for the type of rule set the entry is for, i.e. what assessment or product the entry is for. The tag value is also used to store particular objective results for assessments. The requirement to store these results exists due to the need.TAG_VALUE_STRING SVR_STRING<4000>
decisionDatedetails The date on which the case decision was made.CURAM_DATE SVR_DATE
decisionResultCodedetails Code value to denote the Summary outcome of the Case.CASE_DECISION_RESULT_CODECaseDecisionResultCodeSVR_STRING<10>
caseDecisionSetInstanceIDdetailsnoThe instance ID.CASE_DECISION_SET_INSTANCE_ID SVR_INT64
decisionInfoCodedetails Additional optional information about the case decision.CASE_DECISION_INFO_CODECaseDecisionInfoCodeSVR_STRING<10>
Foreign Keys (2)
ChildParent
ISPCaseDecisionSummaryProc.caseIDCaseHeader.caseID
ISPCaseDecisionSummaryProc.concernRoleIDConcernRole.concernRoleID
Indices (2)
Index NameAttributes
IND__1948943328caseID
IND_1110779228concernRoleID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: caseDecisionSummaryProcID
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
countNumProgramsHHMemberEligibleInDateRangens This method will return a count of programs in the specified date range that a particular household member is eligible for. This number should only be used to determine if a household member is eligible for another program because the numbers of different programs may not be accurate since a household member can be eligible for LIFC in a number of different assistance units and therefore will have an entry for each one of these.SQL
removeByCaseIDnsremove This method removes all the entries on the ISPCaseDecisionSummaryProc table for the specified case id. 
readHHMemberAssessmentEligibilityns This method will read the ispCaseDecisionSummaryProc table and return a decision result for a household member based on the tag value, case decision set id, decision date and their concern role id. This method will find a result matching the search criteria to the nearest date up to the decision date specified in the key. This method works on the assumption that a household member will only have one entry in the table with the same case decision set id, tag value and decision date. However, it is possible to have multiple records for example in the case of LIFC where the household member could be on a number of assistance units, for this reason the method should not be used to check eligibility of products where a household member can be on multiple assistance units.SQL
readByCaseIDnsreadmulti Retrieve list of Case Decision Summary records by case id. 
Related Pages (1)