Table Description
Resolution Status History: The history of the resolution status on an issue.

The Resolution Status History list will display details of each resolution status change that the issue has been through, the effective date will also enable the user to determine the duration of each status. The status' of a resolution are In Edit, Submitted and Approved.

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 case favoring the employer's information. A resolution status history record is created with a value of In Edit. This table stores this resolution status history record.

Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Service Layer::ResolutionStatusHistory::Entity::ResolutionStatusHistory
Controlling File: core\model\Packages\Reference Model\Service Layer\ResolutionStatusHistory\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
resolutionStatusHistoryIDkeynoUnique reference number assigned by the system to the resolution status history record.RESOLUTION_STATUS_HISTORY_ID SVR_INT64
resolutionIDdetailsnoUnique reference number of the resolution record created for this issue.RESOLUTION_ID SVR_INT64
resolutionStatusdetailsnoCode table value to denote the status of the resolution rendered on the case.RESOLUTION_STATUS_CODEResolutionStatusCodeSVR_STRING<10>
effectiveDatedetailsnoThe date the status is effective from.CURAM_DATE SVR_DATE
resolutionConfigurationIDdetails Unique reference number of the configuration in administration upon which the issue delivery case is based. RESOLUTION_CONFIGURATION_ID SVR_INT64
Indices (1)
Index NameAttributes
resolutionIDIdxresolutionID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: resolutionStatusHistoryID
PRE_DATA_ACCESS: yes
This method is used to insert the ResolutionStatusHistory details 
searchByResolutionIDnsmulti To find all Resolution Status History records associated with the specified ResolutionSQL
readResStatusHistoryAndResTypeDetailsns Reads the resolution status history details.SQL
searchResolutionChangeHistoryByCaseIDnsmulti Read the change history for the resolutions on the given investigation delivery.SQL
Related Pages (17)