voids


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

Tracks a voided receipt or checkout for a patient

Columns

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

The internal patient identifier
encounter_id BIGINT 19 0
form_encounter.encounter Defined in XML R

references form_encounter.encounter
what_voided VARCHAR 31 null

checkout,receipt and maybe other options later
date_original DATETIME 19 √ NULL

time of original action that is now voided
date_voided DATETIME 19 null

time of void action
user_id BIGINT 19 null
users.id Defined in XML R

references users.id
amount1 DECIMAL 12,2 0.00

for checkout,receipt total voided adjustments
amount2 DECIMAL 12,2 0.00

for checkout,receipt total voided payments
other_info MEDIUMTEXT 16777215 √ NULL

for checkout,receipt the old invoice refno
reason VARCHAR 31 √ ''
notes VARCHAR 255 √ ''

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc void_id
datevoided Performance Asc date_voided
pidenc Performance Asc/Asc patient_id + encounter_id

Relationships

Close relationships within degrees of separation