Table Description
Service Plan Group Delivery: Entity to hold Service Plan Group Delivery details. This holds the relationship between the Integrated case id, Service Plan Group ID and Service Plan Group Delivery reference. This table represents the link between a service plan group and 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. The following has been set up in the Administration component to achieve this: An administrator creates a Health Care service plan group. The service plan group is now selectable as above for any type of 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::SPGDelivery
Controlling File: ServicePlans\model\Packages\Service Layer\Service Plan Deliveries\ServicePlanGroupDelivery\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
servicePlanGroupDeliveryIdkeynoPrimary Key of the record. Uniquely identifies each record.INTERNAL_ID SVR_INT64
integratedCaseIDdetails Integrated Case identifier.CASE_ID SVR_INT64
creationDatedetails Service Plan Group Delivery Creation dateCURAM_DATE SVR_DATE
servicePlanGroupIddetails Service Plan Group identifier.SERVICE_PLAN_GROUP_ID SVR_INT64
spgdReferencedetails Service Plan Group Delivery reference.CASE_REFERENCE SVR_STRING<40>
Foreign Keys (3)
ChildParent
SPGDeliveryAttachmentLink.servicePlanGroupDeliveryIdSPGDelivery.servicePlanGroupDeliveryId
SPGDeliveryLink.servicePlanGroupDeliveryIdSPGDelivery.servicePlanGroupDeliveryId
SPGDeliveryNoteLink.servicePlanGroupDeliveryIdSPGDelivery.servicePlanGroupDeliveryId
Indices (2)
Index NameAttributes
integratedCaseIDKeyIdxintegratedCaseID
IND_1944249565servicePlanGroupId
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsert Method to insert the SPGDelivery details 
readread Standard read method for getting the details of SPGDelivery records. 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard modify method for updating the SPGDelivery records. 
searchByServicePlanGroupIdAndCaseIdnsreadmulti Method to get the SPGDelivery details for the given Service Plan Group Id and the Case Id 
readCaseIdByServicePlanGroupDeliveryIdnsread Method to read the integrated case id details of SPGDelivery using the SPGDelivery ID 
searchByIntegratedCaseIdreadmulti Method to get the list of SPGDelivery records for the given integrated case id. 
Related Pages (28)