D:InvestigationApprovalCheck

Table Description

Investigation Approval Check: The approval rules for an investigation.

Approval checks functionality is available for a user, organization unit and an issue resolution.

Example

The following investigation resolution approval check can be created:

10% of benefit fraud investigations whose resolutions are submitted for approval require manual approval by the supervisor of the user who submitted the issue resolution for approval.

The remaining 90% of issue resolutions will be automatically approved by the system.

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::Core::Reference Model::Service Layer::InvestigationResolutionApprovalCheck::Entity::InvestigationApprovalCheck
Controlling File:	core\model\Packages\Reference Model\Service Layer\InvestigationResolutionApprovalCheck\Entity\Entity_cat.efx

Table Options

ALLOW_OPTIMISTIC_LOCKING

yes

Attributes (8)

Attribute	Stereotype	Nullable	Description	Domain Definition	Codetable	DDL Type
investigationApprovalCheckID	key	no	Unique reference number assigned by the system to the investigation approval check record.	INTERNAL_ID		SVR_INT64
investigationConfigID	details	yes	The unique internal reference number assigned to the investigation config to which the approval checks apply.	INVESTIGATION_CONFIG_ID		SVR_INT64
percentage	details		The percentage of investigations which require manual approval.	INVESTIGATION_APPROVAL_CHECK_RATE		SVR_INT16
typeCode	details		The type of the approval check.	INVESTIGATION_APPROVAL_CHECK_TYPE_CODE	InvestigApprovalCheck	SVR_STRING<10>
organisationUnitID	details	yes	Unique reference number of the organization unit for which the approval check has been created.	ORGANISATION_UNIT_ID		SVR_INT64
userName	details	yes	Unique reference of the user for which the approval check has been created.	USER_NAME		SVR_STRING<64>
comments	details		Comments recorded by an administrator relating to the approval check.	COMMENTS		SVR_STRING<300>
recordStatus	details		Status of the investigation approval check record. The values are 'Active' or 'Canceled'. Logical deletion is supported.	RECORD_STATUS_CODE	RecordStatus	SVR_STRING<10>

Foreign Keys (3)

Child	Parent
InvestigationApprovalCheck.investigationConfigID	InvestigationConfig.investigationConfigID
InvestigationApprovalCheck.organisationUnitID	OrganisationUnit.organisationUnitID
InvestigationApprovalCheck.userName	Users.userName

Indices (2)

Index Name	Attributes
OrgUnitIDInvestigationIdx	organisationUnitID, investigationConfigID, typeCode, recordStatus
IND__628409102	userName

Operations (35)

Operation	Stereotype	Options	Description	SQL
insert	insert	AUTO_ID: investigationApprovalCheckID AUTO_ID_KEY: INVNAPPCHK PRE_DATA_ACCESS: yes	Inserts an InvestigationApprovalCheck record.
read	read		Reads an InvestigationResolutionApprovalCheck record.
modify	modify	OPTIMISTIC_LOCKING: yes PRE_DATA_ACCESS: yes	Modifies an InvestigationResolutionApprovalCheck record.
cancel	nsmodify	OPTIMISTIC_LOCKING: yes PRE_DATA_ACCESS: yes	Sets the status of the Investigation Resolution Approval Check record to 'Canceled'.
validateInsert			Validates the Investigation Resolution Approval Check details being inserted.
validateModify			Validates the Investigation Resolution Approval Check details being modified.
validate			Validates the common Investigation Resolution Approval Check details.
validateCancel			Validates the details of the record being canceled.
countInvestigationCheck	ns		Checks if an approval check already exists for an investigation.	SQL
readRecordStatus	nsread		Reads the status of the Investigation Resolution Approval Check record.
searchByInvestigation	nsmulti		This method lists all existing approval checks for a particular investigation.	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
countUserCheckAllInvestigations	ns		Counts duplicate resolution approval check records for a user with no investigation specified.	SQL
countOrgUnitCheck	ns		Counts duplicate investigation resolution approval check records for an organization unit.	SQL
countOrgUnitCheckAllInvestigations	ns		Counts duplicate investigation resolution approval check records for an organization unit with no issue specified.	SQL
countInvestigationCheckModify	ns		Checks if an approval check already exists for an investigation.	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
countUserCheckModifyAllInvestigations	ns		Counts duplicate resolution approval check records for a user with no investigation specified.	SQL
countOrgUnitCheckModify	ns		Counts duplicate investigation resolution approval check records for an organization unit.	SQL
countOrgUnitCheckModifyAllInvestigations	ns		Counts duplicate investigation resolution approval check records for an organization unit with no investigation specified.	SQL
readByUserTypeCodeInvestigationAndStatus	ns		This method returns the maximum percentage and record count of active approval checks configured for a user and a particular investigation.	SQL
readByUserTypeCodeAndStatus	ns		This method returns the maximum percentage and record count of active approval checks configured for a user and any investigation.	SQL
readByOrgUnitTypeCodeInvestigationAndStatus	ns		This method returns the maximum percentage and record count of active approval checks configured for an organization unit and a particular investigation.	SQL
readByOrgUnitTypeCodeAndStatus	ns		This method returns the maximum percentage and record count of active approval checks configured for an organization unit and any investigation.	SQL
readByTypeCodeInvestigationAndStatus	ns		This method returns the maximum percentage and record count of active approval checks configured for an investigation.	SQL
readForOrgUnitAndInvestigation	ns			SQL
readForOrgUnit	ns			SQL
searchByOrganisationUnitID	readmulti		Reads all the records for an organisation unit id.
insertInvestigationApprovalCheck	insert	PRE_DATA_ACCESS: no	Inserts record to investigation approval check entity. This method expects investigation 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 (investigation approval check ID). It's preferred to call this method only in scenario's where caller wants to set the value of primary key (investigation approval check ID) by itself.
remove	remove		Removes a record from investigation approval check entity.
searchByUserName	readmulti		Reads all the records for a user.
searchByInvestigationAndVersionNo	nsmulti		This method lists all existing approval checks for a particular investigation.	SQL
modifyInvestigationApprovalCheck	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.

Related Pages (20)

Submit For Approval (InvestigationDelivery_submit)
Delete Investigation Approval Check (Organization_cancelInvestigationApprovalCheckForOrgUnit)
Delete Investigation Approval Check (Organization_cancelInvestigationApprovalCheckForUser)
New Investigation Approval Check (Organization_createInvestigationApprovalCheckForOrgUnit)
New Investigation Approval Check (Organization_createInvestigationApprovalCheckForUser)
Investigation (Organization_listInvestigationApprovalChecksForOrgUnit)
Investigation (Organization_listInvestigationApprovalChecksForUser)
Edit Investigation Approval Check (Organization_modifyInvestigationApprovalCheckForOrgUnitFromList)
Edit Investigation Approval Check (Organization_modifyInvestigationApprovalCheckForOrgUnitFromView)
Edit Investigation Approval Check (Organization_modifyInvestigationApprovalCheckForUserFromList)
Edit Investigation Approval Check (Organization_modifyInvestigationApprovalCheckForUserFromView)
View Investigation Approval Check for Organization Unit (Organization_viewInvestigationApprovalCheckForOrgUnit)
View Investigation Approval Check for User (Organization_viewInvestigationApprovalCheckForUser)
Delete Approval Check For Investigation (Product_cancelApprovalCheckForInvestigation)
New Approval Check (Product_createApprovalCheckForInvestigation)
Approval Checks (Product_listApprovalChecksForInvestigation)
Approval Checks (Product_listApprovalChecksForInvestigation1)
Edit Approval Check (Product_modifyApprovalCheckForInvestigationFromList)
Edit Approval Check (Product_modifyApprovalCheckForInvestigationFromView)
View Approval Check For Investigation (Product_viewApprovalCheckForInvestigation)

Database Table: InvestigationApprovalCheck