Table Description
Verification Requirement Usage: Records the usage of a particular verification requirement.

The Curam Verification Engine allows an individual verification requirement to be used by many different types of cases.

Example

James Smith's income amount is captured at the integrated case level for a IV-A case. There is a requirement to verify James' income amount. This verification requirement is 'used by' the IV-A integrated Case and a TANF product delivery, as defined in the Curam Administration component.

A TANF product delivery and a Food Stamps product delivery are added to the IV-A integrated case. When a user views the list of verifications for the TANF product delivery, a reference to the income verification appears in the list. However, this verification does not appear in the list of verifications required by the Food Stamps product delivery.

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::Verification::Administration::Service Layer::Verification Requirement Usage::Entity::VerificationRequirementUsage
Controlling File: Verification\model\Packages\Administration\Service Layer\Verification Requirement Usage\Entity\Verification Requirement Usage_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
verificationRequirementUsageIDkeynoUnique reference number assigned by the system to a verification requirement usage record.VERIFICATION_REQUIREMENT_USAGE_ID SVR_INT64
verificationRequirementIDdetailsnoUnique reference number assigned by the system referring to the related verification requirement record.VERIFICATION_REQUIREMENT_ID SVR_INT64
relatedItemIDdetailsnoThis is the generated ID of the record that represents the Integrated Case or Product Delivery.VERIFICATION_REQ_USAGE_RELATED_ITEM_NAMEVerificationTypeSVR_STRING<10>
relatedItemTypedetailsnoIdentifies the type of Curam case that this usage refers to, i.e. Integrated Case, Product Delivery.VERIFICATION_REQ_USAGE_RELATED_ITEM_TYPE SVR_STRING<20>
recordStatusdetails Used to support logical deletes.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
namedetails Name of the verification requirement usage.VERIFICATION_REQ_USAGE_NAMEVerReqUsageNameSVR_STRING<10>
commentsdetails General remarks entered by the user.COMMENTS SVR_STRING<300>
Foreign Keys (1)
ChildParent
VerificationRequirementUsage.verificationRequirementIDVerificationRequirement.verificationRequirementID
Indices (3)
Index NameAttributes
VerRqUsVerRqIDIdxverificationRequirementID
usageNameAndStatusname, recordStatus, verificationRequirementID
vrUsgReltdTypIDxrelatedItemType
Operations (21)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: verificationRequirementUsageID
AUTO_ID_KEY: RVERFNBO
PRE_DATA_ACCESS: yes
Create a verification requirement usage record. 
readreadPRE_DATA_ACCESS: no
Reads a verification requirement usage record. 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Modifies a verification requirement usage record. 
validateDetails  Performs the common validations on the details of a verification requirement usage record. 
cancelnsmodifyPRE_DATA_ACCESS: yes
Cancels a verification requirement usage record. 
validateCancel  Validates the details to cancel a verification requirement usage record. 
validateInsert  Validates the details to create a verification requirement usage record. 
validateModify  Validates the details to be used to modify a verification requirement usage record 
readNameByIDnsread Reads Verification Requirement Usage name. 
searchAllVerificationRequirementUsageByRequirementIDnsreadmulti Return a list of all verification requirement usage for verification requirement. 
searchAllActiveNamesnsmulti Reads all active requirement usage names of a verification requirementSQL
countByNameAndStatusns Counts the number of active record with a specified name.SQL
countAllUsagesByRequirementIDns  SQL
countTypeByRequirementIDAndStatusns  SQL
searchAllActiveTypesnsmulti  SQL
readRequirementDetailsByRelatedItemTypensreadmulti   
searchRequirementIDByDataItemIDDateAndRelatedItemnsmulti This method searches verification requirements by verifiable data item, related data item type and dates.SQL
insertVerificationRequirementUsageinsert Inserts Verification Requirement Usage record. This method expects the verificationRequirementUsageID to be set by the calling method. It is preferred to call insertVerificationRequirementUsage method only in scenarios where calling method wants to set the value of primary key by itself. 
searchAllVerificationRequirementUsageByVerificationRequirementreadmulti Return a list of all verification requirement usage for verification requirement. 
searchByRelatedItemTypereadmulti Return a list of all verification requirement usage for a related item type. 
searchRecordsByStatusCodereadmulti   
Related Pages (113)
Update Existing Evidence (AdvancedEvidenceSharing_update)
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)
Edit Annual Tax Return Evidence (HCR_incomingModifyAnnualTaxReturnEvidence)
Edit Elective CHIP Enrollee Evidence (ISP_incomingModifyElectiveCHIPEnrolleeProductEvidence)
Edit Pay In Evidence (ISP_incomingModifyISPPayInProductEvidence)
Edit Spend Down Medical Expense Evidence (ISP_incomingModifyISPSpendDownMedicalExpenseProductEvidence)
Verification Engine (VerificationAdmin_allCategoryTreeWindow)
Apply Requirement (VerificationAdmin_createVerificationRequirementUsage)
Delete Verification Requirement (VerificationAdmin_deleteVerificationRequirement)
Delete Verification Requirement Use (VerificationAdmin_deleteVerificationRequirementUsage)
Edit Verifiable Data Item (VerificationAdmin_modifyVerifiableDataItem)
Edit Verification Requirement Usage (VerificationAdmin_modifyVerificationRequirementUsage)
Verification Engine (VerificationAdmin_treeWindow)
Verification Requirement Usage (VerificationAdmin_viewVerificationRequirementUsage)