Manage Granularity Pools

Owned by Copy Page Tree (Unlicensed)
Last updated: Jul 21, 2023 by Nancy Cohn (Deactivated)
6 min read

A granularity pool determines the attribute groupings that are available for a ledger granularity rule that uses custom granularity. An attribute grouping is comprised of a set of attributes values for security types, market sector descriptions, or issue countries that require processing in the same manner for a ledger granularity rule. You can assign a granularity pool to multiple ledger granularity rules.

Add Granularity Pools and Attribute Groupings

In the Add Granularity Pool/Attribute Grouping panel, you can add or update a granularity pool, can add or update attribute groupings for a granularity pool, and can add attribute values to attribute groupings. You can specify attribute values for security types, market sector descriptions, and issue countries.

To add a granularity pool/attribute grouping:

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

  2. Complete the options in the Add Granularity Pool/Attribute Grouping panel.

  3. Click Submit.
    The attribute values you add become effective in the granularity pool/attribute grouping on the current date.

Add Granularity Pool/Attribute Grouping Panel Options

The following are the options in the Add Granularity Pool/Attribute Grouping panel.

Option

Tag

Description

Option

Tag

Description

New or Existing Granularity Pool

7103

Indicates whether you are adding a new granularity pool or maintaining an existing granularity pool. Options include:

  • New Granularity Pool. Allows you to add a granularity pool and add attribute groupings for that pool.

  • Existing Granularity Pool. Allows you to maintain attribute groupings for an existing granularity pool.

Granularity Pool Name

11482

Specifies the name of the granularity pool that you are adding. This field appears only if you set the New or Existing Granularity Pool field to a value of New Granularity Pool.

Query Existing Granularity Pool

7101

Specifies the granularity pool you are updating. This field appears only if you set the New or Existing Granularity Pool field to a value of Existing Granularity Pool.

Add Attribute Grouping for

7102

Indicates whether you are adding a new attribute grouping or maintaining an existing attribute grouping. You can assign the same attribute grouping to more than one granularity pool. Options include:

  • New Attribute Grouping. Allows you to add an attribute grouping for the selected pool. When you set the New or Existing Granularity Pool field to a value of New Granularity Pool, this field displays a value of New Attribute Grouping by default. If you are adding a new granularity pool, select this option.

  • Existing Attribute Grouping. Allows you to update an existing attribute grouping for the selected pool.

Attribute Group Name

11478

Specifies the name of the attribute grouping that you are adding to the selected granularity pool. You cannot assign the same attribute grouping to more than one granularity pool. This field appears only if you set the Add Attribute Grouping for field to a value of New Attribute Grouping.

Attribute Type

7002

Specifies the attribute type associated with the selected granularity pool/attribute grouping. You can select a value when you add a new attribute grouping. Otherwise, this field displays the attribute type for the selected attribute grouping. Options include:

  • Security Type. Allows you to specify a value in the Security Type field.

  • Market Sector Description. Allows you to specify a value in the Market Sector Description field.

  • Issue Country. Allows you to specify a value in the Issue Country field and the Issue Country Code field.

Security Type

2288

Specifies the security type value to add to the selected attribute group.

You can also add a null security type value to an attribute grouping. A null value matches only those securities that have a null value for that specific security attribute.

Market Sector Description

2291

Specifies the market sector description value to add to the selected attribute group.

You can also add a null market sector description value to an attribute grouping. A null value matches only those securities that have a null value for that specific security attribute.

Issue Country

7005

Specifies the issue country value to add to the selected attribute group.

You can also add a null market sector description value to an attribute grouping. A null value matches only those securities that have a null value for that specific security attribute.

Issue Country Code

2292

Specifies the issue country code value to add to the selected attribute group.

List the Attribute Groupings for a Granularity Pool

In the Granularity Pool Maintenance panel, you can view a list of attribute groupings for a granularity pool.

To list the attribute groupings for a granularity pool:

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

  2. In the Transaction Type field, select List Granularity Pool.

  3. In the Query Existing Granularity Pool field, enter the name of the granularity pool you want to review.
    When you select a pool, the Granularity Pool Instance field displays the instance number of the selected pool.

  4. Click Submit.
    You see the attribute groupings for the granularity pool in the Show All tab.

Delete Granularity Pools

In the Granularity Pool Maintenance panel, you can delete an entire granularity pool, along with the attribute groupings within that pool. You cannot delete a granularity pool if a ledger granularity rule is using that pool.

To delete a granularity pool:

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

  2. In the Transaction Type field, select Delete Entire Granularity Pool.

  3. In the Query Existing Granularity Pool field, enter the name of the granularity pool you want to delete.
    When you select a pool, the Granularity Pool Instance field displays the instance number of the selected pool.

  4. Click Submit.

Delete Attribute Groupings from a Granularity Pool

In the Granularity Pool Maintenance panel, you can delete an attribute grouping from a granularity pool. You cannot delete an attribute grouping if it is used in a custom granularity PST rule detail you set up.

To delete an attribute grouping from a granularity pool:

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

  2. In the Transaction Type field, select Delete Attribute Grouping.

  3. In the Query Existing Granularity Pool field, select the name of the granularity pool associated with the attribute grouping you want to delete.
    When you select a pool, the Granularity Pool Instance field displays the instance number of the selected pool.

  4. In the Attribute Group Name field, select the name of the attribute grouping you want to delete.
    When you select an attribute grouping, the Attribute Group Number field displays the instance number of the selected group and the Attribute Type field displays the attribute type associated with the selected granularity pool/attribute group.

  5. Click Submit.

Delete Attributes from an Attribute Grouping

In the Granularity Pool Maintenance panel, you can delete a security master attribute from an attribute grouping associated with a granularity pool. For example, if you set up a granularity pool that includes an attribute grouping for security types FI, MF, and DB, you can delete the FI security master attribute from the attribute grouping.

To delete an attribute from an attribute grouping:

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

  2. In the Transaction Type field, select Remove Attribute from Grouping.

  3. In the Query Existing Granularity Pool field, select the name of the granularity pool associated with the attribute grouping from which you want to delete an attribute.
    When you select a pool, the Granularity Pool Instance field displays the instance number of the selected pool.

  4. In the Attribute Group Name field, select the name of the attribute grouping from which you want to delete an attribute.
    When you select an attribute grouping, the Attribute Group Number field displays the instance number of the selected group and the Attribute Type field displays the attribute type associated with the selected granularity pool/attribute group.

  5. In the Gran Source Value 1 field, select the security master attribute that you want deleted. 
    If you do not specify an attribute, the system deletes any attribute with a null value for the specified criteria.

  6. Click Submit.

Â