Table Description
Baseline Plan Group: A snapshot of the plan group(s) present on a service plan at the time a baseline was created.

When a baseline is created, the service plan goal, plan groups, sub-goalsand plan items 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 expected and actual start and end dates of any plan groups present on a service plan at the time the baseline was 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 planned group entity stores the details of the plan group(s) present on the service plan at the time the baseline was 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::BaselinePlanGroup
Controlling File: ServicePlans\model\Packages\Service Layer\Service Plan Deliveries\Baseline\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGno
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
baselinePGIDkeynoUnique reference number assigned by the system to the baseline plan group record.BASELINE_PLANNED_GROUP_ID SVR_INT64
plannedGroupIDdetailsnoUnique reference number of the plan group represented by this baseline plan group.PLANNED_GROUP_ID SVR_INT64
parentGroupIDdetailsyesUnique reference number of the parent group record to which this plan group belonged at the time the baseline was created.PLANNED_GROUP_ID SVR_INT64
baselineIDdetailsnoUnique reference number of the baseline to which this baseline plan group is associated.BASELINE_ID SVR_INT64
plannedGroupNamedetails Name of the plan group at the time the baseline was created.PLANNED_GROUP_NAME SVR_STRING<50>
expectedStartDatedetails Date on which the plan group represented by this baseline plan group was expected to start.CURAM_DATE SVR_DATE
expectedEndDatedetails Date on which the plan group represented by this baseline plan group was expected to end.CURAM_DATE SVR_DATE
actualEndDatedetails Date on which the plan group represented by this baseline plan group ended.CURAM_DATE SVR_DATE
actualStartDatedetails Date on which the plan group represented by this baseline plan group commenced.CURAM_DATE SVR_DATE
Foreign Keys (1)
ChildParent
BaselinePlanGroup.baselineIDBaseline.baseLineID
Indices (1)
Index NameAttributes
BaselinePGMultiIdxbaselineID, plannedGroupID
Operations (9)
OperationStereotypeOptionsDescriptionSQL
readread Standard Operation 
searchContentListDetailsByBaselineIDnsmulti Returns id, and name from baseline planned group for the baseline plan content page for a specified baseline identifier.SQL
readPlannedGroupIDNameAndBaselineNamens reads the planned group name, id, and baseline name for a specified baseline planned groupSQL
searchBaselineSubGoalsDatesnsmulti lists the expected end dates, expected start date, actual start dates, actual end dates, names, and sub goal id's for all baseline sub goals of the baseline planned groupSQL
searchChildPlannedGroupsByBaselineIDAndPlannedGroupIDnsmulti lists the expected end dates, expected start date, actual start dates, actual end dates, names, and planned groups id's for all planned groups of the baseline planned groupSQL
insertinsertAUTO_ID: baselinePGID
Standard Operation 
searchDetailsByBaselineIDNoGroupnsmulti Reads baseline planned group details for comparison when planned group is not associated with another group.SQL
searchDetailsByBaselineIDAndGroupIDnsmulti Lists baseline planned group details by baseline ID and parent group ID.SQL
removeremove Standard Operation 
Related Pages (10)