onsite_portal_activity


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 onsite_portal_activity.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 portal activity (document submission, and other activities) that requires review before they are accepted into the patient chart

Columns

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

The internal patient identifier
activity VARCHAR 255 √ NULL
require_audit BOOLEAN 3 √ 1
pending_action VARCHAR 255 √ NULL
action_taken VARCHAR 255 √ NULL
status VARCHAR 255 √ NULL
narrative LONGTEXT 2147483647 √ NULL
table_action LONGTEXT 2147483647 √ NULL
table_args LONGTEXT 2147483647 √ NULL
action_user INT 10 √ NULL
action_taken_time DATETIME 19 √ NULL
checksum LONGTEXT 2147483647 √ NULL

Indexes

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

Relationships

Close relationships within degrees of separation