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)
|
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 five) flu vaccine administration dates. ADMIN_DATE_1 = most recent flu vaccine administration date.
|
n/a
|
6
|
Administration date - dose 2
|
ADMIN_DATE_2
|
Most recent (up to five) flu vaccine administration dates. ADMIN_DATE_1 = most recent flu vaccine administration date.
|
n/a
|
7
|
Administration date - dose 3
|
ADMIN_DATE_3
|
Most recent (up to five) flu vaccine administration dates. ADMIN_DATE_1 = most recent flu vaccine administration date.
|
n/a
|
8
|
Administration date - dose 4
|
ADMIN_DATE_4
|
Most recent (up to five) flu vaccine administration dates. ADMIN_DATE_1 = most recent flu vaccine administration date.
|
n/a
|
9
|
Administration date - dose 5
|
ADMIN_DATE_5
|
Most recent (up to five) flu vaccine administration dates. ADMIN_DATE_1 = most recent flu vaccine administration date.
|
n/a
|
10
|
Vaccine product - dose 1
|
VACCINE_PRODUCT_1
|
The manufacturer name of vaccine received for the most recent (up to five) flu vaccinations. Vaccine_Product_1 = most recent flu vaccination given.
|
|
11
|
Vaccine product - dose 2
|
VACCINE_PRODUCT_2
|
The manufacturer name of vaccine received for the most recent (up to five) flu vaccinations. Vaccine_Product_1 = most recent flu vaccination given.
|
|
12
|
Vaccine product - dose 3
|
VACCINE_PRODUCT_3
|
The manufacturer name of vaccine received for the most recent (up to five) flu vaccinations. Vaccine_Product_1 = most recent flu vaccination given.
|
|
13
|
Vaccine product - dose 4
|
VACCINE_PRODUCT_4
|
The manufacturer name of vaccine received for the most recent (up to five) flu vaccinations. Vaccine_Product_1 = most recent flu vaccination given.
|
|
14
|
Vaccine product - dose 5
|
VACCINE_PRODUCT_5
|
The manufacturer name of vaccine received for the most recent (up to five) flu vaccinations. Vaccine_Product_1 = most recent flu vaccination given.
|
|
15
|
CVX - dose 1
|
VACCINE_PRODUCT _1_CVX
|
The vaccine type that was administered for the most recent (up to five) flu vaccinations. Vaccine_Product_1 _cvx = most recent flu vaccination given.
|
CVX Codes
|
16
|
CVX - dose 2
|
VACCINE_PRODUCT _2_CVX
|
The vaccine type that was administered for the most recent (up to five) flu vaccinations. Vaccine_Product_1_cvx = most recent flu vaccination given.
|
CVX Codes
|
17
|
CVX - dose 3
|
VACCINE_PRODUCT _3_CVX
|
The vaccine type that was administered for the most recent (up to five) flu vaccinations. Vaccine_Product_1_cvx = most recent flu vaccination given.
|
CVX Codes
|
18
|
CVX - dose 4
|
VACCINE_PRODUCT _4_CVX
|
The vaccine type that was administered for the most recent (up to five) flu vaccinations. Vaccine_Product_1_cvx = most recent flu vaccination given.
|
CVX Codes
|
19
|
CVX - dose 5
|
VACCINE_PRODUCT _5_CVX
|
The vaccine type that was administered for the most recent (up to five) flu vaccinations. Vaccine_Product_1_cvx = most recent flu vaccination given.
|
CVX Codes
|
20
|
Vaccine received - 2018-2019 flu season (MMWR)
|
VAX_RECEIVED_18 _19_MMWR
|
Received flu vaccine during 2018-2019 flu season, based on CDC MMWR weeks.
|
Yes/No Yes if flu vaccine administered during 09/30/2018-9/28/2019, and age >=9; if age < 9, child must have received either two doses >= 4 weeks apart during this time period or have received two flu vaccine doses prior to this season.
|
21
|
Vaccine received - 2019-2020 flu season (MMWR)
|
VAX_RECEIVED_ 19_20_MMWR
|
Received flu vaccine during 2019-2020 flu season, based on CDC MMWR weeks.
|
Yes/No Yes if flu vaccine administered during 09/29/2019-9/26/2020, and age >=9; if age < 9, child must have received either two doses >= 4 weeks apart during this time period or have received two flu vaccine doses prior to this season.
|
22
|
Vaccine received - 2020-2021 flu season (MMWR)
|
VAX_RECEIVED_ 20_21_MMWR
|
Received flu vaccine during 2020-2021 flu season, based on CDC MMWR weeks.
|
Yes/No Yes if flu vaccine administered during 09/27/2020-10/2/2021, and age >=9; if age < 9, child must have received either two doses >= 4 weeks apart during this time period or have received two flu vaccine doses prior to this season.
|
23
|
Vaccine received - 2021-2022 flu season (MMWR)
|
VAX_RECEIVED_ 21_22_MMWR
|
Received flu vaccine during 2021-2022 flu season, based on CDC MMWR weeks.
|
Yes/No Yes if flu vaccine administered during 10/3/2021-10/1/2022, and age >=9; if age < 9, child must have received either two doses >= 4 weeks apart during this time period or have received two flu vaccine doses prior to this season.
|
24
|
Vaccine received - 2022-2023 flu season (MMWR)
|
VAX_RECEIVED_ 22_23_MMWR
|
Received flu vaccine during 2022-2023 flu season, based on CDC MMWR weeks.
|
Yes/No Yes if flu vaccine administered during 10/2/2022-9/30/2023, and age >=9; if age < 9, child must have received either two doses >= 4 weeks apart during this time period or have received two flu vaccine doses prior to this season.
|
25
|
Vaccine received - 2018-2019 flu season (Ordering)
|
VAX_RECEIVED_ 18_19_ORDER
|
Received flu vaccine during 2018-2019 flu season, based on ordering.
|
Yes/No Yes if flu vaccine administered during 07/1/2018-6/30/2019, and age >=9; if age < 9, child must have received either two doses >= 4 weeks apart during this time period or have received two flu vaccine doses prior to this season.
|
26
| Vaccine received - 2019-2020 flu season (Ordering)
| VAX_RECEIVED_ 19_20_ORDER
| Received flu vaccine during 2019-2020 flu season, based on ordering.
| Yes/No Yes if flu vaccine administered during 07/1/2019-6/30/2020, and age >=9; if age < 9, child must have received either two doses >= 4 weeks apart during this time period or have received two flu vaccine doses prior to this season.
|
27
| Vaccine received - 2020-2021 flu season (Ordering)
| VAX_RECEIVED_ 20_21_ORDER
| Received flu vaccine during 2020-2021 flu season, based on ordering.
| Yes/No Yes if flu vaccine administered during 07/1/2020-6/30/2021, and age >=9; if age < 9, child must have received either two doses >= 4 weeks apart during this time period or have received two flu vaccine doses prior to this season.
|
28
| Vaccine received - 2021-2022 flu season (Ordering)
| VAX_RECEIVED_ 21_22_ORDER
| Received flu vaccine during 2021-2022 flu season, based on ordering.
| Yes/No Yes if flu vaccine administered during 07/1/2021-6/30/2022, and age >=9; if age < 9, child must have received either two doses >= 4 weeks apart during this time period or have received two flu vaccine doses prior to this season.
|
29
| Vaccine received - 2022-2023 flu season (Ordering)
| VAX_RECEIVED_ 22_23_ORDER
| Received flu vaccine during 2022-2023 flu season, based on ordering.
| Yes/No Yes if flu vaccine administered during 07/1/2022-6/30/2023, and age >=9; if age < 9, child must have received either two doses >= 4 weeks apart during this time period or have received two flu vaccine doses prior to this season.
|
30
| Recipient name: first
| RECIP_FIRST_NAME
| Recipient's first name.
| n/a
|
31
| Recipient name: middle
| RECIP_MIDDLE_NAME
| Recipient's middle name.
| n/a
|
32
| Recipient name: last
| RECIP_LAST_NAME
| Recipient's last name.
| n/a
|
33
| Recipient age
| RECIP_AGE
| Recipient’s age in years.
| n/a
|
34
| Recipient address: street
| RECIP_ADDRESS _STREET
| The street component of the recipient's address.
| n/a
|
35
| Recipient address: street 2
| RECIP_ADDRESS _STREET_2
| The street 2 component of the recipient's address.
| n/a
|
36
| Recipient address: city | RECIP_ADDRESS _CITY
| The city component of the recipient's address.
| n/a
|
37
| Recipient address: state
| RECIP_ADDRESS _STATE
| The state component of the recipient's address.
| n/a
|
38
| 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
|
39
| 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.
| Derived from FIPs based on County_Code. When recip_address _county is null, derived from recip_address_zip.
|
40
| 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
|
41
| 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.
|
42
| Census tract - recipient address (2020)
| CENSUS_TRACT
| 2020 census tract based on recipient address only.
|
|
43
| Census tract - recipient address (2010)
| CENSUS_TRACT_10
| 2010 census tract based on recipient address only.
| |
44
| Census tract - administration address
| CENSUS_TRACT _ADMIN_10
| 2010 census tract based on vaccinating provider's address only.
| |
45
| 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.
| n/a
|