Teams
Stores team definitions that determine row-level access and shared ownership. This table supports collaboration and access control.
Columns
| Name | Type | ReadOnly | Description |
| Associated_User_Id | String | False |
The unique identifier (Id) of the user who is associated with this team. This value defines the relationship between the team and its member or owner. |
| Commentlog | String | True |
The comment log entries that are associated with this team record. This field stores collaboration notes or administrative history. |
| Created_By | String | True |
The Id of the user who created this team record. This value identifies the record author for auditing and ownership tracking. |
| Created_By_Name | String | True |
The display name of the user who created this team record. This value is shown for clarity in the user interface and reports. |
| Date_Entered | Datetime | True |
The date and time when this team record was created. This value supports lifecycle tracking and audit review. |
| Date_Modified | Datetime | True |
The date and time when this team record was most recently updated. This field supports change tracking and version transparency. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when this team record is marked as deleted. It returns a value of 'false' when the record remains active and available. |
| Description | String | False |
A detailed description of the team. This field can include purpose, role notes, or organizational context. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following this team record to receive activity updates. It returns a value of 'false' when the user is not following the record. |
| Id [KEY] | String | True |
The Id for this team record. This value is used to reference and manage the team throughout the system. |
| Locked_Fields | String | True |
The list of fields that are restricted from editing for this team record. This prevents modification of protected or system-managed fields. |
| Modified_By_Name | String | True |
The display name of the user who most recently modified this team record. This value provides visibility into update history. |
| Modified_User_Id | String | True |
The Id of the user who most recently updated this team record. This value identifies the source of the latest change. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the team record is marked as a favorite by the current user. It returns a value of 'false' when it is not marked as a favorite. |
| Name | String | False |
The primary display name of the team. This value is used throughout the interface and reports. |
| Name_2 | String | False |
An alternate or secondary display name for the team. This value is used when additional naming detail is required. |
| Private | Bool | False |
A Boolean field that returns a value of 'true' when the team is designated as private and visibility is restricted. It returns a value of 'false' when the team is publicly visible within allowed access controls. |
| Sync_Key | String | True |
The synchronization key that is used to match this team record with external systems. This value supports data consistency across integrations. |