Bureau of Competition Production Guide
Preparing Native Files
Preferred Format
- Submit Microsoft Excel and PowerPoint 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.
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 |
| Originating Path |
File path of the file as it resided in its
original environment. |
FILEPATH |
| Production Link |
Relative path to production media of
submitted native files. Example: FTC-001\NATIVE\001\FTC-0003090.xls |
NATIVELINK |
| Hash |
The SHA (Secure Hash Algorithm) or MD5 Hash for the original native file if available |
HASH |
