Manage Security Groupings for Ledger Granularity Rules

Owned by Copy Page Tree (Unlicensed)
Last updated: Jul 21, 2023 by Nancy Cohn (Deactivated)
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. 

To add a security to a granularity rule:

  1. Do one of the following: 
    - In Portfolio Data Center, in the left navigation pane, click Portfolio Desk > Accounting Portfolio Rules > Ledger Granularity> Add Security to Granularity Rule.
    - In Accounting Center, in the left navigation pane, click Setup > Portfolio Rules > Ledger Granularity > Add Security to Granularity Rule.
    You see the Add Security to Granularity Rule panel.

  2. Complete the options in the Add Security to Granularity Rule panel.

  3. Click Submit.

  4. Repeat this procedure to add multiple securities to a security grouping for a ledger granularity rule.

Add Security to Granularity Rule Panel Options

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

Option

Tag

Description

Option

Tag

Description

Ledger Granularity Rule Name

8939

Specifies the name of the ledger granularity rule associated with the security grouping.

Ledger Granularity Rule

8933

Displays the unique identifier for the selected ledger granularity rule name.

Add Security to Grouping for

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

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

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

1234

Specifies the cross reference or primary asset identifier type for the security, such as CUSIP, ISIN, and SEDOL.

Cross Reference ID 

1233

Specifies the cross reference security type, such as SEDOL, CUSIP, and so on.

Issue Name

961

Specifies the name of the security.

Ticker

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. Do one of the following: 
    - In Portfolio Data Center, in the left navigation pane, click Portfolio Desk > Accounting Portfolio Rules > Ledger Granularity> Security Grouping Maintenance.
    - In Accounting Center, in the left navigation pane, click Setup > Portfolio Rules > Ledger Granularity > Security Grouping Maintenance.
    You see the Security Grouping Maintenance panel.

  2. In the Transaction Type field, select Delete Entire Security Grouping.

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

  4. Click Submit.

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. Do one of the following: 
    - In Portfolio Data Center, in the left navigation pane, click Portfolio Desk > Accounting Portfolio Rules > Ledger Granularity> Security Grouping Maintenance.
    - In Accounting Center, in the left navigation pane, click Setup > Portfolio Rules > Ledger Granularity > Security Grouping Maintenance.
    You see the Security Grouping Maintenance panel.

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

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

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

  5. Click Submit.

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. Do one of the following: 
    - In Portfolio Data Center, in the left navigation pane, click Portfolio Desk > Accounting Portfolio Rules > Ledger Granularity> Security Grouping Maintenance.
    - In Accounting Center, in the left navigation pane, click Setup > Portfolio Rules > Ledger Granularity > Security Grouping Maintenance.
    You see the Security Grouping Maintenance panel.

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

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

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

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

  6. Click Submit.

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. Do one of the following: 
    - In Portfolio Data Center, in the left navigation pane, click Portfolio Desk > Accounting Portfolio Rules > Ledger Granularity> List Securities in Grouping/Granularity Rule.
    - In Accounting Center, in the left navigation pane, click Setup > Portfolio Rules > Ledger Granularity > List Securities in Grouping/Granularity Rule.
    You see the List Securities in Grouping/Granularity Rule panel.

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

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

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

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

  6. Click Submit.
    You see the results for the securities that met your criteria in the Show All tab.