Categories
Stores hierarchical category definitions for organizing content and records. This table supports knowledge management, product classification, and list filtering.
Columns
| Name | Type | ReadOnly | Description |
| Created_By | String | True |
The Id of the user who created this category record. This field supports origin tracking and audit history. |
| Created_By_Name | String | True |
The name of the user who created this category record. This field provides a readable reference for the Created_By field. |
| Date_Entered | Datetime | True |
The date and time when this category record was created. This field supports lifecycle and audit reporting. |
| Date_Modified | Datetime | True |
The date and time when this category record was most recently modified. This field supports update tracking and change review. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the category record is marked for deletion. It returns a value of 'false' when the record remains active. This field supports soft-delete workflows. |
| Description | String | False |
The full text description of the category. This field provides context for how the category is used. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user follows this category to receive updates. It returns a value of 'false' when the user does not follow the category. |
| Id [KEY] | String | True |
The unique identifier (Id) for this category record. This field ensures reliable referencing across modules and reporting processes. |
| Is_External | Bool | False |
A Boolean field that returns a value of 'true' when the category is designated for use in external systems or integrations. It returns a value of 'false' when the category is internal only. |
| Lft | Int | False |
The left boundary index of the category in the hierarchical tree structure. This field is used to determine category ordering and nesting by using the nested set model. |
| Locked_Fields | String | True |
The list of fields that cannot be modified for this record. This field supports protecting data integrity when certain attributes must remain unchanged. |
| Lvl | Int | False |
The depth level of the category in the hierarchy. A value of '0' indicates a top-level category, and higher values indicate nested subcategories. |
| Modified_By_Name | String | True |
The name of the user who most recently modified this category record. This field provides a readable reference for the Modified_User_Id field. |
| Modified_User_Id | String | True |
The Id of the user who most recently modified this category record. This field supports audit tracking and accountability. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the current user marks this category as a favorite. It returns a value of 'false' when the record is not marked as a favorite. |
| Name | String | False |
The display name of the category. This field is used to identify the category across the application. |
| Rgt | Int | False |
The right boundary index of the category in the hierarchical tree structure. This field is used with the left index to calculate nesting, sibling relationships, and hierarchical depth. |
| Root | String | False |
The Id of the top-level (root) category in the hierarchy to which this category belongs. This field anchors the category within the full hierarchical tree. |
| Source_Id | String | False |
The Id of the originating source record if the category is created through integration or automated processes. This field supports traceability. |
| Source_Meta | String | False |
Additional metadata related to the source of the category. This field provides integration or system-level context. |
| Source_Type | String | False |
The type of system or record that originates the category. This field supports classification in multi-system environments. |
| Sync_Key | String | True |
The synchronization key that links this category record to external systems. This field ensures consistency during data replication and integration. |