Articles in this section

What is the Redemption history CSV?

  • Updated
Index
・What is the Redemption history CSV?
・"Redemptions" CSV
・"Individual" CSV

 

What is the Redemption history CSV?

You can confirm by Team Admin > Culture Rewards > Redemption history CSV.

The following 2 kinds of CSV files are available for each month.

  • Redemptions
  • Individual

※Data from the previous month will be added and displayed around 14:00 on the first day of the month.

You can confirm the history of approval, delivery, and return of custom rewards.

A CSV file will include requests for which any of these 3 actions were taken in the specified month.

Rejected requests will not be included.

 

Example)
Yumi Satoh's request (A) was approved on October 15 and was delivered on November 1.
Yoshito Yamada's request (B) was approved and returned on October 15.

  • October CSV will include both (A) and (B).
  • November CSV will include only (A).

交換履歴CSV例.png

"Redemption" CSV

This CSV includes all the redemption history for custom rewards.
The following items are available.

  • requestID：The redemption request ID
  • approvedDate：The date when the request was approved
  • deliverdDate：The date when the request was delivered
  • refundedDate：The date when the request was returned
  • fullName：The name of the applicant
  • emailAddress：The email address of the applicant
  • departments：The department of the applicant
  • position：The position of the applicant
  • employeeCode：The employee number of the applicant
  • employmentType：The employment type of the applicant
  • rewardName：The name of the requested custom reward
  • category：The type of the reward
    ※A custom reward will be indicated as "custom."
  • totalPoints：Points used for the request
  • totalAmount：The value of the requested reward
    ※This field will be left blank for a custom reward.
  • currencyUnit：Currency
    ※This field will be left blank for a custom reward.
  • memo：The memo for CSV by admin
    The memo entered on the custom reward settings page will be displayed here.

 

"Individual" CSV

The data from the "Redemption" CSV is sorted by individuals or reward types.

  • redemptionStatus：The type of the redemption (approved, delivered, or refunded)
  • fullName：The name of the applicant
  • emailAddress：The email address of the applicant
  • departments：The department of the applicant
  • position：The position of the applicant
  • employeeCode：The employee number of the applicant
  • employmentType：The employment type of the applicant
  • category：The type of the reward
    ※A custom reward will be indicated as "custom."
  • totalPoints：Points used for the request
  • totalAmount：The value of the requested reward
    ※This field will be left blank for a custom reward.
  • currencyUnit：Currency
    ※This field will be left blank for a custom reward.

  Example)
The image below means "Yumi Satoh's culture reward request worth 1000 points were approved.


Individual CSV.png

 

Related articles