Table Description
Home Study Home Visit: A home visit conducted as part of a home study in order to gather information from individuals related to the home.

A home visit conducted as part of a home study in order to gather information from individuals related to the home.

Example

Initial Family Interview, Reference Interview etc.
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 Home Visit::Entity::HomeStudyHomeVisit
Controlling File: CPM\model\Packages\Service Layer\Home Study\Home Study Home Visit\HomeStudyHomeVisit_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
homeStudyHomeVisitIDkeynoThe unique system generated identifier for the home study home visit record.INTERNAL_ID SVR_INT64
homeStudyIDdetailsnoThe unique system generated identifier for the home study record.INTERNAL_ID SVR_INT64
purposedetails The purpose of the home visit.HOME_VISIT_PURPOSEHomeVisitPurposeSVR_STRING<10>
dateOfVisitdetails The date on which the home visit was conducted.CURAM_DATE SVR_DATE
homeVisitFindingsdetails A description of the overall result of the home study home visit.CPM_COMMON_TEXT SVR_STRING<1000>
commentsdetails Comments recorded by the user relating to the home visit.COMMENTS SVR_STRING<300>
recordStatusdetails The status is used to indicate if the home visit has been logically deleted.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
conductedBydetailsnoThe name of the user that conducted to home visit.USER_NAME SVR_STRING<64>
Foreign Keys (3)
ChildParent
HomeStudyHomeVisit.homeStudyIDHomeStudy.homeStudyID
HomeStudyHomeVisit.conductedByUsers.userName
HomeVisitInterview.homeStudyHomeVisitIDHomeStudyHomeVisit.homeStudyHomeVisitID
Indices (2)
Index NameAttributes
HomeStudyHomeVisitIndex1homeStudyID
HomeStudyHomeVisitIndex2conductedBy
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: homeStudyHomeVisitID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByHomeStudyreadmulti Returns a list of all of the home visits recorded for the given home study. 
Related Pages (12)