Object Tables- Docs, Folders, Metadata

Document Table

This table contains all the documents within CAM.

Query the table by: select * from document limit 100

^Use the document Query type

Column	Description	Keys (Primary/ Foreign)

Column	Description	Keys (Primary/ Foreign)
Id	The internal CAM id of the document row. This is auto-generated by CAM	PK
extId	Displays the row number of the entry in the document table. It is a mandatory field.
extContainerId	If the configured External System is iManage this column displays the database name, followed by the document number and version (e.g. demo!463.1), in case of NetDocuments, this displays the 12 digit document number (e.g. 4816-5122-8805). It is a mandatory field.	FK with extContainerId on externalsystem
name	Name of the document.
extContainerName	If the configured External System is iManage, this column displays the database name, followed by the document number and version (e.g. demo!463.1), in case of NetDocuments, this displays the document name.
description	Displays the description of the document.
number	Displays the document number for iManage. This does not apply for NetDocuments. It is a mandatory field.
folder	This displays the folder name
folderId	This displays the folder id This is auto-generated by CAM
workspaceId	If the configured External System is iManage this column displays the database name, followed by workspace id. (e.g. demo.463.1), in case of NetDocuments,
tabId	The id of the tab used to display the document on a sharepoint site or teams site.
type	Displays the doc type (e.g. csv, BMP, PDF etc.)
typeId	Displays the type Id. This is auto-generated by CAM (folder type id)
etag
ctag
version	Displays the document version number. It is a mandatory field.
sourceId	Displays the database or cabinet name	FK with sourceid on externalsystem
hasAttachment	Flag to indicate if document has an attachment (in case of emails for example)
isdeclared	Indicates if the document is marked as a record
DeclaredDate	Date the document was declared, if isdeclared=1
indexNumber	Number of the index
originalDocketId	If the document was part of a docket, includes that docket id.
dateSent	Displays the message sent date (in case of email)
dateReceived	Displays the message received date (in case of email)
transcriptDate	Date the document was transcripted.
FileName	Displays the file name (without extension)
FileExtension	Displays the doc type (e.g. csv, BMP, PDF etc.)
FilePath	The path of the file (e.g. if the file was stored in a fileshare)
FileSize	The size of the file uploaded. Includes kb/mb/gb designations.
dateFiled	The date the document was filed, e.g. 20/11/2022
sortorder	Allows to sort the documents in a particular order in the workspace.
SortOrderModifiedDate	Date the sort order was modified, e.g. 20/11/2022
orderedById	Id of the ordering schema
orderingDate	Date the ordering occurred, e.g. 20/11/2022
workProductId	If using iManage Work, this is the product id from there.
isDeleted	Flag to indicate if document is deleted from the system. 1/0
importReference	Displays the document ID as a reference for import.
isDeletedToken	If from a SQL based system, the metadata row could have a token as a GUID if the record was deleted.
extLongId	The external system’s long id
extShortId	The external system’s short id
StatusId	Displays the document status id associated to document. This is auto generated by CAM.
SecurityLevelId	Sets an id based on the security level set on the document. This is auto-generated by CAM. 0 - no access 1 - read 2- read-write 3- full access
checkedOutLocation	Displays the path where the file is checked out
CheckedOutPath	The path of the checked out file
checkedOutBy	Displays the user name who has checked out the file
checkedoutbyid	The id of the person who checked out the document. This is auto-generated by CAM
checkedOutDate	Displays the file checkout date
checkedoutDueDate	Displays the due date for the checked out file.
checkedoutComment	The comment left when a file is checked out.
isOffline	Is the document an offline stored document?
csJobId
securityLevel	Displays the document security (public/private/view) 1- public 2-private 3- view
emailid	Introduced new column in document table. It contains id/msg_id from iManage and NetDocuments respectively.
emailto	Displays the email recipient name
emailfrom	Displays the email sender name
emailcc	Displays the user name added in the cc field in the email
emailBcc	Displays the user name added in the Bcc field in the email
emailSubject	Displays the subject/title added in the subject field in the email.
emailMessageId	This is an existing column. It contains the conversation ID, used to group emails. Note: emailMessageid later will be renamed as emailConversationId
isExternalEmail	Is this an external email outside the firm?
checksum	A checksum of changes in sql.
extDocRefId	Id of the refiled external document
targetContainerId	The id of the target container (netDocuments)
targetContainerName	The name of the target container (netDocuments)
authorId	Displays the author Id associated to the author. This is auto-generated by CAM
author	Displays the document author name
operator	Displays the name of the user who edited the document most recently
operatorId	Displays the operator ID associated to the author. This is auto-generated by CAM
clientCodeId	Displays the client code ID associated to client code. This is auto-generated by CAM
clientCode	This value is updated based on the Auroradb column mapping in the metadata tab.
matterCodeId	Displays the matter code ID associated to matter code. This is auto-generated by CAM
matterCode	This value is updated based on the Auroradb column mapping in the metadata tab.
practiceCodeId	Displays the practice code Id associated to practice code. This is auto-generated by CAM
practiceCode	This value is updated based on the Auroradb column mapping in the metadata tab.
industryCodeId	Displays the industry code Id associated to industry code. This is auto-generated by CAM
industryCode	This value is updated based on the Auroradb column mapping in the metadata tab.
docStatusCode	The document status code from the external system
docStatusCodeid	The document status code id from the external system
jurisdictionCode	Code of the jurisdiction
jurisdictionCodeId	Id for the Code of the jurisdiction
matterType	Displays the matter type
matterTypeId	The id of the matter type
matterSubType	The subtype of the matter
matterSubTypeId	The id of the subtype
class	The class of document (document, email, etc)
classId	Displays the class Id associated to class. This is auto-generated by CAM
classCodeId	Displays the class code Id associated to class code. This is auto-generated by CAM
classCode	Code of the class. E.g. if class is document, typically the code is DOC
subClassCode	This is updated for iManage only
commentsId	Displays the comments Id associated to comments. This is auto-generated by CAM
comments	Displays the comments added to the document
isLatest	Flag to indicate if document updated recently
isCheckedOut	Flag to indicate if document is checked out
isApproved	Is the document approved?
isArchived	Is the document archived?
isAutoversioning	Is the document autoversioned, instead of manually versioned?
GUID	A guid value from sql or source system.
importedById	Id of the system imported by into CAM
importedDate	Displays the date when the file was imported to CAM
lastChangeDate	Displays the last update date
lastChangeUserId	Displays the last change user id associated to the last change user. This is auto-generated by CAM.
lastChangeUser	Displays the user name who last updated the document
c1-c45	Displays the custom metadata fields
n1-n10	Displays the custom metadata fields
d1-d10