Versions Compared

Old Version 12

changes.mady.by.user Former user

Saved on

compared with

New Version 13

changes.mady.by.user Former user

Saved on

Key

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

Anchor
_Toc422747199
_Toc422747199
Manage Field Properties

You can use the Setup workspace in Reference Data Center to maintain several properties of fields, including whether to require additional authorization for the release of an overridden field. You can also add fields to field groups and audit the historical changes in field properties.

Anchor
config_admin_man_fields_htm_mana_9320
config_admin_man_fields_htm_mana_9320
Anchor
_Toc422747200
_Toc422747200
About Field Properties

You can manage field properties, including field validations and override authorizations.

To manage field properties:

  1. From the Setup workspace, click Fields in the left navigation.
    You see the Fields workspace with the list of available fields.
  2. Scroll down to the field you wish to view or edit.
  3. On the toolbar, click Edit.
    You see the Editing Fields Reference Data Settings workspace.
  4. Set the Composite Nulls check box to allow null values in the composite record for this field. Or, clear to block nulls.
  5. Set the Authorization Required check box to require manager approval to release any data override for this field. Or, clear to remove this requirement.
  6. Set the Log Changes for Accounting Purposes check box to enable the logging of key fields for the earnings process. Or, clear to disable logging.
  7. To assign a validation, select the validation you wish to use and click Add. Or, select the validation you wish to remove and click Remove. See Manage Data Strategies for details about specifying field validations during the setup of a data strategy.
  8. Click Next.
    You see the Editing Field Groups workspace.
  9. Click the Field Groups drop down to select the field group to assign to this field.
    NOTE: When you add/remove fields to a field group, you automatically update the fields processed by the data strategies using this field group.
  10. Click Next.
    You see the Editing Field Data Strategies workspace with the list of all data strategies that use fields groups that contain this field.
  11. Select a data strategy and then click the Release Level dropdown and optionally select the release level default you wish used as the default for this data strategy when securities are not held.
    Options include:
    –  Released For Trading
    –  Released For Trading & Back Office
    –  Released With No Exceptions
  12.  You can also set other properties when securities are not  held, including:
    –  Authorization Required.
    –  Composite Nulls
    –  Log changes for accounting purposes
    –  Override Values
    –  Validations
  13.  Click Save.
    You see the Fields workspace with the list of available fields.
Panel
borderColor#9F9F9F
titleColor#F7F9F9
titleBGColor#B48436
borderStyledashed
titleContent on this page:

Table of Contents
maxLevel2
indent2 px

Anchor
_Toc422747201
_Toc422747201
Add a Field to a Field Group

You must add a field to a field group before you can use the field with a data strategy.

To add fields to a field group:

  1. From the Setup workspace, click Fields in the left navigation.
    You see the Fields workspace with the list of available fields.
  2. Scroll down to the field you wish to add to a field group and click Add to Field Group.
    You see the Add Field to Field Group dialog box.
  3. Select one or more field groups to contain this field
  4. Click Save.
    You see the Fields workspace with the refreshed list of available fields.

Anchor
_Toc422747202
_Toc422747202
Audit Changes to Field Properties

You can audit the historical changes to field properties.

To audit changes to field properties:

  1. From the Setup workspace, click Fields in the left navigation.
    You see the Fields workspace with the list of available fields.
  2. Scroll down to the field you wish to audit and click View Audit Record.
    You see the list of historical changes, including the user ID and timestamp associated with the change.
  3. Select an historical record and click View Audit Record.
    You see the Fields Audit Details dialog box.
  4. Click Compare Audit to Current to display the difference between the historical and the current field properties. You can select a second historical record and click Compare Audit Records to display the differences between the two records.
  5. Click OK to exit the review.

Anchor
_Toc422747203
_Toc422747203
Manage Field Attributes

You can use the Setup workspace in Reference Data Center to add field attributes as derived fields for data enrichment. You also can view and edit field attributes, including the code category used to validate field values. You can use field attributes to form a field group.

Anchor
_Toc422747204
_Toc422747204
Add Field Attributes

You can add field attributes, including derived fields for use as data enrichment. You must add the field attributes before you can manage field properties.

To add derived fields to use for data enrichment:

  1. From the Setup workspace, click Field Attributes in the left navigation.
    You see the Field Attributes workspace.
  2. In the left pane, select the Custom folder and then select the Detailed Calculation folder or the Inference folder. All derived fields are located in these folders.
    You see the list of available derived fields.
  3. Click New.
  4. You see the New Detail Calculation Field dialog box.
  5. Complete the descriptive information, build the data enrichment formula, and click OK. For example, you can enter a formula applying only to bonds that concatenates the issue name and the maturity date to form a more descriptive issue name for the bond.

Anchor
_Toc422747205
_Toc422747205
View / Edit Field Attributes

You can view and edit field attributes, including the code category used to validate fields.

To view / edit field attributes:

  1. From the Setup workspace, click Field Attributes in the left navigation.
    You see the Field Attributes workspace.
  2. In the left pane, select the appropriate folder.
    You see the list of all available field attributes in the folder.
  3. Double click the field attribute you wish to view or edit.
    You see the Editing dialog box for the named field.
  4. Review the descriptive information, make the appropriate changes, and click OK.

Anchor
_Toc422747206
_Toc422747206
Manage Inventory of Fields

You can use the Setup workspace in Reference Data Center to add, view, and edit the fields in the Eagle data model by managing the inventory of fields. You must keep the inventory of fields consist with the Define Data Language (DDL) statements defining the physical database. For example, when a new column is added to the Eagle data warehouse tables, you must add the column to the Inventory of Fields before the new field can be accessed and used by Reference Data Center.

Anchor
_Toc422747207
_Toc422747207
Add Fields to the Inventory of Fields

You can add fields to the inventory of available fields for use by Reference Data Center.

To add fields to the inventory of available fields:

  1. From the Setup workspace, click Inventory of Fields in the left navigation.
    You see the Inventory of Fields workspace with the database tables available.
  2. Select the database table that contains the new field.
    You see all the columns in the table.
  3. Click New.
    You see the New PACE Inventory Field dialog box.
  4. Complete the fields and click Add.
    You see a message confirming that the field was added.
  5. Click Refresh.
    You see the refreshed list of columns in the table.

Anchor
_Toc422747208
_Toc422747208
View / Edit Fields in the Inventory of Fields

You can view and edit fields in the inventory of fields.

To view / edit fields in the inventory of fields:

  1. From the Setup workspace, click Inventory of Fields in the left navigation.
    You see the Inventory of Fields workspace with the list of available database tables.
  2. Select the database table that contains the field you wish to view or edit.
    You see the list of columns in the table.
  3. Double click the field you wish to view or edit.
    You see the New PACE Inventory Field dialog box.
  4. Review the information, make the appropriate changes, and click Save All.
    You see the refreshed list of columns in the table.

Anchor
_

Toc422747209

Toc422747223
_

Toc422747209

Toc422747223
Manage

Sources

Field Groups

You can use the Setup workspace in Reference Data Center to add, view, and edit the data sources used by Reference Data Center. You can add data sources to use as gold copies for data strategies.

Anchor_Toc422747210_Toc422747210Add Data Sources

You can add data sources for use as additional vendor sources or gold copies.
To add data sources:

  1. From the Setup workspace, click Sources in the left navigation.
    You see the Sources workspace with the current list of data sources.
  2. Click Add.
    You see the Add Source Details dialog box.
  3. Enter the Short Name, Long Name, and Comments that describe the data source. The short name identifies the records on the historical database for this data source.
  4. Select the Feed Types you wish to use with this data source. For example, for BBID (Bloomberg) as a data source, you can select Analytics, Positions, Prices, Securities, and so forth, as feed types.
  5. Click Assign to select or remove business groups that access the data source.
  6. Click Save.
    You see the refreshed list of all the available data sources.
Anchor_Toc422747211_Toc422747211View / Edit Data Sources

You can view and edit the data sources.
To view / edit data sources:

  1. From the Setup workspace, click Sources in the left navigation.
    You see the Sources workspace with the refreshed list of data sources.
  2. Select the source you wish to view / edit and click Edit.
    You see the Editing Source Details dialog box.
  3. Review the information, make the appropriate changes, and click Save.
    You see the refreshed list of all the available data sources.
Anchor_Toc422747212_Toc422747212 Manage Code Values

You can use the Setup workspace in Reference Data Center to add, edit, and delete code values used to validate composited and non-composited fields. See "Manage Field Attributes" for details on assigning a code category for field validation. Code values are discrete lists of approved field values organized by code category. When you assign a code category to a field for validation, the reference data value must match a code value listed in the code category or an exception is raised.
Code values are also used by Reference Data Center to populate drop down lists for queries. For example, the code category RDC_REL_LEVELS is used to populate the Release Level drop down list displayed for the Security Summary query, as shown below:

  •  NOT RELEASED
  •  RELEASED FOR TRADING
  •  RELEASED FOR TRADING AND BACK OFFICE
  •  RELEASED WITH NO EXCEPTIONS
Anchor_Toc422747213_Toc422747213Add Code Values

You can add code values to a code category.
To add code values to a code category:

  1. From the Setup workspace, click Codes in the left navigation.
    You see the Codes workspace with the list of available code categories.
  2. Select the code category for the code value you wish to add and click Add Code.
    You see the Codes web dialog box.
  3. Enter the Short Name and Long Name for the new code value.
  4. Click Add.
    You see the refreshed list of available code categories. You must double click the code category short description to view the updated list of codes in the code category.
Anchor_Toc422747214_Toc422747214View / Edit Code Values

You can view and edit code values within a code category.
To view / edit code values within a code category:

  1. From the Setup workspace, click Codes in the left navigation.
    You see the Codes workspace with the list of available code categories.
  2. Select the code category you wish to edit and click Edit Code.
    You see the list of code values for the code category.
  3. Select the code value you wish to view or edit and click Edit.
    You see the Code Values dialog box.
  4. Review the information, make the appropriate changes, and click OK.
    You see the refreshed list of all code values for the code category.
Anchor_Toc422747215_Toc422747215

Delete Code Values

You can delete code values from a code category.
To delete code values from a code category:

  1. From the Setup workspace, click Codes in the left navigation pane.
    You see the Codes workspace with the list of available code categories.
  2. Double click the code category you wish to review.
    You see the list of code values for the code category.
  3. Select the code value you wish to delete and click Delete.
    You see the refreshed list of all code values for the code category.
Anchor_Toc422747216_Toc422747216 Manage Date Rules

You can use the Setup workspace in Reference Data Center to add, view, and edit date rules. Date rules determine the date (or date range) that filters data used for an associated process. For example, date rules are used to calculate relative dates, that is, dates in relation to the current cycle effective date. You can assign a date rule to block stale vendor data from use when you define the data strategies.

Anchor_Toc422747217_Toc422747217Add Date Rules

You can add date rules to calculate relative dates.
To add date rules:

  1. From the Setup workspace, click Date Rules in left navigation.
    You see the Date Rules workspace with list of available date rules.
  2. Click New.
    You see the New Date Rule dialog box.
  3. Enter Name for the field.
  4. Enter Comments/Remarks for the field.
  5. Click the 3. How do you want your start date? drop down, select calculate, and complete the start date information.
  6. Click the 4. How do you want your end date? drop down, select calculate, and complete the end date information.
  7. Set the 5. What date do you wish use in functions where a single date is required? field to Start date or End date.
  8. Click the 6. Which Source do you want to use for the business Calendar? drop down and select the data source you wish to use for your business calendar. Default is EAGLE PACE.
  9. Click OK.
    You see a message that the date rule was successfully saved and the Date Rules window refreshes the list of available date rules.
Anchor_Toc422747218_Toc422747218View / Edit Date Rules

You can view and edit date rules that calculate relative dates.
To view / edit date rules:

  1. From the Setup workspace, click Date Rules in left navigation.
    You see the Date Rules workspace with the list of available date rules.
  2. Select the date rule you wish to view/edit and click Edit on the toolbar.
    You see the Edit Date Rule dialog box.
  3. Review the information, make the appropriate changes, and click OK.
    You see the Date Rules window refresh with the list of available date rules.
Anchor_Toc422747219_Toc422747219

Date Rule Example

You can use date rules for processing data strategies for time-sensitive reference data types such as Schedules. You can also use date rules to control when vendor data is consider too stale for composite use.
For example, assume that you are processing composited securities for an effective date of 1/1/2013 and wish to exclude vendor data that is more than 35 days old. You can assign a date rule to the data strategy that calculates the relative date 11/27/2012 and then blocks all data older than 11/27/2012 from the 1/1/2013 compositing process. In effect, only the most recent vendor data within the calculated 35-day window is composited and all older vendor data is ignored.
 

Anchor_Toc422747220_Toc422747220 Manage Error Codes

You can use the Setup workspace in Reference Data Center to add, view, and edit the error codes used by Reference Data Center for field validation. You can define error codes and messages in different languages.

Anchor_Toc422747221_Toc422747221Add Error Codes

You can add error codes for use with field validations.
To add error codes:

  1. From the Setup workspace, click Errors in the left navigation.
    You see the Errors workspace with the current list of error codes.
  2. Click Create New.
    You see the Create New dialog box.
  3. Click the Center drop down and select Reference Data Center.
  4. In the Code text box, enter a unique identifier. If you leave this option blank, the system assigns a unique identifier.
  5. Specify the severity for this error.
    Options include:
    –  Critical. (Default). This option blocks the use of the flagged field in the security composite; the field must be corrected.
    –  Warning. This option allows the use of the flagged field in the security composite; the error is considered informational.
  6. In the Description text box, enter a description of the error.
  7. In the Business Description text box, optionally enter a business description of the error.
  8. In the Resolution text box, enter a suggested resolution for the error.
  9. Click OK.
    You see the refreshed list of all the available error codes.
Anchor_Toc422747222_Toc422747222View / Edit Error Codes

You can view and edit the data Errors.
To view / edit data Errors:

  1. From the Setup workspace, click Errors in the left navigation.
    You see the Errors workspace with the list of available error codes.
  2. Select the error code you wish to view or edit and click Edit.
    You see the Editing Errors dialog box.
  3. Review the information, make the appropriate changes, and click OK.
    You see the refreshed list of error codes.
Anchor_Toc422747223_Toc422747223 Manage Field Groups

You can use the Setup workspace in Reference Data Center to maintain field groups for use with your data strategies. You can also reconfigure data strategies that use these field groups. A field group consists of a set of field attributes. You must assign enrichments to the field attributes in the field group before they can be used with data strategies.

Anchor_Toc422747224_Toc422747224Define Field Groups

You can define new field groups and specify general information about the field group.
To define new field groups:

  1. From the Setup workspace, click Field Groups in the left navigation.
    You see the Field Groups workspace with the list of available groups.
  2. Click Create New.
    You see the Field Group Define dialog box.
  3. In the ID text box, enter a unique identifier. If you leave this option blank, the system assigns a unique identifier.
  4. In the Name text box, enter a name for the field group.
  5. In the Description text box, optionally enter a description of the field group.
  6. Click the Data Type drop down and select the field group data type. To use this field group managed by a given data strategy, you must select a data type that the data strategy manages.
    Options include:
    –  Security
    –  Analytics
    –  Ratings
    –  Variable Rates
  7. Click the Assign Exceptions To drop down and select the user group that handles the exceptions for the fields within the field group.
  8. Set Field Treatment if you wish the fields in this group to source from a single vendor and release only when all fields are eligible for release. Or, clear this field if you wish to allow the fields to be sourced from more than one vendor and release as each field is eligible for release.
  9. Click Next.
    You see the Field Group Fields dialog box.
Anchor_Toc422747225_Toc422747225Specify the Fields

You can specify the set of fields that comprise the field group.
To specify the set of fields in the field group:

  1. Click Add.
    You see the Field Selector dialog box.
  2. Select the fields you wish for the field group.
  3. Click OK.
    You see the refreshed list of fields, including any validations assigned when you managed field properties. See Manage Field Properties for details about setting up field validations for fields.
    NOTE: If you select the two fields with the same underlying database field, a warning message is raised.
  4. Click Next.      You see the  Field Group Data Strategy dialog box.
Anchor_Toc422747226_Toc422747226Specify Data Strategies

You can specify data strategies that use this field group, as well as reconfigure the data strategy for source rules, override values, and validations.
To specify data strategies that use this field group:

  1. Click the Select Data Strategies drop down and select the data strategies that plan to use this field group.
    You see the data strategies listed in the workspace with the current data strategy settings for source rules, override values, and validations.
    NOTE: Field group has been added to the list of field groups at the bottom of the list.
  2. Select the data strategy you wish to reconfigure.
  3. Click the Field Groups tab and reorder the list as you wish the data strategy to display.
  4. Click the Fields tab and review the release level options and properties for each field in the new field group. You can override the field default settings for use with this data strategy.
  5. Go to Step 2 and reconfigure any other data strategy you have selected for use with this field group.
  6. Click Save and Close.
    You see the refreshed list of field groups.
Anchor_Toc422747227_Toc422747227 Manage Validations

You can use the Setup workspace in Reference Data Center to create validations that raise errors and warning messages. Validations ensure the quality of your composited data. You can only assign validations to data strategies when you manage field properties during your data strategy setup.

Anchor_Toc422747228_Toc422747228Create Validations

You can create validations to confirm the legitimacy of the field values used in the composited record.
To create validations for composited fields:

  1. From the Setup workspace, click Validations in the left navigation.
    You see the Validations workspace with the list of available validations.
  2. Click Create New.
    You see the Creating New Validation dialog box.
  3. In the ID text box, enter a unique identifier. If you leave this option blank, the system assigns a unique identifier.
  4. In the Name text box, enter a name for the validation.
  5. In the Description text box, optionally enter a description of the validation.
  6. Click the Data Type drop down and select the validation data type. To use this validation with fields managed by a given data strategy, you must select a data type that the data strategy manages.
    Options include:
    –  Security
    –  Analytics
    –  Ratings
    –  Variable Rates
  7. Click the Error drop down.
    You see the Select Errors dialog box.
  8. Click the Center drop down and select RDC.
  9. Click the Error Severity drop down and select the severity of the error you wish assigned.
    Options include:
    –  Critical
    –  Warning
  10. Click Search.
    You see the list of available error codes used by Reference Data Center for the severity level selected.
  11. Select the error code that you wish raised when the validation is true and click Ok.
  12. Click Define for Tests and use the Logic Builder to define the logic for the validation. For example, to raise an error when field X is empty, the logic is "Field X is null".
  13. Set Gold Copy Data if you wish to apply the validation to the composited gold copy field. Or, clear if validations do not apply.
  14. Set Vendor Data if you wish to apply the validation to the vendor sourced field. Or, clear if validations do not apply.
  15. Set Apply this validation when data is manually entered if you wish to apply the validation to manually entered values. Or, clear if validations do not apply.
  16. Click Save.
    You see the refreshed list of available validations.
Anchor_Toc422747229_Toc422747229View / Edit Validations

You can view and edit field validations.
To edit / view validations for composited fields:

  1. From the Setup workspace, click Validations in the left navigation.
    You see the Validations workspace with the list of available validations.
  2. Select the validation you wish to view / edit.
  3. Click Edit.
    You see the Editing Validation dialog box.
  4. Review the information, make the appropriate changes, and click Save.
Anchor_Toc422747230_Toc422747230 Manage Gold Copies

You can use the Setup workspace in Reference Data Center to define gold copies to use with data strategies for compositing and maintaining securities data. You can edit and view gold copy definitions.

Anchor_Toc422747231_Toc422747231Define Gold Copies

You can define gold copies for composited securities data. You must associate each gold copy to a defined source interface instance, such as EAGLE PACE.
To define gold copies:

  1. From the Setup workspace, click Gold Copies in the left navigation.
    You see the Gold Copies workspace with the list of available gold copies.
  2. Click Create New.
    You see the Creating New Gold Copy dialog box.
  3. In the Name text box, enter a name for the gold copy.
  4. In the Description text box, optionally enter a description of the gold copy.
  5. Click the Composite Source drop down.
    You see the Select Interfaces dialog box.
  6. Click the Feed Type drop down and select SMF.
  7. Click Search.
    You see the list of available source interfaces for securities gold copies.
  8. Select the source interface you wish to use.
  9. Click Save.
    You see the refreshed list of available gold copies.
Anchor_Toc422747232_Toc422747232View / Edit Gold Copy Definitions

You can view and edit gold copy definitions.
To edit / view gold copy definitions:

  • From the Setup workspace, click Gold Copies in the left navigation.
    You see the Gold Copies workspace with the list of available definitions.
  • Select the gold copy definition you wish to view / edit.
  • Click Edit.
    You see the Editing Gold copy dialog box.
    •  Review the gold copy definition, make the appropriate changes, and click Save

    maintain field groups for use with your data strategies. You can also reconfigure data strategies that use these field groups. A field group consists of a set of field attributes. You must assign enrichments to the field attributes in the field group before they can be used with data strategies.

    Anchor
    _Toc422747224
    _Toc422747224
    Define Field Groups

    You can define new field groups and specify general information about the field group.

    To define new field groups:

    1. From the Setup workspace, click Field Groups in the left navigation.
      You see the Field Groups workspace with the list of available groups.
    2. Click Create New.
      You see the Field Group Define dialog box.
    3. In the ID text box, enter a unique identifier. If you leave this option blank, the system assigns a unique identifier.
    4. In the Name text box, enter a name for the field group.
    5. In the Description text box, optionally enter a description of the field group.
    6. Click the Data Type drop down and select the field group data type. To use this field group managed by a given data strategy, you must select a data type that the data strategy manages.
      Options include:
      –  Security
      –  Analytics
      –  Ratings
      –  Variable Rates
    7. Click the Assign Exceptions To drop down and select the user group that handles the exceptions for the fields within the field group.
    8. Set Field Treatment if you wish the fields in this group to source from a single vendor and release only when all fields are eligible for release. Or, clear this field if you wish to allow the fields to be sourced from more than one vendor and release as each field is eligible for release.
    9. Click Next.
      You see the Field Group Fields dialog box.

    Anchor
    _Toc422747225
    _Toc422747225
    Specify the Fields

    You can specify the set of fields that comprise the field group.

    To specify the set of fields in the field group:

    1. Click Add.
      You see the Field Selector dialog box.
    2. Select the fields you wish for the field group.
    3. Click OK.
      You see the refreshed list of fields, including any validations assigned when you managed field properties. See Manage Field Properties for details about setting up field validations for fields.
      NOTE: If you select the two fields with the same underlying database field, a warning message is raised.
    4. Click Next.      
      You see the  Field Group Data Strategy dialog box.

    Anchor
    _Toc422747226
    _Toc422747226
    Specify Data Strategies

    You can specify data strategies that use this field group, as well as reconfigure the data strategy for source rules, override values, and validations.
    To specify data strategies that use this field group:

    1. Click the Select Data Strategies drop down and select the data strategies that plan to use this field group.
      You see the data strategies listed in the workspace with the current data strategy settings for source rules, override values, and validations.
      NOTE: Field group has been added to the list of field groups at the bottom of the list.
    2. Select the data strategy you wish to reconfigure.
    3. Click the Field Groups tab and reorder the list as you wish the data strategy to display.
    4. Click the Fields tab and review the release level options and properties for each field in the new field group. You can override the field default settings for use with this data strategy.
    5. Go to Step 2 and reconfigure any other data strategy you have selected for use with this field group.
    6. Click Save and Close.
      You see the refreshed list of field groups.