Identity Manager 9.2.1 - Configuration Guide

Name of the table to which the column belongs.

Name of the column in the data model.

Language-dependent column name for displaying in the administration tools user interface. Translate the given text using the button.

Additional information about the column. The comment is displayed under the help function for a column in the individual administration tools. Translate the given text using the button.

If a column is disabled by a preprocessor condition, the option is set by the Database Compiler. For more information, see Conditional compilation using preprocessor conditions.

You can add preprocessor conditions to columns. The column is therefore only available when the preprocessor condition is fulfilled. For more information, see Conditional compilation using preprocessor conditions.

The sort order specifies the position for displaying the column on the generic form and the custom tabs of the default form. Columns with a value less than 1 are not displayed on the forms. For more information, see Displaying custom columns and tables on main data forms.

Group is used to display the column on general main data forms. A new tab is created for each group on the generic form. For more information, see Displaying custom columns and tables on main data forms.

If a database view has the View table type, the reference to the column in the base table is entered here. For more information, see Database views of the View type.

Example:

The Department database view is part of the Basetree base table. The columns of the Basetree table are entered as base columns.

Specifies whether permitted values can be customized for this column. For more information, see Permitted column values.

Marks whether the value in this column must correspond to the values in the List of permitted values, or are empty. For more information, see Permitted column values.

If a column is enabled for editing the permitted values (that is, the Customizing permitted values list is not allowed option is not set and the Defined list of values option is set), you can add to or extend a value list. For more information, see Permitted column values.

Specifies whether the bitmask can be customized for this column. For more information, see Defining bitmasks.

Meaning of each bit position if the column contains a bitmask. The first bit in the definition start with the index 0. For more information, see Defining bitmasks.

Sort criteria for displaying the values. You have the following options:

• Bit position: Sort by position.

• Display: Sort by display value.

For more information, see Defining bitmasks.

Specifies whether this column can be given in multiple languages.

Permitted values are:

• Translation target: The column content is displayed in translation.

• Translation source: The column supplies the translation.

• #LD content: The column has contents in #LD notation. The contents are extracted for translation.

• Without text memory fallback: The text store is not used as fallback for the column.

The combination of values determines the resulting translation.

For more information, see Flagging columns for translation.

Syntax type of data in this column. The syntax type is used to give One Identity Manager tools the appropriate syntax highlighting or input assistance.

Permitted syntax types are:

• HTML: Input in HTML format.

• Picture: Images.

• SQL.Query: Full database queries.

• SQL.Special: Special syntax for database queries.

• SQL.WhereClause: WHERE clause for database queries.

• Text.Dollar: Input in $ notation.

• UNC: UNC path.

• URL: URL.

• VB.Class: Full VB.Net class definitions.

• VB.Instruction: VB.Net statements in the form Value =.

• VB.Method: Single methods or functions in VB.Net.

• XML: Input in XML format.

• ConnectionString: Input as a connection string.

• JSON: Input in JSON format.

• Color: Input of color codes.

Number of decimal places used to display values.For more information, see Defining decimal places for displaying values.

Additional information about displaying date and time in One Identity Manager tools.

Column weighting in indexing. Used for indexing the full-text search. Increasing weighting results in a higher position in the search results.

If the value is less than or equal to 0, no indexing takes place. If the value is greater than 0, the data value is indexed. Columns to be indexed are assigned a weighting of 1 in the default installation.

For more information, see Configuring columns for full-text search.

Shows the .Net data type for the column. This is used internally and cannot be edited. The Net data types are mapped internally to SQL data types. If no value is given, the data type is taken from the database schema.

Permitted syntax types are:

Maximum column length in the database schema.

Minimum column length in the database schema.

The primary key is given when the database is created.

Specifies whether this is UID column. This option is only permissible for columns with the String .Net data type and a length of 38 characters.

Specifies whether a default value is defined by a template for this column.

This option is used to label text columns whose data contents is so large that they cannot be kept internally in one line in the SQL sever and are therefore saved as a reference. This allows speedier access to the data.

Specifies whether changes to this column are logged. For more information, see Logging data changes.

Specifies whether the column is to be logged when an object is deleted. For more information, see Logging data changes.

Specifies whether the table is to be exported for the SPML schema.

This column is not exported in data transports. The property is taken into account when data is transported between databases.

This column is not imported in data transports. The property is taken into account when data is transported between databases.

This column is a multi-valued-property (MVP) containing individual value entries that are separated by char(7) or chr(7).

You can specify additional requirements on the values of an MVP column. You have the following options:

• Unique: Set this option if the value must be unique.

• Case sensitive: Set this option if the case sensitivity should be taken into account when the value is tested.

• Accent insensitive: Set this option if accent characters should not be taken into account when the value is tested.

For more information, see Specifying requirements for MVP columns.

Specifies whether the parameter contents can have multiple lines. Columns that are labeled with this option are displayed on a generic form with multiline input fields.

For custom columns in a predefined table, permissions are not automatically assigned to predefined permissions groups, even though the Common | AutoExtendPermissions configuration parameter is set.

One column with a description can be labeled with this option per table. The description is only displayed on user interface assignment controls.

Specifies whether the column contains name properties. Depending on the password policy configuration, columns with name properties may be included in the password check. For more information about password policies, see the One Identity Manager Operational Guide.

One column which maps hierarchy information in readable form can be labeled with this option per table. The column is used to map the hierarchy to the user interface assignment controls.

This column is part of the primary key.

Alternative primary keys are already specified in the default version, but the definition can be customized. Alternative primary keys are used for data transport amongst other things.

Identifier of the foreign key of a many-to-all table The foreign key and the dynamic foreign key of a many-to-all table are identified with this option.

Specifies whether the column is offered in the Rule Editor for compliance rules to create queries and in the Web Portal to display tabular overviews.

Specifies whether this column references a parent object. This input is needed for displaying hierarchical tables.

Example:

In the ADSContainer table, the UID_ParentADSContainer column contains the reference to the parent Active Directory container. The UID_ParentADSContainer column is labeled with this option in order to display this hierarchical link on forms.

Specifies whether the value in this column is encrypted. When the database is encrypted the value in this column is encrypted.

Dynamic foreign keys refer to the object key in other tables. The object key comprises the table name and the values of the primary key of the actual object. Permitted tables can be limited. All tables are permitted, if there are no restrictions. For more information, see Dynamic foreign key.

Specifies whether the column content is recorded in logs. For example, in the One Identity Manager Service log.

If the column is used in a database view of the Proxy type, the corresponding column is entered in the view. For example, the column ADSDomain.DisplayName is mapped in the UNSRoot view to column RootObjectDisplay. For more information, see Database views of the proxy type.

Each value in these columns is prepared for fast table lookup support. The search is also supported by single values in MVP columns. The internal mapping of prepared data in done in the QBMSplittedLookup table.

Permitted values are:

• Central user account (CentralAccount)

• Email address (EMail)

You can extend the list of permitted values and customize the results.

• In the Designer, flag columns containing a user account name with the Central user account value in the Table lookup support property.

• In the Designer, flag columns containing an email address with the Email address value in the Table lookup support property.

The functionality can be used for finding a unique central user account, for example, or a unique default email address for an identity. In the default installation, columns that are taken into account when the central user account or an email address are mapped are labeled with this property. The results are shown in the QERCentralAccount and QERMailAddress database views.

Specifies whether column's the default configuration can be changed by the user, such as, templates, formatting, minimum length, maximum length, column format.

Maximum length of the column. If the value is equal to 0, the length from the database schema is used.

Minimum length of the column. For columns that are displayed as required input fields in the administration tools user interface, set the minimum length to 1 or higher.

Specify the format permitted for value in this column. For more information, see Using predefined formatting types.

You can control the permitted format for the column with formatting types and formatting scripts.

Specifies whether the template can overwrite or not. If this option is set, the value template is always applied. If the option is not set, the value template is only applied when the column is empty. For more information, see Editing value templates.

Limit for the number of objects changed directly by a template. Once this limit has been reached, processing is stopped with an error message. For more information, see Restricting performance of value templates.

Limit for the number of objects changed directly by a template. Once this limit has been reached, processing takes place synchronously with the One Identity Manager Service. For more information, see Restricting performance of value templates.

Specifies whether the value is automatically truncated to the maximum column length if the maximum length is exceeded when applying a template. If this option is enabled, the value is not automatically truncated to the maximum column length. For more information, see Editing value templates.

Formatting script for the column. The formatting script for checking values is written in VB.Net syntax, which allows usage of all VB.Net script functions.

Script for conditional displaying of columns in One Identity Manager tools. For more information, see Scripts for conditionally displaying and editing columns.

Script for conditional editing of columns in One Identity Manager tools. For more information, see Scripts for conditionally displaying and editing columns.

The column references an object in another table.

Information is determined once a day through the maintenance tasks. The data material can help to plan capacities and maintenance work on the database.

(Only for internal use) This indicates that the template was changed.

Columns labeled with this option cannot be excluded from a custom configuration package. These columns are excluded from data transport.

Specifies the mapping direction that will be applied to this column when synchronizing between two One Identity Manager databases. For more information about this, see the One Identity Manager User Guide for the One Identity Manager Connector.