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

CALIFORNIA IMMUNIZATION REGISTRY

COVID-19 Vaccinations 
Data Dictionary Recipient View

Last Updated  11/02/2022

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

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

ā€‹5

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


ā€‹6

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

ā€‹7

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 

ā€‹8

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

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

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

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ā€™

ā€‹12

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)

ā€‹13

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) 

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) 

ā€‹14

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

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

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

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

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. 

ā€‹19

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

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

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

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. 

ā€‹23

Mixed zip ā€‹

ā€‹mixed_zip 

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

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. 

ā€‹
ā€‹25

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

ā€‹26

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) 


ā€‹27

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) 


ā€‹28

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. 

ā€‹29

Administered

at location: type ā€‹

ā€‹admin_type_desc 

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


Derived from value recorded for second dose, unless null, then first dose value is used. 

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

ā€‹30

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. 


Derived from value recorded for second dose, unless null, then first dose value is used. 

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)

ā€‹31

ā€‹Lot numbers 

ā€‹lot_numbers 

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

ā€‹n/a
ā€‹32

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) 

ā€‹33

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) 

ā€‹34

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

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

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

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

Snapshot time ā€‹

ā€‹snapshot_time 

ā€‹Data current as of this timestamp. 

ā€‹n/a
ā€‹39

Partially

vaccinated date ā€‹

ā€‹partially_vaccinated

_date 

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

ā€‹n/a
ā€‹40

Fully

vaccinated date ā€‹

ā€‹fully_vaccinated_date 

ā€‹Date recipient became fully vaccinated. 

ā€‹n/a
ā€‹41

Emailā€‹

ā€‹Email_Address 

ā€‹Recipientā€™s email.


Derived from value recorded for second dose, unless null, then first dose value is used.

ā€‹
ā€‹42

Phone number ā€‹

ā€‹Phone_Number 

ā€‹Recipientā€™s phone number 


Derived from value recorded for second dose, unless null, then first dose value is used. 

ā€‹
ā€‹43

Administration

date ā€“ Dose 3 ā€‹

ā€‹ds3_admin_date 

ā€‹If given, the third recorded dose administration date for the recipient. 


Ignores DOSE_NUM field in VW_ALL_IIS_LHJ for determination. 

ā€‹n/a
ā€‹44

ā€‹Administration

date ā€“ Dose 4 

ā€‹ds4_admin_date 

ā€‹If given, the fourth recorded dose administration date for the recipient. 


Ignores DOSE_NUM field in VW_ALL_IIS_LHJ for determination. 

ā€‹n/a
ā€‹45

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) 
INV (Invalid dose) 
UNK (Unknown validity) 

ā€‹46

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) 
INV (Invalid dose) 
UNK (Unknown validity) 

ā€‹47

Booster dose

flag ā€“ Pfizer  ā€‹

ā€‹Pfizer_Booster 

ā€‹Received at least 3 doses of Pfizer and 12+ years of age.


UPDATED 1/25/2022. 

Previous names:  

Is_Pfizer_3+_18+; 

Is_Pfizer_3+_12+ (1/11/2022)   

ā€‹0 (FALSE) 

1 (TRUE) 

ā€‹48

ā€‹Booster dose flag - Pfizer with minimum interval 


 Pfizer_Booster
_Interval 


Received at least 3 doses of Pfizer, with minimum interval of 136 days between 2nd and 3rd dose, and 12+ years of age. 


UPDATED 1/25/2022. 

Previous names: Is_Pfizer_3+_18+_164+;

Is_Pfizer_3+_12+_136+ 

(1/11/2022)

ā€‹0 (FALSE) 

1 (TRUE) 



ā€‹49

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


ā€‹50

ā€‹Booster dose flag ā€“ Moderna 

ā€‹Moderna_Booster 

ā€‹At least 3 doses of Moderna and 18+ years of age.


UPDATED 1/25/2022. 

Previous name: Is_Moderna_3+_18+. 

ā€‹0 (FALSE) 

1 (TRUE) 

ā€‹51

ā€‹Booster dose flag ā€“ Moderna with minimum interval 

ā€‹Moderna_Booster

_Interval 

ā€‹At least 3 doses of Moderna, with minimum interval of 136 days between 2nd and 3rd dose, and 18+ years of age.


UPDATED 1/25/2022. 

Previous name: Is_Moderna_3+_18+_164+. 

Changed minimum interval from 164 days to 136 days per updated CDC recommendations. 

0 (FALSE) 

1 (TRUE) 


ā€‹52

Booster dose flag ā€“ J&J ā€‹

ā€‹JJ_Booster 

ā€‹At least 2 doses of J&J and 18+ years of age.


UPDATED 1/25/2022. 

Previous name: Is_JJ_2+_18+. 

ā€‹0 (FALSE) 

1 (TRUE)


ā€‹53

ā€‹Booster dose flag ā€“ J&J with minimum interval 

ā€‹JJ_Booster_Interval 

ā€‹At least 2 doses of J&J, with minimum interval of 52 days between 1st and 2nd dose, and 18+ years of age.


UPDATED 1/25/2022. 

Previous name: 

Is_JJ_2+_18+_52+. 

ā€‹0 (FALSE) 

1 (TRUE)


ā€‹54

ā€‹Booster dose flag ā€“ mixed mRNA 

ā€‹Pfizer_or_Moderna

_Booster 

ā€‹At least 3 doses of Pfizer or Moderna combined and 18+ years of age.


UPDATED 1/25/2022. 

Previous name: Is_Pfizer_or_Moderna

_3+_18+. 

ā€‹0 (FALSE) 

1 (TRUE)


ā€‹55

ā€‹Booster dose flag ā€“ mixed mRNA with minimum interval 

ā€‹Pfizer_or_Moderna

_Booster_ Interval 

ā€‹At least 3 doses of Pfizer or Moderna combined, with a minimum interval of 136 days between 2nd and 3rd dose, and 18+ years of age. 


UPDATED 1/25/2022. 

Previous name: Is_Pfizer_or_Moderna

_3+_18+_164+. 

Changed minimum interval from 164 days to 136 days per updated CDC recommendations. 

ā€‹0 (FALSE) 

1 (TRUE)


ā€‹56

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


ā€‹57

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

ā€‹58

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 

ā€‹59

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


ā€‹60

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


ā€‹61

Booster eligibility flag ā€“ 2nd booster ā€‹

ā€‹IS_SECOND

_BOOSTER_ELIGIBLE 

ā€‹A vaccine recipient is considered eligible for a second booster if they meet at least one of the following criteria: 
  1. Age 50+ and received first booster of any vaccine >= 108 days ago 
  2. Age 18+ and received J&J vaccine for primary dose, and J&J vaccine for first booster >= 52 days ago 

ā€‹0 (FALSE) 

1 (TRUE) 

  

ā€‹62

ā€‹Booster dose flag ā€“ 2nd Pfizer booster with minimum interval 

ā€‹Pfizer_Booster

_2_Interval 

ā€‹At least 4 doses of Pfizer, with minimum interval of 108 days between 3rd and 4th dose, and 12+ years of age.

ā€‹0 (FALSE) 

1 (TRUE) 


ā€‹63

ā€‹Booster dose flag ā€“ 2nd Moderna booster with minimum interval 

ā€‹Moderna_Booster

_2_Interval 

ā€‹At least 4 doses of Moderna, with minimum interval of 108 days between 3rd and 4th dose, and 18+ years of age.

ā€‹0 (FALSE) 

1 (TRUE) 


ā€‹64

ā€‹Booster dose flag ā€“ 2nd booster of mixed mRNA with minimum interval 

ā€‹Pfizer_or_Moderna

_Booster_2_Interval 

ā€‹At least 4 doses of Pfizer or Moderna combined, with a minimum interval of 108 days between 3rd and 4th dose, and 12+ years of age. 

ā€‹0 (FALSE) 

1 (TRUE) 


ā€‹65

Booster dose flag ā€“ 2nd J&J booster with minimum interval ā€‹

ā€‹JJ_Booster

_2_Interval 

ā€‹At least 3 doses of J&J, with minimum interval of 108 days between 2nd and 3rd dose, and 18+ years of age. 

ā€‹0 (FALSE) 

1 (TRUE) 


ā€‹66
ā€‹Booster dose flag - bivalent
ā€‹BIVALENT_BOOSTER
ā€‹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)


ā€‹67

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

ā€‹has_additional

_dose_and_108

_ days 

ā€‹Second additional dose after completion of primary series. 


Additional dose that is 108 days after IS_ADDITIONAL_DOSE

_AND_24_DAYS flag is set for mRNA vaccine; OR 

Additional dose that is 108 days after IS_ADDITIONAL_DOSE

_AND_52_DAYS flag is set for J&J vaccine. 

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

ā€‹0 (FALSE) 

1 (TRUE) 


ā€‹68
ā€‹Census tract ā€“ recipient address (2020)
ā€‹CENSUS_TRACT
ā€‹2020 census tract based on recipient address only.
ā€‹
ā€‹69
ā€‹Census tract ā€“ recipient address (2010
ā€‹CENSUS_TRACT_10
ā€‹2010 census tract based on recipient address only.
ā€‹
70
ā€‹Census tract ā€“ administration address
ā€‹CENSUS_TRACT_ADMIN_10
ā€‹2010 census tract based on vaccinating providerā€™s address only.
ā€‹
ā€‹71
ā€‹HPI 3.0 - census tract
ā€‹HPI_3_TRACT
ā€‹Healthy Places Index 3.0 score based on the 2010 census tract from the recipientā€™s address.
ā€‹Healthy Places Index
ā€‹72
ā€‹HPI 3.0 ā€“ zip
ā€‹HPI_3_ZIP
ā€‹Healthy PIaces Index 3.0 score 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
ā€‹73
ā€‹HPI 3.0 - mixed
ā€‹HPI_3_MIXED
ā€‹HPI_3_TRACT; if null, uses HPI_3_ZIP.
ā€‹Healthy Places Index
ā€‹74
ā€‹Recipient address: concatenated
ā€‹MIXED_ADDRESS
ā€‹Concatenation of the recipient address street, city, state, and zip code.
ā€‹
ā€‹75
ā€‹Administration address: concatenated
ā€‹MIXED_ADMIN_ADDRESS
ā€‹Concatenation of the vaccinating providerā€™s address street, city, state, and zip code.
ā€‹

Notes: 

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


Page Last Updated :