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) |