Name Prefix
Dropdown
Titles (Mr. Rev. Mx.)
Name Suffix
Must match suffix names exactly
Household ID
names, numbers (up to 9 digits), or a combination of both
Household Primary Contact
TRUE
only include next to Primary Contact; do not include False next to those who aren't
Home Email
Any Text
multiples can be separated by a semicolon (;)
Work Email
Any Text
multiples can be separated by a semicolon (;)
Other Email
Any Text
multiples can be separated by a semicolon (;)
Home Phone Number
any length, with or without dashes
multiples can be separated by a semicolon (;)
Work Phone Number
any length, with or without dashes
multiples can be separated by a semicolon (;)
Mobile Phone Number
any length, with or without dashes
multiples can be separated by a semicolon (;)
Pager Phone Number
any length, with or without dashes
multiples can be separated by a semicolon (;)
Fax Phone Number
any length, with or without dashes
multiples can be separated by a semicolon (;)
Skype Phone Number
any length, with or without dashes
multiples can be separated by a semicolon (;)
Other Phone Number
any length, with or without dashes
multiples can be separated by a semicolon (;)
Home Address Street Line 1
Any Text
Home Address Street Line 2
Any Text
Home Address City
Any Text
Home Address State
abbreviation or full name
Home Address Zip Code
Any Text
Work Address Street Line 1
Any Text
Work Address Street Line 2
Any Text
Work Address City
Any Text
Work Address State
abbreviation or full name
Work Address Zip Code
Any Text
Other Address Street Line 1
Any Text
Other Address Street Line 2
Any Text
Other Address City
Any Text
Other Address State
abbreviation or full name
Other Address Zip Code
Any Text
Birthdate
any combination of:
YYYY-MM-DD
MM/DD/YYYY
follow the formatting from your Accounts Localization Setting
If the person doesn’t have a birth year, use 1885; this shows no age in People.
Anniversary
any combination of:
YYYY-MM-DD
MM/DD/YYYY
follow the formatting from your Accounts Localization Setting
must have Marital Status as Married or Widowed
Grade
-1 to 12 (where -1 is Pre-K, 0 is Kindergarten)
1st, 2nd, 3rd, etc.
not case-sensitive
School Type
Elementary, Middle School, High School, College, Other
School Names
Dropdown
Names of local educational institutions K-Post Secondary
Gender
M/F
Male/Female
not case-sensitive
Child
Y/N
Yes/No
True/False
1/0
not case-sensitive
Campus
Must match campus names exactly