Table Description
Baseline Plan Item: A snapshot of the plan item(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 to a client and may also be manually created by the user. Baselines 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 plan item(s) present on a service plan at the time the Baselines 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 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 plan item entity stores the details of the plan item(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::BaselinePlanItem
Controlling File: ServicePlans\model\Packages\Service Layer\Service Plan Deliveries\Baseline\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (33)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
baselinePlanItemIDkeynoUnique reference number assigned by the system to the baseline plan item record.BASELINE_PLAN_ITEM_ID SVR_INT64
baselineSubGoalIDdetailsnoUnique reference number of the baseline sub-goal to which this baseline plan item is associated.BASELINE_SUB_GOAL_ID SVR_INT64
plannedItemIDdetailsnoUnique reference number of the plan item which is represented by this baseline plan item.PLANNED_ITEM_ID SVR_INT64
namedetails Name of the plan item represented by this baseline plan item.PLAN_ITEM_NAME SVR_STRING<500>
authorizedUnitsdetails Indicates the the authorized number of units for the plan item e.g. 6 physiotherapy visits.AUTHORIZED_UNITS SVR_INT32
expectedStartDatedetails Expected start date of the plan item represented by this baseline plan item.CURAM_DATE SVR_DATE
expectedEndDatedetails Expected end date of the plan item represented by this baseline plan item.CURAM_DATE SVR_DATE
actualStartDatedetails Actual start date of the plan item represented by this baseline plan item.CURAM_DATE SVR_DATE
actualEndDatedetails Actual end date of the plan item represented by this baseline plan item.CURAM_DATE SVR_DATE
sensitivityCodedetails Sensitivity code associated with this plan item.SENSITIVITY_CODESensitivitySVR_STRING<10>
typeCodedetails Codetable field enabling categorization of plan items.PLAN_ITEM_TYPE_CODEPlanItemTypeSVR_STRING<10>
expectedOutComeIDdetails Unique reference number of the outcome associated with this plan item.OUTCOME_ID SVR_INT64
outcomeAchieveddetails Code table value to indicate whether the outcome was achieved.OUTCOME_ACHIEVED_CODEOutcomeAchievedSVR_STRING<10>
goodCauseIDdetails Unique reference number of a good cause record specified for this plan item.GOOD_CAUSE_ID SVR_INT64
concerningIDdetails The Concern Role ID of the person to whom the selected plan item is concerned.CONCERN_ROLE_ID SVR_INT64
responsibilityIDdetails Unique reference number of the user or participant who is determined to be responsible for a plan item.RESPONSIBILITY_ID SVR_INT64
responsibilityTypedetails Code table attribute denotes the type of id stored in the responsibilityID attribute. The plan participant or a system user may be responsible for a plan item.RESPONSIBILITY_TYPE_CODEResponsibilityTypeSVR_STRING<10>
respUserNamedetails User name of the user who is responsible for the plan item.USER_NAME SVR_STRING<64>
ownerUserNamedetails User name of the user who is the owner of the plan item.USER_NAME SVR_STRING<64>
estimatedCostdetailsyesEstimated cost of the plan item to the organization.OPTIONAL_POSITIVE_MONEY SVR_MONEY
actualCostdetailsyesActual cost of the plan item to the organization.OPTIONAL_POSITIVE_MONEY SVR_MONEY
commentsdetails User entered remarks regarding the plan item.COMMENTS SVR_STRING<300>
caseIDdetails Unique reference number assigned by the system to a service plan record.CASE_ID SVR_INT64
goodCauseNamedetails Name of the good cause. This is a code table value for translation purposes.GOOD_CAUSE_NAME_CODEGoodCauseNameSVR_STRING<10>
subGoalNamedetails Name of the sub-goal. This is a code table value for translation purposes.SUBGOAL_NAME_CODESubGoalNameSVR_STRING<10>
concerningNamedetails The governing First Name and Surname or label utilized by the Concern Role in their interaction with the Organization in that role type.CONCERN_ROLE_NAME SVR_STRING<131>
caseParticipantRoleIDdetails The unique reference number of the service plan participant.CASE_PARTICIPANT_ROLE_ID SVR_INT64
outcomeNamedetails Name of the outcome. This is a code table value for translation purposes.OUTCOME_NAME_CODEOutcomeNameSVR_STRING<10>
respSetToParticipantdetails Indicator to say whether the plan item responsibility set to the participant or not.CONCERN_ROLE_ID SVR_INT64
planItemResponsibilityNamedetails Name of the participant responsible for the plan itemPLAN_ITEM_RESP_NAME SVR_STRING<131>
userFullNamedetails Full name of the user responsible for the plan itemUSER_FULL_NAME SVR_STRING<131>
planItemRespUserFullNamedetails Full name of the user responsible for the plan itemUSER_FULL_NAME SVR_STRING<131>
statusdetails Status of the plan item record. The values are Unapproved, Approved, Not Started, In Progress and Completed.PLANNED_ITEM_STATUS_CODEPlannedItemStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
BaselinePlanItem.baselineSubGoalIDBaselineSubGoal.baselineSubGoalID
Indices (1)
Index NameAttributes
BasSubGoalIDIndxbaselineSubGoalID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: baselinePlanItemID
Standard Operation 
readread Standard Operation 
removeremovePRE_DATA_ACCESS: yes
Standard Operation 
searchByBaselineSubGoalIDnsmulti Returns planned item id, name, expected start date, expected end date, actual start date, actual end date, and sensitivity code from baseline plan item for a specified baseline sub-goal identifier.SQL
searchPlanItemDetailsByBaselineSubGoalIDAndSensitivitynsmulti Reads details about all baseline planItems for a baseline sub goal.SQL
readSensitivityCodensread Reads the sensitivity code of a baseline planItem. 
Related Pages (10)