Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ComplianceLevel | Unknown | 0 | null |
|
|
Compliance level - Regulatory compliance requirements |
|||||||||||
| FormID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
||||||||||
| FormName | varchar | 50 | √ | null |
|
|
Form name - Descriptive name of the form or template |
||||||||||
| FormDesc | varchar | 500 | √ | null |
|
|
Description field - Detailed description or explanation of Forms information |
||||||||||
| FormCategory | varchar | 50 | √ | null |
|
|
Text field - FormCategory text information for Forms records |
||||||||||
| FormAction | varchar | 200 | √ | null |
|
|
Text field - FormAction text information for Forms records |
||||||||||
| BillingTypeID | int | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
||||||||||
| comments | varchar | 100 | √ | null |
|
|
Text field - comments text information for Forms records |
||||||||||
| authRequired | varchar | 20 | √ | null |
|
|
Text field - authRequired text information for Forms records |
||||||||||
| FormDescription | Unknown | 0 | null |
|
|
Form description - Purpose and usage of the form |
|||||||||||
| FormType | Unknown | 0 | null |
|
|
Form type - Classification of form (Assessment, Progress Note, etc.) |
|||||||||||
| FormVersion | Unknown | 0 | null |
|
|
Version number - Current version of the form template |
|||||||||||
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this form is currently available for use |
|||||||||||
| Template | varchar | 50 | √ | null |
|
|
Text field - Template text information for Forms records |
||||||||||
| orderby | varchar | 500 | √ | null |
|
|
Order/sequence - Ordering or sequencing information for Forms display |
||||||||||
| StatusIDs | varchar | 100 | √ | null |
|
|
Status indicator - Current operational status or state of Forms records |
||||||||||
| ParamNames | varchar | 200 | √ | null |
|
|
Name field - Descriptive name or identifier for Forms records |
||||||||||
| IsAlowMultiSelect | bit | 1 | √ | null |
|
|
Boolean flag - Indicates whether specific condition or feature is enabled/active |
||||||||||
| ParamsRequiredSelect | varchar | 200 | √ | null |
|
|
Text field - ParamsRequiredSelect text information for Forms records |
||||||||||
| RequiredPrograms | Unknown | 0 | null |
|
|
Program requirements - Which programs require this form |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Forms | Primary key | Asc | FormID |