practitioner_role
The US Core PractitionerRole Profile inherits from the FHIR [PractitionerRole](https://hl7.org/fhir/R4/practitionerrole.html) resource; refer to it for scope and usage definitions.
The US Core PractitionerRole Profile inherits from the FHIR PractitionerRole resource; refer to it for scope and usage definitions. This profile sets minimum expectations for the PractitionerRole Resource to record, search, and fetch the practitioner role information. It specifies which core elements, extensions, vocabularies, and value sets SHALL be present and constrains how the elements are used. Providing the floor for standards development for specific use cases promotes interoperability and adoption. The requirements for the US Core Practitioner were drawn from the Argonaut Provider Directory, IHE Healthcare Provider Directory and the ONC Provider Directory Workshop.
Source
| Model | Leg | Role |
|---|
us-core-practitionerrole | FHIR | defines this table |
openEHR-EHR-CLUSTER.electronic_communication.v1 | openEHR | merged in — Electronic communication |
This table is the union of 2 source models. Columns carrying a From value came from a model that merged into it, so the same row satisfies both specifications.
Columns
| Column | Type | Null | Description | From | Source |
|---|
id | uuid primary key | no | PractitionerRole.id | — | — |
created_at | timestamptz | no | Row creation timestamp. | — | — |
updated_at | timestamptz | no | Row update timestamp; maintained by the application. | — | — |
created_by | text | no | Actor who created the row. | — | — |
updated_by | text | no | Actor who last updated the row. | — | — |
practitioner_id | uuid | yes | Practitioner that is able to provide the defined services for the organization | — | PractitionerRole.practitioner |
organization_id | uuid | yes | Organization where the roles are available | — | PractitionerRole.organization |
phone_number
phone_use_code
email
email_use_code | text, text, text, text
text, text, text, text | yes | Contact details that are specific to the role/location/service | — | PractitionerRole.telecom |
phone_comment
email_comment | text, text
text, text | yes | Comment | openEHR-EHR-CLUSTER.electronic_communication.v1 | /items[at0004] |
References
Referenced by
Indexes
practitioner_role_practitioner_id_idx on practitioner_idpractitioner_role_organization_id_idx on organization_id
Child tables
4 tables hang off practitioner_role, one row per repetition.
practitioner_role_code
Child table — one row per repetition, deleted with its parent.
| Column | Type | Null | Description | From | Source |
|---|
id | uuid primary key | no | Primary key. | — | — |
practitioner_role_id | uuid → practitioner_role | no | — | — | — |
code
code_code
code_system
code_valueset_id | coded text
text, text, text, text | yes | Roles which this practitioner may perform | — | PractitionerRole.code |
Constraints
check ((code is null and code_code is null and code_system is null and code_valueset_id is null) or (code is not null and code_code is not null and code_system is not null and code_valueset_id is not null))
References
Indexes
practitioner_role_code_practitioner_role_id_idx on practitioner_role_id
practitioner_role_specialty
Child table — one row per repetition, deleted with its parent.
| Column | Type | Null | Description | From | Source |
|---|
id | uuid primary key | no | Primary key. | — | — |
practitioner_role_id | uuid → practitioner_role | no | — | — | — |
specialty
specialty_code
specialty_system
specialty_valueset_id | coded text
text, text, text, text | yes | Specific specialty of the practitioner | — | PractitionerRole.specialty |
Constraints
check ((specialty is null and specialty_code is null and specialty_system is null and specialty_valueset_id is null) or (specialty is not null and specialty_code is not null and specialty_system is not null and specialty_valueset_id is not null))
References
| Columns | Target | On delete |
|---|
practitioner_role_id | practitioner_role | cascade |
specialty_valueset_id, specialty_code, specialty_system, specialty | valueset_code | restrict |
Indexes
practitioner_role_specialty_practitioner_role_id_idx on practitioner_role_id
practitioner_role_location
Child table — one row per repetition, deleted with its parent.
| Column | Type | Null | Description | From | Source |
|---|
id | uuid primary key | no | Primary key. | — | — |
practitioner_role_id | uuid → practitioner_role | no | — | — | — |
location_id | uuid | no | The location(s) at which this practitioner provides care | — | PractitionerRole.location |
Unique
practitioner_role_id, location_id
References
Indexes
practitioner_role_location_location_id_idx on location_id
practitioner_role_other_telecom
Child table — one row per repetition, deleted with its parent.
| Column | Type | Null | Description | From | Source |
|---|
id | uuid primary key | no | Primary key. | — | — |
practitioner_role_id | uuid → practitioner_role | no | — | — | — |
system | text | no | — | — | — |
value | text | no | — | — | — |
use_code | text | yes | — | — | — |
rank | integer | yes | — | — | — |
valid_from | timestamptz | yes | — | — | — |
valid_until | timestamptz | yes | — | — | — |
comment | text | yes | Comment | openEHR-EHR-CLUSTER.electronic_communication.v1 | /items[at0004] |
References
Indexes
practitioner_role_other_telecom_practitioner_role_id_idx on practitioner_role_id
Value sets
| Value set | Codes |
|---|
http://cts.nlm.nih.gov/fhir/ValueSet/2.16.840.1.113762.1.4.1099.30 | 0 |
http://hl7.org/fhir/us/core/ValueSet/us-core-practitionerrole-specialty | 0 |