UserGuid
|
|
Guid
|
Yes
|
ex: C440CB7A-0007-4DCC-AD19-ED361A12EEB5
|
RID
|
|
int
|
Yes
|
Unique API Key provided to you.
Sample value : 123456
|
ExtMemberId
|
|
varchar(20)
|
Yes
|
Member Identifier on the partner site
Can be any values. Ex: 11213213 or AD1214
|
TxId
|
|
varchar(50)
|
No
|
Can be any values. Ex: 11123 or AD1214
|
Country
|
|
varchar(250)
|
No
|
Country of the member
Can be any values. Ex: USA or United States of America or Canada or CA
|
State
|
|
varchar(50)
|
No
|
State of the member
Can be any values. Ex: Texas or TX
|
FirstName
|
|
varchar(250)
|
No
|
First name of the member
Can be any values. Ex: Donald or Donald II
|
LastName
|
|
varchar(250)
|
No
|
Last name of the member
Can be any values. Ex: Smith or Smith Jr
|
EmailAddress
|
|
varchar(250)
|
No
|
Email Address of the member
Can be any values, but a valid email address regular expression is applied
|
Zip
|
|
varchar(10)
|
No
|
Zip Code of the member
|
Gender
|
|
char(1)
|
No
|
Gender of the member
Accepts either M (for male) or F (for female)
|
Dob
|
|
varchar(20)
|
No
|
Date of birth of member
Values should be in the MM/DD/YYYY format , ex: 01/23/1983
|
Address1
|
|
varchar(500)
|
No
|
Address of the member
Any string values upto 500 char length
|
Address2
|
|
varchar(500)
|
No
|
Address of the member
Any string values upto 500 char length
|
Ethnicity
|
|
int
|
No
|
Ethnicity of the member
Accepted Values:
1 White
2 Black or African American
3 Hispanic
4 American Indian or Alaskan Native
5 Asian Indian
6 Chinese
7 Filipino
8 Japanese
9 Korean
10 Vietnamese
11 Pacific Islander
12 Middle Eastern
14 Other Asian
15 Other
16 Prefer not to answer
|
City
|
|
varchar(50)
|
No
|
City of the member
Can be any values. Ex: Texas or TX
|