care_team


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of care_team.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Contains the care team records for a patient

Columns

Column Type Size Nulls Auto Default Children Parents Comments
created_by Unknown 0 null
users.id Defined in XML R

The id of the user that initially created this record

pid Unknown 0 null
patient_data.pid Defined in XML R

The internal patient identifier

status Unknown 0 null
list_options.option_id Defined in XML R

fk to list_options.option_id WHERE list_options.list_id=‘Care_Team_Status’

updated_by Unknown 0 null
users.id Defined in XML R

The id of the user that last updated this record

Relationships