Table Description
Evidence Descriptor Approval Request: A relationship between an evidence descriptor and an approval request.

The evidence descriptor record is the common or central record for all evidence types. When evidence is submitted for approval, this table provides the link between the evidence descriptor record and the associated approval request record.

Example

A case worker captures income evidence for participant Linda Smith as part of her income support benefit. Once Linda is finished data entry of the evidence, she selects to apply the evidence change. The system identifies that the evidence change requires approval based on the configured approval checks and therefore submits the evidence for manual approval by the case supervisor. A record is created in the evidence descriptor approval request table to link the evidence descriptor for the income evidence to the approval request record.

Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Service Layer::Infrastructure::Temporal Evidence::Entity::Evidence Approval Request Link::EDApprovalRequest
Controlling File: core\model\Packages\Reference Model\Service Layer\Temporal Evidence\Entity\EvidenceApprovalRequestLink\EvidenceApprovalRequestLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
approvalRequestIDdetails Unique reference number of the approval request record which was created for the approval of the evidence.APPROVAL_REQUEST_ID SVR_INT64
currentRequestInddetails Indicates if the approval request is the current or most recent approval request for the evidence record. An evidence record can go through the approval process more than once, for example if approval is initially rejected by the case supervisor.CURAM_INDICATOR SVR_BOOLEAN
edApprovalRequestIDkeynoUnique reference number assigned by the system to a evidence descriptor approval request record.INTERNAL_ID SVR_INT64
evidenceDescriptorIDdetails Unique reference number of the evidence descriptor record for which the approval request was created.EVIDENCE_DESCRIPTOR_ID SVR_INT64
requestedDateTimedetails The date and time on which the evidence approval was requested.CURAM_DATETIME SVR_DATETIME
Indices (2)
Index NameAttributes
ApRqIDIdxapprovalRequestID
EvDescIDCurrReqevidenceDescriptorID, currentRequestInd
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: edApprovalRequestID
POST_DATA_ACCESS: no
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
readCurrentApprovalRequestDetailsns Returns an Approval Request record that is linked to an ED Approval request record using the Evidence Descriptor ID and current request indicator specifiedSQL
readCurrentEDApprovalRequestDetailsns Returns an ED Approval Request record using the Evidence Descriptor ID and current request indicator specifiedSQL
modifyCurrentRequestDetailsnsmodifyOPTIMISTIC_LOCKING: yes
Modifies the current request indicator of an EDApprovalRequest record 
removeremove Standard Operation 
searchApprovalRequestsByEvidenceDescriptorIDnsmulti Returns a list of Approval Requests associated with this Evidence DescriptorSQL
modifyCurrentRequestIndnsmodify   
searchExternalApprovalRequestsByEvidenceDescriptorIDnsmulti  SQL
Related Pages (165)
Delete Existing (AdvancedEvidenceSharing_removeExistingEvidence)
Transfer Application (Application_transferApplicationToExistingCase)
CAProductHomeDetails
Cash Assistance (CashAssistance_CashAssitanceSummaryHistory)
Cash Assistance (CashAssistance_listTimeLimits)
View Cash Assistance Summary (CashAssistance_ViewCashAssistanceSummary)
Check Eligibility (CheckEligibility)
Check Eligibility (CheckMAEligibility)
Check Eligibility (CheckMAEligibilityFromIC)
Renew Chip Product Delivery (Chip_RenewProductDelivery)
CHIPProductHomeDetails
CREOLECAProductHomeDetails
CREOLECHIPProductHomeDetails
CREOLEFAProductHomeDetails
CREOLEMAProductHomeDetails
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)
Beneficiary Evidence Selection: (EVD_listBeneficiaryEvidenceForTransferToTrust)
Trust Evidence Selection: (EVD_selectTransferToTrustEvidencePreAssociation)
Approve Evidence (Evidence_approveApprovalRequest)
Confirm Evidence Approval: (Evidence_confirmEvidenceApproval)
Delete Evidence (Evidence_deleteInEdit)
Undo deletion of active evidence: (Evidence_discardPendingRemoveForActive)
Discard Evidence (Evidence_discardPendingUpdate)
Evidence Approval Requests (Evidence_listAllApprovalRequests)
Approval History (Evidence_listAllApprovalRequests1)
Transfer Evidence: (Evidence_listEvidenceForTransfer)
Reject Evidence: (Evidence_rejectApprovalRequest)
Reject Evidence: (Evidence_rejectApprovalRequest1)
Reject Evidence (Evidence_rejectApprovalRequests)
Delete Active Evidence (Evidence_removeActive)
Confirm Evidence Transfer (Evidence_transferEvidenceConfirmation)
FAProductHomeDetails
Food Assistance (FoodStamps_ListABAWDTimeLimitSummary)
View Food Assistance Summary (FoodStamps_ViewABAWDTimeLimitSummary)
Enable Employee Shopping (HCR_enableAndLogEmployeeCoCShopping)
Edit Annual Tax Return Evidence (HCR_incomingModifyAnnualTaxReturnEvidence)
Apply Changes (HCREvidence_applyChanges)
New Sporting Activity Expense Evidence Details (ICSample_createSportingActivityExpense_fromActive)
New Sporting Activity Expense Evidence Details (ICSample_createSportingActivityExpense_fromInEdit)
Assign Pay In (ISP_applyFromExistingPayInTowardsSpendDown)
Apply To Period (ISP_ApplyToPeriod)
Check Retroactive Medical Assistance Eligibility (ISP_checkRetroactiveEligibility_fromICHome)
Check Retroactive Medical Assistance Eligibility (ISP_checkRetroactiveEligibility_fromPDHome)
Edit Elective CHIP Enrollee Evidence (ISP_incomingModifyElectiveCHIPEnrolleeProductEvidence)
Edit Pay In Evidence (ISP_incomingModifyISPPayInProductEvidence)
Edit Spend Down Medical Expense Evidence (ISP_incomingModifyISPSpendDownMedicalExpenseProductEvidence)
Spend Down Periods (ISP_listCurrentSpendDown)
Renew Long Term Care Eligibility (ISP_renewProductDeliveryEligibility)
Renew Long Term Care Eligibility (ISP_renewProductDeliveryEligibilityFromMenu)
ISPCaseHomeDetails
Check Retroactive Medical Assistance Eligibility (ISPCheckRetroactiveEligibilityPDHomeFromMenu)
Home (ISPSpendDown_productHome)
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)
LIFCProductHomeDetails
LTCProductHomeDetails
Discard Evidence (PDEvidence_discardPendingUpdate)
ProductHomeDetails
RefugeeProductHomeDetails
SpendDownProductHomeDetails
Renew TB Product Delivery (TBBCC_RenewProductDelivery)
TBBCCProductHomeDetails