ā1
| Recipient ID
| RECIP_ID
| āUnique ID for this recipient.
| ān/a
|
ā2
| āRecipient name: first
| āRECIP_FIRST_NAME
| āRecipient's first name.
| ān/a
|
ā3
| āāRecipient name: middle
| āRECIP_MIDDLE_ NAME
| āRecipient's middle name.
| ān/a
|
ā4
| āRecipient name: last
| āRECIP_LAST_NAME
| āRecipient's last name.
| ān/a
|
ā5
| āRecipient date of birthā
| āRECIP_DOB
| āRecipient's date of birth.ā
| ān/a
|
ā6
| āRecipient age
| āRECIP_AGE
| āRecipient's age in years at time of vaccination.
| ān/a
|
ā7
| āāRecipient current age
| āRECIP_CURRENT_ AGE
| āRecipient's current age in years.
| ān/a
|
ā8
| āRecipient sex
| āRECIP_SEX
| āRecipient sex.
| āHL7 User Defined table 0001 M (Male) F (Female) U (Unknown/ undifferentiated) X (Non-Binary)
|
ā9
| 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)
|
ā10
| āRecipient address: street
| āRECIP_ADDRESS_ STREET
| āāThe street component of the recipient's address.
| ān/a
|
ā11
| āāāRecipient address: āÆstreet 2
| āRECIP_ADDRESS_ STREET_2
| āāThe street 2 component of the recipient's address.
| ān/a
|
ā12
| āāRecipient address: city
| āRECIP_ADDRESS _CITY
| āāThe city component of the recipient's address.
| ān/a
|
ā13
| āRecipient address: state
| āRECIP_ADDRESS_ STATE
| āāāThe state component of the recipient's address.
| āāUS Postal Service two-character State Codesāā
|
ā14
| āā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
|
ā15
| ā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
|
ā16
| ā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
|
ā17
| ā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
|
ā18
| āAdministered at location: state
| āADMIN_ADDRESS_ STATE
| āAddress of the physical clinic or facility that reported the vaccination.
| ān/a
|
ā19
| āAdministered at location: zip code
| āADMIN_ADDRESS_ ZIP
| āZipcode of the physical clinic or facility that reported the vaccination.
| ān/a
|
ā20
| ā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
|
ā21
| āCensus tract ā recipient address (2020)
| āCENSUS_TRACT
| ā2020 census tract based on recipient address only.
| ān/a
|
ā22
| āCensus tract ā recipient address (2010)
| āCENSUS_TRACT_10
| ā2010 census tract based on recipient address only.
| ān/a
|
ā23
| āCensus tract ā administration address
| āCENSUS_TRACT_ ADMIN_10
| ā2010 census tract based on vaccinating providerās address only.
| ān/a
|
ā24
| ā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
|
ā25
| ā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
|
ā26
| ā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
|
ā27
| āā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.
| ān/a
|
ā28
| āRecipient age at time of dose number 1 of HPV
| āAGE_AT_DOSE_1
| āRecipient's age in years at time of dose number 1 of HPV.
| ān/a
|
ā29
| āRecipient age at time of dose number 2 of HPV
| āAGE_AT_DOSE_2
| āRecipient's age in years at time of dose number 2 of HPV.
| ān/a
|
ā30
| āRecipient age at time of dose number 3 of HPV
| āAGE_AT_DOSE_3
| āRecipient's age in years at time of dose number 3 of HPV.
| ān/a
|
ā31
| āRecipient age at time of dose number 4 of HPV
| āAGE_AT_DOSE_4
| āRecipient's age in years at time of dose number 4 of HPV.
| ān/a
|
ā32
| āāAdministration date: Dose 1ā
| āADMIN_DATE_1
| āThe first recorded HPV administration date for the recipient.
| ān/a
|
ā33
| āāāAdministration date: Dose 2
| āADMIN_DATE_2
| āThe second recorded HPV administration date for the recipient.
| ān/a
|
ā34
| āāāAdministration date: Dose 3
| āADMIN_DATE_3
| āThe third recorded HPV administration date for the recipient.
| ān/a
|
ā35
| āāāAdministration date: Dose 4
| āADMIN_DATE_4
| āThe fourth recorded HPV administration date for the recipient.
| ān/a
|
ā36
| āAdministered at location: type for Dose 1
| āADMIN_TYPE_1
| āThe characteristic of the provider site that reported the vaccination, refusal, or missed appointment, for the first recorded HPV dose.
| āāLocally Defined Value Set: 1 (Commercial vaccination service provider) 2 (Corrections/detention health services) 3 (Health center ā community) 4 (Health center ā migrant or refugee) 5 (Health center ā occupational) 6 (Health center ā STD/HIV clinic) 7 (Health center ā student) 8 (Home health care provider) 9 (Hospital) 10 (Indian Health Service) 11 (Tribal health) 12 (Medical practice ā family medicine) 13 (Medical practice ā pediatrics) 14 (Medical practice ā internal medicine) 15 (Medical practice ā OB/GYN) 16 (Medical practice ā other specialty) 17 (Pharmacy ā chain) 18 (Pharmacy ā independent) 19 (Public health provider ā public health clinic) 20 (Public health provider ā Federally Qualified Health Center) 21 (Public health provider ā Rural Health Clinic) 22 (Long-term care ā nursing home, skilled nursing facility, federally certified) 23 (Long-term care ā nursing home, skilled nursing facility, non-federally certified) 24 (Long-term care ā assisted living) 25 (Long-term care ā intellectual or developmental disability) 26 (Long-term care ā combination) 27 (Urgent care) 28 (Other) UNK (Unknown)
|
ā37
| āāAdministered at location: type for Dose 2
| āADMIN_TYPE_2
| āThe characteristic of the provider site that reported the vaccination, refusal, or missed appointment, for the second recorded HPV dose.
| āSee value set for ADMIN_TYPE_1 above.
|
ā38
| āAdministered at location: type for Dose 3
| āADMIN_TYPE_3
| āThe characteristic of the provider site that reported the vaccination, refusal, or missed appointment, for the third recorded HPV dose.
| āSee value set for ADMIN_TYPE_1 above.
|
ā39
| āAdministered at location: type for Dose 4
| āADMIN_TYPE_4
| āThe characteristic of the provider site that reported the vaccination, refusal, or missed appointment, for the fourth recorded HPV dose.
| āSee value set for ADMIN_TYPE_1 above.
|
āā40
| āAdministered at location: type description for Dose 1
| āADMIN_TYPE_ DESC_1
| āThe characteristic of the provider site that reported the vaccination, refusal, or missed appointment, for the first recorded HPV dose.
| āSee value set for ADMIN_TYPE_1 above.
|
ā41
| āAdministered at location: type description for Dose 2
| āADMIN_TYPE_ DESC_2
| āThe characteristic of the provider site that reported the vaccination, refusal, or missed appointment, for the second recorded HPV dose.
| āSee value set for ADMIN_TYPE_1 above.
|
ā42
| āAdministered at location: type description for Dose 3
| āADMIN_TYPE_ DESC_3
| āThe characteristic of the provider site that reported the vaccination, refusal, or missed appointment, for the third recorded HPV dose.
| āSee value set for ADMIN_TYPE_1 above.
|
ā43
| āAdministered at location: type description for Dose 4
| āADMIN_TYPE_ DESC_4
| āThe characteristic of the provider site that reported the vaccination, refusal, or missed appointmen, for the fourth recorded HPV dose.
| āSee value set for ADMIN_TYPE_1 above.
|
ā44
| āVaccine status of recipient
| āVACCINE_STATUS
| āThe up-to-date status of the recipient based on CDC guidelines.
| āNOT UP TO DATE - recipient has not completed series UP TO DATE- Up to date if: 1st dose between 9-15 y/o, 2nd dose was more than 136 days after 1st dose 1st dose between 9-15 y/o, 2nd dose less than 137 days after first, 3rd dose more than 80 days after 2nd, (3rd dose was given before 12/16/2016 and more than 108 days after 1st dose) OR (3rd dose given after 12/15/2016 and more than 136 days after 1st dose) 1st dose between 15-27 y/o, 2nd dose more than 24 days after 1st dose, 3rd dose more than 80 days after 2nd and more than 136 days after 1st 1st dose between 15-27 y/o, 2nd dose given early (before 25 days after 1st)/3rd dose given early (before 81 days after 2nd and/or before 137 days after 1st), but 4th dose given more than 80 days after 3rd
|
ā45
| āEligible for second dose in series
| āELIGIBLE_DOSE_2
| āRecipient eligible for second dose in series
| ā1 - eligible for second dose 0 - not eligible for second dose
|
ā46
| āEligible for third dose in series
| āELIGIBLE_DOSE_3
| āRecipient eligible for third dose in series
| ā1 - eligible for third dose 0 - not eligible for third dose
|
āā47
| āRecipient has initiated series
| āINITIATED_SERIES
| āRecipient has initiated series
| ā1- recipient has initated series
|
ā48
| āāVaccine eligibility
| āVACCINE_ ELIGIBILITY
| āThe recipientās documented eligibility for the vaccine (e.g., VFC- MediCal/CHDP, VFC-Uninsured, etc.; 317; State General Fund; Private). Known data quality issues, not a required field.
| āV01 Private V02 VFC Eligible Medi-Cal/CHDP V03āÆ VFC Eligible Uninsured V04 VFC Eligible Native American/AK Native V05āÆ VFC Eligible Underinsured (FQHC/RHC Only) V07 317 Eligible LHD or HDAS Only CAA01 State General Funding
|