DNA-style Fields

Documentation of available fields with examples

Addresses

  • CensusTractNumber: A numerical code representing a small geographic region used for statistical purposes by the US Census Bureau. Example: "123456"

  • CityName: The name of the city where the address is located. Example: "Philadelphia"

  • CountryCode: A standardized two-letter code representing the country. Example: "US"

  • CountrySubdivisionCode: The code representing the country's primary subdivision, such as a state or province. Example: "PA" (Pennsylvania)

  • IsAddressChange: A boolean flag indicating if the address has recently been changed. Example: true

  • AddressLines:

    • AddrLineTypCd: The type code for the address line, indicating if it is a street address, PO box, etc. Example: "STR" (Street), "POB" (PO Box)

    • Value: The actual address line value. Example: "123 Main St"

  • MailCode: A code used for mailing purposes. Example: "MAILCODE123"

  • ShouldUpdate: A boolean indicating if the address information needs to be updated in the system. Example: true

  • SMSANumber: Standard Metropolitan Statistical Area number. Example: "98765"

  • State: The state where the address is located. Example: "PA"

  • UseCode: A code representing the use of the address. Example: "RES" (Residential), "BUS" (Business)

  • ZipCode: The primary postal code. Example: "19103"

  • ZipSuffix: The extended part of the ZIP code for more precise location identification. Example: "1234"

  • SeasonalAddress:

    • StartDate: The start date of the seasonal address. Example: "2023-05-01"

    • StartDayNbr: The start day number of the seasonal address. Example: 1

    • StartMonthCd: The start month code of the seasonal address. Example: "05" (May)

    • StopDate: The stop date of the seasonal address. Example: "2023-10-01"

    • StopDayNbr: The stop day number of the seasonal address. Example: 1

    • StopMonthCd: The stop month code of the seasonal address. Example: "10" (October)

Demographics

  • CreditRating: The credit rating of the individual. Example: "EXCELLENT"

  • CustomerTypeCode: The customer type code. Example: "IND" (Individual), "BUS" (Business)

  • EducationLevel: The education level of the individual. Example: "BACHELOR"

  • GradDate: The graduation date. Example: "2020-05-15"

  • IncomeLevel: The income level of the individual. Example: "75000-100000"

  • IsAllowPromCallsMsgs: Boolean indicating if promotional calls/messages are allowed. Example: true

  • MailTypeCode: The mail type code. Example: "PAPER", "EMAIL"

  • MemberGroupCode: The member group code. Example: "VIP", "REGULAR"

  • Occupation: The occupation of the individual. Example: "Software Engineer"

  • OwnOrRent: Indicates if the individual owns or rents. Example: "OWN", "RENT"

  • PreferredLocaleCode: The preferred locale code. Example: "EN_US"

  • PrivacyRequested: Boolean indicating if privacy is requested. Example: true

  • SpousePersonNumber: The person number of the spouse. Example: 123456

  • TaxCountryCode: The tax country code. Example: "US"

EmailAddresses

  • addrUseCode: The address use code. Example: "PERSONAL", "BUSINESS"

  • IsDelete: Boolean indicating if the email address should be deleted. Example: true

  • ElectronicAddressLines:

    • AddrLine: The electronic address line. Example: "user@example.com"

ForeignTaxIds

  • TaxIdApplyDate: The tax ID apply date. Example: "2022-01-01"

  • TaxIdCertDate: The tax ID certification date. Example: "2022-02-01"

  • CountryCode: The country code. Example: "US"

  • TaxIdNbr: The tax ID number. Example: "123-45-6789"

  • TaxIDTyp: The tax ID type. Example: "SSN", "EIN"

HSAData

  • EmployerOrgNumber: The employer organization number. Example: 98765

  • IDVettingStatusCode: The ID vetting status code. Example: "APPROVED"

  • OFACVettingStatusCode: The OFAC vetting status code. Example: "CLEARED"

  • VettDate: The vetting date. Example: "2023-01-15"

  • VettingEffDate: The vetting effective date. Example: "2023-01-20"

Identification

  • CustKeyWord: The customer keyword. Example: "SECRETKEY"

  • DateOfBirth: The date of birth. Example: "1985-05-20"

  • DateOfDeath: The date of death. Example: "2075-10-01"

  • ForeignCertExpirationDate: The foreign certification expiration date. Example: "2030-12-31"

  • TaxIdApplyDate: The tax ID apply date. Example: "2000-01-01"

  • TaxIdCertDate: The tax ID certification date. Example: "2000-02-01"

  • TaxPayerNumber: The taxpayer number. Example: "123-45-6789"

IsValid

  • IsValid: Boolean indicating if the record is valid. Example: true

Name

  • FirstName: The first name. Example: "John"

  • LastName: The last name. Example: "Doe"

  • MiddleInitial: The middle initial. Example: "A"

  • MiddleName: The middle name. Example: "Allen"

  • NickName: The nickname. Example: "Johnny"

  • SalutationCode: The salutation code. Example: "Mr.", "Mrs.", "Dr."

  • Suffix: The suffix. Example: "Jr.", "Sr.", "III"

PersExtOrgIds

  • ExternalId: The external ID. Example: "EXT12345"

  • ExternalIdTypeCode: The external ID type code. Example: "EMPLOYEE_ID"

  • ExternalOrgNumber: The external organization number. Example: 123456

PersIds

  • CountryCode: The country code. Example: "US"

  • CountrySubdivisionCode: The country's subdivision code. Example: "PA"

  • ExpireDate: The expiration date. Example: "2025-12-31"

  • IssueDate: The issue date. Example: "2020-01-01"

  • LastVerificationDate: The last verification date. Example: "2023-06-01"

  • StateCode: The state code. Example: "PA"

  • PersIdTypeCode: The personal ID type code. Example: "DRIVER_LICENSE"

  • IdValue: The ID value. Example: "123456789"

PersonNumber

  • PersonNumber: A unique identifier for the person. Example: 123456789

PersTyps

  • PersonTypeCode: The person type code. Example: "INDIVIDUAL", "BUSINESS"

  • EffectiveDate: The effective date. Example: "2023-01-01"

  • RemoveTypeCode: Boolean indicating if the person type should be removed. Example: true

Phones

  • AreaCode: The area code of the phone number. Example: "215"

  • PhoneCode: The phone code. Example: "MOBILE", "HOME"

  • CountryCode: The country code of the phone number. Example: "1"

  • Exchange: The exchange part of the phone number. Example: "555"

  • Extension: The extension number, if applicable. Example: "1234"

  • ForeignPhoneNumber: The foreign phone number, if applicable. Example: "+44 20 7946 0958"

  • IsPreferred: Boolean indicating if this is the preferred phone number. Example: true

  • PhoneLastUpdatedDate: The date the phone number was last updated. Example: "2023-07-15"

  • Number: The phone number. Example: "555-1234"

  • ShouldDelete: Boolean indicating if the phone number should be deleted. Example: true

  • ShouldUpdate: Boolean indicating if the phone number should be updated. Example: true

  • UsageCode: The usage code of the phone number. Example: "BUSINESS", "PERSONAL"

UserFields

  • Code: A custom code representing the user-defined field. Example: "CUSTOM_FIELD_1"

  • Value: The value of the user-defined field. Example: "Value1"

Last updated

Change request #178: