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 object’s profile.

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

The filter parameter may resemble the following:

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, you must 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 required to return a valid row must be found in both tables in the join for a row to be returned.
• 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 need to 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.