Table Description
Advanced Evidence Sharing Delivery Plan: This entity represents a plan to deliver a shared piece of evidence, represented by a share item, to a target case on a target system. Multiple delivery plans can exist for the same share item. This entity is purely infrastructural and internal to the Advanced Evidence Sharing solution. It should not be extended or customized in any way.
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::Entity::AESDeliveryPlan::AESDeliveryPlan
Controlling File: AdvancedEvidenceSharing\model\Entity\AESDeliveryPlan\AESDeliveryPlan.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
LAST_UPDATED_FIELDyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
deliveryPlanIDkeynoUnique identifier of the Advanced Evidence Sharing Delivery Plan entity.ADVANCED_EVIDENCE_SHARING_DELIVERY_PLAN_ID SVR_INT64
shareItemIDdetailsnoA foreign key to an Advanced Evidence Sharing Share Item record.ADVANCED_EVIDENCE_SHARING_SHARE_ITEM_ID SVR_INT64
borActiondetailsyesA business object resolution action. This is an instruction of how to treat the evidence (i.e. the share item) to be delivered as part of this Advanced Evidence Sharing Delivery Plan, e.g. Insert the evidence or Modify the evidence.ADVANCED_EVIDENCE_SHARING_BUSINESS_OBJECT_RESOLUTION_ACTIONAESBORActionSVR_STRING<10>
borEvidenceIDdetailsyesThis represents the evidence on the target case that was matched to, and which will be actioned, by the delivery. In the case of an insert, this field will be left blank as no matching happens in this instance.EVIDENCE_ID SVR_INT64
targetSystemdetailsnoThe target system, e.g. Curam.ADVANCED_EVIDENCE_SHARING_TARGET_SYSTEMAESTargetSystemSVR_STRING<10>
targetCaseIDdetailsnoThe identifier of the target case.CASE_ID SVR_INT64
configShareCaseIDdetailsnoJoe Smith is a member on the following 3 cases:

  • Unemployment Benefit
  • Income Support
  • HCR

The following evidence sharing configurations exist on the system:

  • Unemployment Benefit -> Income Support
  • Income Support -> HCR

If a piece of Income evidence is added to the Unemployment Benefit case, then that evidence should be brokered to both the Income Support and HCR cases. This will be achieved through two separate delivery plans.

For the delivery plan that delivers the Income evidence from Income Support to HCR, the configShareCaseID should be that of the Income Support case, as the sharing configuration dictates that the evidence is shared between these two types. Storing the correct configShareCaseID is important as it mandates how the evidence is treated when it makes its way onto the target case. The sharing configuration between Unemployment Benefit and Income Support might mandate that the evidence comes from a trusted source, whereas the sharing configuration between Income Support and HCR might mandate that the evidence does not come from a trusted source, i.e. it requires case worker review before being accepted onto the case.

CASE_ID SVR_INT64
evidenceTypedetailsnoThe type of evidence being delivered to the target case. For logically equivalent evidence, this may be different to the evidence that was shared.EVIDENCE_TYPE_CODEEvidenceTypeSVR_STRING<10>
statusdetailsnoThe status of the delivery plan. This can be one of the following:

  • Open
  • In Progress
  • Complete
  • Complete With Fallback To In-Edit
  • Complete With Fallback To Incoming Evidence
  • Complete - Could Not Remove As Record Has Dependents
  • Delivery Failed - Retry Required
  • Complete With Failure - Evidence Is Not Delivered
ADVANCED_EVIDENCE_SHARING_DELIVERY_PLAN_STATUSAESDeliveryPlanStatusSVR_STRING<10>
Foreign Keys (3)
ChildParent
AESDeliveryPlan.shareItemIDAESShareItem.shareItemID
AESDeliveryPlan.configShareCaseIDCaseHeader.caseID
AESDeliveryPlan.targetCaseIDCaseHeader.caseID
Indices (3)
Index NameAttributes
EBShareItemIdxshareItemID
IND__1562022129targetCaseID
IND__1843307915configShareCaseID
Operations (15)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: deliveryPlanID
PRE_DATA_ACCESS: yes
Standard Operation 
modifyStatusnsmodifyOPTIMISTIC_LOCKING: yes
  
readread Standard Operation 
searchByShareItemIDreadmulti   
validate  Validates the Advanced Evidence Sharing Delivery Plan entity details. @param details Advanced Evidence Sharing Delivery Plan entity details @throws curam.util.exception.AppException Generic Exception Message @throws curam.util.exception.InformationalException Generic Exception Message  
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByTargetCaseEvidenceTypeAndStatusreadmulti   
searchByTargetCaseAndStatusreadmulti   
searchByTargetCaseAndEvidenceTypereadmulti   
countTotalNumberOfRecordsns Counts the total number of records on the Advanced Evidence Sharing Delivery Plan entity.SQL
countNumRecordsByStatusns Counts all the records of a specified status on the Advanced Evidence Sharing Delivery Plan entity.SQL
modifyBORnsmodifyOPTIMISTIC_LOCKING: yes
Modifies the borAction and borEvidenceID fields on an Advanced Evidence Sharing Delivery Plan record. 
searchByShareSetIDnsmulti  SQL
searchByTargetCaseIDreadmulti   
readShareSetTypens  SQL
Related Pages (4)