Table Description
Plan Template Service Plan Link: A relationship between a service plan and a plan template.

This entity allows the administration of the link between templates and service plans within Service Planning Administration.

Example

A case worker creates a Return to Work service plan for participant Linda Smith as she has recently become unemployed. He chooses to use a predefined template which consists of a Sustainable Employment goal, Transportation and Childcare sub-goals and Mileage Reimbursement and Childcare Provision plan items. The following was performed in the administration component to achieve this:

  • An administrator creates a Return to Work Template with a Sustainable Employment goal.
  • Transportation and Childcare sub-goal are linked to the goal, and Mileage Reimbursement and Childcare Provision plan items to these sub-goals
    • .
  • This template is then associated with a Return to Work service plan.
This link entity enables the sharing and reuse of templates across multiple service plans.

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::Templates::PlanTemplate::LinkTable::PlanTemplateServicePlanLink::Entity::PlanTemplateServicePlanLink
Controlling File: ServicePlans\model\Packages\Service Layer\Templates\PlanTemplate\LinkTable\PlanTemplateServicePlanLink\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
planTemplateServicePlanLinkIDkeynoUnique reference number assigned by the system to a plan template service plan record.PLAN_TEMPLATE_SERVICE_PLAN_LINK_ID SVR_INT64
planTemplateIDdetailsnoUnique reference number of the plan template which has been associated with the service plan. Links the plan template to the related service plan.PLAN_TEMPLATE_ID SVR_INT64
servicePlanIDdetailsnoUnique reference number of the service plan with which the plan template has been associated.SERVICE_PLAN_ID SVR_INT64
Foreign Keys (2)
ChildParent
PlanTemplateServicePlanLink.planTemplateIDPlanTemplate.planTemplateID
PlanTemplateServicePlanLink.servicePlanIDServicePlan.servicePlanID
Indices (2)
Index NameAttributes
PTSPLTemplateIndexplanTemplateID, servicePlanID
PTSPLPlanIndexservicePlanID
Operations (10)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: planTemplateServicePlanLinkID
AUTO_ID_KEY: SERCPLANBO
Standard Operation 
readread Standard Operation 
removeByPlanTemplateAndServicePlannsremove   
countByServicePlanAndTemplatens  SQL
countByServicePlanPlanTemplateAndStatusns Counts service plans that the plan template is associated with.SQL
searchByServicePlanIDnsmulti Returns list of planTemplateIDs and planTemplateNames for all plan templates assigned to a service plan.SQL
searchByServicePlanreadmulti Returns all columns of plan template service plan link for the given service plan ID. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies a row of data from plan template service plan link table. 
insertPlanTemplateServicePlanLinkinsert <p class="MsoNormal"> <span style="COLOR: #002060">Inserts plan template service plan link record. This method expects the planTemplateServicePlanLinkID to be set. It is preferred to call insertPlanTemplateServicePlanLink method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
searchLocalizedNameByServicePlanIDnsmulti  SQL
Related Pages (5)