ā1
|
Bridgeād Recipient IDā
|
āBRIDGE_RECIP_IDā
|
āRecipient ID used for this individual in the recipient level view. ā ā
When an individual is identified as having more than one recipient ID in the dataset using the below bridging logic, all doses for that individual are mapped under one of the recipient IDs in the recipient level view. The recipient ID that is selected will be denoted as BRIDGE_RECIP_ID. In the recipient level view, RECIP_ID field reflects BRIDGE_RECIP_ID.
Bridging logic:
- Same first name ANDā
- Same last name AND
- Same DOB AND
- One of the following
- (Address street similar (50% max difference) OR both address street isāÆblank) AND same ZIP codeā - Same admin date and same lot numberā - Same phone number - Same email addressā
|
ān/a
|
ā2
|
āāRecipient ID
|
āRECIP_ID
|
āUnique ID for this recipient.
|
āān/a
|
ā3ā
|
āāVaccination event ID
|
āVAX_EVENT_IDā
|
āThe vaccination eventās unique identifier within the system.
|
ān/a
|
ā4
|
āāAdministration date
|
āADMIN_DATE
|
āThe date the vaccination event occurred.
|
ān/aā
|
ā5
|
āCVXā
|
āāCVXā
|
āThe vaccine type that was administered.
|
āCVX Codes ā Vaccines Administered
|
ā6
|
āAdministered at location
|
āāADMIN_NAME
|
āThe name of the physical clinic or facility that reported the vaccination. In a small practice setting, this could be the same as the responsible organization.ā
|
ān/aā
|
ā7
|
āLot number
|
āLOT_NUMBER
|
āThe lot number of the vaccine administered.
|
ān/a
|
ā8
|
āāNumber in Series
|
āNUMBER_IN_SERIES
|
āThe total number of doses required to complete a vaccination series.
|
ān/a
|
ā9
|
āOrdinal Position
|
āāORDINAL_POSITIONā
|
āThe dose number in a vaccination series.
|
ān/a
|
ā10
|
āOrganization code
|
āORG_CODE
|
āThe CAIR2 Organization Code assigned to administering organization.
|
ān/aāā
|
ā11
|
āRecipient name: firstāā
|
āRECIP_FIRST_NAME
|
āRecipientās first name.
|
ān/a
|
ā12
|
āāāRecipient name: middle
|
āRECIP_MIDDLE_NAME
|
āRecipientās middle name.
|
ān/a
|
ā13
|
āRecipient name: last
|
āRECIP_LAST_NAMEāā
|
āRecipientās last name.
|
ān/a
|
14
|
āāRecipient date of birth
|
āRECIP_DOB
|
āRecipientās date of birth.
|
ān/a
|
15
|
āRecipient address: street
|
āRECIP_ADDRESS _STREET
|
āThe street component of the recipient's address.
|
ān/a
|
ā16
|
āāRecipient address: street 2
|
āRECIP_ADDRESS _STREET_2
|
āThe street 2 component of the recipient's address.
|
ān/a
|
17
|
āRecipient address: city
|
āRECIP_ADDRESS_CITY
|
āThe city component of the recipient's address.
|
ān/a
|
ā18
|
Recipient address: state
|
āāRECIP_ADDRESS_STATE
|
āāThe state component of the recipient's address.
|
āUS Postal Service two-character State Codes
|
ā19
|
ā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
|
ā20
|
āRecipient race 1
|
āRECIP_RACE_1ā
|
āRecipientās race.
|
ā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)ā
|
ā21
|
āRecipient race 2ā
|
āRECIP_RACE_2
|
āRecipientās race. Fields recipient race 2ā6 support recipients with more than 1 race. (Skip if only one race reported).
|
āSee Value Set in āRecipient Race 1ā field.
|
ā22
|
āReciāpient race 3
|
āRECIP_RACE_3ā
|
āRecipientās race. Fields recipient race 2ā6 support recipients with more than 1 race. (Skip if only one race reported).
|
āSee Value Set in āRecipient Race 1ā field.
|
ā23
|
āRecipient race 4
|
āRECIP_RACE_4
|
āRecipientās race. Fields recipient race 2ā6 support recipients with more than 1 race. (Skip if only one race reported).
|
āSee Value Set in āRecipient Race 1ā field.
|
ā24
|
āRecipient race 5
|
āRECIP_RACE_5
|
āRecipientās race. Fields recipient race 2ā6 support recipients with more than 1 race. (Skip if only one race reported).
|
āSee Value Set in āRecipient Race 1ā field.
|
ā25ā
|
āRecipient race 6
|
āRECIP_RACE_6
|
āRecipientās race. Fields recipient race 2ā6 support recipients with more than 1 race. (Skip if only one race reported).
|
āSee Value Set in āRecipient Race 1ā field.
|
ā26
|
āRecipient ethnicity
|
āRECIP_ETHNICITY
|
āThe ancestry of the recipient
|
āHL7 User Defined table 0189 2135-2 (Hispanic or Latino) 2186-5 (Not Hispanic or Latino) PHC1175 (Prefer not to say) UNK (Unknown ethnicity)
|
ā27
|
āRecipient sex
|
āRECIP_SEX
|
āRecipientās sex
|
āHL7 User Defined table 0001 M (Male) F (Female) U (Unknown/ undifferentiated)āā X (Non-āāBinary)āā
|
ā28
|
ā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
|
29
|
āVaccine group
|
āVACCINE_GROUP
|
āThe code of the vaccine group. If the patient received a combination vaccine (e.g., Pediarix), the vaccination will appear within each vaccine group for the components included in the combination vaccine (e.g., for Pediarix, the vaccination will appear within the DTaP, Hep B, and Polio vaccine groups).
|
ā1 (Adeno) 2 (Anthrax) 3 (BCG) 4 (Cholera) 6 (Tetanus, Diphtheria, Acellular Pertussis) 7 (Diphtheria, Tetanus, Acellular Pertussis) 8 (Encephalitis) 9 (Influenza Seasonal) 11 (Hepatitis A) 12 (Hepatitis B) 13 (Hib) 14 (Ig) 15 (Lyme) 16 (Meningitis) 17 (Measles, Mumps, Rubella) 18 (Plague) 19 (Pneumonia Conjugate) 20 (Poliomyelitis) 21 (Rabies) 23 (Rotavirus) 24 (Typhoid) 25 (Vaccinia) 26 (Varicella) 27 (Yellow Fever) 31 (Tetanus) 33 (Diphtheria Antitoxin) 34 (Pneumonia Polysaccharide) 48 (Ig-RSV) 128 (Pertussis) 129 (Zoster) 130 (Human Papilloma Virus) 131 (Novel Influenza-09) 132 (Ig-HBIg) 135 (MenB) 136 (Influenza - H5N1) 138 (Coronavirus) 139 (Dengue)
|
ā30
|
āVaccine Group Display Name
|
āVACCINE_GROUP _DISPLAY_NAME
|
āShort version of VACCINE_GROUP _NAME
|
1 (Adeno) 2 (Anthrax) 3 (BCG) 4 (Cholera) 6 (Td/Tdap) 7 (DTP/aP) 8 (Encephalitis) 9 (Influenza-seasnl) 11 (HepA) 12 (HepB) 13 (Hib) 14 (Ig) 15 (Lyme) 16 (Men ACWY) 17 (MMR) 18 (Plague) 19 (PneumoConjugate) 20 (Polio) 21 (Rabies) 23 (Rotavirus) 24 (Typhoid) 25 (Vaccinia) 26 (Varicella) 27 (Yellow Fever) 31 (Tetanus) 33 (Diphtheria) 34 (PneumoPoly 23) 48 (Ig-RSV) 128 (Pertussis) 129 (Zoster) 130 (HPV) 131 (Influenza-H1N1) 132 (Ig-HBIg) 135 (MenB) 136 (Influenza - H5N1) 138 (COVID-19) 139 (Dengue)
|
ā31
|
āVaccine Group Name
|
āVACCINE_GROUP _NAME
|
āThe name of the vaccine group
|
āSee Value Set in āVaccine Groupā field.
|
ā32
|
āVaccine Name
|
āVACCINE_NAME
|
āThe name of the individual vaccine within a vaccine group
|
āCVX Codes ā Vaccines Administered
|
ā33
|
āRecipient age - days
|
āAGE_IN_DAYS
|
āRecipientās age in days
|
ān/a
|
ā34
|
āRecipient age - months
|
āAGE_IN_MONTHS
|
āRecipientās age in months
|
ān/a
|
ā35
|
āRecipient address: county
|
āRECIP_ADDRESS _COUNTY
|
āThe county code component of the recipient's address
|
āFIPS Codesā
|
ā36
|
āRecipient County Nameāā
|
āRECIP_COUNTY _LABEL
|
āThe county name component of the recipient's address.
|
āDerived from FIPs based on County Code. When RECIP_ADDRESS_COUNTY is null, derived from RECIP_ADDRESS_ZIP. See RECIP_ADDRESS_COUNTY _NEW
|
ā37
|
āNDC
|
āNDC
|
āThe vaccine product that was administered: Unit of Use (UoU) is preferred if both UoU and Unit of Sale (UoS) are available.
|
āNDC Crosswalk Tables
|
38
|
āMVX
|
āMVX
|
āThe manufacturer of the vaccine administered
|
āMVX ā Manufacturers of Vaccines
|
ā39
|
āVaccine expiration date
|
āVAX_EXPIRATION
|
āThe expiration date of the vaccine administered
|
ān/a
|
ā40
|
āVaccine administering site
|
āVAX_ADMIN_SITE
|
āThe body site of vaccine administration.
|
āHL7 defined table 0163 LT (Left thigh) LA (left arm) LD (left deltoid) LG (left gluteus medius) LVL (left vastus lateralis) LLFA (left lower forearm) RT (right thigh) RA (right arm) RD (right deltoid) RG (right gluteus medius) RVL (right vastus lateralis) RLFA (right lower forearm)
|
ā41
|
āVaccine route of administration
|
āVAX_ROUTE
|
āThe route of vaccine administration (e.g., oral, subcutaneous).
|
HL7 defined table 0162 or FDA NCI Thesaurus (NCIT) NCIT values preferred and provided for reference C38238 (Intradermal) C28161 (Intramuscular) C38284 (Nasal) C38276 (Intravenous) C38288 (Oral) C38676 (Percutaneous) C38299 (Subcutaneous) C38305 (Transdermal)
|
ā42
|
āDose number
|
āDOSE_NUM
|
āDose number in vaccination series, provided dose is considered valid (e.g., counts towards immunity). Based on ORDINAL_POSITION.
|
1 (Valid first dose) 2 (Valid second dose) 3 (Valid third dose) 4 (Valid fourth dose) 5 (Valid fifth dose) INV (Invalid dose) UNK (Unknown validity)
|
ā43
|
āVaccination series complete
|
āVAX_SERIES _COMPLETE
|
āReport if the vaccination series is complete. Select āYESā when the recipient has completed the required doses for the specific vaccine product. If more doses are required select āNO.ā If unknown, or cannot be calculated, select āUNK.āā
|
āYES (Yes) NO (No) UNK (Unknown)
|
ā44
|
āVaccine Eligibility
|
āVACCINE_ELIGIBILITY
|
āThe recipientās documented eligibility for the vaccine (e.g., VFC- MediCal/CHDP, VFC-Uninsured, etc.; 317; State General Fund; Private). Known data quality issues, not a required field.
|
āV01 Private V02 āāVFC Eligible Medi-Cal/CHDP V03⯠VFC Eligible Uninsured V04 VFC Eligible Native American/AK Native V05⯠VFC Eligible Underinsured (FQHC/RHC Only) V07 317 Eligible LHD or HDAS Only CAA01 āāState General Fundingā
|
ā45
|
āVTrckS provider PIN
|
āVTRCKS_PROV_PIN
|
The 6-digit Provider PIN in VTrckS. For VFC Providers, this is the VFC PIN
|
n/a |
46ā
|
Administered at location: type
|
ADMIN_TYPE
|
The characteristic of the provider site that reported the vaccination, refusal, or missed appointment
|
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)
|
ā47
|
Administration address: streetā
|
āADMIN_ADDRESS _STREET
|
āThe street component of where the vaccine is administered/ planned to be administered. Exception for mobile clinics
|
ān/a
|
ā48
|
āAdministration address: street 2
|
āADMIN_ADDRESS _STREET_2
|
āThe street 2 component of where the vaccine is administered/planned to be administered. Exception for mobile clinics
|
ān/a
|
ā49
|
āAdministration address: city
|
āADMIN_ADDRESS _CITY
|
āThe city component of where the vaccine is administered/planned to be administered. Exception for mobile clinics
|
ān/a
|
ā50
|
āAdministration address: county
|
āADMIN_ADDRESS _COUNTY
|
āThe county component of the administration address
|
āFIPS Codesāā
|
51
|
ā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 county name
|
ā52
|
āā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
|
ā53
|
āAdministration address: zip code
|
āADMIN_ADDRESS_ZIP
|
āThe zip code component of where the vaccine is administered/planned to be administered. Exception for mobile clinics
|
ān/a
|
ā54
|
āāDate vaccine entered into registry
|
āIIS_ADDED_DATE
|
āThe date vaccine reported to local registry
|
ān/a
|
ā55
|
āMotherās First Name
|
āMOTHERS_FIRST_NAME
|
āMotherās fist name
|
ān/a
|
āā56
|
āMotherās Maiden Last Name
|
āMOTHERS_MAIDEN_LAST
|
āMotherās maiden last name
|
ān/a
|
ā 57
|
āVaccinator name: Firstā
|
āVACCINATOR_FIRST_NAME
|
āVaccinatorās first name
|
ān/a
|
ā58
|
āVaccinator name: Lastā
|
āVACCINATOR_LAST_NAME
|
āVaccinatorās last name
|
ān/a
|
59
|
ID
|
āIMMUN_FACT_ID
|
āUnique identifier for the immunization record
|
ān/a
|
ā60
|
āEmail
|
āEMAIL_ADDRESS
|
āRecipientās email
|
ān/a
|
ā61
|
āPhone number
|
āPHONE_NUMBER
|
āRecipientās phone number
|
ān/a
|
ā62
|
āHistorical dose
|
āHISTORICAL_IND
|
āVaccination entered as an administered or historical dose
|
00 (Administered) 01 (Historical)
|
ā63
|
ā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)
|
ā64
|
āSnowflake entered date
|
āWAREHOUSE_ENTER _DATE
|
āDate/time record created in Snowflake
|
ān/a
|
ā65
|
āCAIR2 updated Date
|
āCAIR_UPDATE_TS
|
āDate/time record updated in CAIR2
|
ān/a
|
ā646
|
āSnowflake updated date
|
āWAREHOUSE_UPDATE _DATE
|
āDate/time record updated in Snowflake
|
ān/a
|
ā67
|
āRecipient address: concatenated
|
āMIXED_ADDRESS
|
āConcatenation of the recipient address street, city, state, and zip code
|
ān/a
|
ā68
|
āAdministration address: concatenated
|
āMIXED_ADMIN _ADDRESS
|
āConcatenation of the vaccinating providerās address street, city, state, and zip code
|
ān/a
|
ā69
|
āāRecipient Address: county (New)
|
āRECIP_ADDRESS _COUNTY_NEW
|
āIf recipient county is blank, this field gets populated by the FIPS code based on the recipient zip code, if available.
|
āFIPS Codesāā
|
ā70
|
āāRecipient address: county based on HPI_3_MIXED
|
āHPI_COUNTY _RCP_MIXED
|
āThe county name of the recipientās address, derived from HPI_3_MIXED
|
āDerived from FIPs based on County Code.
|
ā71
|
ā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. MIXED_ZIP: If recipient zip code is null, field is populated by admin zip code. MIXED_COUNTY: If RECIP_ADDRESS_ COUNTY_NEW is null or unknown, field is populated with ADMIN_COUNTY_LABEL.
|
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,ā āÆā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ā
|
ā72
|
āRecipient age - years
|
āRECIP_AGE
|
āRecipientās age in years
|
ān/a
|
ā73
|
ā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 (1002-5, 2028-9, 2076-8, 2054-5, 2106-3) is noted then āMultiracialā, otherwise first race noted.
|
ā74
|
āāCensus tract ā recipient address (2020)āā
|
āCENSUS_TRACTā
|
āā2020 census tract based on recipient address only.
|
ā
|
ā75
|
ā Census tract ā recipient address (2010)ā
|
āCENSUS_TRACT_10
|
ā2010 census tract based on recipient address only.
|
ā
|
ā76
|
āCensus tract ā administration address
|
āCENSUS_TRACT_ADMIN_10
|
ā2010 census tract based on vaccinating providerās address only.
|
ā
|
ā77
|
āāHPI 3.0 - census tract
|
āāāHPI_3_TRACT
|
ā āHealthy Places Index 3.0 score quartile based on the 2010 census tract from the recipientās address.āÆ
|
ā
|
ā78
|
āHPI 3.0 ā zip
|
āHPI_3_ZIP
|
āāHealthy PIaces Index 3.0 score quartile 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ā
Locally Defined Value Set:āÆāÆ 1 (HPI Quartile 1)⯠2 (HPI Quartile 2)⯠3 (HPI Quartile 3)⯠4 (HPI Quartile 4)⯠Null (no HPI score assigned)
|
ā79āā
|
āHPI 3.0 - mixed
|
āāHPI_3_MIXED
|
āHPI_3_TRACT; if null, uses HPI_3_ZIP.
|
āāHealthy Places Index
Locally Defined Value Set:āÆāÆ
1 (HPI Quartile 1)⯠2 (HPI Quartile 2)⯠3 (HPI Quartile 3)⯠4 (HPI Quartile 4)⯠Null (no HPI score assigned)⯠āā
|
ā80
|
āAdministered at location: descriptionā
|
āADMIN_TYPE_DESC
|
āDescription of ADMIN_TYPE. The characteristic of the provider site that reported the vaccination, refusal, or missed appointment
|
ā
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)
ā
|
āā81
|
āSnapshot time
|
āSNAPSHOT_TIME
|
āData current as of this timestamp
|
ān/aāā
|