Summation’s Attachment Viewer

March 29th, 2009

Many Summation users are unaware of Summation’s document attachment viewing options. However, the attachment viewing feature is a great way to increase the value of a traditional database and is essential when reviewing e-evidence. The attachment viewing features allow users to easily view related or attached documents that are not displayed in the current record set. The features also allows users to add all related documents to search result sets. Finally, users can use these features to keep track of what documents were sent together, or emailed, with other documents. Here’s how it works.
The attachment viewer tracks the parent and attachment relationships between documents. The parent document is the first document, or lead document, in a group of attached documents. For example, the fax cover sheet sending documents is the parent document. Or, the cover letter enclosing important or relevant information is the parent document. All other documents in the group of attached documents are the attachments or child documents.
For the attachment viewing system to work, all documents in an attachment group need to be coded as individual documents. A fax cover sheet would have its own database record. Each document attached to the fax cover sheet would have its own record. Similarly, a cover letter has its own database record, and each document attached would have its own record. I think you get the idea.
Coding the relationship between parent and child/attached documents is key. Every parent document record includes the docids of all attached documents in the attchids field. Every attached document record includes the docid for the parent document in the parentid field. Let’s take an example of a fax cover sheet sending a letter and a table of data. The group of documents has an entire bates range of ABC00001 – ABC00009, as follows:

• Fax Cover Sheet: ABC00001
• Letter: ABC00002 – ABC00008
• Table: ABC00009

First, create the record for the Fax Cover Sheet. The Bates Range is ABC00001. Now, because the document has documents attached to it, you need to code the Attchids field (e-table). The DOCIDS, or beginning bates number, of each attached document gets coded here. So, you’d type in ABC00002, ABC00009 in the Attchids field. Now, w’ere ready to code the document attachments. The Bates Range for the letter is ABC00002 – ABC00008. Because this is an attachment, you also need to code the parentid field. Type in ABC00001 in that field. We’re going to do the same thing for the table. It’s Batesrange is ABC00009, and ABC00001 goes in the parentid field.
Fortunately, imaging vendors usually capture this information and can provide it to you with their load files. E-discovery vendors also capture this information and can provide it to you in the eDII files. Thus, if you think about this ahead of time, you will not need to code in this information.
Now, that all the attachment information is coded, you can put it to work! It works easiest, in my opinion, from Column Display. If a record is included in an attachment group as a parent document or an attachment, you can view all related documents by right mouse-clicking on the record’s row number in Column Display, and selecting “View Parent Doc & Attachments” or “View attached documents,” depending on the cirumstances. The attachment viewer will launch, and you will be able to select to view the image, OCR text, or data for the attached documents, even if the attached documents were not included in your current record set in Column Display.
That’s not all it will do. If you perform a search, you can add all related documents to the search result set to make sure you’ve captured the entirety of document attachment groups. Again, from Column Display, go to Search|Include Family Summaries. Summation will add any attached or parent documents to the record that are associated with the documents currently displayed. Those added records will be highlighted for easy reference.

If you go to the sample case, P Franc v. Morris (Version 2.5), you can play around a little bit with these functions in the email collection (bates prefix eml). I think it is a very useful tool that not enough users know about. It can save you a lot of time because we all know every time we see a fax cover sheet or letter, we want to know what was attached!

Lisa Ratzlaff

Summation’s E-Table and the E-Stdfrm

March 29th, 2009

Although Summation’s E-Table has been around now for years, I notice that many users are still defaulting to, and creating new databases in the Standard Table and the old trusty and familiar Standard Form. While I understand this form is what we’re used to and models itself after the old paradigms we developed in a paper-litigation world, there are several reasons to switch over to the E-table. I’m going to post a series of articles to explain why I think using the E-Table is what makes sense, including a basic description of tables and forms, features of the new E-Table and its forms, reasons to use the E-Table and its forms, and tips for helping you make the switch, including dealing with imaging vendors to provide you with appropriate load files for the E-Table. While change is not always easy, change can be good. Now that I’m used to the new E-Table and the E-Stdfrm and the flexibility they provide, I will never switch back.

About At Issue Technology Corner

December 14th, 2008

I started At Issue Technology Corner to share articles and posts about new litigation technology, to provide training tools and tips for Summation iBlaze, CaseMap and other litigation support software, and to discuss best practices for using legal technology. I am a Summation Certified Trainer, a Certified CaseMap Trainer, and a very experience litigation paralegal and litigation support manager. Most importantly, I would like to create a community of legal technology users who will share their insights and knowledge with others.

I hope this blog is helpful to you, and that you use it to share your thoughts, too.

Why Use Summation, CaseMap or any litigation support database

December 14th, 2008

A Case for ROI

I hear from many of my clients that using Summation or CaseMap is too expensive. Some mistakenly believe that it is difficult and time consuming to set up a case database. In fact, however, the numbers show otherwise. It is very cost and time effective to use a litigation support tool, once you have been properly trained how to use the software. In fact, using Summation or CaseMap saves money and time, right from the start of litigation.

Let’s assume we’ve got a case in the door with 15 boxes of documents. There is an average of 2000 pages per box, so we’re dealing with about 37,500 pages. On average, there are four pages per document, so we’re dealing with about 9,375 documents. If the case lasts two years, you will save $32,000 and close to 200 hours by using a litigation support document management system. Here are the numbers:

Manual Document Management System

Photocopy documents at $.15 per page: $5,625.00
Bates labeling documents at $.05 per page: $1,875.00
Creating a working set at $.10 per page: $3,750.00
Total Copy Costs = $11,250.00

According to KMPG, the average document review rate with paper is 100 pages per hour.

Time Spent Creating Document Index: 375 hours
Cost to Create Index at $125 per hour: $46,875.00

Let’s also assume that we misplace or lose about .05% of the documents with a manual system and that it takes on average about 40 minutes to find each lost or misplaced document.

Number of documents searched for each month: 5
Hours spent looking for these documents for case: 67.5
Cost to search for misplaced documents for case: $8,437.50
TOTAL COST TO MANAGE DOCUMENTS: $66,562.60
TOTAL HOURS SPENT: 442.5

Digital Document Management System

Image documents at $.15 per page: $5,625.00
OCR documents at $.03 per page: $1,125.00
Bates label documents at $.01 per page $375.00
Extra CD: $50.00
Total Scanning Costs: $7,175.00

According to KMPG, the average document review rate with electronic documents is 200 pages per hour.

Time Spent Creating Database: 187.5 hours
Cost to Create Database at $125 per hour: $23,437.50

The average time to find a misplaced or lost document with a litigation support system is about 10 minutes per document.

Number of documents searched for each month: 5
Hours spent looking for these documents for case: 11.25
Cost to search for misplaced documents for case: $1,406.25
TOTAL COST TO MANAGE DOCUMENTS: $32,018.75
TOTAL HOURS SPENT: 198.75

You can see that the savings over the lifetime of a single case are significant. The savings more than offset the cost for the software and training. Also, think what you could do with the extra hours you save. Perhaps, it’s fewer OT hours for staff. Perhaps you can take on an additional case. Maybe you can spend time with your family.

Stay tuned for a similar analysis for electronic discovery evidence.

Lisa Ratzlaff, RP