Transactions

Objectives

After completing this lesson, you will be able to:

  • Understand the purpose of Global Transaction Defaults
  • Import transactions
  • Post and Test a Transaction

Transactions

Transactions are the heart of commissions. The transaction flow will vary by industry, but will typically take the form of a monthly transaction per customer (exception being the Retail industry). These monthly transactions represent the paid premiums associated with the customers’ policies or coverage. While the way transactions are managed will vary depending on the needs of the business, the most commonly defined activity is a monthly paid premium for each active customer that may include premiums, eligible counts, claims expense or other data that is eligible for commission.

Before we go into the process flow for importing and posting transactions, let’s review the key transaction tables. For more detail, see Lesson 1 of the Appendix to the course.

Key Transaction Tables

TranHead

The master transaction record is stored in the TranHead (short for Transaction Header) table, so named because it contains the header information for the transaction. This includes an auto-generated primary key called TranHeadNo and a pointer to the customer record called CustomerNo.

TranHis

The TranHis (Transaction History) table holds the billing information for the vendor. It is used as the source information to calculate the commission amount. Key fields in this table include the Transaction History Number (TranHisNo), Transaction Head Number (TranHeadNo), Broker Number (BrokerNo), and Vendor Number (VendorNo).

BrokerHistory

The BrokerHistory table contains the summary of all broker balances, including earned and paid commissions by billing period. This is important for keeping track of outstanding balances, so they can be properly applied to current payouts.

Importing and Posting Transactions

As we saw in the unit on data integration, TranHead records are imported via an import table called InTranHead. However, the transaction posting process does much more. It is during the posting process that the calculation takes place.

During the Transaction posting process, InTranHead records are converted to TranHead records and a broker specific TranHis record is created for every broker found during the Broker Detail lookup process. TranHis records are also updated with additional information derived or computed as part of the payout process.

After computation is complete, a BrokerHistory record is created for every TranHis record that was computed for the first time or recomputed and an adjustment was created from the Computation task in Payout. Additional BrokerHistory records can be created without a TranHis or TranHead through Bonus Calculations or Manual Adjustments being created as part of the payout.

BrokerHistory records are the final payment records created by the payout process, and are locked once the payout has been finalized.

Global Transaction Defaults

When a transaction enters the APM system, it contains minimal detail. Before it can be posted, we need a process to populate the transaction with necessary data from the policy, customer and broker records. This is done using a Global Transaction Default.

Typically, a transaction would include the following information:

  • CustomerID
  • PremiumDueDate
  • Financial Entity
  • Transaction Type (INCOME, COUNTS, etc.)
  • Product
  • PremiumReceived/Member Counts

However, this isn’t enough detail to calculate the commission. We need to ensure that the correct producer is paid, that they are paid the right amount, and the ERP extract is distributing the payment across the correct Lines of Business. Therefore, at a minimum, the system also needs the following information:

  • Broker Number
  • Broker Detail Number
  • Vendor Number
  • Broker/Vendor relationship
  • Schedule
  • Schedule Grid
  • Formula

Global Transaction Defaults allow us to populate data on the transaction that’s needed for calculating commissions, reporting, AP extracts and other output. Data can be populated directly, or it can be derived or modified though the use of expressions.

Let’s look at an example.

A transaction comes in for a policy sold to Page Mortgage Group with the following information:

  • Customer ID: AF2005 – Page Mortgage Group
  • Premium Due Date: January 20, 2022
  • Transaction Type: Income
  • Product: Group Term Life Insurance
  • Amount: US$2500

This isn’t enough to calculate the commission. For example, we don’t know who the writing agent or agency is, the location, policy age, and other information that tells us what the commission rate will be. The Global Transaction Default tells the system how to pull this information and add it to the transaction

Exercise: Update the Global Transaction Default record

In this exercise, we will use the Global Transaction Default to populate the transaction with the information we will need to compensate the payees. This includes the State field, which we will retrieve from the Customer Policy.

Steps

  1. Update the Global Transaction Default to only apply to transactions with a Transaction Type of Income Transaction.

    1. From the Administrator portal, select Commission Settings – Global Transaction Defaults.

    2. Open the first record in the list, with tab sequence 10.

    3. Under Entity Rules, select (+).

    4. Set the recType to Match Rules.

    5. Select Save.

    6. Select Add Rule.

    7. Set the Field Name to TransType.

    8. Leave the Comparator at Equals.

    9. Set the Field Value to Income Transaction.

      • Select Save, then Close.
      • On the Entity Rules Detail box, select Save, then Close.
  2. Add a step to populate the state from the customer policy record to the transaction.

    1. Scroll to the After CustPolicy section.

    2. Select (+).

    3. Enter the following information in the TranDefault Detil screen:

      • Field Name: State
      • Expression: GTD-StatCd-AfterCustPolicy
      • ActionCd: Override
      • Process Order: Leave at default
    4. Select Save.

    5. Select Close.

      • Save the Global Transaction Default record.
      • Select Activate.

Posting Transactions

Now that we have configured the Global Transaction Default, we can import and post our transactions. As we saw earlier, posting transactions uses the Global Transaction Default settings to populate the Transation Detail with data from other tables; then, the commission is calculated from a Schedule.

Once the Post process is complete, the transactions will be visible in the Manager portal under Inquiry – Transaction Search.

Exercise: Import and Post a set of Transactions

In this exercise, we will import and post a set of transactions from a spreadsheet using the same process we used in Unit 5. An Import Format called TransactionImport has already been created.

Steps

  1. Create the Transactions import file.

    1. From the Integration portal, select Inbound Data - File Search.

    2. Select Add (+)

    3. Enter the following for the Transaction Import file:

      • File ID: TrainingTransactions
      • Name: Traning Transactions
      • Payout Type ID: CLIENT Payout
      • Process Year: 2022
      • Process Month: 1
    4. Select Save.

    5. Select Add Import Request.

    6. Set the import format to TransactionImport.

    7. Leave the upload type set to Client.

    8. Select Choose File.

    9. Select Transactions.xls, then select Open.

    10. Select Next.

    11. Select Complete.

  2. Post the Transactions

    1. Select Ready.

    2. Select Post.

    3. In the Statistics area, verify the Posted column is populated with the number of transactions.

  3. View the imported and posted transactions.

    1. From the Manager portal, select Inquiry - Transaction Search.

    2. Select Search to display all transactions.

    3. Open any transaction and view the details.

Log in to track your progress & complete quizzes