Tag


Description

Tagging and categorization system for organizing and categorizing records across the healthcare system. This flexible tagging system enables users to create custom labels, categories, and organizational structures for patients, claims, activities, and other business entities to support workflow management, reporting, and data organization.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
TaggedRecord.FkTagId FK_TaggedRecord_TaggedRecord R

Primary key - Unique identifier for each tag in the system
Name nvarchar 400 null

Tag name - Descriptive name or label for the tag used for categorization and identification
TagOrder int 4 √ null

Display order - Numeric value controlling the sort order when tags are displayed in lists or menus
fkTagGroupId int 4 √ null

Tag group reference - Links tag to a parent tag group for hierarchical organization and categorization (foreign key to TagGroup.TagGroupId)
BackgroundColor nvarchar 20 √ null

Background color - Hex color code or color name for tag background display in user interface
Color nvarchar 20 √ null

Text color - Hex color code or color name for tag text display in user interface
IsOn bit 1 ((1))

Active status - Boolean flag indicating whether this tag is currently active and available for use
ReportId int 4 √ null

Associated report - Links tag to a specific report for report-based tagging and filtering (foreign key to Reports.ReportID)
CreateBy int 4 √ null

Created by user - UserID of the person who created this tag (foreign key to AccessUser.UserID)
CreateDate datetime 16,3 √ null

Creation date - Timestamp when the tag was first created in the system
UpdateBy int 4 √ null

Last updated by - UserID of the person who last modified this tag (foreign key to AccessUser.UserID)
UpdateDate datetime 16,3 √ null

Last update date - Timestamp when the tag was last modified
DataSourceId int 4 √ null

Data source reference - Links tag to a specific data source for data-driven tagging and categorization
IsMyTag bit 1 ((0))

Personal tag flag - Boolean indicating whether this is a personal tag created by and visible only to the creating user
ParentType int 4 ((0))

Parent entity type - Numeric code indicating the type of entity this tag can be applied to (Patient=1, Claim=2, Activity=3, etc.)

Indexes

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

Relationships

Close relationships within degrees of separation