Skip Navigation LinksCAIR-records-LHD-COVID-DataDictionary-RecipView

CALIFORNIA IMMUNIZATION REGISTRY

COVID-19 Vaccinations 
Data Dictionary Recipient View

Last Updated  9/14ā€‹/2023

PDF

ā€‹ā€‹LHJ Data Source in IRIS 

View Name: VW_ALL_ IIS_RECIPIENTS_LHJ 

View Description: This is a recipient level view that contains one row per vaccine recipient and is used by the California Department of Public Health (CDPH) vaccine data team for calculations that involve measures of people (e.g., partially/fully vaccinated, race/ethnicity). The data include COVID-19 vaccine doses reported to the California Immunization Registry (CAIR2) and the Healthy Futures Registry (the San Diego Immunization Registry was integrated into CAIR2 in April 2022). Doses administered by the following federal agencies and reported directly to the CDC are not included: Veterans Health Administration, Department of Defense, the Federal Bureau of Prisons, and some Indian Health Service clinics. 

Field Definitions

ā€‹Field No.
ā€‹COVID-19 Data Element
ā€‹ā€‹Variable Name
ā€‹Data Element Description
ā€‹ā€‹Value Set
ā€‹1

ā€‹Recipient ID 

ā€‹recip_id

ā€‹Unique ID for this recipient. This can be the ID used by your system or a randomly assigned unique identifier. However, the ID must be consistent across reports to allow linking doses to the same recipient ID. 

ā€‹n/a 

ā€‹2

ā€‹Administration

date ā€“ Dose 1 

ā€‹ds1_admin_date 

ā€‹The first recorded dose administration date for the recipient. 

Ignores DOSE_NUM field in VW_ALL_IIS_LHJ for determination. 

ā€‹n/a 

ā€‹3

ā€‹Administration

date ā€“ Dose 2 

ā€‹ds2_admin_date 

ā€‹The second recorded dose administration date for the recipient. 


Ignores DOSE_NUM field in VW_ALL_IIS_LHJ for determination. 

ā€‹n/a 

ā€‹4
ā€‹Administration date ā€“ Dose 3
ā€‹ds3_admin_date
ā€‹The third recorded dose administration date for the recipient. 

Ignores DOSE_NUM field in VW_ALL_IIS_LHJ for determination.
ā€‹n/a
ā€‹5
ā€‹Administration date ā€“ Dose 4
ā€‹ds4_admin_date
The fourth recorded dose administration date for the recipient. 

Ignores DOSE_NUM field in VW_ALL_IIS_LHJ for determination.
ā€‹n/a
ā€‹6
ā€‹Administration date ā€“ Dose 5
ā€‹ds5_admin_date
ā€‹The fifth recorded dose administration date for the recipient. 

Ignores DOSE_NUM field in VW_ALL_IIS_LHJ for determination.
ā€‹n/a
ā€‹7
ā€‹Administration date ā€“ Dose 6
ā€‹ds6_admin_date
ā€‹The sixth recorded dose administration date for the recipient. 

Ignores DOSE_NUM field in VW_ALL_IIS_LHJ for determination.
ā€‹n/a
ā€‹8

ā€‹Vaccine types

received 

ā€‹vax_received 

ā€‹The manufacturer name (s) of all vaccines received, for up to 4 doses.

Locally Defined Value Set:  
Moderna 
Pfizer 
J&J 

ā€‹9

ā€‹Vaccination

status 

ā€‹fully_vaccinated 

ā€‹Recipientā€™s vaccination status.

A vaccine recipient is considered fully vaccinated if they meet at least one of the following criteria: 

1) They received one dose of J&J 

2) They received two 

Pfizer doses  >= 17 days apart 

3) They received two Moderna doses >= 24 days apart 

4) They received a combination of Pfizer/Moderna doses

>= 17 days apart. 


The following criteria were removed on 2/22/2022: 

- Three or more vaccination records 

- Only dose in IRIS is labeled as dose number 2 

ā€‹Locally Defined Value Set: 
FALSE (Partially vaccinated) 
TRUE (Fully vaccinated) 


ā€‹10

ā€‹Recipient

name: first 

ā€‹recip_first_name 

Recipientā€™s first name. UPDATED 9/7/2022. Derived from value recorded for most recent dose. Previously derived from second dose value

ā€‹n/a 

ā€‹11

Recipient

name: middle ā€‹

ā€‹recip_middle

_name 

Recipientā€™s middle name. UPDATED 9/7/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.

ā€‹n/a 

ā€‹12

Recipient

name: last ā€‹

ā€‹recip_last_name 

Recipientā€™s last name. UPDATED 9/7/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.
ā€‹n/a
ā€‹13

Recipient

date of birth ā€‹

ā€‹recip_dob 

Recipientā€™s date of birth. UPDATED 9/7/2022. Derived from value recorded for most recent dose. Previously derived from second dose value. ā€‹n/a
ā€‹14

Recipient age ā€‹

ā€‹recip_age 

Recipientā€™s age in years. UPDATED 9/7/2022. Derived from value recorded for most recent dose. Previously derived from second dose value ā€‹n/a
ā€‹15

Recipient

age group ā€‹

ā€‹recip_age_group 

Recipientā€™s age group, in years. UPDATED 9/7/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.

ā€‹Locally Defined Value Set: 

Under 5 

5-11 

12-17 

18-49 

50-64 

65+ 

Unknown* 

 

Birthdates within 60 days of the vaccination date are categorized as ā€˜Unknownā€™

ā€‹16

Recipient sex ā€‹

ā€‹recip_sex 

Recipient sex. UPDATED 9/7/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.

ā€‹HL7 User Defined Table 0001  
M (Male) 
F (Female) 
U (Unknown/
undifferentiated)

ā€‹17

Recipient race/ethnicity   ā€‹

ā€‹recip_race_eth 

Recipientā€™s race/ethnicity. UPDATED 9/7/2022. Derived from value recorded for most recent dose. Previously derived from second dose value

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

POL (Unable to report due to policy/law) 

ā€‹18

Recipient

address: street ā€‹

ā€‹recip_address_street 

ā€‹The street component of the recipient's address.

 

UPDATED 4/5/2022. Derived from value recorded for most recent dose. Previously derived from second dose value. 

ā€‹n/a
ā€‹19

Recipient

address:  street 2 ā€‹

ā€‹recip_address

_street_2 

ā€‹The street 2 component of the recipient's address.


UPDATED 4/5/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.

Previous name: recip_recip_address
_street_2.

ā€‹n/a
ā€‹20

Recipient

address: city ā€‹

ā€‹recip_address_city 

ā€‹The city component of the recipient's address.


UPDATED 4/5/2022. 

Derived from value recorded for most recent dose. Previously derived from second dose value.

ā€‹n/a
ā€‹21

Recipient

address:

zip code ā€‹

ā€‹recip_address_zip 

ā€‹The zip code of the recipient's address (5 digit or 10 digits, with hyphen, are acceptable).


UPDATED 4/5/2022. 

Derived from value recorded for most recent dose. Previously derived from second dose value. 

ā€‹n/a
ā€‹22

Recipient

county name ā€‹

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


UPDATED 4/5/2022. Derived from value recorded for most recent dose. Previously derived from second dose value. 

ā€‹Derived from FIPs based on County_Code. When recip_address_county is null, derived from recip_address_zip. 

See Recip_Address_

County_New. 

ā€‹23

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.)


UPDATED 4/5/2022. 

Derived from value recorded for most recent dose. Previously derived from second dose value.

ā€‹n/a
ā€‹24

ā€‹Administered

at location 

ā€‹admin_name 

ā€‹The name of the physical clinic or facility that reported the vaccination, refusal, or missed appointment. In a small practice setting, this could be the same as the responsible organization. 


UPDATED 4/5/2022. 

Derived from value recorded for most recent dose. Previously derived from second dose value. 

ā€‹n/a
ā€‹25

Administration

address:  
zip code ā€‹

ā€‹admin_address_zip 

ā€‹The zip code component of where the vaccine is being administered/ planned to be administered. Exception for mobile clinics.


UPDATED 4/5/2022. 

Derived from value recorded for most recent dose. Previously derived from second dose value. 

ā€‹n/a
ā€‹26

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.


UPDATED 4/5/2022. 

Derived from value recorded for most recent dose. Previously derived from second dose value. 

ā€‹Join with FIPS table based on County_Code to get the name/desc. 

ā€‹27

Mixed zip ā€‹

ā€‹mixed_zip 

UPDATED 7/26/2022. Derived from value recorded for most recent dose. Previously derived from second dose value ā€‹
ā€‹28

Mixed county ā€‹

ā€‹mixed_county 

If recip_address_county_new is NULL or unknown, populate this with admin_county_label.

UPDATED 7/26/2022. Derived from value recorded for most recent dose. Previously derived from second dose value

ā€˜Outside Californiaā€™ category includes out-of-state residents and records where recipientā€™s state of residence is blank. 


UPDATED 4/5/2022. Derived from value recorded for most recent dose. Previously derived from second dose value. 

ā€‹
ā€‹29

ā€‹Local health jurisdiction 

ā€‹LHJ 

ā€‹Local health jurisdiction of recipientā€™s residence; if zip code (mixed_zip) is in Berkeley, Long Beach, or Pasadena cities, LHJ = Berkeley, Long Beach and Pasadena, respectively, otherwise LHJ = mixed_county.

UPDATED 7/26/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.

ā€˜Outside Californiaā€™ category includes out-of-state residents and records where recipientā€™s state of residence is blank.



ā€‹when mixed_zip in

(ā€˜94701,ā€™ ā€˜94702,ā€™ ā€˜94703,ā€™ ā€˜94704,ā€™ ā€˜94705,ā€™ ā€˜94707,ā€™ ā€˜94708,ā€™ ā€˜94709,ā€™ ā€˜94710,ā€™ ā€˜94712,ā€™ ā€˜94720') then ā€˜Berkeleyā€™  ā€‹when mixed_zip in 


(ā€˜90801,ā€™ ā€˜90802,ā€™ ā€˜90803,ā€™ ā€˜90804,ā€™ ā€˜90805,ā€™ ā€˜90806,ā€™ ā€˜90807,ā€™ ā€˜90808,ā€™ ā€˜90809,ā€™ ā€˜90810,ā€™ ā€˜90813,ā€™ ā€˜90814,ā€™ ā€˜90815,ā€™ ā€˜90822,ā€™ ā€˜90831,ā€™ ā€˜90832',  

ā€Æwhen mixed_zip in 

(ā€˜90833,ā€™ ā€˜90834,ā€™ ā€˜90835,ā€™ ā€˜90840,ā€™ ā€˜90842,ā€™ ā€˜90844,ā€™ ā€˜90845,ā€™ ā€˜90846,ā€™ ā€˜90847,ā€™ ā€˜90848,ā€™ ā€˜90853,ā€™ ā€˜90888,ā€™ ā€˜90899') then ā€˜Long Beachā€™ 

when left(mixed_zip,5) 

in (ā€˜91101,ā€™ ā€˜91102',  ā€˜91103,ā€™ ā€˜91104,ā€™ ā€˜91105,ā€™ ā€˜91106,ā€™ ā€˜91107,ā€™ ā€˜91109,ā€™ ā€˜91110,ā€™ ā€˜91114,ā€™ ā€˜91115,ā€™ ā€˜91116,ā€™ ā€˜91117,ā€™ ā€˜91121,ā€™ ā€˜91123,ā€™ ā€˜91124,ā€™ ā€˜91125,ā€™ ā€˜91126,ā€™ ā€˜91129,ā€™ ā€˜91131,ā€™ ā€˜91182,ā€™ ā€˜91184,ā€™ ā€˜91185,ā€™ ā€˜91188,ā€™ ā€˜91189,ā€™ ā€˜91191,ā€™ ā€˜91199') then ā€˜Pasadenaā€™ ā€‹

ELSE mixed_county 
ā€‹30

VEM quartile  ā€‹

ā€‹hpiquartile 

ā€‹Vaccine Equity Metric (VEM) score quartiles based on mixed_zip.

 

Vaccine Equity Metric (VEM) score quartiles combine the Public Health Alliance of Southern Californiaā€™s Healthy Places Index (HPI) measure with CDPH-derived scores to estimate factors that impact health, like income, education, and access to health care. Zip codes range from less healthy community conditions in Quartile 1 to more healthy community conditions in Quartile 4. 


UPDATED 7/26/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.

ā€‹Locally Defined Value Set:  

1 (VEM Quartile 1) 

2 (VEM Quartile 2) 

3 (VEM Quartile 3) 

4 (VEM Quartile 4) 

Null (no VEM score assigned) 


31

VEM quartile

based on

recipient

zip code ā€‹

ā€‹hpiquartile_rcp_zip 

ā€‹Vaccine Equity Metric (VEM) score quartiles based on recipient zip code.

 

Vaccine Equity Metric (VEM) score quartiles combine the Public Health Alliance of Southern Californiaā€™s Healthy Places Index (HPI) measure with CDPH-derived scores to estimate factors that impact health, like income, education, and access to health care. Zip codes range from less healthy community conditions in Quartile 1 to more healthy community conditions in Quartile 4.


UPDATED 7/26/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.

ā€‹Locally Defined Value Set:  

1 (VEM Quartile 1) 

2 (VEM Quartile 2) 

3 (VEM Quartile 3) 

4 (VEM Quartile 4) 

Null (no VEM score assigned) 


ā€‹32

Recipient

address:

county based

on zip code ā€‹

ā€‹hpi_county_rcp_zip 

ā€‹The county name of the recipientā€™s address, derived from the zip code of the recipientā€™s address. 


UPDATED 7/26/2022. Derived from value recorded for most recent dose. Previously derived from second dose value. 

ā€‹County derived from recip_address_zip. 

ā€‹33

Administered

at location: type ā€‹

ā€‹admin_type_desc 

ā€‹The characteristic of the provider site that reported the vaccination, refusal, or missed appointment.


UPDATED 4/5/2023. Derived from value recorded for most recent dose. Previously derived from second dose value.

ā€‹Labels from 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)

ā€‹34

MCEā€‹

ā€‹MCE

ā€‹Provider affiliated with state agency multi-county entity, health system multi-county entity, or pharmacy entity participating in CDC Long Term Care or Retail Pharmacy Partnership programs. 


ā€‹UPDATED 4/5/2023. Derived from value recorded for most recent dose. Previously derived from second dose value. 

Locally Defined Value Set: 

CDCR (State Agency MCE - California Department of Corrections and Rehabilitation) 

DHS (State Agency MCE - Department of State Hospitals) 

AHMC Healthcare (Health System MCE) 

Dignity Health (Health System MCE) 

Kaiser Permanente (Health System MCE) 

Providence (Health System MCE) 

Sutter Health (Health System MCE) 

UC Health (Health System MCE) 

CVS (Pharmacy) 

Rite Aid (Pharmacy) 

Walgreens (Pharmacy) 

Albertson Companies, Inc. (Pharmacy) 

Costco (Pharmacy) 

Kroger (Pharmacy) 

Walmart (Pharmacy) 

Topco (Pharmacy) 

Good Neighbor (Pharmacy) 

Health Mart (Pharmacy) 

CPESN (Pharmacy) 

Cardinal (Pharmacy) 

GeriMed (Pharmacy) 

MHA (Pharmacy) 

Premier-Innovatix (Pharmacy)

ā€‹35

ā€‹Lot numbers 

ā€‹lot_numbers 

ā€‹The lot numbers for all COVID vaccinations administered, concatenated. 

ā€‹n/a
ā€‹36

Original dose

number ā€“ Dose 1  ā€‹

ā€‹ds1_orig_dose_num 

ā€‹Original reported dose number in vaccination series for first dose. 

ā€‹Locally Defined Value Set: 
1 (Valid first dose) 
2 (Valid second dose) 
INV (Invalid dose) 
UNK (Unknown validity) 

ā€‹37

Original dose

number ā€“ Dose 2 ā€‹

ā€‹ds2_orig_dose_num 

ā€‹Original reported dose number in vaccination series for second dose. 

ā€‹Locally Defined Value Set: 
1 (Valid first dose) 
2 (Valid second dose) 
INV (Invalid dose) 
UNK (Unknown validity) 

ā€‹38
ā€‹Original dose number ā€“ Dose 3
ā€‹ds3_orig_dose_num
ā€‹Original reported dose number in vaccination series for third dose.
ā€‹Locally Defined Value Set:
1 (Valid first dose)
2 (Valid second dose)
3 (Valid third dose)
INV (Invalid dose)
UNK (Unknown validity)



ā€‹39
ā€‹Original dose number ā€“ Dose 4
ā€‹ds4_orig_dose_num
ā€‹Original reported dose number in vaccination series for fourth dose.
ā€‹Locally Defined Value Set:
1 (Valid first dose)
2 (Valid second dose)
3 (Valid third dose)
INV (Invalid dose)
UNK (Unknown validity)
ā€‹40
ā€‹Original dose number ā€“ Dose 5
ā€‹ds5_orig_dose_num
ā€‹Original reported dose number in vaccination series for fifth dose.
ā€‹Locally Defined Value Set:
1 (Valid first dose)
2 (Valid second dose)
3 (Valid third dose)
INV (Invalid dose)
UNK (Unknown validity)
ā€‹41
ā€‹Original dose number ā€“ Dose 6
ā€‹ds6_orig_dose_num
ā€‹Original reported dose number in vaccination series for sixth dose.
ā€‹Locally Defined Value Set:
1 (Valid first dose)
2 (Valid second dose)
3 (Valid third dose)
INV (Invalid dose)
UNK (Unknown validity)
ā€‹42

Dose 1

vaccination

event ID  ā€‹

ā€‹ds1_vax_event_id 

ā€‹The vaccination eventā€™s unique identifier within the system for first reported dose (based on vaccination date). 

ā€‹n/a
ā€‹43

ā€‹Dose 2

vaccination

event ID 

ā€‹ds2_vax_event_id 

ā€‹The vaccination eventā€™s unique identifier within the system for second reported dose (based on vaccination date). 

ā€‹n/a
ā€‹44

Dose 3

vaccination

event ID ā€‹

ā€‹ds3_vax_event_id 

ā€‹The vaccination eventā€™s unique identifier within the system for third reported dose (based on vaccination date). 

ā€‹n/a
ā€‹45

ā€‹Dose 4

vaccination

event ID 

ā€‹ds4_vax_event_id 

ā€‹The vaccination eventā€™s unique identifier within the system for fourth reported dose (based on vaccination date). 

ā€‹n/a
ā€‹46
ā€‹Dose 5 vaccination event ID
ā€‹ds5_vax_event_id
ā€‹The vaccination eventā€™s unique identifier within the system for fifth reported dose (based on vaccination date).
ā€‹n/a
ā€‹47
ā€‹Dose 6 vaccination event ID
ā€‹ds6_vax_event_id
ā€‹The vaccination eventā€™s unique identifier within the system for sixth reported dose (based on vaccination date).
ā€‹n/a
ā€‹48

Snapshot time ā€‹

ā€‹snapshot_time 

ā€‹Data current as of this timestamp. 

ā€‹n/a
ā€‹49

Partially

vaccinated date ā€‹

ā€‹partially_vaccinated

_date 

ā€‹Date recipient became partially vaccinated (i.e., received first dose of Pfizer or Moderna).

ā€‹n/a
ā€‹50

Fully

vaccinated date ā€‹

ā€‹fully_vaccinated_date 

ā€‹Date recipient became fully vaccinated. 

ā€‹n/a
ā€‹51

Emailā€‹

ā€‹Email_Address 

ā€‹Recipientā€™s email.


UPDATED 4/5/2023. Derived from value recorded for most recent dose. Previously derived from seā€‹cond dose value.

ā€‹
ā€‹52

Phone number ā€‹

ā€‹Phone_Number 

ā€‹Recipientā€™s phone number 


UPDATED 4/5/2023. Derived from value recorded for most recent dose. Previously derived from second dose value.

ā€‹



53
Additional dose flag
HAS_ADDITIONAL_DOSE
_AND_24_DAYS
Received additional dose administered at least 24 days after series completion (Pfizer recipients 5+ years of age, Moderna and J&J recipients 18+ years of age).

Includes any dose that was administered at least 24 days after series completion (2 mRNA or 1 J&J). Includes both additional doses and booster doses.

UPDATED 8/24/2022. Derived from value recorded for most recent dose. Previously derived from second dose value



0 (FALSE)
1 (TRUE)















54

ā€‹Additional dose flag ā€“ 52 day interval 

ā€‹HAS_ADDITIONAL

_DOSE_AND_52_DAYS 

ā€‹Additional dose administered at least 52 days after series completion.

UPDATED 8/24/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.

ā€‹0 (FALSE) 

1 (TRUE)


ā€‹55

ā€‹Recipient address: state 

ā€‹RECIP_ADDRESS

_STATE 

ā€‹The state component of the recipientā€™s address.


UPDATED 4/5/2022. 

Derived from value recorded for most recent dose. Previously derived from second dose value. 

ā€‹US Postal Service two-character state codes 

ā€‹56

Administration address: state ā€‹

ā€‹ADMIN_ADDRESS

_STATE 

ā€‹The state component of where the vaccine is administered/ planned to be administered. Exception for mobile clinics. 


UPDATED 4/5/2022. 

Derived from value recorded for most recent dose. Previously derived from second dose value. 

ā€‹US Postal Service two-character state codes 

ā€‹57

ā€‹Patient sharing indicator 

ā€‹LOCKED_IND 

ā€‹Patient sharing status.


If 1, patient has requested that their record not be shared with organizations other than their own provider or public health. 

ā€‹0 (FALSE) 

1 (TRUE) 


ā€‹58

ā€‹Booster eligibility flag 

ā€‹IS_BOOSTER

_ELIGIBLE 

A vaccine recipient is considered eligible for a booster if they meet at least one of the following criteria:
Monovalent Booster Eligibility
Age 5ā€“11 (Suppress on/after 10/13/2022): 3rd dose (original booster) - Pfizer Monovalent Booster at least 136 days after 2nd dose (Pfizer Pediatric)

Age 12+ (Suppress on/after 09/06/2022): 3rd dose (original booster) - Pfizer Monovalent Booster at least 136 days after 2nd dose (Pfizer/Moderna/Novavax)

Age 18+ (Suppress on/after 09/06/2022):  3rd dose (original booster) - Moderna Monovalent Booster at
least 136 days after 2nd dose (Pfizer/Moderna/Novavax) 

Age 18+ (Suppress on/after 09/06/2022): 2nd dose (original booster) - J&J at least 52 days after 1st dose (J&J) 

Bivalent Booster Eligibility

Age 6 monthsā€“5: 3rd dose ā€“ Moderna pediatric bivalent booster at least 52 days after 2nd dose (Moderna Under 6)

Age 5+: 3rd dose (updated booster) - Pfizer pediatric bivalent booster at least 52 days after 2nd dose (Pfizer Pediatric/Moderna Under 6)
 
Age group 6ā€“11: 3rd dose (updated booster) - Pfizer Pediatric/Moderna bivalent booster at least 52 days after 2nd dose (Pfizer Pediatric/Moderna) 

Age 12+: 3rd dose (updated booster) - Pfizer/Moderna bivalent booster at least 52 days after 2nd dose (Pfizer/Moderna/Novavax) or last monovalent booster (Pfizer/Moderna)

Age 18+: 2nd dose (updated booster) - Pfizer/Moderna bivalent booster at least 52 days after 1st dose (J&J) or last monovalent booster (Pfizer/Moderna)



ā€‹0 (FALSE) 

1 (TRUE) 







ā€‹59
ā€‹Booster dose flag - bivalent
ā€‹BIVALENT_BOOSTER
Age 6 monthsā€“5: 3rd dose ā€“ Moderna pediatric bivalent booster at least 52 days after 2nd dose (Moderna Under 6

ā€‹Age 5+: 3rd dose (updated booster) - Pfizer pediatric bivalent booster at least 52 days after 2nd dose (Pfizer Pediatric/Moderna Under 6)
 
Age group 6ā€“11: 3rd dose (updated booster) - Pfizer Pediatric/Moderna bivalent booster at least 52 days after 2nd dose (Pfizer Pediatric/Moderna) 

Age 12+: 3rd dose (updated booster) - Pfizer/Moderna bivalent booster at least 52 days after 2nd dose (Pfizer/Moderna/Novavax) or last monovalent booster (Pfizer/Moderna)

Age 18+: 2nd dose (updated booster) - Pfizer/Moderna bivalent booster at least 52 days after 1st dose (J&J) or last monovalent booster (Pfizer/Moderna)



ā€‹

0 (FALSE)

1 (TRUE)




ā€‹60
ā€‹Census tract ā€“ recipient address (2020)
ā€‹CENSUS_TRACT
ā€‹2020 census tract based on recipient address only.
ā€‹
61
ā€‹Census tract ā€“ recipient address (2010
ā€‹CENSUS_TRACT_10
ā€‹2010 census tract based on recipient address only.
ā€‹
62
ā€‹Census tract ā€“ administration address
ā€‹CENSUS_TRACT
_ADMIN_10
ā€‹2010 census tract based on vaccinating providerā€™s address only.
ā€‹
ā€‹63
ā€‹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) 
ā€‹64
ā€‹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)

ā€‹65
ā€‹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)
ā€‹66
ā€‹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.
ā€‹
67
ā€‹Recipient address: concatenated
ā€‹MIXED_ADDRESS
ā€‹Concatenation of the recipient address street, city, state, and zip code.
ā€‹
68
ā€‹Administration address: concatenated
ā€‹MIXED_ADMIN
_ADDRESS
ā€‹Concatenation of the vaccinating providerā€™s address street, city, state, and zip code.
ā€‹

ā€‹69

ā€‹Up to date status

ā€‹VACCINE_STATUS

ā€‹A vaccine recipient is considered up to date with COVID-19 vaccines if they meet at least one of the following criteria based on CDC recommended products, ages, and minimum intervals between doses: 
 
Age 6+: 1 updated (bivalent) Pfizer or Moderna vaccine. 
 
Age 6 monthsā€“5: 2 or 3 doses of COVID vaccine, including at least 1 dose of updated (bivalent) Pfizer or Moderna vaccine, as recommended based on previous doses and age. 
 
UPDATED 5/17/2023
ā€‹Locally Defined Value Set:  
Not_Up_to_Date 
Up_to_Date 


ā€‹70
ā€‹Bivalent booster date
ā€‹BIVALENT_BOOSTER_DATE
ā€‹Date recipient received bivalent booster dose.ā€‹
ā€‹

Notes: 

Minimum intervals are based on CDC recommendations, using 28-day months and including a 4-day grace period.

Page Last Updated :