1 / 5

Data Verification Cleanup Tools

Data Verification Cleanup Tools. 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. halFILE Database Validator. Identify invalid table codes Identify documents without images

marion
Download Presentation

Data Verification Cleanup Tools

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