Table Description
Provider Deduction: Information specifically related to the maintenance of provider deductions.

Provider deductions permits the organization to deduct an agreed sum of money from a provider payment.

Provider Deductions can be applied to all types of payments in respect of a provider, including invoice, placement, contract and attendance based payments.

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::CPM::Service Layer::Provider::ProviderDeduction::Entity::ProviderDeduction
Controlling File: CPM\model\Packages\Service Layer\Provider\ProviderDeduction\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (18)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
providerDeductionIDkeynoThe unique system generated identifier for the provider deduction record.CASE_DEDUCTION_ITEM_ID SVR_INT64
providerConcernRoleIDdetailsyesThe unique system generated identifier for the provider concern role record.CONCERN_ROLE_ID SVR_INT64
createdDatedetails The date that the provider deduction item was created on the system.CURAM_DATE SVR_DATE
startDatedetails The date from which provider deduction item is effective.CURAM_DATE SVR_DATE
endDatedetails The date to which provider deduction item is effective.CURAM_DATE SVR_DATE
recordStatusdetails The status of the provider deduction item.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
commentsdetails The comments entered by the user.COMMENTS SVR_STRING<300>
relatedCaseIDdetailsyesThe unique identifier of the case the provider deduction item is related to. This will only be populated if the deduction being created is offset against an outstanding liability.CASE_ID SVR_INT64
ratedetails A percentage which is deducted from a specified provider payment .RATE SVR_DOUBLE
deductionTypedetails The type of provider deduction item.DEDUCTION_ITEM_TYPE_CODEDeductionItemTypeSVR_STRING<10>
deductionNamedetails Name of the deduction type.DEDUCTION_NAME_CODEDeductionNameSVR_STRING<10>
thirdPartyConcernRoleIDdetailsyesThe unique identifier of third party where the category of deduction is third party deduction.CONCERN_ROLE_ID SVR_INT64
customerAccNamedetails For third party deductions this is the name by which the concern is known to the third party.CUSTOMER_ACCOUNT_NAME SVR_STRING<35>
customerAccNumberdetails For third party deductions this is the reference number by which the concern is known to the third party.CUSTOMER_ACCOUNT_NUMBER SVR_STRING<12>
prioritydetails Specified the order in which the deduction is processed.PRIORITY SVR_INT32
categorydetails Indicates the category of the deductions.DEDUCTION_CATEGORY_CODEDeductionCategoryCodeSVR_STRING<10>
businessStatusdetails The business status of the deduction.BUSINESS_STATUSBusinessStatusSVR_STRING<10>
actionTypedetails The action to take when there is an insufficient amount remaining on the benefit to process the deduction amount.DEDUCTION_ACTION_TYPE_CODEDeductionActionTypeSVR_STRING<10>
Foreign Keys (5)
ChildParent
ProviderDeduction.relatedCaseIDCaseHeader.caseID
ProviderDeduction.thirdPartyConcernRoleIDConcernRole.concernRoleID
ProviderDeduction.providerConcernRoleIDProvider.providerConcernRoleID
ProviderDeductionCDILink.providerDeductionIDProviderDeduction.providerDeductionID
ProviderDeductionProductLink.providerDeductionIDProviderDeduction.providerDeductionID
Indices (4)
Index NameAttributes
ProviderDeductionPriorityIdxpriority
ProviderDeductConcrnRoleIDIdxproviderConcernRoleID
IND__1005454165relatedCaseID
IND_2054055271thirdPartyConcernRoleID
Operations (14)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: providerDeductionID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchByProviderreadmulti   
modifyPriorityByOne  Increments the priority by one for all provider deduction records of which priority is greater than or equal to the priority being passed. 
readMaxPriorityns  SQL
searchCaseDeductionItemByCaseIDCategoryDateRangensmulti Retrieves the Case Deduction Items using the case ID, category,deduction name, start date and end date as the parameters.SQL
modifyPrioritynsmodifyOPTIMISTIC_LOCKING: no
Modifies the priority for the given provider deduction record identifier. 
searchByPrioritynsreadmultiWHERE: priority >= :priority
  
readLowestPrioritynsPRE_DATA_ACCESS: no
 
Returns the lowest provider deduction priority. The lowest priority returned will be the highest numerical value i.e. in a list of deductions with priorities 1, 2, 3, 4 and 5, the lowest priority would be 5.SQL
readActiveDeductionByProviderIDAndPrioritynsreadPRE_DATA_ACCESS: no
Returns an active provider deduction based on the provider and priority. 
searchForUnlinkedProviderDeductionsnsmulti Search for Provider Deductions whose associated Case Deduction Items have not been linked. SQL
searchForUnlinkedProviderDeductionCDIsnsmulti  SQL
Related Pages (99)
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)
Deductions (ProviderManagement_listActiveDeductionForProvider)
Applied and Un-applied Deductions: (ProviderManagement_listAppliedUnappliedDeductionForProvider)
Third Party Deductions: (ProviderManagement_listThirdPartyDeductionForProvider)
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)
Override Maximum Deduction Rate (ProviderManagement_setOverrideMDR)
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)
Override Maximum Deduction Rate (ProviderManagement_unsetOverrideMDR)
Update Placement Period (ProviderManagement_updateSamplePlacementPeriod)
Applied Deduction Details (ProviderManagement_viewAppliedDeductionDetails)
Provider Deduction History (ProviderManagement_viewAppliedProviderDeductionHistory)
Third Party Deduction Details (ProviderManagement_viewThirdPartyDeductionDetails)
View Provider Deduction History: (ProviderManagement_viewThirdPartyProviderDeductionHistory)
Un-applied Deduction Details (ProviderManagement_viewUnappliedDeductionDetails)
Provider Deduction History (ProviderManagement_viewUnappliedProviderDeductionHistory)
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)