Letters Query Fields

UNDER REVIEW

Field Group	Field Name	Data Type	Description
Appeal Pulls	Channel	Text	Channel of pull
	Mail Date	Date	Date letter sent
Appeals	Active	True/False	Determine if appeal is active
	Appeal ID	Text	ID of appeal
Appeal Segments	Appeal Segment ID	Text	ID of appeal segment
Contacts	Address1	Text	First line of address
	City	Text	City
	Constituent ID	Text	Partner/Constituent ID
	Country Code	Text	Country Abbreviation
	County Name	Text	Name of county
	Email (Alt 1-3)	Text	Additional email addresses
	First Name	Text	Partner first name
	Last Name	Text	Partner last name
	Middle Name	Text	Partner middle name
	Postal Code	Text	Zip Code
	Primary Email	Text	Email address
	Salutation	Text	Salutation field from partner record
	State	Text	State of current address
	StateProv	Text	State of current address
	Title	Text	Name Title, Mr, Mrs, Captain, etc
	Website	Text	Website field from partner record
	With Contacts	Linked Query	Filter records based on Contacts type query
Letters	Date Pulled	Date	Date letter sent
Packages	Package Description	Text	Package Description
	Package ID	Text	Package ID
Segmentation	Segment ID	Text	ID of segment