In the Reference Data Center, you can use the Reports button on the ribbon to run reports. A full history is maintained for each data record in the application. Reports show all reference data and the associated audit information. You can sort columns alphabetically, remove columns, clear a filter on a column, use Find to quickly identify items in a column, and freeze and unfreeze a column. You can use the Print or Export buttons on the ribbon to then print or export a report in an Excel or CSV file format.
...
| Report Name | Description |
|---|---|
| Data Strategy | The Data Strategy report providesreport displays field level information on data strategies , such as the field group, field group owner, field group release level, database, field name, table name, precision, field type, field process type, reference code name, enrichment field, data category, and approvals.. You can filter the search results by data strategy. |
| Exception Summary | The Exception Summary report providesdisplays all exceptions for a specified date. You can filter the search results by error severity, security, error code and data category. |
| Release Status Detail | The Release Status Detail report showsdisplays the current release status at the individual security level . Information includes the security alias, release status, issue name, issue description, ticker, primary asset identifier, investment type, security type, maturity date, processing security type, asset currency, issue identifier, effective date, inactive flag, number of errors, number of warnings, number of errors and warnings, update source, update date, source, pool number, update type, alternate asset identifier, number of attachments, data strategy, and gold copy. You can filter the search results by security, release status level, investment type, currency, data strategy, and gold copy. |
| Release Status Summary | The Release Status Summary report shows the current release status grouped by gold copy and data strategy. Information includes the gold copy, data strategy, release status level, and number of securities. You can filter the search results by composite source, days to look backeffective date, gold copy, and data strategy. |
| Securities not Assigned to a Data Strategy | The Securities not Assigned to a Data Strategy Report displays securities not associated with a data strategy. You can filter the search results by data strategy. |
| Security Audit | The Security Audit report showsreport displays all data changes . Information includes the source, security alias, ticker, primary asset identifier, investment type, issue name, security type, coupon, maturity date, processing security type, effective date, journal type, table name, column name, field name, new value, old value, master journal instance, last modified, action, and last updated by. You can filter search results by journal instance, the search results by data source, security, investment type, security type, processing security type, update user, journal type, update type, last hours, and field identifier.start date, end date, last updated by |
| User Audit | The User Audit report shows report displays the manual changes made to all securities and exceptions. Information includes audit type, action, security alias, user, date, issue name, investment type, processing security type, primary asset identifier, comments, start date, end date, old value, new value, source, and error code. You can filter the search results by security, action, investment type, currency, and audit type. Options for audit type include authorize, auto expiration, edit xreference, no override, overlay (override), reject, release exception, security, and underlay (default)and currency. |
Run Reports
Use this procedure to run all Reference Data Center reports.
To run a RDC reportreport in Reference Data Center:
- From the Reference Desk workspace, click Securities in the left navigationOn the ribbon, click Reports and from the drop-down list, select the report you want to run.
You see the Securities workspace Search panel associated with all the available securities. - Click the View By drop down and select Security.
- the report you've selected.
- Complete the required search criteria and click the click Search button.
You see the search results based on the criteria you selected. - Select the security and then on the ribbon click Reports.
- From the Reports drop-down list, select the report you want to run.
- Complete the required search criteria and click the Search button to display the results.
- You can then use the Print or Export buttons on the ribbon to print or export a report in an Excel or CSV file formatdisplayed in the panel below.
- To print or export the report, click Export on the ribbon, and then select either Export to Excel or Export to CSV.