| Grouping |
Field Name |
Comments |
| Name |
IsOrganization |
| True |
churches, companies, organizations |
| False |
individuals |
|
| Name
(IsOrganization = "False")
|
Title |
|
| FirstName |
|
| MiddleName |
|
| LastName |
|
| Suffix |
ex. Jr., Sr., II., III. |
| SpouseTitle |
|
| Spouse |
spouse first name |
| SpouseMiddleName |
|
| SpouseLastName |
only if different than LastName |
| Name
(IsOrganization = "True")
|
CompanyName |
If IsOrganization = "False" then CompanyName refers to where the individual works. |
| Address |
SelectedMailingAddress |
| 1 |
Home |
| 2 |
Business |
| 3 |
Other |
|
| Home Address |
HomeAddress |
|
| HomeCity |
|
| HomeState |
|
| HomeZip |
|
| HomeCountry |
|
| Business Address |
BusinessAddress |
|
| BusinessCity |
|
| BusinessState |
|
| BusinessZip |
|
| BusinessCountry |
|
| Other Address |
OtherAddress |
|
| OtherCity |
|
| OtherState |
|
| OtherZip |
|
| OtherCountry |
|
| Phone |
AssistantPhone |
|
| BusinessPhone |
|
| BusinessPhone2 |
|
| BusinessFax |
|
| CallbackPhone |
|
| CarPhone |
|
| CompanyMainPhone |
|
| HomePhone |
|
| HomePhone2 |
|
| HomeFax |
|
| ISDNPhone |
|
| MobilePhone |
|
| OtherPhone |
|
| OtherFax |
|
| PagerNumber |
|
| PrimaryPhone |
|
| RadioPhone |
|
| TelexPhone |
|
| TTYTDDPhone |
|
| Internet |
Email1 |
|
| Email2 |
|
| Email3 |
|
| UserCertificate |
|
| PersonalHomePage |
|
| BusinessHomePage |
|
| NetMeetingAlias |
|
| NetMeetingServer |
|
| ComputerNetworkName |
|
| FTPSite |
|
| InternetFreeBusyAddress |
|
| Notes |
Notes |
|
| Greetings |
FullName |
Formal greeting used to address envelopes |
| Greeting |
Greeting used inside letters |
| ShortName |
Formatted: FirstName and Spouse LastName |
| MPD |
CreatedDate |
When the contact was first added to the database |
| OrgAccountIDs |
Account ids associated with this contact by the organization. Multiple IDs can be separated by a comma.
Example: 12345678, 87654321, 18273645
|
| Deceased |
True/False |
| DirectDeposit |
True/False |
| MPDPhaseID |
| 0 |
n/a |
| 10 |
Never Contacted |
| 20 |
Ask in Future |
| 30 |
Call for Appt |
| 40 |
Appt Scheduled |
| 50 |
Call for Decision |
| 60 |
PARTNER-Financial |
| 70 |
PARTNER-Special |
| 80 |
PARTNER-Pray |
| 90 |
Not Interested |
| 100 |
Never Ask |
|
| NeverAsk |
| True |
Never ask this contact for support |
| False |
Allow asking this contact for support |
|
| NextAsk |
Date when you should ask this contact for support |
| PledgeAmount |
If amount is greater than zero, PledgeFrequency must be greater than zero. |
| PledgeFrequency |
| 0 |
<none> |
| 1 |
monthly |
| 2 |
bi-monthly |
| 3 |
quarterly |
| 4 |
quad-monthly |
| 6 |
semi-annual |
| 12 |
annual |
| 24 |
biannual |
|
| PledgeReceived |
| True |
First check has been received for this pledge |
| False |
First check has not been received for this pledge |
|
| PledgeStartDate |
Date when the pledge started |
| ReferredBy |
Primary referrer |
| ReferredByList |
All those who have referred you to this contact. Each referrer should be on their own line (separated by a carriage return). |
| Region |
|
| SendNewsletter |
| True |
Send this contact a prayer letter |
| False |
Don't send this contact a prayer letter |
|
| Magazine |
True/False |
| LikelyToGive |
| 0 |
Unassigned |
| 1 |
Least Likely |
| 2 |
Likely |
| 3 |
Most Likely |
|
| Personal / Professional |
AssistantName |
|
| Categories |
|
| Children |
|
| ChurchName |
|
| Department |
|
| FamilyLevel |
| 0 |
<None> |
| 10 |
Very Extended |
| 20 |
Cousin |
| 30 |
Uncle/Aunt |
| 40 |
Grandparent |
| 50 |
Nephew/Niece |
| 60 |
Sibling |
| 70 |
Parent |
| 80 |
Grandchild |
| 90 |
Son/Daughter |
| 100 |
Immediate |
|
| FamilySide |
|
| Hobby |
|
| JobTitle |
|
| ManagerName |
|
| NickName |
|
| OfficeLocation |
|
| Profession |
|
| SpouseCompanyName |
|
| SpouseHobby |
|
| SpouseNickName |
|
| SpouseProfession |
|
| Anniversary / Birthday |
AnniversaryDay |
|
| AnniversaryMonth |
|
| AnniversaryYear |
|
| BirthdayDay |
|
| BirthdayMonth |
|
| BirthdayYear |
|
| SpouseBirthdayDay |
|
| SpouseBirthdayMonth |
|
| SpouseBirthdayYear |
|
| User |
User1 |
|
| User2 |
|
| User3 |
|
| User4 |
|
| UserStatus |
|