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 2012-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

2012-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

2012-01-15 14:22:01.032

StatusUpdateDateTi me DateTime 19

2012-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 2012-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

2012-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 2012-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.

CustomDateTimeVal ue3

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.

CustomNumericNam e1 String 100 TotalPurchas es

The name of the first numeric custom attribute, as defined in CRMS. Can be blank if not defined.

CustomNumericValu e1 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.