FilterBuilderDataSource


Description

Filter builder data source configuration - Configuration table managing data source definitions for dynamic filter building and report generation. This table stores filter criteria, data source connections, and hierarchical filter relationships to support flexible reporting, data analysis, and user-defined filtering capabilities across healthcare data management systems.

Columns

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

Filter primary key - Unique identifier for each filter data source configuration
ParentId nvarchar 100 √ null

Parent filter reference - Links to parent filter for hierarchical filter structures
FilterName nvarchar 400 √ null

Filter name - Descriptive name for the filter configuration
FilterDesc nvarchar 1073741823 √ null

Filter description - Detailed description of the filter’s purpose and functionality
Criteria nvarchar 1073741823 √ null

Filter criteria - JSON or XML configuration defining the filter criteria and logic
CreatedBy int 4 √ null

Created by user - UserID of the person who created this filter configuration
CreatedDate datetime 16,3 √ null

Creation date - Date when this filter configuration was created
UpdatedBy int 4 √ null

Updated by user - UserID of the person who last updated this filter
UpdatedDate datetime 16,3 √ null

Last update date - Date when this filter configuration was last modified
ParentType nvarchar 100 √ null

Parent type - Type classification of the parent filter or data source
DatasourceId nvarchar 100 √ null

Data source identifier - Reference to the underlying data source for this filter
OrderNumber int 4 √ null

Display order - Numeric order for displaying filters in user interfaces
IsDefault bit 1 null

Default filter flag - Indicates if this is the default filter for the data source

Indexes

Constraint Name Type Sort Column(s)
PK_FilterBuilderDataSource Primary key Asc Id

Relationships

Close relationships within degrees of separation