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 print or export a report in an Excel or CSV file format.
About the Reference Data Reports
Reference data Center includes the following reports:
| Report Name | Description |
|---|---|
| Data Strategy | The Data Strategy report provides 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 provides |
| Release Status Detail | The Release Status Detail report shows 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 back, and data strategy. |
| Securities not Assigned to a Data Strategy | |
| Security Audit | The Security Audit report shows 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, source, security, investment type, security type, processing security type, update user, journal type, update type, last hours, and field identifier. |
| User Audit | The User Audit report shows 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, 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). |
Run Reports
Use this procedure to run all Reference Data Center reports.
To run a RDC report:
- From the Reference Desk workspace, click Securities in the left navigation.
You see the Securities workspace with all the available securities. - Click the View By drop down and select Security.
- Complete the required search criteria and click the 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 format.
0 Comments