Table Description
Visitation Role: A role which may be played by a case participant or a user on a visitation plan, visitation log or visitation evaluation. Out of the box the role types are Visitor and Client To Visit.

A visitation role is defined for each of the participants in a visitation plan.

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, Julie Smith.
The child welfare caseworker dealing with Daniel creates an outcome plan for the family. The caseworker creates a visitation plan for Daniel and Julie to maintain relationships. Daniel has a role of Client to Visit on the visitation plans and related visitation logs. Julie has a role of visitor on the visitation plans and related visitation logs.
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::VisitationRole::VisitationRole
Controlling File: AssessmentPlanning\model\Packages\Visitation\Entity\Delivery\VisitationRole.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
visitationRoleIDkeynoUnique identifier for the record.INTERNAL_ID SVR_INT64
relatedIDdetailsnoUnique identifier of the visitation plan, visitation log, or visitation evaluation that this role relates to.INTERNAL_ID SVR_INT64
relatedTypedetailsnoThe type of related record, i.e. visitation plan, visitation log or visitation evaluation.VISITATION_ROLE_RELATED_TYPEVisitationRoleRelatedTypeSVR_STRING<10>
roleRelatedIDdetailsnoUnique identifier of the case participant role or user that this role represents.VISITATION_ROLE_RELATED_ROLE_ID SVR_STRING<30>
roleRelatedTypedetailsnoThe type of related role, i.e. case participant or user.VISITATION_ROLE_RELATED_ROLE_TYPEVisitRoleRelatedRoleTypeSVR_STRING<10>
roleTypedetailsnoThe type of role this visitation role represents, for example Visitor or Client To Visit.VISITATION_ROLE_TYPEVisitationRoleTypeSVR_STRING<10>
recordStatusdetailsnoThe status of this role record. RECORD_STATUSRecordStatusSVR_STRING<10>
evaluateInddetailsyesIndicates if this role is for evaluation or not. Adding visitors and clients to visit to a visitation plan will set the evaluate indicator to true. Adding visitors and clients visited to a visitation log without adding them to the plan will result in records with the evaluate indicator set to false.CURAM_INDICATOR SVR_BOOLEAN
createdDateTimedetailsnoThe date and time on which the role record is created.CURAM_DATETIME SVR_DATETIME
Foreign Keys (1)
ChildParent
VisitationLogRoleLink.visitationRoleIDVisitationRole.visitationRoleID
Indices (2)
Index NameAttributes
IND__1934630585relatedID
IND_1136221425roleRelatedID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: visitationRoleID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: no
Standard Operation 
searchActiveRolesByRelatedIDRelatedTypeAndRoleTypereadmulti Returns a list of active visitation roles for the specified relatedID, relatedType and roleType. Example usages include listing visitors on a visitation plan, listing visitees on a visitation plan, listing visitors on a visitation log, listing visitees on a visitation log, listing visitors on a visitation evaluation, listing visitees on a visitation evaluation. 
readActiveByRelatedIDRelatedTypeRoleRelatedIDRoleRelatedTypeAndRoleTypensread Returns the role record which matches the specified relatedID, relatedType, roleRelatedID, roleRelatedType and roleType, if this record exists. Example usage is to read a visitor record for a particular case participant role (roleRelatedID/type) on a particular visitationplan (relatedID/type). 
readread Standard Operation 
searchActiveRolesByRoleTypeRoleRelatedIDAndRelatedTypereadmultiORDER_BY: createdDateTime DESC
Returns a list of active visitation roles for the specified roleType, roleRelatedID and RelatedType  
Related Pages (37)
Visit Evaluation (VisitationEvaluation_addEvaluation)
Edit Evaluation (VisitationEvaluation_editEvaluation)
Visits (VisitationEvaluation_listByPlanReviewNonSDM)
Visits (VisitationEvaluation_listByPlanReviewSDM)
VisitationEvaluation_listLogsByPlanReview
VisitationEvaluation_viewRationaleDetails
Add Registered Visitor (VisitationLog_addRegisteredVisitor)
Add Unregistered Visitor (VisitationLog_addUnregisteredVisitor)
Add Clients Visited (VisitationLog_addVisitings)
Add Visitors (VisitationLog_addVisitors)
Delete Visitation Log (VisitationLog_cancel)
Edit Visitation Log (VisitationLog_edit)
Edit Visitation Log (VisitationLog_editNarrative)
Visitation Logs (VisitationLog_listByVisitationPlan)
Unregistered Person Details (VisitationLog_modifyUnregisteredVisitor)
Remove Client Visited (VisitationLog_removeVisitingClient)
Remove Clients Visited (VisitationLog_removeVisitings)
Remove Visitor (VisitationLog_removeVisitor)
Remove Visitors (VisitationLog_removeVisitors)
New Visitation Log (VisitationPlan_addLog)
Add Registered Visitor (VisitationPlan_addRegisteredVisitor)
Add Unregistered Visitor (VisitationPlan_addUnregisteredVisitor)
Add Clients to Visit (VisitationPlan_addVisitings)
Add Visitors (VisitationPlan_addVisitors)
Cancel Visitation Plan (VisitationPlan_cancel)
Close Visitation Plan (VisitationPlan_close)
Edit Visitation Plan (VisitationPlan_edit)
Visitation Plan (VisitationPlan_home)
Visits (VisitationPlan_listByParentCase)
Unregistered Person Details (VisitationPlan_modifyUnregisteredVisitor)
Remove Client To Visit (VisitationPlan_removeVisitingClient)
Remove Clients to Visit (VisitationPlan_removeVisitings)
Remove Visitor (VisitationPlan_removeVisitor)
Remove Visitors (VisitationPlan_removeVisitors)
VisitationPlan_viewSummaryDetails
VisitationPlan_visitationPlanDetails
New Visitation Plan (VisitationPlanCreateWizard_details)