Table Description
This Entity is used to override/bypass a mandatory verification requirement of a verifiable item. On activation of an evidence with a mandatory verification required for an item having a corresponding waiver record, the evidence will get activated. The case rules should take care of what happens to the evidence when outside the waiver period. This entity can be populated through code by implementing curam.verification.sl.infrastructure.impl.EvidenceVerificationWaiver interface and binding it using guice.
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::Application::Service Layer::Verification Waiver::Entity::VerificationWaiver
Controlling File: Verification\model\Packages\Application\Service Layer\Verification Waiver\Verification Waiver.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
AUDIT_FIELDSyes
LAST_UPDATED_FIELDyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
verificationWaiverIDkeynoSystem generated Unique ID assigned to the waiver recordINTERNAL_ID SVR_INT64
productIDdetailsyesUnique reference number of the product, for which the waiver for an integrated case evidence verification should be considered on activating the product delivery, when the property curam.miscapp.considerproductidforicwaivers is set to true.PRODUCT_ID SVR_INT64
VDIEDLinkIDdetailsnoUnique reference number referring to the evidence details of this verification record.VDIED_LINK_ID SVR_INT64
startDatedetails The date from when the requirement to verify a piece of evidence is waived.CURAM_DATE SVR_DATE
endDatedetails The date the requirement to verify a piece of evidence is waivered to. CURAM_DATE SVR_DATE
verificationIDdetailsnoUnique reference number assigned by the system to a verification record.VERIFICATION_ID SVR_INT64
commentsdetails General remarks entered by the user.COMMENTS SVR_STRING<300>
recordStatusdetailsnoUsed to support logical deletes.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (3)
ChildParent
VerificationWaiver.productIDProduct.productID
VerificationWaiver.VDIEDLinkIDVDIEDLink.VDIEDLinkID
VerificationWaiver.verificationIDVerification.verificationID
Indices (3)
Index NameAttributes
IDXVerifiWaiverVDIEDLinkVDIEDLinkID
IDXVerificWaiverVerificationverificationID
IND_1836243082productID
Operations (13)
OperationStereotypeOptionsDescriptionSQL
readread Standard Operation 
insertinsertAUTO_ID: verificationWaiverID
PRE_DATA_ACCESS: yes
Standard Operation 
modifymodifyPRE_DATA_ACCESS: yes
Standard Operation 
searchByVerifiableDataItemEvidenceDescriptorLinkreadmulti Returns a list of waiver records for a particular VDIEDLink 
searchByCaseIDnsmulti Returns a list of waivers for a caseSQL
searchByVerificationIDreadmulti Returns a list of Waiver records for a particulat verification 
searchByEvidenceDescriptorIDnsmulti Returns a list of waiver records for an Evidence DescriptorSQL
cancelnsmodifyPRE_DATA_ACCESS: yes
  
modifyPeriodnsmodifyPRE_DATA_ACCESS: yes
Modify the start and end dates of waiver record. Can also include some comments on the reason why the dates are changed. 
searchByParticipantIDnsmulti Returns a list of waiver records for a particular participant. This is applicable for participant evidenceSQL
searchActiveByVerificationIDreadmultiWHERE: VerificationWaiver.verificationID = :verificationID AND VerificationWaiver.recordStatus = 'RST1'
Search for all waiver records for a verification 
removeremove Removes the waiver record from the table. 
searchCurrentActiveByVerificationIDreadmultiPRE_DATA_ACCESS: yes
WHERE: VerificationWaiver.verificationID = :verificationID AND VerificationWaiver.recordStatus = 'RST1' AND startDate<= :currentDate AND endDate >=:currentDate
Search for all waiver records for a verification 
Related Pages (139)
Update Existing Evidence (AdvancedEvidenceSharing_update)
Verifications (ApplicationEvidence_listAllVerificationsForCase)
Verifications (ApplicationEvidence_listVerificationsForCase)
Verification Details (ApplicationEvidence_viewVerificationListItemWaiver)
Verifications (ClassicIC_evidenceListVerificationsForCase)
Home (CommonIntake_applicationCaseHome)
CommonIntake_applicationCaseHomeContextPanel
Verifications (CommonIntake_listAllVerificationsForCase)
Verifications (CommonIntake_listVerificationsForCase)
Verifications (DefaultIC_listAllVerificationsForCase)
Verifications (DefaultIC_listVerificationsForCase)
Verifications (DefaultICProduct_listAllVerificationsForCase)
Verifications (DefaultICProduct_listVerificationsForCase)
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)
Verifications (Evidence_listAllVerificationsForCase)
Verifications (Evidence_listVerificationsForCase)
Verification Details (Evidence_viewVerificationListItemWaiver)
Edit Annual Tax Return Evidence (HCR_incomingModifyAnnualTaxReturnEvidence)
Confirm Renewal Completion (HCRIC_completeRenewal)
Verifications (HCRIC_listAllVerificationsForCase)
Verifications (HCRIC_listVerificationsForCase)
Verifications (IC_evidenceListAllVerificationsForCase)
Verifications (IC_evidenceListVerificationsForCase)
Verifications (ICSample_listVerificationsForCase)
Verifications (ICSampleSportingGrant_listAllVerificationsForCase)
Verifications (ICSampleSportingGrant_listVerificationsForCase)
Edit Elective CHIP Enrollee Evidence (ISP_incomingModifyElectiveCHIPEnrolleeProductEvidence)
Edit Pay In Evidence (ISP_incomingModifyISPPayInProductEvidence)
Edit Spend Down Medical Expense Evidence (ISP_incomingModifyISPSpendDownMedicalExpenseProductEvidence)
Verifications (PD_evidenceListAllVerificationsForCase)
Verifications (PD_evidenceListVerificationsForCase)
Verifications (PDSampleSportingGrant_listAllVerificationsForCase)
Verifications (PDSampleSportingGrant_listVerificationsForCase)
Verifications (ServiceDelivery_listVerificationsForCase)
Verify Evidence (VerificationApplication_associateOutstandingEvd)
Cancel Verification Waiver (VerificationApplication_cancelWaiver)
Add Verification waiver (VerificationApplication_createWaiver)
Edit Period of waiver (VerificationApplication_modifyWaiverPeriod)
Verify Evidence (VerificationApplication_verifyOutstandingEvd)
This page allows you to view verification waiver details. (VerificationApplication_viewWaiverDetails)