Person Object

See also LookupTable Object and Fields on Organization Object

Column

DataType

UpdateField

AddressLineOne

str

AddressLineTwo

str

AltName

str

yes

CellPhone

str

yes

CellPhoneAC

str

CellPhoneLU

str

CheckInNotes

str

CityName

str

Comments

str

CountryName

str

EmailAddress

str

yes

EmailAddress2

str

yes

EmployerOther

str

yes

FirstName

str

yes

HomePhone

str

LastName

str

yes

LetterStatusNotes

str

MaidenName

str

yes

MiddleName

str

yes

Name

str

Name2

str

NickName

str

yes

OccupationOther

str

yes

OtherNewChurch

str

yes

OtherPreviousChurch

str

yes

PreferredName

str

PrimaryAddress

str

PrimaryAddress2

str

PrimaryCity

str

PrimaryCountry

str

PrimaryState

str

PrimaryZip

str

SchoolOther

str

yes

StateCode

str

StreetName

str

SuffixCode

str

yes

TitleCode

str

yes

WorkPhone

str

yes

WorkPhoneLU

str

ZipCode

str

AddressTypeId

int

Age

int

BaptismStatusId

int

BaptismTypeId

int

BibleFellowshipClassId

int

BirthDay

int

yes

BirthMonth

int

yes

BirthYear

int

yes

CampusId

int

yes

ContributionOptionsId

int

CreatedBy

int

DecisionTypeId

int

DropCodeId

int

EntryPointId

int

EnvelopeOptionsId

int

FamilyId

int

GenderId

int

yes

Grade

int

yes

InterestPointId

int

JoinCodeId

int

LetterStatusId

int

MaritalStatusId

int

yes

MemberStatusId

int

ModifiedBy

int

NewMemberClassStatusId

int

OriginId

int

PeopleId

int

PhonePrefId

int

PictureId

int

PositionInFamilyId

int

yes

PrimaryBadAddrFlag

int

PrimaryResCode

int

ResCodeId

int

SpouseId

int

AddressFromDate

date

AddressToDate

date

BaptismDate

date

BaptismSchedDate

date

BDate

date

CreatedDate

date

DeceasedDate

date

yes

DecisionDate

date

DropDate

date

JoinDate

date

LastContact

date

LetterDateReceived

date

LetterDateRequested

date

ModifiedDate

date

NewMemberClassDate

date

OriginDate

date

WeddingDate

date

yes

BadAddressFlag

bool

ChristAsSavior

bool

ContributionsStatement

bool

CustodyIssue

bool

DoNotCallFlag

bool

yes

DoNotMailFlag

bool

yes

DoNotPublishPhones

bool

yes

DoNotVisitFlag

bool

yes

ElectronicStatement

bool

HasDuplicates

bool

IsDeceased

bool

MemberAnyChurch

bool

OkTransport

bool

ReceiveSMS

bool

yes

SendEmailAddress1

bool

SendEmailAddress2

bool

BaptismStatus

LookupTable

BaptismType

LookupTable

Campus

LookupTable

ContributionStatementOption

LookupTable

DecisionType

LookupTable

DiscoveryClassStatus

LookupTable

DropType

LookupTable

EntryPoint

LookupTable

EnvelopeOption

LookupTable

Families

LookupTable

FamilyPosition

LookupTable

Gender

LookupTable

InterestPoint

LookupTable

JoinType

LookupTable

MaritalStatus

LookupTable

MemberLetterStatus

LookupTable

MemberStatus

LookupTable

Origin

LookupTable

ResidentCode

LookupTable

BFClass

Organizations