The Credit Non-Qualifying Points to Members job calculates and updates a member’s points balance. This process aggregates the points for all non-qualifying currencies credited to the member since it was last run.
Required Editions
| Available in: Lightning Experience in Enterprise, Performance, Developer, and Unlimited Editions that have Loyalty Management enabled |
The key nodes used in the Credit Non-Qualifying Points to Members Data Processing Engine template, in the order of the execution, are as follows:
| Node Value | Description | Node Type |
|---|---|---|
|
Loyalty Ledger Loyalty Member Currency Loyalty Program Currency Loyalty Program |
Data sources used in the job for calculating non-qualifying points. | Data Source |
| Add Loyalty Program Currency Type to Ledger | Adds the program currency type to ledgers. | Join |
| Add Program Name to Ledger | Adds the program name to ledgers. | Join |
| Filter Non-Qualifying Points Accrued For Program | Filters the ledgers that have non-qualifying points for the loyalty program. | Filter |
| Non-Qualifying Points Accrued by Member | Joins the Filter Non-Qualifying Points Accrued For Program and the Loyalty Member Currency nodes to get the last time the accruals were processed for each member. | Join |
| Is Ledger Created After Last Process Run | Determines whether a ledger was created after the last accrual was processed. | Formula |
| Ledger Records For Aggregation | Filters the ledgers created after the last time non-qualifying points were credited to members. | Filter |
| Total Points To Credit Since Last Process Date | Aggregates the accrued non-qualifying points after the last run. The aggregated points are grouped by member and currency. | Group and Aggregate |
| Calculate Total Points Accrued | Calculates the total points accrued points by a member. | Formula |
| Update Member Balance And Last Accrual Process Date | Updates the total accrued points and the last accrual processed date in the loyalty member currency records. | Writeback Object |
Input Variables
You can define the input parameters for the calculation job so that the input values are passed at the time of job execution. These input values are considered while defining the filter criteria and expressions in different nodes. The input variable defined for Credit Non-Qualifying Points is Loyalty Program Name. The value is passed while executing the Data Processing Engine job.