Reveal Field Mapping Matrix & Definitions

Internal and external Processing to Reveal field mappings and descriptions

The table below shows the Reveal 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.

REVIEW SQL FIELD NAME	Review (Web) Display Name	PROCESSING FIELD NAME	Description
ALLRECIPIENTS	All Recipients	RECIPIENTS	All Recipient(s) fields of the email combined in one field.
APP_CREATED_DATETIME	Application Created Date/Time	METACREATEDDATETIME	Metadata created date and time combined in one field where applicable.
APP_LASTMOD_DATETIME	Application Last Saved Date/Time	METALASTMODDATETIME	Metadata last modified date and time combined in one field where applicable.
APP_LASTPRINTED_DATETIME	Last Printed Date/Time	METALASTPRINTDATETIME	Metadata last printed date and time combined in one field where applicable.
APP_META_CATEGORY	Application Category	METACATEGORY	Bucket field containing all efile metadata.
APP_META_COMMENTS	Application Comments	METACOMMENTS	Comments of the efile extracted from the file’s metadata.
APP_META_KEYWORDS	Application Keywords	METAKEYWORDS	Keywords of the efile extracted from the file’s metadata.
APP_META_REVISION	Application Revision	METAREVISION	Revision of the efile extracted from the file’s metadata.
APP_META_SUBJECT	Application Meta Subject	METASUBJECT	Subject of the efile extracted from the file’s metadata.
APP_META_TEMPLATE	Application Template	METATEMPLATE	Template of the efile extracted from the file’s metadata.
APP_METADATA	Application Metadata	METADATA	Category of the efile extracted from the file’s metadata.
APPLICATION_TYPE	Application Type	APPTYPE	Category of application.
APPTBEGDATE	Appointment Begin Date	APPTBEGDATE	Start date of email appointment.
APPTBEGDATETIME	Appointment Begin Date/Time	APPTBEGDATETIME	Start date and time of the email appointment combined in one field.
APPTBEGTIME	Appointment Begin Time	APPTBEGTIME	Start time of the email appointment.
APPTENDDATE	Appointment End Date	APPTENDDATE	End date of email appointment.
APPTENDDATETIME	Appointment End Date/Time	APPTENDDATETIME	End date and time of the email appointment combined in one field.
APPTENDTIME	Appointment End Time	APPTENDTIME	End time of the email appointment.
ATTACHMENT_COUNT	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_LIST	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.
AUTHOR	Author	EFILEDOCAUTHOR	Author of the efile extracted from the file’s metadata.
BATCHID	Batch ID	EXPORTNAME	Name of the export or commonly referred to as CD Volume.
BATESCHILDLIST	Bates Child List	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.
BATESFAMILYRANGE	Bates Family Range	BATESFAMILYRANGE	Family boundary expressed as the family's BATESBEGATTACH-BATESENDATTACH.
BCC	Bcc	BCC	Recipient(s) of the email.
BEGATTACH	Begin Number Attach	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.
BEGBATES	Begin Bates	BATESBEG	Beginning bates number of the file.
BEGBATESATTACH	Begin Bates Attach	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.
BEGDOC	Begin Number	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.
CC_ADDRESSES	Cc	CC	Recipient(s) of the email.
COLLECTIONLOCATION	Collection Location	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.
COLLECTIONSOURCE	Collection Source	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.
COMPANY	Company	EFILECOMPANY	Company of the efile extracted from the file’s metadata.
CONVBASEINDEX	Conversation Base Index	CONVBASEINDEX	First 44 characters of Conversation Index of the email; only applies to Microsoft email.
CONVERSATION	CONVERSATION	CONVERSATION	This should be populated with the display field in RSMFConversations for all exported events.
CONVERSATION_ID	Conversation ID	CONVERSATION ID	Conversation Index of the email; only applies to Microsoft email.
CONVERSATIONID	CONVERSATIONID	CONVERSATIONID	This should be populated with the Id field in RSMFConversations for all exported events.
CONVERSATIONPARTICIPANTS	CONVERSATIONPARTICIPANTS	CONVERSATIONPARTICIPANTS	RSMF text thread parties.
CONVERSATIONPLATFORM	CONVERSATIONPLATFORM	CONVERSATIONPLATFORM	RSMF text application.
CONVERSATIONSLICESENDERS	CONVERSATIONSLICESENDERS	CONVERSATIONSLICESENDERS	RSMF thread senders.
CREATION_DATE	OS Creation Date	OSCREATEDDATE	File system created date.
CREATION_TIME	OS Creation Time	OSCREATEDTIME	File system created time.
CUSTODIAN_NAME	Custodian	CUSTODIAN	Custodian name.
CUSTODIANTITLE	Custodian Title	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.
CUSTWITHDUPES	Custodians with Duplicates	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.
CUSTWITHDUPESCUST	Custodians with Duplicates plus current custodian	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.
DATE_CREATED	Application Created Date/Time	METACREATEDDATE	Metadata created date where applicable.
DATE_OTHER	Date	EMPTYFIELD	Blank field.
DE_CLOSESTCONCEPT	Decision Engine Closest Concept	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.
DE_CONCEPTGROUPS	Decision Engine Concept Groups	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.
DE_CONCEPTTERMS	Decision Engine Concept Terms	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.
DE_EMAILTHREADDIRECTION	Decision Engine Thread Direction	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.
DE_EMAILTHREADID	Decision Engine Email Threads	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.
DE_EMAILTHREADISINCLUSIVE	Decision Engine Inclusive Thread	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.
DE_EMAILTHREADNUMITEMS	Decision Engine Thread Document Count	EMAILTHREADNUMITEMS	Indicates the number of total items within the thread (all emails and attachments).
DE_NDFAMILYID	Decision Engine Family ID	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.
DE_NDNUMCHARS	Decision Engine Number of Characters	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.
DE_NDPARENT	Decision Engine Near Duplicate Parent	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.
DE_NDSIMILARITY	Decision Engine Similarity Score	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.
DE_QUERY	Decision Engine Queries	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.
DE_TAGS	Decision Engine 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.
DECRYPTED	Decrypted	DECRYPTED	If the file was decrypted within Discovery Manager, the value will be TRUE.
DELIVERYREPORTREQ	Delivery Report Requested	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
DM_DUPEID	Discovery Manager Dupe ID	TVDUPEID	The Discovery Manager duplicate identifier. Only populated with the TVFILEID of the original file if the file is a duplicate within the system.
DM_IMPORTQCCOMMENT	Discovery Manager QC Comments	IMPORTQCCOMMENT	The Import QC comment applied to the file when the file was moved to QC Cleared by the user.
DM_INDEXSTATUS	Processing Index Status	INDEXSTATUS	The Discovery Manager Index status of the file. This can only be one value.
DM_ISREDACTED	Is Redacted	ISREDACTED	If redacted images were imported for the file, this field will be populated as TRUE.
DM_PARENTID	Discovery Manager Parent ID	TVPARENTID	The Discovery Manager parent identifier. Only populated for attachments, archive children, and embedded objects with the TVFILEID of the parent item.
DM_PROJECTNAME	Project Name	PROJECTNAME	Name of the project.
DOCUMENT_AUTHOR	Document Author	EFILELASTAUTHOR	Last Author of the efile extracted from the file’s metadata.
DOCUMENT_NAME	Document Name	EMPTYFIELD	Blank field.
DOCUMENT_RECEIVED_BY	Document Received By	EMPTYFIELD	Blank field.
DOCUMENT_TYPE_DESC	App Name	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.
DOMAINS	Sender Recipient Domains	DOMAINS	Sender and Recipient domains combined into one field. Where applicable.
DUPEPATHS	Duplicate Document Path	DUPEPATHS	Only populated on original items. This will contain the RelativePathParent(s) for all duplicate files separated by a semicolon. This will not include the original file’s RelativePathParent.
DUPEPATHSWITHORIG	Duplicate Document Path Include Orig	DUPEPATHSWITHORIG	This field is the same as DUPEPATHS 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 DUPEPATHS field. However, in the DUPEPATHSWITHORG field in this example, the original Custodian’s RelativePathParent would be populated.
EFILETITLE	Application File Title	EFILETITLE	Title of the efile extracted from the file’s metadata.
EMAIL_UNREAD	Email Unread	EMAILREADSTATUS	Read status of the email.
EMAILADDRESSESALL	All Addresses	EMAILADDRESSESALL	All Email address fields (Sender and Recipients) of the email combined in one field.
EMAILDATERECEIVED	Email Date Received	EMAILDATERECEIVED	Date Received of the email.
EMAILDATETIMERECEIVED	Email Datetime Received	EMAILDATETIMERECEIVED	Date Received date and time of the email combined in one field.
EMAILFOLDER	Email Folder	EMAILFOLDER	Folder where the email item originated. Populated on parent emails only.
EMAILINTFILEPATH	Email Internal File Path	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
EMAILITEMTYPE	Email Item Type	EMAILITEMTYPE	The item type of the email according to native application.
EMAILPRIORITY	Email Priority	EMAILPRIORITY	Priority of the email.
EMAILSENSITIVITY	Email Sensitivity	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.
EMAILTIMERECEIVED	Email Time Received	EMAILTIMERECEIVED	Time Received of the email.
EMAILTRANSPORTHEADERS	Email Header	EMAILTRANSPORTHEADERS	Email Transport Header of the email; only applies to Microsoft email.
ENCRYPTED	Encrypted	ENCRYPTED	If the file is encrypted, the value will be TRUE.
ENDATTACH	End Number Attach	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.
ENDBATES	End Bates	BATESEND	Ending bates number of the file.
ENDBATESATTACH	End Bates Attach	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.
ENDDOC	End Number	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.
ENTRY_ID	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.
EXCEPTION_TYPE	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.
EXIFLATITUDE	EXIF Latitude	EXIFLATITUDE	Image origin global position latitude dimension.
EXIFLONGITUDE	EXIF Longitude	EXIFLONGITUDE	Image origin global position longitude dimension.
EXPORTED_NATIVE_FILE	Exported Native File	NATIVEFILE	Full file path to the deliverable native file.
EXPORTEDFILEEXT	Exported File Extension	FILEEXT	Exported extension of the file. For example, if an MSG file is exported as an MHT file, this field would read MHT.
EXPORTFILESIZE	File Size (Exported) in bytes	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.
FAMILYRANGE	Family Range	FAMILYRANGE	BEGATTACH-ENDATTACH.
FILE_EXTENSION	Extension	ORIGFILEEXT	Original extension of the file. For example, if an MSG file is exported as an MHT file, this field would read MSG.
FILE_SIZE	File Size (Kb)	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.
FILEIDCHILDLIST	File ID Child List	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.
FILEIDPARENTID	Exported Parent ID	FILEIDPARENTID	Populated for children with the exported FileID of the corresponding parent item.
FILESIZE	File Size (bytes)	EXPORTFILESIZE	Size of the original file in bytes.
FILESIZEKB	File Size in Kb	EXPORTFILESIZEKB	Size of the original file in kilobytes.
FILTERING_EFFECTIVE_HIT	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.
FOREIGN_LANGUAGES	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.
HASEMBEDDEDOBJECTS	Has Embedded Objects	HASEMBEDDEDOBJECTS	If the file has an embedded object(s), the value will be TRUE.
HASHIDDENCONTENT	Has Hidden Content	HASHIDDENCONTENT	If the file has Hidden Content, the value will be TRUE.
HASPATTERN	Has Pattern	HASPATTERN	If the file matches at least 1 pattern, the value will be true.
HIDDENCONTENT	Hidden Content	HIDDENCONTENT	The Hidden Content of the file. If the file contains several Hidden Content values, the values will be separated with a semicolon.
IMAGEMANUAL	Image Manual	IMAGEMANUAL	If the file was manually imaged within QC, this field will be populated as TRUE.
IMAGEPLACEHOLDER	Image Place Holder	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.
IMAGEQCCOMMENT	Image QC Comment	IMAGEQCCOMMENT	Displays the QC Comment of the file if the file was moved to QC Cleared and a comment was applied within QC.
IMAGESTATUS	Image Status	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.
IMPORTPATH	Import Path	IMPORTPATH	Original path of the associated file with the file name.
IS_EXCEPTION	Exception	EMPTYFIELD	Blank field.
IS_FOREIGN_LANGUAGE	Foreign Language	EMPTYFIELD	Blank field.
IS_PRODUCED	Produced	EMPTYFIELD	Blank field.
ISADUPLICATE	Is A Duplicate	ISDUPLICATE	If the file is duplicate: TRUE; If the file is not duplicate: FALSE.
ISEMBEDDEDOBJECT	Embedded Object	ISEMBEDDEDOBJECT	If the file is an embedded object, the value will be TRUE.
ISPARENT	Is Parent	ISPARENT	All efiles and parent emails will be populated with TRUE. Attachments and embedded objects will be populated with FALSE.
ITEMID	Item ID	No Field	Reveal Unique Identifier. Auto generated upon record load.
LANGUAGE	Detected Languages	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.
LANGUAGECHAR	Language Character Count	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.
LAST_ACCESS_DATE	OS Last Access Date	OSLASTACCESSEDDATE	File system last accessed date.
LAST_ACCESS_TIME	OS Last Access Time	OSLASTACCESSEDTIME	File system last accessed time.
LAST_MODIFIED_DATE	OS Saved Date	OSLASTMODDATE	File system last modified date.
LAST_MODIFIED_TIME	OS Saved Time	OSLASTMODTIME	File system last modified time.
LAST_PRINTED_DATE	Last Printed Date	METALASTPRINTDATE	Metadata last printed date where applicable.
LAST_PRINTED_TIME	Last Printed Time	METALASTPRINTTIME	Metadata last printed time where applicable.
LAST_SAVED_DATE	Application Last Saved Date	METALASTMODDATE	Metadata last modified date where applicable.
LAST_SAVED_TIME	Application Last Saved Time	METALASTMODTIME	Metadata last modified time where applicable.
MASTERDATE	Master Date	MASTERDATE	Efiles = Last Modified Date; Email & Attachment = Date Sent of parent email. This field is used for the date restrictions within Discovery Manager.
MASTERDATETIME	Master Date Time	MASTERDATETIME	MASTERDATE and MASTERTIME combined into one field.
MASTERTIME	Master Time	MASTERTIME	Efiles = Last Modified Time; Email & Attachment = Time Sent of parent email.
MD5_HASH	Duplicate ID	MD5HASH	The MD5 Hash of the file.
MEDIADESCRIPTION	Media Description	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.
MEDIAMANUFACTURER	Media Manufacturer	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.
MEDIAMODEL	Media Model	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.
MEDIASERIAL	Media Serial Number	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.
MESSAGE_ID	Internet Message ID	EMAILINTMESSAGEID	Internet Message ID of the email; only applies to Microsoft email.
MSGNO	Message Number	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
NAME	File Name	FILENAME	Original file name of the file.
OCR_PATH	Ocr Path	TEXTFILE	Full file path to the deliverable text file.
OS_CREATED_DATETIME	OS Creation Date/Time	OSCREATEDDATETIME	File system created date and time combined in one field.
OS_LASTACCESS_DATETIME	OS Last Access Date/Time	OSLASTACCESSEDDATETIME	File system last accessed date and time combined in one field.
OS_LASTMOD_DATETIME	OS Saved Date/Time	OSLASTMODDATETIME	File system last modified date and time combined in one field.
PAGE_COUNT	Page Count	IMAGEPAGECOUNT	Total number of images exported.
PARENT_ITEMID	Parent ID	No Field	Review internal family identifier. Auto generated upon family build.
PARENTCHILDDOCID	Parent Child Document ID	EMPTYFIELD	Blank field.
PARENTCHILDMD5	Parent Child Document MD5	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.
PATTERNNAME	Pattern Name	PATTERNNAME	The Pattern Names of the file. If there are multiple Patterns responsive to the file, the values will be separated with a semicolon.
PDF_PATH	Native PDF File	PDFEXPORTPATH	Processing export path for Native PDF Files.
PROCESSED_DATE	Processed Date	PROCESSEDDATE	Date of processing for reporting purposes.
PROJECTPATH	Project Path	PROJECTPATH	File path to the native file stored in the project’s Processing Folder.
RECEIVED_DATE	Date Received	EMAILDATERECEIVED	Date Received of the email.
RECEIVED_TIME	Time Received	EMAILTIMERECEIVED	Time Received of the email.
RECIPIENT	To	TO	Recipient(s) of the email.
RECIPIENTCOUNT	Recipient Count	RECIPIENTCOUNT	Total number of recipients of the email.
RELATIVE_PATH	Folder	RELATIVEPATH	Original path of the associated file without the file name.
RELATIVENATIVEFILE	Exported Relative Native File	RELATIVENATIVEFILE	Relative file path to the deliverable native file.
RELATIVEPATHPARENT	Relative Path Parent	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.
RELATIVETEXTFILE	Exported Relative Text File	RELATIVETEXTFILE	Relative file path to the deliverable text file.
SENDER	From	FROM	Sender of the email.
SENT_DATE	Date Sent	DATESENT	Date Sent of the email.
SENT_TIME	Time Sent	TIMESENT	Time Sent of the email.
SENTONBEHALFOF	Sent on Behalf of	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.
SOURCE	Source	ARCHIVESTORE	Name of email archive (PST/OST/NSF) and non email archive (ZIP/RAR etc.) from which the file was extracted.
SUBJECT	Subject	SUBJECT	Edoc subject.
SUBJECT_OTHER	Email Subject	SUBJECT	Email subject.
THREAD_IN_REPLY_TO	Email In-Reply-To	INTREPLYTOID	Email In-Reply-To ID used to pull together email threads.
THREAD_REFERENCES	Email References	INTREFERENCES	Internet references used to pull together email threads.
TIME_CREATED	Application Created Time	METACREATEDTIME	Metadata created time where applicable.
TIME_OTHER	Time	EMPTYFIELD	Blank field.
TIMEZONE	Time Zone	TIMEZONE	Timezone value used when importing scope data.
TVFAMILYID	TV Family ID	TVFAMILYID	The Discovery Manager unique identifier for document families.
TVFILEID	TV FILE ID	TVFILEID	The Discovery Manager unique identifier. Populated for all files.
TYPEDOCUMENT	Type of Document	DOCUMENTTYPE	Efile = EFILE; Parent Email = EMAIL; Attachment/Embedded Object = ATTACHMENT.
TYPEDOCUMENTPARENT	Type of Parent Document	DOCUMENTTYPEPARENT	Efile = EFILE; Parent Email/Attachment/Embedded Object = EMAIL.
UTCOFFSET	UTC Offset	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.
VOLUMENAME	Volume Name	VOLUMENAME	The name of the Volume assigned to the file. This is only populated when using the Enable Volume and Folder Options.
ZANTAZARCHIVEINTERNETRECIPIENTS	Zantaz Recipients (Domino/Notes)	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.
ZANTAZARCHIVEORIGINALFROM	Zantaz Sender	ZANTAZARCHIVEORIGINALFROM	Domino/Notes: Lists the sender of the email item.
ZANTAZARCHIVERECIPIENTS	Zantaz Recipients Expanded	ZANTAZARCHIVERECIPIENTS	Domino/Notes: Provides the same information as ZANTAZARCHIVEORIGINALRECIPIENTS except groups are expanded.
ZANTAZRECIP	Zantaz All Email Recipients (Outlook)	ZANTAZRECIP	Exchange/Outlook: Every recipient on an email thread (i.e. TO, CC, BCC) for Zantaz emails.

Last Update 12/27/2023