Skip Navigation LinksVaricella-DataDictionaryRecipView

california immunization registry

Varicella Vaccinations                                CAIR Logo

Data Dictiā€‹ā€‹onary ā€“ Recipient Level View   

ā€‹Excelā€‹

Last Updated 5/3 /2024

Dataset Name: VW_VARICELLA_RECIP_LHJ

Dataset Description: This is a recipient level view that contains all varicella vaccine 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

ā€‹Administration date: dose 1ā€‹

ā€‹ADMIN_DATE_DOSE1

ā€‹Vaccine administration date for first dose of varicella vaccine (CVX code = 21, 94).ā€‹

ā€‹n/a
ā€‹2

ā€‹Administration date: dose 2ā€‹

ā€‹ADMIN_DATE_DOSE2

ā€‹Vaccine administration date for second dose of varicella vaccine (CVX code = 21, 94).ā€‹

ā€‹n/a
ā€‹3
ā€‹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
ā€‹4
ā€‹Recipient age
ā€‹AGE_FIRST_VZV
ā€‹Recipient's age in years when first dose of varicella vaccine was received.
ā€‹n/a
ā€‹5
ā€‹Array - vaccine administration dates
ā€‹ARR_ADMIN_DATE
ā€‹Array showing dates that all varicella vaccine doses were administered to recipient.
ā€‹n/a
ā€‹6
ā€‹Array - age at receipt of vaccination
ā€‹ARR_AGE
ā€‹Array showing recipient's age in years when each varicella vaccine dose was administered.
ā€‹n/a
ā€‹7
ā€‹Array - CVX codes
ā€‹ARR_CVX
ā€‹Array showing CVX codes for all varicella vaccine doses administered to recipient
ā€‹n/a
ā€‹8
ā€‹Census tract - recipient address (2020)
ā€‹CENSUS_TRACT
ā€‹2020 census tract based on recipient address only.
ā€‹
ā€‹9
ā€‹Census tract - recipient address (2010)
ā€‹CENSUS_TRACT_10
ā€‹2010 census tract based on recipient address only.ā€‹ā€‹
ā€‹
ā€‹10
ā€‹Census tract - administration address
ā€‹CENSUS_TRACT_ADMIN_10
ā€‹2010 census tract based on vaccinating provider's address only.
ā€‹
ā€‹11
ā€‹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) 



ā€‹12
ā€‹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. ā€‹
ā€‹
ā€‹13
ā€‹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)



ā€‹14
ā€‹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
ā€‹
ā€‹15
ā€‹1 VZV by age 2
ā€‹ONEVZVBY2YO
ā€‹Received one dose of varicella vaccine (CVX code = 21, 94) by age 2. 
16Based on Childhood Immunization Status (CIS) measure.
ā€‹
0 (No)
1 (Yes)

ā€‹ā€‹ā€‹

ā€‹16
ā€‹Recipient address: city
ā€‹RECIP_ADDRESS_CITY
ā€‹The city component of the recipient's address.
ā€‹n/a
ā€‹17
ā€‹Recipient address: state
ā€‹RECIP_ADDRESS_STATE
ā€‹The state component of the recipient's address.
ā€‹n/a
ā€‹18
ā€‹Recipient address: street
ā€‹RECIP_ADDRESS_STREET
ā€‹The street component of the recipient's address.
ā€‹n/a
ā€‹19
ā€‹Recipient address: street 2
ā€‹RECIP_ADDRESS_STREET_2
ā€‹The street 2 component of the recipient's address.
ā€‹n/a
ā€‹20
ā€‹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
ā€‹21
ā€‹Recipient age
ā€‹RECIP_AGE
ā€‹Recipientā€™s age in years as of current date.
ā€‹n/a
ā€‹22
ā€‹Recipient address: county
ā€‹RECIP_COUNTY_LABEL
ā€‹The county name component of the recipient's address. 
ā€˜Outside Californiaā€™ category includes out-of-state residents and records where recipientā€™s state of residence is blank.



ā€‹Derived from FIPs based on County_Code. When recip_address_county is null, derived from recip_address_zip. 
ā€‹23
ā€‹Recipient date of birth
ā€‹RECIP_DOB
ā€‹Recipient's date of birth.
ā€‹n/a
ā€‹24
ā€‹Recipient name: first
ā€‹RECIP_FIRST_NAME
ā€‹Recipient's first name.
ā€‹n/a
ā€‹25
ā€‹Recipient ID
ā€‹RECIP_ID
ā€‹Unique ID for this recipient.ā€‹
ā€‹n/a
ā€‹26
ā€‹Recipient name: last
ā€‹RECIP_LAST_NAME
ā€‹Recipient's last name.
ā€‹n/a
ā€‹27
ā€‹Recipient name: middle
ā€‹RECIP_MIDDLE_NAME
ā€‹Recipient's middle name.
ā€‹n/a
ā€‹28
ā€‹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)
29PHC1175 (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)



ā€‹

ā€‹29
ā€‹Recipient sex
ā€‹RECIP_SEX
ā€‹Recipient sex.
ā€‹
HL7 User Defined Table 0001 
M (Male)
F (Female)
U (Unknown/undifferentiated)

ā€‹

ā€‹30
ā€‹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
ā€‹31
ā€‹CVX - dose 1
ā€‹VACCINE_PRODUCT_1_CVX
ā€‹The vaccine type that was administered for the first dose of varicella vaccine.
ā€‹CVX Codes - Vaccines Administered
ā€‹32
ā€‹CVX - dose 2
ā€‹VACCINE_PRODUCT_2_CVX
ā€‹The vaccine type that was administered for the second dose of varicella vaccine.
ā€‹CVX Codes - Vaccines Administered
ā€‹33
ā€‹Varicella series completed 
ā€‹VZV_SERIES_COMPLETE_CHILD
ā€‹Received first dose of varicella vaccine (CVX code = 21, 94) at age 12-15 months, and second dose at age 4-6 years. Based on CDC ā€‹
recommendations for routine childhood vaccination. 
ā€‹
0 (No)
1 (Yes)

ā€‹


Page Last Updated :