Skip Navigation LinksHepB-DataDictionaryRecipView

california immunization registry

Hepatitis B ā€‹Vaccinations                           CAIR2 Logo  
Data Dictionary ā€“ Recipient Level View

Excel

ā€‹Last Updated 2/8 /2024

Dataset Name: VW_HEP_B_RECIP_LHJ

Dataset Description: This is a recipient level view that contains all hepatitis B vaccine dose recipients reported to the California Immunization Registry (CAIR2), including records received from the Healthy Futures Registry (also known as the Regional Immunization Data Exchange or RIDE) via data exchange. RIDE data was incorporated into CAIR November 2022.  The San Diego Immunization Registry was integrated into CAIR2 in April 2022.  

Field Definitions

ā€‹Field No.
ā€‹Data Element
ā€‹Variable Name
ā€‹Data Element Description
ā€‹Value Setā€‹ā€‹ā€‹
ā€‹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)

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 (most recent)
ā€‹ADMIN_DATE_1
ā€‹Most recent (up to four) Hep B vaccine administration dates. ADMIN_DATE_1 = most recent Hep B vaccine administration date.ā€‹
ā€‹n/a
ā€‹6
ā€‹Administration date: dose 2
ā€‹ADMIN_DATE_2
ā€‹Most recent (up to four) Hep B vaccine administration dates. ADMIN_DATE_1 = most recent Hep B vaccine administration date.
ā€‹n/a
ā€‹7
ā€‹Administration date: dose 3
ā€‹ADMIN_DATE_3
ā€‹Most recent (up to four) Hep B vaccine administration dates. ADMIN_DATE_1 = most recent Hep B vaccine administration date.
ā€‹n/a
ā€‹8
ā€‹Administration date: dose 4
ā€‹ADMIN_DATE_4
ā€‹Most recent (up to four) Hep B vaccine administration dates. ADMIN_DATE_1 = most recent Hep B vaccine administration date.
ā€‹n/a
ā€‹9
ā€‹Vaccine product - dose 1
ā€‹VACCINE_PRODUCT_1
ā€‹The manufacturer name of vaccine received for the most recent (up to four) Hep B vaccinations. Vaccine_Product_1 = most recent Hep B vaccination givenā€‹
ā€‹n/a
ā€‹10
ā€‹Vaccine product - dose 2
ā€‹VACCINE_PRODUCT_2
ā€‹The manufacturer name of vaccine received for the most recent (up to four) Hep B vaccinations. Vaccine_Product_1 = most recent Hep B vaccination given.
ā€‹n/a
ā€‹11
ā€‹Vaccine product - dose 3
ā€‹VACCINE_PRODUCT_3
ā€‹The manufacturer name of vaccine received for the most recent (up to four) Hep B vaccinations. Vaccine_Product_1 = most recent Hep B vaccination given.
ā€‹n/a
ā€‹12
ā€‹Vaccine product - dose 4
ā€‹VACCINE_PRODUCT_4
ā€‹The manufacturer name of vaccine received for the most recent (up to four) Hep B vaccinations. Vaccine_Product_1 = most recent Hep B vaccination given.
ā€‹n/a
ā€‹13
ā€‹CVX - dose 1
ā€‹VACCINE_PRODUCT_1_CVX
ā€‹The vaccine type that was administered for the most recent (up to four) Hep B vaccinations. Vaccine_Product_1_cvx = most recent Hep B vaccination given.

ā€‹CVX Codesā€‹

ā€‹14
ā€‹CVX - dose 2
ā€‹VACCINE_PRODUCT_2_CVX
ā€‹The vaccine type that was administered for the most recent (up to four) Hep B vaccinations. Vaccine_Product_1_cvx = most recent Hep B vaccination given.

ā€‹CVX Codesā€‹

ā€‹15
ā€‹CVX - dose 3
ā€‹VACCINE_PRODUCT_3_CVX
ā€‹The vaccine type that was administered for the most recent (up to four) Hep B vaccinations. Vaccine_Product_1_cvx = most recent Hep B vaccination given.

ā€‹CVX Codesā€‹

ā€‹16
ā€‹CVX - dose 4
ā€‹VACCINE_PRODUCT_4_CVX
ā€‹The vaccine type that was administered for the most recent (up to four) Hep B vaccinations. Vaccine_Product_1_cvx = most recent Hep B vaccination given.

ā€‹CVX Codesā€‹

ā€‹17
ā€‹Vaccine received - Birth
ā€‹VAX_BIRTH_RECEIVED
ā€‹Received Hep B vaccine at birth, as recommended by CDC.
ā€‹Yes/No
ā€‹18
ā€‹Vaccine received - within 3 days of birth
ā€‹VAX_BIRTH_3_DAYS_RECEIVED
ā€‹Received Hep B vaccine within 3 days of birth.
ā€‹Yes/Noā€‹
ā€‹19
ā€‹Vaccine 2 received - 1-2 Months of age
ā€‹VAX_2_RECEIVED_CHILDHOOD
ā€‹Received second Hep B vaccine at 1-2 months of age, as recommended by CDC.
ā€‹Yes/No
ā€‹20
ā€‹Vaccine 3 received - 6-18 Months of age
ā€‹VAX_3_RECEIVED_CHILDHOOD
ā€‹Received third Hep B dose at 6-18 months of age, as recommended by CDC.
ā€‹Yes/No
ā€‹21
ā€‹Hep B series completed per CDC childhood immunization schedule
ā€‹Hep_B_SERIES_COMPLETE_CHILDHOOD
ā€‹Three dose Hep B childhood vaccination series was completed according to CDC childhood immunization schedule 
ā€‹Yes/No
ā€‹22
ā€‹Vaccine received - time 0
ā€‹VAX_1_RECEIVED
ā€‹Received first Hep B dose
ā€‹Yes/No
ā€‹23
ā€‹Vaccine 2 received - 1-2 months after first dose
ā€‹VAX_2_RECEIVED
ā€‹Received second Hep B vaccine  1-2 months after first dose, as recommended by CDC.
ā€‹Yes/No
ā€‹24
ā€‹Vaccine 3 received - 6 months after first  dose
ā€‹VAX_3_RECEIVED
ā€‹Received third Hep B dose 6 months after first dose, as recommended by CDC.
ā€‹Yes/No
ā€‹25
ā€‹Hep B 3 dose series completed
ā€‹Hep_B_SERIES_3_COMPLETE
ā€‹Three dose Hep B vaccination series completed at 0, 1-2 months and 6 month intervalā€‹
ā€‹Yes/No
ā€‹26
ā€‹Hep B 3 dose series completed, varied interval
ā€‹Hep_B_RECEIVED_3_DOSES
ā€‹Received three doses of Hep B, vaccine interval varied
ā€‹Yes/No
ā€‹27
ā€‹Hep B 2 dose series completed 
ā€‹Hep_B_SERIES_2_COMPLETE_Recombivax
ā€‹Adolescents age 11ā€“15 years may use an alternative 2-dose schedule with at least 4 months between doses (adult formulation Recombivax HB only)
ā€‹Yes/No
ā€‹28
ā€‹Hep B 2 dose series completed 
ā€‹Hep_B_SERIES_2_COMPLETE_Heplisav
ā€‹Adolescents age 18 years or older may receive: Heplisav-B 2-dose series at least 4 weeks apart
ā€‹Yes/No
ā€‹29
ā€‹Recipient age - at first dose, months
ā€‹AGE_FIRST_Hep_B_Months
ā€‹Recipient age in months when received first Hep B vaccine.
ā€‹n/a
ā€‹30
ā€‹Recipient age - at second dose, months
ā€‹AGE_SECOND_Hep_B_Months
ā€‹Recipient age in months when received second Hep B vaccine.
ā€‹n/a
ā€‹31
ā€‹Recipient age - at third dose, months
ā€‹AGE_THIRD_Hep_B_Months
ā€‹Recipient age in months when received third Hep B vaccine.
ā€‹n/a
ā€‹32
ā€‹Recipient age - at first dose, years
ā€‹AGE_FIRST_Hep_B_Years
ā€‹Recipient age in years when received first Hep B vaccine.ā€‹
ā€‹n/a
ā€‹33
ā€‹Recipient age - at second dose, years
ā€‹AGE_SECOND_Hep_B_Years
ā€‹Recipient age in years when received second Hep B vaccine.
ā€‹n/a
ā€‹34
ā€‹Recipient age - at third dose, years
ā€‹AGE_THIRD_Hep_B_Years
ā€‹Recipient age in years when received third Hep B vaccine.
ā€‹n/a
ā€‹35
ā€‹Recipient name: first
ā€‹RECIP_FIRST_NAME
ā€‹Recipient's first name.
ā€‹n/a
ā€‹36
ā€‹Recipient name: middle
ā€‹RECIP_MIDDLE_NAME
ā€‹Recipient's middle name.
ā€‹n/a
ā€‹37
ā€‹Recipient name: last
ā€‹RECIP_LAST_NAME
ā€‹Recipient's last name.
ā€‹n/a
ā€‹38
ā€‹Recipient age
ā€‹RECIP_AGE
ā€‹Recipientā€™s age in years as of current date.
ā€‹n/a
ā€‹39
ā€‹Recipient address: street
ā€‹RECIP_ADDRESS_STREET
ā€‹The street component of the recipient's address.
ā€‹n/a
ā€‹40
ā€‹Recipient address:  street 2
ā€‹RECIP_ADDRESS_STREET_2
ā€‹The street 2 component of the recipient's address.ā€‹
ā€‹n/a
ā€‹41
ā€‹Recipient address: city
ā€‹RECIP_ADDRESS_CITY
ā€‹The city component of the recipient's address
ā€‹n/a
ā€‹42
ā€‹Recipient address: state
ā€‹RECIP_ADDRESS_STATE
ā€‹The state component of the recipient's address.
ā€‹US Postal Service two-character State Codes
ā€‹43
ā€‹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
ā€‹44
ā€‹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. 
45ā€‹ā€‹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
ā€‹46
ā€‹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. Derived from value recorded for most recent dose. 
ā€‹Join with FIPs table based on County Code to get county name.
ā€‹47
ā€‹Census tract ā€“ recipient address (2020)
ā€‹CENSUS_TRACT
ā€‹2020 census tract based on recipient address only.
ā€‹
ā€‹48
ā€‹Census tract ā€“ recipient address (2010)
ā€‹CENSUS_TRACT_10
ā€‹2010 census tract based on recipient address only.
ā€‹
ā€‹49
ā€‹Census tract ā€“ administration address
ā€‹CENSUS_TRACT_ADMIN_10
ā€‹2010 census tract based on vaccinating providerā€™s address only.
ā€‹
ā€‹50
ā€‹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
ā€‹51
ā€‹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.
ā€‹
ā€‹52
ā€‹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 



ā€‹53
ā€‹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  



ā€‹54
ā€‹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
Page Last Updated :