App Database : jiveProfileField Table

Profile field data table.

Column Name	Type	Length	Nullable	Unicode	Description
extManaged	smallint	N/A	false		Whether or not the field data is managed by an external system
extMapping	varchar	2048	true		Config string used to look up field value in an external system
fieldID	bigint	N/A	false		The ID of the field. Primary key.
fieldType	int	N/A	false		The type of field.
idx	int	N/A	false		The index of the field in the field list.
isDefault	smallint	N/A	false		Whether or not the field is a default field
isEditable	smallint	N/A	false		Whether or not the field is editable.
isFilterable	smallint	N/A	false		Whether or not the field is filterable.
isList	smallint	N/A	false		Whether values are lists
isRequired	smallint	N/A	false		Whether or not the field is required.
isSearchable	smallint	N/A	false		Whether or not the field is searchable.
isVisibleToGuests	smallint	N/A	false		Whether or not the field is visible to guests.
isVisibleToUsers	smallint	N/A	false		Whether or not the field is visible.
name	varchar	255	false	true	The name of the field.
regIdx	int	N/A	false		Index of the field on the registration page.