Table Description
VerificationAttachmentLink : Records an attachment to the provision of a verification item.

When an item is added to a verification, in order to verify a piece of data, this item can be delivered in a number of different forms; a document, a phone call, an email. If the item is electronic, the user can 'attach' the item to the item provision and it can be viewed an maintained at any stage. Alternatively, the user may scan a hard copy document and attach the resulting file. If a hard copy of the item is retained, the user can specify the location and reference of the file as part of the attachment.

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::Verification::Application::Service Layer::Verification Attachment Link::Entity::VerificationAttachmentLink
Controlling File: Verification\model\Packages\Application\Service Layer\Verification Attachment Link\Entity\VerificationAttachmentLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
verificationAttachmentLinkIDkeynoUnique reference number assigned by the system to a verification item attachment record.VERIFICATION_ATTACHMENT_LINK_ID SVR_INT64
verificationItemProvidedIDdetailsnoUnique reference number assigned by the system which refers to the details of the provision of this verification item.VERIFICATION_ITEM_PROVIDED_ID SVR_INT64
attachmentIDdetailsnoUnique reference number to the Attachment entity within the Core Enterprise Framework.ATTACHMENT_ID SVR_INT64
descriptiondetails A description of the attachment.DESCRIPTION SVR_STRING<300>
recordStatusdetails Used to support logical deletes.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
VerificationAttachmentLink.verificationItemProvidedIDVerificationItemProvided.verificationItemProvidedID
Indices (2)
Index NameAttributes
AttIDVerAttLkIDXattachmentID
IND_1230691955verificationItemProvidedID
Operations (18)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: verificationAttachmentLinkID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyPRE_DATA_ACCESS: yes
Standard Operation 
cancelnsmodifyPRE_DATA_ACCESS: yes
  
searchAttachmentByVerificationItemProvidednsmulti  SQL
validateInsert    
validateModify    
validateDetails    
validateCancel    
readAttachmentIDByLinkIDnsread   
validateAttachmentLink    
readEvidenceDescriptorIDByProvidedIDns  SQL
readVerificationItemContextNamens  SQL
readVerificationItemContextNameByAttachIDns  SQL
readProvidedIDByAttachmentIDnsread   
searchAttachmentByVerificationAttachmentLinknsmulti Returnes the VerificationAttachmentSummaryDetailsList by verification item idSQL
searchByAttachmentIDreadmulti Reads all the records matching the given attachment id. 
countByAttachmentIDAndRecordStatusns Counts the number of records corresponding to the specified attachment ID and record status.SQL
Related Pages (32)
View Verification Item Provision Details: (ApplicationVerification_viewVerificationItemProvisionDetails)
Add Attachment (ApplicationVerificationApplication_addAttachmentForItem)
Add Proof (ApplicationVerificationApplication_createVerificationItemProvision)
Edit Attachment Details (ApplicationVerificationApplication_modifyAttachmentDetails)
Accept All Evidence (EvidenceBroker_acceptAllIncomingEvidence)
Accept Evidence (EvidenceBroker_acceptIncomingEvidence)
Dismiss Evidence (EvidenceBroker_confirmResolvedNonIdenticalEvidence)
Synchronize Evidence: (EvidenceBroker_listEvidenceForSynchronizing)
Reject All Evidence (EvidenceBroker_rejectAllIncomingEvidence)
Reject Evidence (EvidenceBroker_rejectIncomingEvidence)
Accept Documents (VerificationApplication_acceptAllSubmittedDocumentsForItem)
Accept Document (VerificationApplication_acceptSubmittedDocumentForItem)
Add Attachment (VerificationApplication_addAttachment)
Add Attachment: (VerificationApplication_addAttachmentEvidenceDetails)
Add Attachment (VerificationApplication_addAttachmentForItem)
Verify Evidence (VerificationApplication_associateOutstandingEvd)
Verify Evidence (VerificationApplication_associateOutstandingEvdForPDC)
Add Proof (VerificationApplication_createParticipantVerificationItemProvision)
Add Proof (VerificationApplication_createVerificationItemProvision)
Delete Attachment (VerificationApplication_deleteAttachment)
Delete Attachment: (VerificationApplication_deleteAttachmentEvidenceDetails)
Delete Attachment (VerificationApplication_deleteAttachmentFromList)
Edit Attachment Details (VerificationApplication_modifyAttachmentDetails)
Edit Attachment Details: (VerificationApplication_modifyAttachmentDetailsEvidenceDetails)
Edit Attachment Details (VerificationApplication_modifyAttachmentDetailsFromList)
Remove Verification Item (VerificationApplication_removeVerificationItemProvision)
View Attachment Details : (VerificationApplication_viewAttachment)
View Attachment Details : (VerificationApplication_viewAttachmentEvidenceDetails)
View Attachment Details (VerificationApplication_viewAttachmentFromItem)
View Verification Item Provision Details: (VerificationApplication_viewEvidenceVerificationItemProvisionDetails)
View Verification Item Provision Details: (VerificationApplication_viewVerificationItemProvisionDetails)
Verification Item Provision (VerificationApplication_viewVerificationItemProvisionDetailsForList)