Schema reference / Tables / view MDX source

care_team

The US Core CareTeam Profile inherits from the FHIR [CareTeam](https://hl7.org/fhir/R4/careteam.html) resource; refer to it for scope and usage definitions.

The US Core CareTeam Profile inherits from the FHIR CareTeam resource; refer to it for scope and usage definitions. This profile sets minimum expectations for the CareTeam resource for identifying the Care Team members associated with a patient to promote interoperability and adoption through common implementation. It specifies which core elements, extensions, vocabularies, and value sets SHALL be present in the resource and how the elements are used. Providing the floor for standards development for specific use cases promotes interoperability and adoption.

Source

Model	Leg	Role
`us-core-careteam`	FHIR	defines this table

Columns

Column	Type	Null	Description	Source
`id`	`uuid primary key`	no	CareTeam.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.	—
`status`	`text`	yes	proposed \| active \| suspended \| inactive \| entered-in-error	`CareTeam.status`
`patient_id`	`uuid`	yes	Who care team is for	`CareTeam.subject`

References

Columns	Target	On delete
`patient_id`	`patient`	no action

Referenced by

care_team_participant via care_team_id
care_team_participant via member_care_team_id

Indexes

care_team_patient_id_idx on patient_id

Child tables

1 table hang off care_team, one row per repetition.

`care_team_participant`

Child table — one row per repetition, deleted with its parent.

Column	Type	Null	Description	Source
`id`	`uuid primary key`	no	Primary key.	—
`care_team_id`	`uuid` → `care_team`	no	—	—
`role` `role_code` `role_system` `role_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Type of involvement	`CareTeam.participant.role`
`member_care_team_id` `member_organization_id` `member_patient_id` `member_practitioner_id` `member_practitioner_role_id` `member_related_person_id`	uuid, uuid, uuid, uuid, uuid, uuid `uuid`, `uuid`, `uuid`, `uuid`, `uuid`, `uuid`	yes	Who is involved	`CareTeam.participant.member`

Constraints

check ((role is null and role_code is null and role_system is null and role_valueset_id is null) or (role is not null and role_code is not null and role_system is not null and role_valueset_id is not null))
check (num_nonnulls(member_care_team_id, member_organization_id, member_patient_id, member_practitioner_id, member_practitioner_role_id, member_related_person_id) <= 1)

References

Columns	Target	On delete
`care_team_id`	`care_team`	cascade
`role_valueset_id, role_code, role_system, role`	`valueset_code`	restrict
`member_care_team_id`	`care_team`	no action
`member_organization_id`	`organization`	no action
`member_patient_id`	`patient`	no action
`member_practitioner_id`	`practitioner`	no action
`member_practitioner_role_id`	`practitioner_role`	no action
`member_related_person_id`	`related_person`	no action

Indexes

care_team_participant_care_team_id_idx on care_team_id
care_team_participant_member_care_team_id_idx on member_care_team_id
care_team_participant_member_organization_id_idx on member_organization_id
care_team_participant_member_patient_id_idx on member_patient_id
care_team_participant_member_practitioner_id_idx on member_practitioner_id
care_team_participant_member_practitioner_role_id_idx on member_practitioner_role_id
care_team_participant_member_related_person_id_idx on member_related_person_id

Value sets

Value set	Codes
`http://cts.nlm.nih.gov/fhir/ValueSet/2.16.840.1.113762.1.4.1099.30`	0