Table Description
VerificationAttachmentStatus: Additional information about the review status of an attachment which is linked to a verification, and which is to be reviewed by the agency for suitability to be used as proof to verify a piece of evidence.

Example

A Microsoft Word document has been uploaded by a citizen, via the Citizen Portal, to be reviewed by the agency for suitablity to be used as proof to verify a piece of evidence. The document is linked to a verification, and some additional information about the document, including the review status, is stored on this entity.
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 Attachment Status::Entity::VerificationAttachmentStatus
Controlling File: Verification\model\Packages\Application\Service Layer\Outstanding Verification Attachment Pending Review\Entity\OutstandingVerificationAttachmentPendingReview_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
verificationAttachmentStatusIDkeynoThe unique reference number of the record.INTERNAL_ID SVR_INT64
attachmentLinkIDdetailsnoUnique reference number of the attachment link with which this record is associated.ATTACHMENT_LINK_ID SVR_INT64
recordStatusdetailsnoUsed for logical deletes.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
reviewStatusdetailsnoThe review status of the record.DOCUMENT_REVIEW_STATUSDocumentReviewStatusSVR_STRING<10>
lastModifiedDatedetailsyesThe date on which the record was last modified.CURAM_DATE SVR_DATE
lastModifiedBydetailsyesThe username of the user who last modified the record.USER_NAME SVR_STRING<64>
Foreign Keys (1)
ChildParent
VerificationAttachmentStatus.attachmentLinkIDAttachmentLink.attachmentLinkID
Indices (1)
Index NameAttributes
IND_423634599attachmentLinkID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: verificationAttachmentStatusID
PRE_DATA_ACCESS: yes
Standard Operation 
modifymodifyPRE_DATA_ACCESS: yes
Standard Operation 
cancelmodifyPRE_DATA_ACCESS: yes
Standard Operation 
readByAttachmentLinkIDnsread Reads by an attachment link ID. 
readread Standard Operation 
searchByLinkedIDTypeAndReviewStatusnsmulti Searches the AttachmentLink table by related ID, related type, record status, and searches for a corresponding VerificationAttachmentStatus record for the given review status.SQL
searchByLinkedIDTypeAndStatusnsmulti Searches the AttachmentLink table by related ID, related type and record status, and joins with it's corresponding VerificationAttachmentStatus record, if one exists.SQL
countByRelatedIDTypeAndReviewStatusns Counts the number of records on the AttachmentLink table for the specified related ID, related type and record status, where a corresponding record on the VerificationAttachmentStatus table exists, for the specified review status.SQL
Related Pages (190)
Verifications (ApplicationEvidence_listAllVerificationsForCase)
Verifications (ApplicationEvidence_listVerificationsForCase)
Verification Details (ApplicationEvidence_viewVerificationListItemAppliesTo)
Verification Details (ApplicationEvidence_viewVerificationListItemDetails)
Home (ApplicationSummary)
Add Attachment (ApplicationVerificationApplication_addAttachmentForItem)
Edit Attachment Details (ApplicationVerificationApplication_modifyAttachmentDetails)
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)
Program Summary (Eligibility_createProgram)
Employer_evidenceListWSVerifications
EVD_listAbParChildSupportEvidenceWSVerifications
EVD_listAbsenceEvidenceWSVerifications
EVD_listAbsentParentCSEEvidenceWSVerifications
EVD_listAbsentParentEvidenceWSVerifications
EVD_listAdoptionEvidenceWSVerifications
EVD_listAdoptionPaymentEvidenceWSVerifications
EVD_listAlienEvidenceWSVerifications
EVD_listAlienSponsorEvidenceWSVerifications
EVD_listAlienSponsorshipEvidenceWSVerifications
EVD_listAlimonyExpenseEvidenceWSVerifications
EVD_listAnnuityBeneficiaryEvidenceWSVerifications
EVD_listAnnuityEvidenceWSVerifications
EVD_listAnnuityIncomeEvidenceWSVerifications
EVD_listAnticipatedIncomeEvidenceWSVerifications
EVD_listAssignedIncomeEvidenceWSVerifications
EVD_listAuthorizedRepEvidenceWSVerifications
EVD_listBeneficiaryEvidenceWSVerifications
EVD_listBenefitEvidenceWSVerifications
EVD_listBoarderEvidenceWSVerifications
EVD_listBurialPlanEvidenceWSVerifications
EVD_listBurialPlotEvidenceWSVerifications
EVD_listBusinessAssetEvidenceWSVerifications
EVD_listChildImmuneEvidenceWSVerifications
EVD_listChildSupportEnforcementEvidenceWSVerifications
EVD_listChildSupportExpenseEvidenceWSVerifications
EVD_listContributorEvidenceWSVerifications
EVD_listCostOfCareAllowanceEvidenceWSVerifications
EVD_listCountableAssistanceHistoryEvidenceWSVerifications
EVD_listCourtOrderExpenseEvidenceWSVerifications
EVD_listCoverageEvidenceWSVerifications
EVD_listCoverageTypeDetailsEvidenceWSVerifications
EVD_listCriminalHistoryEvidenceWSVerifications
EVD_listDependentCareExpenseEvidenceWSVerifications
EVD_listDeprivationEvidenceWSVerifications
EVD_listDisabilityEvidenceWSVerifications
EVD_listDomesticViolenceEvidenceWSVerifications
EVD_listEarnedIncomeEvidenceWSVerifications
EVD_listEmergencyEvidenceWSVerifications
EVD_listEmploymentExpenseEvidenceWSVerifications
EVD_listEmploymentOfferEvidenceWSVerifications
EVD_listEntitlementEvidenceWSVerifications
EVD_listExemptionEvidenceWSVerifications
EVD_listExtensionEvidenceWSVerifications
EVD_listFosterCareEvidenceWSVerifications
EVD_listFosterCarePaymentEvidenceWSVerifications
EVD_listGeneralInsuranceEvidenceWSVerifications
EVD_listGrossReceiptEvidenceWSVerifications
EVD_listHeadOfHouseholdEvidenceWSVerifications
EVD_listHholdMealsGroupEvidenceWSVerifications
EVD_listHouseholdMemberEvidenceWSVerifications
EVD_listHouseholdRelationshipEvidenceWSVerifications
EVD_listIncomeAllocationEvidenceWSVerifications
EVD_listIncomeReportingEvidenceWSVerifications
EVD_listIncomeTrustScheduleEvidenceWSVerifications
EVD_listLegalGuardianEvidenceWSVerifications
EVD_listLevelOfCareEvidenceWSVerifications
EVD_listLifeInsuranceEvidenceWSVerifications
EVD_listLiquidResourcesEvidenceWSVerifications
EVD_listLivingArrangeEvidenceWSVerifications
EVD_listLivingExpenseEvidenceWSVerifications
EVD_listLoanEvidenceWSVerifications
EVD_listMealGroupMemberEvidenceWSVerifications
EVD_listMedicalExpenseEvidenceWSVerifications
EVD_listMedicalExpensePaymentEvidenceWSVerifications
EVD_listMedicalInstitutionEvidenceWSVerifications
EVD_listMedicalInsuranceEvidenceWSVerifications
EVD_listMedicalScreeningEvidenceWSVerifications
EVD_listMedInstTemporaryAbsenceEvidenceWSVerifications
EVD_listMinorParNonResEvidenceWSVerifications
EVD_listMinorParSchlAttEvidenceWSVerifications
EVD_listOwnershipEvidenceWSVerifications
EVD_listPaidEmploymentEvidenceWSVerifications
EVD_listPregnancyEvidenceWSVerifications
EVD_listPropertyEvidenceWSVerifications
EVD_listResourceIncomeEvidenceWSVerifications
EVD_listResourceTransferEvidenceWSVerifications
EVD_listSelfEmploymentEvidenceWSVerifications
EVD_listShelterExpenseEvidenceWSVerifications
EVD_listSocialRelationshipEvidenceWSVerifications
EVD_listSpousalCooperationEvidenceWSVerifications
EVD_listStudentEvidenceWSVerifications
EVD_listStudentExpenseEvidenceWSVerifications
EVD_listTPLEnforcementEvidenceWSVerifications
EVD_listTradeDisputeEvidenceWSVerifications
EVD_listTransferReversalEvidenceWSVerifications
EVD_listTransferToIndividualEvidenceWSVerifications
EVD_listTransferToTrustEvidenceWSVerifications
EVD_listTrusteeEvidenceWSVerifications
EVD_listTrustEvidenceWSVerifications
EVD_listTrustIncomeEvidenceWSVerifications
EVD_listUnbornChildEvidenceWSVerifications
EVD_listUnearnedIncomeEvidenceWSVerifications
EVD_listUnearnedRentalIncomeExpenseEvidenceWSVerifications
EVD_listUnpaidEmploymentEvidenceWSVerifications
EVD_listUtilityExpenseEvidenceWSVerifications
EVD_listVehicleEvidenceWSVerifications
EVD_listVetMilitaryServEvidenceWSVerifications
EVD_listVoluntaryQuitEvidenceWSVerifications
EVD_listWorkNonParticipationEvidenceWSVerifications
EVD_listWorkRegistrationEvidenceWSVerifications
EVD_listWorkRequirementsEvidenceWSVerifications
Evidence_DynamicEvidenceTypeWSVerifications
Verifications (Evidence_listAllVerificationsForCase)
Verifications (Evidence_listVerificationsForCase)
Verification Details (Evidence_viewVerificationListItemAppliesTo)
Verification Details (Evidence_viewVerificationListItemDetails)
Verifications (Evidence_workspaceTypeVerifications)
HCR_listAnnualTaxReturnEvidenceWSVerifications
Confirm Renewal Completion (HCRIC_completeRenewal)
Verifications (HCRIC_listAllVerificationsForCase)
Verifications (HCRIC_listVerificationsForCase)
Verifications (IC_evidenceListAllVerificationsForCase)
Verifications (IC_evidenceListVerificationsForCase)
Evidence Type Verifications (ICSample_EvidenceTypeVerificationList)
Verifications (ICSample_listVerificationsForCase)
Verifications (ICSampleSportingGrant_listAllVerificationsForCase)
Verifications (ICSampleSportingGrant_listVerificationsForCase)
Spend Down Periods (ISP_listCurrentSpendDown)
ISP_listElectiveCHIPEnrolleeProductEvidenceWSVerifications
ISP_listISPPayInProductEvidenceWSVerifications
ISP_listISPSpendDownMedicalExpenseProductEvidenceWSVerifications
Home (ISPSpendDown_productHome)
Participant_evidenceListAddressWSVerifications
Participant_evidenceListAltIDWSVerifications
Participant_evidenceListBankAccountWSVerifications
Verifications (PD_evidenceListAllVerificationsForCase)
Verifications (PD_evidenceListVerificationsForCase)
Verifications (PDSampleSportingGrant_listAllVerificationsForCase)
Verifications (PDSampleSportingGrant_listVerificationsForCase)
Person_evidenceListAltNameWSVerifications
Person_evidenceListClientWSVerifications
Person_evidenceListCtznshpWSVerifications
Person_evidenceListEducationWSVerifications
Person_evidenceListEmploymentWSVerifications
Person_evidenceListEmpWorkHrWSVerifications
Person_evidenceListFrgnRsdncyWSVerifications
Person_evidenceListRelationshipWSVerifications
Person_evidenceListWSVerifications
ProspectEmployer_evidenceListWSVerifications
ProspectPerson_evidenceListWSVerifications
Verifications (ServiceDelivery_listVerificationsForCase)
Accept Documents (VerificationApplication_acceptAllSubmittedDocumentsForItem)
Accept Document (VerificationApplication_acceptSubmittedDocumentForItem)
Add Attachment (VerificationApplication_addAttachment)
Add Attachment: (VerificationApplication_addAttachmentEvidenceDetails)
Add Attachment (VerificationApplication_addAttachmentForItem)
Verify Evidence (VerificationApplication_associateOutstandingEvd)
Delete Attachment (VerificationApplication_deleteAttachment)
Delete Attachment: (VerificationApplication_deleteAttachmentEvidenceDetails)
Verifications Outstanding (VerificationApplication_ICOutstandingVerificationList)
Verifications (VerificationApplication_IntegratedCaseVerificationList)
Edit Attachment Details (VerificationApplication_modifyAttachmentDetails)
Edit Attachment Details: (VerificationApplication_modifyAttachmentDetailsEvidenceDetails)
Edit Attachment Details (VerificationApplication_modifyAttachmentDetailsFromList)
Verifications Outstanding (VerificationApplication_PDOutstandingVerificationList)
Verifications (VerificationApplication_productDeliveryVerificationList)
Reject Documents (VerificationApplication_rejectAllSubmittedDocumentsForItem)
Reject Document (VerificationApplication_rejectSubmittedDocumentForItem)
Verify Evidence (VerificationApplication_verifyOutstandingEvd)
View Attachment Details : (VerificationApplication_viewAttachment)
View Attachment Details : (VerificationApplication_viewAttachmentEvidenceDetails)
View Attachment Details (VerificationApplication_viewAttachmentFromItem)
View Verification Details: (VerificationApplication_viewEvidenceItemVerificationDetails)
View Verification Details: (VerificationApplication_viewEvidenceVerificationDetails)
View Verification Details: (VerificationApplication_viewICOutstandingVerificationList)
View Verification Details: (VerificationApplication_viewIntegratedCaseVerificationList)
View Verification Details: (VerificationApplication_viewPDOutstandingVerificationList)
View Verification Details: (VerificationApplication_viewproductDeliveryVerificationList)
View Verification Details (VerificationApplication_viewVerificationDetailsTransaction)
Verification Details (VerificationApplication_viewVerificationListItemAppliesTo)
View Verification Details: (VerificationApplication_viewWorkspaceParticipantVerificationDetails)
View Verification Details: (VerificationApplication_viewWorkspaceVerificationDetails)