Configuration Guide › Relational Database Management › How to Describe a Database in a Directory Configuration File › Managed Object Descriptions › Database Tables › Table Elements

Table Elements

The parameters for a table element are as follows:

name

(Required)

Specifies the name of the table that stores some or all of the attributes in a managed profile of an object.

primary

Indicates whether the table is the primary table for the managed object. The primary table contains the unique identifier for the object, as follows:

• True—The table is the primary table.
• False—The table is a secondary table (default).

If you do not specify the primary parameter, CA IdentityMinder assumes the table as a secondary table.

Note: Only one table can be the primary table.

filter

Identifies a subset of the table entries that apply to the managed object.

The optional filter parameter may resemble the following example:

filter="ORG=2"

Note: The filter applies only to queries that CA IdentityMinder generates. If you overwrite a generated query with a custom query, specify the filter in the custom query.

fullouterjoin

Indicates whether the outer join is a full outer join.

• True— The outer join is a full outer join. In this case, the condition that is required to return a valid row is found in both tables in the join for a returned row.
• False—The outer join is a left outer join relative to the primary table. In this case, only the rows in one table in the query must satisfy the condition (default).

Note: The parameters are optional unless otherwise specified.

The Table parameter can contain one or more Reference elements to link a primary table to secondary tables.