FormDesigns


Description

Form designs management table for creating and configuring dynamic forms, electronic documents, and data collection instruments. This table supports comprehensive form management including field definitions, signature configurations, security settings, workflow integration, and multi-format publishing. Essential for healthcare documentation, compliance forms, assessment instruments, and custom data collection requirements in early intervention and healthcare services.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int identity 4 √ null
FormSignatures.FormDesignID FK_FormDigitalSignatures_FormDesigns R
FormSubmissions.FormDesignId FK_FormSubmissions_FormDesigns R

Form design primary key - Unique identifier for each form design
Name nvarchar 256 null

Form name - Name of the form design
Description nvarchar 1024 √ null

Form description - Detailed description of the form purpose and usage
Status int 4 null

Form status - Current status of the form (Draft, Active, Inactive, etc.)
Location int 4 null

Form location - Location or context where the form is used
Type int 4 null

Form type - Type of form (Electronic, PDF, Web, etc.)
FillableFileId nvarchar 100 √ null

Fillable file ID - Identifier for fillable PDF or document file
WebFormId int 4 √ null

Web form ID - Identifier for web-based form implementation
IsLockable bit 1 null

Lockable flag - Indicates if the form can be locked after completion
CaseType nvarchar 2000 √ null

Case type filter - Case types for which this form is applicable
VisitCode nvarchar 4000 √ null

Visit code filter - Visit codes for which this form is applicable
PaySource nvarchar 2000 √ null

Payment source filter - Payment sources for which this form is applicable
CheckList nvarchar 2000 √ null

Checklist integration - Checklist items associated with this form
Fields nvarchar 1073741823 √ null

Form fields definition - JSON or XML definition of form fields and layout
CreatedDate datetime 16,3 null

Creation date - Date when the form design was created
CreatedBy int 4 null

Created by user - UserID of the person who created the form
ModifiedDate datetime 16,3 √ null

Modification date - Date when the form was last modified
ModifiedBy int 4 √ null

Modified by user - UserID of the person who last modified the form
DeletedDate datetime 16,3 √ null

Deletion date - Date when the form was marked as deleted
DeletedBy int 4 √ null

Deleted by user - UserID of the person who deleted the form
AutomaticallyLock bit 1 null

Auto lock flag - Indicates if the form should automatically lock after submission
SignaturesConfigurations nvarchar 1073741823 √ null

Signature configurations - Configuration settings for digital signatures
IsHideTypeSignature bit 1 null

Hide type signature flag - Indicates if signature type should be hidden
IsRememberSignature bit 1 null

Remember signature flag - Indicates if signature should be remembered for future use
SignatureOrder bit 1 ((0))

Signature order flag - Indicates if signatures have a specific order requirement
GetFormId int 4 √ (NULL)

Get form ID - Reference to form used for data retrieval
PublishBy int 4 √ null

Published by user - UserID of the person who published the form
PublishToId int 4 √ (NULL)

Publish to ID - Target identifier for form publishing
DataSourceId int 4 √ null

Data source reference - Links to data source for form population
CategoryID varchar 250 √ null

Category identifier - Category classification for the form
CustomDataSourceId uniqueidentifier 16 √ null

Custom data source ID - Unique identifier for custom data source
LayerItemMarketId int 4 √ null

Layer item market ID - Market-specific layer item identifier
PrintFormId int 4 √ null

Print form ID - Reference to printable version of the form
RequireSignatureOnSubmit bit 1 ((0))

Require signature on submit - Indicates if signature is required upon form submission
OneManyForm bit 1 √ null

One-to-many form flag - Indicates if form supports one-to-many relationships
ShortcutPdf bit 1 √ null

Shortcut PDF flag - Indicates if form has PDF shortcut functionality
Role nvarchar 4000 √ null

Role restrictions - Roles that have access to this form
FormGroups varchar 500 √ null

Form groups - Groups or categories this form belongs to
DefaultFormStatus varchar 20 √ null

Default form status - Default status for new form submissions
TeamsHaveFullAccess varchar 200 √ null

Teams with full access - Teams that have full access to this form

Indexes

Constraint Name Type Sort Column(s)
PK_FormDesigns Primary key Asc ID
IX_FormDesigns_Location Performance Asc Location
IX_FormDesigns_WebFormId Performance Asc WebFormId

Relationships

Close relationships within degrees of separation