ā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)
|
ā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
| āVTrckS provider PIN
| āVTRCKS_PROV_PIN
| The 6-digit Provider PIN in VTrckS. For VFC Providers, this is the VFC PIN
| n/a |
45ā
| 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)
|
ā46
| 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
|
ā47
| ā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
|
ā48
| ā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
|
ā49
| āAdministration address: county
| āADMIN_ADDRESS _COUNTY
| āThe county component of the administration address
| āFIPS Codesāā
|
ā50
| ā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
|
ā51
| āā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
|
ā52
| ā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
|
ā53
| āāDate vaccine entered into registry
| āIIS_ADDED_DATE
| āThe date vaccine reported to local registry
| ān/a
|
ā54
| āID
| āIMMUN_FACT_ID
| āUnique identifier for the immunization record
| ān/a
|
ā55
| āEmail
| āEMAIL_ADDRESS
| āRecipientās email
| ān/a
|
ā56
| āPhone number
| āPHONE_NUMBER
| āRecipientās phone number
| ān/a
|
ā57
| āHistorical dose
| āHISTORICAL_IND
| āVaccination entered as an administered or historical dose
| 00 (Administered) 01 (Historical)
|
ā58
| ā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)
|
ā59
| āSnowflake entered date
| āWAREHOUSE_ENTER _DATE
| āDate/time record created in Snowflake
| ān/a
|
ā60
| āCAIR2 updated Date
| āCAIR_UPDATE_TS
| āDate/time record updated in CAIR2
| ān/a
|
ā61
| āSnowflake updated date
| āWAREHOUSE_UPDATE _DATE
| āDate/time record updated in Snowflake
| ān/a
|
ā62
| āRecipient address: concatenated
| āMIXED_ADDRESS
| āConcatenation of the recipient address street, city, state, and zip code
| ān/a
|
ā63
| āAdministration address: concatenated
| āMIXED_ADMIN _ADDRESS
| āConcatenation of the vaccinating providerās address street, city, state, and zip code
| ān/a
|
ā64
| āā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ā
|
ā65
| āRecipient vaccination number
| āRECIP_VAX_NUM
| āDose number, incremented by 1 for each dose received by the recipient, in order of vaccination date. All doses received by each recipient, including invalid doses, are assigned a number. May differ from dose number assigned by IIS.
| ān/a
|
ā66
| āā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.
|
ā67
| ā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ā
|
ā68
| āRecipient age - years
| āRECIP_AGE
| āRecipientās age in years
| ān/a
|
ā69
| ā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.
|
āā70
| āSnapshot time
| āSNAPSHOT_TIME
| āData current as of this timestamp
| ān/a
|