Updated: 10/12/2009
Version: Control 4.4
Table Purpose, Usage, and Notes
This table is used to store the layout and properties of user Dashboards. System dashboards are not contained here.
Information on Table Data
- ClassTypeIDs Stored in Table:
- 31000 - Dashboard
- DashboardType
- 0 CalendarDesigner
- 1 CalendarView
- 2 Check In
- 3 Course Monitor
- 4 Course Setup
- 5 Accounting
- 6 Home
Table Structure
| ~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
| Dashboard.ClassTypeID | int | Identifier for the Type of Object | |||||
| Dashboard.ColumnCount | int | Number of columns the dashboard is divided into. | |||||
| Dashboard.DashboardName | varchar(25) | Name of the dashboard. | |||||
| Dashboard.DashboardType | int | Enumerated Type - This value will be 6 if you clone an Accounting dashboard or create a new dashboard. It will be 5 if you clone a Home dashboard. This appears to have no affect on the dashboard or its usage. | |||||
| Dashboard.DashboardTypeText | varchar(50) | Text version DashboardType | |||||
| Dashboard.DashboardXML | text | This text contains the information about the instruments that are present on the dashboard and their options. | |||||
| Dashboard.ExcludedFranchises | varchar(100) | ||||||
| Dashboard.ID | int | Primary Key for the Table | |||||
| Dashboard.IncludedFranchises | varchar(100) | ||||||
| Dashboard.IsActive | bit | Indicates if Enabled. 1Record is Active, 0Record is Not Active | |||||
| Dashboard.IsLocked | bit | 1Cannot alter instruments on the dashboard. | |||||
| Dashboard.IsShared | bit | 1Other employees can use this dashboard. | |||||
| Dashboard.IsSystem | bit | Used to Mark Required Records | |||||
| Dashboard.ModifiedByComputer | varchar(25) | HostName of computer that last modified this record | |||||
| Dashboard.ModifiedByUser | varchar(25) | Windows User who last modified this record | |||||
| Dashboard.ModifiedDate | datetime | DateTime this Record was last modified | |||||
| Dashboard.SeqID | int | ||||||
| Dashboard.ShowOnMenu | bit | 1Display on the dashboard drop-down. | |||||
| Dashboard.StoreID | int | Not Used. | |||||
| Dashboard.UserClassTypeID | int | 3500 or NULL. | |||||
| Dashboard.UserID | int | NULL if the User who owned this Dashboard has been deleted and the dashboard again saved. In either case the dashboard will be considered owned by anyone who opens it until it is deleted. | SQL Structure - UserName.ID | ||||
| Dashboard.UserStoreID | int | Not Used. |
Related Tables
sql_structure_-_username_table
You could leave a comment if you were logged in.