D:EvidenceApprovalCheck

Table Description

Evidence Approval Check: An instance of the evidence approval rules for a product.

Evidence approval checks specify the percentage of case evidence, that must be manually approved.

Evidence approval checks can be specified at the User, Organization Unit and Product levels.

Example

An evidence approval check value is set at sixty percent for a user Ronan Rooney, then sixty percent of evidence recorded by this user must be manually approved. The remaining forty percent of evidence 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::EvidenceApprovalCheck::entity::EvidenceApprovalCheck::EvidenceApprovalCheck
Controlling File:	core\model\Packages\Reference Model\Service Layer\EvidenceApprovalCheck\Entity\EvidenceApprovalCheck\EvidenceApprovalCheck_cat.efx

Table Options

ALLOW_OPTIMISTIC_LOCKING

yes

Attributes (8)

Attribute	Stereotype	Nullable	Description	Domain Definition	Codetable	DDL Type
evidenceApprovalCheckID	key	no	Unique internal reference number of the evidence approval check.	EVIDENCE_APPROVAL_CHECK_ID		SVR_INT64
percentage	details		Percentage of evidence approval to send for manual approval.	EVIDENCE_APPROVAL_CHECK_RATE		SVR_INT16
productID	details	yes	Product id of the product for which the evidence approval check has been created.	PRODUCT_ID		SVR_INT64
organisationUnitID	details	yes	Organization unit id of the organization unit for which the evidence approval check has been created.	ORGANISATION_UNIT_ID		SVR_INT64
userName	details	yes	User name of the user for which the evidence approval check has been created.	USER_NAME		SVR_STRING<64>
typeCode	details		Type code for the evidence approval check, user evidence approval check, organization unit evidence approval check etc.	EVIDENCE_APPROVAL_CHECK_CODE	EvidenceApprovalCheck	SVR_STRING<10>
recordStatus	details		Record status of evidence approval check record.	RECORD_STATUS_CODE	RecordStatus	SVR_STRING<10>
comments	details		Comments for the evidence approval check.	COMMENTS		SVR_STRING<300>

Foreign Keys (3)

Child	Parent
EvidenceApprovalCheck.organisationUnitID	OrganisationUnit.organisationUnitID
EvidenceApprovalCheck.productID	Product.productID
EvidenceApprovalCheck.userName	Users.userName

Indices (2)

Index Name	Attributes
EvidAppChkIdx1	userName, productID, typeCode
EvidAppChkIdx2	organisationUnitID

Operations (49)

Operation	Stereotype	Options	Description	SQL
insert	insert	AUTO_ID: evidenceApprovalCheckID AUTO_ID_KEY: EVDNAPPCHK PRE_DATA_ACCESS: yes	COMMENTS=Inserts evidenceApprovalCheck record.
readDetailsAndProductName	ns		COMMENTS=Returns details of EvidenceApprovalCheck record.	SQL
modify	modify	OPTIMISTIC_LOCKING: yes PRE_DATA_ACCESS: yes	COMMENTS=Modifies details of an EvidenceApprovalCheck record. OPTIMISTIC_LOCKING=yes
searchByUser	nsmulti		COMMENTS=Returns details of EvidenceApprovalCheck records for a User.	SQL
searchByOrgUnit	nsmulti		COMMENTS=Retrieves details of all evidence approval checks for the specified organization unit.	SQL
searchByProduct	nsmulti		COMMENTS=Retrieves details of all evidence approval checks for the specified product. This will not include user-product approval types.	SQL
searchByStatusTypeUserName	ns		COMMENTS=@superseded - replaced by readByStatusTypeUserName	SQL
searchByStatusTypeOrgUnitID	ns		COMMENTS=@superseded - replaced by searchByStatusTypeOrgUnitID	SQL
searchByStatusTypeProductID	ns		COMMENTS=@superseded - replaced by readByStatusTypeProductID	SQL
searchByStatusTypeUserProductID	ns		COMMENTS=@superseded - replaced by readByStatusTypeUserProductID	SQL
searchByStatusTypeOrgUnitProductID	ns		COMMENTS=@superseded - replaced by readByStatusTypeOrgUnitProductID	SQL
validate			Validates Evidence Approval Check details
validateInsert			Validates Insert Evidence Approval Check details
validateModify			Validates Modify Evidence Approval Check details
readEvidenceApprovalCheckStatus	nsread		COMMENTS=Read status details for an evidenceApprovalCheck record.
cancel	nsmodify	OPTIMISTIC_LOCKING: yes PRE_DATA_ACCESS: yes	PRE_DATA_ACCESS=yes OPTIMISTIC_LOCKING=yes COMMENTS=Updates evidence approval record to canceled.
validateCancel			Validates Cancel Evidence Approval Check details
countOrgUnitCheck	ns	PRE_DATA_ACCESS: no	COMMENTS=Checks for duplicate organization unit evidence approval checks on insert.	SQL
countProductCheck	ns		COMMENTS=Checks for duplicate product evidence approval checks on insert.	SQL
countUserCheck	ns	PRE_DATA_ACCESS: no	COMMENTS=Checks for duplicate user evidence approval checks on insert.	SQL
countOrgUnitCheckModify	ns		COMMENTS=Checks for duplicate organization unit evidence approval checks on modify.	SQL
countProductCheckModify	ns		COMMENTS=Checks for duplicate product evidence approval checks on modify.	SQL
countUserCheckModify	ns		COMMENTS=Checks for duplicate product evidence approval checks on modify.	SQL
countOrgUnitCheckAllProducts	ns		Reads duplicate evidence approval checks where no product id is specified.	SQL
countUserCheckAllProducts	ns		Reads duplicate evidence approval check records for a user where no product is specified.	SQL
countUserCheckModifyAllProducts	ns		Reads duplicate evidence approval checks for a user where no product is specified.	SQL
countOrgUnitCheckModifyAllProducts	ns		Reads duplicate evidence approval check records for a user where no product is specified.	SQL
readByStatusTypeUserName	ns		Returns the maximum percentage for the specified status, type and user name.	SQL
readByStatusTypeOrgUnitID	ns		Returns the maximum percentage for the specified status, type and organization unit identifier.	SQL
readByStatusTypeProductID	ns		Returns the maximum percentage for the specified status, type and product identifier.	SQL
readByStatusTypeUserProductID	ns		Returns the maximum percentage for the specified status, type, user name and product identifier.	SQL
readByStatusTypeOrgUnitProductID	ns		Returns the maximum percentage for the specified status, type, organization unit identifier and product identifier.	SQL
searchOrgUnitCheck			@superseded - replaced by countOrgUnitCheck
searchOrgUnitCheckAllProducts			@superseded - replaced by countOrgUnitCheckAllProducts
searchOrgUnitCheckModify			@superseded - replaced by countOrgUnitCheckModify
searchOrgUnitCheckModifyAllProducts			@superseded - replaced by countOrgUnitCheckModifyAllProducts
searchProductCheck			@superseded - replaced by countProductCheck
searchProductCheckModify			@superseded - replaced by countProductCheckModify
searchUserCheck			@superseded - replaced by countUserCheck
searchUserCheckAllProducts			@superseded - replaced by countUserCheckAllProducts
searchUserCheckModify			@superseded - replaced by countUserCheckModify
searchUserCheckModifyAllProducts			@superseded - replaced by countUserCheckModifyAllProducts
read			@superseded - replaced by readDetailsAndProductName
searchByProductID	readmulti		Return a list of evidence approval check records by product ID.
remove	remove		Removes a record from evidence approval check.
searchByUserName	readmulti		<p> Reads all the records for a user. </p>
insertEvidenceApprovalCheck	insert	PRE_DATA_ACCESS: no	<p class="MsoNormal"> <span style="COLOR: #002060">Inserts evidence approval check record. This method expects the <font color="#000000">evidenceApprovalCheckID</font> to be set. It is preferred to call insertEvidenceApprovalCheck method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p>
searchByOrganisationUnitID	readmulti		Retrieves details of all evidence approval checks for the specified organization unit. This will not include product name and applies to all products indicator.
modifyEvidenceApprovalCheck	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 (25)

Capture Head of Household Details: (IncomeScreening_createCase)
Delete Evidence Approval Check (Organization_cancelOrgUnitEvidenceApproval)
Delete Evidence Approval Check (Organization_cancelUserEvidenceApproval)
New Evidence Approval Check (Organization_createOrgUnitEvidenceApproval)
New Evidence Approval Check (Organization_createUserEvidenceApproval)
Evidence Approvals (Organization_listOrgUnitEvidenceApproval)
Evidence Approval Checks (Organization_listUserEvidenceApproval)
Edit Evidence Approval Check (Organization_modifyOrgUnitEvidenceApprovalFromList)
Edit Evidence Approval Check (Organization_modifyOrgUnitEvidenceApprovalFromView)
Edit Evidence Approval Check (Organization_modifyUserEvidenceApprovalFromList)
Edit Evidence Approval Check (Organization_modifyUserEvidenceApprovalFromView)
Evidence Approval Check Home (Organization_viewOrgUnitEvidenceApproval)
View Evidence Approval Check Details (Organization_viewUserEvidenceApproval)
Cancel Evidence Approval Check (Product_cancelEvidenceApproval)
New Evidence Approval Check (Product_createEvidenceApproval)
Evidence Approval Check (Product_listBenefitEvidenceApproval)
Evidence Approval Check (Product_listLiabilityEvidenceApproval)
Edit Evidence Approval Check (Product_modifyEvidenceApprovalFromList)
Edit Evidence Approval Check (Product_modifyEvidenceApprovalFromView)
View Evidence Approval Check (Product_viewEvidenceApproval)
Delete Evidence Approval Check (Supervisor_cancelUserEvidenceApproval)
New Evidence Approval Check (Supervisor_createUserEvidenceApproval)
Edit Evidence Approval Check (Supervisor_modifyUserEvidenceApprovalFromList)
Edit Evidence Approval Check (Supervisor_modifyUserEvidenceApprovalFromView)
View Evidence Approval Check Details (Supervisor_viewUserEvidenceApproval)

Database Table: EvidenceApprovalCheck