UserFields


Description

Custom user field definitions defining configurable fields for extending user profiles with organization-specific data requirements. This table manages custom field definitions including validation rules, display properties, and data collection requirements, supporting flexible user profile customization and compliance with organizational data collection needs.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
userFieldID int identity 4 √ null
UserFieldChoices.fkUserFieldID FK__UserFieldCho__UserFields C
UserFieldsInLevels.userFieldID FK__UserFieldsInLev__UserFields C
UserFieldValues.fkUserFieldID FK__UserFieldVal__UserFields C

Primary key - Unique identifier for each custom user field
fkICSInternalFieldID int 4 √ null

ICS internal field reference - Links to ICS system internal field definitions
UserFieldDescrip varchar 30 √ null

Field description - Description of the custom field’s purpose and usage
UserFieldCode varchar 20 √ null

Field code - Short code or identifier for the custom field
UserFieldLocked int 4 √ null

Field locked flag - Indicates if the field definition is locked from changes
UserFieldRequired int 4 √ null

Required field flag - Indicates if the field is required for user profiles
UserFieldRequiredLocked int 4 √ null

Required setting locked - Indicates if the required setting is locked from changes
UserFieldAllowExempt int 4 √ null

Allow exemption flag - Indicates if users can be exempted from this field requirement
UserFieldDocRequired int 4 √ null

Documentation required - Indicates if supporting documentation is required for this field
fkICSUserFieldFormat int 4 √ null

Field format reference - Links to ICS field format definitions
UserFieldLength int 4 √ null

Field length - Maximum length or size for field values
UserFieldFreq varchar 20 √ null

Field frequency - Frequency requirement for field updates
UserFieldFreqType varchar 20 √ null

Frequency type - Type of frequency requirement (Annual, Monthly, etc.)
UserFieldFreqAmt int 4 √ null

Frequency amount - Numeric amount for frequency calculations
UserFieldDisplayOrder int 4 √ null

Display order - Order in which fields are displayed in user interfaces
EnteredBy int 4 √ null

Created by user - UserID of the person who created the field definition
DateCreated datetime 16,3 √ null

Creation date - Date and time when the field was created

Indexes

Constraint Name Type Sort Column(s)
PK__UserFields__717DADAD Primary key Asc userFieldID

Relationships

Close relationships within degrees of separation