Table Description
Service Delivery Link: A link between a service and other tables e.g. client.

A service can be added to any type of case and an outcome plan. This entity stores the link between a service and a client.

Example

James Smith's strengths and needs were assessed and it was identified that he had an issue with substance abuse and also had mental health issues. An outcome plan was created to address these issues. 10 sessions of counseling were scheduled to deal with his substance abuse issues. This entity stores the link between counseling and James Smith.
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::ServiceDelivery::Entity::ServiceDeliveryLink
Controlling File: CPM\model\Packages\Service Layer\Service Delivery\ServiceDelivery.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
serviceDeliveryLinkIDkeynoUnique reference number assigned by the system to a ServiceDelivery record.INTERNAL_ID SVR_INT64
serviceDeliveryIDdetailsnoUnique reference number of the ServiceDelivery record this link record is created for.INTERNAL_ID SVR_INT64
relatedIDdetailsnoUnique reference number of the record we want to link to the Service Delivery.INTERNAL_ID SVR_INT64
relatedTypedetailsnoCodetable value representing the type of the record we are linking to the Service Delivery.SERVICE_DEL_RELATED_TYPEServiceDelRelatedTypeSVR_STRING<10>
recordStatusdetailsnoStatus of the ServiceDeliveryLink.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
ServiceDeliveryLink.serviceDeliveryIDServiceDelivery.serviceDeliveryID
Indices (3)
Index NameAttributes
SDelLinkSDRltdIDTypeStsIdxserviceDeliveryID, relatedID, recordStatus, relatedType
SDLinkRltdIDTypeStsIdxrelatedID, relatedType, recordStatus
SDelLinkSDRltdTypeStsIdxserviceDeliveryID, relatedType, recordStatus
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: serviceDeliveryLinkID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByRelatedIDTypeAndStatusreadmulti Returns a list of service delivery link records of the specified relatedID, type and record status. 
searchByServiceDeliveryRelatedTypeAndStatusreadmulti Returns a list of service delivery link records for the specified service delivery, relatedType and record status. 
readByServiceDeliveryRelatedIDTypeAndStatusnsread Returns a service delivery link record of the specified service delivery, relatedID, type and record status. 
Related Pages (0)