Table Description
ConcernRoleAttachmentLink: A link between an attachment and a concernRole This table allows the sharing and reuse of multiple attachments across multiple concern roles.

Example

Child Care Center Providers must provide a documents such as fire certificates, health and safety statements etc. These are also considered to be pertinent to the Provider, not a case.

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::Concern::Entity Objects::Concern Role Attachment Link::ConcernRoleAttachmentLink
Controlling File: core\model\Packages\Concern\ConcernRoleAttachmentLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
attachmentLinkIDkeynoUnique identifier assigned by the system to the concern role attachment link record.INTERNAL_ID SVR_INT64
concernRoleIDdetailsnoUnique identifier for the concern role record.CONCERN_ROLE_ID SVR_INT64
attachmentIDdetailsnoUnique identifier of the attachment record being linked to the concern role.ATTACHMENT_ID SVR_INT64
statusCodedetailsnoThe record status code applied to this link.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
descriptiondetails The description of the attachment.DESCRIPTION SVR_STRING<300>
dateReceiveddetails Date on which the attachment was added to the participant.CURAM_DATE SVR_DATE
Foreign Keys (2)
ChildParent
ConcernRoleAttachmentLink.attachmentIDAttachment.attachmentID
ConcernRoleAttachmentLink.concernRoleIDConcernRole.concernRoleID
Indices (2)
Index NameAttributes
roleAttchmntIdxconcernRoleID
IND__922224182attachmentID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertPRE_DATA_ACCESS: no
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: no
Standard Operation 
searchByConcernRolereadmultiWHERE: ConcernRoleAttachmentLink.concernRoleID = :concernRoleID
This method will return a list of commAttachmentLinks for a particular Communication 
countByAttachmentIDAndRecordStatusns Counts the number of records relating to the specified attachment ID and record status.SQL
Related Pages (26)