This document is available in two formats: this web page (for browsing content) and PDF (comparable to original document formatting). To view the PDF you will need Acrobat Reader, which may be downloaded from the Adobe site.

U.S. DEPARTMENT OF JUSTICE, ANTITRUST DIVISION
METADATA FIELDS & FAMILY RECORD SPECIFICATIONS
Default Summation Load File Layout (.txt)    [Note: Field Names has an 8-character limit]
Field Name Field Description Field Type Hard Copy E-mail Spreadsheets Presentations Other Elec. Docs.
COMPANY Company submitting data Note Text X X X X X
BOX# Submission/Volume#/box number Note Text X X X X X
CUSTDIAN Custodian(s)/source(s) — form: Last, First or ABC Dept Multi-Entry X X X X X
BEGDOC# Start Bates (including prefix) - no spaces Note Text X X X X X
ENDDOC# End Bates (including prefix) - no spaces Note Text X X X X X
DOCID Populate with exact same value as Start Bates [DOCID = BEGDOC#] Note Text X X X X X
PGCOUNT Page count Integer X X X* X X
PARENTID Parent's start Bates, including prefix (ONLY in CHILD records) Note Text X X X X X
ATTCHIDs Child document list: start Bates of each child (ONLY in PARENT records) Multi-Entry X X X X X
FAMLYRNG Family start and end Bates (including prefix) (i.e. ABC-001 – ABC-003) Note Text X X X X X
PRPRTIES Record type: File, E-mail, Attachment or Hard Copy;
Privilege notations: Redacted, Document Withheld Based On Privilege		 Multi-Entry X X X X X
FROM Author — format: Last, First Note Text    X X X X
TO Recipient — format: Last, First Multi-Entry    X X X X
CC Cc field — format: Last, First Multi-Entry    X X X X
BCC Bcc field — format: Last, First Multi-Entry    X X X X
SUBJECT Subject/document title Note Text    X X X X
DOCDATE Document date/date sent - format: MM/DD/YYYY Date Keyed    X      
TIMESENT Time email was sent Time    X      
DATECRTD Date created Date      X X X
DATESVD Date modified Date     X X X
DATERCVD Date accessed/received Date   X X X X
FILESIZE File size Note Text     X X X
ATTITLE File name - name of file as appeared in its original location Note Text     X X X
APPLICAT Application used to create native file (e.g. Excel, Outlook, Word) Note Text     X X X
FILEPATH Data's original source full folder file path Note Text   X X X X
DOCLINK Current file path location to the native file (on the delivery medium) Note Text     X X X
FOLDERID E-mail folder path (sample:Inbox/Active) or Hard Copy folder Information Note Text X X      
PARAGRPH Subpoena/request paragraph number to which the document is responsive Note Text X X X X X
HASH Hash value (used for deduplication or other processing) Note Text   X X X X
SRCHTRMS List of search terms used to identify record as responsive (if used) Multi-Entry   X X X X

Parent IDs, Attachment IDs, and Family Range Details
General Notes:      
  Confirm Family Range definition for attached files    
  Confirm Field Names and Field Types.    
  Remember that each of the Family hass its own record    
         
Family Range Definition:    
   All related records will have a FAMLIYRNG field when the file or email has a parent or children    
   FAMLYRNG will start with the first page of the top-most parent and continue through the last child's last page    
         
Example:      
   Description:
Email
Attachment to E-mail
Attachment to E-mail
     
Doc No. 1
Doc No. 2
Doc No. 3
   BEGDOC#
ABC-001
ABC-011
ABC-016
   ENDDOC#
ABC-010
ABC-015
ABC-020
   PARENTID
[empty]
ABC-001
ABC-001
   ATTCHIDS
ABC-011; ABC-016
[empty]
[empty]
   FAMLYRNG
ABC-001 – ABC-020
ABC-001 – ABC-020
ABC-001 – ABC-020