Table Description
Resolution: The resolution which has been rendered on an issue.

Only one resolution is stored on an issue.

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 favoring the employers information. This table stores the details of the resolution rendered on the issue.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Service Layer::Resolution::Entity::Resolution
Controlling File: core\model\Packages\Reference Model\Service Layer\Resolution\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
resolutionIDkeynoUnique reference number assigned by the system to the resolution record.RESOLUTION_ID SVR_INT64
caseIDdetailsnoUnique reference number of the case header record created for this issue.CASE_ID SVR_INT64
resolutionConfigurationIDdetailsnoUnique identifier of the resolution configuration on which the resolution is based.RESOLUTION_CONFIGURATION_ID SVR_INT64
creationDatedetailsnoDate the resolution was recorded on the issue.CURAM_DATE SVR_DATE
userNamedetailsnoName of the user who recorded the resolution.USER_NAME SVR_STRING<64>
recordStatusdetails Used to logically delete a resolution that is added to an investigation.RECORD_STATUSRecordStatusSVR_STRING<10>
Indices (2)
Index NameAttributes
resolutionConfigurationIDIdxresolutionConfigurationID
resolutnCaseIDIdxcaseID
Operations (16)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: resolutionID
PRE_DATA_ACCESS: yes
This method is used to insert the Resolution details 
readread Reads the resolution details. 
modifyResolutionnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
This method is used to modify the Resolution. 
readByCaseIDnsread To find the Resolution associated with the specified Issue Delivery case 
validateInsert  Validates the Resolution details being inserted. 
validate  Validates the common Resolution details. 
countResolutionsByCaseIDns Counts the number of resolutions set up for an Issue Case.SQL
validateModify  Validates the Resolution details being modified. 
readVersionNonsread This method reads the version number for the specified resolution. 
readResolutionConfigurationIDnsread This method reads the resolutionConfigurationID for a resolution. 
validateCancel  Validate the resolution to be cancelled. 
cancelnsmodify Logically deletes this resolution. 
readResolutionForInvestigationns Reads the resolution for an investigation.SQL
readVersionNoByResolutionIDnsread This method reads the version number for the specified resolution based on the resolution identifier. 
countActiveResolutionByConfigIDnsPRE_DATA_ACCESS: yes
 		Counts the number of resolutions that are not canceled that are set up for all cases.SQL
countActiveResolutionByConfigIDCaseTypensPRE_DATA_ACCESS: yes
 		Counts the number of resolutions that are not canceled that are set up for cases of a relevant type.SQL
Related Pages (30)
Approve Resolution (Appeal_approveResolution)
Add Resolution (Appeal_createResolution)
Status history of the Issue Resolution (Appeal_listResolutionStatusHistory)
Reject Resolution (Appeal_rejectResolution)
Submit Resolution For Approval (Appeal_submitResolutionForApproval)
Status Details (Appeal_viewStatusDetails)
Issue Home (Case_viewIssuesTransaction)
Home (ICInvestigationSample_home)
- (Investigation_homeTabDetails)
Investigation_homeTabDetailsPreview
Remove Resolution (InvestigationDelivery_cancelInvestigationResolution)
Add Resolution (InvestigationDelivery_createResolution)
Edit Resolution (InvestigationDelivery_modifyResolution)
Submit For Approval (InvestigationDelivery_submit)
View Resolution Change History (InvestigationDelivery_viewChangeDetails)
Home (InvestigationSample_home)
Edit Resolution (IssueAppeal_modifyResolution)
Approve Resolution (IssueDelivery_approveResolution)
Add Resolution (IssueDelivery_createResolution)
Home (IssueDelivery_home)
Issue Home (IssueDelivery_homeForAppeal)
Resolution Status History (IssueDelivery_listResolutionStatusHistory)
Edit Resolution (IssueDelivery_modifyResolution)
Reject Resolution (IssueDelivery_rejectResolution)
Submit Resolution for Approval (IssueDelivery_submitResolutionForApproval)
View Resolution Status History (IssueDelivery_viewStatusDetails)
Remove Resolution (Product_cancelInvestigationResolutionLink)
Delete Resolution (Product_removeResolution)
Home (ProviderManagement_investigationHome)
- (ProviderManagement_viewProviderInvestigationTabDetails)