Field Mapping Matrix & Definitions

AI Document Id

AI_DOCUMENT_ID

-

The identifier in the AI system.

Deprecated

Alert Detail

ALERT_DETAIL

-

List the alerts found for the document that encountered an indexing error.

Active

All Addresses

EMAILADDRESSESALL

EMAILADDRESSESALL

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

All Recipients

ALLRECIPIENTS

RECIPIENTS

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

All Reviewed Profiles

ALL_REVIEWED_PROFILES

-

All Profiles with the reviewed status of this document.

All Reviewed Users

ALL_REVIEWED_USERS

-

All users who reviewed this document.

App Name

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.

Application Category

APP_META_CATEGORY

METACATEGORY

Bucket field containing all efile metadata.

Application Comments

APP_META_COMMENTS

METACOMMENTS

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

Application Created Date

DATE_CREATED

METACREATEDDATE

Metadata created date where applicable.

Application Created Date/Time

APP_CREATED_DATETIME

METACREATEDDATETIME

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

Application Created Time

TIME_CREATED

METACREATEDTIME

Metadata created time where applicable.

Application File Title

EFILETITLE

EFILETITLE

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

Application Keywords

APP_META_KEYWORDS

METAKEYWORDS

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

Application Last Saved Date

LAST_SAVED_DATE

METALASTMODDATE

Metadata last modified date where applicable.

Application Last Saved Date/Time

APP_LASTMOD_DATETIME

METALASTMODDATETIME

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

Application Last Saved Time

LAST_SAVED_TIME

METALASTMODTIME

Metadata last modified time where applicable.

Application Meta Subject

APP_META_SUBJECT

METASUBJECT

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

Application Metadata

APP_METADATA

METADATA

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

Application Revision

APP_META_REVISION

METAREVISION

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

Application Template

APP_META_TEMPLATE

METATEMPLATE

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

Application Type

APPLICATION_TYPE

APPTYPE

Category of application.

Appointment Begin Date

APPTBEGDATE

APPTBEGDATE

Start date of email appointment.

Appointment Begin Date/Time

APPTBEGDATETIME

APPTBEGDATETIME

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

Appointment Begin Time

APPTBEGTIME

APPTBEGTIME

Start time of the email appointment.

Appointment End Date

APPTENDDATE

APPTENDDATE

End date of email appointment.

Appointment End Date/Time

APPTENDDATETIME

APPTENDDATETIME

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

Appointment End Time

APPTENDTIME

APPTENDTIME

End time of the email appointment.

Assigned To

ASSIGNED_TO

-

The user who is assigned the document of the assignment.

Assignment Folder

ASSIGNED_TO_FOLDER

-

The name of the assignment folder of the document

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.

Audio/Video Duration

MEDIA_LENGTH_SECONDS

-

This will apply when a media file is imported and indexed into a project, the related length of the media will be stored, in seconds in a new field called “Audio/Video Duration (Seconds)”.

Author

AUTHOR

EFILEDOCAUTHOR

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

Batch Folders

BATCH_FOLDERS

-

Contains the folder names used for assignment jobs.

Batch ID

BATCHID

EXPORTNAME

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

Bates Child List

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 Family Range

BATESFAMILYRANGE

BATESFAMILYRANGE

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

Bcc

BCC

BCC

An email's "Bcc" field.

BD ClusterPath

CLUSTERPATH

-

The full list of cluster ids to reach the current document. It will start with the root (0) and go out to the RELATEDSETID, then if applicable on to near dup cluster and exact dup cluster. Format: /0/126/133/239/1124/267/7222

BD DupType

DUPTYPE

-

Type of duplicate: Exact, Near

BD EMT AttachmentCount

EMT_ATTACHMENTCOUNT

-

Number of attachments to an email document.

BD EMT DuplicateID

EMT_DUPLICATEID

-

An identifier assigned to documents for the purpose of relating exact duplicates.

BD EMT EmailAction

EMT_EMAILACTION

-

Type of message: Send, Reply, ReplyAll, Forward, or Draft.

BD EMT FamilyID

EMT_FAMILYID

-

Identifier assigned to documents for the purpose of relating emails and their attachments.

BD EMT Intelligent Sort

EMT_THREADSORTHIERDESC

-

is a different way to view an email thread. This field flips the sort order of emails in reverse order so that the final chronological email (or attachment to that email) is first.

BD EMT IsDuplicate

EMT_ISDUPLICATE

-

Specifies if this document is a duplicate: True/False.

BD EMT IsMessage

EMT_ISMESSAGE

-

Specifies if this document is an email: True/False

BD EMT IsUnique

EMT_ISUNIQUE

-

Message is unique, due to the message itself and/or an attachment. (brs_emt_unique_reason details why it is unique.)

BD EMT MessageCt

EMT_MESSAGECOUNT

-

is simply the total number of messages in an email thread. It is only counting the emails and not the attachments, but the attachments inherit the message count value for their parents. So if you search for a threadID you will get all emails plus attachments, but the message count will only match the emails.

BD EMT ThreadHasMissingMessage

EMT_THREADHASMISSINGMESSAGE

-

Email thread has been identified to have a message that is not present in the dataset.

BD EMT ThreadID

EMT_THREADID

-

Identifier assigned to documents for the purpose of relating the content in email threads. All Emails and attachments within the thread will have the same EMT_THREADID

BD EMT ThreadIndent

EMT_THREADINDENT

-

Specifies the display of emails within a tiered system. The original message is assigned a value of 0. All corresponding messages, such as forwards and replies, are staggered beneath the original, stepped in as specified for each "re:" or "fw:" in the email chain.

BD EMT ThreadPath Full

EMT_THREADPATH

-

The list of document ids to lead to the current document in the email chain, using the document keys (Control Number or BegBates). For example, FirstEmailID;SecondEmailID;thirdEmailID might specify a forward of a reply to an original message.

BD EMT ThreadSort

EMT_THREADSORT

-

Allows you to sort documents within an email thread in message order. The list of document ids to lead to the current document in the email chain, using the document keys (Control Number or BegBates).

For example, FirstEmailID;SecondEmailID;ThirdEmailID might specify a forward of a reply to an original message.

BD EMT UniqueReason

EMT_UNIQUEREASON

-

Specifies why the email was flagged as unique: Message, Attach, or Message_and_Attach.

BD EMT WasUnique

EMT_WASUNIQUE

-

Specifies if a document was unique in a previous build, but after incremental build is no longer unique: True/False.

BD EMT WasUniqueReason

EMT_WASUNIQUEREASON

-

Specifies why a document was flagged as unique in a previous build, but after incremental build is no longer unique: Message, Attach, or Message_and_Attach

BD ExactDupSetID

EXACTDUPSETID

-

Identifier assigned to documents for the purpose of relating exact duplicates.

BD ExactDupStatus

EXACTDUPSTATUS

-

Specifies the document’s status as part of an exact duplicate set: ExactOrig, ExactDupe.

BD IsExactPivot

ISEXACTPIVOT

-

Specifies if a document is the ExactOrig pivot in an Exact Duplicate Set: True/False.

BD IsNearDupPivot

ISNEARDUPPIVOT

-

Specifies if a document is the ExactOrig pivot in a near duplicate set: True/False.

BD IsStrictDupPivot

ISSTRICTDUPPIVOT

-

Specifies if a document is the ExactOrig pivot in a strict duplicate set: True/False.

BD Languages

LANGUAGES

-

A list of languages found in a document (according to the language detector).

BD NearDupSetID

NEARDUPSETID

-

Identifier assigned to documents for the purpose of relating near duplicates.

BD NearDupSimilarityScore

NEARDUPSIMILARITYSCORE

-

A document’s degree of similarity to the pivot document of its near duplicate set.

BD NearDupStatus

NEARDUPSTATUS

-

Specifies the document’s status as part of a near duplicate set: NearOrig, NearDupe.

BD Primary Language

PRIMARYLANGUAGE

-

The single most likely and prominent language in a document (according to the language detector).

BD RelatedSetID

RELATEDSETID

-

Specifies the cluster ID in which a related document is contained. The Related Cluster is the one closest to the outside edge that is neither an Exact Dup cluster nor a Near Dup cluster. (The document may also have NearDupSetID and ExactDupSetIDs.)

BD StrictDupSetID

STRICTDUPSETID

-

Identifier assigned to documents for the purpose of relating strict duplicates.

BD StrictDupStatus

STRICTDUPSTATUS

-

Specifies the document’s status as part of a strict duplicate set: StrictOrig, StrictDupe.

BD Summary

SUMMARY

-

Provides a brief summary of the text of each document.

BDID

BDID

-

This is a unique identifier for a document in the Brainspace Cluster Wheel. BDID includes the cluster Path (BD ClusterPath) and the unique value given to each document that identifies the location of that document on the Cluster Wheel.

Begin Bates

BEGBATES

BATESBEG

Beginning bates number of the file.

Begin Bates Attach

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.

Begin Number

BEGDOC

FILEID

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

Begin Number Attach

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.

Brs Has Entity

BRS_HAS_ENTITY

-

Brainspace Entity Report. Specifies if a document contains reference to one or more entities: True/False.

Brs Has Entity Type

BRS_HAS_ENTITY_TYPE

-

Brainspace Entity Report. Specifies the entity that caused the document to be flagged under BRS_HAS_ENTITY: Credit Card Number, Email, Location, Money, Nationality, Organization, Person, Personal ID Number, Phone Number, Product, Religion, Title, URL.

Cc

CC_ADDRESSES

CC

An email's "Cc" field.

Collection Location

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 Source

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.

Color Brightness - 25

COLOR_DETECTION_STATE_25

-

The presence of color state for a document at color luminance 0.25

Color Brightness - 30

COLOR_DETECTION_STATE_30

-

The presence of color state for a document at color luminance 0.30

Color Brightness - 35

COLOR_DETECTION_STATE_35

-

The presence of color state for a document at color luminance 0.35

Color Brightness - 40

COLOR_DETECTION_STATE_40

-

The presence of color state for a document at color luminance 0.40

Color Brightness - 45

COLOR_DETECTION_STATE_45

-

The presence of color state for a document at color luminance 0.45

Color Brightness - 50

COLOR_DETECTION_STATE_50

-

The presence of color state for a document at color luminance 0.50

Company

COMPANY

EFILECOMPANY

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

Confidentiality Designation

TAG_SET_1

-

Tag Set.

CONVERSATION

CONVERSATION

CONVERSATION

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

Conversation Base Index

CONVBASEINDEX

CONVBASEINDEX

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

Conversation ID

CONVERSATION_ID

CONVINDEX

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

Conversation Topic

CONVERSATION_TOPIC

CONVTOPIC

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

CONVERSATION_PARTICIPANTS

CONVERSATIONPARTICIPANTS

CONVERSATIONPARTICIPANTS

RSMF text thread parties.

CONVERSATION_PLATFORM

CONVERSATIONPLATFORM

CONVERSATIONPLATFORM

RSMF text application.

CONVERSATIONID

CONVERSATIONID

CONVERSATIONID

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

CONVERSATIONSLICE_SENDERS

CONVERSATIONSLICESENDERS

CONVERSATIONSLICESENDERS

RSMF thread senders.

Custodian

CUSTODIAN_NAME

CUSTODIAN

Custodian name.

Custodian Title

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.

Custodians (ALL)

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

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.

Date

DATE_OTHER

-

Blank field.

Date Received

RECEIVED_DATE

EMAILDATERECEIVED

Date Received of the email.

Date Sent

SENT_DATE

DATESENT

Date Sent of the email.

Decision Engine Closest Concept

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 Concept Groups

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 Terms

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 Email Threads

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 Family ID

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 Inclusive Thread

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 Near Duplicate Parent

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 Number of Characters

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 Queries

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 Similarity Score

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 Tags

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 Thread Direction

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 Document Count

DE_EMAILTHREADNUMITEMS

EMAILTHREADNUMITEMS

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

Decrypted

DECRYPTED

DECRYPTED

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

Delivery Report Requested

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

Detected Languages

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.

Discovery Manager Dupe ID

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 Parent ID

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 QC Comments

DM_IMPORTQCCOMMENT

IMPORTQCCOMMENT

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

Document Author

DOCUMENT_AUTHOR

EFILELASTAUTHOR

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

Document Contains Images

COLOR_DETECTION_FOUND_IMAGES

-

Are images present for a document

Document Date

DOCUMENTDATE

DOCUMENTDATE

Uses the same hierarchy for population as 'Master Date' but differs in that it DOES NOT pass values down to children. This provides a single date field that consolidates the available dates within a given document to a single value.

Document Id

BRS_KEY

-

Brainspace Sentiment Report

Document Name

DOCUMENT_NAME

-

Blank field.

Document Received By

DOCUMENT_RECEIVED_BY

-

Blank field.

Duplicate Collection Location

DUPLICATE_COLLECTIONLOCATION

DUPLICATE_COLLECTIONLOCATION

All collection locations combined into one field. The collection location is captured when assigning data to a custodian in Discovery Manager’s Custodians Module. This can be changed after data assignment by unassigning the data from the Custodian and applying it properly when assigning the data to the Custodian again.

Duplicate Collection Source

DUPLICATE_COLLECTIONSOURCE

DUPLICATE_COLLECTIONSOURCE

All collection sources combined into one field. Collecton sources are captured when assigning data to a Custodian in Discovery Manager’s 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.

Duplicate Document Path

DUPEPATHS

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.

Duplicate Document Path Include Orig

DUPEPATHSWITHORIG

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.

Duplicate ID

MD5_HASH

MD5HASH

The MD5 Hash of the file.

Duplicate Job Name

DUPLICATE_JOB_NAME

DUPLICATE_JOB_NAME

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

EDRM Message ID Hash

EDRM_MIH

-

EDRM promoted message ID

EDRM_MSGID

EDRM_MSGID

EDRM_MSGID

Identifies the name of the job associated with a duplicate copy of a document.

Email Date Received

EMAILDATERECEIVED

EMAILDATERECEIVED

Date Received of the email.

Email Datetime Received

EMAILDATETIMERECEIVED

EMAILDATETIMERECEIVED

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

Email Folder

EMAILFOLDER

EMAILFOLDER

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

Email Header

EMAILTRANSPORTHEADERS

EMAILTRANSPORTHEADERS

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

Email In-Reply-To

THREAD_IN_REPLY_TO

INTREPLYTOID

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

Email Internal File Path

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 Item Type

EMAILITEMTYPE

EMAILITEMTYPE

The item type of the email according to native application.

Email Priority

EMAILPRIORITY

EMAILPRIORITY

Priority of the email.

Email References

THREAD_REFERENCES

INTREFERENCES

Internet references used to pull together email threads.

Email Sensitivity

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 Subject

SUBJECT_OTHER

DOCDISPLAYNAME

Populates with the subject of the email if the document is an email. If it’s not an email, it populates with the document name / file name.

Email Time Received

EMAILTIMERECEIVED

EMAILTIMERECEIVED

Time Received of the email.

Email Unread

EMAIL_UNREAD

EMAILREADSTATUS

Read status of the email.

Embedded Object

ISEMBEDDEDOBJECT

ISEMBEDDEDOBJECT

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

Emotional Intelligence Status Message

_EMS_STATUS_MESSAGE

-

Brainspace Emotional Intelligence Report

Encrypted

ENCRYPTED

ENCRYPTED

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

End Bates

ENDBATES

BATESEND

Ending bates number of the file.

End Bates Attach

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 Number

ENDDOC

-

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

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.

Entity Count

ENTITY_COUNT

-

Total number of documents found in all the entity clusters.

ENTITY_COUNT_UNIQUE

-

Number of documents containing entity count that is not contained in any other message in the entity cluster.

Entity Email

ENTITY_EMAIL

-

A sequence of characters that appear to be legitimate email addresses.

Entity Email Count

ENTITY_EMAIL_COUNT

-

Number of emails found in the entity cluster.

Entity Email Count Unique

ENTITY_EMAIL_COUNT_UNIQUE

-

Number of emails containing content that is not contained in any other message in the entity cluster.

Entity Location Count

ENTITY_LOCATION_COUNT

-

Number of documents found in the entity cluster.

Entity Location Count Unique

ENTITY_LOCATION_COUNT_UNIQUE

-

Number of documents containing content that is not contained in any other message in the entity cluster.

Entity Money

ENTITY_MONEY

-

A sequence of symbols, numbers and/or words that are detected as referencing money.

Entity Money Count

ENTITY_MONEY_COUNT

-

Number of documents found in the entity cluster.

Entity Money Count Unique

ENTITY_MONEY_COUNT_UNIQUE

-

Number of documents containing content that is not contained in any other message in the entity cluster.

Entity Nationality

ENTITY_NATIONALITY

-

Reference to a country or region of origin, such as American or Swiss.

Entity Nationality Count

ENTITY_NATIONALITY_COUNT

-

Number of documents found in the entity cluster.

Entity Nationality Count Unique

ENTITY_NATIONALITY_COUNT_UNIQUE

-

Number of documents containing content that is not contained in any other message in the entity cluster.

Entity Organization

ENTITY_ORGANIZATION

-

A corporation, institution, government agency, or other group of people defined by an established organizational structure.

Entity Organization Count

ENTITY_ORGANIZATION_COUNT

-

Number of documents found in the entity cluster.

Entity Organization Count Unique

ENTITY_ORGANIZATION_COUNT_UNIQUE

-

Number of documents containing content that is not contained in any other message in the entity cluster.

Entity Person

ENTITY_PERSON

-

A human identified by name, nickname, or alias.

Entity Person Count

ENTITY_PERSON_COUNT

-

Number of documents found in the entity cluster.

Entity Person Count Unique

ENTITY_PERSON_COUNT_UNIQUE

-

Number of documents containing content that is not contained in any other message in the entity cluster.

Entity Personal Id Num

ENTITY_PERSONAL_ID_NUM

-

A series of digits in a pattern detected as a national or well-known personal identifier.

Entity Personal Id Num Count

ENTITY_PERSONAL_ID_NUM_COUNT

-

Number of documents found in the entity cluster.

Entity Personal Id Num Count Unique

ENTITY_PERSONAL_ID_NUM_COUNT_UNIQUE

-

Number of documents containing content that is not contained in any other message in the entity cluster.

Entity Phone Number

ENTITY_PHONE_NUMBER

-

A series of digits in a pattern detected as a phone number.

Entity Phone Number Count

ENTITY_PHONE_NUMBER_COUNT

-

Number of documents found in the entity cluster.

Entity Phone Number Count Unique

ENTITY_PHONE_NUMBER_COUNT_UNIQUE

-

Number of documents containing content that is not contained in any other message in the entity cluster.

Entity Product

ENTITY_PRODUCT

-

Reference to a commercially available product.

Entity Product Count

ENTITY_PRODUCT_COUNT

-

Number of documents found in the entity cluster.

Entity Product Count Unique

ENTITY_PRODUCT_COUNT_UNIQUE

-

Number of documents containing content that is not contained in any other message in the entity cluster.

Entity Religion

ENTITY_RELIGION

-

Reference to an organized religion or theology as well as its followers.

Entity Religion Count

ENTITY_RELIGION_COUNT

-

Number of documents found in the entity cluster.

Entity Religion Count Unique

ENTITY_RELIGION_COUNT_UNIQUE

-

Number of documents containing content that is not contained in any other message in the entity cluster.

Entity Title

ENTITY_TITLE

-

Appellation associated with a person by virtue of occupation, office, birth, or as an honorific.

Entity Title Count

ENTITY_TITLE_COUNT

-

Number of documents found in the entity cluster.

Entity Title Count Unique

ENTITY_TITLE_COUNT_UNIQUE

-

Number of documents containing content that is not contained in any other message in the entity cluster.

Entity Url

ENTITY_URL

-

Web address.

Entity Url Count

ENTITY_URL_COUNT

-

Number of documents found in the entity cluster.

Entity Url Count Unique

ENTITY_URL_COUNT_UNIQUE

-

Number of documents containing content that is not contained in any other message in the entity cluster.

Entity Credit Card Num

ENTITY_CREDIT_CARD_NUM

-

A sequence of numbers that are detected as patterns used by the major credit card providers.

Entity Credit Card Num Count

ENTITY_CREDIT_CARD_NUM_COUNT

-

Number of documents found in the entity cluster.

Entity Credit Card Num Count Unique

ENTITY_CREDIT_CARD_NUM_COUNT_UNIQUE

-

Number of documents containing credit card number that is not contained in any other message in the entity cluster.

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

IS_EXCEPTION

-

Blank field.

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.

EXIF Latitude

EXIFLATITUDE

EXIFLATITUDE

Image origin global position latitude dimension.

EXIF Longitude

EXIFLONGITUDE

EXIFLONGITUDE

Image origin global position longitude dimension.

Exolution Cluster ID

EXO_CLUSTERID

-

Assigns identifiers to each document cluster.

Exolution Error

EXO_ERROR

-

Logs error information when a document fails to add to Exolution or fails to create a redacted file.

Exolution File Locked

EXO_FILE_LOCKED

-

Indicates whether or not a document is locked.

Exolution File Version

EXO_FILE_VERSION

-

Stores the redacted file version when the user chooses the Separate Redacted Document option .

Exolution Flattening Status

EXO_FLATTENING_STATUS

-

Flattening Status.

Exolution Freeze Redaction

EXO_FREEZE_REDACTION

-

Stores the type of freeze applied to the document. Empty if no redaction freeze is applied.

Exolution Has Redactions

EXO_HAS_REDACTIONS

-

If this has value Yes then the document has redaction.

Exolution Last Redaction Modified By

EXO_LAST_REDACTION_MODIFIED_BY

-

Stores the name of the user who last created or deleted a redaction

Exolution Last Redaction Modified Date

EXO_LAST_REDACTION_MODIFIED_DATE

-

Stores date-time when last time redaction was added or deleted.

Exolution Original Document

EXO_ORIGINAL_DOC

-

Stores the type of freeze applied to the document. Empty if no redaction freeze is applied.

Exolution Processing Status

EXO_PROCESSING_STATUS

-

Any value other than Success = The Add to Exolution has failed for that document.

Exolution Redacted File Created

EXO_REDACTED_FILE_CREATED

-

Indicates whether or not a redacted file is created for the document.

Exolution Redacted File Created Date

EXO_REDACTED_FILE_CREATED_DATE

-

Stores date-time when the last time a redacted file is created for the document.

Exolution Redacted File Current

EXO_REDACTED_FILE_CURRENT

-

A flag that indicates whether or not any redactions are changed in a document after a redacted file is created last time.

Exolution Redacted Group ID

EXO_REDACTED_GROUPID

-

Stores the artifact id of the original unredacted document for the unredacted documents and their redacted copies.

Exolution Redaction Burn Status

EXO_REDACTION_BURN_STATUS

-

Redaction burn status.

Exolution Redaction List

EXO_REDACTION_LIST

-

A list of the redaction applied on the document.

Exolution Redaction Type

EXO_REDACTION_TYPE

-

Exolution Redaction Type.

Exolution Review Complete

EXO_REVIEW_COMPLETE

-

Indicates whether or not the document is marked reviewed.

Exported File Extension

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 Native File

EXPORTED_NATIVE_FILE

NATIVEFILE

Full file path to the deliverable native file.

Exported Parent ID

FILEIDPARENTID

FILEIDPARENTID

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

Exported Relative Native File

RELATIVENATIVEFILE

RELATIVENATIVEFILE

Relative file path to the deliverable native file.

Exported Relative Text File

RELATIVETEXTFILE

RELATIVETEXTFILE

Relative file path to the deliverable text file.

Extension

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.

Family Range

FAMILYRANGE

FAMILYRANGE

BEGATTACH-ENDATTACH.

Family Relationship

FAMILY_RELATIONSHIP

-

Relationship to other documents.

File ID Child List

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 Name

NAME

FILENAME

The original file name of the file. However, for emails exclusively, files are named [email subject].msg. This only affects metadata values and does not impact actual file names written to disk/S3 or stored paths.

Any emails with this field populated prior to 2026.3 will have the format GUID_[email subject].msg.

File Size (bytes)

FILESIZE

EXPORTFILESIZE

Size of the original file in bytes.

File Size (Exported) in bytes

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 (Kb)

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 in Kb

FILESIZEKB

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.

Filtering Keywords

FILTERING_KEYWORDS

SEARCHGROUPS

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

First Reviewed By

FIRST_REVIEWED_BY

-

Field displaying first user to review the document.

First Reviewed On Date

FIRST_REVIEWED_ON_DATE

-

Field displaying the date the document was first reviewed.

First Reviewed On Time

FIRST_REVIEWED_ON_TIME

-

Field displaying the time the document was first reviewed.

First Reviewed Profile

FIRST_REVIEWED_PROFILE

-

Field displaying first tag profile used to review the document.

Folder

RELATIVE_PATH

RELATIVEPATH

Original path of the associated file without the file name.

Foreign Language

IS_FOREIGN_LANGUAGE

-

This field indicates whether the document is foreign.

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.

From

SENDER

FROM

Sender of the email.

Has Alert

ALERT

-

The field indicates an indexing alert detail with the details in the alert detail field.

Has Alerts

alerts

-

This is a Review icon- Has alerts. Yes/No field that indicates if there are any alerts. Alerts include revisions, hidden data, comments, or linked comments

Has Annotations

annotations

-

This is a Review icon- Has Annotations and in the annotations filter. This field includes if any of the following is set: Has Free Hand, Has Highlights, Has Notes, Has PDF Redactions, Has Redactions, Has Spreadsheet, Redactions, Has Sticky Notes or Has Text Annotations.

Has Embedded Objects

HASEMBEDDEDOBJECTS

HASEMBEDDEDOBJECTS

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

Has Hidden Content

HASHIDDENCONTENT

HASHIDDENCONTENT

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

Has Pattern

HASPATTERN

HASPATTERN

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

Has Text Annotations

text_annotations

-

This is the ID that is assigned to the text annotations. This field is created by store procedure creating in a temporary table.

HASEMOJI

HASEMOJI

-

HASEMOJI.

Hidden Content

HIDDENCONTENT

HIDDENCONTENT

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

Image Labels

IMAGE_LABELS

-

All of the labels for an image.

Image Labels Over 55

IMAGE_LABELS_OVER_55

-

Image Labels with a confidence over 55.

Image Labels Over 60

IMAGE_LABELS_OVER_60

-

Image Labels with a confidence over 60.

Image Labels Over 65

IMAGE_LABELS_OVER_65

-

Image Labels with a confidence over 65.

Image Labels Over 70

IMAGE_LABELS_OVER_70

-

Image Labels with a confidence over 70.

Image Labels Over 75

IMAGE_LABELS_OVER_75

-

Image Labels with a confidence over 75.

Image Labels Over 80

IMAGE_LABELS_OVER_80

-

Image Labels with a confidence over 80.

Image Labels Over 85

IMAGE_LABELS_OVER_85

-

Image Labels with a confidence over 85.

Image Labels Over 90

IMAGE_LABELS_OVER_90

-

Image Labels with a confidence over 90.

Image Labels Over 95

IMAGE_LABELS_OVER_95

-

Image Labels with a confidence over 95.

Image Labels Under 60

IMAGE_LABELS_UNDER_60

-

Image Labels with a confidence under 60.

Image Labels Under 65

IMAGE_LABELS_UNDER_65

-

Image Labels with a confidence under 65.

Image Labels Under 70

IMAGE_LABELS_UNDER_70

-

Image Labels with a confidence under 70.

Image Labels Under 75

IMAGE_LABELS_UNDER_75

-

Image Labels with a confidence under 75.

Image Labels Under 80

IMAGE_LABELS_UNDER_80

-

Image Labels with a confidence under 80.

Image Labels Under 85

IMAGE_LABELS_UNDER_85

-

Image Labels with a confidence under 85.

Image Labels Under 90

IMAGE_LABELS_UNDER_90

-

Image Labels with a confidence under 90.

Image Labels Under 95

IMAGE_LABELS_UNDER_95

-

Image Labels with a confidence under 95.

Image Manual

IMAGEMANUAL

IMAGEMANUAL

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

Image Place Holder

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 QC Comment

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 Status

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.

Import Path

IMPORTPATH

IMPORTPATH

Original path of the associated file with the file name.

Intent

_EMS_INTENT_SCORE

-

Analytic score for intentionality of document language. This is from Brainspace Emotional Intelligence Report.

Internet Message ID

MESSAGE_ID

EMAILINTMESSAGEID

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

Is A Duplicate

ISADUPLICATE

ISDUPLICATE

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

Is Parent

ISPARENT

ISPARENT

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

Is Redacted

DM_ISREDACTED

ISREDACTED

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

Item ID

ITEMID

TVFILEID

Reveal’s unique numeric ID of the document. Auto generated upon record load.

Job Name

JOB_NAME

EXPORTNAME

The Job Name field allows users to provide a unique identifier for their data processing tasks, whether it's submitting an import job in Discovery Manager or creating an upload job in the Web Uploader. It helps to map and track uploader job names from Processing. This multi-value text field supports large cases with documents appearing in multiple imports and helps efficiently identify job-related metadata during searches.

Language Character Count

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.

Last Document Action

LAST_DOCUMENT_ACTION

-

Last Document Type

Last Printed Date

LAST_PRINTED_DATE

METALASTPRINTDATE

Metadata last printed date where applicable.

Last Printed Date/Time

APP_LASTPRINTED_DATETIME

METALASTPRINTDATETIME

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

Last Printed Time

LAST_PRINTED_TIME

METALASTPRINTTIME

Metadata last printed time where applicable.

Last Reviewed By

LAST_REVIEWED_BY

-

Field displaying most recent user to review the document.

Last Reviewed On Date

LAST_REVIEWED_ON_DATE

-

Field displaying the date the document was last reviewed.

Last Reviewed On Time

LAST_REVIEWED_ON_TIME

-

Field displaying the time the document was last reviewed.

Last Reviewed Profile

LAST_REVIEWED_PROFILE

-

Field displaying most recent tag profile used to review the document.

Master Date

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 Time

MASTERDATETIME

MASTERDATETIME

MASTERDATE and MASTERTIME combined into one field.

Master Time

MASTERTIME

MASTERTIME

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

Media Description

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 Manufacturer

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 Model

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 Serial Number

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.

Message Number

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

Native PDF File

PDF_Path

PDFEXPORTPATH

Processing export path for Native PDF Files.

Native Spreadsheet View Path

SPREADSHEET_PATH

-

Path to spreadsheet converted for viewer.

Native View Page Count

NATIVE_VIEW_PAGE_COUNT

-

Page count of converted native view PDF.

Native View Path

NATIVE_VIEW_PATH

-

Path to document converted to PDF, AV or spreadsheet.

Negative Snippets

_EMS_NEGATIVE_SNIPPETS

-

Excerpt of document containing negative language. This is from Brainspace Sentiment Report.

Negativity

_EMS_NEGATIVITY_SCORE

-

Analytic score for negativity of document language. This is from Brainspace Sentiment Report.

Notes

NOTES

-

Notes.

Ocr Flag

OCR_FLAG

-

Ocr Flag.

Ocr Path

OCR_PATH

TEXTFILE

Full file path to the deliverable text file.

Opportunity

_EMS_OPPORTUNITY_SCORE

-

Analytic score for the opportunity of document language. This is from the Brainspace Emotional Intelligence Report.

OS Creation Date

CREATION_DATE

OSCREATEDDATE

File system created date.

OS Creation Date/Time

OS_CREATED_DATETIME

OSCREATEDDATETIME

File system created date and time combined in one field.

OS Creation Time

CREATION_TIME

OSCREATEDTIME

File system created time.

OS Last Access Date

LAST_ACCESS_DATE

OSLASTACCESSEDDATE

File system last accessed date.

OS Last Access Date/Time

OS_LASTACCESS_DATETIME

OSLASTACCESSEDDATETIME

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

OS Last Access Time

LAST_ACCESS_TIME

OSLASTACCESSEDTIME

File system last accessed time.

OS Saved Date

LAST_MODIFIED_DATE

OSLASTMODDATE

File system last modified date.

OS Saved Date/Time

OS_LASTMOD_DATETIME

OSLASTMODDATETIME

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

OS Saved Time

LAST_MODIFIED_TIME

OSLASTMODTIME

File system last modified time.

Page Count

PAGE_COUNT

IMAGEPAGECOUNT

Total number of images exported.

Parent Child Document ID

PARENTCHILDDOCID

-

Blank field.

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.

Parent ID

PARENT_ITEMID

TVFAMILYID

Review internal family identifier. Auto generated upon family build.

Pattern Name

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.

Positive Snippets

_EMS_POSITIVE_SNIPPETS

-

Excerpt of document containing positive language. This is from the Brainspace Sentiment Report.

Positivity

_EMS_POSITIVITY_SCORE

-

Analytic score for positivity of document language. This is from the Brainspace Sentiment Report.

Pressure

_EMS_PRESSURE_SCORE

-

Analytic score for pressure of document language. This is from the Brainspace Emotional Intelligence Report.

Previous Begin Numbers

PREVIOUS_BEGIN_NUMBERS

-

Contains previous document begin numbers that were replaced by a re-numbering job.

Privilege Reason

TAG_SET_4

-

Tag Set.

Privileged

TAG_SET_2

-

Tag Set.

Processed Date

PROCESSED_DATE

PROCESSEDDATE

Date of processing for reporting purposes.

Processing Index Status

DM_INDEXSTATUS

INDEXSTATUS

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

Produced

IS_PRODUCED

-

Y/N field to indicate if the field has been produced. This field is updated during the database update.

Production Jobs

PRODUCTION_JOBS

-

Contains the production jobs names used for update jobs.

Production Number Range

PRODNUMRANGE

-

Contains the production number range.

Production Page Count

PRODUCTION_PAGE_COUNT

-

The page count after production job.

Project Name

DM_PROJECTNAME

PROJECTNAME

Name of the project.

Project Path

PROJECTPATH

PROJECTPATH

File path to the native file stored in the project’s Processing Folder.

Rationalization

_EMS_RATIONALIZATION_SCORE

-

Analytic score for rationalization in document language. This is from the Brainspace Emotional Intelligence Report.

Raw Transcription

RAW_TRANSCRIPTION

-

The default Audio/Video Transcription text set load file field.

Read Receipt Requestted

READRECEIPTREQ

READRECEIPTREQ

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

Recipient Count

RECIPIENTCOUNT

RECIPIENTCOUNT

Total number of recipients of the email.

Relative Path Parent

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.

Relevance

RELEVANCE

-

Search Relevance.

Responsiveness

TAG_SET_3

-

Tag Set.

Rev Arc From Bcc

REV_ARC_FROM_BCC

-

Brainspace Communicators Graph Viz Report.

Rev Arc From Cc

REV_ARC_FROM_CC

-

Brainspace Communicators Graph Viz Report.

Rev Arc From Cc Bcc

REV_ARC_FROM_CC_BCC

-

Brainspace Communicators Graph Viz Report.

Rev Arc From To

REV_ARC_FROM_TO

-

Brainspace Communicators Graph Viz Report.

Rev Arc From To Bcc

REV_ARC_FROM_TO_BCC

-

Brainspace Communicators Graph Viz Report.

Rev Arc From To Cc

REV_ARC_FROM_TO_CC

-

Brainspace Communicators Graph Viz Report.

Rev Arc From To Cc Bcc

REV_ARC_FROM_TO_CC_BCC

-

Brainspace Communicators Graph Viz Report.

Rev Bcc

REV_BCC

-

Brainspace Communicators Report.

Rev Bcc Comm Id

REV_BCC_COMM_ID

-

Brainspace Normalized Communicators Report.

Rev Bcc Count

REV_BCC_COUNT

-

Brainspace Communicators Report.

Rev Bcc Domain

REV_BCC_DOMAIN

-

Brainspace Communicators Report.

Rev Bcc Domain Count

REV_BCC_DOMAIN_COUNT

-

Brainspace Communicators Report.

Rev Bcc Person Id

REV_BCC_PERSON_ID

-

Brainspace Normalized Communicators Report.

Rev Cc

REV_CC

-

Brainspace Communicators Report.

Rev Cc Comm Id

REV_CC_COMM_ID

-

Brainspace Normalized Communicators Report.

Rev Cc Count

REV_CC_COUNT

-

Brainspace Communicators Report.

Rev Cc Domain

REV_CC_DOMAIN

-

Brainspace Communicators Report.

Rev Cc Domain Count

REV_CC_DOMAIN_COUNT

-

Brainspace Communicators Report.

Rev Cc Person Id

REV_CC_PERSON_ID

-

Brainspace Normalized Communicators Report.

Rev Domain

REV_DOMAIN

-

Brainspace Communicators Report.

Rev Domain Arc From Bcc

REV_DOMAIN_ARC_FROM_BCC

-

Brainspace Communicators Graph Viz Report.

Rev Domain Arc From Cc

REV_DOMAIN_ARC_FROM_CC

-

Brainspace Communicators Graph Viz Report.

Rev Domain Arc From Cc Bcc

REV_DOMAIN_ARC_FROM_CC_BCC

-

Brainspace Communicators Graph Viz Report.

Rev Domain Arc From To

REV_DOMAIN_ARC_FROM_TO

-

Brainspace Communicators Graph Viz Report.

Rev Domain Arc From To Bcc

REV_DOMAIN_ARC_FROM_TO_BCC

-

Brainspace Communicators Graph Viz Report.

Rev Domain Arc From To Cc

REV_DOMAIN_ARC_FROM_TO_CC

-

Brainspace Communicators Graph Viz Report.

Rev Domain Arc From To Cc Bcc

REV_DOMAIN_ARC_FROM_TO_CC_BCC

-

Brainspace Communicators Graph Viz Report.

Rev Domain Count

REV_DOMAIN_COUNT

-

Brainspace Communicators Report.

Rev Domain Node From Bcc

REV_DOMAIN_NODE_FROM_BCC

-

Brainspace Communicators Graph Viz Report.

Rev Domain Node From Cc

REV_DOMAIN_NODE_FROM_CC

-

Brainspace Communicators Graph Viz Report.

Rev Domain Node From Cc Bcc

REV_DOMAIN_NODE_FROM_CC_BCC

-

Brainspace Communicators Graph Viz Report.

Rev Domain Node From To

REV_DOMAIN_NODE_FROM_TO

-

Brainspace Communicators Graph Viz Report.

Rev Domain Node From To Bcc

REV_DOMAIN_NODE_FROM_TO_BCC

-

Brainspace Communicators Graph Viz Report.

Rev Domain Node From To Cc

REV_DOMAIN_NODE_FROM_TO_CC

-

Brainspace Communicators Graph Viz Report.

Rev Domain Node From To Cc Bcc

REV_DOMAIN_NODE_FROM_TO_CC_BCC

-

Brainspace Communicators Graph Viz Report.

Rev From

REV_FROM

-

Brainspace Communicators Report.

Rev From Comm Id

REV_FROM_COMM_ID

-

Brainspace Normalized Communicators Report.

Rev From Domain

REV_FROM_DOMAIN

-

Brainspace Communicators Report.

Rev From Person Id

REV_FROM_PERSON_ID

-

Brainspace Normalized Communicators Report.

Rev Node From Bcc

REV_NODE_FROM_BCC

-

Brainspace Communicators Graph Viz Report.

Rev Node From Cc

REV_NODE_FROM_CC

-

Brainspace Communicators Graph Viz Report.

Rev Node From Cc Bcc

REV_NODE_FROM_CC_BCC

-

Brainspace Communicators Graph Viz Report.

Rev Node From To

REV_NODE_FROM_TO

-

Brainspace Communicators Graph Viz Report.

Rev Node From To Bcc

REV_NODE_FROM_TO_BCC

-

Brainspace Communicators Graph Viz Report.

Rev Node From To Cc

REV_NODE_FROM_TO_CC

-

Brainspace Communicators Graph Viz Report.

Rev Node From To Cc Bcc

REV_NODE_FROM_TO_CC_BCC

-

Brainspace Communicators Graph Viz Report.

Rev Recipient

REV_RECIPIENT

-

Brainspace Communicators Report.

Rev Recipient Count

REV_RECIPIENT_COUNT

-

Brainspace Communicators Report.

Rev Recipient Domain

REV_RECIPIENT_DOMAIN

-

Brainspace Communicators Report.

Rev Recipient Domain Count

REV_RECIPIENT_DOMAIN_COUNT

-

Brainspace Communicators Report.

Rev To

REV_TO

-

Brainspace Communicators Report.

Rev To Comm Id

REV_TO_COMM_ID

-

Brainspace Normalized Communicators Report.

Rev To Count

REV_TO_COUNT

-

Brainspace Communicators Report.

Rev To Domain

REV_TO_DOMAIN

-

Brainspace Communicators Report.

Rev To Domain Count

REV_TO_DOMAIN_COUNT

-

Brainspace Communicators Report.

Rev To Person Id

REV_TO_PERSON_ID

-

Brainspace Normalized Communicators Report.

Roundabout Style

_EMS_ROUNDABOUT_STYLE_SCORE

-

Analytic score for roundabout style of document language, which may indicate evasiveness. This is from the Brainspace Emotional Intelligence Report.

RSMF View Path

RSMF_PATH

-

Short Message View.

Sender Recipient Domains

DOMAINS

DOMAINS

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

Sent on Behalf of

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_DATETIME

SENT_DATETIME

SENTDATETIME

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

Sentiment Status Message

_EMS_SENTIMENT_STATUS_MESSAGE

-

Brainspace Sentiment Report

Source

SOURCE

ARCHIVESTORE

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

Standard First Level Review - First Reviewed Date

TAG_PROFILE_1_FIRST_REVIEWED_DATE

-

Field displaying the date the document was first reviewed for the Standard First Level Review Tag Profile.

Standard First Level Review - First Reviewed User

TAG_PROFILE_1_FIRST_REVIEWED_USER

-

Field displaying first user to review the document for the Standard First Level Review Tag Profile.

Subject

SUBJECT

SUBJECT

Populates with the subject of the email if the document is an email. If it’s not an email, it will remain blank.

Text File Size (Bytes)

DM_TEXTFILESIZE

TEXTFILESIZE

The size of the extracted text or OCR (Optical Character Recognition) content per document. It is designed to hold the file size in big int format, providing a detailed measure of the text content within a document after extraction.

Time

TIME_OTHER

-

Blank field.

Time Received

RECEIVED_TIME

EMAILTIMERECEIVED

Time Received of the email.

Time Sent

SENT_TIME

TIMESENT

Time Sent of the email.

Time Zone

TIMEZONE

TIMEZONE

Timezone value used when importing scope data.

To

RECIPIENT

TO

An email's "To" field.

Transcript Folders

TRANSCRIPT_FOLDERS

-

Transcript Folders

TV Family ID

TVFAMILYID

TVFAMILYID

The Discovery Manager unique identifier for document families.

TV File ID

TVFILEID

TVFILEID

The Discovery Manager unique identifier. Populated for all files.

Type of Document

TYPEDOCUMENT

DOCUMENTTYPE

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

Type of Parent Document

TYPEDOCUMENTPARENT

DOCUMENTTYPEPARENT

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

UTC Offset

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.

Volume Name

VOLUMENAME

VOLUMENAME

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

Work Folders

PUBLIC_FOLDERS

-

Public Folders.

Zantaz All Email Recipients (Outlook)

ZANTAZRECIP

ZANTAZRECIP

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

Zantaz Recipient Names

ZANTAZARCHIVEORIGINALRECIPIENTS

ZANTAZARCHIVEORIGINALRECIPIENTS

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

Zantaz Recipients (Domino/Notes)

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 Expanded

ZANTAZARCHIVERECIPIENTS

ZANTAZARCHIVERECIPIENTS

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

Zantaz Sender

ZANTAZARCHIVEORIGINALFROM

ZANTAZARCHIVEORIGINALFROM

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

Deprecated