Table Description
Home Study Document: A document created as part of a home study that is based on a Microsoft Word template, which contains standard home study topics to be addressed.

A document created as part of a home study that is based on a Microsoft Word template, which contains standard home study topics to be addressed.

Example

A template on which a document may be based might contain sections to capture information on the social history of the providers, provider resources, or the attitudes and beliefs of the provider regarding Foster Care/Adoption issues.
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 Document::Entity::HomeStudyDocument
Controlling File: CPM\model\Packages\Service Layer\Home Study\Home Study Document\HomeStudyDocument_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
homeStudyDocumentIDkeynoThe unique system generated identifier for the home study document record.INTERNAL_ID SVR_INT64
homeStudyIDdetailsnoThe unique system generated identifier for the home study record.INTERNAL_ID SVR_INT64
documentTemplateIDdetailsnoThe unique system generated identifier for the document template record.DOCUMENT_TEMPLATE_ID SVR_STRING<40>
attachmentIDdetailsnoThe unique system generated identifier for the attachment record.ATTACHMENT_ID SVR_INT64
createdBydetailsnoUser name of the user who created this record.USER_NAME SVR_STRING<64>
dateCreateddetails The date on which the home study document was created.CURAM_DATE SVR_DATE
documentDescriptiondetails A description of the document created.DOCUMENT_DESCRIPTION SVR_STRING<50>
recordStatusdetails The status is used to indicate if the home study document has been logically deleted.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (4)
ChildParent
HomeStudyDocument.attachmentIDAttachment.attachmentID
HomeStudyDocument.documentTemplateIDDocumentTemplate.documentTemplateID
HomeStudyDocument.homeStudyIDHomeStudy.homeStudyID
HomeStudyDocument.createdByUsers.userName
Indices (4)
Index NameAttributes
HomeStudyDocumentIndex1attachmentID
HomeStudyDocumentIndex2createdBy
HomeStudyDocumentIndex3documentTemplateID
HomeStudyDocumentIndex4homeStudyID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: homeStudyDocumentID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByHomeStudynsreadmulti Retrieves a list of home study records for the home study specified. 
Related Pages (7)