Table Description
Baseline Milestone: A snapshot of a milestone present on a service plan at the time the baseline was created.

When a baseline is created, the service plan goal, plan group(s), sub-goal(s),plan item(s) and milestones present on the plan at that time are recorded. Baselines can be automatically created by the system at specific points in the delivery of the service plan and may also be manually created by the user. Baselines are created by the system when a service plan is submitted for approval and on plan approval. Creation of these baselines is controlled by an environment variables allowing the customer to enable/disable this processing. This entity holds the details of any milestone(s) present on a service plan at the time the baseline is created.

Example

A case worker creates a Return to Work service plan for participant Linda Smith as she has recently become unemployed. A Review milestone is added so that a review takes place 14 days after the plan was created. A Sustainable Employment goal is selected for this service plan. Linda Smith is unable to pay for transport to get to work and also needs assistance paying for childcare. A plan group is created which contains a Childcare sub-goal to meet Linda's need to get care for her dependents and a Transportation sub-goal to overcome her transportation barrier preventing her from gaining sustainable employment. The Mileage Reimbursement and Childcare Provision plan items are added to the service plan to achieve the service plan sub-goals.

The service plan is submitted for approval and a submission baseline is created. The baseline milestone entity stores the details of the milestone(s) present on the service plan at the time the baseline is created.

Model Details
Location in Model: Logical View::MetaModel::Curam::ServicePlans::Service Plan Deliveries::Baseline::Entity::BaselineMilestone
Controlling File: ServicePlans\model\Packages\Service Layer\Service Plan Deliveries\Baseline\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (11)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
baselineMilestoneIDkeynoUnique identifier assigned by the system to this baseline milestone record.BASELINE_MILESTONE_ID SVR_INT64
baselineIDdetails Unique identifier of the baseline on which this milestone has been recorded.BASELINE_ID SVR_INT64
plannedSubGoalIDdetails Unique identifier of the planned sub goal to which this milestone has been added.PLANNED_SUBGOAL_ID SVR_INT64
plannedGroupIDdetails Unique identifier of the planned group to which this milestone has been added.PLANNED_GROUP_ID SVR_INT64
milestoneDeliveryIDdetails Unique identifier of the milestone which is represented by this baseline milestone.MILESTONE_DELIVERY_ID SVR_INT64
namedetails The milestone name.MILESTONE_NAME SVR_STRING<128>
typedetails The milestone type.MILESTONE_TYPE SVR_STRING<128>
expectedStartDatedetails Date on which the milestone is expected to start.CURAM_DATE SVR_DATE
expectedEndDatedetails Date on which the milestone is expected to end.CURAM_DATE SVR_DATE
actualStartDatedetails Date on which the milestone started.CURAM_DATE SVR_DATE
actualEndDatedetails Date on which the milestone ended.CURAM_DATE SVR_DATE
Indices (1)
Index NameAttributes
BasMsBasMsDIdIdxbaselineID, milestoneDeliveryID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: baselineMilestoneID
Standard Operation 
searchBaselineMilestonesByBaselineIDnsmulti Method to list all service plan level baseline milestones.SQL
searchByBaselineIDAndPlannedGroupIDnsmulti Method to list all plan group level baseline milestones.SQL
searchByBaselineIDAndPlannedSubGoalIDnsmulti Method to list all subgoal level baseline milestones.SQL
readread Standard Operation 
readByBaselineAndMilestoneDeliveryIDnsread Method to read the baselineMilestone record based on the baseline and milestone delivery ID. 
Related Pages (9)