Table Description
Temporal Evidence Approval Check: Maintains configuration details for approval check functionality associated with evidence maintained using the temporal evidence solution.

Temporal Evidence Approval Checks specifies the percentage of evidence that must be manually approved, for evidence which is maintained using the temporal evidence solution. Temporal Evidence Approval Checks can be specified at the User, Organization Unit, Position and Evidence Type level.

Example

A job of junior case worker exists within an organization. An organization dealing with income support cases holds one such position of this job type. The organization decides that due to the inexperienced level of any user holding this position, a large number of evidence changes worked on by such users should be routed for manual approval and therefore the organization configure evidence approval checks at 75% for this position. During evidence maintenance, for any user holding this position, 75% of the evidence changes they submit will be routed to the case supervisor for manual approval. The remaining 25% of evidence changes will be automatically approved.

Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Service Layer::Infrastructure::Temporal Evidence::Entity::Evidence Approval Check::TemporalEvidenceApprovalCheck
Controlling File: core\model\Packages\Reference Model\Service Layer\Temporal Evidence\Entity\EvidenceApprovalCheck\EvidenceApprovalCheck_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
temporalEvApprovalCheckIDkeynoUnique identifier of the temporal evidence approval check record.INTERNAL_ID SVR_INT64
organisationUnitIDdetails Identifier of the organization unit to which the evidence approval check percentage applies. This is only relevant for evidence approval checks configured for an organization unit.ORGANISATION_UNIT_ID SVR_INT64
userNamedetails Username of the user to whom the evidence approval check percentage applies. This is only relevant for evidence approval checks configured for a user.USER_NAME SVR_STRING<64>
positionIDdetails Identifier of the position to which the evidence approval check percentage applies. This is only relevant for evidence approval checks set up for a position.POSITION_ID SVR_INT64
evidenceTypedetailsyesType of evidence to which the evidence approval check percentage applies.TEMPORAL_EVIDENCE_TYPE_APPROVALTemporalEvTypeApprovalSVR_STRING<10>
approvalTypedetailsnoType of evidence approval check, i.e., organization, position, user, and/or evidence type.TEMPORAL_EVIDENCE_APPROVAL_CHECK_CODETemporalEvApprovalCheckSVR_STRING<10>
percentagedetailsnoThe percentage of evidence changes for which manual approval.EVIDENCE_APPROVAL_CHECK_RATE SVR_INT16
commentsdetails Extra notes or comments entered by a user.COMMENTS SVR_STRING<300>
recordStatusdetailsnoStatus of the temporal evidence approval check record. The values are 'Active' or 'Canceled'. Logical deletion is supported.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Indices (3)
Index NameAttributes
TEAprCkUsrNameIdxuserName
TEAprChkOrgUnIDIdxorganisationUnitID
TEAprChkPosIdxpositionID
Operations (24)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: temporalEvApprovalCheckID
AUTO_ID_KEY: TPEVDAPCHK
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
removensmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
  
searchByOrgUnitreadmultiWHERE: organisationUnitID = :organisationUnitID
  
searchByUserreadmultiWHERE: userName = :userName
  
searchByPositionreadmultiWHERE: positionID = :positionID
  
searchByEvidenceTypeOnlynsmulti  SQL
validate    
searchByProductApprovalTypeAndStatusnsmulti  SQL
countSharedByEvidenceTypens  SQL
searchEvidenceTypesForCreateByProductIDnsmulti  SQL
searchProductsSharingEvidencensmulti  SQL
searchEvidenceTypesByProductIDnsmulti  SQL
readByUserApprovalTypeAndEvidenceTypens  SQL
readByUserAndApprovalTypens  SQL
readByPositionApprovalTypeAndEvidenceTypens  SQL
readByPositionAndApprovalTypens  SQL
readByOrgUnitApprovalTypeAndEvidenceTypens  SQL
readByOrgUnitAndApprovalTypens  SQL
readByApprovalTypeAndEvidenceTypens  SQL
searchByEvidenceTypereadmulti Return&nbsp;a&nbsp;list&nbsp;of temporal evidence approval check records&nbsp;by&nbsp;evidence type. 
insertTemporalEvidenceApprovalCheckinsertPRE_DATA_ACCESS: no
<p class="MsoNormal"> <span style="COLOR: #002060">Inserts temporal evidence approval check record. This method expects the&nbsp;temporalEvApprovalCheckID to be set. It is preferred to call insertTemporalEvidenceApprovalCheck method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
modifyTemporalEvidenceApprovalCheckmodifyOPTIMISTIC_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 (155)
Delete Existing (AdvancedEvidenceSharing_removeExistingEvidence)
Transfer Application (Application_transferApplicationToExistingCase)
Edit Child Support Payments Evidence (EVD_incomingModifyAbParChildSupportEvidence)
Edit Absence Evidence (EVD_incomingModifyAbsenceEvidence)
Edit Absenteeism Evidence (EVD_incomingModifyAbsentParentCSEEvidence)
Edit Absent Parent Evidence (EVD_incomingModifyAbsentParentEvidence)
Edit Adoption Evidence (EVD_incomingModifyAdoptionEvidence)
Edit Adoption Payment Evidence (EVD_incomingModifyAdoptionPaymentEvidence)
Edit Alien Evidence (EVD_incomingModifyAlienEvidence)
Edit Alien Sponsor Evidence (EVD_incomingModifyAlienSponsorEvidence)
Edit Alien Sponsorship Evidence (EVD_incomingModifyAlienSponsorshipEvidence)
Edit Alimony Expense Evidence (EVD_incomingModifyAlimonyExpenseEvidence)
Edit Annuity Beneficiary Evidence (EVD_incomingModifyAnnuityBeneficiaryEvidence)
Edit Annuity Evidence (EVD_incomingModifyAnnuityEvidence)
Edit Annuity Income Evidence (EVD_incomingModifyAnnuityIncomeEvidence)
Edit Anticipated Income Evidence (EVD_incomingModifyAnticipatedIncomeEvidence)
Edit Assigned Income Evidence (EVD_incomingModifyAssignedIncomeEvidence)
Edit Authorized Representative Evidence (EVD_incomingModifyAuthorizedRepEvidence)
Edit Beneficiary Evidence (EVD_incomingModifyBeneficiaryEvidence)
Edit Benefit Evidence (EVD_incomingModifyBenefitEvidence)
Edit Boarder Evidence (EVD_incomingModifyBoarderEvidence)
Edit Burial Plan Evidence (EVD_incomingModifyBurialPlanEvidence)
Edit Burial Plot Evidence (EVD_incomingModifyBurialPlotEvidence)
Edit Business Asset Evidence (EVD_incomingModifyBusinessAssetEvidence)
Edit Child Immunization Evidence (EVD_incomingModifyChildImmuneEvidence)
Edit Child Support Enforcement Evidence (EVD_incomingModifyChildSupportEnforcementEvidence)
Edit Child Support Expense Evidence (EVD_incomingModifyChildSupportExpenseEvidence)
Edit Contributor Evidence (EVD_incomingModifyContributorEvidence)
Edit Cost Of Care Allowance Evidence (EVD_incomingModifyCostOfCareAllowanceEvidence)
Edit Countable Assistance History Evidence (EVD_incomingModifyCountableAssistanceHistoryEvidence)
Edit Court Order Expense Evidence (EVD_incomingModifyCourtOrderExpenseEvidence)
Edit Coverage Evidence (EVD_incomingModifyCoverageEvidence)
Edit Coverage Type Evidence (EVD_incomingModifyCoverageTypeDetailsEvidence)
Edit Criminal History Evidence (EVD_incomingModifyCriminalHistoryEvidence)
Edit Dependent Care Expense Evidence (EVD_incomingModifyDependentCareExpenseEvidence)
Edit Deprivation Evidence (EVD_incomingModifyDeprivationEvidence)
Edit Disability Evidence (EVD_incomingModifyDisabilityEvidence)
Edit Domestic Violence Evidence (EVD_incomingModifyDomesticViolenceEvidence)
Edit Earned Income Evidence (EVD_incomingModifyEarnedIncomeEvidence)
Edit Emergency Evidence (EVD_incomingModifyEmergencyEvidence)
Edit Employment Expense Evidence (EVD_incomingModifyEmploymentExpenseEvidence)
Edit Employment Offer Evidence (EVD_incomingModifyEmploymentOfferEvidence)
Edit Entitlement Evidence (EVD_incomingModifyEntitlementEvidence)
Edit Exemption Evidence (EVD_incomingModifyExemptionEvidence)
Edit Extension Evidence (EVD_incomingModifyExtensionEvidence)
Edit Foster Care Evidence (EVD_incomingModifyFosterCareEvidence)
Edit Foster Care Payment Evidence (EVD_incomingModifyFosterCarePaymentEvidence)
Edit General Insurance Evidence (EVD_incomingModifyGeneralInsuranceEvidence)
Edit Gross Receipt Evidence (EVD_incomingModifyGrossReceiptEvidence)
Edit Head of Household Evidence (EVD_incomingModifyHeadOfHouseholdEvidence)
Edit Household Meal Group Evidence (EVD_incomingModifyHholdMealsGroupEvidence)
Edit Household Member Evidence (EVD_incomingModifyHouseholdMemberEvidence)
Edit Household Relationship Evidence (EVD_incomingModifyHouseholdRelationshipEvidence)
Edit Income Reporting Evidence (EVD_incomingModifyIncomeReportingEvidence)
Edit Income Trust Schedule Evidence (EVD_incomingModifyIncomeTrustScheduleEvidence)
Edit Legal Guardian Expense Evidence (EVD_incomingModifyLegalGuardianEvidence)
Edit Level Of Care Evidence (EVD_incomingModifyLevelOfCareEvidence)
Edit Life Insurance Evidence (EVD_incomingModifyLifeInsuranceEvidence)
Edit Liquid Resources Evidence (EVD_incomingModifyLiquidResourcesEvidence)
Edit Living Arrangement Evidence (EVD_incomingModifyLivingArrangeEvidence)
Edit Living Expense Evidence (EVD_incomingModifyLivingExpenseEvidence)
Edit Loan Evidence (EVD_incomingModifyLoanEvidence)
Edit Household Meal Group Member Evidence (EVD_incomingModifyMealGroupMemberEvidence)
Edit Medical Expense Evidence (EVD_incomingModifyMedicalExpenseEvidence)
Edit Medical Expense Payment Evidence (EVD_incomingModifyMedicalExpensePaymentEvidence)
Edit Medical Institution Evidence (EVD_incomingModifyMedicalInstitutionEvidence)
Edit Medical Insurance Evidence (EVD_incomingModifyMedicalInsuranceEvidence)
Edit Medical Screening Evidence (EVD_incomingModifyMedicalScreeningEvidence)
Edit Medical Institution Temporary Absence Evidence (EVD_incomingModifyMedInstTemporaryAbsenceEvidence)
Edit Minor Parent Non Residency Evidence (EVD_incomingModifyMinorParNonResEvidence)
Edit Minor Parent School Attendance Evidence (EVD_incomingModifyMinorParSchlAttEvidence)
Edit Ownership Evidence (EVD_incomingModifyOwnershipEvidence)
Edit Paid Employment Evidence (EVD_incomingModifyPaidEmploymentEvidence)
Edit Pregnancy Evidence (EVD_incomingModifyPregnancyEvidence)
Edit Property Evidence (EVD_incomingModifyPropertyEvidence)
Edit Resource Income Evidence (EVD_incomingModifyResourceIncomeEvidence)
Edit Resource Transfer Evidence (EVD_incomingModifyResourceTransferEvidence)
Edit Self Employment Evidence (EVD_incomingModifySelfEmploymentEvidence)
Edit Shelter Expense Evidence (EVD_incomingModifyShelterExpenseEvidence)
Edit Social Relationship Evidence (EVD_incomingModifySocialRelationshipEvidence)
Edit Spousal Cooperation Evidence (EVD_incomingModifySpousalCooperationEvidence)
Edit Student Evidence (EVD_incomingModifyStudentEvidence)
Edit Student Expense Evidence (EVD_incomingModifyStudentExpenseEvidence)
Edit Third Party Liability Enforcement Evidence (EVD_incomingModifyTPLEnforcementEvidence)
Edit Trade Dispute Evidence (EVD_incomingModifyTradeDisputeEvidence)
Edit Transfer Reversal Evidence (EVD_incomingModifyTransferReversalEvidence)
Edit Transfer To Individual Evidence (EVD_incomingModifyTransferToIndividualEvidence)
Edit Transfer To Trust Evidence (EVD_incomingModifyTransferToTrustEvidence)
Edit Trustee Evidence (EVD_incomingModifyTrusteeEvidence)
Edit Trust Evidence (EVD_incomingModifyTrustEvidence)
Edit Trust Income Evidence (EVD_incomingModifyTrustIncomeEvidence)
Edit Unborn Child Evidence (EVD_incomingModifyUnbornChildEvidence)
Edit Unearned Income Evidence (EVD_incomingModifyUnearnedIncomeEvidence)
Edit Unearned Rental Income Expense Evidence (EVD_incomingModifyUnearnedRentalIncomeExpenseEvidence)
Edit Unpaid Employment Evidence (EVD_incomingModifyUnpaidEmploymentEvidence)
Edit Utility Expense Evidence (EVD_incomingModifyUtilityExpenseEvidence)
Edit Vehicle Evidence (EVD_incomingModifyVehicleEvidence)
Edit Veteran Military Service Evidence (EVD_incomingModifyVetMilitaryServEvidence)
Edit Voluntary Quit Evidence (EVD_incomingModifyVoluntaryQuitEvidence)
Edit Work Non-Participation Evidence (EVD_incomingModifyWorkNonParticipationEvidence)
Edit Work Registration Evidence (EVD_incomingModifyWorkRegistrationEvidence)
Edit Work Requirements Evidence (EVD_incomingModifyWorkRequirementsEvidence)
Delete Evidence (Evidence_deleteInEdit)
Discard Evidence (Evidence_discardPendingUpdate)
Transfer Evidence: (Evidence_listEvidenceForTransfer)
Delete Active Evidence (Evidence_removeActive)
Confirm Evidence Transfer (Evidence_transferEvidenceConfirmation)
Enable Employee Shopping (HCR_enableAndLogEmployeeCoCShopping)
Edit Annual Tax Return Evidence (HCR_incomingModifyAnnualTaxReturnEvidence)
Apply To Period (ISP_ApplyToPeriod)
Edit Elective CHIP Enrollee Evidence (ISP_incomingModifyElectiveCHIPEnrolleeProductEvidence)
Edit Pay In Evidence (ISP_incomingModifyISPPayInProductEvidence)
Edit Spend Down Medical Expense Evidence (ISP_incomingModifyISPSpendDownMedicalExpenseProductEvidence)
Add Evidence (IssueDelivery_addEvidence)
Add Evidence (IssueDelivery_addEvidenceForIC)
Add Evidence (IssueDelivery_addEvidenceForProductDelivery)
Create Issue (IssueDelivery_createIssue)
New Issue Case (IssueDelivery_createIssueForICWizard)
New Issue Case (IssueDelivery_createIssueForPDWizard)
Delete Evidence Approval for Organization Unit (Organization_cancelTemporalEvidenceApprovalCheckForOrgUnit)
Delete Evidence Approval for Position (Organization_cancelTemporalEvidenceApprovalCheckForPosition)
Delete Evidence Approval (Organization_cancelTemporalEvidenceApprovalCheckForUser)
New Evidence Approval Check (Organization_createTemporalEvidenceApprovalCheckForOrgUnit)
New Evidence Approval Check (Organization_createTemporalEvidenceApprovalCheckForPosition)
New Temporal Evidence Approval (Organization_createTemporalEvidenceApprovalCheckForUser)
Evidence (Organization_listOrgUnitTemporalEvidenceApproval)
Evidence Approvals (Organization_listPositionTemporalEvidenceApproval)
Evidence (Organization_listUserTemporalEvidenceApproval)
Edit Evidence Approval Check (Organization_modifyTemporalEvidenceApprovalCheckForOrgUnitFromList)
Edit Evidence Approval Check (Organization_modifyTemporalEvidenceApprovalCheckForOrgUnitFromView)
Edit Evidence Approval Check (Organization_modifyTemporalEvidenceApprovalCheckForPositionFromList)
Edit Evidence Approval Check (Organization_modifyTemporalEvidenceApprovalCheckForPositionFromView)
Edit Temporal Evidence Approval (Organization_modifyTemporalEvidenceApprovalCheckForUserFromList)
Edit Temporal Evidence Approval for User: (Organization_modifyTemporalEvidenceApprovalCheckForUserFromView)
Organization Unit Evidence Approvals (Organization_orgUnitEvidenceApproval)
User Evidence Approvals (Organization_userEvidenceApproval)
Organization Unit Temporal Evidence Approval Home: (Organization_viewTemporalEvidenceApprovalCheckForOrgUnit)
Position Temporal Evidence Approval Home: (Organization_viewTemporalEvidenceApprovalCheckForPosition)
View Temporal Evidence Approval for User: (Organization_viewTemporalEvidenceApprovalCheckForUser)
Discard Evidence (PDEvidence_discardPendingUpdate)
Delete Evidence Type Approval For Product (Product_cancelLiabilityTemporalEvidenceApprovalCheck)
Delete Evidence Approval Check (Product_cancelTemporalEvidenceApprovalCheck)
New Evidence Approval (Product_createTemporalEvidenceApprovalCheckForProduct)
Edit Evidence Approval (Product_modifyLiabilityTemporalEvidenceApprovalCheckForProductFromView)
Edit Evidence Approval (Product_modifyTemporalEvidenceApprovalCheckForProductFromList)
Edit Evidence Approval (Product_modifyTemporalEvidenceApprovalCheckForProductFromView)
View Evidence Approval: (Product_viewLiabilityTemporalEvidenceApprovalCheckForProduct)
View Evidence Approval: (Product_viewTemporalEvidenceApprovalCheckForProduct)
Delete Evidence Approval (Resource_cancelTemporalEvidenceApprovalCheck)
New Evidence Approval (Resource_createTemporalEvidenceApprovalCheck)
Resource_listTemporalEvidenceApprovalCheck
Edit Evidence Approval (Resource_modifyTemporalEvidenceApprovalCheckFromList)
Edit Evidence Approval (Resource_modifyTemporalEvidenceApprovalCheckFromView)
View Evidence Type Approval: (Resource_viewTemporalEvidenceApprovalCheck)
Evidence Approvals (Supervisor_evidenceApprovals)