Ledger Granularity Rule Detail Options

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

The following are the options in the Add Granularity Rule Details panel.

Required Parameters

The following are the options for required parameters:

  • Ledger Granularity Type (tag 7001). Determines the type of details you are defining. Options include:
    –  Holding Term. Allows you to define details for holding term granularity rules to break out core ledger accounts by long term, short term, or cash equivalent holding terms. Additional fields appear that allow you to identify the ledger granularity rule for the details and provide holding term account mapping information and core ledger account information.
    –  Custom Granularity - PST Rule Detail. Allows you to define details for custom granularity rules that break out custom accounts by processing security type in combination with security master attributes. Additional fields appear that allow you to identify the ledger granularity rule, granularity pool, and PST for the details, and provide core account to custom account mappings to use in ledger reports.
    –  Custom Granularity - Security Group Rule Detail. Allows you to define details for custom granularity rules that break out custom accounts by security groupings. Additional fields appear that allow you to identify the ledger granularity rule and security grouping for the details, and provide core account to custom account mappings to use in ledger reports.
  • Ledger Granularity Rule Name (tag 8939). Specifies the name of the ledger granularity rule for which you are defining details.
  • Granularity Pool (tag 11482). Displays the name of the granularity pool associated with the ledger granularity rule. This field appears if you set the Ledger Granularity Type field (tag 7001) to a value of Custom Granularity - PST Rule Detail.
  • Processing Security Type (tag 3931). Specifies the processing security type for which you are mapping accounts. This field appears if you set the Ledger Granularity Type field (tag 7001) to a value of Custom Granularity - PST Rule Detail.
  • Processing Security Type Rule Instance (tag 9093). Displays the unique identifier of the PST rule associated with the selected ledger granularity rule and processing security type. This field appears if you set the Ledger Granularity Type field (tag 7001) to a value of Custom Granularity - PST Rule Detail.
  • Security Grouping Description (tag 9095). Specifies the name of the security grouping for which you are defining details. This field appears if you set the Ledger Granularity Type field (tag 7001) to a value of Custom Granularity - Security Group.
  • Security Grouping (tag 9095). Displays the unique identifier of the security grouping for which you are defining details. This field appears if you set the Ledger Granularity Type field (tag 7001) to a value of Custom Granularity - Security Group.

Holding Term Account Mapping Information

The following are the options for holding term account mapping information.

  • Ledger Granularity Short Term Account (tag 8941). Displays the account number for the target short term account for the holding term breakout. After you specify a value in the Core Ledger Account field, the system displays the corresponding short term account to use for a holding term breakout. This field appears if you set the Ledger Granularity Type field (tag 7001) to a value of Holding Term.
  • Ledger Granularity Short Term Account Description (tag 7003). Displays the account description for the target short term account for the holding term breakout. This field appears if you set the Ledger Granularity Type field (tag 7001) to a value of Holding Term.
  • Ledger Granularity Cash Equivalent Account (tag 8942). Displays the account number for the target cash equivalent account for the holding term breakout. After you specify a value in the Core Ledger Account field, the system displays the corresponding cash equivalent account to use for a holding term breakout. This field appears if you set the Ledger Granularity Type field (tag 7001) to a value of Holding Term.
  • Ledger Granularity Cash Equivalent Account Description (tag 7004). Displays the account description for the target cash equivalent account for the holding term breakout. This field appears if you set the Ledger Granularity Type field (tag 7001) to a value of Holding Term.

PST Rule - Security Attributes

The following are the options for PST rule security attributes:

  • Security Type Group (tag 7010). Identifies the name of the security type attribute grouping to which the account mappings for the selected PST rule apply. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by security type, and security type is the first attribute. The available security type attribute groupings are defined in the granularity pool assigned to the ledger granularity rule.
  • Security Type Group Instance (tag 2288). Specifies the unique identifier of the security type attribute grouping to which the account mappings for the PST rule apply. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by security type, and security type is the first attribute.
  • Long / Short Indicator (tag 2289). Identifies the Long/Short Indicator value to which the account mappings for the selected PST rule apply. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by Long/Short Indicator, and Long/Short Indicator is the first attribute. Options include Long and Short.
  • Federal Tax Indicator (tag 2290). Identifies the security's Federal Tax Indicator value to which the account mappings for the selected PST rule apply. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by Federal Tax Indicator, and Federal Tax Indicator is the first attribute. Options include Yes and No.
  • Market Sector Description Group (tag 7011). Identifies the name of the market sector description attribute grouping to which the account mappings for the selected PST rule apply. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by market sector description, and market sector description is the first attribute. The available market sector description attribute groupings are defined in the granularity pool assigned to the ledger granularity rule.
  • Market Sector Description Group Instance (tag 2291). Specifies the unique identifier of the market sector description attribute grouping to which the account mappings for the PST rule apply. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by market sector description, and market sector description is the first attribute.
  • Issue Country Group (tag 7005). Identifies the name of the issue country attribute grouping to which the account mappings for the selected PST rule apply. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by issue country, and issue country is the first attribute. The available issue country attribute groupings are defined in the granularity pool assigned to the ledger granularity rule.
  • Issue Country Group Instance (tag 2292). Specifies the unique identifier of the issue country attribute grouping to which the account mappings for the PST rule apply. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by issue country, and issue country is the first attribute.
  • Affiliated / Unaffiliated (tag 2293). Identifies the security's Affiliated/Unaffiliated value to which the account mappings for the selected PST rule apply. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by Affiliated/Unaffiliated, and Affiliated/Unaffiliated is the first attribute. Options include Affiliated and Unaffiliated.
  • Granularity Category (tag 2300). Identifies the name of the granularity category to which the account mappings for the selected PST rule apply. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by granularity category, and granularity category is the first attribute. You can specify a null value for the granularity category.
  • Granularity Category Desc (tag 7013). Displays the description for the selected granularity category. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by granularity category, and granularity category is the first attribute.
  • Security Type Group (tag 7009). Identifies the name of the security type attribute grouping to which the account mappings for the selected PST rule apply. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by security type, and security type is the second attribute. The available security type attribute groupings are defined in the granularity pool assigned to the ledger granularity rule.
  • Security Type Group Instance (tag 2294). Specifies the unique identifier of the security type attribute grouping to which the account mappings for the PST rule apply. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by security type, and security type is the second attribute.
  • Long / Short Indicator (tag 2295). Identifies the Long/Short Indicator value to which the account mappings for the selected PST rule apply. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by Long/Short Indicator, and Long/Short Indicator is the second attribute. Options include Long and Short.
  • Federal Tax Indicator (tag 2296). Identifies the security's Federal Tax Indicator value to which the account mappings for the selected PST rule apply. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by Federal Tax Indicator, and Federal Tax Indicator is the second attribute. Options include Yes and No.
  • Market Sector Description Group (tag 7012). Identifies the name of the market sector description attribute grouping to which the account mappings for the selected PST rule apply. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by market sector description, and market sector description is the second attribute. The available market sector description attribute groupings are defined in the granularity pool assigned to the ledger granularity rule.
  • Market Sector Description Group Instance (tag 2297). Specifies the unique identifier of the market sector description attribute grouping to which the account mappings for the PST rule apply. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by market sector description, and market sector description is the second attribute.
  • Issue Country Group (tag 7002). Identifies the name of the issue country attribute grouping to which the account mappings for the selected PST rule apply. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by issue country, and issue country is the second attribute. The available issue country attribute groupings are defined in the granularity pool assigned to the ledger granularity rule.
  • Issue Country Group Instance (tag 2298). Specifies the unique identifier of the issue country attribute grouping to which the account mappings for the PST rule apply. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by issue country, and issue country is the second attribute.
  • Affiliated / Unaffiliated (tag 2299). Identifies the security's Affiliated/Unaffiliated value to which the account mappings for the selected PST rule apply. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by Affiliated/Unaffiliated, and Affiliated/Unaffiliated is the second attribute. Options include Affiliated and Unaffiliated.
  • Granularity Category (tag 2301). Identifies the name of the granularity category to which the account mappings for the selected PST rule apply. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by granularity category, and granularity category is the second attribute. You can specify a null value for the granularity category.
  • Granularity Category Desc (tag 7014). Displays the description for the selected granularity category. This field appears if the Processing Security Type Rule Instance field (tag 9093) value identifies a PST rule that breaks out accounts by granularity category, and granularity category is the second attribute.

Core Ledger Account Information

The following are the options for core ledger account information:

  • Core Ledger Account (tag 1288). Specifies the account number as it exists in the core Chart of Accounts. For custom granularity, you must specify a core account to map to the new custom account. If you break out an account with holding term granularity, note that all three accounts (LT, ST, CE) can be further broken down using custom granularity.
  • Core Ledger Account Description (tag 1290). Specifies the account description for the account number as it exists in the core Chart of Accounts. This field appears if you set the Ledger Granularity Type field (tag 7001) to a value of Custom Granularity - Security Group.

Custom Ledger Account Information

The following are the options for custom ledger account information:

  • Custom Ledger Account Number (tag 1623). Specifies the custom account number to use for the PST rule or security grouping breakout. This field appears if you set the Ledger Granularity Type field (tag 7001) to a value of Custom Granularity - PST Rule Detail or Custom Granularity - Security Group Detail.
  • Custom Ledger Description (tag 1624). Specifies the description of the custom account number to use for the PST rule or security grouping breakout. This field appears if you set the Ledger Granularity Type field (tag 7001) to a value of Custom Granularity - PST Rule Detail or Custom Granularity - Security Group Detail.