Page Comparison

Versions Compared

Version	Old Version 9	New Version 10
Changes made by	René Ponce Carrillo (Deactivated)	Eric Schullek (Unlicensed)
Saved on	Dec 02, 2022	Dec 30, 2022

Key

This line was added.
This line was removed.
Formatting was changed.

...

Displays the object Id associated to the object

Expand

title	Audit

Audit Table

Security Table

Column

Description

Displays the row number of the entry in the security table.

documentId

Displays the document Id associated to the document. This is auto-generated by CAM.

folderId

Displays the folder Id associated to the folder. This is auto-generated by CAM.

userId

Displays the user Id associated to the user. This is auto-generated by CAM.

userName

Displays the user name

groupId

N/A

groupName

N/A

roleId

N/A

denied

Displays if permission is denied to the user (0- allow /1-deny)

accesspermissions

Displays the access permission code assigned to the user

policyId

N/A

expiryDate

Displays the security expiry date

joinDate

Displays the security assigned date

isLatest

Flag to indicate if security has been recently updated

docId

N/A

objectId

Column	Description
id	The internal CAM id for the audit table. Is a mandatory field.
docId	It is a mandatory field if a document is set. Displays the docid.
folderId	It is a mandatory field if a folderid is set.
userId	Displays the user Id associated to the user. Displays the user Id associated to the user.
extDocId	extFolder	extUserId
objectType	Displays the object type.
actionCodeId	actionCodeName	logType	applicationName	ipAddress	clientCode	MatterCode	actionUserName	ticketId	comments	docNumber	hasJournal	version	metadata
createdDate	Displasy the audit creation date.
createdByUserId	camCreatedDate	camCreatedBy	extSystemId
subscriberId	Displays the tenant subscriber Id.
runId	actionDate
extContainerId	If the configured External System is iManage this column displays the database name, followed by the folder number (e.g. demo!1234), in case of NetDocuments, this displays the 12 digit folder number (e.g. 4816-5122-8805). It is a mandatory field.
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.

Expand

title	Security

	The external document id (filled if a document was added/changed/updated/deleted)
extFolder	The external folder id (filled if a folder/workspace was added/changed/updated/deleted)
extUserId	The external userid (filled if a user or security was added/changed/updated/deleted)
objectType	Displays the object type.
actionCodeId	The id of the particular action done on the object. Is a mandatory field.
actionCodeName	The name of the particular action done on the object. Is a mandatory field.
logType	The type of the log.
applicationName	Name of the CAM application module making the modification/addition/deletion.
ipAddress	If the ip address is filled from an external system or user.
clientCode	If a client is changed, this is the client code.
MatterCode	If a matter is changed, this is the matter code.
actionUserName	If a action has a specific user name passed, this will be filled.
ticketId
comments	Any comments left on the audit.
docNumber	If a document was added/changed/updated/deleted, the docnumber is filled.
hasJournal	Set to 1 if a journal is with the object.
version	Version of the object.
metadata	Any metadata added/changed/updated/deleted
createdDate	Displays the audit creation date. Is mandatory.
createdByUserId
camCreatedDate
camCreatedBy
extSystemId
subscriberId	Displays the tenant subscriber Id.
runId
actionDate
extContainerId	If the configured External System is iManage this column displays the database name, followed by the folder number (e.g. demo!1234), in case of NetDocuments, this displays the 12 digit folder number (e.g. 4816-5122-8805). It is a mandatory field.
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.

Displays the parent folder Id associated to the parent folder

Expand

title	Security

Security Table

Folder Table

Column

Description

extid

Displays the row number of the entry in the folder table. It is a mandatory field.

extContainerId

If the configured External System is iManage this column displays the database name, followed by the folder number (e.g. demo!1234), in case of NetDocuments, this displays the 12 digit folder number (e.g. 4816-5122-8805). It is a mandatory field.

folderType

Displays the folder type (e.g. folder/saved search/workspace etc). See chart below: FolderTypeids. It is a mandatory field.

folderdescription

Displays the folder name

parentFolder

Displays the parent folder name.

parentFolderId

Column	Description
id	Displays the row number of the entry in the security table.
documentId	Displays the document Id associated to the document. This is auto-generated by CAM.
objectTypefolderId	Displays the object type.
securityType	Displays the security type assigned (user/group)
securityTypeId	Displays the security type the folder Id associated to the folder. This is auto-generated by CAM.
userId	Displays the user Id associated to the security typeuser. This is auto-generated by CAMsecurityTypeName.
userName	Displays the user name
groupId	N/A
groupName	N/A
roleId	N/A
accessdenied	Displays the access code associated if permission is denied to the user (30- allow /2/1/0-deny)
accessLevelaccesspermissions	Displays the access level permission code assigned to the user (full access/read-write/read only/no-access)defaultSecurity
policyId	N/A
runId	N/A
subscriberId	Displays the tenant subscriber Id
system	Displays the external system
repositoryId	Displays the repository name
documentDBName	Displays the database name
writeDate	Displays
createdDate	Displays the date the security was assigned to the user
createdBy	N/A
lastchangeDate	Displays the last update date
lastchangeUserId	Displays the last change user id associated to the last change userexpiryDate	Displays the security expiry date
joinDate	Displays the security assigned date
isLatest	Flag to indicate if security has been recently updated
docId	N/A
objectId	Displays the object Id associated to the object. This is auto-generated by CAM.
objectType	Displays the object type.
securityType	Displays the security type assigned (user/group)
securityTypeId	Displays the security type Id associated to the security type. This is auto-generated by CAM.lastchangeUser
securityTypeName	N/A
access	Displays the user name who last updated the security
flag
docIdHash	Displays the folder Id

Expand

title	Folder

access code associated to the user (3/2/1/0)
accessLevel	Displays the access level assigned to the user (full access/read-write/read only/no-access)
defaultSecurity	N/A
runId	N/A
subscriberId	Displays the tenant subscriber Id
system	Displays the external system
repositoryId	Displays the repository name
documentDBName	Displays the database name
writeDate	Displays
createdDate	Displays the date the security was assigned to the user
createdBy	N/A
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.

workspaceId

lastchangeUser

Displays the

workspace id associated to the workspace. If the configured External System is iManage this column displays the database name, followed by the workspace

user name who last updated the security
flag
docIdHash	Displays the folder Id

Expand

title	Folder

Folder Table

Column	Description
extid	Displays the row number of the entry in the folder table. It is a mandatory field.
extContainerId	If the configured External System is iManage this column displays the database name, followed by the folder number (e.g. demo!1234), in case of NetDocuments, this displays the 12 digit workspace folder number (e.g. 4816-5122-8805)
documentNumber	N/A
version	N/A
indexNumber	N/A
orderedById	N/A
orderingDate	N/A
isDeleted	N/A
importReference	Displays the folder Id
isDeletedToken	N/A
folderStatusId	N/A
folderStatus	N/A
owner	Displays the folder owner name
ownerId	Displays the folder Id associated to the . It is a mandatory field.
folderType	Displays the folder type (e.g. folder/saved search/workspace etc). See chart below: FolderTypeids. It is a mandatory field.
folderdescription	Displays the folder name
parentFolder	Displays the parent folder name.
parentFolderId	Displays the parent folder Id associated to the parent folder. This is auto-generated by CAM.
securityLevelIdworkspaceId	Displays the security level Id workspace id associated to the security level. This is auto-generated by CAM.
securityLevel	Displays the folder security level (inherit/view/private etc.)
documentClass	This value is updated based on the Auroradb column mapping in the metadata tab.
documentClassId	Displays the document class Id associated to the document classworkspace. If the configured External System is iManage this column displays the database name, followed by the workspace number (e.g. demo!1234), in case of NetDocuments, this displays the 12 digit workspace number (e.g. 4816-5122-8805)
documentNumber	N/A
version	N/A
indexNumber	N/A
orderedById	N/A
orderingDate	N/A
isDeleted	N/A
importReference	Displays the folder Id
isDeletedToken	N/A
folderStatusId	N/A
folderStatus	N/A
owner	Displays the folder owner name
ownerId	Displays the folder Id associated to the folder. This is auto-generated by CAM.
clientCodeIdsecurityLevelId	Displays the client code ID security level Id associated to client codethe security level. This is auto-generated by CAMclientCode.
securityLevel	Displays the folder security level (inherit/view/private etc.)
documentClass	This value is updated based on the Auroradb column mapping in the metadata tab.
documentClassId	Displays the document class Id associated to the document class. This is auto-generated by CAM.
matterCodeIdclientCodeId	Displays the matter client code ID associated to matter client code. This is auto-generated by CAM
matterCodeclientCode	This value is updated based on the Auroradb column mapping in the metadata tab.
practiceCodeIdmatterCodeId	Displays the practice matter code ID associated to practice 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.
matterType	Displays the matter type
matterSubType	This value is updated based on the Auroradb column mapping in the metadata tab.
areaOfLaw	N/A
classCode	N/A
deptCode	N/A
subClassCode	N/A
comments	N/A
matterShortName	N/A
matterFamilyNumber	N/A
matterStatusId	N/A
sourceId	N/A
nblsNumber	N/A
startDate	N/A
closeDate	N/A
retentionStartDate	N/A
retentionEndDate	N/A
filedDate	N/A
hasUnorderedDocuments	N/A
templateId	N/A
location	N/A
responsibleLawyerId	N/A
originatingLawyerId	N/A
billingLawyerId	N/A
officeCode	N/A
countryCode	N/A
juristicationCodeId	N/A
juristicationCode	N/A
courtCode	N/A
judgeCode	N/A
onLegalHold	N/A
legalHoldStartDate	N/A
legalHoldEndDate	N/A
guId	N/A
importedById	N/A
importedDate	Displays the date the folder was imported in 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	N/A
objectId	N/A
createdDate	Displays the folder creation date
createdBy	Displays the user name who created the folder
isLatest	Flag to indicate if the folder was recently updated
subscriberId	Displays the tenant subscriber Id
system	Displays the external system
repositoryId	Displays the repository name
writeDate	Displays
targetDatabase	N/A
targetId	N/A
isApproved	N/A
isArchived	N/A
isAutoversioning	N/A
isEcho	N/A
isExternal	N/A
isExternalUser	N/A
isFavorite	Applies for workspaces
isLocked	N/A
isOfficalLocked	N/A
isQueueforIndexing	N/A
isSigned	N/A
repositoryName	N/A
alternateFolderId	N/A

...

Expand

title	User_groups

User_Groups Table

Column	Description
id	Displays the row number of the entry in the user_group table
userId	Displays the user id associated to the user name. This is auto-generated by CAM.
userSystemId	Displays the user name
groupId	Displays the user id associated to the user name. This is auto-generated by CAM.
groupSystemId	Displays the group name the user is associated to.
subscriberId	Displays the tenant subscriber Id
system	Displays the external system
repositoryId	Displays the repository name
documentDbName	Displays the database name
flag
created_on	Displays the date the user was added to the group
created_by	N/A
modified_on	Displays the last update date
modified_by	N/A
metadata	N/A
sourceId	Displays the database name
repositoryName	Displays the repository name

Expand

title	Folder Type Ids

Folder_Type_Ids Table

Use these Id’s to search for specific folder results in Analytics, or use them in Request Workflow queries specifying specific folder id's.

Folder Type	FolderTypeId
Workspace	1
Folder	2
iManage_Tab	3
iManage_Search_Folder	4
iManage_Category_Folder	5
iManage_Folder_Shortcut	6
iManage_Document_Shortcut	7
ND_Filter	8
ND_Saved_Search	9
iManage_My_Matters	10
iManage_My_Favorites	11
Office_Channel	12
Office_Site	13
Office_Team	14
Office_Onedrive	15
Office_Private_Channel	12
Office_Site	13
Office_Team	14
Office_Onedrive	15
Office_Private_Channel	16
HighQ_Site	17
	18	16
HighQ_Site	17
	18

Expand

title	External System

External System Table

Use the table name external_system_nt in your query.

Column	Description
id	The internal CAM id of each external system.
name	Name of the external system. E.g. iManage, Kira, O365 etc
nickname	A nickname. Typically most people will set this the same as the name.
description	Description of the external system.
type	The system type. Can be 0,1,2
base_url	The url of the cloud based system.
icon_path	Path of where the icons are stored for the system. Is blank if not set (uses CAM default icons).
libraries	If a particular library within the API is used. Most commonly is blank.
active	Is actively used or not. 0 is active, 1 is not.
is_deleted	Marks if the system is deleted from CAM. ) is not deleted. 1 is deleted.
created_user_id	The user id who created the external system connection.
last_modified_user_id	The user id who last modified the external system connection.
created_date	The date created
last_modified_date	The date last modified.