Batch Push Points Expiration
The Point expiration batch push will serve as a log of point expiration data by program members. Each time a member's point expiration data changes, a record is added to the file. If a member has multiple updates throughout the day, the member will appear multiple times in the file.
Naming Convention
The Point Expiration Batch file will have the following naming convention:
2_<client_id>_POINTS_EXPIRATION_YYYYMMDD.zip
Zip file containing the CSV file: 2_<client_id>_POINTS_EXPIRATION_YYYYMMDD.csv
Where:
- <client_id> represents the CrowdTwist generated client_id
- YYYYMMDD represents the timestamp of the file with year, month, and day values when the file generation is complete
- File contains header row, comma separated
|
Field Name |
Sample Value |
Format |
Description |
|
User Details |
|||
|
user_id |
348399 | Integer | This is crowdTwist member id. |
| email_address | test@ct.com | String | Email of the member. |
| third_party_id | String | User's third party ID. | |
| message_date | 2021-05-20T18:25:43.511-04:00 | String | Event capture timestamp for inactivity point expiration. |
| Inactivity point expiration |
|
|
Show only when Inactivity data is present. |
|
inactivity_last_qualified_date |
2021-05-20T18:25:43.511-04:00 |
String |
The UTC date & time the of the last qualifying activity performed. This date must be an ISO-8601 compliant date field. |
|
inactivity_exp_date |
2021-05-20T18:25:43.511-04:00 |
String |
The UTC date & time the of the last qualifying activity performed. This date must be an ISO-8601 compliant date field. |
| inactivity_points_exp | 200 | Integer | Number of points that will be expiring if qualified activity is not performed. |
|
Redemption Period point expiration |
|
|
Show only when FIFO data is present. |
| redperiod_expiration_date_pre1 | 2021-05-20T18:25:43.511-04:00 |
String |
Point expiration date of preceding 1st month where preceding month is the month where expiration period was updated and points have data. The UTC date & time the of the last qualifying activity performed. This date must be an ISO-8601 compliant date field. |
| redperiod_expired_pre1 | 120 | Integer | Number of points expired in the preceding 1st month. |
| redperiod_redeemed_pre1 | 100 | Integer | Number of points redeemed in the preceding 1st month. |
| redperiod_expiration_date_nxt1 | 2021-05-20T18:25:43.511-04:00 |
String |
Point expiration date of current month. The UTC date & time the of the last qualifying activity performed. This date must be an ISO-8601 compliant date field. |
| redperiod_expiring_nxt1 | 200 | Integer | Number of points expiring in the current month. |
| redperiod_redeemed_nxt1 | 120 | Integer | Number of points redeemed in the current month. |
|
redperiod_expiration_date_nxt2 |
2021-05-20T18:25:43.511-04:00 |
String |
Point expiration date of next 1st month where next 1st month is the month where expiration period was updated and points have data. The UTC date & time the of the last qualifying activity performed. This date must be an ISO-8601 compliant date field. |
| redperiod_expiring_nxt2 | 200 | Integer | Number of points expiring in the next 1st month. |
| redperiod_redeemed_nxt2 | 120 | Integer | Number of points redeemed in next 1st month. |
|
redperiod_expiration_date_nxt3 |
2021-05-20T18:25:43.511-04:00 |
String |
Point expiration date of next 2nd month where next 2nd month is the month where expiration period was updated and points have data.. The UTC date & time the of the last qualifying activity performed. This date must be an ISO-8601 compliant date field. |
| redperiod_expiring_nxt3 | 200 | Integer | Number of points expiring in the next 2nd month. |
| redperiod_redeemed_nxt3 | 120 | Integer | Number of points redeemed in next 2nd month. |
|
redperiod_expiration_date_nxt4 |
2021-05-20T18:25:43.511-04:00 |
String |
Point expiration date of next 3rd month where next 3rd month is the month where expiration period was updated and points have data. The UTC date & time the of the last qualifying activity performed. This date must be an ISO-8601 compliant date field. |
| redperiod_expiring_nxt4 | 200 | Integer | Number of points expiring in the next 3rd month. |
| redperiod_redeemed_nxt4 | 120 | Integer | Number of points redeemed in next 3rd month. |
|
redperiod_expiration_date_nxt5 |
2021-05-20T18:25:43.511-04:00 |
String |
Point expiration date of next 4th month where next 4th month is the month where expiration period was updated and points have data. The UTC date & time the of the last qualifying activity performed. This date must be an ISO-8601 compliant date field. |
| redperiod_expiring_nxt5 | 200 | Integer | Number of points expiring in the next 4th month. |
| redperiod_redeemed_nxt5 | 120 | Integer | Number of points redeemed in next 4th month. |
|
redperiod_expiration_date_nxt6 |
2021-05-20T18:25:43.511-04:00 |
String |
Point expiration date of next 5th month where where next 5th month is the month where expiration period was updated and points have data. The UTC date & time the of the last qualifying activity performed. This date must be an ISO-8601 compliant date field. |
| redperiod_expiring_nxt6 | 200 | Integer | Number of points expiring in the next 5th month. |
| redperiod_redeemed_nxt6 | 120 | Integer | Number of points redeemed in next 5th month. |