Table 1.

PrEP Locator database system domains, variables, variable definitions, and variable examples.

Domain and variable name		Variable definition	Variable example
Contact information
	Titlea	Name of the clinic or provider	Empowerment Resource Center
	Telephonea	Clinic telephone number object, containing a number that must be 10 digits or empty and an extension field without an enforced format	404-999-9999
	Telephone2	Second clinic telephone number object	404-999-5555
	ClinicEmail	Email address of the clinic, which must be a valid email address	info@preplocator.org
	Link	Website of the clinic, which must be a valid URL beginning with http:// or https://	https://www.preplocator.org
Address
	StreetAddressa	Street address	1518 Clifton Rd.
	Localitya	City and/or county	Decatur
	Regiona	State	GA
	PostalCodea	5-digit zip code	30322
PrEP service information
	Spanish	Whether the clinic offers services in Spanish; false by default	False
	Uninsured	Whether the clinic accepts uninsured patients; false by default	True
	Navigation	Whether the clinic offers PrEP navigation services; false by default	True
	Coordinator	PrEP coordinator for the clinic, an object containing the clinic coordinator’s information, with name, email address, and telephone number fields	Jane Doe, janedoe@healthcare.com, 404-727-9999
Clinic hours
	Schedule	Schedule for the clinic, an object containing the hours of operation, with objects for each day of the week; each day’s object contains status (open, closed, or empty), openTime, and closeTime	Monday, open 8:00AM to 5:00PM
Entry management
	Statusa	Active, pending, or excluded, as determined by Emory staff	Active
	Vetteda	State licensure verification by Emory staff	True
	Eligible	Rationale for eligibility determination	Does not prescribe PrEP
	Notes	Contact notes for each clinic, including information such as the number of contact attempts and the results of contact	Contacted by email and telephone 5 times.
System-generated variables
	Id	ID of the clinic, auto-incremented from 1	1428
	Lat	Latitude in decimal format, generated from a Google API using the clinic address	33.798258
	Long	Longitude in decimal format, generated from a Google API using the clinic address	-84.323467
	Created	RFC 3339 timestamp for when the clinic was added to the database	2016-04-12T23:20:50.52Z
	Updated	RFC 3339 timestamp for when the clinic was added to the database	2016-04-12T23:20:50.52Z

^aIndicates a required variable; an entry cannot be processed without this information.