Activity Query Fields

UNDER REVIEW

Field Group	Field Name	Data Type	Description
Acknowledgements	Date Letter Sent	Date	Date that acknowledgement was sent
	Letter Was Sent	True/False	Acknowledgement actually sent
	Response Appeal ID	Text	ID of Response Appeal
	Response Appeal Name	Text	Name of Response Appeal
Activity	Activity Count	Number	Number of activities
	Activity Date	Date	Date activity occurred
	Activity Type	Text	Type of Activity, such as Contribution, Order, Pledge, etc
	Activity Value	Currency	Value of Activity
	Call Hour	Time	Time of Call
	Channel	Text	Appeal Channel
	Date and Time Recorded	Time	The date the activity was recorded
	Date Entered	Date	Date Activity Entered (may be different than Activity Date)
	First Activity Amount	Currency	Amount of first activity
	First Activity Date	Date	Date of first activity
	Gift Count	Number	Total number of lifetime gifts
	Last Activity Amount	Currency	Amount of last activity
	Last Activity Date	Date	Date of last activity
	Lifetime Single Largest Activity Value	Currency	Amount of largest activity
	Lifetime Sum of Activity Value	Currency	Total value of lifetime activity
	Month Received	Date (Month)	The month of the activity (Jan, Feb, Mar, etc)
	Note	Text	Notes attached to activity
	Operator	Text (Name)	Name of person entering activity
	Single Largest Activity Date	Date	Date of largest activity
	Single Largest Activity Value	Currency	Value of largest activity
	Single Largest Activity Value Last 12 Months	Currency	Value of largest activity in past 12 months
	Sum of Activity Value	Currency	Total value of lifetime activity
	Week Received	Number	Chronological week of year activity received (1 - 52)
	Year Entered	Date (Year)	Year activity entered
	Year Received	Date (Year)	Year activity received
Appeals	Active Appeal	True/False	Determine whether or not an appeal is active
	Appeal Date	Date	Date appeal created
	Appeal Description	Text	Value of the description field of an appeal
	Appeal ID	Text	Appeal ID
	Appeal Mail Date	Date	Date appeal mailed
	Appeal Segment	Text	Name of segment
	Appeal Segment Description	Text	Description of segment
	Appeal Type	Text	Type of Appeal; Event, Solicitation, Acknowledgement
	Bulk Appeal`	True/False	Determine whether or not an appeal is marked as Bulk
Batch Categories	Batch Category	Text	Filter by category of batch (user-defined)
Batches	Batch Date	Date	Date of Batch
	Batch ID	Text	ID of Batch
	Batch Name	Text	Name of Batch
	Batch Status	Text	Status of Batch; Closed, Open, Pending, etc
	Batch Type	Text	Type of Batch (user-defined)
	Default Payment Method	Text	Default payment type for batch
Contact Notes	With Contact Notes	Linked Query	Filter by a Contact Notes type query
Contacts	Address1	Text	First line of address
	Address2	Text	Second line of address
	Address3	Text	Third line of address
	Birth Date	Date	Birth Date
	Birth Month	Date (Month)	Birth Month
	Birth Year	Date (Year)	Birth Year
	City	Text	City
	Company	Text	Company Name, from Company field on partner record
	Congress District	Text	Number identifying congressional district
	Constituent ID	Text	System ID number of constituent or partner
	Country Code	Text	Country abbreviations
	Country Name	Text	Name of country
	County Name	Text	Name of county
	Days since start	Number	Number of days since partner entered into system
	Deceased Date	Date	Date of death
	Do Not Merge	True/False	Find partners with the Prevent Merge flag checked
	Email	Text	Email address
	Email (Alt 1-3)	Text	Additional email addresses
	Fax Phone	Text	Fax number
	FIPS	Number	Federal Information Processing Standard identification
	First Name	Text	Partner first name
	Full Name	Text	Partner full name, from the Name field on partner record
	Gender	Text	Male, Female, Couple, etc.
	Home Phone	Text	Home phone number
	Last Name	Text	Partner last name
	Latitude	Text	Latitude of partner's current address
	Longitude	Text	Longitude of partner's current address
	Match Code	Text	Address standardization match code
	Member Count	Number	Distinct Partner Count
	Middle Name	Text	Partner middle name
	Mobile Phone	Text	Mobile/Cell phone number
	No Direct Mail	True/False	Find partners with the No Direct Mail flag checked
	No Email Solicitation	True/False	Find partners with the No EmailSolicitation flag checked
	No Phone Solicitation	True/False	Find partners with the No Phone Solicitation flag checked
	No Response Letters	True/False	Find partners with the No Response Letters flag checked
	No Tax Statements	True/False	Find partners with the No Tax Statements flag checked
	Origin Source Code	Text	Origin Source Code field from partner record
	Other Phone	Text	Additional phone number
	Partner Origin Date	Date	Date partner added to system
	Postal Code	Text	Full Zip Code (Zip + 4)
	Postal Code 5	Text	First 5 characters of Zip Code
	Prospect	True/False	Returns 1 if partner is a prospect, else 0
	Salutation	Text	Salutation field from partner record
	Spouse	Text	Spouse Name
	State/Province	Text	State of current address
	Suffix	Text	Name suffix, Jr, Sr, III, etc
	Title	Text	Name Title, Mr, Mrs, Captain, etc
	Undeliverable Address	True/False	Find partners with the Undeliverable Address flag checked
	VIP	True/False	Find partners with the VIP flag checked
	Website	Text	Website field from partner record
	With Contacts	Linked Query	Filter by a Contact type query
	Work Phone	Text	Work phone number
Funds	Fund Description	Text	Description of Fund
	Fund ID	Text	ID of Fund
	Fund Name	Text	Name of Fund
Grouping Options	Appeal Group	Text	Filter by fund grouping type and value
Invoice Gifts	With Invoice Gifts	Linked Query	Filter by an InvoiceGift type query
Invoice Items	Description	Text	Item Description
	FMV	Currency	Fair Market Value
	Item Net	Currency	Net value of invoice item
	List of Products (Quantity) Ordered	Text	Output SKU and quantity ordered
	Quantity	Number	Quantity of items ordered
	SKU	Text	SKU (Stock Keeping Unit) for invoice items
Invoices	Invoice Number	Text	Invoice Number
	With Invoices	Linked Query	Filter by an Invoice Type query
Packages	Package Description	Text	Package Description
	Package ID	Text	Package ID
Payments	Amount Received	Currency	Payment amount
	Check Number	Text	Check ID number used for payment
	Payment Status	Text	Status of Payment, received, etc.
	Payment Type	Text	Method of Payment; Cash, Check, Credit Card, etc
	Sum of Amount Received	Currency	Total payment amount
Pledges	Pledge Value	Currency	Total amount pledged
Segmentation	Segment ID	Text	Segment ID