New and Updated Customer Export Data Table

Field Name Field Description Data Type Size Sample Data Notes
FileId Integer 10 123 TIBCO Reward internal file identifier
RegistrationDate Date the customer completed their registration for the client’s program. DateTime 19 2018-01-15 14:22:01.032 If the customer has signed up on the client’s microsite, this value will be the date the customer completed signup. Otherwise, this value will be equivalent to the CreationDate. This is also known as “Member SinceDate.”
CreationDate Date the customer first entered the TIBCO Reward system DateTime 2018-01-15 14:22:01.032 If the client provided a historical transaction feed, this value will be the date of the first transaction appearing for the customer.
ShopperStatus String 1 “A” = Active “I” = Inactive When a customer opts out of the loyalty program, this value will be “I”. Otherwise, the value will be “A”.
LoyaltyMember Bit 1 1 = Member 0 = Non- member When a customer opts out of the loyalty program, this value will be “0”. Otherwise, the value will be “1”.
SourceOfChange NOTE: This is a deprecated schema element. String 100 “Retailer”, “Shopper”, “CSR”, or “Other” Note: SourceOfChange is deprecated. It is not supported. If it appears in a schema, be aware that the data is not used or usable.
ShopperId String 50 “123459876” Client’s identifier for this customer
InStorecardShopperI D Integer 10 100123456
FirstName String 100 “Jane”
MiddleName String 100 “C”
LastName String 100 “Doe”
AddressLine1 String 100 “123 Main Street”
AddressLine2 String 100 “Apt. 1”
City String 100 “San Francisco”
State String 2 “CA”
PostalCode String 100 “94104”
EMail String 200 “jane@exam ple.com”
EmailOptIn Boolean 1 1 = Opted into marketing emails 0 = Opted out of marketing emails EmailOptIn=“1” maps to a value of “OptedIn” in the CustomerPrivacy XML element; EmailOptIn=“0” maps to a value of “eMail” in the CustomerPrivacy XML element.
PhoneNumber String 100 “4155551234”
LoyaltyProgramID String 100 “112358” This field only applicable if the customer 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.
TierName String 100 “Base tier”, “Second tier” This is the name of the customer’s tier as it appears in the CSR tool. This is also used for display purposes when using Tier Signage.
TierJoinDate DateTime 19 2018-01-15 14:22:01.032
StatusUpdateDateTi me DateTime 19 2018-01-15 14:22:01.032 When ShopperShopperStatus changes from “A” to “I” or from “I” to “A”, this value is updated with the time the change was made in the TIBCO Reward system.
PointBalance Integer 10 10, 5000
CustomDateTimeValueLastChangedDate Time DateTime 19 2018-01-17 14:22:01.032 The last time a custom date field was changed for this customer, cumulative across all custom date/time fields.
CustomDateTimeName1 String 100 First Purchase The name of the first date/time custom attribute, as defined in CRMS: in this case, "First Purchase". The line can be omitted from the file if a custom attribute is not defined.
CustomDateTimeVal ue1 DateTime 19 2018-07-19T00:00:01.065 The value of the first date/time custom attribute for this customer. A Custom Attribute line can be omitted from the file if a custom attribute is not defined. Can be blank if not defined.
CustomDateTimeName2 String 100 Last Purchase The name of the second date/time custom attribute, as defined in CRMS: in this case, "Last Purchase". Line can be omitted from the file if a custom attribute is not defined.
CustomDateTimeValue2 DateTime 19 2018-06-25T00:00:04.083 The value of the second date/time custom attribute for this customer. Line can be omitted from the file if a custom attribute is not defined.
CustomDateTimeName3 String 100 The name of the third date/time custom attribute, as defined in CRMS. Line can be omitted from the file if a custom attribute is not defined.
CustomDateTimeValue3 DateTime 19 The value of the third date/time custom attribute for this customer. Line can be omitted from the file if a custom attribute is not defined.
Name and value columns repeat for fourth through 19th attributes
CustomDateTimeName20 String 100 The name of the 20th date/time custom attribute, as defined in CRMS. Line can be omitted from the file if a custom attribute is not defined.
CustomDateTimeValue20 DateTime 19 The value of the 20th date/time custom attribute for this customer. Can be omitted if not defined.
CustomNumericValueLastChangedDateTi me DateTime 19 The last time a custom numeric field was changed for this customer, cumulative across all custom numeric fields.
CustomNumericName1 String 100 TotalPurchases The name of the first numeric custom attribute, as defined in CRMS. Can be blank if not defined.
CustomNumericValue1 Decimal 10 3 The value of the first numeric custom attribute for this customer. Can be blank if not defined.
CustomNumericName2 String 100 TotalDollars The name of the second numeric custom attribute, as defined in CRMS. Can be blank if not defined.
CustomNumericValue2 Decimal 10 128.94 The value of the second numeric custom attribute for this customer. Can be blank if not defined.
Name and value columns repeat for third through 19th attributes.
CustomNumericName20 String 100 The name of the 20th numeric custom attribute, as defined in CRMS. Can be blank if not defined.
CustomNumericValue20 Decimal 10 The value of the 20th numeric custom attribute for this customer. Can be blank if not defined.
CustomLookupValueLastChangedDateTi me DateTime 19 The last time a custom lookup field was changed for this customer, cumulative across all custom lookup fields.
CustomLookupName1 String 100 The name of the first lookup custom attribute, as defined in CRMS. Can be blank if not defined.
CustomLookupValue1 String 45 The value of the first lookup custom attribute for this customer. Can be blank if not defined.
CustomLookupName2 String 100 The name of the second lookup custom attribute, as defined in CRMS. Can be blank if not defined.
CustomLookupValue2 String 45 The value of the second lookup custom attribute for this customer. Can be blank if not defined.
Name and value columns repeat for third through 19th attributes.
CustomLookupName20 String 100 The name of the 20th lookup custom attribute, as defined in CRMS. Can be blank if not defined.
CustomLookupValue20 String 45 The value of the 20th lookup custom attribute for this customer. Can be blank if not defined.
CustomTextValueLas tChangedDateTime String 100 The last time a custom text field was changed for this customer, cumulative across all custom text fields.
CustomTextName1 String 100 The name of the first text custom attribute, as defined in CRMS. Can be blank if not defined.
CustomTextValue1 String 100 The value of the first text custom attribute for this customer. Can be blank if not defined. Note: Only the first 100 characters of the text custom attribute fields are included in the Customer Export file.
CustomTextName2 String 100 The name of the second text custom attribute, as defined in CRMS. Can be blank if not defined.
CustomTextValue2 String 100 The value of the second text custom attribute for this customer. Can be blank if not defined. Note: Only the first 100 characters of the text custom attribute fields are included in the Customer Export file.
<Custom Text Name and Value columns 2 through 19> Name and value columns repeat for third through 19th attributes.
CustomTextName20 String 100 The name of the 20th text custom attribute, as defined in CRMS. Can be blank if not defined.
CustomTextValue20 String 100 The value of the 20th text custom attribute for this customer. Can be blank if not defined. Note: Only the first 100 characters of the text custom attribute fields are included in the Customer Export file.