...

Expand
titleAudit

Audit Table

Column

Description

id

docId

folderId

userId

extDocId

extFolder

extUserId

objectType

actionCodeId

actionCodeName

logType

applicationName

ipAddress

clientCode

MatterCode

actionUserName

ticketId

comments

docNumber

hasJounral

version

metadata

createdDate

createdByUserId

camCreatedDate

camCreatedBy

extSystemId

subscriberId

runId

actionDate

extContainerId

extContainerName

Expand
titleSecurity

Security Table

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.

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

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

securityTypeName

N/A

access

Displays the 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 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.

lastchangeUser

Displays the user name who last updated the security

flag

 

docIdHash

Displays the folder Id

...