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 Identity Manager 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 only if the table stores information for more than one object type.

The filter parameter may resemble the following example:

filter="type=’USER’"

Note: The filter applies only to queries that CA Identity Manager 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.