Skip to main content

Reveal Review Publication

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”