UserFieldsInLevels


Description

User field level associations linking custom user fields to specific organizational levels or security levels. This junction table determines which custom fields are applicable at different organizational levels, supporting level-based field visibility and data collection requirements based on user roles or organizational hierarchy.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
userFieldID int 4 √ null
UserFields.userFieldID FK__UserFieldsInLev__UserFields C

User field reference - Links to the custom user field (UserFields.userFieldID)
fkICSUserFieldLevelID int 4 √ null

ICS user field level reference - Links to the ICS user field level classification
fieldLevelItemID int 4 √ null

Field level item reference - Links to the specific field level item configuration
fkLevelID Unknown 0 null

Level reference - Links to the organizational or security level

Relationships

Close relationships within degrees of separation