VladaOmega
Sign inStart free
Provider identity

Provider → Facility affiliation (curated)

vlada_curated.dim_provider_facility_affiliation·live·dim·Provider Enrollment & Ownership (PECOS)
Rows
N/A
Columns
5
History
N/A
Card
nocolumns only
Typed tools
0

What it is

  1. 1Curated clinician-NPI → facility-CCN affiliation edges (with facility_type and PAC ID).
  2. 2The curated provider↔facility bridge (the silver source is drug_silver.dim_facility_affiliation / cms_facility_affiliation).

Grain

KeyGrain
N/A
  1. 1One row per (clinician_npi, facility_ccn) affiliation edge.

Columns (5)

ColumnTypeMeaning
clinician_npistring
facility_ccnstring
facility_typestring
ind_pac_idstring
sourcevarchar(35)

Query it

describe_data_source(source_fqn="vlada_curated.dim_provider_facility_affiliation")     # the card, live
query_substrate(sql="SELECT * FROM vlada_curated.dim_provider_facility_affiliation WHERE <filter> LIMIT 100")
ItemValue
Typed tools that read itnone; raw SQL
Identity keyclinician_npi
Joinhow_to_join(source_fqn="vlada_curated.dim_provider_facility_affiliation")
Raw doorAthena (read-only via query_substrate): vlada_curated.dim_provider_facility_affiliation

This page as markdown: /docs-md/data/vlada_curated_dim_provider_facility_affiliation.md · every page in one file: /llms-full.txt