Table Description
Service Plan Group Delivery Link.: Entity to hold the link between case id and the service plan group delivery. This table represents the link between a service plan group and a service plan within an integrated case.

Example

A case worker creates an integrated case for participant Linda Smith who has recently been involved in a work related accident. Within the integrated service plan view, he then creates a Health Care service plan group, so that all service plans created for Linda with health care related goals can be grouped and managed together. He then creates a Short Term Disability service plan within the Health Care service plan group. The following has been set up in the Administration component to achieve this: An administrator creates a Health Care service plan group. A Short Term Disability service plan is associated to the Health Care service plan group. The service plan can now be added to the service plan group within the integrated service plan view of the integrated case.
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::ServicePlans::Service Plan Deliveries::ServicePlanGroupDelivery::Entity::SPGDeliveryLink
Controlling File: ServicePlans\model\Packages\Service Layer\Service Plan Deliveries\ServicePlanGroupDelivery\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGno
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
servicePlanGroupDeliveryLinkIdkeynoService Plan Group Delivery Link identifier. Uniquely identifies each record.INTERNAL_ID SVR_INT64
servicePlanGroupDeliveryIddetailsnoService Plan Group Delivery identifier.INTERNAL_ID SVR_INT64
caseIDdetails Case identifier.CASE_ID SVR_INT64
Foreign Keys (1)
ChildParent
SPGDeliveryLink.servicePlanGroupDeliveryIdSPGDelivery.servicePlanGroupDeliveryId
Indices (2)
Index NameAttributes
SPGDelLnkCaseIDIdxcaseID
SPGDlLnkSPGDlIDIdxservicePlanGroupDeliveryId
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
removeremove Standard Operation 
searchServicePlanDeliveriesByServicePlanGroupDeliveryIdnsreadmulti Method to get the list of SPGDelivery Link details for the given SPG Delivery id. 
readServicePlanGroupDeliveryIdByCaseIdnsread Method to get the details of the SPGDelivery for the given integrated case id. 
searchServicePlanDeliveryStatusnsmulti Returns the service plan deliveries for a service plan group and the associated status.SQL
Related Pages (18)