|
This query describes donors.
Donor Code/ID (Text (18), Required)
Unique code/id to describe donor.
Donor Name (Text (50), Optional)
Full name of donor. If left blank, it will be derived from other name fields.
Is Organization (Boolean, Optional)
If True, then use Organization Name, but not Title/First/Middle/Last/Suffix/Spouse name fields.
Organization Name (Text (50), Optional)
Only provide if IsOrganization is True.
Title (Text (25), Optional)
Primary name title. Only use if Is Organization is not true.
First/Given Name (Text (25), Optional)
Primary first name. Only use if Is Organization is not true.
First/Given Name (Auto-Split) (Text (50), Optional)
Only use if Is Organization is not true. "And" words will be used to determine primary first name and spouse first name.
Middle Name (Text (25), Optional)
Primary middle name. Only use if Is Organization is not true.
Last/Family Name (Text (25), Optional)
Primary last name. Only use if Is Organization is not true.
Suffix (Text (25), Optional)
Primary name suffix. Only use if Is Organization is not true.
Spouse Title (Text (25), Optional)
Spouse name title. Only use if Is Organization is not true.
Spouse First/Given Name (Text (25), Optional)
Spouse first name. Only use if Is Organization is not true.
Spouse First/Given Name (Auto-Split) (Text (50), Optional)
Only use if Is Organization is not true. "And" words will be used to determine primary first name and spouse first name.
Spouse Middle Name (Text (25), Optional)
Spouse middle name. Only use if Is Organization is not true.
Spouse Last/Family Name (Text (25), Optional)
Spouse last name. Only use if Is Organization is not true.
Street Address (Text (200), Optional)
Spouse last name. Only use if Is Organization is not true.
City (Text (50), Optional)
Spouse last name. Only use if Is Organization is not true.
State/Province (Text (50), Optional)
Spouse last name. Only use if Is Organization is not true.
ZIP/Postal Code (Text (25), Optional)
Spouse last name. Only use if Is Organization is not true.
Country Code (A2/A3/Numeric) (Text (3), Optional)
A2, A3 or Numeric ISO 3166 Country Code.
Country/Region (Text (50), Optional)
Name of country. Optional way to lookup a country.
Address Is Deliverable (Boolean, Optional)
Name of country. Optional way to lookup a country.
Address Last Update (DateTime, Optional)
When the address last changed in the source database.
Phone (Text (50), Optional)
When the address last changed in the source database.
Phone Is Operational (Boolean, Optional)
When the address last changed in the source database.
Phone Last Update (DateTime, Optional)
When the phone number last changed in the source database.
Email (Text (200), Optional)
When the phone number last changed in the source database.
Email Is Operational (Boolean, Optional)
When the phone number last changed in the source database.
Email Last Update (DateTime, Optional)
When the email last changed in the source database.
|