Siebel Loyalty Administration Guide > Getting Started with Siebel Loyalty > Configuration of Siebel Loyalty >

Setting Up Points Loan Repayment


Your company can, at its discretion, loan points to its members. For details of how this is done, see Lending Points to Loyalty Members. To collect repayment of these loans automatically, Siebel Loyalty provides a workflow process named LOY Loan Repayment. To invoke the workflow, you must build a search spec that the workflow takes as its input.

The search spec identifies members that have outstanding points loans and have positive points accruals. The workflow, once activated, runs nightly and performs the following process:

  1. Owes points? Identifies members who have outstanding points owed.
  2. Accrued points? Identifies members who have accrued points.
  3. Creates redemption. For each member where both are true, creates a redemption transaction that debits points from the member and pays them back to your company up to the amount of points owed.

The workflow identifies loaned points that the member owes regardless of whether the member has spent these loaned points. The workflow does not wait till the member has the full amount of points needed to redeem the loan. It can collect loaned points incrementally.

To set up the search spec for points loan repayment

  1. Navigate to the Administration - Server screen.
  2. In the link bar, click Jobs.
  3. On the Jobs list, create a new record, and complete the necessary fields. Some fields are described in the following table.
    Field
    Comments

    Component/Job

    Select Workflow Process Batch Manager.

  4. On the Job Parameters list at the bottom of the screen, create a new record, and complete the necessary fields. Some fields are described in the following table.
    Field
    Comments

    Name

    Select Workflow Process Name.

    Value

    Enter the name of the work flow the search spec will apply to; in this case, LOY Loan Repayment.

  5. On the Job Parameters list at the bottom of the screen, create another new record, and complete the necessary fields. Some fields are described in the following table.
    Field
    Comments

    Name

    Select Search Specification.

    Value

    Enter the following string:

    [Transaction Sub Type] = LookupValue ('LOY_TXN_SUB_TYPE_CD', 'Loan') AND [Status] = LookupValue('LOY_TXN_STATUS_CD', 'Processed') AND [Current Loan Balance] > 0

  6. Go back to the top of the screen and click Start.

    Each time the component runs, for each applicable member it creates a transaction of Type = REDEMPTION, Subtype = Loan Repayment, and Points = <as many as the member has available, up to the amount needed to repay the loan>.

Siebel Loyalty Administration Guide