transactions

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

Represents patient referrals, and transactional records for billing, legal, and requests from the patient or their physician

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

lbf_data.form_id	Defined in XML	R
lbt_data.form_id	Defined in XML	R

date

DATETIME

19

√

NULL

title

VARCHAR

255

''

pid

BIGINT

19

√

NULL

patient_data.pid

Defined in XML

R

The internal patient identifier

user

VARCHAR

255

''

groupname

VARCHAR

255

''

authorized

TINYINT

3

√

NULL

Showing 1 to 7 of 7 entries

Indexes

Search:

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

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees