Table Description
Baseline: A snapshot of a service plan at a certain point in time.

When a baseline is created, the service plan goal, plan group(s), sub-goal(s) and plan item(s) 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.

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. A Find a Job sub-goal is added to the service plan. The Full-time Job Search plan item is added to the service plan to achieve the service plan goal. An expected outcome of Full time Employment is selected for the Full-time Job Search plan item.

The service plan is submitted for approval. An approval submission baseline is automatically created by the Curam Application. The same process is undertaken for a baseline which is manually created by a Curam user.

This baseline records the parent information for the baseline, used within other baseline-related entities which records service plan details 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::Baseline
Controlling File: ServicePlans\model\Packages\Service Layer\Service Plan Deliveries\Baseline\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (12)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
baseLineIDkeynoUnique reference number assigned by the system to the baseline record.BASELINE_ID SVR_INT64
namedetails Name of the baseline.BASELINE_NAME SVR_STRING<50>
typeCodedetails Type of baseline and will depend on how the baseline was created e.g. Automatic or Manual.BASELINE_TYPE_CODEBaselineTypeSVR_STRING<10>
creationDateTimedetails Date and time the baseline was created.CURAM_DATETIME SVR_DATETIME
plannedGoalIDdetailsnoUnique reference number of the service plan goal at the time the baseline was created.PLANNED_GOAL_ID SVR_INT64
goalNamedetails Name of service plan goal at the time the baseline was created.GOAL_NAME_CODEGoalNameSVR_STRING<10>
commentsdetails General remarks entered by the user.BASELINE_COMMENT SVR_STRING<200>
createdBydetails User name of the creator of the baseline.USER_NAME SVR_STRING<64>
expectedStartDatedetails Date on which the goal represented by this baseline was expected to start.CURAM_DATE SVR_DATE
expectedEndDatedetails Date on which the goal represented by this baseline was expected to end.CURAM_DATE SVR_DATE
actualStartDatedetails Date on which the goal represented by this baseline commenced.CURAM_DATE SVR_DATE
actualEndDatedetails Date on which the goal represented by this baseline ended.CURAM_DATE SVR_DATE
Foreign Keys (2)
ChildParent
BaselinePlanGroup.baselineIDBaseline.baseLineID
BaselineSubGoal.baseLineIDBaseline.baseLineID
Indices (2)
Index NameAttributes
BasePlnGoalIDIdxplannedGoalID
BaselineNameIndxname
Operations (15)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: baseLineID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
removeremovePRE_DATA_ACCESS: yes
Standard Operation 
searchByCaseIDnsmulti Returns id, name, type, created by, and creation date time of all baselines of a specified CaseID.SQL
countByPlannedGoalIDAndTypens Counts baselines for a planned goal.SQL
readBaselineGoalDetailsns Reads goal name, goal ID, expectedStartDate and expectedEndDate for a baseline.SQL
readNamensread Reads baseline name. 
searchNameAndIDByCaseIDnsmulti Lists baseline name and ID details by caseID, excluding baseline defined by the key value of baseline ID.SQL
readGoalNamensread Reads baseline's goal name. 
readCaseIDByBaselineIDns Reads the service plan delivery case id based on the baseline id.SQL
countByNamens Reads a count of baseline records which have the same name as the one passed it.SQL
validateDetails  Validates details before modifying or creating a baseline record. 
validateRemove  validates the details before removal 
readByNameAndPlannedGoalnsread Reads the baseline record with a specified name and planned goal. 
Related Pages (16)