location

One row per facility or place of service, with address and facility type, used to resolve the facility identifiers carried on encounters and claims.

At a glance

Schema	dax_core
Table	location
Layer	Core Data Model
Object type	table
Columns	14
Grain	location_id, data_source
Tags	core

Columns

Column	Type	Key	Terminology	Constraints	Description
location_id	varchar	PK	—	not null	—
npi	varchar		Provider	—	—
name	varchar		—	—	—
facility_type	varchar		—	—	—
parent_organization	varchar		—	—	—
address	varchar		—	—	—
city	varchar		—	—	—
state	varchar		—	—	—
zip_code	varchar		—	—	—
latitude	float		—	—	—
longitude	float		—	—	—
ingest_datetime	timestamp		—	—	—
dax_last_run	timestamp		—	—	—
data_source	varchar	PK	—	not null	—

Querying

select *
from dax_core.location
limit 100;