Refer to the tables below for a description and example of the fields available in resource reports and load files.
*Date and Time formats are examples only and can be customized per report
Resource Reports:
| Field | Description | Example |
| Id | Indexed IO's internal ID number | 5c6ddd69e4b0b17e6cc18c39 |
| ProjectId | The ID number for the project this item is a part of | 59b6c575e4b0b5fbdc3e15a7 |
| CollectionId | The ID number for the collection this item is a part of | 5c6ddc56e4b042e642a0b889 |
| SortKey | The value used to sort this record in the collection | 200201250147470000_5c6ddd69e4b0b17e6cc18c39_5c6ddd69e4b0b17e6cc18c39_5c6ddd69e4b0b17e6cc18c39 |
| Custodian | The records assigned custodian | IIO |
| RelativePath | The location of this record in relation to how it was uploaded | albert_meyers_000_1_1.pst-contents/Top of Personal Folders/meyers-a/ExMerge - Meyers, Albert/Sent Items/1.msg |
| BaseName | The name of this file without an extension | 1 |
| Filename | The complete name of this file including extension | 1.msg |
| Extension | The files extension | MSG |
| AllPaths | The location of this record as well as the location of any duplicate copies of it | albert_meyers_000_1_1.pst-contents/Top of Personal Folders/meyers-a/ExMerge - Meyers, Albert/Sent Items/1.msg; SprintTestSet.zip-contents/SprintTestSet/RegularPST/albert_meyers_000_1_1.pst-contents/Top of Personal Folders/meyers-a/ExMerge - Meyers, Albert/Sent Items/1.msg; |
| Type | Whether this record is an email, container, or other file | |
| MimeType | The mime type of the record. Some file extensions can have different mime types | application/vnd.ms-outlook |
| Category | A more varied categorization of the type of record than Type | |
| IsContainer | Y/N field, is it a container | N |
| IsRegularFile | Y/N field, is it a regular file (not container or email) | N |
| IsEmail | Y/N field, is it an email | Y |
| IsSourceData | Y/N field, was this uploaded rather than extracted from something that was uploaded | N |
| IsSystemFile | Y/N field, is this a NIST identified system file | N |
| IsDuplicateFile | Y/N field, is this a duplicate | Y |
| HasVirus | Y/N field, is this a virus | N |
| WasPasswordProtected | Y/N field, was this file encrypted | N |
| WasDecrypted | Y/N field, was the file able to be decrypted | N |
| Size | Size of the record in bytes | 19968 |
| SystemTags | Any applied system tags, separated by ";" | Duplicate;Processing Exception; |
| ProjectTags | Any applied project tags, separated by ";" | Confidential;Hot Doc; |
| DomainTags | Any applied domain tags, separated by ";" | 123.com;gmail.com; |
| BatchTags | Any applied batch tags, separated by ";" | Review Batch-001; |
| SHA1 | SHA1 Hash value | 663df9e2fcb2859723eb6b41dc3f64244cea0aa9 |
| SHA256 | SHA256 Hash Value | 31eb7ec76795755e65253024d5ef60209a87f0e737a6beddc67f3d561e8733f0 |
| SHA512 | SHA5125 Hash Value | de995520e9651d7136402d1865c050641ad7200a857c36293beacaeb1f717314b07120d8b04a2c3b41de417608d7a3efd3e7217fd4158f2e925cb26fffc09747 |
| MD5 | MD5 Hash value (used for de duplication) | ab01128ef1e9d39c57f60c7966f7d30e |
| IsTopParentResource | Y/N field, was this a parent item rather than an attachment | Y |
| TopParentResourceId | ID number for the parent item | 5c6ddd69e4b0b17e6cc18c39 |
| TopParentCreatedDate | created date for this items parent | 2002-01-25T01:47:47.000+0000 |
| ParentResourceId | immediate parent resource ID | 5c6ddd69e4b0b17e6cc18c39 |
| Ancestors | ID number for the parent item | 5c6ddd69e4b0b17e6cc18c39 |
| EmbeddedIndex | Embedded Index number | 0 |
| Language | Records language | en |
| HadProcessingException | Y/N field, did this file have exceptions | Y |
| ProcessingException | The error on the file if it had an exception | Unable to extract from container |
| NumPdfPages | Number of pages in the indexed IO generated PDF | 2 |
| HadPdfException | Y/N field, were there errors when making a PDF of this record | N |
| PdfException | The error during PDF if there was one | Error durring PDF: NULL |
| CreatedDate | Records created date | 2002-01-25T01:47:47.000+0000 |
| ModifiedDate | Records modified date | 2002-01-25T01:47:47.000+0000 |
| PrintDate | Records print date | 2002-01-25T01:47:47.000+0000 |
| MetadataDate | Records metadata date | 2002-01-25T01:47:47.000+0000 |
| Title | The title for documents, or the subject for emails | FW: FW: Laid-Off A No Nothing Production |
| Creator | Creator of the record | Meyers |
| EmailFrom | Extracted email from field | Meyers |
| EmailTo | Extracted email to field | Slinger;Ryan </O=ENRON/OU=NA/CN=RECIPIENTS/CN=Rslinger> |
| EmailCc | Extracted email cc field | 'kpeterso@epelectric.com' |
| EmailBcc | Extracted email bcc field | DL-Portland Real Time Shift <DL-PortlandRealTimeShift@ENRON.com> |
| EmailRecipients | Combines the EmailTo, EmailCC, and EmailBcc fields | Slinger;Ryan </O=ENRON/OU=NA/CN=RECIPIENTS/CN=Rslinger> |
| EmailMessageClass | The type of email | IPM.Note |
| EmailConversationTopic | The email threads subject line | FW: Laid-Off A No Nothing Production |
| EmailDomains | List of domains extracted from email metadata | epelectric.com |
| InternetMessageId | Embedded Email Message ID number | <KUCKO1NTZZPPUYSLIQ35PUG2TQRKLENHA@zlsvr22> |
| Notes | List of any notes applied to the record | Doc needs further review |
| PrivilegedNotes | List of any privilege notes applied to the record | Attorney client communication |
| BegBates | Most recent starting bates number | iio-000786 |
| EndBates | Most recent ending bates number | iio-000786 |
| BegAttachBates | Most recent starting bates number of attachments | iio-000786 |
| EndAttachBates | Most recent ending bates number of attachments | iio-000786 |
| AllBegBates | All applied starting bates numbers | iio-000959;FORMAT-000959;iio-000786 |
| AllEndBates | All applied ending bates numbers | iio-000960;FORMAT-000960;iio-000786 |
| AllBegAttachBates | All applied starting bates numbers of attachments | iio-000959;FORMAT-000959;iio-000786 |
| AllEndAttachBates | All applied ending bates numbers of attachments | iio-000959;FORMAT-000959;iio-000786 |
Export Load Files:
The following "Parent Email" is used for bates number examples:
| Field | Description | Example |
| Identifier | Starting bates number of the record | iio-001 |
| BegBates | Starting bates number | iio-001 |
| EndBates | Ending bates number | iio-002 |
| ParentBegBates | Starting bates number of the parent item | iio-001 |
| FamilyBegAttachIdentifier | Beg bates number of the records family | iio-001 |
| FamilyEndAttachIdentifier | Beg bates number of the last record in this records family | iio-004 |
| GroupIdentifier | Beg bates number of the starting record for this records family (blank if single page family) | iio-001 |
| FamilyBegAttachBates | Beg bates for first member of family | iio-001 |
| FamilyEndAttachBates | End bates for last member of family | iio-006 |
| FamilyBatesRange | Bates range for this items family | iio-001 - iio-0006 |
| AttachmentsFamilyBegAttachIdentifier | Beg bates number for the first attachment in this files family | iio-003 |
| AttachmentsFamilyEndAttachIdentifier | Beg bates number of the last attachment in this files family | iio-004 |
| AttachmentIdentifierList | List of Beg bates numbers for attached items | iio-003;iio-004 |
| AttachmentFilenameList | List of file names for attached items | ScreenShot.jpg;Attachment.doc |
| NumberOfAttachments | Number of attachments | 2 |
| RelativeNativePath | Location of this record native file in the export | NATIVE\5c6ddc56e4b042e642a0b889\albert_meyers_000_1_1.pst-contents\Top of Personal Folders\meyers-a\ExMerge - Meyers, Albert\Deleted Items\970.MSG |
| RelativePdfPath | Location of this records native PDF in the export | NATIVEPDF\5c6ddc56e4b042e642a0b889\albert_meyers_000_1_1.pst-contents\Top of Personal Folders\meyers-a\ExMerge - Meyers, Albert\Deleted Items\970.msg.PDF |
| RelativeEndorsedPdfPath | Location of this record branded PDF in the export | PDF\iio-000983.PDF |
| RelativeTextPath | Location of this records plaintext in the export | TEXT\000\iio-000983.txt |
| ImageCount | Number of pages in the branded PDF | 1 |
| IIOIdentifier | Internal IIO ID number | 5c6ddd76e4b0b17e6cc1901e |
| Custodian | The records assigned custodian | IIO |
| MimeType | The mime type of the record. Some file extensions can have different mime types | application/vnd.ms-outlook |
| Tags | All applied tags | Duplicate;Exported;_COMPARE TO STAGING - f5ddede6-ce02-480b-99f4-95abd5a5008c;Compare to Staging - 2/21/19 6:11 PM;Formatter Test Export - 3/7/19 6:16 PM;For Webinar - 3/12/19 4:18 PM |
| AllCustodians | List of all custodians for any duplicates of this record | Albert Myers;Austin;Indexed IO;Test;IIO |
| AllPaths | The location of this record as well as the location of any duplicate copies of it | albert_meyers_000_1_1.pst-contents/Top of Personal Folders/meyers-a/ExMerge - Meyers, Albert/Deleted Items/970.msg; SprintTestSet.zip-contents/SprintTestSet/RegularPST/albert_meyers_000_1_1.pst-contents/Top of Personal Folders/meyers-a/ExMerge - Meyers, Albert/Deleted Items/970.msg |
| OriginalFilename | Records original filename | 970.msg |
| OriginalFilenameExtension | Records original file extension | MSG |
| OriginalPath | Original uploaded file path for this record | albert_meyers_000_1_1.pst-contents/Top of Personal Folders/meyers-a/ExMerge - Meyers, Albert/Deleted Items/970.msg |
| DocumentPath | Original uploaded path for this record (documents only) | albert_meyers_000_1_1.pst-contents/Top of Personal Folders/meyers-a/ExMerge - Meyers, Albert/Deleted Items/970.msg-3801945269c94d76f7104371bc5de4eb/labcorpportland.doc |
| EmailPath | Location of this record in it's original PST file (emails only) | albert_meyers_000_1_1.pst-contents/Top of Personal Folders/meyers-a/ExMerge - Meyers, Albert/Deleted Items/970.msg |
| BaseName | The name of this file without an extension | 970 |
| Folders | Folder this record was stored in | albert_meyers_000_1_1.pst-contents\Top of Personal Folders\meyers-a\ExMerge - Meyers, Albert\Deleted Items\ |
| TopFolders | Highest level folder this record was stored in | albert_meyers_000_1_1.pst-contents\Top of Personal Folders\meyers-a\ExMerge - Meyers, Albert\Deleted Items\ |
| FileSize | File size in bytes | 69632 |
| FileSizeKb | File size in Kilobytes | 68 |
| Language | Records language | EN |
| MD5 | MD5 Hash value (used for de duplication) | 3801945269c94d76f7104371bc5de4eb |
| SHA1 | SHA1 Hash value | b83ec335b49166373cab25cf6284cd9902d54218 |
| SHA256 | SHA256 Hash Value | 74d3233af235ba59bdc6ea612fd6f477aec3ae8c2d8ea868ed617d23abe6a98c |
| SHA512 | SHA5125 Hash Value | 847f8290824651bba3b467516dd2f6bb8506c756ccf78ec456dddabef0cd7ae8055eeb4f3b41dd57c52da667212e0eebf9b460faed6c62c99cdc5fdb7069f86e |
| HadProcessingException | Y/N field, did this file have exceptions | N |
| ProcessingException | The error on the file if it had an exception | Unable to extract from container |
| HadImagePlaceholder | Was this record placeholdered | Y |
| Format | Specific formatting type | application/pdf; version=1.4 |
| ResourceIdentifier | Embedded resource ID number | <GC4ACKJPNLBJALIUJEWBFLIWEUBFO4JNTRIJB@zlsvr22> |
| Contributor | Entity responsible for making contributions to the content of the resource | calibre (0.7.50) [http://calibrebookreviews.com] |
| Coverage | The extent or scope of the content of the resource | No Available Data |
| Creator | Creator of the record | Clyatt |
| Modifier | Name of most recent person to edit the file | Barbara Hope Gentile |
| CreatorTool | Tool used to create original document | Adobe PageMaker 6.52 |
| Publisher | Entity responsible for making the resource available | CC Publishing |
| Relation | Reference to related resource | http://www.relatedwebsite.com |
| Rights | Information about rights held in and over the resource | © 2016 Nature Publishing Group |
| Source | A reference to a resource from which the present resource is derived | The Lawyer |
| Type | Whether this record is an email, container, or other file | |
| Title | The title for documents, or the subject for emails | Urgent - Drugs Test Reminder |
| DocTitle | Title of the document | IMPORTANT |
| EmailSubject | Email Subject | Urgent - Drugs Test Reminder |
| Description | Description of the file | Message from client to investors |
| Keywords | Keywords associated with the file | Priority; important; top level |
| Author | File Author | Barbara Hope Gentile |
| PageCount | Number of pages | 1 |
| OfficeCategory | Internal document property | Capitalized Time |
| HasComments | Y/N field, was the file commented | N |
| HasTrackChanges | Y/N field, does file have tracked changes | N |
| HasHiddenSheet | Y/N field, does the file have a hidden sheet | Y |
| HasHiddenRow | Y/N field, does the file have hidden rows | N |
| HasHiddenColumn | Y/N field, does the file have hidden columns | Y |
| HasHiddenRowColumn | Y/N field, does the file have hidden rows or columns | N |
| EmailId | Email Identification number | <POBUI0MCVPYWEEIAK2I1RC3FUOSA41XRB@zlsvr22> |
| EmailFrom | Extracted email from field | Clyatt |
| EmailTo | Extracted email to field | Allen;Thresa A. </O=ENRON/OU=NA/CN=RECIPIENTS/CN=Tallen>;Anderson;John </O=ENRON/OU=NA/CN=RECIPIENTS/CN=Janders3> |
| EmailCc | Extracted email cc field | Pete Davis <pete.davis@enron.com> |
| EmailBcc | Extracted email bcc field | Pete Davis <pete.davis@enron.com> |
| EmailAllRecipients | List of all email recipients | Allen;Anderson;John </O=ENRON/OU=NA/CN=RECIPIENTS/CN=Janders3>;Thresa A. </O=ENRON/OU=NA/CN=RECIPIENTS/CN=Tallen> |
| EmailAllAddresses | list of all email addresses on message | Allen;Anderson;Clyatt;John </O=ENRON/OU=NA/CN=RECIPIENTS/CN=Janders3>;Thresa A. </O=ENRON/OU=NA/CN=RECIPIENTS/CN=Tallen> |
| EmailConversationTopic | The email threads subject line | Urgent - Drugs Test Reminder |
| EmailConversationIndex | "Thread-Index" value from email header | AcGrMP9gngi6/pCJTbW5oQkAS0pM6w== |
| EmailHasDeliveryReceipt | Y/N field, does the email have a delivery receipt | Y |
| EmailDeliveryReceiptTo | "Return-Receipt-To" value from email header | "Steiner, David" <David.Steiner@ENRON.com> |
| EmailHasReadReceipt | Y/N field, does the email have a read receipt | Y |
| EmailReadReceiptTo | "Disposition-Notification-To" value from email header | "Steiner, David" <David.Steiner@ENRON.com> |
| EmailInternetMessageId | Alternate email identification number | <POBUI0MCVPYWEEIAK2I1RC3FUOSA41XRB@zlsvr22> |
| EmailImportance | "Importance" value from email header | High |
| EmailSensitivity | Aspose value for email sensitivity | None |
| SentDate | Date file was sent | 2/1/02 |
| SentTime | Time file was sent | 01:36:00.000+0000 |
| SentDateTime | Sent Date and Time | 2002-02-01T01:36:00.000+0000 |
| ReceivedDate | Date file was received | 2/1/02 |
| ReceivedTime | Time file was received | 01:36:00.000+0000 |
| ReceivedDateTime | Received Date and Time | 2002-02-01T01:36:00.000+0000 |
| CreatedDate | Records created date | 2/1/02 |
| CreatedTime | Time file was created | 01:36:00.000+0000 |
| CreatedDateTime | Created Date and Time | 2002-02-01T01:36:00.000+0000 |
| ModifiedDate | Records modified date | 2/1/02 |
| ModifiedTime | Modified Time | 01:36:00.000+0000 |
| ModifiedDateTime | Modified Date and Time | 2002-02-01T01:36:00.000+0000 |
| AccessedDate | Date file was accessed | 2/1/02 |
| AccessedTime | Time file was last accessed | 01:36:00.000+0000 |
| AccessedDateTime | Accessed Date and Time | 2002-02-01T01:36:00.000+0000 |
| PrintDate | Records print date | 2002-02-01T01:36:00.000+0000 |
| MetadataDate | Records metadata date | 2002-02-01T01:36:00.000+0000 |
| AppointmentStartDate | Appointment Start Date | 2/1/02 |
| AppointmentStartTime | Appointment Start Time | 01:36:00.000+0000 |
| AppointmentStartDateTime | Appointment Start Date and Time | 2002-02-01T01:36:00.000+0000 |
| AppointmentEndDate | Appointment End Date | 2/1/02 |
| AppointmentEndTime | Appointment End Time | 01:36:00.000+0000 |
| AppointmentEndDateTime | Appointment End Date and Time | 2002-02-01T01:36:00.000+0000 |
| TimezoneProcessed | Timezone processing was done in | UTC |
| Application | Application that opens the original file | Microsoft Outlook |
| EProperties | Description of the type of file | |
| Latitude | Location information | 46.99973678 |
| Longitude | Location information | -117.3392105 |
| Rating | Adobe XMP file user rating [0-5], -1 indicates rejected, 0 indicates unrated | 5 |
| Notes | List of any notes applied to the record | Needs further review |
| WasPasswordProtected | Y/N field, was this file encrypted | N |
| WasDecrypted | Y/N field, was the file able to be decrypted | N |
| HasTrackChangesOrComments | Y/N field, does the file have tracked changes or comments | N |
| EmailMessageClass | The type of email | IPM.Note |
| ParentDate | Parent Date | 2/1/02 |
| ParentTime | Parent Time | 01:36:00.000+0000 |
| ParentDateTime | Parent Date and Time | 2002-02-01T01:36:00.000+0000 |
| PriorBegBates | Previous beginning bates number | FORMAT-001164 |
| PriorEndBates | Previous ending bates number | FORMAT-001164 |
| PriorBegAttachBates | Previous Beginning bates number for attachments | FORMAT-001164 |
| PriorEndAttachBates | Previous ending bates number for attachments | FORMAT-001167 |
| AllBegBates | All applied starting bates numbers | iio-001230;FORMAT-001164 |
| AllEndBates | All applied ending bates numbers | iio-001230;FORMAT-001164 |
| AllBegAttachBates | All applied starting bates numbers of attachments | iio-001230;FORMAT-001164 |
| AllEndAttachBates | All applied ending bates numbers of attachments | iio-001233;FORMAT-001167 |
| PrivilegedNotes | List of any privilege notes applied to the record | Attorney Client communication |
| HasNotes | Y/N field, did this record have applied notes | N |
| HasPrivilegedNotes | Y/N field, did this record have applied privilege notes | N |
Comments
0 comments
Please sign in to leave a comment.