Maintaining Transaction Account Rules

Transaction account rules affect how trades and assets are handled during systematic resolution. These rules can: use complex criteriaIn a query, a criterion is a single point of comparison. For instance, one criterion in a query might be reps in the state of Michigan. Query and search criteria are based on properties in the primary SalesConnect objects associated with the type of connection or other record which the query or search finds. to flag items as No Sales, Pass-Through, or Exclude; apply transaction account labelsA label is like a tag, a convenient way for you to mark records so that you can easily find and work with them later. Most labels are tagged to key connections. For instance, you could create a label called "Top Reps," and then assign this label to the top-producing reps with which you work. Since you can search for connections with a particular label assigned to them, you can easily retrieve the list of reps who have been assigned this label. However, you can also define transaction account labels that may be systematically applied to the transactions and assets imported to SalesConnect, so that it's easy to find and work with those transactions and assets later. to items; change items' transaction code and suffix; and change the firmA broker/dealer firm (or broker dealer or broker-dealer) is a connection associated with intermediary business, typically a top-level organization in this hierarchy. Broker/dealer firms are also sometimes referred to as just "firms" or "brokers" or "dealers" or "financial institutions." Each broker/dealer firm may have one or more offices affiliated with it, and through these offices, reps may also be affiliated with it. A broker/dealer firm may have associated firm contacts, as well. Possibly the most critical information you can track for broker/dealer firms are aliases, also known as trading IDs. Aliases are the IDs that associate transactions with each broker/dealer firm. If you need to write queries or reports: The primary data for broker/dealer firms is stored in the Firm table. The Firm Alias table stores trading IDs associated with broker/dealer firms./officeAn office is a connection in the intermediary business hierarchy, an organization subordinate to a broker/dealer firm. Offices are also sometimes referred to as "branches'; institutional firms have branches in SalesConnect. An office is affiliated with a single broker/dealer firm, and may have one or more reps directly affiliated with it. An office may have associated office contacts, as well. Possibly the most critical information you can track for offices are aliases, also known as trading IDs. Aliases are the IDs that associate transactions with each office. If you need to write queries or reports: The primary data for offices is stored in the Office table. Information about office trading IDs is stored in the Office Alias table./repA rep is perhaps the most important contact connection in the intermediary business hierarchy. Each rep is an individual who sells funds and is affiliated with an office (and through the office, with a broker/dealer firm). Reps may also be referred to as "financial advisors." Possibly the most critical information you can track for reps are aliases, also known as trading IDs. Aliases are the IDs that associate transactions and assets with each rep. If you need to write queries or reports: The primary data for reps is stored in the Contact and Rep Profile tables. The Rep Alias table stores trading IDs associated with reps. aliases assigned to items. See Transaction Account Rules for more about these rules and their roleRoles are linked to security and personas in SalesConnect. Each role represents a group of operators who perform similar tasks and who need access to similar features. Each operator is assigned to at least one specific role. Roles may be included in security rules and in territory category definitions, too. in trade and asset handling for SalesConnect. See these topics:

• Tips for Building a Transaction Account Rule Set
• Adding a Transaction Account Rule
• Changing Transaction Account Rules
• Deleting a Transaction Account Rule

Tips for Building a Transaction Account Rule Set

As you define transaction account rules, keep in mind these tips about how these rules are evaluated at processing time:

• For rules with Rule Type set to Standard, all criteria specified in the Definition section are joined with the logical operator AND; that is, the only records selected will be those that meet ALL of the specified criteria.

• All transaction account rules are either Inclusion or Exclusion rules (as set in Inclusion or Exclusion). If possible, define broad Inclusion rules that are sequenced to run first; Exclusion rules are designed to allow you to remove subsets of records selected by an Inclusion rule, so that they are not acted upon as the Inclusion rule indicates. For instance, you might define an Inclusion rule that selects all incoming trades with the firm/office trading IDA trading ID is a number associated with transactions that identifies the responsible firm, office or rep. A trading ID is always associated with a specific transfer agency. Trading IDs are also known as aliases. set "15/033" and with trade class "Sale" to change the trade class to "Sale Cancel". If however, you also wanted to ensure that incoming trades with the firm/office trading ID set "15/033" and with trade class "Sale" AND with rep trading IDs between "042" and "182" are not changed to "Sale Cancel", you could use an Exclusionrule to achieve this. An Exclusion rule must:

  • Select records previously selected for a specific action or set of actions by an Inclusion rule
  • Contain the same action as the Inclusion rule in its definition—in effect you are indicating that this subset should be excluded from this specific action that would otherwise be performed.
• Rules are evaluated at processing time in descending order by Sequence Number order. That means that any Exclusion rule should be set to a lower Sequence Number than the Inclusion rule that it qualifies.

Adding a Transaction Account Rule

1. Using the Data Operations personaA persona is an interface set of menus and dashboard or home view that was designed for a single set of operators who share goals, skills, attitude and behavior patterns. Each persona's interface displays only the content and tools that are relevant for that group., select Rule Definitions from the Resolution menu. Or, select in the universal menu, and then select Rule Definitions under Feeds.

2. Check to see if an appropriate rule already exists. You can use the displayed Transaction Account Rule Definition Search page to filter the listed entries as needed, using either a new or saved search.

   Use a saved search

   1. Select Load Search, and then select an option to list saved searches in a popup:

      • Private to choose from searches saved for your use only.
      • Public to choose from searches saved for everyone.
      • Shared to choose from searches available to specific groups.
   2. Select for the search you want. Criteria from the search are loaded. You can change them if necessary. If you do and you want to save the search:

   1. Select Save Search, then use the Save Search dialog to name it and select a security type for it:

      • Private if for your use only.
      • Public if for all operators. (You may not have this option.)
      • Shared if for just a specific group, and then pick a security ruleSecurity rules are used to control access to specific tools, controls, pages and other features in SalesConnect. Each security rule includes roles and/or operators who will have access to the items secured by that rule. or define a new one including the needed roles or operators.
   2. Select Save on the Save Search dialog. The search is now available using the Load Search option.

   3. When ready, select Search on the Search page. Search results are displayed.

      • You can select Criteria Applied to show the search (blue) and sort criteria (green). You can select X for any criterionIn a query, a criterion is a single point of comparison. For instance, one criterion in a query might be reps in the state of Michigan. Query and search criteria are based on properties in the primary SalesConnect objects associated with the type of connection or other record which the query or search finds. to remove it.
      • You can select Back to Criteria to add to or change the search criteria.
      • You may be able to use tools to print or export the displayed results or to perform other tasks. See Table Tips for more information.
      • You can select a link to display the appropriate detail page.
   Create a new search

   1. If criteria from an earlier search are displayed and you no longer want to use them, you can select Clear All, or select Criteria Applied, and then X for individual items to clear them.

   2. Type or select criteria to include in the search.

      Tips

      • Range fields provide a set of From and To fields, so that you can search using a range of values. The first (From) value must be lower than the second (To) value.
      • For some fields, you can select to display a popup you can use to select a date and/or time.
      • You don't need to include dollar signs or separators like commas when entering dollar amounts.

   3. If you want to save the search:

      1. Select Save Search, then use the Save Search dialog to name it and select a security type for it:

         • Private if for your use only.
         • Public if for all operators. (You may not have this option.)
         • Shared if for just a specific group, and then pick a security rule or define a new one including the needed roles or operators.
      2. Select Save on the Save Search dialog. The search is now available using the Load Search option.

   4. When ready, select Search on the Search page. Search results are displayed.

      • You can select Criteria Applied to show the search (blue) and sort criteria (green). You can select X for any criterion to remove it.
      • You can select Back to Criteria to add to or change the search criteria.
      • You may be able to use tools to print or export the displayed results or to perform other tasks. See Table Tips for more information.
      • You can select a link to display the appropriate detail page.
3. When ready to add a rule, select Add Transaction Account Rule Definition.

4. On the displayed Add Transaction Account Rule Definition page, complete details for this rule.

   1. In the Description field, type brief text describing the purpose of the rule.
   2. In the Inclusion or Exclusion field in the Definition section, select Inclusion or Exclusion. Inclusion rules generally act on all records meeting the criteria you will define. If you need to exclude some records from an action defined in an Inclusion rule that runs first, define an Exclusion rule that uses an Action that exactly matches the one for that Inclusion rule; an Exclusion rule cancels the effect of an earlier Inclusion rule on a subset of records.
   3. Select Transaction, Account, or both in the Definition section, to set whether the rule applies to transactions, accounts, or both.

   4. In the Action section, select the action to apply to records affected by the rule:

      1. In the Action Type field, select the type of action you want. If you choose Label, you can apply a transaction account label to selected records, but you must first have defined the label you want to use. See Define a label in the Transaction Account Label list (part of Maintaining Resolution Lists) for instructions.
      2. Complete the additional fields that are displayed once you have picked an action type.

   5. Create a standard or complex rule: Standard rules use simple criteria from the Definition Types list, while Complex rules use criteria defined with a queryA query is a special type of saved search for connections or other data in SalesConnect, created with a SalesConnect query tool rather than a standard search page. When you create a query, you select query criteria based on familiar field names from the interface; the criteria you specify are transformed behind the scenes into the appropriate SQL statements. tool. Some users may only create standard rules.

      To create a standard rule:

      1. In the Rule Type field, select Standard.

      2. In the Definition Types field, select the items you want to include in criteria for this rule. As you select items, new fields are added to the Definition section of the page.

      3. Complete the fields now shown in the Definition section to set values for the criteria you selected.

      To create a complex rule:

      1. In the Rule Type field, select Complex. The Definition Types field is hidden, as it isn't used for complex rules. Buttons for editing transaction and/or account queries may appear, depending on whether Transaction, Account, or both are selected.

      2. Define necessary queries. If the rule applies to transactions, you must define a transaction query. If it applies to accounts, you must define an account query. If it applies to both transactions and accounts, you must define a query of each type.

         1. Select Edit Transaction Query or Edit Account Query as appropriate. A query popup is displayed.

         2. Define criteria for the query. You can add criteria based on objectIn object-oriented programming, an object is a software bundle of related attributes (properties) and behavior (methods). Software objects are often used to model the real-world objects that you find in everyday life. Often, you can think of an object as roughly equivalent to a table in a database, though the object has additional logic attached to it. For example, one type of "object" in the real world and in a SalesConnect application is a person, known in SalesConnect as a contact or connection. Each contact has many properties, such as a name and birth date; in SalesConnect, these are properties of the object Contact. In the real world, each contact also has many behaviors; in software such as SalesConnect, you are typically interested only in recording or managing certain types of behavior for Contact instances. Objects in SalesConnect are logically named entities mapped to Java classes: objects are the instantiations of classes. So, the class for the Contact object includes methods for setting and retrieving key properties for Contact entities, such as the contact's name. An object may call its own methods, or it may call another object's methods that are visible to it. In SalesConnect, the properties for objects defined for an application project are most typically mapped to specific database table columns./propertyIn SalesConnect, a property is an attribute for one aspect of the state of an object. For instance, the contact object has properties that include a first name (firstName) and last name (lastName). (You can think of a property as roughly equivalent to a column.) combinations or on object subqueriesA subquery is really a separate query that is nested inside the WHERE clause of a primary query. Subqueries can allow you to refine a query in several different ways. They can: (1) Allow you to expand a query to include criteria based on properties from additional objects that contain related data. For instance, when you create a Rep query, you can include a subquery that includes criteria based on properties in the Transaction History object. Transactions in the Transaction History object are generally associated with specific reps, so criteria based on the Transaction History object allow you to expand your search for Reps to related data. (2) Limit the results returned by a query based on criteria for a parent object. For instance, when you create a Rep query, you can include a subquery that includes criteria based on properties in the Firm or Office objects. All Reps are associated with Firms and Offices, so subqueries that limit the Firms or Offices with which the Reps returned by a query may be associated, you are limiting the results based on criteria for a parent object. (3) Search within a pre-selected subgroup of the active entity type. For instance, when you create a Rep query, if you know that you only want to find Reps for whom an email address is stored in SalesConnect, but you want to add other criteria to the query as well, it may be most efficient to include a subquery that pre-selects only those Reps with email addresses in SalesConnect and then add other query criteria to select within that group..

            1. Select Add Criteria in the Filter Criteria Editor. anew item containing a set of controls appears in the Criteria Editor.
            2. In the first field, select either a listed business object/property or a subquery item.
            3. Complete the remaining fields in the item in the Filter Criteria Editor to define this criterion.
            4. Repeat the steps above until you have added all needed criteria to your query.
         3. When you have finished with the query, select Ok on the popup.
   6. When you have finished creating the rule, select Save. Each time that the entire ruleset changes (new rules are added, existing ones are changed or deleted), the entire ruleset must be compiled. You'll be alerted what that process completes.

History is maintained for changes to transaction account rule definitions; see Reviewing Maintenance History for details for accessing it.

Deleting a Transaction Account Rule

1. Using the Data Operations persona, select Rule Definitions from the Resolution menu. Or, select in the universal menu, and then select Rule Definitions under Feeds.

2. Search for the rule or rules you want to delete, using the displayed Transaction Account Rule Definition Search page and either a new or saved search.

   Use a saved search

   1. Select Load Search, and then select an option to list saved searches in a popup:

      • Private to choose from searches saved for your use only.
      • Public to choose from searches saved for everyone.
      • Shared to choose from searches available to specific groups.
   2. Select for the search you want. Criteria from the search are loaded. You can change them if necessary. If you do and you want to save the search:

   1. Select Save Search, then use the Save Search dialog to name it and select a security type for it:

      • Private if for your use only.
      • Public if for all operators. (You may not have this option.)
      • Shared if for just a specific group, and then pick a security rule or define a new one including the needed roles or operators.
   2. Select Save on the Save Search dialog. The search is now available using the Load Search option.

   3. When ready, select Search on the Search page. Search results are displayed.

      • You can select Criteria Applied to show the search (blue) and sort criteria (green). You can select X for any criterion to remove it.
      • You can select Back to Criteria to add to or change the search criteria.
      • You may be able to use tools to print or export the displayed results or to perform other tasks. See Table Tips for more information.
      • You can select a link to display the appropriate detail page.
   Create a new search

   1. If criteria from an earlier search are displayed and you no longer want to use them, you can select Clear All, or select Criteria Applied, and then X for individual items to clear them.

   2. Type or select criteria to include in the search.

      Tips

      • Range fields provide a set of From and To fields, so that you can search using a range of values. The first (From) value must be lower than the second (To) value.
      • For some fields, you can select to display a popup you can use to select a date and/or time.
      • You don't need to include dollar signs or separators like commas when entering dollar amounts.

   3. If you want to save the search:

      1. Select Save Search, then use the Save Search dialog to name it and select a security type for it:

         • Private if for your use only.
         • Public if for all operators. (You may not have this option.)
         • Shared if for just a specific group, and then pick a security rule or define a new one including the needed roles or operators.
      2. Select Save on the Save Search dialog. The search is now available using the Load Search option.

   4. When ready, select Search on the Search page. Search results are displayed.

      • You can select Criteria Applied to show the search (blue) and sort criteria (green). You can select X for any criterion to remove it.
      • You can select Back to Criteria to add to or change the search criteria.
      • You may be able to use tools to print or export the displayed results or to perform other tasks. See Table Tips for more information.
      • You can select a link to display the appropriate detail page.
3. In the search results table, use the checkboxes to select the rule or rules you want to delete, and then select Delete. You may be asked to confirm this. Each time that the entire ruleset changes (new rules are added, existing ones are changed or deleted), the entire ruleset must be compiled. You'll be alerted what that process completes.

History is maintained for changes to transaction account rule definitions; see Reviewing Maintenance History for details for accessing it.