| 1 | Recipient ID | RECIP_ID | Unique ID for recipient. |
| 2 | Administration date ā Dose 1 | DS1_ADMIN_DATE | The first recorded dose administration date for the recipient. Ignores DOSE_NUM field in dose-level dataset for determination. |
| 3 | Administration date ā Dose 2 | DS2_ADMIN_DATE | The second recorded dose administration date for the recipient. Ignores DOSE_NUM field in dose-level dataset for determination. |
| 4 | Administration date ā Dose 3 | DS3_ADMIN_DATE | If given, the third recorded dose administration date for the recipient. Ignores DOSE_NUM field in dose-level dataset for determination. |
| 5 | Administration date ā Dose 4 | DS4_ADMIN_DATE | If given, the fourth recorded dose administration date for the recipient. Ignores DOSE_NUM field in dose-level dataset for determination. |
| 6 | Vaccine types received | VAX_RECEIVED | The trade name(s) of all vaccines received, for up to 4 doses.
Locally Defined Value Set:
ACAM2000
JYNNEOS
|
| 7 | Vaccination status | FULLY_VACCINATED | Recipient's vaccination status for MPX.
A vaccine recipient is considered fully vaccinated for MPX if they meet at least one of the following criteria:
1) They received one dose of ACAM2000 (CVX 75)
2) They received two JYNNEOS (CVX 206) doses >= 24 days apart.
Locally Defined Value Set:
FALSE (Partially vaccinated)
TRUE (Fully vaccinated)
|
| 8 | Fully vaccinated date | FULLY_VACCINATED_DATE | Date recipient became fully vaccinated for MPX.
|
| 9 | Partially vaccinated date | PARTIALLY_VACCINATED_DATE | Date recipient became partially vaccinated for MPX (i.e., received first dose of JYNNEOS) |
| 10 | Recipient name: first | RECIP_FIRST_NAME | Recipient's first name. |
| 11 | Recipient name: middle | RECIP_MIDDLE_NAME | Recipient's middle name. |
| 12 | Recipient name: last | RECIP_LAST_NAME | Recipient's last name. |
| 13 | Recipient date of birth | RECIP_DOB | Recipient's date of birth. |
| 14 | Recipient age | RECIP_AGE | Recipient's age in years. |
| 15 | Recipient age group | RECIP_AGE_GROUP | Recipient's age group, in years.
Locally Defined Value Set:
|
| 16 | Recipient sex | RECIP_SEX | Recipient sex. Derived from value recorded for second dose, unless null, then first dose value is used.
Locally Defined Value Set:
F (Female)
M (Male)
O (Other)
X (Non-binary)
U (Unknown/undifferentiated)
|
| 17 | 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)
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)
|
| 18 | Recipient address: street | RECIP_ADDRESS_STREET | The street component of the recipient's address. |
| 19 | Recipient address:
street 2 | RECIP_ADDRESS_STREET_2 | The street 2 component of the recipient's address. |
| 20 | Recipient address: city | RECIP_ADDRESS_CITY | The city component of the recipient's address. |
| 21 | Recipient address: state | RECIP_ADDRESS_STATE | The state component of the recipient's address.
US Postal Service two-character state codes
|
| 22 | Recipient address: zip code | RECIP_ADDRESS_ZIP | The zip code of the recipient's address.
|
| 23 | 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. See Recip_Address_County_New.
|
| 24 | 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.) |
| 25 | 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. |
ā26
| āAdministration address: concatenated
| āMIXED_ADMIN_ADDRESS
| āConcatenation of the vaccinating providerās address street, city, state, and zip code.
|
| 27 | Administration address: state | ADMIN_ADDRESS_STATE | The state component of where the vaccine is administered/ planned to be administered. Exception for mobile clinics.
US Postal Service two-character state codes
|
| 28 | 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. |
| 29 | 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.
Join with FIPS table based on County_Code to get the name/description.
|
| 30 | Mixed zip | MIXED_ZIP | If recipient zip code is null, this field is populated by admin zip code. |
| 31 | Mixed county | MIXED_COUNTY | If recip_address_county_new is NULL or unknown, populate this with admin_county_label.
'Outside California' category includes out-of-state residents and records where recipient's state of residence is blank. |
| 32 | 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.
'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
|
ā33
| āCensus tract ā recipient
| āCENSUS_TRACT_10
| ā2010 census tract based on recipient address only
|
ā34
| āCensus tract ā administration address
| āCENSUS_TRACT_ADMIN_10
| ā2010 census tract based on vaccinating providerās address only.
|
ā35
| ā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
|
ā36
| ā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
|
ā37
| āHPI 3.0 - mixed
| āHPI_3_MIXED
| ā HPI_3_TRACT; if null, uses HPI_3_ZIP.
Healthy Places Index
|
| 38 | 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.
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)
|
| 39 | 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.
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)
|
| 40 | 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.
County derived from recip_address_zip
|
41
| Administered at location: type | ADMIN_TYPE_DESC | The characteristic of the provider site that reported the vaccination, refusal, or missed appointment.
Locally Defined Value Set:
1 (Childcare facility)
2 (College/university)
3 (Community HC)
4 (Corrections facility - all ages)
5 (Drug treatment facility)
6 (Family planning)
7 (Family practice)
8 (Fed-qual or rural HC)
9 (Foster care)
10 (Health department-associated site)
11 (Health plans)
12 (HIE/data aggregator)
13 (HIV/STD clinic)
14 (Home health)
15 (Hospital - birthing)
16 (Tribal/IHS clinic)
17 (Internal medicine)
18 (Juvenile detention center)
19 (Local health dept)
20 (Military healthcare)
21 (Multispecialty practice)
22 (Nursing home/LTC)
23 (OBGYN)
24 (Other)
25 (Other IIS)
26 (Pediatrics)
27 (Pharmacy)
28 (Private practice)
29 (School/school district)
30 (Special vaccine clinic)
31 (State agency)
32 (State public health)
33 (Urgent care)
34 (WIC program)
35 (Hospital)
36 (School clinic)
37 (Non clinical site)
38 (Pandemic only)
39 (Pending)
|
| 42 | Lot numbers | LOT_NUMBERS | The lot numbers for all COVID vaccinations administered, concatenated.
|
| 43 | Email | EMAIL_ADDRESS | Recipient's email address. |
| 44 | Phone number | PHONE_NUMBER | Recipient's phone number. |
ā45
| ā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
|
ā46
| ā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
|
ā47
| ā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
|
ā48
| ā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
|
| 49 | 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.
Locally Defined Value Set:
0 (FALSE)
1 (TRUE)
|
ā50
| āSnapshot time
| āSNAPSHOT_TIME
| āData current as of this timestamp.
n/a
|
| 51 | Table creation date | TBL_CREATE_DTTM | Date/time the recipient level view materialization (table creation) is performed.
|