Points are a type of incentives issued to customers as a part of loyalty or promotion. This table summarizes loyalty-related KPIs of customers enrolled as part of Multi-Loyalty Programs (MLP). 

Each row in the table represents a customer enrollment into MLP. A customer can have multiple enrollments (as a result, the table will have multiple rows with the same field name) as this table is relevant to Multi-Loyalty Programs. For example. if a customer enrolled into sub-programs A, B, and C of an MLP, there will be three rows in this table with the same field name related to A, B, and C respectively


Column NameField NameDescription
Auto Update Time ceauto_update_time_ce
Date and time when the customer enrolment table is recently updated (Unix timestamp)
Auto Update Time cpsauto_update_time_cps
Date and time when the customer point summary table is recently updated (Unix timestamp)
Customer Enrollment IDcustomer_enrollment_ID
Unique ID of each customer enrollment entry for the corresponding event program.
Customer Slabcustomer_slab
Current loyalty slab of the customer based on the enrolled program. For each enrolled program, the customer will have a separate row in the table.
Event Date
event_date
Date of customer’s enrollment for the specific program. (Unix timestamp).
Event Program
event_program
Name of the program in which the customer is enrolled.
Event User ID
event_user_ID
User ID of the customer who gets enrolled by event program.
Event Zone Till
event_zone_till
It shows the Till from which the customer is enrolled in the MLP.
Last Tier Date Change
last_tier_date_change
Most recent date when the customer changed their slab from one tier to another. (Unix timestamp)
Latest Updated Date
latest_updated_date
Most recent date when the customer point summary table is updated. (Unix timestamp)
Latest Updated Time
latest_updated_time
Most recent time when the customer point summary table is updated. (Unix timestamp)
Tier Expiry Date
tier_expiry_date
The date on which the customer’s current loyalty slab expires.
Expired Points
expired_points
Total points expired for the customers till date.
Lifetime Points
lifetime_points
Stands for total points earned by the customers till date.
Loyalty Points
loyalty_points
The total points available for redemption till date
Redeemed Points
redeemed_points
The total points redeemed by the customers till date.
Yearyear
Year in which the customer is enrolled in MLP (year corresponding to event date).