Vaccine Records Import - Data Migrations

Vaccine, or Immunization, records can be imported into existing patient records using a standard spreadsheet (CSV/XLSX, delimited text) file. The columns below are accepted for population of this data:

Column Header Description Format Required Example
Last Name Patient's full last name. May also include suffix. text Yes John
First Name Patient's full first name text Yes Smith
Date of Birth Patient Birthday date No "1990-01-01", "01/01/1990"
Chart ID DrChrono Chart ID text No SMJO000001
CVX Code Unique Vaccine identifier. (See Reference) numerical/code Yes 212
Name Vaccine Label text Yes SARS-COV-2 (COVID-19) vaccine, vector non-replicating, recombinant spike protein-Ad26, preservative free, 0.5 mL
Administration Start

Date & Time when vaccine was administered.

date-time Yes "01/01/2023 10:30am"
Units

Units of measure

text No

"Micrograms"

Amount Volume of dose administered numerical No 1
Comments Internal notes related to this vaccine's administration text No Redness at site after administration
Completion Status

Vaccination Status. Can be one of:

"CP" (Complete)

"RE" (Refused)

"NA" (Not Administered)

"PA" (Partially Administered)

choice Yes "CP"
CPT Code

Vaccine CPT Code

text/code No "91317"
Funding Eligibility

VFC (Vaccine for Children) program eligibility code.

(See reference for choices)

choice No "V01"
Next Dose Date

Date for next dose of vaccine

date No "04/01/2023"
Observed Immunity

Code indicating immunity to particular disease. (See reference for choices)

text/code No

"398102009"

(Acute poliomyelitis (disorder))

Ordering Doctor

Doctor's full name. If exists in the DrChrono practice group, the entry will be linked to the provider. Otherwise, it will be linked to the primary provider on record for the practice group.

text No

"Samuel Smith, MD"

Record Source

Code or value of record type.

Can be one of (written as ("code":"value")):

  • "00": "New immunization record"
  • "01": "Historical Information - source unspecified
  • "02": "Historical information - from other provider"
  • "03": "Historical information - from parent's written record"
  • "04": "Historical information - from parent's recall"
  • "05": "Historical information - from other registry"
  • "06":"Historical information - from birth certificate"
  • "07":"Historical information - from school record"
  • "08":"Historical information - from public agency"
text/code No

"00"

Route

Route of vaccine administration.

(Vaccine Site & Routes reference)

text No

"Subcutaneous"

Site

specific location on patient where vaccine was administered.

(Vaccine Site & Routes reference)

text No

"Left Arm"

Attached to this article is a CSV template you may use to help structure the data you wish to have imported.