• Solutions
    • Pricing
    • For Community-Based Organizations
    • For Health Plans
    • For Doula Organizations
    • For Coalitions & Hubs
  • Network
    • Provider Network
  • About
    • Impact
    • Careers
    • News
  • Resources
    • Blog
  • Contact
    • Book a Demo
    • Contact Support
    • Subscribe
  • Platform Login
  • Book a Demo
  • Solutions
    • Pricing
    • For Community-Based Organizations
    • For Health Plans
    • For Doula Organizations
    • For Coalitions & Hubs
  • Network
    • Provider Network
  • About
    • Impact
    • Careers
    • News
  • Resources
    • Blog
  • Contact
    • Book a Demo
    • Contact Support
    • Subscribe
  • Platform Login
  • Book a Demo
  • Home
  • Pear Suite Features
  • Data Management

Data Dictionary

Explore essential data dictionary components, their answer options, and how to utilize them for effective data management and analysis.

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Pear Suite Features
    Member Management Templates & Builder Tools Goals Data Management Organizational Settings Pear Suite HUB Control Pear Suite Call Center Mobile App Recommendations External Resources Analytics User Dashboard
  • Activities
    Creating New Activities Scheduling Activities Managing Activities
  • Billing & Claims
    Getting Started Managing Claims
  • Customer Types
    Community Health Worker (CHW) Enhanced Care Managment - (ECM) Community Supports (CS) PCHI Doula
  • What's New
    Hot Topics Announcements & Release Notes
  • Resources
+ More

Table of Contents

Special Reserved IDs (non-member-field) Core member information Demographics Contact Information Insurance & related Language & Social Education, Employment & Household Emergency Contact Primacy Care Provider Caregiver

Pear Suite's database is built on a foundational library of pre-set data IDs that house the data collected in the member profile. These are the most important data IDs in the system which were selected to highlight information that's key to understanding the member's life situation. These data IDs are used as the basic information that organizes the analytics page, data exports, and care plan.

Data ID Field Label Data Type Options
D0 _id Member ID Text  
D1 firstName First Name Text  
D2 lastName Last Name Text  
D3 nickName Nick Name Text  
D4 gender Gender MultiChoice Agender, Cisgender, DoNotIdentifyWithLabels, Genderfluid, Genderqueer, IntersexDsd, Man, Nonbinary, NotListed, PreferNotToDisclose, Transgender, Woman
D5 dob Date of Birth Date  
D6 contactInfo.address Address 1 Text  
D7 contactInfo.primaryPhoneNumber.digits Phone Text  
D8 sex Sex Multi Female, Male
D13 contactInfo.email Email Text  
D25 race Race MultiChoice Alaska Native, Native American/Indigenous American/American Indian, Non-Hawaiian Pacific Islander, Hispanic / Latino / Spanish, American Indian / Alaskan, Asian / Asian American, Native Hawaiian, Black / African American, Caucasian / White, Not Listed, Prefer Not To Disclose
D26 spokenLanguages Spoken Languages MultiChoice AffanOromo, Amharic, Arabic, Armenian, Asl, Bantu, Bengali, Bosnian, CHamoru, Cantonese, Chinese, Chuukese, Croatian, Dari, Dinka, English, Farsi, Fijian, Filipino, French, German, Greek, Gujarati, Haitian, Hawaiian, Hebrew, Hindi, Hmong, Ilocano, Indonesian, Italian, Japanese, Khmer, Kinyarwanda, Korean, Lao, Mandarin, Marshallese, Mixteco, Montenegrin, Navajo, NotListed, Pashto, Persian, Polish, Portuguese, Punjabi, Russian, Samoan, Serbian, SerboCroatian, Somali, Spanish, Swahili, Tagalog, Tamil, Telugu, Thai, ThaiKadai, Tigrigna, Tonga, Turkish, Urdu, Vietnamese
D31 insuranceDetails.primaryInsuranceCompany.insurance Primary Insurance Company Text  
D44 ethnicity Ethnicity Multi Hispanic, NonHispanic, NotListed
D45 medicaidStatus Medicaid Status Multi ApplicationPending, Enrolled, NotEnrolled, Unknown
D46 medicareStatus Medicare Status Multi ApplicationPending, Enrolled, NotEnrolled, Unknown
D47 pronouns Pronouns MultiChoice HeHim, NotListed, PreferNotToDisclose, SheHer, TheyThem
D50 sexualOrientation Sexual Orientation MultiChoice Asexual, Bisexual, DoNotIdentifyWithLabels, Gay, HeterosexualOrStraight, Lesbian, NotListed, Pansexual, PreferNotToDisclose, Queer
D53 contactInfo.address2 Address 2 Text  
D60 contactInfo.zip Zip Code Text  
D67 phonetic Name Pronunciation Text  
D68 pregnancyStatus / pregnancyStatusEnum Pregnancy Status Multi NotPregnant, Postpartum, Pregnant
D69 primaryHealthPlanId Primary Health Plan ID Text  
D70 insuranceDetails.secondaryInsuranceCompany.insurance Secondary Insurance Company Text  
D71 secondaryHealthPlanId Secondary Health Plan ID Text  
D72 timezone Timezone Multi America/Anchorage, America/Los_Angeles, America/Phoenix, America/Denver, America/Chicago, America/Indiana/Indianapolis, America/New_York, America/Puerto_Rico, America/St_Johns, America/Argentina/Buenos_Aires, America/Sao_Paulo, Pacific/Midway, Pacific/Honolulu, Etc/GMT, UTC, Europe/Paris, Europe/Athens, Africa/Cairo, Africa/Harare, Africa/Nairobi, Asia/Tehran, Asia/Dubai, Asia/Karachi, Asia/Kolkata, Asia/Dhaka, Asia/Ho_Chi_Minh, Asia/Taipei, Asia/Tokyo, Australia/Adelaide, Australia/Sydney, Pacific/Guadalcanal, Pacific/Auckland
D73 diagnoses Diagnoses MultiChoice (org-scoped diagnosis codes — no global fixed list)
D74 prescriptions Prescriptions MultiChoice (free-text medication names — no fixed list)
D75 contactInfo.city City Text  
D76 contactInfo.country Country Multi (full ISO 3166-1 alpha-2 set, ~249 codes — e.g. US, CA, GB, MX)
D77 contactInfo.state State Multi AL, AK, AZ, AR, CA, CO, CT, DC, DE, FL, GA, HI, ID, IL, IN, IA, KS, KY, LA, ME, MD, MA, MI, MN, MS, MO, MT, NE, NV, NH, NJ, NM, NY, NC, ND, OH, OK, OR, PA, RI, SC, SD, TN, TX, UT, VT, VA, WA, WV, WI, WY (+ AS, FM, GU, MH, MP, PW, PR, VI in frontend)
D78 socialSecurityNumber Social Security Number Text  
D79 groups Groups MultiChoice (org-scoped group titles — no global fixed list)
D80 maidenNameOrAlias Maiden Name or Alias Text  
D81 medicalRecordNumber Medical Record Number Text  
D82 highestLevelOfEducation Highest Level of Education Multi NoEducation, GradeSchool, MiddleSchool, HighSchoolEquivalent, SomeCollegeNoDegree, AssociateDegree, BachelorDegree, MasterDegree, DoctoralDegree, PhD, TradeSchool, ProfessionalDegreeAndCertification
D83 employmentStatus Employment Status Multi Unemployed, EmployedPartTime, EmployedFullTime, Disabled, Retired
D84 employerName Employer Name Text  
D85 maritalStatus Marital Status Multi Divorced, Married, Separated, Single, Widowed
D86 peopleInHousehold People in Household Number  
D87 childrenInHousehold Children in Household Number  
D94 createdAt Created At Date  
D95 closureReason Closure Reason Text  
D96 emergencyContactName Emergency Contact Name Text  
D97 emergencyContactPhone Emergency Contact Phone Text  
D98 emergencyContactEmail Emergency Contact Email Text  
D99 emergencyContactRelation Emergency Contact Relationship Text  
D100 emergencyContactCanBeCalled Emergency Contact Can Be Called Boolean  
D101 emergencyContactCanBeTexted Emergency Contact Can Be Texted Boolean  
D102 primaryCareProviderName Primary Care Provider Name Text  
D103 primaryCareProviderPhone Primary Care Provider Phone Text  
D104 primaryCareProviderEmail Primary Care Provider Email Text  
D105 primaryCareProviderRelation Primary Care Provider Relationship Text  
D106 primaryCareProviderCanBeCalled Primary Care Provider Can Be Called Boolean  
D107 primaryCareProviderCanBeTexted Primary Care Provider Can Be Texted Boolean  
D108 caregiverName Caregiver Name Text  
D109 caregiverPhone Caregiver Phone Text  
D110 caregiverEmail Caregiver Email Text  
D111 caregiverRelation Caregiver Relationship Text  
D112 caregiverCanBeCalled Caregiver Can Be Called Boolean  
D113 caregiverCanBeTexted Caregiver Can Be Texted Boolean  
D114 age Age Number  
D115 status Member Status Multi Active, ClosedMerged, ClosedSuccessful, ClosedUnsuccessful, Declined
D116 shortMemberId Short Member ID Text  

Special Reserved IDs (non-member-field)

ID Purpose
PS_INTERNAL_MEMBER_ID Internal PearSuite member ID constant
DROQ1 Reserved read-only question data point (ReadOnlyText)

Core member information

ID Label Field Type
D0 Member ID _id Text
D1 First Name firstName Text
D2 Last Name lastName Text
D3 Nick Name nickName Text
D67 Name Pronunciation phonetic Text
D114 Age age Number
D115 Member Status status Multi
D94 Created At createdAt Date
D95 Closure Reason closureReason Text

Demographics

ID Label Field Type
D4 Gender gender MultiChoice
D8 Sex sex Multi
D5 Date of Birth dob Date
D25 Race race MultiChoice
D44 Ethnicity ethnicity Multi
D47 Pronouns pronouns MultiChoice
D50 Sexual Orientation sexualOrientation MultiChoice
D68 Pregnancy Status pregnancyStatus / pregnancyStatusEnum Multi
D80 Maiden Name or Alias maidenNameOrAlias Text
D78 Social Security Number socialSecurityNumber Text

Contact Information

ID Label Field Type
D6 Address 1 contactInfo.address Text
D53 Address 2 contactInfo.address2 Text
D75 City contactInfo.city Text
D77 State contactInfo.state Multi
D60 Zip Code contactInfo.zip Text
D76 Country contactInfo.country Multi
D7 Phone contactInfo.primaryPhoneNumber.digits Text
D13 Email contactInfo.email Text
D72 Timezone timezone Multi

Insurance & related

ID Label Field Type
D31 Primary Insurance Company insuranceDetails.primaryInsuranceCompany.insurance Text
D69 Primary Health Plan ID primaryHealthPlanId Text
D70 Secondary Insurance Company insuranceDetails.secondaryInsuranceCompany.insurance Text
D71 Secondary Health Plan ID secondaryHealthPlanId Text
D45 Medicaid Status medicaidStatus Multi
D46 Medicare Status medicareStatus Multi
D73 Diagnoses diagnoses MultiChoice
D74 Prescriptions prescriptions MultiChoice
D81 Medical Record Number medicalRecordNumber Text

Language & Social

ID Label Field Type
D26 Spoken Languages spokenLanguages MultiChoice
D79 Groups groups MultiChoice

Education, Employment & Household

ID Label Field Type
D82 Highest Level of Education highestLevelOfEducation Multi
D83 Employment Status employmentStatus Multi
D84 Employer Name employerName Text
D85 Marital Status maritalStatus Multi
D86 People in Household peopleInHousehold Number
D87 Children in Household childrenInHousehold Number

Emergency Contact

ID Label
D96 Emergency Contact Name
D97 Emergency Contact Phone
D98 Emergency Contact Email
D99 Emergency Contact Relationship
D100 Emergency Contact Can Be Called
D101 Emergency Contact Can Be Texted

Primacy Care Provider

ID Label
D102 Primary Care Provider Name
D103 Primary Care Provider Phone
D104 Primary Care Provider Email
D105 Primary Care Provider Relationship
D106 Primary Care Provider Can Be Called
D107 Primary Care Provider Can Be Texted

Caregiver

ID Label
D108 Caregiver Name
D109 Caregiver Phone
D110 Caregiver Email
D111 Caregiver Relationship
D112 Caregiver Can Be Called
D113 Caregiver Can Be Texted
metadata schema

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Templates & Builder Tools - Overview
  • Supported Fields for Data Exports
  • Creating an External Resource
footer logo

Empowering Community Health Workers

Solutions

  • Pricing
  • Organizations
  • Health Plans
  • Login

About

  • Provider Network
  • Our Impact
  • Careers
  • News

Contact

  • Book a Demo
  • Contact Support
  • Subscribe
  • Media Kit
Soc hipaa compliant logo BBB logo program distinction logo

emailinfo@pearsuite.com

© Copyright 2024. Pear Suite. All rights reserved Privacy Policy Terms of Service

Knowledge Base Software powered by Helpjuice

Expand