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