Table Description
Entity to link the name of the online user who created the piece of evidence as part of a change of circumstance. CoC Evidence Link: This entity allows a citizen to be linked to a piece of evidence This entity allows a citizen to be linked to a piece of evidence. The link is inserted when the citizen creates a piece of evidence as part of a change of circumstance via the online portal
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::HCROnline::Service Layer::entity::CoCEvidenceLink::CoCEvidenceLink
Controlling File: HCROnline\model\Service Layer\Entity\Entity.efx
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceLinkIDkeyno INTERNAL_ID SVR_INT64
evidenceDescriptorIDdetailsno EVIDENCE_DESCRIPTOR_ID SVR_INT64
usernamedetailsno USER_NAME SVR_STRING<64>
timestampdetailsno CURAM_DATETIME SVR_DATETIME
Foreign Keys (1)
ChildParent
CoCEvidenceLink.evidenceDescriptorIDEvidenceDescriptor.evidenceDescriptorID
Indices (1)
Index NameAttributes
IND__1867617576evidenceDescriptorID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: evidenceLinkID
Standard Operation 
searchByEvidenceDescriptorIDreadmulti   
searchByCaseIDnsmulti Searches across the EvidenceDescriptor table by case ID for records that exist on the CoCEvidenceLink table and are associated with tha case ID. SQL
countByCaseIDAndEvidenceStatusns Returns a count of CoCEvidenceLink records for the specified case and evidence status.SQL
countUnevaluatedByCaseIDns Returns a count of CoCEvidenceLink records for the specified case and for the evidence which is in a state of unevaluated. Evidence can attain this state when verifications have been deferred and in edit evidence is added to the case and not activated due to evidence validation failures.SQL
searchByCaseIDAndEvidenceStatusnsmulti Returns a list of the details of evidence descriptor records associated with a specified case and evidence status and linked to a change of circumstance.SQL
Related Pages (5)