Table Description
Plan Review Item : Details of the activity (service or action), objective or goal that has been reviewed, or the referral that has been added as part of a plan review.

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 activities reviewed during the review of the plan.

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::PlanReviewItem
Controlling File: AssessmentPlanning\model\Packages\OutcomePlanning\Entity\Delivery\PlanReview.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
planReviewItemIDkeynoThe unique identifier of the plan review itemINTERNAL_ID SVR_INT64
planReviewIDdetailsnoThe unique identifier of the review this item is part ofINTERNAL_ID SVR_INT64
reviewDatedetailsnoThe date the item was reviewedCURAM_DATE SVR_DATE
relatedIDdetailsnoThe unique identifier of the item being reviewedINTERNAL_ID SVR_INT64
relatedTypedetailsnoThe type of the item being reviewedPLAN_REVIEW_ITEM_RELATED_TYPEPlanReviewItemRelTypeSVR_STRING<10>
updateTypedetailsnoThe action performed as part of the review. Identifies if a review record has resulted from completion, addition to plan or maintenance of the item being reviewed.PLAN_REVIEW_UPDATE_TYPEPlanReviewUpdateTypeSVR_STRING<10>
reviewedBydetailsnoThe username of the user performing the reviewUSER_NAME SVR_STRING<64>
commentsdetailsyesThe review commentsOUTCOME_PLAN_RICH_TEXT_SMALL SVR_STRING<2000>
progressIDdetailsyesThe unique identifier of the progress recorded as part of the reviewINTERNAL_ID SVR_INT64
recordStatusdetailsnoThe status of the plan review itemRECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (3)
ChildParent
PlanReviewItem.planReviewIDPlanReview.planReviewID
PlanReviewItem.progressIDProgress.progressID
PlanReviewItem.reviewedByUsers.userName
Indices (6)
Index NameAttributes
PlanRevItemRelIDTypeStatusIdxplanReviewID, relatedID, relatedType, recordStatus
PlanRevItemRevRelTypStatusIdxrelatedID, relatedType, recordStatus
PlanRevItemPRevRTypStatusIdxplanReviewID, recordStatus, relatedType
PlanReviewItemRelatedIdxrelatedID
IND__1417919885progressID
IND_944915225reviewedBy
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: planReviewItemID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByRelatedIDTypeAndStatusreadmulti Returns a list of plan review items for the given related ID, related type and status. 
readActiveByPlanReviewRelatedIDAndTypensread Returns the active plan review item for the given plan review, related ID and related type, if one exists. 
searchByPlanReviewAndStatusreadmulti Returns a list of plan review items for the given plan review and status. 
searchByPlanReviewRelatedTypeAndStatusreadmulti Returns a list of plan review items for the given plan review, related type and status. 
Related Pages (14)