Table Description
Case Group: A group of case members in a case.

A case group is used to group together a sub-set of the case members within a case for a particular purpose and period of time.

Example

A case is created in order to deliver an income benefit to a client. A case group of type 'Benefit' is created to establish the case members of the case that constitute the household members that should be considered as an assistance unit when determining eligibility.

Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Case::Entity Objects::Case Groups::CaseGroups
Controlling File: core\model\Packages\Case\Case Groups_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
LAST_UPDATED_FIELDyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
caseClientGroupIDkeynoThe unique ID for the CaseGroups recordINTERNAL_ID SVR_INT64
caseIDdetailsnoThe caseID of the case for which this caseGroup existsCASE_ID SVR_INT64
concernRoleIDdetailsnoThe Concern Role ID of the person who is a member of this groupCONCERN_ROLE_ID SVR_INT64
groupCodedetails The Group code representing the Group type - Benefit, Financial etc. CASE_GROUP_TYPE_CODECaseGroupTypeSVR_STRING<10>
categoryCodedetails  CASE_GROUP_CATEGORY_CODECaseGroupTypeSVR_STRING<10>
startDatedetails The date on which this concern started in this group for the caseCURAM_DATE SVR_DATE
endDatedetails The date on which this client ceased to be a member of this group for this caseCURAM_DATE SVR_DATE
Indices (3)
Index NameAttributes
CGCaseIDConcRIdIdxcaseID, concernRoleID
CaseGrStDtIndxgroupCode, startDate
IND__1348066514endDate
Operations (11)
OperationStereotypeOptionsDescriptionSQL
insertinsert This operation will insert into the Case groups entity 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchByCasereadmulti reads the list of caseGroups by caseID 
searchCaseMembersByCaseIDnsmulti Returns a list of household members for a case who are eligible to receive benefit.SQL
modifyCaseGroupEndDatensmodifyPRE_DATA_ACCESS: yes
Set the case group end date to the current date. 
searchExistingGroupCaseMemberreadmultiPRE_DATA_ACCESS: yes
Returns a list of case groups on which a person exists. 
searchCasesByMemberGroupCodeAndDatesnsmulti Returns list of cases for concern role where it has specified group code in the date range specified.SQL
searchCasesByGroupCodensmulti Returns list of cases for concern role where it has specified group code.SQL
searchCaseMembersByCaseIDAndTypensmulti Returns a list of case group members of the specified type for a case.SQL
Related Pages (237)
Add Member (addGroupMember)
Add Member (addGroupMemberLIFC)
Add Member (addGroupMemberRefugee)
Add Member (addGroupMemberRefugee1)
Delete Hearing Representative (Appeal_cancelRepresentative)
Delete Witness (Appeal_cancelWitness)
Delete Witness (Appeal_cancelWitnessIC)
New Case Appeal (Appeal_createProductAppealParticipants)
Delete Hearing Representative (Appeal_IC_cancelHearingReviewRepresentative)
Delete Hearing Representative (Appeal_IC_cancelRepresentative)
New Case Appeal (Appeal_newCaseAppeal)
New Appeal (Appeal_nextStageAppeal)
New Determination Appeal (AppealWizard_DeterminationSelectParticipants)
New Program Appeal (AppealWizard_selectParticipants)
Match Client (Application_matchClientConfirmation)
Add Client (Application_registerPersonAndAddAsClient)
Register Person (Application_registerProspectPersonAsPerson)
Register Person (BenefitSample_registerPerson)
CAPreviewPanel
CAProductHomeDetails
Delete Member (Case_cancelCaseMember)
Delete Client Role (Case_cancelClientRole)
Eligible Members (Case_listEligibleMembers)
Register Person and Create Case (Case_registerPersonAndCreateIntegratedCase)
Register Person and Create Case (Case_registerPersonAndCreateIntegratedCasePDC)
Add Member (CashAssistance_addGroupMember)
Assistance (CashAssistance_listBenefitGroupMembers)
Financial (CashAssistance_listFinancialGroupMembers)
Member (CashAssistance_listGroupMembers)
Member (CashAssistance_listPreviousCurrentGroupMembers)
Home (CashAssistance_productDeliveryHome)
Remove Member (CashAssistance_removeGroupMember)
Check Eligibility (CheckEligibility)
Check Eligibility (CheckMAEligibility)
Check Eligibility (CheckMAEligibilityFromIC)
Site Map (CHIP_EvidenceMap)
Home (CHIP_productHome)
Renew Chip Product Delivery (Chip_RenewProductDelivery)
CHIPPreviewPanel
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)
CHIPProductHomeDetails
Add Client (CommonIntake_addClient)
Remove Client (CommonIntake_cancelApplicationClient)
Details (CommonIntake_listProgramAuthorisationDetails)
Register Client (CommonIntake_registerClient)
Authorization (CommonIntake_viewApplicationAuthorization)
Home (CREOLECA_productDeliveryHome)
CREOLECAProductHomeDetails
Member (CREOLECashAssistance_listGroupMembers)
New Receipt (CREOLECHIP_createCoPaymentReceiptEvidence)
CREOLECHIPProductHomeDetails
Member (CREOLEFA_listGroupMembers)
Home (CREOLEFA_productDeliveryHome)
CREOLEFAProductHomeDetails
Member (CREOLEFoodAssistance_listGroupMembers)
Member (CREOLEMA_listGroupMembers)
Home (CREOLEMA_productDeliveryHome)
CREOLEMAProductHomeDetails
Program Summary (Eligibility_createProgram)
Eligibility Result (Eligibility_viewResults)
Eligibility Result (Eligibility_viewResultsFromIC)
Delete Company Relationship (Employer_cancelRelatedCompany)
Edit Company Relationship (Employer_modifyRelatedCompany)
New Household Relationship Evidence (EVD_addToCaseHouseholdRelationshipEvidence_sa)
New Household Relationship Evidence (EVD_addToCaseHouseholdRelationshipEvidence_wzSelAllCre)
New Household Member Evidence (EVD_createHouseholdMemberEvidence_sa)
New Spend Down Medical Expense Evidence Details (EVD_createISPSpendDownMedicalExpenseEvidence_fromCreateMedicalExpense)
New Spend Down Medical Expense Evidence Details (EVD_createISPSpendDownMedicalExpenseProductEvidence)
Edit Household Relationship Evidence (EVD_incomingModifyHouseholdRelationshipEvidence)
Edit Household Relationship Evidence (EVD_modifyHouseholdRelationshipEvidence)
Modify Spend Down Medical Expense Evidence Details (EVD_modifyISPSpendDownMedicalExpenseProductEvidence)
FAPreviewPanel
FAProductHomeDetails
Add Member (FoodAssistance_addGroupMember)
Assistance (FoodAssistance_listBenefitGroupMembers)
Financial (FoodAssistance_listFinancialGroupMembers)
Member (FoodAssistance_listGroupMembers)
Member (FoodAssistance_listPreviousCurrentGroupMembers)
Remove Member (FoodAssistance_removeGroupMember)
Home (FoodStamps_productDeliveryHome)
GeneralMAPreviewPanel
GenericPreviewPanel
Add Member (HCRAddMemberWizard_summary)
HCRChildrenHealthInsurancePlan_panelDetails
Register Person (ICSample_registerPerson)
Register Person (IncomeScreening_registerHouseholdMember)
Register Person (IncomeScreening_registerPerson)
Delete Household Evidence Details: (IncomeSupportScreening_cancelISHouseholdEvidence)
Register Person (IncomeSupportScreening_registerPerson)
Register Person (IncomeSupportScreening_registerPersonForHouseholdEvidence)
Register Prospect Person as Person (Individual_registerProspectAsPerson)
Member (InsuranceAffordability_listBenefitGroupMembers)
Member (InsuranceAffordability_listGroupMembers)
Related Persons (Intake_listRelatedPerson)
Register Person (Intake_personFullRegistration)
Person Search Results (Intake_personSearchResult)
Register Prospect Person as Person (Intake_registerProspectAsPerson)
Register Prospect Person as Person (Intake_registerProspectPersonAsPerson)
Register Prospect Person (Intake_registerProspectPersons)
Register Prospect Person (Intake_registerProspectPersons_Reset)
Register Prospect Person (Intake_registerProspectPersons_Reset1)
Register Prospect Person (Intake_registerProspectPersons1)
New Program Appeal (IntakeAppealWizard_selectParticipants)
Register Person (IntakeShortCuts_registerPerson)
Delete Case Member (InvestigationDelivery_cancelCaseMember)
Register Person (InvestigationSample_registerPerson)
Register Person (InvestigationSample_registerPersonForPDC)
Add Household Member (ISAddMemberWizard_summaryDetails)
New Spend Down Medical Expense Evidence (ISP_addToCaseISPSpendDownMedicalExpenseProductEvidence_sa)
New Spend Down Medical Expense Evidence (ISP_addToCaseISPSpendDownMedicalExpenseProductEvidence_wzSelAllCre)
Assign New Expense (ISP_applyFromNewMedicalExpense)
Check Retroactive Medical Assistance Eligibility (ISP_checkRetroactiveEligibility_fromICHome)
Check Retroactive Medical Assistance Eligibility (ISP_checkRetroactiveEligibility_fromPDHome)
Check Retroactive Spend Down Eligibility (ISP_checkSpendDownRetroactiveEligibility)
Confirm Benefit Delivery System (ISP_confirmBenefitDeliverySystemEvidence)
Renew Program (ISP_confirmProgramRenewal)
New Benefit Delivery System (ISP_createBenefitDeliverySystemEvidence)
New Receipt (ISP_createCoPaymentReceiptEvidence)
New Spend Down Medical Expense Evidence (ISP_createISPSpendDownMedicalExpenseProductEvidence_sa)
New Spend Down Medical Expense Evidence (ISP_createISPSpendDownMedicalExpenseProductEvidence_wzSelAllCre)
Retroactive Program Summary (ISP_createRetroactiveProgram)
Edit Spend Down Medical Expense Evidence (ISP_incomingModifyISPSpendDownMedicalExpenseProductEvidence)
Site Map (ISP_lifcEvidenceMap)
Edit Spend Down Medical Expense Evidence (ISP_modifyISPSpendDownMedicalExpenseProductEvidence)
Register Person (ISP_registerPerson)
Renew Program (ISP_renewProductDeliveryConfirmation)
Renew Long Term Care Eligibility (ISP_renewProductDeliveryEligibility)
Renew Long Term Care Eligibility (ISP_renewProductDeliveryEligibilityFromMenu)
Select Dental Plan By County (ISP_selectDentalPlanBenefitDeliverySystemEvidence)
Select Primary Care Provider (ISP_selectDentalPlanByPCPBenefitDeliverySystemEvidence)
Select Dental Plan Search Criteria (ISP_selectDentalPlanSearchCriteriaBenefitDeliverySystem)
Select Health Plan By County (ISP_selectHealthPlanBenefitDeliverySystemEvidence)
Select Health Plan by Primary Care provider (ISP_selectHealthPlanByPCPBenefitDeliverySystemEvidence)
Select Health Plan Search Criteria (ISP_selectHealthPlanSearchCriteriaBenefitDeliverySystem)
Select Primary Care Provider (ISP_selectPCPDentalPlanBenefitDeliverySystemEvidence)
Select Primary Care Provider (ISP_selectPrimaryCareProviderBenefitDeliverySystemEvidence)
Site Map (ISP_SpendDownEvidenceMap)
Medical Assistance Eligibility Result (ISP_viewCurrentChipRenewalEligibilityDetails)
Medical Assistance Eligibility Result (ISP_viewCurrentChipRenewalIneligibleDetails)
Retroactive Medical Assistance Eligibility Result (ISP_viewCurrentRetroactiveMedicalAssistanceEligibilityResults)
Retroactive Spend Down Eligibility Result (ISP_viewCurrentRetroactiveSpendDownEligibilityResults)
Medical Assistance with Spend Down Eligibility Result (ISP_viewMedicalAssistanceWithSDEligibilityDetails)
Premiums (ISP_viewPremiumEvidence)
Medical Assistance Eligibility Result (ISP_viewProductDeliveryRenewEligibilityResult)
Medical Assistance Eligibility Result (ISP_viewProductDeliveryRenewInEligibilityResult)
Medical Assistance with Spend Down Retroactive Eligibility Result (ISP_viewRetroactiveMedicalAssistanceWithSDEligibilityDetails)
Check Retroactive Medical Assistance Eligibility (ISPCheckRetroactiveEligibilityPDHomeFromMenu)
Basic Intake Information (ISPIntakeInformation_createFromScreening)
New Certification (ISPProduct_createCertification)
Edit Certification (ISPProduct_modifyCertificationFromList)
Edit Certification (ISPProduct_modifyCertificationFromView)
Medical Assistance with Spend Down Program Summary (ISPSpendDown_createProgram)
Create Program (ISPSpendDown_createRetroactiveProgram)
Home (ISPSpendDown_productHome)
Reuse Program (ISPSpendDown_reuseProgram)
Reuse Program (ISPSpendDown_reuseRetroactiveProgram)
Select Application Date (ISPSpendDown_selectApplicationDate)
Assistance (ISPSpendDownProduct_listBenefitGroupMembers)
Financial (ISPSpendDownProduct_listFinancialGroupMembers)
Member (ISPSpendDownProduct_listGroupMembers)
Re-add a Member (ISReAddMemberWizard_submit)
Add Legal Action Participants (LegalAction_addParticipant)
Register Person (LiabilitySample_registerPerson)
LIFCPreviewPanel
Assistance (LIFCProduct_listBenefitGroupMembers)
Financial (LIFCProduct_listFinancialGroupMembers)
LIFCProductHomeDetails
Assistance (listBenefitGroupMembers)
Financial (listFinancialGroupMembers)
Member (listGroupMembers)
Member (listGroupMembersLIFC)
Member (listGroupMembersLTC)
Member (listGroupMembersRefugee)
Member (listGroupMembersTBBCC)
Member (listPreviousCurrentGroupMembersLIFC)
Member (listPreviousCurrentGroupMembersRefugee)
LTCPreviewPanel
Assistance (LTCProduct_listBenefitGroupMembers)
Financial (LTCProduct_listFinancialGroupMembers)
LTCProductHomeDetails
Home (MA_lifcProductHome)
Home (MA_ltcProductHome)
Home (MA_productHome)
Home (MA_refugeeProductHome)
Assistance (MedicalAssistance_listBenefitGroupMembers)
Financial (MedicalAssistance_listFinancialGroupMembers)
Organization_listRecentApprovedCaseForUser1
Organization_listRecentAssignedCaseForUser1
Organization_listRecentViewedCaseForUser
Remove Client (OutcomePlan_removeClient)
Merge Duplicate (Participant_mergeRelationships)
Delete Relationship (Person_cancelRelationship)
Edit Relationship (Person_modifyRelationship)
Edit Relationship (Person_modifyRelationshipFromList)
Edit Relationship (Person_modifyRelationshipFromView)
Register Person (Person_register)
Register Person (Person_registerForPDC)
Add Unit Member (ProductDelivery_addUnitMember)
Remove Unit Member (ProductDelivery_removeUnitMember)
ProductHomeDetails
Apply Update (ProgramRecommendation_confirmApplyToExistingPD)
Authorize (ProgramRecommendation_confirmAuthorize)
Authorize (ProgramRecommendation_listHouseholdMembersForMA)
Confirm Registration (Prospect_registerPersonFromProspect)
Delete Company Relationship (ProspectEmployer_cancelRelatedCompany)
Edit Company Relationship (ProspectEmployer_modifyRelatedCompany)
Register Prospect Employer as Employer (ProspectEmployer_registerAsEmployer)
Register Prospect Employer as Employer (ProspectEmployer_registerAsEmployerWizard)
Delete Relationship (ProspectPerson_cancelRelationship)
Edit Relationship (ProspectPerson_modifyRelationshipFromList)
Edit Relationship (ProspectPerson_modifyRelationshipFromView)
Register Prospect Person as Person (ProspectPerson_registerAsPerson)
Register Prospect Person as Person (ProspectPerson_registerAsPersonForPDCWizard)
Register Prospect Person as Person (ProspectPerson_registerAsPersonWizard)
Step 5: Register Person (ProviderManagement_duplicateRegisterPersonAsProvider)
Step 5: Register Person (ProviderManagement_registerPersonAsProvider)
Register As Person (ProviderManagement_registerProviderAsPersonFrmProviderHome)
Assistance (RefugeeProduct_listBenefitGroupMembers)
Financial (RefugeeProduct_listFinancialGroupMembers)
RefugeeProductHomeDetails
Register Person (RegisterPerson_registerForPDCWizard)
Register Person (RegisterPerson_registerWizard)
Remove Member (removeGroupMember)
Remove Client (SocialEnterpriseFolder_removeClient)
SpendDownPreviewPanel
SpendDownProductHomeDetails
Assistance (TBBCC_listBenefitGroupMembers)
Financial (TBBCC_listFinancialGroupMembers)
Home (TBBCC_productHome)
Renew TB Product Delivery (TBBCC_RenewProductDelivery)
TBBCCProductHomeDetails