Table Description
Service Rate: The rate and payment options that apply to a service offering.

The service rate is the amount the organization is willing to pay their providers for a service.

Example

A minimum amount of $50 and a maximum amount of $100 for a Bereavement Counseling 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::Service Offering::Service Rate::Entity::ServiceRate
Controlling File: CPM\model\Packages\Service Layer\Service Offering\Service Rate\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
serviceRateIDkeynoThe unique system generated identifier for the Service Rate record.SERVICE_RATE_ID SVR_INT64
serviceOfferingIDdetailsnoThe unique system generated identifier for the service rate.SERVICE_OFFERING_ID SVR_INT64
startDatedetails The date from which the service rate and payment options apply to the service offering.CURAM_DATE SVR_DATE
endDatedetails The last date on which the service rate and payment options apply to the service offering.CURAM_DATE SVR_DATE
minAmountdetails The minimum amount that the organization will pay for the service offering. When a value is not entered by the user, this stores -1 as a sentinel value.CURAM_AMOUNT SVR_MONEY
maxAmountdetails The maximum amount that the organization will pay for the service offering. When a value is not entered by the user, this stores -1 as a sentinel value.CURAM_AMOUNT SVR_MONEY
fixedAmountdetails The fixed amount that the organization will pay for the service offering. 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 service rate.COMMENTS SVR_STRING<300>
Foreign Keys (2)
ChildParent
ServiceRate.serviceOfferingIDServiceOffering.serviceOfferingID
SILITransaction.serviceRateIDServiceRate.serviceRateID
Indices (1)
Index NameAttributes
ServiceRateIndex1serviceOfferingID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: serviceRateID
AUTO_ID_KEY: SEROFF
Creates a new row on ServiceRate table. 
readread Reads a row of data from ServiceRate table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on ServiceRate table. 
searchByServiceOfferingreadmulti Searches records from ServiceRate table using service offering name. 
insertServiceRatensinsert Creates a new row on ServiceRate table and it should be used only when the user is passing the primary id. 
Related Pages (147)
New Text Translation (ProviderManagement_addDescriptionTranslationToServiceOffering)
New Text Translation (ProviderManagement_addNameTranslationToServiceOffering)
New Service (ProviderManagement_addServiceOfferingForProvider)
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 Provider (ProviderManagement_approveProvider)
Approve Provider Service (ProviderManagement_approveProviderServiceOffering)
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)
Close Provider (ProviderManagement_closeProvider)
Close Provider Group (ProviderManagement_closeProviderGroup)
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 Approval Criteria (ProviderManagement_createApprovalCriterion)
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 Approval Check (ProviderManagement_createServiceOfferingApprovalCheck)
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)
Reject Provider Service (ProviderManagement_denyApproveProviderServiceOffering)
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)
Enroll Provider (ProviderManagement_enrollAsProvider)
Enroll Provider Group (ProviderManagement_enrollAsProviderGroup)
Enroll Provider (ProviderManagement_enrollProvider)
Transfer to Provider (ProviderManagement_enrollProviderFromEnquiry)
Enroll Provider Group (ProviderManagement_enrollProviderGroup)
Services (ProviderManagement_listAmendedProviderOfferingsForProviderGroup)
Approval Criteria (ProviderManagement_listApprovalCriterion)
Contract Text (ProviderManagement_listContractTextForServiceOffering)
Good Causes for Service:# END, CR00260713 (ProviderManagement_listGoodCauseForServiceOffering)
Expected Outcomes for Service:# END, CR00260713 (ProviderManagement_listOutcomesForServiceOffering)
Rates (ProviderManagement_listRatesForServiceOffering)
Payment Options (ProviderManagement_listServicePaymentOption)
Performance Measures (ProviderManagement_listSOPerformanceMeasure)
Training Requirements (ProviderManagement_listTrainingRequirementsForServiceOffering)
Services (ProviderManagement_listUtilizationContractProviderOfferingsForProviderGroup)
Performance Measure (ProviderManagement_listUtilizationPerformanceMeasureForAmendHistory)
Services (ProviderManagement_listUtilizationProviderOfferingsForAmendHistory)
Edit Service Invoice Line Item (ProviderManagement_modifyEPServiceInvoiceLineItem)
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 Utilization Contract (ProviderManagement_modifyUtilizationContractForProvider)
Edit Utilization Contract (ProviderManagement_modifyUtilizationContractForProviderGroup)
Edit Rate (ProviderManagement_modifyUtilizationContractProviderOfferingRate)
Place Client (ProviderManagement_placeSampleClient)
No Match Task Action (ProviderManagement_processSILIException)
Reject Provider (ProviderManagement_rejectProvider)
Remove Client (ProviderManagement_removeClientFromServiceInvoiceLineItem)
Renew Contract (ProviderManagement_renewContract)
Renew Contract (ProviderManagement_renewProviderGroupContract)
Re-Open Provider (ProviderManagement_reopenProvider)
Re-Open Provider Group (ProviderManagement_reOpenProviderGroup)
Step 2: Enroll Provider (ProviderManagement_sampleEnrollProvider)
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)
Transfer Client (ProviderManagement_transferClient)
Transfer Placement to Another Case (ProviderManagement_transferSamplePlacementToAnotherCase)
Reassessment Details (ProviderManagement_triggerReassessment)
Update Placement Period (ProviderManagement_updateSamplePlacementPeriod)
Utilization Contract: (ProviderManagement_viewAmendedContract)
Home (ProviderManagement_viewAmendedUtilizationContractForProviderGroup)
Completed Line Item (ProviderManagement_viewCompleteServiceInvoiceLineItem)
ProviderManagement_viewEPServiceInvoiceLineItem
View Service Invoice Line Item: (ProviderManagement_viewInsertServiceInvoiceLineItem)
Delivery (ProviderManagement_viewServiceDeliveryConfiguration)
Service (ProviderManagement_viewServiceForResourceMgr)
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)
Home (ProviderManagement_viewServiceOfferingFrmList)
Home (ProviderManagement_viewServiceOfferingFrmServiceGroup)
Home (ProviderManagement_viewServiceOfferingFromSearch)
ProviderManagement_viewServiceOfferingTabDetails
Service Rate: (ProviderManagement_viewServiceRate)
View Service Invoice Type Payment Detail for Provider: (ProviderManagement_viewSIPaymentForProvider)
View Service Invoice Type Payment Detail for Provider Group: (ProviderManagement_viewSIPaymentForProviderGroup)
Home (ProviderManagement_viewTrainingServiceOfferingFrmList)
Utilization Contract: (ProviderManagement_viewUtilizationContractForProvider)
Utilization Contract (ProviderManagement_viewUtilizationContractForProviderGroup)
Performance Measure (ProviderManagement_viewUtilizationContractPerformanceMeasureForProvider)
Services (ProviderManagement_viewUtilizationContractProviderOfferings)