| ID |
int |
Unique Person ID |
|
Salutation |
string |
| TitleID |
int |
Person's Title ID. Use "SelectTitles" to get a list of available titles. |
| FirstName |
string |
Person's First Name |
| LastName |
string |
Person's Last Name |
| BirthDate |
date |
Person's Birth Date. Format: YYYY-MM-DD |
| IsCompany |
int |
0 = Person Profile. 1 = Company Profile |
| Company |
string |
Where person works |
| GenderID |
int |
1 = Male. 2 = Female. |
| MaritalStatusID |
int |
Person's Marital Status. Use Select Marital Statuses to get a list of available marital statuses. |
| ChurchID |
int |
Person's Church. Select Churches to get a list of available churches. |
| Occupation |
string |
Person's Occupation |
| DonorID |
string |
Person's External Donor ID from a donor program. |
| ProfilePhoto |
string |
Path to Person Profile Photo. Add "http://www.ministrysync.com" in front of path to get it. |
| ST_DonorGUID |
string |
Donor ID assigned by Stewardship Technology. |
| TitleName |
string |
Person's Title Name |
| Address1 |
string |
Person's Address 1 |
| Address2 |
string |
Person's Address 2 |
| City |
string |
Person's City |
| StateID |
int |
Person's State and Country. Select states and Select Countries to get a list of State ID's |
| StateName |
string |
Person's State Name |
| State |
string |
Person's State Abbr. Code |
| CountryID |
int |
Person's Country ID. Use Select Countries to get a list of available countries. |
| Country |
string |
Person's Country Name |
| CountryCode |
string |
Person's two letter country code |
| PostalCode |
string |
Person's Postal Code |
| Zip4 |
string |
Person's Zip+4 |
| Gender |
string |
Male or Female |
| MaritalStatus |
string |
Person's Marital Status Name |
| ChurchName |
string |
Person's assigned Church Name |
| Pastor |
string |
Person's assigned Church Pastor Name |
| IsPartnerChurch |
int |
0 = No. 1 = Yes. |
| PhoneNumber |
string |
Person's Primary Phone Number |
| PhoneDescription |
string |
Person's Phone Description (Home, Work, Cell, Pager, Church, Fax) |
| EmailAddress |
string |
Person's Primary Email Address |
| EmailDescription |
string |
Person's Email Description (Personal, Work, Other) |
| MergedTitle |
string |
Person's Merged Title with Spouse |
| MergedSalutation |
string |
Person's Merged Salutation with Spouse |
| MergedName |
string |
Person's Merged Name with Spouse |
| CreatedPersonID |
int |
Person ID who created this person profile. |
| CreatedDate |
datetime |
Date and time the person was created. |
| LastUpdatedPersonID |
string |
Person ID who last updated this person profile. |
| LastUpdatedDate |
datetime |
Date and time the person was last updated. |
| Deleted |
int |
0 = No. 1 = Yes. |
| DeletedPersonID |
int |
Person ID who deleted this person profile. |
| DeletedDate |
datetime |
Date and time the person was deleted. |