327 lines
2.6 KiB
Text
327 lines
2.6 KiB
Text
|
Data Elements Specification
|
||
|
|
|
||
|
|
|
||
|
|
Field Name
|
||
|
|
|
||
|
|
|
||
|
|
provider_location_guid
|
||
|
|
loc_store_no
|
||
|
|
|
||
|
|
|
||
|
|
loc_phone
|
||
|
|
loc_name
|
||
|
|
loc_admin_street1
|
||
|
|
loc_admin_street2
|
||
|
|
loc_admin_city
|
||
|
|
loc_admin_state
|
||
|
|
loc_admin_zip
|
||
|
|
sunday_hours
|
||
|
|
monday_hours
|
||
|
|
tuesday_hours
|
||
|
|
wednesday_hours
|
||
|
|
thursday_hours
|
||
|
|
friday_hours
|
||
|
|
saturday_hours
|
||
|
|
web_address
|
||
|
|
pre_screen
|
||
|
|
insurance_accepted
|
||
|
|
walkins_accepted
|
||
|
|
provider_notes
|
||
|
|
ndc
|
||
|
|
|
||
|
|
|
||
|
|
med_name
|
||
|
|
|
||
|
|
|
||
|
|
In_stock
|
||
|
|
|
||
|
|
|
||
|
|
supply_level
|
||
|
|
|
||
|
|
|
||
|
|
quantity_last_updated
|
||
|
|
|
||
|
|
|
||
|
|
Latitude
|
||
|
|
Longitude
|
||
|
|
|
||
|
|
|
||
|
|
Category
|
||
|
|
|
||
|
|
|
||
|
|
free_mask_program
|
||
|
|
|
||
|
|
|
||
|
|
min_age_months
|
||
|
|
|
||
|
|
|
||
|
|
min_age_years
|
||
|
|
|
||
|
|
|
||
|
|
File details
|
||
|
|
|
||
|
|
|
||
|
|
Field Description
|
||
|
|
|
||
|
|
|
||
|
|
Vaccine Finder Provider ID integer(36)
|
||
|
|
|
||
|
|
|
||
|
|
Chain store number for pharmacies only
|
||
|
|
|
||
|
|
|
||
|
|
Data Type
|
||
|
|
|
||
|
|
|
||
|
|
integer
|
||
|
|
|
||
|
|
|
||
|
|
Valid Values
|
||
|
|
|
||
|
|
|
||
|
|
Pharmacies: Integer
|
||
|
|
|
||
|
|
|
||
|
|
Non-pharmacies: Not applicable
|
||
|
|
|
||
|
|
|
||
|
|
Location phone number
|
||
|
|
|
||
|
|
|
||
|
|
Provider Location Display Name
|
||
|
|
|
||
|
|
|
||
|
|
varchar (128)
|
||
|
|
varchar (255)
|
||
|
|
|
||
|
|
|
||
|
|
Street address 1
|
||
|
|
|
||
|
|
|
||
|
|
varchar (255)
|
||
|
|
|
||
|
|
|
||
|
|
Street address 2
|
||
|
|
|
||
|
|
|
||
|
|
varchar (255)
|
||
|
|
|
||
|
|
|
||
|
|
City
|
||
|
|
State
|
||
|
|
|
||
|
|
|
||
|
|
varchar (255)
|
||
|
|
|
||
|
|
|
||
|
|
varchar (2)
|
||
|
|
|
||
|
|
|
||
|
|
Postal Code
|
||
|
|
|
||
|
|
|
||
|
|
varchar (10)
|
||
|
|
|
||
|
|
|
||
|
|
Open hours for Sunday
|
||
|
|
|
||
|
|
|
||
|
|
varchar(255)
|
||
|
|
|
||
|
|
|
||
|
|
hh:mm:AM - hh:mm:AM
|
||
|
|
|
||
|
|
|
||
|
|
Open hours for Monday
|
||
|
|
|
||
|
|
|
||
|
|
Open hours for Tuesday
|
||
|
|
|
||
|
|
|
||
|
|
varchar(255)
|
||
|
|
varchar(255)
|
||
|
|
|
||
|
|
|
||
|
|
hh:mm:AM - hh:mm:AM
|
||
|
|
hh:mm:AM - hh:mm:AM
|
||
|
|
|
||
|
|
|
||
|
|
Open hours for Wednesday
|
||
|
|
|
||
|
|
|
||
|
|
varchar(255)
|
||
|
|
|
||
|
|
|
||
|
|
hh:mm:AM - hh:mm:AM
|
||
|
|
|
||
|
|
|
||
|
|
Open hours for Thursday
|
||
|
|
|
||
|
|
|
||
|
|
varchar(255)
|
||
|
|
|
||
|
|
|
||
|
|
hh:mm:AM - hh:mm:AM
|
||
|
|
|
||
|
|
|
||
|
|
Open hours for Friday
|
||
|
|
|
||
|
|
|
||
|
|
Open hours for Saturday
|
||
|
|
|
||
|
|
|
||
|
|
varchar(255)
|
||
|
|
varchar(255)
|
||
|
|
|
||
|
|
|
||
|
|
hh:mm:AM - hh:mm:AM
|
||
|
|
hh:mm:AM - hh:mm:AM
|
||
|
|
|
||
|
|
|
||
|
|
Web address
|
||
|
|
|
||
|
|
|
||
|
|
varchar(255)
|
||
|
|
|
||
|
|
|
||
|
|
Allow nulls
|
||
|
|
|
||
|
|
|
||
|
|
Web address (Pre-Screen link)
|
||
|
|
|
||
|
|
|
||
|
|
varchar(255)
|
||
|
|
|
||
|
|
|
||
|
|
Allow nulls
|
||
|
|
|
||
|
|
|
||
|
|
Accepts Insurance?
|
||
|
|
|
||
|
|
|
||
|
|
Accepts Walk-ins?
|
||
|
|
|
||
|
|
|
||
|
|
boolean
|
||
|
|
|
||
|
|
|
||
|
|
boolean
|
||
|
|
|
||
|
|
|
||
|
|
Allow nulls
|
||
|
|
|
||
|
|
|
||
|
|
Allow nulls
|
||
|
|
|
||
|
|
|
||
|
|
Notes to display on the provider details page
|
||
|
|
|
||
|
|
|
||
|
|
varchar (1000)
|
||
|
|
|
||
|
|
|
||
|
|
Allow nulls
|
||
|
|
|
||
|
|
|
||
|
|
The National Drug Code
|
||
|
|
|
||
|
|
|
||
|
|
varchar (32)
|
||
|
|
|
||
|
|
|
||
|
|
XXXX-XXXXX-XX
|
||
|
|
|
||
|
|
|
||
|
|
The name of the medication
|
||
|
|
|
||
|
|
|
||
|
|
Is this vaccine in stock for the public at this
|
||
|
|
location?
|
||
|
|
|
||
|
|
|
||
|
|
varchar(255)
|
||
|
|
|
||
|
|
|
||
|
|
boolean
|
||
|
|
|
||
|
|
|
||
|
|
True/False
|
||
|
|
|
||
|
|
|
||
|
|
The Supply level availability code (number)
|
||
|
|
|
||
|
|
|
||
|
|
integer
|
||
|
|
|
||
|
|
|
||
|
|
Valid values are:
|
||
|
|
-1: No Report
|
||
|
|
0: No Supply
|
||
|
|
1: <24 Hour Supply
|
||
|
|
3: 24-48 Hour Supply
|
||
|
|
4: >48 Hour Supply
|
||
|
|
|
||
|
|
|
||
|
|
Date the "on hand quantity (number)" was last
|
||
|
|
updated
|
||
|
|
|
||
|
|
|
||
|
|
date
|
||
|
|
|
||
|
|
|
||
|
|
YYYY-MM-DD
|
||
|
|
|
||
|
|
|
||
|
|
latitude
|
||
|
|
|
||
|
|
|
||
|
|
varchar(255)
|
||
|
|
|
||
|
|
|
||
|
|
longitude
|
||
|
|
|
||
|
|
|
||
|
|
Is this vaccine a COVID or Seasonal Flu vaccine?
|
||
|
|
|
||
|
|
|
||
|
|
varchar(255)
|
||
|
|
|
||
|
|
|
||
|
|
varchar(255)
|
||
|
|
|
||
|
|
|
||
|
|
Valid values are:
|
||
|
|
COVID, Seasonal
|
||
|
|
|
||
|
|
|
||
|
|
Does this location participate in the federal free
|
||
|
|
mask program?
|
||
|
|
|
||
|
|
|
||
|
|
boolean
|
||
|
|
|
||
|
|
|
||
|
|
Allow nulls
|
||
|
|
|
||
|
|
|
||
|
|
Minimum age for vaccinations at this location if <1
|
||
|
|
year or non-whole number.
|
||
|
|
|
||
|
|
|
||
|
|
integer
|
||
|
|
|
||
|
|
|
||
|
|
Allow nulls
|
||
|
|
|
||
|
|
|
||
|
|
Minimum age for vaccinations at this location >1
|
||
|
|
year if minimum age is a whole number.
|
||
|
|
|
||
|
|
|
||
|
|
integer
|
||
|
|
|
||
|
|
|
||
|
|
Allow nulls
|
||
|
|
|
||
|
|
|