Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Custom granularity adds granularity to your custom chart of account by breaking out accounts based on security characteristics. These characteristics can include processing security type, security type, long/short indicator, Federal tax indicator, market sector description, affiliated/unaffiliated, issue country, and granularity category, or can include a group of user specified assets. The system uses custom granularity rules to post the appropriate information for report rendering. You can then run ledger report queries that break core ledger accounts into more granular custom accounts.

Set Up Ledger Granularity Rules for Custom Granularity

Depending on the criteria you use to break out accounts, you may need to perform some or all of the following tasks to create ledger granularity rules for custom granularity.

To set up ledger granularity rules based on custom granularity:

  1. Assign security attributes to the appropriate securities if you are creating rules based on security attributes. See the Set Up Securities for Ledger Granularity page for more information.
  2. Add granularity pools that determine the attribute groupings available for a ledger granularity rule if you are creating rules based on security types, market sector descriptions, and/or issue countries. See the Manage Granularity Pools page for more information.
  3. Add ledger granularity rules. See the Manage Ledger Granularity Rules page for more information.
  4. Add PST rules if you are creating rules based on processing security type (PST). A PST rule identifies a specific PST plus zero, one, or two of seven available security attributes. See the Manage Processing Security Type (PST) Rules page for more information.
  5. Add ledger granularity rule details based on PST rules where you set the Ledger Granularity Type field to a value of Custom Granularity - PST Rule Detail. The rule details provide the criteria for applying the rule and include core account to custom account mappings to use in ledger reports. See the Manage Ledger Granularity Rules page for more information.
  6. Create security groupings, if you use them for account breakouts, and ensure they include the appropriate set of securities. See the Manage Security Groupings for Ledger Granularity Rules page for more information.
  7. Add ledger granularity rule details based on security groupings where you set the Ledger Granularity Type field to a value of Custom Granularity - Security Group Rule Detail. The rule details provide the criteria for applying the rule and include core account to custom account mappings to use in ledger reports. See the Manage Ledger Granularity Rules page for more information.
  8. Assign ledger granularity rules to each entity/accounting basis that requires ledger granularity reporting. See the Set Up Entities for Ledger Granularity page for more information.

Security Characteristics Available for Account Breakouts

Content on this page:

Custom granularity rules have great flexibility and allow for many different options in customizing ledger accounts. At the most granular level, you can create a rule for an individual security or group of securities, using the Security Grouping panels.

You can also set up rules at the processing security type level called PST rules. For PST rules you are allowed up to two additional security attributes (in addition to processing security type) with which to differentiate securities. The attributes available include:

OptionTagDescription
Long/Short Indicator15Indicates whether the position is long or short. Stored in the ESTAR_LEDGER_ACCOUNT table in the OPEN_EVT_ID column
Federal Tax Indicator 1545Indicates whether the security has a U.S. Federal Tax Indicator. Stored in the SECURITYDBO.FIXED_INCOME table in the FEDERAL_TAX_INDICATOR column.
Affiliated/Unaffiliated1433Indicates whether the security is affiliated or unaffiliated. Stored in the SECURITYDBO.SECURITY_MASTER table in the USER_GROUP_SECTOR2 column.
Granularity Category11476A granularity category is a generic SMF field added specifically for ledger granularity. If the available attributes (security type, long/short indicator, federal tax indicator, market sector description, affiliated/unaffiliated, and issue country) do not provide enough breakout for a security, you can use a granularity category to classify that asset. No default values are provided for this field. You can add code values using the Codes workspace for the GRANULARITY_CAT code category. Stored in the SECURITYDBO.SECURITY_MASTER table in the GRANULARITY_CATEGORY column.
Security Type82Specifies the security type of the security. Stored in the SECURITYDBO.SECURITY_MASTER table in the SECURITY_TYPE column.
Market Sector Description10173Specifies the market sector description for the security. Stored in the SECURITYDBO.SECMASTER_DETAIL_EXT table in the MARKET_SECTOR_DESCRIPTION column.
Issue Country1418Specifies the code that represents the country that issued the security. Stored in the SECURITYDBO.SECMASTER_DETAIL_EXT table in the COUNTRY_OF_ISSUE column.


If you create rules based on the last three attributes (Security Type, Market Sector Description, Issue Country), you must use granularity pools to group the attribute values.

About Granularity Pools

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. Granularity rules facilitate the setup process for rules based on security types, market sector descriptions, or issue countries. You can assign a granularity pool to multiple ledger granularity rules.

When you first add a ledger granularity rule that you plan to use to break out accounts by security type, market sector description, and/or issue country, you must identify the granularity pool to use with that rule. This allows you to choose attribute groupings from the granularity pool when you define rule details.

The following example illustrates how granularity pools work. Say you plan to create a ledger granularity rule that breaks out ledger accounts by processing security type along with security type and issue country. The granularity pool you create for this ledger granularity rule might include four attribute groupings. If security types CMBS, RMBS, and MBS are reflected on one ledger account and security types EQ, MF, and CASH are reflected in another ledger account, you can create a granularity pool that includes an ST Mortgage Backeds attribute grouping for security types CMBS, RMBS, and MBS and includes an ST Other attribute grouping for security types EQ, MF, and CASH. You also create a Country Domestic A attribute grouping in that pool for an issue country of US and create a Country Foreign A attribute grouping for an issue country of CA, IT, and ME because those sets of attribute values are processed the same way. 

The following figure illustrates the data stored in granularity pools. Granularity Pool A contains six attribute groupings based on security type, issue country, and market sector description. Granularity Pool B contains four attribute groupings based on security type and issue country. 

Granularity Pool

Attribute Grouping Name

Attribute Grouping #

Attribute Grouping Value

Attribute

A

ST Mortgage Backeds

1

CMBS

Security Type

A

ST Mortgage Backeds

1

RMBS

Security Type

A

ST Mortgage Backeds

1

MBS

Security Type

A

ST Other

2

EQ

Security Type

A

ST Other

2

MF

Security Type

A

ST Other

2

CASH

Security Type

A

Country Domestic A

3

US

Issue Country

A

Country Foreign A

4

CA

Issue Country

A

Country Foreign A

4

IT

Issue Country

A

Country Foreign A

4

ME

Issue Country

A

Sector Corp

5

CORP

Market Sector Desc

A

Sector Govt

6

GOVT

Market Sector Desc

B

ST 1

7

FI

Security Type

B

ST 1

7

CMBS

Security Type

B

ST 2

8

EQ

Security Type

B

ST 2

8

CASH

Security Type

B

Country Domestic B

9

US

Issue Country

B

Country Foreign B

10

IT

Issue Country

About Custom Accounts and Custom Granularity

STAR's core accounts are used for posting purposes because STAR's Post Matrix references the core chart of accounts. Reports generated then display the custom accounts. Custom granularity is based on the custom chart of account that you map to STAR's core accounts, and you use the Custom Chart of Accounts for reporting purposes. With the addition of ledger granularity, the system's custom capabilities expanded from one custom account for every core account to granularity based on security grouping and processing security type (PST).

With custom granularity, you can break out ledger reports using custom accounts based on security groupings and/or security master attributes included in PST rules. You create ledger granularity rules with custom granularity rule details to provide the mappings from the core account to the custom account for securities that meet specific criteria, and assign the ledger granularity rules to entity/accounting basis groupings that use those mappings in ledger reports. You can set up ledger granularity rules to map any STAR ledger account, including the Short Term and Cash Equivalent accounts used for holding term granularity, to a custom account for that security group or PST rule.

Custom granularity rules offer great flexibility and allow for many different options in customizing ledger accounts. The following example demonstrates one way you might want the system to map core accounts to custom accounts based on custom granularity criteria. 

Core Account


PST


L/S


Fed Tax


Custom Account



Account Number

Account Name








Account Number

Account Name

1010000100

Cost of Investments


DBIBFD


L


Y


1010000111

Cost of Investments - Long Taxable

1010000100

Cost of Investments


DBIBFD


L


N


1010000122

Cost of Investments - Long Non Taxable

1010000100

Cost of Investments


DBIBFD


S


Y


1010000133

Cost of Investments - Short Taxable

1010000100

Cost of Investments


DBIBFD


S


N


1010000144

Cost of Investments - Short Non Taxable

In this example, you want the core account for Cost of Investments mapped to different custom accounts based on the value of the holding's processing security type, long/short indicator, and Federal tax indicator. Alternately, you can set up custom granularity rules that map custom accounts based on a security grouping comprised of individual securities.

How Eagle Applies Custom Granularity Rules in Investment Accounting

When Eagle processes a transaction, it recognizes the ledger granularity rule in effect for that transaction's entity/accounting basis and security. The system retrieves the correct custom granularity rule for the asset, which is based on either a security grouping rule or a PST rule, and posts that information for report rendering. This allows ledger reports and report queries to break core ledger accounts into more granular custom accounts.

The system applies the criteria specified in custom granularity rules in order of most granular to least granular criteria, as follows:

  1. Security Groupings. Highest level of granularity. A security grouping is a set of securities that break out custom ledger accounts in the same manner following user-defined core to custom ledger mappings. You can create security groupings for assets that do not share SMF features but break out accounts in the same way.
  2. Processing Security Type. Second highest level of granularity. A processing security type (PST) rule allows you to break out accounts with custom account mappings by a security's processing security type or by a security's processing security type plus up to two additional security attributes.
  3. Security Attributes. Lowest level of granularity. You can identify up to two security attributes within a PST rule. These attributes can include the security's Security Type, Long/Short Indicator, Federal Tax Indicator, Market Sector Description, Affiliated/Unaffiliated, Issue Country, and Granularity Category.
  • No labels

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.