Siebel Loyalty Administration Guide > Setting Up Siebel Loyalty Programs >

Example of Setting Up Retroactive Tier Changes


Setting up a retroactive tier program requires adding additional program level attributes, defining additional tier rules, and adding an additional Admin - Retro Accrual promotion. These configurations determine whether or not retroactive changes are applied to transactions.

Creating Retroactive Tier Member Attributes

The tier class qualifying period member attributes are used to specify the current and previous qualifying period of a member for a particular tier class. These attributes determine whether or not retroactive tier logic must apply to a transaction.

Every tier class that is eligible for retroactive tier changes needs the following three member attributes defined:

  • TC1 Previous QP Start. For tier class 1, this attribute is the start date of the previous qualifying period.
  • TC1 Current QP Start. For tier class 1, this attribute is the start date of the current qualifying period.
  • TC1 Current QP End. For tier class 1, this attribute is the end date of the current qualifying period.

To create retroactive tier member attributes

  1. Navigate to the Loyalty Program Administration screen.
  2. Locate the program that the attribute applies to and click its Program Id hyperlink.
  3. Clear the program form's Active check box.
  4. Click the Program Level Attributes view tab.
  5. In the link bar of the Program Level Attributes view, click Member Attributes.
  6. Add the first record to the Program Level Attributes list, and complete the necessary fields. Some fields are described in the following table.
    Field
    Value

    Name

    TC1 Previous QP Start

    Data Type

    Date

    Display to User

    No

  7. Add the second record to the Program Level Attributes list, and complete the necessary fields. Some fields are described in the following table.
    Field
    Value

    Name

    TC1 Current QP Start

    Data Type

    Date

    Display to User

    No

  8. Add the third record to the Program Level Attributes list, and complete the necessary fields. Some fields are described in the following table.
    Field
    Value

    Name

    TC1 Current QP End

    Data Type

    Date

    Display to User

    No

  9. Repeat the steps in this procedure to add these attributes to each tier class and select the Active check box to activate the attributes.
  10. When you are finished creating all attributes for the program, select the program form's Active check box to activate the program.

Creating Retroactive Tier Member Tier Attributes

These attributes are used to distinguish a retroactive tier change from a regular tier change.

To create retroactive tier member tier attributes

  1. Navigate to the Loyalty Program Administration screen.
  2. Locate the program that the attribute applies to and click its Program Id hyperlink.
  3. Clear the program form's Active check box.
  4. Click the Program Level Attributes view tab.
  5. In the link bar of the Program Level Attributes view, click Member Tier Attributes.
  6. Add a record to the Program Level Attributes list, and complete the necessary fields. Some fields are described in the following table.
    Field
    Value

    Name

    Tier Approval Status

    Field

    Tier Approval Status

    Read Only

    Y

    Data Type

    String

    Pick List

    LOY Member Tier Approval Status Picklist

  7. Add another record to the Program Level Attributes list, and complete the necessary fields. Some fields are described in the following table.
    Field
    Value

    Name

    Transaction Sub Type LIC

    Field

    Transaction Sub Type LIC

    Read Only

    Y

    Data Type

    String

  8. When you are finished creating all attributes for the program, select the Active check box to activate the attributes and then select the program form's Active check box to activate the program.

Creating Retroactive Tier Transaction Attributes

These attributes are used to identify the date of the transaction, the current date in Siebel Loyalty, the age of the transaction and determines whether or not any retroactive tier action must be taken.

To create retroactive tier transaction attributes

  1. Navigate to the Loyalty Program Administration screen.
  2. Locate the program that the attribute applies to and click its Program Id hyperlink.
  3. Clear the program form's Active check box.
  4. Click the Program Level Attributes view tab.
  5. In the link bar of the Program Level Attributes view, click Transaction Attributes.
  6. Add a record to the Program Level Attributes list, and complete the necessary fields. Some fields are described in the following table.
    Field
    Value

    Name

    Transaction Age

    Field

    Transaction Age

    Read Only

    Select the Read Only check box

    Data Type

    Number

  7. Add another record to the Program Level Attributes list, and complete the necessary fields. Some fields are described in the following table.
    Field
    Value

    Name

    Is Qualifying

    Field

    Qualifying Flag

    Read Only

    Select the Read Only check box

    Data Type

    String

  8. Add another record to the Program Level Attributes list, and complete the necessary fields. Some fields are described in the following table.
    Field
    Value

    Name

    Current Date

    Field

    Current Date

    Read Only

    Select the Read Only check box

    Data Type

    Date

  9. Add another record to the Program Level Attributes list, and complete the necessary fields. Some fields are described in the following table.
    Field
    Value

    Name

    Transaction Date

    Field

    Transaction Date

    Read Only

    Y

    Data Type

    Date

  10. When you are finished creating all attributes for the program, select the Active check box to activate the attributes and then select the program form's Active check box to activate the program.

Setting Up Retroactive Tier Rules

The retroactive tier logic requires additional rules to evaluate member records and determine if a tier change is necessary.

For the given example for the Base Tier, the following would be the new sequence of rules (assuming only points as the criterion for Tier qualification):

  1. Manual Tier Approval
  2. Retro Tier Automatic Activation
  3. 250,000 Points, Upgrade Platinum Retro
  4. 250,000 Points & Not Expired - Upgrade to Platinum
  5. 120,000 Points, Upgrade Gold Retro
  6. 120,000 Points & Not Expired - Upgrade to Gold
  7. 60,000 Points, Upgrade Silver Retro
  8. 60,000 Points & Not Expired - Upgrade to Silver
  9. Expired Cancellation Retro
  10. Base Expired, Qualify Base
  11. Manual Upgrade to Silver
  12. Manual Upgrade to Gold
  13. Manual Upgrade to Platinum
  14. Manual Qualify Base

The additional rules having sequence numbers 1, 2, 3, 9 and the modified rule with sequence number 10 are explained in the procedure below.

To set up retroactive tier rules

  1. Navigate to the Loyalty Program Administration screen.
  2. In the Loyalty Programs list, select the program that the tiers are used by and click its Program Id hyperlink.
  3. Click the Tier Classes view tab.
  4. Select the tier class to be modified.
  5. In the Tiers view, click the Tier Id hyperlink.
  6. Click Modify.
  7. Create a new rule for this Tier:
    1. In the Rules list, add a new record and enter the values in the following table.
      Field
      Value

      Sequence

      1

      Name

      Manual Tier Approval

      Apply To

      Tiers

    2. Click the Rule Name.
    3. To create the first criterion, add a new record in the Criteria list, and complete the necessary fields in the Criteria list and the Compare to Values Details, and Values forms, as shown in the following table.
      Field
      Value

      Sequence

      1

      Name

      Check Tier Approval

      Type of Comparison

      Compare to Values

      Object

      Member Tier

      Attribute

      Tier Approval Status

      Condition

      Equals

      Value

      Pending

      Value

      Pending RT Decision

    4. Click the Actions view tab and add a new record in the Actions list, and complete the necessary fields in the Actions list and form, as shown in the following table.
      Field
      Value

      Sequence

      1

      Name

      Qualify Tier

      Type

      Qualify Tier

    5. Add a new record in the Actions list, and complete the necessary fields in the Actions list and form, as shown in the following table.
      Field
      Value

      Sequence

      2

      Name

      CreateQualPeriodAttributes

      Type

      Invoke Custom Action

      Method

      CreateQualPeriodAttrib

  8. Create the second rule for this Tier.
    1. In the Rules list, add a new record and enter the values in the following table.
      Field
      Value

      Sequence

      2

      Name

      Retro Tier Automatic Activation

      Apply to

      Tiers

    2. Click the Rule Name.
    3. To create the first criterion, add a new record in the Criteria list, and complete the necessary fields in the Criteria list and the Compare to Values Details, and Values forms, as shown in the following table.
      Field
      Value

      Sequence

      1

      Name

      Check Tier Approval

      Type of Comparison

      Compare to Value

      Object

      Member Tier

      Attribute

      Tier Approval Status

      Condition

      Equals

      Value

      RTCINT - To Be Activated

    4. Click the Actions view tab and add a new record in the Actions list, and complete the necessary fields in the Actions list and form, as shown in the following table.
      Field
      Value

      Sequence

      1

      Name

      Qualify Tier

      Type

      Qualify Tier

  9. Create the third rule for this Tier.
    1. In the Rules list, add a new record and enter the values in the following table.

      NOTE:  The values used in this procedure are for illustration purposes only. Your values might vary depending on your configuration.

      Field
      Value

      Sequence

      3

      Name

      250,000 points - Upgrade Platinum Retro

      Apply to

      Tiers

    2. Click the Rule Name.
    3. To create the first criterion, add a new record in the Criteria list, and complete the necessary fields in the Criteria list and the Compare to Values Details, and Values forms, as shown in the following table.
      Field
      Value

      Sequence

      1

      Name

      Greater Than or Equal To 250,000 Regular Points

      Type of Comparison

      Compare to Values

      Object

      Member Tier

      Attribute

      Regular Points

      Condition

      Is Greater Than or Equal To

      Value

      250000

    4. To create the second criterion, add a new record in the Criteria list, and complete the necessary fields in the Criteria list and the Compare to Values Details, and Values forms, as shown in the following table.
      Field
      Value

      Sequence

      2

      Name

      Check Tier Approval Status

      Type of Comparison

      Compare to Values

      Object

      Member Tier

      Attribute

      Tier Approval Status

      Condition

      Equals

      Value

      Pending - RTC

      Value

      RTCINT - Automatic

    5. Click the Actions view tab and add a new record in the Actions list, and complete the necessary fields in the Actions list and form, as shown in the following table.
      Field
      Value

      Sequence

      1

      Name

      Upgrade to Platinum

      Type

      Upgrade Tier

      New Tier

      Platinum

  10. Create the fourth rule for this tier.
    1. In the Rules list, add a new record and enter the values in the following table.
      Field
      Value

      Sequence

      9

      Name

      Expired - Cancellation Retro

      Apply to

      Tiers

    2. Click the Rule Name.
    3. To create the first criterion, add a new record in the Criteria list, and complete the necessary fields in the Criteria list and the Compare to Values Details, and Values forms, as shown in the following table.
      Field
      Value

      Sequence

      1

      Name

      Is Expired

      Type of Comparison

      Compare to Values

      Object

      Member Tier

      Attribute

      Is Expired

      Condition

      Equals

      Value

      Y

    4. To create the second criterion, add a new record in the Criteria list, and complete the necessary fields in the Criteria list and the Compare to Values Details, and Values forms, as shown in the following table.
      Field
      Value

      Sequence

      2

      Name

      Check Transaction Sub Type LIC

      Type of Comparison

      Compare to Values

      Object

      Member Tier

      Attribute

      Transaction Sub Type LIC

      Condition

      Equals

      Value

      Cancellation

    5. To create the third criterion, add a new record in the Criteria list, and complete the necessary fields in the Criteria list and the Compare to Values Details, and Values forms, as shown in the following table.
      Field
      Value

      Sequence

      3

      Name

      Check Tier Approval

      Type of Comparison

      Compare to Values

      Object

      Member Tier

      Attribute

      Tier Approval Status

      Condition

      Equals

      Value

      Pending - RTC

      Value

      RTCINT - Automatic

    6. Click the Actions view tab and add a new record in the Actions list, and complete the necessary fields in the Actions list and form, as shown in the following table.
      Field
      Value

      Sequence

      1

      Name

      Qualify (Tier Name)

      Type

      Qualify Tier

  11. Create the fifth rule for this tier.
    1. In the Rules list, add a new record and enter the values in the following table.
      Field
      Value

      Sequence

      10

      Name

      Tier Expired, Qualify (Tier Name)

      Apply to

      Tiers

    2. Click the Rule Name.
    3. To create the first criterion, add a new record in the Criteria list, and complete the necessary fields in the Criteria list and the Compare to Values Details, and Values forms, as shown in the following table.
      Field
      Value

      Sequence

      1

      Name

      Is Expired

      Type of Comparison

      Compare to Values

      Object

      Member Tier

      Attribute

      Is Expired

      Condition

      Equals

      Value

      Y

    4. To create the second criterion, add a new record in the Criteria list, and complete the necessary fields in the Criteria list and the Compare to Values Details, and Values forms, as shown in the following table.
      Field
      Value

      Sequence

      2

      Name

      Check Tier Approval Status

      Type of Comparison

      Compare to Values

      Object

      Member Tier

      Attribute

      Tier Approval Status

      Condition

      Equals

      Value

      Automatic

      Value

      Manual - Approved

      Value

      RTC - Manual - Approved

    5. Click the Actions view tab and add a new record in the Actions list, and complete the necessary fields in the Actions list and form, as shown in the following table.
      Field
      Value

      Sequence

      1

      Name

      Qualify (Tier Name)

      Type

      Qualify Tier

  12. If your loyalty program has different sets of tiers for different customers, then repeat the steps in this procedure until you have modified all of the sets of tiers in the program.

Creating the Admin - Retro Accruals Base Promotion

When you define a Retroactive Tier program, you must create the Admin - Retro Accruals base promotion to determine the type of retroactive tier logic that is used.

NOTE:  The rules for the Admin- Retro Accruals promotion are for illustration purposes only. Actual implementation requirements can vary. If you decide you do no want to use retroactive tier logic, then you can deactivate this base promotion.

To create the Admin - Retro Accruals base promotion

  1. Navigate to the Loyalty Promotions Administration screen.
  2. Add a new record to the Promotions list, and enter the values that are provided in the following table.
    Field
    Value

    Name

    Admin - Retro Accruals

    Always Apply

    Y

    Apply To

    Accrual-Product

    Program

    Enter the name of the program.

    Partner

    Enter the partners for the program.

    Product Inclusion

    All Products

    Promotion Start

    Enter one day before today's date.

    Promotion End

    Leave this field blank, because you do not want the base promotion to expire.

  3. Click the Promotion Number (#) field's hyperlink.
  4. Click the Rules view tab.
  5. Create the first rule for this promotion:
    1. Add a new record to the Rules list, and enter the values in the following table.
      Field
      Value

      Sequence

      1

      Name

      Retro Txns 1 month ago A

      Apply To

      Transactions

    2. Click the Name field's hyperlink.
    3. Add a new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      1

      Name

      Check Txn Points

      Type of Comparison

      Compare to Values

    4. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Transaction Points

      Condition

      Is Greater Than

    5. Add a new record to the Values list and enter 0 in the Value field.
    6. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      2

      Name

      Is Qualifying?

      Type of Comparison

      Compare to Values

    7. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Is Qualifying

      Condition

      Equals

    8. Add a new record to the Values list and enter Y in the Value field.
    9. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      3

      Name

      Transaction Age < 1 Month

      Type of Comparison

      Compare to Values

    10. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Transaction Age

      Condition

      Is Less Than

    11. Add a new record to the Values list and enter 30 in the Value field.
    12. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      4

      Name

      TC1 Previous QP Start < Txn Date

      Type of Comparison

      Compare to Object

    13. In the Compare to Object Detail form, enter the values in the following table.
      Section
      Field
      Value

      Compare this Object

       

       

      Compare this object

      Object

      Member

      Compare this object

      Attribute

      TC1 Previous QP Start

      Compare this object

      Condition

      Is Less Than

      To this object

      Object

      Transaction

      To this object

      Attribute

      Transaction Date

    14. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      5

      Name

      TC2 Previous QP Start < Txn Date

      Type of Comparison

      Compare to Object

    15. In the Compare to Object Detail form, enter the values in the following table.
      Section
      Field
      Value

      Compare this object

      Object

      Member

      Compare this object

      Attribute

      TC2 Previous QP Start

      Compare this object

      Condition

      Is Less Than

      To this object

      Object

      Transaction

      To this object

      Attribute

      Transaction Date

    16. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      6

      Name

      TC1 Current QP End, Txn Date

      Type of Comparison

      Compare to Object

    17. In the Compare to Object Detail form, enter the values in the following table.
      Section
      Field
      Value

      Compare this object

      Object

      Member

      Compare this object

      Attribute

      TC1 Current QP End

      Compare this object

      Condition

      Is Greater Than

      To this object

      Object

      Transaction

      To this object

      Attribute

      Transaction Date

    18. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      7

      Name

      TC1 Current QP End < Today

      Type of Comparison

      Compare to Object

    19. In the Compare to Object Detail form, enter the values in the following table.
      Section
      Field
      Value

      Compare this object

      Object

      Member

      Compare this object

      Attribute

      TC1 Current QP End

      Compare this object

      Condition

      Is Less Than

      To this object

      Object

      Transaction

      To this object

      Attribute

      Current Date

    20. Click the Actions view tab.
    21. Add a new record to the Actions list, and enter the values in the following table.
      Field
      Value

      Sequence

      1

      Name

      RTC Automatic

      Type

      RTC Automatic

  6. Create the second rule for this promotion:
    1. Add a new record to the Rules list, and enter the values in the following table.
      Field
      Value

      Sequence

      2

      Name

      Retro Txns 1 Month Ago B

      Apply To

      Transactions

    2. Click the Name field's hyperlink.
    3. Add a new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      1

      Name

      Check Txn Points

      Type of Comparison

      Compare to Values

    4. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Transaction Points

      Condition

      Is Greater Than

    5. Add a new record to the Values list and enter 0 in the Value field.
    6. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      2

      Name

      Is Qualifying?

      Type of Comparison

      Compare to Values

    7. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Is Qualifying

      Condition

      Equals

    8. Add a new record to the Values list and enter Y in the Value field.
    9. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      3

      Name

      Transaction Age < 1 Month

      Type of Comparison

      Compare to Values

    10. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Transaction Age

      Condition

      Is Less Than

    11. Add a new record to the Values list and enter 30 in the Value field.
    12. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      4

      Name

      TC1 Previous QP Start < Txn Date

      Type of Comparison

      Compare to Object

    13. In the Compare to Object Detail form, enter the values in the following table.
      Section
      Field
      Value

      Compare this object

      Object

      Member

      Compare this object

      Attribute

      TC1 Previous QP Start

      Compare this object

      Condition

      Is Less Than

      To this object

      Object

      Transaction

      To this object

      Attribute

      Transaction Date

    14. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      5

      Name

      TC2 Previous QP Start < Txn Date

      Type of Comparison

      Compare to Object

    15. In the Compare to Object Detail form, enter the values in the following table.
      Section
      Field
      Value

      Compare this object

      Object

      Member

      Compare this object

      Attribute

      TC2 Previous QP Start

      Compare this object

      Condition

      Is Less Than

      To this object

      Object

      Transaction

      To this object

      Attribute

      Transaction Date

    16. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      6

      Name

      TC2 Current QP End, Txn Date

      Type of Comparison

      Compare to Object

    17. In the Compare to Object Detail form, enter the values in the following table.
      Section
      Field
      Value

      Compare this object

      Object

      Member

      Compare this object

      Attribute

      TC2 Current QP End

      Compare this object

      Condition

      Is Greater Than

      To this object

      Object

      Transaction

      To this object

      Attribute

      Transaction Date

    18. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      7

      Name

      TC2 Current QP End < Today

      Type of Comparison

      Compare to Object

    19. In the Compare to Object Detail form, enter the values in the following table.
      Section
      Field
      Value

      Compare this object

      Object

      Member

      Compare this object

      Attribute

      TC2 Current QP End

      Compare this object

      Condition

      Is Less Than

      To this object

      Object

      Transaction

      To this object

      Attribute

      Current Date

    20. Click the Actions view tab.
    21. Add a new record to the Actions list, and enter the values in the following table.
      Field
      Value

      Sequence

      1

      Name

      RTC Automatic

      Type

      RTC Automatic

  7. Create the third rule for this promotion:
    1. Add a new record to the Rules list, and enter the values in the following table.
      Field
      Value

      Sequence

      3

      Name

      Retro Txns 1 month ago C

      Apply To

      Transactions

    2. Click the Name field's hyperlink.
    3. Add a new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      1

      Name

      Check Txn Points

      Type of Comparison

      Compare to Values

    4. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Transaction Points

      Condition

      Is Greater Than

    5. Add a new record to the Values list and enter 0 in the Value field.
    6. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      2

      Name

      Is Qualifying?

      Type of Comparison

      Compare to Values

    7. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Is Qualifying

      Condition

      Equals

    8. Add a new record to the Values list and enter Y in the Value field.
    9. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      3

      Name

      Transaction Age < 1 Month

      Type of Comparison

      Compare to Values

    10. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Transaction Age

      Condition

      Is Less Than

    11. Add a new record to the Values list and enter 30 in the Value field.
    12. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      4

      Name

      TC1 Previous QP Start < Txn Date

      Type of Comparison

      Compare to Object

    13. In the Compare to Object Detail form, enter the values in the following table.
      Section
      Field
      Value

      Compare this object

      Object

      Member

      Compare this object

      Attribute

      TC1 Previous QP Start

      Compare this object

      Condition

      Is Less Than

      To this object

      Object

      Transaction

      To this object

      Attribute

      Transaction Date

    14. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      5

      Name

      TC2 Previous QP Start < Txn Date

      Type of Comparison

      Compare to Object

    15. In the Compare to Object Detail form, enter the values in the following table.
      Section
      Field
      Value

      Compare this object

      Object

      Member

      Compare this object

      Attribute

      TC2 Previous QP Start

      Compare this object

      Condition

      Is Less Than

      To this object

      Object

      Transaction

      To this object

      Attribute

      Transaction Date

    16. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      6

      Name

      TC1 Current QP Start, Txn Date

      Type of Comparison

      Compare to Object

    17. In the Compare to Object Detail form, enter the values in the following table.
      Section
      Field
      Value

      Compare this object

      Object

      Member

      Compare this object

      Attribute

      TC1 Current QP Start

      Compare this object

      Condition

      Is Greater Than

      To this object

      Object

      Transaction

      To this object

      Attribute

      Transaction Date

    18. Click the Actions view tab.
    19. Add a new record to the Actions list, and enter the values in the following table.
      Field
      Value

      Sequence

      1

      Name

      RTC Automatic

      Type

      RTC Automatic

  8. Create the fourth rule for this promotion:
    1. Add a new record to the Rules list, and enter the values in the following table.
      Field
      Value

      Sequence

      4

      Name

      Retro Txns 1 month ago D

      Apply To

      Transactions

    2. Click the Name field's hyperlink.
    3. Add a new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      1

      Name

      Check Txn Points

      Type of Comparison

      Compare to Values

    4. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Transaction Points

      Condition

      Is Greater Than

    5. Add a new record to the Values list and enter 0 in the Value field.
    6. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      2

      Name

      Is Qualifying?

      Type of Comparison

      Compare to Values

    7. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Is Qualifying

      Condition

      Equals

    8. Add a new record to the Values list and enter Y in the Value field.
    9. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      3

      Name

      Transaction Age < 1 Month

      Type of Comparison

      Compare to Values

    10. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Transaction Age

      Condition

      Is Less Than

    11. Add a new record to the Values list and enter 30 in the Value field.
    12. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      4

      Name

      TC1 Previous QP Start < Txn Date

      Type of Comparison

      Compare to Object

    13. In the Compare to Object Detail form, enter the values in the following table.
      Section
      Field
      Value

      Compare this object

      Object

      Member

      Compare this object

      Attribute

      TC1 Previous QP Start

      Compare this object

      Condition

      Is Less Than

      To this object

      Object

      Transaction

      To this object

      Attribute

      Transaction Date

    14. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      5

      Name

      TC2 Previous QP Start < Txn Date

      Type of Comparison

      Compare to Object

    15. In the Compare to Object Detail form, enter the values in the following table.
      Section
      Field
      Value

      Compare this object

      Object

      Member

      Compare this object

      Attribute

      TC2 Previous QP Start

      Compare this object

      Condition

      Is Less Than

      To this object

      Object

      Transaction

      To this object

      Attribute

      Transaction Date

    16. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      6

      Name

      TC2 Current QP Start, Txn Date

      Type of Comparison

      Compare to Object

    17. In the Compare to Object Detail form, enter the values in the following table.
      Section
      Field
      Value

      Compare this object

      Object

      Member

      Compare this object

      Attribute

      TC2 Current QP Start

      Compare this object

      Condition

      Is Greater Than

      To this object

      Object

      Transaction

      To this object

      Attribute

      Transaction Date

    18. Click the Actions view tab.
    19. Add a new record to the Actions list, and enter the values in the following table.
      Field
      Value

      Sequence

      1

      Name

      RTC Automatic

      Type

      RTC Automatic

  9. Create the fifth rule for this promotion:
    1. Add a new record to the Rules list, and enter the values in the following table.
      Field
      Value

      Sequence

      5

      Name

      Retro Txns 1 -3 months ago

      Apply To

      Transactions

    2. Click the Name field's hyperlink.
    3. Add a new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      1

      Name

      Check Txn Points

      Type of Comparison

      Compare to Values

    4. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Transaction Points

      Condition

      Is Greater Than

    5. Add a new record to the Values list and enter 0 in the Value field.
    6. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      2

      Name

      Is Qualifying?

      Type of Comparison

      Compare to Values

    7. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Is Qualifying

      Condition

      Equals

    8. Add a new record to the Values list and enter Y in the Value field.
    9. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      3

      Name

      Transaction Age, 1 Month

      Type of Comparison

      Compare to Values

    10. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Transaction Age

      Condition

      Is Greater Than

    11. Add a new record to the Values list and enter 29 in the Value field.
    12. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      4

      Name

      Transaction Age < 3 Months

      Type of Comparison

      Compare to Values

    13. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Transaction Age

      Condition

      Is Less Than

    14. Add a new record to the Values list and enter 90 in the Value field.
    15. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      5

      Name

      TC1 Previous QP Start < Txn Date

      Type of Comparison

      Compare to Object

    16. In the Compare to Object Detail form, enter the values in the following table.
      Section
      Field
      Value

      Compare this object

      Object

      Member

      Compare this object

      Attribute

      TC1 Previous QP Start

      Compare this object

      Condition

      Is Less Than

      To this object

      Object

      Transaction

      To this object

      Attribute

      Transaction Date

    17. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      6

      Name

      TC2 Previous QP Start < Txn Date

      Type of Comparison

      Compare to Object

    18. In the Compare to Object Detail form, enter the values in the following table.
      Section
      Field
      Value

      Compare this object

      Object

      Member

      Compare this object

      Attribute

      TC2 Previous QP Start

      Compare this object

      Condition

      Is Less Than

      To this object

      Object

      Transaction

      To this object

      Attribute

      Transaction Date

    19. Click the Actions view tab.
    20. Add a new record to the Actions list, and enter the values in the following table.
      Field
      Value

      Sequence

      1

      Name

      RTC Automatic

      Type

      RTC Automatic

  10. Create the sixth rule for this promotion:
    1. Add a new record to the Rules list, and enter the values in the following table.
      Field
      Value

      Sequence

      6

      Name

      Retro Txns 3 - 8 months ago

      Apply To

      Transactions

    2. Click the Name field's hyperlink.
    3. Add a new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      1

      Name

      Check Txn Points

      Type of Comparison

      Compare to Values

    4. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Transaction Points

      Condition

      Is Greater Than

    5. Add a new record to the Values list and enter 0 in the Value field.
    6. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      2

      Name

      Is Qualifying?

      Type of Comparison

      Compare to Values

    7. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Is Qualifying

      Condition

      Equals

    8. Add a new record to the Values list and enter Y in the Value field.
    9. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      3

      Name

      Transaction Age, 3 Months

      Type of Comparison

      Compare to Values

    10. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Transaction Age

      Condition

      Is Greater Than

    11. Add a new record to the Values list and enter 89 in the Value field.
    12. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      4

      Name

      Transaction Age < 8 Months

      Type of Comparison

      Compare to Values

    13. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Transaction Age

      Condition

      Is Less Than

    14. Add a new record to the Values list and enter 240 in the Value field.
    15. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      5

      Name

      TC1 Previous QP Start < Txn Date

      Type of Comparison

      Compare to Object

    16. In the Compare to Object Detail form, enter the values in the following table.
      Section
      Field
      Value

      Compare this object

      Object

      Member

      Compare this object

      Attribute

      TC1 Previous QP Start

      Compare this object

      Condition

      Is Less Than

      To this object

      Object

      Transaction

      To this object

      Attribute

      Transaction Date

    17. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      6

      Name

      TC2 Previous QP Start < Txn Date

      Type of Comparison

      Compare to Object

    18. In the Compare to Object Detail form, enter the values in the following table.
      Section
      Field
      Value

      Compare this object

      Object

      Member

      Compare this object

      Attribute

      TC2 Previous QP Start

      Compare this object

      Condition

      Is Less Than

      To this object

      Object

      Transaction

      To this object

      Attribute

      Transaction Date

    19. Click the Actions view tab.
    20. Add a new record to the Actions list, and enter the values in the following table.
      Field
      Value

      Sequence

      1

      Name

      RTC Manual

      Type

      RTC Manual

  11. Create the seventh rule for this promotion:
    1. Add a new record to the Rules list, and enter the values in the following table.
      Field
      Value

      Sequence

      7

      Name

      Retro Txns, 8 months

      Apply To

      Transactions

    2. Click the Name field's hyperlink.
    3. Add a new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      1

      Name

      Check Txn Points

      Type of Comparison

      Compare to Values

    4. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Transaction Points

      Condition

      Is Greater Than

    5. Add a new record to the Values list and enter 0 in the Value field.
    6. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      2

      Name

      Is Qualifying?

      Type of Comparison

      Compare to Values

    7. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Is Qualifying

      Condition

      Equals

    8. Add a new record to the Values list and enter Y in the Value field.
    9. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      3

      Name

      Transaction Age, 8 months

      Type of Comparison

      Compare to Values

    10. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Transaction Age

      Condition

      Is Greater Than

    11. Add a new record to the Values list and enter 239 in the Value field.
    12. Click the Actions view tab.
    13. Add a new record to the Actions list, and enter the values in the following table.
      Field
      Value

      Sequence

      1

      Name

      RTC Adjust Qualifying Points

      Type

      RTC Adjust Qualifying Points

  12. Create the eighth rule for this promotion:
    1. Add a new record to the Rules list, and enter the values in the following table.
      Field
      Value

      Sequence

      8

      Name

      Retro Txns Prior to Previous QP TC2

      Apply To

      Transactions

    2. Click the Name field's hyperlink.
    3. Add a new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      1

      Name

      Check Txn Points

      Type of Comparison

      Compare to Values

    4. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Transaction Points

      Condition

      Is Greater Than

    5. Add a new record to the Values list and enter 0 in the Value field.
    6. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      2

      Name

      Is Qualifying?

      Type of Comparison

      Compare to Values

    7. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Is Qualifying

      Condition

      Equals

    8. Add a new record to the Values list and enter Y in the Value field.
    9. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      3

      Name

      TC2 Previous QP Start, Txn Date

      Type of Comparison

      Compare to Object

    10. In the Compare to Object Detail form, enter the values in the following table.
      Section
      Field
      Value

      Compare this object

      Object

      Member

      Compare this object

      Attribute

      TC2 Previous QP Start

      Compare this object

      Condition

      Is Greater Than

      To this object

      Object

      Transaction

      To this object

      Attribute

      Transaction Date

    11. Click the Actions view tab.
    12. Add a new record to the Actions list, and enter the values in the following table.
      Field
      Value

      Sequence

      1

      Name

      RTC Adjust Qualifying Points

      Type

      RTC Adjust Qualifying Points

  13. Create the ninth rule for this promotion:
    1. Add a new record to the Rules list, and enter the values in the following table.
      Field
      Value

      Sequence

      9

      Name

      Retro Txns Prior to Previous QP TC1

      Apply To

      Transactions

    2. Click the Name field's hyperlink.
    3. Add a new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      1

      Name

      Check Txn Points

      Type of Comparison

      Compare to Values

    4. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Transaction Points

      Condition

      Is Greater Than

    5. Add a new record to the Values list and enter 0 in the Value field.
    6. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      2

      Name

      Is Qualifying?

      Type of Comparison

      Compare to Values

    7. In the Compare to Values Detail form, enter the values in the following table.
      Field
      Value

      Object

      Transaction

      Attribute

      Is Qualifying

      Condition

      Equals

    8. Add a new record to the Values list and enter Y in the Value field.
    9. Add another new record to the Criteria list, and enter the values in the following table.
      Field
      Value

      Sequence

      3

      Name

      TC1 Previous QP Start, Txn Date

      Type of Comparison

      Compare to Object

    10. In the Compare to Object Detail form, enter the values in the following table.
      Section
      Field
      Value

      Compare this object

      Object

      Member

      Compare this object

      Attribute

      TC1 Previous QP Start

      Compare this object

      Condition

      Is Greater Than

      To this object

      Object

      Transaction

      To this object

      Attribute

      Transaction Date

    11. Click the Actions view tab.
    12. Add a new record to the Actions list, and enter the values in the following table.
      Field
      Value

      Sequence

      1

      Name

      RTC Adjust Qualifying Points

      Type

      RTC Adjust Qualifying Points

  14. Click Activate to activate the Admin - Retro Accrual promotion.
Siebel Loyalty Administration Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.