FolderTemplates


Description

Document folder templates - Template management system for organizing and structuring document folders across healthcare workflows. This table stores reusable folder structures, organizational hierarchies, and configuration settings to standardize document management, ensure consistent filing systems, and support automated folder creation for patient records, administrative documents, and clinical documentation.

Columns

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

Template primary key - Unique identifier for each folder template
TemplateName nvarchar 100 √ null

Template name - Descriptive name for the folder template
TemplateStructure nvarchar 1073741823 √ null

Folder structure - JSON or XML configuration defining the folder hierarchy and organization
Status bit 1 √ null

Template status - Active/inactive status of the folder template
TemplateLevel nvarchar 100 √ null

Template level - Organizational level where this template applies (Patient, Case, Agency, etc.)
CreatedDate datetime 16,3 √ null

Creation date - Date when this folder template was created
CreatedBy int 4 √ null

Created by user - UserID of the person who created this template
UpdatedDate datetime 16,3 √ null

Last update date - Date when this template was last modified
UpdatedBy int 4 √ null

Updated by user - UserID of the person who last updated this template

Indexes

Constraint Name Type Sort Column(s)
PK_FolderTemplate Primary key Asc FolderTemplateId

Relationships

Close relationships within degrees of separation