The following table lists all possible columns in the Constituent360 database against which tries to match in processing a Custom Constituent Import. Each column is described and the type of data it requires specified. Note that you do not have to specify field headings that exactly match those shown in this list.
Warning: You must define at least two valid fields in the import file for an update. If you fail to do so, the upload will fail.
| Column | Column Group | Description |
|---|---|---|
| Accept Email |
Yes (or any one of Y, 1, True, T) if the constituent accepts email.
No (or any one of N, 0, False, F) if the constituent does not accept email. Note: Flip Value (Yes means No) appears under the More Information column. This permits the administrator to allow for a user database field configuration where you would indicate Yes, the constituent did not accept email. Flipping that value would "translate" that to 0 and indicate, No, the constituent did not accept email. |
|
| Accept Mail | Address |
Yes (or any one of Y, 1, True, T) if the constituent accepts mail.
No (or any one of N, 0, False, F) if the constituent does not accept mail. Note: Flip Value (Yes means No) appears under the More Information column. This permits the administrator to allow for a user database field configuration where you would indicate Yes, the constituent did not accept mail. Flipping that value would "translate" that to 0 and indicate, No, the constituent did not accept mail. |
| Affiliate Assignment | Biographical Information |
Value indicating whether constituent is to be associated with an affiliate.
The number 0 or 1: 0 = AUTO (automatic assignment to unit) 1 = MANUAL (automatic assignment disabled for this constituent) |
| Affiliate Code | Biographical Information | Name of affiliate, if any, with which constituent is associated. Allows 128 letters and numbers maximum. |
| Alternate 1 Address Type | Address | Standard choices are Home or Business, but your site might be customized with other values. Allows 20 letters and numbers maximum. |
| Alternate 2 Address Type | Address | Standard choices are Home or Business, but your site might be customized with other values. Allows 20 letters and numbers maximum. |
| Alumnus | Significant Other |
Whether the constituent's significant other attended the same school.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| Relationship 1: Alumnus | Relationships |
Whether the person in the relationship attended the same school as the constituent.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| Relationship 2: Alumnus | Relationships |
Whether the person in the relationship attended the same school as the constituent.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| Relationship 3: Alumnus | Relationships |
Whether the person in the relationship attended the same school as the constituent.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| Relationship 4: Alumnus | Relationships |
Whether the person in the relationship attended the same school as the constituent.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| Relationship 5: Alumnus | Relationships |
Whether the person in the relationship attended the same school as the constituent.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| Relationship 6: Alumnus | Relationships |
Whether the person in the relationship attended the same school as the constituent.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| Relationship 7: Alumnus | Relationships |
Whether the person in the relationship attended the same school as the constituent.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| Relationship 8: Alumnus | Relationships |
Whether the person in the relationship attended the same school as the constituent.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| Boolean #1 (through Boolean #50) | Additional Information |
Custom information to be communicated as True/False or Yes/No for any administrator-defined purpose. Up
to
50 custom "booleans" are supported. The number 0 or 1:
0 = No/False 1 =Yes/True |
| C3 Member | Biographical Information |
Value indicating whether constituent is a member of a 501(c)(3) organization.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| C3 First Activity Date | Biographical Information | Date of constituent's first interaction. |
| C3 Origin | Biographical Information |
How the constituent first entered the system. Number:
0 = UNDEFINED 1 = SELF_REG 2 = ADMIN_REG 3 = PROSPECT_LIST 4 = EXCHANGE 5 = QUICK_REG 6 = DONATION 7 = JOINT_DONATION (unused) 8 = TRIBUTE (unused) 9 = MEMORIAL (unused) 10 = GIFT_NOTIF (unused) 11 = TICKET 12 = GUEST (unused) 13 = ALERT 14 = TELL_A_FRIEND 15 = FOAF (TeamRaiser Donor) (DEPRECATED) 16 = UNKNOWN 17 = AUTOREG (pre-Molokini auto-reg) 18 = NEWS_CONTRIBUTION 19 = TR_PARTICIPANT (TeamRaiser Participant) 20 = TR_FRIEND (TeamRaiser Friend) 21 = FORWARDED_EMAIL 22 = SURVEY_PARTICIPANT 23 = PREREGISTRATION 24 = ECOMMERCE_PURCHASE 25 = LDAP (auto-create on login attempt) 26 = RSVP (to an event) 27 = EMAIL UPLOAD 28 = SENT ECARD 29 = TEAMRAISER COMPANY CONTACT 30 = TRIBUTES CHAMPION 31 = TRIBUTES FUND 32 = AUCTION UPLOAD 33 = WIDGETS 34 = TEAMRAISER FAMILY PARTICIPANT 50 = PERSONAL EVENTS HOST 51 = PERSONAL EVENTS ATTENDEE 52 = PERSONAL EVENTS CONTACT 100 = IMPORT |
| C3 Origin Reference ID | Biographical Information | User-defined identifier for cross-referencing the C3 Origin between Luminate and user databases. Allows 11 digits maximum. |
| C4 Member | Biographical Information |
Value indicating whether constituent is a member of a 501(c)(4) organization.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| C4 First Activity Date | Biographical Information | Date of constituent's first interaction. |
| C4 Origin | Biographical Information |
How the constituent first entered the system.
Number: 0 = UNDEFINED 1 = SELF_REG 2 = ADMIN_REG 3 = PROSPECT_LIST 4 = EXCHANGE 5 = QUICK_REG 6 = DONATION 7 = JOINT_DONATION (unused) 8 = TRIBUTE (unused) 9 = MEMORIAL (unused) 10 = GIFT_NOTIF (unused) 11 = TICKET 12 = GUEST (unused) 13 = ALERT 14 = TELL_A_FRIEND 15 = FOAF (TeamRaiser Donor) (DEPRECATED) 16 = UNKNOWN 17 = AUTOREG (pre-Molokini auto-reg) 18 = NEWS_CONTRIBUTION 19 = TR_PARTICIPANT (TeamRaiser Participant) 20 = TR_FRIEND (TeamRaiser Friend) 21 = FORWARDED_EMAIL 22 = SURVEY_PARTICIPANT 23 = PREREGISTRATION 24 = ECOMMERCE_PURCHASE 25 = LDAP (auto-create on login attempt) 26 = RSVP (to an event) 27 = EMAIL UPLOAD 100 = IMPORT |
| C4 Origin Reference ID | Biographical Information | User-defined identifier for cross-referencing the C4 Origin between Luminate and user databases. 11 digits maximum |
| Card Expiration Date | Sustained Giving Information | Date when credit card used for sustained giving will expire. |
| Center ID | Center Assignment | The ID of a center to add the constituent to. (Center IDs are available on the Center Details page.) Centers that do not exist will not be created. This field will only be available when importing constituents in All Centers mode. |
| Center Name | Center Assignment | The name of a center to add the constituent to. (Names must match existing center names exactly.) Centers that do not exist will not be created. This field will only be available when importing constituents in All Centers mode. |
| Center Email Opt-In Flag | Center Assignment |
A Boolean value that indicates whether the constituent should be opted into email for the centers
specified in the record. Can set this value to No for existing customers or set to Yes for new
constituents. During uploads, the opt-in flag is recorded only for constituents created in the upload.
If zero or false, the constituent will be opted out of email for the specified centers.
Possible values include (these values can be flipped): True/False Yes/No 1/0 T/F Y/N |
| Center Removal Flag | Center Assignment | A Boolean value that indicates whether the constituent should be removed from the center(s) specified in the record. If "true", then the constituent will be removed from the centers. Possible values include: True/False, Yes/No, 1/0, T/F, Y/N (These values can be flipped.) |
| Address: City (for UK: Town) | Address | Name of the city listed for the residence of the constituent. Allows 64 letters and numbers maximum. |
| Employer Address: City | Employment | Name of the city listed for the constituent's employer. Allows 64 letters and numbers maximum. |
| Work Address: City | Address | Name of the city listed for the constituent's place of work. Allows 64 letters and numbers maximum. |
| Secondary School: Class | Education | Year in which the constituent was expected to be graduated. Allows 4 digits maximum. |
| First Post-Secondary School: Class | Education | Year in which the constituent was expected to be graduated. Allows 4 digits maximum. |
| Second Post-Secondary School: Class | Education | Year in which the constituent was expected to be graduated. Allows 4 digits maximum. |
| Third Post-Secondary School: Class | Education | Year in which the constituent was expected to be graduated. Allows 4 digits maximum. |
| Fourth Post-Secondary School: Class | Education | Year in which the constituent was expected to be graduated. Allows 4 digits maximum. |
| Fifth Post-Secondary School: Class | Education | Year in which the constituent was expected to be graduated. Allows 4 digits maximum. |
| Sixth Post-Secondary School: Class | Education | Year in which the constituent was expected to be graduated. Allows 4 digits maximum. |
| Class Note | Biographical Information | Contains the name of the file where class notes (if any) are stored. Allows 50 letters and numbers maximum. |
| Class Note Last Modified | Biographical Information | Indicates when the class note was last modified. |
| First Post-Secondary School: Concentration | Education | Subcategory within a major, such as European history for a history major. Allows 250 letters and numbers maximum. |
| Second Post-Secondary School: Concentration | Education | Subcategory within a major, such as European history for a history major. Allows 250 letters and numbers maximum. |
| Third Post-Secondary School: Concentration | Education | Subcategory within a major, such as European history for a history major. Allows 250 letters and numbers maximum. |
| Fourth Post-Secondary School: Concentration | Education | Subcategory within a major, such as European history for a history major. Allows 250 letters and numbers maximum. |
| Fifth Post-Secondary School: Concentration | Education | Subcategory within a major, such as European history for a history major. Allows 250 letters and numbers maximum. |
| Sixth Post-Secondary School: Concentration | Education | Subcategory within a major, such as European history for a history major. Allows 250 letters and numbers maximum. |
| First Post-Secondary School: Conferred | Education |
Confirmation that a degree was awarded by the school.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| Second Post-Secondary School: Conferred | Education |
Confirmation that a degree was awarded by the school.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| Third Post-Secondary School: Conferred | Education |
Confirmation that a degree was awarded by the school.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| Fourth Post-Secondary School: Conferred | Education |
Confirmation that a degree was awarded by the school.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| Fifth Post-Secondary School: Conferred | Education |
Confirmation that a degree was awarded by the school.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| Sixth Post-Secondary School: Conferred | Education | Confirmation that a degree was awarded by the school.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| Contact ID | Biographical Information |
The number string that defines the constituent ID of a constituent. The ID is generated by the system
when the person registered with your site.
To locate a CONS_ID: From Constituent360, click Contacts. Enter appropriate information in the Find Contact area and click the Find button. Locate the constituent in the Contact List and mouse over the Edit action. In the string that displays in the status bar at the bottom of the page, locate the cons_id (near the end of the string). |
| Address: Country | Address | Name of the country listed for the residence of this constituent. Allows 64 letters and numbers maximum. |
| Employer Address: Country | Employment | Name of the country listed for the constituent's employer. Allows 64 letters and numbers maximum. |
| Work Address: Country | Address | Name of the country listed for the constituent's place of work. Allows 64 letters and numbers maximum. |
| Date #1 (through Date #9) | Additional Information | Custom date for any administrator-defined purpose. Up to 9 custom dates are supported. |
| Date of Birth | Biographical Information | Month, day, and year entered as the date of birth for this constituent. |
| Date of Birth | Significant Other | Month, day, and year of birth of the constituent's significant other. |
| Relationship 1: Date of Birth | Relationships | Month, day, and year of birth. |
| Relationship 2: Date of Birth | Relationships | Month, day, and year of birth. |
| Relationship 3: Date of Birth | Relationships | Month, day, and year of birth. |
| Relationship 4: Date of Birth | Relationships | Month, day, and year of birth. |
| Relationship 5: Date of Birth | Relationships | Month, day, and year of birth. |
| Relationship 6: Date of Birth | Relationships | Month, day, and year of birth. |
| Relationship 7: Date of Birth | Relationships | Month, day, and year of birth. |
| Relationship 8: Date of Birth | Relationships | Month, day, and year of birth. |
| Deceased | Biographical Information |
Whether or not the constituent has passed away.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| Deceased | Significant Other |
Whether or not the constituent's significant other has passed away.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| First Post-Secondary School: Degree | Education | Degree or certification constituent was awarded, if any. Allows 64 letters and numbers maximum. |
| Second Post-Secondary School: Degree | Education | Degree or certification constituent was awarded, if any. Allows 64 letters and numbers maximum. |
| Third Post-Secondary School: Degree | Education | Degree or certification constituent was awarded, if any. Allows 64 letters and numbers maximum. |
| Fourth Post-Secondary School: Degree | Education | Degree or certification constituent was awarded, if any. Allows 64 letters and numbers maximum. |
| Fifth Post-Secondary School: Degree | Education | Degree or certification constituent was awarded, if any. Allows 64 letters and numbers maximum. |
| Sixth Post-Secondary School: Degree | Education | Degree or certification constituent was awarded, if any. Allows 64 letters and numbers maximum. |
| First Post-Secondary School: Department | Education | Section of a school, such as History, Science, Languages, and so on. Allows 250 letters and numbers maximum. |
| Second Post-Secondary School: Department | Education | Section of a school, such as History, Science, Languages, and so on. Allows 250 letters and numbers maximum. |
| Third Post-Secondary School: Department | Education | Section of a school, such as History, Science, Languages, and so on. Allows 250 letters and numbers maximum. |
| Fourth Post-Secondary School: Department | Education | Section of a school, such as History, Science, Languages, and so on. Allows 250 letters and numbers maximum. |
| Fifth Post-Secondary School: Department | Education | Section of a school, such as History, Science, Languages, and so on. Allows 250 letters and numbers maximum. |
| Sixth Post-Secondary School: Department | Education | Section of a school, such as History, Science, Languages, and so on. Allows 250 letters and numbers maximum. |
| Directory Member | Biographical Information |
Signifies whether the constituent is a member of the directory.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| Directory Opt-In | Biographical Information |
Signifies whether the constituent has opted into the directory.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| Primary Email Address of constituent. Email should be unique for each record. Allows 255 letters and numbers maximum. | ||
| Email Interest Name | Interest Assignment | The name of an email interest to which the constituent is to be added. Values can match the name of an existing email or web interest. If the interest does not already exist, an email interest will be created. Allows 255 letters and numbers maximum. |
| Email Opt-In Status |
Number indicating the constituent's status for opting in to email:
0 = unknown 1 = Double Opt-In 2 = Single Opt-In 3 = Clicked Through 4 = Opened 5 = Opt-Out 6 = Spam Complaint Can set this value to No for existing customers or to Yes for new constituents. During uploads, the opt-in flag is recorded only for constituents created in the upload. |
|
| Employer | Employment | Name of the employer listed by the constituent. |
| Employer Address Import ID | Biographical Information | Raiser's Edge identifier for importing constituent's employer address data. Allows 64 letters and numbers maximum. |
| Employer Industry | Employment |
Standard choices are:
Accounting/Finance Advertising/Public Relations Arts/Entertainment/Publishing Banking/Mortgage Clerical/Administrative Construction/Facilities Customer Service Education/Training Engineering/Architecture Government/Military Healthcare Hospitality/Travel Human Resources Insurance Internet/New Media Law Enforcement/Security Legal Management Consulting Manufacturing/Operations Marketing Non-Profit/Volunteer Pharmaceutical/Biotech Real Estate Restaurant/Food Service Retail Sales Technology Telecommunications Transportation/Logistics |
| Employment Status | Employment | Standard choices are "self-employed," "full-time," "part-time," "retired," "semi-retired," and "seeking employment," but your site may be customized. |
| Year-To-Date: Engagement Factor 1 (to Year-To-Date: Engagement Factor 10) | Transaction Information | Relative ranking of this constituent who performed an interaction (defined to engage people with your site) with other constituents who performed the same interaction with your Web site. |
| Enrolled Name | Biographical Information | Name used by constituent if different from legal name. Allows 50 letters and numbers maximum. |
| Ethnicity | Biographical Information | Ethnic background designated by constituent. Allows 64 letters and numbers maximum. |
| Exchange ID | Biographical Information | A system-generated ID primarily used for importing data into Raiser's Edge. Allows 64 letters and numbers maximum. |
| Expiration | Membership Information | Date when constituent's membership will expire. |
| ax | Phone | Fax number at which the constituent can be reached. Allows 50 letters and numbers maximum. |
| Fax Import ID | Biographical Information | Raiser's Edge identifier for importing constituent's fax number. Allows 64 letters and numbers maximum. |
| Name: First Name | Biographical Information | First name of the constituent. Allows 50 letters and numbers maximum. |
| Significant Other: First Name | Significant Other | First name of the constituent's significant other. Allows 50 letters and numbers maximum. |
| Relationship 1: First Name | Relationships | First name. Allows 50 letters and numbers maximum. |
| Relationship 2: First Name | Relationships | First name. Allows 50 letters and numbers maximum. |
| Relationship 3: First Name | Relationships | First name. Allows 50 letters and numbers maximum. |
| Relationship 4: First Name | Relationships | First name. Allows 50 letters and numbers maximum. |
| Relationship 5: First Name | Relationships | First name. Allows 50 letters and numbers maximum. |
| Relationship 6: First Name | Relationships | First name. Allows 50 letters and numbers maximum. |
| Relationship 7: First Name | Relationships | First name. Allows 50 letters and numbers maximum. |
| Relationship 8: First Name | Relationships | First name. Allows 50 letters and numbers maximum. |
| Gender | Biographical Information | Male or Female. Allows 20 letters and numbers maximum. |
| Significant Other: Gender | Significant Other | Male or Female. Allows 20 letters and numbers maximum. |
| Relationship 1: Gender | Relationships | Male or Female. Allows 20 letters and numbers maximum. |
| Relationship 2: Gender | Relationships | Male or Female. Allows 20 letters and numbers maximum. |
| Relationship 3: Gender | Relationships | Male or Female. Allows 20 letters and numbers maximum. |
| Relationship 4: Gender | Relationships | Male or Female. Allows 20 letters and numbers maximum. |
| Relationship 5: Gender | Relationships | Male or Female. Allows 20 letters and numbers maximum. |
| Relationship 6: Gender | Relationships | Male or Female. Allows 20 letters and numbers maximum. |
| Relationship 7: Gender | Relationships | Male or Female. Allows 20 letters and numbers maximum. |
| Relationship 8: Gender | Relationships | Male or Female. Allows 20 letters and numbers maximum. |
| Group ID | Group Assignment | The ID of a group to add the constituent to. Only for use with existing records. Values can be Luminate IDs or external IDs cross-referenced to Luminate IDs. Groups that do not exist will not be created. Allows 64 letters and numbers maximum. |
| Group Name | Group Assignment | The name of a group to add the constituent to. Groups that do not exist will be created. Allows 255 letters and numbers maximum. |
| Group Removal Flag | Group Assignment | A Boolean value that indicates whether the constituent should be removed from the group(s) specified in the record. If "true," then the constituent will be removed from the groups. If "false," the constituent will not be removed. |
| Home Address Import ID | Biographical Information | Raiser's Edge identifier for importing constituent's home address data. Allows 64 letters and numbers maximum. |
| Home Phone Import ID | Biographical Information | Raiser's Edge identifier for importing constituent's home phone data. Allows 64 letters and numbers maximum. |
| Income Level | Biographical Information | A single amount or an amount range; possibly a general categorization, such as low or middle. Allows 40 letters and numbers maximum. |
| Individual Relationship Link | Biographical Information | URL to online content. Allows 64 letters and numbers maximum. |
| Interest ID | Interest Assignment | The ID of an existing email or web content interest to which the constituent is to be added. Values can be Luminate IDs or external IDs cross-referenced to Luminate IDs. Interests that do not exist will not be created. Allows 64 letters and numbers maximum. |
| Interest Opt-in Flag | Interest Assignment | A Boolean value that indicates whether the constituent should be opted into the interest(s) specified in the record. If 0 (zero) or "false", then the constituent will be opted out of the interests. 0 or false, 1 or true |
| Name: Last Name | Biographical Information | Last name of this constituent. Allows 50 letters and numbers maximum. |
| Relationship 1: Last Name | Relationships | Last name. Allows 50 letters and numbers maximum. |
| Relationship 2: Last Name | Relationships | Last name. Allows 50 letters and numbers maximum. |
| Relationship 3: Last Name | Relationships | Last name. Allows 50 letters and numbers maximum. |
| Relationship 4: Last Name | Relationships | Last name. Allows 50 letters and numbers maximum. |
| Relationship 5: Last Name | Relationships | Last name. Allows 50 letters and numbers maximum. |
| Relationship 6: Last Name | Relationships | Last name. Allows 50 letters and numbers maximum. |
| Relationship 7: Last Name | Relationships | Last name. Allows 50 letters and numbers maximum. |
| Relationship 8: Last Name | Relationships | Last name. Allows 50 letters and numbers maximum. |
| Significant Other: Last Name | Significant Other | Last name of the constituent's significant other. Allows 50 letters and numbers maximum. |
| Last Renewal | Membership Information | Date when constituent last renewed membership |
| Lifetime Email | Permanent alternate email address to which this constituent can be sent email. Allows 255 letters and numbers maximum. | |
| Maiden Name | Biographical Information | Birth surname of a married female constituent. Allows 50 letters and numbers maximum. |
| Significant Other: Maiden Name | Significant Other | Birth surname of constituent's wife. Allows 50 letters and numbers maximum. |
| First Post-Secondary School: Major | Education | Field of study in which the constituent specialized. Allows 250 letters and numbers maximum. |
| Second Post-Secondary School: Major | Education | Field of study in which the constituent specialized. Allows 250 letters and numbers maximum. |
| Third Post-Secondary School: Major | Education | Field of study in which the constituent specialized. Allows 250 letters and numbers maximum. |
| Fourth Post-Secondary School: Major | Education | Field of study in which the constituent specialized. Allows 250 letters and numbers maximum. |
| Fifth Post-Secondary School: Major | Education | Field of study in which the constituent specialized. Allows 250 letters and numbers maximum. |
| Sixth Post-Secondary School: Major | Education | Field of study in which the constituent specialized. Allows 250 letters and numbers maximum. |
| Marital Status | Biographical Information |
Marital status of constituent. Allows 20 letters and numbers maximum.
Standard choices are: Married Single Divorced Separated |
| Matched Donor | Biographical Information |
Indicates whether any gifts made by this constituent are matched by an employer.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| Member ID | Biographical Information | The nonprofit's membership ID. Allows 32 letters and numbers maximum. |
| Member Since | Membership Information | Date when constituent first became a member. |
| Membership ID | Membership Information | ID that you or your donor database assigns. It should be unique for each record. Allows 32 letters and numbers maximum. |
| Membership Type | Membership Information |
Unique numerical identifier. Allows 11 digits maximum.
* This column is required in the upload file if you are updating Membership Status (see Status, below) To locate a Membership Type: From Fundraising, click Donation Management. Then click on the Membership Types tab. In the Membership Types list, place your cursor over the edit link for the appropriate Membership Type associated with the Membership Status to be updated. The link value will display in your browser status bar and it will end with the text "mem_type_id=" and a number (for example, mem_type_id=1004). That number is the Membership Type. |
| Name: Middle Name | Biographical Information | Constituent's middle name. Allows 50 letters and numbers maximum. |
| Significant Other: Middle Name | Significant Other | Middle name of the constituent's significant other. Allows 50 letters and numbers maximum. |
| First Post-Secondary School: Minor | Education | Constituent's secondary area of academic specialization. Allows 250 letters and numbers maximum. |
| Second Post-Secondary School: Minor | Education | Constituent's secondary area of academic specialization. Allows 250 letters and numbers maximum. |
| Third Post-Secondary School: Minor | Education | Constituent's secondary area of academic specialization. Allows 250 letters and numbers maximum. |
| Fourth Post-Secondary School: Minor | Education | Constituent's secondary area of academic specialization. Allows 250 letters and numbers maximum. |
| Fifth Post-Secondary School: Minor | Education | Constituent's secondary area of academic specialization. Allows 250 letters and numbers maximum. |
| Sixth Post-Secondary School: Minor | Education | Constituent's secondary area of academic specialization. Allows 250 letters and numbers maximum. |
| Mobile Phone Import ID | Biographical Information | Raiser's Edge identifier for importing constituent's cell phone data. Allows 64 letters and numbers maximum. |
| Mobile Phone | Phone | Number of constituent's cell phone. Allows 50 letters and numbers maximum. |
| Monetary Value #1 (through Monetary Value #10) | Additional Information | Custom currency amount. Up to 10 custom values are supported. Allows 20 digits maximum. |
| First Post-Secondary School: Name | Education | Post-secondary school constituent attended. Allows 64 letters and numbers maximum. |
| Second Post-Secondary School: Name | Education | Post-secondary school constituent attended. Allows 64 letters and numbers maximum. |
| Third Post-Secondary School: Name | Education | Post-secondary school constituent attended. Allows 64 letters and numbers maximum. |
| Fourth Post-Secondary School: Name | Education | Post-secondary school constituent attended. Allows 64 letters and numbers maximum. |
| Fifth Post-Secondary School: Name | Education | Post-secondary school constituent attended. Allows 64 letters and numbers maximum. |
| Sixth Post-Secondary School: Name | Education | Post-secondary school constituent attended. Allows 64 letters and numbers maximum. |
| Secondary School: Name | Education | High school from which the constituent was graduated. Allows 64 letters and numbers maximum. |
| Nickname | Biographical Information | Moniker of the constituent. Allows 30 letters and numbers maximum. |
| Number #1 (through Number #10) | Additional Information | Custom number, such as an administrator-defined ID. Up to 10 custom numbers are supported. Allows 11 digits maximum. |
| Occupation | Employment | Job type selected by this constituent. Allows 64 letters and numbers maximum.
Standard choices are: Accounting/Finance Advertising/Public Relations Arts/Entertainment/Publishing Banking/Mortgage Clerical/Administrative Construction/Facilities Customer Service Education/Training Engineering/Architecture Government/Military Healthcare Hospitality/Travel Human Resources Insurance Internet/New Media Law Enforcement/Security Legal Management Consulting Manufacturing/Operations Marketing Non-Profit/Volunteer Pharmaceutical/Biotech Real Estate Restaurant/Food Service Retail Sales Technology Telecommunications Transportation/Logistics |
| Origin Source Code | Biographical Information | Custom string of letters and/or numbers. Client-defined identifier associated with a Luminate application and used to record a constituent's first interaction with Luminate. Allows 255 characters maximum. |
| Origin Subsource Code | Biographical Information | Custom string of letters and/or numbers. Client-defined identifier associated with a Luminate application and used to record additional details, beyond the Origin Source Code, about a constituent's first interaction with Luminate. Allows 255 characters maximum. |
| Other Address Import ID | Biographical Information | Raiser's Edge identifier for importing constituent's other address data. Allows 64 letters and numbers maximum. |
| Phone | Phone | Ten-digit telephone number listed for contacting this constituent. Allows 50 letters and numbers maximum. |
| Photo | Biographical Information | Contains a pair of graphic files separated by a ";" delimiter that represent the uploaded full-size and thumb-nail directory photos (if any) for this constituent. Allows 50 letters and numbers maximum. |
| Place of Birth | Biographical Information | Location where constituent was born. Allows 64 letters and numbers maximum. |
| Significant Other: Place of Birth | Significant Other | Location where constituent's significant other was born. Allows 64 letters and numbers maximum. |
| Position | Employment | Employment-defined job title of the constituent. Allows 64 letters and numbers maximum. |
| Prefer Gift Aid | Biographical Information | Indicates whether the constituent prefers to contribute with Gift Aid. See
http://www.inlandrevenue.gov.uk/pdfs/ir65.htm for details.
The number 0 or 1: 0 = No/False 1 =Yes/True |
| Other Address: Preferred Address | Address | Address at which constituent prefers to receive correspondence.
Number 1, 2, or 3 where: 1 = home 2 = work 3 = other |
| First Post-Secondary School: Preferred Class | Education | Year of graduating class with which constituent prefers to be associated. Allows 4 digits maximum. |
| Second Post-Secondary School: Preferred Class | Education | Year of graduating class with which constituent prefers to be associated. Allows 4 digits maximum. |
| Third Post-Secondary School: Preferred Class | Education | Year of graduating class with which constituent prefers to be associated. Allows 4 digits maximum. |
| Fourth Post-Secondary School: Preferred Class | Education | Year of graduating class with which constituent prefers to be associated. Allows 4 digits maximum. |
| Fifth Post-Secondary School: Preferred Class | Education | Year of graduating class with which constituent prefers to be associated. Allows 4 digits maximum. |
| Sixth Post-Secondary School: Preferred Class | Education | Year of graduating class with which constituent prefers to be associated. Allows 4 digits maximum. |
| Preferred Format | HTML if the constituent can receive email messages with formatting in them.
Plain Text if the constituent can receive only emails without formatting in
them.
Number: 0 = UNDEFINED 1 = HTML 2 = PLAIN |
|
| Preferred Locale | Biographical Information | Locale with which constituent prefers to be associated; represented as a language and/or a geographical region, such as English_GB or FR_CA. Allows 50 letters and numbers maximum. |
| Preferred Phone | Phone | Telephone number at which constituent prefers to be called. Allows 50 letters and numbers maximum. |
| Other Address: Primary Address Type | Address | Standard choices are "Home" or "Business" but your site may be customized with other values. Allows 20 letters and numbers maximum. |
| Primary Business Org Import ID | Biographical Information | Raiser's Edge identifier for importing constituent's primary business data. Allows 64 letters and numbers maximum. |
| Primary Business Relationship Link ID | Biographical Information | Raiser's Edge link associated with constituent's business but unused in Constituent360 by Luminate. Allows 64 letters and numbers maximum. |
| Primary Email Import ID | Biographical Information | Raiser's Edge identifier for importing constituent's primary email address data. Allows 64 letters and numbers maximum. |
| Professional Suffix | Biographical Information | Constituent's abbreviated profession (for example, MD). Allows 50 letters and numbers maximum. |
| Significant Other: Professional Suffix | Significant Other | Constituent's significant other's abbreviated profession (for example, ESQ). Allows 50 letters and numbers maximum. |
| Religion | Biographical Information | Religious faith designated by constituent. Allows 64 letters and numbers maximum. |
| Salutation (Casual) | Biographical Information | User-defined informal greeting. Allows 100 letters and numbers maximum. |
| Salutation (Formal) | Biographical Information | User-defined formal greeting. Allows 100 letters and numbers maximum. |
| Secondary Email | Alternate Email address at which this constituent can be sent email. Allows 255 letters and numbers maximum. | |
| Secondary Email Import ID | Biographical Information | Raiser's Edge identifier for importing constituent's secondary email address data. Allows 64 letters and numbers maximum. |
| Security Category | Biographical Information | ID of security category to which this constituent has access. Number generated by Luminate. |
| Significant Other Import ID | Biographical Information | Raiser's Edge identifier for importing data about constituent's significant other. Allows 64 letters and numbers maximum. |
| Address: State/Province | Address | Two-letter abbreviation for the state listed for the residence of the constituent. |
| Employer Address: State/Province | Employment | Two-letter abbreviation for the state listed for the constituent's employer. |
| Other Address: State/Province | Address | Two-letter abbreviation for the alternate address state provided by the constituent. |
| Address: Street 1 (for UK: Address 1) | Address | Number and name of the street listed as the residence of the constituent. Allows 128 characters maximum. |
| Address: Street 2 (for UK: Address 2) | Address | Additional information pertaining to the address of the residence (for example, Apt). Allows 128 characters maximum. |
| Address: Street 3 (for UK: Address 3) | Address | Additional information pertaining to the address of the residence. Allows 128 characters maximum. |
| Employer Address: Street 1 (for UK: Address 1) | Employment | Number and name of the street listed for the constituent's employer. Allows 128 characters maximum. |
| Employer Address: Street 2 (for UK: Address 2) | Employment | Additional information for the constituent's employer (for example, Suite). Allows 128 characters maximum. |
| Employer Address: Street 3 (for UK: Address 3) | Employment | Additional information for the constituent's employer. Allows 128 characters maximum. |
| Other Address: Street 1 (for UK: Address 1) | Address | Number and name of the alternate street address provided by the constituent. Allows 128 characters maximum. |
| Other Address: Street 2 (for UK: Address 2) | Address | Additional alternate address information provided by the constituent (for example, Suite). Allows 128 characters maximum. |
| Other Address: Street 3 (for UK: Address 3) | Address | Additional alternate address information provided by the constituent. Allows 128 characters maximum. |
| Work Address: State/Province | Address | Two-letter abbreviation for the state listed for the constituent's place of work. |
| Work Address: Street 1 (for UK: Address 1) | Address | Number and name of the street listed for the constituent's place of work. Allows 128 characters maximum. |
| Work Address: Street 2 (for UK: Address 2) | Address | Additional information for the constituent's place of work (for example, Suite). Allows 128 characters maximum. |
| Work Address: Street 3 (for UK: Address 3) | Address | Additional information for the constituent's place of work. Allows 128 characters maximum. |
| Status | Membership Information | Constituent's status as a member. Number:
0 = unknown status 1 = never a member 2 = current member 3 = lapsed member (<1 year) 4 = inactive member (>1 year) Note: If this column is updated, the Membership Level ID (see above) is required. |
| String #1 (through String #30) | Additional Information | Custom information for any administrator-defined purpose. Up to 30 custom "strings" (descriptions) are supported. Allows 255 characters maximum. |
| Suffix | Biographical Information | Abbreviation after the constituent's name to indicate familial status (for example, Jr). Allows 50 letters and numbers maximum. |
| Significant Other: Suffix | Significant Other | Abbreviation after the name of the constituent's significant other to indicate familial status (for example, Jr). Allows 50 characters maximum. |
| Tax Exempt Certificate | Biographical Information | Description of tax exempt certificate constituent holds. Allows 30 letters and numbers maximum. |
| Tax Exempt Issuer | Biographical Information | Authority that issued the tax exempt certificate the constituent holds. Allows 50 letters and numbers maximum. |
| Tax Exempt Reason | Biographical Information | Reason constituent provides for tax exempt status.
Number: 0 = Taxable 1 = For Resale 2 = Government - National 3 = Government - Excluding National 4 = Charitable Organization 5 = Hospital/Medical Facility or Practitioner 6 = Religious Organization 10 = Tax Exempt Certificate Holder 13 = Direct Pay 15 = Other Non-Taxable |
| Title | Biographical Information | A word put before the constituent's name to show rank, occupation, marital status. Allows 50 letters and numbers maximum. |
| Significant Other : Title | Significant Other | A word preceding the name to show rank, occupation, marital status. Allows 50 letters and numbers maximum. |
| First Post-Secondary School: Type | Education | Academic, technical, vocational, and so forth. Allows 30 letters and numbers maximum. |
| Second Post-Secondary School: Type | Education | Academic, technical, vocational, and so forth. Allows 30 letters and numbers maximum. |
| Third Post-Secondary School: Type | Education | Academic, technical, vocational, and so forth. Allows 30 letters and numbers maximum. |
| Fourth Post-Secondary School: Type | Education | Academic, technical, vocational, and so forth. Allows 30 letters and numbers maximum. |
| Fifth Post-Secondary School: Type | Education | Academic, technical, vocational, and so forth. Allows 30 letters and numbers maximum. |
| Sixth Post-Secondary School: Type | Education | Academic, technical, vocational, and so forth. Allows 30 letters and numbers maximum. |
| Relationship 1: Type | Relationships | Friend, sibling, child, and so forth. Allows 30 letters and numbers maximum. |
| Relationship 2: Type | Relationships | Friend, sibling, child, and so forth. Allows 30 letters and numbers maximum. |
| Relationship 3: Type | Relationships | Friend, sibling, child, and so forth. Allows 30 letters and numbers maximum. |
| Relationship 4: Type | Relationships | Friend, sibling, child, and so forth. Allows 30 letters and numbers maximum. |
| Relationship 5: Type | Relationships | Friend, sibling, child, and so forth. Allows 30 letters and numbers maximum. |
| Relationship 6: Type | Relationships | Friend, sibling, child, and so forth. Allows 30 letters and numbers maximum. |
| Relationship 7: Type | Relationships | Friend, sibling, child, and so forth. Allows 30 letters and numbers maximum. |
| Relationship 8: Type | Relationships | Friend, sibling, child, and so forth. Allows 30 letters and numbers maximum. |
| User Name | Biographical Information | Name this constituent enters to log in to the site. Can be provided by the constituent when originally registering as a user on this site or generated by the system. Allows 255 letters and numbers maximum. |
| Web Content Interest Name | Interest Assignment | The name of a web content interest to which the constituent is to be added. Values can match the name of an existing email or web interest. If the interest does not exist, a web content interest will be created. Allows 255 letters and numbers maximum. |
| Work Address Import ID | Biographical Information | Raiser's Edge identifier for importing constituent's work address data. Allows 64 letters and numbers maximum. |
| Work Phone | Phone | Constituent's work telephone number. Allows 50 letters and numbers maximum. |
| Work Phone Import ID | Biographical Information | Raiser's Edge identifier for importing constituent's work phone data. Allows 64 letters and numbers maximum. |
| Work Web Page | Biographical Information | URL of constituent's work web page. Allows 50 letters and numbers maximum. |
| Address: ZIP/Postal Code (for UK: Postcode) | Address | ZIP or Postal Code selected for the residence of the constituent. Allows 40 letters and numbers maximum. |
| Employer Address: ZIP/Postal Code (for UK: Postcode) | Employment | Alternate ZIP or Postal Code of the constituent's employer. Allows 40 letters and numbers maximum. |
| Work Address: ZIP/Postal Code | Address | ZIP or Postal Code selected for the constituent's place of work. Allows 40 letters and numbers maximum. |
| Other Address: ZIP/Postal Code (for UK: Postcode) | Address | Alternate ZIP or Postal Code provided by the constituent. Allows 40 letters and numbers maximum. |
The following Advocacy columns refer to the legislative districts that represent this constituent in different levels of government:
| Column | Column Group | Description |
|---|---|---|
| Congressional District (Manual Override) | Advocacy Information | Name of the federal legislative geographic area to which this constituent is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred. Allows 50 letters and numbers maximum. |
| County (Manual Override) | Advocacy Information | Name of the county legislative geographic area to which this constituent is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred. Allows 50 letters and numbers maximum. |
| State House District (Manual Override) | Advocacy Information | Name of the state house legislative geographic area to which this constituent is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred. Allows 50 letters and numbers maximum. |
| State Senate District (Manual Override) | Advocacy Information | Name of the state senate legislative geographic area to which this constituent is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred. Allows 50 letters and numbers maximum. |