Include Additional Donor Fields

From Documentation
Jump to navigation Jump to search

What fields and options are included when the Include additional donor fields and statistics is selected?

The Include additional donor fields and statistics will add the following fields and data to your output file:

Field Description
TGA-XXXX Total giving amount for the donor for the current year
TGC-XXXX Total number of gifts for the donor for the current year
TGA-XXXX Total giving amount for the donor for the previous year from the run date
TGC-XXXX Total number of gifts for the donor for the previous year from the run date
TGA-XXXX Total giving amount for the donor for the 2ndd year back from the run date
TGC-XXXX Total number of gifts for the donor for the 2nd year back from the run date
TGA-XXXX Total giving amount for the donor for the 3rd year back from the run date
TGC-XXXX Total number of gifts for the donor for the 3rd year back from the run date
TGA-XXXX Total giving amount for the donor for the 4th year back from the run date
TGC-XXXX Total number of gifts for the donor for the 4th year back from the run date
TGA-XXXX Total giving amount for the donor for the 5th year back from the run date
TGC-XXXX Total number of gifts for the donor for the 5th year back from the run date
TGA-XXXX Total giving amount for the donor for the 6th year back from the run date
TGC-XXXX Total number of gifts for the donor for the 6th year back from the run date
PGifts Indicates whether or not the donor has any planned gifts
BirthDate Donor's birth date
Age Age of the donor, if known
Gender Gender of the donor
CreateDate Date that the donor's constituent record was added to the system
AICodes The AI Codes assigned to the donor's constituent record
EmpName The donor's employer name
EmpPos The donor's employment position
YearsofGiving Total number of years that the donor has been giving to your organization