Masterfile Maintenance
Masterfile Maintenance
BlueBook (Statistics)
inTouch / CRM Dashboard
Database Queries & Files
Pledge Administrator
Batch Processing
Web Reports / Filing Cabinet
Standard Database Reports
Promo History Upload
Planned Giving Inquiry
Masterfile Maintenance
BlueBook (Statistics)
inTouch / CRM Dashboard
Database Queries & Files
Pledge Administrator
Batch Processing
Web Reports / Filing Cabinet
Standard Database Reports
Promo History Upload
Planned Giving Inquiry
Trent Johnson
Account
Logout
Menu
W12Z Database
8,188,274 accounts
Upload Account List
Add Account
New Search
Load Saved Search
Nicole Ruiz Search
Lucy Martin Search
Account #
Check Digit
Alternate ID#
Email Address
Honor/Memorial
Phone Number
Zip Code
Last Name
Name Contains
Company
Address or City Contains
City
State/Province
Foreign Country
ARUBA DUTCH CARIBBEAN
AFGHANISTAN
ALBANIA
ALGERIA
AMERICA
ANDORRA
ANGOLA
ANGUILLA
ANTIGUA & BARBUDA
ANTARCTICA
ARGENTINA
ARMENIA
ASCENSION
AUSTRALIA
AUSTRIA
AZERBAIJAN
AZORES
BAHAMAS
BAHRAIN
BANGLADESH
BARBADOS
BELARUS
BELGIUM
BELIZE
BENIN
BERMUDA
BHUTAN
BOLIVIA
BOSNIA-HERZEGOVINA
BOTSWANA
BRAZIL
BRITISH VIRGIN ISLANDS
BRUNEI DARUSSALAM
BULGARIA
BURKINA FASO
BURMA (MYANMAR)
BURUNDI
CAMBODIA
CAMEROON
CANADA
CANARY ISLANDS
CHANNEL ISLANDS
CAPE VERDE
CAYMAN ISLANDS
CENTRAL AFRICAN REPUBLIC
CENTRAL AMERICA
CEYLON
CHAD
CHILE
CHRISTMAS ISLANDS
COCOS ISLANDS
CHINA
COLOMBIA
COMOROS
CONGO
COOK ISLANDS
CORSICA
COSTA RICA
CROATIA
CUBA
CURACAO
CYPRUS
CZECH REPUBLIC
DENMARK
DJIBOUTI
DOMINICA
DOMINICAN REPUBLIC
DUBAI
EAST TIMOR
ECUADOR
EL SALVADOR
EGYPT
ERITREA
ETHIOPIA
ENGLAND
EQUATORIAL GUINEA
ESTONIA
EUROPE
FALKLAND ISLANDS
FAROE ISLANDS
FRENCH GUIANA
FIJI
FINLAND
FRANCE
FRENCH POLYNESIA
GABON
GAMBIA
REPUBLIC OF GEORGIA
GERMANY
EAST GERMANY
WEST GERMANY
GHANA
GIBRALTAR
GREAT BRITAIN
GREECE
GREENLAND
GRENADA
GUADELOUPE
GUATEMALA
GUERNSEY
GUINEA
GUINEA-BISSAU
GUYANA
HAITI
HOLLAND
HONDURAS
HONG KONG
HUNGARY
ICELAND
INDIA
INDONESIA
IRAN
IRAQ
IRELAND
NORTHERN IRELAND
ISLE OF LEWIS
ISLE OF MAN
ISRAEL
ITALY
COTE D'IVOIRE (IVORY COAST)
IVORY COAST AND COTE DIVOIRE
JAMAICA
JAPAN
JERSEY
JORDAN
KAMPUCHEA
KAZAKHSTAN
KIRIBATI
KENYA
DEM. PEOPLE'S REP. OF KOREA
KOREA, DEM. PEOPLE'S REP. (N)
KOREA, REPUBLIC OF (SOUTH)
NORTH KOREA
SOUTH KOREA
KOREA
KOSOVO
KUWAIT
KYRGYSTAN
LAOS
REPUBLIC OF LAO
LIBYAN ARAB JAMAHIRIYA
LATVIA
LEBANON
LEEWARD ISLANDS
LESOTHO
LIBERIA
LIBYA
LIECHTENSTEIN
LITHUANIA
LONDON
LUXEMBOURG
MACAU
MACAO
MACEDONIA, REPUBLIC OF
MADAGASCAR
MADEIRA ISLANDS
MALAWI
MALAYSIA
MALDIVES
MALI
MALTA
MARSHALL ISLANDS
MARTINIQUE
MAURITANIA
MAURITIUS
MEXICO
MICRONESIA
MOLDOVA
MONACO
MONGOLIA
MONTENEGRO
MONTSERRAT
MOROCCO
MOZAMBIQUE
MYANMAR
NAMIBIA
NAURU
NEPAL
NETHERLANDS
NETHERLANDS ANTILLES
NEW CALEDONIA
NEW DELHI
NEW GUINEA
NEW ZEALAND
NICARAGUA
NIGER
NIGERIA
NIUE
NORWAY
NORTH AMERICA
OMAN
PAKISTAN
PALESTINE
PALAU
PANAMA
PAPUA-NEW GUINEA
PARAGUAY
PACIFIC ISLANDS
PERU
PHILIPPINES
PITCAIRN ISLANDS
POLAND
PORTUGAL
QATAR
REUNION
ROMANIA
RWANDA
RUSSIAN FEDERATION
RUSSIA
SICILY
ST CHRISTOPHER(ST KITTS)/NEVIS
ST. LUCIA
ST. HELENA
SANTA CRUZ ISLANDS
SAMOA
SAO TOME & PRINCIPE
ST. PIERRE & MIQUELON
SCOTLAND
SENEGAL
ST. VINCENT & GRENADINES
SAN MARINO
SLOVENIA
SOLOMON ISLANDS
SAUDI ARABIA
SOUTH VIETNAM
SOUTH AFRICA
SOUTH AMERICA
SERBIA-MONTENEGRO
SEYCHELLES
SPAIN
SIERRA LEONE
SINGAPORE
SLOVAK REPUBLIC
SLOVAKIA
SURINAME
SWAZILAND
SOMALIA
SWEDEN
SWITZERLAND
SYRIA
SRI LANKA
SUDAN
SOUTH SUDAN
TAIWAN
TAJIKISTAN
TANZANIA
THAILAND
TIMOR LESTE
TOKELAU
TONGA
TOGO
TRANSNISTRIA
TRINIDAD & TOBAGO
TRISTAN DA CUNHA
TUNISIA
TURKEY
TURKMENISTAN
TURKS & CAICOS ISLANDS
TUVALU
UGANDA
UNITED ARAB EMIRATES
UNITED KINGDOM
UKRAINE
UPPER VOLTA
URUGUAY
UZBEKISTAN
VANUATU
VATICAN CITY
VENEZUELA
VIETNAM
WALES
WALLIS & FUTUNA ISLANDS
WEST AFRICA
WEST INDIES
WEST MALAYSIA
WESTERN SAMOA
WESTERN SAHARA
YEMEN
SOUTH YEMEN
NORTH YEMEN
YUGOSLAVIA
ZAIRE
ZALAU
ZAMBIA
ZIMBABWE
CRM Task Type
CRM Category
CRM Date Range
to
CRM Task Status
Incomplete
Archived
Complete
CRM Priority
High
Normal
Low
MRC Date
HPC Amount
Flag
NO RECEIPT/ACKNOWL.
DECEASED
EMAIL ONLY
DONOVAN DONOR
1 MAILING PER YEAR
2 MAILINGS PER YEAR
NEWSLETTERS ONLY
YE TAX RECEIPTS ONLY
CALENDAR ONLY
NAME LABELS ONLY
MAJOR DONOR
MONTHLY GIVER
NO CREDIT CARD OFFERS
NO CALENDARS
NO NAME LABELS
NO NEWSLETTERS
NO GIFTS/PREMIUMS
NOT DELIVERABLE
NCOA UNDELIVERABLE
DO NOT MERGE/CONSOLIDATE
DO NOT CALL
DO NOT RENT
DO NOT MAIL
DO NOT EMAIL
ALUMNI
BOARD MEMBER
VOLUNTEER
Name Type
A - AGENCY
B - BUSINESS
C - CHURCH
D - DM
F - FOUNDATION
G - GOVERNMENT
N - NON-SECTARIAN
V - VENDOR
X - INTERNAL USE
Cell Code
A0 - 0-6M/1 DM
A1 - 0-6M/1 DM/.01-9.99
A2 - 0-6M/1 DM/10-14
A3 - 0-6M/1 DM/15-24
A4 - 0-6M/1 DM/25-49
A5 - 0-6M/1 DM/50-99
A6 - 0-6M/1 DM/100-249
A7 - 0-6M/1 DM/250-499
A8 - 0-6M/1 DM/500-999
A9 - 0-6M/1 DM/1000+
B0 - 7-12M/1 DM
B1 - 7-12M/1 DM/.01-9.99
B2 - 7-12M/1 DM/10-14
B3 - 7-12M/1 DM/15-24
B4 - 7-12M/1 DM/25-49
B5 - 7-12M/1 DM/50-99
B6 - 7-12M/1 DM/100-249
B7 - 7-12M/1 DM/250-499
B8 - 7-12M/1 DM/500-999
B9 - 7-12M/1 DM/1000+
C0 - 13-24M/1 DM
C1 - 13-24M/1 DM/.01-9.99
C2 - 13-24M/1 DM/10-14
C3 - 13-24M/1 DM/15-24
C4 - 13-24M/1 DM/25-49
C5 - 13-24M/1 DM/50-99
C6 - 13-24M/1 DM/100-249
C7 - 13-24M/1 DM/250-499
C8 - 13-24M/1 DM/500-999
C9 - 13-24M/1 DM/1000+
D0 - 25-36M/1 DM
D1 - 25-36M/1 DM/.01-9.99
D2 - 25-36M/1 DM/10-14
Donor Source
AA - AGENCY
AP - ARTIST PROGRAM
CF - CROWD FUNDING
CH - CHURCH
DE - MAJOR DONOR
DM - DIRECT MAIL
EM - EMPLOYEE MATCHES/INVESTMENTS
EV - EVENT
FD - FOUNDATIONS
GV - GOVERNMENT
IG - INTERNET GIVING
OT - OTHER
PH - PHONE - INBOUND
PS - PERSONAL SOLICITATION
RA - RADIO
RE - REFERRAL
SD - SEED
SF - SUPPRESSION FILE
ST - STAFF
TM - TELEMARKETING - OUTBOUND
TR - TRUSTS/ESTATES
TV - TELEVISION
UN - UNKNOWN
WM - WHITE MAIL
Caseworker
10 - BD
11 - GF
12 - GX
D - DM
20 - BS
30 - CM
35 - CX
40 - LS
50 - JO
60 - FD
70 - WS
80 - VB
90 - VX
91 - PC
92 - PX
93 - JA
94 - JX
Status
M - MONTHLY GIVER
P - PARTNER
V - VENDOR
Matching?
MC - MATCHING GIFT COMPANY
MD - MATCHING GIFT FOUNDATION
Occupation
001 - HOMEMAKER
002 - TEACHER
003 - ATTORNEY
004 - DOCTOR
005 - DENTIST
Cong District
AL - AT LARGE
01 - CONGRESSIONAL DISTRICT 01
02 - CONGRESSIONAL DISTRICT 02
03 - CONGRESSIONAL DISTRICT 03
04 - CONGRESSIONAL DISTRICT 04
05 - CONGRESSIONAL DISTRICT 05
06 - CONGRESSIONAL DISTRICT 06
07 - CONGRESSIONAL DISTRICT 07
08 - CONGRESSIONAL DISTRICT 08
09 - CONGRESSIONAL DISTRICT 09
10 - CONGRESSIONAL DISTRICT 10
11 - CONGRESSIONAL DISTRICT 11
12 - CONGRESSIONAL DISTRICT 12
13 - CONGRESSIONAL DISTRICT 13
14 - CONGRESSIONAL DISTRICT 14
15 - CONGRESSIONAL DISTRICT 15
16 - CONGRESSIONAL DISTRICT 16
17 - CONGRESSIONAL DISTRICT 17
18 - CONGRESSIONAL DISTRICT 18
19 - CONGRESSIONAL DISTRICT 19
Add a Search Filter
Select by ID
Alternate ID#
Email Address
Honor/Memorial
Phone Number
Select by Demographic Data
Zip Code
Last Name
Name Contains
Company
Address or City Contains
City
State/Province
Foreign Country
CRM Task Type
CRM Category
CRM Date Range
CRM Task Status
CRM Priority
MRC Date
HPC Amount
Flag
Name Type
Cell Code
Donor Source
Caseworker
Status
Matching?
Occupation
Cong Dist
Search
Save
this Search
Reset
Search
Trent Johnson
Back
Account
Logout
Save this Search
Name of Search
Set as My Default Search
Save Values
Save