Administration > Database Administration > About Databases

To help you plan and create your databases, we have created a list of the standard Concordance Desktop database fields, including administrative fields:

Basic Database Fields

Field Name	Field Description	Possible Values/Examples	Load File	Email & Attachments	E-Docs
CNDCN	A unique identifier assigned to each record.	0000001	√	√	√
ATTACHMENT	Populates a list of the parent document and its attachments.	Ex: ABC0002;ABC0003		√
CONVERSINDEX	E-mail thread identification.	Ex: 01C72AC4CB0FC3953C5FA8E149389B522EFF595EF9FB		√
FROM	Author of the e-mail message.			√
TO	Main recipient(s) of the e-mail message.			√
CC	Recipient(s) of "Carbon Copies" of the e-mail message.			√
BCC	Recipient(s) of "Blind Carbon Copies" of the e-mail message.			√
TITLE	Title field value extracted from the metadata of the native file.		√	√	√
SUBJECT	Subject of the e-mail message.	Ex: FW: Concordance Desktop	√	√	√
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	√	√	√
AUTHOR	Author field value pulled from metadata of the native file.		√	√	√
COMPANY	Name of the company that created the document.		√	√	√
CATEGORY	Category field value pulled from metadata of the native file.	Ex. Software	√	√	√
KEYWORDS	Keywords extracted from the metadata of the native file.		√	√	√
PRODUCER	The name of the PDF producer.		√	√	√
CREATOR	The software that created the document.		√	√	√
COMMENTS	Comments field value pulled from the metadata of the native file.		√	√	√
FILEPATH	Contains a clickable hyperlink to the native document in electronic format.		√	√	√
SOURCE	The original folder path or pst path that the file was saved in.		√	√	√
FILEEXT	File extension of native file.	Ex. DOC	√	√	√
FOLDER	The original folder the file was saved in.			√
DATE	The date the original file was created.			√
TIME	The time the email message was received.			√
GMT_DATE	Email received date in GMT.			√
GMT_TIME	Email received time in GMT.			√
MODDATE	Last day the file was modified.		√	√	√
CREATIONDATE	The day the document was created.		√	√	√
PRINTDATE	Last day the document was printed.		√	√	√
BEGATTACH	Displays BegDoc# of parent record.	EX: ABC0001		√
ENDATTACH	EndDoc# of last attached document in family.	EX: ABC0003		√
ATTACHRANGE	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 - ABC0003		√
BEGNO	Displays page ID of first page in a document.		√	√	√
ENDNO	Displays page ID of last page in a document.		√	√	√
TEXT01	Contains document level text.		√	√	√
TEXT02	Overflow field for document level text.		√	√	√
TEXT03	Overflow field for document level text.		√	√	√
TEXT04	Overflow field for document level text.		√	√	√
TEXT05	Overflow field for document level text.		√	√	√
EDITDATE	Last day the document was edited in Concordance Desktop.		√		√
CREATEDDATE	The date the document was added to Concordance Desktop.		√		√
HEADER	Contents of the header in an e-mail message.			√
METADATA	A collection that represents all of the built-in document properties.		√	√	√
MESSAGEID	Outlook identification number.	81F3CC6EBB6FD011917800805FC17836072FDBF2@PANTHERS.RBVDNR.COM		√
MESSAGEINDEX	The index of the message file in the database.			√
ENTRYID	Unique identifier of e-mails in mail stores.	Ex: 1322C3C03649D4418625711400748A13		√
PARENT_DOCID	Parent ID of the document's family.			√
BEGPRODNO	Captures the beginning production number.		√	√	√
ENDPRODNO	Captures the ending production number.		√	√	√

Basic Administrative Fields

Field	Type	Settings
ACCESSID	Numeric	20, 0, Accession, Use to track delete documents Generates a record load order number.
CREATEDATE	Date	Set properties using the Validation command on the Edit menu, normally not keyed or indexed
EDITTRAIL	Paragraph	Set properties using the Validation command on the Edit menu, includes YYYYMMDD, time, time zone, [session # -- assession #] per user
PRODBEG1	Text	Captures beginning Bates #s for first production. Using number suffixes avoids having to rename fields later for additional productions.
PRODEND1	Text	Captures ending Bates #s for first production. Using number suffixes avoids having to rename fields later for additional productions.
PRODNOTES1, PRODNOTES2	Paragraph	Enter pertinent information here about the person who ordered the production, add this on every single record in a production set.
PRODDATE1	Date	Enter the production date here with global edit or AppendTextToField.cpl.
PRODTAGS1	Paragraph	Used to capture tags as they existed at the time of production using the Tag To Field command, Tools > Manage Tags/Issues.
TAGS	Paragraph	Used to hold the names of checked tags generated by the Tag To Field command, Tools > Manage Tags/Issues.
TAGINFO	Paragraph	Used to hold activity generated by the Tag History&Store It.cpl.
CUSTODIAN	Paragraph	Original owner of the data.
REVIEWSTATUS	Paragraph	Name of person who reviewed the file.
ATTYNOTES	Paragraph	Used to hold attorney notes.
ADMIN1, ADMIN2, ADMIN3, ADMIN4	Paragraph	Extra fields to hold data generated later for any reason, make several of them. When you make a new field, you must run a full index so these fields save valuable time. Make some paragraph and some for dates.

Basic database fields

Basic database fields

Basic Database Fields

Field Name

Field Description

Possible Values/Examples

Load File

Email & Attachments

E-Docs

Basic Administrative Fields

Field

Type

Settings