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

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

Indexes

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

Relationships

Close relationships within degrees of separation