Table Description
Visitation Plan Status History: Records transitions in state for a visitation plan.

When a visitation plan changes status, a VisitationPlanStatusHistory record is created.

Example

Daniel Smith is a 18 month child who has been placed in a foster care home as it was deemed by the child welfare agency that he was not safe staying at home with his mother, Linda Smith.
The child welfare caseworker dealing with Daniel creates an outcome plan for the family. The caseworker creates a visitation plan for Daniel and Linda to maintain relationships. The visitation plan outlines that Linda must make two face-to-face visits per month. Julie completes bi-monthly face-face visits with Daniel according to the visitation plan. The caseworker performs regular visit
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::Visitation::Entity::Delivery::VisitationPlanStatusHistory::VisitationPlanStatusHistory
Controlling File: AssessmentPlanning\model\Packages\Visitation\Entity\Delivery\VisitationPlanStatusHistory.efx
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
visitationPlanStatusHistoryIDkeynoUnique identifier for the record.INTERNAL_ID SVR_INT64
visitationPlanIDdetailsnoUnique identifier of the related visitation plan record. INTERNAL_ID SVR_INT64
createdBydetailsnoThe user who created this record.USER_NAME SVR_STRING<64>
createdDatedetailsnoThe date on which this record was created.CURAM_DATE SVR_DATE
visitationPlanStatusdetailsnoThe visitation plan status.VISITATION_PLAN_STATUSVisitationPlanStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
VisitationPlanStatusHistory.visitationPlanIDVisitationPlan.visitationPlanID
Indices (1)
Index NameAttributes
IND_1007444318visitationPlanID
Operations (2)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: visitationPlanStatusHistoryID
Standard Operation 
readByVisitationPlanAndStatusnsread   
Related Pages (2)