amendments_history


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 amendments_history.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 clinicinan comments regarding an amendment request

Columns

Column Type Size Nulls Auto Default Children Parents Comments
amendment_id Unknown 0 null
amendments.amendment_id Defined in XML R

The internal amendment id

amendment_note Unknown 0 null
list_options.option_id Defined in XML R

Comments regarding the amendment as entered by the creating user. Also contains a human readable description of the amendment status.

amendment_status Unknown 0 null
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘amendment_status’ and represents the current status of the amendment

created_by Unknown 0 null
users.id Defined in XML R

The id of the user that initially created this amendment

created_time Unknown 0 null

Timestamp indicating when the amendment record was created.

Relationships