1 / 5

Comprehensive Data Verification and Cleanup Tools for Reliable Reporting

This report outlines essential tools and techniques for effective data verification and cleanup. Utilize sequential clerk number analysis to identify missing documents, validate database entries, and streamline record maintenance. Discover how to filter data by volume or date range, identify invalid table codes, and locate documents missing images. The report also includes methods to clean up data by removing leading zeros, commas, and extra spaces. Technical support is available to assist with creating stored procedures and custom programs for efficient data management.

declan-martin
Télécharger la présentation

Comprehensive Data Verification and Cleanup Tools for Reliable Reporting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data VerificationCleanup Tools

  2. Gap Report / Edit Reports • Look for missing documents by finding a gap in the sequential clerk number • Pull up data by volume or date range and sight verify

  3. halFILE Database Validator • Identify invalid table codes • Identify documents without images • Instrument_type not in (‘PRO’,’DIV’,’TS’,’BKR’) • Clerk_number between ’96-00001’ and ’97-00001’ • Date_filed between ‘1/1/2007’ and ’12/31/2007’ • Special book/page version is available • First document: Book: 2625 Page: 1 • Second document: Book: 2625 Page: 5 • Checks that first document has 4 pages

  4. DBFix32 • Remove leading zeros • Remove commas • Remove leading spaces • Remove spaces • Remove dashes • Remove double spaces • Replace values

  5. Custom Cleanup • Tech Support can create stored procedures, programs, and reports to assist you with data cleanup • Locate records will null values • Change subdivision codes • Mass update records

More Related