Table Description
SPMilestoneDeliveryLink: A milestone is a significant event or task which will be completed during the life cycle of a milestone configuration type. A review may take place two weeks from the start of a milestone type and it may need to be send to a plan participant at certain points of the milestone types lifecycle. Milestones can be used to facilitate these events.

This entity is used to store data relating to the plan groups and sub goals to which milestones have been added within a service plan.
Model Details
Location in Model: Logical View::MetaModel::Curam::ServicePlans::Service Plan Deliveries::SPMilestoneDeliveryLink::Entity::SPMilestoneDeliveryLink
Controlling File: ServicePlans\model\Packages\Service Layer\Service Plan Deliveries\SPMilestoneDeliveryLink\Entity\Entity_cat.efx
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
spMilestoneDeliveryLinkIDkeynoUnique identifier assigned by the system to this milestone link record.SP_MILESTONE_DELIVERY_LINK_ID SVR_INT64
milestoneDeliveryIDdetails Unique identifier of the milestone record.MILESTONE_DELIVERY_ID SVR_INT64
plannedGroupIDdetails Unique identifier of the planned group to which this milestone has been added.PLANNED_GROUP_ID SVR_INT64
plannedSubGoalIDdetails Unique identifier of the planned sub goal to which this milestone has been added.PLANNED_SUBGOAL_ID SVR_INT64
Indices (1)
Index NameAttributes
IND__744324703milestoneDeliveryID
Operations (26)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: spMilestoneDeliveryLinkID
Standard Operation 
searchUncompletedMilestonesForServicePlannsmulti @deprecated since curam 6.0, replaced by {@Link SPMilestoneDeliveryLink#searchUncompletedMilestonesForServicePlan1()} See release note:CR00236426 This method builds the default list of milestones for a service plan. This list contains milestones at service plan level with a status of Not Started or In Progress.SQL
removeremove Method to remove a SPMilestoneDeliveryLink record. 
readSPMSDelLinkIDByMSDelIDnsread Reads the SPMilestoneDeliveryLinkID using the milestoneDeliveryID. 
searchMilestonesByPlannedGroupIDnsmulti @deprecated since curam 6.0, replaced by {@Link SPMilestoneDeliveryLink#searchMilestonesByPlannedGroupID()}. See release note:CR00236426 Method to list milestone deliveries for a planned group.SQL
searchMilestonesByPlannedSubGoalIDnsmulti @deprecated since curam 6.0, replaced by {@Link SPMilestoneDeliveryLink#searchMilestonesByPlannedSubGoalID1()} See release note:CR00236426 Method to list milestone deliveries for a planned sub goal.SQL
searchMilestonesAndLinksByCaseIDnsmulti Method to retrieve a list of milestones created at service plan level and their service plan link details.SQL
searchMilestonesAndLinksByCaseIDAndPlannedGroupIDnsmulti Method to retrieve a list of milestones created at planned group level and their service plan link details.SQL
searchMilestonesAndLinksByCaseIDAndPlannedSubGoalIDnsmulti Method to retrieve a list of milestones created at planned sub-goal level and their service plan link details.SQL
searchMilestonesForBaselineByCaseID1nsmulti Searches details of all milestones required for baseline milestone creation at service plan level.SQL
searchMilestonesForBaselineByPlannedGroupIDnsmulti @deprecated since curam 6.0, replaced by {@Link SPMilestoneDeliveryLink#searchMilestonesForBaselineByPlannedGroupID1()} See release note: CR00236665 Searches details of all milestones required for baseline milestone creation at planned group level.SQL
searchMilestonesForBaselineByPlannedSubGoalIDnsmulti @deprecated since curam 6.0, replaced by {@Link SPMilestoneDeliveryLink#searchMilestonesForBaselineByPlannedSubGoalID1()} See release note: CR00236665 Searches details of all milestones required for baseline milestone creation at planned subgoal level.SQL
countMilestonesForPlannedSubGoalns Returns a number of milestones specified for a planned sub goal.SQL
countMilestonesForPlannedGroupns Returns a number of milestones specified for a planned group.SQL
searchTrackingGanttDetailsByCaseIDnsmulti @deprecated since curam 6.0, replaced by {@Link SPMilestoneDeliveryLink#searchTrackingGanttDetailsByCaseID1()} See release note:CR00236426 Method to search milestones created at service plan level for display on tracking gantt.SQL
searchTrackingGanttDetailsByPlannedGroupIDnsmulti @deprecated since curam 6.0, replaced by {@Link SPMilestoneDeliveryLink#searchTrackingGanttDetailsByPlannedGroupID1()} See release note: CR00236665 Method to search milestones created at plan group level for display on tracking gantt.SQL
searchTrackingGanttDetailsByPlannedSubGoalIDnsmulti @deprecated since curam 6.0, replaced by {@Link SPMilestoneDeliveryLink#searchTrackingGanttDetailsByPlannedSubGoalID1()} See release note:CR00236426 Method to search milestones created at sub-goal level for display on tracking gantt.SQL
searchUncompletedMilestonesForServicePlan1nsmulti This method builds the default list of milestones for a service plan. This list contains milestones at service plan level with a status of Not Started or In Progress.SQL
searchMilestonesByPlannedSubGoalID1nsmulti Method to list milestone deliveries for a planned sub goal.SQL
searchTrackingGanttDetailsByCaseID1nsmulti Method to search milestones created at service plan level for display on tracking gantt.SQL
searchMilestonesByPlannedGroupID1nsmulti Method to list milestone deliveries for a planned group.SQL
searchTrackingGanttDetailsByPlannedSubGoalID1nsmulti Method to search milestones created at sub-goal level for display on tracking gantt.SQL
searchTrackingGanttDetailsByPlannedGroupID1nsmulti Method to search milestones created at plan group level for display on tracking gantt.SQL
searchMilestonesForBaselineByCaseIDnsmulti @deprecated since curam 6.0, replaced by {@Link SPMilestoneDeliveryLink#searchMilestonesForBaselineByCaseID1()} See release note: CR00236665 Searches details of all milestones required for baseline milestone creation at service plan level.SQL
searchMilestonesForBaselineByPlannedGroupID1nsmulti Searches details of all milestones required for baseline milestone creation at planned group level.SQL
searchMilestonesForBaselineByPlannedSubGoalID1nsmulti Searches details of all milestones required for baseline milestone creation at planned subgoal level.SQL
Related Pages (39)
Tracking Gantt (IntegratedServicePlan_trackingGantt)
Add Milestone (ServicePlanDelivery_addMilestone)
Approve Service Plan (ServicePlanDelivery_approve)
Clone Service Plan (ServicePlanDelivery_clone)
New Baseline (ServicePlanDelivery_createBaseline)
Delete Plan Group (ServicePlanDelivery_deletePlannedGroup)
Delete Plan Group (ServicePlanDelivery_deletePlannedGroupFromGantt)
Delete Sub-Goal (ServicePlanDelivery_deletePlannedSubGoal)
Delete Sub-Goal (ServicePlanDelivery_deletePlannedSubGoal_fromGantt)
Service Plan Home: (ServicePlanDelivery_home)
Home (ServicePlanDelivery_home1)
Service Plan Home (ServicePlanDelivery_homeTransaction)
Milestones (ServicePlanDelivery_listAllISPMilestones)
Milestones (ServicePlanDelivery_listAllSPGMilestone)
View Plan Group Details (ServicePlanDelivery_listGroupItems)
View Plan Group Details (ServicePlanDelivery_listGroupMilestones)
Milestones (ServicePlanDelivery_listISPMilestones)
View Sub-Goal Milestones (ServicePlanDelivery_listMilestones)
Plan Content (ServicePlanDelivery_listPlanContentForSP)
View Sub-Goal Plan Items (ServicePlanDelivery_listPlanItems)
Milestones (ServicePlanDelivery_listSPGMilestone)
Milestones (Incomplete) (ServicePlanDelivery_listUncompletedMilestonesForServicePlan)
Edit Plan Group (ServicePlanDelivery_modifyPlannedGroupFromGantt)
Edit Plan Group (ServicePlanDelivery_modifyPlannedGroupFromList)
Edit Plan Group (ServicePlanDelivery_modifyPlannedGroupFromView)
Delete Milestone (ServicePlanDelivery_removeMilestone)
- (ServicePlanDelivery_servicePlanTabDetails)
Submit Service Plan (ServicePlanDelivery_submit)
Tracking Gantt (ServicePlanDelivery_trackingGantt)
Use Service Plan Template (ServicePlanDelivery_useTemplate)
View Plan Group Details (ServicePlanDelivery_viewPlannedGroup)
Plan Group Details (ServicePlanDelivery_viewPlannedGroupFromGantt)
View Sub-Goal Details (ServicePlanDelivery_viewPlannedSubGoal)
Sub-Goal Details (ServicePlanDelivery_viewPlannedSubGoal_fromGantt)
Service Plan Home: (ServicePlanDeliveryDetails_home)
Service Plan Group Home (ServicePlanGroupDelivery_home)
Service Plan Group Home (ServicePlanGroupDelivery_homeActiveOnly)
- (ServicePlanGroupDelivery_tabDetails)
Tracking Gantt (ServicePlanGroupDelivery_trackingGantt)