Table Description
Participant Comment : Comments made by a participant in relation to a service, referral or action that a client is participating in.

Any time an action, service, referral or activity is created for a client, an event is raised and a record is stored on this entity to make it easier to access all activities a client is associated with.

Example

James Smith was assessed for substance abuse issues and as a result the case worker scheduled 10 sessions of counseling from 01/01/2011 to 02/15/2011 provided by Dr. John Kelly. James Smith submits comments about this service using the Citizen Self Service. This entity stores these comments.

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::Core::Reference Model::Service Layer::ParticipantComment::Entity::ParticipantComment
Controlling File: core\model\Packages\Reference Model\Service Layer\ParticipantComment_cat.efx
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
participantCommentIDkeynoUnique identifier for participant comment.INTERNAL_ID SVR_INT64
concernRoleIDdetailsnoReference to the Participant that has made this comment.INTERNAL_ID SVR_INT64
relatedObjectIDdetailsnoUnique reference of the object with which the comment is associated. For example, a referral, service delivery, etc. This id is used in conjunction with the relatedObjectType for lookup.INTERNAL_ID SVR_INT64
relatedObjectTypedetailsnoThe type of object that this comment is related to. For example, a referral, service delivery, etc.COMMENT_RELATED_TYPECommentRelatedTypeSVR_STRING<10>
creationDateTimedetailsnoThe time and date that this comment was created.CURAM_DATETIME SVR_DATETIME
commentsdetailsnoThe comment that the participant has made.PARTICIPANT_COMMENT_TEXT SVR_STRING<2000>
createdBydetailsnoThe user that created this record.USER_NAME SVR_STRING<64>
Foreign Keys (1)
ChildParent
ParticipantComment.concernRoleIDConcernRole.concernRoleID
Indices (2)
Index NameAttributes
ptCmtCRRelTyIDIdxconcernRoleID, relatedObjectType, relatedObjectID
ptCmtRelTyIDIdxrelatedObjectID, relatedObjectType
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: participantCommentID
Standard Operation 
readread Standard Operation 
searchByConcernRoleRelatedTypeIDreadmulti Searches for comments based on concernRole and related object. 
searchByRelatedTypeAndIDreadmulti Searches for comments based on the related id and type fields. 
Related Pages (3)