Report table

Report table
This table stores details of the reports designed and generated by ISIM users.
Column Name Description Data type

ID^* Unique ID for the table. Primary key. Numeric

TITLE^* Report title given to the report. Character (255)

TYPE^* Indicates whether the report was designed with Security Identity Manager or RI. Character (255)

AUTHOR Author of the report (designer). Character (255)

REPORT_SIZE The size of the report template stored in the REPORT_DATA column of this table. Numeric

REPORT_DATA The report (custom/third party) template is stored here. The templates must be shared by the different Security Identity Manager installations in a clustered environment and so they are stored here. Binary

STYLESHEET Name of the style sheet for the report. Character (255)

REPORTSUBTYPE^* Identifies if this report is a user-defined report or an out-of-box report. Character (1)

REPORTCATEGORY^* Identifies which category the run is to be listed on the Run Reports page. Character (255)

EDITABLE Indicates whether this report can be edited or not. The value is N for reconciliation statistics, Audit Events, Recertification History, Pending Recertification, Recertification Policies, and access control information reports. Character (1)

^* Indicates the column is required and not null.
Parent topic: Reports tables

Column Name	Description	Data type
ID^*	Unique ID for the table. Primary key.	Numeric
TITLE^*	Report title given to the report.	Character (255)
TYPE^*	Indicates whether the report was designed with Security Identity Manager or RI.	Character (255)
AUTHOR	Author of the report (designer).	Character (255)
REPORT_SIZE	The size of the report template stored in the REPORT_DATA column of this table.	Numeric
REPORT_DATA	The report (custom/third party) template is stored here. The templates must be shared by the different Security Identity Manager installations in a clustered environment and so they are stored here.	Binary
STYLESHEET	Name of the style sheet for the report.	Character (255)
REPORTSUBTYPE^*	Identifies if this report is a user-defined report or an out-of-box report.	Character (1)
REPORTCATEGORY^*	Identifies which category the run is to be listed on the Run Reports page.	Character (255)
EDITABLE	Indicates whether this report can be edited or not. The value is N for reconciliation statistics, Audit Events, Recertification History, Pending Recertification, Recertification Policies, and access control information reports.	Character (1)