Table Description
Case Deduction History: A history of the processing performed on a specific case deduction item.

A deduction history record is created each time a case deduction item becomes active, inactive, is processed, skipped or cancelled. A case deduction history record is created for a case deduction item that is paying a third party each time the payment is awaiting payment, issued or cancelled.

Example

A case worker creates a product delivery case for participant Linda Smith. Linda was overpaid in the past and the organization would like to recoup this. The caseworker sets up an applied deduction for $5 per payment to recover the outstanding amount of the liability . Linda also pays gas and electricity on a monthly basis and would like this to be deducted from her benefit payment. A third party deduction is set up to deduct from the benefit payment and pay the Gas and Electricity companies on a monthly basis. A deduction history record of 'In-Active' is created for each of these deductions. The caseworker activates the deductions and a history record of 'Active' is recorded for each one. During financial processing, a history record of 'Processed' is recorded if the deduction has been applied to the benefit, or 'Skipped' if the deduction could not be processed.

Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Case::Entity Objects::CaseDeductionHistory::CaseDeductionHistory
Controlling File: core\model\Packages\Case\CaseDeductionHistory_cat.efx
Table Options
LAST_UPDATED_FIELDyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
caseDeductionHistoryIDkeynoUnique reference number assigned by the system to the deduction history record.CASE_DEDUCTION_HISTORY_ID SVR_INT64
caseDeductionItemIDdetails Unique reference number of the deduction associated with this deduction history record.CASE_DEDUCTION_ITEM_ID SVR_INT64
instructLineItemIDdetails Unique reference number of the instruction line item which has been created for this case deduction item.INSTRUCTION_LINE_ITEM_ID SVR_INT64
amountdetails The amount of the related deduction instruction line item i.e. the deduction amount which was processed during deduction processing.CURAM_AMOUNT SVR_MONEY
percentagedetailsyesThe percentage of the related deduction instruction line item i.e. the deduction percentage which was processed during deduction processing.RATE SVR_DOUBLE
effectiveDatedetailsnoDate the deduction history record was processed.CURAM_DATETIME SVR_DATETIME
statusdetails The status of the deduction represented by this history record i.e. Active, Inactive, Processed, Cancelled or Skipped.CASE_DEDUCTION_HISTORY_STATUSCaseDedHistoryStatusSVR_STRING<10>
descriptiondetails  CASE_DEDUCTION_HISTORY_DESCRIPTION SVR_STRING<1000>
commentsdetails General remarks entered by a user. Not displayed currently but can be used to extend the entity in the future.COMMENTS SVR_STRING<300>
prioritydetailsnoThe priority of the deduction item.PRIORITY SVR_INT32
Indices (1)
Index NameAttributes
CDedHstCDedItIDIdxcaseDeductionItemID
Operations (3)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: caseDeductionHistoryID
Standard Operation 
readread Standard Operation 
searchByCaseDeductionItemIDnsreadmulti   
Related Pages (169)
- (CHIPDecision_context)
- (DefaultICProduct_tabDetails)
DefaultICProduct_tabDetailsPreview
- (EmergencyMedicaidDecision_context)
- (ESIDecision_context)
- (ExemptionDecision_context)
Regenerate Payment (ExternalParty_regeneratePayment)
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)
Confirm & Reissue (Financial_regenerateAppliedFixedDeduction)
Regenerate Payment For New Nominee: (Financial_regenerateForNewNominee)
Regenerate Payment (Financial_regeneratePayment)
Reissue Payment (Financial_regeneratePayment1)
Reissue Payment Instrument (Financial_regeneratePaymentInstrument)
Reissue with Un-applied Deduction (Financial_regenerateUnappliedDeduction)
Simulate Payment (Financial_simulatePayment1)
Check Retroactive Medicaid Eligibility (HCRRetroactiveMedicaid_confirmCheckEligibilty)
- (InsuranceAssistanceDecision_context)
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)
End Deduction (Participant_endDeduction)
- (Participant_regeneratePaymentInstrument)
Activate Deduction (ProductDelivery_activateDeduction)
Delete Deduction (ProductDelivery_cancelDeduction)
Delete Deduction (ProductDelivery_cancelDeduction1)
New Fixed Deduction (ProductDelivery_createAppliedFixedDeduction)
New Applied Fixed Deduction (ProductDelivery_createAppliedFixedDeduction1)
New Applied Fixed Deduction (ProductDelivery_createAppliedFixedDeductionWizard)
New Variable Deduction (ProductDelivery_createAppliedVariableDeduction)
New Applied Variable Deduction (ProductDelivery_createAppliedVariableDeduction1)
New Applied Variable Deduction (ProductDelivery_createAppliedVariableDeductionWizard)
New Third Party Fixed Deduction (ProductDelivery_createThirdPartyFixedDeduction)
New Third Party Fixed Deduction (ProductDelivery_createThirdPartyFixedDeduction1)
New Third Party Variable Deduction (ProductDelivery_createThirdPartyVariableDeduction)
New Third Party Variable Deduction (ProductDelivery_createThirdPartyVariableDeduction1)
New Fixed Deduction (ProductDelivery_createUnappliedFixedDeduction)
New Un-applied Fixed Deduction (ProductDelivery_createUnappliedFixedDeduction1)
New Variable Deduction (ProductDelivery_createUnappliedVariableDeduction)
New Un-applied Variable Deduction (ProductDelivery_createUnappliedVariableDeduction1)
Deactivate Deduction (ProductDelivery_deactivateDeduction)
Third Party Deduction (ProductDelivery_listAppliedDeductionHistory)
Third Party Deduction (ProductDelivery_listThirdPartyDeductionHistory)
Un-applied Deduction (ProductDelivery_listUnappliedDeductionHistory)
Edit Applied Deduction (ProductDelivery_modifyAppliedDeductionDetailsFromList)
Edit Applied Deduction (ProductDelivery_modifyAppliedDeductionDetailsFromView)
Edit Deduction Details (ProductDelivery_modifyDeductionDetailsFromList)
Edit Deduction Details (ProductDelivery_modifyDeductionDetailsFromView)
Edit Third Party Deduction Details (ProductDelivery_modifyThirdPartyDeductionFromList)
Edit Third Party Deduction Details (ProductDelivery_modifyThirdPartyDeductionFromList1)
Edit Third Party Deduction Details (ProductDelivery_modifyThirdPartyDeductionFromView)
Edit Third Party Deduction Details (ProductDelivery_modifyThirdPartyDeductionFromView1)
Edit Un-applied Deduction Details (ProductDelivery_modifyUnappliedDeductionDetailsFromList)
Edit Un-applied Deduction Details (ProductDelivery_modifyUnappliedDeductionDetailsFromView)
Save Simulation (ProductDelivery_saveSimulation)
Simulate Payment (ProductDelivery_simulatePayment)
- (ProductDelivery_tabDetails)
ProductDelivery_tabDetailsPreview
View Applied Deduction (ProductDelivery_viewAppliedDeductionDetails1)
View Third Party Deduction (ProductDelivery_viewThirdPartyDeductionDetails1)
View Un-applied Deduction (ProductDelivery_viewUnappliedDeductionDetails1)
Activate Contract (ProviderManagement_activateContract)
Activate Deduction (ProviderManagement_activateProviderDeduction)
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)
Delete Deduction (ProviderManagement_cancelProviderDeduction)
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 Applied Deduction (ProviderManagement_createAppliedVariableDeduction)
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 Third Party Deduction (ProviderManagement_createThirdPartyVariableDeduction)
New Training Service (ProviderManagement_createTrainingServiceOffering)
New Un-Applied Deduction (ProviderManagement_createUnappliedVariableDeduction)
New Utilization Contract (ProviderManagement_createUtilizationContractForProvider)
New Rate (ProviderManagement_createUtilizationContractProviderOfferingRate)
Deactivate Deduction (ProviderManagement_deactivateProviderDeduction)
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 Applied Deduction (ProviderManagement_modifyAppliedDeductionDetails)
Edit Text Translation (ProviderManagement_modifyLocalizableSODescriptionTextTranslation)
Edit Text Translation (ProviderManagement_modifyLocalizableSONameTextTranslation)
Select Provider Payment Type (ProviderManagement_modifyPaymentType)
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 Third Party Deduction (ProviderManagement_modifyThirdPartyDeduction)
Edit Un-Applied Deduction (ProviderManagement_modifyUnappliedDeductionDetails)
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)
Provider Deduction History (ProviderManagement_viewAppliedProviderDeductionHistory)
View Provider Deduction History: (ProviderManagement_viewThirdPartyProviderDeductionHistory)
Provider Deduction History (ProviderManagement_viewUnappliedProviderDeductionHistory)
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)
- (StateBasicPlanDecision_context)
- (StreamlineMedicaidDecision_context)
- (UQHPDecision_context)