Reveal Field Mapping Matrix & Definitions

Prev Next

The table below shows each field and its Reveal (web) display name, its Reveal SQL ID, its corresponding Processing (DM) SQL ID, and a description of the field’s content. The table can be sorted (A→Z or Z→A) or filtered to select fields by hovering over the corner of a column header then clicking the sorting icon Sorting icon.

  • Web Display Name: The field’s name in the Reveal web application. These names are visible when pressing +Add in advanced searches, and are the column headers in the Review Grid.

  • Reveal SQL Name: The SQL database name for Review fields. Use these names to create SQL searches in the search bar.

  • Processing (DM) SQL Name: The SQL database name for Processing fields used in Discovery Manager (DM). Web fields that don’t have Processing SQL names are represented with a dash [ - ] sign since they are created, populated, and used exclusively in Reveal Web.

  • Description: A description of the metadata represented in the field.

Important

Reveal SQL names may be the same or different than its Processing SQL name. This means some Processing SQL names will not work in Reveal Web.

Deprecated fields

Certain fields in the Field Mapping Matrix table are deprecated, meaning the field is still available in the system but is no longer recommended for use because it has been replaced, is no longer actively supported, or is scheduled to be removed in a future release.

Deprecated fields may continue to display existing data or function for backward compatibility, but users should avoid relying on them for new workflows, searches, reports, integrations, or configurations.

Web Display Name

Reveal

SQL Name

Processing (DM)

SQL Name

Description

Status

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.

Active

All Recipients

ALLRECIPIENTS

RECIPIENTS

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

Active

All Reviewed Profiles

ALL_REVIEWED_PROFILES

-

All Profiles with the reviewed status of this document.

Active

All Reviewed Users

ALL_REVIEWED_USERS

-

All users who reviewed this document.

Active

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.

Active

Application Category

APP_META_CATEGORY

METACATEGORY

Bucket field containing all efile metadata.

Active

Application Comments

APP_META_COMMENTS

METACOMMENTS

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

Active

Application Created Date

DATE_CREATED

METACREATEDDATE

Metadata created date where applicable.

Active

Application Created Date/Time

APP_CREATED_DATETIME

METACREATEDDATETIME

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

Active

Application Created Time

TIME_CREATED

METACREATEDTIME

Metadata created time where applicable.

Active

Application File Title

EFILETITLE

EFILETITLE

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

Active

Application Keywords

APP_META_KEYWORDS

METAKEYWORDS

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

Active

Application Last Saved Date

LAST_SAVED_DATE

METALASTMODDATE

Metadata last modified date where applicable.

Active

Application Last Saved Date/Time

APP_LASTMOD_DATETIME

METALASTMODDATETIME

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

Active

Application Last Saved Time

LAST_SAVED_TIME

METALASTMODTIME

Metadata last modified time where applicable.

Active

Application Meta Subject

APP_META_SUBJECT

METASUBJECT

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

Active

Application Metadata

APP_METADATA

METADATA

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

Active

Application Revision

APP_META_REVISION

METAREVISION

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

Active

Application Template

APP_META_TEMPLATE

METATEMPLATE

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

Active

Application Type

APPLICATION_TYPE

APPTYPE

Category of application.

Active

Appointment Begin Date

APPTBEGDATE

APPTBEGDATE

Start date of email appointment.

Active

Appointment Begin Date/Time

APPTBEGDATETIME

APPTBEGDATETIME

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

Active

Appointment Begin Time

APPTBEGTIME

APPTBEGTIME

Start time of the email appointment.

Active

Appointment End Date

APPTENDDATE

APPTENDDATE

End date of email appointment.

Active

Appointment End Date/Time

APPTENDDATETIME

APPTENDDATETIME

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

Active

Appointment End Time

APPTENDTIME

APPTENDTIME

End time of the email appointment.

Active

Assigned To

ASSIGNED_TO

-

The user who is assigned the document of the assignment.

Active

Assignment Folder

ASSIGNED_TO_FOLDER

-

The name of the assignment folder of the document

Active

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.

Active

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.

Active

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)”.

Active

Author

AUTHOR

EFILEDOCAUTHOR

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

Active

Batch Folders

BATCH_FOLDERS

-

Contains the folder names used for assignment jobs.

Active

Batch ID

BATCHID

EXPORTNAME

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

Active

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.

Deprecated

Bates Family Range

BATESFAMILYRANGE

BATESFAMILYRANGE

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

Deprecated

Bcc

BCC

BCC

An email's "Bcc" field.

Active

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

Active

BD DupType

DUPTYPE

-

Type of duplicate: Exact, Near

Active

BD EMT AttachmentCount

EMT_ATTACHMENTCOUNT

-

Number of attachments to an email document.

Active

BD EMT DuplicateID

EMT_DUPLICATEID

-

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

Active

BD EMT EmailAction

EMT_EMAILACTION

-

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

Active

BD EMT FamilyID

EMT_FAMILYID

-

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

Active

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.

Active

BD EMT IsDuplicate

EMT_ISDUPLICATE

-

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

Active

BD EMT IsMessage

EMT_ISMESSAGE

-

Specifies if this document is an email: True/False

Active

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.)

Active

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.

Active

BD EMT ThreadHasMissingMessage

EMT_THREADHASMISSINGMESSAGE

-

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

Active

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

Active

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.

Active

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.

Active

BD EMT ThreadSort

EMT_THREADSORT

-

Allows you to sort documents within an email thread in chronological 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.

Active

BD EMT UniqueReason

EMT_UNIQUEREASON

-

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

Active

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.

Active

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

Active

BD ExactDupSetID

EXACTDUPSETID

-

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

Active

BD ExactDupStatus

EXACTDUPSTATUS

-

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

Active

BD IsExactPivot

ISEXACTPIVOT

-

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

Active

BD IsNearDupPivot

ISNEARDUPPIVOT

-

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

Active

BD IsStrictDupPivot

ISSTRICTDUPPIVOT

-

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

Active

BD Languages

LANGUAGES

-

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

Active

BD NearDupSetID

NEARDUPSETID

-

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

Active

BD NearDupSimilarityScore

NEARDUPSIMILARITYSCORE

-

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

Active

BD NearDupStatus

NEARDUPSTATUS

-

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

Active

BD Primary Language

PRIMARYLANGUAGE

-

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

Active

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.)

Active

BD StrictDupSetID

STRICTDUPSETID

-

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

Active

BD StrictDupStatus

STRICTDUPSTATUS

-

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

Active

BD Summary

SUMMARY

-

Provides a brief summary of the text of each document.

Active

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.

Active

Begin Bates

BEGBATES

BATESBEG

Beginning bates number of the file.

Active

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.

Active

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.

Active

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.

Active

Brs Has Entity

BRS_HAS_ENTITY

-

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

Active

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.

Active

Cc

CC_ADDRESSES

CC

An email's "Cc" field.

Active

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.

Active

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.

Active

Color Brightness - 25

COLOR_DETECTION_STATE_25

-

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

Active

Color Brightness - 30

COLOR_DETECTION_STATE_30

-

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

Active

Color Brightness - 35

COLOR_DETECTION_STATE_35

-

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

Active

Color Brightness - 40

COLOR_DETECTION_STATE_40

-

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

Active

Color Brightness - 45

COLOR_DETECTION_STATE_45

-

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

Active

Color Brightness - 50

COLOR_DETECTION_STATE_50

-

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

Active

Company

COMPANY

EFILECOMPANY

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

Active

Confidentiality Designation

TAG_SET_1

-

Tag Set.

Active

CONVERSATION

CONVERSATION

CONVERSATION

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

Active

Conversation Base Index

CONVBASEINDEX

CONVBASEINDEX

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

Active

Conversation ID

CONVERSATION_ID

CONVINDEX

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

Active

Conversation Topic

CONVERSATION_TOPIC

CONVTOPIC

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

Deprecated

CONVERSATION_PARTICIPANTS

CONVERSATIONPARTICIPANTS

CONVERSATIONPARTICIPANTS

RSMF text thread parties.

Active

CONVERSATION_PLATFORM

CONVERSATIONPLATFORM

CONVERSATIONPLATFORM

RSMF text application.

Active

CONVERSATIONID

CONVERSATIONID

CONVERSATIONID

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

Active

CONVERSATIONSLICE_SENDERS

CONVERSATIONSLICESENDERS

CONVERSATIONSLICESENDERS

RSMF thread senders.

Active

Custodian

CUSTODIAN_NAME

CUSTODIAN

Custodian name.

Active

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.

Active

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.

Active

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.

Active

Date

DATE_OTHER

-

Blank field.

Deprecated

Date Received

RECEIVED_DATE

EMAILDATERECEIVED

Date Received of the email.

Active

Date Sent

SENT_DATE

DATESENT

Date Sent of the email.

Active

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.

Deprecated

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.

Deprecated

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.

Deprecated

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.

Deprecated

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.

Deprecated

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.

Active

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.

Active

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.

Deprecated

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.

Deprecated

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.

Deprecated

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.

Deprecated

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.

Deprecated

Decision Engine Thread Document Count

DE_EMAILTHREADNUMITEMS

EMAILTHREADNUMITEMS

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

Deprecated

Decrypted

DECRYPTED

DECRYPTED

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

Active

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

Active

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.

Active

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.

Active

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.

Active

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.

Active

Document Author

DOCUMENT_AUTHOR

EFILELASTAUTHOR

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

Active

Document Contains Images

COLOR_DETECTION_FOUND_IMAGES

-

Are images present for a document

Active

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.

Active

Document Id

BRS_KEY

-

Brainspace Sentiment Report

Active

Document Name

DOCUMENT_NAME

-

Blank field.

Deprecated

Document Received By

DOCUMENT_RECEIVED_BY

-

Blank field.

Deprecated

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.

Active

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.

Active

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.

Active

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.

Active

Duplicate ID

MD5_HASH

MD5HASH

The MD5 Hash of the file.

Active

Duplicate Job Name

DUPLICATE_JOB_NAME

DUPLICATE_JOB_NAME

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

Active

EDRM Message ID Hash

EDRM_MIH

-

EDRM promoted message ID

Deprecated

EDRM_MSGID

EDRM_MSGID

EDRM_MSGID

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

Active

Email Date Received

EMAILDATERECEIVED

EMAILDATERECEIVED

Date Received of the email.

Active

Email Datetime Received

EMAILDATETIMERECEIVED

EMAILDATETIMERECEIVED

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

Active

Email Folder

EMAILFOLDER

EMAILFOLDER

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

Active

Email Header

EMAILTRANSPORTHEADERS

EMAILTRANSPORTHEADERS

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

Active

Email In-Reply-To

THREAD_IN_REPLY_TO

INTREPLYTOID

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

Active

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

Active

Email Item Type

EMAILITEMTYPE

EMAILITEMTYPE

The item type of the email according to native application.

Active

Email Priority

EMAILPRIORITY

EMAILPRIORITY

Priority of the email.

Active

Email References

THREAD_REFERENCES

INTREFERENCES

Internet references used to pull together email threads.

Active

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.

Active

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.

Active

Email Time Received

EMAILTIMERECEIVED

EMAILTIMERECEIVED

Time Received of the email.

Active

Email Unread

EMAIL_UNREAD

EMAILREADSTATUS

Read status of the email.

Active

Embedded Object

ISEMBEDDEDOBJECT

ISEMBEDDEDOBJECT

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

Active

Emotional Intelligence Status Message

_EMS_STATUS_MESSAGE

-

Brainspace Emotional Intelligence Report

Active

Encrypted

ENCRYPTED

ENCRYPTED

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

Active

End Bates

ENDBATES

BATESEND

Ending bates number of the file.

Active

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.

Active

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.

Active

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.

Active

Entity Count Unique

ENTITY_COUNT_UNIQUE

-

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

Active

Entity Email

ENTITY_EMAIL

-

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

Active

Entity Email Count

ENTITY_EMAIL_COUNT

-

Number of emails found in the entity cluster.

Active

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.

Active

Entity Location

ENTITY_LOCATION

- A city, state, country, region, or other location that contains both a population and a government.
- A geographic place such as a body of water, mountain, park, or address.
- A structure such as a building or monument.

Active

Entity Location Count

ENTITY_LOCATION_COUNT

-

Number of documents found in the entity cluster.

Active

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.

Active

Entity Money

ENTITY_MONEY

-

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

Active

Entity Money Count

ENTITY_MONEY_COUNT

-

Number of documents found in the entity cluster.

Active

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.

Active

Entity Nationality

ENTITY_NATIONALITY

-

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

Active

Entity Nationality Count

ENTITY_NATIONALITY_COUNT

-

Number of documents found in the entity cluster.

Active

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.

Active

Entity Organization

ENTITY_ORGANIZATION

-

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

Active

Entity Organization Count

ENTITY_ORGANIZATION_COUNT

-

Number of documents found in the entity cluster.

Active

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.

Active

Entity Person

ENTITY_PERSON

-

A human identified by name, nickname, or alias.

Active

Entity Person Count

ENTITY_PERSON_COUNT

-

Number of documents found in the entity cluster.

Active

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.

Active

Entity Personal Id Num

ENTITY_PERSONAL_ID_NUM

-

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

Active

Entity Personal Id Num Count

ENTITY_PERSONAL_ID_NUM_COUNT

-

Number of documents found in the entity cluster.

Active

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.

Active

Entity Phone Number

ENTITY_PHONE_NUMBER

-

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

Active

Entity Phone Number Count

ENTITY_PHONE_NUMBER_COUNT

-

Number of documents found in the entity cluster.

Active

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.

Active

Entity Product

ENTITY_PRODUCT

-

Reference to a commercially available product.

Active

Entity Product Count

ENTITY_PRODUCT_COUNT

-

Number of documents found in the entity cluster.

Active

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.

Active

Entity Religion

ENTITY_RELIGION

-

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

Active

Entity Religion Count

ENTITY_RELIGION_COUNT

-

Number of documents found in the entity cluster.

Active

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.

Active

Entity Title

ENTITY_TITLE

-

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

Active

Entity Title Count

ENTITY_TITLE_COUNT

-

Number of documents found in the entity cluster.

Active

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.

Active

Entity Url

ENTITY_URL

-

Web address.

Active

Entity Url Count

ENTITY_URL_COUNT

-

Number of documents found in the entity cluster.

Active

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.

Active

Entity Credit Card Num

ENTITY_CREDIT_CARD_NUM

-

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

Active

Entity Credit Card Num Count

ENTITY_CREDIT_CARD_NUM_COUNT

-

Number of documents found in the entity cluster.

Active

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.

Active

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.

Active

Exception

IS_EXCEPTION

-

Blank field.

Deprecated

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.

Active

EXIF Latitude

EXIFLATITUDE

EXIFLATITUDE

Image origin global position latitude dimension.

Active

EXIF Longitude

EXIFLONGITUDE

EXIFLONGITUDE

Image origin global position longitude dimension.

Active

Exolution Cluster ID

EXO_CLUSTERID

-

Assigns identifiers to each document cluster.

Deprecated

Exolution Error

EXO_ERROR

-

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

Deprecated

Exolution File Locked

EXO_FILE_LOCKED

-

Indicates whether or not a document is locked.

Deprecated

Exolution File Version

EXO_FILE_VERSION

-

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

Deprecated

Exolution Flattening Status

EXO_FLATTENING_STATUS

-

Flattening Status.

Deprecated

Exolution Freeze Redaction

EXO_FREEZE_REDACTION

-

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

Deprecated

Exolution Has Redactions

EXO_HAS_REDACTIONS

-

If this has value Yes then the document has redaction.

Deprecated

Exolution Last Redaction Modified By

EXO_LAST_REDACTION_MODIFIED_BY

-

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

Deprecated

Exolution Last Redaction Modified Date

EXO_LAST_REDACTION_MODIFIED_DATE

-

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

Deprecated

Exolution Original Document

EXO_ORIGINAL_DOC

-

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

Deprecated

Exolution Processing Status

EXO_PROCESSING_STATUS

-

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

Deprecated

Exolution Redacted File Created

EXO_REDACTED_FILE_CREATED

-

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

Deprecated

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.

Deprecated

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.

Deprecated

Exolution Redacted Group ID

EXO_REDACTED_GROUPID

-

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

Deprecated

Exolution Redaction Burn Status

EXO_REDACTION_BURN_STATUS

-

Redaction burn status.

Deprecated

Exolution Redaction List

EXO_REDACTION_LIST

-

A list of the redaction applied on the document.

Deprecated

Exolution Redaction Type

EXO_REDACTION_TYPE

-

Exolution Redaction Type.

Deprecated

Exolution Review Complete

EXO_REVIEW_COMPLETE

-

Indicates whether or not the document is marked reviewed.

Deprecated

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.

Active

Exported Native File

EXPORTED_NATIVE_FILE

NATIVEFILE

Full file path to the deliverable native file.

Active

Exported Parent ID

FILEIDPARENTID

FILEIDPARENTID

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

Active

Exported Relative Native File

RELATIVENATIVEFILE

RELATIVENATIVEFILE

Relative file path to the deliverable native file.

Active

Exported Relative Text File

RELATIVETEXTFILE

RELATIVETEXTFILE

Relative file path to the deliverable text file.

Active

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.

Active

Family Range

FAMILYRANGE

FAMILYRANGE

BEGATTACH-ENDATTACH.

Active

Family Relationship

FAMILY_RELATIONSHIP

-

Relationship to other documents.

Active

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.

Active

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.

Active

File Size (bytes)

FILESIZE

EXPORTFILESIZE

Size of the original file in bytes.

Active

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.

Active

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.

Active

File Size in Kb

FILESIZEKB

EXPORTFILESIZEKB

Size of the original file in kilobytes.

Active

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.

Active

Filtering Keywords

FILTERING_KEYWORDS

SEARCHGROUPS

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

Deprecated

First Reviewed By

FIRST_REVIEWED_BY

-

Field displaying first user to review the document.

Active

First Reviewed On Date

FIRST_REVIEWED_ON_DATE

-

Field displaying the date the document was first reviewed.

Active

First Reviewed On Time

FIRST_REVIEWED_ON_TIME

-

Field displaying the time the document was first reviewed.

Active

First Reviewed Profile

FIRST_REVIEWED_PROFILE

-

Field displaying first tag profile used to review the document.

Active

Folder

RELATIVE_PATH

RELATIVEPATH

Original path of the associated file without the file name.

Active

Foreign Language

IS_FOREIGN_LANGUAGE

-

This field indicates whether the document is foreign.

Deprecated

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.

Active

From

SENDER

FROM

Sender of the email.

Active

Has Alert

ALERT

-

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

Active

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

Active

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.

Active

Has Embedded Objects

HASEMBEDDEDOBJECTS

HASEMBEDDEDOBJECTS

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

Active

Has Hidden Content

HASHIDDENCONTENT

HASHIDDENCONTENT

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

Active

Has Pattern

HASPATTERN

HASPATTERN

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

Active

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.

Active

HASEMOJI

HASEMOJI

-

HASEMOJI.

Active

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.

Active

Image Labels

IMAGE_LABELS

-

All of the labels for an image.

Active

Image Labels Over 55

IMAGE_LABELS_OVER_55

-

Image Labels with a confidence over 55.

Active

Image Labels Over 60

IMAGE_LABELS_OVER_60

-

Image Labels with a confidence over 60.

Active

Image Labels Over 65

IMAGE_LABELS_OVER_65

-

Image Labels with a confidence over 65.

Active

Image Labels Over 70

IMAGE_LABELS_OVER_70

-

Image Labels with a confidence over 70.

Active

Image Labels Over 75

IMAGE_LABELS_OVER_75

-

Image Labels with a confidence over 75.

Active

Image Labels Over 80

IMAGE_LABELS_OVER_80

-

Image Labels with a confidence over 80.

Active

Image Labels Over 85

IMAGE_LABELS_OVER_85

-

Image Labels with a confidence over 85.

Active

Image Labels Over 90

IMAGE_LABELS_OVER_90

-

Image Labels with a confidence over 90.

Active

Image Labels Over 95

IMAGE_LABELS_OVER_95

-

Image Labels with a confidence over 95.

Active

Image Labels Under 60

IMAGE_LABELS_UNDER_60

-

Image Labels with a confidence under 60.

Active

Image Labels Under 65

IMAGE_LABELS_UNDER_65

-

Image Labels with a confidence under 65.

Active

Image Labels Under 70

IMAGE_LABELS_UNDER_70

-

Image Labels with a confidence under 70.

Active

Image Labels Under 75

IMAGE_LABELS_UNDER_75

-

Image Labels with a confidence under 75.

Active

Image Labels Under 80

IMAGE_LABELS_UNDER_80

-

Image Labels with a confidence under 80.

Active

Image Labels Under 85

IMAGE_LABELS_UNDER_85

-

Image Labels with a confidence under 85.

Active

Image Labels Under 90

IMAGE_LABELS_UNDER_90

-

Image Labels with a confidence under 90.

Active

Image Labels Under 95

IMAGE_LABELS_UNDER_95

-

Image Labels with a confidence under 95.

Active

Image Manual

IMAGEMANUAL

IMAGEMANUAL

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

Active

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.

Active

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.

Active

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.

Active

Import Path

IMPORTPATH

IMPORTPATH

Original path of the associated file with the file name.

Active

Intent

_EMS_INTENT_SCORE

-

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

Active

Internet Message ID

MESSAGE_ID

EMAILINTMESSAGEID

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

Active

Is A Duplicate

ISADUPLICATE

ISDUPLICATE

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

Active

Is Parent

ISPARENT

ISPARENT

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

Active

Is Redacted

DM_ISREDACTED

ISREDACTED

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

Active

Item ID

ITEMID

TVFILEID

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

Active

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.

Active

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.

Active

Last Document Action

LAST_DOCUMENT_ACTION

-

Last Document Type

Active

Last Printed Date

LAST_PRINTED_DATE

METALASTPRINTDATE

Metadata last printed date where applicable.

Active

Last Printed Date/Time

APP_LASTPRINTED_DATETIME

METALASTPRINTDATETIME

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

Active

Last Printed Time

LAST_PRINTED_TIME

METALASTPRINTTIME

Metadata last printed time where applicable.

Active

Last Reviewed By

LAST_REVIEWED_BY

-

Field displaying most recent user to review the document.

Active

Last Reviewed On Date

LAST_REVIEWED_ON_DATE

-

Field displaying the date the document was last reviewed.

Active

Last Reviewed On Time

LAST_REVIEWED_ON_TIME

-

Field displaying the time the document was last reviewed.

Active

Last Reviewed Profile

LAST_REVIEWED_PROFILE

-

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

Active

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.

Active

Master Date Time

MASTERDATETIME

MASTERDATETIME

MASTERDATE and MASTERTIME combined into one field.

Active

Master Time

MASTERTIME

MASTERTIME

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

Active

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.

Active

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.

Active

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.

Active

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.

Active

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

Active

Native PDF File

PDF_Path

PDFEXPORTPATH

Processing export path for Native PDF Files.

Active

Native Spreadsheet View Path

SPREADSHEET_PATH

-

Path to spreadsheet converted for viewer.

Active

Native View Page Count

NATIVE_VIEW_PAGE_COUNT

-

Page count of converted native view PDF.

Active

Native View Path

NATIVE_VIEW_PATH

-

Path to document converted to PDF, AV or spreadsheet.

Active

Negative Snippets

_EMS_NEGATIVE_SNIPPETS

-

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

Active

Negativity

_EMS_NEGATIVITY_SCORE

-

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

Active

Notes

NOTES

-

Notes.

Active

Ocr Flag

OCR_FLAG

-

Ocr Flag.

Active

Ocr Path

OCR_PATH

TEXTFILE

Full file path to the deliverable text file.

Active

Opportunity

_EMS_OPPORTUNITY_SCORE

-

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

Active

OS Creation Date

CREATION_DATE

OSCREATEDDATE

File system created date.

Active

OS Creation Date/Time

OS_CREATED_DATETIME

OSCREATEDDATETIME

File system created date and time combined in one field.

Active

OS Creation Time

CREATION_TIME

OSCREATEDTIME

File system created time.

Active

OS Last Access Date

LAST_ACCESS_DATE

OSLASTACCESSEDDATE

File system last accessed date.

Active

OS Last Access Date/Time

OS_LASTACCESS_DATETIME

OSLASTACCESSEDDATETIME

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

Active

OS Last Access Time

LAST_ACCESS_TIME

OSLASTACCESSEDTIME

File system last accessed time.

Active

OS Saved Date

LAST_MODIFIED_DATE

OSLASTMODDATE

File system last modified date.

Active

OS Saved Date/Time

OS_LASTMOD_DATETIME

OSLASTMODDATETIME

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

Active

OS Saved Time

LAST_MODIFIED_TIME

OSLASTMODTIME

File system last modified time.

Active

Page Count

PAGE_COUNT

IMAGEPAGECOUNT

Total number of images exported.

Active

Parent Child Document ID

PARENTCHILDDOCID

-

Blank field.

Deprecated

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.

Active

Parent ID

PARENT_ITEMID

TVFAMILYID

Review internal family identifier. Auto generated upon family build.

Active

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.

Active

Positive Snippets

_EMS_POSITIVE_SNIPPETS

-

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

Active

Positivity

_EMS_POSITIVITY_SCORE

-

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

Active

Pressure

_EMS_PRESSURE_SCORE

-

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

Active

Previous Begin Numbers

PREVIOUS_BEGIN_NUMBERS

-

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

Active

Privilege Reason

TAG_SET_4

-

Tag Set.

Active

Privileged

TAG_SET_2

-

Tag Set.

Active

Processed Date

PROCESSED_DATE

PROCESSEDDATE

Date of processing for reporting purposes.

Active

Processing Index Status

DM_INDEXSTATUS

INDEXSTATUS

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

Active

Produced

IS_PRODUCED

-

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

Active

Production Jobs

PRODUCTION_JOBS

-

Contains the production jobs names used for update jobs.

Active

Production Number Range

PRODNUMRANGE

-

Contains the production number range.

Active

Production Page Count

PRODUCTION_PAGE_COUNT

-

The page count after production job.

Active

Project Name

DM_PROJECTNAME

PROJECTNAME

Name of the project.

Active

Project Path

PROJECTPATH

PROJECTPATH

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

Active

Rationalization

_EMS_RATIONALIZATION_SCORE

-

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

Active

Raw Transcription

RAW_TRANSCRIPTION

-

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

Active

Read Receipt Requestted

READRECEIPTREQ

READRECEIPTREQ

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

Active

Recipient Count

RECIPIENTCOUNT

RECIPIENTCOUNT

Total number of recipients of the email.

Active

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.

Active

Relevance

RELEVANCE

-

Search Relevance.

Active

Responsiveness

TAG_SET_3

-

Tag Set.

Active

Rev Arc From Bcc

REV_ARC_FROM_BCC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Arc From Cc

REV_ARC_FROM_CC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Arc From Cc Bcc

REV_ARC_FROM_CC_BCC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Arc From To

REV_ARC_FROM_TO

-

Brainspace Communicators Graph Viz Report.

Active

Rev Arc From To Bcc

REV_ARC_FROM_TO_BCC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Arc From To Cc

REV_ARC_FROM_TO_CC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Arc From To Cc Bcc

REV_ARC_FROM_TO_CC_BCC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Bcc

REV_BCC

-

Brainspace Communicators Report.

Active

Rev Bcc Comm Id

REV_BCC_COMM_ID

-

Brainspace Normalized Communicators Report.

Active

Rev Bcc Count

REV_BCC_COUNT

-

Brainspace Communicators Report.

Active

Rev Bcc Domain

REV_BCC_DOMAIN

-

Brainspace Communicators Report.

Active

Rev Bcc Domain Count

REV_BCC_DOMAIN_COUNT

-

Brainspace Communicators Report.

Active

Rev Bcc Person Id

REV_BCC_PERSON_ID

-

Brainspace Normalized Communicators Report.

Active

Rev Cc

REV_CC

-

Brainspace Communicators Report.

Active

Rev Cc Comm Id

REV_CC_COMM_ID

-

Brainspace Normalized Communicators Report.

Active

Rev Cc Count

REV_CC_COUNT

-

Brainspace Communicators Report.

Active

Rev Cc Domain

REV_CC_DOMAIN

-

Brainspace Communicators Report.

Active

Rev Cc Domain Count

REV_CC_DOMAIN_COUNT

-

Brainspace Communicators Report.

Active

Rev Cc Person Id

REV_CC_PERSON_ID

-

Brainspace Normalized Communicators Report.

Active

Rev Domain

REV_DOMAIN

-

Brainspace Communicators Report.

Active

Rev Domain Arc From Bcc

REV_DOMAIN_ARC_FROM_BCC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Domain Arc From Cc

REV_DOMAIN_ARC_FROM_CC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Domain Arc From Cc Bcc

REV_DOMAIN_ARC_FROM_CC_BCC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Domain Arc From To

REV_DOMAIN_ARC_FROM_TO

-

Brainspace Communicators Graph Viz Report.

Active

Rev Domain Arc From To Bcc

REV_DOMAIN_ARC_FROM_TO_BCC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Domain Arc From To Cc

REV_DOMAIN_ARC_FROM_TO_CC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Domain Arc From To Cc Bcc

REV_DOMAIN_ARC_FROM_TO_CC_BCC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Domain Count

REV_DOMAIN_COUNT

-

Brainspace Communicators Report.

Active

Rev Domain Node From Bcc

REV_DOMAIN_NODE_FROM_BCC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Domain Node From Cc

REV_DOMAIN_NODE_FROM_CC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Domain Node From Cc Bcc

REV_DOMAIN_NODE_FROM_CC_BCC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Domain Node From To

REV_DOMAIN_NODE_FROM_TO

-

Brainspace Communicators Graph Viz Report.

Active

Rev Domain Node From To Bcc

REV_DOMAIN_NODE_FROM_TO_BCC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Domain Node From To Cc

REV_DOMAIN_NODE_FROM_TO_CC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Domain Node From To Cc Bcc

REV_DOMAIN_NODE_FROM_TO_CC_BCC

-

Brainspace Communicators Graph Viz Report.

Active

Rev From

REV_FROM

-

Brainspace Communicators Report.

Active

Rev From Comm Id

REV_FROM_COMM_ID

-

Brainspace Normalized Communicators Report.

Active

Rev From Domain

REV_FROM_DOMAIN

-

Brainspace Communicators Report.

Active

Rev From Person Id

REV_FROM_PERSON_ID

-

Brainspace Normalized Communicators Report.

Active

Rev Node From Bcc

REV_NODE_FROM_BCC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Node From Cc

REV_NODE_FROM_CC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Node From Cc Bcc

REV_NODE_FROM_CC_BCC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Node From To

REV_NODE_FROM_TO

-

Brainspace Communicators Graph Viz Report.

Active

Rev Node From To Bcc

REV_NODE_FROM_TO_BCC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Node From To Cc

REV_NODE_FROM_TO_CC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Node From To Cc Bcc

REV_NODE_FROM_TO_CC_BCC

-

Brainspace Communicators Graph Viz Report.

Active

Rev Recipient

REV_RECIPIENT

-

Brainspace Communicators Report.

Active

Rev Recipient Count

REV_RECIPIENT_COUNT

-

Brainspace Communicators Report.

Active

Rev Recipient Domain

REV_RECIPIENT_DOMAIN

-

Brainspace Communicators Report.

Active

Rev Recipient Domain Count

REV_RECIPIENT_DOMAIN_COUNT

-

Brainspace Communicators Report.

Active

Rev To

REV_TO

-

Brainspace Communicators Report.

Active

Rev To Comm Id

REV_TO_COMM_ID

-

Brainspace Normalized Communicators Report.

Active

Rev To Count

REV_TO_COUNT

-

Brainspace Communicators Report.

Active

Rev To Domain

REV_TO_DOMAIN

-

Brainspace Communicators Report.

Active

Rev To Domain Count

REV_TO_DOMAIN_COUNT

-

Brainspace Communicators Report.

Active

Rev To Person Id

REV_TO_PERSON_ID

-

Brainspace Normalized Communicators Report.

Active

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.

Active

RSMF View Path

RSMF_PATH

-

Short Message View.

Active

Sender Recipient Domains

DOMAINS

DOMAINS

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

Active

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.

Active

SENT_DATETIME

SENT_DATETIME

SENTDATETIME

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

Active

Sentiment Status Message

_EMS_SENTIMENT_STATUS_MESSAGE

-

Brainspace Sentiment Report

Active

Source

SOURCE

ARCHIVESTORE

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

Active

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.

Active

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.

Active

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.

Active

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.

Active

Time

TIME_OTHER

-

Blank field.

Deprecated

Time Received

RECEIVED_TIME

EMAILTIMERECEIVED

Time Received of the email.

Active

Time Sent

SENT_TIME

TIMESENT

Time Sent of the email.

Active

Time Zone

TIMEZONE

TIMEZONE

Timezone value used when importing scope data.

Active

To

RECIPIENT

TO

An email's "To" field.

Active

Transcript Folders

TRANSCRIPT_FOLDERS

-

Transcript Folders

Active

TV Family ID

TVFAMILYID

TVFAMILYID

The Discovery Manager unique identifier for document families.

Active

TV File ID

TVFILEID

TVFILEID

The Discovery Manager unique identifier. Populated for all files.

Active

Type of Document

TYPEDOCUMENT

DOCUMENTTYPE

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

Active

Type of Parent Document

TYPEDOCUMENTPARENT

DOCUMENTTYPEPARENT

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

Active

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.

Active

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.

Deprecated

Work Folders

PUBLIC_FOLDERS

-

Public Folders.

Active

Zantaz All Email Recipients (Outlook)

ZANTAZRECIP

ZANTAZRECIP

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

Deprecated

Zantaz Recipient Names

ZANTAZARCHIVEORIGINALRECIPIENTS

ZANTAZARCHIVEORIGINALRECIPIENTS

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

Deprecated

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.

Deprecated

Zantaz Recipients Expanded

ZANTAZARCHIVERECIPIENTS

ZANTAZARCHIVERECIPIENTS

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

Deprecated

Zantaz Sender

ZANTAZARCHIVEORIGINALFROM

ZANTAZARCHIVEORIGINALFROM

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

Deprecated

Footer Design