Table Description
Case Evidence Group Link: Links an evidence entity to an evidence group of an evidence set. Links an evidence entity to an evidence group of an evidence set.
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::Service Layer::CaseEvidenceAPI::entity::CaseEvidenceGroupLink::CaseEvidenceGroupLink
Controlling File: core\model\Packages\Reference Model\Service Layer\CaseEvidenceAPI\CaseEvidenceAPI_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
caseEvidenceGroupLinkIDkeynoUnique identifier of the caseEvidenceGroupLink.CASE_EVIDENCE_GROUP_LINK_ID SVR_INT64
caseEvidenceGroupIDdetailsnoUnique identifier of the caseEvidenceGroup to which this entity is linked.CASE_EVIDENCE_GROUP_ID SVR_INT64
relatedIDdetailsnoIdentifies the customized evidence record. Depending on the evidenceType, this identifier will be a foreign key on a number of possible tables. As this attribute does not relate to one particular table, it cannot be constrained via a foreign key constraint.INTERNAL_ID SVR_INT64
evidenceTypedetailsnoCode denoting which specific evidence entity this record can be found on.EVIDENCE_TYPE_CODEEvidenceTypeSVR_STRING<10>
isEditableInTreeInddetailsnoIndicates whether the evidence linked to is editable on this tree or not.CURAM_INDICATOR SVR_BOOLEAN
evidenceTypeInstanceIDdetailsnoThis identifier is used to trace the history of modifications to custom evidence across multiple evidence trees on a specified case. The evidenceTypeInstanceID remains the same for all modifications to each custom evidence entity on the case.INTERNAL_ID SVR_INT64
Foreign Keys (1)
ChildParent
CaseEvidenceGroupLink.caseEvidenceGroupIDCaseEvidenceGroup.caseEvidenceGroupID
Indices (1)
Index NameAttributes
GrLkGrpIDTypeIdxcaseEvidenceGroupID, evidenceType
Operations (19)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: caseEvidenceGroupLinkID
POST_DATA_ACCESS: no
PRE_DATA_ACCESS: yes
Standard Operation 
readByTypeTreeAndRelatedIDns Reads details of an evidence link by caseEvidenceTreeID, evidenceType and relatedID.SQL
readIsEditableInTreeIndnsread Reads the isEditableInTreeInd on the evidence link record. 
removeByIdAndVersionnsremovePRE_DATA_ACCESS: yes
Removes a link on an evidence tree. 
validateRemove  Validates the removal of an evidence link on an evidence tree. 
readTreeStatusns Reads the tree status for the specified evidence link identifier.SQL
searchByTreeAndTypensmultiREADMULTI_LIM: 500
 
Searches for links on an evidence tree based on caseEvidenceTreeID and evidenceType.SQL
modifyRelatedIDnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Modifies the relatedID on an evidence link of an In Edit evidence tree. 
validateModifyRelatedID  Validates the modification of a relatedID on a caseEvidenceGroupLink on an In Edit evidence tree. 
readGroupIDByTreeAndTypens Reads caseEvidenceGroupID using the caseEvidenceTreeID and evidenceType.SQL
modifyIsEditableInTreeIndnsmodifyOPTIMISTIC_LOCKING: no
Modifies the isEditableInTreeInd indicator to the value passed into the function. 
searchLinkIDByGroupnsmultiREADMULTI_LIM: 500
 
Returns a list of caseEvidenceGroupLinkIDs based on the caseEvidenceGroupID passed into the function.SQL
searchByCaseEvidenceGroupIDnsreadmultiREADMULTI_LIM: 500
Searches CaseEvidenceGroupLink by CaseEvidenceGroupID.  
validateInsert  Validates the insertion of details onto the CaseEvidenceGroupLink entity. 
readread Standard Operation 
searchEvidenceHistorynsmultiREADMULTI_LIM: 500
 
Returns a list of evidence details for a specified piece of evidence on an evidence tree.SQL
readByGroupAndEvidenceTypensread Reads CaseEvidenceGroupLink details by caseEvidenceGroupID and evidenceType. 
readTreeForLinkns Returns the case evidence tree identifier for the specified link.SQL
remove  @superseded - replaced by removeByIdAndVersion 
Related Pages (131)
Activate Evidence (BenefitSample_activateEffectiveDatedEvidence)
Cancel Evidence (BenefitSample_cancelEditableEffectiveDatedEvidence)
Cancel Evidence (BenefitSample_cancelEffectiveDatedEvidence)
Create Case (BenefitSample_createCase)
Evidence (BenefitSample_listEffectiveDatedEvidence)
Edit Evidence (BenefitSample_modifyEffectiveDatedEvidence)
Suspend Evidence (BenefitSample_suspendEffectiveDatedEvidence)
View Evidence (BenefitSample_viewEffectiveDatedEvidence)
View Evidence (BenefitSample_viewEffectiveDatedEvidenceApprove)
Sample Benefit Overpayment Evidence (BenefitSampleOverpayment_viewEvidence)
View Evidence (Case_viewBenefitSampleEvidenceTransaction)
View Evidence (Case_viewLiabilitySampleEvidenceTransaction)
Modify Case Details (CHIPProductDelivery_modifyHeader)
Edit Case (DefaultICProduct_modifyHeader)
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)
Check Retroactive Medicaid Eligibility (HCRRetroactiveMedicaid_confirmCheckEligibilty)
Home (ICBenefitUnderPayment_home)
New Case (ICMember_createProductDelivery)
Evidence (ICProductSample_listEffectiveDatedEvidence)
Edit Case (ICProductSample_modifyHeader)
Create Delivery (ICSample_createProductDelivery)
Evidence (ICSportingGrantSample_listEffectiveDatedEvidence)
Edit Case (ICSportingGrantSample_modifyHeader)
Delete Dependent Care Expense Evidence Details: (IncomeSupportScreening_cancelDependentCareExpenseEvidence)
Delete Income Evidence Details: (IncomeSupportScreening_cancelIncomeEvidence)
Delete Benefit Evidence Details: (IncomeSupportScreening_cancelISBenefitEvidence)
Delete Household Evidence Details: (IncomeSupportScreening_cancelISHouseholdEvidence)
and (IncomeSupportScreening_cancelISHouseholdRshipEvidence)
and (IncomeSupportScreening_cancelISHouseholdRshipEvidenceFromCreate)
and (IncomeSupportScreening_cancelISHouseholdRshipEvidenceFromList)
Delete Medicaid Evidence Details: (IncomeSupportScreening_cancelISMedicaidEvidence)
Delete Medical Expense Evidence Details: (IncomeSupportScreening_cancelMedicalExpenseEvidence)
Delete Resource Evidence Details: (IncomeSupportScreening_cancelResourceEvidence)
Delete Shelter Expense Evidence Details: (IncomeSupportScreening_cancelShelterExpenseEvidence)
Check Eligibility: (IncomeSupportScreening_checkEligibility)
Transfer Evidence: (IncomeSupportScreening_confirmTransferEvidence)
Confirm Appointment: (IncomeSupportScreening_createAppointment)
Capture Head of Household Details: (IncomeSupportScreening_createCase)
New Dependent Care Expense Evidence Details: (IncomeSupportScreening_createDependentCareExpenseEvidence)
New Income Evidence Details: (IncomeSupportScreening_createIncomeEvidence)
New Benefit Evidence Details: (IncomeSupportScreening_createISBenefitEvidence)
New Household Member Details: (IncomeSupportScreening_createISHouseholdEvidence)
New Relationships For: (IncomeSupportScreening_createISHouseholdRshipEvidence)
New Medicaid Evidence Details: (IncomeSupportScreening_createISMedicaidEvidence)
New Medical Expense Evidence Details: (IncomeSupportScreening_createMedicalExpenseEvidence)
New Resource Evidence Details: (IncomeSupportScreening_createResourceEvidence)
New Shelter Expense Evidence Details: (IncomeSupportScreening_createShelterExpenseEvidence)
Emergency Assistance Evidence: (IncomeSupportScreening_enterEmergencyAssistanceEvidence)
Household Expenses: (IncomeSupportScreening_enterExpenseEvidence)
Household Member Relationships: (IncomeSupportScreening_enterHouseholdRelationships)
Household Income: (IncomeSupportScreening_enterIncomeEvidence)
Household Benefits: (IncomeSupportScreening_enterISBenefitEvidence)
Household Members: (IncomeSupportScreening_enterISHouseholdEvidence)
Medicaid Details: (IncomeSupportScreening_enterISMedicaidEvidence)
Household Resources: (IncomeSupportScreening_enterResourceEvidence)
Eligibility Summary Communication: (IncomeSupportScreening_generateEligibilitySummaryComm)
Home: (IncomeSupportScreening_home)
Emergency Assistance Evidence: (IncomeSupportScreening_listEmergencyAssistanceEvidence)
Household Expenses: (IncomeSupportScreening_listExpenseEvidence)
Select Household Member: (IncomeSupportScreening_listHouseholdMembersForRelationships)
Household Member Relationships: (IncomeSupportScreening_listHouseholdRelationships)
Household Income: (IncomeSupportScreening_listIncomeEvidence)
Household Benefits: (IncomeSupportScreening_listISBenefitEvidence)
Household Members: (IncomeSupportScreening_listISHouseholdEvidence)
Medicaid Details: (IncomeSupportScreening_listISMedicaidEvidence)
Household Resources: (IncomeSupportScreening_listResourceEvidence)
Modify Dependent Care Expense Evidence Details: (IncomeSupportScreening_modifyDependentCareExpenseEvidenceFromList)
Modify Dependent Care Expense Evidence Details: (IncomeSupportScreening_modifyDependentCareExpenseEvidenceFromView)
Modify Emergency Assistance Evidence Details: (IncomeSupportScreening_modifyEmergencyAssistanceEvidenceFromView)
Modify Income Evidence Details: (IncomeSupportScreening_modifyIncomeEvidenceFromList)
Modify Income Evidence Details: (IncomeSupportScreening_modifyIncomeEvidenceFromView)
Modify Benefit Evidence Details: (IncomeSupportScreening_modifyISBenefitEvidenceFromList)
Modify Benefit Evidence Details: (IncomeSupportScreening_modifyISBenefitEvidenceFromView)
Modify Household Member Details: (IncomeSupportScreening_modifyISHouseholdEvidenceFromList)
Modify Household Member Details: (IncomeSupportScreening_modifyISHouseholdEvidenceFromView)
and (IncomeSupportScreening_modifyISHouseholdRshipEvidence)
and (IncomeSupportScreening_modifyISHouseholdRshipEvidenceFromCreate)
and (IncomeSupportScreening_modifyISHouseholdRshipEvidenceFromList)
Modify Medicaid Evidence Details: (IncomeSupportScreening_modifyISMedicaidEvidenceFromList)
Modify Medicaid Evidence Details: (IncomeSupportScreening_modifyISMedicaidEvidenceFromView)
Modify Medical Expense Evidence Details: (IncomeSupportScreening_modifyMedicalExpenseEvidenceFromList)
Modify Medical Expense Evidence Details: (IncomeSupportScreening_modifyMedicalExpenseEvidenceFromView)
Modify Resource Evidence Details: (IncomeSupportScreening_modifyResourceEvidenceFromList)
Modify Resource Evidence Details: (IncomeSupportScreening_modifyResourceEvidenceFromView)
Modify Shelter Expense Evidence Details: (IncomeSupportScreening_modifyShelterExpenseEvidenceFromList)
Modify Shelter Expense Evidence Details: (IncomeSupportScreening_modifyShelterExpenseEvidenceFromView)
Select the Head of the Household (IncomeSupportScreening_transferEvidence)
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)
Medical Assistance with Spend Down Program Summary (ISPSpendDown_createProgram)
Create Program (ISPSpendDown_createRetroactiveProgram)
Reuse Program (ISPSpendDown_reuseProgram)
Reuse Program (ISPSpendDown_reuseRetroactiveProgram)
Liability Overbilling Home (LiabilityOverbilling_home)
Activate Evidence (LiabilitySample_activateEffectiveDatedEvidence)
Cancel Evidence (LiabilitySample_cancelEditableEffectiveDatedEvidence)
Cancel Evidence (LiabilitySample_cancelEffectiveDatedEvidence)
Create Case (LiabilitySample_createCase)
Evidence (LiabilitySample_listEffectiveDatedEvidence)
Edit Evidence (LiabilitySample_modifyEffectiveDatedEvidence)
View Evidence (LiabilitySample_viewEffectiveDatedEvidence)
View Evidence (LiabilitySample_viewEffectiveDatedEvidenceApprove)
Reverse Line Item (Participant_createLineItemReversal)
Benefit Underpayment Home (PDBenefitUnderPayment_home)
Edit Case Details (ProductDelivery_modifyHeader)
Edit Case (ProductDelivery_modifyHeader1)
New Disregard (SanctionAssessment_createDisregard_CREOLE)
New Sanction (SanctionAssessment_createSanction_CREOLE)
Edit Sanction (SanctionAssessment_modifySanction)
Edit Recommendation Disregard (SanctionAssessment_modifySanctionOverride)
Edit Plan Item (ServicePlanDelivery_modifyCustomPlanItem)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderNonEditable)
Edit Plan Item (ServicePlanDelivery_modifyPlanItem_NameEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanBasicPlanItem)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderNonEditable)
Edit Plan Item (ServicePlanDelivery_modifyServiceUnitPlanItem)
Modify Case Details (TBBCCProductDelivery_modifyHeader)