D:IssueResolutionApprovalCheck

Table Description

Issue Resolution Approval Check: Issue resolution approval checks.

Issue Resolution approval checks specify the percentage of issue resolutions, that must be manually approved.

Issue Resolution approval checks can be specified at the User, Organization Unit and Issue Type levels.

Example

An issue resolution approval check value is set at sixty percent for a user, then sixty percent of issue resolutions recorded by this user must be manually approved. The remaining forty percent of issue resolutions will be automatically approved by the system.

Model Details

Location in Model:	Logical View::MetaModel::Curam::Core::Reference Model::Service Layer::IssueResolutionApprovalCheck::Entity::IssueResolutionApprovalCheck
Controlling File:	core\model\Packages\Reference Model\Service Layer\IssueResolutionApprovalCheck\Entity\IssueResolutionApprovalCheck_cat.efx

Table Options

ALLOW_OPTIMISTIC_LOCKING

yes

Attributes (8)

Attribute	Stereotype	Nullable	Description	Domain Definition	Codetable	DDL Type
issueResolutionApprovalCheckID	key	no	Unique reference number assigned by the system to the issue approval check record.	ISSUE_RESOLUTION_APPROVAL_CHECK_ID		SVR_INT64
issueConfigurationID	details		Unique reference number of the issue type for which the approval check has been created.	ISSUE_CONFIGURATION_ID		SVR_INT64
percentage	details		Percentage of records which must be manually approved.	ISSUE_RESOLUTION_APPROVAL_CHECK_RATE		SVR_INT16
typeCode	details		Type of approval check i.e. type, user approval check or organization approval check.	ISSUE_RESOLUTION_APPROVAL_CHECK_CODE	IssueResApprovalCheck	SVR_STRING<10>
organisationUnitID	details		Unique reference number of the organization unit for which the approval check has been created.	ORGANISATION_UNIT_ID		SVR_INT64
userName	details		The user for which the approval check has been created.	USER_NAME		SVR_STRING<64>
comments	details		Comments added by a user to the approval check.	COMMENTS		SVR_STRING<300>
recordStatus	details		Status of the approval check record.	RECORD_STATUS_CODE	RecordStatus	SVR_STRING<10>

Indices (2)

Index Name	Attributes
OrgUnitIDIssueIdx	organisationUnitID, issueConfigurationID, typeCode, recordStatus
IND__1019959275	userName

Operations (35)

Operation	Stereotype	Options	Description	SQL
insert	insert	AUTO_ID: issueResolutionApprovalCheckID AUTO_ID_KEY: ISRNAPPCHK PRE_DATA_ACCESS: yes	Inserts an IssueResolutionApprovalCheck record.
read	read		Reads an IssueResolutionApprovalCheck record.
modify	modify	OPTIMISTIC_LOCKING: yes PRE_DATA_ACCESS: yes	Modifies an IssueResolutionApprovalCheck record.
cancel	nsmodify	OPTIMISTIC_LOCKING: yes PRE_DATA_ACCESS: yes	Sets the status of the Issue Resolution Approval Check record to 'Canceled'.
validateInsert			Validates the Issue Resolution Approval Check details being inserted.
validateModify			Validates the Issue Resolution Approval Check details being modified.
validate			Validates the common Issue Resolution Approval Check details.
validateCancel			Validates the details of the record being canceled.
countIssueCheck	ns		Checks if an approval check already exists for an issue.	SQL
readRecordStatus	nsread		Reads the status of the Issue Resolution Approval Check record.
searchByIssue	nsmulti		This method lists all existing approval checks for a particular issue.	SQL
searchByUser	nsmulti		This method lists all existing approval checks for a user.	SQL
countUserCheck	ns		Counts duplicate resolution approval check records for a user.	SQL
countUserCheckAllIssues	ns		Counts duplicate resolution approval check records for a user with no issue specified.	SQL
countOrgUnitCheck	ns		Counts duplicate issue resolution approval check records for an organization unit.	SQL
countOrgUnitCheckAllIssues	ns		Counts duplicate issue resolution approval check records for an organization unit with no issue specified.	SQL
countIssueCheckModify	ns		Checks if an approval check already exists for an issue.	SQL
searchByOrgUnit	nsmulti		This method lists all existing approval checks for an org unit.	SQL
countUserCheckModify	ns		Counts duplicate resolution approval check records for a user.	SQL
countUserCheckModifyAllIssues	ns		Counts duplicate resolution approval check records for a user with no issue specified.	SQL
countOrgUnitCheckModify	ns		Counts duplicate issue resolution approval check records for an organization unit.	SQL
countOrgUnitCheckModifyAllIssues	ns		Counts duplicate issue resolution approval check records for an organization unit with no issue specified.	SQL
readByUserTypeCodeIssueAndStatus	ns		This method returns the maximum percentage and record count of active approval checks configured for a user and a particular issue.	SQL
readByUserTypeCodeAndStatus	ns		This method returns the maximum percentage and record count of active approval checks configured for a user and any issue.	SQL
readByOrgUnitTypeCodeIssueAndStatus	ns		This method returns the maximum percentage and record count of active approval checks configured for an organization unit and a particular issue.	SQL
readByOrgUnitTypeCodeAndStatus	ns		This method returns the maximum percentage and record count of active approval checks configured for an organization unit and any issue.	SQL
readByTypeCodeIssueAndStatus	ns		This method returns the maximum percentage and record count of active approval checks configured for an issue.	SQL
searchByOrganisationUnitID	readmulti		Reads all the records for an organisation unit.
insertIssueApprovalCheck	insert		Inserts record to issue resolution approval check entity. This method expects issue resolution approval check ID to be set by the caller, if not set it delegates the call to insert() which is modeled to auto generate primary key field (issue resolution approval check ID). It's preferred to call this method only in scenario's where caller wants to set the value of primary key (issue resolution approval check ID) by itself.
remove	remove		Removes a record from issue approval check entity.
searchByUserName	readmulti		Reads all the records for a user.
searchByIssueAndVersionNo	nsmulti		This method lists all existing approval checks for a particular issue.	SQL
modifyIssueApprovalCheck	modify	OPTIMISTIC_LOCKING: yes	This modify operation will be called while re-applying a change set in the target system. Entity level validations that will happen during a standard modify operation will not be applicable in this case. This modify operation will update all the attributes defined for this entity.
searchByOrgUnitAndVersionNo	nsmulti		This method lists all existing approval checks for an org unit.	SQL
searchByUserAndVersionNo	nsmulti		This method lists all existing approval checks for a user.	SQL

Related Pages (21)

Submit Resolution For Approval (Appeal_submitResolutionForApproval)
Submit Resolution for Approval (IssueDelivery_submitResolutionForApproval)
Delete Issue Resolution Approval Check (Organization_cancelResolutionApprovalCheckForOrgUnit)
Delete Issue Resolution Approval Check (Organization_cancelResolutionApprovalCheckForUser)
New Issue Case Resolution Approval Check (Organization_createResolutionApprovalCheckForOrgUnit)
New Issue Resolution Approval Check (Organization_createResolutionApprovalCheckForUser)
Issue Case Resolution (Organization_listResolutionApprovalChecksForOrgUnit)
Issue Resolution (Organization_listResolutionApprovalChecksForUser)
Edit Issue Case Resolution Approval Check (Organization_modifyResolutionApprovalCheckForOrgUnitFromList)
Edit Issue Case Resolution Approval Check (Organization_modifyResolutionApprovalCheckForOrgUnitFromView)
Edit Issue Resolution Approval Check (Organization_modifyResolutionApprovalCheckForUserFromList)
Edit Issue Resolution Approval Check (Organization_modifyResolutionApprovalCheckForUserFromView)
View Issue Resolution Approval Check for Organization Unit (Organization_viewResolutionApprovalCheckForOrgUnit)
View Issue Resolution Approval Check for User (Organization_viewResolutionApprovalCheckForUser)
Delete Resolution Approval Check (Product_cancelResolutionApprovalCheckForIssue)
New Resolution Approval Check (Product_createResolutionApprovalCheckForIssue)
Resolution Approval Checks (Product_listResolutionApprovalChecksForIssue)
Resolution Approval Checks (Product_listResolutionApprovalChecksForIssue1)
Edit Resolution Approval Check (Product_modifyResolutionApprovalCheckForIssueFromList)
Edit Resolution Approval Check (Product_modifyResolutionApprovalCheckForIssueFromView)
View Resolution Approval Check For Issue (Product_viewResolutionApprovalCheckForIssue)

Database Table: IssueResolutionApprovalCheck