ā1
| āRecipient ID
| āRECIP_ID
| āUnique ID for this recipient.
| ān/a
|
ā2
| āRecipient date of birth
| āRECIP_DOB
| āRecipient's date of birth.
| ān/a
|
ā3
| āRecipient sex
| āRECIP_SEX
| āRecipient sex.
| ā HL7 User Defined table 0001 M (Male) F (Female) U (Unknown/undifferentiated) X (Non-Binary) ā
|
ā4
| āRecipient race/ethnicity
| āRECIP_RACE_ETH
| āRecipient's race/ethnicity.
| ā When ethnicity is marked āHispanic or Latinoā then āLatinoā, when more than one specified race code (1002-5, 2028-9, 2076-8, 2054-5, 2106-3) is noted then āMultiracialā, otherwise first race is noted. Derived from original ethnicity and race codes: HL7 User Defined Table 0189 2135-2 (Hispanic or Latino) 2186-5 (Not Hispanic or Latino) PHC1175 (Prefer not to say) UNK (Unknown ethnicity) POL (Unable to report to do policy/law)
HL7 User Defined Table 0005 1002-5 (American Indian or Alaska Native) 2028-9 (Asian) 2076-8 (Native Hawaiian or Other Pacific Islander) 2054-5 (Black or African American) 2106-3 (White) 2131-1 (Other Race) UNK (Unknown)
|
ā5
| āAdministration date ā dose 1
| āADMIN_DATE_1
| āFirst MMR vaccine administration date. ADMIN_DATE_1 = first MMR vaccine administration date of series.
| ān/a
|
ā6
| āAdministration date ā dose 2
| āADMIN_DATE_2
| āSecond MMR vaccine administration date. ADMIN_DATE_2 = second MMR vaccine administration date of series.
| ān/a
|
ā7
| āAdministration date ā dose 3
| āADMIN_DATE_3
| āThird MMR vaccine administration date (if applicable). ADMIN_DATE_3 = third MMR vaccine administration date of series (if applicable).ā
| ān/a
|
ā8
| āVaccine product - dose 1
| āVACCINE_PRODUCT_1
| āThe manufacturer name of vaccine received for the first dose of the MMR series. Vaccine_Product_1 = first MMR vaccination given.
| ā |
ā9
| āVaccine product - dose 2
| āVACCINE_PRODUCT_2
| āThe manufacturer name of vaccine received for the second dose of the MMR series. Vaccine_Product_2 = second MMR vaccination given.
| ā |
ā10
| āVaccine product - dose 3
| āVACCINE_PRODUCT_3
| āThe manufacturer name of vaccine received for the third dose of MMR, if applicable. Vaccine_Product_3 = third MMR vaccination given (if applicable).
| ā |
ā11
| āCVX - dose 1
| āVACCINE_PRODUCT_1_CVX
| āThe vaccine type that was administered for the first dose of the MMR series. Vaccine_Product_1_cvx = first MMR vaccination given. ā
| āCVX Codes
|
ā12
| āCVX - dose 2
| āVACCINE_PRODUCT_2_CVX
| āThe vaccine type that was administered for the second dose of the MMR series. Vaccine_Product_2_cvx = second MMR vaccination given.
| āCVX Codes
|
ā13
| āCVX - dose 3
| āVACCINE_PRODUCT_3_CVX
| āThe vaccine type that was administered for the third dose of MMR, if applicable. Vaccine_Product_3_cvx = third MMR vaccination given (if applicable).
| āCVX Codes
|
ā14
| āVaccine received - 12-15 Months of Age
| āVAX_RECEIVED_12_15_MONTHS
| āReceived MMR vaccine at age 12-15 months, as recommended by CDC.
| āYes/No
|
ā15
| āVaccine received - 4-6 Years of Age
| āVAX_RECEIVED_4_6_YEARS
| āReceived MMR vaccine at age 4-6 years, as recommended by CDC.
| āYes/No
|
ā16
| āVaccine received - Third dose
| āVAX_RECEIVED_THIRD_DOSE
| āReceived third dose of MMR vaccine.
| āYes/No
|
ā17
| āMMR series completed
| āMMR_SERIES_COMPLETE
| āTwo dose MMR vaccination series was completedā
| āYes/No
|
ā18
| āMMR series completed per CDC schedule
| āMMR_SERIES_COMPLETE_ON_SCHEDULE
| āTwo dose MMR vaccination series was completed according to CDC recommended schedule
| āYes/No
|
ā 19
| āRecipient age - at first dose
| āAGE_FIRST_MMR
| āRecipient age in years when received first MMR vaccine.
| ān/a
|
ā20
| āRecipient age - at second dose
| āAGE_SECOND_MMR
| āRecipient age in years when received second MMR vaccine.
| ān/a
|
ā21
| āRecipient age - at third dose
| āAGE_THIRD_MMR
| āRecipient age in years if received third MMR vaccine.
| ān/a
|
ā22
| āRecipient name: first
| āRECIP_FIRST_NAME
| āRecipient's first name.
| ān/aā
|
ā 23
| āRecipient name: middle
| āRECIP_MIDDLE_NAME
| āRecipient's middle name.
| ān/a
|
ā 24
| āRecipient name: last
| āRECIP_LAST_NAME
| āRecipient's last name.
| ān/a
|
ā25
| āRecipient age
| āRECIP_AGE
| āRecipient's age in years as of current date.ā
| ān/a
|
ā 26
| Recipient address: streetā
| āRECIP_ADDRESS_STREET
| āThe street component of the recipient's address.
| ān/a
|
ā27
| āRecipient address: street 2
| āRECIP_ADDRESS_STREET_2
| āThe street 2 component of the recipient's address.
| ān/a
|
ā28
| āRecipient address: city
| āRECIP_ADDRESS_CITY
| āThe city component of the recipient's address
| ān/a
|
ā 29
| āRecipient address: state
| āRECIP_ADDRESS_STATE
| āThe state component of the recipient's address
| āUS Postal Service two-character State Codes
|
ā30
| āRecipient address: zip code
| āRECIP_ADDRESS_ZIP
| āThe zip code of the recipient's address (5 digit or 10 digits, with hyphen, are acceptable).
| ān/aā
|
ā31
| āRecipient county name
| āRECIP_COUNTY_LABEL
| āThe county name component of the recipient's address
| āDerived from FIPs based on County Code. When RECIP_ADDRESS_COUNTY is null, derived from RECIP_ADDRESS_ZIP. See RECIP_ADDRESS_COUNTY _NEW
|
ā 32
| āResponsible organization
| āRESPONSIBLE_ORG
| āThe name of the parent organization or health system that originated and is accountable for the content of the record. If an organization has several clinics or facilities, this would be the organization that represents all of the clinics/facilities (the "Administered at location" field is the name of individual physical location).
| ān/a
|
ā 33
| āAdministration address: county name
| āADMIN_COUNTY_LABEL
| āThe county component of where the vaccine is being administered/planned to be administered. Exception for mobile clinics.
| āJoin with FIPs table based on County_Code to get the county name
|
ā34
| āCensus tract ā recipient address (2020)
| āCENSUS_TRACT
| ā2020 census tract based on recipient address only.
| ān/a
|
ā35
| āCensus tract ā recipient address (2010)
| āCENSUS_TRACT_10
| ā2010 census tract based on recipient address only.
| ān/a
|
ā 36
| āCensus tract ā administration address
| āCENSUS_TRACT_ADMIN_10
| ā2010 census tract based on vaccinating providerās address only.
| ān/aā
|
ā37
| āAdministered at location
| āADMIN_NAME
| āThe name of the physical clinic or facility that reported the vaccination. In a small practice setting, this could be the same as the responsible organization.
| ān/a
|
ā38
| āRecipient address: county based on HPI_3_MIXED
| āHPI_COUNTY_RCP_MIXED
| āThe county name of the recipientās address, derived from HPI_3_MIXED.
| ā |
ā 39
| āHPI 3.0 - census tract
| āHPI_3_TRACT
| āHealthy Places Index 3.0 score quartile based on the 2010 census tract from the recipientās address.
| āHealthy Places Index Locally Defined Value Set: 1 (HPI Quartile 1)
2 (HPI Quartile 2) 3 (HPI Quartile 3) 4 (HPI Quartile 4) Null (no HPI score assigned) https://map.healthyplacesindex.org
|
ā40
| āHPI 3.0 ā zip
| āHPI_3_ZIP
| Healthy PIaces Index 3.0 score quartile based on the recipientās address zip (if null, uses the ZCTA zip from the zip-to-ZCTA crosswalk); if recipientās address zip is still null, uses the vaccinating providerās address zip (if providerās address zip is null, uses the ZCTA from the zip-to-ZCTA crosswalk).
| āHealthy Places Index Locally Defined Value Set: 1 (HPI Quartile 1) 2 (HPI Quartile 2) 3 (HPI Quartile 3) 4 (HPI Quartile 4) Null (no HPI score assigned) https://map.healthyplacesindex.org
|
ā41
| āHPI 3.0 - mixed
| āHPI_3_MIXED
| āHPI_3_TRACT; if null, uses HPI_3_ZIP.
| āHealthy Places Index Locally Defined Value Set: 1 (HPI Quartile 1) 2 (HPI Quartile 2) 3 (HPI Quartile 3) 4 (HPI Quartile 4) Null (no HPI score assigned) https://map.healthyplacesindex.org ā
|