Table Description
Plan Template Milestone: A milestone is a significant event or task which will be completed during the life cycle of a milestone configuration type. Milestones can be added to service plan templates at the plan template level, the plan group level and the sub goal level.

This table provides the link between plan templates and milestones. This entity is focused solely on the administration of template milestones within the Service Planning Administration component.

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::PlanTemplateMilestone::Entity::PlanTemplateMilestone
Controlling File: ServicePlans\model\Packages\Service Layer\Templates\PlanTemplateMilestone\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
LAST_UPDATED_FIELDyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
planTemplateMilestoneIDkeynoUnique reference number assigned by the system to the plan template milestone record.PLAN_TEMPLATE_MILESTONE_ID SVR_INT64
milestoneConfigurationIDdetails Unique reference number of the milestone configuration on which the plan template milestone is based.MILESTONE_CONFIGURATION_ID SVR_INT64
planTemplateIDdetails Unique reference number of the plan template to which this milestone has been added.PLAN_TEMPLATE_ID SVR_INT64
planTemplatePlanGroupIDdetails Unique reference number of the plan template plan group to which this milestone has been added.PLAN_TEMPLATE_PLAN_GROUP_ID SVR_INT64
planTemplateSubGoalIDdetails Unique reference number of the plan template sub goal to which this milestone has been added.PLAN_TEMPLATE_SUBGOAL_ID SVR_INT64
startAfterdetails The number of days after the service plan start date that this milestone is due to start.NUMBER_OF_DAYS SVR_INT32
durationdetails The length of time this milestone is expected to take.NUMBER_OF_DAYS SVR_INT32
commentsdetailsyesGeneral remarks entered by the user.COMMENTS SVR_STRING<300>
commentsTextIDdetailsyes Unique Identifier corresponding to localized comments of PlanTemplateMilestone.LOCALIZABLE_TEXT_ID SVR_INT64
Foreign Keys (1)
ChildParent
PlanTemplateMilestone.commentsTextIDLocalizableText.localizableTextID
Indices (1)
Index NameAttributes
PTMilestoneCmntsTxtIDIdxcommentsTextID
Operations (25)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: planTemplateMilestoneID
AUTO_ID_KEY: SERCPLANBO
PRE_DATA_ACCESS: yes
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
removeremovePRE_DATA_ACCESS: yes
Standard Operation 
validateInsert  Method to validate the details being inserted. 
validateModify  Method to validate the details being modified. 
validateRemove  Method to validate that the template milestone can be removed. 
validateDetails  Method to validate the common template milestone details. 
readDetailsns  @deprecated Since Curam 6.0, replaced with {@link PlanTemplateMilestone#readMilestoneDetails()} as part of implementing localization of plan template milestone description. See release note : CR00229083. Method to read the template milestone details. SQL
searchByPlanTemplateIDnsmulti Method to return a list of milestones added at the template level.SQL
searchByPlanTemplatePlanGroupIDnsmulti Method to return a list of milestones created at plan group level.SQL
searchByPlanTemplateSubGoalIDnsmulti Method to return a list of milestones created at sub goal level.SQL
readPlanTemplateIDPlanGroupIDAndSubGoalIDnsread Method to read the planTemplateID, planTemplatePlanGroupID and planTemplateSubGoalID for a milestone. 
countByMilestoneConfigurationIDns Counts the number of plan template milestone records for a specified milestone configuration.SQL
searchServicePlanLevelMilestonesnsmulti Method to return template milestones configured at service plan level.SQL
searchPlanGroupLevelMilestonesnsmulti Method to return template milestones configured at plan group level.SQL
searchSubGoalLevelMilestonesnsmulti Method to return template milestones configured at subgoal level.SQL
readread Reads a row of data from plan template milestone table. 
insertPlanTemplateMilestoneinsert <p class="MsoNormal"> <span style="COLOR: #002060">Inserts plan template milestone record. This method expects the planTemplateMilestoneID to be set. It is preferred to call <font color="#000000">insertPlanTemplateMilestone</font> method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
modifyCommentsTextIDnsmodifyOPTIMISTIC_LOCKING: yes
Modifies commentsTextID. 
readMilestoneDetailsns Method to read the template milestone details.SQL
modifyPlanTemplateMilestonemodifyOPTIMISTIC_LOCKING: yes
This modify operation will be called while re-applying a change set in the target system. Entity level validations that will happen during a standard modify operation will not be applicable in this case. This modify operation will update all the attributes defined for this entity. 
readLastWrittenns Reads the last updated time of the template milestone.SQL
searchMilestoneAndIdsByPlanTemplatensmulti Returns the list of milestones and the related IDs created at a plan level in the in a service plan template.SQL
searchMilestoneAndIDsByPlanTemplatePlanGroupnsmulti Returns the list of milestones and the related IDs created at a plan group level in the in a service plan template.SQL
searchMilestoneAndIDsByPlanTemplateSubGoalnsmulti Returns the list of milestones and the related IDs created at a sub goal level in the in a service plan template.SQL
Related Pages (15)