NAV

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.