pnotes


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 pnotes.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

Patient Messages about the healthcare treatment of the patient

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
date DATETIME 19 √ NULL
body LONGTEXT 2147483647 √ NULL
pid BIGINT 19 √ NULL
patient_data.pid Defined in XML R

The internal patient identifier
user VARCHAR 255 √ NULL
users.id Defined in XML R
groupname VARCHAR 255 √ NULL
groups.name Defined in XML R
activity TINYINT 3 √ NULL
authorized TINYINT 3 √ NULL
title VARCHAR 255 √ NULL
assigned_to VARCHAR 255 √ NULL
users.id Defined in XML R
deleted TINYINT 3 √ 0

flag indicates note is deleted
message_status VARCHAR 20 'New'
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘message_status’ and represents the status of the message
portal_relation VARCHAR 100 √ NULL
is_msg_encrypted TINYINT 3 √ 0

Whether messsage encrypted 0-Not encrypted, 1-Encrypted
update_by BIGINT 19 √ NULL
users.id Defined in XML R
update_date DATETIME 19 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
pid Performance Asc pid

Relationships

Close relationships within degrees of separation