Person table

•
Environment: cloud
• 3 minutes to read
 • 3 minutes to read

Person fields. Key constants are in ``BulkUpdateSystem.PersonFieldValueKeys`.

Person

FieldValueKeys

OperationTypes

Expected Field Values

Affected Properties

Position

SelectOne, Clear

Values Count = 0 or 1

Values[0] = (int) PositionIdx

Position

Number

Set, Clear, SearchAndReplace, RegEx

Values Count = 0 to 7

Set: Values[0] = (string)

Clear: Clears value

SearchAndReplace:
Values[1] = searchString
Values[2] = replaceString
Values[3] = options

RegEx:
Values[4] = expression
Values[5] = replace with
Values[6] = options

Number

Title

Title

MrMrs

MrMrs

Salutation

Salutation

FirstName

Firstname

MiddleName

MiddleName

LastName

Lastname

AddressAddress1

Address.Address1

AddressAddress2

Address.Address2

AddressAddress3

Address.Address3

AddressZipCode

Address.Zipcode

AddressZipCity

Address.City

AddressCounty

Address.County

AddressState

Address.State

PersonNoMail

Set

Values Count = 1

Values[0] = (int) 0 or 1
0 = unChecked
1 = Checked

Nomailing

AddInterests

addItems

Values Count = 1…n

Values[n] = (int) InteresItemtId

Selects each interest.

InterestHelper

ActiveInterests

RemoveInterest

removeItems

Values Count = 1…n

Values[n] = (int) InteresItemtId

Deselects each interest.

InterestHelper

ActiveInterests

AddSubscriptions

addItems

Values Count = 1…n

Values[0] = (int) MailingTypeId

Deletes a record in the MailingTypeReservation table.

MailingTypeReservations

RemoveSubscriptions

 removeItems

Values Count = 1...n

Values[0] = (int) MailingTypeId

Adds a record to the MailingTypeReservation table.

 MailingTypeReservations

LegalBasis

 Add, Remove

Values Count = 0 to 5

Add:
if value doesn’t already exist
Values[0] = (int) consentPurposeId
Values[1] = (int) legalBaseId

Optional:

Values[2] = (int) consentSourceId
Values[3] = (string) comment

Remove:

Clears all existing rows

Values[0] = *not used
Values[1] =*not used
Values[2] = *not used
Values[3] =*not used
Values[4] = (int) consentPurposeId

 ConsentPersons

UseAsMailingAddress

Check, Toggle

Values Count = 1

Check:
Values[0] = (int)
0 = Use company address
1 = Use person address

Toggle: invert current

Usepersonaddress

Retired

Set

Values Count = 1

Values[0] = (int)
0 = not retired
1 = retired

Retired

BirthDate

Set, Clear

Values Count = 1

Set:
Values[0] = (Date)
Format: InvariantInfo

Clear:
Day = 0, Month = 0,  Year = 0

DayOfBirth

MonthOfBirth

YearOfBirth

PersonCountry

SelectOne

Values Count = 1

Values[0] = (int) CountryId

Country

Url

Add, Remove, ReplaceWith, Clear, SearchAndReplace, RegEx

Values Count = 0 to 8

Add:
if value doesn’t already exist
Values[0] = (string) value
Values[1] = (string) description

Remove:
only one needs to match
Values[0] = (string) value,
or...
Values[1] = (string) description

ReplaceWith:
locates row with Rank =1 and updates it, removes all others. Updates using:
Values[0] = (string) value
Values[1] = (string) description

Clear:
Clears all existing rows

SearchAndReplace:
works on value only, not description.
Values[2] = searchString
Values[3] = replaceString
Values[4] = Search Options

RegEx:
works on value only, not description.
Values[5] = expression
Values[6] = replace with
Values[7] = Search Options

Urls

value = UrlAddress

Email

Emails
value = EmailAddress

MobilePhone

MobilePhones

value = Phone

DirectPhone

OfficePhones

value = Phone

PrivatePhone

PrivatePhones

value = Phone

OtherPhone

Pagers

value = Phone

DirectFax

Faxes

value = Phone

See User-Defined Fields.