Versions Compared

Key

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

...

Expand
titleGroups

Groups Table

Column

Description

id

Displays the id of the entry in the groups table in CAM

groupId

Displays the group Id

groupName

Displays the group name

email

The email of the group

office

The office location of the group

groupType

Displays the group type (Internal/External) Internal=0 External=1

groupContainerType

The type of container of the group

extcontainerid

The id of the container (typically = the name)

extcontainername

The container name where the group came from

isCAMGroup

Is a group within CAM for CAM. 0= from any other ext system

subscriberId

Displays the tenant subscriber Id

system

Displays the external system

repositoryId

Displays the repository name

documentDBName

Displays the database name

writeDate

Displays the entry date in CAM

flag

 

created_on

Displays the group creation date

created_by

Displays the user name extid

The external id of the group

Metadata

Displays in JSON format any metadata applied to the group. Comma separated.

CreatedDate

Date the group was created

EditedDate

Date the group was last edited

CreatedbyUserid

User id of the person who created the group

CreatedByUser

The user who created the group

modified_on

Displays the last update date

modified_by

N/A

metadata

N/A

sourceId

Displays the database name

isCabinetGroup

 

repositoryName

Displays the repository nameLastChangeUserid

The userid of the person who last edited the group

LastChangeUser

The user who last edited the group

camCreatedDate

If created in CAM, the created date

camCreatedBy

If created in CAM, the user who created

camEditedDate

If edited in CAM, the date edited

camEditedBy

If edited in CAM, the user who edited

extSystemId

The external system id

subscriberid

The tenant subscriber id

Expand
titleMetadata

Metadata Table

Column

Description

id

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

columnName

Displays the column name mapped to the metadata in CAM

name

Displays the metadata ID

value

Displays the metadata desc

parent

Displays the parent Id for the metadata

attributes

N/A

docSystemKey

Displays the metadata name

objectId

N/A

subscriberId

Displays the tenant subscriber Id

system

Displays the external system name

repositoryId

Displays the repository name in the external system

sourceId

Displays the cabinet/database name

lastEdited

Displays the last edited date and time

createdDate

Displays the metadata created date

createdBy

Displays the user name who created the metadata

modifiedBy

Displays the user name who last modified the metadata

writeDate

Displays the

uidCustomMetadata

 

repositoryName

Displays the repository name

...