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 INT 10 √ null
amendments.amendment_id Defined in XML R

The internal amendment id
amendment_note TEXT 65535 √ 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 VARCHAR 50 √ 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 INT 10 null
users.id Defined in XML R

The id of the user that initially created this amendment
created_time TIMESTAMP 19 √ NULL

Timestamp indicating when the amendment record was created.

Indexes

Constraint Name Type Sort Column(s)
amendment_history_id Performance Asc amendment_id

Relationships

Close relationships within degrees of separation