Bureau of Competition Production Guide

Preparing Native Files

Preferred Format

  • Submit Microsoft Excel files in native format with extracted text and metadata.
  • Submit Microsoft Access files and other multimedia files in native format with metadata.
  • Submit other files and attachments as images with extracted text and metadata.

Optional Format

With prior approval from the Bureau of Competition staff person identified in the formal request, you may submit files natively with a "built" Concordance database as long as it contains:
  1. extracted text,
  2. metadata, and
  3. links to the native file.

Metadata & Other Information Requirements

Include the following metadata fields and information in the delimited data load file. Alongside each piece of information, we've recommended a corresponding field name for the delimited data load file.

View sample delimited data load file >>

Document Info /
Metadata
Description
Concordance
Field Name
Beginning Bates number The beginning bates number for the document BEGBATES
Ending Bates number The ending bates number for the document ENDBATES
Page Count The total number of pages in the document PGCOUNT
Custodian The name of the original custodian of the file CUSTODIAN
Creation Date The date attachment was saved at the location on the electronic media for the first time CREATEDATE
Creation Time The time the attachment was saved at the location on the electronic media for the first time CREATETIME
Modified Date The date/time the attachment was last changed, and then saved MODDATE
Modified Time The time the attachment was last changed, and then saved MODTIME
Last Accessed Date The time the attachment was last opened, scanned, or even “touched” by a user or software activity LASTACCDATE
Last Accessed Time The time the attachment was last opened, scanned, or even “touched” by a user or software activity LASTACCTIME
Size The amount of space the file takes up on the electronic media. Usually recorded in kilobytes, however may be reported in single bytes FILESIZE
File Name The name of the attachment including the extension denoting the application in which the file was created FILENAME
Native link Relative path of submitted native files such as Excel spreadsheets NATIVELINK
Hash The SHA (Secure Hash Algorithm) or MD5 Hash for the original native file if available HASH

Last Modified: Wednesday, March 25, 2009