METADATA COLUMN

MEANING

ID

Unique number created at processing to associate this metadaat with a give document.

FAMILY

For compound documents, this is the top most file in the group.  For example, records for a email with attachment would all contain the ID number of the email.

CUSTODIAN

name of the custodian associated with this document

PATH

The original path on disk (not to be confused with the location of the produced file).

TITLE

Document title if not an email.  This will also be the subject of an email as the "title" and "subject" are not stored distinctly in the system.

MD5

Text version of the MD5 hash value (32 characters, hex digit format).

EXT

The original extension of the file

DATE

Date of the parent document (sometimes called "Sort Date"). Usually "Send or Received if email, and "last Modified" if a non-email document.  For attachments, it is always the same as the parent date.

CREATED

Date the document or email was create.  1/1/1900 if not available

MODIFIED

Date the document or email was create.  1/1/1900 if not available

SENT

Date the document or email was create.  1/1/1900 if not available

RECEIVED

Date the document or email was create.  1/1/1900 if not available

UTC

The UTC time equivalent for the DATE field.  This ensure we can compute proper time zone offsets regardless of the current time zone rules.

MSGID

The unique internal message ID

FROM

Full display name of the email sender

TO

Full display name of the TO recipients. Names are ';' separated

CC

Full display name of the CC recipients. Names are ';' separated

BCC

Full display name of the BCC recipients. Names are ';' separated

FROMADDR

Email address with domain of the sender

TOADDR

Email address with domain of all recipients. Addresses are ';' separated

AUTHOR

The author field as listed in the original document's internal metadata

DOCTITLE

The title as listed in the original document's internal metadata

COMPANY

The company name listed in the original document's internal metadata

VERSION

The text version listed in the original document's internal metadata

LASTMODBY

Name of the person who last modified the document

DESCRIPTION

The description provided by the original document's internal metadata

REVISION

Numeric version of the revision count if provided in the original document's internal metadata.