Table Description
Product Deduction Link: A relationship between a product and a deduction.

The DeductionProductLink entity provides the functionality to list existing deductions which are linked to products, link existing deductions to products, create new deductions for a product, modify deductions for a product and remove an association between a deduction and a product.

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::DeductionProductLink::Entity::DeductionProductLink
Controlling File: core\model\Packages\Reference Model\Service Layer\DeductionProductLink\Entity\DeductionProductLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
deductionProductLinkIDkeynoUnique reference number assigned by the system to the deduction product link record.DEDUCTION_PRODUCT_LINK_ID SVR_INT64
deductionIDdetailsnoUnique reference number of the deduction record which is associated with the product record.DEDUCTION_ID SVR_INT64
productIDdetailsnoUnique reference number of the product record which is associated with the deduction record.PRODUCT_ID SVR_INT64
prioritydetailsnoThe priority of the deduction associated with the product.PRIORITY SVR_INT32
preventOverlappingInddetailsyesIndicates if overlapping deductions can be applied.CURAM_INDICATOR SVR_BOOLEAN
Foreign Keys (2)
ChildParent
DeductionProductLink.deductionIDDeduction.deductionID
DeductionProductLink.productIDProduct.productID
Indices (1)
Index NameAttributes
ProductIDDeductionIDIndexproductID, deductionID
Operations (18)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: deductionProductLinkID
AUTO_ID_KEY: PRODUCTBO
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchDeductionByProductIDnsmulti Returns a list of deductions associated with a particular product.SQL
searchUnassociatedActiveDeductionnsmulti Returns a list of active deductions not associated with a particular product.SQL
readLowestPriorityByProductIDns Returns the lowest deduction priority associated with a specified product. The lowest priority returned will be the highest numerical value i.e. in a list with priorities 1, 2, 3, 4, 5, the lowest priority would be 5.SQL
readDeductionByProductIDPrioritynsread Returns the deduction product link details based on the deduction priority for the product. 
countByDeductionIDns Counts the number of deduction product link records for a specified deduction.SQL
readDeductionNamePriorityVersionNoByDeductionProductLinkIDns Returns deduction name, priority and version number. This information can then be used by the user if they decide to modify a deduction product link record.SQL
searchDeductionProductLinkIDPriorityByDeductionIDnsreadmultiORDER_BY: priority
Returns a list of deductionProductLinkID's and related priorities for a specified deduction. 
searchIDNamePriorityCategoryByProductIDCategorynsmulti Returns a list of deduction details associated with a particular product and deduction category.SQL
readPriorityByDeductionIDnsread Returns the priority of the deduction product link by deductionID. 
readPriorityByDeductionAndProductIDnsread Returns the priority of the deduction product link by deductionID and productID. 
searchByProductIDreadmulti Return a list of deduction production link records by product ID. 
insertDeductionProductLinkinsert <p class="MsoNormal"> <span style="COLOR: #002060">Inserts&nbsp;deduction product link&nbsp;record. This method expects the&nbsp;deductionProductLinkID to be set. It is preferred to call insertDeductionProductLink method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
searchDeductionWithVersionNoByProductIDnsmulti Returns a list of deductions associated with a particular product.SQL
readPreventOvelappingIndByCaseIDDeductionNamens Reads deduction allow overlapping indicator for a case and deduction name.SQL
Related Pages (131)
Reissue with Applied Deduction (Financial_createAppliedFixedDeductionWizard)
Reissue with Un-applied Deduction (Financial_createUnappliedDeductionWizard)
Confirm & Reissue (Financial_regenerateAppliedFixedDeduction)
Reissue with Un-applied Deduction (Financial_regenerateUnappliedDeduction)
End Deduction (Participant_endDeduction)
Add Existing Deduction (Product_addDeduction)
New Deduction (Product_createDeduction)
Product_deductionHome
Deductions (Product_listDeduction)
Edit Deduction (Product_modifyDeductionFromList)
Remove Deduction From Product (Product_removeDeduction)
Activate Deduction (ProductDelivery_activateDeduction)
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)
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)
Select Applied Deduction Name (ProductDelivery_selectAppliedName)
Select Third Party Deduction Name (ProductDelivery_selectThirdPartyName)
Select Un-applied Deduction Name (ProductDelivery_selectUnappliedName)
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)
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)
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)
Select Applied Deduction Name (ProviderManagement_selectAppliedName)
Select Third Party Deduction Name (ProviderManagement_selectThirdPartyName)
Select Un-applied Deduction Name (ProviderManagement_selectUnappliedName)
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)
Delete Deduction (Resource_cancelDeduction)
Edit Deduction (Resource_modifyDeductionFromList)
Edit Deduction (Resource_modifyDeductionFromView)
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)