Headings on a Standard Excel Membership Pull
Headings	Description	Example
CTLID	Member ID #
CTSALF	Salutation Filter	Complete Member name including prefix (Dr.) & Suffix (Jr.)
CTAD1	Address Line 1
CTAD2	Address Line 2
CTAD3	Address Line 3	The 3rd address line is usually not used
CTCTY	City
CTST	State
CTZIP	ZIP Code
CTRMK1	Remark Line 1	"Bad Member" Address appears -
CTRMK2	Remark Line 2	in these 2 fields
CTLNML	Last Name
CTMCAT	Member Category
CTLSTP	Last Payment Date	9909 = Sept 1999 & 0009 = Sept 2000
CTLSTC	Last Payment State/Chapter
CTPST	State
CTPCHP	Chapter
CTPEV	Event
CTCUR	Current Year	04 = 2004
CTCURT	Current Year Total member $
CTPY1	Prior Year 1	03 = 2003
CTPYT1	Prior Year 1 Total member $
CTWPHO	Work Phone
CTHPHO	Home Phone