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 Oracle Health Data Intelligence 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. |
