GridViewFiles


Description

Grid view configuration management - Configuration table storing grid view definitions, filters, settings, and customizations for data display interfaces. This table manages user interface configurations including filter content, grid settings, data sources, custom fields, and application assignments to support customizable data views and reporting interfaces across the healthcare system.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
GridID int identity 4 null

Grid primary key - Unique identifier for each grid view configuration

FilterContent nvarchar 1073741823 null

Filter configuration - JSON or XML content defining filter criteria for the grid

GridSetting nvarchar 1073741823 null

Grid settings - Configuration settings for grid display and behavior

XmlDataSource nvarchar 1073741823 null

Data source XML - XML configuration defining the data source for the grid

GridName varchar 100 null

Grid name - Descriptive name for the grid view

GridDesc varchar 500 null

Grid description - Detailed description of the grid’s purpose and functionality

ColumnKey varchar 100 null

Column key - Key identifier for column configuration

CustomFields nvarchar 1073741823 null

Custom fields - Configuration for custom fields in the grid

AppsAssigned varchar 100 null

Assigned applications - Applications that have access to this grid view

CreateBy int 4 null

Created by user - UserID of the person who created the grid configuration

DateCreateBy datetime 16,3 null

Creation date - Date when the grid configuration was created

UpdateBy int 4 null

Updated by user - UserID of the person who last updated the grid

DateUpdateBy datetime 16,3 null

Last update date - Date when the grid configuration was last updated

QueryString nvarchar 1073741823 null

Query string - SQL query or query parameters for data retrieval

GetFormId int 4 (NULL)

Form reference - Links to form configuration if applicable

PublishToId int 4 (NULL)

Publish target - Target for publishing grid data

LayerItemMarketId int 4 null

Layer market reference - Links to layer item market configuration

Indexes

Constraint Name Type Sort Column(s)
PK_GridViewFiles Primary key Asc GridID

Relationships