Table Description
Product Evidence Form Link: Permits an administrator to add more evidences to a product. Permits an administrator to add more evidences to a product.

Technical Notes

Please Note: This entity is no longer part of the default flow in the Curam Application, as such it is neither written to nor read from by the Curam Application. It continues to be shipped with the Curam model as customer may have custom logic which uses this entity, however it should be noted that if you are implementing custom logic which references this entity then you must also ensure that it is written to as needed. The information that was originally stored in this entity is now stored in evidence screen.
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::Products::Entity Objects::ProductEvidenceFormLink::ProductEvidenceFormLink
Controlling File: core\model\Packages\Products\Product EvidenceForm Link_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
VALIDATION_EXIT_POINTyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
productEvidenceFormLinkIDkeynoUnique ID of this recordPRODUCT_EVIDENCE_FORM_LINK_ID SVR_INT64
productIDdetailsnoID of the product that the evidence is available forPRODUCT_ID SVR_INT64
evidenceFormIDdetailsnoID of the evidence form entityEVIDENCE_FORM_ID SVR_INT64
startDatedetailsnoStart of period over which this evidence form is applicable on this productCURAM_DATE SVR_DATE
endDatedetails End of period over which this evidence form is applicable on this productCURAM_DATE SVR_DATE
recordStatusdetails Used by Curam to indicate if a record has been logically deletedRECORD_STATUS_CODERecordStatusSVR_STRING<10>
commentsdetails Free text entered in relation to the evidence form.COMMENTS SVR_STRING<300>
Foreign Keys (2)
ChildParent
ProductEvidenceFormLink.evidenceFormIDEvidenceForm.evidenceFormID
ProductEvidenceFormLink.productIDProduct.productID
Indices (2)
Index NameAttributes
PEFLnkEvidFormIDevidenceFormID, recordStatus
PEFLnkProductIDproductID
Operations (14)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByProductIDreadmultiORDER_BY: startDate
Returns a list of all matching Product Evidence Form Links for the corresponding Product  
searchByEvidenceFormIDreadmultiORDER_BY: startDate
WHERE: ProductEvidenceFormLink.evidenceFormID =:evidenceFormID AND (ProductEvidenceFormLink.recordStatus = :recordStatus OR :recordStatus IS NULL)
Returns a list of all matching Product Evidence Form Links for the corresponding Evidence Form  
searchByProductIDEvidenceFormIDStatusAndStartEndDatereadmultiWHERE: ProductEvidenceFormLink.productID = :productID AND ProductEvidenceFormLink.evidenceFormID =:evidenceFormID AND ProductEvidenceFormLink.recordStatus = :recordStatus AND (((:startDate >= ProductEvidenceFormLink.startDate) AND (:startDate <= ProductEvidenceFormLink.endDate OR ProductEvidenceFormLink.endDate IS NULL)) OR ((:startDate <= ProductEvidenceFormLink.startDate) AND (:endDate >= ProductEvidenceFormLink.startDate OR :endDate IS NULL)));
Returns a list of all matching Product Evidence Form Links for the corresponding Product in the given date range 
searchEvidenceFormUpdatesnsmultiPRE_DATA_ACCESS: yes
 		This method returns a list of the other versions of a given evidence form available for a product. (if any)SQL
searchEvidenceFormsForCasensmulti This method returns a list of all the evidence forms for a product which have not as yet been recorded with this case or its integrated case.SQL
countOverlappedProductEvidenceFormLinknsPRE_DATA_ACCESS: yes
 		Returns the count of all matching Product Evidence Form Links for the corresponding Product in the given date rangeSQL
countByEvidenceFormIDStatusAndDatens Returns count of records for the EvidenceFormID and status and endDate less than the provided oneSQL
searchICEvidenceFormsNotAlreadyAddednsmulti This method will retrieve all of the evidence forms available to be added to an integrated case.SQL
countNewEvidenceFormsForCasens This method returns a count of the evidence Forms, which can be added to a given Product Delivery case. These are the forms associated with the product, where no forms of that evidenceType have already been recorded.SQL
countNewEvidenceFormsForICns This method returns a count of the evidence Forms, which can be added to a given Integrated case. These are the forms associated with the IC Type, where no forms of that evidenceType have already been recorded.SQL
searchEvidenceFormsCompletedForCasensmulti This call returns all the evidence forms which have been filled in for a given case.SQL
Related Pages (10)