Table Description
Approval Check: Approval rules for any type of artifact.

This is a generic approval check entity which can be used to define approval checks for any type of artifact in Curam, e.g. an assessment, a product. An approval check can be specified for a user, an organization unit and/or the artifact itself. Approval checks define the percentage of a specified artifact that must be manually approved by a supervisor.

Example

The following assessment approval check can be created: 10% of Caregiver Strength and Needs assessments submitted for approval require manual approval by the supervisor of the user that submitted the assessment. The remaining 90% of Caregiver Strength and Needs assessments 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::ApprovalCheck::Entity::ApprovalCheck
Controlling File: core\model\Packages\Reference Model\Service Layer\ApprovalCheck\Entity\ApprovalCheck_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
approvalCheckIDkeynoUnique identifier for Approval Check.INTERNAL_ID SVR_INT64
relatedIDdetailsyesUnique identifier for the related artefact, for example the id of an Assessment, or a Product.INTERNAL_ID SVR_INT64
relatedTypedetailsnoThe type of the related artefact, for example Assessment or Product.APPROVAL_CHECK_RELATED_TYPEApprovalRelatedTypeSVR_STRING<10>
typeCodedetailsnoThe type of this Approval Check. The Approval Check may be a User Approval Check, an Organization Unit Approval Check, or a Related Type Approval Check.APPROVAL_CHECK_TYPE_CODEApprovalCheckTypeSVR_STRING<10>
percentagedetailsyesSignifies what percent of related artefacts this approval check should be applied to.APPROVAL_CHECK_PERCENTAGE SVR_INT16
costdetailsyesSignifies a threshold of cost, above which this approval check should be applied.APPROVAL_CHECK_COST SVR_MONEY
recordStatusdetailsnoStatus of the Approval Check.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
commentsdetailsyesComments for this Approval Check.COMMENTS SVR_STRING<300>
usernamedetailsyesSignifies the user this Approval Check is related to. Only applicable where the type is 'User'.USER_NAME SVR_STRING<64>
organisationUnitIDdetailsyesSignifies the organisationUnit this Approval Check is related to. Only applicable where the type is 'OrganisationUnit'.ORGANISATION_UNIT_ID SVR_INT64
Foreign Keys (2)
ChildParent
ApprovalCheck.organisationUnitIDOrganisationUnit.organisationUnitID
ApprovalCheck.usernameUsers.userName
Indices (4)
Index NameAttributes
userTypeStatusIdxrecordStatus, username, typeCode, relatedType
relTypeStatusIdxrelatedID, relatedType, recordStatus, typeCode
orgUnitTypeStatusIdxtypeCode, organisationUnitID, recordStatus, relatedType
relTypeUserNameTypeCodeIdxrelatedType, typeCode, username
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: approvalCheckID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByUsernameTypeRelatedTypeAndStatusreadmulti Returns a list of Approval Checks for the given username, type, relatedType, and status. This operation would typically be used to search records of type 'User'. 
searchByTypeRelatedIDRelatedTypeAndStatusreadmulti Returns a list of Approval Checks for the given type, relatedID, relatedType and status. This operation would typically be used to search records of type 'RelatedType'. 
searchByOrganisationUnitIDTypeRelatedTypeAndStatusreadmulti Returns a list of Approval Checks for the given organisationUnitID, type, relatedType, and status. This operation would typically be used to search records of type 'OrganisationUnit'. 
cancelnsmodifyOPTIMISTIC_LOCKING: yes
Sets the status of the Approval Check record to 'Canceled'. 
searchByRelatedTypeUsernameAndTypeCodereadmulti   
Related Pages (88)
AssessmentDefinition_details
New Factor (AssessmentDefinitionFactorAdmin_createAssessmentDefinitionFactor)
Assessment Results (AssessmentDelivery_listAssessmentResults)
New Factor (AssessmentPlanningAdmin_addAssessmentDefinitionFactorFromList)
Delete Assessment Definition (AssessmentPlanningAdmin_cancelAssessmentDefinition)
Create Assessment Approval Check: (AssessmentPlanningAdmin_createAssessmentApprovalCheck)
New Assessment Definition (AssessmentPlanningAdmin_createAssessmentDefinition)
Edit Assessment Definition (AssessmentPlanningAdmin_editAssessmentDefinitionFromList)
Edit Assessment Definition (AssessmentPlanningAdmin_editAssessmentDefinitionFromView)
Assessment Approval Checks: (AssessmentPlanningAdmin_listApprovalChecks)
Modify Assessment Approval Check: (AssessmentPlanningAdmin_modifyAssessmentApprovalCheckFromList)
Modify Assessment Approval Check: (AssessmentPlanningAdmin_modifyAssessmentApprovalCheckFromView)
Assessment Approval Check: (AssessmentPlanningAdmin_viewAssessmentApprovalCheck)
Home (AssessmentPlanningAdmin_viewAssessmentDefinition)
Create Assessment Approval Check: (Organization_createAssessmentApprovalCheckForOrgUnit)
Create Assessment Approval Check: (Organization_createAssessmentApprovalCheckForUser)
Create Outcome Plan Agreement Approval Check (Organization_createOutcomePlanApprovalCheckForOrgUnit)
Create Outcome Plan Agreement Approval Check (Organization_createOutcomePlanApprovalCheckForUser)
Assessment Approval Checks: (Organization_listAssessmentApprovalChecksForOrgUnit)
Assessment Approval Checks (Organization_listAssessmentApprovalChecksForUser)
Outcome Plan Agreement Approval Checks (Organization_listOutcomePlanApprovalChecksForOrgUnit)
Outcome Plan Agreement Approval Checks (Organization_listOutcomePlanApprovalChecksForUser)
Edit Assessment Approval Check (Organization_modifyOrgUnitAssessmentApprovalFromList)
Edit Assessment Approval Check (Organization_modifyOrgUnitAssessmentApprovalFromView)
Modify Approval Check (Organization_modifyOutcomePlanApproval)
Edit Assessment Approval Check (Organization_modifyUserAssessmentApprovalFromList)
Edit Assessment Approval Check (Organization_modifyUserAssessmentApprovalFromView)
Organization_viewInlineUserAssessmentApproval
Assessment Approval Check: (Organization_viewOrgUnitAssessmentApproval)
Organization_viewOutcomePlanApproval
Assessment Approval Check: (Organization_viewUserAssessmentApproval)
New Outcome Plan (OutcomePlanAdmin_createOutcomePlanAdmin)
Edit Outcome Plan (OutcomePlanAdmin_editOutcomePlanAdminFromList)
Edit Outcome Plan (OutcomePlanAdmin_editOutcomePlanAdminFromView)
OutcomePlanAdmin_listOutcomePlanAdmin
Home (OutcomePlanAdmin_viewOutcomePlanAdmin)
Complete Agreement (OutcomePlanAgreement_complete)
New Provider Service Approval Check (ProviderManagement_createPOApprovalCheckForOrganizationUnit)
New Provider Service Approval Check (ProviderManagement_createPOApprovalCheckForUser)
New Approval Check (ProviderManagement_createProviderApprovalCheck)
New Provider Approval Check (ProviderManagement_createProviderApprovalCheckForOrganizationUnit)
New Provider Approval Check (ProviderManagement_createProviderApprovalCheckForUser)
New Approval Check (ProviderManagement_createProviderOfferingApprovalCheck)
New Approval Check (ProviderManagement_createServiceOfferingApprovalCheck)
New Service Approval Check (ProviderManagement_createServiceOfferingApprovalCheckForOrganizationUnit)
New Service Approval Check (ProviderManagement_createServiceOfferingApprovalCheckForUser)
Delete Approval Check (ProviderManagement_deleteProviderOfferingApprovalCheck)
Provider Service (ProviderManagement_listPOApprovalChecksForOrganizationUnit)
Provider Service (ProviderManagement_listPOApprovalChecksForUser)
Service Delivery Approval Checks: (ProviderManagement_listProviderApprovalChecks)
Provider (ProviderManagement_listProviderApprovalChecksForOrganizationUnit)
Provider (ProviderManagement_listProviderApprovalChecksForUser)
Service (ProviderManagement_listServiceOfferingApprovalChecksForOrganizationUnit)
Service (ProviderManagement_listServiceOfferingApprovalChecksForUser)
Edit Provider Service Approval Check (ProviderManagement_modifyPOApprovalCheckForOrganizationUnit)
Edit Provider Service Approval Check (ProviderManagement_modifyPOApprovalCheckForUser)
Edit Approval Check (ProviderManagement_modifyProviderApprovalCheck)
Edit Provider Approval Check (ProviderManagement_modifyProviderApprovalCheckForOrganizationUnit)
Edit Provider Approval Check (ProviderManagement_modifyProviderApprovalCheckForUser)
Edit Approval Check (ProviderManagement_modifyProviderOfferingApprovalCheck)
Edit Approval Check (ProviderManagement_modifyServiceOfferingApprovalCheck)
Edit Service Approval Check (ProviderManagement_modifyServiceOfferingApprovalCheckForOrganizationUnit)
Edit Service Approval Check (ProviderManagement_modifyServiceOfferingApprovalCheckForUser)
Home (ProviderManagement_providerHome)
Home (ProviderManagement_providerHomeForFacilityManager)
Retrieve approval check: (ProviderManagement_sampleRetrieveApprovalCheckInformation)
New Provider Service Approval Check (ProviderManagement_selectProviderForPOApprovalCheck)
New Provider Service Approval Check (ProviderManagement_selectProviderForPOApprovalCheckForUser)
View Provider Service Approval Check: (ProviderManagement_viewPOApprovalCheckForOrganizationUnit)
View Provider Service Approval Check: (ProviderManagement_viewPOApprovalCheckForUser)
View Approval Check (ProviderManagement_viewProviderApprovalCheck)
View Provider Approval Check: (ProviderManagement_viewProviderApprovalCheckForOrganizationUnit)
View Provider Approval Check: (ProviderManagement_viewProviderApprovalCheckForUser)
View Provider Service Approval Check for Service Delivery (ProviderManagement_viewProviderOfferingApprovalCheck)
View Provider Service: (ProviderManagement_viewProviderServiceOffering)
ProviderManagement_viewProviderServiceOfferingForFacilityManager
View Approval Check: (ProviderManagement_viewServiceOfferingApprovalCheck)
View Service Approval Check: (ProviderManagement_viewServiceOfferingApprovalCheckForOrganizationUnit)
View Service Approval Check: (ProviderManagement_viewServiceOfferingApprovalCheckForUser)
Home (ProviderManagement_viewServiceOfferingFrmList)
Home (ProviderManagement_viewServiceOfferingFrmServiceGroup)
Home (ProviderManagement_viewServiceOfferingFromSearch)
Home (ProviderManagement_viewTrainingServiceOfferingFrmList)
Screening Approval Check (Screening_createScreeningCaseApprovalCheckForUser)
Delete Case Approval Check (Screening_deleteScreeningCaseApprovalCheckForUser)
Screening (Screening_listScreeningCaseApprovalCheckForUser)
Edit Screening Approval Check (Screening_modifyScreeningCaseApprovalCheckForUser)
View Case Approval Check Details (Screening_viewScreeningCaseApprovalCheckForUser)