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