The careteam table is related to the Careteam resource that is available via the FHIR API.
The careteam table represents relationships between a person and a primary care provider (PCP), practice (usually associated with a unique TIN), accountable care organization, or other provider organization. Each person may have zero to many rows in this table.
See also:
Source Concepts
- HIEBus encountercaregiverrelationships (patient level only)
Table Schema
| Name |
Type
|
Description |
| personid |
VARCHAR(38) GUID |
Unique identifier representing a unique person that may include data from several sources that have been linked. This identifier is the person_id of a HIEBus recordgroup.
|
| careteamid |
VARCHAR(38) GUID |
An internal HIEBus identier, encountercaregiverrelationships.id.
|
| startdate |
TIMESTAMP |
|
| enddate |
TIMESTAMP |
|
| identifier |
VARCHAR |
If available, the identifier of the related entity or caregiver. HIEBus caregiver.identifier.
|
| name |
VARCHAR |
The name or last name of the related entity or caregiver. HIEBus caregiver.lastname.
|
| firstname |
VARCHAR |
The first name (if applicable) of the related entity or caregiver. HIEBus caregiver.firstname.
|
| relationshiptype |
VARCHAR |
The type of relationship described by this row. For example, PCP, AttributedACO, AttributedProvider.
|
| relationshipcodetype |
VARCHAR |
|
| relationshiptypetermid |
INTEGER |
|
| organization |
VARCHAR |
HIEBus recordauthority name.
|
| organizationcode |
VARCHAR |
HIEBus recordauthority code.
|
| lastupdated |
TIMESTAMP |
System generated timestamp indicating the most recent change to this data row. Used for differential operations. Managed in UTC.
|
Back to Tables
