Table Description
Home Study: A study conducted on a provider to ascertain that the living conditions and environment of the home are suitable for the care of the agency's clients.

A study conducted on a provider to ascertain that the living conditions and environment of the home are suitable for the care of the agency's clients.

Example

An example of a type of provider for which a home study will be conducted is a Foster Care Home.
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::CPM::Service Layer::Home Study::Home Study::Entity::HomeStudy
Controlling File: CPM\model\Packages\Service Layer\Home Study\Home Study\HomeStudy_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (11)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
homeStudyIDkeynoThe unique system generated identifier for the home study record.INTERNAL_ID SVR_INT64
providerConcernRoleIDdetailsnoThe unique system generated identifier for the provider.CONCERN_ID SVR_INT64
homeStudyTypedetails The type of home study, e.g. Foster Home or Adoptive Home.HOME_STUDY_TYPEHomeStudyTypeSVR_STRING<10>
purposedetails The purpose for which the home study is being conducted, e.g. to complete an initial home study of a new Foster Home.HOME_STUDY_PURPOSEHomeStudyPurposeSVR_STRING<10>
dateInitiateddetails The date on which all activities associated to the home study first commenced.CURAM_DATE SVR_DATE
reevaluationDatedetails The date on which a subsequent home study to reassess the home should begin, e.g. a home study for the purposes of re-evaluation may be due to be initiated one year after the approval of the initial home study.CURAM_DATE SVR_DATE
finalRecommendationdetails The recommendation made by the assessor for the home study, prior to submitting the home study for approval.HOME_STUDY_FINAL_RECOMMENDATIONHomeStudyFinalRecommnSVR_STRING<10>
supportForRecommendationdetails Information to clarify the recommendation made by the assessor of the home study.CPM_COMMON_TEXT SVR_STRING<1000>
commentsdetails Comments recorded by a user relating to the home study.COMMENTS SVR_STRING<300>
statusdetails The status of the home study. For example, when a home study is approved, the status will be set to 'Approved'.HOME_STUDY_STATUS_CODEHomeStudyStatusSVR_STRING<10>
assessorNamedetailsnoThe name of the user who is responsible for assessing this Home Study.USER_NAME SVR_STRING<64>
Foreign Keys (6)
ChildParent
HomeStudy.providerConcernRoleIDProvider.providerConcernRoleID
HomeStudy.assessorNameUsers.userName
HomeStudyAssessment.homeStudyIDHomeStudy.homeStudyID
HomeStudyDocument.homeStudyIDHomeStudy.homeStudyID
HomeStudyHomeVisit.homeStudyIDHomeStudy.homeStudyID
HomeStudyStatusHistory.homeStudyIDHomeStudy.homeStudyID
Indices (4)
Index NameAttributes
HomeStudyIndex1providerConcernRoleID
HomeStudyIndex2assessorName
HomeStudyStatusIdxstatus
HomeStudyDateInitiatedIdxdateInitiated
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: homeStudyID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByProviderreadmulti   
searchByDateRangeAndStatusnsmulti Searches all the home studies whose date initiated is between the date range for a given status.SQL
Related Pages (30)
Approve Home Study (HomeStudy_approvePopup)
Delete Assessment (HomeStudy_cancelAssessmentForHomeStudy)
Delete Home Visit (HomeStudy_cancelHomeVisitForHomeStudy)
Cancel Interview (HomeStudy_cancelInterviewForHomeStudy)
Delete Home Study (HomeStudy_cancelPopup)
Opening Microsoft Word Document (HomeStudy_controlMSWord)
New Assessment (HomeStudy_createAssessmentForHomeStudy)
New Document (HomeStudy_createHomeStudyDocument)
New Home Visit (HomeStudy_createHomeVisitForHomeStudy)
New Interview (HomeStudy_createInterviewForHomeVisit)
New Home Study (HomeStudy_createPopup)
Delete Document (HomeStudy_deleteHomeStudyDocument)
Home Study Assessments (HomeStudy_listAssessmentForHomeStudy)
Home Study Documents (HomeStudy_listDocumentsForHomeStudy)
Home Studies (HomeStudy_listHomeStudies)
Home Visit (HomeStudy_listHomeVisitsForHomeStudy)
Edit Assessment (HomeStudy_modifyAssessmentForHomeStudy)
Edit Document (HomeStudy_modifyHomeStudyDocument)
Edit Home Visit (HomeStudy_modifyHomeVisitForHomeStudy)
Edit Interview (HomeStudy_modifyInterviewForHomeStudy)
Edit Home Study (HomeStudy_modifyPopup)
Reject Home Study Recommendation (HomeStudy_rejectPopup)
Submit for Approval (HomeStudy_submitForApprovalPopup)
View Assessment for Home Study (HomeStudy_viewAssessmentForHomeStudy)
Home Study For Provider (HomeStudy_viewDetails)
View Home Study Document (HomeStudy_viewHomeStudyDocument)
View Home Visit For Home Study (HomeStudy_viewHomeVisitForHomeStudy)
View Interview for Home Visit (HomeStudy_viewInterviewForHomeVisit)
Home Study Status History (HomeStudy_viewStatusHistoryPopup)
Approve Provider Service (ProviderManagement_approveProviderServiceOffering)