CustomForms


Description

Custom form definitions managing dynamic form configurations and layouts for data collection. This table defines custom forms with their fields, validation rules, URLs, and behavior settings to support flexible data collection, custom workflows, and organization-specific forms for healthcare data management.

Columns

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

Primary key - Unique identifier for each custom form
Name nvarchar 500 null

Form name - Name of the custom form
Level nvarchar 200 √ null

Form level - Level or category of the form
Description nvarchar 500 √ null

Form description - Detailed description of the form purpose
RedirectMessage nvarchar 500 √ null

Redirect message - Message displayed after form submission
Url nvarchar 200 √ null

Form URL - URL where the form is accessible
RedirectUrl nvarchar 200 √ null

Redirect URL - URL to redirect to after form submission
Fields nvarchar 1073741823 √ null

Form fields - JSON or serialized definition of form fields and layout
IsDraft bit 1 √ null

Draft flag - Boolean indicating if the form is in draft status
IsLocked bit 1 √ null

Locked flag - Boolean indicating if the form is locked from editing
DateCreated datetime 16,3 √ null

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

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

Update date - Date when the form was last updated
UpdatedBy int 4 √ null

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

Deletion date - Soft delete timestamp for audit trail purposes
CustomTable nvarchar 200 √ null

Custom table - Name of custom table for storing form data
ForeignKeyField nvarchar 200 √ null

Foreign key field - Name of foreign key field for data relationships
KeyField nvarchar 200 √ null

Key field - Name of the primary key field
OneManyForm bit 1 √ null

One-to-many flag - Boolean indicating if form supports one-to-many relationships
PrimaryField nvarchar 200 √ null

Primary field - Name of the primary field for the form
fkDataSourceID uniqueidentifier 16 √ null

Data source reference - Links to data source for form data
OnlyCustomFields bit 1 √ null

Custom fields only - Boolean indicating if form shows only custom fields
ShowTwoColumns bit 1 √ null

Two column layout - Boolean indicating if form uses two-column layout
OnlyCoreFields bit 1 √ null

Core fields only - Boolean flag indicating if form displays only core system fields without custom fields
HtmlDesignString nvarchar 1073741823 √ null

HTML design - HTML string containing custom form design, layout, and styling for advanced form presentation
ForExistingRecord bit 1 ((0))

Existing record flag - Boolean indicating if form is designed for editing existing records rather than creating new ones
FooterHtmlString nvarchar 1073741823 √ null

Footer HTML - HTML string for custom footer content displayed at bottom of form
FormStyle int 4 √ null

Form style - Integer code defining the visual style or theme applied to the form
HeaderFooterId int 4 √ null

Header footer reference - Links to HeaderFooterConfig table for form header/footer configuration
HeaderHtmlString nvarchar 1073741823 √ null

Header HTML - HTML string for custom header content displayed at top of form
PrintDataSourceId uniqueidentifier 16 √ null

Print data source - GUID reference to data source used for printing form data
ShowToolBarItems bit 1 ((0))

Show toolbar - Boolean flag controlling whether toolbar items are displayed on the form
CustomJs nvarchar 1073741823 √ null

Custom JavaScript - JavaScript code for custom form behavior, validation, and interactive features
IsSystem bit 1 √ null

System form flag - Boolean indicating if this is a system-defined form that cannot be deleted

Indexes

Constraint Name Type Sort Column(s)
PK_CustomFieldSettings Primary key Asc pkID

Relationships

Close relationships within degrees of separation