Table Description
Planned Goal: The objective of a service plan.

This entity is focused on the delivery, rather than administration, of a goal within a service plan. A service plan can only contain one goal.

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, therefore a Transportation sub-goal is added to the service plan. A Mileage Reimbursement plan item is added to the service plan to allow Linda to overcome the barrier that preventing her from gaining Sustainable Employment.

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::PlannedGoal::Entity::PlannedGoal
Controlling File: ServicePlans\model\Packages\Service Layer\Service Plan Deliveries\PlannedGoal\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
plannedGoalIDkeynoUnique reference number assigned by the system to a planned goal record.PLANNED_GOAL_ID SVR_INT64
goalIDdetailsnoUnique reference number of the goal which has been added to the service plan.GOAL_ID SVR_INT64
caseIDdetailsnoUnique reference number of the service plan to which this goal has been added.CASE_ID SVR_INT64
commentsdetails User entered remarks about the planned goal.COMMENTS SVR_STRING<300>
outcomeAchieveddetails Code table value indicating the result of the goal. This is determined by the user based on whether the sub-goals added to the goal were enough to satisfy the goal. The possible values for the outcome are Attained, Not Attained and Canceled. OUTCOME_ACHIEVED_CODEOutcomeAchievedSVR_STRING<10>
expectedStartDatedetails Date on which the goal is expected to commence.CURAM_DATE SVR_DATE
expectedEndDatedetails Date on which the goal is expected to end.CURAM_DATE SVR_DATE
actualStartDatedetails Date on which the goal commenced.CURAM_DATE SVR_DATE
actualEndDatedetails Date on which the goal ended.CURAM_DATE SVR_DATE
createdOndetails  CURAM_DATETIME SVR_DATETIME
Foreign Keys (3)
ChildParent
PlannedGoal.goalIDGoal.goalID
PlannedGoal.caseIDServicePlanDelivery.caseID
PlannedSubGoal.plannedGoalIDPlannedGoal.plannedGoalID
Indices (2)
Index NameAttributes
indxGoalPGgoalID
indxCasePGcaseID
Operations (31)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: plannedGoalID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readNameByCaseIDns Reads goal name of the planned goal for the integrated case.SQL
readGoalAndOutcomeByCaseIDns Reads planned goal and achieved outcome for the service plan delivery.SQL
readIDAndGoalContractTextByCaseIDns @deprecated by readIDAndGoalContractTextByCaseID1. @deprecated-since V6.0 SP2. Reads the active planned goal id and goal contract text for a service plan id.SQL
countPlannedGoalByCaseIDns Counts number of planned goals based on a case identifier.SQL
readPlannedGoalIDByCaseIDns Reads planned goal id for a service plan id.SQL
readIDByCaseIDnsread Reads planned goal ID for a service plan delivery. 
readDetailsByCaseIDnsread Reads planned goal ID, planned goal's outcome achieved and planned goal's version number for a service plan delivery. 
modifyOutcomeAchievednsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Updates the outcome achieved for a planned goal. 
readOutcomeAchievedByCaseIDnsread Reads outcome achieved and version number for the service plan. 
validateModifyOutcomeAchieved  Validates the modification details. 
readGoalIDnsread Reads goalID by plannedGoalID. 
modifyGoalTypensmodifyPRE_DATA_ACCESS: yes
Modifies the the goalID for the Service plan. 
readGoalIDByCaseIDnsread Reads the underlying goal definition using the caseID. 
validateModifyGoalType  Validates that the goal can be changed for the service plan delivery. 
validateCaseStatus  Validates that the service plan delivery is not closed. 
removeremove Removes the planned goal. 
readGoalNameAndIDByCaseIDns Reads goal name and goal id for the service plan delivery.SQL
readGoalNameByCaseIDns Reads goal name by service plan delivery ID.SQL
readGoalDetailsByCaseIDns Reads goalName, goalID, expectedStartDate and expectedEndDate for a planned goal.SQL
reCalculateDates  This method decides if any subgoal dates (expected start and end dates OR actual start and end dates) effect the date ranges for the planned goal and if so will update them. 
modifyDateRangensmodify Modifies the dates of the planned goal if any of the planned subgoals dates vary from the planned goals dates. 
readSubGoalMinAndMaxDatesns Returns the max and min actual and expected dates of all the subgoals(that do not have a parent group id set) belonging to this goal.SQL
readBaselineGanttGoalDetailsns Reads the goal details for a baseline gantt.SQL
readGoalDetailsForTrackingGanttByCaseIDns @deprecated since Curam v6, replaced with {@link readGoalGroupDetailsForTrackingGanttByCaseID}. The return parameter struct TrackingGanttGoalDetails has all the details of curam.serviceplans.sl.struct.TrackingGanttGoalDetails along with 'caseID'.SQL
readPlanGroupMinAndMaxDatesns Returns the max and min actual and expected dates for all planned group (who have no parent group) that belong to this goal.SQL
readGoalGroupDetailsForTrackingGanttByCaseIDns Reads the goal details for the tracking gantt.SQL
readIDAndGoalContractTextByCaseAndLanguagens Reads the active planned goal id and goal contract text for a service plan id by language code and case id.SQL
readIDAndGoalContractTextByCaseID1  Reads the active planned goal id and goal contract text for a service plan id. 
Related Pages (127)
Delete Hearing Representative (Appeal_cancelRepresentative)
Delete Witness (Appeal_cancelWitness)
Delete Witness (Appeal_cancelWitnessIC)
Delete Hearing Representative (Appeal_IC_cancelHearingReviewRepresentative)
Delete Hearing Representative (Appeal_IC_cancelRepresentative)
Match Client (Application_matchClientConfirmation)
Add Client (Application_registerPersonAndAddAsClient)
Register Person (Application_registerProspectPersonAsPerson)
Register Person (BenefitSample_registerPerson)
Delete Member (Case_cancelCaseMember)
Delete Client Role (Case_cancelClientRole)
Register Person and Create Case (Case_registerPersonAndCreateIntegratedCase)
Register Person and Create Case (Case_registerPersonAndCreateIntegratedCasePDC)
Add Client (CommonIntake_addClient)
Remove Client (CommonIntake_cancelApplicationClient)
Register Client (CommonIntake_registerClient)
Service Plans (DefaultIC_ICList)
Service Plans: (DefaultICMemberServicePlanDelivery_list)
Delete Company Relationship (Employer_cancelRelatedCompany)
Edit Company Relationship (Employer_modifyRelatedCompany)
New Household Relationship Evidence (EVD_addToCaseHouseholdRelationshipEvidence_sa)
New Household Relationship Evidence (EVD_addToCaseHouseholdRelationshipEvidence_wzSelAllCre)
New Household Member Evidence (EVD_createHouseholdMemberEvidence_sa)
Edit Household Relationship Evidence (EVD_incomingModifyHouseholdRelationshipEvidence)
Edit Household Relationship Evidence (EVD_modifyHouseholdRelationshipEvidence)
Add Member (HCRAddMemberWizard_summary)
Register Person (ICSample_registerPerson)
Service Plans (ICSampleSportingGrant_ICList)
Register Person (IncomeScreening_registerHouseholdMember)
Register Person (IncomeScreening_registerPerson)
Delete Household Evidence Details: (IncomeSupportScreening_cancelISHouseholdEvidence)
Register Person (IncomeSupportScreening_registerPerson)
Register Person (IncomeSupportScreening_registerPersonForHouseholdEvidence)
Register Prospect Person as Person (Individual_registerProspectAsPerson)
Related Persons (Intake_listRelatedPerson)
Register Person (Intake_personFullRegistration)
Person Search Results (Intake_personSearchResult)
Register Prospect Person as Person (Intake_registerProspectAsPerson)
Register Prospect Person as Person (Intake_registerProspectPersonAsPerson)
Register Prospect Person (Intake_registerProspectPersons)
Register Prospect Person (Intake_registerProspectPersons_Reset)
Register Prospect Person (Intake_registerProspectPersons_Reset1)
Register Prospect Person (Intake_registerProspectPersons1)
Register Person (IntakeShortCuts_registerPerson)
Cost (IntegratedServicePlan_cost)
Integrated Service Plan Home (IntegratedServicePlan_home)
Integrated Service Plan Home (IntegratedServicePlan_homeActiveOnly)
- (IntegratedServicePlan_tabDetails)
Tracking Gantt (IntegratedServicePlan_trackingGantt)
Delete Case Member (InvestigationDelivery_cancelCaseMember)
Register Person (InvestigationSample_registerPerson)
Register Person (InvestigationSample_registerPersonForPDC)
Add Household Member (ISAddMemberWizard_summaryDetails)
Register Person (ISP_registerPerson)
Basic Intake Information (ISPIntakeInformation_createFromScreening)
Re-add a Member (ISReAddMemberWizard_submit)
Add Legal Action Participants (LegalAction_addParticipant)
Register Person (LiabilitySample_registerPerson)
Remove Client (OutcomePlan_removeClient)
Merge Duplicate (Participant_mergeRelationships)
Delete Relationship (Person_cancelRelationship)
Edit Relationship (Person_modifyRelationship)
Edit Relationship (Person_modifyRelationshipFromList)
Edit Relationship (Person_modifyRelationshipFromView)
Register Person (Person_register)
Register Person (Person_registerForPDC)
Confirm Registration (Prospect_registerPersonFromProspect)
Delete Company Relationship (ProspectEmployer_cancelRelatedCompany)
Edit Company Relationship (ProspectEmployer_modifyRelatedCompany)
Register Prospect Employer as Employer (ProspectEmployer_registerAsEmployer)
Register Prospect Employer as Employer (ProspectEmployer_registerAsEmployerWizard)
Delete Relationship (ProspectPerson_cancelRelationship)
Edit Relationship (ProspectPerson_modifyRelationshipFromList)
Edit Relationship (ProspectPerson_modifyRelationshipFromView)
Register Prospect Person as Person (ProspectPerson_registerAsPerson)
Register Prospect Person as Person (ProspectPerson_registerAsPersonForPDCWizard)
Register Prospect Person as Person (ProspectPerson_registerAsPersonWizard)
Step 5: Register Person (ProviderManagement_duplicateRegisterPersonAsProvider)
Step 5: Register Person (ProviderManagement_registerPersonAsProvider)
Register As Person (ProviderManagement_registerProviderAsPersonFrmProviderHome)
Register Person (RegisterPerson_registerForPDCWizard)
Register Person (RegisterPerson_registerWizard)
Add Plan Group (ServicePlanDelivery_addPlannedGroup)
Approve Service Plan (ServicePlanDelivery_approve)
Compare Baselines (ServicePlanDelivery_baselineComparisonGantt)
Clone Service Plan (ServicePlanDelivery_clone)
Close Service Plan (ServicePlanDelivery_close)
New Baseline (ServicePlanDelivery_createBaseline)
New Contract (ServicePlanDelivery_createContract)
Add Sub-Goal (ServicePlanDelivery_createPlannedSubGoal)
Service Plan Home: (ServicePlanDelivery_home)
Home (ServicePlanDelivery_home1)
Service Plan Home (ServicePlanDelivery_homeTransaction)
Service Plans: # END NON-TRANSLATABLE (ServicePlanDelivery_ICList)
Service Plans: (ServicePlanDelivery_list)
Milestones (ServicePlanDelivery_listAllISPMilestones)
Service Plans (ServicePlanDelivery_ListICs)
Milestones (ServicePlanDelivery_listISPMilestones)
Plan Content: (ServicePlanDelivery_listPlanContent)
Plan Content (ServicePlanDelivery_listPlanContentForSP)
Edit Baseline (ServicePlanDelivery_modifyBaselineFromList)
Edit Baseline (ServicePlanDelivery_modifyBaselineFromView)
Edit Service Plan (ServicePlanDelivery_modifyDetails)
Edit Goal (ServicePlanDelivery_modifyGoal)
Modify Service Plan Type (ServicePlanDelivery_modifyType)
Edit Plan Type (ServicePlanDelivery_modifyType1)
Add Plan Group (ServicePlanDelivery_newPlannedGroup)
Add Sub-Goal (ServicePlanDelivery_newPlannedSubGoal)
Print Contract (ServicePlanDelivery_printContract)
Print Contract (ServicePlanDelivery_savePrintContract)
Select Baseline for Comparison: (ServicePlanDelivery_selectBaselineForCompare)
Select Sub-Goal (ServicePlanDelivery_selectNewPlannedSubGoal)
Select Sub-Goal Type (ServicePlanDelivery_selectNewPlannedSubGoalType)
Select Sub-Goal (ServicePlanDelivery_selectPlannedSubGoal)
Select Sub-Goal Type (ServicePlanDelivery_selectPlannedSubGoalType)
- (ServicePlanDelivery_servicePlanTabDetails)
Submit Service Plan (ServicePlanDelivery_submit)
Tracking Gantt (ServicePlanDelivery_trackingGantt)
Use Service Plan Template (ServicePlanDelivery_useTemplate)
Baseline Gantt (ServicePlanDelivery_viewBaselineGantt)
Service Plan Home: (ServicePlanDeliveryDetails_home)
Close Service Plans (ServicePlanGroupDelivery_close)
Service Plan Group Home (ServicePlanGroupDelivery_home)
Service Plan Group Home (ServicePlanGroupDelivery_homeActiveOnly)
- (ServicePlanGroupDelivery_tabDetails)
Tracking Gantt (ServicePlanGroupDelivery_trackingGantt)
Remove Client (SocialEnterpriseFolder_removeClient)