Table Description
Evidence Status History: A history of evidence status modifications for case evidence trees.

A record will be written to this table every time an evidence tree is either created or its status modified.

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::EvidenceStatusHistory::EvidenceStatusHistory
Controlling File: core\model\Packages\Reference Model\Service Layer\CaseEvidenceAPI\CaseEvidenceAPI_cat.efx
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceStatusHistoryIDkeynoUnique identifier of the evidenceStatusHistory.EVIDENCE_STATUS_HISTORY_ID SVR_INT64
caseEvidenceTreeIDdetailsnoIdentifier of the related case evidence tree.CASE_EVIDENCE_TREE_ID SVR_INT64
effectiveFromdetails Date from which the status is effective. This will be the same as the evidence tree effective from date.CURAM_DATE SVR_DATE
creationDateTimedetailsnoDate/time of the creation of the evidence status history record.CURAM_DATETIME SVR_DATETIME
statusCodedetailsnoEvidence tree status code.EVIDENCE_TREE_STATUS_CODEEvidenceTreeStatusSVR_STRING<10>
reasonCodedetailsnoCode denoting the reason for the evidence status change. In particular, this should be populated in the instance where the evidence status is being modified to 'Suspended'.EVIDENCE_STATUS_MODIFICATION_REASON_CODEEvidenceStatusModReasonSVR_STRING<10>
Foreign Keys (1)
ChildParent
EvidenceStatusHistory.caseEvidenceTreeIDCaseEvidenceTree.caseEvidenceTreeID
Indices (1)
Index NameAttributes
CaseEvTreeIDIdxcaseEvidenceTreeID
Operations (2)
OperationStereotypeOptionsDescriptionSQL
searchByCaseEvidenceTreeIDnsreadmultiORDER_BY: creationDateTime
Searches for all evidence status history records for a specified case evidence tree. 
insertinsertAUTO_ID: evidenceStatusHistoryID
PRE_DATA_ACCESS: yes
Standard Operation 
Related Pages (73)
Create Case (BenefitSample_createCase)
Edit Evidence (BenefitSample_modifyEffectiveDatedEvidence)
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)
New Case (ICMember_createProductDelivery)
Create Delivery (ICSample_createProductDelivery)
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)
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)
Household Member Relationships: (IncomeSupportScreening_enterHouseholdRelationships)
Household Member Relationships: (IncomeSupportScreening_listHouseholdRelationships)
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)
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)
Create Case (LiabilitySample_createCase)
Edit Evidence (LiabilitySample_modifyEffectiveDatedEvidence)
Reverse Line Item (Participant_createLineItemReversal)
Evidence Status History (ProductDelivery_listEvidenceStatusHistory)
New Disregard (SanctionAssessment_createDisregard_CREOLE)
New Sanction (SanctionAssessment_createSanction_CREOLE)
Edit Sanction (SanctionAssessment_modifySanction)
Edit Recommendation Disregard (SanctionAssessment_modifySanctionOverride)