Personnel Analytics Schema v1
Overview
The Personnel Analytics bundle contains attribution data that defines the patient provider relationship.
Character Separated Values (CSV) Properties
Property |
Value |
Header Record |
Yes |
Field Delimiter |
Comma |
Record Delimiter |
CR/LF |
Character Encoding |
UTF-8 |
Files
File Name |
File Description |
PH_F_Attribution |
This table contains relationships between providers and people (members, beneficiaries, or patients), as defined by the attribution algorithm logic. |
PH_D_Personnel |
This table contains all personnel relevant to the activity in HealtheIntent from a client. This includes personnel who use the system, are attributable, are scorable, or are simply members of the client in some way. |
PH_D_Organization_Personnel_Reltn |
This table contains relationships between organizations and personnel. |
PH_D_Organization |
This table contains all client organization information including the organization ID. |
PH_D_Personnel_Personnel_Group_Reltn |
This table contains relationships between personnel and personnel groups. |
Field Definitions
PH_F_Attribution
Fields |
Data Type |
Description |
empi_id |
varchar(200) |
A Cerner-derived unique member identifier that is used across all data sources. |
organization_id |
varchar(200) |
An internal database ID for the organization. |
part_key |
int |
This column is null and will not be of use. |
population_id |
varchar(200) |
The unique identifier of the populations for a client (ex: registries population, EDW population, etc.) |
prsnl_id |
varchar(200) |
An internal database ID. Typically a combo of ministry_prsnl_id and version. |
PH_D_Personnel
Fields |
Data Type |
Description |
active_ind |
boolean |
Active indicator as submitted via the personnel ministry. |
family_name |
varchar(200) |
The family or last name for the patient |
given_name |
varchar(200) |
The given name as submitted via the personnel ministry. |
ministry_prsnl_id |
varchar(200) |
An internal database ID for the personnel. |
part_key |
int |
This column is null and will not be of use. |
prsnl_id |
varchar(200) |
An internal database ID. Typically a combo of ministry_prsnl_id and version. |
prsnl_name |
varchar(200) |
The full name as submitted via the personnel ministry. |
version |
varchar(200) |
An internal identifier to denote which archive this data part lives on. |
PH_D_Organization_Personnel_Reltn
Fields |
Data Type |
Description |
ministry_org_id |
varchar(200) |
An internal database ID for the organization. |
ministry_prsnl_id |
varchar(200) |
An internal database ID for the personnel. |
org_id |
varchar(200) |
An internal database ID. Typically a combo of ministry_org_id and version. |
part_key |
int |
This column is null and will not be of use. |
prsnl_id |
varchar(200) |
An internal database ID. Typically a combo of ministry_prsnl_id and version. |
reltn_type |
varchar(200) |
Type of relationship the personnel has with the organization. |
reltn_type_key |
varchar(200) |
not applicable |
version |
varchar(200) |
An internal identifier to denote which archive this data part lives on. |
PH_D_Organization
Fields |
Data Type |
Description |
ministry_org_id |
varchar(200) |
An internal database ID for the organization. |
org_id |
varchar(200) |
An internal database ID. Typically a combo of ministry_org_id and version. |
org_name |
varchar(200) |
The name of the organization as submitted via the personnel ministry. |
part_key |
int |
This column is null and will not be of use. |
version |
varchar(200) |
An internal identifier to denote which archive this data part lives on. |
PH_D_Personnel_Personnel_Group_Reltn
Fields |
Data Type |
Description |
ministry_prsnl_group_id |
varchar(200) |
An internal database ID for the personnel group. |
ministry_prsnl_id |
varchar(200) |
An internal database ID for the personnel. |
part_key |
int |
This column is null and will not be of use. |
prsnl_group_id |
varchar(200) |
ID of the personnel group related to the personnel. |
prsnl_id |
varchar(200) |
An internal database ID. Typically a combo of ministry_prsnl_id and version. |
version |
varchar(200) |
An internal identifier to denote which archive this data part lives on. |