1. Home
  2. Data & reports
  3. Supporter management
  4. Account data structure tagged field list

Account data structure tagged field list

The Account Data Structure contains a list of fields, some of which are ‘tagged’.

What is a tagged data field?

These are fields containing certain pre-defined types of data in the database. These data fields are considered ‘tagged’ and so we know exactly where this data lives and how this data is to be used.

For example, when your ‘Post code’ field is tagged as ‘Postcode’, then our email-to-target tools know to use this field to lookup the targets for the action. Or, the field that is tagged as Email Address will be used to uniquely identify the supporter, and is also where thank you emails are sent to. There are several other kinds of tagged fields. 

The database also contains ‘untagged’ data fields, which are essentially empty placeholders that you can use to create and define your own field types, relating to your organizations’ particular needs and goals. For example, you might want to store your own offline database ID, to make it more easy to match supporters between the two systems. Because this field is not used by the Engaging Networks platform for any special purpose, it would be added as an untagged field.

Which Tagged Fields Are Available?

The table below provides a description of each of the pre-assigned, tagged fields in the database.

Field Id

Use

Length

Title

Constituent’s Name Prefix

50

First Name

Constituent’s First Name Value

500

Middle Name

Constituent’s Middle Name Value

500

Last Name

Constituent’s Last Name Value

500

Address 1

Constituent’s Street Address

1000

Address 2

Constituent’s Apt, Floor, Suite, Etc.

1000

Address 3

Additional Address Information

1000

City

Constituent’s City

500

Region

Constituent’s State, Province, etc.

500

Email Address

Constituent’s Primary Email (unique identifier in the software)

500

Postcode

Constituent’s Postal Code

200

Country

Constituent’s Country

500

Phone Number

Constituent’s Phone Number

200

Password

Password for logging into Peer-to-Peer dashboard

50

Donation Amount

Amount of the Donation

Numeric value

Payment Type

Type of Credit Card, PayPal, or Bank Account

50

Credit Card Number

Number of Credit Card Being Used to Donate

18

Credit Card Expiration Date

Expiration of Credit Card Being Used to Donate

8

Credit Card Verification Value

Verification Code of Credit Card Being Used to Donate

4

Card Holder Name

Name of Owner of Credit Card Being Used to Donate

500

Card Start Date

Date that Credit Card Being Used to Donate was Issued

20

Bank Account Number

Number of Bank Account being Used to Donate

50

Bank Routing Transit Number

Routing Number of Bank Hosting Account from which Donation Is Made

20

Bank Account Type

Type of Bank Account (Checking/Savings) from which Donation is Made

30

Bank Name

Name of Bank Hosting Account from which Donation is Made

500

Issue Number

Issue Number of Credit Card Being Used to Donate (not used in USA / UK)

 

Payment Currency

Type of Currency being Used to Donate

3

Recurring Payment

Flag to Indicate if Donation is Recurring (‘Y’)

1

Recurring Day

Day the Next Recurring Payment Should Occur

1 to 30

Recurring Start Date

Date Recurring Donation Payments Began

20

Recurring End Date

Date Recurring Donation Payments Will Stop

20

Recurring Count

Number of Recurring Donation Payments to Process

500

Recurring Frequency

How Often Recurring Donation Payments Occur

10

Recurring Period

Length of Time Between Recurring Donation Payments

Numeric value

Tax Deductible

Flag to Indicate if Donation is Tax Deductible (‘Y’) (you can use this for Gift Aid)

1

Pledge Amount

Amount of Donation Being Pledged to a Specific Category

Numeric value

P2P Team Name

LEGACY – DO NOT USE Name of Peer-to-Peer Fundraising Team

100

P2P Fundraiser Type

LEGACY – DO NOT USE Type of Peer-to-Peer Account (Individual or Team)

50

Tribute Options

Choices of Tribute Gifts

400

Recognize Gift

Flag to Indicate if Donor / Donation Should be Specially Recognized (‘Y’)

1

Additional Comments

Additional Comments Related to Transaction / E-cards personalized message field

4000

Anonymous Donor

Flag to Indicate if Donation is Being Made Anonymously (‘Y’)

10

IN MEMORIAM ONLY BELOW

   

In Memoriam

Flag to Indicate if Donation is Being Made in Memory/Honor of Someone (‘Y’ value must be submitted)

1

Inform Email

Email of Person Being Informed of In Memoriam Gift

400

Inform Name

Name of Person Being Informed of In Memoriam Gift

400

Inform Address 1

Address of Person Being Informed of In Memoriam Gift

400

Inform Address 2

Address 2 of Person Being Informed of In Memoriam Gift

400

Inform City

City of Person Being Informed of In Memoriam Gift

400

Inform Region

State/Province of Person Being Informed of In Memoriam Gift

400

Inform Postcode

Postcode of Person Being Informed of In Memoriam Gift

400

Inform Country

Country of Person Being Informed of In Memoriam Gift

400

Honoree Name

Name of Person in Whose Honor the In Memoriam Gift is Made

400

Gift Reason

The Reason that In Memoriam Gift is Made

4000

END IN MEMORIAM FIELDS

   

Direct Gift

Where (Target / Purpose) the Donor Wants to Direct Their Gift to be Used

255

Appeal Code

Extra Field Used for Tracking Data About One Specific Transaction Page

300

Membership Type

Type of Membership Being Purchased

30

Membership Start Date

Date Membership Begins

30

Membership End Date

Date Membership Ends

30

Membership Term

Length of Membership (in Days)

30

Membership Cost

Total Cost of Membership

10

Number of Members

Number of Members Included in the Membership

10

Member Name 1

Name of First Member

50

Member Name 2

Name of Second Member

50

Member Name 3

Name of Third Member

50

Member Name 4

Name of Fourth Member

50

Member Name 5

Name of Fifth Member

50

Member Name 6

Name of Sixth Member

50

Member Name 7

Name of Seventh Member

50

Second Address 1

Constituent’s Secondary Address

1000

Second Address 2

Constituent’s Secondary Apt, Floor, Suite, Etc.

1000

Second City

Constituent’s Secondary City 500

Second Region

Constituent’s Secondary State, Province, Etc. 500

Second Postcode

Constituent’s Secondary Postal Code 200

Second Country

Constituent’s Secondary Country 500

Email Address 2

Secondary Email Address (not the unique identifier) 500

Phone Number 2

Secondary Phone Number 200

BIilling Address 1

Donor’s Credit Card Billing Address 1000

Billing Address 2

Donor’s Credit Card Billing Apt, Floor, Suite, Etc. 1000

Billing City

Donor’s Credit Card Billing City 500

Billing Region

Donor’s Credit Card Billing State, Province, etc. 500

Billing Postcode

Donor’s Credit Card Billing Postal Code 200

Billing Country

Donor’s Credit Card Billing Country 500

Supporter Suffix

Constituent’s Suffix 50

Supporter Organization

Constituent’s Organization Name 500

Supporter Language

Constituent’s Preferred Language 200

Supporter Chapter

Chapter that Constituent’s Belongs To 500

Supporter Birthday

Date of Constituent’s Birth

The birthday date must be formatted YYYY-MM-DD

20

Shipping Title

For Premium donation pages, the title the shipping should be sent to

50

Shipping First Name

For Premium donation pages, the first name the shipping should be sent to

100

Shipping Last Name

For Premium donation pages, the last name the shipping should be sent to

100

Shipping Email Address

For Premium donation pages, the email address of the shipping

100

Shipping Address 1

For Premium donation pages, the first line of the shipping address 20

Shipping Address 2

For Premium donation pages, the second line of the shipping address 200

Shipping City

For Premium donation pages, the town/city of the shipping address 100

Shipping Region

For Premium donation pages, the region of the shipping address 100

Shipping Postcode

For Premium donation pages, the postcode of the shipping address 50

Shipping Country

For Premium donation pages, the country of the shipping address 100

Shipping Notes

For Premium donation pages, any notes on the shipping 2000

Shipping Enabled

For Premium donation pages, whether the shipping address is different to the donor address (Y or N) 1

Which Un-Tagged Fields Are Available?

You can add untagged fields to your database structure as required.

Your database also contains four un-tagged, placeholder fields, enabling you to create and define your own data types as needed.

Other 1

Client-Defined Transaction Field

500

Other 2

Client-Defined Transaction Field

500

Other 3

Client-Defined Transaction Field

500

Other 4

Client-Defined Transaction Field

500

Updated on July 16, 2019

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support