Skip to main content

Reveal Processing

Reveal 11-Processing Field Mapping Matrix

The table below shows the Reveal 11 field display name, its corresponding Reveal Processing field, and a description of the field content. For a matrix containing SQL field names and data types, see the downloadable PDF. You may use the right arrow on your keyboard to scroll the table for additional information.

REVIEW SQL FIELD NAME

PROCESSING FIELD NAME

Description

Review (Web) Display Name

ALLRECIPIENTS

RECIPIENTS

All Recipient(s) fields of the email combined in one field.

All Recipients

APP_CREATED_DATETIME

METACREATEDDATETIME

Metadata created date and time combined in one field where applicable.

Application Created Date/Time

APP_LASTMOD_DATETIME

METALASTMODDATETIME

Metadata last modified date and time combined in one field where applicable.

Application Last Saved Date/Time

APP_LASTPRINTED_DATETIME

METALASTPRINTDATETIME

Metadata last printed date and time combined in one field where applicable.

Last Printed Date/Time

APP_META_CATEGORY

METACATEGORY

Bucket field containing all efile metadata.

Application Category

APP_META_COMMENTS

METACOMMENTS

Comments of the efile extracted from the file’s metadata.

Application Comments

APP_META_KEYWORDS

METAKEYWORDS

Keywords of the efile extracted from the file’s metadata.

Application Keywords

APP_META_REVISION

METAREVISION

Revision of the efile extracted from the file’s metadata.

Application Revision

APP_META_SUBJECT

METASUBJECT

Subject of the efile extracted from the file’s metadata.

Application Meta Subject

APP_META_TEMPLATE

METATEMPLATE

Template of the efile extracted from the file’s metadata.

Application Template

APP_METADATA

METADATA

Category of the efile extracted from the file’s metadata.

Application Metadata

APPLICATION_TYPE

APPTYPE

Category of application.

Application Type

APPTBEGDATE

APPTBEGDATE

Start date of email appointment.

Appointment Begin Date

APPTBEGDATETIME

APPTBEGDATETIME

Start date and time of the email appointment combined in one field.

Appointment Begin Date/Time

APPTBEGTIME

APPTBEGTIME

Start time of the email appointment.

Appointment Begin Time

APPTENDDATE

APPTENDDATE

End date of email appointment.

Appointment End Date

APPTENDDATETIME

APPTENDDATETIME

End date and time of the email appointment combined in one field.

Appointment End Date/Time

APPTENDTIME

APPTENDTIME

End time of the email appointment.

Appointment End Time

ATTACHMENT_COUNT

NUMATTACH

All efiles, parent emails, and loose parent emails with no attachments will be populated with 0. Parent emails with attachments, loose parent emails with attachments and efiles with embedded objects will be populated with the number of attachments within the family. So if an email has an attachment the parent email = 1 the attachment = 0.

Attachment Count

ATTACHMENT_LIST

ATTACHMENTS

Populated on parent emails and attached email files only. If the email has an attachment the name of the attachment will be populated. Multiple attachment names will be separated by a semicolon.

Attachment List

AUTHOR

EFILEDOCAUTHOR

Author of the efile extracted from the file’s metadata.

Author

BATCHID

EXPORTNAME

Name of the export or commonly referred to as CD Volume.

Batch ID

BATESCHILDLIST

BATESCHILDLIST

All parent items that have attachments will be populated with the BATESBEG(s) of their attachments. If the parent item has multiple attachments, the BATESBEG values will be separated with a semicolon.

Bates Child List

BATESFAMILYRANGE

BATESFAMILYRANGE

Family boundary expressed as the family's BATESBEGATTACH-BATESENDATTACH.

Bates Family Range

BCC

BCC

Recipient(s) of the email.

Bcc

BEGATTACH

BEGATTACH

All Efiles, Parent Emails, and loose Parent Emails will be populated with their FILEID. All attachments and embedded objects within the family will be populated with the Parent item’s FILEID. So if a Parent Email has the FILEID TV-00000001 all files within the family will = TV-00000001. This is the group identifier for Relativity Exports.

Begin Number Attach

BEGBATES

BATESBEG

Beginning bates number of the file.

Begin Bates

BEGBATESATTACH

BATESBEGATTACH

All efiles, parent emails, and loose parent emails will be populated with their BATESBEG value. All attachments and embedded objects within the family will be populated with the parent item’s BATESBEG value. So if a parent email has the BATESBEG IMAGE-00000001 all files within the family will have BATESBEGATTACH IMAGE-00000001. This is the group identifier for Relativity Exports.

Begin Bates Attach

BEGDOC

FILEID

The “bates number” of the file which is a unique, sequential number assigned to each efile, email, and atachment in the collection based on the File Numbering setting chosen at export time. All below examples will use the FILEID when being populated. This is the file identifier for Relativity Exports.

Begin Number

CC_ADDRESSES

CC

Recipient(s) of the email.

Cc

COLLECTIONLOCATION

COLLECTIONLOCATION

The Collection Location of the file. This information is captured when assigning data to a custodian in the Custodians Module. This can be changed after data assignment by unassigning the data from the Custodian and applying properly when assigning the data to the Custodian again.

Collection Location

COLLECTIONSOURCE

COLLECTIONSOURCE

The Collection Source of the file. This information is captured when assigning data to a Custodian in the Custodians Module. This can be changed after data assignment by unassigning the data from the Custodian and applying properly when assigning the data to the Custodian again.

Collection Source

COMPANY

EFILECOMPANY

Company of the efile extracted from the file’s metadata.

Company

CONVBASEINDEX

CONVBASEINDEX

First 44 characters of Conversation Index of the email; only applies to Microsoft email.

Conversation Base Index

CONVERSATION

CONVERSATION

This should be populated with the display field in RSMFConversations for all exported events.

CONVERSATION

CONVERSATION_ID

CONVERSATION ID

Conversation Index of the email; only applies to Microsoft email.

Conversation ID

CONVERSATIONID

CONVERSATIONID

This should be populated with the Id field in RSMFConversations for all exported events.

CONVERSATIONID

CONVERSATIONPARTICIPANTS

CONVERSATIONPARTICIPANTS

RSMF text thread parties.

CONVERSATIONPARTICIPANTS

CONVERSATIONPLATFORM

CONVERSATIONPLATFORM

RSMF text application.

CONVERSATIONPLATFORM

CONVERSATIONSLICESENDERS

CONVERSATIONSLICESENDERS

RSMF thread senders.

CONVERSATIONSLICESENDERS

CREATION_DATE

OSCREATEDDATE

File system created date.

OS Creation Date

CREATION_TIME

OSCREATEDTIME

File system created time.

OS Creation Time

CUSTODIAN_NAME

CUSTODIAN

Custodian name.

Custodian

CUSTODIANTITLE

CUSTODIANTITLE

This will apply the information provided within the Title field in the Custodians Module for a particular Custodian for all files assigned to the Custodian. This field can be edited after assigning data to a particular Custodian. This does not have to be a title. If there is something unique to be captured for all files within a particular Custodian, like a bar code, this field could be used for that purpose thus making it more like a custom field at export time.

Custodian Title

CUSTWITHDUPES *

CUSTWITHDUPES

If the file is an original file and has duplicates, the original file will be populated with the Custodian name(s) of the Custodians that contain a duplicative copy of the file within the project. This analysis is only performed on the project level.

Custodians with Duplicates

CUSTWITHDUPESCUST *

CUSTWITHDUPESCUST

This field is the same as CUSTWITHDUPES with one exception. If the custodian that contains the original copy of the file does not contain a duplicate copy within their population their name will not be included in the CUSTWITHDUPES field. However in the CUSTWITHDUPESCUST field, in this example, the Custodian’s name would be populated.

Custodians with Duplicates plus current custodian

DATE_CREATED

METACREATEDDATE

Metadata created date where applicable.

Application Created Date/Time

DATE_OTHER

EMPTYFIELD

Blank field.

Date

DE_CLOSESTCONCEPT

CLOSESTCONCEPT

A concept score ranging anywhere from 0.50 to 1.0. A file with a score of 1.0 would be an exact match, a file with a score of 0.60 would be somewhat conceptually related. The Closest Concept is the concept search that is the most conceptually similar to the file in the concept search result.

Decision Engine Closest Concept

DE_CONCEPTGROUPS

CONCEPTGROUPS

The name of the Discovery Manager Concept Search Group(s) the file is assigned to. If the file belongs to multiple Concept Search Groups, the Concept Search Groups will be separated with a semicolon.

Decision Engine Concept Groups

DE_CONCEPTTERMS

CONCEPTTERMS

The responsive concept search term(s) of the file. If there are multiple search terms responsive to the file, the search terms will be separated with a semicolon.

Decision Engine Concept Terms

DE_EMAILTHREADDIRECTION

EMAILTHREADDIRECTION

Indicates the probable action the sender of the email performed to generate an email. This value will be one of the following: NEW, REPLY, REPLY ALL, FORWARD or DRAFT.

Decision Engine Thread Direction

DE_EMAILTHREADID

EMAILTHREADID

A group identifier assigned to all items in the same email thread. This value will be the TVFILEID of the earliest email within the thread. This value is calculated and populated on the thread and family level. All Emails and attachments within the thread will contain the EMAILTHREADID.

Decision Engine Email Threads

DE_EMAILTHREADISINCLUSIVE

EMAILTHREADISINCLUSIVE

Indicates a subset of emails in an email family that contain all of the text of all of the emails in the family; for such emails the field will be TRUE. If a user were to read all emails flagged with this metadata they will have read all authored content of the entire email family without needing to read all of the email items.

Decision Engine Inclusive Thread

DE_EMAILTHREADNUMITEMS

EMAILTHREADNUMITEMS

Indicates the number of total items within the thread (all emails and attachments).

Decision Engine Thread Document Count

DE_NDFAMILYID

NDFAMILYID

A group identifier to identify all items in the same textual near-duplicate group. This value will be the TVFILEID of the principal item in the group, which is the item against which all other group members were compared. This value is populated on the near duplicate group level.

Decision Engine Family ID

DE_NDNUMCHARS

NDNUMCHARS

The number of characters found in the item text. This will include all words (including numbers). Uses of this value could include special handling of near duplicates of very short texts and ordering items within a near-duplicate group by size. This value is calculated and populated on the file level.

Decision Engine Number of Characters

DE_NDPARENT

NDPARENT

If the file which is considered the principal item of the near duplicate group which all other group members are compared against, this field will be TRUE. This value is populated on the near duplicate group level.

Decision Engine Near Duplicate Parent

DE_NDSIMILARITY

NDSIMILARITY

The similarity of an item compared to the principal item of a near-duplicate group. This value is expressed as a decimal percent in the range of [0-100]. The principal item of the group, and any exact duplicate of it, will always have a value of 100. This value is populated on the near duplicate group level.

Decision Engine Similarity Score

DE_QUERY

QUERY

The Decision Engine Query(s) of the file. If there are multiple Queries responsive to the file, the values will be separated with a semicolon.

Decision Engine Queries

DE_TAGS

TAGS

The name of the Decision Engine Tag(s) assigned to the file. If the file belongs to multiple Tags within the Decision Engine, the Tags will be separated with a semicolon.

Decision Engine Tags

DECRYPTED

DECRYPTED

If the file was decrypted within Discovery Manager, the value will be TRUE.

Decrypted

DELIVERYREPORTREQ

DELIVERYREPORTREQ

If the email was a delivery report, the value will be TRUE. https://technet.microsoft.com/en-us/library/jj150554%28v=exchg.150%29.aspx

Delivery Report Requested

DM_DUPEID

TVDUPEID

The Discovery Manager duplicate identifier. Only populated with the TVFILEID of the original file if the file is a duplicate within the system.

Discovery Manager Dupe ID

DM_IMPORTQCCOMMENT

IMPORTQCCOMMENT

The Import QC comment applied to the file when the file was moved to QC Cleared by the user.

Discovery Manager QC Comments

DM_INDEXSTATUS

INDEXSTATUS

The Discovery Manager Index status of the file. This can only be one value.

Processing Index Status

DM_ISREDACTED

ISREDACTED

If redacted images were imported for the file, this field will be populated as TRUE.

Is Redacted

DM_PARENTID

TVPARENTID

The Discovery Manager parent identifier. Only populated for attachments, archive children, and embedded objects with the TVFILEID of the parent item.

Discovery Manager Parent ID

DM_PROJECTNAME

PROJECTNAME

Name of the project.

Project Name

DOCUMENT_AUTHOR

EFILELASTAUTHOR

Last Author of the efile extracted from the file’s metadata.

Document Author

DOCUMENT_NAME

EMPTYFIELD

Blank field.

Document Name

DOCUMENT_RECEIVED_BY

EMPTYFIELD

Blank field.

Document Received By

DOCUMENT_TYPE_DESC

APPNAME

Native application that created the associated file. This is based on the file’s signature. For example, for Adobe PDF files this would equal PDF.

App Name

DOMAINS

DOMAINS

Sender and Recipient domains combined into one field. Where applicable.

Sender Recipient Domains

DUPEPATHS *

DUPEPATHS

This is only populated for parent-level original files, it is not populated for duplicates. It contains all duplicates' paths but does not contain the original's path. The original's path is contained in the RelativePathParent field. Non-parent-level records will be empty.

Duplicate Document Path

DUPEPATHSWITHORIG *

DUPEPATHSWITHORIG

This is populated for all parent-level records except in the case where the record is an original without duplicate(s). It contains all of the duplicate paths including the original's. If the record is an original without duplicates, then it will be empty and the original's path will be contained in the RelativePathParent field. Non-parent-level records will be empty.

Duplicate Document Path Include Orig

EFILETITLE

EFILETITLE

Title of the efile extracted from the file’s metadata.

Application File Title

EMAIL_UNREAD

EMAILREADSTATUS

Read status of the email.

Email Unread

EMAILADDRESSESALL

EMAILADDRESSESALL

All Email address fields (Sender and Recipients) of the email combined in one field.

All Addresses

EMAILDATERECEIVED

EMAILDATERECEIVED

Date Received of the email.

Email Date Received

EMAILDATETIMERECEIVED

EMAILDATETIMERECEIVED

Date Received date and time of the email combined in one field.

Email Datetime Received

EMAILFOLDER

EMAILFOLDER

Folder where the email item originated. Populated on parent emails only.

Email Folder

EMAILINTFILEPATH

EMAILINTFILEPATH

Relative file path to email inside of the archive. For example, if the email was in the Financials folder underneath the Inbox folder, this would read Inbox\Financials

Email Internal File Path

EMAILITEMTYPE

EMAILITEMTYPE

The item type of the email according to native application.

Email Item Type

EMAILPRIORITY

EMAILPRIORITY

Priority of the email.

Email Priority

EMAILSENSITIVITY

EMAILSENSITIVITY

The Sensitivity of the email is the level of importance for an email (https://docs.microsoft.com/en-us/exchange/clients-and-mobile-in-exchange-online/outlook-for-ios-and-android/sensitive-labeling-and-protection-outlook-for-ios-android). This applies to Outlook email from 2007 and later only.

Email Sensitivity

EMAILTIMERECEIVED

EMAILTIMERECEIVED

Time Received of the email.

Email Time Received

EMAILTRANSPORTHEADERS

EMAILTRANSPORTHEADERS

Email Transport Header of the email; only applies to Microsoft email.

Email Header

ENCRYPTED

ENCRYPTED

If the file is encrypted, the value will be TRUE.

Encrypted

ENDATTACH

ENDATTACH

All efiles without embedded objects and parent emails without attachments will be populated with their FILEID. All items within the family will be populated with the last item within the family’s FILEID. So if the last item in the family was FILEID TV-00000002 all items within the family would = TV-00000002.

End Number Attach

ENDBATES

BATESEND

Ending bates number of the file.

End Bates

ENDBATESATTACH

BATESENDATTACH

All efiles without embedded objects and parent emails without attachments will be populated with their BATESEND value. All items within the family will be populated with the last bates number. So if the last page within the family was IMAGE-00000100 all items within the family will have BATESENDATTACH IMAGE-00000100.

End Bates Attach

ENDDOC

ENDATTACH

All efiles without embedded objects and parent emails without attachments will be populated with their FILEID. All items within the family will be populated with the last item within the family’s FILEID. So if the last item in the family was FILEID TV-00000002 all items within the family would = TV-00000002.

End Number

ENTRY_ID

EMAILENTRYID

Entry ID of the email; Entry ID applies to Microsoft email; Universal ID of the email; Universal ID applies to Lotus Notes email.

Entry ID

EXCEPTION_TYPE

QCFLAGCATEGORY

The QCFlagCategory(s) assigned to the file. If the file belongs to multiple QCFlagCategory fields, the values will be separated with a semicolon.

Exception Type

EXIFLATITUDE

EXIFLATITUDE

Image origin global position latitude dimension.

EXIF Latitude

EXIFLONGITUDE

EXIFLONGITUDE

Image origin global position longitude dimension.

EXIF Longitude

EXPORTED_NATIVE_FILE

NATIVEFILE

Full file path to the deliverable native file. This is the doclink field for Relativity Exports when using the Set File Links (Export Path) for the Native File Copy Mode setting.

Exported Native File

EXPORTEDFILEEXT

FILEEXT

Exported extension of the file. For example, if an MSG file is exported as an MHT file, this field would read MHT.

Exported File Extension

EXPORTFILESIZE

EXPORTFILESIZE

Size of the exported file in bytes. For example, if an MSG file is exported as an MHT file, this field would be populated with the size of the MHT file, and not the size of the original MSG file.

File Size (Exported) in bytes

FAMILYRANGE

FAMILYRANGE

BEGATTACH-ENDATTACH.

Family Range

FILE_EXTENSION

ORIGFILEEXT

Original extension of the file. For example, if an MSG file is exported as an MHT file, this field would read MSG.

Extension

FILE_SIZE

EXPORTFILESIZEKB

Size of the exported file in kilobytes. For example, if an MSG file is exported as an MHT file, this field would be populated with the size of the MHT file, and not the size of the original MSG file.

File Size (Kb)

FILEIDCHILDLIST

FILEIDCHILDLIST

All parent items that have attachments will be populated with the FILEID(s) of their attachments. If the parent item has multiple attachments, the FILEID values will be separated with a semicolon.

File ID Child List

FILEIDPARENTID

FILEIDPARENTID

Populated for children with the exported FileID of the corresponding parent item.

Exported Parent ID

FILESIZE

EXPORTFILESIZE

Size of the original file in bytes.

File Size (bytes)

FILESIZEKB

EXPORTFILESIZEKB

Size of the original file in kilobytes.

File Size in Kb

FILTERING_EFFECTIVE_HIT

SEARCHTERM

The responsive search term(s) of the file. If there are multiple search terms responsive to the file, the search terms will be separated with a semicolon.

Filtering Effective Hit

FOREIGN_LANGUAGES

LANGUAGEPER

The language(s) identified within the file followed by their percentage contained within the file. Up to 3 languages will be identified for a given file. If the file contains more than 1 language, the languages will be separated by a semicolon, and will be ordered in percentage of the language contained within the file from largest to smallest.

Foreign Languages

HASEMBEDDEDOBJECTS

HASEMBEDDEDOBJECTS

If the file has an embedded object(s), the value will be TRUE.

Has Embedded Objects

HASHIDDENCONTENT

HASHIDDENCONTENT

If the file has Hidden Content, the value will be TRUE.

Has Hidden Content

HASPATTERN

HASPATTERN

If the file matches at least 1 pattern, the value will be true.

Has Pattern

HIDDENCONTENT

HIDDENCONTENT

The Hidden Content of the file. If the file contains several Hidden Content values, the values will be separated with a semicolon.

Hidden Content

IMAGEMANUAL

IMAGEMANUAL

If the file was manually imaged within QC, this field will be populated as TRUE.

Image Manual

IMAGEPLACEHOLDER

IMAGEPLACEHOLDER

If the file has no images associates with it, and an image placeholder exists for the file, this field will be populated as TRUE.

Image Place Holder

IMAGEQCCOMMENT

IMAGEQCCOMMENT

Displays the QC Comment of the file if the file was moved to QC Cleared and a comment was applied within QC.

Image QC Comment

IMAGESTATUS

IMAGESTATUS

The image status of the file. Not Imaged = The file has not been imaged yet; Not Supported = the file is not supported for system imaging; Success = the file was successfully imaged; Errored = The system attempted to image but errored it out; Pending = the file is within an imaging job but has not been imaged yet.

Image Status

IMPORTPATH

IMPORTPATH

Original path of the associated file with the file name.

Import Path

IS_EXCEPTION

EMPTYFIELD

Blank field.

Exception

IS_FOREIGN_LANGUAGE

EMPTYFIELD

Blank field.

Foreign Language

IS_PRODUCED

EMPTYFIELD

Blank field.

Produced

ISADUPLICATE

ISDUPLICATE

If the file is duplicate: TRUE; If the file is not duplicate: FALSE.

Is A Duplicate

ISEMBEDDEDOBJECT

ISEMBEDDEDOBJECT

If the file is an embedded object, the value will be TRUE.

Embedded Object

ISPARENT

ISPARENT

All efiles and parent emails will be populated with TRUE. Attachments and embedded objects will be populated with FALSE.

Is Parent

ITEMID

No Field

Reveal Unique Identifier. Auto generated upon record load.

Item ID

LANGUAGE

LANGUAGE

The language(s) identified within the file. Up to 3 languages will be identified for a given file. If the file contains more than 1 language, the languages will be separated by a semicolon, and will be ordered in percentage of the language contained within the file from largest to smallest.

Detected Languages

LANGUAGECHAR

LANGUAGECHAR

The language(s) identified within the file followed by their character count within the file. Up to 3 languages will be identified for a given file. If the file contains more than 1 language, the languages will be separated by a semicolon, and will be ordered in percentage of the language contained within the file from largest to smallest.

Language Character Count

LAST_ACCESS_DATE

OSLASTACCESSEDDATE

File system last accessed date.

OS Last Access Date

LAST_ACCESS_TIME

OSLASTACCESSEDTIME

File system last accessed time.

OS Last Access Time

LAST_MODIFIED_DATE

OSLASTMODDATE

File system last modified date.

OS Saved Date

LAST_MODIFIED_TIME

OSLASTMODTIME

File system last modified time.

OS Saved Time

LAST_PRINTED_DATE

METALASTPRINTDATE

Metadata last printed date where applicable.

Last Printed Date

LAST_PRINTED_TIME

METALASTPRINTTIME

Metadata last printed time where applicable.

Last Printed Time

LAST_SAVED_DATE

METALASTMODDATE

Metadata last modified date where applicable.

Application Last Saved Date

LAST_SAVED_TIME

METALASTMODTIME

Metadata last modified time where applicable.

Application Last Saved Time

MASTERDATE

MASTERDATE

Efiles = Last Modified Date; Email & Attachment = Date Sent of parent email. This field is used for the date restrictions within Discovery Manager.

Master Date

MASTERDATETIME

MASTERDATETIME

MASTERDATE and MASTERTIME combined into one field.

Master Date Time

MASTERTIME

MASTERTIME

Efiles = Last Modified Time; Email & Attachment = Time Sent of parent email.

Master Time

MD5_HASH

MD5HASH

The MD5 Hash of the file.

Duplicate ID

MEDIADESCRIPTION

MEDIADESCRIPTION

This will apply the information provided within the Description field in the Imports Module for a particular import for all files within the import. This field can be edited after an import has completed for a particular import. This does not have to be a serial number. If there is something unique to be captured for all files within a particular import, like a bar code, this field could be used for that purpose thus making it more like a custom field at export time.

Media Description

MEDIAMANUFACTURER

MEDIAMANUFACTURER

This will apply the information provided within the Manufacturer field in the Imports Module for a particular import for all files within the import. This field can be edited after an import has completed for a particular import. This does not have to be a media manufacturer. If there is something unique to be captured for all files within a particular import, like a bar code, this field could be used for that purpose thus making it more like a custom field at export time.

Media Manufacturer

MEDIAMODEL

MEDIAMODEL

This will apply the information provided within the Model Number field in the Imports Module for a particular import for all files within the import. This field can be edited after an import has completed for a particular import. This does not have to be a serial number. If there is something unique to be captured for all files within a particular import, like a bar code, this field could be used for that purpose thus making it more like a custom field at export time.

Media Model

MEDIASERIAL

MEDIASERIAL

This will apply the information provided within the Serial Number field in the Imports Module for a particular import for all files within the import. This field can be edited after an import has completed for a particular import. This does not have to be a serial number. If there is something unique to be captured for all files within a particular import, like a bar code, this field could be used for that purpose thus making it more like a custom field at export time.

Media Serial Number

MESSAGE_ID

EMAILINTMESSAGEID

Internet Message ID of the email; only applies to Microsoft email.

Internet Message ID

MSGNO

MSGNO

All efiles and parent emails will be populated with their ‘I’TVFILEID’S’TVFILEID. Attachments and embedded objects will be populated with the ‘I’Parent item’s TVFILEID’S’Attachment’s TVFILEID, etc. So if a parent email has the TVFILEID 1 and has one attachment that has the TVFILEID 2 the parent email = I1S1 and the attachment = I1S2

Message Number

NAME

FILENAME

Original file name of the file.

File Name

OCR_PATH

TEXTFILE

Full file path to the deliverable text file.

Ocr Path

OS_CREATED_DATETIME

OSCREATEDDATETIME

File system created date and time combined in one field.

OS Creation Date/Time

OS_LASTACCESS_DATETIME

OSLASTACCESSEDDATETIME

File system last accessed date and time combined in one field.

OS Last Access Date/Time

OS_LASTMOD_DATETIME

OSLASTMODDATETIME

File system last modified date and time combined in one field.

OS Saved Date/Time

PAGE_COUNT

IMAGEPAGECOUNT

Total number of images exported.

Page Count

PARENT_ITEMID

No Field

Review internal family identifier. Auto generated upon family build.

Parent ID

PARENTCHILDDOCID

EMPTYFIELD

Blank field.

Parent Child Document ID

PARENTCHILDMD5

PARENTCHILDMD5

All efiles and parent emails will be populated with their MD5 hash value twice. Attachments and embedded objects will be populated with the parent item’s MD5 hash followed immediately by their MD5 hash.

Parent Child Document MD5

PATTERNNAME

PATTERNNAME

The Pattern Names of the file. If there are multiple Patterns responsive to the file, the values will be separated with a semicolon.

Pattern Name

PDF_PATH

PDFEXPORTPATH

Processing export path for Native PDF Files.

Native PDF File

PROCESSED_DATE

PROCESSEDDATE

Date of processing for reporting purposes.

Processed Date

PROJECTPATH

PROJECTPATH

File path to the native file stored in the project’s Processing Folder. This is the doclink field for Relativity Exports when using the Set File Links (Processing Path) & Copy Files for the Native File Copy Mode setting.

Project Path

RECEIVED_DATE

EMAILDATERECEIVED

Date Received of the email.

Date Received

RECEIVED_TIME

EMAILTIMERECEIVED

Time Received of the email.

Time Received

RECIPIENT

TO

Recipient(s) of the email.

To

RECIPIENTCOUNT

RECIPIENTCOUNT

Total number of recipients of the email.

Recipient Count

RELATIVE_PATH

RELATIVEPATH

Original path of the associated file without the file name.

Folder

RELATIVENATIVEFILE

RELATIVENATIVEFILE

Relative file path to the deliverable native file.

Exported Relative Native File

RELATIVEPATHPARENT

RELATIVEPATHPARENT

Recommended over RELATIVEPATH. This is the original file path of the associated file without the file name for the parent item. The difference between RELATIVEPATH and RELATIVEPATHPARENT is if the file is an attachment or embedded object, the RELATIVEPATH will contain the full path to these items including the parent item’s name. For example, an email attachment’s RELATIVEPATH = Test.PST\Inbox\00001000.email\, where the RELATIVEPATHPARENT = Test.PST\Inbox.

Relative Path Parent

RELATIVETEXTFILE

RELATIVETEXTFILE

Relative file path to the deliverable text file.

Exported Relative Text File

SENDER

FROM

Sender of the email.

From

SENT_DATE

DATESENT

Date Sent of the email.

Date Sent

SENT_TIME

TIMESENT

Time Sent of the email.

Time Sent

SENTONBEHALFOF

SENTONBEHALFOF

The email address of an individual that has granted Send On Behalf Of permission to another user or a delegate. For example, if John Doe (jdoe@email.com) has granted Bob Doe (bdoe@email.com) rights to be a delegate to send email on John’s behalf, and Bob has sent an email on John’s behalf, this field would be populated with John’s email address, whereas Bob’s email address would be populated in the FROM field.

Sent on Behalf of

SOURCE

ARCHIVESTORE

Name of email archive (PST/OST/NSF) and non email archive (ZIP/RAR etc.) from which the file was extracted.

Source

SUBJECT

SUBJECT

Edoc subject.

Subject

SUBJECT_OTHER

SUBJECT

Email subject.

Email Subject

THREAD_IN_REPLY_TO

INTREPLYTOID

Email In-Reply-To ID used to pull together email threads.

Email In-Reply-To

THREAD_REFERENCES

INTREFERENCES

Internet references used to pull together email threads.

Email References

TIME_CREATED

METACREATEDTIME

Metadata created time where applicable.

Application Created Time

TIME_OTHER

EMPTYFIELD

Blank field.

Time

TIMEZONE

TIMEZONE

Timezone value used when importing scope data.

Time Zone

TVFAMILYID

TVFAMILYID

The Discovery Manager unique identifier for document families.

TV Family ID

TVFILEID

TVFILEID

The Discovery Manager unique identifier. Populated for all files.

TV FILE ID

TYPEDOCUMENT

DOCUMENTTYPE

Efile = EFILE; Parent Email = EMAIL; Attachment/Embedded Object = ATTACHMENT.

Type of Document

TYPEDOCUMENTPARENT

DOCUMENTTYPEPARENT

Efile = EFILE; Parent Email/Attachment/Embedded Object = EMAIL.

Type of Parent Document

UTCOFFSET

UTCOFFSET

This is the time zone offset from GMT that the data was processed in. For example, if the data was processed in GMT-5 this would be populated with -5.00. This is the native time zone offset field for Relativity Exports.

UTC Offset

VOLUMENAME

VOLUMENAME

The name of the Volume assigned to the file. This is only populated when using the Enable Volume and Folder Options.

Volume Name

ZANTAZARCHIVEINTERNETRECIPIENTS

ZANTAZARCHIVEINTERNETRECIPIENTS

Domino/Notes: Lists the internet addresses of each recipient on a thread (john.doe@domain.com) and not what appears in the mail client (Doe, John). Groups are expanded so each recipient is listed.

Zantaz Recipients (Domino/Notes)

ZANTAZARCHIVEORIGINALFROM

ZANTAZARCHIVEORIGINALFROM

Domino/Notes: Lists the sender of the email item.

Zantaz Sender

ZANTAZARCHIVERECIPIENTS

ZANTAZARCHIVERECIPIENTS

Domino/Notes: Provides the same information as ZANTAZARCHIVEORIGINALRECIPIENTS except groups are expanded.

Zantaz Recipients Expanded

ZANTAZRECIP

ZANTAZRECIP

Exchange/Outlook: Every recipient on an email thread (i.e. TO, CC, BCC) for Zantaz emails.

Zantaz All Email Recipients (Outlook)

Note

* Live data fields - These fields that don’t exist within SQL but are populated at export time.