Skip Navigation LinksMPX-Data-Dictionary-Snowflake-Doses

california immunization registry

CAIR logoVaccinia (including MPX) Vaccination

- Recipients Snowflake Data Dictionary

Last Updated 8/19/2022


LHJ Data Source

Table Name: TBL_IMMUN_MONKEYPOX_RECIPIENTS

Description: This is a recipient level table 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 all vaccinia vaccine doses (including monkeypox) reported to the California Immunization Registry (CAIR2) and the Healthy Futures Registry (the San Diego Immunization Registry was integrated into CAIR2 in April 2022).


FIELD DEFINITIONS

Field No.

Data Element

Variable Name

Description

1Recipient IDRECIP_IDUnique ID for recipient.
2Administration date – Dose 1DS1_ADMIN_DATEThe first recorded dose administration date for the recipient. Ignores DOSE_NUM field in dose-level dataset for determination.
3Administration date – Dose 2DS2_ADMIN_DATEThe second recorded dose administration date for the recipient. Ignores DOSE_NUM field in dose-level dataset for determination.
4Administration date – Dose 3DS3_ADMIN_DATEIf given, the third recorded dose administration date for the recipient. Ignores DOSE_NUM field in dose-level dataset for determination.
5Administration date – Dose 4DS4_ADMIN_DATEIf given, the fourth recorded dose administration date for the recipient. Ignores DOSE_NUM field in dose-level dataset for determination.
6Vaccine types receivedVAX_RECEIVEDThe trade name(s) of all vaccines received, for up to 4 doses.

Locally Defined Value Set:
ACAM2000
JYNNEOS
7Vaccination statusFULLY_VACCINATEDRecipient'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)
8Fully vaccinated dateFULLY_VACCINATED_DATEDate recipient became fully vaccinated for MPX.
9Partially vaccinated datePARTIALLY_VACCINATED_DATEDate recipient became partially vaccinated for MPX (i.e., received first dose of JYNNEOS)
10Recipient name: firstRECIP_FIRST_NAMERecipient's first name.
11Recipient name: middleRECIP_MIDDLE_NAMERecipient's middle name.
12Recipient name: lastRECIP_LAST_NAMERecipient's last name.
13Recipient date of birthRECIP_DOBRecipient's date of birth.
14Recipient ageRECIP_AGERecipient's age in years.
15Recipient age groupRECIP_AGE_GROUPRecipient's age group, in years.

Locally Defined Value Set:
16Recipient sexRECIP_SEXRecipient 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)
17Recipient race/ethnicity  RECIP_RACE_ETHRecipient'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)
18Recipient address: streetRECIP_ADDRESS_STREETThe street component of the recipient's address.
19Recipient address:
street 2
RECIP_ADDRESS_STREET_2The street 2 component of the recipient's address.
20Recipient address: cityRECIP_ADDRESS_CITYThe city component of the recipient's address.
21Recipient address: stateRECIP_ADDRESS_STATEThe state component of the recipient's address.

US Postal Service two-character state codes
22Recipient address: zip codeRECIP_ADDRESS_ZIPThe zip code of the recipient's address.
23Recipient county nameRECIP_COUNTY_LABELThe 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.
24Responsible organizationRESPONSIBLE_ORGThe 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.)
25Administered at locationADMIN_NAMEThe 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.
26Administration address: stateADMIN_ADDRESS_STATEThe state component of where the vaccine is administered/ planned to be administered. Exception for mobile clinics.

US Postal Service two-character state codes
27Administration address:
zip code
ADMIN_ADDRESS_ZIPThe zip code component of where the vaccine is being administered/ planned to be administered. Exception for mobile clinics.
28Administration address:
county name
ADMIN_COUNTY_LABELThe 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.
29Mixed zipMIXED_ZIPIf recipient zip code is null, this field is populated by admin zip code.
30Mixed countyMIXED_COUNTYIf 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.
31Local health jurisdictionLHJLocal 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
32VEM quartile HPIQUARTILEVaccine 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)
33VEM quartile based on recipient zip codeHPIQUARTILE_RCP_ZIPVaccine 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)
34Recipient address: county based on zip codeHPI_COUNTY_RCP_ZIPThe county name of the recipient's address, derived from the zip code of the recipient's address.

County derived from recip_address_zip
35Administered at location: typeADMIN_TYPE_DESCThe 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)
36Lot numbersLOT_NUMBERSThe lot numbers for all COVID vaccinations administered, concatenated.
37Dose 1 vaccination event ID DS1_VAX_EVENT_IDThe vaccination event's unique identifier within the system for first reported dose (based on vaccination date).
38Dose 2 vaccination event IDDS2_VAX_EVENT_IDThe vaccination event's unique identifier within the system for second reported dose (based on vaccination date).
39Dose 3 vaccination event IDDS3_VAX_EVENT_IDThe vaccination event's unique identifier within the system for third reported dose (based on vaccination date).
40Dose 4 vaccination event IDDS4_VAX_EVENT_IDThe vaccination event's unique identifier within the system for fourth reported dose (based on vaccination date).
41Snapshot timeSNAPSHOT_TIMEData current as of this timestamp.
42EmailEMAIL_ADDRESSRecipient's email address.
43Phone numberPHONE_NUMBERRecipient's phone number.
44Patient sharing indicatorLOCKED_INDPatient 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)
45Table creation dateTBL_CREATE_DTTMDate/time the recipient level view materialization (table creation) is performed.

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


Page Last Updated :