Registered Card Attribute Properties

Note: Registered Card Attribute values are calculated data.
Registered Card Attribute Properties
Property Name Description Type Length Nulls Allowed Sample Data Default Data Notes
RegisteredCardID TIBCO Reward unique identifier for a customer card Int 4 No 123459876 0 TIBCO Reward unique identifier for a customer card.
CardNumber Card number, e.g., VISA card no. (Will be encrypted.) nvarchar 800 Yes 1111222233334444 Null This will come back as an encrypted field after being saved to TIBCO Reward the first time.
ShopperId TIBCO Reward shopper Id assigned to this card int 4 bytes Yes 123459876 Null

Precision,scale = 10,0; e.g.,

1234567890

CommonName This can be used to store extra information about the registered card nvarchar 200 No Acme Co Loyalty Card Empty String This can be used to store extra information about the registered card.
AlternateCardIdentifier If you need an unencrypted card number, use this field nvarchar 200 Yes 1234567 Null This field is not encrypted and should not be used for the storage of any monetary instrument data.
CardType Type identifier for credit card char 1 No V Empty String

The Credit Cart type. supported values are:

Visa = V

MasterCard = M

AmericanExpress = A

Discover = D

DinersClub = C

JapaneseCommerceBank = J

NonCreditCardLoyaltyCard = L

PrivateLabelCreditCard = P

ExpirationMonth Standard int 4 No 12 None

Precision,scale = 10,0; e.g.,

1234567890

ExpirationYear Standard int 4 No 2010 None

Precision,scale = 10,0; e.g.,

1234567890

LastFour The last four digits of the card number nvarchar 8 No 8162 Empty String The last four digits of the card number, this can be card number or alternate card number. The value used to search for members in the CSR tool.
SecurityCode Do not use nvarchar 8 Yes 858 Null Not used.
CardHolderName The name as printed on the card nvarchar 200 No John B Doe Empty String The cardholder name as printed on the card.
Status Status of the card char 1 No A Empty String A/I (active or inactive). Only active cards are used by the TIBCO Reward system in transaction matching etc.
CreateDateTime Date time the card is created datetime 8 No

2012-04-23T00:00:00.0000000+

02:00

None Date time the card is created.
IsPreferred Reserved for future use char 1 No N Empty String <<Blank>>
FileImportId Id of the import file that created the card int 4 No 4321 0 Zero indicates that this was not created by file import.
EncryptedCardNumber Encrypted version of card number varbinary 128 Yes NA Null Not for external use.
FirstSix For future use. Some clients allowthe fist six digits of a card to be used, to help differentiate between cards. nvarchar 12 Yes 123456 Null For future use.