NAV

Dimensions EDW Schema v1

Overview

The Dimensions enterprise data warehouse (EDW) bundle contains files that make up shared reference models in HealtheEDW such as providers.

Character Separated Values (CSV) Properties

Property Value
Header Record Yes
Field Delimiter Comma
Record Delimiter CR/LF
Character Encoding UTF-8

Files

File Name Description
PH_D_Provider This table contains the providers that are contained in activity data, for example, claims or electronic health record (EHR) activity data. This includes name demographic information for providers included in that data as well as a link to personnel.
PH_D_Provider_Alias This table contains the aliases for providers contained on the PH_D_Provider table. This typically may include TIN, NPI, DEA, or proprietary aliases.
PH_D_Provider_Address This table contains any additional addresses for a given provider.
PH_D_Provider_Email This table contains the provider’s email addresses that are associated with the provider.
PH_D_Provider_Telecom This table contains the provider’s telecom numbers associated with the provider.

Field Definitions

PH_D_Provider

Field Definition Data Type
degrees The provider degrees provided with the piece of activity data from a data source. varchar(200)
family_name The family or last name for the patient. varchar(200)
given_name The provider given_name provided with the activity data from a data source. varchar(200)
modification_type Not applicable varchar(30)
modification_type_key The data model or source that contributed to the last modification. varchar(200)
name The provider name provided with the activity data from a data source. varchar(400)
prefix The prefix portion of the person’s name. varchar(30)
provider_id The unique ID of the provider. varchar(36)
prsnl_id An internal database ID. Typically, this is a combination of the ministry_prsnl_id value and version. varchar(200)
suffix The suffix portion of the person’s name. In the case of providers, this could be degrees earned. varchar(30)
titles The provider titles provided with the activity data from a data source. varchar(30)
version An internal ID that indicates the archive on which this data part lives. varchar(200)

PH_D_Provider_Alias

Field Definition Data Type
alias_type_key This field is empty and may not be useful for some people. varchar(200)
alias_id The alias number for the provider in the activity data. For example, the NPI number. varchar(200)
alias_type The type of the alias, for example, NPI, DEA, TAX, SL, EXTERNAL, UPIN, or EI. varchar(30)
assigning_authority The assigning authority for the alias type. varchar(200)
modification_type Not applicable varchar(30)
modification_type_key The data model or source that contributed to the last modification. varchar(200)
provider_id The unique ID of the provider. varchar(36)

PH_D_Provider_Address

Field Definition Data Type
country The country where the provider’s address is located. varchar(200)
county The county of the provider’s address. varchar(200)
locality The city of the provider’s address. varchar(200)
modification_type The type of modification that occurred for the provider record. varchar(30)
modification_type_key The data model or source that contributed to the last modification. varchar(200)
postal_code The postal or ZIP Code of the provider’s address. varchar(20)
primary_ind Indicates whether the address is the primary address. boolean
provider_id The unique ID of the provider. varchar(36)
region The state of the provider’s address. varchar(200)
street_address The street address of the provider. varchar(300)

PH_D_Provider_Email

Field Definition Data Type
email_value The provider email. varchar(200)
modification_type The type of modification that occurred for the provider record. varchar(30)
modification_type_key The data model or source that contributed to the last modification. varchar(200)
primary_ind Indicates whether the email is the primary email. boolean
provider_id The unique ID of the provider. varchar(36)

PH_D_Provider_Telecom

Field Definition Data Type
modification_type The type of modification that occurred for the provider record. varchar(30)
modification_type_key The data model or source that contributed to the last modification. varchar(200)
phone_number The preferred phone number of the person. varchar(50)
phone_type The type of phone number, for example, home, business, or mobile. varchar(200)
primary_ind Indicates whether the telecom is the primary telecom. boolean
provider_id The unique ID of the provider. varchar(36)