Table Description
Baseline Plan Item: A snapshot of the sub-goals(s) 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) and plan item(s) present on the plan are recorded. Baselines can be automatically created by the system at specific points in the delivery of a service plan service plan to a client and may also be manually created by the user. They can be created automatically by the system when a service plan is submitted for approval and on plan approval. Automatic baselines are controlled by an environment variable that allows the customer to enable/disable this processing according to requirements. This entity holds the details of any sub-goals(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 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 will contain a Childcare sub-goals 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 sub-goal entity stores the details of the sub-goal(s) present on the service plan at the time the baseline is created.

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::Service Plan Deliveries::Baseline::Entity::BaselineSubGoal
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
baselineSubGoalIDkeynoUnique reference number assigned by the system to the baseline sub-goal record.BASELINE_SUB_GOAL_ID SVR_INT64
baseLineIDdetailsnoUnique reference number of the baseline to which this baseline sub-goal belongs.BASELINE_ID SVR_INT64
plannedSubGoalIDdetailsnoUnique reference number of the sub-goal represented by this baseline sub-goal.PLANNED_SUBGOAL_ID SVR_INT64
sensitivityCodedetails The sensitivity value of the sub-goal represented by this baseline sub-goal at the time the baseline was created.SENSITIVITY_CODESensitivitySVR_STRING<10>
namedetails Name of the sub-goal represented by this baseline sub-goal.SUBGOAL_NAME_CODESubGoalNameSVR_STRING<10>
typeCodedetails Type code of the sub-goal represented by this baseline sub-goal.SUBGOAL_TYPE_CODESubGoalTypeSVR_STRING<10>
plannedGroupIDdetailsyesUnique reference number of the baseline plan group to which this baseline sub-goal belongs.PLANNED_GROUP_ID SVR_INT64
expectedStartDatedetails Date on which the sub-goal represented by this baseline sub-goal was expected to start.CURAM_DATE SVR_DATE
expectedEndDatedetails Date on which the sub-goal represented by this baseline sub-goal was expected to end.CURAM_DATE SVR_DATE
actualStartDatedetails Date on which the sub-goal represented by this baseline sub-goal commenced.CURAM_DATE SVR_DATE
actualEndDatedetails Date on which the sub-goal represented by this baseline sub-goal ended.CURAM_DATE SVR_DATE
Foreign Keys (2)
ChildParent
BaselineSubGoal.baseLineIDBaseline.baseLineID
BaselinePlanItem.baselineSubGoalIDBaselineSubGoal.baselineSubGoalID
Indices (1)
Index NameAttributes
BaselineIDIndxbaseLineID
Operations (11)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: baselineSubGoalID
Standard Operation 
readread Standard Operation 
removeremovePRE_DATA_ACCESS: yes
Standard Operation 
searchByBaselineIDnsmulti Returns id, name and type from baseline sub-goal for a specified baseline identifier.SQL
searchByBaselineIDAndPlannedSubGoalIDns Returns baseline name, sub-goal name, sub-goal ID, type code of sub-goal, and sensitivity code of sub-goal for a specified baseline identifier and a sub-goal identifierSQL
searchSubGoalDetailsByBaselineIDAndSensitivitynsmulti Reads details about all baseline sub goals for a baseline.SQL
readSensitivityCodensread Reads the sensitivity for a specified 
readCaseIDByBaselineSubGoalIDns Reads the case id based on the baseline subgoal id.SQL
searchDetailsByBaselineIDAndSensitivityNoGroupnsmulti Reads baseline details for comparison when baseline is not associated with a group.SQL
searchDetailsByBaselineIDSensitivityAndGroupnsmulti Reads baseline details for comparison when baseline is associated with a group.SQL
searchSubGoalsByBaselineIDnsmulti Returns id, name and type from baseline sub-goal for a specified baseline identifier.SQL
Related Pages (11)