| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
Surrogate id of the record used as the primary incrementing key |
|||||||||||||||||||||||||||||||||||||
| date | DATETIME | 19 | √ | NULL |
|
|
Date of the form |
|||||||||||||||||||||||||||||||||||||
| encounter | BIGINT | 19 | √ | NULL |
|
|
ID of the associated encounter |
|||||||||||||||||||||||||||||||||||||
| form_name | LONGTEXT | 2147483647 | √ | NULL |
|
|
Name of the form |
|||||||||||||||||||||||||||||||||||||
| form_id | BIGINT | 19 | √ | NULL |
|
|
ID of the specific form instance |
|||||||||||||||||||||||||||||||||||||
| pid | BIGINT | 19 | √ | NULL |
|
|
The internal patient identifier |
|||||||||||||||||||||||||||||||||||||
| user | VARCHAR | 255 | √ | NULL |
|
|
User responsible for creating this form. |
|||||||||||||||||||||||||||||||||||||
| groupname | VARCHAR | 255 | √ | NULL |
|
|
The groupname that created this record. |
|||||||||||||||||||||||||||||||||||||
| authorized | TINYINT | 3 | √ | NULL |
|
|
Authorization status |
|||||||||||||||||||||||||||||||||||||
| deleted | TINYINT | 3 | 0 |
|
|
Flag indicating if the form has been deleted |
||||||||||||||||||||||||||||||||||||||
| formdir | LONGTEXT | 2147483647 | √ | NULL |
|
|
Directory name of where the form exists in the filesystem. Also is the suffix name of the sub-type form that holds the individual form data for this form. The full table name is CONCAT(‘form_’,formdir) |
|||||||||||||||||||||||||||||||||||||
| therapy_group_id | INT | 10 | √ | NULL |
|
|
ID of the therapy group that this form’s encounter session is connected to |
|||||||||||||||||||||||||||||||||||||
| issue_id | BIGINT | 19 | 0 |
|
|
References lists.id to identify the medical issue this form is connected to |
||||||||||||||||||||||||||||||||||||||
| provider_id | BIGINT | 19 | 0 |
|
|
References users.id to identify the provider who is responsible for or involved in the healthcare this form relates to. This field is only populated in some types of procedure order forms and when a form is a dynamic Layout Based Form (LBF) |