Field Descriptions for CloudNine™ LAW

_DocCat

Numeric value indicating type of document. Attributes may be easily searched using the Query Builder in CloudNine™ LAW.

ex: 521

Doc

Numeric

tblDoc

_DupID

Child duplicates have ID value of parent dup. Parents have their own ID value (from LAW ID for ED Loader cases, EDA ID for Turbo Import cases, or external deduplication database tblDupLog.DupID), allowing grouping of the field to locate dup families. Records that are not duplicates or not tested will have a value of 0 in this field.

0=Not dup or not tested

>0=Dup or parent dup

Doc

Numeric

tblDoc

_DupMethod

Indicates which key, or hash, was used when testing the dup state of the record.

1=MD5Hash

2=Sha1Hash

129=MD5Hash - Deduplicated using Inter-Case Deduplication utility

130=Sha1Hash - Deduplicated using Inter-Case Deduplication utility

Doc

TinyInt

tblDoc

_FTIndex

Displays status of full text indexing using numeric values.

0=No text is available for indexing

1=Document's text is ready for indexing

2=Record was flagged for reindexing, but has not yet been reindexed

3=Document's text has been indexed.

Doc

TinyInt

tblDoc

_GUID

The globally unique identifier (GUID) for a document in CloudNine™ LAW.

The GUID field is populated when a file is imported into LAW using the ED Loader, Turbo Import, LAW case, or load file import.

During imports using ED Loader or Turbo Import, each file is automatically assigned a unique GUID.

During load file and LAW case imports, if the load file or case contains the GUID field and it is populated for a file, the GUID field will be populated with the existing GUID value. If the GUID field does not exist or is not populated for a file, a unique GUID is automatically assigned to the file.

GUIDs can also be generated and populate the _GUID field using the Generate document GUIDs function on the Tools menu on the main form. (Populating the _GUID Field)

The GUID value cannot be modified.

B389E85F-8026-4247-AF95-019DEB696CFF

37CA99B2-3A38-4793-8B6F-C4331DCEDA4B

Doc

Text

tblDoc

_PS_ARCX

Numeric success/failure indicator tied to archive extraction process.

0=Not executed.

1=Successfully executed.

2=Error occurred, see ErrorMsg field.

Doc

TinyInt

tblDoc

_PS_ATTX

Numeric success/failure indicator tied to attachment extraction process (set for parent and child).

0=Not executed.

1=Successfully executed.

2=Error occurred, see ErrorMsg field.

Doc

TinyInt

tblDoc

_PS_DIGESTX

Numeric success/failure indicator tied to process of hashing native file.

0=Not executed.

1=Successfully executed.

2=Error occurred, see ErrorMsg field.

Doc

TinyInt

tblDoc

_PS_EMBEDX

Numeric success/failure indicator tied to extraction of embedded images in e-mail.

0=Not executed.

1=Successfully executed.

2=Error occurred, see ErrorMsg field.

Doc

TinyInt

tblDoc

_PS_MDX

Numeric success/failure indicator tied to metadata extraction process.

0=Not executed.

1=Successfully executed.

2=Error occurred, see ErrorMsg field.

Doc

TinyInt

tblDoc

_PS_NATIVEX

Numeric success/failure indicator tied to native file extraction process.

0=Not executed.

1=Successfully executed.

2=Error occurred, see ErrorMsg field.

Doc

TinyInt

tblDoc

_PS_OLEX

Numeric success/failure indicator tied to OLE extraction process (set for parent and child).

0=Not executed.

1=Successfully executed.

2=Error occurred, see ErrorMsg field.

Doc

TinyInt

tblDoc

ApplicationName

Application Name field value pulled from metadata of the native file.

ex: Microsoft Office Word

Doc

Text

tblDoc

Attach

Populates parent records with original filenames of all attached records, separated by

semi-colons.

ex: Attach1.doc;Attach2.xls

Doc

Memo

tblDoc

AttachLvl

Numeric values indicate if a record is a parent, attachment, or neither.

0=Indicates parent record, record that does not have attachments, or record that is not an attachment.

1=Indicates record is an attachment.

Doc

Numeric

tblDoc

Attachmt

Populates parent records with BegDoc# of each attached record, separated by semi-colons.

ex: ABC0002;ABC0003

Doc

Text

tblAttach

AttachPID

Populates parent records and attachments with the ID number of the parent record.

0=Indicates record is not a parent and not an attachment.

>0=Any value greater than zero will indicate that a record is either a parent or an attachment. The value is equal to the ID value of the parent record, so parents and their attachments will have the same value.

Doc

Numeric

tblDoc

AttRange

Stores BegDoc# of parent record and EndDoc# of last attachment record, separated by a hyphen. Populated for all records in the family (parent and attachment(s)).

ex: ABC0001 - ABC0008

Doc

Text

tblAttach

Author

Author field value pulled from metadata of the native file.

Doc

Text

tblDoc

BatchStation

Name of the computer that ran a batch process on a document.

ex: Laptop01

Doc

Text

tblDoc

BatesRng

(Exports only - does not exist in LAW case database) Lists the PageID of the first page of a document and the PageID of the last page of a document, separated by a hyphen.

ex: ABC0001 - ABC0005

Doc

N/A

N/A

BCC

Recipient(s) of "Blind Carbon Copies" of the e-mail message.

Doc

Memo

tblDoc

BegAttach

Displays BegDoc# of parent record. When exported, the values will match the field used as the Image Tag.

ex: ABC0001

Doc

Text

tblAttach

BegDoc#

Displays page ID of first page in a document.

ex: ABC0001

Doc

Text

tblDoc

BookmarkName

Names of bookmarks in an Adobe Acrobat PDF file.

Doc

Text

tblDoc

Categories

Category field value pulled from metadata of the native file.

ex: Software

Doc

Memo

tblDoc

CC

Recipient(s) of "Carbon Copies) of the e-mail message.

Doc

Memo

tblDoc

Comments

Comments field value pulled from the metadata of the native file.

Doc

Memo

tblDoc

Conversation

Normalized subject of e-mails.

Doc

Memo

tblDoc

ConversationIndex

E-mail thread identification.

ex: 01C72AC4CB0FC3953C5FA8E149389B522EFF595EF9FB

Doc

Memo

tblDoc

Created

Stores date and time the record was created in CloudNine™ LAW.

Doc

Date

tblDoc

Custodian

Lookup field, displays textual value of custodian assigned by user in ED Loader or Turbo Import.

Doc

Lookup

tblCustodians.Name

DateAccessed

Stores the last accessed date from the properties of the file. Note: Many functions will cause this value to be updated by Windows (e.g., viewing file properties, dragging and dropping) and therefore this date will often reflect the current date. To avoid this situation, run the DisableLastAccessUpdate.reg file located in the \LAW50 folder (same folder as law50.exe) prior to handling the data (requires reboot after running). This will prevent updates to this value (applies to LAW TimeAccessed field also) by Windows. To re-enable the registry setting, run the EnableLastAccessUpdate.reg file located in the same folder.

Doc

Date

tblDoc

DateAppEnd

Appointment end date for calendar items.

Doc

Date

tblDoc

DateAppStart

Appointment start date for calendar items.

Doc

Date

tblDoc

DateCreated

Creation date of the native file.

Doc

Date

tblDoc

DateLastMod

Date the native file was last modified.

Doc

Date

tblDoc

DateLastPrnt

Date the native file was last printed (Office documents).

Doc

Date

tblDoc

DateRcvd

Received date of an e-mail message.

Doc

Date

tblDoc

DateSent

Sent date of an e-mail message.

Doc

Date

tblDoc

DelivReceipt

Delivery receipt request notification.

Y=Yes (delivery receipt requested)

N=No

<null>=Attachments and e-docs will have null value.

Doc

Text

tblDoc

DocExt

File extension of native file. May show original extension or suggested extension, depending on state of "auto-assign ext." option in ED Loader or Turbo Import.

ex: DOC

Doc

Text

tblDoc

DocID

For files imported using ED Loader or Turbo Import, the Document ID value assigned during import. Starting number specified by user in DocID Seed field in Sources tab in ED Loader or Turbo Import.

For files imported using CloudNine™ Explore using the LAW Direct export, the Numbering Seed value automatically assigned by CloudNine™ Explore during the process.

ex: ID00001

ex: 00000150

Doc

Text

tblDoc

DocOrder

Numeric value indicating order of documents in each folder.

ex: 3

Doc

Text

tblDoc

DupCustNames

Names of the custodians containing duplicate versions of the original record. Populated for parent/original records only (DupStatus=P) after running Tools > Apply Duplicate Relationships.

FirstCustodianName; SecondCustodianName

Doc

Memo

tblDoc

DupCustPaths

Source path to each duplicate version of the original record. Populated for parent/original records only (DupStatus=P) after running Tools > Apply Duplicate Relationships.

D:\Docs\; E:\Docs2

Doc

Memo

tblDoc

DupParentName

Custodian name of the original record. Populated for duplicate records only (DupStatus=G or C) after running Tools > Apply Duplicate Relationships.

ParentCustodianName

Doc

Memo

tblDoc

DupParentPath

Name of the custodian containing the original record. Populated for duplicate records only (DupStatus=G or C) after running Tools > Apply Duplicate Relationships.

C:\Docs\

Doc

Memo

tblDoc

DupStatus

Displays dedup status with single character value (see dedup documentation for more info).

N=Not a duplicate

G=Global-level duplicate

C=Custodian-level duplicate

P=Parent duplicate

Doc

Text

tblDoc

EdaID

Populated for parent items exported from CloudNine™ Explore or Turbo Import. Pulled from InventoryItems.ID in the CloudNine™ Explore case database.

0=Indicates non-CloudNine™ Explore record or not a Turbo Import.

>0=ID of record in the CloudNine™ Explore case. Attachments in LAW will have the same EDA ID of the parent record.  If a Turbo Import, the EDAIDs are non-sequential.

Doc

Numeric

tblDoc

EDFolder

Full path to source files (if e-docs or loose e-mail) or folder path contained with a mail store (if NSF or PST).

ex(1): Personal Folders\Inbox

ex(2): C:\EDOCS

Doc

Lookup

tblFolders.Name

EDPages

Stores the number of printed pages following the e-Print batch process.

ex: 75

Doc

Numeric

tblDoc

EDSession

For ED Loader imports, stores session name, as assigned by user in ED Loader's Session Label field.
 

For imports from CloudNine™ Explore LAW Direct export or Turbo Import, field is populated with: [export name] on [Explore case name] (YYYY/MM/DD HH:MM:SS). The export session time is based on the local timezone of the machine performing the export.

In Version 7.2+ Turbo Import sets will reflect the Import Name in this field.

ED Loader ex: Session Created On 1/4/2007 12:48:23 PM

LAW Direct export ex: LDE Export - 001 on Explore Case Name (2015/09/30 2:30:02 PM)

DocB

Lookup

tblSessions.Title

EDSource

Fully qualified original path to the source folder, files, and/or mail stores.

ex(1): C:\Mail\Outlook.pst

ex(2): C:\Edocs\Spreadsheets

Doc

Lookup

tblEDSources.SourcePath

EMailClient

Email client used to send the email message (information not always available).

ex: MS Outlook

ex: Outlook Express

ex: Lotus Notes

Doc

Text

tblDoc

EMail_Subject

Subject of the e-mail message.

ex: FW: CloudNine™ LAW

Doc

Memo

tblDoc

EndAttach

EndDoc# of last attached document in family. When exported, the values will match the field used as the Image Tag.

ex: ABC0003

Doc

Text

tblAttach

EndDoc#

Page ID of last page in a document.

ex: ABC0003

Doc

Text

tblDoc

EntryID

Unique identifier of e-mails in mail stores.

ex: 1322C3C03649D4418625711400748A13

Doc

Memo

tblDoc

EP*

Any field preceded by EP indicates a field that contains extended property or EP metadata. EP metadata can come from user defined fields added to original PDFs, Office files, and EXIF metadata for TIFF and JPEG image files. Any custom metadata found is placed into a special field designated as a an extended property.  

ex: if a Word document contains a value of Jones in its Typist field, upon import of the file, LAW creates a new field for the case called EPTypist and populate the field for that document with the value Jones.

Doc

Text

Extended

ErrorMsg

Displays error or warning messages, if any occurred during ED Loader import, Turbo Import, or TIFF conversion.

Doc

Memo

tblDoc

ET_Conversants

The names of all senders and recipients mentioned in the From, To, CC, and BCC fields found in the entire email, based on reading the headers of any quoted messages as well as the primary message itself.

Enron Announcements, confadmin@ect.enron.com

Doc

Memo

tblDoc

ET_Inclusive

Flags a minimal set of documents which can be viewed in order to read the email message thread's entire conversation. In the simplest case this will simply be the last message in the thread, since it will quote all the previous messages.
 

Note that inclusiveness is calculated based on message bodies, and does not consider metadata, such as an email's subject.
 

The ET_Inclusive field only flags email messages. It does not flag attachments.

N=No, Y=Yes

Doc

Text

tblDoc

ET_InclusiveReason

If ET_Inclusive field is set to Y, ET_InclusiveReason field indicates why the email is inclusive.
 

If the email message contains message content that is not copied in any of its subsequent replies or forwards, Message is displayed.
 

If the email message has attachments that are not included in any of its subsequent replies or forwards, Attachment is displayed.
 

If the email message has both new message content and new attachments  not included in any of its subsequent replies or forwards, Message, Attachment is displayed.
 

If ET_Inclusive field is set to N, ET_InclusiveReason field is blank.

Message, Attachment

Doc

Text

tblDoc

ET_Indent

Indicates the indent level of the email message in relation to the first email in the email thread associated with the email message.

0=First email in the email thread

1=Replies to first email

2=Replies to replies to first email

3=Replies to replies to replies to first email...and so on.

Doc

Numeric

tblDoc

ET_IsMessage

Indicates whether the document was recognized as an email message ('Y'), or some other kind of document ('N').

N=No, Y=Yes

Doc

Text

tblDoc

ET_MessageId

A unique ID that is assigned to each message. If several documents have the same Message ID, it is because they were recognized as separate copies of the same email message.

00001004

Doc

Text

tblDoc

ET_MetaUpdate

Indicates whether the email metadata was populated from analyzed text by the Near-Duplicate & Email Thread Analysis utility.

N=No, Y=Yes

Doc

Text

tblDoc

ET_ParentId

The immediate parent of the current email in the thread. For the first message, this will be blank. For each subsequent one, it will be the ID of the email which it replies to or is a forward of.

00002766

Doc

Text

tblDoc

ET_ThreadId

A unique ID assigned to each message thread.

00001701

Doc

Text

tblDoc

ET_ThreadIndex

Is composed of a base ID, plus a unique number for each message within the thread, and if there are attachments, the letter A plus the unique number for the attachment within the thread. For example, A1, A2, A3.
 

Uses the format: [base ID].[unique number for message].A[unique attachment number]
 

The base ID is the same as the thread ID without the leading zeros. The thread index for the root message of the thread will just be this.

1701.1

1701.1.A1

1701.1.A2

Doc

Text

tblDoc

ET_ThreadModified

Equal to the timestamp of the most recent “process data” operation that made any additions to the thread.

9/27/2013 1:06:59 PM

Doc

Date

tblDoc

ET_ThreadSize

The total number of unique messages (not documents -- see 'IsMessage' above) in the thread.

1, 3, 10

Doc

Numeric

tblDoc

ET_ThreadSort

A sort order which follows the chain of conversation, from first message to most recent. If a conversation splits into multiple branches, ET_ThreadSort will keep each of the branches together.

640, 641, 642

Doc

Numeric

tblDoc

FileAccuracy

Accuracy rating generated by file engine during file validation.

0=Unidentified

1=Low

2=Medium

3=High

Doc

TinyInt

tblDoc

FileDescription

Description of native file type, as listed in file type database.

ex: MS Word for Windows Document

Doc

Text

tblDoc

Filename

Original filename of native file. Contains subject of e-mail message for e-mail records.

ex(1): Estimates.xls

ex(2): FW: Monday Meeting

Doc

Memo

tblDoc

Filesize

Size of native file, in bytes.

ex: 27739

Doc

BigInt

tblDoc

FileType

ID number associated with file type, as listed in file type database.

ex: 229

Doc

Numeric

tblDoc

FolderRng

(Exports only - does not exist in LAW case database) Lists the PageID of the first page of the first document in a folder and the last PageID of the last document in a folder, separated by a hyphen.

ex. ABC0001 - ABC0011

Doc

N/A

N/A

Footer

Displays size of footer value if image was endorsed in CloudNine™ LAW.

0=Unendorsed

25=Contains 1/4 in. footer.

50=Contains 1/2 in. footer.

and so on.

Values are displayed in increments of .25 inches.

Page

Numeric

tblPage

From

Author of the e-mail message.

Doc

Text

tblDoc

HasAnnotations

Annotations are applied to document.

Y=Yes

N=No

Doc

Text

tblDoc

HasBookmarks

Adobe Acrobat PDF file contains bookmarks.

Y=Yes

N=No

Doc

Text

tblDoc

HasComments

Microsoft Word, Excel or PowerPoint document contains comments or PDF document contains sticky notes.

Y=Yes

N=No

Doc

Text

Extended

HasExtProps

Indicates whether extended property fields (e.g. HasComments) exist within the document. The actual values of the extended property fields (e.g. a “Y” or “N” in HasComments) have no bearing on the HasExtProps value.

Y=Yes

N=No

Doc

Text

Extended

HasHiddenRowCol

Microsoft Excel document contains one or more hidden rows or columns.

Y=Yes

N=No

Doc

Text

Extended

HasHiddenSheet

Microsoft Excel document contains one or more hidden worksheets.

Y=Yes

N=No

Doc

Text

Extended

HasPageLimit

Microsoft Excel, Adobe Acrobat PDF, Law PDF, or text file document contains page limits for printing or converting the document to TIFF or PDF.

Note: If the total number of pages for a specific document is greater than the page limit value, and the page limit check box is enabled for the document’s file type under the General category in the e-Print Options or TIFF Conversion Options dialog box, the HasPageLimit field will be set to Y.

Note: The HasPageLimit field is only updated for Excel, PDF, or text files that are printed or converted using batch processing. The HasPageLimit field is not updated for Excel, PDF, or text files that are manually printed or converted .

Y=Yes

N=No

Doc

Text

tblDoc

HasRedaction

Redactions are applied to document.

Y=Yes

N=No

Doc

Text

tblDoc

HasTrackChanges

Microsoft Word or Excel document contains tracked changes.

Y=Yes

N=No

Doc

Text

Extended

Header

Displays size of header value if image was endorsed in CloudNine™ LAW.

0=Unendorsed

25=Contains 1/4 in. header

50=Contains 1/2 in. header

and so on.

Values are displayed in increments of .25 inches.

Page

Numeric

tblPage

Headers

Contents of the header in an e-mail message.

Doc

Memo

tblDoc

HiddenSlides

PowerPoint document contains hidden slides.

Y=Yes

N=No

Doc

Text

Extended

HiddenText

True if document contains hidden text, otherwise False.

Doc

Boolean

tblDoc

ID

Unique ID value assigned to all records in CloudNine™ LAW, starting with 1.

ex: 1

Doc

Numeric

tblDoc

ImageExt

File extension of image records in LAW (applies to docs imported as raw images or via load file, scanned images, and files converted to TIFF in CloudNine™ LAW).

ex: TIF

Doc

Text

tblDoc

Importance

Importance field extracted from an e-mail message.

Low

Normal

High

None

Note: The SQL database codes these values as numbers. Low is 0, Normal is 1, High is 2, and None is 3.

Doc

Text

tblDoc

ImportSet

For imports from CloudNine™ Turbo Import, in version 7.2+ Turbo Import sets will reflect the Import Name in this field.

Import Set 001

Doc

Text

ImportSessions

ImportStation

Name of the computer that imported a document.

ex: Laptop01

Doc

Text

tblDoc

InReplyToID

IntMsgID of the e-mail replied to.

Doc

Memo

tblDoc

IntMsgID

Internet Message ID assigned to an e-mail message by the outgoing mail server.

Doc

Memo

tblDoc

IsRedacted

Redaction is merged on the page.

Y=Yes (merged redaction exists)

<blank>=
Page does not contain a merged redaction

Page

Text

tblPage

Keywords

Keywords extracted from the metadata of the native file.

ex: LAW

Doc

Memo

tblDoc

Language

Lists the first 5 languages found in the document.

ex: English; Japanese; Spanish

Doc

varchar (SQL) or text (Access)

tblDoc

LastAuthor

Last Saved By field value pulled from metadata of the native file.

ex: Joe L. Author

Doc

Text

tblDoc

MailStore

(Exports only - does not exist in LAW case database) Fully qualified original path to mail store (including filename).

ex: D:\MailStores\Sample.pst

Doc

N/A

N/A

MD5Hash

Unique identifier, similar to a "fingerprint", extracted from all files imported via ED Loader or Turbo Import. Uses 128-bit encryption. May be used for deduping purposes.

ex: D564668821C34200FF3E32C9BFDCCC80

Doc

Text

tblDoc

MsgClass

Outlook bound property indicating type of entry in store.

ex: IPM.Note

Doc

Text

tblDoc

NativeFile

Not currently utilized in LAW for electronic discovery cases, except for native files imported into a LAW case from CloudNine™ Explore using the LAW Direct export.

N/A for all files except files imported from LAW Direct export.

For files imported into an existing LAW case:

...\Cases\[LAW case name]\$EDD\$NativeFiles\

For files imported into a LAW case created by a LAW Direct export:

...\Cases\[ED Loader case name]\$EDD\$NativeFiles\

Doc

Memo

tblDoc

ND_ClusterID

A unique ID for each near-duplicate document cluster. Documents in a cluster may be similar, but not as closely related as documents in the near-duplicate family, and some documents in a cluster may not be similar, but are connected by a chain of relationships between documents.

ex: 00000017

Doc

Text

tblDoc

ND_ContentHash

Identifies exact duplicates. If documents have the same hash value in the ND_ContentHash field, they share the exact same text, even if the documents have different metadata or file formats.

ex: 230554D8C9CB9A4BCDD6E2B49244D91BBFB6A8DC

Doc

Text

tblDoc

ND_FamilyID

A unique ID for each near-duplicate document family. All documents within the same near-duplicate family will have the same ID in the ND_FamilyID field.

The ND_FamilyID value matches the master document's ID value, but is padded to eight digits.

For example, if the master ID = 1. The corresponding ND_FamilyID value = 00000001.

ex: 00000112

Doc

Text

tblDoc

ND_IsMaster

Indicates whether the document is the master document.

Within a family, the master document is the one with the greatest overall similarity to all the other documents in the family. It has to be a near-duplicate of every other document in the family.

Note: Documents that are not part of a near-duplicate family will also have a Y (Yes) value in the field.

Y=Yes

N=No

Doc

Text

tblDoc

ND_ResultSet

Used for internal tracking purposes by the near-duplicate processing utility. Indicates the near-duplicate index revision that the ND_* fields for the current record represent.

ex: 2

Doc

Text

tblDoc

ND_Similarity

Displays the percentage of similarity between the document and its master document.

Within a family, the master document is the one with the greatest overall similarity to all the other documents in the family. It has to be a near-duplicate of every other document in the family.

ex: 85, 100

Doc

Numeric

tblDoc

ND_Sort

A document’s sort order ID. The Near-Duplicate Analysis utility sorts documents based on document similarity. The closer documents are to one another, the closer their sort order ID will be to each other.

ex: 2284, 2285, 2330, 2286

Doc

Numeric

tblDoc

NumAttach

(Exports only - does not exist in LAW case database) Total number of records attached to the document. Value will always be 0 (zero) for actual attachment records.

ex: 2

Doc

N/A

N/A

OcrAccuracy

The percentage of accuracy for the file's document-level OCR. This field will be blank for a document when the OCR was transferred from CloudNine™ Explore.

ex: 10, 99, 100

Doc

Numeric

tblDoc

OcrFlag

Page-level OCR status of each page in a document.

Y=Page flagged for OCR

N=Page not flagged

C=Page is complete

E=Error occurred OCRing page

Page

Text

tblPage

OcrStatus

Doc-level OCR status of a document.

Y=One or more pages flagged for OCR

N=No pages flagged

C=OCR complete on document

I=OCR was cancelled

E=Error occurred OCRing document

P=Processing (special flag used by LAW during OCR)

Doc

Text

tblDoc

Organization

Company field extracted from metadata of native file.

ex: CloudNine

Doc

Memo

tblDoc

OrigExt

Original file extension of native file, if "auto-assign ext." option was enabled and file was suspect.

ex: PDF

Doc

Text

tblDoc

Page

Page number of each page in a document.

Page

Numeric

tblPage

Page ID

ID number assigned by user to pages of documents (images only).

ex: ABC0001

Page

Text

tblPage

PageColor

Stores the color information at a page level for scanned and imported images, as well as images created during a TIFF conversion. See the following Help topic for more information: Administration->Tracking Page Source, Size, and Color.

Black & White (1)

Color (2)

Grayscale (3)

Page

Lookup

tblPage.ColorID

PageFilename

Path to TIFF image or PDF  file that was a result of a TIFF conversion in CloudNine™ LAW. Path is relative to $ImageArchive folder, located in case folder.

ex: 00\00\00\01.tif

Page

Text

tblPage

PageHeight

Stores the height of an image at a page level for scanned and imported images, as well as images created during a TIFF conversion. See the following Help topic for more information: Administration->Tracking Page Source, Size, and Color.

ex: 11.50

Page

Numeric

tblPage

PageSize

Stores the page size of an image at a page level for scanned and imported images, as well as images created during a TIFF conversion. See the following Help topic for more information: Administration->Tracking Page Source, Size, and Color.

Letter (1)

Legal (2)

Double Letter (3)

Oversized (4)

Page

Lookup

tblPage.PageSizeID

PageSource

Stores the source of an image at a page level for scanned and imported images, as well as images created during a TIFF conversion. See the following Help topic for more information: Administration->Tracking Page Source, Size, and Color.

Feeder (1)

Flatbed (2)

Imported (3)

TIFF Conversion (4)

Manual TIFF Conversion (5)

Page

Lookup

tblPage.SourceID

PageWidth

Stores the width of an image at a page level for scanned and imported images, as well as images created during a TIFF conversion. See the following Help topic for more information: Administration->Tracking Page Source, Size, and Color.

ex: 8.5

Page

Numeric

tblPage

ParentID

(Exports only - does not exist in LAW case database) Populated only for attachments, this field will display the Image Tag field value of the attachment record's parent. For example, if the Image Tag is set to "DocID", the parent record's DocID value will be listed as the ParentID for the attachments.

ex: ID00001

Doc

N/A

N/A

Path

Folder path for LAW records, relative to root case folder, as shown in the tree view in CloudNine™ LAW's main interface. Physical files may not exist in this path in Windows, depending on how the files were imported or scanned into CloudNine™ LAW. For more information on storage locations, please see the Help topics under Acquiring Documents.

001Source\001Box

Doc

Text

tblDoc

PgCount

Number of pages in a document (image records).

ex: 250

Doc

Numeric

tblDoc

Placeholder_Name

Determines whether a document placeholder image is generated instead of a document image if LAW attempts to convert the document to a TIFF file.

Blank or a predefined or custom document placeholder template name. Custom placeholder templates are created from the Separator Page Options dialog box.

Doc

List

tblDoc

PrevErrMsg

If a record is successfully converted to TIFF or PDF, the ErrorMsg field is cleared and any existing value in that field is prepended to the PrevErrMsg field for reference.

Doc

Memo

PrintJobName

Displays the name of the job in the print spooler for TIFF conversions. This field allows additional errors to be logged if multiple jobs are detected in the spooler for a conversion or the name of the job in the spooler does not match the expected job name for a document. *NOTE: Special attention must be given to any errors prefixed with "Multiple jobs detected" or "Print job name does not match expected format" to inspect the captured image against the original for correctness.

0DB7AC7F42A84562A2749BF95483F43B_5_05.ntv.xls

Doc

Text

tblDoc

ReadReceipt

Read receipt request notification for e-mail messages.

Y=Yes (read receipt requested)

N=No

<null>=Attachments and e-docs will have null value.

Doc

Text

tblDoc

RecordType

(Exports only - does not exist in LAW case database) Lists the record type for each entry in the load file.

IMAGE;LOOSE E-MAIL;E-MAIL;E-DOC;IMAGE ATTACHMENT;LOOSE E-MAIL ATTACHMENT;E-MAIL ATTACHMENT;E-DOC ATTACHMENT;LOOSE E-MAIL ATTACHMENT (E-MAIL);E-MAIL ATTACHMENT (E-MAIL);

E-DOC ATTACHMENT (E-MAIL)

Doc

N/A

N/A

Revision

Revision number extracted from metadata of native file.

ex: 18

Doc

Text

tblDoc

Sensitivity

Sensitivity field extracted from e-mail messages.

ex: Private

Doc

Text

tblDoc

Sha1Hash

Unique identifier, similar to a "fingerprint", extracted from all files imported via ED Loader or Turbo Import. Uses 160-bit encryption. May be used for deduping purposes.

ex: B68F4F57223CA7DA3584BAD7ECF111B8044F8631

Doc

Text

tblDoc

SourceApp

Source application assigned to the native file, as specified in the file type database. This application will be used to print the file during the e-Print and TIFF Conversion batch processes.

<No Source Specified>

Adobe Acrobat

AutoVue Suite

Binary/Hex Printer

Corel WordPerfect

eDrawings Viewer

Image Printer

Internet Explorer

IrfanView

Law PDF

Microsoft Excel

Microsoft Outlook

Microsoft PowerPoint

Microsoft Project

Microsoft Visio

Microsoft Word

Native PDF Printer

Quick View Plus

Shell Printer

Snapshot Viewer

Text/RTF Printer

VoloView Express

Doc

List

tblDoc

SourceFile

Fully qualified original path (including filename) to original loose e-mail message. Field is blank for all other types.

ex: D:\001\test.msg

Doc

Memo

tblDoc

SpeakerNotes

PowerPoint document contains speaker notes.

Y=Yes

N=No

Doc

Text

Extended

Subject

Subject field value extracted from metadata of native file.

Subject field is for e-docs only. EMail_Subject field is for e-mail messages.

ex: LAW

Doc

Text

tblDoc

SuspectExt

Flagged with "Y" value for files deemed suspect during the validation process, meaning the original file extension did not represent the true file type.

Y=Considered suspect

N=Not a suspect file

Doc

Text

tblDoc

SuspectOLE

Document suspected to contain embedded files.

Y=Contains embedded files.

N=Does not contain embedded files.

Doc

Text

tblDoc

Template

Template field value pulled from metadata of the native file.

ex: Normal.dot

Doc

Text

tblDoc

TextFilePath

Full path to the linked text file associated with a document imported using the load file import. This field is populated when load files are imported into a case with the "Link to source files in place when importing load files" check box selected on the Preferences tab in the Options dialog box (Tools > Options).

ex: C:\Docs\Vol001\007\00011157.txt

Doc

Memo

tblDoc

TextPStatus

Status of text extraction that occurs as files are converted to TIFF images or PDF files (TIFF Conversion batch process). "Save text with images" must be enabled in order for the TIFF engine to attempt text extraction.

C=Text was extracted during TIFF conversion.

N=No text was extracted during TIFF conversion.

Doc

Text

tblDoc

TextXStatus

For files imported using ED Loader or Turbo Import, the status of native text extraction that occurs during the import.
 

For files exported from CloudNine™ Explore using the LAW Direct export, the status of native text extraction for the file in CloudNine™ Explore when the file is exported.

C=Text extracted successfully from native file.

N=No text was extracted.

E=Error occurred extracting text, see ErrorMsg field.

Doc

Text

tblDoc

ThreadID

Tracks e-mail threads imported via ED Loader or Turbo Import from Outlook stores and from loose MSG files. Attachments to e-mails receiving a value for the ThreadID are populated with the ThreadID of the corresponding parent e-mail.  

Populated with the leftmost 22 characters of ConversationIndex field.

Doc

Text

tblDoc

TiffStatus

Status of TIFF conversion.

Note: Values in this field will not control which files are converted to TIFF files, and which are not. Any files selected for TIFF conversion in the Batch Process form will be converted to TIFF or given a placeholder (if enabled) regardless of this field.

Y=Flagged for converting to TIFF (any files with a valid source app assigned will be flagged after ED import)

C=File was converted to TIFF file

E=Error occurred and was logged during TIFF or  PDF conversion(see ErrorMsg field)

W=Warning was logged during TIFF or  PDF conversion

N=File not flagged for converting to TIFF (no valid source app assigned during ED import, <No Source Specified> value is assigned)

P=Placeholder printed for the document

Doc

Text

tblDoc

TimeAccessed

Stores the last accessed time from the properties of the file. Note: Many functions will cause this value to be updated by Windows (e.g., viewing file properties, dragging and dropping) and therefore this time will often be inaccurate.

To avoid this situation,prior to handling the data, run the DisableLastAccessUpdate.reg file located in the \LAW50 folder (same folder as law50.exe)  (requires reboot after running). This will prevent updates to this value (applies to LAW DateAccessed field also) by Windows while the file is being handled throughout the project. To re-enable the registry setting, run the EnableLastAccessUpdate.reg file located in the same folder.

Doc

Text

tblDoc

TimeAppEnd

Appointment end time for calendar items.

Doc

Text

tblDoc

TimeAppStart

Appointment start time for calendar items.

Doc

Text

tblDoc

TimeCreated

Creation time of the native file.

Doc

Text

tblDoc

TimeLastMod

Time native file was last modified.

Doc

Text

tblDoc

TimeLastPrnt

Time native file was last printed (Office documents).

Doc

Text

tblDoc

TimeRcvd

Time the e-mail message was received.

Doc

Text

tblDoc

TimeSent

Time the e-mail message was sent.

Doc

Text

tblDoc

TimeZoneProc

Time zone where item was first processed.

Doc

Text

tblDoc

Title

Title field value extracted from the metadata of the native file.

Doc

Text

tblDoc

To

Main recipient(s) of the e-mail message.

Doc

Memo

tblDoc

Unread

E-mail has not been read.

Y=Yes

N=No

Doc

Text

tblDoc

UserId

Not currently utilized in CloudNine™ LAW.

N/A

Doc

Numeric

tblDoc

Volume

Stores volume ID, as listed in tblVolume in LAW case database.

Doc

Numeric

tblVolume