Table Description
Plan Template Plan Group: A grouping of sub-goal(s) and other plan group(s) within a service plan template.

A plan group is created by a user as a means of logically grouping related sub-goals on a service plan template. It is also possible to add a plan group to other plan groups, further extending the flexibility of the service plan template structure. NOTE: Plan groups are administrable in service plan templates only.

Example

An administrator creates a Return to Work service plan template. A Self Sufficiency goal is selected for this template. A plan group is created which contains the Childcare sub-goal and the Transportation sub-goal. The Mileage Reimbursement and Childcare Provision plan items are added to these sub-goals to achieve the service plan template goal.

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::PlanTemplatePlanGroup::Entity::PlanTemplatePlanGroup
Controlling File: ServicePlans\model\Packages\Service Layer\Templates\PlanTemplatePlanGroup\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
LAST_UPDATED_FIELDyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
planTemplatePlanGroupIDkeynoUnique reference number assigned by the system to a template plan group record.PLAN_TEMPLATE_PLAN_GROUP_ID SVR_INT64
planTemplateIDdetails Unique reference number of the plan template to which the template plan group has been added.PLAN_TEMPLATE_ID SVR_INT64
parentGroupIDdetails Unique reference number of the parent plan group.PLAN_TEMPLATE_PLAN_GROUP_ID SVR_INT64
namedetailsyesName of the template plan group.PLAN_TEMPLATE_PLAN_GROUP_NAME SVR_STRING<50>
commentsdetails User entered remarks regarding the template plan group.COMMENTS SVR_STRING<300>
nameTextIDdetailsyes

Localized textID of name.

LOCALIZABLE_TEXT_ID SVR_INT64
commentsTextIDdetailsyes

Localized textID of comments.

LOCALIZABLE_TEXT_ID SVR_INT64
Foreign Keys (2)
ChildParent
PlanTemplatePlanGroup.commentsTextIDLocalizableText.localizableTextID
PlanTemplatePlanGroup.nameTextIDLocalizableText.localizableTextID
Indices (3)
Index NameAttributes
PTPlanGroupCommentsTextIDIndexcommentsTextID
PTPlanGroupNameTextIDIndexname, planTemplateID
IND_1065389055nameTextID
Operations (23)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: planTemplatePlanGroupID
AUTO_ID_KEY: SERCPLANBO
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifyDetailsnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Method to modify template plan group details. 
removeremovePRE_DATA_ACCESS: yes
Standard Operation 
searchParentPlanGroupsForTemplatensmulti @deprecated Since Curam 6.0, replaced with {@link PlanTemplatePlanGroup#searchParentPlanGroupNamesForTemplate()} as part of implementing localization of plan template plan group name. See release note: CR00235328. Method to search parent plan groups for a service plan template.SQL
searchChildPlanGroupsForTemplatensmulti Method to find all child plan groups for a service plan template.SQL
countByNameAndTemplateIDns Count the number of plan groups that share the same name as the one providedSQL
validateInsert  Validates the template plan group details. 
validateModify  Validates the modified details for a template plan group. 
readNamensread @Deprecated Since curam 6.0, replaced by {@Link PlanTemplatePlanGroup#readNameDetails()} see release note:CR00235328. Reads a plan group name 
validateRemove  Validates plan template plan group cancellation. 
removeChildRecords  Removes all child records for a given plan group 
getParentPlanGroupDetailsnsmulti Reads all the parent plan groups for a specified template.SQL
getChildPlanGroupDetailsnsmulti Gets all child plan groups for a parent plan group.SQL
readPlanTemplateIDAndParentGroupIDnsread Reads the planTemplateID and parentGroupID for the PlanTemplatePlanGroup record. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies a row of data from plan template plan group table. 
searchByPlanTemplateIDreadmulti Returns all columns of plan template plan group for the given plan template ID. 
insertPlanTemplatePlanGroupinsert <p class="MsoNormal"> <span style="COLOR: #002060">Inserts plan template plan group record. This method expects the planTemplatePlanGroupID to be set. It is preferred to call <font color="#000000">insertPlanTemplatePlanGroup</font> method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
modifyCommentsTextIDnsmodify Modifies commentsTextID. 
modifyNameTextIDnsmodify Modifies nameTextID. 
readNameDetailsnsread Reads a plan group name and nameTextID. 
searchParentPlanGroupNamesForTemplatensmulti Method to search parent plan groups for a service plan template.SQL
readLastWrittenns Reads the last updated time of the template plan group.SQL
Related Pages (13)