onsite_signatures


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_signatures.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 digital signatures used for patient documents and anywhere else a signature is required in the portal

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
status VARCHAR 128 'waiting'
type VARCHAR 128 null

witness-signature
created INT 10 null
lastmod DATETIME 19 null
pid BIGINT 19 √ NULL
patient_data.pid Defined in XML R

The internal patient identifier
encounter INT 10 √ NULL
form_encounter.encounter Defined in XML R
user VARCHAR 255 √ NULL

User who created the esignature. If the signature is a staff member (administrator/witness) it will come from the users.username. If it is a patient signature the value will be ‘-patient-’
activity TINYINT 3 0
authorized TINYINT 3 √ NULL
signator VARCHAR 255 null
sig_image TEXT 65535 √ NULL

The image of the signature as a Data URI created from a browser Canvas object representing an image/png image of the signature
signature TEXT 65535 √ NULL
sig_hash VARCHAR 255 null

sha3-512 hash of the sig_image
ip VARCHAR 46 null
signer Unknown 0 null

If type=witness-signature signer will be ‘Witness Signature’ if type=‘admin-signature’ then signer will be the Username of the clinical staff member that signed, if type=‘patient-signature’ then the value will be the patient’s name

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
encounter Performance Asc encounter
pid Must be unique Asc/Asc pid + user

Relationships

Close relationships within degrees of separation