TntMPD.DataServer
Bridging the gap between your organization and your staff...
Donors

Contents

Syndication

Donors

Print this Topic Previous pageReturn to chapter overviewNext page

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.  way to lookup a country.

Address Is Deliverable

Boolean

Optional

Name of country.  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.