Table Description
Reassessment Decision Information: The case decision IDs which affect the reassessment period defined by the reassessmentInfo fromDate and toDate.
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::Infrastructure::Eligibility Determination::Entity Objects::ReassessmentResults::ReassessmentDecisionInfo::ReassessmentDecisionInfo
Controlling File: core\model\Packages\Infrastructure\Eligibility Determination\Reassessment Results_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGno
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
reassessmentDecisionInfoIDkeynoUnique identifier for entity.REASSESSMENT_DECISION_INFO_ID SVR_INT64
reassessmentInfoIDdetailsnoThe ID of the associated reassessment info record.REASSESSMENT_INFO_ID SVR_INT64
oldDecisionIDdetailsyesThe case decision id of the old case decision.CASE_DECISION_ID SVR_INT64
reassessedDecisionIDdetailsyesThe case decision id of the reassessed case decision.CASE_DECISION_ID SVR_INT64
Foreign Keys (3)
ChildParent
ReassessmentDecisionInfo.oldDecisionIDCaseDecision.caseDecisionID
ReassessmentDecisionInfo.reassessedDecisionIDCaseDecision.caseDecisionID
ReassessmentDecisionInfo.reassessmentInfoIDReassessmentInfo.reassessmentInfoID
Indices (3)
Index NameAttributes
ReassessDcsnInIdx2reassessedDecisionID, oldDecisionID
ReassessDcsnInfIdxreassessmentInfoID
oldDecIdxoldDecisionID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: no
Standard Operation 
searchByReassessmentInfoIDreadmulti Search Reassessment Info by Reassessment Info ID. 
searchByReassessedDecisionIDreadmulti   
searchByOldDecisionIDreadmulti   
Related Pages (26)
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)
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)
Reverse Line Item (Participant_createLineItemReversal)
ProductDelivery_listFilteredPaymentPeriodDecisionList
Benefit Statement (ProductDelivery_viewAllComponentsBenefitStatement)
Reassessment Decisions (ProductDelivery_viewBenefitPaymentPeriodDecisionList)
Reassessment Decisions (ProductDelivery_viewLiabilityPaymentPeriodDecisionList)
Reassessment Decisions (ProductDelivery_viewPaymentPeriodDecisionList)
Benefit Statement (ProductDelivery_viewSingleComponentBenefitStatement)
New Disregard (SanctionAssessment_createDisregard_CREOLE)
New Sanction (SanctionAssessment_createSanction_CREOLE)
Edit Sanction (SanctionAssessment_modifySanction)
Edit Recommendation Disregard (SanctionAssessment_modifySanctionOverride)