Table Description
Issue Resolution Link: A relationship between a resolution and a type of issue.

This table allows for the associations between a resolution and a type of issue in Issue Administration.

Example

During case processing a discrepancy is identified between the earned income details provided by the client and those provided by the client's employer. An earned income issue is automatically created. A user reviews the issue and renders a resolution on the issue favoring the employers information.

To facilitate this, the following needs to be created in the Administration component:

  • An administrator creates an issue of type Earned Income.
  • A resolution of 'Agree with Employer' is also created.
  • This resolution is associated with the earned income issue.
This table stores the association between the resolution and the earned income issue.

Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Service Layer::IssueResolutionLink::Entity::IssueResolutionLink
Controlling File: core\model\Packages\Reference Model\Service Layer\IssueResolutionLink\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
LAST_UPDATED_FIELDyes
VALIDATION_EXIT_POINTno
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
issueResolutionLinkIDkeynoUnique reference number assigned by the system to the issue resolution record.ISSUE_RESOLUTION_LINK_ID SVR_INT64
resolutionConfigurationIDdetails Unique reference number of the resolution which has been associated with the issue.RESOLUTION_CONFIGURATION_ID SVR_INT64
issueConfigurationIDdetails Unique reference number of the issue which has been associated with the resolution.ISSUE_CONFIGURATION_ID SVR_INT64
startDatedetails The date the resolution was associated with the type of issue.CURAM_DATE SVR_DATE
endDatedetails The date the resolution was removed from the type of issue.CURAM_DATE SVR_DATE
recordStatusdetails Status of the issue resolution link record i.e. Active or Canceled.RECORD_STATUSRecordStatusSVR_STRING<10>
Indices (1)
Index NameAttributes
IssueResolutionIDIndexissueConfigurationID
Operations (13)
OperationStereotypeOptionsDescriptionSQL
searchByIssueConfigurationIDnsmulti Returns a list of resolution configurations associated with a particular issue configuration.SQL
insertinsertAUTO_ID: issueResolutionLinkID
AUTO_ID_KEY: ISSUESBO
PRE_DATA_ACCESS: yes
Inserts the issue resolution link details. 
readRecordStatusnsread Reads the record status for issue resolution link. 
cancelnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Changes the recordStatus of the issue resolution link to 'canceled'. 
countByResolutionConfigurationIDns Counts the number of active issue resolution link records for a specified resolution.SQL
validateCancel  Validates issue resolution cancellation. 
validateInsert  Validates the Issue Resolution Link details being inserted. 
searchByIssueConfigIDAndStatusnsmulti Returns a list of active resolutions associated with a particular issue.SQL
readVersionNonsread Returns the version number for a specified issue resolution link record. 
searchForUnassignedResolutionsnsmulti  SQL
readread Reads&nbsp;the&nbsp;issue&nbsp;resolution&nbsp;link&nbsp;details. 
modifymodify Modifies&nbsp;the&nbsp;issue&nbsp;resolution&nbsp;link&nbsp;details. 
insertIssueResolutionLinkinsert Inserts&nbsp;issue&nbsp;resolution&nbsp;link&nbsp;record.&nbsp;This&nbsp;method&nbsp;expects&nbsp;the&nbsp;issueResolutionLinkID&nbsp;to&nbsp;be&nbsp;set.&nbsp;It&nbsp;is preferred&nbsp;to&nbsp;call&nbsp;insertIssueResolutionLink&nbsp;method&nbsp;only&nbsp;in&nbsp;scenarios&nbsp;where&nbsp;calling&nbsp;method&nbsp;wants&nbsp;to&nbsp;set&nbsp;the&nbsp;value&nbsp;of&nbsp;primary<br /> key&nbsp;by&nbsp;itself. 
Related Pages (8)