Object: Contact

Fields

Name	Label	Type	Description

Name	Label	Type	Description
Id	Contact ID	ID
IsDeleted	Deleted	CHECKBOX
MasterRecordId	Master Record ID	LOOKUP
AccountId	Account ID	LOOKUP
LastName	Last Name	TEXT(80)
FirstName	First Name	TEXT(40)
Salutation	Salutation	PICKLIST
MiddleName	Middle Name	TEXT(40)
Suffix	Suffix	TEXT(40)
Name	Full Name	TEXT(121)
OtherStreet	Other Street	TEXT AREA(255)
OtherCity	Other City	TEXT(40)
OtherState	Other State/Province	TEXT(80)
OtherPostalCode	Other Zip/Postal Code	TEXT(20)
OtherCountry	Other Country	TEXT(80)
OtherLatitude	Other Latitude	NUMBER(3,15)
OtherLongitude	Other Longitude	NUMBER(3,15)
OtherGeocodeAccuracy	Other Geocode Accuracy	PICKLIST
OtherAddress	Other Address	AUTO NUMBER
MailingStreet	Contact Mailing Street	TEXT AREA(255)
MailingCity	Contact Mailing City	TEXT(40)
MailingState	Contact Mailing State/Province	TEXT(80)
MailingPostalCode	Contact Mailing ZIP/Postal Code	TEXT(20)
MailingCountry	Contact Mailing Country	TEXT(80)
MailingLatitude	Contact Mailing Latitude	NUMBER(3,15)
MailingLongitude	Contact Mailing Longitude	NUMBER(3,15)
MailingGeocodeAccuracy	Mailing Geocode Accuracy	PICKLIST
MailingAddress	Contact Mailing Address	AUTO NUMBER
Phone	Business Phone	PHONE
Fax	Business Fax	PHONE
MobilePhone	Mobile Phone	PHONE
HomePhone	Home Phone	PHONE
OtherPhone	Other Phone	PHONE
AssistantPhone	Asst. Phone	PHONE
ReportsToId	Reports To ID	LOOKUP
Email	Email	EMAIL
Title	Title	TEXT(128)
Department	Department	TEXT(80)
AssistantName	Assistant's Name	TEXT(40)
LeadSource	Lead Source	PICKLIST
Birthdate	Birthdate	DATE
Description	Contact Description	TEXT AREA (LONG)(32000)
OwnerId	Owner ID	LOOKUP
HasOptedOutOfEmail	Email Opt Out	CHECKBOX
HasOptedOutOfFax	Fax Opt Out	CHECKBOX
DoNotCall	Do Not Call	CHECKBOX
CreatedDate	Created Date	DATETIME
CreatedById	Created By ID	LOOKUP
LastModifiedDate	Last Modified Date	DATETIME
LastModifiedById	Last Modified By ID	LOOKUP
SystemModstamp	System Modstamp	DATETIME
LastActivityDate	Last Activity	DATE
LastCURequestDate	Last Stay-in-Touch Request Date	DATETIME
LastCUUpdateDate	Last Stay-in-Touch Save Date	DATETIME
LastViewedDate	Last Viewed Date	DATETIME
LastReferencedDate	Last Referenced Date	DATETIME
EmailBouncedReason	Email Bounced Reason	TEXT(255)
EmailBouncedDate	Email Bounced Date	DATETIME
IsEmailBounced	Is Email Bounced	CHECKBOX
PhotoUrl	Photo URL	URL
Jigsaw	Data.com Key	TEXT(20)
JigsawContactId	Jigsaw Contact ID	TEXT(20)
IndividualId	Individual ID	LOOKUP
Pronouns	Pronouns	PICKLIST
GenderIdentity	Gender Identity	PICKLIST
HasPrivacyHold	Privacy Hold	CHECKBOX
AQB__ANLink__c	Alternate Name Link	LOOKUP
AQB__AName__c	Alternate Name	FORMULA (TEXT)(1300)	The Alternate Name for this Contact as defined in either the linked Name record or the Contact's Automatic Alternate Name, or formatted by the Alternate Name formula.
AQB__AccessibilityPreferences__c	Accessibility Preferences	PICKLIST (MULTI-SELECT)	Accessibility preferences or restrictions for ths Contact.
AQB__AccountCapacity__c	Account Capacity	FORMULA (TEXT)(1300)	An institution-defined set of values, meant to describe the amount a prospect might be able to give.
AQB__AccountMailingAddressType__c	Account Mailing Address Type	FORMULA (TEXT)(1300)	A description of the nature of the address information, such as residence, business, etc.
AQB__AccountMailingAddress__c	Account Mailing Address	FORMULA (TEXT)(1300)
AQB__AccountMailingCity__c	Account Mailing Address City	FORMULA (TEXT)(1300)
AQB__AccountMailingCountry__c	Account Mailing Address Country	FORMULA (TEXT)(1300)
AQB__AccountMailingCounty__c	Account Mailing Address County	FORMULA (TEXT)(1300)
AQB__AccountMailingLocality__c	Account Mailing Address Locality	FORMULA (TEXT)(1300)
AQB__AccountMailingNote__c	Account Mailing Address Note	FORMULA (TEXT)(1300)	This field may be used to attach any brief information regarding this Account Address.
AQB__AccountMailingPostalCode__c	Account Mailing Address Zip/Postal Code	FORMULA (TEXT)(1300)
AQB__AccountMailingState__c	Account Mailing Address State/Province	FORMULA (TEXT)(1300)
AQB__AccountMailingStatus__c	Account Mailing Address Status	FORMULA (TEXT)(1300)
AQB__AccountMailingStreet__c	Account Mailing Address Street	FORMULA (TEXT)(1300)
AQB__AccountPhone__c	Account Phone	FORMULA (TEXT)(1300)
AQB__AccountReadiness__c	Account Readiness	FORMULA (TEXT)(1300)	An institution-defined set of values, meant to describe the preparedness of the prospect to give or the status of the prospect's cultivation.
AQB__AdditionalInstitutionalSuffix__c	Additional Institutional Suffix	TEXT(50)	Any additional information you want added to the institutional suffix.
AQB__AddressChangeFlags__c	Address Change Flags	TEXT(100)	Contains comma separated codes that specify the portion of the address that was changed or modified.
AQB__AddressInUseText__c	Address Preference	FORMULA (TEXT)(1300)
AQB__AddressInUseType__c	Address Preference	PICKLIST	Used to set the current mailing address to 'Account Mailing', 'Business' or 'Alternate'.
AQB__Age__c	Age	FORMULA (NUMBER)(18,0)
AQB__Alert__c	Alert	TEXT AREA (LONG)(4000)
AQB__AutomatedAlternateName__c	Automated Alternate Name	TEXT(200)	This is the Alternate Name that is formatted by using the Name Definition flagged for the Alternate Name.
AQB__AutomatedCommunityName__c	Automated Community Name	TEXT(200)	This is the Community Name that is formatted by using the Name Definition flagged for the Community Name.
AQB__AutomatedDefaultAddressSalutation__c	Automated Default Address Salutation	TEXT(200)	This is the Default Address Salutation that is formatted by using the Name Definition flagged for the Default Address Salutation.
AQB__AutomatedDefaultGreetingSalutation__c	Automated Default Greeting Salutation	TEXT(200)	This is the Default Greeting Salutation that is formatted by using the Name Definition flagged for the Default Greeting Salutation.
AQB__AutomatedFormalName__c	Automated Formal Name	TEXT(200)	This is the Formal Name that is formatted by using the Name Definition flagged for the Formal Name.
AQB__AutomatedPreferredName__c	Automated Preferred Name	TEXT(200)	This is the Preferred Name that is formatted by using the Name Definition flagged for the Preferred Name.
AQB__AwardGiftCredit__c	Award Gift Credit	CHECKBOX
AQB__BusinessAddressCity__c	Business Address City	FORMULA (TEXT)(1300)
AQB__BusinessAddressCountry__c	Business Address Country	FORMULA (TEXT)(1300)
AQB__BusinessAddressLocality__c	Business Address Locality	FORMULA (TEXT)(1300)
AQB__BusinessAddressNote__c	Business Address Note	FORMULA (TEXT)(1300)	Any free text information you wish to enter regarding this address that is not otherwise maintained.
AQB__BusinessAddressPostalCode__c	Business Address Postal Code	FORMULA (TEXT)(1300)
AQB__BusinessAddressStatePro__c	Business Address State/Province	FORMULA (TEXT)(1300)
AQB__BusinessAddressStatus__c	Business Address Status	FORMULA (TEXT)(1300)	A description of the validity of this business address. A status of 'Returned by the Post Office' might be used as an intermediate step before declaring an address to be 'Lost'.
AQB__BusinessAddressStreet__c	Business Address Street	FORMULA (TEXT)(1300)
AQB__BusinessAddressType__c	Business Address Type	FORMULA (TEXT)(1300)	A description of the nature of this business address.
AQB__BusinessAddress__c	Business Address	FORMULA (TEXT)(1300)	The mailing address at the Contact's primary employment location.
AQB__BusinessEmail__c	Business Email	EMAIL	Email at contact's primary place of employment.
AQB__BusinessPhone__c	Business Phone	FORMULA (TEXT)(1300)	The phone number at the Contact's primary business location.
AQB__CAECategory__c	VSE Category	PICKLIST	This is the VSE Category of the individual Contact.
AQB__CNLink__c	Community Name Link	LOOKUP
AQB__CName__c	Community Name	FORMULA (TEXT)(1300)	The Community Name for this Contact as defined in either the linked Name record or the Contact's Automatic Community Name, or formatted by the Community Name formula.
AQB__CarrierRoute__c	Carrier Route	TEXT(50)	An alphanumeric code assigned to a mail delivery or collection route within a zip code.
AQB__CauseDeath__c	Cause of Death	TEXT(255)	The cause of the contact's death.
AQB__CertifiedCityName__c	Certified City Name	TEXT(255)	The certified city name for this contact address.
AQB__CertifiedStateAbbreviation__c	Certified State Abbreviation	TEXT(100)	The certified state abbreviation for the contact address.
AQB__CertifiedStreetName__c	Certified Street Name	TEXT(255)	The certified street name for the contact address.
AQB__CertifiedZipCode__c	Certified Zip Code	TEXT(20)	The certified zip code of the contact address.
AQB__CityofDeath__c	City of Death	TEXT(255)
AQB__Comments__c	Comments	TEXT AREA (LONG)(1000)
AQB__CommunityPassword__c	Community Password	TEXT(30)
AQB__ContactAnonymousOption__c	Gift Recognition Credits are Anonymous	CHECKBOX
AQB__ContactCount__c	Contact Count	FORMULA (NUMBER)(18,0)
AQB__ContactExternalID__c	Contact External ID	TEXT(20)	An ID number used by a prior data system to identify this Contact.
AQB__ContactGrouping__c	Contact Grouping	FORMULA (TEXT)(1300)
AQB__ContactMailingAddressStreetLineOne__c	Mailing Addr Street Line One	FORMULA (TEXT)(1300)
AQB__ContactMailingAddressStreetLineThre__c	Mailing Addr Street Line Three	FORMULA (TEXT)(1300)
AQB__ContactMailingAddressStreetLineTwo__c	Mailing Addr Street Line Two	FORMULA (TEXT)(1300)
AQB__ContactPicture__c	Contact Picture	TEXT AREA (RICH)(32768)	Picture of the Contact.
AQB__ContactSource__c	Contact Source	TEXT(100)
AQB__Contact_Mailing_Address__c	Mailing Address	FORMULA (TEXT)(1300)
AQB__CorroboratedDeathDate__c	Corroborated Death Date	DATE
AQB__CountryId__c	Country ID	TEXT(5)	The contact address country id. Intended to be used when integrating with a third party address verification system.
AQB__CountryofDeath__c	Country of Death	TEXT(100)
AQB__CountyNumber__c	County Number	TEXT(10)	The contact address county id. Intended to be used when integrating with a third party address verification system.
AQB__County__c	County	TEXT(255)	The name of the geographical region within which the address is located.
AQB__DateObituaryAttached__c	Date Obituary Attached	DATE
AQB__DateofDeathNotification__c	Date of Death Notification	DATE
AQB__DateofDeathPrecision__c	Date of Death Precision	PICKLIST
AQB__DateofDeath__c	Date of Death	DATE
AQB__DeathCorroboratedby__c	Death Corroborated by	TEXT(50)
AQB__Deceased__c	Deceased?	CHECKBOX
AQB__DefaultAddressSal__c	Default Address Salutation	FORMULA (TEXT)(1300)
AQB__DefaultGreetingSal__c	Default Greeting Salutation	FORMULA (TEXT)(1300)
AQB__DegreeYear__c	Degree Year	FORMULA (TEXT)(1300)
AQB__Degree__c	Degree	FORMULA (TEXT)(1300)
AQB__DeliveryPoint1__c	Delivery Point Code	TEXT(10)	Two digit validation code provided by USPS.
AQB__DeliveryPointCheckDigit__c	Delivery Point Check Digit	TEXT(10)	Single check digit provided by USPS.
AQB__DeliveryPointValidationFlag__c	Delivery Point Validation Flag	TEXT(10)	Single character indicating delivery point validation status, (Y) Yes, (N) No
AQB__DeliveryPointValidation__c	Delivery Point Validation	TEXT(10)	Three digit code assigned by USPS that confirms the address can be delivered to (this code is a combination of Delivery Point Validation and Delivery Point Check Digit).
AQB__DirectoryIncludeSendEmailLink__c	Directory Include Send Email Link	CHECKBOX
AQB__DirectoryPublishAddress__c	Directory Publish Address	CHECKBOX
AQB__DirectoryPublishCoreData__c	Directory Publish Core Data	CHECKBOX
AQB__DirectoryPublishEducation__c	Directory Publish Education	CHECKBOX
AQB__DirectoryPublishEmail__c	Directory Publish Email	CHECKBOX
AQB__DirectoryPublishEmployment__c	Directory Publish Employment	CHECKBOX
AQB__DirectoryPublishInterests__c	Directory Publish Interests	CHECKBOX
AQB__DirectoryPublishPhone__c	Directory Publish Phone	CHECKBOX
AQB__DistrictAlternate__c	District - Alternate	PICKLIST
AQB__DistrictIsOverridden__c	District is Overridden	CHECKBOX	Indicates that the user has overridden the district that is associated with the Mailing Address Postal Code.
AQB__District__c	District	PICKLIST
AQB__DoNotArchive__c	Do Not Archive	CHECKBOX	Indicates that the address, phone and/or email should not be archived.
AQB__DoNotContact__c	Do Not Contact	CHECKBOX
AQB__DoNotSolicit__c	Do Not Solicit	CHECKBOX
AQB__EducationLink__c	Primary Degree Link	LOOKUP	An internal field that maintains the link between this Contact and the primary Education data row.
AQB__EmailNotes__c	Email Notes	TEXT(200)
AQB__EmailPreference__c	Email Preference	PICKLIST
AQB__EmployerName__c	Employer Name	FORMULA (TEXT)(1300)	The name of the Employer for the Contact's primary Employment.
AQB__EngagementScoreExperiential__c	Experiential	NUMBER(5,0)
AQB__EngagementScorePhilanthropic__c	Philanthropic	NUMBER(5,0)
AQB__EngagementScoreVolunteer__c	Volunteer	NUMBER(5,0)
AQB__EngagmentScoreCommunication__c	Communications	NUMBER(5,0)
AQB__Ethnicity__c	Ethnicity	PICKLIST	A picklist of values that describe the Contact's ethnic background.
AQB__FIPSStateCode__c	FIPS State Code	TEXT(10)	The Federal Information Processing Standard state code of this contact address.
AQB__FNLink__c	Formal Name Link	LOOKUP
AQB__FName__c	Formal Name	FORMULA (TEXT)(1300)	The Formal Name for this Contact as defined in either the linked Name record or the Contact's Automatic Formal Name, or formatted by the Formal Name formula.
AQB__Flag__c	Flag	TEXT(10)	Mid level validation flag indicating detailed status, (E) Exact, (T) Tentative, (M) Multiple, (S) Secondary, (U) Unmatched, (F) Foreign
AQB__FoodPreferences__c	Food Preferences	PICKLIST (MULTI-SELECT)	Food preferences or restrictions for this Contact.
AQB__Full_Name__c	Full Name	FORMULA (TEXT)(1300)
AQB__Gender__c	Gender	PICKLIST
AQB__Greeting__c	Greeting	TEXT(200)
AQB__Institution__c	Institution	FORMULA (TEXT)(1300)
AQB__InstitutionalArea1Alternate__c	Institutional Area 1 - Alternate	PICKLIST	Alternate Institutional Area 1 assigned to this Contact, if any.
AQB__InstitutionalArea1IsOverridden__c	Institutional Area 1 is Overridden	CHECKBOX	Indicates that the user has overridden the Institutional Area 1 that is associated with the Mailing Address Postal Code.
AQB__InstitutionalArea1__c	Institutional Area 1	PICKLIST	This Institutional Area 1 associated with this Contact.
AQB__InstitutionalArea2Alternate__c	Institutional Area 2 - Alternate	PICKLIST	Alternate Institutional Area 2 assigned to this Contact, if any.
AQB__InstitutionalArea2IsOverridden__c	Institutional Area 2 is Overridden	CHECKBOX	Indicates that the user has overridden the Institutional Area 2 that is associated with the Mailing Address Postal Code.
AQB__InstitutionalArea2__c	Institutional Area 2	PICKLIST	This Institutional Area 2 associated with this Contact.
AQB__InstitutionalArea3Alternate__c	Institutional Area 3 - Alternate	PICKLIST	Alternate Institutional Area 3 assigned to this Contact, if any.
AQB__InstitutionalArea3IsOverridden__c	Institutional Area 3 is Overridden	CHECKBOX	Indicates that the user has overridden the Institutional Area 3 that is associated with the Mailing Address Postal Code.
AQB__InstitutionalArea3__c	Institutional Area 3	PICKLIST	This Institutional Area 3 associated with this Contact.
AQB__InstitutionalArea4Alternate__c	Institutional Area 4 - Alternate	PICKLIST	Alternate Institutional Area 4 assigned to this Contact, if any.
AQB__InstitutionalArea4IsOverridden__c	Institutional Area 4 is Overridden	CHECKBOX	Indicates that the user has overridden the Institutional Area 4 that is associated with the Mailing Address Postal Code.
AQB__InstitutionalArea4__c	Institutional Area 4	PICKLIST	This Institutional Area 4 associated with this Contact.
AQB__InstitutionalSuffixOverride__c	Institutional Suffix Override	TEXT(100)	Use this to override the automated institutional suffix.
AQB__InstitutionalSuffix__c	Institutional Suffix	TEXT(100)	The suffix, if any, that your institution wants to append to Contact names.
AQB__InternalContactMailingStreetOne__c	Internal Contact Mailing Street One	FORMULA (TEXT)(1300)
AQB__InternalContactMailingStreetTwo__c	Internal Contact Mailing Street Two	FORMULA (TEXT)(1300)
AQB__InvolvementRating__c	Involvement	FORMULA (TEXT)(1300)
AQB__InvolvementScore__c	Involvement Score	FORMULA (NUMBER)(16,2)	Holds the score value defined in each Engagement Scoring rule. The score will be accumulated in the corresponding object selected for each rule. The cumulative score will be displayed on the contact record layout.Holds the score value defined in each Engagement Scoring rule. The score will be accumulated in the corresponding object selected for each rule. The cumulative score will be displayed on the contact record layout.
AQB__IsPrimaryContact__c	Is Primary Contact?	FORMULA (TEXT)(1300)
AQB__IsSecondaryContact__c	Is Secondary Contact?	FORMULA (TEXT)(1300)	If Yes, the Contact is the secondary Contact on the Account.
AQB__Languages__c	Languages	TEXT(100)
AQB__LastActivityDate__c	Last Activity Date	DATE
AQB__Latitude__c	Latitude	TEXT(50)	Specifies the north south position of a point on the Earth's surface.
AQB__LegacyContactIDNumber__c	Legacy Contact ID Number	TEXT(40)
AQB__LinkedAddress__c	Alternate Address Link	LOOKUP
AQB__LocationofDeath__c	Location of Death	TEXT(50)
AQB__Longitude__c	Longitude	TEXT(50)	Specifies the east west position of a point on the Earth's surface.
AQB__MaidenName__c	Maiden Name	TEXT(40)	The maiden name of this contact.
AQB__MailingAddressType__c	Mailing Address Type	PICKLIST	A description of the nature of this address, such as residence, business, vacation home, etc.
AQB__MailingDistrict__c	Mailing District	PICKLIST	An institution-defined way to segment contacts by a district code. This is associated with the contact and not a specific address.
AQB__MailingLists__c	Mailing Lists for this Contact	PICKLIST (MULTI-SELECT)	The specific mailings lists which this contact has been assigned.
AQB__MailingLocality__c	Mailing Address Locality	FORMULA (TEXT)(1300)
AQB__MailingNote__c	Mailing Address Note	TEXT(255)
AQB__MailingRegion__c	Mailing Region	PICKLIST	An institution-defined way to segment contacts by a region code. This is associated with the contact and not a specific address.
AQB__MailingStatus__c	Mailing Address Status	PICKLIST
AQB__MailingStreetLineFour__c	Deprecated Contact Mailing Street Line 4	TEXT(200)
AQB__MailingStreetLineOne__c	Deprecated Contact Mailing Street Line 1	TEXT(200)
AQB__MailingStreetLineThree__c	Deprecated Contact Mailing Street Line 3	TEXT(200)
AQB__MailingStreetLineTwo__c	Deprecated Contact Mailing Street Line 2	TEXT(200)
AQB__MailingTimeZone__c	Time Zone	PICKLIST	The time zone assigned to the is contact.
AQB__MaritalStatus__c	Marital Status	PICKLIST
AQB__MobileWork__c	Mobile Work	PHONE
AQB__MostRecentEventAttendanceLink__c	Most Recent Event Attendance Link	LOOKUP
AQB__MostRecentEventAttended__c	Most Recent Event Attended	LOOKUP
AQB__Most_Recent_Event_Attendance_Date__c	Most Recent Event Attendance Date	DATE
AQB__Most_Recent_Event_Registration_Date__c	Most Recent Event Registration Date	DATE
AQB__Most_Recent_Event_Registration_Link__c	Most Recent Event Registration Link	LOOKUP
AQB__Most_Recent_Event_Registration__c	Most Recent Event Registration	LOOKUP
AQB__Name__c	Name	FORMULA (TEXT)(1300)
AQB__NextActivityDate__c	Next Task Date	DATE
AQB__NextActivity__c	Next Task	FORMULA (TEXT)(1300)	The flag indicates status of the next Task for the Contact. White - no future Tasks. Green - Activity due date is at least 14 days away. Yellow - Task due date is within 14 days. Red - Task is overdue.
AQB__Nickname__c	Nickname	TEXT(80)	The nickname of this contact.
AQB__Notifiedby__c	Notified of Death by	TEXT(40)
AQB__Number_of_Events_Attended__c	Number of Events Attended	NUMBER(9,0)
AQB__ObituaryAttached__c	Obituary Attached	CHECKBOX
AQB__ObituaryLink__c	Obituary Link	URL
AQB__OtherEmail__c	Other Email	EMAIL
AQB__OtherPreferences__c	Other Preferences	TEXT AREA (RICH)(32768)	The other event preferences or restrictions for this Contact.
AQB__OwnerUnit__c	Owner Unit	PICKLIST	Designates the Unit of the User that created this record. This field is intended for use in creating Sharing Rules for the purpose of controlling access to the record.
AQB__PNameLink__c	Preferred Name Link	LOOKUP
AQB__PName__c	Preferred Name	FORMULA (TEXT)(1300)	The Preferred Name for this Contact as defined in either the linked Name record or the Contact's Automatic Preferred Name, or formatted by the Preferred Name formula.
AQB__PersonalEmail__c	Personal Email	EMAIL
AQB__PhoneNotes__c	Phone Notes	TEXT(200)
AQB__PhonePreference__c	Phone Preference	PICKLIST
AQB__PlaceofBirth__c	Place of Birth	TEXT(50)
AQB__PreferredYear__c	Pref Year	FORMULA (TEXT)(1300)
AQB__Presentation_Preferences__c	Presentation Preferences	PICKLIST (MULTI-SELECT)	Presentation preferences or restrictions for this Contact.
AQB__PrimaryEmploymentLink__c	Primary Employment Link	LOOKUP	An internal field used to maintain the linkage between a Contact and the primary Employment data.
AQB__PrimaryEmploymentTitle__c	Primary Employment Title	FORMULA (TEXT)(1300)
AQB__PrimaryGiftRecognitionCredit_Percent__c	Legal Credit %	PERCENT(3,2)	The default percentage used to credit a contact with the Legal credit for based on the amount of a gift. This percentage ties back to the gift recognition object and represents the amount that the contact should get financial recognition.
AQB__Pronoun__c	Pronoun	PICKLIST	The pronoun or set of pronouns that the Contact would like others to use when talking to or about that Contact.
AQB__RFM__c	Deprecated RFM	FORMULA (TEXT)(1300)	Deprecated.
AQB__RegionAlternate__c	Region - Alternate	PICKLIST
AQB__RegionIsOverridden__c	Region is Overridden	CHECKBOX	Indicates that the user has overridden the region that is associated with the Mailing Address Postal Code.
AQB__Region__c	Region	PICKLIST
AQB__Relationship__c	Account Relationship	PICKLIST
AQB__ResidentialDeliveryIndicator__c	Residential Delivery Indicator	TEXT(1)	Indicates whether an address is residential (R) or business (B).
AQB__RevertAddressInUseType__c	Revert Address In Use Type	PICKLIST	The address in use type that the contact's mailing address will revert to once a seasonal address expires.
AQB__SalutationLink__c	Salutation Link	LOOKUP
AQB__SchoolEmail__c	School Email	EMAIL
AQB__School__c	School	FORMULA (TEXT)(1300)
AQB__SecondaryGiftRecognitionCreditPercent__c	Gift Recognition Credit %	PERCENT(3,2)	The default percentage used to credit a contact with the gift recognition credit, based on the amount of a gift. This percentage ties back to the gift recognition object and represents the amount that the contact should get for reporting recognition.
AQB__SecondaryType__c	Secondary Contact Types	PICKLIST (MULTI-SELECT)
AQB__Setup__c	Setup	LOOKUP
AQB__Signator__c	Signator	CHECKBOX
AQB__StateId__c	State Id	TEXT(2)	The contact address state id. Intended to be used when integrating with a third party address verification system.
AQB__StateProvinceofDeath__c	State/Province of Death	TEXT(100)
AQB__Suffix__c	Suffix Picklist	PICKLIST
AQB__TotalAccountOpenOpportunities__c	Total Account Open Opportunities	FORMULA (CURRENCY)(16,2)
AQB__TotalEngagementScore__c	Total Engagement Score	FORMULA (NUMBER)(18,0)
AQB__Total_Number_of_Event_Registrations__c	Total Number of Event Registrations	NUMBER(5,0)
AQB__Total_of_All_Registration_Fees__c	Total of All Registration Fees	CURRENCY(9,2)
AQB__Type__c	Contact Type	PICKLIST
AQB__UseAccountAddressOnImport__c	Use Account Address on Import	CHECKBOX
AQB__ValidationDate__c	Validated On	DATETIME	The date the address was validated.
AQB__VerificationFlag__c	Verification Flag	TEXT(10)	The verification flag of the contact address.
aqcv_conversionid__c	aqcv conversionid	TEXT(255)	Unique id
AQB__Degree_Level__c	Degree Level	FORMULA (TEXT)(1300)
AQB__VSEAlumniDegreeCategory__c	VSE Alumni Degree Category	FORMULA (TEXT)(1300)
USyd_Contact_ID__c	Contact ID	AUTO NUMBER	This is another unique identifier for a contact
USyd_Contact_Type_Priority_Order__c	Contact Type Priority Order	FORMULA (NUMBER)(18,0)
USYD_Contact_Mailing_City__c	Contact Mailing City	FORMULA (TEXT)(1300)	USYD_Custom. Used in receipting.
Calc_Receipt_Name__c	Calc Receipt Name	FORMULA (TEXT)(1300)
USYD_Receipt_Name__c	Receipt Name	TEXT(255)	Used for Receipting.
USYD_Best_Contact_Email__c	Best Contact Email	FORMULA (TEXT)(1300)	This is the best email to contact according to this hierarchy: Email Preference, Personal Email, Business Email, Other Email, Student Email
USYD_Contact_Mailing_Continent__c	Contact Mailing Continent	FORMULA (TEXT)(1300)	Defines the Continents of the Contact Mailing Address
USYD_CG_CON_DPID_Location__c	Address DPID	TEXT(100)
Alternate_ID__c	Alternate ID	TEXT(30)
USYD_Special_Category_Flag_Temp__c	Special Category Flag Temp	CHECKBOX	This is temporary, will delete soon after This contains the value in Advance. This will be replaced once the gifts data and formula is finalised.
USYD_Sydney_Metro__c	Metropolitan Area	FORMULA (TEXT)(1300)	Sydney Metro / NSW Non Sydney Metro / Rest of World by postcode
imodules_Alternate_ID__c	imodules Alternate ID	TEXT(50)	Captures External Reference ID from Imodules Lead.
USYD_Degree__c	Degree	FORMULA (TEXT)(1300)	This field holds the full degree name. eg: Bachelor of Science.
USYD_Secondary_Type_Concatenation__c	Secondary Type Concatenation	FORMULA (TEXT)(1300)	This concatenates secondary types for Contacts except Memorial types. Useful in report (e.g formulas)
USYD_Contact_Mailing_Country__c	Contact Mailing Country	FORMULA (TEXT)(1300)	USYD_Custom. Used in receipting.
USYD_Contact_Mailing_State__c	Contact Mailing State/Province	FORMULA (TEXT)(1300)	USYD_Custom. Used in receipting.
USYD_Contact_Mailing_Street__c	Contact Mailing Street	FORMULA (TEXT)(1300)	USYD_Custom. Used in receipting.
USYD_Contact_Mailing_Zip_Postal_Code__c	Contact Mailing Zip/Postal Code	FORMULA (TEXT)(1300)	USYD_Custom. Used in receipting.
USYD_Do_Not_Mail__c	Do Not Mail	CHECKBOX	This indicates that this contact should not be sent communications by post.
USYD_Lost__c	Lost	FORMULA (CHECKBOX)	Lost: a contact who does not have any active modes of contact (excludes LinkedIn URL)
USYD_Preferred_Email__c	Preferred Email	FORMULA (TEXT)(1300)	Captures Email if either or both Do Not Email and Do Not Contact are unchecked.
USYD_Preferred_Phone__c	Preferred Phone	FORMULA (TEXT)(1300)	Captures Phone if either or both Do Not Call and Do Not Contact are unchecked.
USYD_Preferred_Contact_Mailing_Address__c	Preferred Contact Mailing Address	FORMULA (TEXT)(1300)	Captures Address if either or both Do Not Mail and Do Not Contact are unchecked and address is not empty.
Salesforce_ID__c	Salesforce ID	FORMULA (TEXT)(1300)
Usyd_Prospect_Manager__c	Prospect Manager	FORMULA (TEXT)(1300)
USYD_Special_Category__c	Special Category	PICKLIST (MULTI-SELECT)
AQB__EngagementScoreCategory__c	Engagement Score Category	PICKLIST	Identifies the category group the engagement score will be totaled in to.
AQB__EngagementScoreOverride__c	Engagement Score Override	CHECKBOX	This field will be used to change the value of the score manually to a value that does not meet the criteria of the defined rule within the Engagement Score parameter.
AQB__EngagementScore__c	Engagement Score	NUMBER(4,0)	This field holds the score value associated with an override.
AQB__ProfessionalSuffix__c	Professional Suffix	TEXT(40)
USYD_Duplicate_Review_Complete__c	Duplicate Review Complete	CHECKBOX	Exclude from duplicate rule evaluation if True
Usyd_Is_Notable_Alumni__c	Is Influential Alumni	CHECKBOX	DEceased: Is Notable Alumni equal to true if there exist and accolade name of Notable Alumni Note: Field is re purposed for AVE-113
Usyd_RTS_Reason__c	RTS Reason	PICKLIST	Return To Sender Reason. Other will be tracked in the mailing address note field.
USyd_Has_Children__c	Has Children	PICKLIST	Number of children
USyd_Other_Family_Relations__c	Other Family Relations	PICKLIST
Usyd_Account_ID_Name__c	Account ID Name	FORMULA (TEXT)(1300)	Field used in search layout to display account ID and Account Name
Usyd_Business_Email_Modified_By__c	Business Email Modified By	LOOKUP
Usyd_Business_Email_Modified_Date__c	Business Email Modified Date	DATETIME
Usyd_Business_Email_Modified_Source__c	Business Email Modified Source	PICKLIST
Usyd_Mailing_Address_Modified_By__c	Mailing Address Modified By	LOOKUP
Usyd_Mailing_Address_Modified_Date__c	Mailing Address Modified Date	DATETIME
Usyd_Mailing_Address_Modified_Source__c	Mailing Address Modified Source	PICKLIST
Usyd_Mobile_Modified_By__c	Mobile Modified By	LOOKUP
Usyd_Mobile_Modified_Date__c	Mobile Modified Date	DATETIME
Usyd_Mobile_Modified_Source__c	Mobile Modified Source	PICKLIST
Usyd_Other_Email_Modified_By__c	Other Email Modified By	LOOKUP
Usyd_Other_Email_Modified_Date__c	Other Email Modified Date	DATETIME
Usyd_Other_Email_Modified_Source__c	Other Email Modified Source	PICKLIST
Usyd_Personal_Email_Modified_By__c	Personal Email Modified By	LOOKUP
Usyd_Personal_Email_Modified_Date__c	Personal Email Modified Date	DATETIME
Usyd_Personal_Email_Modified_Source__c	Personal Email Modified Source	PICKLIST
Usyd_School_Email_Modified_By__c	School Email Modified By	LOOKUP
Usyd_School_Email_Modified_Date__c	School Email Modified Date	DATETIME
Usyd_School_Email_Modified_Source__c	School Email Modified Source	PICKLIST
AQB__DummyText_AQ__c	Dummy Text	TEXT(50)	This is a system use only field, do not add to Form or Reports
AQB__PrimaryLanguage__c	Primary Language	PICKLIST
AQB__MultiEthnicity__c	Multi Ethnicity	PICKLIST (MULTI-SELECT)
pmdm__ConsecutiveAbsences__c	Consecutive Absences	NUMBER(18,0)
pmdm__IsClient__c	Client	CHECKBOX
pmdm__LastServiceDate__c	Last Service Date	DATE
pmdm__NumAbsentServiceDeliveries__c	Number of Absent Service Deliveries	NUMBER(18,0)
pmdm__NumPresentServiceDeliveries__c	Number of Present Service Deliveries	NUMBER(18,0)
pmdm__AttendanceRate__c	Attendance Rate	FORMULA (PERCENT)(18,0)
pmdm__AttendanceSummary__c	Attendance Summary	FORMULA (TEXT)(1300)
caseman__AgeCategory__c	Age Category	PICKLIST
caseman__Age__c	Age	FORMULA (NUMBER)(18,0)
caseman__ClientID__c	Client ID	TEXT(100)	If you have Client IDs for your clients you can import them to this field.
caseman__EmergencyContactRole__c	Emergency Contact Role	TEXT(255)	The relationship between the Contact and their Emergency Contact.
caseman__EmergencyContact__c	Emergency Contact	LOOKUP
caseman__LegalName__c	Legal Name	TEXT(255)	The legal name of the Contact. Use this field if you need to track legal name for administrative reasons or to assist Contact with official paperwork.
caseman__PhotoFileID__c	Photo File ID	TEXT(18)	An ID generated and used by Salesforce to manage Client Photo files. Not intended for page layouts.
caseman__PreferredCommunicationMethod__c	Preferred Communication Method	PICKLIST	The Contact's preferred communication method. Values are determined by your Admin.
caseman__PreferredPhoneField__c	Preferred Phone Field	PICKLIST	The contact's preferred phone number field, will update the Preferred Phone Number field.
caseman__PreferredPhoneNumber__c	Preferred Phone Number	PHONE	This field is controlled by the Preferred Phone Field picklist.
caseman__Pronouns__c	Pronouns	PICKLIST	The pronoun set used by the client to refer to themself.
caseman__WatchListDate__c	Watch List Date	DATE	The date you added the client to the Watch List.
caseman__WatchList__c	Watch List	CHECKBOX	Check this checkbox if this client requires heightened attention by staff.
caseman__EmergencyContactPhone__c	Emergency Contact Phone	FORMULA (TEXT)(1300)
sumoapp__CreatedBySumo__c	Created By SUMO	CHECKBOX
sumoapp__IsGhost__c	Is Ghost	CHECKBOX
sumoapp__TextOptIn__c	Text Opt In	CHECKBOX
sumoapp__VoiceOptOut__c	Phone Reminder Opt Out	CHECKBOX
USDY_Wellness_PrivatelyManagedAccom__c	Privately Managed Accommodation	PICKLIST
USYD_ATSIAboriginalandTorrensStraitIslan__c	Aboriginal and Torrens Strait Islander	PICKLIST
USYD_Academic_Plans_Exist__c	Academic Plans Exist	PICKLIST	Information to confirm if Academic Plans Exist or not
USYD_Account_Balance__c	Account Balance	CURRENCY(16,2)	Information on if the student Owes money to the university
USYD_Affiliated_Organisations__c	Affiliated Organisations	PICKLIST (MULTI-SELECT)
USYD_Citizenship__c	Citizenship	PICKLIST
USYD_Country_of_Citizenship__c	Country of Citizenship	TEXT(255)
USYD_Country_of_Origin__c	Country of Origin	PICKLIST
USYD_Email_Alert_Recipient__c	Email Alert Recipient	EMAIL	This field is populated on the flow based on existence of Preferred Email and Contact Email fields. This field will be the Recipient of certain Email Alerts
USYD_IsAlumni__c	IsAlumni	CHECKBOX
USYD_IsInternational__c	USYD IsInternational	TEXT(80)
USYD_IsStaff__c	IsStaff	CHECKBOX
USYD_IsStudent__c	IsStudent	CHECKBOX
USYD_LGBTIQA__c	LGBTIQA	PICKLIST
USYD_Language_Barrier__c	Language Barrier	PICKLIST
USYD_Level_of_Study__c	Level of Study	PICKLIST
USYD_Next_Of_Kin__c	Next Of Kin	CHECKBOX
USYD_Part_time__c	Part time	CHECKBOX
USYD_Preferred_Address_Wellness__c	Preferred Address	TEXT AREA(255)	Preferred Address entered by the intake officer during the intake
USYD_Preferred_Contact_no_wellness__c	Preferred Contact no	TEXT(15)	Preferred contact no captured by intake officer during case investigation
USYD_Preferred_E_mail_wellness__c	Preferred E-mail	EMAIL	Preferred e-mail address captured by the intake officer during the intake process
USYD_Preferred_Name_wellness__c	Preferred Name	TEXT(100)	Preferred Name for wellness app
USYD_Special_Care_Plan__c	Special Care Plan	CHECKBOX	SLO will select this if a Special care plan is needed
USYD_Staff_ID__c	Staff ID	TEXT(10)
Usyd_Formal_Salutation__c	Formal Salutation	FORMULA (TEXT)(1300)	AVE-39. Dear ‘xxx’ at the top of the letter or formal email
USYD_Sydney_Student_ID__c	Sydney Student ID	TEXT(100)
USYD_Under_Age__c	Under Age	FORMULA (CHECKBOX)
USYD_Unikey__c	Unikey	TEXT(15)
USYD_Visa_Type__c	Visa Type	PICKLIST
USYD_Vulnerable_Contact__c	USYD Vulnerable Contact	CHECKBOX
USYD_Wellness_External_Support__c	External Support	PICKLIST (MULTI-SELECT)
USYD_Wellness_Internal_Support__c	Internal Support	PICKLIST (MULTI-SELECT)
USYD_Wellness_Living_at_home__c	Living at home	PICKLIST
USYD_Wellness_Other_Accommodation__c	Other Accommodation	TEXT(40)
USYD_Wellness_Primary_Faculty__c	Primary Faculty	PICKLIST	Primary Faculty selected by wellness team when the student is part of multiple faculties
USYD_Wellness_Private_Rental__c	Private Rental	PICKLIST
USYD_Wellness_Residential_College__c	Residential College	PICKLIST
USYD_Wellness_Student_Current_Accom__c	Student Current Accommodation Type	PICKLIST
USYD_Wellness_Student_Living_Arrangement__c	Student Living Arrangement	PICKLIST
USYD_Wellness_University_Owned_Accom__c	University Owned Accomodation	PICKLIST
USYD_wellness_Trim_Record__c	Safer Communities Record Exists in RMS	CHECKBOX
USYD_wellness_contact__c	Wellness Contact	CHECKBOX	This flag identifies that the field identifies that the contact is created by Wellness team
Usyd_Account_Email_Modified_By__c	Account Email Modified By	LOOKUP
Usyd_Account_Email_Modified_Date__c	Account Email Modified Date	DATETIME
Usyd_Account_Phone_Modified_By__c	Account Phone Modified By	LOOKUP
Usyd_Account_Phone_Modified_Date__c	Account Phone Modified Date	DATETIME
Usyd_Account_Phone_Modified_Source__c	Account Phone Modified Source	PICKLIST
Usyd_Average_Legal_Credit__c	Average Legal Credit	NUMBER(16,2)	This stores the average Legal Credit of all Gift recognition credits related to the Contact
Usyd_Consecutive_Years__c	Consecutive Years	NUMBER(18,0)	Count of number of years given from current year backwards consecutively
Usyd_Email_Modified_By__c	Email Modified By	LOOKUP
Usyd_Email_Modified_Date__c	Email Modified Date	DATETIME
Usyd_Email_Modified_Source__c	Email Modified Source	PICKLIST
Usyd_Largest_Legal_Credit__c	Largest Legal Credit	NUMBER(16,2)	This stores the Largest Legal Credit of all Gift recognition credits related to the Contact
Usyd_Most_Recent_Legal_Credit_Amount__c	Most Recent Legal Credit Amount	NUMBER(16,2)	Most Recent Legal Credit Amount
Usyd_Most_Recent_Legal_Credit_Campaign__c	Most Recent Legal Credit Campaign	TEXT(255)
Usyd_Most_Recent_Legal_Credit_Date__c	Most Recent Legal Credit Date	DATE
Usyd_Open_Opportunities_Amount__c	Open Opportunities Amount	NUMBER(16,2)	AVE-84: This field holds the value of the total amount in opportunity linked to the account of the contact where status is not closed.
Usyd_Open_Pledge_Amount__c	Open Pledge Amount	CURRENCY(16,2)	Ave-84: This is to hold value by calculating all pledges balance and get the LC based on GRC.
Usyd_Phone_Modified_By__c	Phone Modified By	LOOKUP
Usyd_Phone_Modified_Date__c	Phone Modified Date	DATETIME
Usyd_Phone_Modified_Source__c	Phone Modified Source	PICKLIST
Usyd_Recurring_Gift__c	Recurring Gift #	NUMBER(18,0)	AVE-332: This is to hold the number of recurring gifts in which status are either active, under investigation, pending review.
Usyd_Total_Credit_Amount__c	Total Legal Credit	NUMBER(16,2)	This stores the sum of all Gift recognition credits related to the Contact
Usyd_Total_Giving_Influence__c	Total Giving Influence	NUMBER(16,2)	AVE-332: This is calculated same as Total Credit Amount but using the GRC % on contact record.
Usyd_Total_Years_Given__c	Total Years Given	NUMBER(18,0)	Total Years Given
flag1__c	flag1	TEXT(1)
Usyd_Informal_Salutation__c	Informal Salutation	FORMULA (TEXT)(1300)	AVE-39. Informal email or letter
Usyd_Mailing_Name__c	Mailing Name	FORMULA (TEXT)(1300)	AVE_Mailing_Name AVE-39: Purpose: Used for Outer envelope, address block
USYD_CampaignSummaryLastModifiedDate__c	Campaign Summary Last Modified Date	DATE
USYD_MostRecentCampaignInteractionDate__c	Most Recent Campaign Interaction Date	DATE
USYD_Most_Recent_Campaign_Interacted__c	Most Recent Campaign Interacted	LOOKUP
USYD_No_of_Campaigns_Clicked_LY__c	No. of Campaigns Clicked Last Year	NUMBER(18,0)
USYD_No_of_Campaigns_Clicked_YTD__c	No. of Campaigns Clicked YTD	NUMBER(18,0)
USYD_No_of_Campaigns_Participated_LY__c	No. of Campaigns Participated Last Year	NUMBER(18,0)
USYD_No_of_Campaigns_Participated_YTD__c	No. of Campaigns Participated YTD	NUMBER(18,0)
USYD_No_of_Campaigns_Registered_LY__c	No. of Campaigns Registered Last Year	NUMBER(18,0)
USYD_No_of_Campaigns_Registered_YTD__c	No. of Campaigns Registered YTD	NUMBER(18,0)
USYD_No_of_TAP_eNewsletters_Clicked_LY__c	No. of TAP eNewsletters Clicked Last Yr	NUMBER(18,0)
USYD_No_of_TAP_eNewsletters_Clicked_YTD__c	No. of TAP eNewsletters Clicked YTD	NUMBER(18,0)
USYD_Total_Campaigns_Received_LY__c	Total Campaigns Received Last Year	NUMBER(18,0)
USYD_Total_Campaigns_Received_YTD__c	Total Campaigns Received YTD	NUMBER(18,0)
bt_stripe__Default_Payment_Gateway__c	Default Payment Gateway	LOOKUP	This field is automatically set from the related Default Payment Method's Payment Gateway.
bt_stripe__Default_Payment_Method__c	Default Payment Method	LOOKUP	Latest payment method will be automatically populated, but can be updated.
bt_stripe__Gender__c	Gender	PICKLIST
bt_stripe__Maiden_Name__c	Maiden Name	TEXT(255)
bt_stripe__Personal_ID_Number_Encrypted__c	Personal ID Number	TEXT (ENCRYPTED)(175)	The government-issued ID number of the account representative, as appropriate for the representative's country (e.g., a Social Security Number in the U.S. or a Social Insurance Number in Canada)
bt_stripe__Personal_ID_Type__c	Personal ID Type	PICKLIST
bt_stripe__Primary_Stripe_Customer__c	Primary Stripe Customer	CHECKBOX
bt_stripe__SSN_Last_4_Encrypted__c	SSN Last 4	TEXT (ENCRYPTED)(4)	The last 4 digits of the Social Security Number of the account representative (U.S. only)
USYD_Address_Type__c	Address Type	PICKLIST	This field categorizes the type of Address provided and how it is used.
USYD_Email_Type__c	Email Type	PICKLIST	This field categorizes the type of email provided and how it is used.
USYD_Phone_Type__c	Phone Type	PICKLIST	This field categorizes the type of phone number provided and how it is used.

Validation rules

Name	Label

Name	Label
Canadian_Postal_Code_in_Mailing_Address	Canadian_Postal_Code_in_Mailing_Address
Contact_Mailing_Street_One	Contact_Mailing_Street_One
Contact_Mailing_Street_Three	Contact_Mailing_Street_Three
Contact_Mailing_Street_Two	Contact_Mailing_Street_Two
Greeting	Greeting
No_Account_Phone_Change	No_Account_Phone_Change
No_Business_Email	No_Business_Email
No_Business_Phone	No_Business_Phone
No_Business_Phone_Change	No_Business_Phone_Change
No_Mobile_Phone	No_Mobile_Phone
No_Other_Email	No_Other_Email
No_Personal_Email	No_Personal_Email
No_School_Email	No_School_Email
Primary_Credit_Percent_Too_Large	Primary_Credit_Percent_Too_Large
Recognition_Credit_Percent_Sum_Too_Large	Recognition_Credit_Percent_Sum_Too_Large
Secondary_Credit_Less_Than_Primary_Credi	Secondary_Credit_Less_Than_Primary_Credi
Secondary_Credit_Percent_Too_Large	Secondary_Credit_Percent_Too_Large
Too_Many_Contact_Mail_Add_Street_Lines	Too_Many_Contact_Mail_Add_Street_Lines
US_Postal_Code_in_Mailing_Address	US_Postal_Code_in_Mailing_Address
Valid_Canada_Prov_in_Mail_Address_Abbrev	Valid_Canada_Prov_in_Mail_Address_Abbrev
Valid_Canadian_Province_in_Mail_Address	Valid_Canadian_Province_in_Mail_Address
Valid_US_State_in_Mailing_Address	Valid_US_State_in_Mailing_Address
Valid_US_State_in_Mailing_Address_Abbrev	Valid_US_State_in_Mailing_Address_Abbrev
USyd_Contact_AU_Mobile_Validation	USyd_Contact_AU_Mobile_Validation
USyd_No_FIrst_Name	USyd_No_FIrst_Name
USyd_No_Phone_or_Email	USyd_No_Phone_or_Email
Usyd_Contact_Phone_Validation	Usyd_Contact_Phone_Validation
LC_and_GRC_blank_for_household	LC_and_GRC_blank_for_household
Email_is_Required	Email_is_Required
StaffID_is_Mandatory	StaffID_is_Mandatory
USYD_MA_Email_Type_is_Mandatory	USYD_MA_Email_Type_is_Mandatory
USYD_MA_Phone_Type_is_Mandatory	USYD_MA_Phone_Type_is_Mandatory
USYD_MA_Address_Type_is_Mandatory	USYD_MA_Address_Type_is_Mandatory

Triggers

Name	Label

Name	Label
ContactTrigger	AQB.ContactTrigger
Contact	sumoapp.Contact
Contact_Gen	bt_stripe.Contact_Gen

Fields Details

Name	Id
Label	Contact ID
Type	ID
Required	Yes

Name	IsDeleted
Label	Deleted
Type	CHECKBOX
Required	Yes
Default value	false

Name	MasterRecordId
Label	Master Record ID
Type	LOOKUP
Foreign key	Yes

Name	AccountId
Label	Account ID
Type	LOOKUP
Foreign key	Yes

Name	LastName
Label	Last Name
Type	TEXT(80)
Required	Yes

Name	FirstName
Label	First Name
Type	TEXT(40)

Name	Salutation
Label	Salutation
Type	PICKLIST
Picklist values	Mr Ms Mrs Counselor Countess Dame Dato Dato Dr Dato The Honourable Dato' Dr Dato' Sri Datuk Datuk Dr Daw Deaconess Deputy Director Detective Superintendent Councillor Director Doctor Dr Dr & Mrs Dr Dame Dr Sir Drs Emerita Professor Emeritus Professor Emeritus Professor Dame Emeritus Professor Sir Emeritus Professor The Ho Father Flight Lieutenant Former Senator Dr Fr General Group Captain H E Dr H E Major General H E Sir H M King HE The Rt Rev Dr Her Excellency Her Excellency Dr Her Excellency Mrs Her Excellency the Honourable Her Hon Judge Her Honour Her Worship His Beatitude His Excellency His Excellency Archbishop His Excellency Dr His Excellency Leiataua D His Excellency Mr His Excellency the Hon His Grace His Hon Dr His Hon Judge His Hon Magistrate His Hon Mr His Honour Judge His Majesty King His Worship Hon Hon Associate Professor Hon Justice Hon Mr & Mrs Honorary Professor Ing Inspector Judge Justice Khunying King Lady Lady Evang Lieutenant Lieutenant Colonel Lieutenant Commander Lieutenant General Sir Lieutenant-General Sir Lord Lt General M Ma Madam Madame Maestro Major Major General Major General Sir Major-General Maq Master Mdm Mis Miss Miss/Mr Miss` Mme Mr & Mrs Mr Justice Mr/Mrs Mr/Ms Mrs/Mr Ms/Mr Ms/Ms Mx N Ns Pastor Presbytera President President Monsieur Prince Principal Naval Engineer Prof Prof & Mrs Professor Professor & Mrs Professor Dame Professor Dato' Ar Professor Dato' Dr Professor Datuk Dr Professor Dr Professor Dr Ir Professor Emerita Professor Emeritus Professor Lord Professor Sir Professor The Hon Professsor Puan Rabbi Rabbi Dr raMiss Ratu Rear Admiral Rear Admiral Sir Rev Rev Dr Rev Canon Rev Fr Rev'd Reverend Reverend Brother Reverend Canon Reverend Canon Dr Reverend Dr Reverend Father Reverend Rabbi Reverend the Hon Dr Rt Hon Sir Rt Rev Dr Senator Senator The Hon Senior Constable Sir Sir / Madam Sister Squadron Leader Sr Sub Lieutenant Superintendent Swami Tan Sri Tan Sri Data Tan Sri Datuk Dr The Hon The Hon Associate Justice The Hon Chief Justice The Hon Dame The Hon Dr The Hon Emer Professor The Hon Judge The Hon Justice The Hon Mr The Hon Mr Justice The Hon Mrs The Hon Professor The Hon Sir The Hon. Rev. Prof. The Honourable The Honourable Dr The Most Rev The Most Rev Dr The Most Rev Sir The Most Reverend Bishop The Rev The Rev Canon The Rev Dr The Rev Fr The Rev Mr The Rev Msgr The Rev Professor The Rev Sir The Rev The Hon The Rev'd Canon Dr The Reverend The Reverend Canon The Right Hon The Right Rev The Right Rev Dr The Rt Hon The Rt Hon Sir The Rt Hon the Lord The Rt Hon The Lord Mayor The Rt Rev The Venerable The Very Rev The Very Reverend Father Ven Venerable Master Vice Admiral Vice-Admiral Viscount Wing Commander YAB Tan Sri Dr YB YB Dato' YB Tan Sri Dato' Dr * - A/ V Marshall Adjprof Air Chief Marshall Air Chief Marshall Sir Air Commodore Air Marshal Air Vice Marshal Air Vice-Marshal Ambassador Archbishop Assistant Professor Adjunct Assoc Professor Adjunct Professor Admiral Assoc Prof (Dr) Associate Prof Associate Professor Associate Professor Dr Ayatollah Sheikh Baroness Bishop Br Brigadier Brigadier Sir Brother Canon Captain Chancellor Chief Justice Cl Assoc Prof Clinical Assoc Professor Clinical Associate Prof Clinical Professor Colonel Commander Commissioner Commodore Consul Corporal

Name	MiddleName
Label	Middle Name
Type	TEXT(40)

Name	Suffix
Label	Suffix
Type	TEXT(40)

Name	Name
Label	Full Name
Type	TEXT(121)
Required	Yes

Name	OtherStreet
Label	Other Street
Type	TEXT AREA(255)

Name	OtherCity
Label	Other City
Type	TEXT(40)

Name	OtherState
Label	Other State/Province
Type	TEXT(80)

Name	OtherPostalCode
Label	Other Zip/Postal Code
Type	TEXT(20)

Name	OtherCountry
Label	Other Country
Type	TEXT(80)

Name	OtherLatitude
Label	Other Latitude
Type	NUMBER(3,15)

Name	OtherLongitude
Label	Other Longitude
Type	NUMBER(3,15)

Name	OtherGeocodeAccuracy
Label	Other Geocode Accuracy
Type	PICKLIST
Picklist values	Address NearAddress Block Street ExtendedZip Zip Neighborhood City County State Unknown

Name	OtherAddress
Label	Other Address
Type	AUTO NUMBER

Name	MailingStreet
Label	Contact Mailing Street
Type	TEXT AREA(255)

Name	MailingCity
Label	Contact Mailing City
Type	TEXT(40)

Name	MailingState
Label	Contact Mailing State/Province
Type	TEXT(80)

Name	MailingPostalCode
Label	Contact Mailing ZIP/Postal Code
Type	TEXT(20)

Name	MailingCountry
Label	Contact Mailing Country
Type	TEXT(80)

Name	MailingLatitude
Label	Contact Mailing Latitude
Type	NUMBER(3,15)

Name	MailingLongitude
Label	Contact Mailing Longitude
Type	NUMBER(3,15)

Name	MailingGeocodeAccuracy
Label	Mailing Geocode Accuracy
Type	PICKLIST
Picklist values	Address NearAddress Block Street ExtendedZip Zip Neighborhood City County State Unknown

Name	MailingAddress
Label	Contact Mailing Address
Type	AUTO NUMBER

Name	Phone
Label	Business Phone
Type	PHONE

Name	Fax
Label	Business Fax
Type	PHONE

Name	MobilePhone
Label	Mobile Phone
Type	PHONE

Name	HomePhone
Label	Home Phone
Type	PHONE

Name	OtherPhone
Label	Other Phone
Type	PHONE

Name	AssistantPhone
Label	Asst. Phone
Type	PHONE

Name	ReportsToId
Label	Reports To ID
Type	LOOKUP
Foreign key	Yes

Name	Email
Label	Email
Type	EMAIL

Name	Title
Label	Title
Type	TEXT(128)

Name	Department
Label	Department
Type	TEXT(80)

Name	AssistantName
Label	Assistant's Name
Type	TEXT(40)

Name	LeadSource
Label	Lead Source
Type	PICKLIST
Picklist values	Purchased List External Referral Planned Giving Alumni Engagement Major Giving Prospect Development Academic Referral Community Giving University Referral Grateful Patient Referral Rented List

Name	Birthdate
Label	Birthdate
Type	DATE

Name	Description
Label	Contact Description
Type	TEXT AREA (LONG)(32000)

Name	OwnerId
Label	Owner ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	HasOptedOutOfEmail
Label	Email Opt Out
Type	CHECKBOX
Required	Yes
Default value	false

Name	HasOptedOutOfFax
Label	Fax Opt Out
Type	CHECKBOX
Required	Yes
Default value	false

Name	DoNotCall
Label	Do Not Call
Type	CHECKBOX
Required	Yes
Default value	false

Name	CreatedDate
Label	Created Date
Type	DATETIME
Required	Yes

Name	CreatedById
Label	Created By ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	LastModifiedDate
Label	Last Modified Date
Type	DATETIME
Required	Yes

Name	LastModifiedById
Label	Last Modified By ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	SystemModstamp
Label	System Modstamp
Type	DATETIME
Required	Yes

Name	LastActivityDate
Label	Last Activity
Type	DATE

Name	LastCURequestDate
Label	Last Stay-in-Touch Request Date
Type	DATETIME

Name	LastCUUpdateDate
Label	Last Stay-in-Touch Save Date
Type	DATETIME

Name	LastViewedDate
Label	Last Viewed Date
Type	DATETIME

Name	LastReferencedDate
Label	Last Referenced Date
Type	DATETIME

Name	EmailBouncedReason
Label	Email Bounced Reason
Type	TEXT(255)

Name	EmailBouncedDate
Label	Email Bounced Date
Type	DATETIME

Name	IsEmailBounced
Label	Is Email Bounced
Type	CHECKBOX
Required	Yes
Default value	false

Name	PhotoUrl
Label	Photo URL
Type	URL

Name	Jigsaw
Label	Data.com Key
Type	TEXT(20)

Name	JigsawContactId
Label	Jigsaw Contact ID
Type	TEXT(20)

Name	IndividualId
Label	Individual ID
Type	LOOKUP
Foreign key	Yes

Name	Pronouns
Label	Pronouns
Type	PICKLIST
Picklist values	He/Him She/Her They/Them He/They She/They Not Listed

Name	GenderIdentity
Label	Gender Identity
Type	PICKLIST
Picklist values	Male Female Nonbinary Not Listed

Name	HasPrivacyHold
Label	Privacy Hold
Type	CHECKBOX
Required	Yes
Default value	false

Name	AQB__ANLink__c
Label	Alternate Name Link
Type	LOOKUP
Foreign key	Yes
Help Text	Link to the Name row that should be used as the Alternate Name,

Name	AQB__AName__c
Label	Alternate Name
Type	FORMULA (TEXT)(1300)
Help Text	The Alternate Name for this Contact as defined in either the linked Name record or the Contact's Automatic Alternate Name, or formatted by the Alternate Name formula.
Description	The Alternate Name for this Contact as defined in either the linked Name record or the Contact's Automatic Alternate Name, or formatted by the Alternate Name formula.

Name	AQB__AccessibilityPreferences__c
Label	Accessibility Preferences
Type	PICKLIST (MULTI-SELECT)
Help Text	Accessibility preferences or restrictions for this Contact.
Picklist values	Wheelchair Access Close to the Door No Stairs Must have a Chair
Description	Accessibility preferences or restrictions for ths Contact.

Name	AQB__AccountCapacity__c
Label	Account Capacity
Type	FORMULA (TEXT)(1300)
Help Text	An institution-defined set of values, meant to describe the amount a prospect might be able to give.
Description	An institution-defined set of values, meant to describe the amount a prospect might be able to give.

Name	AQB__AccountMailingAddressType__c
Label	Account Mailing Address Type
Type	FORMULA (TEXT)(1300)
Help Text	A description of the nature of the address information, such as residence, business, etc.
Description	A description of the nature of the address information, such as residence, business, etc.

Name	AQB__AccountMailingAddress__c
Label	Account Mailing Address
Type	FORMULA (TEXT)(1300)
Help Text	Default Street, Default City, Default State/Province, Default PostalCode, and Default Country (if not USA) formatted for use to display on the Contact screen and HTML emails. This field should not be used in mail merges.

Name	AQB__AccountMailingCity__c
Label	Account Mailing Address City
Type	FORMULA (TEXT)(1300)

Name	AQB__AccountMailingCountry__c
Label	Account Mailing Address Country
Type	FORMULA (TEXT)(1300)
Help Text	If left blank or "US", "USA" or "United States"is entered, US formatting rules are applied to postal code and state names. If "Canada", or "CN" is entered, then Canadian rules are applied. Any other country name allows any data in those fields.

Name	AQB__AccountMailingCounty__c
Label	Account Mailing Address County
Type	FORMULA (TEXT)(1300)

Name	AQB__AccountMailingLocality__c
Label	Account Mailing Address Locality
Type	FORMULA (TEXT)(1300)
Help Text	Single field containing the City, State/Province, Postal Code, and Country of the Account Mailing Address.

Name	AQB__AccountMailingNote__c
Label	Account Mailing Address Note
Type	FORMULA (TEXT)(1300)
Help Text	This field may be used to attach any brief information regarding this Account Address.
Description	This field may be used to attach any brief information regarding this Account Address.

Name	AQB__AccountMailingPostalCode__c
Label	Account Mailing Address Zip/Postal Code
Type	FORMULA (TEXT)(1300)

Name	AQB__AccountMailingState__c
Label	Account Mailing Address State/Province
Type	FORMULA (TEXT)(1300)

Name	AQB__AccountMailingStatus__c
Label	Account Mailing Address Status
Type	FORMULA (TEXT)(1300)
Help Text	The Status indicates the relative mailability of this address. See the link 'Help for this Page' under Affinaquest Links for a full explanation.

Name	AQB__AccountMailingStreet__c
Label	Account Mailing Address Street
Type	FORMULA (TEXT)(1300)

Name	AQB__AccountPhone__c
Label	Account Phone
Type	FORMULA (TEXT)(1300)
Help Text	Phone at account mailing address.

Name	AQB__AccountReadiness__c
Label	Account Readiness
Type	FORMULA (TEXT)(1300)
Help Text	An institution-defined set of values, meant to describe the preparedness of the prospect to give or the status of the prospect's cultivation.
Description	An institution-defined set of values, meant to describe the preparedness of the prospect to give or the status of the prospect's cultivation.

Name	AQB__AdditionalInstitutionalSuffix__c
Label	Additional Institutional Suffix
Type	TEXT(50)
Help Text	Any additional information you want added to the institutional suffix.
Description	Any additional information you want added to the institutional suffix.

Name	AQB__AddressChangeFlags__c
Label	Address Change Flags
Type	TEXT(100)
Help Text	Contains comma separated codes that specify the portion of the address that was changed or modified.
Description	Contains comma separated codes that specify the portion of the address that was changed or modified.

Name	AQB__AddressInUseText__c
Label	Address Preference
Type	FORMULA (TEXT)(1300)
Help Text	Indicates if the Contact's Mailing Address is the Account Mailing Address, an Alternate Address, or the Business Address.

Name	AQB__AddressInUseType__c
Label	Address Preference
Type	PICKLIST
Help Text	A read-only field used to indicate what type of address the contact current mailing address is associate The valid values are 'Account Mailing', 'Business' or 'Alternate'.
Picklist values	Account Mailing Business Alternate
Description	Used to set the current mailing address to 'Account Mailing', 'Business' or 'Alternate'.

Name	AQB__Age__c
Label	Age
Type	FORMULA (NUMBER)(18,0)
Help Text	The computed age of this contact based upon the birth date.

Name	AQB__Alert__c
Label	Alert
Type	TEXT AREA (LONG)(4000)
Help Text	An alert that should display whenever the Contact is displayed.

Name	AQB__AutomatedAlternateName__c
Label	Automated Alternate Name
Type	TEXT(200)
Help Text	This is the Alternate Name that is formatted by using the Name Definition flagged for the Alternate Name.
Description	This is the Alternate Name that is formatted by using the Name Definition flagged for the Alternate Name.

Name	AQB__AutomatedCommunityName__c
Label	Automated Community Name
Type	TEXT(200)
Help Text	This is the Community Name that is formatted by using the Name Definition flagged for the Community Name.
Description	This is the Community Name that is formatted by using the Name Definition flagged for the Community Name.

Name	AQB__AutomatedDefaultAddressSalutation__c
Label	Automated Default Address Salutation
Type	TEXT(200)
Help Text	This is the Default Address Salutation that is formatted by using the Name Definition flagged for the Default Address Salutation.
Description	This is the Default Address Salutation that is formatted by using the Name Definition flagged for the Default Address Salutation.

Name	AQB__AutomatedDefaultGreetingSalutation__c
Label	Automated Default Greeting Salutation
Type	TEXT(200)
Help Text	This is the Default Greeting Salutation that is formatted by using the Name Definition flagged for the Default Greeting Salutation.
Description	This is the Default Greeting Salutation that is formatted by using the Name Definition flagged for the Default Greeting Salutation.

Name	AQB__AutomatedFormalName__c
Label	Automated Formal Name
Type	TEXT(200)
Help Text	This is the Formal Name that is formatted by using the Name Definition flagged for the Formal Name.
Description	This is the Formal Name that is formatted by using the Name Definition flagged for the Formal Name.

Name	AQB__AutomatedPreferredName__c
Label	Automated Preferred Name
Type	TEXT(200)
Help Text	This is the Preferred Name that is formatted by using the Name Definition flagged for the Preferred Name.
Description	This is the Preferred Name that is formatted by using the Name Definition flagged for the Preferred Name.

Name	AQB__AwardGiftCredit__c
Label	Award Gift Credit
Type	CHECKBOX
Required	Yes
Help Text	If checked, this contact will default to receiving a gift credit when a gift is processed for the account to which it is associated. This is now set through a workflow associated with the primary and secondary gift credit recognition percentages.
Default value	false

Name	AQB__BusinessAddressCity__c
Label	Business Address City
Type	FORMULA (TEXT)(1300)

Name	AQB__BusinessAddressCountry__c
Label	Business Address Country
Type	FORMULA (TEXT)(1300)

Name	AQB__BusinessAddressLocality__c
Label	Business Address Locality
Type	FORMULA (TEXT)(1300)

Name	AQB__BusinessAddressNote__c
Label	Business Address Note
Type	FORMULA (TEXT)(1300)
Help Text	Any free text information you wish to enter regarding this address that is not otherwise maintained.
Description	Any free text information you wish to enter regarding this address that is not otherwise maintained.

Name	AQB__BusinessAddressPostalCode__c
Label	Business Address Postal Code
Type	FORMULA (TEXT)(1300)

Name	AQB__BusinessAddressStatePro__c
Label	Business Address State/Province
Type	FORMULA (TEXT)(1300)

Name	AQB__BusinessAddressStatus__c
Label	Business Address Status
Type	FORMULA (TEXT)(1300)
Help Text	A description of the validity of this business address. A status of 'Returned by the Post Office' might be used as an intermediate step before declaring an address to be 'Lost'.
Description	A description of the validity of this business address. A status of 'Returned by the Post Office' might be used as an intermediate step before declaring an address to be 'Lost'.

Name	AQB__BusinessAddressStreet__c
Label	Business Address Street
Type	FORMULA (TEXT)(1300)

Name	AQB__BusinessAddressType__c
Label	Business Address Type
Type	FORMULA (TEXT)(1300)
Help Text	A description of the nature of this business address.
Description	A description of the nature of this business address.

Name	AQB__BusinessAddress__c
Label	Business Address
Type	FORMULA (TEXT)(1300)
Help Text	The mailing address at the Contact's primary employment location.
Description	The mailing address at the Contact's primary employment location.

Name	AQB__BusinessEmail__c
Label	Business Email
Type	EMAIL
Help Text	Email at contact's primary place of employment.
Description	Email at contact's primary place of employment.

Name	AQB__BusinessPhone__c
Label	Business Phone
Type	FORMULA (TEXT)(1300)
Help Text	The phone number at the Contact's primary business location.
Description	The phone number at the Contact's primary business location.

Name	AQB__CAECategory__c
Label	VSE Category
Type	PICKLIST
Help Text	This is the CAE Category of the individual Contact.
Picklist values	Alumni Parent Other Individual Alumni (non-degree) Alumni Affiliate Donor Former Staff Friend Graduand Memorial Nok Memorial Donor (I) Memorial Honouree Staff Student
Description	This is the VSE Category of the individual Contact.

Name	AQB__CNLink__c
Label	Community Name Link
Type	LOOKUP
Foreign key	Yes
Help Text	Link to the Name row that should be used as the Community Name.

Name	AQB__CName__c
Label	Community Name
Type	FORMULA (TEXT)(1300)
Help Text	The Community Name for this Contact as defined in either the linked Name record or the Contact's Automatic Community Name, or formatted by the Community Name formula.
Description	The Community Name for this Contact as defined in either the linked Name record or the Contact's Automatic Community Name, or formatted by the Community Name formula.

Name	AQB__CarrierRoute__c
Label	Carrier Route
Type	TEXT(50)
Help Text	An alphanumeric code assigned to a mail delivery or collection route within a zip code.
Description	An alphanumeric code assigned to a mail delivery or collection route within a zip code.

Name	AQB__CauseDeath__c
Label	Cause of Death
Type	TEXT(255)
Help Text	The cause of the contact's death.
Description	The cause of the contact's death.

Name	AQB__CertifiedCityName__c
Label	Certified City Name
Type	TEXT(255)
Help Text	The certified city name for this contact address.
Description	The certified city name for this contact address.

Name	AQB__CertifiedStateAbbreviation__c
Label	Certified State Abbreviation
Type	TEXT(100)
Help Text	The certified city name for this contact address.
Description	The certified state abbreviation for the contact address.

Name	AQB__CertifiedStreetName__c
Label	Certified Street Name
Type	TEXT(255)
Help Text	The certified street name for the contact address.
Description	The certified street name for the contact address.

Name	AQB__CertifiedZipCode__c
Label	Certified Zip Code
Type	TEXT(20)
Help Text	The certified zip code of the contact address.
Description	The certified zip code of the contact address.

Name	AQB__CityofDeath__c
Label	City of Death
Type	TEXT(255)
Help Text	The city where the death took place.

Name	AQB__Comments__c
Label	Comments
Type	TEXT AREA (LONG)(1000)
Help Text	General Comments regarding this Contact.

Name	AQB__CommunityPassword__c
Label	Community Password
Type	TEXT(30)
Help Text	The Contact's password to the Constituent Community.

Name	AQB__ContactAnonymousOption__c
Label	Gift Recognition Credits are Anonymous
Type	CHECKBOX
Required	Yes
Help Text	This field indicates if this Contact wishes that its Gift Credits be anonymous.
Default value	false

Name	AQB__ContactCount__c
Label	Contact Count
Type	FORMULA (NUMBER)(18,0)

Name	AQB__ContactExternalID__c
Label	Contact External ID
Type	TEXT(20)
Unique	Yes
Help Text	An ID number used by a prior data system to identify this Contact.
Description	An ID number used by a prior data system to identify this Contact.

Name	AQB__ContactGrouping__c
Label	Contact Grouping
Type	FORMULA (TEXT)(1300)
Help Text	Used to ensure unique contact grouping. NOTE - THIS FIELD SHOULD NOT BE USED WITH THE FORMAL, PREFERRED, ALTERNATE, OR COMMUNITY NAMES.

Name	AQB__ContactMailingAddressStreetLineOne__c
Label	Mailing Addr Street Line One
Type	FORMULA (TEXT)(1300)
Help Text	First line of the Contact Mailing Street Address.

Name	AQB__ContactMailingAddressStreetLineThre__c
Label	Mailing Addr Street Line Three
Type	FORMULA (TEXT)(1300)
Help Text	AQB__InternalContactMailingStreetTwo__c

Name	AQB__ContactMailingAddressStreetLineTwo__c
Label	Mailing Addr Street Line Two
Type	FORMULA (TEXT)(1300)
Help Text	Second line of the Account Mailing Street Address.

Name	AQB__ContactPicture__c
Label	Contact Picture
Type	TEXT AREA (RICH)(32768)
Help Text	Picture of the Contact.
Description	Picture of the Contact.

Name	AQB__ContactSource__c
Label	Contact Source
Type	TEXT(100)

Name	AQB__Contact_Mailing_Address__c
Label	Mailing Address
Type	FORMULA (TEXT)(1300)

Name	AQB__CorroboratedDeathDate__c
Label	Corroborated Death Date
Type	DATE
Help Text	The date that the death was corroborated.

Name	AQB__CountryId__c
Label	Country ID
Type	TEXT(5)
Help Text	The contact address country id. Intended to be used when integrating with a third party address verification system.
Description	The contact address country id. Intended to be used when integrating with a third party address verification system.

Name	AQB__CountryofDeath__c
Label	Country of Death
Type	TEXT(100)
Help Text	The country where the death took place.

Name	AQB__CountyNumber__c
Label	County Number
Type	TEXT(10)
Help Text	The contact address county id. Intended to be used when integrating with a third party address verification system.
Description	The contact address county id. Intended to be used when integrating with a third party address verification system.

Name	AQB__County__c
Label	County
Type	TEXT(255)
Help Text	The name of the geographical region within which the address is located.
Description	The name of the geographical region within which the address is located.

Name	AQB__DateObituaryAttached__c
Label	Date Obituary Attached
Type	DATE
Help Text	The date that the obituary was attached.

Name	AQB__DateofDeathNotification__c
Label	Date of Death Notification
Type	DATE
Help Text	The date that the notification of death was received.

Name	AQB__DateofDeathPrecision__c
Label	Date of Death Precision
Type	PICKLIST
Help Text	Precision of the Date of Death for this Contact.
Picklist values	On On or About

Name	AQB__DateofDeath__c
Label	Date of Death
Type	DATE
Help Text	Date of death of this Contact.

Name	AQB__DeathCorroboratedby__c
Label	Death Corroborated by
Type	TEXT(50)
Help Text	The person who corroborated the notification of death.

Name	AQB__Deceased__c
Label	Deceased?
Type	CHECKBOX
Required	Yes
Help Text	Checked if this contact is deceased.
Default value	false

Name	AQB__DefaultAddressSal__c
Label	Default Address Salutation
Type	FORMULA (TEXT)(1300)
Help Text	The default Salutation to be used in an Address for this Contact.

Name	AQB__DefaultGreetingSal__c
Label	Default Greeting Salutation
Type	FORMULA (TEXT)(1300)
Help Text	The default Salutation to be used in a Greeting for this Contact.

Name	AQB__DegreeYear__c
Label	Degree Year
Type	FORMULA (TEXT)(1300)
Help Text	The year that this Degree was awarded.

Name	AQB__Degree__c
Label	Degree
Type	FORMULA (TEXT)(1300)
Help Text	The Degree associated with the Institution. It is degree Abbreviation/type picklist (eg MS, BS, PHD etc)

Name	AQB__DeliveryPoint1__c
Label	Delivery Point Code
Type	TEXT(10)
Help Text	Two digit validation code provided by USPS.
Description	Two digit validation code provided by USPS.

Name	AQB__DeliveryPointCheckDigit__c
Label	Delivery Point Check Digit
Type	TEXT(10)
Help Text	Single check digit provided by USPS.
Description	Single check digit provided by USPS.

Name	AQB__DeliveryPointValidationFlag__c
Label	Delivery Point Validation Flag
Type	TEXT(10)
Help Text	Single character indicating delivery point validation status, (Y) Yes, (N) No
Description	Single character indicating delivery point validation status, (Y) Yes, (N) No

Name	AQB__DeliveryPointValidation__c
Label	Delivery Point Validation
Type	TEXT(10)
Help Text	Three digit code assigned by USPS that confirms the address can be delivered to (this code is a combination of Delivery Point Validation and Delivery Point Check Digit).
Description	Three digit code assigned by USPS that confirms the address can be delivered to (this code is a combination of Delivery Point Validation and Delivery Point Check Digit).

Name	AQB__DirectoryIncludeSendEmailLink__c
Label	Directory Include Send Email Link
Type	CHECKBOX
Required	Yes
Help Text	Do not display blind contact link on directory
Default value	false

Name	AQB__DirectoryPublishAddress__c
Label	Directory Publish Address
Type	CHECKBOX
Required	Yes
Help Text	If checked, the contact wishes for full address to be included in the directory.
Default value	false

Name	AQB__DirectoryPublishCoreData__c
Label	Directory Publish Core Data
Type	CHECKBOX
Required	Yes
Help Text	If checked, the contact wishes for their name, degree, year, city, and state/province to be included in the directory.
Default value	false

Name	AQB__DirectoryPublishEducation__c
Label	Directory Publish Education
Type	CHECKBOX
Required	Yes
Help Text	If checked, the contact wishes for their educational information to be included in the directory.
Default value	false

Name	AQB__DirectoryPublishEmail__c
Label	Directory Publish Email
Type	CHECKBOX
Required	Yes
Help Text	If checked, the contact wishes for their email to be included in the directory.
Default value	false

Name	AQB__DirectoryPublishEmployment__c
Label	Directory Publish Employment
Type	CHECKBOX
Required	Yes
Help Text	If checked, the contact wishes for their employment information to be included in the directory.
Default value	false

Name	AQB__DirectoryPublishInterests__c
Label	Directory Publish Interests
Type	CHECKBOX
Required	Yes
Help Text	If checked, the contact wishes for their interests to be included in the directory.
Default value	false

Name	AQB__DirectoryPublishPhone__c
Label	Directory Publish Phone
Type	CHECKBOX
Required	Yes
Help Text	If checked, the contact wishes for their preferred phone to be included in the directory.
Default value	false

Name	AQB__DistrictAlternate__c
Label	District - Alternate
Type	PICKLIST
Help Text	Alternate District assigned to this Contact, if any.
Picklist values	District One District Two District Three Greater Melbourne

Name	AQB__DistrictIsOverridden__c
Label	District is Overridden
Type	CHECKBOX
Required	Yes
Help Text	Indicates that the user has overridden the district that is associated with the Mailing Address Postal Code.
Default value	false
Description	Indicates that the user has overridden the district that is associated with the Mailing Address Postal Code.

Name	AQB__District__c
Label	District
Type	PICKLIST
Help Text	The District to which this Contact would be assigned as indicated by the Postal Code Lookup.
Picklist values	District One District Two District Three Greater Melbourne

Name	AQB__DoNotArchive__c
Label	Do Not Archive
Type	CHECKBOX
Required	Yes
Help Text	Indicates that the address, phone and/or email should not be archived.
Default value	false
Description	Indicates that the address, phone and/or email should not be archived.

Name	AQB__DoNotContact__c
Label	Do Not Contact
Type	CHECKBOX
Required	Yes
Help Text	If checked, this contact does not wish to receive communications of any sort.
Default value	false

Name	AQB__DoNotSolicit__c
Label	Do Not Solicit
Type	CHECKBOX
Required	Yes
Help Text	If checked, this Contact should not be solicited for gifts.
Default value	false

Name	AQB__EducationLink__c
Label	Primary Degree Link
Type	LOOKUP
Foreign key	Yes
Help Text	An internal field that maintains the link between this Contact and the primary Education data row.
Description	An internal field that maintains the link between this Contact and the primary Education data row.

Name	AQB__EmailNotes__c
Label	Email Notes
Type	TEXT(200)
Help Text	Notes describing any special uses or restrictions when using this contact's email addresses. A total of 200 characters can be entered.

Name	AQB__EmailPreference__c
Label	Email Preference
Type	PICKLIST
Help Text	Indicates the email to utilize for this contact.
Picklist values	Personal Email Business Email Other Email School Email

Name	AQB__EmployerName__c
Label	Employer Name
Type	FORMULA (TEXT)(1300)
Help Text	The name of the Employer for the Contact's primary Employment.
Description	The name of the Employer for the Contact's primary Employment.

Name	AQB__EngagementScoreExperiential__c
Label	Experiential
Type	NUMBER(5,0)
Help Text	The total engagement score for Experiential activities.

Name	AQB__EngagementScorePhilanthropic__c
Label	Philanthropic
Type	NUMBER(5,0)
Help Text	The total engagement score for philanthropic activities.

Name	AQB__EngagementScoreVolunteer__c
Label	Volunteer
Type	NUMBER(5,0)
Help Text	The total engagement score for volunteer activities.

Name	AQB__EngagmentScoreCommunication__c
Label	Communications
Type	NUMBER(5,0)
Help Text	The total engagement score for communications.

Name	AQB__Ethnicity__c
Label	Ethnicity
Type	PICKLIST
Help Text	A picklist of values that describe the Contact's ethnic background.
Picklist values	Aboriginal Origin Aboriginal & Torres Strait Origin Other Torres Strait Islander Origin Neither Aboriginal nor Torres Strait Islander
Description	A picklist of values that describe the Contact's ethnic background.

Name	AQB__FIPSStateCode__c
Label	FIPS State Code
Type	TEXT(10)
Help Text	The Federal Information Processing Standard state code of this contact address.
Description	The Federal Information Processing Standard state code of this contact address.

Name	AQB__FNLink__c
Label	Formal Name Link
Type	LOOKUP
Foreign key	Yes
Help Text	Link to the Name row that should be used as the Formal Name

Name	AQB__FName__c
Label	Formal Name
Type	FORMULA (TEXT)(1300)
Help Text	The Formal Name for this Contact as defined in either the linked Name record or the Contact's Automatic Formal Name, or formatted by the Formal Name formula.
Description	The Formal Name for this Contact as defined in either the linked Name record or the Contact's Automatic Formal Name, or formatted by the Formal Name formula.

Name	AQB__Flag__c
Label	Flag
Type	TEXT(10)
Help Text	Mid level validation flag indicating detailed status, (E) Exact, (T) Tentative, (M) Multiple, (S) Secondary, (U) Unmatched, (F) ForeignThe address flag of the contact address.
Description	Mid level validation flag indicating detailed status, (E) Exact, (T) Tentative, (M) Multiple, (S) Secondary, (U) Unmatched, (F) Foreign

Name	AQB__FoodPreferences__c
Label	Food Preferences
Type	PICKLIST (MULTI-SELECT)
Help Text	Food preferences or restrictions for this Contact.
Picklist values	Gluten Free Kosher Vegan Vegetarian Nut Allergies
Description	Food preferences or restrictions for this Contact.

Name	AQB__Full_Name__c
Label	Full Name
Type	FORMULA (TEXT)(1300)

Name	AQB__Gender__c
Label	Gender
Type	PICKLIST
Help Text	Picklist of gender values.
Picklist values	F M Unspecified T S N Y X

Name	AQB__Greeting__c
Label	Greeting
Type	TEXT(200)
Help Text	This is the greeting salutation as it might be used in a letter or email such as "Mr. Smith" or "Dr. Brown". The system will automatically format a formal salutation unless you type one in. This field can contain 40 characters.

Name	AQB__Institution__c
Label	Institution
Type	FORMULA (TEXT)(1300)
Help Text	Institution from which this Degree was awarded.

Name	AQB__InstitutionalArea1Alternate__c
Label	Institutional Area 1 - Alternate
Type	PICKLIST
Help Text	Alternate Institutional Area 1 assigned to this Contact, if any.
Picklist values	Institutional Area 1 Institutional Area 2 Institutional Area 3 Institutional Area 4
Description	Alternate Institutional Area 1 assigned to this Contact, if any.

Name	AQB__InstitutionalArea1IsOverridden__c
Label	Institutional Area 1 is Overridden
Type	CHECKBOX
Required	Yes
Help Text	Indicates that the user has overridden the Institutional Area 1 that is associated with the Mailing Address Postal Code.
Default value	false
Description	Indicates that the user has overridden the Institutional Area 1 that is associated with the Mailing Address Postal Code.

Name	AQB__InstitutionalArea1__c
Label	Institutional Area 1
Type	PICKLIST
Help Text	This Institutional Area 1 associated with this Contact.
Picklist values	Institutional Area 1 Institutional Area 2 Institutional Area 3 Institutional Area 4
Description	This Institutional Area 1 associated with this Contact.

Name	AQB__InstitutionalArea2Alternate__c
Label	Institutional Area 2 - Alternate
Type	PICKLIST
Help Text	Alternate Institutional Area 2 assigned to this Contact, if any.
Picklist values	Institutional Area 1 Institutional Area 2 Institutional Area 3 Institutional Area 4
Description	Alternate Institutional Area 2 assigned to this Contact, if any.

Name	AQB__InstitutionalArea2IsOverridden__c
Label	Institutional Area 2 is Overridden
Type	CHECKBOX
Required	Yes
Help Text	Indicates that the user has overridden the Institutional Area 2 that is associated with the Mailing Address Postal Code.
Default value	false
Description	Indicates that the user has overridden the Institutional Area 2 that is associated with the Mailing Address Postal Code.

Name	AQB__InstitutionalArea2__c
Label	Institutional Area 2
Type	PICKLIST
Help Text	This Institutional Area 2 associated with this Contact.
Picklist values	Institutional Area 1 Institutional Area 2 Institutional Area 3 Institutional Area 4
Description	This Institutional Area 2 associated with this Contact.

Name	AQB__InstitutionalArea3Alternate__c
Label	Institutional Area 3 - Alternate
Type	PICKLIST
Help Text	Alternate Institutional Area 3 assigned to this Contact, if any.
Picklist values	Institutional Area 1 Institutional Area 2 Institutional Area 3 Institutional Area 4
Description	Alternate Institutional Area 3 assigned to this Contact, if any.

Name	AQB__InstitutionalArea3IsOverridden__c
Label	Institutional Area 3 is Overridden
Type	CHECKBOX
Required	Yes
Help Text	Indicates that the user has overridden the Institutional Area 3 that is associated with the Mailing Address Postal Code.
Default value	false
Description	Indicates that the user has overridden the Institutional Area 3 that is associated with the Mailing Address Postal Code.

Name	AQB__InstitutionalArea3__c
Label	Institutional Area 3
Type	PICKLIST
Help Text	This Institutional Area 3 associated with this Contact.
Picklist values	Institutional Area 1 Institutional Area 2 Institutional Area 3 Institutional Area 4
Description	This Institutional Area 3 associated with this Contact.

Name	AQB__InstitutionalArea4Alternate__c
Label	Institutional Area 4 - Alternate
Type	PICKLIST
Help Text	Alternate Institutional Area 4 assigned to this Contact, if any.
Picklist values	Institutional Area 1 Institutional Area 2 Institutional Area 3 Institutional Area 4
Description	Alternate Institutional Area 4 assigned to this Contact, if any.

Name	AQB__InstitutionalArea4IsOverridden__c
Label	Institutional Area 4 is Overridden
Type	CHECKBOX
Required	Yes
Help Text	Indicates that the user has overridden the Institutional Area 4 that is associated with the Mailing Address Postal Code.
Default value	false
Description	Indicates that the user has overridden the Institutional Area 4 that is associated with the Mailing Address Postal Code.

Name	AQB__InstitutionalArea4__c
Label	Institutional Area 4
Type	PICKLIST
Help Text	This Institutional Area 4 associated with this Contact.
Picklist values	Institutional Area 1 Institutional Area 2 Institutional Area 3 Institutional Area 4
Description	This Institutional Area 4 associated with this Contact.

Name	AQB__InstitutionalSuffixOverride__c
Label	Institutional Suffix Override
Type	TEXT(100)
Help Text	Use this to override the automated institutional suffix.
Description	Use this to override the automated institutional suffix.

Name	AQB__InstitutionalSuffix__c
Label	Institutional Suffix
Type	TEXT(100)
Help Text	The suffix, if any, that your institution wants to append to Contact names.
Description	The suffix, if any, that your institution wants to append to Contact names.

Name	AQB__InternalContactMailingStreetOne__c
Label	Internal Contact Mailing Street One
Type	FORMULA (TEXT)(1300)
Help Text	Holding field used to help calculate street lines.

Name	AQB__InternalContactMailingStreetTwo__c
Label	Internal Contact Mailing Street Two
Type	FORMULA (TEXT)(1300)
Help Text	Internal Account Mailing Address with first line stripped off.

Name	AQB__InvolvementRating__c
Label	Involvement
Type	FORMULA (TEXT)(1300)
Help Text	No stars indicate a lack of involvement with your organization. One to three stars indicate increasing involvement in volunteer activities, interests, or communication with your organization.

Name	AQB__InvolvementScore__c
Label	Involvement Score
Type	FORMULA (NUMBER)(16,2)
Description	Holds the score value defined in each Engagement Scoring rule. The score will be accumulated in the corresponding object selected for each rule. The cumulative score will be displayed on the contact record layout.Holds the score value defined in each Engagement Scoring rule. The score will be accumulated in the corresponding object selected for each rule. The cumulative score will be displayed on the contact record layout.

Name	AQB__IsPrimaryContact__c
Label	Is Primary Contact?
Type	FORMULA (TEXT)(1300)
Help Text	If checked, this Contact is the Primary Contact for the Account.

Name	AQB__IsSecondaryContact__c
Label	Is Secondary Contact?
Type	FORMULA (TEXT)(1300)
Help Text	If Yes, the Contact is the secondary Contact on the Account.
Description	If Yes, the Contact is the secondary Contact on the Account.

Name	AQB__Languages__c
Label	Languages
Type	TEXT(100)

Name	AQB__LastActivityDate__c
Label	Last Activity Date
Type	DATE

Name	AQB__Latitude__c
Label	Latitude
Type	TEXT(50)
Help Text	Specifies the north south position of a point on the Earth's surface.
Description	Specifies the north south position of a point on the Earth's surface.

Name	AQB__LegacyContactIDNumber__c
Label	Legacy Contact ID Number
Type	TEXT(40)
Help Text	The ID number used for this contact in a legacy system from which data was converted into Affinaquest.

Name	AQB__LinkedAddress__c
Label	Alternate Address Link
Type	LOOKUP
Foreign key	Yes
Help Text	If an Alternate Address is designated as the Address in Use, this field contains a link to the Alternate Address object to be used as a shortcut for access to that Alternate Address.

Name	AQB__LocationofDeath__c
Label	Location of Death
Type	TEXT(50)
Help Text	The location where the death took place.

Name	AQB__Longitude__c
Label	Longitude
Type	TEXT(50)
Help Text	Specifies the east west position of a point on the Earth's surface.
Description	Specifies the east west position of a point on the Earth's surface.

Name	AQB__MaidenName__c
Label	Maiden Name
Type	TEXT(40)
Help Text	The maiden name of this contact.
Description	The maiden name of this contact.

Name	AQB__MailingAddressType__c
Label	Mailing Address Type
Type	PICKLIST
Help Text	A description of the nature of this address, such as residence, business, vacation home, etc.
Picklist values	Business Address Home Address Home Address - Unverified Internal USYD Address Other Sydney Student Address Seasonal Address Postal Address Home Business Vacation Other SITS Contact Address
Description	A description of the nature of this address, such as residence, business, vacation home, etc.

Name	AQB__MailingDistrict__c
Label	Mailing District
Type	PICKLIST
Help Text	An institution-defined way to segment contacts by a district code. This is associated with the contact and not a specific address.
Picklist values	Mountain Coastal Piedmont
Description	An institution-defined way to segment contacts by a district code. This is associated with the contact and not a specific address.

Name	AQB__MailingLists__c
Label	Mailing Lists for this Contact
Type	PICKLIST (MULTI-SELECT)
Help Text	The specific mailings lists which this contact has been assigned.
Picklist values	Annual Fund Mailings Event Invitations Newsletters Solicitations
Description	The specific mailings lists which this contact has been assigned.

Name	AQB__MailingLocality__c
Label	Mailing Address Locality
Type	FORMULA (TEXT)(1300)

Name	AQB__MailingNote__c
Label	Mailing Address Note
Type	TEXT(255)
Help Text	Help on note

Name	AQB__MailingRegion__c
Label	Mailing Region
Type	PICKLIST
Help Text	An institution-defined way to segment contacts by a region code. This is associated with the contact and not a specific address.
Picklist values	North South East West
Description	An institution-defined way to segment contacts by a region code. This is associated with the contact and not a specific address.

Name	AQB__MailingStatus__c
Label	Mailing Address Status
Type	PICKLIST
Help Text	Help on status
Picklist values	Active Inactive Last Known Needs Verification Return To Sender (RTS) Partial Address

Name	AQB__MailingStreetLineFour__c
Label	Deprecated Contact Mailing Street Line 4
Type	TEXT(200)

Name	AQB__MailingStreetLineOne__c
Label	Deprecated Contact Mailing Street Line 1
Type	TEXT(200)

Name	AQB__MailingStreetLineThree__c
Label	Deprecated Contact Mailing Street Line 3
Type	TEXT(200)

Name	AQB__MailingStreetLineTwo__c
Label	Deprecated Contact Mailing Street Line 2
Type	TEXT(200)

Name	AQB__MailingTimeZone__c
Label	Time Zone
Type	PICKLIST
Help Text	The time zone assigned to the is contact.
Picklist values	EST Eastern Standard Time GMT-5:00 IET Indiana Eastern Standard Time GMT-5:00 CST Central Standard Time GMT-6:00 MST Mountain Standard Time GMT-7:00 PST Pacific Standard Time GMT-8:00 PRT Puerto Rico and US Virgin Islands Time GMT-4:00 CNT Canada Newfoundland Time GMT-3:30 AGT Argentina Standard Time GMT-3:00 BET Brazil Eastern Time GMT-3:00 CAT Central African Time GMT-1:00 GMT Greenwich Mean Time GMT UTC Universal Coordinated Time GMT ECT European Central Time GMT+1:00 EET Eastern European Time GMT+2:00 ART (Arabic) Egypt Standard Time GMT+2:00 EAT Eastern African Time GMT+3:00 MET Middle East Time GMT+3:30 NET Near East Time GMT+4:00 PLT Pakistan Lahore Time GMT+5:00 IST India Standard Time GMT+5:30 BST Bangladesh Standard Time GMT+6:00 VST Vietnam Standard Time GMT+7:00 CTT China Taiwan Time GMT+8:00 JST Japan Standard Time GMT+9:00 ACT Australia Central Time GMT+9:30 AET Australia Eastern Time GMT+10:00 SST Solomon Standard Time GMT+11:00 NST New Zealand Standard Time GMT+12:00 MIT Midway Islands Time GMT-11:00 HST Hawaii Standard Time GMT-10:00 AST Alaska Standard Time GMT-9:00 PNT Phoenix Standard Time GMT-7:00
Description	The time zone assigned to the is contact.

Name	AQB__MaritalStatus__c
Label	Marital Status
Type	PICKLIST
Help Text	A picklist describing the marital status of this contact.
Picklist values	Married Single Widowed Life Partner Deceased Spouse/Partner Surviving Spouse/Partner Married/Partner Divorced Spouse/Partner Divorced Defacto Former Defacto Formerly Married Married at Time of Death Partner/Significant Other Separated

Name	AQB__MobileWork__c
Label	Mobile Work
Type	PHONE
Help Text	Mobile work phone number.

Name	AQB__MostRecentEventAttendanceLink__c
Label	Most Recent Event Attendance Link
Type	LOOKUP
Foreign key	Yes
Help Text	Link to the most recent event attendance record.

Name	AQB__MostRecentEventAttended__c
Label	Most Recent Event Attended
Type	LOOKUP
Foreign key	Yes
Help Text	The name of the most recently attended event.

Name	AQB__Most_Recent_Event_Attendance_Date__c
Label	Most Recent Event Attendance Date
Type	DATE
Help Text	Date of Most Recent event attendance record.

Name	AQB__Most_Recent_Event_Registration_Date__c
Label	Most Recent Event Registration Date
Type	DATE
Help Text	The date of the event for which this contact most recently registered.

Name	AQB__Most_Recent_Event_Registration_Link__c
Label	Most Recent Event Registration Link
Type	LOOKUP
Foreign key	Yes
Help Text	The most recent event for which this contact has registered.

Name	AQB__Most_Recent_Event_Registration__c
Label	Most Recent Event Registration
Type	LOOKUP
Foreign key	Yes
Help Text	The name of the event for which this contact most recently registered.

Name	AQB__Name__c
Label	Name
Type	FORMULA (TEXT)(1300)

Name	AQB__NextActivityDate__c
Label	Next Task Date
Type	DATE

Name	AQB__NextActivity__c
Label	Next Task
Type	FORMULA (TEXT)(1300)
Help Text	The flag indicates status of the next Task for the Contact. White - no future Tasks. Green - Activity due date is at least 14 days away. Yellow - Task due date is within 14 days. Red - Task is overdue.
Description	The flag indicates status of the next Task for the Contact. White - no future Tasks. Green - Activity due date is at least 14 days away. Yellow - Task due date is within 14 days. Red - Task is overdue.

Name	AQB__Nickname__c
Label	Nickname
Type	TEXT(80)
Help Text	The nickname of this contact.
Description	The nickname of this contact.

Name	AQB__Notifiedby__c
Label	Notified of Death by
Type	TEXT(40)
Help Text	The individual who provided the notification of death.

Name	AQB__Number_of_Events_Attended__c
Label	Number of Events Attended
Type	NUMBER(9,0)
Help Text	The number of events for which this contact has an event attendance record.

Name	AQB__ObituaryAttached__c
Label	Obituary Attached
Type	CHECKBOX
Required	Yes
Help Text	Indicates that a copy of the obituary has been attached to this Contact.
Default value	false

Name	AQB__ObituaryLink__c
Label	Obituary Link
Type	URL
Help Text	Link to an on-line obituary.

Name	AQB__OtherEmail__c
Label	Other Email
Type	EMAIL
Help Text	Alternative email address for this contact.

Name	AQB__OtherPreferences__c
Label	Other Preferences
Type	TEXT AREA (RICH)(32768)
Help Text	The other event preferences or restrictions for this Contact.
Description	The other event preferences or restrictions for this Contact.

Name	AQB__OwnerUnit__c
Label	Owner Unit
Type	PICKLIST
Help Text	Designates the Unit of the User that created this record. This field is intended for use in creating Sharing Rules for the purpose of controlling access to the record.
Picklist values	Advancement Services Alumni and Supporter Relations Development Prospect Development
Description	Designates the Unit of the User that created this record. This field is intended for use in creating Sharing Rules for the purpose of controlling access to the record.

Name	AQB__PNameLink__c
Label	Preferred Name Link
Type	LOOKUP
Foreign key	Yes
Help Text	Link to the Name row that should be used as the Preferred Name

Name	AQB__PName__c
Label	Preferred Name
Type	FORMULA (TEXT)(1300)
Help Text	The Preferred Name for this Contact as defined in either the linked Name record or the Contact's Automatic Preferred Name, or formatted by the Preferred Name formula.
Description	The Preferred Name for this Contact as defined in either the linked Name record or the Contact's Automatic Preferred Name, or formatted by the Preferred Name formula.

Name	AQB__PersonalEmail__c
Label	Personal Email
Type	EMAIL
Help Text	Contact's personal email address.

Name	AQB__PhoneNotes__c
Label	Phone Notes
Type	TEXT(200)
Help Text	Notes describing any special uses or restrictions when using this contact's phone numbers. A total of 200 characters can be entered.

Name	AQB__PhonePreference__c
Label	Phone Preference
Type	PICKLIST
Help Text	Indicates the telephone number to utilize for this contact.
Picklist values	Account Phone Business Phone Mobile

Name	AQB__PlaceofBirth__c
Label	Place of Birth
Type	TEXT(50)
Help Text	Enter the city and state where this contact was born.

Name	AQB__PreferredYear__c
Label	Pref Year
Type	FORMULA (TEXT)(1300)
Help Text	The year with which this Contact wishes to be associated for reunions and other identification.

Name	AQB__Presentation_Preferences__c
Label	Presentation Preferences
Type	PICKLIST (MULTI-SELECT)
Help Text	Presentation preferences or restrictions for this Contact.
Picklist values	Hearing Impaired Sight Impaired Needs Headphones Needs Signing
Description	Presentation preferences or restrictions for this Contact.

Name	AQB__PrimaryEmploymentLink__c
Label	Primary Employment Link
Type	LOOKUP
Foreign key	Yes
Help Text	An internal field used to maintain the linkage between a Contact and the primary Employment data.
Description	An internal field used to maintain the linkage between a Contact and the primary Employment data.

Name	AQB__PrimaryEmploymentTitle__c
Label	Primary Employment Title
Type	FORMULA (TEXT)(1300)

Name	AQB__PrimaryGiftRecognitionCredit_Percent__c
Label	Legal Credit %
Type	PERCENT(3,2)
Help Text	The default percentage used to credit a contact with a legal credit for based on the amount of a gift.
Default value	0
Description	The default percentage used to credit a contact with the Legal credit for based on the amount of a gift. This percentage ties back to the gift recognition object and represents the amount that the contact should get financial recognition.

Name	AQB__Pronoun__c
Label	Pronoun
Type	PICKLIST
Help Text	The pronoun or set of pronouns that the Contact would like others to use when talking to or about that Contact.
Picklist values	He/His She/Her They/Them Ey/Em He/Him He/They None She/They She-they-it/Her-them-it They/Her/Him Xe/Xem Zie/Zim They/He/Them
Description	The pronoun or set of pronouns that the Contact would like others to use when talking to or about that Contact.

Name	AQB__RFM__c
Label	Deprecated RFM
Type	FORMULA (TEXT)(1300)
Help Text	A star is awarded for each of the following five conditions: having a giving record, having a pending opportunity, having a largest gift over a defined amount, having a total amount of giving over a defined amount, and having made a gift this year.
Description	Deprecated.

Name	AQB__RegionAlternate__c
Label	Region - Alternate
Type	PICKLIST
Help Text	Alternate Region assigned to this Contact, if any.
Picklist values	Armed Forces America Federated States of Micronesia Armed Forces Europe Armed Forces Pacific Australian Capital Territory Alabama Alaska American Samoa Arizona Arkansas California Colorado Connecticut District of Columbia Delaware Florida Georgia Guam Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Marshall Islands Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana New South Wales Northern Territory Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Northern Mariana Islands Ohio Oklahoma Oregon Palau Pennsylvania Puerto Rico Queensland Rhode Island South Australia South Carolina South Dakota Tasmania Tennessee Texas Utah Victoria Vermont Virgin Islands Virginia Western Australia West Virginia Wisconsin Wyoming

Name	AQB__RegionIsOverridden__c
Label	Region is Overridden
Type	CHECKBOX
Required	Yes
Help Text	Indicates that the user has overridden the region that is associated with the Mailing Address Postal Code.
Default value	false
Description	Indicates that the user has overridden the region that is associated with the Mailing Address Postal Code.

Name	AQB__Region__c
Label	Region
Type	PICKLIST
Help Text	The Region to which this Contact would be assigned as indicated by the Postal Code Lookup.
Picklist values	Armed Forces America Federated States of Micronesia Armed Forces Europe Armed Forces Pacific Australian Capital Territory Alabama Alaska American Samoa Arizona Arkansas California Colorado Connecticut District of Columbia Delaware Florida Georgia Guam Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Marshall Islands Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana New South Wales Northern Territory Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Northern Mariana Islands Ohio Oklahoma Oregon Palau Pennsylvania Puerto Rico Queensland Rhode Island South Australia South Carolina South Dakota Tasmania Tennessee Texas Utah Victoria Vermont Virgin Islands Virginia Western Australia West Virginia Wisconsin Wyoming

Name	AQB__Relationship__c
Label	Account Relationship
Type	PICKLIST
Help Text	Picklist of values describing the relationship of this contact to its account.
Picklist values	Husband Wife Head of Household Son Daughter Employee Board Member Partner Grandson Primary Contact Secondary Contact Deceased Spouse Surviving Spouse Solicitation Contact Solicitation Copy Decedent Executor Solicitor

Name	AQB__ResidentialDeliveryIndicator__c
Label	Residential Delivery Indicator
Type	TEXT(1)
Help Text	Indicates whether an address is residential (R) or business (B).
Description	Indicates whether an address is residential (R) or business (B).

Name	AQB__RevertAddressInUseType__c
Label	Revert Address In Use Type
Type	PICKLIST
Help Text	The address in user type that the contact's mailing address will revert to once a seasonal address expires.
Picklist values	Business Account Mailing Alternate
Description	The address in use type that the contact's mailing address will revert to once a seasonal address expires.

Name	AQB__SalutationLink__c
Label	Salutation Link
Type	LOOKUP
Foreign key	Yes
Help Text	Link to LL-Salutation object based on the Salutation.

Name	AQB__SchoolEmail__c
Label	School Email
Type	EMAIL
Help Text	Email address assigned by the educational institution.

Name	AQB__School__c
Label	School
Type	FORMULA (TEXT)(1300)
Help Text	The School associated with this Degree.

Name	AQB__SecondaryGiftRecognitionCreditPercent__c
Label	Gift Recognition Credit %
Type	PERCENT(3,2)
Help Text	The default percentage used to credit a contact with a gift recognition credit ,based on the amount of a gift.
Default value	0
Description	The default percentage used to credit a contact with the gift recognition credit, based on the amount of a gift. This percentage ties back to the gift recognition object and represents the amount that the contact should get for reporting recognition.

Name	AQB__SecondaryType__c
Label	Secondary Contact Types
Type	PICKLIST (MULTI-SELECT)
Help Text	A multi-select picklist allowing for the assignment of multiple secondary categorization levels for this contact. The primary category should be entered into the Type field.
Picklist values	Alumni Alumni (non-degree) Alumni affiliate Association Corporation Discretionary Trust Donor Estate Former staff Foundation (E) Foundation (I) Friend Graduand Memorial NOK Memorial donor (I) Memorial honouree Organisation (I) Staff Student Tertiary institute (E) Tertiary institute (I) Trust Parent of Student - Alumni

Name	AQB__Setup__c
Label	Setup
Type	LOOKUP
Foreign key	Yes

Name	AQB__Signator__c
Label	Signator
Type	CHECKBOX
Required	Yes
Help Text	Checkbox to indicate if this contact should be flag as the default signatgor when a check donation is given.
Default value	false

Name	AQB__StateId__c
Label	State Id
Type	TEXT(2)
Help Text	The contact address state id. Intended to be used when integrating with a third party address verification system.
Description	The contact address state id. Intended to be used when integrating with a third party address verification system.

Name	AQB__StateProvinceofDeath__c
Label	State/Province of Death
Type	TEXT(100)
Help Text	The state or province where the death took place.

Name	AQB__Suffix__c
Label	Suffix Picklist
Type	PICKLIST
Help Text	A picklist for name suffix.
Picklist values	Jr. Sr. MD PhD JD I II III IV V

Name	AQB__TotalAccountOpenOpportunities__c
Label	Total Account Open Opportunities
Type	FORMULA (CURRENCY)(16,2)

Name	AQB__TotalEngagementScore__c
Label	Total Engagement Score
Type	FORMULA (NUMBER)(18,0)

Name	AQB__Total_Number_of_Event_Registrations__c
Label	Total Number of Event Registrations
Type	NUMBER(5,0)
Help Text	The total number of events for which this contact has registered.

Name	AQB__Total_of_All_Registration_Fees__c
Label	Total of All Registration Fees
Type	CURRENCY(9,2)
Help Text	The total amount of registration fees paid by this contact for all registrations.

Name	AQB__Type__c
Label	Contact Type
Type	PICKLIST
Help Text	A picklist of the highest level categorization of this contact. The category can be further described in the Secondary Type field.
Picklist values	Friend Corporate Contact Foundation Contact Patient Alumni Alumni Affiliate Donor Former Staff Graduand Memorial Nok Memorial Donor Memorial Honouree Staff Student Executor Solicitor Parent of Student - Alumni

Name	AQB__UseAccountAddressOnImport__c
Label	Use Account Address on Import
Type	CHECKBOX
Required	Yes
Default value	false

Name	AQB__ValidationDate__c
Label	Validated On
Type	DATETIME
Help Text	The date the address was validated.
Description	The date the address was validated.

Name	AQB__VerificationFlag__c
Label	Verification Flag
Type	TEXT(10)
Help Text	The verification flag of the contact address.
Description	The verification flag of the contact address.

Name	aqcv_conversionid__c
Label	aqcv conversionid
Type	TEXT(255)
Unique	Yes
Description	Unique id

Name	AQB__Degree_Level__c
Label	Degree Level
Type	FORMULA (TEXT)(1300)
Help Text	The Degree Level for the Primary Degree.

Name	AQB__VSEAlumniDegreeCategory__c
Label	VSE Alumni Degree Category
Type	FORMULA (TEXT)(1300)

Name	USyd_Contact_ID__c
Label	Contact ID
Type	AUTO NUMBER
Required	Yes
Description	This is another unique identifier for a contact

Name	USyd_Contact_Type_Priority_Order__c
Label	Contact Type Priority Order
Type	FORMULA (NUMBER)(18,0)

Name	USYD_Contact_Mailing_City__c
Label	Contact Mailing City
Type	FORMULA (TEXT)(1300)
Description	USYD_Custom. Used in receipting.

Name	Calc_Receipt_Name__c
Label	Calc Receipt Name
Type	FORMULA (TEXT)(1300)

Name	USYD_Receipt_Name__c
Label	Receipt Name
Type	TEXT(255)
Help Text	The receipt name as it appears in the name related list.
Description	Used for Receipting.

Name	USYD_Best_Contact_Email__c
Label	Best Contact Email
Type	FORMULA (TEXT)(1300)
Help Text	This is the best email address to contact
Description	This is the best email to contact according to this hierarchy: Email Preference, Personal Email, Business Email, Other Email, Student Email

Name	USYD_Contact_Mailing_Continent__c
Label	Contact Mailing Continent
Type	FORMULA (TEXT)(1300)
Description	Defines the Continents of the Contact Mailing Address

Name	USYD_CG_CON_DPID_Location__c
Label	Address DPID
Type	TEXT(100)
Help Text	A unique eight-digit Delivery Point Identifier (DPID) for each delivery address within Australia

Name	Alternate_ID__c
Label	Alternate ID
Type	TEXT(30)

Name	USYD_Special_Category_Flag_Temp__c
Label	Special Category Flag Temp
Type	CHECKBOX
Required	Yes
Default value	false
Description	This is temporary, will delete soon after This contains the value in Advance. This will be replaced once the gifts data and formula is finalised.

Name	USYD_Sydney_Metro__c
Label	Metropolitan Area
Type	FORMULA (TEXT)(1300)
Description	Sydney Metro / NSW Non Sydney Metro / Rest of World by postcode

Name	imodules_Alternate_ID__c
Label	imodules Alternate ID
Type	TEXT(50)
Unique	Yes
Description	Captures External Reference ID from Imodules Lead.

Name	USYD_Degree__c
Label	Degree
Type	FORMULA (TEXT)(1300)
Description	This field holds the full degree name. eg: Bachelor of Science.

Name	USYD_Secondary_Type_Concatenation__c
Label	Secondary Type Concatenation
Type	FORMULA (TEXT)(1300)
Description	This concatenates secondary types for Contacts except Memorial types. Useful in report (e.g formulas)

Name	USYD_Contact_Mailing_Country__c
Label	Contact Mailing Country
Type	FORMULA (TEXT)(1300)
Description	USYD_Custom. Used in receipting.

Name	USYD_Contact_Mailing_State__c
Label	Contact Mailing State/Province
Type	FORMULA (TEXT)(1300)
Description	USYD_Custom. Used in receipting.

Name	USYD_Contact_Mailing_Street__c
Label	Contact Mailing Street
Type	FORMULA (TEXT)(1300)
Description	USYD_Custom. Used in receipting.

Name	USYD_Contact_Mailing_Zip_Postal_Code__c
Label	Contact Mailing Zip/Postal Code
Type	FORMULA (TEXT)(1300)
Description	USYD_Custom. Used in receipting.

Name	USYD_Do_Not_Mail__c
Label	Do Not Mail
Type	CHECKBOX
Required	Yes
Help Text	Opted out of Communications via Post.
Default value	false
Description	This indicates that this contact should not be sent communications by post.

Name	USYD_Lost__c
Label	Lost
Type	FORMULA (CHECKBOX)
Required	Yes
Help Text	Lost: a contact who does not have any active modes of contact (excludes LinkedIn URL)
Description	Lost: a contact who does not have any active modes of contact (excludes LinkedIn URL)

Name	USYD_Preferred_Email__c
Label	Preferred Email
Type	FORMULA (TEXT)(1300)
Help Text	Captures Email if either or both Do Not Email and Do Not Contact are unchecked.
Description	Captures Email if either or both Do Not Email and Do Not Contact are unchecked.

Name	USYD_Preferred_Phone__c
Label	Preferred Phone
Type	FORMULA (TEXT)(1300)
Help Text	Captures Phone if either or both Do Not Call and Do Not Contact are unchecked.
Description	Captures Phone if either or both Do Not Call and Do Not Contact are unchecked.

Name	USYD_Preferred_Contact_Mailing_Address__c
Label	Preferred Contact Mailing Address
Type	FORMULA (TEXT)(1300)
Help Text	Captures Address if either or both Do Not Mail and Do Not Contact are unchecked and address is not empty.
Description	Captures Address if either or both Do Not Mail and Do Not Contact are unchecked and address is not empty.

Name	Salesforce_ID__c
Label	Salesforce ID
Type	FORMULA (TEXT)(1300)

Name	Usyd_Prospect_Manager__c
Label	Prospect Manager
Type	FORMULA (TEXT)(1300)

Name	USYD_Special_Category__c
Label	Special Category
Type	PICKLIST (MULTI-SELECT)
Picklist values	AAIA Donor Bill Walsh Donor CMRI Donor Grateful Patient Grateful Patient Donor In Memorial Donor NEAF Donor Northern Clinical School Donor SSI Donor Sydney Peace Foundation Donor Warren Centre Donor Western Clinical School Donor Hoc Mai Donor

Name	AQB__EngagementScoreCategory__c
Label	Engagement Score Category
Type	PICKLIST
Help Text	If using the override option, the appropriate engagement score category will be stored in this field.
Picklist values	Communications Experiential Philanthropic Volunteer
Description	Identifies the category group the engagement score will be totaled in to.

Name	AQB__EngagementScoreOverride__c
Label	Engagement Score Override
Type	CHECKBOX
Required	Yes
Help Text	If a manual update is needed for the Engagement Score value that is outside the parameters of the rule defined, the Engagement Score Override can be used. Marking the override checkbox, selecting the corresponding category will allow the user to manually override the "Engagement Score" field.
Default value	false
Description	This field will be used to change the value of the score manually to a value that does not meet the criteria of the defined rule within the Engagement Score parameter.

Name	AQB__EngagementScore__c
Label	Engagement Score
Type	NUMBER(4,0)
Help Text	When completing an Engagement Score override users will select the category, check the override box, and fill the engagement score field value to the desired score value. All three fields will need to be placed on the desired object.
Description	This field holds the score value associated with an override.

Name	AQB__ProfessionalSuffix__c
Label	Professional Suffix
Type	TEXT(40)

Name	USYD_Duplicate_Review_Complete__c
Label	Duplicate Review Complete
Type	CHECKBOX
Required	Yes
Default value	false
Description	Exclude from duplicate rule evaluation if True

Name	Usyd_Is_Notable_Alumni__c
Label	Is Influential Alumni
Type	CHECKBOX
Required	Yes
Default value	false
Description	DEceased: Is Notable Alumni equal to true if there exist and accolade name of Notable Alumni Note: Field is re purposed for AVE-113

Name	Usyd_RTS_Reason__c
Label	RTS Reason
Type	PICKLIST
Help Text	Return To Sender Reason. Other will be tracked in the mailing address note field.
Picklist values	No Longer at this Address Contact is Deceased Insufficient/Invalid Address Requested to no longer receive mail No Reason Other
Description	Return To Sender Reason. Other will be tracked in the mailing address note field.

Name	USyd_Has_Children__c
Label	Has Children
Type	PICKLIST
Picklist values	Unknown Has no children 1 2 3 4 5+
Description	Number of children

Name	USyd_Other_Family_Relations__c
Label	Other Family Relations
Type	PICKLIST
Picklist values	Unknown Has no grandchildren Has grandchildren

Name	Usyd_Account_ID_Name__c
Label	Account ID Name
Type	FORMULA (TEXT)(1300)
Help Text	Field used in search layout to display account ID and Account Name
Description	Field used in search layout to display account ID and Account Name

Name	Usyd_Business_Email_Modified_By__c
Label	Business Email Modified By
Type	LOOKUP
Foreign key	Yes
Help Text	Business email modified by name

Name	Usyd_Business_Email_Modified_Date__c
Label	Business Email Modified Date
Type	DATETIME
Help Text	Business email modified date

Name	Usyd_Business_Email_Modified_Source__c
Label	Business Email Modified Source
Type	PICKLIST
Picklist values	Aperture Australia Post Census 2022 Email iModules Mail Phone Swift Sydney Student

Name	Usyd_Mailing_Address_Modified_By__c
Label	Mailing Address Modified By
Type	LOOKUP
Foreign key	Yes
Help Text	Mailing Address modified by name

Name	Usyd_Mailing_Address_Modified_Date__c
Label	Mailing Address Modified Date
Type	DATETIME
Help Text	Mailing Address Modified Date

Name	Usyd_Mailing_Address_Modified_Source__c
Label	Mailing Address Modified Source
Type	PICKLIST
Picklist values	Aperture Australia Post Census 2022 Email iModules Mail Phone Swift Sydney Student

Name	Usyd_Mobile_Modified_By__c
Label	Mobile Modified By
Type	LOOKUP
Foreign key	Yes
Help Text	Mobile modified by name

Name	Usyd_Mobile_Modified_Date__c
Label	Mobile Modified Date
Type	DATETIME
Help Text	Mobile modified date

Name	Usyd_Mobile_Modified_Source__c
Label	Mobile Modified Source
Type	PICKLIST
Picklist values	Aperture Australia Post Census 2022 Email iModules Mail Phone Swift Sydney Student

Name	Usyd_Other_Email_Modified_By__c
Label	Other Email Modified By
Type	LOOKUP
Foreign key	Yes
Help Text	Other email modified by name

Name	Usyd_Other_Email_Modified_Date__c
Label	Other Email Modified Date
Type	DATETIME
Help Text	Other email modified date

Name	Usyd_Other_Email_Modified_Source__c
Label	Other Email Modified Source
Type	PICKLIST
Picklist values	Aperture Australia Post Census 2022 Email iModules Mail Phone Swift Sydney Student

Name	Usyd_Personal_Email_Modified_By__c
Label	Personal Email Modified By
Type	LOOKUP
Foreign key	Yes
Help Text	Personal email modified by name

Name	Usyd_Personal_Email_Modified_Date__c
Label	Personal Email Modified Date
Type	DATETIME
Help Text	Person email modified date

Name	Usyd_Personal_Email_Modified_Source__c
Label	Personal Email Modified Source
Type	PICKLIST
Picklist values	Aperture Australia Post Census 2022 Email iModules Mail Phone Swift Sydney Student

Name	Usyd_School_Email_Modified_By__c
Label	School Email Modified By
Type	LOOKUP
Foreign key	Yes
Help Text	School email modified by name

Name	Usyd_School_Email_Modified_Date__c
Label	School Email Modified Date
Type	DATETIME
Help Text	School email last modified date

Name	Usyd_School_Email_Modified_Source__c
Label	School Email Modified Source
Type	PICKLIST
Picklist values	Aperture Australia Post Census 2022 Email iModules Mail Phone Swift Sydney Student

Name	AQB__DummyText_AQ__c
Label	Dummy Text
Type	TEXT(50)
Help Text	This is a system use only field, do not add to Form or Reports
Description	This is a system use only field, do not add to Form or Reports

Name	AQB__PrimaryLanguage__c
Label	Primary Language
Type	PICKLIST
Picklist values	Arabic Chinese English French German Italian Japanese Polish Portuguese Russian Spanish Turkish

Name	AQB__MultiEthnicity__c
Label	Multi Ethnicity
Type	PICKLIST (MULTI-SELECT)
Picklist values	Asian Black or African American Caucasian Hispanic or Latino Native American Native Hawaiian and Other Pacific Islander Other Unknown

Name	pmdm__ConsecutiveAbsences__c
Label	Consecutive Absences
Type	NUMBER(18,0)
Help Text	The number of consecutive absences for this Contact, counting back from today. Clears to 0 when most recent Service Delivery was present.

Name	pmdm__IsClient__c
Label	Client
Type	CHECKBOX
Required	Yes
Default value	false

Name	pmdm__LastServiceDate__c
Label	Last Service Date
Type	DATE

Name	pmdm__NumAbsentServiceDeliveries__c
Label	Number of Absent Service Deliveries
Type	NUMBER(18,0)

Name	pmdm__NumPresentServiceDeliveries__c
Label	Number of Present Service Deliveries
Type	NUMBER(18,0)

Name	pmdm__AttendanceRate__c
Label	Attendance Rate
Type	FORMULA (PERCENT)(18,0)

Name	pmdm__AttendanceSummary__c
Label	Attendance Summary
Type	FORMULA (TEXT)(1300)

Name	caseman__AgeCategory__c
Label	Age Category
Type	PICKLIST
Picklist values	Child Youth Adult Senior

Name	caseman__Age__c
Label	Age
Type	FORMULA (NUMBER)(18,0)

Name	caseman__ClientID__c
Label	Client ID
Type	TEXT(100)
Unique	Yes
Description	If you have Client IDs for your clients you can import them to this field.

Name	caseman__EmergencyContactRole__c
Label	Emergency Contact Role
Type	TEXT(255)
Help Text	The relationship between the Contact and their Emergency Contact.
Description	The relationship between the Contact and their Emergency Contact.

Name	caseman__EmergencyContact__c
Label	Emergency Contact
Type	LOOKUP
Foreign key	Yes

Name	caseman__LegalName__c
Label	Legal Name
Type	TEXT(255)
Help Text	The legal name of the Contact. Use this field if you need to track legal name for administrative reasons or to assist Contact with official paperwork.
Description	The legal name of the Contact. Use this field if you need to track legal name for administrative reasons or to assist Contact with official paperwork.

Name	caseman__PhotoFileID__c
Label	Photo File ID
Type	TEXT(18)
Description	An ID generated and used by Salesforce to manage Client Photo files. Not intended for page layouts.

Name	caseman__PreferredCommunicationMethod__c
Label	Preferred Communication Method
Type	PICKLIST
Help Text	The Contact's preferred communication method. Values are determined by your Admin.
Picklist values	Call Text Email
Description	The Contact's preferred communication method. Values are determined by your Admin.

Name	caseman__PreferredPhoneField__c
Label	Preferred Phone Field
Type	PICKLIST
Help Text	The contact's preferred phone number field, will update the Preferred Phone Number field.
Picklist values	Phone Home Phone Mobile Phone Other Phone
Description	The contact's preferred phone number field, will update the Preferred Phone Number field.

Name	caseman__PreferredPhoneNumber__c
Label	Preferred Phone Number
Type	PHONE
Help Text	This field is controlled by the Preferred Phone Field picklist.
Description	This field is controlled by the Preferred Phone Field picklist.

Name	caseman__Pronouns__c
Label	Pronouns
Type	PICKLIST
Help Text	The pronoun set used by the client to refer to themself.
Picklist values	she/her/hers he/him/his they/them/theirs other/ask me
Description	The pronoun set used by the client to refer to themself.

Name	caseman__WatchListDate__c
Label	Watch List Date
Type	DATE
Help Text	The date you added the client to the Watch List.
Description	The date you added the client to the Watch List.

Name	caseman__WatchList__c
Label	Watch List
Type	CHECKBOX
Required	Yes
Help Text	Check this checkbox if this client requires heightened attention by staff.
Default value	false
Description	Check this checkbox if this client requires heightened attention by staff.

Name	caseman__EmergencyContactPhone__c
Label	Emergency Contact Phone
Type	FORMULA (TEXT)(1300)

Name	sumoapp__CreatedBySumo__c
Label	Created By SUMO
Type	CHECKBOX
Required	Yes
Default value	false

Name	sumoapp__IsGhost__c
Label	Is Ghost
Type	CHECKBOX
Required	Yes
Default value	false

Name	sumoapp__TextOptIn__c
Label	Text Opt In
Type	CHECKBOX
Required	Yes
Default value	true

Name	sumoapp__VoiceOptOut__c
Label	Phone Reminder Opt Out
Type	CHECKBOX
Required	Yes
Default value	false

Name	USDY_Wellness_PrivatelyManagedAccom__c
Label	Privately Managed Accommodation
Type	PICKLIST
Picklist values	Sydney University Village Scape UniLodge Urbanest IGLU Atira Other Student accommodation

Name	USYD_ATSIAboriginalandTorrensStraitIslan__c
Label	Aboriginal and Torrens Strait Islander
Type	PICKLIST
Picklist values	Yes No Not Assessed

Name	USYD_Academic_Plans_Exist__c
Label	Academic Plans Exist
Type	PICKLIST
Picklist values	Yes No
Description	Information to confirm if Academic Plans Exist or not

Name	USYD_Account_Balance__c
Label	Account Balance
Type	CURRENCY(16,2)
Description	Information on if the student Owes money to the university

Name	USYD_Affiliated_Organisations__c
Label	Affiliated Organisations
Type	PICKLIST (MULTI-SELECT)
Picklist values	Centre of English teaching Centre of Continuing Education Confucius Institute The United States Studies Centre Other

Name	USYD_Citizenship__c
Label	Citizenship
Type	PICKLIST
Picklist values	Yes No

Name	USYD_Country_of_Citizenship__c
Label	Country of Citizenship
Type	TEXT(255)

Name	USYD_Country_of_Origin__c
Label	Country of Origin
Type	PICKLIST
Picklist values	New Zealand United Kingdom Unites States India Peoples Republic of China Taiwan Singapore

Name	USYD_Email_Alert_Recipient__c
Label	Email Alert Recipient
Type	EMAIL
Description	This field is populated on the flow based on existence of Preferred Email and Contact Email fields. This field will be the Recipient of certain Email Alerts

Name	USYD_IsAlumni__c
Label	IsAlumni
Type	CHECKBOX
Required	Yes
Default value	false

Name	USYD_IsInternational__c
Label	USYD IsInternational
Type	TEXT(80)

Name	USYD_IsStaff__c
Label	IsStaff
Type	CHECKBOX
Required	Yes
Default value	false

Name	USYD_IsStudent__c
Label	IsStudent
Type	CHECKBOX
Required	Yes
Default value	false

Name	USYD_LGBTIQA__c
Label	LGBTIQA
Type	PICKLIST
Picklist values	Yes No Not Assessed

Name	USYD_Language_Barrier__c
Label	Language Barrier
Type	PICKLIST
Picklist values	Yes No Not Assessed

Name	USYD_Level_of_Study__c
Label	Level of Study
Type	PICKLIST
Picklist values	Under Graduation Post Graduate Higher Degree by Research

Name	USYD_Next_Of_Kin__c
Label	Next Of Kin
Type	CHECKBOX
Required	Yes
Default value	false

Name	USYD_Part_time__c
Label	Part time
Type	CHECKBOX
Required	Yes
Default value	false

Name	USYD_Preferred_Address_Wellness__c
Label	Preferred Address
Type	TEXT AREA(255)
Description	Preferred Address entered by the intake officer during the intake

Name	USYD_Preferred_Contact_no_wellness__c
Label	Preferred Contact no
Type	TEXT(15)
Description	Preferred contact no captured by intake officer during case investigation

Name	USYD_Preferred_E_mail_wellness__c
Label	Preferred E-mail
Type	EMAIL
Description	Preferred e-mail address captured by the intake officer during the intake process

Name	USYD_Preferred_Name_wellness__c
Label	Preferred Name
Type	TEXT(100)
Description	Preferred Name for wellness app

Name	USYD_Special_Care_Plan__c
Label	Special Care Plan
Type	CHECKBOX
Required	Yes
Help Text	Select when student needs special care plan
Default value	false
Description	SLO will select this if a Special care plan is needed

Name	USYD_Staff_ID__c
Label	Staff ID
Type	TEXT(10)
Unique	Yes

Name	Usyd_Formal_Salutation__c
Label	Formal Salutation
Type	FORMULA (TEXT)(1300)
Help Text	Dear ‘xxx’ at the top of the letter or formal email
Description	AVE-39. Dear ‘xxx’ at the top of the letter or formal email

Name	USYD_Sydney_Student_ID__c
Label	Sydney Student ID
Type	TEXT(100)

Name	USYD_Under_Age__c
Label	Under Age
Type	FORMULA (CHECKBOX)
Required	Yes

Name	USYD_Unikey__c
Label	Unikey
Type	TEXT(15)
Unique	Yes

Name	USYD_Visa_Type__c
Label	Visa Type
Type	PICKLIST
Picklist values	Permanent Resident Partner Visa Student

Name	USYD_Vulnerable_Contact__c
Label	USYD Vulnerable Contact
Type	CHECKBOX
Required	Yes
Default value	false

Name	USYD_Wellness_External_Support__c
Label	External Support
Type	PICKLIST (MULTI-SELECT)
Picklist values	1800RESPECT NSW Sexual Violence Helpline SRC casework office SUPRA casework office USU Anti-Slavery Australia Community Legal Centre Australian Human Rights Commission GP/Allied Health Professional NSW Police Hospital, Local Sexual Assault Service Other

Name	USYD_Wellness_Internal_Support__c
Label	Internal Support
Type	PICKLIST (MULTI-SELECT)
Picklist values	RPA/ USYD Partnership Outreach Clinic Student Affairs Unit Workplace Relations Unit Student Accomodation Financial support Protective Services Gadigal Centre Student Counselling Service USYD After Hours Mental Wellbeing Support line Inclusion and Disability Service Special Considerations Faculty/School Student support/Education Support team Domestic/International Fees Office Other

Name	USYD_Wellness_Living_at_home__c
Label	Living at home
Type	PICKLIST
Picklist values	Yes No

Name	USYD_Wellness_Other_Accommodation__c
Label	Other Accommodation
Type	TEXT(40)

Name	USYD_Wellness_Primary_Faculty__c
Label	Primary Faculty
Type	PICKLIST
Picklist values	FASS Academic Operations School of Economics School of Education and Social Work School of Languages and Cultures School of Literature, Art and Media School of Philosophical and Historical Inquiry School of Social and Political Sciences Business School Engineering Faculty Units School of Aerospace, Mechanical and Mechatronic Engineering School of Biomedical Engineering School of Chemical and Biomolecular Engineering School of Civil Engineering School of Computer Science School of Electrical and Information Engineering School of Project Management FMH Clinical and Professional Development Unit School of Health Sciences School of Medical Sciences School of Public Health Sydney Dental School Sydney Medical School Sydney Nursing School Sydney Pharmacy School School of Life and Environmental Sciences School of Psychology Science Faculty Units Sydney School of Veterinary Science Sydney Conservatorium of Music Sydney Law School Sydney School of Architecture, Design and Planning
Description	Primary Faculty selected by wellness team when the student is part of multiple faculties

Name	USYD_Wellness_Private_Rental__c
Label	Private Rental
Type	PICKLIST
Picklist values	Yes No

Name	USYD_Wellness_Residential_College__c
Label	Residential College
Type	PICKLIST
Picklist values	St Andrew’s College St Pauls’ College Sancta Sophia College St John’s College The Women’s College Wesley College Mandelbaum House

Name	USYD_Wellness_Student_Current_Accom__c
Label	Student Current Accommodation Type
Type	PICKLIST
Picklist values	University owned Residential college Privately managed

Name	USYD_Wellness_Student_Living_Arrangement__c
Label	Student Living Arrangement
Type	PICKLIST
Picklist values	living alone living with relatives/family living with others; e.g. flatmates, friends homeless/couch surfing

Name	USYD_Wellness_University_Owned_Accom__c
Label	University Owned Accomodation
Type	PICKLIST
Picklist values	Abercrombie Darlington House Darlington Terrace Nepean Hall Nepean Lodge Queen Mary Building Regiment Building

Name	USYD_wellness_Trim_Record__c
Label	Safer Communities Record Exists in RMS
Type	CHECKBOX
Required	Yes
Default value	false

Name	USYD_wellness_contact__c
Label	Wellness Contact
Type	CHECKBOX
Required	Yes
Default value	false
Description	This flag identifies that the field identifies that the contact is created by Wellness team

Name	Usyd_Account_Email_Modified_By__c
Label	Account Email Modified By
Type	LOOKUP
Foreign key	Yes
Help Text	Account email modified by

Name	Usyd_Account_Email_Modified_Date__c
Label	Account Email Modified Date
Type	DATETIME
Help Text	Account email last modified date

Name	Usyd_Account_Phone_Modified_By__c
Label	Account Phone Modified By
Type	LOOKUP
Foreign key	Yes

Name	Usyd_Account_Phone_Modified_Date__c
Label	Account Phone Modified Date
Type	DATETIME
Help Text	Account Phone modified by date

Name	Usyd_Account_Phone_Modified_Source__c
Label	Account Phone Modified Source
Type	PICKLIST
Help Text	Account Phone modified source
Picklist values	Aperture Australia Post Census 2022 Email iModules Mail Phone Swift Sydney Student

Name	Usyd_Average_Legal_Credit__c
Label	Average Legal Credit
Type	NUMBER(16,2)
Help Text	This stores the average of all funds received Transactions based on LC % on GRC record Value = Σ of Transaction Amount * GRC LC % / # of Transactions (where Transaction records having the Funds Received Flag set to true and Amount is greater than 0) Refreshed on Nightly Job that picks up all transactions(regardless of type i.e. void) for the day for all contacts
Description	This stores the average Legal Credit of all Gift recognition credits related to the Contact

Name	Usyd_Consecutive_Years__c
Label	Consecutive Years
Type	NUMBER(18,0)
Help Text	Count of number of years given from current year backwards consecutively for funds received Transaction based on LC % on GRC record Value = Count of each year Transaction (where Transaction records have Funds Received Flag is set to true and Amount is greater than 0) from current year backwards consecutively Refreshed on Nightly Job that picks up all transactions(regardless of type i.e. void) for the day for all contacts
Description	Count of number of years given from current year backwards consecutively

Name	Usyd_Email_Modified_By__c
Label	Email Modified By
Type	LOOKUP
Foreign key	Yes
Help Text	Email modified by name

Name	Usyd_Email_Modified_Date__c
Label	Email Modified Date
Type	DATETIME
Help Text	Email modified date

Name	Usyd_Email_Modified_Source__c
Label	Email Modified Source
Type	PICKLIST
Picklist values	Aperture Australia Post Census 2022 Email iModules Mail Phone Swift Sydney Student

Name	Usyd_Largest_Legal_Credit__c
Label	Largest Legal Credit
Type	NUMBER(16,2)
Help Text	This stores the Largest Amount of all funds received Transactions based on LC % on GRC record Value= Takes the Largest Amount of all Transaction records * GRC LC % (where Transaction records having the Funds Received Flag set to true and Amount is greater than 0) Refreshed on Nightly Job that picks up all transactions(regardless of type i.e. void) for the day for all contacts
Description	This stores the Largest Legal Credit of all Gift recognition credits related to the Contact

Name	Usyd_Most_Recent_Legal_Credit_Amount__c
Label	Most Recent Legal Credit Amount
Type	NUMBER(16,2)
Help Text	This stores the Most Recent funds received Transactions based on LC % on GRC record Value = Most recent Transaction Amount * GRC LC % (where Transaction records having the Funds Received Flag set to true and Amount is greater than 0) Refreshed on Nightly Job that picks up all transactions(regardless of type i.e. void) for the day for all contacts
Description	Most Recent Legal Credit Amount

Name	Usyd_Most_Recent_Legal_Credit_Campaign__c
Label	Most Recent Legal Credit Campaign
Type	TEXT(255)
Help Text	The campaign on the Most Recent funds received Transaction based on LC % on GRC record Value = Campaign of the most recent Transaction (where Transaction records have Funds Received Flag is set to true and Amount is greater than 0) Refreshed on Nightly Job that picks up all transactions(regardless of type i.e. void) for the day for all contacts

Name	Usyd_Most_Recent_Legal_Credit_Date__c
Label	Most Recent Legal Credit Date
Type	DATE
Help Text	The date for the Most Recent Legal Credit Amount Value = date of the most recent Transaction (where Transaction records having the Funds Received Flag set to true and Amount is greater than 0) Refreshed on Nightly Job that picks up all transactions(regardless of type i.e. void) for the day for all contacts

Name	Usyd_Open_Opportunities_Amount__c
Label	Open Opportunities Amount
Type	NUMBER(16,2)
Description	AVE-84: This field holds the value of the total amount in opportunity linked to the account of the contact where status is not closed.

Name	Usyd_Open_Pledge_Amount__c
Label	Open Pledge Amount
Type	CURRENCY(16,2)
Help Text	Pledge balances based on LC% Value =Σ of Transaction Balance * GRC LC % (where Transaction records have Funds Received Flag is set to true and Amount is greater than 0) Refreshed on Nightly Job that picks up all transactions(regardless of type i.e. void) for the day for all contacts
Description	Ave-84: This is to hold value by calculating all pledges balance and get the LC based on GRC.

Name	Usyd_Phone_Modified_By__c
Label	Phone Modified By
Type	LOOKUP
Foreign key	Yes
Help Text	Phone Modified by name

Name	Usyd_Phone_Modified_Date__c
Label	Phone Modified Date
Type	DATETIME
Help Text	Phone last modified date

Name	Usyd_Phone_Modified_Source__c
Label	Phone Modified Source
Type	PICKLIST
Picklist values	Aperture Australia Post Census 2022 Email iModules Mail Phone Swift Sydney Student

Name	Usyd_Recurring_Gift__c
Label	Recurring Gift #
Type	NUMBER(18,0)
Help Text	Pledge balances based on LC% Value = # of Recurring Gifts linked to a pledge (linked to the Contact whose status is Active, Under Investigation, or Pending Review) Refreshed on Nightly Job that picks up all transactions(regardless of type i.e. void) for the day for all contacts
Description	AVE-332: This is to hold the number of recurring gifts in which status are either active, under investigation, pending review.

Name	Usyd_Total_Credit_Amount__c
Label	Total Legal Credit
Type	NUMBER(16,2)
Help Text	This stores the sum of all funds received transactions based on LC % on GRC record Value = Σ of Transaction Amount * GRC LC % (where Transaction records have having Funds Received Flag set to true and Amount is greater than 0) Refreshed on Nightly Job that picks up all transactions(regardless of type i.e. void) for the day for all contacts
Description	This stores the sum of all Gift recognition credits related to the Contact

Name	Usyd_Total_Giving_Influence__c
Label	Total Giving Influence
Type	NUMBER(16,2)
Help Text	Same as Total Legal Credit but based on GRC% instead of LC% + Soft Credits Value = Σ of Transaction Amount * GRC GRC% (where Transaction records have having Funds Received Flag set to true and Amount is greater than 0) + Soft Credits to the Account Refreshed on Nightly Job that picks up all transactions(regardless of type i.e. void) for the day for all contacts
Description	AVE-332: This is calculated same as Total Credit Amount but using the GRC % on contact record.

Name	Usyd_Total_Years_Given__c
Label	Total Years Given
Type	NUMBER(18,0)
Help Text	The Total number of years funds received Transaction based on LC % on GRC record Value = Count of each year Transaction (where Transaction records have Funds Received Flag is set to true and Amount is greater than 0) Refreshed on Nightly Job that picks up all transactions(regardless of type i.e. void) for the day for all contacts
Description	Total Years Given

Name	flag1__c
Label	flag1
Type	TEXT(1)

Name	Usyd_Informal_Salutation__c
Label	Informal Salutation
Type	FORMULA (TEXT)(1300)
Help Text	Informal email or letter
Description	AVE-39. Informal email or letter

Name	Usyd_Mailing_Name__c
Label	Mailing Name
Type	FORMULA (TEXT)(1300)
Help Text	Used for Outer envelope, address block
Description	AVE_Mailing_Name AVE-39: Purpose: Used for Outer envelope, address block

Name	USYD_CampaignSummaryLastModifiedDate__c
Label	Campaign Summary Last Modified Date
Type	DATE

Name	USYD_MostRecentCampaignInteractionDate__c
Label	Most Recent Campaign Interaction Date
Type	DATE

Name	USYD_Most_Recent_Campaign_Interacted__c
Label	Most Recent Campaign Interacted
Type	LOOKUP
Foreign key	Yes

Name	USYD_No_of_Campaigns_Clicked_LY__c
Label	No. of Campaigns Clicked Last Year
Type	NUMBER(18,0)

Name	USYD_No_of_Campaigns_Clicked_YTD__c
Label	No. of Campaigns Clicked YTD
Type	NUMBER(18,0)

Name	USYD_No_of_Campaigns_Participated_LY__c
Label	No. of Campaigns Participated Last Year
Type	NUMBER(18,0)

Name	USYD_No_of_Campaigns_Participated_YTD__c
Label	No. of Campaigns Participated YTD
Type	NUMBER(18,0)

Name	USYD_No_of_Campaigns_Registered_LY__c
Label	No. of Campaigns Registered Last Year
Type	NUMBER(18,0)

Name	USYD_No_of_Campaigns_Registered_YTD__c
Label	No. of Campaigns Registered YTD
Type	NUMBER(18,0)

Name	USYD_No_of_TAP_eNewsletters_Clicked_LY__c
Label	No. of TAP eNewsletters Clicked Last Yr
Type	NUMBER(18,0)

Name	USYD_No_of_TAP_eNewsletters_Clicked_YTD__c
Label	No. of TAP eNewsletters Clicked YTD
Type	NUMBER(18,0)

Name	USYD_Total_Campaigns_Received_LY__c
Label	Total Campaigns Received Last Year
Type	NUMBER(18,0)

Name	USYD_Total_Campaigns_Received_YTD__c
Label	Total Campaigns Received YTD
Type	NUMBER(18,0)

Name	bt_stripe__Default_Payment_Gateway__c
Label	Default Payment Gateway
Type	LOOKUP
Foreign key	Yes
Help Text	This field is automatically set from the related Default Payment Method's Payment Gateway.
Description	This field is automatically set from the related Default Payment Method's Payment Gateway.

Name	bt_stripe__Default_Payment_Method__c
Label	Default Payment Method
Type	LOOKUP
Foreign key	Yes
Help Text	Latest payment method will be automatically populated, but can be updated.
Description	Latest payment method will be automatically populated, but can be updated.

Name	bt_stripe__Gender__c
Label	Gender
Type	PICKLIST
Picklist values	Female Male

Name	bt_stripe__Maiden_Name__c
Label	Maiden Name
Type	TEXT(255)

Name	bt_stripe__Personal_ID_Number_Encrypted__c
Label	Personal ID Number
Type	TEXT (ENCRYPTED)(175)
Help Text	The government-issued ID number of the account representative, as appropriate for the representative's country (e.g., a Social Security Number in the U.S. or a Social Insurance Number in Canada)
Description	The government-issued ID number of the account representative, as appropriate for the representative's country (e.g., a Social Security Number in the U.S. or a Social Insurance Number in Canada)

Name	bt_stripe__Personal_ID_Type__c
Label	Personal ID Type
Type	PICKLIST
Picklist values	Driver License Passport Permanent Resident Card Birth Certificate Other

Name	bt_stripe__Primary_Stripe_Customer__c
Label	Primary Stripe Customer
Type	CHECKBOX
Required	Yes
Default value	false

Name	bt_stripe__SSN_Last_4_Encrypted__c
Label	SSN Last 4
Type	TEXT (ENCRYPTED)(4)
Help Text	The last 4 digits of the Social Security Number of the account representative (U.S. only)
Description	The last 4 digits of the Social Security Number of the account representative (U.S. only)

Name	USYD_Address_Type__c
Label	Address Type
Type	PICKLIST
Help Text	What kind of mailing address has the Contact provided?
Picklist values	Home Business Postal Other
Description	This field categorizes the type of Address provided and how it is used.

Name	USYD_Email_Type__c
Label	Email Type
Type	PICKLIST
Help Text	What kind of email has the Contact provided?
Picklist values	Personal Business Other
Description	This field categorizes the type of email provided and how it is used.

Name	USYD_Phone_Type__c
Label	Phone Type
Type	PICKLIST
Help Text	What kind of phone number has the Contact provided?
Picklist values	Mobile Business Landline Fax Other
Description	This field categorizes the type of phone number provided and how it is used.

TAP - Advancement Portfolio Product

Object: Contact

Analytics

Fields

Validation rules

Triggers

Fields Details

Related content