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