ENTITY_COLUMN table

During the configuration of the IBM Security Access Manager reporting interface schema, the system administrator selects the entities and a set of attributes. The reporting Interface stores the selected pairs of entities and attributes in this table. The Report Designer can later choose to report on any of the attributes in the ENTITY_COLUMN table.

Column Name	Description	Data type
ENTITY_NAME*	Name of the entity (for example Person). Primary key.	Character (255)
COLUMN_NAME*	Column name as present in the entity table represented by the preceding entity name.	Character (255)
ATTRIBUTE_NAME*	Name of the attribute as returned by ISIM server. Primary key.	Character (255)
MULTI_VALUED	Indicates whether the attribute is multi-valued or not. Value is Y/N. Maximum of 1 character.	Character (1)
IMPLICITLY_MAPPED	Indicates whether the data synchronizer implicitly maps a particular attribute. If the attribute is present in the object filter of some ACI, it is implicitly mapped. Maximum of 1 character.	Character (1)
AVAILABLE_FOR_REPORTING	Indicates whether the column is available for reporting. The value for this column represents different states in which the corresponding data can be, such as newly mapped or available.	Character (255)
TABLE_NAME	Name of the table created for an entity. V_ENTITY is a view. It is not a table.	Character (255)

^* Indicates the column is required and not null.

Parent topic: Reports tables