Table Description
Home Visit Interview: An interview conducted as part of a home visit.

An interview conducted as part of a home visit.

Example

A couple who wish to provide foster care services are interviewed in their home by the resource manager as part of a home 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::CPM::Service Layer::Home Study::Home Visit Interview::Entity::HomeVisitInterview
Controlling File: CPM\model\Packages\Service Layer\Home Study\Home Visit Interview\HomeVisitInterview_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
homeVisitInterviewIDkeynoThe unique system generated identifier for the home visit interview record.INTERNAL_ID SVR_INT64
homeStudyHomeVisitIDdetailsnoThe unique system generated identifier for the home study home visit record.INTERNAL_ID SVR_INT64
typedetails The type of interview conducted, for example home visit interview.HOME_VISIT_INTERVIEW_TYPEHomeVisitInterviewTypeSVR_STRING<10>
startDateTimedetails The date and time at which the interview began.CURAM_DATETIME SVR_DATETIME
endDateTimedetails The date and time at which the interview ended.CURAM_DATETIME SVR_DATETIME
methoddetails The method by which the interview has taken place, for example Face-to-Face.HOME_VISIT_METHODHomeVisitMethodSVR_STRING<10>
narrativedetails The narrative for the interview. For example the resource manager may record the areas discussed and answers giving by interviewees during the interview.CPM_COMMON_TEXT SVR_STRING<1000>
locationdetails The location where the interview took place.HOME_VISIT_INTEVIEW_LOCATIONHomeVisitInteviewLocationSVR_STRING<10>
recordStatusdetails The status is used to indicate if the interview has been logically deleted.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (2)
ChildParent
HomeVisitInterview.homeStudyHomeVisitIDHomeStudyHomeVisit.homeStudyHomeVisitID
InterviewAttendee.homeVisitInterviewIDHomeVisitInterview.homeVisitInterviewID
Indices (1)
Index NameAttributes
HomeVisitInterviewIndex1homeStudyHomeVisitID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: homeVisitInterviewID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByHomeStudyHomeVisitreadmulti   
Related Pages (8)