Table Description
Service Plan Group Delivery Attachment Link.: Entity to hold the relationship between the attachments and the service plan group delivery details. This table represents the link between a service plan group and a attachment.

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 attaches a copy of Linda’s latest doctor’s report to the Health Care service plan group.
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::SPGDeliveryAttachmentLink
Controlling File: ServicePlans\model\Packages\Service Layer\Service Plan Deliveries\ServicePlanGroupDelivery\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
deliveryAttachmentLinkIdkeynoAttribute to uniquely identify the service plan group delivery Attachment link record.INTERNAL_ID SVR_INT64
attachmentIddetails Attribute to uniquely identify the attachment record.ATTACHMENT_ID SVR_INT64
servicePlanGroupDeliveryIddetailsnoAttribute to uniquely identify the service plan group delivery note link record.INTERNAL_ID SVR_INT64
statusdetails Attribute to store the status of the record. Can be either ACTIVE(Value= RST1) or CANCELLED(Value = RST2)RECORD_STATUSRecordStatusSVR_STRING<10>
attachmentDatedetails Date on which the attachment was added to the Case.CURAM_DATE SVR_DATE
descriptiondetails Free text description of the service plan group delivery attachment.DESCRIPTION SVR_STRING<300>
caseParticipantRoleIDdetails The member whom the attachment is concerning.CASE_PARTICIPANT_ROLE_ID SVR_INT64
Foreign Keys (1)
ChildParent
SPGDeliveryAttachmentLink.servicePlanGroupDeliveryIdSPGDelivery.servicePlanGroupDeliveryId
Indices (2)
Index NameAttributes
attachmentIDKeyIdxattachmentId
SPGDelAttIdxservicePlanGroupDeliveryId
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchByServicePlanGroupDeliveryIdreadmulti This method is used to fetch spgDeliveryAttachmentLink by service plan group delivery ID. 
cancelLinknsmodify This method is used to cancel the link between Attachment and service plan group delivery link ID. 
readByAttachmentIDnsread This method is used to fetch spgDeliveryAttachmentLink by attachmentID 
Related Pages (5)