Special Field Mapping
The following are fields of special significance:
Reveal Table Name | Brainspace |
---|---|
SUBJECT_OTHER | Maps to “Email Subject”. Used as the title in Brainspace so if the value is blank in Reveal Review, the Brainspace title will be "No title". It is possible to map more than one Reveal field to the same Brainspace field and the values should combine however this could interfere with Brainspace analytics. |
SENDER | Maps to “From” |
RECIPIENT | Maps to “To” |
CC_ADDRESSES | Maps to “CC” |
BCC | Maps to “BCC” |
SENT_DATE, TIME_SENT | All known (non-custom) DATE, TIME pairs are combined into a single field value when ingested into Brainspace. You only need to include the date field in the profile, the time will append automatically. |
ATTACHMENT_LIST | Maps to “Attachment” |
BEGIN_NUMBER_ATTACH | Maps to “Parent ID” when using BEGDOC as ID. |
PARENT_ITEMID | Maps to “Parent ID” when using ITEMID as ID. |
CONVERSATION_ID | Maps to “Conversation Index” |
CUSTODIAN_NAME | Maps to “Custodian” |
ITEMID or BEGDOC | Map one or other to ID field to be used as the lookup key. ITEMID is commonly used as the key field with BEGDOC mapped to “String”. The ID field is the only required Brainspace field but ingest will fail if you are trying to ingest body text and no provided docs have text. |
BODY_TEXT | You can map one or more text sets from Reveal to "Body Text". The text will be appended together in the document viewer in Brainspace. For example, you could map the primary language version along with a secondary translation. "Extracted / OCR / Loaded" has special meaning. Extracted text is used first if available with fallback to OCR/loaded if not available. |
FILE_SIZE | Maps to “File Size” |
DOCUMENT_TYPE_DESC | Maps to “File Type” |