D:CaseEvidence

Table Description

Case Evidence: Links the Case to the Evidence used in that Case. Links the Case to the Evidence used in that Case.

Technical Notes

Please Note: This entity is no longer part of the default flow in the Curam Application, as such it is neither written to nor read from by the Curam Application. It continues to be shipped with the Curam model as customer may have custom logic which uses this entity, however it should be noted that if you are implementing custom logic which references this entity then you must also ensure that it is written to as needed. The information that was originally stored in this entity is now stored in case evidence group.

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::CaseEvidence::CaseEvidence
Controlling File:	core\model\Packages\Case\Case Evidence_cat.efx

Table Options

ALLOW_OPTIMISTIC_LOCKING

yes

Attributes (6)

Attribute	Stereotype	Nullable	Description	Domain Definition	Codetable	DDL Type
evidenceID	key	no	Unique reference number assigned by the system to an evidence record.	EVIDENCE_ID		SVR_INT64
caseID	details	no	CaseID of the CaseHeader in respect of which this CaseEvidence was entered	CASE_ID		SVR_INT64
assessmentID	details		Unique identifier of an assessment which is populated in respect of an assessment being run.	ASSESSMENT_ID		SVR_INT64
effectiveFrom	details		Date that the case evidence is effective from	CURAM_DATE		SVR_DATE
statusCode	details		Indicates the status of the Case Evidence record (suspended, active, etc.)	CODETABLE_CODE		SVR_STRING<10>
previousEvidenceID	details		unique identifier for the previous CaseEvidence record that this CaseEvidence record was created from.	EVIDENCE_ID		SVR_INT64

Foreign Keys (2)

Child	Parent
CaseEvidence.caseID	CaseHeader.caseID
CaseEvidenceType.evidenceID	CaseEvidence.evidenceID

Indices (1)

Index Name	Attributes
CEvidnceIDStDatIdx	caseID, statusCode, effectiveFrom

Operations (9)

Operation	Stereotype	Options	Description	SQL
insert	insert		Standard Operation
modify	modify	OPTIMISTIC_LOCKING: yes	Standard Operation
read	read		Standard Operation
searchByCaseIDStatusAndType	nsmulti		Reads all records for a given case of a given status.	SQL
searchByCaseID	nsmulti	PRE_DATA_ACCESS: yes	Method that reads all records from the case evidence table by case identifier. This method also selects the CaseEvidence records for an integrated Case which contain evidence which is pertinent to the Case.	SQL
readNearestEvidence	ns		This operation is used to read the nearest record in the past to the input date, for a given Case.	SQL
readNextEvidence	ns		Retrieves the details of the evidence record with the next highest effective from date after that supplied.	SQL
readNearestEvidenceByType	ns		This operation is used to read the nearest record in the past to the input date, for a given Case, which has an associated Case Evidence Type record of the specified type.	SQL
searchByCaseIDAssessmentID	nsmulti	PRE_DATA_ACCESS: yes	Method that reads all records from the case evidence table by case identifier and assessment identifier. This method also selects the CaseEvidence records for an integrated Case which contain evidence which is pertinent to the Case.	SQL

Related Pages (101)

Add Member (CHIPProduct_addAssistanceGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
Submit Case For Approval (CHIPProductDelivery_submit)
Program Summary (Eligibility_createProgram)
Check Retroactive Medicaid Eligibility (HCRRetroactiveMedicaid_confirmCheckEligibilty)
Capture Head of Household Details: (IncomeScreening_createCase)
Household Benefits: (IncomeScreening_enterBenefitEvidence)
Household Expenses: (IncomeScreening_enterExpenseEvidence)
Household Members: (IncomeScreening_enterHouseholdMembers)
Household Income: (IncomeScreening_enterIncomeEvidence)
Household Resources: (IncomeScreening_enterResourceEvidence)
Income Screening Home: (IncomeScreening_home)
Household Benefits: (IncomeScreening_listBenefitEvidence)
Household Expenses: (IncomeScreening_listExpenseEvidence)
Household Members: (IncomeScreening_listHouseholdMember)
Household Income: (IncomeScreening_listIncomeEvidence)
Household Resources: (IncomeScreening_listResourceEvidence)
Check Retroactive Spend Down Eligibility (ISP_checkSpendDownRetroactiveEligibility)
Approve Evidence (ProductDelivery_approveEffectiveDatedEvidence)
Submit Case For Approval (ProductDelivery_submit)
Activate Contract (ProviderManagement_activateContract)
New Text Translation (ProviderManagement_addDescriptionTranslationToServiceOffering)
New Text Translation (ProviderManagement_addNameTranslationToServiceOffering)
Add Service Authorization Line Item: (ProviderManagement_addSampleServiceAuthorizationLineItem)
New Service (ProviderManagement_addServicesToProviderContract)
Add Services to Contract (ProviderManagement_addServicesToProviderGroupContract)
New Service (ProviderManagement_addServicesToProviderGroupContract_fromView)
Update to Training (ProviderManagement_addTrainingForServiceOffering)
Submit Service Invoice Line Item for Processing (ProviderManagement_allowSILIForProcessingAsDuplicate)
Amend Utilization Contract (ProviderManagement_amendProviderGroupUtilizationContract)
Amend Contract (ProviderManagement_amendUtilizationContract)
Approve Line Item (ProviderManagement_approveLineItemCorrections)
Approve Line Item (ProviderManagement_approvePendingSILI)
Approve Line Item (ProviderManagement_approvePendingSILICorrections)
Approve Line Item (ProviderManagement_approveServiceInvoiceLineItem)
Approve Service Invoice Line Items (ProviderManagement_approveServiceInvoiceLineItems)
Approve Line Item (ProviderManagement_approveSILI)
Approve Service Invoice Line Item as Duplicate (ProviderManagement_approveSILIAsDuplicate)
Approve Line Item (ProviderManagement_approveSILICorrections)
Approve Line Items (ProviderManagement_approveSubmittedSILI)
Approve Line Items (ProviderManagement_confirmApproveServiceInvoiceLineItems)
Confirm cancel overlapping reservations (ProviderManagement_confirmCancelOverlappingActiveResForAnyClient)
Confirm Modify Overlapping Placements (ProviderManagement_confirmModifyOverlappingPlacementPrd)
Confirm modify overlapping placements (ProviderManagement_confirmModifyPlacementPrdForWL)
Submit Line Items (ProviderManagement_confirmSubmitServiceInvoiceLineItems)
New Service (ProviderManagement_createNewServiceOffering)
New Service (ProviderManagement_createNewTrainingServiceOffering)
New Service Rate (ProviderManagement_createProviderGroupUtilizationContractProviderOfferingRate)
New Payment Options (ProviderManagement_createProviderPaymentOption)
New Rate (ProviderManagement_createProviderServiceOfferingRate)
Create Emergency Placement (ProviderManagement_createSampleEmergencyPlacement)
Create Service Authorization Line Items (ProviderManagement_createSampleSAWithSALI)
New Service (ProviderManagement_createServiceOffering)
New Payment Options (ProviderManagement_createServicePaymentOption)
New Service Rate (ProviderManagement_createServiceRate)
New Training Service (ProviderManagement_createTrainingServiceOffering)
New Utilization Contract (ProviderManagement_createUtilizationContractForProvider)
New Rate (ProviderManagement_createUtilizationContractProviderOfferingRate)
Edit Payment Option (ProviderManagement_editProviderPaymentOption)
Edit Service (ProviderManagement_editServiceOffering)
Edit Service (ProviderManagement_editServiceOfferingFrmView)
Edit Payment Options (ProviderManagement_editServicePaymentOption)
Edit Service Rate (ProviderManagement_editServiceRate)
Edit Training Service (ProviderManagement_editTrainingServiceOffering)
Edit Training Service (ProviderManagement_editTrainingServiceOfferingFrmView)
Edit Text Translation (ProviderManagement_modifyLocalizableSODescriptionTextTranslation)
Edit Text Translation (ProviderManagement_modifyLocalizableSONameTextTranslation)
Confirm Placement (ProviderManagement_modifyPlaceDuringConfirmation)
Edit Placement (ProviderManagement_modifyPlacementDetails)
Modify Placement Information (ProviderManagement_modifyPlacementInformation)
Confirm Cancel Reservation (ProviderManagement_modifyPlacementInformationConfirmCancelReservation)
Allocate Place (ProviderManagement_modifyPlaceProviderOfferingAllocate)
Edit Service Rate (ProviderManagement_modifyProviderGroupUtilizationContractProviderOfferingRate)
Edit Rate (ProviderManagement_modifyProviderServiceOfferingRate)
Confirm Placement: (ProviderManagement_modifySamplePlaceDuringConfirmation)
Modify Service Authorization Line Item: (ProviderManagement_modifySampleServiceAuthorizationLineItem)
Edit Delivery Configuration (ProviderManagement_modifySecurityRightsAndServiceDeliveryConfiguration)
Edit Utilization Contract (ProviderManagement_modifyUtilizationContractForProviderGroup)
Edit Rate (ProviderManagement_modifyUtilizationContractProviderOfferingRate)
Place Client (ProviderManagement_placeSampleClient)
Renew Contract (ProviderManagement_renewContract)
Renew Contract (ProviderManagement_renewProviderGroupContract)
Submit Line Item (ProviderManagement_submitOpenSILIForProcessing)
Submit Line Item (ProviderManagement_submitServiceInvoiceLineItemForProcessing)
Submit Line Items (ProviderManagement_submitServiceInvoiceLineItems)
Submit Line Item (ProviderManagement_submitSILI)
Submit Service Invoice Line Item for Processing (ProviderManagement_submitSILIForProcessingFromTask)
Submit Service Invoice (ProviderManagement_submittServiceInvoiceForProcessing)
Transfer Client (ProviderManagement_transferClient)
Transfer Placement to Another Case (ProviderManagement_transferSamplePlacementToAnotherCase)
Reassessment Details (ProviderManagement_triggerReassessment)
Update Placement Period (ProviderManagement_updateSamplePlacementPeriod)
Add Plan Item (ServicePlanDelivery_addCustomServicePlanItem)
Add Plan Item (ServicePlanDelivery_addServicePlanItem)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderNonEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderNonEditable)
Submit Case For Approval (TBBCCProductDelivery_submit)

Database Table: CaseEvidence