DataSets
Stores dataset definitions that structure reporting and analytics output. This table supports visualization, metric aggregation, and cross-module data modeling.
Columns
| Name | Type | ReadOnly | Description |
| Acl_Team_Names | String | True |
The list of team names that are associated with the data set record through team-based access control. |
| Acl_Team_Set_Id | String | False |
The unique identifier (Id) of the team set that is associated with the data set to support shared ownership and security permissions. |
| Body_Back_Color | String | False |
The background color that is used for the main body section of the rendered output for this data set. |
| Body_Text_Color | String | False |
The text color that is used for the main body content when the data set is displayed or exported. |
| Created_By | String | True |
The Id of the user who created the data set record. |
| Custom_Layout | String | False |
The layout definition that determines how the data set is structured and displayed in reports or dashboards. |
| Date_Entered | Datetime | True |
The date and time when the data set record was created. |
| Date_Modified | Datetime | True |
The date and time when the data set record was last modified. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the data set record is marked for deletion. It returns a value of 'false' when the record remains active as part of standard soft-delete lifecycle behavior. |
| Description | String | False |
A descriptive summary that explains the purpose, content, or formatting intent of the data set. |
| Exportable | Bool | False |
A Boolean field that returns a value of 'true' when the data set can be exported from the system. It returns a value of 'false' when export functionality is restricted. |
| Font_Size | String | False |
The font size that is used when rendering the text elements of the data set in reports or dashboards. |
| Header | Bool | False |
A Boolean field that returns a value of 'true' when the data set includes a header row. It returns a value of 'false' when the data set is configured without a header section. |
| Header_Back_Color | String | False |
The background color that is used for the header section of the data set display. |
| Header_Text_Color | String | False |
The text color that is used for any header labels or titles in the data set display. |
| Id [KEY] | String | True |
The Id for the data set record. |
| List_Order_Y | Int | True |
The vertical ordering priority that is used when this data set appears in lists, dashboards, or composite report layouts. |
| Modified_User_Id | String | True |
The Id of the user who last modified the data set record. |
| Name | String | False |
The display name assigned to the data set, used for selection, filtering, and reporting configuration. |
| Output_Default | String | False |
The default output format or layout style that is applied when the data set is rendered. |
| Parent_Id | String | False |
The Id of the parent data set from which this data set inherits layout or configuration values. |
| Parent_Name | String | True |
The display name of the parent data set from which configuration settings are inherited. |
| Prespace_Y | Bool | False |
A Boolean field that returns a value of 'true' when additional vertical spacing is inserted above the data set in the rendered output. It returns a value of 'false' when no extra spacing is applied. |
| Query_Id | String | False |
The Id of the custom query that retrieves the data used in this data set. |
| Query_Name | String | False |
The display name of the custom query that supplies the data used in this data set. |
| Report_Id | String | False |
The Id of the report that uses this data set as part of its layout or data retrieval configuration. |
| Report_Name | String | False |
The display name of the report that consumes this data set for rendering, printing, or dashboard display. |
| Table_Width | String | False |
The width value that is applied to the table representation of the data set when it is rendered. |
| Table_Width_Type | String | False |
The unit type that is used for the table width value, such as fixed units or percentage of available layout space. |
| Team_Count | String | False |
The number of teams that are associated with the data set record for access control purposes. |
| Team_Id | String | False |
The Id of the primary team that is assigned to the data set record. |
| Team_Name | String | False |
The display name of the primary team that is assigned to the data set record. |
| Team_Set_Id | String | False |
The Id of the team set that grants shared access to the data set record. |
| Use_Prev_Header | Bool | False |
A Boolean field that returns a value of 'true' when the data set inherits the header formatting from its parent data set. It returns a value of 'false' when the header formatting is defined independently. |