Facts spreadsheet field list

Trait Fields

Date and Time

The date and time when the fact occurred.

Type a date in this field or use the Date Stamper. You can enter fuzzy dates such as 07/??/97, and use date status indicators such as <06/15/97 (i.e., before 06/15/97). If two or more facts have the same date and time value, you can also add a sequence number (e.g., #1, #2).

Fact Text

The text defining the fact.

Type up to 10,000 characters of text. To ensure consistency, use object short names.

Linked Issues

The issues linked to the fact.

Type the short name of the issues linked to the fact. you can link as many issues as you want to a singe fact -- just keep typing the issue short name.

Potential Source(s)

The potential source(s) for a fact (e.g., the short name of a witness you hope will give you this fact during his or her deposition).

Type up to 10,000 characters describing the potential sources of the fact. To ensure consistency, use object short names.

Tip: To make the most of CaseMap, list the facts you're hoping to develop before having definitive sources for them.

Related Files

Files that have been manually linked to a record in the spreadsheet. This field is only used in rare instances when it's deemed absolutely necessary to have additional files linked to a record.

Tip: Normally, the Linked File field is used to link a file to a record, especially when using the Send to CaseMap feature. Documents that have been linked into CaseMap can be linked to records in other spreadsheets by using the document short name in any description field that displays the chain-link symbol in the field title.

Read-only. Click the Ellipsis button in this field to add or remove related files.

Use with Caution: Files added to this field through the Related Files dialog box have to be individually re-linked if the files are moved. Files linked to this field will not be included in search results or reports. Related files will not be linked to other spreadsheets.

Source(s)

The definitive sources of the fact and their location (e.g., ArndtDepo, Pg. 112, Line 14).

Type up to 10,000 characters describing the sources of the fact. To ensure consistency, use object short names.

Source Quote

The text sent to CaseMap from an external application.

Holds up to 10,000 characters of a source quote from content from another program. To ensure consistency, use object short names.

Status+

Whether the fact is disputed and by which party. You can also use this field to indicate that a fact is prospective (i.e., one for which you hope to develop sources).

Select an existing value such as Undisputed, Disputed by Opposition, or Prospective. If the value you want is not listed, add a new value to the list.

Status Description

If the fact is disputed, a description of why it is.

Type up to 10,000 characters of text. To ensure consistency, use object short names.

Evaluation Fields

Key

An indication of whether a fact is particularly important.

To indicate an issue is key, select the check box.

Tip: You can check the box by double-clicking it or by pressing the SPACEBAR.

# Fields

# Issues

The number of issues linked to the fact.

Read-only. CaseMap counts the links for you. Double-click to display a list of the issues linked to the fact.

# Objects

The number of objects mentioned by short name on the Facts spreadsheet.

Read-only. CaseMap counts the links for you. Double-click to display a list of the objects linked to the fact.

# Open Questions

The number of open questions linked to the fact. Open questions have an answer status of Unaddressed or In Progress.

Read-only. CaseMap counts the links for you. Double-click to display a list of the open questions linked to the fact.

# Questions

The number of questions linked to the fact.

Read-only. CaseMap counts the links for you. Double-click to display a list of all questions linked to the fact.

# Source(s)

The number of objects cited by short name in the Source(s) field.

Read-only. CaseMap counts the links for you. Double-click to display a list of the objects acting as sources.

Update History Fields

Creation Author

The short name of the author who authorized the fact's entry.

Read-only. CaseMap enters the author's short name.

Creation Scribe

The short name of the scribe who entered the fact.

Read-only. CaseMap enters the scribe's short name. If an author acts as a scribe (i.e., enters the fact in CaseMap), the author's name appears in this field.

Creation Time Stamp

The date and time when the fact record was entered.

Read-only. CaseMap enters the date and time for you.

Last Update Author

The short name of the author who requested the last update to the fact.

Read-only. CaseMap enters the author's short name for you.

Last Update Scribe

The short name of the scribe who made the last update to the fact.

Read-only. CaseMap enters the scribe's short name for you. If an author acts as a scribe (i.e., enters the updates), the author's name displays in this field.

Last Update Time Stamp

The date and time when the fact was last updated.

Read-only. CaseMap enters the date and time for you.