Table Description
Plan Review : A review of activities(service,referral, actions), objectives and goals within an outcome plan.

A review of an outcome plan is for a specified review period, and has an expected completion date. A number of review items are linked to the plan review. A review narrative and review notes may be recorded.

Example

An outcome plan is created for James Smith, Linda Smith and their child Robert to identify and address their issues. The Family Strengths and Needs Assessment (FSN) Assessment is run from this outcome plan by a case worker. Activities(services, actions and referrals are created to address the identified needs. Three months later the case worker creates a review on the outcome plan. All activities added to the outcome plan are reviewed. This entity stores the details of the review comments entered for each activity.

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::OutcomePlanning::OutcomePlan::Entity::Delivery::PlanReview::PlanReview
Controlling File: AssessmentPlanning\model\Packages\OutcomePlanning\Entity\Delivery\PlanReview.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (14)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
planReviewIDkeynoUnique identifier of the plan reviewINTERNAL_ID SVR_INT64
caseIDdetailsnoUnique identifier of the OutcomePlan being reviewedCASE_ID SVR_INT64
fromDatedetailsnoThe from date of the period that is being reviewedCURAM_DATE SVR_DATE
toDatedetailsnoThe to date of the period that is being reviewedCURAM_DATE SVR_DATE
creationDatedetailsnoThe date the review was createdCURAM_DATE SVR_DATE
createdBydetailsnoThe username of the user who created the reviewUSER_NAME SVR_STRING<64>
completionDatedetailsyesThe completion date of the reviewCURAM_DATE SVR_DATE
completedBydetailsyesThe username of the user who completed the reviewUSER_NAME SVR_STRING<64>
completionCommentsdetailsyesThe comments added by the user when completing the reviewOUTCOME_PLAN_RICH_TEXT_SMALL SVR_STRING<2000>
progressIDdetailsyesUnique identifier of the progress recorded against the plan goal when completing the reviewINTERNAL_ID SVR_INT64
narrativeNoteIDdetailsyesUnique identifier of the note used to record the review narrativeNOTE_ID SVR_INT64
noteIDdetailsyesUnique identifier of the note associated with the reviewNOTE_ID SVR_INT64
statusdetailsnoThe status of the reviewPLAN_REVIEW_STATUSPlanReviewStatusSVR_STRING<10>
reviewTypedetailsyesThe type of review. Can be either planned or unplanned.PLAN_REVIEW_TYPEPlanReviewTypeSVR_STRING<10>
Foreign Keys (8)
ChildParent
PlanReview.caseIDCaseHeader.caseID
PlanReview.narrativeNoteIDNote.noteID
PlanReview.noteIDNote.noteID
PlanReview.progressIDProgress.progressID
PlanReview.createdByUsers.userName
PlanReview.completedByUsers.userName
PlanReviewItem.planReviewIDPlanReview.planReviewID
VisitationEvaluation.planReviewIDPlanReview.planReviewID
Indices (6)
Index NameAttributes
PlanReviewCaseStatusIdxcaseID, status
IND__1286383775narrativeNoteID
IND__422959477noteID
IND__525179130progressID
IND__112483679createdBy
IND_170230980completedBy
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: planReviewID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByCasereadmultiWHERE: caseID = :caseID AND status!='PLRV10003'
Returns a list of plan reviews for the given case where the status is not 'Cancelled'. 
readread Standard Operation 
readOpenByCasensread Returns the open plan review for the given case, if one exists. 
searchByCaseAndStatusreadmulti Returns a list of plan reviews for the given case and status. 
Related Pages (36)
Home (MDTOutcomePlan_home)
Edit Narrative (OutcomePlan_addNarrativeNoteToReview)
New Note (OutcomePlan_addNoteToReview)
Delete Plan Review (OutcomePlan_cancelReview)
Complete Review (OutcomePlan_completeReview)
New Review (OutcomePlan_createReview)
Update Completion Details (OutcomePlan_editCompletedReview)
Edit Review (OutcomePlan_editReview)
Edit Expected Completion Date (OutcomePlan_editReviewExpectedCompletionDate)
Home (OutcomePlan_home)
Activities (OutcomePlan_listActions)
Assessments (OutcomePlan_listAssessmentsForReview)
Objectives (OutcomePlan_listExpectedOutcomes)
Goals (OutcomePlan_listGoals)
Reviews (OutcomePlan_listReviews)
Review (OutcomePlan_maintainReviewItem)
OutcomePlan_outcomePlanDetails
Review (OutcomePlan_reviewAction)
Review (OutcomePlan_reviewExpectedOutcome)
Review (OutcomePlan_reviewGoal)
New Assessment (OutcomePlan_selectPlanReviewAssessmentDefinition)
Activities (OutcomePlan_viewReviewActivities)
) (OutcomePlan_viewReviewContext)
Review (OutcomePlan_viewReviewDropDown)
Expected Completion Date History (OutcomePlan_viewReviewExpectedCompletionDateHistory)
Objectives (OutcomePlan_viewReviewExpectedOutcomes)
Goals (OutcomePlan_viewReviewGoals)
Home (OutcomePlan_viewReviewHome)
Notes (OutcomePlan_viewReviewNotes)
Review (OutcomePlanService_reviewService)
Visit Evaluation (VisitationEvaluation_addEvaluation)
Edit Evaluation (VisitationEvaluation_editEvaluation)
Visits (VisitationEvaluation_listByPlanReviewNonSDM)
Visits (VisitationEvaluation_listByPlanReviewSDM)
VisitationEvaluation_listLogsByPlanReview
VisitationEvaluation_viewRationaleDetails