Table Description
Provider Offering Rate: The Provider Offering Rate is used to define the rate that applies at different times during the provision of the service by the provider.

A Fixed Amount or a Minimum and/or Maximum Amount must be specified.A single provider offering rate only may exist for a provider offering at any one given time.

Example

The organization can specify the rate of a range through a minimum amount of $50 and a maximum amount of $100 for a Bereavement Counseling service. The organization will pay anything between $50 and $100 for this service.

A minimum amount of $80 per session for a Physiotherapy service. The organization will pay from $80 for this service

A maximum amount of $150 for a Traditional Foster Care service. The organization will pay up to $150 for this service.

A fixed amount of $180 for a Special Needs Foster Care Service. The organization will pay a set amount of $180 for this service.

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 Service::Provider Offering Rate::Entity::ProviderOfferingRate
Controlling File: CPM\model\Packages\Service Layer\Provider Service\Provider Offering Rate\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
providerOfferingRateIDkeynoThe unique system generated identifier for the provider offering rate record.INTERNAL_ID SVR_INT64
providerOfferingIDdetailsnoThe unique system generated identifier for the provider offering record.INTERNAL_ID SVR_INT64
startDatedetails The date from which the provider offering rate applies to the provider offering. Any service offering received by a client from this particular provider from this date should be billed at this rate.CURAM_DATE SVR_DATE
endDatedetails The last date that the provider offering rate applies to the provider offering. Any service offering authorized to a client from this particular provider up to and including this date should be billed at this rate.CURAM_DATE SVR_DATE
minAmountdetailsyesThe minimum amount that the organization will pay for the service offering when being provided by a particular provider. This can be used in conjunction with the maximum amount to define a range within which payments for a service are valid.When a value is not entered by the user, this stores -1 as a sentinel value.CURAM_AMOUNT SVR_MONEY
maxAmountdetailsyesThe maximum amount that the organization will pay for the service offering when being provided by a particular provider. This can be used in conjunction with the minimum amount to define a range within which payments for a service are valid. When a value is not entered by the user, this stores -1 as a sentinel value.CURAM_AMOUNT SVR_MONEY
fixedAmountdetailsyesThe fixed amount that the organization will pay for the service offering when being provided by a particular provider. When a value is not entered by the user, this stores -1 as a sentinel value.CURAM_AMOUNT SVR_MONEY
commentsdetails Comments recorded by a user relating to the provider offering rate.COMMENTS SVR_STRING<300>
contractVersionIDdetailsyesThe unique system generated identifier for the contract version record.CONTRACT_VERSION_ID SVR_INT64
Foreign Keys (3)
ChildParent
ProviderOfferingRate.contractVersionIDContractVersion.contractVersionID
ProviderOfferingRate.providerOfferingIDProviderOffering.providerOfferingID
SILITransaction.providerRateIDProviderOfferingRate.providerOfferingRateID
Indices (3)
Index NameAttributes
ProviderOfferingRateIndex1contractVersionID
ProviderOfferingRateIndex2contractVersionID, providerOfferingID
ProviderOfferingRateIndex3providerOfferingID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: providerOfferingRateID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchByreadmulti This method lists all the Provider Offering Rates for a Provider Offering 
searchByProviderOfferingAndContractreadmultiORDER_BY: startDate, providerOfferingID, providerOfferingRateID
  
searchByContractreadmulti   
Related Pages (157)
Activate Contract (ProviderManagement_activateContract)
New Text Translation (ProviderManagement_addDescriptionTranslationToServiceOffering)
New Text Translation (ProviderManagement_addNameTranslationToServiceOffering)
New Performance Measure (ProviderManagement_addPOPerformanceMeasure)
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)
Service Invoice Line Item (ProviderManagement_approveordenySILI)
Approve Line Item (ProviderManagement_approvePendingSILI)
Approve Line Item (ProviderManagement_approvePendingSILICorrections)
Approve Line Item (ProviderManagement_approvePRLICorrectionFromView)
Approve Provider Roster Line Item Correction (ProviderManagement_approvePRLICorrections)
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 Line Item (ProviderManagement_cancelServiceInvoiceLineItem)
Cancel Service Invoice Line Items (ProviderManagement_cancelServiceInvoiceLineItems)
Cancel Service Invoice Line Item (ProviderManagement_cancelSILIFromTask)
Approve Line Items (ProviderManagement_confirmApproveServiceInvoiceLineItems)
Confirm cancel overlapping reservations (ProviderManagement_confirmCancelOverlappingActiveResForAnyClient)
Confirm Modify Overlapping Placements (ProviderManagement_confirmModifyOverlappingPlacementPrd)
Confirm modify overlapping placements (ProviderManagement_confirmModifyPlacementPrdForWL)
Submit Roster (ProviderManagement_confirmSubmitRoster)
Submit Roster (ProviderManagement_confirmSubmitRosterForFacilityManager)
Submit Line Item (ProviderManagement_confirmSubmitRosterLineItem)
Submit Line Items (ProviderManagement_confirmSubmitServiceInvoiceLineItems)
Confirm Suspend Provider (ProviderManagement_confirmSuspendProvider)
Confirm Transfer of Placement to Reservation (ProviderManagement_confirmTransferToReservation)
New Line Item (ProviderManagement_createNewServiceInvoiceLineItem)
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)
New Service (ProviderManagement_createServiceOffering)
New Payment Options (ProviderManagement_createServicePaymentOption)
New Service Rate (ProviderManagement_createServiceRate)
New Line Item (ProviderManagement_createSILICorrection)
New Training Service (ProviderManagement_createTrainingServiceOffering)
New Utilization Contract (ProviderManagement_createUtilizationContractForProvider)
New Rate (ProviderManagement_createUtilizationContractProviderOfferingRate)
Delete Service (ProviderManagement_deleteContractProviderOffering)
Delete Service (ProviderManagement_deleteContractProviderOfferingForProviderGroup)
Delete Contract (ProviderManagement_deleteUtilizationContractForProvider)
Delete Service (ProviderManagement_deleteUtilizationContractProviderOfferingForProvider)
Delete Service (ProviderManagement_deleteUtilizationContractProviderOfferingForProviderGroup)
Deny Line Item (ProviderManagement_denyServiceInvoiceLineItem)
Deny Service Invoice Line Items (ProviderManagement_denyServiceInvoiceLineItems)
Deny Service Invoice Line Item (ProviderManagement_denySILIFromTask)
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)
Generate Contract (ProviderManagement_generateContract)
Services (ProviderManagement_listAmendedProviderOfferingsForProviderGroup)
Performance Measures (ProviderManagement_listPOPerformanceMeasures)
ProviderManagement_listPOPlaceLimits
ProviderManagement_listPOPlaceLimitsForFacilityManager
ProviderManagement_listProviderServiceRate
ProviderManagement_listProviderServiceRateForFacilityManager
Services (ProviderManagement_listUtilizationContractProviderOfferingsForProviderGroup)
Performance Measure (ProviderManagement_listUtilizationPerformanceMeasureForAmendHistory)
Services (ProviderManagement_listUtilizationProviderOfferingsForAmendHistory)
Wait Lists (ProviderManagement_listWaitListEntryForProvider)
Provider Service Wait Lists: (ProviderManagement_listWaitListEntryForProviderOffering)
Edit Service Invoice Line Item (ProviderManagement_modifyEPServiceInvoiceLineItem)
Edit Flat Rate Contract (ProviderManagement_modifyFlatRateContractForProviderGroup)
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 Line Item (ProviderManagement_modifyServiceInvoiceLineItem)
Edit Provider Service (ProviderManagement_modifyServiceOfferingForProvider)
Edit Provider Service (ProviderManagement_modifyServiceOfferingForProviderFrmView)
Edit Utilization Contract (ProviderManagement_modifyUtilizationContractForProvider)
Edit Utilization Contract (ProviderManagement_modifyUtilizationContractForProviderGroup)
Edit Rate (ProviderManagement_modifyUtilizationContractProviderOfferingRate)
Place Client (ProviderManagement_placeSampleClient)
Preview Contract (ProviderManagement_previewContract)
Print Contract (ProviderManagement_printContract)
No Match Task Action (ProviderManagement_processSILIException)
Remove Client (ProviderManagement_removeClientFromServiceInvoiceLineItem)
Delete Provider (ProviderManagement_removeProviderFromProviderGroup)
Delete Provider Group (ProviderManagement_removeProviderGroupFromPGAssociation)
Delete Rate (ProviderManagement_removeProviderOfferingRate)
Renew Contract (ProviderManagement_renewContract)
Renew Contract (ProviderManagement_renewProviderGroupContract)
Wait Lists (ProviderManagement_searchWaitListForProvider)
Wait Lists (ProviderManagement_searchWaitListForProviderAndProviderOffering)
Wait List Search (ProviderManagement_searchWaitListForProviderOffering)
Submit Line Item (ProviderManagement_submitOpenSILIForProcessing)
Submit Roster Line Item (ProviderManagement_submitPRLIFromExceptionTask)
Submit Roster (ProviderManagement_submitRoster)
Submit Roster (ProviderManagement_submitRosterForFacilityManager)
Submit Line Item (ProviderManagement_submitRosterLineItem)
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)
Suspend Provider (ProviderManagement_suspendProvider)
Terminate Contract (ProviderManagement_terminateContract)
Transfer Client (ProviderManagement_transferClient)
Transfer Placement to Another Case (ProviderManagement_transferSamplePlacementToAnotherCase)
Reassessment Details (ProviderManagement_triggerReassessment)
Update Placement Period (ProviderManagement_updateSamplePlacementPeriod)
Edit Wait List Entry (ProviderManagement_updateWaitListEntry)
Utilization Contract: (ProviderManagement_viewAmendedContract)
Home (ProviderManagement_viewAmendedUtilizationContractForProviderGroup)
Completed Line Item (ProviderManagement_viewCompleteServiceInvoiceLineItem)
View Contract Service: (ProviderManagement_viewContractService)
ProviderManagement_viewEPServiceInvoiceLineItem
View Service Invoice Line Item: (ProviderManagement_viewInsertServiceInvoiceLineItem)
Price (ProviderManagement_viewProviderRatesForService)
Price (ProviderManagement_viewProviderRatesForServiceModal)
View Provider Service: (ProviderManagement_viewProviderServiceOffering)
ProviderManagement_viewProviderServiceOfferingForFacilityManager
View Provider Service Rate (ProviderManagement_viewProviderServiceOfferingRate)
Price (ProviderManagement_viewReferralProviderRatesForService)
Service Invoice Line Item (ProviderManagement_viewServiceInvoiceLineItem)
Service Invoice Line Item for Provider (ProviderManagement_viewServiceInvoiceLineItemForProvider)
View Service Invoice Line Item for Provider Group: (ProviderManagement_viewServiceInvoiceLineItemForProviderGroup)
Messages for Line Item (ProviderManagement_viewServiceInvoiceLineItemInfoMessages)
View Service Invoice Type Payment Detail for Provider: (ProviderManagement_viewSIPaymentForProvider)
View Service Invoice Type Payment Detail for Provider Group: (ProviderManagement_viewSIPaymentForProviderGroup)
Utilization Contract: (ProviderManagement_viewUtilizationContractForProvider)
Utilization Contract (ProviderManagement_viewUtilizationContractForProviderGroup)
Performance Measure (ProviderManagement_viewUtilizationContractPerformanceMeasureForProvider)
Service (ProviderManagement_viewUtilizationContractProviderOfferingForAmendHistory)
View Contract Service: (ProviderManagement_viewUtilizationContractProviderOfferingForProvider)
View Contract Service: (ProviderManagement_viewUtilizationContractProviderOfferingForProviderGroup)
Services (ProviderManagement_viewUtilizationContractProviderOfferings)
ProviderManagement_viewWaitListEntryFrmProvider
ProviderManagement_viewWaitListEntryFrmProviderOffering
ProviderManagement_viewWaitListEntryFrmProviderSearch
View Wait List Entry History: (ProviderManagement_viewWaitListEntryHistory)
ProviderManagement_viewWaitListEntryHistoryFrmProvider