Manage Metadata

Owned by Tom Fahey (Unlicensed)
Last updated: Oct 24, 2016 by Former user (Deleted)
7 min read

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.

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.

Add a Field to a Field Group

Content on this page:

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.