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