pro_assessments


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 pro_assessments.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 Patient Reported Outcome assessment results as delivered via the PROMIS assessment delivery system

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
form_oid VARCHAR 255 null

unique id for specific instrument, pulled from assessment center API
form_name VARCHAR 255 null

pulled from assessment center API
user_id INT 10 null
users.id Defined in XML R

ID for user that orders the form
deadline DATETIME 19 null

deadline to complete the form, will be used when sending notification and reminders
patient_id INT 10 null
patient_data.pid Defined in XML R

The internal patient identifier
assessment_oid VARCHAR 255 null

unique id for this specific assessment, pulled from assessment center API
status VARCHAR 255 null

ordered or completed
score DOUBLE 22 null

T-Score for the assessment
error DOUBLE 22 null

Standard error for the score
created_at DATETIME 19 null

timestamp recording the creation time of this assessment
updated_at DATETIME 19 null

this field indicates the completion time when the status is completed

Indexes

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

Relationships

Close relationships within degrees of separation