Rewards Data Table

Field # Name Description Type Length Sample Data Notes
1 LoyaltyLabRewardID TIBCO Reward's unique identifier for a reward. Integer

10

3877824
2

RewardCompensation

The compensation type of the reward. It can be: “OfflineRebate” (External Rebate), or “Bonus”. See the Award Type table following this table. String 100 “B” , “O”

RewardCompensation for Reward Center redemptions will always be “B.”

If you are using automatic point conversion, the RewardCompensation will be “O”.

3

RewardText

Text of the associated reward.

String 255

“100 Points”, “$20 Credit”,

This field contains different strings of text, depending on the type of reward:

“$<Amount> Credit” – Dollar/Percent Off

“<CRMS Description>” – Bonus

“$<Rebate Amount> Rebate” – External Rebate

“<Points><PointsName>” – Points Program

“$<Rebate Amount> < Award Description>” – Automatic Point Conversion Award

“<Reward Product Description>” – Reward Center.

4 RewardValue Value of the associated reward. Decimal 10

30.0000

This field contains different strings of text, depending on the type of reward:

“20.00” – Bonus, Dollar/Percent Off, External Rebate “100”– Points

Note: Does not apply to reward catalog items

5

ShopperID

Client’s shopper identifier

String 50 “112358” This element is not included in the output if ShopperId is not captured in the TIBCO Reward system.
6

InStorecardShop perId

TIBCO Reward's unique identifier for a shopper. Integer 10 12345
7 FirstName

String

100 “Jane”
8 MiddleName String 100 “C”
9 LastName String 100

“Doe”

10 AddressLine1 String 100

“123 Main Street”

11 AddressLine2 String 100 “Apt. 1”
12 City String 100

“San Francisco”

13 State String 2 “CA”
14 PostalCode String 100 “94104”
15 PhoneNumber Phone number of shopper earning the reward. String 100 “415-555-1234”
16 EMail E-mail address of shopper earning the reward. String 200 “jane@ex ample.com”
17 ProcessDateTime The date and time the reward was processed at Reward DateTime 19 CCYY- MM-DD hh:mm:ss.mmm No equivalent in XML format
18 PointBalance

If there is a point program, the customer's current point balance.

Decimal

10 200.0000
19 PointBalanceExtr actDate DateTi me 19 CCYY- MM-DD hh:mm:ss.mmm
20 OfferId ID of Offer within TIBCO Reward that generated the Reward.

Intege r

9 4372897
21 OfferName A description of the Offer within TIBCO Reward that generated the Reward. String 100 “$15 off $100 purchase”

22

LoyaltyProgramID String

100

“112358”

This field only applicable if the shopper registers a loyalty card (not a credit card) when joining the client’s main program, in which case this field will contain the card number of the loyalty card. Otherwise, this value will not be included.