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

Close relationships within degrees of separation