Table Description
Service Delivery Evaluation: Comment entered regarding an evaluation of a service provided by a provider.

When evaluating a service, a case worker can specify an evaluation comment and also rate the service provider across various criterion. An evaluation comment can have multiple criteria evaluations associated with it.

Example

James Smith is attending counseling sessions provided by Dr. John Kelly for substance abuse issues. The case worker specifies a comment about the service provider and also rates the provider for punctuality,facilities, and staff. The provider scored 4 for punctuality, 5 for facilities and 4 for staff. This entity stores the comments entered when rating the service provider.
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::ServiceDelivery::ServiceEvaluation::Entity::ServiceDeliveryEvaluation
Controlling File: CPM\model\Packages\Service Layer\Service Delivery\ServiceDelivery.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
serviceDeliveryEvaluationIDkeynoUnique identifier of the service delivery evaluation note.INTERNAL_ID SVR_INT64
createdBydetails Unique username of the user who performed the service delivery evaluationUSER_NAME SVR_STRING<64>
creationDatedetails Date on which this service delivery evaluation was performed.CURAM_DATE SVR_DATE
commentsdetails Comment entered by a user about their evaluation of a service delivery.COMMENTS SVR_STRING<300>
recordStatusdetails Status of the SDECriterionEvaluation record, i.e. Active or CancelledRECORD_STATUS_CODERecordStatusSVR_STRING<10>
providerIDdetailsyesUnique identifier of the provider of the service being evaluated, if a provider has been specified on that service.CONCERN_ROLE_ID SVR_INT64
serviceOfferingIDdetailsnoUnique identifier of the service which is being evaluated.SERVICE_OFFERING_ID SVR_INT64
Foreign Keys (5)
ChildParent
ServiceDeliveryEvaluation.providerIDProvider.providerConcernRoleID
ServiceDeliveryEvaluation.serviceOfferingIDServiceOffering.serviceOfferingID
SDCriterionEvaluation.serviceDeliveryEvaluationIDServiceDeliveryEvaluation.serviceDeliveryEvaluationID
SDEvaluationOutcome.serviceDeliveryEvaluationIDServiceDeliveryEvaluation.serviceDeliveryEvaluationID
ServiceDelivery.serviceDeliveryEvaluationIDServiceDeliveryEvaluation.serviceDeliveryEvaluationID
Indices (2)
Index NameAttributes
ProviderServiceIdxproviderID, recordStatus, serviceOfferingID
SDEvalServiceOfferingIDIdxserviceOfferingID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: serviceDeliveryEvaluationID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
searchByProviderServiceAndStatusreadmultiORDER_BY: creationDate
Returns a list of service delivery evaluation records, sorted by creation date, for the specified provider, service and record status. 
Related Pages (8)