Table Description
Visitation Compliancy Admin: Specifies the percentage range for a visit compliance level.

Visit compliance measures whether or not a visitor was compliant with his or her expectations with regards to the frequency of visits with the visited client in question. Visit compliance is calculated based on certain criteria including the visit duration, the contact method and whether the visit was scheduled, rescheduled or unscheduled. The compliancy calculation produces a compliance percentage value by comparing the compliant visits to the number of planned visit in for a particular review period. The compliance level is determined by comparing the calculated compliance percentage against min and max compliance ranges defined.

Example

Daniel Smith is an 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. The visitation plan outlines that Julie must make two face-to-face visits per month. Julie completes her scheduled visits with Daniel in accordance with the visitation plan. The caseworker decides to perform a 6 month review, and as part of the review, the caseworker evaluates the visits between Julie and Daniel. Since Julie has completed all planned visits in the review period, the calculated compliance is 100% and the compliance level is totally. This entity stores compliances ranges for the compliance levels.
Model Details
Location in Model: Logical View::MetaModel::Curam::Visitation::Entity::Administration::VisitationCompliancyAdmin::VisitationCompliancyAdmin
Controlling File: AssessmentPlanning\model\Packages\Visitation\Entity\Administration\VisitationCompliancyAdmin.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
visitationCompliancyAdminIDkeynoUnique identifier for the record.INTERNAL_ID SVR_INT64
relatedCaseTypedetailsnoThe type of the case associated with this visitation compliancy record. CASE_TYPE_CODECaseTypeCodeSVR_STRING<10>
relatedCaseIDdetailsnoThe unique identifier of the case related to this visitation compliancyINTERNAL_ID SVR_INT64
recordStatusdetailsnoThe status of the visitation compliancy record. RECORD_STATUS_CODERecordStatusSVR_STRING<10>
minPercentdetailsnoThe minimum percentage value for the range.VISITATION_COMPLIANCY_MINIMUM_PERCENT SVR_STRING<20>
maxPercentdetailsnoThe maximum percentage value for the range. VISITATION_COMPLIANCY_MAXIMUM_PERCENT SVR_STRING<20>
complianceLeveldetailsyesThe level assigned to visits that fall within the range specified by this record, i.e. Totally, Routinely, Sporadically, Rarely. VISITATION_COMPLIANCE_LEVELVisitationComplianceLevelSVR_STRING<10>
Indices (2)
Index NameAttributes
VisitComplianceIdxcomplianceLevel
VisitRelatedIdxrelatedCaseID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: visitationCompliancyAdminID
AUTO_ID_KEY: VISITBO
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
searchByRelatedIDTypeAndStatusreadmulti Returns a list of visitation compliancy admin records for the given case type, related ID and status. 
searchByComplianceRelatedIDTypeAndStatusreadmulti Returns a list of visitation compliancy admin records for the given compliance level, related ID and type 
Related Pages (8)