Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 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.

About the Reference Data Reports

Reference data Center includes the following From the Reference Data Center, you can run the following reports:

Report Name

Description

Data Strategy

The Data Strategy

report provides

report 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

provides

displays all exceptions for a specified date.

You can filter the search results by start and end date, error severity, security, error code and data category.

Release Status Detail

The Release Status Detail report

shows

displays the current release status

at

information 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

the total count of securities grouped by 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

effective 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 shows

report 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

You can filter the search results by security, 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

investment type, and currency. 

 Active Enrichments

The Active Enrichments report displays all enrichments that are currently assigned to data strategies and are enabled for the given data strategy.

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). 

data strategy.

 Active Validations

The Validations report displays all validations that are currently assigned to data strategies and are enabled for the given data strategy.

You can filter the search results by data strategy.

Run Reports

Use this procedure to run all Reference Data Center reports.

To run a RDC reportreport in Reference Data Center:

...

  1. On the ribbon, click Reports and from the drop-down list, select the report you want to run.
    You see the

...

  1. Search panel associated with

...

  1. the report you've selected.

  2. Complete the required search criteria and

...

  1. click Search

...

  1. .
    You see the

...

  1. results

...

  1. displayed in the panel below.

  2. To print or export the report, click Export on the ribbon, and then select either Export to Excel or Export to CSV.