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.