Reveal Field Mapping Matrix & Definitions

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 ([email protected]) has granted Bob Doe ([email protected]) 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 ([email protected]) 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.