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? | |
csJobIdsecurityLevelId | Displays the security level ID associated to security. This is auto-generated by CAM | | |
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 | Displays the custom metadata fields | |
runId | The job id of the run. | |
objectId | Id of the particular object reference type (matter,client etc) | |
subscriberId | The subscriberid from Office365 | |
system | Displays the external system name | FK with name on externalsystem |
repositoryId | Displays the repository name | FK with repositoryid on externalsystem |
createdBy | Displays the user name who created the file | |
createdDate | Displays the file creation date | |
writeDate | Displays the date the document was updated in CAM | |
targetDatabase | The target database of a job to move a document/folder/workspace | |
targetId | The id of the target database | |
docId | Displays the auto generated document id. | |
docIdHash | A hash reference of the docid | |
isApproved | Flag to tell if the document/object is approved | |
isArchived | Flag to tell if the document/object is archived | |
isAutoversioning | Flag to show if the document has been autoversioned by the source. | |
isEcho | | |
isExternal | Is an external stored document? | |
isExternalUser | Is for an external user? | |
isFavorite | Is a favorited document? | |
isLocked | Is the document locked? | |
isOfficialLocked | Is the document officially locked from the source? | |
isQueueforIndexing | Is the document queued for indexing? | |
isSigned | Is the document signed? Applies to NetDocuments only. | |
repositoryName | Displays the repository name | |