Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
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 |