Table Description
Schedule Reassessment: A case which is pending reassessment.

Entries here should only be managed from the ProductDeliveryReassessment module, and this entity will only be used by batch processing, as deferred processing is used in other processing modes.

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::ScheduleReassessment::ScheduleReassessment
Controlling File: core\model\Packages\Infrastructure\Eligibility Determination\Schedule Reassessment_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
scheduledReassessmentIDkeynoUnique identifier for the record.SCHEDULED_REASSESSMENT_ID SVR_INT64
caseIDdetailsnoAs caseID is key field in many related tables, it cannot be NULL valueCASE_ID SVR_INT64
fromDatedetails The from date of the reassessment.CURAM_DATE SVR_DATE
toDatedetails The to date of the reassessment.CURAM_DATE SVR_DATE
Foreign Keys (1)
ChildParent
ScheduleReassessment.caseIDCaseHeader.caseID
Indices (1)
Index NameAttributes
SchReassIdxcaseID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
readAllnkreadmulti Retrieve all the Schedule Reassessments. 
searchAllWithCaseReferencensmulti  SQL
readAllWithCaseReference  @superseded - replaced by searchAllWithCaseReference 
Related Pages (180)
Add Member (addGroupMember)
Add Member (addGroupMemberLIFC)
Add Member (addGroupMemberRefugee)
Add Member (addGroupMemberRefugee1)
Delete Existing (AdvancedEvidenceSharing_removeExistingEvidence)
Transfer Application (Application_transferApplicationToExistingCase)
Activate Evidence (BenefitSample_activateEffectiveDatedEvidence)
Cancel Evidence (BenefitSample_cancelEditableEffectiveDatedEvidence)
Cancel Evidence (BenefitSample_cancelEffectiveDatedEvidence)
Create Case (BenefitSample_createCase)
New Member (Case_createCaseMember)
Add Family as Case Members (Case_createCaseRelatedMember)
Register Person and Create Case (Case_registerPersonAndCreateIntegratedCase)
Register Person and Create Case (Case_registerPersonAndCreateIntegratedCasePDC)
Register Prospect Person and Create a Case (Case_registerProspectPersonAndCreateIntegratedCase)
Register Prospect Person and Create an Integrated Case (Case_registerProspectPersonAndCreateIntegratedCasePDC)
Add Member (CHIPProduct_addAssistanceGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
Modify Case Details (CHIPProductDelivery_modifyHeader)
Reassess (CHIPProductDelivery_reassessBenefit)
Authorize (CREOLEProgramRecommendation_confirmAuthorize)
New Product Delivery (DefaultIC_createProductDelivery)
New Case (DefaultICMember_createProductDelivery)
Attribute Existing Evidence (DefaultICProduct_attributeExistingEvidence)
Edit Case (DefaultICProduct_modifyHeader)
Program Summary (Eligibility_createProgram)
Transfer Evidence: (Evidence_listEvidenceForTransfer)
Delete Active Evidence (Evidence_removeActive)
Confirm Evidence Transfer (Evidence_transferEvidenceConfirmation)
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)
Enable Employee Shopping (HCR_enableAndLogEmployeeCoCShopping)
Check Retroactive Medicaid Eligibility (HCRRetroactiveMedicaid_confirmCheckEligibilty)
New Case (ICMember_createProductDelivery)
Edit Case (ICProductSample_modifyHeader)
Create Delivery (ICSample_createProductDelivery)
New Case (ICSample_selectIntegratedCaseType)
Attribute Existing Evidence (ICSportingGrantSample_attributeExistingEvidence)
Edit Case (ICSportingGrantSample_modifyHeader)
Capture Head of Household Details: (IncomeScreening_createCase)
Related Persons (Intake_listRelatedPerson)
Person Search Results (Intake_personSearchResult)
Register Prospect Person (Intake_registerProspectPersons)
Register Prospect Person (Intake_registerProspectPersons_Reset)
Register Prospect Person (Intake_registerProspectPersons_Reset1)
Register Prospect Person (Intake_registerProspectPersons1)
Apply To Period (ISP_ApplyToPeriod)
Cancel Sanction (ISP_cancelSanctionEvidence)
Cancel Disregard (ISP_cancelSanctionOverride)
Renew Program (ISP_confirmProgramRenewal)
New Household Member Evidence Details (ISP_createCase)
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)
Renew Program (ISP_renewProductDeliveryConfirmation)
Basic Intake Information (ISPIntakeInformation_createFromScreening)
Delete Certification (ISPProduct_cancelCertification)
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)
Reuse Program (ISPSpendDown_reuseProgram)
Reuse Program (ISPSpendDown_reuseRetroactiveProgram)
Add Evidence (IssueDelivery_addEvidence)
Add Evidence (IssueDelivery_addEvidenceForIC)
Add Evidence (IssueDelivery_addEvidenceForProductDelivery)
Create Issue (IssueDelivery_createIssue)
New Issue Case (IssueDelivery_createIssueForICWizard)
New Issue Case (IssueDelivery_createIssueForPDWizard)
Activate Evidence (LiabilitySample_activateEffectiveDatedEvidence)
Cancel Evidence (LiabilitySample_cancelEditableEffectiveDatedEvidence)
Cancel Evidence (LiabilitySample_cancelEffectiveDatedEvidence)
Create Case (LiabilitySample_createCase)
Reverse Line Item (Participant_createLineItemReversal)
Delete Certification (ProductDelivery_cancelCertification)
Delete Certification (ProductDelivery_cancelCertification1)
New Certification (ProductDelivery_createCertification)
Edit Certification (ProductDelivery_modifyCertificationFromList)
Edit Certification (ProductDelivery_modifyCertificationFromView)
Edit Case Details (ProductDelivery_modifyHeader)
Edit Case (ProductDelivery_modifyHeader1)
Authorize (ProgramRecommendation_confirmAuthorize)
Authorize (ProgramRecommendation_listHouseholdMembersForMA)
Authorize (ProgramRecommendation_PremiumCoPaymentDetails)
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)
Remove Member (removeGroupMember)
New Disregard (SanctionAssessment_createDisregard_CREOLE)
New Sanction (SanctionAssessment_createSanction_CREOLE)
Edit Sanction (SanctionAssessment_modifySanction)
Edit Recommendation Disregard (SanctionAssessment_modifySanctionOverride)
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)
Modify Case Details (TBBCCProductDelivery_modifyHeader)
Reassess (TBBCCProductDelivery_reassessBenefit)