Data Set Dictionary
======================================================================
EPSILON CONFIDENTIAL EPSILON CONFIDENTIAL EPSILON CONFIDENTIAL
INFORMATION LISTED BELOW IS AVAILABLE UNDER THE TERMS OF THE
CONFIDENTIALITY AGREEMENT
EPSILON CONFIDENTIAL EPSILON CONFIDENTIAL EPSILON CONFIDENTIAL
======================================================================
+--------------------------------------------------------------------+
| PARALYZED VETERANS OF AMERICA (PVA) |
| DATA DICTIONARY TO ACCOMPANY |
| |
| KDD-CUP-98 |
| |
| The Second International Knowledge Discovery and |
| Data Mining Tools Competition |
| |
| Held in Conjunction with KDD-98 |
| |
| The Fourth International Conference on Knowledge |
| Discovery and Data Mining |
| [www.kdnuggets.com] or |
| [www-aig.jpl.nasa.gov/kdd98] or |
| [www.aaai.org/Conferences/KDD/1998] |
| |
| Sponsored by the |
| |
| American Association for Artificial Intelligence (AAAI) |
| Epsilon Data Mining Laboratory |
| Paralyzed Veterans of America (PVA) |
+--------------------------------------------------------------------+
| |
| Created: 7/20/98 |
| Last update: 7/20/98 |
| file name: cup98DIC.txt |
| |
+--------------------------------------------------------------------+
Variable Description
-------------------------- ------------------------------------------
ODATEDW Origin Date. Date of donor's first gift
to PVA YYMM format (Year/Month).
OSOURCE Origin Source
- (Only 1rst 3 bytes are used)
- Defaulted to 00000 for conversion
- Code indicating which mailing list the
donor was originally acquired from
- A nominal or symbolic field.
TCODE Donor title code
000 = _
001 = MR.
001001 = MESSRS.
001002 = MR. & MRS.
002 = MRS.
002002 = MESDAMES
003 = MISS
003003 = MISSES
004 = DR.
004002 = DR. & MRS.
004004 = DOCTORS
005 = MADAME
006 = SERGEANT
009 = RABBI
010 = PROFESSOR
010002 = PROFESSOR & MRS.
010010 = PROFESSORS
011 = ADMIRAL
011002 = ADMIRAL & MRS.
012 = GENERAL
012002 = GENERAL & MRS.
013 = COLONEL
013002 = COLONEL & MRS.
014 = CAPTAIN
014002 = CAPTAIN & MRS.
015 = COMMANDER
015002 = COMMANDER & MRS.
016 = DEAN
017 = JUDGE
017002 = JUDGE & MRS.
018 = MAJOR
018002 = MAJOR & MRS.
019 = SENATOR
020 = GOVERNOR
021002 = SERGEANT & MRS.
022002 = COLNEL & MRS.
024 = LIEUTENANT
026 = MONSIGNOR
027 = REVEREND
028 = MS.
028028 = MSS.
029 = BISHOP
031 = AMBASSADOR
031002 = AMBASSADOR & MRS.
033 = CANTOR
036 = BROTHER
037 = SIR
038 = COMMODORE
040 = FATHER
042 = SISTER
043 = PRESIDENT
044 = MASTER
046 = MOTHER
047 = CHAPLAIN
048 = CORPORAL
050 = ELDER
056 = MAYOR
059002 = LIEUTENANT & MRS.
062 = LORD
063 = CARDINAL
064 = FRIEND
065 = FRIENDS
068 = ARCHDEACON
069 = CANON
070 = BISHOP
072002 = REVEREND & MRS.
073 = PASTOR
075 = ARCHBISHOP
085 = SPECIALIST
087 = PRIVATE
089 = SEAMAN
090 = AIRMAN
091 = JUSTICE
092 = MR. JUSTICE
100 = M.
103 = MLLE.
104 = CHANCELLOR
106 = REPRESENTATIVE
107 = SECRETARY
108 = LT. GOVERNOR
109 = LIC.
111 = SA.
114 = DA.
116 = SR.
117 = SRA.
118 = SRTA.
120 = YOUR MAJESTY
122 = HIS HIGHNESS
123 = HER HIGHNESS
124 = COUNT
125 = LADY
126 = PRINCE
127 = PRINCESS
128 = CHIEF
129 = BARON
130 = SHEIK
131 = PRINCE AND PRINCESS
132 = YOUR IMPERIAL MAJEST
135 = M. ET MME.
210 = PROF.
STATE State abbreviation (a nominal/symbolic field)
ZIP Zipcode (a nominal/symbolic field)
MAILCODE Mail Code
" "= Address is OK
B = Bad Address
PVASTATE EPVA State or PVA State
Indicates whether the donor lives in a state
served by the organization's EPVA chapter
P = PVA State
E = EPVA State (Northeastern US)
DOB Date of birth (YYMM, Year/Month format.)
NOEXCH Do Not Exchange Flag (For list rental)
_ = can be exchanged
X = do not exchange
RECINHSE In House File Flag
_ = Not an In House Record
X = Donor has given to PVA's In House program
RECP3 P3 File Flag
_ = Not a P3 Record
X = Donor has given to PVA's P3 program
RECPGVG Planned Giving File Flag
_ = Not a Planned Giving Record
X = Planned Giving Record
RECSWEEP Sweepstakes file flag
_ = Not a Sweepstakes Record
X = Sweepstakes Record
MDMAUD The Major Donor Matrix code
The codes describe frequency and amount of
giving for donors who have given a $100+
gift at any time in their giving history.
An RFA (recency/frequency/monetary) field.
The (current) concatenated version is a nominal
or symbolic field. The individual bytes could separately be
used as fields and refer to the following:
First byte: Recency of Giving
C=Current Donor
L=Lapsed Donor
I=Inactive Donor
D=Dormant Donor
2nd byte: Frequency of Giving
1=One gift in the period of recency
2=Two-Four gifts in the period of recency
5=Five+ gifts in the period of recency
3rd byte: Amount of Giving
L=Less than $100(Low Dollar)
C=$100-499(Core)
M=$500-999(Major)
T=$1,000+(Top)
4th byte: Blank/meaningless/filler
'X' indicates that the donor is not a major donor.
For more information regarding the RFA codes, see
the promotion history field definitions.
DOMAIN DOMAIN/Cluster code. A nominal or symbolic field.
could be broken down by bytes as explained below.
1st byte = Urbanicity level of the donor's neighborhood
U=Urban
C=City
S=Suburban
T=Town
R=Rural
2nd byte = Socio-Economic status of the neighborhood
1 = Highest SES
2 = Average SES
3 = Lowest SES (except for Urban communities, where
1 = Highest SES, 2 = Above average SES,
3 = Below average SES, 4 = Lowest SES.)
CLUSTER CLUSTER
Code indicating which cluster group the donor falls into.
Each cluster is unique in terms of socio-economic status,
urbanicty, ethnicity and a variety of other demographic
characteristics. A nominal or symbolic field.
AGE Overlay Age
0 = missing
AGEFLAG Age Flag
E = Exact
I = Inferred from Date of Birth Field
HOMEOWNR Home Owner Flag
H = Home owner
U = Unknown
CHILD03 Presence of Children age 0-3
B = Both, F = Female, M = Male
CHILD07 Presence of Childern age 4-7
CHILD12 Presence of Childern age 8-12
CHILD18 Presence of Childern age 13-18
NUMCHLD NUMBER OF CHILDREN
INCOME HOUSEHOLD INCOME
GENDER Gender
M = Male
F = Female
U = Unknown
J = Joint Account, unknown gender
WEALTH1 Wealth Rating
HIT MOR Flag # HIT (Mail Order Response)
Indicates total number of known times the donor has
responded to a mail order offer other than PVA's.
-------------------------- -------------------------------------------------
The following variables indicate the number of
known times the donor has responded to other
types of mail order offers.
MBCRAFT Buy Craft Hobby
MBGARDEN Buy Gardening
MBBOOKS Buy Books
MBCOLECT Buy Collectables
MAGFAML Buy General Family Mags
MAGFEM Buy Female Mags
MAGMALE Buy Sports Mags
PUBGARDN Gardening Pubs
PUBCULIN Culinary Pubs
PUBHLTH Health Pubs
PUBDOITY Do It Yourself Pubs
PUBNEWFN News / Finance Pubs
PUBPHOTO Photography Pubs
PUBOPP Opportunity Seekers Pubs
-------------------------- -------------------------------------------------
DATASRCE Source of Overlay Data
Indicates which third-party data source the donor
matched against
1 = MetroMail
2 = Polk
3 = Both
MALEMILI % Males active in the Military
MALEVET % Males Veterans
VIETVETS % Vietnam Vets
WWIIVETS % WWII Vets
LOCALGOV % Employed by Local Gov
STATEGOV % Employed by State Gov
FEDGOV % Employed by Fed Gov
SOLP3 SOLICIT LIMITATION CODE P3
= can be mailed (Default)
00 = Do Not Solicit or Mail
01 = one solicitation per year
02 = two solicitations per year
03 = three solicitations per year
04 = four solicitations per year
05 = five solicitations per year
06 = six solicitations per year
12 = twelve solicitations per year
SOLIH SOLICITATION LIMIT CODE IN HOUSE
= can be mailed (Default)
00 = Do Not Solicit
01 = one solicitation per year
02 = two solicitations per year
03 = three solicitations per year
04 = four solicitations per year
05 = five solicitations per year
06 = six solicitations per year
12 = twelve solicitations per year
MAJOR Major ($$) Donor Flag
_ = Not a Major Donor
X = Major Donor
WEALTH2 Wealth Rating
Wealth rating uses median family income and
population statistics from each area to
index relative wealth within each state
The segments are denoted 0-9, with 9 being
the highest income group and zero being the
lowest. Each rating has a different meaning
within each state.
GEOCODE Geo Cluster Code indicating the level geography at which
a record matches the census data.
A nominal or symbolic field.
Blank=No code has been assigned or did not
match at any level.
-------------------------- -------------------------------------------------
The following variables reflect donor interests,
as collected from third-party data sources
COLLECT1 COLLECTABLE (Y/N)
VETERANS VETERANS (Y/N)
BIBLE BIBLE READING (Y/N)
CATLG SHOP BY CATALOG (Y/N)
HOMEE WORK FROM HOME (Y/N)
PETS HOUSEHOLD PETS (Y/N)
CDPLAY CD PLAYER OWNERS (Y/N)
STEREO STEREO/RECORDS/TAPES/CD (Y/N)
PCOWNERS HOME PC OWNERS/USERS
PHOTO PHOTOGRAPHY (Y/N)
CRAFTS CRAFTS (Y/N)
FISHER FISHING (Y/N)
GARDENIN GARDENING (Y/N)
BOATS POWER BOATING (Y/N)
WALKER WALK FOR HEALTH (Y/N)
KIDSTUFF BUYS CHILDREN'S PRODUCTS (Y/N)
CARDS STATIONARY/CARDS BUYER (Y/N)
PLATES PLATE COLLECTOR (Y/N)
LIFESRC LIFE STYLE DATA SOURCE
Indicates source of the lifestyle variables listed
above
1 = MATCHED ON METRO MAIL ONLY
2 = MATCHED ON POLK ONLY
3 = MATCHED BOTH MM AND POLK
-------------------------- -------------------------------------------------
PEPSTRFL Indicates PEP Star RFA Status
blank = Not considered to be a PEP Star
'X' = Has PEP Star RFA Status
-------------------------- -------------------------------------------------
The following variables reflect characteristics
of the donors neighborhood, as collected from the
1990 US Census.
POP901 Number of Persons
POP902 Number of Families
POP903 Number of Households
POP90C1 Percent Population in Urbanized Area
POP90C2 Percent Population Outside Urbanized Area
POP90C3 Percent Population Inside Rural Area
POP90C4 Percent Male
POP90C5 Percent Female
ETH1 Percent White
ETH2 Percent Black
ETH3 Percent Native American
ETH4 Percent Pacific Islander/Asian
ETH5 Percent Hispanic
ETH6 Percent Asian Indian
ETH7 Percent Japanese
ETH8 Percent Chinese
ETH9 Percent Philipino
ETH10 Percent Korean
ETH11 Percent Vietnamese
ETH12 Percent Hawaiian
ETH13 Percent Mexican
ETH14 Percent Puerto Rican
ETH15 Percent Cuban
ETH16 Percent Other Hispanic
AGE901 Median Age of Population
AGE902 Median Age of Adults 18 or Older
AGE903 Median Age of Adults 25 or Older
AGE904 Average Age of Population
AGE905 Average Age of Adults >= 18
AGE906 Average Age of Adults >= 25
AGE907 Percent Population Under Age 18
CHIL1 Percent Children Under Age 7
CHIL2 Percent Children Age 7 - 13
CHIL3 Percent Children Age 14-17
AGEC1 Percent Adults Age18-24
AGEC2 Percent Adults Age 25-34
AGEC3 Percent Adults Age 35-44
AGEC4 Percent Adults Age 45-54
AGEC5 Percent Adults Age 55-64
AGEC6 Percent Adults Age 65-74
AGEC7 Percent Adults Age >= 75
CHILC1 Percent Children Age <=2
CHILC2 Percent Children Age 3-5
CHILC3 Percent Children Age 6-11
CHILC4 Percent Children Age 12-15
CHILC5 Percent Children Age 16-18
HHAGE1 Percent Households w/ Person 65+
HHAGE2 Percent Households w/ Person 65+ Living Alone
HHAGE3 Percent Households Headed by an Elderly Person Age 65+
HHN1 Percent 1 Person Households
HHN2 Percent 2 Person Households
HHN3 Percent 3 or More Person Households
HHN4 Percent 4 or More Person Households
HHN5 Percent 5 or More Person Households
HHN6 Percent 6 Person Households
MARR1 Percent Married
MARR2 Percent Separated or Divorced
MARR3 Percent Widowed
MARR4 Percent Never Married
HHP1 Median Person Per Household
HHP2 Average Person Per Household
DW1 Percent Single Unit Structure
DW2 Percent Detached Single Unit Structure
DW3 Percent Duplex Structure
DW4 Percent Multi (2+) Unit Structures
DW5 Percent 3+ Unit Structures
DW6 Percent Housing Units in 5+ Unit Structure
DW7 Percent Group Quarters
DW8 Percent Institutional Group Quarters
DW9 Non-Institutional Group Quarters
HV1 Median Home Value in hundreds
HV2 Average Home Value in hundreds
HV3 Median Contract Rent in hundreds
HV4 Average Contract Rent in hundreds
HU1 Percent Owner Occupied Housing Units
HU2 Percent Renter Occupied Housing Units
HU3 Percent Occupied Housing Units
HU4 Percent Vacant Housing Units
HU5 Percent Seasonal/Recreational Vacant Units
HHD1 Percent Households w/ Related Children
HHD2 Percent Households w/ Families
HHD3 Percent Married Couple Families
HHD4 Percent Married Couples w/ Related Children
HHD5 Percent Persons in Family Household
HHD6 Percent Persons in Non-Family Household
HHD7 Percent Single Parent Households
HHD8 Percent Male Householder w/ Child
HHD9 Percent Female Householder w/ Child
HHD10 Percent Single Male Householder
HHD11 Percent Single Female Householder
HHD12 Percent Households w/ Non-Family Living Arrangements
ETHC1 Percent White < Age 15
ETHC2 Percent White Age 15 - 59
ETHC3 Percent White Age 60+
ETHC4 Percent Black < Age 15
ETHC5 Percent Black Age 15 - 59
ETHC6 Percent Black Age 60+
HVP1 Percent Home Value >= $200,000
HVP2 Percent Home Value >= $150,000
HVP3 Percent Home Value >= $100,000
HVP4 Percent Home Value >= $75,000
HVP5 Percent Home Value >= $50,000
HVP6 Percent Home Value >= $300,000
HUR1 $ 1 or 2 Room Housing Units
HUR2 Percent >= 6 Room Housing Units
RHP1 Median Number of Rooms per Housing Unit
RHP2 Average Number of Rooms per Housing Unit
RHP3 Median Number of Persons per Housing Unit
RHP4 Average Number of Persons per Room
HUPA1 Percent Housing Units w/ 2 thru 9 Units at the Address
HUPA2 Percent Housing Units w/ >= 10 Units at the Address
HUPA3 Percent Mobile Homes or Trailers
HUPA4 Percent Renter Occupied Single Unit Structure
HUPA5 Percent Renter Occupied, 2 - 4 Units
HUPA6 Percent Renter Occupied, 5+ Units
HUPA7 Percent Renter Occupied Mobile Homes or Trailers
RP1 Percent Renters Paying >= $500 per Month
RP2 Percent Renters Paying >= $400 per Month
RP3 Percent Renters Paying >= $300 per Month
RP4 Percent Renters Paying >= $200 per Month
MSA MSA Code
ADI ADI Code
DMA DMA Code
IC1 Median Household Income in hundreds
IC2 Median Family Income in hundreds
IC3 Average Household Income in hundreds
IC4 Average Family Income in hundreds
IC5 Per Capita Income
IC6 Percent Households w/ Income < $15,000
IC7 Percent Households w/ Income $15,000 - $24,999
IC8 Percent Households w/ Income $25,000 - $34,999
IC9 Percent Households w/ Income $35,000 - $49,999
IC10 Percent Households w/ Income $50,000 - $74,999
IC11 Percent Households w/ Income $75,000 - $99,999
IC12 Percent Households w/ Income $100,000 - $124,999
IC13 Percent Households w/ Income $125,000 - $149,999
IC14 Percent Households w/ Income >= $150,000
IC15 Percent Families w/ Income < $15,000
IC16 Percent Families w/ Income $15,000 - $24,999
IC17 Percent Families w/ Income $25,000 - 34,999
IC18 Percent Families w/ Income $35,000 - $49,999
IC19 Percent Families w/ Income $50,000 - $74,999
IC20 Percent Families w/ Income $75,000 - $99,999
IC21 Percent Families w/ Income $100,000 - $124,999
IC22 Percent Families w/ Income $125,000 - $149,999
IC23 Percent Families w/ Income >= $150,000
HHAS1 Percent Households on Social Security
HHAS2 Percent Households on Public Assistance
HHAS3 Percent Households w/ Interest, Rental or Dividend Income
HHAS4 Percent Persons Below Poverty Level
MC1 Percent Persons Move in Since 1985
MC2 Percent Persons in Same House in 1985
MC3 Percent Persons in Different State/Country in 1985
TPE1 Percent Driving to Work Alone Car/Truck/Van
TPE2 Percent Carpooling Car/Truck/Van)
TPE3 Percent Using Public Transportation
TPE4 Percent Using Bus/Trolley
TPE5 Percent Using Railways
TPE6 Percent Using Taxi/Ferry
TPE7 Percent Using Motorcycles
TPE8 Percent Using Other Transportation
TPE9 Percent Working at Home/No Transportation
PEC1 Percent Working Outside State of Residence
PEC2 Percent Working Outside County of Residence in State
TPE10 Median Travel Time to Work in minutes
TPE11 Mean Travel Time to Work in minutes
TPE12 Percent Traveling 60+ Minutes to Work
TPE13 Percent Traveling 15 - 59 Minutes to Work
LFC1 Percent Adults in Labor Force
LFC2 Percent Adult Males in Labor Force
LFC3 Percent Females in Labor Force
LFC4 Percent Adult Males Employed
LFC5 Percent Adult Females Employed
LFC6 Percent Mothers Employed Married and Single
LFC7 Percent 2 Parent Earner Families
LFC8 Percent Single Mother w/ Child in Labor Force
LFC9 Percent Single Father w/ Child in Labor Force
LFC10 Percent Families w/ Child w/ no Workers
OCC1 Percent Professional
OCC2 Percent Managerial
OCC3 Percent Technical
OCC4 Percent Sales
OCC5 Percent Clerical/Administrative Support
OCC6 Percent Private Household Service Occ.
OCC7 Percent Protective Service Occ.
OCC8 Percent Other Service Occ.
OCC9 Percent Farmers
OCC10 Percent Craftsmen, Precision, Repair
OCC11 Percent Operatives, Machine
OCC12 Percent Transportation
OCC13 Percent Laborers, Handlers, Helpers
EIC1 Percent Employed in Agriculture
EIC2 Percent Employed in Mining
EIC3 Percent Employed in Construction
EIC4 Percent Employed in Manufacturing
EIC5 Percent Employed in Transportation
EIC6 Percent Employed in Communications
EIC7 Percent Employed in Wholesale Trade
EIC8 Percent Employed in Retail Industry
EIC9 Percent Employed in Finance, Insurance, Real Estate
EIC10 Percent Employed in Business and Repair
EIC11 Percent Employed in Personnal Services
EIC12 Percent Employed in Entertainment and Recreation
EIC13 Percent Employed in Health Services
EIC14 Percent Employed in Educational Services
EIC15 Percent Employed in Other Professional Services
EIC16 Percent Employed in Public Administration
OEDC1 Percent Employed by Local Government
OEDC2 Percent Employed by State Government
OEDC3 Percent Employed by Federal Government
OEDC4 Percent Self Employed
OEDC5 Percent Private Profit Wage or Salaried Worker
OEDC6 Percent Private Non-Profit Wage or Salaried Worker
OEDC7 Percent Unpaid Family Workers
EC1 Median Years of School Completed by Adults 25+
EC2 Percent Adults 25+ Grades 0-8
EC3 Percent Adults 25+ w/ some High School
EC4 Percent Adults 25+ Completed High School or Equivalency
EC5 Percent Adults 25+ w/ some College
EC6 Percent Adults 25+ w/ Associates Degree
EC7 Percent Adults 25+ w/ Bachelors Degree
EC8 Percent Adults 25+ Graduate Degree
SEC1 Percent Persons Enrolled in Private Schools
SEC2 Percent Persons Enrolled in Public Schools
SEC3 Percent Persons Enrolled in Preschool
SEC4 Percent Persons Enrolled in Elementary or High School
SEC5 Percent Persons in College
AFC1 Percent Adults in Active Military Service
AFC2 Percent Males in Active Military Service
AFC3 Percent Females in Active Military Service
AFC4 Percent Adult Veterans Age 16+
AFC5 Percent Male Veterans Age 16+
AFC6 Percent Female Veterans Age 16+
VC1 Percent Vietnam Veterans Age 16+
VC2 Percent Korean Veterans Age 16+
VC3 Percent WW2 Veterans Age 16+
VC4 Percent Veterans Serving After May 1975 Only
ANC1 Percent Dutch Ancestry
ANC2 Percent English Ancestry
ANC3 Percent French Ancestry
ANC4 Percent German Ancestry
ANC5 Percent Greek Ancestry
ANC6 Percent Hungarian Ancestry
ANC7 Percent Irish Ancestry
ANC8 Percent Italian Ancestry
ANC9 Percent Norwegian Ancestry
ANC10 Percent Polish Ancestry
ANC11 Percent Portuguese Ancestry
ANC12 Percent Russian Ancestry
ANC13 Percent Scottish Ancestry
ANC14 Percent Swedish Ancestry
ANC15 Percent Ukranian Ancestry
POBC1 Percent Foreign Born
POBC2 Percent Born in State of Residence
LSC1 Percent English Only Speaking
LSC2 Percent Spanish Speaking
LSC3 Percent Asian Speaking
LSC4 Percent Other Language Speaking
VOC1 Percent Households w/ 1+ Vehicles
VOC2 Percent Households w/ 2+ Vehicles
VOC3 Percent Households w/ 3+ Vehicles
HC1 Percent Median Length of Residence
HC2 Percent Median Age of Occupied Dwellings in years
HC3 Percent Owner Occupied Structures Built Since 1989
HC4 Percent Owner Occupied Structures Built Since 1985
HC5 Percent Owner Occupied Structures Built Since 1980
HC6 Percent Owner Occupied Structures Built Since 1970
HC7 Percent Owner Occupied Structures Built Since 1960
HC8 Percent Owner Occupied Structures Built Prior to 1960
HC9 Percent Owner Occupied Condominiums
HC10 Percent Renter Occupied Condominiums
HC11 Percent Occupied Housing Units Heated by Utility Gas
HC12 Percent Occupied Housing Units Heated by Bottled, Tank or LP
HC13 Percent Occupied Housing Units Heated by Electricity
HC14 Percent Occupied Housing Units Heated by Fuel Oil
HC15 Percent Occupied Housing Units Heated by Solar Energy
HC16 Percent Occupied Housing Units Heated by Coal, Wood, Other
HC17 Percent Housing Units w/ Public Water Source
HC18 Percent Housing Units w/ Well Water Source
HC19 Percent Housing Units w/ Public Sewer Source
HC20 Percent Housing Units w/ Complete Plumbing Facilities
HC21 Percent Housing Units w/ Telephones
MHUC1 Median Homeowner Cost w/ Mortgage per Month dollars
MHUC2 Median Homeowner Cost w/out Mortgage per Month dollars
AC1 Percent Adults Age 55-59
AC2 Percent Adults Age 60-64
-------------------------- -------------------------------------------------
The fields listed below are from the promotion history file.
PROMOTION CODES:
----------------
The following lists the promotion codes and their
respective field names (where XXXX refers to ADATE, RFA,
RDATE and RAMNT.)
'97NK' ==> xxxx_2 (mailing was used to construct
the target fields)
'96NK' ==> xxxx_3
'96TK' ==> xxxx_4
'96SK' ==> xxxx_5
'96LL' ==> xxxx_6
'96G1' ==> xxxx_7
'96GK' ==> xxxx_8
'96CC' ==> xxxx_9
'96WL' ==> xxxx_10
'96X1' ==> xxxx_11
'96XK' ==> xxxx_12
'95FS' ==> xxxx_13
'95NK' ==> xxxx_14
'95TK' ==> xxxx_15
'95LL' ==> xxxx_16
'95G1' ==> xxxx_17
'95GK' ==> xxxx_18
'95CC' ==> xxxx_19
'95WL' ==> xxxx_20
'95X1' ==> xxxx_21
'95XK' ==> xxxx_22
'94FS' ==> xxxx_23
'94NK' ==> xxxx_24
1st 2 bytes of the code refers to the year of the
mailing while 3rd and 4th bytes refer to the
following promotion codes/types:
LL mailings had labels only
WL mailings had labels only
CC mailings are calendars with stickers but do
not have labels
FS mailings are blank cards that fold into
thirds with labels
NK mailings are blank cards with labels
SK mailings are blank cards with labels
TK mailings have thank you printed on the
outside with labels
GK mailings are general greeting cards (an
assortment of birthday, sympathy, blank, & get
well) with labels
XK mailings are Christmas cards with labels
X1 mailings have labels and a notepad
G1 mailings have labels and a notepad
This information could certainly be used to calculate
several summary variables that count the number of
occurrences of various types of promotions received
in the most recent 12-36 months, etc.
RFA (RECENCY/FREQUENCY/AMOUNT)
------------------------------
The RFA (recency/frequency/amount) status of the
donors (as of the promotion dates) is included in the
RFA fields.
The (current) concatenated version is a nominal
or symbolic field. The individual bytes could
separately be used as fields and refer to the
following:
First Byte of code is concerned with RECENCY
based on Date of the last Gift
F=FIRST TIME DONOR Anyone who has made their
first donation in the last 6 months and has
made just one donation.
N=NEW DONOR Anyone who has made their first
donation in the last 12 months and is not a
First time donor. This is everyone who made
their first donation 7-12 months ago, or
people who made their first donation between
0-6 months ago and have made 2 or more
donations.
A=ACTIVE DONOR Anyone who made their first
donation more than 12 months ago and has made
a donation in the last 12 months.
L=LAPSING DONOR A previous donor who made their
last donation between 13-24 months ago.
I=INACTIVE DONOR A previous donor who has not
made a donation in the last 24 months. It is
people who made a donation 25+ months ago.
S=STAR DONOR STAR Donors are individuals who
have given to 3 consecutive card mailings.
Second Byte of code is concerned with FREQUENCY
based on the period of recency. The period of
recency for all groups except L and I is the
last 12 months. For L it is 13-24 months ago,
and for I it is 25-36 months ago. There are
four valid frequency codes.
1=One gift in the period of recency
2=Two gift in the period of recency
3=Three gifts in the period of recency
4=Four or more gifts in the period of recency
Third byte of the code is the Amount of the last
gift.
A=$0.01 - $1.99
B=$2.00 - $2.99
C=$3.00 - $4.99
D=$5.00 - $9.99
E=$10.00 - $14.99
F=$15.00 - $24.99
G=$25.00 and above
ADATE_2 Date the 97NK promotion was mailed
ADATE_3 Date the 96NK promotion was mailed
ADATE_4 Date the 96TK promotion was mailed
ADATE_5 Date the 96SK promotion was mailed
ADATE_6 Date the 96LL promotion was mailed
ADATE_7 Date the 96G1 promotion was mailed
ADATE_8 Date the 96GK promotion was mailed
ADATE_9 Date the 96CC promotion was mailed
ADATE_10 Date the 96WL promotion was mailed
ADATE_11 Date the 96X1 promotion was mailed
ADATE_12 Date the 96XK promotion was mailed
ADATE_13 Date the 95FS promotion was mailed
ADATE_14 Date the 95NK promotion was mailed
ADATE_15 Date the 95TK promotion was mailed
ADATE_16 Date the 95LL promotion was mailed
ADATE_17 Date the 95G1 promotion was mailed
ADATE_18 Date the 95GK promotion was mailed
ADATE_19 Date the 95CC promotion was mailed
ADATE_20 Date the 95WL promotion was mailed
ADATE_21 Date the 95X1 promotion was mailed
ADATE_22 Date the 95XK promotion was mailed
ADATE_23 Date the 94FS promotion was mailed
ADATE_24 Date the 94NK promotion was mailed
RFA_2 Donor's RFA status as of 97NK promotion date
RFA_3 Donor's RFA status as of 96NK promotion date
RFA_4 Donor's RFA status as of 96TK promotion date
RFA_5 Donor's RFA status as of 96SK promotion date
RFA_6 Donor's RFA status as of 96LL promotion date
RFA_7 Donor's RFA status as of 96G1 promotion date
RFA_8 Donor's RFA status as of 96GK promotion date
RFA_9 Donor's RFA status as of 96CC promotion date
RFA_10 Donor's RFA status as of 96WL promotion date
RFA_11 Donor's RFA status as of 96X1 promotion date
RFA_12 Donor's RFA status as of 96XK promotion date
RFA_13 Donor's RFA status as of 95FS promotion date
RFA_14 Donor's RFA status as of 95NK promotion date
RFA_15 Donor's RFA status as of 95TK promotion date
RFA_16 Donor's RFA status as of 95LL promotion date
RFA_17 Donor's RFA status as of 95G1 promotion date
RFA_18 Donor's RFA status as of 95GK promotion date
RFA_19 Donor's RFA status as of 95CC promotion date
RFA_20 Donor's RFA status as of 95WL promotion date
RFA_21 Donor's RFA status as of 95X1 promotion date
RFA_22 Donor's RFA status as of 95XK promotion date
RFA_23 Donor's RFA status as of 94FS promotion date
RFA_24 Donor's RFA status as of 94NK promotion date
-------------------------- -------------------------------------------------
The following fields are summary variables from
the promotion history file.
CARDPROM Lifetime number of card promotions received to
date. Card promotions are promotion type FS, GK,
TK, SK, NK, XK, UF, UU.
MAXADATE Date of the most recent promotion received (in
YYMM, Year/Month format)
NUMPROM Lifetime number of promotions received to date
CARDPM12 Number of card promotions received in the last
12 months (in terms of calendar months translates
into 9603-9702)
NUMPRM12 Number of promotions received in the last 12
months (in terms of calendar months translates
into 9603-9702)
-------------------------- -------------------------------------------------
The following fields are from the giving history
file.
RDATE_3 Date the gift was received for 96NK
RDATE_4 Date the gift was received for 96TK
RDATE_5 Date the gift was received for 96SK
RDATE_6 Date the gift was received for 96LL
RDATE_7 Date the gift was received for 96G1
RDATE_8 Date the gift was received for 96GK
RDATE_9 Date the gift was received for 96CC
RDATE_10 Date the gift was received for 96WL
RDATE_11 Date the gift was received for 96X1
RDATE_12 Date the gift was received for 96XK
RDATE_13 Date the gift was received for 95FS
RDATE_14 Date the gift was received for 95NK
RDATE_15 Date the gift was received for 95TK
RDATE_16 Date the gift was received for 95LL
RDATE_17 Date the gift was received for 95G1
RDATE_18 Date the gift was received for 95GK
RDATE_19 Date the gift was received for 95CC
RDATE_20 Date the gift was received for 95WL
RDATE_21 Date the gift was received for 95X1
RDATE_22 Date the gift was received for 95XK
RDATE_23 Date the gift was received for 94FS
RDATE_24 Date the gift was received for 94NK
RAMNT_3 Dollar amount of the gift for 96NK
RAMNT_4 Dollar amount of the gift for 96TK
RAMNT_5 Dollar amount of the gift for 96SK
RAMNT_6 Dollar amount of the gift for 96LL
RAMNT_7 Dollar amount of the gift for 96G1
RAMNT_8 Dollar amount of the gift for 96GK
RAMNT_9 Dollar amount of the gift for 96CC
RAMNT_10 Dollar amount of the gift for 96WL
RAMNT_11 Dollar amount of the gift for 96X1
RAMNT_12 Dollar amount of the gift for 96XK
RAMNT_13 Dollar amount of the gift for 95FS
RAMNT_14 Dollar amount of the gift for 95NK
RAMNT_15 Dollar amount of the gift for 95TK
RAMNT_16 Dollar amount of the gift for 95LL
RAMNT_17 Dollar amount of the gift for 95G1
RAMNT_18 Dollar amount of the gift for 95GK
RAMNT_19 Dollar amount of the gift for 95CC
RAMNT_20 Dollar amount of the gift for 95WL
RAMNT_21 Dollar amount of the gift for 95X1
RAMNT_22 Dollar amount of the gift for 95XK
RAMNT_23 Dollar amount of the gift for 94FS
RAMNT_24 Dollar amount of the gift for 94NK
-------------------------- -------------------------------------------------
The following fields are summary variables from
the giving history file.
RAMNTALL Dollar amount of lifetime gifts to date
NGIFTALL Number of lifetime gifts to date
CARDGIFT Number of lifetime gifts to card promotions to date
MINRAMNT Dollar amount of smallest gift to date
MINRDATE Date associated with the smallest gift to date
MAXRAMNT Dollar amount of largest gift to date
MAXRDATE Date associated with the largest gift to date
LASTGIFT Dollar amount of most recent gift
LASTDATE Date associated with the most recent gift
FISTDATE Date of first gift
NEXTDATE Date of second gift
TIMELAG Number of months between first and second gift
AVGGIFT Average dollar amount of gifts to date
-------------------------- -------------------------------------------------
CONTROLN Control number (unique record identifier)
TARGET_B Target Variable: Binary Indicator for Response to
97NK Mailing
TARGET_D Target Variable: Donation Amount (in $) associated
with the Response to 97NK Mailing
HPHONE_D Indicator for presence of a published home
phone number
-------------------------- -------------------------------------------------
(See the section on RFA for the meaning of the
codes)
RFA_2R Recency code for RFA_2
RFA_2F Frequency code for RFA_2
RFA_2A Donation Amount code for RFA_2
MDMAUD_R Recency code for MDMAUD
MDMAUD_F Frequecy code for MDMAUD
MDMAUD_A Donation Amount code for MDMAUD
-------------------------- -------------------------------------------------
CLUSTER2 Classic Cluster Code (a nominal symbolic field)
GEOCODE2 County Size Code
======================================================================
EPSILON CONFIDENTIAL EPSILON CONFIDENTIAL EPSILON CONFIDENTIAL
INFORMATION LISTED BELOW IS AVAILABLE UNDER THE TERMS OF THE
CONFIDENTIALITY AGREEMENT
EPSILON CONFIDENTIAL EPSILON CONFIDENTIAL EPSILON CONFIDENTIAL
======================================================================