FormDesigns


Description

Form design templates that define the visual layout, field arrangement, and user interface design for electronic forms used in data collection and documentation.

Columns

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

Reference identifier - Foreign key reference to related entity or lookup table

Name nvarchar 256 null

Form name - Descriptive name of the form design template

Description nvarchar 1024 null

Form description - Detailed description of the form’s purpose and usage

Status int 4 null

Form status - Current status of the form design (Active, Draft, Archived, etc.)

Location int 4 null

Form location - Where the form is used or displayed in the system

Type int 4 null

Form type - Classification of form type (Assessment, Progress Note, Evaluation, etc.)

FillableFileId nvarchar 100 null

Fillable file reference - Reference to the fillable PDF or document template

WebFormId int 4 null

Web form reference - Reference to the web-based form implementation

IsLockable bit 1 null

Lockable flag - Whether the form can be locked to prevent further editing

CaseType nvarchar 2000 null

Case type association - Types of cases where this form is applicable

CheckList nvarchar 2000 null

Checklist items - List of required items or steps for form completion

Fields nvarchar 1073741823 null

Form fields - JSON or XML definition of all fields in the form

CreatedDate datetime 16,3 null

Creation date - Date when the design was created

CreatedBy int 4 null

Creator reference - Reference to the user who created this form design

DeletedDate datetime 16,3 null

Deletion date - Date when the form design was marked as deleted

DeletedBy int 4 null

Deletion user reference - Reference to the user who deleted this form design

AutomaticallyLock bit 1 null

Auto-lock flag - Whether the form automatically locks after completion

DesignId Unknown 0 null

Primary key - FormDesigns unique identifier for each form design

DesignName Unknown 0 null

Design name - Descriptive name of the form design

FieldPositions Unknown 0 null

Field positions - Coordinate information for field placement

FormLayout Unknown 0 null

Form layout - JSON or XML definition of the form structure

GetFormId int 4 (NULL)

Form retrieval reference - Reference for retrieving the form from external systems

IsDefault Unknown 0 null

Default flag - Whether this is the default design for forms

VisitCode nvarchar 2000 null

Visit code association - Visit or service codes where this form is used

PaySource nvarchar 2000 null

Payment source association - Payment sources or payers that require this form

ModifiedDate datetime 16,3 null

Modified date - Date when the design was last modified

ModifiedBy int 4 null

Last modifier reference - Reference to the user who last modified this form design

SignaturesConfigurations nvarchar 1073741823 null

Signature configurations - Configuration settings for digital signatures on this form

SignatureOrder bit 1 ((0))

Signature order flag - Whether signatures must be collected in a specific order

IsRememberSignature bit 1 null

Remember signature flag - Whether to remember and reuse signatures for this form

IsHideTypeSignature bit 1 null

Hide signature type flag - Whether to hide the signature type selection from users

PublishToId int 4 (NULL)

Publication target - Reference to the target audience or group for form publication

StyleDefinition Unknown 0 null

Style definition - CSS styling for the form appearance

Indexes

Constraint Name Type Sort Column(s)
PK_FormDesigns Primary key Asc ID

Relationships