D:ReassessmentQueueControl

Table Description

An entry in the reassessment queue control table indicates that a particular workflow has claimed responsibility for reassessing a particular case.

Model Details

Location in Model:	Logical View::MetaModel::Curam::Core::Reference Model::DependencyManager::DependencyMgr::ReassessmentQueueControl
Controlling File:	core\model\Packages\DependencyManager_cat.efx

Attributes (6)

Attribute	Stereotype	Nullable	Description	Domain Definition	Codetable	DDL Type
reassessmentQueueControlID	key	no	A surrogate primary key which identifies a particular reassessment request.	INTERNAL_ID		SVR_INT64
caseID	details		The case that is to be reassessed.	CASE_ID		SVR_INT64
statusCode	details		Indicates whether this reassessment request is PENDING, RELEASED, COMPLETE. or BACKEDOFF.	CASE_REASSESSMENT_CONTROL_STATUS_CODE	ReassessmentControlStatus	SVR_STRING<10>
lockTS	details		The dateTime at which the reassessment was queued .	CURAM_DATETIME		SVR_DATETIME
completionTS	details		The dateTime at which the reassessment was completed.	CURAM_DATETIME		SVR_DATETIME
workflowID	details		The processID of the workflow associated with this reassessment.	PROCESS_INSTANCE_ID		SVR_INT64

Indices (2)

Index Name	Attributes
queueControlCaseidIdx	caseID
queueCtrlCaseidStatusIdx	caseID, statusCode

Operations (8)

Operation	Stereotype	Options	Description	SQL
searchByCaseIDAndStatus	nsreadmulti
insert	insert		Standard Operation
modify	modify		Standard Operation
read	read		Standard Operation
searchByCaseID	nsreadmulti
readDateDeferredToBatchHashcode	ns			SQL
readDateDeferredToBatchNoHashcode	ns			SQL
searchLatestLockTSByCaseID	nsmulti		Gets the most recent record based on the lockTS field for a case, excluding backed-off locks. Should typically find one record but high contention could generate multiple records hence this is a read multi.	SQL

Related Pages (122)

AppealWizard_listCreoleDecisionsForDetermination
Add Member (CHIPProduct_addAssistanceGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
Check Eligibility (DefaultICProduct_checkEligibilityCaseDetermination)
Current Determination (DefaultICProduct_listCreoleDecisions)
DefaultICProduct_listCreoleDecisionsForDetermination
Manual Eligibility Check (DefaultICProduct_readManualEligibilityCheckDecision)
Enable Special Enrollment Shopping Experience (HCR_enableAndLogSpecialEnrollmentShopping)
Enable Special Enrollment Shopping Experience (HCR_enableSpecialEnrollmentShopping)
Home (HCRChildrenHealthInsurancePlan)
HCRChildrenHealthInsurancePlan_panelDetails
HCREmergencyMedicaid_panelDetails
Home (HCREmergencyMedicaidHome)
HCREmployerSponsoredInsurace_panelDetails
Home (HCREmployerSponsoredInsuraceHome)
HCRExemption_panelDetails
Home (HCRExemptionHome)
Home (HCRInsuranceAssistance)
HCRInsuranceAssistance_panelDetails
HCRStateBasicHealthPlan_panelDetails
Home (HCRStateBasicHealthPlanPDHome)
HCRUnassistedQualifiedHealthPlan_panelDetails
Home (HCRUnassistedQualifiedHealthPlanHome)
Work Eligibility (IntegratedCase_caParticipationWorkEligibility)
Work Eligibility (IntegratedCase_faParticipationWorkEligibility)
Apply To Period (ISP_ApplyToPeriod)
Activate Case (ProductDelivery_activate)
Check Eligibility (ProductDelivery_checkEligibilityCaseDetermination)
ProductDelivery_errorDetermination
ProductDelivery_listCaseApprovalEventCreoleDecisions
View Decision (ProductDelivery_listCaseApprovalEventCreoleDecisionsViewOnly)
Determination Results (ProductDelivery_listCreoleDecisions)
ProductDelivery_listCreoleDecisionsForDetermination
Determination Results (ProductDelivery_listMACreoleDecision)
Determination Results (ProductDelivery_listMACreoleDecisions)
ProductDelivery_listSubmitForApprovalCreoleDecisions
ProductDelivery_listSubmitForApprovalCreoleDecisionsViewOnly
Manual Eligibility Check (ProductDelivery_readManualEligibilityCheckDecision)
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)
Check Eligibility (ServiceDelivery_checkEligibilityCaseDetermination)
Manual Eligibility Check (ServiceDelivery_readManualEligibilityCheckDecision)
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)
Home (StreamlinedMedicaid_home)
StreamlinedMedicaid_panelDetails

Database Table: ReassessmentQueueControl