data verification cleanup tools n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Data Verification Cleanup Tools PowerPoint Presentation
Download Presentation
Data Verification Cleanup Tools

Loading in 2 Seconds...

play fullscreen
1 / 5

Data Verification Cleanup Tools - PowerPoint PPT Presentation


  • 94 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Data Verification Cleanup Tools' - declan-martin


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
gap report edit reports
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
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
dbfix32
DBFix32
  • Remove leading zeros
  • Remove commas
  • Remove leading spaces
  • Remove spaces
  • Remove dashes
  • Remove double spaces
  • Replace values
custom cleanup
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