Table Description
Product Evidence Link: A relationship between an evidence type and a product.

The evidence metadata entity stores configuration data about an evidence type. Product evidence link entity provides a link between evidence metadata and a product, which indicates the list of evidence types used by a product or conversely the list of products which use a particular evidence type.

Example

Income support benefit uses a range of evidence types including income evidence and income usage evidence. Once the evidence is designed and configured in evidence metadata table, the income evidence and income usage evidence types are associated with income support product by creating two product evidence link records; one between income support product and income evidence, the second between income support product and income usage evidence. With these links established the temporal evidence solution will know that these two evidence types are used by the income support product.

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::Infrastructure::Temporal Evidence::Entity::Product Evidence Link::ProductEvidenceLink
Controlling File: core\model\Packages\Reference Model\Service Layer\Temporal Evidence\Entity\ProductEvidenceLink\ProductEvidenceLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGno
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
productEvidenceLinkIDkeynoUnique reference number of the product evidence link record.PRODUCT_EVIDENCE_LINK_ID SVR_INT64
productIDdetailsnoIdentifier of the product record linked to the evidence metadata record.PRODUCT_ID SVR_INT64
evidenceMetadataIDdetailsnoIdentifier of the evidence metadata record linked to the product record. This sets up a relationship between the evidence type recorded for the evidence metadata and the product.EVIDENCE_METADATA_ID SVR_INT64
dataLinkedToProductInddetailsnoIndicates if the evidence type is maintained at product level. Where this value is true it indicates the evidence is maintained at product level and used during entitlement by the product. Where the value is false it indicates that the evidence is maintained elsewhere, (e.g. at integrated case level) but used during entitlement by the product in question.CURAM_INDICATOR SVR_BOOLEAN
shareableInddetails Indicates if the evidence type can be shared by the product. If it is set to true, then this evidence type can be in Evidence Broker to configure sharing between case types.CURAM_INDICATOR SVR_BOOLEAN
categorydetailsyesThe category code for the evidence in the context of this Product.EVIDENCE_CATEGORYEvidenceCategorySVR_STRING<10>
quickLinkInddetailsyesAn indicator used to show if this evidence type will appear in the quick link list for adding evidence.CURAM_INDICATOR SVR_BOOLEAN
sortOrderdetails The sort order is an integer value used when ordering evidence types, if multiple types have the same sort order the alphabetic ordering of the type code will be used.EVIDENCE_SORT_ORDER SVR_INT64
Foreign Keys (1)
ChildParent
ProductEvidenceLink.evidenceMetadataIDEvidenceMetadata.evidenceMetadataID
Indices (2)
Index NameAttributes
PELEvMtIDProdIDIdxevidenceMetadataID, productID
PELIdxproductID
Operations (16)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: productEvidenceLinkID
AUTO_ID_KEY: PRODEVLNK
PRE_DATA_ACCESS: yes
Standard Operation 
removeremove Standard Operation 
searchByProductIDnsmultiPRE_DATA_ACCESS: no
 
Retrieves a list of evidence types associated with a specified product.SQL
countDuplicatesns  SQL
searchProductsByEvidenceTypensmulti Retrieves the list of products a specified evidence type is being used on.SQL
searchProductsByTypeAndLinkedToProductnsmulti Retrieves all products where the evidence is associated at product level.SQL
searchProductByStatusBenefitIndAndShareableIndnsmulti Retrieves all products where the evidence can be shared. The details retrieved include product ID, name and product type.SQL
modifyShareableByProductIndnsmodifyOPTIMISTIC_LOCKING: no
PRE_DATA_ACCESS: no
Updates the shareable indicator, used by the evidence broker, on the product evidence link. 
searchByProductIDKeyreadmulti Return&nbsp;a&nbsp;list&nbsp;of&nbsp;product evidence link&nbsp;records&nbsp;by&nbsp;product ID. 
modifymodify Modifies a row of data from ProductEvidenceLink table. 
readread Reads a row of data from ProductEvidenceLink table. 
searchDetailsByProductIDnsmulti  SQL
insertProductEvidenceLinkinsert <p class="MsoNormal"> <span style="COLOR: #002060">Inserts product evidence link record. This method expects the productEvidenceLinkID to be set. It is preferred to call insertProductEvidenceLink method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
searchEvidenceTypeLinkEntityDetailsByProductIDnsmulti  SQL
searchDetailsByProductIDAndLinkedToProductnsmulti  SQL
searchByEvidenceMetaDataAndProductreadmulti Returns all columns of Product Evidence Link for the given evidenceMetadataID and productID. 
Related Pages (43)
Transfer Application (Application_transferApplicationToExistingCase)
CAProductHomeDetails
Check Eligibility (CheckEligibility)
Check Eligibility (CheckMAEligibility)
Check Eligibility (CheckMAEligibilityFromIC)
CHIPProductHomeDetails
CREOLECAProductHomeDetails
CREOLECHIPProductHomeDetails
CREOLEFAProductHomeDetails
CREOLEMAProductHomeDetails
Program Summary (Eligibility_createProgram)
Eligibility Result (Eligibility_viewResults)
Transfer Evidence: (Evidence_listEvidenceForTransfer)
Confirm Evidence Transfer (Evidence_transferEvidenceConfirmation)
FAProductHomeDetails
Check Retroactive Spend Down Eligibility (ISP_checkSpendDownRetroactiveEligibility)
Retroactive Medical Assistance Eligibility Result (ISP_viewCurrentRetroactiveMedicalAssistanceEligibilityResults)
Retroactive Spend Down Eligibility Result (ISP_viewCurrentRetroactiveSpendDownEligibilityResults)
Medical Assistance with Spend Down Eligibility Result (ISP_viewMedicalAssistanceWithSDEligibilityDetails)
Medical Assistance with Spend Down Retroactive Eligibility Result (ISP_viewRetroactiveMedicalAssistanceWithSDEligibilityDetails)
Medical Assistance with Spend Down Program Summary (ISPSpendDown_createProgram)
Create Program (ISPSpendDown_createRetroactiveProgram)
Add Evidence (IssueDelivery_addEvidence)
Add Evidence (IssueDelivery_addEvidenceForIC)
Add Evidence (IssueDelivery_addEvidenceForProductDelivery)
Create Issue (IssueDelivery_createIssue)
New Issue Case (IssueDelivery_createIssueForICWizard)
New Issue Case (IssueDelivery_createIssueForPDWizard)
Product Evidence (Liability_listProductEvidenceLink)
LIFCProductHomeDetails
LTCProductHomeDetails
Add Existing Evidence Metadata (Product_addExistingEvidenceMetadata)
Confirm cancel (Product_cancelProductEvidenceLink)
New Evidence Metadata (Product_createEvidenceMetadata)
New Evidence Metadata & Product Evidence (Product_createEvidenceMetadataAndProductEvidenceLink)
Product Evidence (Product_listProductEvidenceLink)
Confirm Enable: (ProductEvidenceLink_setShareable)
Confirm Disable: (ProductEvidenceLink_unsetShareable)
ProductHomeDetails
Authorize (ProgramRecommendation_listHouseholdMembersForMA)
RefugeeProductHomeDetails
SpendDownProductHomeDetails
TBBCCProductHomeDetails