voids

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 | TEXT | 65535 | √ | | 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