Fields


Description

Data dictionary fields managing field definitions, data types, and lookup configurations for dynamic form generation and data validation. This table defines field metadata including names, descriptions, data types, lookup relationships, and semantic types to support flexible data collection, form generation, and data dictionary management for healthcare applications.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
PKFieldID int identity 4 √ null
FieldsInStoredProc.FKFieldID FK__FieldsInS__FKFie__4D77B966 R
FlexFormSettings.fkFieldID FK_FlexFormSettings_Fields R

Primary key - Unique identifier for each field definition
FieldName varchar 50 √ null

Field name - Name of the field used in forms and data collection
FieldDesc varchar 200 √ null

Field description - Short description of the field purpose and usage
LookupTableName varchar 100 √ null

Lookup table - Name of table containing lookup values for this field
LookupFieldName varchar 100 √ null

Lookup field - Name of field in lookup table containing display values
DataType varchar 50 √ null

Data type - Data type specification (varchar, int, datetime, etc.) for field validation
FieldLongDesc varchar 1000 √ null

Long description - Detailed description of field purpose, usage, and business rules
SemanticFieldType varchar 30 √ null

Semantic type - Semantic classification of field (name, address, phone, etc.) for data processing
fkDataDictionaryID int 4 √ null
DataDictionary.FieldID FK_Fields_DataDictionary R

Data dictionary reference - Links to data dictionary entry for this field
SubQuery varchar 4000 √ null

Sub query - SQL subquery for dynamic lookup value generation and complex field relationships

Indexes

Constraint Name Type Sort Column(s)
PK__Fields__49A72882 Primary key Asc PKFieldID

Relationships

Close relationships within degrees of separation