The table below shows each field and its Reveal (web) display name, its Reveal SQL ID, its corresponding Processing (Discovery Manager) 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 .png){kind=small}
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. 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.
Web Display Name | Reveal SQL Name | Processing (DM) SQL Namer | Description |
|---|---|---|---|
AI Document Id | AI_DOCUMENT_ID | - | The identifier in the AI system. |
Alert Detail | ALERT_DETAIL | - | List the alerts found for the document that encountered an indexing error. |
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 Intelligent Sort | EMT_INTELLIGENT SORT | - | 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 MessageCt | EMT_MESSAGECT | - | 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 i0s 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 ThreadPath Full | EMT_THREADPATH FULL | - | 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 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. |
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 Primary Language | PRIMARY LANGUAGE | - | 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 | - | Brainspace Unique Identifier for a document. BDID is a 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 | EMPTYFIELD | 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 | EMPTYFIELD | Blank field. |
Document Received By | DOCUMENT_RECEIVED_BY | EMPTYFIELD | Blank field. |
Duplicate Collection Location | DUPLICATE_COLLECTIONLOCATION | DUPLICATE_COLLECTIONLOCATION | All Recipient(s) fields of the email combined in one field. |
Duplicate Collection Source | DUPLICATE_COLLECTIONSOURCE | DUPLICATE_COLLECTIONSOURCE | All Recipient(s) fields of the email combined in one field. |
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 | All Recipient(s) fields of the email combined in one field. |
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 | - | Ending review control number. |
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 Unique | 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 | ENTITY_LOCATION | - A city, state, country, region, or other location that contains both a population and a government. | |
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 | EMPTYFIELD | 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. |
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 | EMPTYFIELD | Blank field. |
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 | EMPTYFIELD | 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 | EMPTYFIELD | Blank field. |
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 | EMPTYFIELD | 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. |