Manage Security Groupings for Ledger Granularity Rules

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

A security grouping allows a ledger granularity rule to break out custom ledger accounts for a group of securities in the same manner when you cannot use security master attributes to define that set of securities. You can use security groupings in ledger granularity rules when certain assets do not share common security attributes that enable you to identify them using a processing security type (PST) rule.

You can create one or more security groupings for each ledger granularity rule. If you are assigning the same ledger granularity rule to multiple entities, the security grouping can include assets held by different entities, so long as the entities plan to break out accounts for those securities in the same manner. For example, you assign Ledger Granularity Rule 1 to Entity A and Entity B. If Entity A holds assets A, B, and C and Entity B holds assets A, Y, and Z, and if both entities use the same custom accounts for these sets of assets, you create a single security grouping for those securities and assign it to both Entity A and B.

Add Securities to Ledger Granularity Rules

In the Add Security to Granularity Rule panel, you can add or update a security grouping associated with a ledger granularity rule, and can add a security to a new or existing security grouping. The security becomes effective in the security grouping on the current date. 

Content on this page:

To add a security to a granularity rule:

  1. From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
  2. Enter Add Security to Granularity Rule in the Start Search text box.
  3. Click the Add Security to Granularity Rule (Accounting Center) link to access the panel.
    You see the Add Security to Granularity Rule panel.
  4. Complete the options in the Add Security to Granularity Rule panel.
  5. Click Submit.
  6. Repeat this procedure to add multiple securities to a security grouping for a ledger granularity rule.
  7. Close the Add Security to Granularity Rule bottom tab to return to the Accounting Center.

Add Security to Granularity Rule Panel Options

The following are the options in the Add Security to Granularity Rule panel:

  • Ledger Granularity Rule Name (tag 8939). Specifies the name of the ledger granularity rule associated with the security grouping.
  • Ledger Granularity Rule (tag 8933). Displays the unique identifier for the selected ledger granularity rule name.
  • Add Security to Grouping for (tag 7102). Specifies whether you are adding a new security grouping or maintaining securities for an existing security grouping. Options include:
    –  New Security Grouping. Allows you to add a security grouping.
    –  Existing Security Grouping. Allows you to update a security grouping.
  • Query Existing Security Grouping Name (tag 7101). Specifies the security grouping you are updating. This field appears only if you set the Add Security to Grouping for field (tag 7102) to a value of Existing Security Grouping.
  • Security Grouping Name (tag 9096). Specifies the name of the security grouping you are adding. This field appears only if you set the Add Security to Grouping for field (tag 7102) to a value of New Security Grouping.
  • Cross Reference Type (tag 1234). Specifies the cross reference or primary asset identifier type for the security, such as CUSIP, ISIN, and SEDOL.
  • Cross Reference ID (tag 1233). Specifies the cross reference security type, such as SEDOL, CUSIP, and so on.
  • Issue Name (tag 961). Specifies the name of the security.
  • Ticker (tag 13). Specifies the system of letters used to uniquely identify the security.

Delete a Security Grouping

In the Security Grouping Maintenance panel, you can delete a security grouping associated with a granularity rule. When you delete a security grouping, the system removes that grouping, with associated securities, from the ledger granularity rule that uses it. The effective date for the removal of the security grouping is the current date.

To delete a security grouping:

  1. From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
  2. Enter Security Grouping Maintenance in the Start Search text box.
  3. Click the Security Grouping Maintenance (Accounting Center) link to access the panel.
    You see the Security Grouping Maintenance panel.
  4. In the Transaction Type field, select Delete Entire Security Grouping.
  5. In the Security Grouping Name field, select the security grouping you want to delete. 
    You see the security alias grouping number of the selected security grouping in the Security Grouping field.
  6. Click Submit.
  7. Close the Security Grouping Maintenance bottom tab to return to the Accounting Center.

Remove Securities from Security Groupings

In the Security Grouping Maintenance panel, you can remove a security from a security grouping associated with a ledger granularity rule. The effective date for the removal of the security is the current date.

To remove a security from a security grouping:

  1. From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
  2. Enter Security Grouping Maintenance in the Start Search text box.
  3. Click the Security Grouping Maintenance (Accounting Center) link to access the panel.
    You see the Security Grouping Maintenance panel.
  4. In the Transaction Type field, select Remove a Security from Ledger Gran Rule.
    When you select this option, additional fields appear that allow you to identify the ledger granularity rule and the security you want to delete.
  5. In the Ledger Granularity Rule Name field, select the ledger granularity rule associated with the security in the security grouping you want to remove. 
    You see the identifier of the selected rule in the Ledger Granularity Rule field.
  6. Identify the security you want to remove.
    You can specify a value in the Cross Reference Type, Cross Reference Identifier, Issue Name, and/or Ticker fields to identify the security. After you select a security, you see the asset identifier of the selected security in the Asset field. You see the security grouping name and security alias grouping number for that rule in the Security Grouping Name field and the Security Grouping field.
  7. Click Submit.
  8. Close the Security Grouping Maintenance bottom tab to return to the Accounting Center.

Duplicate a Security Grouping

In the Security Grouping Maintenance panel, you can copy a security grouping and securities currently assigned to one ledger granularity rule so that you can use the securities assigned to an existing security grouping with another ledger granularity rule. 

Be aware that if in the future you add individual securities to or delete individual securities from the original security grouping associated with a ledger granularity rule, your changes do not affect the duplicated security grouping associated with another ledger granularity rule.

To duplicate a security grouping:

  1. From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
  2. Enter Security Grouping Maintenance in the Start Search text box.
  3. Click the Security Grouping Maintenance (Accounting Center) link to access the panel.
    You see the Security Grouping Maintenance panel.
  4. In the Transaction Type field, select Duplicate Security Grouping to New Ledger Gran Rule.
    When you select this option, additional fields appear that allow you to identify the From and To ledger granularity rules and the security grouping you want to duplicate.
  5. Click the FROM Ledger Granularity Rule Name field and select the name of the ledger granularity rule associated with the security grouping you want to duplicate.
    You see the identifier of the selected rule in the FROM Ledger Granularity Rule field.
  6. Click the TO Ledger Granularity Rule Name field and select the name of the ledger granularity rule to which you want to assign the security grouping .
    You see the identifier of the selected rule in the TO Ledger Granularity Rule field.
  7. In the Security Grouping Name field or the Security Grouping field, select the name or security alias grouping number of the security grouping that you want to duplicate.
  8. Click Submit.
  9. Close the Security Grouping Maintenance bottom tab to return to the Accounting Center.

List Securities in Security Groupings

In the List Securities in Grouping/Granularity Rule panel, you can list the securities associated with a specific security grouping or can list the securities associated with security groupings for a specific ledger granularity rule. 

To list securities in security groupings:

  1. From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
  2. Enter List Securities in Grouping/Granularity Rule in the Start Search text box.
  3. Click the List Securities in Grouping/Granularity Rule (Accounting Center) link to access the panel.
    You see the List Securities in Grouping/Granularity Rule panel.
  4. In the List Securities by field, indicate whether you want to view all the securities assigned to a security grouping or view all the securities assigned to a ledger granularity rule. Options include:
    –  Security Grouping
    –  Ledger Granularity Rule
  5. If you are listing securities by security grouping, enter the security grouping name in the Security Grouping Name field or enter the security alias grouping number for the security grouping you want to view in the Security Grouping field.
  6. If you are listing securities by ledger granularity rule, select a value in the Ledger Granularity Rule Name field. 
    You see the identifier of the rule you selected in the Ledger Granularity Rule field.
  7. Select a value in the Cross Reference Type, Cross Reference ID, Issue Name, and Ticker fields to further limit the results to specific securities within the selected security grouping or ledger granularity rule.
  8. Click Submit.
    You see the results for the securities that met your criteria in the Show All tab.
  9. Close the List Securities in Grouping/Granularity Rule bottom tab to return to the Accounting Center.