openemr.openemr

Columns

Search:

Table	Type	Column	Type	Size	Nullable	Auto	Default	Comments
issue_types	Table	abbreviation	VARCHAR	75			''
procedure_result	Table	abnormal	VARCHAR	31			''	Abnormal values (no, yes, high, low)
form_ros	Table	abnormal_blood	VARCHAR	3	√		NULL
form_ros	Table	abnormal_hair_growth	VARCHAR	3	√		NULL
form_ros	Table	abnormal_mammogram	VARCHAR	3	√		NULL
users	Table	abook_type	VARCHAR	31			''	Address book type for the user.
insurance_data	Table	accept_assignment	VARCHAR	5			'TRUE'
onsite_documents	Table	accept_signed_status	SMALLINT	5			null
facility	Table	accepts_assignment	BOOLEAN	3			0	Indicates if the facility accepts assignment (0-Does not accept assignment, 1-Accepts assignment)
form_misc_billing_options	Table	accident_state	VARCHAR	2	√		NULL
procedure_order	Table	account	VARCHAR	60	√		NULL	The specific name of the facility location associated with the order where the lab work will be sent from. This is typically used for LabCorp orders.
ar_activity	Table	account_code	VARCHAR	15			null	The account code used to categorize or classify this payment activity (e.g., a billing code or account code).
procedure_order	Table	account_facility	INT	10	√		NULL	Facility Location associated with the order where the lab work is being sent from. This is typically used for LabCorp orders.
issue_types	Table	aco_spec	VARCHAR	63			'patients\|med'
openemr_postcalendar_categories	Table	aco_spec	VARCHAR	63			'encounters\|notes'	Access control for the category. Empty on export
form_eye_neuro	Table	ACT	CHAR	3			'on'
form_eye_neuro	Table	ACT10CCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT10CCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT10SCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT10SCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT11CCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT11CCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT11SCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT11SCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT1CCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT1CCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT1SCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT1SCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT2CCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT2CCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT2SCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT2SCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT3CCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT3CCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT3SCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT3SCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT4CCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT4CCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT4SCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT4SCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT5CCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT5CCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT5SCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT5SCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT6CCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT6CCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT6SCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT6SCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT7CCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT7CCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT7SCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT7SCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT8CCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT8CCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT8SCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT8SCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT9CCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT9CCNEAR	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT9SCDIST	TEXT	65535	√		NULL
form_eye_neuro	Table	ACT9SCNEAR	TEXT	65535	√		NULL
onsite_portal_activity	Table	action_taken	VARCHAR	255	√		NULL
onsite_portal_activity	Table	action_taken_time	DATETIME	19	√		NULL
onsite_portal_activity	Table	action_user	INT	10	√		NULL
drugs	Table	active	BOOLEAN	3	√		1	0 = inactive, 1 = active
prescriptions	Table	active	INT	10			1
questionnaire_repository	Table	active	TINYINT	3			1	Indicates if the questionnaire is active (1 for active, 0 for inactive)
issue_types	Table	active	BOOLEAN	3			1
form_track_anything_type	Table	active	Unknown	0			null	1=The element is active and allows for data entry, 0=data entry is disabled and the element is not displayed to the user
patient_reminders	Table	active	BOOLEAN	3			1	1 if active and 0 if not active
users	Table	active	BOOLEAN	3			1	Indicates the user’s activity status (1 for active, 0 for inactive).
procedure_providers	Table	active	BOOLEAN	3			1	Indicates whether the provider is active
form_group_attendance	Table	activity	TINYINT	3	√		NULL	Activity status (1 for active, 0 for inactive)
form_bronchitis	Table	activity	Unknown	0			null	Activity status, 1=form is active, 0=inactive
procedure_type	Table	activity	BOOLEAN	3			1	1=active, 0=inactive
form_soap	Table	activity	TINYINT	3	√		0
form_ankleinjury	Table	activity	Unknown	0			null	Activity status, 1=form is active, 0=inactive
form_vitals	Table	activity	TINYINT	3	√		0
form_eye_base	Table	activity	TINYINT	3	√		NULL
form_reviewofs	Table	activity	TINYINT	3	√		NULL
form_misc_billing_options	Table	activity	TINYINT	3	√		NULL
form_care_plan	Table	activity	TINYINT	3	√		NULL
pnotes	Table	activity	TINYINT	3	√		NULL
form_ros	Table	activity	INT	10			1
onsite_signatures	Table	activity	TINYINT	3			0
onsite_mail	Table	activity	TINYINT	3	√		NULL	Activity associated with the message. 0=deleted, 1=message is active
billing	Table	activity	BOOLEAN	3	√		NULL	Activity status (1 for active, 0 for inactive)
form_functional_cognitive_status	Table	activity	TINYINT	3	√		NULL
form_observation	Table	activity	TINYINT	3	√		NULL
form_eye_mag_dispense	Table	activity	TINYINT	3	√		NULL
procedure_questions	Table	activity	BOOLEAN	3			1	1 = active, 0 = inactive
form_dictation	Table	activity	TINYINT	3	√		NULL
form_clinical_notes	Table	activity	TINYINT	3	√		NULL
form_clinical_instructions	Table	activity	TINYINT	3	√		1
list_options	Table	activity	TINYINT	3			1
form_questionnaire_assessments	Table	activity	TINYINT	3			1
form_aftercare_plan	Table	activity	Unknown	0			null	1 if plan is active, 0 if deleted
onsite_portal_activity	Table	activity	VARCHAR	255	√		NULL
procedure_order	Table	activity	BOOLEAN	3			1	0 if the record is deleted, 1 if the record is active
lists	Table	activity	TINYINT	3	√		NULL	Value of 0 means the record has been deleted, 1 means the record is active in the system
patient_data	Table	ad_reviewed	DATE	10	√		NULL	Date Ad reviewed
form_eye_refraction	Table	ADDCHECKED	VARCHAR	25	√		NULL
immunizations	Table	added_erroneously	BOOLEAN	3			0
form_reviewofs	Table	addison_syndrom	VARCHAR	5	√		NULL
history_data	Table	additional_history	MEDIUMTEXT	16777215	√		NULL
form_dictation	Table	additional_notes	LONGTEXT	2147483647	√		NULL
form_reviewofs	Table	additional_notes	LONGTEXT	2147483647	√		NULL
ar_activity	Table	adj_amount	DECIMAL	12			0.00	The adjustment amount, if any, to account for changes in the payment (in DECIMAL format).
ar_session	Table	adjustment_code	VARCHAR	50			null	Comes from the list_options.list_id=‘payment_adjustment_code’ and represents the payment adjustment code to apply.
immunizations	Table	administered_by	VARCHAR	255	√		NULL	Alternative to administered_by_id
immunizations	Table	administered_by_id	BIGINT	19	√		NULL	The person that administered the immunization
immunizations	Table	administered_date	DATETIME	19	√		NULL
immunizations	Table	administration_site	VARCHAR	100	√		NULL	Comes from the list_options.list_id=‘immunization_administered_site’ and represents the body sites where the immunization can be administered
form_aftercare_plan	Table	admit_date	Unknown	0			null	Date when the patient was admitted to the aftercare plan.
history_data	Table	alcohol	LONGTEXT	2147483647	√		NULL
form_eye_vitals	Table	alert	CHAR	3	√		'yes'
form_ros	Table	allergies	VARCHAR	3	√		NULL
drugs	Table	allow_combining	BOOLEAN	3			0	1 = allow filling an order from multiple lots
patient_data	Table	allow_health_info_ex	VARCHAR	255			''	Allow Health Information Exchange
patient_data	Table	allow_imm_info_share	VARCHAR	255			''	Allow Immunization Information Sharing
patient_data	Table	allow_imm_reg_use	VARCHAR	255			''	Allow Immunization Registry Use
drugs	Table	allow_multiple	BOOLEAN	3			1	1 = allow multiple lots at one warehouse
patient_data	Table	allow_patient_portal	VARCHAR	31			''	Allow Patient Portal
insurance_companies	Table	alt_cms_id	VARCHAR	15	√		NULL
esign_signatures	Table	amendment	MEDIUMTEXT	16777215	√		NULL	Amendment text, if any.
amendments	Table	amendment_by	VARCHAR	50			null	Comes from the list_options.list_id=‘amendment_from’ and represents who is requesting the amendment
amendments	Table	amendment_date	DATE	10			null	The date when the amendment request was made.
amendments	Table	amendment_desc	MEDIUMTEXT	16777215	√		NULL	Detailed information about the amendment, including any additional notes or changes.
amendments_history	Table	amendment_id	Unknown	0			null	The internal amendment id
amendments	Table	amendment_id	INT	10		√	null	Primary key for the amendment record. It uniquely identifies each amendment.
amendments_history	Table	amendment_note	Unknown	0			null	Comments regarding the amendment as entered by the creating user. Also contains a human readable description of the amendment status.
amendments	Table	amendment_status	VARCHAR	50	√		NULL	Comes from the list_options.list_id=‘amendment_status’ and represents the current status of the amendment
amendments_history	Table	amendment_status	Unknown	0			null	Comes from the list_options.list_id=‘amendment_status’ and represents the current status of the amendment
benefit_eligibility	Table	amount	DECIMAL	5	√		NULL	Benefit amount, if applicable
voids	Table	amount1	DECIMAL	12			0.00	for checkout,receipt total voided adjustments
voids	Table	amount2	DECIMAL	12			0.00	for checkout,receipt total voided payments
immunizations	Table	amount_administered	FLOAT	12	√		NULL
immunizations	Table	amount_administered_unit	VARCHAR	50	√		NULL	Comes from the list_options.list_id=‘drug_units’ and represents the units of drug administered
form_eye_vitals	Table	AMSLEROD	SMALLINT	5	√		NULL
form_eye_vitals	Table	AMSLEROS	SMALLINT	5	√		NULL
form_ros	Table	anemia	VARCHAR	3	√		NULL
form_ankleinjury	Table	ankle_able_to_bear_weight_steps	Unknown	0			null	Ability to bear weight and steps information
form_ankleinjury	Table	ankle_additional_diagnosis	Unknown	0			null	Additional diagnosis for the ankle injury
form_ankleinjury	Table	ankle_additional_x_ray_notes	Unknown	0			null	Additional notes related to X-ray
form_ankleinjury	Table	ankle_date_of_injury	Unknown	0			null	Date of the ankle injury
form_ankleinjury	Table	ankle_diagnosis1	Unknown	0			null	Diagnosis 1 for the ankle injury
form_ankleinjury	Table	ankle_diagnosis2	Unknown	0			null	Diagnosis 2 for the ankle injury
form_ankleinjury	Table	ankle_diagnosis3	Unknown	0			null	Diagnosis 3 for the ankle injury
form_ankleinjury	Table	ankle_diagnosis4	Unknown	0			null	Diagnosis 4 for the ankle injury
form_ankleinjury	Table	ankle_foot	Unknown	0			null	Foot information related to the injury
form_ankleinjury	Table	ankle_how_did_injury_occur	Unknown	0			null	Description of how the injury occurred
form_ankleinjury	Table	ankle_onset_of_swelling	Unknown	0			null	Onset of swelling
form_ankleinjury	Table	ankle_ottawa_bone_tenderness	Unknown	0			null	Information about Ottawa bone tenderness
form_ankleinjury	Table	ankle_plan	Unknown	0			null	Recommended treatment plan for the ankle injury
form_reviewofs	Table	ankle_problems	VARCHAR	5	√		NULL
form_ankleinjury	Table	ankle_severity_of_pain	Unknown	0			null	Severity of pain associated with the injury 1-3
form_ankleinjury	Table	ankle_significant_swelling	Unknown	0			null	Indication of significant swelling
form_ankleinjury	Table	ankle_work_related	Unknown	0			null	Work-related information for the injury
form_ankleinjury	Table	ankle_x_ray_interpretation	Unknown	0			null	Interpretation of X-ray results
form_reviewofs	Table	ankylosing_sondlilitis	VARCHAR	5	√		NULL
form_ros	Table	anorexia	VARCHAR	3	√		NULL
procedure_answers	Table	answer	VARCHAR	255			''	answer data
procedure_answers	Table	answer_seq	INT	10			null	Supports multiple-choice questions. Answer_seq, incremented in code
form_eye_antseg	Table	ANTSEG_COMMENTS	TEXT	65535	√		NULL
form_ros	Table	anxiety	VARCHAR	3	√		NULL
form_ros	Table	ap	VARCHAR	3	√		NULL
form_ros	Table	apnea	VARCHAR	3	√		NULL
history_data	Table	appendectomy	DATETIME	19	√		NULL
form_reviewofs	Table	appendectomy	VARCHAR	5	√		NULL
form_groups_encounter	Table	appt_id	INT	10	√		NULL	The calendar appointment id that this encounter is associated with or that this encounter was created from
patient_tracker	Table	apptdate	DATE	10	√		NULL	The appointment date this patient tracker record applies to
patient_tracker	Table	appttime	TIME	10	√		NULL	The appointment time this patient tracker record applies to
form_eye_refraction	Table	ARNEARODVA	VARCHAR	25	√		NULL
form_eye_refraction	Table	ARNEAROSVA	VARCHAR	25	√		NULL
form_eye_refraction	Table	ARODADD	VARCHAR	25	√		NULL
form_eye_refraction	Table	ARODAXIS	VARCHAR	25	√		NULL
form_eye_refraction	Table	ARODCYL	VARCHAR	25	√		NULL
form_eye_refraction	Table	ARODPRISM	VARCHAR	50	√		NULL
form_eye_refraction	Table	ARODSPH	VARCHAR	25	√		NULL
form_eye_acuity	Table	ARODVA	VARCHAR	25	√		NULL
form_eye_refraction	Table	AROSADD	VARCHAR	25	√		NULL
form_eye_refraction	Table	AROSAXIS	VARCHAR	25	√		NULL
form_eye_refraction	Table	AROSCYL	VARCHAR	25	√		NULL
form_eye_refraction	Table	AROSPRISM	VARCHAR	50	√		NULL
form_eye_refraction	Table	AROSSPH	VARCHAR	25	√		NULL
form_eye_acuity	Table	AROSVA	VARCHAR	25	√		NULL
form_ros	Table	arrythmia	VARCHAR	3	√		NULL
form_ros	Table	arthritis	VARCHAR	3	√		NULL
form_soap	Table	assessment	MEDIUMTEXT	16777215	√		NULL
pro_assessments	Table	assessment_oid	VARCHAR	255			null	unique id for this specific assessment, pulled from assessment center API
pnotes	Table	assigned_to	VARCHAR	255	√		NULL
onsite_mail	Table	assigned_to	VARCHAR	255	√		NULL	Assignment information for the message
users	Table	assistant	VARCHAR	255	√		NULL	Name of the user’s assistant or support staff.
form_eye_hpi	Table	ASSOCIATED1	VARCHAR	255	√		NULL
form_eye_hpi	Table	ASSOCIATED2	TEXT	65535	√		NULL
form_eye_hpi	Table	ASSOCIATED3	TEXT	65535	√		NULL
form_ros	Table	asthma	VARCHAR	3	√		NULL
form_eye_postseg	Table	ATROPINE	VARCHAR	25			null
insurance_companies	Table	attn	VARCHAR	255	√		NULL
facility	Table	attn	VARCHAR	65	√		NULL	Attention line for the facility
documents	Table	audit_master_approval_status	TINYINT	3			1	Approval status from audit_master table
documents	Table	audit_master_id	INT	10	√		NULL	ID from the audit_master table
questionnaire_response	Table	audit_user_id	INT	10	√		NULL
onsite_documents	Table	authorize_signed_time	DATETIME	19	√		NULL
form_aftercare_plan	Table	authorized	Unknown	0			null	Indicates authorization status for the aftercare plan.
form_group_attendance	Table	authorized	TINYINT	3	√		NULL	Authorization status (1 for authorized, 0 for unauthorized)
form_vitals	Table	authorized	TINYINT	3	√		0
form_eye_base	Table	authorized	TINYINT	3	√		NULL
form_functional_cognitive_status	Table	authorized	TINYINT	3	√		NULL
billing	Table	authorized	BOOLEAN	3	√		NULL	Authorization status (1 for authorized, 0 for unauthorized)
form_eye_mag_dispense	Table	authorized	TINYINT	3	√		NULL
form_bronchitis	Table	authorized	Unknown	0			null	Authorization flag
form_questionnaire_assessments	Table	authorized	TINYINT	3			0
forms	Table	authorized	TINYINT	3	√		NULL	Authorization status
form_reviewofs	Table	authorized	TINYINT	3	√		NULL
form_clinical_notes	Table	authorized	TINYINT	3	√		NULL
form_dictation	Table	authorized	TINYINT	3	√		NULL
form_misc_billing_options	Table	authorized	TINYINT	3	√		NULL
pnotes	Table	authorized	TINYINT	3	√		NULL
form_care_plan	Table	authorized	TINYINT	3	√		NULL
onsite_signatures	Table	authorized	TINYINT	3	√		NULL
form_observation	Table	authorized	TINYINT	3	√		NULL
form_ankleinjury	Table	authorized	Unknown	0			null	Authorization status
users	Table	authorized	TINYINT	3	√		NULL	Indicates whether the user is authorized (1 for authorized, 0 for unauthorized).
transactions	Table	authorized	TINYINT	3	√		NULL
form_soap	Table	authorized	TINYINT	3	√		0
onsite_mail	Table	authorized	TINYINT	3	√		NULL	Authorization status of the message
onsite_documents	Table	authorized_signature	TEXT	65535	√		NULL
onsite_documents	Table	authorizing_signator	VARCHAR	50			null
form_misc_billing_options	Table	auto_accident	BOOLEAN	3	√		NULL
form_reviewofs	Table	back_problems	VARCHAR	5	√		NULL
form_reviewofs	Table	back_surgery	VARCHAR	5	√		NULL
form_eye_refraction	Table	BALANCED	CHAR	2			null
lists	Table	begdate	DATETIME	19	√		NULL	The beginning date for when this issue occurred as reported by the patient or the provider
form_ros	Table	belching	VARCHAR	3	√		NULL
benefit_eligibility	Table	benefit_type	VARCHAR	255	√		NULL	Type of the benefit, if applicable
billing	Table	bill_date	DATETIME	19	√		NULL	Date when billing moved into the billed status
drug_sales	Table	bill_date	DATETIME	19	√		NULL
billing	Table	bill_process	TINYINT	3			0	Bill process code -1=leave unprocessed,0=open,1=in progress,2=billed
claims	Table	bill_process	TINYINT	3			0	Billing process status. -1=Leave unchanged, 0=Claim is open,1=Processing in progress,2=Billed,3=Error
claims	Table	bill_time	DATETIME	19	√		NULL	Billing time - The datetime this bill was created
billing	Table	billed	BOOLEAN	3	√		NULL	Billing status (1 for billed, 0 for unbilled)
drug_sales	Table	billed	BOOLEAN	3			0	indicates if the sale is posted to accounting
users	Table	billing_facility	MEDIUMTEXT	16777215	√		NULL	Billing facility information for the user.
form_groups_encounter	Table	billing_facility	INT	10			0	ID of the billing facility
form_encounter	Table	billing_facility	INT	10			0
users	Table	billing_facility_id	INT	10			0	Unique identifier for the user’s billing facility.
facility	Table	billing_location	BOOLEAN	3			0	Indicates if it’s a billing location (0-Not a billing location, 1-Billing location)
patient_data	Table	billing_note	MEDIUMTEXT	16777215	√		NULL	Billing notes for the patient
form_groups_encounter	Table	billing_note	TEXT	65535	√		NULL	Notes related to billing for the encounter
form_encounter	Table	billing_note	MEDIUMTEXT	16777215	√		NULL
procedure_order	Table	billing_type	VARCHAR	4	√		NULL	Comes from the list_options.list_id=‘procedure_billing’ and represents the kind billing being used for this procedure order (insurance, self-pay, etc)
users	Table	billname	VARCHAR	255	√		NULL	Billing name for the user.
form_eye_acuity	Table	BINOCVA	VARCHAR	25	√		NULL
form_ros	Table	biopsy	VARCHAR	3	√		NULL
patient_data	Table	birth_fname	MEDIUMTEXT	16777215	√		NULL
patient_data	Table	birth_lname	MEDIUMTEXT	16777215	√		NULL
patient_data	Table	birth_mname	MEDIUMTEXT	16777215	√		NULL
form_reviewofs	Table	bladder_cancer	VARCHAR	5	√		NULL
form_reviewofs	Table	bladder_infections	VARCHAR	5	√		NULL
form_ros	Table	bleeding_problems	VARCHAR	3	√		NULL
form_ros	Table	blind_spots	VARCHAR	3	√		NULL
form_ros	Table	bloating	VARCHAR	3	√		NULL
form_reviewofs	Table	bloody_nose	VARCHAR	5	√		NULL
form_reviewofs	Table	blurred_vision	VARCHAR	5	√		NULL
form_vitals	Table	BMI	DECIMAL	12	√		NULL
form_vitals	Table	BMI_status	VARCHAR	255	√		NULL
onsite_mail	Table	body	LONGTEXT	2147483647	√		NULL	Body of the message
pnotes	Table	body	LONGTEXT	2147483647	√		NULL
procedure_type	Table	body_site	VARCHAR	31			''	Where to do injection, e.g. arm, buttock
form_misc_billing_options	Table	box_14_date_qual	CHAR	3	√		NULL
form_misc_billing_options	Table	box_15_date_qual	CHAR	3	√		NULL
form_vitals	Table	bpd	VARCHAR	40	√		NULL
form_eye_mag_wearing	Table	BPDD	VARCHAR	20	√		NULL
form_eye_mag_dispense	Table	BPDD	VARCHAR	20	√		NULL
form_eye_mag_dispense	Table	BPDN	VARCHAR	20	√		NULL
form_eye_mag_wearing	Table	BPDN	VARCHAR	20	√		NULL
form_vitals	Table	bps	VARCHAR	40	√		NULL
form_ros	Table	breast_discharge	VARCHAR	3	√		NULL
form_ros	Table	breast_mass	VARCHAR	3	√		NULL
form_reviewofs	Table	broken_bones	VARCHAR	5	√		NULL
form_bronchitis	Table	bronchitis_additional_diagnosis	Unknown	0			null	Additional diagnoses for bronchitis
form_bronchitis	Table	bronchitis_date_of_illness	Unknown	0			null	Date of illness for bronchitis
form_bronchitis	Table	bronchitis_diagnostic_tests	Unknown	0			null	Diagnostic tests for bronchitis
form_bronchitis	Table	bronchitis_heart_click	Unknown	0			null	Heart - Click Sound
form_bronchitis	Table	bronchitis_heart_grade	Unknown	0			null	Heart - Grade
form_bronchitis	Table	bronchitis_heart_location	Unknown	0			null	Heart - Location
form_bronchitis	Table	bronchitis_heart_murmur	Unknown	0			null	Heart - Murmur
form_bronchitis	Table	bronchitis_heart_normal	Unknown	0			null	Heart - Normal Exam
form_bronchitis	Table	bronchitis_heart_not_examined	Unknown	0			null	Heart - Not Examined
form_bronchitis	Table	bronchitis_heart_pmi	Unknown	0			null	Heart - PMI (Point of Maximal Impulse)
form_bronchitis	Table	bronchitis_heart_rub	Unknown	0			null	Heart - Rub Sound
form_bronchitis	Table	bronchitis_heart_s3	Unknown	0			null	Heart - S3 Sound
form_bronchitis	Table	bronchitis_heart_s4	Unknown	0			null	Heart - S4 Sound
form_bronchitis	Table	bronchitis_hpi	Unknown	0			null	History of Present Illness for bronchitis
form_bronchitis	Table	bronchitis_lungs_bs_increased	Unknown	0			null	Lungs - Breath Sounds Increased
form_bronchitis	Table	bronchitis_lungs_bs_normal	Unknown	0			null	Lungs - Breath Sounds Normal
form_bronchitis	Table	bronchitis_lungs_bs_reduced	Unknown	0			null	Lungs - Breath Sounds Reduced
form_bronchitis	Table	bronchitis_lungs_crackles_bll	Unknown	0			null	Lungs - Crackles - Both Lower Lobes
form_bronchitis	Table	bronchitis_lungs_crackles_lll	Unknown	0			null	Lungs - Crackles - Left Lower Lobe
form_bronchitis	Table	bronchitis_lungs_crackles_rll	Unknown	0			null	Lungs - Crackles - Right Lower Lobe
form_bronchitis	Table	bronchitis_lungs_normal_exam	Unknown	0			null	Lungs - Normal Exam
form_bronchitis	Table	bronchitis_lungs_not_examined	Unknown	0			null	Lungs - Not Examined
form_bronchitis	Table	bronchitis_lungs_rubs_bll	Unknown	0			null	Lungs - Rubs - Both Lower Lobes
form_bronchitis	Table	bronchitis_lungs_rubs_lll	Unknown	0			null	Lungs - Rubs - Left Lower Lobe
form_bronchitis	Table	bronchitis_lungs_rubs_rll	Unknown	0			null	Lungs - Rubs - Right Lower Lobe
form_bronchitis	Table	bronchitis_lungs_wheezes_bll	Unknown	0			null	Lungs - Wheezes - Both Lower Lobes
form_bronchitis	Table	bronchitis_lungs_wheezes_dll	Unknown	0			null	Lungs - Wheezes - Diffuse
form_bronchitis	Table	bronchitis_lungs_wheezes_lll	Unknown	0			null	Lungs - Wheezes - Left Lower Lobe
form_bronchitis	Table	bronchitis_lungs_wheezes_rll	Unknown	0			null	Lungs - Wheezes - Right Lower Lobe
form_bronchitis	Table	bronchitis_nares_discharge_left	Unknown	0			null	Nares - Discharge Left
form_bronchitis	Table	bronchitis_nares_discharge_right	Unknown	0			null	Nares - Discharge Right
form_bronchitis	Table	bronchitis_nares_normal_left	Unknown	0			null	Nares - Normal Left
form_bronchitis	Table	bronchitis_nares_normal_right	Unknown	0			null	Nares - Normal Right
form_bronchitis	Table	bronchitis_nares_swelling_left	Unknown	0			null	Nares - Swelling Left
form_bronchitis	Table	bronchitis_nares_swelling_right	Unknown	0			null	Nares - Swelling Right
form_bronchitis	Table	bronchitis_no_sinus_tenderness	Unknown	0			null	No sinus tenderness
form_bronchitis	Table	bronchitis_ops_all_reviewed	Unknown	0			null	Operations related to all reviewed
form_bronchitis	Table	bronchitis_ops_appearance	Unknown	0			null	Operations related to appearance
form_bronchitis	Table	bronchitis_ops_chest_pain	Unknown	0			null	Operations related to chest pain
form_bronchitis	Table	bronchitis_ops_cough	Unknown	0			null	Operations related to cough
form_bronchitis	Table	bronchitis_ops_dizziness	Unknown	0			null	Operations related to dizziness
form_bronchitis	Table	bronchitis_ops_dyspnea	Unknown	0			null	Operations related to dyspnea
form_bronchitis	Table	bronchitis_ops_fever	Unknown	0			null	Operations related to fever
form_bronchitis	Table	bronchitis_ops_malaise	Unknown	0			null	Operations related to malaise
form_bronchitis	Table	bronchitis_ops_sputum	Unknown	0			null	Operations related to sputum
form_bronchitis	Table	bronchitis_ops_sweating	Unknown	0			null	Operations related to sweating
form_bronchitis	Table	bronchitis_ops_wheezing	Unknown	0			null	Operations related to wheezing
form_bronchitis	Table	bronchitis_oropharynx_abcess	Unknown	0			null	Oropharynx - Abscess
form_bronchitis	Table	bronchitis_oropharynx_appearance	Unknown	0			null	Oropharynx - Appearance
form_bronchitis	Table	bronchitis_oropharynx_erythema	Unknown	0			null	Oropharynx - Erythema
form_bronchitis	Table	bronchitis_oropharynx_exudate	Unknown	0			null	Oropharynx - Exudate
form_bronchitis	Table	bronchitis_oropharynx_normal	Unknown	0			null	Oropharynx - Normal
form_bronchitis	Table	bronchitis_oropharynx_not_examined	Unknown	0			null	Oropharynx - Not Examined
form_bronchitis	Table	bronchitis_oropharynx_ulcers	Unknown	0			null	Oropharynx - Ulcers
form_bronchitis	Table	bronchitis_review_of_allergies	Unknown	0			null	Review of allergies for bronchitis
form_bronchitis	Table	bronchitis_review_of_fh	Unknown	0			null	Review of family history for bronchitis
form_bronchitis	Table	bronchitis_review_of_medications	Unknown	0			null	Review of medications for bronchitis
form_bronchitis	Table	bronchitis_review_of_pmh	Unknown	0			null	Review of Past Medical History for bronchitis
form_bronchitis	Table	bronchitis_review_of_sh	Unknown	0			null	Review of social history for bronchitis
form_bronchitis	Table	bronchitis_sinus_tenderness_frontal_left	Unknown	0			null	Sinus Tenderness - Frontal Left
form_bronchitis	Table	bronchitis_sinus_tenderness_frontal_right	Unknown	0			null	Sinus Tenderness - Frontal Right
form_bronchitis	Table	bronchitis_sinus_tenderness_maxillary_left	Unknown	0			null	Sinus Tenderness - Maxillary Left
form_bronchitis	Table	bronchitis_sinus_tenderness_maxillary_right	Unknown	0			null	Sinus Tenderness - Maxillary Right
form_bronchitis	Table	bronchitis_sinus_tenderness_not_examined	Unknown	0			null	Sinus Tenderness - Not Examined
form_bronchitis	Table	bronchitis_tms_af_level_left	Unknown	0			null	Tympanic Membrane and Sinus - AF Level Left
form_bronchitis	Table	bronchitis_tms_af_level_right	Unknown	0			null	Tympanic Membrane and Sinus - AF Level Right
form_bronchitis	Table	bronchitis_tms_bulging_left	Unknown	0			null	Tympanic Membrane and Sinus - Bulging Left
form_bronchitis	Table	bronchitis_tms_bulging_right	Unknown	0			null	Tympanic Membrane and Sinus - Bulging Right
form_bronchitis	Table	bronchitis_tms_nares_not_examined	Unknown	0			null	Tympanic Membrane and Sinus - Nares Not Examined
form_bronchitis	Table	bronchitis_tms_normal_left	Unknown	0			null	Tympanic Membrane and Sinus - Normal Left
form_bronchitis	Table	bronchitis_tms_normal_right	Unknown	0			null	Tympanic Membrane and Sinus - Normal Right
form_bronchitis	Table	bronchitis_tms_perforated_left	Unknown	0			null	Tympanic Membrane and Sinus - Perforated Left
form_bronchitis	Table	bronchitis_tms_perforated_right	Unknown	0			null	Tympanic Membrane and Sinus - Perforated Right
form_bronchitis	Table	bronchitis_tms_retracted_left	Unknown	0			null	Tympanic Membrane and Sinus - Retracted Left
form_bronchitis	Table	bronchitis_tms_retracted_right	Unknown	0			null	Tympanic Membrane and Sinus - Retracted Right
form_bronchitis	Table	bronchitis_tms_thickened_left	Unknown	0			null	Tympanic Membrane and Sinus - Thickened Left
form_bronchitis	Table	bronchitis_tms_thickened_right	Unknown	0			null	Tympanic Membrane and Sinus - Thickened Right
form_bronchitis	Table	bronchitis_treatment	Unknown	0			null	Treatment information for bronchitis
form_reviewofs	Table	burning_with_urination	VARCHAR	5	√		NULL
form_eye_neuro	Table	CACCDIST	VARCHAR	20	√		NULL
form_eye_neuro	Table	CACCNEAR	VARCHAR	20	√		NULL
users	Table	cal_ui	TINYINT	3			1	UNUSED
users	Table	calendar	BOOLEAN	3			0	Indicates whether the user appears in the calendar (1 for appears, 0 for doesn’t appear).
form_reviewofs	Table	cardiac_catheterization	VARCHAR	5	√		NULL
form_care_plan	Table	care_plan_type	VARCHAR	30	√		NULL
patient_data	Table	care_team_facility	MEDIUMTEXT	16777215	√		NULL	List of care team facilities where each id is the facility/organization id contained in the facilities.id. Entries are separated by a the pipe \| symbol
patient_history	Table	care_team_facility	TEXT	65535	√		NULL	List of care team facilities where each id is the facility/organization id contained in the facilities.id. Entries are separated by a the pipe \| symbol
patient_history	Table	care_team_provider	TEXT	65535	√		NULL	List of care team providers where each id is the provider id contained in the users.id. Entries are separated by a the pipe \| symbol.
patient_data	Table	care_team_provider	MEDIUMTEXT	16777215	√		NULL	List of care team providers where each id is the provider id contained in the users.id. Entries are separated by a the pipe \| symbol.
patient_data	Table	care_team_status	MEDIUMTEXT	16777215	√		NULL
form_reviewofs	Table	cataract_surgery	VARCHAR	5	√		NULL
history_data	Table	cataract_surgery	DATETIME	19	√		NULL
form_reviewofs	Table	cataracts	VARCHAR	5	√		NULL
issue_types	Table	category	VARCHAR	75			''
form_CAMOS	Table	category	Unknown	0			null	The category that this note is based upon
patient_reminders	Table	category	VARCHAR	31			''	Maps to the category item in the rule_action_item table
rule_patient_data	Table	category	VARCHAR	31			''	Maps to the category item in the rule_action_item table
rule_action_item	Table	category	VARCHAR	31			''	Maps to list_options list rule_action_category
form_CAMOS_subcategory	Table	category_id	Unknown	0			null	The CAMOS category this subcategory is part of.
form_eye_hpi	Table	CC1	VARCHAR	255	√		NULL
form_eye_hpi	Table	CC2	TEXT	65535	√		NULL
form_eye_hpi	Table	CC3	TEXT	65535	√		NULL
form_ros	Table	change_in_vision	VARCHAR	3	√		NULL
form_ros	Table	changed_bowel	VARCHAR	3	√		NULL
billing	Table	chargecat	VARCHAR	31	√		''	Comes from the list_options.list_id=‘chargecats’ and represents the charge category for certain insursers
drug_sales	Table	chargecat	VARCHAR	31	√		''
ar_session	Table	check_date	DATE	10	√		NULL	The date when the check was received for the payment.
onsite_portal_activity	Table	checksum	LONGTEXT	2147483647	√		NULL
form_ros	Table	chest_pain	VARCHAR	3	√		NULL
form_reviewofs	Table	chest_pains	VARCHAR	5	√		NULL
form_ros	Table	chills	VARCHAR	3	√		NULL
form_reviewofs	Table	chills	VARCHAR	5	√		NULL
form_reviewofs	Table	cholecystectomy	VARCHAR	5	√		NULL
history_data	Table	cholecystestomy	DATETIME	19	√		NULL
form_eye_hpi	Table	CHRONIC1	VARCHAR	255	√		NULL
form_eye_hpi	Table	CHRONIC2	VARCHAR	255	√		NULL
form_eye_hpi	Table	CHRONIC3	VARCHAR	255	√		NULL
form_reviewofs	Table	chronic_bronchitis	VARCHAR	5	√		NULL
form_reviewofs	Table	cirrhosis_of_the_liver	VARCHAR	5	√		NULL
users	Table	city	VARCHAR	30	√		NULL	City of residence or practice for the user. EMPTY for exports
patient_data	Table	city	VARCHAR	255			''	City of the patient’s address
facility	Table	city	VARCHAR	255	√		NULL	City where the facility is located
users	Table	city2	VARCHAR	30	√		NULL	Alternative City of residence or practice for the user. EMPTY for exports
insurance_type_codes	Table	claim_type	TEXT	65535	√		NULL
form_encounter	Table	class_code	VARCHAR	10			'AMB'
lists	Table	classification	INT	10	√		0	UNUSED - will be removed in the future
form_aftercare_plan	Table	client_name	Unknown	0			null	Human readable name of the patient for whom the aftercare plan is created.
rule_action_item	Table	clin_rem_link	VARCHAR	255			''	Custom html link in clinical reminder widget
procedure_order	Table	clinical_hx	VARCHAR	255			''	Clinical history text relevant to the order
form_clinical_notes	Table	clinical_notes_category	VARCHAR	100	√		NULL	Comes from the list_options.list_id=‘Clinical_Note_Category’ and represents the main category for this kind of clinical note
form_clinical_notes	Table	clinical_notes_type	VARCHAR	100	√		NULL	Comes from the list_options.list_id=‘Clinical_Note_Type’ and represents the standardized note type for this note
ar_session	Table	closed	BOOLEAN	3			0	A flag indicating if the session is closed. 0 for open, 1 for closed.
insurance_companies	Table	cms_id	VARCHAR	15	√		NULL
patient_data	Table	cmsportal_login	VARCHAR	60			''
form_functional_cognitive_status	Table	code	VARCHAR	255	√		NULL
form_clinical_notes	Table	code	VARCHAR	255	√		NULL
form_care_plan	Table	code	VARCHAR	255	√		NULL
ar_activity	Table	code	VARCHAR	20			null	The code in the code system referenced in code_type that is the main billing code for this billing activity
form_observation	Table	code	VARCHAR	255	√		NULL
form_eye_mag_impplan	Table	code	VARCHAR	50	√		NULL
billing	Table	code	VARCHAR	20	√		NULL	Billing code
questionnaire_repository	Table	code	VARCHAR	255	√		NULL	Code associated with the questionnaire
questionnaire_repository	Table	code_display	TEXT	65535	√		NULL	Display information for the code associated with the questionnaire
billing	Table	code_text	LONGTEXT	2147483647	√		NULL	Text associated with the billing code
form_observation	Table	code_type	VARCHAR	255	√		NULL
ar_activity	Table	code_type	VARCHAR	12			''	The code system that is used for this billing activity
billing	Table	code_type	VARCHAR	15	√		NULL	Type of billing code
form_eye_mag_impplan	Table	codedesc	VARCHAR	255	√		NULL
layout_options	Table	codes	VARCHAR	255			''
list_options	Table	codes	VARCHAR	255			''
form_eye_mag_impplan	Table	codetext	VARCHAR	255	√		NULL
form_care_plan	Table	codetext	MEDIUMTEXT	16777215	√		NULL
form_functional_cognitive_status	Table	codetext	MEDIUMTEXT	16777215	√		NULL
form_clinical_notes	Table	codetext	TEXT	65535	√		NULL
form_eye_mag_impplan	Table	codetype	VARCHAR	50	√		NULL
history_data	Table	coffee	LONGTEXT	2147483647	√		NULL
procedure_order	Table	collector_id	BIGINT	19			0	References users.id, representing the individual that collected the specimen
form_reviewofs	Table	colon_cancer	VARCHAR	5	√		NULL
form_reviewofs	Table	colon_cancer_surgery	VARCHAR	5	√		NULL
form_reviewofs	Table	colonoscopy	VARCHAR	5	√		NULL
facility	Table	color	VARCHAR	7			''	Color code for the facility
form_track_anything_results	Table	comment	Unknown	0			null	UNUSED
form_taskman	Table	COMMENT	VARCHAR	50	√		NULL
form_eye_mag_wearing	Table	COMMENTS	MEDIUMTEXT	16777215	√		NULL
form_misc_billing_options	Table	comments	VARCHAR	255	√		NULL
form_eye_mag_dispense	Table	COMMENTS	MEDIUMTEXT	16777215	√		NULL
procedure_result	Table	comments	MEDIUMTEXT	16777215	√		NULL	Comments from the lab
lists	Table	comments	LONGTEXT	2147483647	√		NULL	Human readable additional notes/comments of the issue
rule_patient_data	Table	complete	VARCHAR	31			''	Maps to list_options list yesno
form_taskman	Table	COMPLETED	VARCHAR	1	√		NULL	1 = completed
patient_data	Table	completed_ad	VARCHAR	3			'NO'	Completed Ad information
form_taskman	Table	COMPLETED_DATE	DATETIME	19	√		NULL
immunizations	Table	completion_status	VARCHAR	50	√		NULL	Comes from the list_options.list_id=‘Immunization_Completion_Status’ and represents the status of the immunization
layout_options	Table	conditions	MEDIUMTEXT	16777215	√		NULL	serialized array of skip conditions
form_eye_vitals	Table	confused	CHAR	3	√		'nml'
form_ros	Table	constipation	VARCHAR	3	√		NULL
drugs	Table	consumable	BOOLEAN	3			0	1 = will not show on the fee sheet
patient_data	Table	contact_relationship	VARCHAR	255			''	Relationship of the contact person
form_CAMOS	Table	content	Unknown	0			null	The actual chart note text that was entered in for the patient
form_eye_hpi	Table	CONTEXT1	VARCHAR	255	√		NULL
form_eye_hpi	Table	CONTEXT2	TEXT	65535	√		NULL
form_eye_hpi	Table	CONTEXT3	TEXT	65535	√		NULL
patient_data	Table	contrastart	DATE	10	√		NULL	Date contraceptives initially used
procedure_order	Table	control_id	VARCHAR	255			''	Control ID sent back from the lab
eligibility_verification	Table	copay	INT	10	√		NULL	Patient copayment amount
insurance_data	Table	copay	VARCHAR	255	√		NULL
form_ros	Table	copd	VARCHAR	3	√		NULL
form_questionnaire_assessments	Table	copyright	TEXT	65535	√		NULL
form_reviewofs	Table	coronary_artery_bypass	VARCHAR	5	√		NULL
documents	Table	couch_docid	VARCHAR	100	√		NULL	CouchDB document ID
documents	Table	couch_revid	VARCHAR	100	√		NULL	CouchDB revision ID
form_ros	Table	cough	VARCHAR	3	√		NULL
history_data	Table	counseling	LONGTEXT	2147483647	√		NULL
form_groups_encounter	Table	counselors	VARCHAR	255	√		NULL	Information about counselors related to the encounter
patient_data	Table	country_code	VARCHAR	255			''	Country code of the patient’s address
facility	Table	country_code	VARCHAR	30			''	Country code of the facility
patient_data	Table	county	VARCHAR	40			''
benefit_eligibility	Table	coverage_level	VARCHAR	255	√		NULL	Coverage level, if specified
benefit_eligibility	Table	coverage_period	VARCHAR	255	√		NULL	Period of coverage
benefit_eligibility	Table	coverage_type	VARCHAR	512	√		NULL	Type of coverage
users	Table	cpoe	BOOLEAN	3	√		NULL	Indicates whether the user has CPOE (Computerized Physician Order Entry) capabilities.
clinical_plans	Table	cqm_2011_flag	BOOLEAN	3	√		NULL	2011 Clinical Quality Measure flag (unable to customize per patient)
clinical_plans	Table	cqm_2014_flag	BOOLEAN	3	√		NULL	2014 Clinical Quality Measure flag (unable to customize per patient)
clinical_plans	Table	cqm_flag	BOOLEAN	3	√		NULL	Clinical Quality Measure flag (unable to customize per patient)
clinical_plans	Table	cqm_measure_group	VARCHAR	10			''	Clinical Quality Measure Group Identifier
insurance_companies	Table	cqm_sop	INT	10	√		NULL	HL7 Source of Payment for eCQMs
form_eye_refraction	Table	CRCOMMENTS	VARCHAR	255	√		NULL
immunizations	Table	create_date	DATETIME	19	√		NULL
onsite_documents	Table	create_date	TIMESTAMP	19			current_timestamp()
eligibility_verification	Table	create_date	DATE	10	√		NULL	Date when the record was created
questionnaire_response	Table	create_time	DATETIME	19	√		current_timestamp()
onsite_signatures	Table	created	INT	10			null
pro_assessments	Table	created_at	DATETIME	19			null	timestamp recording the creation time of this assessment
immunizations	Table	created_by	BIGINT	19	√		NULL	The user that created this record
patient_data	Table	created_by	BIGINT	19	√		NULL	The id of the user that initially created this record
amendments_history	Table	created_by	Unknown	0			null	The id of the user that initially created this amendment
history_data	Table	created_by	BIGINT	19	√		NULL	The user that created this record
lists_medication	Table	created_by	Unknown	0			null	The user that created this record
patient_history	Table	created_by	BIGINT	19	√		NULL	The user that created this record
prescriptions	Table	created_by	BIGINT	19	√		NULL	The id of the user that initially created this record
amendments	Table	created_by	INT	10			null	The id of the user that initially created this amendment
questionnaire_repository	Table	created_date	DATETIME	19	√		current_timestamp()	Date and time when the questionnaire was created
amendments_history	Table	created_time	Unknown	0			null	Timestamp indicating when the amendment record was created.
ar_session	Table	created_time	TIMESTAMP	19			current_timestamp()	The timestamp when the payment record was created.
amendments	Table	created_time	TIMESTAMP	19	√		NULL	Timestamp indicating when the amendment record was created.
questionnaire_response	Table	creator_user_id	INT	10	√		NULL	user id if answers are provider
form_eye_refraction	Table	CRODAXIS	VARCHAR	25	√		NULL
form_eye_refraction	Table	CRODCYL	VARCHAR	25	√		NULL
form_eye_refraction	Table	CRODSPH	VARCHAR	25	√		NULL
form_eye_acuity	Table	CRODVA	VARCHAR	25	√		NULL
form_reviewofs	Table	crohns_disease	VARCHAR	5	√		NULL
form_eye_refraction	Table	CROSAXIS	VARCHAR	25	√		NULL
form_eye_refraction	Table	CROSCYL	VARCHAR	25	√		NULL
form_eye_refraction	Table	CROSSPH	VARCHAR	25	√		NULL
form_eye_acuity	Table	CROSVA	VARCHAR	25	√		NULL
form_eye_refraction	Table	CTL_COMMENTS	TEXT	65535	√		NULL
form_eye_refraction	Table	CTLBRANDOD	VARCHAR	50	√		NULL
form_eye_mag_dispense	Table	CTLBRANDOD	VARCHAR	50	√		NULL
form_eye_refraction	Table	CTLBRANDOS	VARCHAR	50	√		NULL
form_eye_mag_dispense	Table	CTLBRANDOS	VARCHAR	50	√		NULL
form_eye_mag_dispense	Table	CTLMANUFACTUREROD	VARCHAR	25	√		NULL
form_eye_refraction	Table	CTLMANUFACTUREROD	VARCHAR	50	√		NULL
form_eye_refraction	Table	CTLMANUFACTUREROS	VARCHAR	50	√		NULL
form_eye_mag_dispense	Table	CTLMANUFACTUREROS	VARCHAR	25	√		NULL
form_eye_refraction	Table	CTLODADD	VARCHAR	25	√		NULL
form_eye_refraction	Table	CTLODAXIS	VARCHAR	25	√		NULL
form_eye_refraction	Table	CTLODBC	VARCHAR	25	√		NULL
form_eye_refraction	Table	CTLODCYL	VARCHAR	25	√		NULL
form_eye_refraction	Table	CTLODDIAM	VARCHAR	25	√		NULL
form_eye_mag_dispense	Table	CTLODQUANTITY	VARCHAR	255	√		NULL
form_eye_refraction	Table	CTLODSPH	VARCHAR	25	√		NULL
form_eye_acuity	Table	CTLODVA	VARCHAR	25	√		NULL
form_eye_acuity	Table	CTLODVA1	VARCHAR	25	√		NULL
form_eye_refraction	Table	CTLOSADD	VARCHAR	25	√		NULL
form_eye_refraction	Table	CTLOSAXIS	VARCHAR	25	√		NULL
form_eye_refraction	Table	CTLOSBC	VARCHAR	25	√		NULL
form_eye_refraction	Table	CTLOSCYL	VARCHAR	25	√		NULL
form_eye_refraction	Table	CTLOSDIAM	VARCHAR	25	√		NULL
form_eye_mag_dispense	Table	CTLOSQUANTITY	VARCHAR	255	√		NULL
form_eye_refraction	Table	CTLOSSPH	VARCHAR	25	√		NULL
form_eye_acuity	Table	CTLOSVA	VARCHAR	25	√		NULL
form_eye_acuity	Table	CTLOSVA1	VARCHAR	25	√		NULL
form_eye_refraction	Table	CTLSUPPLIEROD	VARCHAR	50	√		NULL
form_eye_mag_dispense	Table	CTLSUPPLIEROD	VARCHAR	25	√		NULL
form_eye_mag_dispense	Table	CTLSUPPLIEROS	VARCHAR	25	√		NULL
form_eye_refraction	Table	CTLSUPPLIEROS	VARCHAR	50	√		NULL
form_reviewofs	Table	cushing_syndrom	VARCHAR	5	√		NULL
rule_action_item	Table	custom_flag	BOOLEAN	3			0	1 indexed to rule_patient_data, 0 indexed within main schema
immunizations	Table	cvx_code	VARCHAR	64	√		NULL
form_eye_postseg	Table	CYCLOGYL	VARCHAR	25			null
form_eye_postseg	Table	CYCLOMYDRIL	VARCHAR	25			null
drugs	Table	cyp_factor	FLOAT	12			0	quantity representing a years supply
form_eye_neuro	Table	DACCDIST	VARCHAR	20	√		NULL
form_eye_neuro	Table	DACCNEAR	VARCHAR	20	√		NULL
form_painmap	Table	data	Unknown	0			null	Data of the patient pain map to overlay ontop of the pain image. Each mapped data element is in the following format x1CoordinatePixels^y1CoordinatePixels^pain1Description}…}.
layout_options	Table	data_type	TINYINT	3			0
layout_options	Table	datacols	TINYINT	3			1
documents	Table	date	DATETIME	19	√		NULL	Date when the document was created
procedure_result	Table	date	DATETIME	19	√		NULL	Lab-provided date specific to this result
onsite_messages	Table	date	DATETIME	19			null	Timestamp of when the message was sent
form_group_attendance	Table	date	DATE	10	√		NULL
insurance_data	Table	date	DATE	10	√		NULL
extended_log	Table	date	DATETIME	19	√		NULL
onsite_mail	Table	date	DATETIME	19	√		NULL	Date and time of the message
form_clinical_notes	Table	date	DATE	10	√		NULL
form_groups_encounter	Table	date	DATETIME	19	√		NULL	Date and time of the encounter
forms	Table	date	DATETIME	19	√		NULL	Date of the form
history_data	Table	date	DATETIME	19	√		NULL
form_care_plan	Table	date	DATETIME	19	√		NULL
form_eye_mag_dispense	Table	date	TIMESTAMP	19			current_timestamp()
form_aftercare_plan	Table	date	Unknown	0			null	Date and time when the aftercare plan was created.
patient_tracker	Table	date	DATETIME	19	√		NULL	The datetime this tracker event was created
notes	Table	date	Unknown	0			null	Date and time the note was created
form_soap	Table	date	DATETIME	19	√		NULL
form_vitals	Table	date	DATETIME	19	√		NULL
form_clinical_instructions	Table	date	TIMESTAMP	19			current_timestamp()
patient_data	Table	date	DATETIME	19	√		NULL	Date related to the patient
form_eye_base	Table	date	DATETIME	19	√		NULL
form_questionnaire_assessments	Table	date	DATETIME	19	√		current_timestamp()
form_functional_cognitive_status	Table	date	DATE	10	√		NULL
pnotes	Table	date	DATETIME	19	√		NULL
form_ankleinjury	Table	date	Unknown	0			null	Date of the evaluation
form_encounter	Table	date	DATETIME	19	√		NULL
form_observation	Table	date	DATETIME	19	√		NULL
form_bronchitis	Table	date	Unknown	0			null	Date when the record was created
billing	Table	date	DATETIME	19	√		NULL	Date associated with the billing record
patient_history	Table	date	DATETIME	19			current_timestamp()
form_dictation	Table	date	DATETIME	19	√		NULL
transactions	Table	date	DATETIME	19	√		NULL
form_reviewofs	Table	date	DATETIME	19	√		NULL
rule_patient_data	Table	date	DATETIME	19	√		NULL
onsite_portal_activity	Table	date	DATETIME	19	√		NULL
form_misc_billing_options	Table	date	DATETIME	19	√		NULL
form_ros	Table	date	DATETIME	19	√		NULL
lists	Table	date	DATETIME	19	√		NULL	Date the issue was created
prescriptions	Table	date_added	DATETIME	19	√		NULL	Datetime the prescriptions was initially created
procedure_order	Table	date_collected	DATETIME	19	√		NULL	Time the specimen was collected
procedure_report	Table	date_collected	DATETIME	19	√		NULL	Date and time when the report was collected.
procedure_report	Table	date_collected_tz	VARCHAR	5	√		''	Timezone offset from UTC for the date collected.
patient_reminders	Table	date_created	DATETIME	19	√		NULL
facility	Table	date_created	DATETIME	19			current_timestamp()
users	Table	date_created	DATETIME	19			current_timestamp()
drugs	Table	date_created	DATETIME	19			current_timestamp()
insurance_companies	Table	date_created	DATETIME	19			current_timestamp()
patient_access_onsite	Table	date_created	DATETIME	19			current_timestamp()
procedure_providers	Table	date_created	DATETIME	19			current_timestamp()
form_encounter	Table	date_end	DATETIME	19	√		NULL
procedure_order_code	Table	date_end	DATETIME	19	√		NULL
form_care_plan	Table	date_end	DATETIME	19	√		NULL
insurance_data	Table	date_end	DATE	10	√		NULL
procedure_result	Table	date_end	DATETIME	19	√		NULL	Lab-provided end date specific to this result
form_observation	Table	date_end	DATETIME	19	√		NULL
documents	Table	date_expires	DATETIME	19	√		NULL	Date when the document expires and is no longer available.
patient_reminders	Table	date_inactivated	DATETIME	19	√		NULL
form_misc_billing_options	Table	date_initial_treatment	DATE	10	√		NULL
prescriptions	Table	date_modified	DATETIME	19	√		NULL	Datetime the prescriptions was last modified
procedure_order	Table	date_ordered	DATETIME	19	√		NULL	Date and time the order was placed
voids	Table	date_original	DATETIME	19	√		NULL	time of original action that is now voided
procedure_report	Table	date_report	DATETIME	19	√		NULL	Date and time when the report was generated.
procedure_report	Table	date_report_tz	VARCHAR	5	√		''	Timezone offset from UTC for the date reported.
patient_reminders	Table	date_sent	DATETIME	19	√		NULL
procedure_order	Table	date_transmitted	DATETIME	19	√		NULL	Time of order transmission (null if unsent)
voids	Table	date_voided	DATETIME	19			null	time of void action
esign_signatures	Table	datetime	DATETIME	19			null	Datetime of the signature action.
prescriptions	Table	datetime	DATETIME	19	√		NULL
history_data	Table	dc_father	MEDIUMTEXT	16777215	√		NULL
history_data	Table	dc_mother	MEDIUMTEXT	16777215	√		NULL
history_data	Table	dc_offspring	MEDIUMTEXT	16777215	√		NULL
history_data	Table	dc_siblings	MEDIUMTEXT	16777215	√		NULL
history_data	Table	dc_spouse	MEDIUMTEXT	16777215	√		NULL
pro_assessments	Table	deadline	DATETIME	19			null	deadline to complete the form, will be used when sending notification and reminders
patient_data	Table	deceased_date	DATETIME	19	√		NULL	Date of Decease
patient_data	Table	deceased_reason	VARCHAR	255			''	Reason of Decease
eligibility_verification	Table	deductible	INT	10	√		NULL	Patient deductible amount
eligibility_verification	Table	deductiblemet	enum('Y', 'N')	1	√		'Y'	Indicates whether the deductible has been met (‘Y’ or ‘N’)
layout_options	Table	default_value	VARCHAR	255			''
users	Table	default_warehouse	VARCHAR	31			''	Default warehouse for the user.
onsite_mail	Table	delete_date	DATETIME	19	√		NULL	Date and time when the message was deleted
onsite_mail	Table	deleted	TINYINT	3	√		0	Flag indicating whether the mail is deleted
documents	Table	deleted	BOOLEAN	3			0	Flag indicating if the document is deleted (0 or 1). If a file has been marked as deleted the underlying file stored in the file storage system is NOT included in data exports and is no longer available for retrieval
ar_activity	Table	deleted	DATETIME	19	√		NULL	A timestamp (in DATETIME format) indicating when the payment activity was deleted (NULL if active, otherwise when voided).
forms	Table	deleted	TINYINT	3			0	Flag indicating if the form has been deleted
pnotes	Table	deleted	TINYINT	3	√		0	flag indicates note is deleted
form_ros	Table	dementia	VARCHAR	3	√		NULL
onsite_documents	Table	denial_reason	VARCHAR	255			null
ar_session	Table	deposit_date	DATE	10	√		NULL	The date when the payment was deposited.
form_reviewofs	Table	depressed	VARCHAR	5	√		NULL
form_ros	Table	depression	VARCHAR	3	√		NULL
form_track_anything_type	Table	description	Unknown	0			null	Description of the data element type being tracked
form_clinical_notes	Table	description	TEXT	65535	√		NULL
form_functional_cognitive_status	Table	description	MEDIUMTEXT	16777215	√		NULL
ar_session	Table	description	MEDIUMTEXT	16777215	√		NULL	Additional description or notes related to the payment.
procedure_type	Table	description	VARCHAR	255			''	Descriptive text for procedure_code
form_observation	Table	description	VARCHAR	255	√		NULL
form_care_plan	Table	description	MEDIUMTEXT	16777215	√		NULL
extended_log	Table	description	LONGTEXT	2147483647	√		NULL
layout_options	Table	description	MEDIUMTEXT	16777215	√		NULL
lists	Table	destination	VARCHAR	255	√		NULL	Human readable name of GP, Secondary care specialist, etc.
form_ros	Table	diabetes	VARCHAR	3	√		NULL
procedure_order_code	Table	diagnoses	MEDIUMTEXT	16777215	√		NULL	diagnoses and maybe other coding (e.g. ICD9:111.11)
lists	Table	diagnosis	VARCHAR	255	√		NULL	The diagnosis of the issue. Format is a text string in the format of ‘system:code;system:code2;system:coden’
form_physical_exam	Table	diagnosis	Unknown	0			null
form_bronchitis	Table	diagnosis1_bronchitis_form	Unknown	0			null	Diagnosis 1 for bronchitis form
form_bronchitis	Table	diagnosis2_bronchitis_form	Unknown	0			null	Diagnosis 2 for bronchitis form
form_bronchitis	Table	diagnosis3_bronchitis_form	Unknown	0			null	Diagnosis 3 for bronchitis form
form_bronchitis	Table	diagnosis4_bronchitis_form	Unknown	0			null	Diagnosis 4 for bronchitis form
form_ros	Table	diarrhea	VARCHAR	3	√		NULL
form_dictation	Table	dictation	LONGTEXT	2147483647	√		NULL
form_eye_postseg	Table	DIL_MEDS	MEDIUMTEXT	16777215	√		NULL
form_eye_postseg	Table	DIL_RISKS	CHAR	2			'on'
form_eye_antseg	Table	DIMODPUPILREACTIVITY	VARCHAR	25	√		NULL
form_eye_antseg	Table	DIMODPUPILSIZE1	VARCHAR	25	√		NULL
form_eye_antseg	Table	DIMODPUPILSIZE2	VARCHAR	25	√		NULL
form_eye_antseg	Table	DIMOSPUPILREACTIVITY	VARCHAR	25	√		NULL
form_eye_antseg	Table	DIMOSPUPILSIZE1	VARCHAR	25	√		NULL
form_eye_antseg	Table	DIMOSPUPILSIZE2	VARCHAR	25	√		NULL
procedure_providers	Table	direction	CHAR	1			'B'	Bidirectional or Results-only. Empty on Export
form_ros	Table	discharge	VARCHAR	3	√		NULL
form_encounter	Table	discharge_disposition	VARCHAR	100	√		NULL
form_reviewofs	Table	discharge_from_urethra	VARCHAR	5	√		NULL
form_aftercare_plan	Table	discharged	Unknown	0			null	Date when the patient was discharged from the aftercare plan.
drugs	Table	dispensable	BOOLEAN	3			1	0 = pharmacy elsewhere, 1 = dispensed here
drug_sales	Table	distributor_id	BIGINT	19			0	UNUSED - will be removed in the future
form_eye_neuro	Table	DIVERGENCEAMPS	TEXT	65535	√		NULL
form_reviewofs	Table	divirticulitis	VARCHAR	5	√		NULL
form_reviewofs	Table	divirticulitis_surgery	VARCHAR	5	√		NULL
procedure_order_code	Table	do_not_send	BOOLEAN	3			0	0 = normal, 1 = do not transmit to lab
patient_data	Table	DOB	DATE	10	√		NULL	Date of Birth of the patient
form_taskman	Table	DOC_ID	BIGINT	19	√		NULL
form_taskman	Table	DOC_TYPE	VARCHAR	20	√		NULL
onsite_documents	Table	doc_type	VARCHAR	255			null
documents	Table	docdate	DATE	10	√		NULL	Date (YYYY-MM-DD) logically associated with the document, e.g. when a picture was taken.
documents	Table	document_data	LONGTEXT	2147483647	√		NULL	Additional metadata concerning the document is stored here. CCDA/CDA documents store their validation log in this field and DICOM files store a JSON history of actions taken on the DICOM in this field
procedure_result	Table	document_id	BIGINT	19			0	References documents.id if this result is a document
documents	Table	documentationOf	VARCHAR	255	√		NULL	Used for CCDA and lab documents where the individual / contents of the documentation of a service event is recorded
form_ros	Table	doe	VARCHAR	3	√		NULL
facility	Table	domain_identifier	VARCHAR	60	√		NULL	Domain identifier for the facility
procedure_providers	Table	DorP	CHAR	1			'D'	Debugging or Production (MSH-11). Empty on Export
prescriptions	Table	dosage	VARCHAR	100	√		NULL
form_reviewofs	Table	double_vision	VARCHAR	5	√		NULL
form_ros	Table	double_vision	VARCHAR	3	√		NULL
form_ros	Table	dribbling	VARCHAR	3	√		NULL
documents	Table	drive_uuid	BINARY	16	√		NULL	UUID of the document’s drive. Empty in export
patient_data	Table	drivers_license	VARCHAR	255			''	Driver’s license of the patient
prescriptions	Table	drug	VARCHAR	150	√		NULL
drugs	Table	drug_code	VARCHAR	25	√		NULL
prescriptions	Table	drug_dosage_instructions	LONGTEXT	2147483647	√		NULL	Medication dosage instructions
lists_medication	Table	drug_dosage_instructions	LONGTEXT	2147483647	√		NULL	Free text dosage instructions for taking the drug
drugs	Table	drug_id	INT	10		√	null
prescriptions	Table	drug_id	INT	10			0	The id of the drug that was prescribed to the patient. 0 if the drug was manually entered
drug_sales	Table	drug_id	INT	10			null	The id of the drug that was sold to the patient. 0 if the record is not dispensed to a patient
prescriptions	Table	drug_info_erx	MEDIUMTEXT	16777215	√		NULL
patient_tracker	Table	drug_screen_completed	BOOLEAN	3			0	Tracks if the patient has completed a drug screening. 0 if no, 1, if they have completed a drug screening
form_reviewofs	Table	dry_mouth	VARCHAR	5	√		NULL
patient_reminders	Table	due_status	VARCHAR	31			''	Maps to list_options list rule_reminder_due_opt
patient_data	Table	dupscore	INT	10			-9
form_eye_hpi	Table	DURATION1	VARCHAR	255	√		NULL
form_eye_hpi	Table	DURATION2	TEXT	65535	√		NULL
form_eye_hpi	Table	DURATION3	TEXT	65535	√		NULL
form_ros	Table	dysphagia	VARCHAR	3	√		NULL
form_ros	Table	dysuria	VARCHAR	3	√		NULL
form_ros	Table	edema	VARCHAR	3	√		NULL
layout_options	Table	edit_options	VARCHAR	36			''
list_options	Table	edit_options	BOOLEAN	3			1
immunizations	Table	education_date	DATE	10	√		NULL
external_encounters	Table	ee_date	DATE	10	√		NULL
external_encounters	Table	ee_encounter_diagnosis	VARCHAR	255	√		NULL
external_encounters	Table	ee_external_id	VARCHAR	255	√		NULL
external_encounters	Table	ee_facility_id	VARCHAR	255	√		NULL
external_encounters	Table	ee_id	INT	10		√	null
external_encounters	Table	ee_pid	INT	10	√		NULL	The internal patient identifier
external_encounters	Table	ee_provider_id	VARCHAR	255	√		NULL
patient_tracker	Table	eid	BIGINT	19			0	The calendar appointment id
form_ros	Table	ejaculations	VARCHAR	3	√		NULL
form_reviewofs	Table	elbow_problems	VARCHAR	5	√		NULL
eligibility_verification	Table	eligibility_check_date	DATETIME	19	√		NULL	Date and time when the eligibility check was performed
insurance_companies	Table	eligibility_id	VARCHAR	32	√		NULL
patient_data	Table	email	VARCHAR	255			''	Email address of the patient
facility	Table	email	VARCHAR	255	√		NULL	Email address of the facility
pharmacies	Table	email	VARCHAR	255	√		NULL
users	Table	email	VARCHAR	255	√		NULL	Email address associated with the user’s account. EMPTY for exports
users	Table	email_direct	VARCHAR	255			''	Trusted Direct email address for the user.
patient_data	Table	email_direct	VARCHAR	255			''	Trusted Direct email address of the patient
patient_reminders	Table	email_status	BOOLEAN	3			0	0 if not sent and 1 if sent
form_reviewofs	Table	emphysema	VARCHAR	5	√		NULL
form_misc_billing_options	Table	employment_related	BOOLEAN	3	√		NULL
form_taskman	Table	ENC_ID	BIGINT	19	√		NULL
form_clinical_notes	Table	encounter	VARCHAR	255	√		NULL
form_eye_mag_dispense	Table	encounter	BIGINT	19	√		NULL
form_observation	Table	encounter	VARCHAR	255	√		NULL
issue_encounter	Table	encounter	Unknown	0			null	References form_encounter.encounter, representing the encounter that is connected to the issue
form_care_plan	Table	encounter	VARCHAR	255	√		NULL
questionnaire_response	Table	encounter	INT	10	√		NULL	May or may not be associated with an encounter
form_clinical_instructions	Table	encounter	VARCHAR	255	√		NULL
forms	Table	encounter	BIGINT	19	√		NULL	ID of the associated encounter
billing	Table	encounter	INT	10	√		NULL	The encounter that this billing record is connected to
ar_activity	Table	encounter	INT	10			null	The identifier for the encounter for which the payment is connected to (foreign key reference to the forms_encounter.encounter).
onsite_signatures	Table	encounter	INT	10	√		NULL
patient_tracker	Table	encounter	BIGINT	19			0	The encounter the patient appointment is connected to
onsite_documents	Table	encounter	INT UNSIGNED	10	√		NULL
shared_attributes	Table	encounter	BIGINT	19			null	0 if patient attribute, else this is an encounter attribute and references the form_encounter.encounter property
form_encounter	Table	encounter	BIGINT	19	√		NULL
drug_sales	Table	encounter	INT	10			0	The patient encounter which resulted in this drug being sold to the patient.
prescriptions	Table	encounter	INT	10	√		NULL
form_functional_cognitive_status	Table	encounter	VARCHAR	255	√		NULL
form_eye_mag_wearing	Table	ENCOUNTER	INT	10			null
form_groups_encounter	Table	encounter	BIGINT	19	√		NULL
documents	Table	encounter_check	BOOLEAN	3			0	If an encounter is created while tagging (0 or 1)
voids	Table	encounter_id	BIGINT	19			0	references form_encounter.encounter
documents	Table	encounter_id	BIGINT	19			0	Encounter ID if tagged
claims	Table	encounter_id	INT	10			null	Encounter identifier - Identifier for the patient encounter associated with the claim
form_group_attendance	Table	encounter_id	INT	10	√		NULL	The group encounter that this group attendance form is part of
procedure_order	Table	encounter_id	BIGINT	19			0	References form_encounter.encounter, representing the encounter for the order
form_encounter	Table	encounter_type_code	VARCHAR	31	√		NULL
form_encounter	Table	encounter_type_description	MEDIUMTEXT	16777215	√		NULL
documents	Table	encrypted	TINYINT	3			0	Encryption status (0->No, 1->Yes)
benefit_eligibility	Table	end_date	DATE	10	√		NULL	End date for the benefit coverage
prescriptions	Table	end_date	DATE	10	√		NULL
lists	Table	enddate	DATETIME	19	√		NULL	The end date for when this issue occurred as reported by the patient or the provider
form_reviewofs	Table	endoscopy	VARCHAR	5	√		NULL
external_procedures	Table	ep_code	VARCHAR	9	√		NULL
external_procedures	Table	ep_code_text	LONGTEXT	2147483647	√		NULL
external_procedures	Table	ep_code_type	VARCHAR	20	√		NULL
external_procedures	Table	ep_date	DATE	10	√		NULL
external_procedures	Table	ep_encounter	INT	10	√		NULL	The encounter for the external procedure
external_procedures	Table	ep_external_id	VARCHAR	255	√		NULL
external_procedures	Table	ep_facility_id	VARCHAR	255	√		NULL
external_procedures	Table	ep_id	INT	10		√	null
external_procedures	Table	ep_pid	INT	10	√		NULL	The internal patient identifier
form_misc_billing_options	Table	epsdt_flag	BOOLEAN	3	√		NULL
form_ros	Table	erections	VARCHAR	3	√		NULL
pro_assessments	Table	error	DOUBLE	22			null	Standard error for the score
questionnaire_response	Table	error	DOUBLE	22	√		NULL	Standard error for the T-Score
prescriptions	Table	erx_source	TINYINT	3			0	0-OpenEMR 1-External
lists	Table	erx_source	enum('0', '1')	1			'0'	O if the allergy issue originated in OpenEMR, 1 if the allergy issue originated in an external system
prescriptions	Table	erx_uploaded	TINYINT	3			0	0-Pending NewCrop upload 1-Uploaded to NewCrop
lists	Table	erx_uploaded	enum('0', '1')	1			'0'	O if allergy is still waiting to be uploaded to an external system (such as eRX), 1 if the allergy issue has been successfully received by the eRX system
patient_data	Table	ethnicity	VARCHAR	255			''	Ethnicity of the patient
patient_data	Table	ethnoracial	VARCHAR	255			''	Ethnicity/Race information of the patient
extended_log	Table	event	VARCHAR	255	√		NULL
history_data	Table	exams	MEDIUMTEXT	16777215	√		NULL
form_ros	Table	excessive_tearing	VARCHAR	3	√		NULL
history_data	Table	exercise_patterns	LONGTEXT	2147483647	√		NULL
immunizations	Table	expiration_date	DATE	10	√		NULL
form_reviewofs	Table	exposure_to_foreign_countries	VARCHAR	5	√		NULL
form_eye_external	Table	EXT_COMMENTS	TEXT	65535	√		NULL
lists	Table	external_allergyid	INT	10	√		NULL	An identifier for an allergy from an external eRx system
form_clinical_notes	Table	external_id	VARCHAR	30	√		NULL
form_encounter	Table	external_id	VARCHAR	20	√		NULL
form_vitals	Table	external_id	VARCHAR	20	√		NULL
immunizations	Table	external_id	VARCHAR	20	√		NULL
procedure_order	Table	external_id	VARCHAR	20	√		NULL	External identifier
billing	Table	external_id	VARCHAR	20	√		NULL	External identifier associated with billing
lists	Table	external_id	VARCHAR	20	√		NULL	UNUSED - will be removed in the future
prescriptions	Table	external_id	VARCHAR	20	√		NULL
form_functional_cognitive_status	Table	external_id	VARCHAR	30	√		NULL
form_care_plan	Table	external_id	VARCHAR	30	√		NULL
form_groups_encounter	Table	external_id	VARCHAR	20	√		NULL	External ID associated with the encounter
facility	Table	extra_validation	BOOLEAN	3			1	Extra validation indicator (0-No extra validation, 1-Extra validation)
lists	Table	extrainfo	VARCHAR	255	√		NULL	UNUSED - will be removed in the future
form_ros	Table	eye_pain	VARCHAR	3	√		NULL
form_ros	Table	f_flow	VARCHAR	3	√		NULL
form_ros	Table	f_frequency	VARCHAR	3	√		NULL
form_ros	Table	f_hirsutism	VARCHAR	3	√		NULL
form_ros	Table	f_symptoms	VARCHAR	3	√		NULL
procedure_result	Table	facility	VARCHAR	255			''	Lab-provided testing facility ID
form_encounter	Table	facility	LONGTEXT	2147483647	√		NULL
form_groups_encounter	Table	facility	LONGTEXT	2147483647	√		NULL	The facility or location of the encounter
users	Table	facility	VARCHAR	255	√		NULL	The facility where the user is associated.
onsite_documents	Table	facility	INT UNSIGNED	10	√		NULL
facility	Table	facility_code	VARCHAR	31	√		NULL	Facility code for the facility
users	Table	facility_id	INT	10			0	Unique identifier for the user’s associated facility.
form_groups_encounter	Table	facility_id	INT	10			0	Unique identifier for the billing facility that will be used for this encounter.
form_encounter	Table	facility_id	INT	10			0
facility	Table	facility_npi	VARCHAR	15	√		NULL	NPI (National Provider Identifier) for the facility
facility	Table	facility_taxonomy	VARCHAR	15	√		NULL	Taxonomy code for the facility
patient_data	Table	family_size	VARCHAR	255			''	Family size information of the patient
form_ros	Table	fatigue	VARCHAR	3	√		NULL
form_reviewofs	Table	fatigued	VARCHAR	5	√		NULL
facility	Table	fax	VARCHAR	30	√		NULL	Fax number of the facility
users	Table	fax	VARCHAR	30	√		NULL	Fax number for the user. EMPTY for exports
facility	Table	federal_ein	VARCHAR	15	√		NULL	Federal Employer Identification Number of the facility
users	Table	federaldrugid	VARCHAR	255	√		NULL	Federal Drug ID associated with the user.
users	Table	federaltaxid	VARCHAR	255	√		NULL	Federal Tax ID associated with the user.
drug_sales	Table	fee	DECIMAL	12			0.00	The total price of the sale for the drug that was sold to the patient
ar_activity	Table	fee	Unknown	0			null	The billing fee that is being requested for payment of services rendered
billing	Table	fee	DECIMAL	12	√		NULL	Fee associated with billing
form_reviewofs	Table	fever	VARCHAR	5	√		NULL
form_ros	Table	fever	VARCHAR	3	√		NULL
form_ros	Table	fh_blood_problems	VARCHAR	3	√		NULL
shared_attributes	Table	field_id	VARCHAR	31			null	references layout_options.field_id and is the unique property name of this shared attribute
lbt_data	Table	field_id	VARCHAR	31			null	references layout_options.field_id
layout_options	Table	field_id	VARCHAR	31			''
lbf_data	Table	field_id	VARCHAR	31			null	references layout_options.field_id
shared_attributes	Table	field_value	MEDIUMTEXT	16777215	√		NULL
lbt_data	Table	field_value	MEDIUMTEXT	16777215	√		NULL
lbf_data	Table	field_value	LONGTEXT	2147483647	√		NULL
onsite_documents	Table	file_name	VARCHAR	255			null
onsite_documents	Table	file_path	VARCHAR	255			null
prescriptions	Table	filled_by_id	INT	10	√		NULL	UNUSED - will be removed in the future
prescriptions	Table	filled_date	DATE	10	√		NULL
patient_data	Table	financial	VARCHAR	255			''	Financial information of the patient
patient_data	Table	financial_review	DATETIME	19	√		NULL	Financial review date
patient_data	Table	fitness	INT	10			0	The sport team Fitness level assigned to this patient
form_ros	Table	flatulence	VARCHAR	3	√		NULL
layout_options	Table	fld_length	INT	10			15
layout_options	Table	fld_rows	INT	10			0
procedure_questions	Table	fldtype	CHAR	1			'T'	Text, Number, Select, Multiselect, Date, Gestational-age
form_ros	Table	fms	VARCHAR	3	√		NULL
users	Table	fname	VARCHAR	255	√		NULL	First name of the user.
patient_data	Table	fname	VARCHAR	255			''	First name of the patient
ar_activity	Table	follow_up	CHAR	1			null	A flag (CHAR) indicating follow-up actions needed for this payment activity (e.g., ‘y’ for yes, ‘n’ for no).
ar_activity	Table	follow_up_note	MEDIUMTEXT	16777215	√		NULL	Additional notes or instructions related to follow-up actions for this payment activity (in TEXT format).
form_ros	Table	food_intolerance	VARCHAR	3	√		NULL
form_reviewofs	Table	foot_problems	VARCHAR	5	√		NULL
issue_types	Table	force_show	SMALLINT	5			0
notes	Table	foreign_id	Unknown	0			null	The documents.id key for the document this note is connected to
documents	Table	foreign_id	BIGINT	19	√		NULL	The internal patient identifier
documents	Table	foreign_reference_id	BIGINT	19	√		NULL	DB Unique identifier reference to another table record in the database. This is not unique in the document. The table that this record points to is in the foreign_reference_table
documents	Table	foreign_reference_table	VARCHAR	40	√		NULL	Table associated with the foreign reference_id will be populated if foreign_reference_id is populated
prescriptions	Table	form	INT	10	√		NULL
drugs	Table	form	VARCHAR	31			'0'
layout_options	Table	form_id	VARCHAR	31			''
form_eye_mag_impplan	Table	form_id	BIGINT	19			null
lbt_data	Table	form_id	BIGINT	19			null	references transactions.id
form_eye_mag_orders	Table	form_id	BIGINT	19			null
lbf_data	Table	form_id	INT	10		√	null	references forms.form_id
form_clinical_notes	Table	form_id	BIGINT	19			null
therapy_groups_participant_attendance	Table	form_id	INT	10			null	The group attendance encounter form that is the container entity used to track this patient’s attendance
form_vital_details	Table	form_id	Unknown	0			null
form_eye_mag_wearing	Table	FORM_ID	SMALLINT	5			null
forms	Table	form_id	BIGINT	19	√		NULL	ID of the specific form instance
pro_assessments	Table	form_name	VARCHAR	255			null	pulled from assessment center API
form_questionnaire_assessments	Table	form_name	VARCHAR	255	√		NULL
forms	Table	form_name	LONGTEXT	2147483647	√		NULL	Name of the form
pro_assessments	Table	form_oid	VARCHAR	255			null	unique id for specific instrument, pulled from assessment center API
questionnaire_response	Table	form_response	LONGTEXT	2147483647	√		NULL	lform answers array json
questionnaire_response	Table	form_score	INT	10	√		NULL	Arithmetic scoring of questionnaires
forms	Table	formdir	LONGTEXT	2147483647	√		NULL	Directory name of where the form exists in the filesystem. Also is the suffix name of the sub-type form that holds the individual form data for this form. The full table name is CONCAT(‘form_’,formdir)
form_physical_exam	Table	forms_id	Unknown	0			null
form_ros	Table	frequency	VARCHAR	3	√		NULL
form_ros	Table	frequent_colds	VARCHAR	3	√		NULL
form_ros	Table	frequent_illness	VARCHAR	3	√		NULL
form_taskman	Table	FROM_ID	BIGINT	19			null
onsite_documents	Table	full_document	MEDIUMBLOB	16777215	√		NULL
form_ros	Table	g	VARCHAR	3	√		NULL
form_reviewofs	Table	gall_stones	VARCHAR	5	√		NULL
form_reviewofs	Table	gastritis	VARCHAR	5	√		NULL
form_ros	Table	gastro_pain	VARCHAR	3	√		NULL
patient_data	Table	gender_identity	MEDIUMTEXT	16777215	√		NULL
patient_data	Table	genericname1	VARCHAR	255			''	Generic name field 1
patient_data	Table	genericname2	VARCHAR	255			''	Generic name field 2
patient_data	Table	genericval1	VARCHAR	255			''	Generic value field 1
patient_data	Table	genericval2	VARCHAR	255			''	Generic value field 2
form_eye_acuity	Table	GLARECOMMENTS	VARCHAR	255	√		NULL
form_eye_acuity	Table	GLAREODVA	VARCHAR	25	√		NULL
form_eye_acuity	Table	GLAREOSVA	VARCHAR	25	√		NULL
form_reviewofs	Table	glaucoma	VARCHAR	5	√		NULL
form_ros	Table	glaucoma_history	VARCHAR	3	√		NULL
ar_session	Table	global_amount	DECIMAL	12			null	The global amount for the payment.
form_aftercare_plan	Table	goal_a_acute_intoxication	Unknown	0			null	1st Goal for Acute Intoxication/Withdrawal.
form_aftercare_plan	Table	goal_a_acute_intoxication_I	Unknown	0			null	2nd Goal for Acute Intoxication/Withdrawal.
form_aftercare_plan	Table	goal_a_acute_intoxication_II	Unknown	0			null	3rd Goal for Acute Intoxication/Withdrawal.
form_aftercare_plan	Table	goal_b_emotional_behavioral_conditions	Unknown	0			null	1st Goal for Emotional/Behavioral Conditions and Complications.
form_aftercare_plan	Table	goal_b_emotional_behavioral_conditions_I	Unknown	0			null	2nd Goal for Emotional/Behavioral Conditions and Complications.
form_aftercare_plan	Table	goal_c_relapse_potential	Unknown	0			null	1st Goal related to Relapse Potential.
form_aftercare_plan	Table	goal_c_relapse_potential_I	Unknown	0			null	2nd Goal related to Relapse Potential.
users	Table	google_signin_email	VARCHAR	255	√		NULL	Email address for Google Sign-In (if applicable). EMPTY for exports
therapy_groups	Table	group_end_date	DATE	10	√		NULL	Represents the date the group should end
therapy_groups	Table	group_guest_counselors	VARCHAR	255	√		NULL	Names of guest counselors participating in the group that do not exist in the users table
form_group_attendance	Table	group_id	INT	10	√		NULL	FK to the therapy group that this attendance form is tracking
therapy_groups_counselors	Table	group_id	INT	10			null
form_groups_encounter	Table	group_id	BIGINT	19	√		NULL	FK to the therapy group that is attending for the encounter service
layout_options	Table	group_id	VARCHAR	31			''
therapy_groups	Table	group_id	INT	10		√	null	Surrogate id of the record used as the primary incrementing key
therapy_groups_participants	Table	group_id	INT	10			null
therapy_groups	Table	group_name	VARCHAR	255			null
therapy_groups	Table	group_notes	TEXT	65535	√		NULL	Notes about the overall therapy group
insurance_data	Table	group_number	VARCHAR	255	√		NULL
therapy_groups	Table	group_participation	TINYINT	3			null	Represents the participant requirements for the group. 1=Mandatory, 2=Optional
therapy_groups_participants	Table	group_patient_comment	TEXT	65535	√		NULL
therapy_groups_participants	Table	group_patient_end	DATE	10	√		NULL
therapy_groups_participants	Table	group_patient_start	DATE	10			null
therapy_groups_participants	Table	group_patient_status	INT	10			null
therapy_groups	Table	group_start_date	DATE	10			null	Represents the date the group should start
therapy_groups	Table	group_status	INT	10			null	Represents the current status of the therapy group. 10=Active, 20=Finished, 30=Canceled
therapy_groups	Table	group_type	TINYINT	3			null	Represents the type of therapy group. 1=Closed, 2=Open, 3=Training
form_vitals	Table	groupname	VARCHAR	255	√		NULL
form_clinical_notes	Table	groupname	VARCHAR	255	√		NULL
billing	Table	groupname	VARCHAR	255	√		NULL	Group name associated with the billing record
pnotes	Table	groupname	VARCHAR	255	√		NULL
form_soap	Table	groupname	VARCHAR	255	√		NULL
lists	Table	groupname	VARCHAR	255	√		NULL	The user group that created or last updated this issue
form_phq9	Table	groupname	Unknown	0			null	The groupname that created this record.
form_painmap	Table	groupname	Unknown	0			null	The groupname that created this record.
form_reviewofs	Table	groupname	VARCHAR	255	√		NULL
onsite_mail	Table	groupname	VARCHAR	255	√		NULL	Name of the group associated with the message
form_treatment_plan	Table	groupname	Unknown	0			null	The groupname that created this record.
form_ankleinjury	Table	groupname	Unknown	0			null	The groupname that created this record.
form_dictation	Table	groupname	VARCHAR	255	√		NULL
form_care_plan	Table	groupname	VARCHAR	255	√		NULL
form_group_attendance	Table	groupname	VARCHAR	255	√		NULL	User Group that the user was part of that created this record (This is not the therapy group)
form_eye_mag_dispense	Table	groupname	VARCHAR	255	√		NULL
form_observation	Table	groupname	VARCHAR	255	√		NULL
form_CAMOS_item	Table	groupname	Unknown	0			null	The groupname that created this record.
form_questionnaire_assessments	Table	groupname	VARCHAR	255	√		NULL	The groupname that created this record.
form_misc_billing_options	Table	groupname	VARCHAR	255	√		NULL
form_sdoh	Table	groupname	Unknown	0			null	The groupname that created this record.
transactions	Table	groupname	VARCHAR	255			''
form_aftercare_plan	Table	groupname	Unknown	0			null	The groupname that created this record.
form_gad7	Table	groupname	Unknown	0			null	The groupname that created this record.
form_bronchitis	Table	groupname	Unknown	0			null	The groupname that created this record.
form_eye_base	Table	groupname	VARCHAR	255	√		NULL
forms	Table	groupname	VARCHAR	255	√		NULL	The groupname that created this record.
form_CAMOS_category	Table	groupname	Unknown	0			null	The groupname that created this record.
form_functional_cognitive_status	Table	groupname	VARCHAR	255	√		NULL
layout_group_properties	Table	grp_aco_spec	VARCHAR	63			''
layout_group_properties	Table	grp_activity	BOOLEAN	3			1
layout_group_properties	Table	grp_columns	INT	10			0
layout_group_properties	Table	grp_diags	VARCHAR	4095			''
layout_group_properties	Table	grp_form_id	VARCHAR	31			null
layout_group_properties	Table	grp_group_id	VARCHAR	31			''	empty when representing the whole form
layout_group_properties	Table	grp_init_open	BOOLEAN	3			0
layout_group_properties	Table	grp_issue_type	VARCHAR	75			''
layout_group_properties	Table	grp_last_update	TIMESTAMP	19	√		NULL
layout_group_properties	Table	grp_mapping	VARCHAR	31			''	the form category
layout_group_properties	Table	grp_products	VARCHAR	4095			''
layout_group_properties	Table	grp_referrals	BOOLEAN	3			0
layout_group_properties	Table	grp_repeats	INT	10			0
layout_group_properties	Table	grp_save_close	BOOLEAN	3			0
layout_group_properties	Table	grp_seq	INT	10			0	optional order within mapping
layout_group_properties	Table	grp_services	VARCHAR	4095			''
layout_group_properties	Table	grp_size	INT	10			0
layout_group_properties	Table	grp_subtitle	VARCHAR	63			''	for display under the title
layout_group_properties	Table	grp_title	VARCHAR	63			''	descriptive name of the form or group
layout_group_properties	Table	grp_unchecked	BOOLEAN	3			0
patient_data	Table	guardianaddress	MEDIUMTEXT	16777215	√		NULL
patient_data	Table	guardiancity	MEDIUMTEXT	16777215	√		NULL
patient_data	Table	guardiancountry	MEDIUMTEXT	16777215	√		NULL
patient_data	Table	guardianemail	MEDIUMTEXT	16777215	√		NULL
patient_data	Table	guardianphone	MEDIUMTEXT	16777215	√		NULL
patient_data	Table	guardianpostalcode	MEDIUMTEXT	16777215	√		NULL
patient_data	Table	guardianrelationship	MEDIUMTEXT	16777215	√		NULL
patient_data	Table	guardiansex	MEDIUMTEXT	16777215	√		NULL
patient_data	Table	guardiansname	MEDIUMTEXT	16777215	√		NULL	Guardian’s name
patient_data	Table	guardianstate	MEDIUMTEXT	16777215	√		NULL
patient_data	Table	guardianworkphone	MEDIUMTEXT	16777215	√		NULL
form_ros	Table	hai_status	VARCHAR	3	√		NULL
form_reviewofs	Table	hand_problems	VARCHAR	5	√		NULL
esign_signatures	Table	hash	VARCHAR	255			null	Hash of signed data. For an individual form_formdir this will be the hash of the string concatenation of all of the column values for the main entry table. For an overall encounter this will be the string concatenation of all individual form records that are connected to the encounter.
documents	Table	hash	VARCHAR	255	√		NULL	Hash value of the document from when it was uploaded
history_data	Table	hazardous_activities	LONGTEXT	2147483647	√		NULL
form_vitals	Table	head_circ	DECIMAL	12	√		NULL	patient head circumference stored in imperial in
form_reviewofs	Table	headaches	VARCHAR	5	√		NULL
onsite_mail	Table	header	VARCHAR	255	√		NULL	Header of the message
form_ros	Table	hearing_loss	VARCHAR	3	√		NULL
form_reviewofs	Table	heart_attack	VARCHAR	5	√		NULL
form_reviewofs	Table	heart_failure	VARCHAR	5	√		NULL
form_ros	Table	heart_problem	VARCHAR	3	√		NULL
history_data	Table	heart_surgery	DATETIME	19	√		NULL
form_reviewofs	Table	heart_transplant	VARCHAR	5	√		NULL
form_ros	Table	heartburn	VARCHAR	3	√		NULL
form_ros	Table	heat_or_cold	VARCHAR	3	√		NULL
form_vitals	Table	height	DECIMAL	12	√		NULL	patient height stored in imperial in
form_ros	Table	hematemesis	VARCHAR	3	√		NULL
form_ros	Table	hematochezia	VARCHAR	3	√		NULL
form_ros	Table	hematuria	VARCHAR	3	√		NULL
form_ros	Table	hemoptsyis	VARCHAR	3	√		NULL
form_reviewofs	Table	hepatitis	VARCHAR	5	√		NULL
form_ros	Table	hepatitis	VARCHAR	3	√		NULL
history_data	Table	hernia_repair	DATETIME	19	√		NULL
form_reviewofs	Table	herniated_disc	VARCHAR	5	√		NULL
form_reviewofs	Table	herpes	VARCHAR	5	√		NULL
form_eye_external	Table	HERTELBASE	VARCHAR	25	√		NULL
form_ros	Table	hesitancy	VARCHAR	3	√		NULL
form_reviewofs	Table	high_blood_pressure	VARCHAR	5	√		NULL
form_reviewofs	Table	hip_problems	VARCHAR	5	√		NULL
history_data	Table	hip_replacement	DATETIME	19	√		NULL
patient_data	Table	hipaa_allowemail	VARCHAR	3			'NO'	HIPAA Allow Email setting
patient_data	Table	hipaa_allowsms	VARCHAR	3			'NO'	HIPAA Allow SMS setting
patient_data	Table	hipaa_mail	VARCHAR	3			''	HIPAA Mail setting
patient_data	Table	hipaa_message	VARCHAR	20			''	HIPAA Message setting
patient_data	Table	hipaa_notice	VARCHAR	3			''	HIPAA Notice setting
patient_data	Table	hipaa_voice	VARCHAR	3			''	HIPAA Voice setting
history_data	Table	history_father	LONGTEXT	2147483647	√		NULL
history_data	Table	history_mother	LONGTEXT	2147483647	√		NULL
form_ros	Table	history_murmur	VARCHAR	3	√		NULL
history_data	Table	history_offspring	LONGTEXT	2147483647	√		NULL
procedure_order	Table	history_order	enum('0', '1')	1	√		'0'	Indicates if the order is added for history purposes only. 0=No, 1=Yes
history_data	Table	history_siblings	LONGTEXT	2147483647	√		NULL
history_data	Table	history_spouse	LONGTEXT	2147483647	√		NULL
patient_history	Table	history_type_key	VARCHAR	36	√		NULL
form_ros	Table	hiv	VARCHAR	3	√		NULL
patient_data	Table	homeless	VARCHAR	255			''	Homeless status of the patient
form_misc_billing_options	Table	hospitalization_date_from	DATE	10	√		NULL
form_misc_billing_options	Table	hospitalization_date_to	DATE	10	√		NULL
form_eye_hpi	Table	HPI1	TEXT	65535	√		NULL
form_eye_hpi	Table	HPI2	TEXT	65535	√		NULL
form_eye_hpi	Table	HPI3	TEXT	65535	√		NULL
form_reviewofs	Table	hyperactive	VARCHAR	5	√		NULL
form_reviewofs	Table	hyperthyroidism	VARCHAR	5	√		NULL
form_reviewofs	Table	hypothyroidism	VARCHAR	5	√		NULL
history_data	Table	hysterectomy	DATETIME	19	√		NULL
facility	Table	iban	VARCHAR	50	√		NULL	International Bank Account Number (IBAN) for the facility EMPTY IN Export
form_misc_billing_options	Table	icn_resubmission_number	VARCHAR	35	√		NULL
form_eye_mag_orders	Table	id	BIGINT	19		√	null
pro_assessments	Table	id	INT	10		√	null
clinical_plans	Table	id	VARCHAR	31			''	Unique and maps to list_options list clinical_plans
history_data	Table	id	BIGINT	19		√	null
form_eye_vitals	Table	id	BIGINT	19			null	Links to forms.form_id
form_observation	Table	id	BIGINT	19			null
transactions	Table	id	BIGINT	19		√	null
form_eye_antseg	Table	id	BIGINT	19			null	Links to forms.form_id
immunizations	Table	id	BIGINT	19		√	null
form_ros	Table	id	INT	10		√	null
form_eye_mag_impplan	Table	id	INT	10		√	null
form_bronchitis	Table	id	Unknown	0			null	Surrogate id of the record used as the primary incrementing key
patient_data	Table	id	BIGINT	19		√	null	Surrogate id of the record used as the primary incrementing key
form_groups_encounter	Table	id	BIGINT	19		√	null	The primary key which is the same as the forms.form_id column
form_eye_base	Table	id	BIGINT	19		√	null	Links to forms.form_id
form_track_anything	Table	id	Unknown	0			null	The primary key which is the same as the forms.form_id column
onsite_documents	Table	id	INT UNSIGNED	10		√	null
facility	Table	id	INT	10		√	null	Surrogate id of the record used as the primary incrementing key
form_questionnaire_assessments	Table	id	BIGINT	19		√	null
patient_tracker	Table	id	BIGINT	19		√	null	Surrogate ID of the patient tracker record used as the primary incrementing key
form_group_attendance	Table	id	BIGINT	19		√	null	The primary key which is the same as the forms.form_id column
onsite_signatures	Table	id	BIGINT	19		√	null
form_care_plan	Table	id	BIGINT	19			null
form_eye_external	Table	id	BIGINT	19			null	Links to forms.form_id
billing	Table	id	INT	10		√	null	Surrogate id of the record used as the primary incrementing key
form_eye_refraction	Table	id	BIGINT	19			null	Links to forms.form_id
form_vitals	Table	id	BIGINT	19		√	null
form_misc_billing_options	Table	id	BIGINT	19		√	null
lists	Table	id	BIGINT	19		√	null	Primary identifier of the record
documents	Table	id	INT	10			0	Surrogate id of the record used as the primary incrementing key
form_eye_neuro	Table	id	BIGINT	19			null	Links to forms.form_id
prescriptions	Table	id	INT	10		√	null
form_dictation	Table	id	BIGINT	19		√	null
form_prior_auth	Table	id	Unknown	0			null	The primary key which is the same as the forms.form_id column
form_eye_biometrics	Table	id	BIGINT	19			null	Links to forms.form_id
form_note	Table	id	Unknown	0			null	The primary key which is the same as the forms.form_id column
form_ankleinjury	Table	id	Unknown	0			null	Surrogate id of the record used as the primary incrementing key
groups	Table	id	BIGINT	19		√	null	Surrogate id of the record used as the primary incrementing key.
form_painmap	Table	id	Unknown	0			null	The primary key which is the same as the forms.form_id column
form_eye_ros	Table	id	BIGINT	19			null	Links to forms.form_id
rule_patient_data	Table	id	BIGINT	19		√	null
form_taskman	Table	ID	BIGINT	19		√	null
form_soap	Table	id	BIGINT	19		√	null
patient_history	Table	id	BIGINT	19		√	null
form_transfer_summary	Table	id	Unknown	0			null	The primary key which is the same as the forms.form_id column
form_treatment_plan	Table	id	Unknown	0			null	The primary key which is the same as the forms.form_id column
form_track_anything_results	Table	id	Unknown	0			null	Surrogate ID of the result record used as the primary incrementing key
insurance_companies	Table	id	INT	10			0
onsite_mail	Table	id	BIGINT	19		√	null	Surrogate id of the record used as the primary incrementing key
form_eye_locking	Table	id	BIGINT	19			null	Links to forms.form_id
form_eye_mag_wearing	Table	id	INT	10		√	null
form_encounter	Table	id	BIGINT	19		√	null
forms	Table	id	BIGINT	19		√	null	Surrogate id of the record used as the primary incrementing key
form_eye_postseg	Table	id	BIGINT	19			null	Links to forms.form_id
patient_access_onsite	Table	id	INT	10		√	null
form_eye_mag_dispense	Table	id	BIGINT	19		√	null
questionnaire_repository	Table	id	BIGINT UNSIGNED	20		√	null	Unique identifier for the questionnaire record
insurance_data	Table	id	BIGINT	19		√	null
form_phq9	Table	id	Unknown	0			null	The primary key which is the same as the forms.form_id column
form_reviewofs	Table	id	BIGINT	19		√	null
form_eye_hpi	Table	id	BIGINT	19			null	Links to forms.form_id
pharmacies	Table	id	INT	10			0
extended_log	Table	id	BIGINT	19		√	null
lists_medication	Table	id	BIGINT	19		√	null
insurance_type_codes	Table	id	INT	10			null
users	Table	id	BIGINT	19		√	null	Unique identifier for each user in the system.
form_gad7	Table	id	Unknown	0			null	The primary key which is the same as the forms.form_id column
onsite_messages	Table	id	INT	10		√	null	Surrogate ID of the message record
form_clinical_instructions	Table	id	INT	10		√	null
form_eye_acuity	Table	id	BIGINT	19			null	Links to forms.form_id
patient_reminders	Table	id	BIGINT	19		√	null
form_aftercare_plan	Table	id	Unknown	0			null	Unique identifier for each aftercare plan entry. Primary key.
pnotes	Table	id	BIGINT	19		√	null
form_functional_cognitive_status	Table	id	BIGINT	19			null
onsite_portal_activity	Table	id	BIGINT	19		√	null
form_sdoh	Table	id	Unknown	0			null	The primary key which is the same as the forms.form_id column
esign_signatures	Table	id	INT	10		√	null	Surrogate id of the record used as the primary incrementing key.
form_clinic_note	Table	id	Unknown	0			null	The primary key which is the same as the forms.form_id column
questionnaire_response	Table	id	BIGINT	19		√	null
notes	Table	id	Unknown	0			null	Surrogate id of the record used as the primary incrementing key
form_clinical_notes	Table	id	BIGINT	19		√	null
patient_data	Table	imm_reg_stat_effdate	MEDIUMTEXT	16777215	√		NULL
patient_data	Table	imm_reg_status	MEDIUMTEXT	16777215	√		NULL
immunizations	Table	immunization_id	INT	10	√		NULL	Comes from the list_options.list_id=‘immunizations’ and represents common list of immunizations the EMR works with
immunization_observation	Table	imo_code	VARCHAR	255	√		NULL
immunization_observation	Table	imo_codetext	VARCHAR	255	√		NULL
immunization_observation	Table	imo_codetype	VARCHAR	255	√		NULL
immunization_observation	Table	imo_criteria	VARCHAR	255	√		NULL
immunization_observation	Table	imo_criteria_value	VARCHAR	255	√		NULL
immunization_observation	Table	imo_date_observation	TIMESTAMP	19			current_timestamp()
immunization_observation	Table	imo_id	INT	10		√	null
immunization_observation	Table	imo_im_id	INT	10			null	The immunization record this observation is part of
immunization_observation	Table	imo_pid	INT	10	√		NULL	The internal patient identifier
immunization_observation	Table	imo_user	INT	10	√		NULL	The user that is recording the observation for this immunization
immunization_observation	Table	imo_vis_date_presented	DATE	10	√		NULL
immunization_observation	Table	imo_vis_date_published	DATE	10	√		NULL
form_eye_locking	Table	IMP	TEXT	65535	√		NULL
documents	Table	imported	TINYINT	3	√		0	Parsing status for CCR/CCD/CCDA importing
form_eye_mag_impplan	Table	IMPPLAN_order	TINYINT	3	√		NULL
form_encounter	Table	in_collection	BOOLEAN	3	√		NULL
insurance_companies	Table	inactive	BOOLEAN	3			0
facility	Table	inactive	BOOLEAN	3			0	Indicates if the facility is inactive (0-Active, 1-Inactive)
form_ros	Table	incontinence	VARCHAR	3	√		NULL
prescriptions	Table	indication	MEDIUMTEXT	16777215	√		NULL
patient_data	Table	industry	MEDIUMTEXT	16777215	√		NULL
form_reviewofs	Table	infections	VARCHAR	5	√		NULL
facility	Table	info	MEDIUMTEXT	16777215	√		NULL	Additional information about the facility EMPTY in Export
users	Table	info	LONGTEXT	2147483647	√		NULL	Additional information or notes about the user.
immunizations	Table	information_source	VARCHAR	31	√		NULL	Comes from the list_options.list_id=‘immunization_informationsource’ and represents where the source of information the immmunization is coming from originates
form_vitals	Table	inhaled_oxygen_concentration	DECIMAL	6	√		NULL
lists	Table	injury_grade	VARCHAR	31			''	UNUSED - will be removed in the future
lists	Table	injury_part	VARCHAR	31			''	UNUSED - will be removed in the future
lists	Table	injury_type	VARCHAR	31			''	UNUSED - will be removed in the future
insurance_companies	Table	ins_type_code	INT	10	√		NULL	The type of insurance company this record is
form_ros	Table	insomnia	VARCHAR	3	√		NULL
form_reviewofs	Table	insomnia	VARCHAR	5	√		NULL
form_clinical_instructions	Table	instruction	MEDIUMTEXT	16777215	√		NULL	The actual instructions to be given to the patient
form_reviewofs	Table	insulin_dependent_diabetes	VARCHAR	5	√		NULL
eligibility_verification	Table	insurance_id	BIGINT	19	√		NULL	The patient insurance that eligibility is being checked against
form_ros	Table	intellectual_decline	VARCHAR	3	√		NULL
form_vital_details	Table	interpretation_list_id	Unknown	0			null
form_vital_details	Table	interpretation_option_id	Unknown	0			null
patient_data	Table	interpretter	VARCHAR	255			''	Interpreter information for the patient
form_reviewofs	Table	interstitial_lung_disease	VARCHAR	5	√		NULL
prescriptions	Table	interval	INT	10	√		NULL
form_ros	Table	intolerance	VARCHAR	3	√		NULL
drug_sales	Table	inventory_id	INT	10			null
form_groups_encounter	Table	invoice_refno	VARCHAR	31			''	Reference number for the invoice
form_encounter	Table	invoice_refno	VARCHAR	31			''
form_eye_vitals	Table	IOPPOSTTIME	TIME	10	√		NULL
form_eye_vitals	Table	IOPTIME	TIME	10			null
onsite_signatures	Table	ip	VARCHAR	46			null
onsite_messages	Table	ip	VARCHAR	15			null	IP address of the sender. Empty on export
users	Table	irnpool	VARCHAR	31			''	IRN (Insurance Referral Network) pool for the user.
form_reviewofs	Table	irregular_heart_beat	VARCHAR	5	√		NULL
form_ros	Table	irritability	VARCHAR	3	√		NULL
form_ros	Table	irritation	VARCHAR	3	√		NULL
list_options	Table	is_default	BOOLEAN	3			0
form_misc_billing_options	Table	is_hospitalized	BOOLEAN	3	√		NULL
esign_signatures	Table	is_lock	BOOLEAN	3			0	Indicates whether the record is signed, locked, or amended.
pnotes	Table	is_msg_encrypted	TINYINT	3	√		0	Whether messsage encrypted 0-Not encrypted, 1-Encrypted
onsite_mail	Table	is_msg_encrypted	TINYINT	3	√		0	Whether the message is encrypted (0-Not encrypted, 1-Encrypted)
form_misc_billing_options	Table	is_unable_to_work	BOOLEAN	3	√		NULL
forms	Table	issue_id	BIGINT	19			0	References lists.id to identify the medical issue this form is connected to
form_CAMOS	Table	item	Unknown	0			null	The CAMOS item template that this note is based on
patient_reminders	Table	item	VARCHAR	31			''	Maps to the item column in the rule_action_item table
rule_patient_data	Table	item	VARCHAR	31			''	Maps to the item column in the rule_action_item table
rule_action_item	Table	item	VARCHAR	31			''	Maps to list_options list rule_action
form_track_anything_results	Table	itemid	Unknown	0			null	The data element that is being tracked for this result that is found in the form_track_anything_type table
form_ros	Table	jaundice	VARCHAR	3	√		NULL
form_ros	Table	joint_pain	VARCHAR	3	√		NULL
billing	Table	justify	VARCHAR	255	√		NULL	Justification for billing code
form_reviewofs	Table	kidney_cancer	VARCHAR	5	√		NULL
form_reviewofs	Table	kidney_failure	VARCHAR	5	√		NULL
form_reviewofs	Table	kidney_infections	VARCHAR	5	√		NULL
form_reviewofs	Table	kidney_stones	VARCHAR	5	√		NULL
form_reviewofs	Table	kidney_transplant	VARCHAR	5	√		NULL
form_reviewofs	Table	knee_problems	VARCHAR	5	√		NULL
history_data	Table	knee_replacement	DATETIME	19	√		NULL
form_misc_billing_options	Table	lab_amount	DECIMAL	5	√		NULL
procedure_providers	Table	lab_director	BIGINT	19			0	ID of the laboratory director
procedure_providers	Table	lab_id	Unknown	0			null	Laboratory ID
procedure_order	Table	lab_id	BIGINT	19			0	References procedure_providers.ppid and is the lab or provider of the procedure that will process the order and the order is being sent to
procedure_questions	Table	lab_id	BIGINT	19			0	references procedure_providers.ppid to identify the lab
procedure_type	Table	lab_id	BIGINT	19			0	References procedure_providers.ppid, 0 means default to parent
form_eye_external	Table	LADNEXA	TEXT	65535	√		NULL
patient_data	Table	language	VARCHAR	255			''	Language preference of the patient
history_data	Table	last_breast_exam	VARCHAR	255	√		NULL
history_data	Table	last_cardiac_echo	VARCHAR	255	√		NULL
history_data	Table	last_ecg	VARCHAR	255	√		NULL
history_data	Table	last_exam_results	VARCHAR	255	√		NULL
history_data	Table	last_fluvax	VARCHAR	255	√		NULL
history_data	Table	last_gynocological_exam	VARCHAR	255	√		NULL
history_data	Table	last_hemoglobin	VARCHAR	255	√		NULL
history_data	Table	last_ldl	VARCHAR	255	√		NULL
form_groups_encounter	Table	last_level_billed	INT	10			0	The party for whom payment was last billed. 0=None, 1=Ins1, 2=Ins2, 3=Ins3
form_encounter	Table	last_level_billed	INT	10			0	The party for whom payment was last billed. -1=Nobody, 0=Patient, 1=Ins1, 2=Ins2, 3=Ins3
form_encounter	Table	last_level_closed	INT	10			0	The party for whom payment was last received. -1=Nobody, 0=Patient, 1=Ins1, 2=Ins2, 3=Ins3
form_groups_encounter	Table	last_level_closed	INT	10			0	The party for whom payment was last received. 0=None, 1=Ins1, 2=Ins2, 3=Ins3
history_data	Table	last_mammogram	VARCHAR	255	√		NULL
drugs	Table	last_notify	DATE	10	√		NULL
history_data	Table	last_physical_exam	VARCHAR	255	√		NULL
history_data	Table	last_pneuvax	VARCHAR	255	√		NULL
history_data	Table	last_prostate_exam	VARCHAR	255	√		NULL
history_data	Table	last_psa	VARCHAR	255	√		NULL
history_data	Table	last_rectal_exam	VARCHAR	255	√		NULL
history_data	Table	last_retinal	VARCHAR	255	√		NULL
history_data	Table	last_sigmoidoscopy_colonoscopy	VARCHAR	255	√		NULL
form_groups_encounter	Table	last_stmt_date	DATE	10	√		NULL	The date of the last statement
form_encounter	Table	last_stmt_date	DATE	10	√		NULL
shared_attributes	Table	last_update	DATETIME	19			null	time of last update
form_encounter	Table	last_update	TIMESTAMP	19			current_timestamp()
drugs	Table	last_updated	DATETIME	19			current_timestamp()
users	Table	last_updated	DATETIME	19			current_timestamp()
form_clinical_notes	Table	last_updated	DATETIME	19			current_timestamp()
insurance_companies	Table	last_updated	DATETIME	19			current_timestamp()
procedure_providers	Table	last_updated	DATETIME	19			current_timestamp()
facility	Table	last_updated	DATETIME	19			current_timestamp()
form_vitals	Table	last_updated	DATETIME	19			current_timestamp()
patient_data	Table	last_updated	DATETIME	19			current_timestamp()
questionnaire_response	Table	last_updated	DATETIME	19	√		NULL
list_options	Table	last_updated	DATETIME	19			current_timestamp()
onsite_signatures	Table	lastmod	DATETIME	19			null
patient_tracker	Table	lastseq	VARCHAR	4			''	The element file should contain this number of elements
procedure_type	Table	laterality	VARCHAR	31			''	Left, right, …
form_eye_external	Table	LBROW	TEXT	65535	√		NULL
form_ros	Table	lc	VARCHAR	3	√		NULL
form_eye_external	Table	LCAROTID	TEXT	65535	√		NULL
form_eye_external	Table	LCNV	TEXT	65535	√		NULL
form_eye_external	Table	LCNVII	TEXT	65535	√		NULL
form_ros	Table	legpain_cramping	VARCHAR	3	√		NULL
form_eye_mag_wearing	Table	LENS_MATERIAL	VARCHAR	20	√		NULL
form_eye_mag_dispense	Table	LENS_MATERIAL	VARCHAR	20	√		NULL
form_eye_mag_dispense	Table	LENS_TREATMENTS	VARCHAR	100	√		NULL
form_eye_mag_wearing	Table	LENS_TREATMENTS	VARCHAR	100	√		NULL
form_questionnaire_assessments	Table	lform	LONGTEXT	2147483647	√		NULL
questionnaire_repository	Table	lform	LONGTEXT	2147483647	√		NULL	National Institutes of Health (NIH) Lforms version of text content for the questionnaire (e.g., for long forms)
form_questionnaire_assessments	Table	lform_response	LONGTEXT	2147483647	√		NULL
form_physical_exam	Table	line_id	Unknown	0			null
form_eye_acuity	Table	LIODVA	VARCHAR	25			null
form_eye_acuity	Table	LIOSVA	VARCHAR	25			null
layout_options	Table	list_backup_id	VARCHAR	100			''
documents	Table	list_id	BIGINT	19			0	FK to lists.id associated with the document when the document is related to an issue
issue_encounter	Table	list_id	Unknown	0			null	Represents the specific medical issue (allergy,surgery,etc) this encounter is linked to
lists_medication	Table	list_id	BIGINT	19	√		NULL	The internal lists identifier
layout_options	Table	list_id	VARCHAR	100			''
list_options	Table	list_id	VARCHAR	100			''
lists	Table	list_option_id	VARCHAR	100	√		NULL	Comes from the list_options.list_id=CONCAT(lists.type,‘_issue_list’) and represents the prefilled list option id that was chosen as a template to create this issue
form_eye_external	Table	LLF	VARCHAR	25	√		NULL
form_eye_external	Table	LLL	TEXT	65535	√		NULL
form_eye_external	Table	LMCT	TEXT	65535	√		NULL
form_ros	Table	lmp	VARCHAR	3	√		NULL
form_eye_external	Table	LMRD	VARCHAR	25	√		NULL
patient_data	Table	lname	VARCHAR	255			''	Last name of the patient
users	Table	lname	VARCHAR	255	√		NULL	Last name of the user.
form_ros	Table	loc	VARCHAR	3	√		NULL
form_eye_hpi	Table	LOCATION1	VARCHAR	255	√		NULL
form_eye_hpi	Table	LOCATION2	TEXT	65535	√		NULL
form_eye_hpi	Table	LOCATION3	TEXT	65535	√		NULL
form_eye_locking	Table	LOCKED	VARCHAR	3	√		NULL
form_eye_locking	Table	LOCKEDBY	VARCHAR	50	√		NULL
form_eye_locking	Table	LOCKEDDATE	TIMESTAMP	19			current_timestamp()
procedure_providers	Table	login	VARCHAR	255			''	Login information for communication. Empty on Export
immunizations	Table	lot_number	VARCHAR	50	√		NULL
form_eye_external	Table	LTEMPART	TEXT	65535	√		NULL
form_eye_external	Table	LUL	TEXT	65535	√		NULL
form_reviewofs	Table	lung_cancer	VARCHAR	5	√		NULL
form_reviewofs	Table	lung_cancer_surgery	VARCHAR	5	√		NULL
form_reviewofs	Table	lupus	VARCHAR	5	√		NULL
form_eye_external	Table	LVFISSURE	VARCHAR	25	√		NULL
form_ros	Table	m_aches	VARCHAR	3	√		NULL
form_ros	Table	m_redness	VARCHAR	3	√		NULL
form_ros	Table	m_stiffness	VARCHAR	3	√		NULL
form_ros	Table	m_warm	VARCHAR	3	√		NULL
onsite_mail	Table	mail_chain	INT	10	√		NULL	Mail chain ID
facility	Table	mail_city	VARCHAR	50	√		NULL	Mailing city of the facility
facility	Table	mail_state	VARCHAR	3	√		NULL	Mailing state of the facility
patient_reminders	Table	mail_status	BOOLEAN	3			0	0 if not sent and 1 if sent
facility	Table	mail_street	VARCHAR	30	√		NULL	Mailing street address of the facility
facility	Table	mail_street2	VARCHAR	30	√		NULL	Additional mailing street address of the facility
facility	Table	mail_zip	VARCHAR	10	√		NULL	Mailing ZIP code of the facility
users	Table	main_menu_role	VARCHAR	50			'standard'	Main menu role for the user. EMPTY for exports
immunizations	Table	manufacturer	VARCHAR	100	√		NULL	Comes from the list_options.list_id=‘Immunization_Manufacturer’ and represents a list of immunization manufacturers
list_options	Table	mapping	VARCHAR	31			''
layout_options	Table	max_length	INT	10			0
drugs	Table	max_level	FLOAT	12			0
procedure_questions	Table	maxsize	INT	10			0	maximum length if text input field
form_ros	Table	mearche	VARCHAR	3	√		NULL
form_misc_billing_options	Table	medicaid_original_reference	VARCHAR	15	√		NULL
form_misc_billing_options	Table	medicaid_referral_code	VARCHAR	2	√		NULL
form_misc_billing_options	Table	medicaid_resubmission_code	VARCHAR	10	√		NULL
prescriptions	Table	medication	INT	10	√		NULL
therapy_groups_participant_attendance	Table	meeting_patient_comment	TEXT	65535	√		NULL	Comments about the participant’s attendance in the meeting
therapy_groups_participant_attendance	Table	meeting_patient_status	VARCHAR	15	√		NULL	The patient status in the meeting from the list_options.list_id=‘groupstat’
ar_activity	Table	memo	VARCHAR	255			''	Additional comments or adjustment reasons related to the payment activity.
form_ros	Table	memory_problems	VARCHAR	3	√		NULL
form_ros	Table	menopause	VARCHAR	3	√		NULL
onsite_messages	Table	message	LONGTEXT	2147483647	√		NULL	The content of the chat message
benefit_eligibility	Table	message	VARCHAR	512	√		NULL	Additional message or information
onsite_mail	Table	message_status	VARCHAR	20			'New'	Status of the message (‘Done’,‘New’)
pnotes	Table	message_status	VARCHAR	20			'New'	Comes from the list_options.list_id=‘message_status’ and represents the status of the message
form_taskman	Table	METHOD	VARCHAR	20			null
patient_data	Table	migrantseasonal	VARCHAR	255			''	Migrant/Seasonal worker information
documents	Table	mimetype	VARCHAR	255	√		NULL	MIME type of the document
users	Table	mname	VARCHAR	255	√		NULL	Middle name of the user.
patient_data	Table	mname	VARCHAR	255			''	Middle name of the patient
amendments	Table	modified_by	INT	10	√		NULL	The id of the user that last modified this amendment
questionnaire_repository	Table	modified_date	DATETIME	19	√		current_timestamp()	Date and time when the questionnaire was last modified
amendments	Table	modified_time	TIMESTAMP	19	√		NULL	Timestamp indicating when the amendment record was last modified.
ar_session	Table	modified_time	DATETIME	19			null	The date and time of the last modification to the payment record.
ar_activity	Table	modified_time	DATETIME	19			null	The timestamp indicating when this payment activity was last modified (in DATETIME format).
ar_activity	Table	modifier	VARCHAR	12			''	Billing code modifier
billing	Table	modifier	VARCHAR	12	√		NULL	Modifier for billing code
form_eye_hpi	Table	MODIFY1	VARCHAR	255	√		NULL
form_eye_hpi	Table	MODIFY2	TEXT	65535	√		NULL
form_eye_hpi	Table	MODIFY3	TEXT	65535	√		NULL
lists	Table	modifydate	TIMESTAMP	19			current_timestamp()	The date the issue record was last modified
patient_data	Table	monthly_income	VARCHAR	255			''	Monthly income information of the patient
patient_data	Table	mothersname	VARCHAR	255			''	Mother’s name
form_eye_neuro	Table	MOTILITY_LI	CHAR	1	√		'0'
form_eye_neuro	Table	MOTILITY_LL	CHAR	1	√		'0'
form_eye_neuro	Table	MOTILITY_LLIO	INT	10	√		NULL
form_eye_neuro	Table	MOTILITY_LLSO	INT	10	√		NULL
form_eye_neuro	Table	MOTILITY_LR	CHAR	1	√		'0'
form_eye_neuro	Table	MOTILITY_LRIO	INT	10	√		NULL
form_eye_neuro	Table	MOTILITY_LRSO	INT	10	√		NULL
form_eye_neuro	Table	MOTILITY_LS	CHAR	1	√		'0'
form_eye_neuro	Table	MOTILITY_RI	CHAR	1	√		'0'
form_eye_neuro	Table	MOTILITY_RL	CHAR	1	√		'0'
form_eye_neuro	Table	MOTILITY_RLIO	INT	10	√		NULL
form_eye_neuro	Table	MOTILITY_RLSO	INT	10	√		NULL
form_eye_neuro	Table	MOTILITY_RR	CHAR	1	√		'0'
form_eye_neuro	Table	MOTILITY_RRIO	INT	10	√		NULL
form_eye_neuro	Table	MOTILITY_RRSO	INT	10	√		NULL
form_eye_neuro	Table	MOTILITY_RS	CHAR	1	√		'0'
form_eye_neuro	Table	MOTILITYNORMAL	CHAR	3			'on'
form_eye_acuity	Table	MRNEARODVA	VARCHAR	25	√		NULL
form_eye_acuity	Table	MRNEAROSVA	VARCHAR	25	√		NULL
form_eye_refraction	Table	MRODADD	VARCHAR	25	√		NULL
form_eye_refraction	Table	MRODAXIS	VARCHAR	25	√		NULL
form_eye_refraction	Table	MRODBASE	VARCHAR	25	√		NULL
form_eye_refraction	Table	MRODBASENEAR	VARCHAR	25	√		NULL
form_eye_refraction	Table	MRODCYL	VARCHAR	25	√		NULL
form_eye_refraction	Table	MRODNEARAXIS	VARCHAR	25	√		NULL
form_eye_refraction	Table	MRODNEARCYL	VARCHAR	25	√		NULL
form_eye_refraction	Table	MRODNEARSPHERE	VARCHAR	25	√		NULL
form_eye_refraction	Table	MRODPRISM	VARCHAR	25	√		NULL
form_eye_refraction	Table	MRODPRISMNEAR	VARCHAR	50	√		NULL
form_eye_refraction	Table	MRODSPH	VARCHAR	25	√		NULL
form_eye_acuity	Table	MRODVA	VARCHAR	25	√		NULL
form_eye_refraction	Table	MROSADD	VARCHAR	25	√		NULL
form_eye_refraction	Table	MROSAXIS	VARCHAR	25	√		NULL
form_eye_refraction	Table	MROSBASE	VARCHAR	50	√		NULL
form_eye_refraction	Table	MROSBASENEAR	VARCHAR	25	√		NULL
form_eye_refraction	Table	MROSCYL	VARCHAR	25	√		NULL
form_eye_refraction	Table	MROSNEARAXIS	VARCHAR	125	√		NULL
form_eye_refraction	Table	MROSNEARCYL	VARCHAR	25	√		NULL
form_eye_refraction	Table	MROSNEARSHPERE	VARCHAR	25	√		NULL
form_eye_refraction	Table	MROSPRISM	VARCHAR	50	√		NULL
form_eye_refraction	Table	MROSPRISMNEAR	VARCHAR	50	√		NULL
form_eye_refraction	Table	MROSSPH	VARCHAR	25	√		NULL
form_eye_acuity	Table	MROSVA	VARCHAR	25	√		NULL
onsite_mail	Table	mtype	VARCHAR	128	√		NULL	Message type (‘Notification’, ‘Message’)
form_ros	Table	muscle	VARCHAR	3	√		NULL
form_ros	Table	n_headache	VARCHAR	3	√		NULL
form_ros	Table	n_numbness	VARCHAR	3	√		NULL
form_ros	Table	n_weakness	VARCHAR	3	√		NULL
procedure_providers	Table	name	VARCHAR	255			''	Name of the laboratory or organization
form_track_anything_type	Table	name	Unknown	0			null	The name of the type of the data element being tracked
drugs	Table	name	VARCHAR	255			''
pharmacies	Table	name	VARCHAR	255	√		NULL
documents	Table	name	VARCHAR	255	√		NULL	Name of the document. Populated since OpenEMR versions 6.0.0+
form_track_anything	Table	name	Unknown	0			null	The name of the type of the data element being tracked
insurance_companies	Table	name	VARCHAR	255	√		NULL
questionnaire_repository	Table	name	VARCHAR	255	√		NULL	Name or title of the questionnaire
groups	Table	name	LONGTEXT	2147483647	√		NULL	The name of the group.
therapy_groups	Table	name	Unknown	0			null	The name of the therapy group
facility	Table	name	VARCHAR	255	√		NULL	The name of the facility
procedure_type	Table	name	VARCHAR	63			''	Name for this category, procedure or result type
history_data	Table	name_1	VARCHAR	255	√		NULL
history_data	Table	name_2	VARCHAR	255	√		NULL
patient_data	Table	name_history	TEXT	65535	√		NULL
onsite_portal_activity	Table	narrative	LONGTEXT	2147483647	√		NULL
patient_data	Table	nationality_country	TEXT	65535	√		NULL
form_ros	Table	nausea	VARCHAR	3	√		NULL
pharmacies	Table	ncpdp	INT	10	√		NULL
billing	Table	ndc_info	VARCHAR	255	√		NULL	NDC (National Drug Code) information
drugs	Table	ndc_number	VARCHAR	20			''
form_reviewofs	Table	neck_problems	VARCHAR	5	√		NULL
form_eye_postseg	Table	NEO25	VARCHAR	25			null
benefit_eligibility	Table	network_ind	VARCHAR	2	√		NULL	Network indicator
form_eye_neuro	Table	NEURO_COMMENTS	TEXT	65535	√		NULL
users	Table	newcrop_user_role	VARCHAR	30	√		NULL	NewCrop user role for the user.EMPTY for exports
form_ros	Table	night_sweats	VARCHAR	3	√		NULL
form_reviewofs	Table	night_sweats	VARCHAR	5	√		NULL
form_ros	Table	nocturia	VARCHAR	3	√		NULL
form_reviewofs	Table	noninsulin_dependent_diabetes	VARCHAR	5	√		NULL
clinical_plans	Table	normal_flag	BOOLEAN	3	√		NULL	Normal Activation Flag
form_ros	Table	nosebleed	VARCHAR	3	√		NULL
immunizations	Table	note	MEDIUMTEXT	16777215	√		NULL
form_vitals	Table	note	VARCHAR	255	√		NULL
prescriptions	Table	note	MEDIUMTEXT	16777215	√		NULL
notes	Table	note	Unknown	0			null	The notes or comments for the document referenced in foreign_id
form_care_plan	Table	note_related_to	MEDIUMTEXT	16777215	√		NULL	Reference to lists id for note relationships(json)
form_clinical_notes	Table	note_related_to	TEXT	65535	√		NULL	Reference to lists id for note relationships(json)
billing	Table	notecodes	VARCHAR	25			''	Notecodes associated with billing
voids	Table	notes	VARCHAR	255	√		''
list_options	Table	notes	MEDIUMTEXT	16777215	√		NULL
procedure_type	Table	notes	VARCHAR	255			''	Additional notes to enhance description
users	Table	notes	MEDIUMTEXT	16777215	√		NULL	Additional notes or comments about the user. EMPTY for exports
form_track_anything_results	Table	notes	Unknown	0			null	UNUSED
procedure_providers	Table	notes	MEDIUMTEXT	16777215	√		NULL	Additional notes or information. Empty on Export
drug_sales	Table	notes	VARCHAR	255			''
form_eye_neuro	Table	NPC	VARCHAR	10	√		NULL
procedure_providers	Table	npi	VARCHAR	15			''	National Provider Identifier (NPI)
pharmacies	Table	npi	INT	10	√		NULL
users	Table	npi	VARCHAR	15	√		NULL	National Provider Identifier for the user.
prescriptions	Table	ntx	INT	10	√		NULL
form_eye_refraction	Table	NVOCHECKED	VARCHAR	25	√		NULL
form_observation	Table	ob_code	VARCHAR	64	√		NULL
form_observation	Table	ob_documentationof_table	VARCHAR	255	√		NULL
form_observation	Table	ob_documentationof_table_id	BIGINT	19	√		NULL
form_observation	Table	ob_reason_code	VARCHAR	64	√		NULL
form_observation	Table	ob_reason_status	VARCHAR	32	√		NULL
form_observation	Table	ob_reason_text	MEDIUMTEXT	16777215	√		NULL
form_observation	Table	ob_status	VARCHAR	32	√		NULL
form_observation	Table	ob_type	VARCHAR	64	√		NULL
form_observation	Table	ob_unit	VARCHAR	255	√		NULL
form_observation	Table	ob_value	VARCHAR	255	√		NULL
form_soap	Table	objective	MEDIUMTEXT	16777215	√		NULL
form_observation	Table	observation	VARCHAR	255	√		NULL
patient_data	Table	occupation	LONGTEXT	2147483647	√		NULL	Occupation of the patient. UNEMPLOYED, STUDENT, PT STUDENT, or anything else to indicate employed.
lists	Table	occurrence	INT	10	√		0	Comes from the list_options.list_id=‘occurrence’ and is the frequency that this issue occurs for the patient
form_eye_antseg	Table	ODAC	TEXT	65535	√		NULL
form_eye_biometrics	Table	ODACD	VARCHAR	20	√		NULL
form_eye_mag_wearing	Table	ODADD	VARCHAR	10	√		NULL
form_eye_mag_dispense	Table	ODADD	VARCHAR	10	√		NULL
form_eye_antseg	Table	ODAPD	VARCHAR	25	√		NULL
form_eye_biometrics	Table	ODAXIALLENGTH	VARCHAR	20	√		NULL
form_eye_mag_wearing	Table	ODAXIS	VARCHAR	10	√		NULL
form_eye_mag_dispense	Table	ODAXIS	VARCHAR	10	√		NULL
form_eye_mag_dispense	Table	ODBC	VARCHAR	50	√		NULL
form_eye_postseg	Table	ODCMT	TEXT	65535	√		NULL
form_eye_neuro	Table	ODCOINS	TEXT	65535	√		NULL
form_eye_neuro	Table	ODCOLOR	TEXT	65535	√		NULL
form_eye_antseg	Table	ODCONJ	TEXT	65535	√		NULL
form_eye_antseg	Table	ODCORNEA	TEXT	65535	√		NULL
form_eye_postseg	Table	ODCUP	TEXT	65535	√		NULL
form_eye_mag_wearing	Table	ODCYL	VARCHAR	10	√		NULL
form_eye_mag_dispense	Table	ODCYL	VARCHAR	10	√		NULL
form_eye_mag_dispense	Table	ODDIAM	VARCHAR	50	√		NULL
form_eye_postseg	Table	ODDISC	TEXT	65535	√		NULL
form_eye_antseg	Table	ODGONIO	VARCHAR	25	√		NULL
form_eye_mag_wearing	Table	ODHBASE	VARCHAR	20	√		NULL
form_eye_mag_dispense	Table	ODHBASE	VARCHAR	20	√		NULL
form_eye_external	Table	ODHERTEL	VARCHAR	25	√		NULL
form_eye_mag_dispense	Table	ODHPD	VARCHAR	20	√		NULL
form_eye_mag_wearing	Table	ODHPD	VARCHAR	20	√		NULL
form_eye_vitals	Table	ODIOPAP	VARCHAR	10	√		NULL
form_eye_vitals	Table	ODIOPFTN	VARCHAR	10	√		NULL
form_eye_vitals	Table	ODIOPPOST	VARCHAR	10			null
form_eye_vitals	Table	ODIOPTARGET	VARCHAR	10			null
form_eye_vitals	Table	ODIOPTPN	VARCHAR	10	√		NULL
form_eye_antseg	Table	ODIRIS	TEXT	65535	√		NULL
form_eye_biometrics	Table	ODK1	VARCHAR	10	√		NULL
form_eye_biometrics	Table	ODK2	VARCHAR	10	√		NULL
form_eye_biometrics	Table	ODK2AXIS	VARCHAR	10	√		NULL
form_eye_antseg	Table	ODKTHICKNESS	VARCHAR	25	√		NULL
form_eye_antseg	Table	ODLENS	TEXT	65535	√		NULL
form_eye_biometrics	Table	ODLT	VARCHAR	20	√		NULL
form_eye_postseg	Table	ODMACULA	TEXT	65535	√		NULL
form_eye_mag_wearing	Table	ODMIDADD	VARCHAR	10	√		NULL
form_eye_mag_dispense	Table	ODMIDADD	VARCHAR	10	√		NULL
form_eye_mag_wearing	Table	ODMPDD	VARCHAR	20	√		NULL
form_eye_mag_dispense	Table	ODMPDD	VARCHAR	20	√		NULL
form_eye_mag_dispense	Table	ODMPDN	VARCHAR	20	√		NULL
form_eye_mag_wearing	Table	ODMPDN	VARCHAR	20	√		NULL
form_eye_mag_wearing	Table	ODNEARVA	VARCHAR	10	√		NULL
form_eye_neuro	Table	ODNPA	TEXT	65535	√		NULL
form_eye_biometrics	Table	ODPDMeasured	VARCHAR	20	√		NULL
form_eye_postseg	Table	ODPERIPH	TEXT	65535	√		NULL
form_eye_antseg	Table	ODPUPILREACTIVITY	CHAR	25	√		NULL
form_eye_antseg	Table	ODPUPILSIZE1	VARCHAR	25	√		NULL
form_eye_antseg	Table	ODPUPILSIZE2	VARCHAR	25	√		NULL
form_eye_neuro	Table	ODREDDESAT	VARCHAR	20	√		NULL
form_eye_antseg	Table	ODSCHIRMER1	VARCHAR	25	√		NULL
form_eye_antseg	Table	ODSCHIRMER2	VARCHAR	25	√		NULL
form_eye_mag_wearing	Table	ODSLABOFF	VARCHAR	20	√		NULL
form_eye_mag_dispense	Table	ODSLABOFF	VARCHAR	20	√		NULL
form_eye_mag_wearing	Table	ODSPH	VARCHAR	10	√		NULL
form_eye_mag_dispense	Table	ODSPH	VARCHAR	10	√		NULL
form_eye_antseg	Table	ODTBUT	VARCHAR	25	√		NULL
form_eye_mag_wearing	Table	ODVA	VARCHAR	10	√		NULL
form_eye_mag_wearing	Table	ODVBASE	VARCHAR	20	√		NULL
form_eye_mag_dispense	Table	ODVBASE	VARCHAR	20	√		NULL
form_eye_mag_wearing	Table	ODVERTEXDIST	VARCHAR	20	√		NULL
form_eye_mag_dispense	Table	ODVERTEXDIST	VARCHAR	20	√		NULL
form_eye_postseg	Table	ODVESSELS	TEXT	65535	√		NULL
form_eye_vitals	Table	ODVF1	BOOLEAN	3	√		NULL
form_eye_vitals	Table	ODVF2	BOOLEAN	3	√		NULL
form_eye_vitals	Table	ODVF3	BOOLEAN	3	√		NULL
form_eye_vitals	Table	ODVF4	BOOLEAN	3	√		NULL
form_eye_postseg	Table	ODVITREOUS	TEXT	65535	√		NULL
form_eye_mag_dispense	Table	ODVPD	VARCHAR	20	√		NULL
form_eye_mag_wearing	Table	ODVPD	VARCHAR	20	√		NULL
form_eye_biometrics	Table	ODW2W	VARCHAR	20	√		NULL
form_misc_billing_options	Table	off_work_from	DATE	10	√		NULL
form_misc_billing_options	Table	off_work_to	DATE	10	√		NULL
facility	Table	oid	VARCHAR	255			''	For HIEs, CCDA, and FHIR an OID is required/wanted for the facility
drugs	Table	on_order	INT	10			0
form_groups_encounter	Table	onset_date	DATETIME	19	√		NULL	The date when the condition or issue for the group started
form_encounter	Table	onset_date	DATETIME	19	√		NULL
form_misc_billing_options	Table	onset_date	DATE	10	√		NULL
list_options	Table	option_id	VARCHAR	100			''
list_options	Table	option_value	FLOAT	12			0
procedure_questions	Table	options	MEDIUMTEXT	16777215	√		NULL	choices for fldtype S and T
procedure_order	Table	order_abn	VARCHAR	31			'not_required'	The status of the US CMS Advanced Beneficiary Notice and whether the patient has already been given the ABN. Possible values are ‘not_required’=Patient doesn’t need an ABN, ‘required’=Patient needs to be given an ABN before procedure can occur, or ‘signed’=Patient has already been given an ABN and signed it.
form_eye_mag_orders	Table	ORDER_COMPLETED_BYWHOM	VARCHAR	50	√		NULL
form_eye_mag_orders	Table	ORDER_DATE_COMPLETED	DATE	10	√		NULL
form_eye_mag_orders	Table	ORDER_DATE_PLACED	DATE	10			null
form_eye_mag_orders	Table	ORDER_DETAILS	VARCHAR	255			null
procedure_order	Table	order_diagnosis	VARCHAR	255	√		''	Primary order diagnosis
form_eye_mag_orders	Table	ORDER_PLACED_BYWHOM	VARCHAR	50	√		NULL
form_eye_mag_orders	Table	ORDER_PRIORITY	VARCHAR	50	√		NULL
procedure_order	Table	order_priority	VARCHAR	31			''	Comes from the list_options.list_id=‘ord_priority’ and represents the priority of the order
procedure_order	Table	order_psc	TINYINT	3	√		NULL	Should the order for the Patient Service Center (PSC) be put on hold. 0=No, 1=Yes
form_eye_mag_orders	Table	ORDER_STATUS	VARCHAR	50	√		NULL
procedure_order	Table	order_status	VARCHAR	31			''	Comes from the list_options.list_id=‘ord_status’ and represents the status of the order (pending, routed, complete, canceled)
issue_types	Table	ordering	INT	10			0
immunizations	Table	ordering_provider	INT	10	√		NULL	The provider that issued the order to administer this immunization
form_encounter	Table	ordering_provider_id	INT	10	√		0	ordering provider, if any, for this visit
procedure_providers	Table	orders_path	VARCHAR	255			''	Path for orders. Empty on Export
users	Table	organization	VARCHAR	255	√		NULL	Name of the user’s organization or practice.
form_eye_vitals	Table	oriented	CHAR	3	√		'TPP'
patient_tracker	Table	original_user	VARCHAR	255			''	This is the user that created the original record
form_ros	Table	orthopnea	VARCHAR	3	√		NULL
form_eye_antseg	Table	OSAC	TEXT	65535	√		NULL
form_eye_biometrics	Table	OSACD	VARCHAR	20	√		NULL
form_eye_mag_dispense	Table	OSADD	VARCHAR	10	√		NULL
form_eye_mag_wearing	Table	OSADD	VARCHAR	10	√		NULL
form_eye_antseg	Table	OSAPD	VARCHAR	25	√		NULL
form_eye_biometrics	Table	OSAXIALLENGTH	VARCHAR	20	√		NULL
form_eye_mag_dispense	Table	OSAXIS	VARCHAR	10	√		NULL
form_eye_mag_wearing	Table	OSAXIS	VARCHAR	10	√		NULL
form_eye_mag_dispense	Table	OSBC	VARCHAR	50	√		NULL
form_eye_postseg	Table	OSCMT	TEXT	65535	√		NULL
form_eye_neuro	Table	OSCOINS	TEXT	65535	√		NULL
form_eye_neuro	Table	OSCOLOR	TEXT	65535	√		NULL
form_eye_antseg	Table	OSCONJ	VARCHAR	25	√		NULL
form_eye_antseg	Table	OSCORNEA	TEXT	65535	√		NULL
form_eye_postseg	Table	OSCUP	TEXT	65535	√		NULL
form_eye_mag_wearing	Table	OSCYL	VARCHAR	10	√		NULL
form_eye_mag_dispense	Table	OSCYL	VARCHAR	10	√		NULL
form_eye_mag_dispense	Table	OSDIAM	VARCHAR	50	√		NULL
form_eye_postseg	Table	OSDISC	TEXT	65535	√		NULL
form_reviewofs	Table	osetoarthritis	VARCHAR	5	√		NULL
form_eye_antseg	Table	OSGONIO	VARCHAR	25	√		NULL
form_eye_mag_dispense	Table	OSHBASE	VARCHAR	20	√		NULL
form_eye_mag_wearing	Table	OSHBASE	VARCHAR	20	√		NULL
form_eye_external	Table	OSHERTEL	VARCHAR	25	√		NULL
form_eye_mag_wearing	Table	OSHPD	VARCHAR	20	√		NULL
form_eye_mag_dispense	Table	OSHPD	VARCHAR	20	√		NULL
form_eye_vitals	Table	OSIOPAP	VARCHAR	10	√		NULL
form_eye_vitals	Table	OSIOPFTN	VARCHAR	10	√		NULL
form_eye_vitals	Table	OSIOPPOST	VARCHAR	10			null
form_eye_vitals	Table	OSIOPTARGET	VARCHAR	10			null
form_eye_vitals	Table	OSIOPTPN	VARCHAR	10	√		NULL
form_eye_antseg	Table	OSIRIS	TEXT	65535	√		NULL
form_eye_biometrics	Table	OSK1	VARCHAR	10	√		NULL
form_eye_biometrics	Table	OSK2	VARCHAR	10	√		NULL
form_eye_biometrics	Table	OSK2AXIS	VARCHAR	10	√		NULL
form_eye_antseg	Table	OSKTHICKNESS	VARCHAR	25	√		NULL
form_eye_antseg	Table	OSLENS	TEXT	65535	√		NULL
form_eye_biometrics	Table	OSLT	VARCHAR	20	√		NULL
form_eye_postseg	Table	OSMACULA	TEXT	65535	√		NULL
form_eye_mag_dispense	Table	OSMIDADD	VARCHAR	10	√		NULL
form_eye_mag_wearing	Table	OSMIDADD	VARCHAR	10	√		NULL
form_eye_mag_dispense	Table	OSMPDD	VARCHAR	20	√		NULL
form_eye_mag_wearing	Table	OSMPDD	VARCHAR	20	√		NULL
form_eye_mag_wearing	Table	OSMPDN	VARCHAR	20	√		NULL
form_eye_mag_dispense	Table	OSMPDN	VARCHAR	20	√		NULL
form_eye_mag_wearing	Table	OSNEARVA	VARCHAR	10	√		NULL
form_eye_neuro	Table	OSNPA	TEXT	65535	√		NULL
form_eye_biometrics	Table	OSPDMeasured	VARCHAR	20	√		NULL
form_eye_postseg	Table	OSPERIPH	TEXT	65535	√		NULL
form_eye_antseg	Table	OSPUPILREACTIVITY	CHAR	25	√		NULL
form_eye_antseg	Table	OSPUPILSIZE1	VARCHAR	25	√		NULL
form_eye_antseg	Table	OSPUPILSIZE2	VARCHAR	25	√		NULL
form_eye_neuro	Table	OSREDDESAT	VARCHAR	20	√		NULL
form_eye_antseg	Table	OSSCHIRMER1	VARCHAR	25	√		NULL
form_eye_antseg	Table	OSSCHIRMER2	VARCHAR	25	√		NULL
form_eye_mag_wearing	Table	OSSLABOFF	VARCHAR	20	√		NULL
form_eye_mag_dispense	Table	OSSLABOFF	VARCHAR	20	√		NULL
form_eye_mag_wearing	Table	OSSPH	VARCHAR	10	√		NULL
form_eye_mag_dispense	Table	OSSPH	VARCHAR	10	√		NULL
form_eye_antseg	Table	OSTBUT	VARCHAR	25	√		NULL
form_eye_mag_wearing	Table	OSVA	VARCHAR	10	√		NULL
form_eye_acuity	Table	OSVANEARCC	VARCHAR	25	√		NULL
form_eye_mag_wearing	Table	OSVBASE	VARCHAR	20	√		NULL
form_eye_mag_dispense	Table	OSVBASE	VARCHAR	20	√		NULL
form_eye_mag_dispense	Table	OSVERTEXDIST	VARCHAR	20	√		NULL
form_eye_mag_wearing	Table	OSVERTEXDIST	VARCHAR	20	√		NULL
form_eye_postseg	Table	OSVESSELS	TEXT	65535	√		NULL
form_eye_vitals	Table	OSVF1	BOOLEAN	3	√		NULL
form_eye_vitals	Table	OSVF2	BOOLEAN	3	√		NULL
form_eye_vitals	Table	OSVF3	BOOLEAN	3	√		NULL
form_eye_vitals	Table	OSVF4	BOOLEAN	3	√		NULL
form_eye_postseg	Table	OSVITREOUS	TEXT	65535	√		NULL
form_eye_mag_dispense	Table	OSVPD	VARCHAR	20	√		NULL
form_eye_mag_wearing	Table	OSVPD	VARCHAR	20	√		NULL
form_eye_biometrics	Table	OSW2W	VARCHAR	20	√		NULL
form_misc_billing_options	Table	other_accident	BOOLEAN	3	√		NULL
voids	Table	other_info	MEDIUMTEXT	16777215	√		NULL	for checkout,receipt the old invoice refno
lists	Table	outcome	INT	10			0	Comes from the list_options.list_id=‘outcome’ and represents the outcome of the issue
form_misc_billing_options	Table	outside_lab	BOOLEAN	3	√		NULL
documents	Table	owner	INT	10	√		NULL	Foreign key identifier to users of who initially persisted the document
onsite_mail	Table	owner	VARCHAR	128	√		NULL	Owner of the message. If this is a message intended for a patient this will be the patient_data.pid if it is for a user this will be the users.id
notes	Table	owner	Unknown	0			null	Foreign key identifier to users of who initially created this note
form_vitals	Table	oxygen_flow_rate	DECIMAL	12	√		NULL
form_vitals	Table	oxygen_saturation	DECIMAL	6	√		NULL
form_ros	Table	p	VARCHAR	3	√		NULL
form_ros	Table	p_diagnosis	VARCHAR	3	√		NULL
form_ros	Table	p_medication	VARCHAR	3	√		NULL
documents	Table	pages	INT	10	√		NULL	If the document is a multi-page format like tiff and has at least 1 page this will be 1 or greater,if a non-multi-page format this should be null or empty
form_ros	Table	pain	VARCHAR	3	√		NULL
form_ros	Table	palpitation	VARCHAR	3	√		NULL
form_eye_acuity	Table	PAMODVA	VARCHAR	25	√		NULL
form_eye_acuity	Table	PAMOSVA	VARCHAR	25	√		NULL
form_ros	Table	paralysis	VARCHAR	3	√		NULL
procedure_type	Table	parent	BIGINT	19			0	References procedure_type.procedure_type_id for heirarchies of procedure types
form_track_anything_type	Table	parent	Unknown	0			null	This is a reference to a parent form_track_anything_type element. 0=There is no parent, if !0 then it is the track_anything_type_id for the parent element
form_encounter	Table	parent_encounter_id	BIGINT	19	√		NULL
users	Table	password	LONGTEXT	2147483647	√		NULL	The password for the user’s account.
procedure_providers	Table	password	VARCHAR	255			''	Password for communication. Empty on Export
documents	Table	path_depth	TINYINT	3	√		1	Depth of path to use in the URL to find the document. Not applicable for CouchDB. . Empty in export.
patient_data	Table	patient_groups	MEDIUMTEXT	16777215	√		NULL
extended_log	Table	patient_id	BIGINT	19	√		NULL	The internal patient identifier
immunizations	Table	patient_id	BIGINT	19	√		NULL	The internal patient identifier
prescriptions	Table	patient_id	BIGINT	19	√		NULL	The internal patient identifier
onsite_portal_activity	Table	patient_id	BIGINT	19	√		NULL	The internal patient identifier
claims	Table	patient_id	BIGINT	19			null	The internal patient identifier
pro_assessments	Table	patient_id	INT	10			null	The internal patient identifier
questionnaire_response	Table	patient_id	INT	10	√		NULL	The internal patient identifier
ar_session	Table	patient_id	BIGINT	19			null	The internal patient identifier
form_taskman	Table	PATIENT_ID	BIGINT	19			null	The internal patient identifier
procedure_order	Table	patient_id	BIGINT	19			null	The internal patient identifier
voids	Table	patient_id	BIGINT	19			null	The internal patient identifier
procedure_order	Table	patient_instructions	MEDIUMTEXT	16777215	√		NULL	Instructions to be given to the patient for the procedure
users	Table	patient_menu_role	VARCHAR	50			'standard'	Patient menu role for the user. EMPTY for exports
onsite_documents	Table	patient_signature	TEXT	65535	√		NULL
onsite_documents	Table	patient_signed_status	SMALLINT UNSIGNED	5			null
onsite_documents	Table	patient_signed_time	DATETIME	19	√		NULL
ar_activity	Table	pay_amount	DECIMAL	12			0.00	The actual payment amount received (in DECIMAL format), which may differ from the fee amount due to adjustments or discounts.
ar_session	Table	pay_total	DECIMAL	12			0.00	The total payment amount for the claim or billing invoice.
ar_activity	Table	payer_claim_number	VARCHAR	30	√		NULL	The claim number or reference number provided by the payer or insurance company for this payment activity.
ar_session	Table	payer_id	INT	10			null	The insurance company being billed. If this is self-pay the id will be 0
billing	Table	payer_id	INT	10	√		NULL	The insurance company being billed. If this is self-pay the id will be 0
claims	Table	payer_id	INT	10			0	The insurance company being billed. If this is self-pay the id will be 0
claims	Table	payer_type	TINYINT	3			0	The payer type code, indicating the source of payment (0=patient, 1=primary insurance, 2=secondary insurance, etc).
ar_activity	Table	payer_type	INT	10			null	The payer type code, indicating the source of payment (0=patient, 1=primary insurance, 2=secondary insurance, etc).
ar_session	Table	payment_method	VARCHAR	25			null	Comes from the list_options.list_id=‘payment_method’ The method of payment, e.g., ACH, Cash, CC, Check, etc.
ar_session	Table	payment_type	VARCHAR	50			null	Comes from the list_options.list_id=‘payment_type’ and represents the type of payment, such as if this is a patient or insurance payment.
openemr_postcalendar_categories	Table	pc_active	BOOLEAN	3			1	Flag indicating the category is active
openemr_postcalendar_events	Table	pc_aid	VARCHAR	30	√		NULL	The provider this appointment is connected to
openemr_postcalendar_events	Table	pc_alldayevent	INT	10			0	Indicates if the event is an all-day event
openemr_postcalendar_events	Table	pc_apptstatus	VARCHAR	15			'-'	Comes from the list_options.list_id=‘apptstat’ if it is a single patient appointment OR list_options.list_id=‘groupstat’ if this is a group appointment. It represents the current appointment status checked in, checked out, waiting, etc
openemr_postcalendar_events	Table	pc_billing_location	SMALLINT	5			0	Billing facility location of the event
openemr_postcalendar_categories	Table	pc_catcolor	VARCHAR	50	√		NULL	Visual display color associated with the appointment category
openemr_postcalendar_categories	Table	pc_catdesc	MEDIUMTEXT	16777215	√		NULL	Description of the appointment category
openemr_postcalendar_categories	Table	pc_catid	INT UNSIGNED	10		√	null	Auto-incremented identifier for the appointment category
form_groups_encounter	Table	pc_catid	INT	10			5	The encounter service category taken from ‘openemr_postcalendar_categories’
form_encounter	Table	pc_catid	INT	10			5	event category from openemr_postcalendar_categories
openemr_postcalendar_events	Table	pc_catid	INT	10			0	The appointment category
openemr_postcalendar_categories	Table	pc_catname	VARCHAR	100	√		NULL	Name of the appointment category
openemr_postcalendar_categories	Table	pc_cattype	INT	10			null	Type of category used in grouping categories
openemr_postcalendar_events	Table	pc_comments	INT	10	√		0	Comments associated with the event
openemr_postcalendar_categories	Table	pc_constant_id	VARCHAR	255	√		NULL	Identifier for the appointment category which is referenced in the codebase for appointment specific functionality
openemr_postcalendar_events	Table	pc_contemail	VARCHAR	255	√		NULL	Contact email address
openemr_postcalendar_events	Table	pc_contname	VARCHAR	50	√		NULL	Contact name
openemr_postcalendar_events	Table	pc_conttel	VARCHAR	50	√		NULL	Contact telephone number
openemr_postcalendar_events	Table	pc_counter	MEDIUMINT UNSIGNED	8	√		0	Event counter
openemr_postcalendar_categories	Table	pc_dailylimit	INT	10			0	Limit on daily appointments for the category
openemr_postcalendar_events	Table	pc_duration	BIGINT	19			0	Duration of the event
openemr_postcalendar_categories	Table	pc_duration	BIGINT	19			0	Duration of the appointment in seconds
openemr_postcalendar_events	Table	pc_eid	INT UNSIGNED	10		√	null	Surrogate id of the record used as the primary incrementing key
openemr_postcalendar_categories	Table	pc_end_all_day	BOOLEAN	3			0	Flag indicating if the end date is all-day
openemr_postcalendar_categories	Table	pc_end_date_flag	BOOLEAN	3			0	Flag indicating the use of an end date for the appointment
openemr_postcalendar_categories	Table	pc_end_date_freq	INT	10			0	Frequency of the end date
openemr_postcalendar_categories	Table	pc_end_date_type	INT	10	√		NULL	Type of end date for the appointment
openemr_postcalendar_categories	Table	pc_enddate	DATE	10	√		NULL	End date of the appointment
openemr_postcalendar_events	Table	pc_endDate	DATE	10			'0000-00-00'	End date of the event
openemr_postcalendar_events	Table	pc_endTime	TIME	10	√		NULL	End time of the event
openemr_postcalendar_events	Table	pc_eventDate	DATE	10			'0000-00-00'	Date of the event
openemr_postcalendar_events	Table	pc_eventstatus	INT	10			0	Event status -1=hidden,0=queued,1=approved
openemr_postcalendar_events	Table	pc_facility	INT	10			0	The facility for where the service for this appointment will be rendered
openemr_postcalendar_events	Table	pc_fee	VARCHAR	50	√		NULL	Event fee
openemr_postcalendar_events	Table	pc_gid	INT	10	√		0	The therapy group id this appointment is for
openemr_postcalendar_events	Table	pc_hometext	MEDIUMTEXT	16777215	√		NULL	Description of the event
openemr_postcalendar_events	Table	pc_informant	VARCHAR	20	√		NULL	User creating the event
openemr_postcalendar_events	Table	pc_language	VARCHAR	30	√		NULL	Language of the event
openemr_postcalendar_categories	Table	pc_last_updated	DATETIME	19			current_timestamp()
openemr_postcalendar_events	Table	pc_location	MEDIUMTEXT	16777215	√		NULL	Location of the event
openemr_postcalendar_events	Table	pc_multiple	INT UNSIGNED	10			null	Multiple occurrences of the event. Used if this is a recurring appointment.
openemr_postcalendar_events	Table	pc_pid	VARCHAR	11	√		NULL	The internal patient identifier
openemr_postcalendar_events	Table	pc_prefcatid	INT	10			0	Preferred category id for a provider available slot
openemr_postcalendar_categories	Table	pc_recurrfreq	INT	10			0	Frequency of recurring appointments
openemr_postcalendar_events	Table	pc_recurrfreq	INT	10			0	Recurrence frequency of the event
openemr_postcalendar_events	Table	pc_recurrspec	MEDIUMTEXT	16777215	√		NULL	Recurrence specification of the event
openemr_postcalendar_categories	Table	pc_recurrspec	MEDIUMTEXT	16777215	√		NULL	Specification for recurring appointments in php array serialized format. Includes information on the repeating frequency, the type of repeat (daily, weekday,week,monthly, etc)
openemr_postcalendar_categories	Table	pc_recurrtype	INT	10			0	Type of recurring appointment 0=Not recurring,1=Recurring appointment
openemr_postcalendar_events	Table	pc_recurrtype	INT	10			0	Recurrence type of the event
openemr_postcalendar_events	Table	pc_room	VARCHAR	20			''	Comes from the list_options.list_id=‘patient_flow_board_rooms’ and represents the facility room that the patient has been assigned to for this appointment if one has been assigned
openemr_postcalendar_events	Table	pc_sendalertemail	VARCHAR	3			'NO'	Send email alerts for the event
openemr_postcalendar_events	Table	pc_sendalertsms	VARCHAR	3			'NO'	Send SMS alerts for the event
openemr_postcalendar_categories	Table	pc_seq	INT	10			0	Sequence number for the category
openemr_postcalendar_events	Table	pc_sharing	INT	10			0	Sharing status of the event
openemr_postcalendar_events	Table	pc_startTime	TIME	10	√		NULL	Start time of the event
openemr_postcalendar_events	Table	pc_time	DATETIME	19	√		NULL	Time of the event
openemr_postcalendar_events	Table	pc_title	VARCHAR	150	√		NULL	Title of the event
openemr_postcalendar_events	Table	pc_topic	INT	10			1	Topic id of the event
openemr_postcalendar_events	Table	pc_website	VARCHAR	255	√		NULL	Website associated with the event
form_vitals	Table	ped_bmi	DECIMAL	6	√		NULL	pediatric bmi percentile
form_vitals	Table	ped_head_circ	DECIMAL	6	√		NULL	pediatric head circumference percentile
form_vitals	Table	ped_weight_height	DECIMAL	6	√		NULL	pediatric weight height percentile
form_reviewofs	Table	pemphigus	VARCHAR	5	√		NULL
onsite_portal_activity	Table	pending_action	VARCHAR	255	√		NULL
form_reviewofs	Table	peptic_ulcer_disease	VARCHAR	5	√		NULL
prescriptions	Table	per_refill	INT	10	√		NULL
benefit_eligibility	Table	percent	DECIMAL	3	√		NULL	Benefit percentage, if applicable
form_ros	Table	peripheal	VARCHAR	3	√		NULL
prescriptions	Table	pharmacy_id	INT	10	√		NULL	The internal identifier for the pharmacy that is connected to this prescription
patient_data	Table	pharmacy_id	INT	10			0	The patient’s default pharmacy to send prescriptions to
form_reviewofs	Table	pheumothorax	VARCHAR	5	√		NULL
form_eye_acuity	Table	PHODVA	VARCHAR	25	√		NULL
users	Table	phone	VARCHAR	30	√		NULL	Phone number for the user. EMPTY for exports
facility	Table	phone	VARCHAR	30	√		NULL	Phone number of the facility
patient_data	Table	phone_biz	VARCHAR	255			''	Business phone number of the patient
patient_data	Table	phone_cell	VARCHAR	255			''	Cell phone number of the patient
patient_data	Table	phone_contact	VARCHAR	255			''	Contact phone number of the patient
patient_data	Table	phone_home	VARCHAR	255			''	Home phone number of the patient
users	Table	phonecell	VARCHAR	30	√		NULL	Cell phone number for the user. EMPTY for exports
users	Table	phonew1	VARCHAR	30	√		NULL	Work phone number for the user.
users	Table	phonew2	VARCHAR	30	√		NULL	Alternative Work phone number for the user.
form_eye_acuity	Table	PHOSVA	VARCHAR	25	√		NULL
form_ros	Table	photophobia	VARCHAR	3	√		NULL
users	Table	physician_type	VARCHAR	50	√		NULL	Type or designation of the physician (e.g., standard, specialist).
billing	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
form_note	Table	pid	Unknown	0			null	The internal patient identifier
form_dictation	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
form_CAMOS_subcategory	Table	pid	Unknown	0			null	The internal patient identifier
form_vitals	Table	pid	BIGINT	19	√		0	The internal patient identifier
transactions	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
ar_activity	Table	pid	INT	10			null	The internal patient identifier
form_ankleinjury	Table	pid	Unknown	0			null	The internal patient identifier
form_eye_hpi	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
amendments	Table	pid	BIGINT	19			null	The internal patient identifier
form_track_anything	Table	pid	Unknown	0			null	The internal patient identifier
form_eye_antseg	Table	pid	BIGINT	19	√		NULL
document_templates	Table	pid	Unknown	0			null	The internal patient identifier.
therapy_groups_participants	Table	pid	BIGINT	19			null	The internal patient identifier
form_phq9	Table	pid	Unknown	0			null	The internal patient identifier
clinical_plans	Table	pid	BIGINT	19			0	The internal patient identifier
form_eye_biometrics	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
form_bronchitis	Table	pid	Unknown	0			null	The internal patient identifier
form_painmap	Table	pid	Unknown	0			null	The internal patient identifier
patient_history	Table	pid	BIGINT	19			null	The internal patient identifier
form_transfer_summary	Table	pid	Unknown	0			null	The internal patient identifier
form_eye_postseg	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
patient_reminders	Table	pid	BIGINT	19			null	The internal patient identifier
form_eye_external	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
onsite_signatures	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
form_treatment_plan	Table	pid	Unknown	0			null	The internal patient identifier
therapy_groups_participant_attendance	Table	pid	BIGINT	19			null	The internal patient identifier
form_care_plan	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
form_misc_billing_options	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
form_eye_ros	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
form_questionnaire_assessments	Table	pid	BIGINT	19			0	The internal patient identifier
form_eye_locking	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
form_eye_neuro	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
drug_sales	Table	pid	BIGINT	19			0	The internal patient identifier
insurance_data	Table	pid	BIGINT	19			0	The internal patient identifier
form_eye_base	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
form_clinical_notes	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
form_encounter	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
form_clinical_instructions	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
forms	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
form_sdoh	Table	pid	Unknown	0			null	The internal patient identifier
lists	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
form_eye_mag_orders	Table	pid	BIGINT	19			null	The internal patient identifier
form_CAMOS_category	Table	pid	Unknown	0			null	The internal patient identifier
pnotes	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
form_prior_auth	Table	pid	Unknown	0			null	The internal patient identifier
patient_data	Table	pid	BIGINT	19			0	The internal patient identifier used throughout the export to represent this unique patient record
form_eye_refraction	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
form_eye_mag_dispense	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
form_eye_vitals	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
issue_encounter	Table	pid	Unknown	0			null	The internal patient identifier
form_eye_acuity	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
onsite_documents	Table	pid	BIGINT UNSIGNED	20	√		NULL	The internal patient identifier
rule_patient_data	Table	pid	BIGINT	19			null	The internal patient identifier
patient_access_onsite	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
form_observation	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
patient_tracker	Table	pid	BIGINT	19			0	The internal patient identifier
form_ros	Table	pid	BIGINT	19			null	The internal patient identifier
form_soap	Table	pid	BIGINT	19	√		0	The internal patient identifier
form_reviewofs	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
form_gad7	Table	pid	Unknown	0			null	The internal patient identifier
form_CAMOS	Table	pid	Unknown	0			null	The internal patient identifier
shared_attributes	Table	pid	BIGINT	19			null	The internal patient identifier
form_eye_mag_impplan	Table	pid	BIGINT	19			null	The internal patient identifier
history_data	Table	pid	BIGINT	19			0	The internal patient identifier
form_CAMOS_item	Table	pid	Unknown	0			null	The internal patient identifier
form_eye_mag_wearing	Table	PID	BIGINT	19			null	The internal patient identifier
form_aftercare_plan	Table	pid	Unknown	0			null	The internal patient identifier
form_functional_cognitive_status	Table	pid	BIGINT	19	√		NULL	The internal patient identifier
form_soap	Table	plan	MEDIUMTEXT	16777215	√		NULL
form_eye_mag_impplan	Table	plan	VARCHAR	3000	√		NULL
form_eye_locking	Table	PLAN	TEXT	65535	√		NULL
benefit_eligibility	Table	plan_description	VARCHAR	255	√		NULL	Description of the insurance plan
insurance_data	Table	plan_name	VARCHAR	255	√		NULL
benefit_eligibility	Table	plan_type	VARCHAR	255	√		NULL	Type of insurance plan
issue_types	Table	plural	VARCHAR	75			''
form_eye_mag_impplan	Table	PMSFH_link	VARCHAR	50	√		NULL
form_ros	Table	pnd	VARCHAR	3	√		NULL
insurance_data	Table	policy_number	VARCHAR	255	√		NULL
insurance_data	Table	policy_type	VARCHAR	25			''	Whether this is the ‘primary’, ‘secondary’, or ‘tertiary’ insurance
form_ros	Table	polydypsia	VARCHAR	3	√		NULL
form_reviewofs	Table	polyps	VARCHAR	5	√		NULL
form_ros	Table	polyuria	VARCHAR	3	√		NULL
form_reviewofs	Table	poor_appetite	VARCHAR	5	√		NULL
form_reviewofs	Table	poor_circulation	VARCHAR	5	√		NULL
form_reviewofs	Table	poor_hearing	VARCHAR	5	√		NULL
patient_access_onsite	Table	portal_login_username	VARCHAR	100	√		NULL	User entered username
patient_access_onsite	Table	portal_onetime	VARCHAR	255	√		NULL	One time login key. Empty for export.
patient_access_onsite	Table	portal_pwd	VARCHAR	255	√		NULL	Hash of the patient password. Empty for export.
patient_access_onsite	Table	portal_pwd_status	TINYINT	3	√		1	0=>Password Created Through Demographics by The provider or staff. Patient Should Change it at first time it.1=>Pwd updated or created by patient itself
pnotes	Table	portal_relation	VARCHAR	100	√		NULL
users	Table	portal_user	BOOLEAN	3			0	Indicates if the user is a portal user (1 for portal user, 0 for non-portal user). EMPTY for exports
patient_access_onsite	Table	portal_username	VARCHAR	100	√		NULL
form_groups_encounter	Table	pos_code	TINYINT	3	√		NULL	Place of service code
facility	Table	pos_code	TINYINT	3	√		NULL	POS (Place of Service) code of the facility
form_encounter	Table	pos_code	TINYINT	3	√		NULL
form_track_anything_type	Table	position	Unknown	0			null	The order this element should be filled out in the track anything population mechanism
ar_activity	Table	post_date	DATE	10	√		NULL	The date (in DATE format) when the payment was posted, if specified at the time of payment.
form_ros	Table	post_nasal_drip	VARCHAR	3	√		NULL
ar_activity	Table	post_time	DATETIME	19			null	Time of the posting on the date referenced in post_date
ar_session	Table	post_to_date	DATE	10			null	The date when the payment is posted to the claim or billing invoice.
ar_activity	Table	post_user	INT	10			null	The user ID (foreign key reference to the users table) of the person who posted the payment.
patient_data	Table	postal_code	VARCHAR	255			''	Postal code of the patient’s address
facility	Table	postal_code	VARCHAR	11	√		NULL	Postal code of the facility
procedure_providers	Table	ppid	BIGINT	19		√	null	Surrogate ID of the record used as the primary incrementing key
patient_data	Table	preferred_name	TEXT	65535	√		NULL
drug_sales	Table	prescription_id	INT	10			0
prescriptions	Table	prescriptionguid	VARCHAR	50	√		NULL
patient_data	Table	prevent_portal_apps	MEDIUMTEXT	16777215	√		NULL
patient_history	Table	previous_name_enddate	DATE	10	√		NULL
patient_history	Table	previous_name_first	TEXT	65535	√		NULL
patient_history	Table	previous_name_last	TEXT	65535	√		NULL
patient_history	Table	previous_name_middle	TEXT	65535	√		NULL
patient_history	Table	previous_name_prefix	TEXT	65535	√		NULL
patient_history	Table	previous_name_suffix	TEXT	65535	√		NULL
patient_data	Table	pricelevel	VARCHAR	255			'standard'	Price level information of the patient
billing	Table	pricelevel	VARCHAR	31	√		''	Price level associated with billing
drug_sales	Table	pricelevel	VARCHAR	31	√		''
facility	Table	primary_business_entity	INT	10			0	Primary business entity (0-Not set as the primary business entity, 1-Set as the primary business entity)
form_misc_billing_options	Table	prior_auth_number	VARCHAR	20	√		NULL
prescriptions	Table	prn	VARCHAR	30	√		NULL
procedure_order_code	Table	procedure_code	VARCHAR	64			''	like procedure_type.procedure_code
procedure_questions	Table	procedure_code	VARCHAR	31			''	references procedure_type.procedure_code to identify this order type
procedure_type	Table	procedure_code	VARCHAR	64			''	Code and code system identifying this procedure in the format of codesystem:code
procedure_answers	Table	procedure_code	VARCHAR	31	√		NULL
procedure_order_code	Table	procedure_name	VARCHAR	255			''	descriptive name of the procedure code
procedure_answers	Table	procedure_order_id	BIGINT	19			0	references procedure_order.procedure_order_id
procedure_order	Table	procedure_order_id	BIGINT	19		√	null	Surrogate id of the procedure order record
procedure_order_code	Table	procedure_order_id	BIGINT	19			null	references procedure_order.procedure_order_id
procedure_report	Table	procedure_order_id	BIGINT	19	√		NULL	References the procedure order for which this report is associated.
procedure_order_code	Table	procedure_order_seq	INT	10			null	Supports multiple tests per order. Procedure_order_seq incremented in code
procedure_answers	Table	procedure_order_seq	INT	10			0	references procedure_order_code.procedure_order_seq
procedure_report	Table	procedure_order_seq	INT	10			1	References procedure_order_code.procedure_order_seq.
procedure_order_code	Table	procedure_order_title	VARCHAR	255	√		NULL
procedure_order	Table	procedure_order_type	VARCHAR	32			'laboratory_test'	Comes from the list_options.list_id=‘order_type’ and represents the type of procedure order this is (order, lab test, imaging, physical exams, etc
procedure_report	Table	procedure_report_id	BIGINT	19		√	null	Unique identifier for the procedure report. This is the primary key.
procedure_result	Table	procedure_report_id	BIGINT	19			null	references procedure_report.procedure_report_id
procedure_result	Table	procedure_result_id	BIGINT	19		√	null	Surrogate id of the record used as the primary incrementing key
procedure_order_code	Table	procedure_source	CHAR	1			'1'	1=original order, 2=added after order sent
procedure_order_code	Table	procedure_type	VARCHAR	31	√		NULL
procedure_order	Table	procedure_type	Unknown	0			null	Comes from the list_options.list_id=‘proc_type’ and represents the kind of procedure_type this is (‘group’, ‘order’, ‘discrete_result’, etc’)
procedure_type	Table	procedure_type	VARCHAR	31			''	Comes from the list_options.list_id=‘proc_type’ and represents the kind of procedure_type this is (‘group’, ‘order’, ‘discrete_result’, etc’)
procedure_type	Table	procedure_type_id	BIGINT	19		√	null	Surrogate id of the record used as the primary incrementing key
form_track_anything	Table	procedure_type_id	Unknown	0			null
procedure_type	Table	procedure_type_name	VARCHAR	64	√		NULL
billing	Table	process_date	DATETIME	19	√		NULL	Date when the bill was moved into the processing state
claims	Table	process_file	VARCHAR	255	√		NULL	Processing file - File associated with claim processing
billing	Table	process_file	VARCHAR	255	√		NULL	File associated with billing process
claims	Table	process_time	DATETIME	19	√		NULL	Processing time - Time of claim processing
questionnaire_repository	Table	profile	VARCHAR	255	√		NULL	Profile information for the questionnaire
form_reviewofs	Table	prostate_cancer	VARCHAR	5	√		NULL
form_reviewofs	Table	prostate_problems	VARCHAR	5	√		NULL
patient_data	Table	prot_indi_effdate	MEDIUMTEXT	16777215	√		NULL
patient_data	Table	protect_indicator	MEDIUMTEXT	16777215	√		NULL
procedure_providers	Table	protocol	VARCHAR	15			'DL'	Protocol for communication. Empty on Export
insurance_data	Table	provider	VARCHAR	255	√		NULL	The insurance company that insures the patient
onsite_documents	Table	provider	INT UNSIGNED	10	√		NULL
form_aftercare_plan	Table	provider	Unknown	0			null	Provider assigned to the patient for aftercare planning.UNUSED
questionnaire_repository	Table	provider	INT UNSIGNED	10	√		NULL	Identifier for the provider associated with the inputting/creation of this questionnaire
procedure_order	Table	provider_id	BIGINT	19			0	References users.id, representing the ordering provider
billing	Table	provider_id	INT	10	√		NULL	The insurance company being billed. If this is self-pay the id will be 0
forms	Table	provider_id	BIGINT	19			0	References users.id to identify the provider who is responsible for or involved in the healthcare this form relates to. This field is only populated in some types of procedure order forms and when a form is a dynamic Layout Based Form (LBF)
form_encounter	Table	provider_id	INT	10	√		0	default and main provider for this visit
form_groups_encounter	Table	provider_id	INT	10	√		0	Default and main provider for this visit
form_misc_billing_options	Table	provider_id	INT	10	√		NULL
prescriptions	Table	provider_id	INT	10	√		NULL	The id of the user that created this prescription
procedure_order	Table	provider_number	VARCHAR	30	√		NULL	Provider number
form_misc_billing_options	Table	provider_qualifier_code	VARCHAR	2	√		NULL
patient_data	Table	provider_since_date	TEXT	65535	√		NULL
patient_data	Table	providerID	INT	10	√		NULL	The id of the assigned provider to this user
form_ros	Table	psoriasis	VARCHAR	3	√		NULL
patient_tracker_element	Table	pt_tracker_id	BIGINT	19			0	maps to id column in patient_tracker table
patient_data	Table	publ_code_eff_date	MEDIUMTEXT	16777215	√		NULL
patient_data	Table	publicity_code	MEDIUMTEXT	16777215	√		NULL
patient_data	Table	pubpid	VARCHAR	255			''	The public facing Medical Record Number (MRN) of the patient
form_vitals	Table	pulse	DECIMAL	12	√		NULL
form_eye_antseg	Table	PUPIL_COMMENTS	TEXT	65535	√		NULL
form_eye_antseg	Table	PUPIL_NORMAL	VARCHAR	2	√		'1'
form_eye_hpi	Table	QUALITY1	VARCHAR	255	√		NULL
form_eye_hpi	Table	QUALITY2	TEXT	65535	√		NULL
form_eye_hpi	Table	QUALITY3	TEXT	65535	√		NULL
drug_sales	Table	quantity	INT	10			0	The number of items sold of the drug
prescriptions	Table	quantity	VARCHAR	31	√		NULL
procedure_answers	Table	question_code	VARCHAR	31			''	references procedure_questions.question_code
procedure_questions	Table	question_code	VARCHAR	31			''	code identifying this question
procedure_questions	Table	question_text	VARCHAR	255			''	descriptive text for question_code
questionnaire_repository	Table	questionnaire	LONGTEXT	2147483647	√		NULL	JSON serialized version of the questionnaire. If the type of this record is Questionnaire than the JSON will be a serialized definition of a FHIR Questionnaire resource
questionnaire_response	Table	questionnaire	LONGTEXT	2147483647	√		NULL	the subject questionnaire json
form_questionnaire_assessments	Table	questionnaire	LONGTEXT	2147483647	√		NULL
questionnaire_response	Table	questionnaire_foreign_id	BIGINT	19	√		NULL	questionnaire_repository id for subject questionnaire
form_questionnaire_assessments	Table	questionnaire_id	TEXT	65535	√		NULL	The foreign uuid key to the questionnaire.questionnaire_id
questionnaire_repository	Table	questionnaire_id	VARCHAR	255	√		NULL	Unique public identifier
questionnaire_response	Table	questionnaire_id	VARCHAR	255	√		NULL	Id for questionnaire content. String version of UUID
questionnaire_response	Table	questionnaire_name	VARCHAR	255	√		NULL
questionnaire_response	Table	questionnaire_response	LONGTEXT	2147483647	√		NULL	questionnaire response json
form_questionnaire_assessments	Table	questionnaire_response	LONGTEXT	2147483647	√		NULL
medex_recalls	Table	r_created	TIMESTAMP	19			'0000-00-00 00:00:00'	Timestamp when the recall was created
medex_recalls	Table	r_eventDate	DATE	10			null	Date of Appointment or Recall
medex_recalls	Table	r_facility	INT	10			null	FK facility.id associated with the recall
medex_recalls	Table	r_ID	INT	10		√	null	Unique ID for the recall record
medex_recalls	Table	r_pid	INT	10			null	The internal patient identifier
medex_recalls	Table	r_PRACTID	INT	10			null	UNUSED - Practice ID associated with the recall
medex_recalls	Table	r_provider	INT	10			null	Provider ID associated with the recall FK to users.id
medex_recalls	Table	r_reason	VARCHAR	255	√		NULL	Reason for the recall
patient_data	Table	race	VARCHAR	255			''	Race of the patient
form_eye_external	Table	RADNEXA	TEXT	65535	√		NULL
patient_tracker	Table	random_drug_test	BOOLEAN	3	√		NULL	Tracks if the patient should be given a randomized drug test. NULL if not randomized. If randomized, 0 is no, 1 is yes
procedure_result	Table	range	VARCHAR	255			''	Result range
procedure_type	Table	range	VARCHAR	255			''	Default for procedure_result.range
form_reviewofs	Table	rashes	VARCHAR	5	√		NULL
form_eye_external	Table	RBROW	TEXT	65535	√		NULL
form_eye_external	Table	RCAROTID	TEXT	65535	√		NULL
form_eye_external	Table	RCNV	TEXT	65535	√		NULL
form_eye_external	Table	RCNVII	TEXT	65535	√		NULL
lists	Table	reaction	VARCHAR	255			''	Comes from the list_options.list_id=‘reaction’ and represents the reaction of the patient to the allergy
drugs	Table	reactions	MEDIUMTEXT	16777215	√		NULL
form_encounter	Table	reason	LONGTEXT	2147483647	√		NULL
voids	Table	reason	VARCHAR	31	√		''
form_groups_encounter	Table	reason	LONGTEXT	2147483647	√		NULL	The reason for the encounter
ar_activity	Table	reason_code	VARCHAR	255	√		NULL	An optional reason code used to explain adjustments or changes in the payment amount (e.g., primary payer adjustment reason code).
procedure_order_code	Table	reason_code	VARCHAR	31	√		NULL
form_care_plan	Table	reason_code	VARCHAR	31	√		NULL
immunizations	Table	reason_code	VARCHAR	31	√		NULL	Medical code explaining reason of the vital observation value in form codesystem:codetype;…;
procedure_order_code	Table	reason_date_high	DATETIME	19	√		NULL
form_care_plan	Table	reason_date_high	DATETIME	19	√		NULL	The date the explanation reason for the care plan entry value ends
procedure_order_code	Table	reason_date_low	DATETIME	19	√		NULL
form_care_plan	Table	reason_date_low	DATETIME	19	√		NULL	The date the reason was recorded
form_care_plan	Table	reason_description	MEDIUMTEXT	16777215	√		NULL
immunizations	Table	reason_description	MEDIUMTEXT	16777215	√		NULL	Human readable text description of the reason_code column
procedure_order_code	Table	reason_description	MEDIUMTEXT	16777215	√		NULL
patient_reminders	Table	reason_inactivated	VARCHAR	31			''	Maps to list_options list rule_reminder_inactive_opt
form_care_plan	Table	reason_status	VARCHAR	31	√		NULL
procedure_order_code	Table	reason_status	VARCHAR	31	√		NULL
form_vital_details	Table	reason_status	Unknown	0			null	Valid values are ‘completed’,‘negated’,‘pending’ or '' for none
onsite_messages	Table	recip_id	VARCHAR	255			null	JSON array of message recipients. If the message is being sent to one or more clinical staff it will be a JSON array of the usernames from the users table. If a user sends the message it will be a JSON array of one or more patient_data.pid ids. On EHI export this array is filtered to only include patient_data.pids that are in the the specific export task. These messages will be duplicated if patients are in different export tasks but received the same message.
extended_log	Table	recipient	VARCHAR	255	√		NULL
onsite_mail	Table	recipient_id	VARCHAR	128	√		NULL	ID of the message recipient. If a patient is sending this message to a user this will be the users.id, otherwise it is i the patient_data.pid
onsite_mail	Table	recipient_name	VARCHAR	255	√		NULL	Name of the message recipient. This will be the first and last name of the recipient.
history_data	Table	recreational_drugs	LONGTEXT	2147483647	√		NULL
procedure_providers	Table	recv_app_id	VARCHAR	255			''	Receiving application ID (MSH-5.1). Empty on Export
procedure_providers	Table	recv_fac_id	VARCHAR	255			''	Receiving facility ID (MSH-6.1). Empty on Export
form_ros	Table	redness	VARCHAR	3	√		NULL
patient_data	Table	ref_providerID	INT	10	√		NULL	The id of the user that referred this patient
form_eye_mag_dispense	Table	REFDATE	DATETIME	19	√		NULL
ar_session	Table	reference	VARCHAR	255			''	The check or EOB (Explanation of Benefits) number associated with the payment.
form_encounter	Table	referral_source	VARCHAR	31			''
patient_data	Table	referral_source	VARCHAR	30			''	Source of referral for the patient
form_groups_encounter	Table	referral_source	VARCHAR	31			''	Source of the referral
lists	Table	referredby	VARCHAR	255	√		NULL	The human readable name of Referring physician and practice
patient_data	Table	referrer	VARCHAR	255			''	Referrer of the patient
patient_data	Table	referrerID	VARCHAR	255			''	ID of the referring user
form_encounter	Table	referring_provider_id	INT	10	√		0	referring provider, if any, for this visit
prescriptions	Table	refills	INT	10	√		NULL
form_eye_mag_dispense	Table	REFTYPE	VARCHAR	10	√		NULL
immunizations	Table	refusal_reason	VARCHAR	31	√		NULL	Comes from the list_options.list_id=‘immunization_refusal_reason’ and represents the reasons the individual refused immunization
patient_data	Table	regdate	DATETIME	19	√		NULL	Registration Date
lists	Table	reinjury_id	BIGINT	19			0	UNUSED - will be removed in the future
procedure_type	Table	related_code	VARCHAR	255			''	Suggested code(s) for follow-up services if result is abnormal
drugs	Table	related_code	VARCHAR	255			''	may reference a related codes.code
history_data	Table	relatives_cancer	LONGTEXT	2147483647	√		NULL
history_data	Table	relatives_diabetes	LONGTEXT	2147483647	√		NULL
history_data	Table	relatives_epilepsy	LONGTEXT	2147483647	√		NULL
history_data	Table	relatives_heart_problems	LONGTEXT	2147483647	√		NULL
history_data	Table	relatives_high_blood_pressure	LONGTEXT	2147483647	√		NULL
history_data	Table	relatives_mental_illness	LONGTEXT	2147483647	√		NULL
history_data	Table	relatives_stroke	LONGTEXT	2147483647	√		NULL
history_data	Table	relatives_suicide	LONGTEXT	2147483647	√		NULL
history_data	Table	relatives_tuberculosis	LONGTEXT	2147483647	√		NULL
patient_data	Table	religion	VARCHAR	40			''	Religion of the patient
rule_action_item	Table	reminder_message	MEDIUMTEXT	16777215	√		NULL	Custom message in patient reminder
procedure_providers	Table	remote_host	VARCHAR	255			''	Remote host for communication. Empty on Export
form_ros	Table	renal_stones	VARCHAR	3	√		NULL
drugs	Table	reorder_point	FLOAT	12			0
form_misc_billing_options	Table	replacement_claim	BOOLEAN	3	√		0
onsite_mail	Table	reply_mail_chain	INT	10	√		NULL	Reply mail chain ID
procedure_report	Table	report_notes	MEDIUMTEXT	16777215	√		NULL	Notes from the lab related to the report.
procedure_report	Table	report_status	VARCHAR	31			''	Comes from the list_options.list_id=‘proc_rep_status’ and represents the current state/status of the report (e.g. received, complete, error)
form_taskman	Table	REQ_DATE	DATETIME	19			null
prescriptions	Table	request_intent	VARCHAR	100	√		NULL	option_id in list_options.list_id=medication-request-intent
lists_medication	Table	request_intent	VARCHAR	100	√		NULL	option_id in list_options.list_id=medication-request-intent
lists_medication	Table	request_intent_title	VARCHAR	255			null	title in list_options.list_id=medication-request-intent
prescriptions	Table	request_intent_title	VARCHAR	255			null	title in list_options.list_id=medication-request-intent
onsite_portal_activity	Table	require_audit	BOOLEAN	3	√		1
procedure_questions	Table	required	BOOLEAN	3			0	1 = required, 0 = not
issue_encounter	Table	resolved	Unknown	0			null	0=Issue not resolved,1=Issue is resolved
form_eye_locking	Table	Resource	VARCHAR	50	√		NULL
form_vitals	Table	respiration	DECIMAL	12	√		NULL
benefit_eligibility	Table	response_create_date	DATE	10	√		NULL	Date when the benefit response was created
eligibility_verification	Table	response_id	VARCHAR	32	√		NULL	Identifier for the response related to the eligibility verification
form_questionnaire_assessments	Table	response_id	TEXT	65535	√		NULL	The foreign uuid key to the questionnaire_response.response_id
benefit_eligibility	Table	response_id	BIGINT	19			null	Surrogate ID of the benefit eligibility record used as the primary incrementing key
questionnaire_response	Table	response_id	VARCHAR	255	√		NULL	A globally unique id for answer set. String version of UUID
form_questionnaire_assessments	Table	response_meta	TEXT	65535	√		NULL	json meta data for the response resource
benefit_eligibility	Table	response_modify_date	DATE	10	√		NULL	Date when the benefit response was last modified
benefit_eligibility	Table	response_status	enum('A', 'D')	1	√		'A'	Status of the response (Active ‘A’ or Denied ‘D’)
rule_patient_data	Table	result	VARCHAR	255			''
procedure_result	Table	result	VARCHAR	255			''	Result data
form_track_anything_results	Table	result	Unknown	0			null	The user entered response for this data element being tracked
procedure_result	Table	result_code	VARCHAR	31			''	LOINC code, might match a procedure_type.procedure_code
procedure_result	Table	result_data_type	CHAR	1			'S'	N=Numeric, S=String, F=Formatted, E=External, L=Long text as the first line of comments
form_observation	Table	result_status	VARCHAR	32	√		NULL
procedure_result	Table	result_status	VARCHAR	31			''	Result status (preliminary, cannot be done, final, corrected, incomplete, etc.)
procedure_result	Table	result_text	VARCHAR	255			''	Description of result_code
procedure_providers	Table	results_path	VARCHAR	255			''	Path for results. Empty on Export
form_eye_postseg	Table	RETINA_COMMENTS	TEXT	65535	√		NULL
lists	Table	returndate	DATE	10	√		NULL	UNUSED - will be removed in the future
billing	Table	revenue_code	VARCHAR	6			''	Item revenue code
onsite_documents	Table	review_date	DATETIME	19	√		NULL
procedure_report	Table	review_status	VARCHAR	31			'received'	The status of the report review (e.g., pending review, received, reviewed).
notes	Table	revision	Unknown	0			null	UNUSED
documents	Table	revision	TIMESTAMP	19			current_timestamp()	Timestamp of the last time the document was changed and persisted
form_reviewofs	Table	rheumotoid_arthritis	VARCHAR	5	√		NULL
form_reviewofs	Table	ringing_in_ears	VARCHAR	5	√		NULL
form_eye_external	Table	RLF	VARCHAR	25	√		NULL
form_eye_external	Table	RLL	TEXT	65535	√		NULL
form_eye_external	Table	RMCT	TEXT	65535	√		NULL
form_eye_external	Table	RMRD	VARCHAR	25	√		NULL
patient_tracker_element	Table	room	VARCHAR	20			''	Comes from the list_options.list_id=‘patient_flow_board_rooms’ and represents the facility room that the patient has been assigned to and this tracker element is connected to
form_eye_ros	Table	ROSCOMMENTS	TEXT	65535	√		NULL
form_eye_ros	Table	ROSCV	TEXT	65535	√		NULL
form_eye_ros	Table	ROSDERM	TEXT	65535	√		NULL
form_eye_ros	Table	ROSENDOCRINE	TEXT	65535	√		NULL
form_eye_ros	Table	ROSGENERAL	TEXT	65535	√		NULL
form_eye_ros	Table	ROSGI	TEXT	65535	√		NULL
form_eye_ros	Table	ROSGU	TEXT	65535	√		NULL
form_eye_ros	Table	ROSHEENT	TEXT	65535	√		NULL
form_eye_ros	Table	ROSIMMUNO	TEXT	65535	√		NULL
form_eye_ros	Table	ROSMUSCULO	TEXT	65535	√		NULL
form_eye_ros	Table	ROSNEURO	TEXT	65535	√		NULL
form_eye_ros	Table	ROSPSYCH	TEXT	65535	√		NULL
form_eye_ros	Table	ROSPULM	TEXT	65535	√		NULL
prescriptions	Table	route	VARCHAR	100	√		NULL	Max size 100 characters is same max as immunizations
drugs	Table	route	VARCHAR	31			'0'
immunizations	Table	route	VARCHAR	100	√		NULL	Comes from the list_options.list_id=‘drug_route’ and represents a list of immunization manufacturers
procedure_type	Table	route_admin	VARCHAR	31			''	Oral, injection
form_eye_external	Table	RTEMPART	TEXT	65535	√		NULL
prescriptions	Table	rtx	INT	10	√		NULL
form_eye_external	Table	RUL	TEXT	65535	√		NULL
form_eye_external	Table	RVFISSURE	VARCHAR	25	√		NULL
form_eye_mag_wearing	Table	RX_NUMBER	INT	10			null
form_eye_mag_wearing	Table	RX_TYPE	VARCHAR	25	√		NULL
form_eye_mag_dispense	Table	RXCOMMENTS	MEDIUMTEXT	16777215	√		NULL
prescriptions	Table	rxnorm_drugcode	VARCHAR	25	√		NULL
form_eye_mag_dispense	Table	RXTYPE	VARCHAR	20	√		NULL
form_ros	Table	s_acne	VARCHAR	3	√		NULL
form_ros	Table	s_cancer	VARCHAR	3	√		NULL
form_ros	Table	s_disease	VARCHAR	3	√		NULL
form_ros	Table	s_other	VARCHAR	3	√		NULL
drug_sales	Table	sale_date	DATE	10			null	The date the sale occurred on
drug_sales	Table	sale_id	INT	10		√	null	The unique identifier for this record
form_eye_acuity	Table	SCNEARODVA	VARCHAR	25	√		NULL
form_eye_acuity	Table	SCNEAROSVA	VARCHAR	25	√		NULL
form_eye_acuity	Table	SCODVA	VARCHAR	25	√		NULL
form_reviewofs	Table	scoliosis	VARCHAR	5	√		NULL
pro_assessments	Table	score	DOUBLE	22			null	T-Score for the assessment
form_eye_acuity	Table	SCOSVA	VARCHAR	25	√		NULL
history_data	Table	seatbelt_use	LONGTEXT	2147483647	√		NULL
users	Table	see_auth	INT	10			1	Indicates if the user has the ability to see authorizations.
form_ros	Table	seizures	VARCHAR	3	√		NULL
drug_sales	Table	selector	VARCHAR	255	√		''	references drug_templates.selector
procedure_providers	Table	send_app_id	VARCHAR	255			''	Sending application ID (MSH-3.1). Empty on Export
procedure_providers	Table	send_fac_id	VARCHAR	255			''	Sending facility ID (MSH-4.1). Empty on Export
onsite_messages	Table	sender_id	VARCHAR	64	√		NULL	ID of the message sender. This will be the patient_data.pid if a patient sent the message. Otherwise it is the users.id if a user sent the message.
onsite_mail	Table	sender_id	VARCHAR	128	√		NULL	ID of the message sender. If a patient is sending this message to a user this will be the patient_data.pid, otherwise it is the users.id
onsite_mail	Table	sender_name	VARCHAR	255	√		NULL	Name of the message sender
form_groups_encounter	Table	sensitivity	VARCHAR	30	√		NULL	Sensitivity information related to the encounter as to who should be able to access / view this encounter
form_encounter	Table	sensitivity	VARCHAR	30	√		NULL
layout_options	Table	seq	INT	10			0
procedure_questions	Table	seq	INT	10			0	sequence number for ordering
patient_tracker_element	Table	seq	VARCHAR	4			''	This is a numerical sequence for this pt_tracker_id events and in combination with the pt_tracker_id uniquely identifies this record
list_options	Table	seq	INT	10			0
procedure_type	Table	seq	INT	10			0	Sequence number for ordering
ar_activity	Table	sequence_no	INT UNSIGNED	10			null	A unique identifier for this payment activity, incremented in the code.
facility	Table	service_location	BOOLEAN	3			1	Indicates if it’s a service location (0-Not a service location, 1-Service location)
ar_session	Table	session_id	INT UNSIGNED	10		√	null	The unique identifier for an accounting session, used as a surrogate key.
ar_activity	Table	session_id	INT UNSIGNED	10			null	The session ID (foreign key reference to the ar_session table) associated with this payment activity, if applicable.
form_eye_hpi	Table	SEVERITY1	VARCHAR	255	√		NULL
form_eye_hpi	Table	SEVERITY2	TEXT	65535	√		NULL
form_eye_hpi	Table	SEVERITY3	TEXT	65535	√		NULL
lists	Table	severity_al	VARCHAR	50	√		NULL	Comes from the list_options.list_id=‘severity_ccda’ and represents the severity of the allergic reaction of the patient to the allergy
patient_data	Table	sex	VARCHAR	255			''	Gender of the patient
patient_data	Table	sexual_orientation	MEDIUMTEXT	16777215	√		NULL
form_reviewofs	Table	sexually_transmitted_disease	VARCHAR	5	√		NULL
form_encounter	Table	shift	VARCHAR	31			''
form_reviewofs	Table	shortness_of_breath	VARCHAR	5	√		NULL
form_ros	Table	shortness_of_breath	VARCHAR	3	√		NULL
form_reviewofs	Table	shortness_of_breath_2	VARCHAR	5	√		NULL
form_reviewofs	Table	shoulder_problems	VARCHAR	5	√		NULL
onsite_signatures	Table	sig_hash	VARCHAR	255			null	sha3-512 hash of the sig_image
onsite_signatures	Table	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
onsite_signatures	Table	signator	VARCHAR	255			null
onsite_signatures	Table	signature	TEXT	65535	√		NULL
esign_signatures	Table	signature_hash	VARCHAR	255			null	Hash of the signature itself hash(tid,table,uid,is_lock,hash,amendment). sha1= less than 50 chars; greater than 50chars=sha3-512 algorithm.
onsite_signatures	Table	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
issue_types	Table	singular	VARCHAR	75			''
form_ros	Table	sinus_problems	VARCHAR	3	√		NULL
form_reviewofs	Table	sinus_surgery	VARCHAR	5	√		NULL
form_reviewofs	Table	sinusitis	VARCHAR	5	√		NULL
prescriptions	Table	site	VARCHAR	50	√		NULL
prescriptions	Table	size	VARCHAR	25	√		NULL
documents	Table	size	INT	10	√		NULL	Size of the document in bytes
drugs	Table	size	VARCHAR	25			''
history_data	Table	sleep_patterns	LONGTEXT	2147483647	√		NULL
patient_reminders	Table	sms_status	BOOLEAN	3			0	0 if not sent and 1 if sent
form_ros	Table	snoring	VARCHAR	3	√		NULL
patient_data	Table	soap_import_status	TINYINT	3	√		NULL	SOAP Import Status (1-Prescription Press 2-Prescription Import 3-Allergy Press 4-Allergy Import)
form_ros	Table	social_difficulties	VARCHAR	3	√		NULL
form_ros	Table	sore_throat	VARCHAR	3	√		NULL
users	Table	source	TINYINT	3	√		NULL	An indicator of the source of the user (e.g., internal or external).
procedure_report	Table	source	BIGINT	19			0	References the user who entered this report data.
layout_options	Table	source	CHAR	1			'F'	F=Form, D=Demographics, H=History, E=Encounter
questionnaire_repository	Table	source_url	TEXT	65535	√		NULL	URL associated with the questionnaire for where the questionnaire originated or where more information about the questionnaire can be obtained
users	Table	specialty	VARCHAR	255	√		NULL	The specialty of the user (e.g., cardiology, pediatrics).
procedure_type	Table	specimen	VARCHAR	31			''	Blood, urine, saliva, etc.
procedure_order	Table	specimen_fasting	VARCHAR	31	√		NULL	Fasting status of the patient at the time the specimen was collected. 0=Patient not fasting, 1=Patient was fasting at time of collection
procedure_order	Table	specimen_location	VARCHAR	31			''	Comes from the list_options.list_id=‘Specimen_Location’ and represents the location the specimen was collected at
procedure_report	Table	specimen_num	VARCHAR	63			''	A unique identifier for the specimen associated with the report.
procedure_order	Table	specimen_type	VARCHAR	31			''	Comes from the list_options.list_id=‘Specimen_Type’ and represents the specimen type collected for the procedure
procedure_order	Table	specimen_volume	VARCHAR	30			''	Volume of the specimen
form_reviewofs	Table	splenectomy	VARCHAR	5	√		NULL
form_ros	Table	sputum	VARCHAR	3	√		NULL
patient_data	Table	squad	VARCHAR	32			''	The Athletic Squad this patient is a member of
patient_data	Table	ss	VARCHAR	255			''	Social Security Number of the patient
procedure_type	Table	standard_code	VARCHAR	255			''	Industry standard code type and code (e.g. CPT4:12345)
prescriptions	Table	start_date	DATE	10	√		NULL
benefit_eligibility	Table	start_date	DATE	10	√		NULL	Start date for the benefit coverage
patient_tracker_element	Table	start_datetime	DATETIME	19	√		NULL	The datetime this tracker element event was created
facility	Table	state	VARCHAR	50	√		NULL	State where the facility is located
patient_data	Table	state	VARCHAR	255			''	State of the patient’s address
users	Table	state	VARCHAR	30	√		NULL	State or province of residence or practice for the user. EMPTY for exports
users	Table	state2	VARCHAR	30	√		NULL	Alternative State or province of residence or practice for the user. EMPTY for exports
users	Table	state_license_number	VARCHAR	25	√		NULL	State license number for the user.
onsite_portal_activity	Table	status	VARCHAR	255	√		NULL
pro_assessments	Table	status	VARCHAR	255			null	ordered or completed
patient_data	Table	status	VARCHAR	255			''	Marital Status: M = Married, S = Single, or something else
claims	Table	status	TINYINT	3			0	Claim status - Status of the billing claim. -1=Leave Unchanged,1=Unbilled,2=Mark as billed, 7=Denied
questionnaire_repository	Table	status	VARCHAR	31	√		NULL	Status information for the questionnaire
onsite_signatures	Table	status	VARCHAR	128			'waiting'
patient_tracker_element	Table	status	VARCHAR	31			''	Comes from the list_options.list_id=‘apptstat’ if it is a single patient appointment OR list_options.list_id=‘groupstat’ if this is a group appointment. It represents the current appointment status at the time this tracker element was created
questionnaire_response	Table	status	VARCHAR	63	√		NULL	form current status. completed,active,incomplete
form_eye_neuro	Table	STEREOPSIS	VARCHAR	25	√		NULL
form_reviewofs	Table	stiff_joints	VARCHAR	5	√		NULL
form_groups_encounter	Table	stmt_count	INT	10			0	The statement count
form_encounter	Table	stmt_count	INT	10			0
form_reviewofs	Table	stomach_pains	VARCHAR	5	√		NULL
documents	Table	storagemethod	TINYINT	3			0	Storage method (0->Harddisk, 1->CouchDB)
form_ros	Table	stream	VARCHAR	3	√		NULL
patient_data	Table	street	VARCHAR	255			''	Street address of the patient
users	Table	street	VARCHAR	60	√		NULL	Street address for the user. EMPTY for exports
facility	Table	street	VARCHAR	255	√		NULL	Street address of the facility
users	Table	street2	VARCHAR	60	√		NULL	Alternative street address for the user. EMPTY for exports
patient_data	Table	street_line_2	TEXT	65535	√		NULL
users	Table	streetb	VARCHAR	60	√		NULL	Secondary street address for the user. EMPTY for exports
users	Table	streetb2	VARCHAR	60	√		NULL	Alternative street address for the user. EMPTY for exports
form_reviewofs	Table	strep_throat	VARCHAR	5	√		NULL
form_reviewofs	Table	stress_test	VARCHAR	5	√		NULL
form_ros	Table	stroke	VARCHAR	3	√		NULL
issue_types	Table	style	SMALLINT	5			0
form_CAMOS	Table	subcategory	Unknown	0			null	The CAMOS subcategory template that this note is based on
form_CAMOS_item	Table	subcategory_id	Unknown	0			null	The CAMOS subcategory this item is part of.
form_soap	Table	subjective	MEDIUMTEXT	16777215	√		NULL
claims	Table	submitted_claim	MEDIUMTEXT	16777215	√		NULL	Submitted claim - Claims form data
insurance_data	Table	subscriber_city	VARCHAR	255	√		NULL
insurance_data	Table	subscriber_country	VARCHAR	255	√		NULL
insurance_data	Table	subscriber_DOB	DATE	10	√		NULL
insurance_data	Table	subscriber_employer	VARCHAR	255	√		NULL
insurance_data	Table	subscriber_employer_city	VARCHAR	255	√		NULL
insurance_data	Table	subscriber_employer_country	VARCHAR	255	√		NULL
insurance_data	Table	subscriber_employer_postal_code	VARCHAR	255	√		NULL
insurance_data	Table	subscriber_employer_state	VARCHAR	255	√		NULL
insurance_data	Table	subscriber_employer_street	VARCHAR	255	√		NULL
insurance_data	Table	subscriber_employer_street_line_2	TEXT	65535	√		NULL
insurance_data	Table	subscriber_fname	VARCHAR	255	√		NULL
insurance_data	Table	subscriber_lname	VARCHAR	255	√		NULL
insurance_data	Table	subscriber_mname	VARCHAR	255	√		NULL
insurance_data	Table	subscriber_phone	VARCHAR	255	√		NULL
insurance_data	Table	subscriber_postal_code	VARCHAR	255	√		NULL
insurance_data	Table	subscriber_relationship	VARCHAR	255	√		NULL
insurance_data	Table	subscriber_sex	VARCHAR	25	√		NULL
insurance_data	Table	subscriber_ss	VARCHAR	255	√		NULL
insurance_data	Table	subscriber_state	VARCHAR	255	√		NULL
insurance_data	Table	subscriber_street	VARCHAR	255	√		NULL
insurance_data	Table	subscriber_street_line_2	TEXT	65535	√		NULL
drugs	Table	substitute	INT	10			0
prescriptions	Table	substitute	INT	10	√		NULL
list_options	Table	subtype	VARCHAR	31			''
lists	Table	subtype	VARCHAR	31			''	The sub type of the issue where the list_options.list_id=‘issue_subtypes’
users	Table	suffix	VARCHAR	255	√		NULL	Suffix for the user’s name (e.g., Jr., Sr.).
patient_data	Table	suffix	TEXT	65535	√		NULL
form_groups_encounter	Table	supervisor_id	INT	10	√		0	Supervising provider, if any, for this visit
form_encounter	Table	supervisor_id	INT	10	√		0	supervising provider, if any, for this visit
users	Table	supervisor_id	INT	10			0	Unique identifier of the user’s supervisor. EMPTY for exports
form_ros	Table	swelling	VARCHAR	3	√		NULL
form_reviewofs	Table	swollen_joints	VARCHAR	5	√		NULL
form_reviewofs	Table	swollen_lymph_nodes	VARCHAR	5	√		NULL
form_ros	Table	syncope	VARCHAR	3	√		NULL
esign_signatures	Table	table	VARCHAR	255			null	Table name for the signature. This will either be ‘forms’ if it represents an individual form the provider is e-signing or ‘form_encounter’ if it represents the entire encounter record the provider is attesting to.
onsite_portal_activity	Table	table_action	LONGTEXT	2147483647	√		NULL
onsite_portal_activity	Table	table_args	LONGTEXT	2147483647	√		NULL
form_observation	Table	table_code	VARCHAR	255	√		NULL
billing	Table	target	VARCHAR	30	√		NULL	Target associated with billing code
claims	Table	target	VARCHAR	30	√		NULL	Claim target - Target associated with the claim
facility	Table	tax_id_type	VARCHAR	31			''	Tax ID type for the facility
users	Table	taxonomy	VARCHAR	30			'207Q00000X'	Taxonomy code associated with the user.
form_eye_locking	Table	Technician	VARCHAR	50	√		NULL
form_vitals	Table	temp_method	VARCHAR	255	√		NULL
form_vitals	Table	temperature	DECIMAL	12	√		NULL	patient temperature stored in fahrenheit degrees
document_templates	Table	template_content	Unknown	0			null	Digital document template that is assigned to a patient to be filled out. Uses Domain Specific Language (DSL) template tags to inject specific functionality into the template for patients to fill out. Patient data template tags can be found at the following URL: https://www.open-emr.org/wiki/index.php/Patient_Portal_Document_Templates
onsite_documents	Table	template_data	LONGTEXT	2147483647	√		NULL
forms	Table	therapy_group_id	INT	10	√		NULL	ID of the therapy group that this form’s encounter session is connected to
form_reviewofs	Table	throat_cancer	VARCHAR	5	√		NULL
form_reviewofs	Table	throat_cancer_surgery	VARCHAR	5	√		NULL
documents	Table	thumb_url	VARCHAR	255	√		NULL	URL of the document’s thumbnail
form_ros	Table	thyroid_problems	VARCHAR	3	√		NULL
form_ros	Table	tia	VARCHAR	3	√		NULL
esign_signatures	Table	tid	INT	10			null	Table row ID for signature. This is either the forms.id or the form_encounter.encounter id
list_options	Table	timestamp	TIMESTAMP	19			current_timestamp()
form_eye_hpi	Table	TIMING1	VARCHAR	255	√		NULL
form_eye_hpi	Table	TIMING2	TEXT	65535	√		NULL
form_eye_hpi	Table	TIMING3	TEXT	65535	√		NULL
form_ros	Table	tinnitus	VARCHAR	3	√		NULL
procedure_questions	Table	tips	VARCHAR	255			''	Additional instructions for answering the question
users	Table	title	VARCHAR	30	√		NULL	Title or designation of the user (e.g., MD, RN).
form_eye_mag_impplan	Table	title	VARCHAR	255			null
pnotes	Table	title	VARCHAR	255	√		NULL
patient_data	Table	title	VARCHAR	255			''	Title of the patient
transactions	Table	title	VARCHAR	255			''
onsite_mail	Table	title	VARCHAR	255	√		NULL	Title of the message
list_options	Table	title	VARCHAR	255			''
layout_options	Table	title	MEDIUMTEXT	16777215	√		NULL
lists	Table	title	VARCHAR	255	√		NULL	The human readable description of the issue
layout_options	Table	titlecols	TINYINT	3			1
form_taskman	Table	TO_ID	BIGINT	19			null
history_data	Table	tobacco	LONGTEXT	2147483647	√		NULL
list_options	Table	toggle_setting_1	BOOLEAN	3			0
list_options	Table	toggle_setting_2	BOOLEAN	3			0
history_data	Table	tonsillectomy	DATETIME	19	√		NULL
form_reviewofs	Table	tonsillectomy	VARCHAR	5	√		NULL
form_track_anything_results	Table	track_anything_id	Unknown	0			null
form_track_anything_results	Table	track_timestamp	Unknown	0			null	The time this result was recorded
drug_sales	Table	trans_type	TINYINT	3			1	1=sale, 2=purchase, 3=return, 4=transfer, 5=adjustment
pharmacies	Table	transmit_method	INT	10			1
procedure_order_code	Table	transport	VARCHAR	31	√		NULL
procedure_type	Table	transport	VARCHAR	31	√		NULL
form_eye_postseg	Table	TROPICAMIDE	VARCHAR	25			null
questionnaire_response	Table	tscore	DOUBLE	22	√		NULL	T-Score
prescriptions	Table	txDate	DATE	10			null
benefit_eligibility	Table	type	VARCHAR	4	√		NULL	Type of benefit
issue_types	Table	type	VARCHAR	75			''
insurance_data	Table	type	enum('primary', 'secondary', 'tertiary')	9	√		NULL
onsite_signatures	Table	type	VARCHAR	128			null	witness-signature
documents	Table	type	enum('file_url', 'blob', 'web_url')	8	√		NULL	Type of the document (e.g., ‘file_url’, ‘blob’, ‘web_url’)
lists	Table	type	VARCHAR	255	√		NULL	The type of the issue (allergy, medication, etc) where the issue_types.category=‘default’
insurance_type_codes	Table	type	VARCHAR	60			null
procedure_providers	Table	type	VARCHAR	31	√		NULL	Type of provider or organization
questionnaire_repository	Table	type	VARCHAR	63			'Questionnaire'	Type of questionnaire (e.g., FHIR ‘Questionnaire’)
lists	Table	udi	VARCHAR	255	√		NULL	The unique device identifier. Populated if the issue is of type medical_device
lists	Table	udi_data	MEDIUMTEXT	16777215	√		NULL	The JSON serialized medical device as returned from the https://accessgudid.nlm.nih.gov/api/v2/devices/lookup.json api. Populated if the issue is of type medical_device
esign_signatures	Table	uid	INT	10			null	User id for the signing user.
form_reviewofs	Table	ulcerations	VARCHAR	5	√		NULL
form_reviewofs	Table	ulcerative_colitis	VARCHAR	5	√		NULL
prescriptions	Table	unit	INT	10	√		NULL
drugs	Table	unit	VARCHAR	31			'0'
billing	Table	units	INT	10	√		NULL	Number of units for billing
procedure_result	Table	units	VARCHAR	31			''	Units for the result
procedure_type	Table	units	VARCHAR	31			''	Default for procedure_result.units
layout_options	Table	uor	BOOLEAN	3			1
pnotes	Table	update_by	BIGINT	19	√		NULL
immunizations	Table	update_date	TIMESTAMP	19			current_timestamp()
pnotes	Table	update_date	DATETIME	19	√		NULL
pro_assessments	Table	updated_at	DATETIME	19			null	this field indicates the completion time when the status is completed
patient_data	Table	updated_by	BIGINT	19	√		NULL	The id of the user that last updated this record
prescriptions	Table	updated_by	BIGINT	19	√		NULL	The id of the user that last updated this record
immunizations	Table	updated_by	BIGINT	19	√		NULL	The user that last updated this record
users	Table	upin	VARCHAR	255	√		NULL	Universal Physician Identification Number for the user.
form_ros	Table	urgency	VARCHAR	3	√		NULL
documents	Table	url	VARCHAR	255	√		NULL	URL of the document
users	Table	url	VARCHAR	255	√		NULL	URL associated with the user’s profile.
prescriptions	Table	usage_category	VARCHAR	100	√		NULL	option_id in list_options.list_id=medication-usage-category
lists_medication	Table	usage_category	VARCHAR	100	√		NULL	option_id in list_options.list_id=medication-usage-category
lists_medication	Table	usage_category_title	VARCHAR	255			null	title in list_options.list_id=medication-usage-category
prescriptions	Table	usage_category_title	VARCHAR	255			null	title in list_options.list_id=medication-usage-category
groups	Table	user	LONGTEXT	2147483647	√		NULL	The username of the user that belongs to this group.
onsite_mail	Table	user	VARCHAR	255	√		NULL	User associated with the message
form_care_plan	Table	user	VARCHAR	255	√		NULL
form_painmap	Table	user	Unknown	0			null	The user that created this record.
form_dictation	Table	user	VARCHAR	255	√		NULL
form_CAMOS_item	Table	user	Unknown	0			null	User responsible for creating this category.
form_group_attendance	Table	user	VARCHAR	255	√		NULL	The username of the user that created this record.
patient_tracker_element	Table	user	VARCHAR	255			''	This is the user that created this element
prescriptions	Table	user	VARCHAR	50	√		NULL
form_gad7	Table	user	Unknown	0			null	The user that created this record.
drug_sales	Table	user	VARCHAR	255	√		NULL
form_eye_mag_dispense	Table	user	VARCHAR	255	√		NULL
form_observation	Table	user	VARCHAR	255	√		NULL
form_treatment_plan	Table	user	Unknown	0			null	The user that created this record.
form_reviewofs	Table	user	VARCHAR	255	√		NULL
form_vitals	Table	user	VARCHAR	255	√		NULL
transactions	Table	user	VARCHAR	255			''
lists	Table	user	VARCHAR	255	√		NULL	The user that created or last updated this issue
form_phq9	Table	user	Unknown	0			null	The user that created this record.
form_questionnaire_assessments	Table	user	VARCHAR	255	√		NULL
form_CAMOS_category	Table	user	Unknown	0			null	User responsible for creating this category.
form_eye_base	Table	user	VARCHAR	255	√		NULL
form_ankleinjury	Table	user	Unknown	0			null	User responsible for creating the record.
form_functional_cognitive_status	Table	user	VARCHAR	255	√		NULL
onsite_documents	Table	user	Unknown	0			null	User who created the esignature
form_clinical_instructions	Table	user	VARCHAR	255	√		NULL
form_soap	Table	user	VARCHAR	255	√		NULL
pnotes	Table	user	VARCHAR	255	√		NULL
form_bronchitis	Table	user	Unknown	0			null	User responsible for creating the record.
extended_log	Table	user	VARCHAR	255	√		NULL
form_misc_billing_options	Table	user	VARCHAR	255	√		NULL
onsite_signatures	Table	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-’
form_clinical_notes	Table	user	VARCHAR	255	√		NULL
forms	Table	user	VARCHAR	255	√		NULL	User responsible for creating this form.
form_aftercare_plan	Table	user	Unknown	0			null	User responsible for creating the aftercare plan.
form_sdoh	Table	user	Unknown	0			null	The user that created this record.
billing	Table	user	INT	10	√		NULL	The user that created this billing record.
shared_attributes	Table	user_id	BIGINT	19			null	User who last updated this shared attribute
voids	Table	user_id	BIGINT	19			null	references users.id
therapy_groups_counselors	Table	user_id	INT	10			null
ar_session	Table	user_id	INT	10			null	The reference to the user ID the created this billing session
pro_assessments	Table	user_id	INT	10			null	ID for user that orders the form
history_data	Table	userarea11	MEDIUMTEXT	16777215	√		NULL
history_data	Table	userarea12	MEDIUMTEXT	16777215	√		NULL
history_data	Table	userdate11	DATE	10	√		NULL
history_data	Table	userdate12	DATE	10	√		NULL
history_data	Table	userdate13	DATE	10	√		NULL
history_data	Table	userdate14	DATE	10	√		NULL
history_data	Table	userdate15	DATE	10	√		NULL
form_taskman	Table	USERFIELD_1	VARCHAR	50	√		NULL
patient_data	Table	userlist1	VARCHAR	255			''	User list field 1
patient_data	Table	userlist2	VARCHAR	255			''	User list field 2
patient_data	Table	userlist3	VARCHAR	255			''	User list field 3
patient_data	Table	userlist4	VARCHAR	255			''	User list field 4
patient_data	Table	userlist5	VARCHAR	255			''	User list field 5
patient_data	Table	userlist6	VARCHAR	255			''	User list field 6
patient_data	Table	userlist7	VARCHAR	255			''	User list field 7
onsite_messages	Table	username	VARCHAR	64			null	Username associated with the message sender This will be the patient’s portal username if a patient sent the message. Otherwise it is the user’s username if a user sent the message.
users	Table	username	VARCHAR	255	√		NULL	The username associated with the user’s account.
patient_data	Table	usertext1	VARCHAR	255			''	User text field 1
history_data	Table	usertext11	MEDIUMTEXT	16777215	√		NULL
history_data	Table	usertext12	VARCHAR	255			''
history_data	Table	usertext13	VARCHAR	255			''
history_data	Table	usertext14	VARCHAR	255			''
history_data	Table	usertext15	VARCHAR	255			''
history_data	Table	usertext16	VARCHAR	255			''
history_data	Table	usertext17	VARCHAR	255			''
history_data	Table	usertext18	VARCHAR	255			''
history_data	Table	usertext19	VARCHAR	255			''
patient_data	Table	usertext2	VARCHAR	255			''	User text field 2
history_data	Table	usertext20	VARCHAR	255			''
history_data	Table	usertext21	VARCHAR	255			''
history_data	Table	usertext22	VARCHAR	255			''
history_data	Table	usertext23	VARCHAR	255			''
history_data	Table	usertext24	VARCHAR	255			''
history_data	Table	usertext25	VARCHAR	255			''
history_data	Table	usertext26	VARCHAR	255			''
history_data	Table	usertext27	VARCHAR	255			''
history_data	Table	usertext28	VARCHAR	255			''
history_data	Table	usertext29	VARCHAR	255			''
patient_data	Table	usertext3	VARCHAR	255			''	User text field 3
history_data	Table	usertext30	VARCHAR	255			''
patient_data	Table	usertext4	VARCHAR	255			''	User text field 4
patient_data	Table	usertext5	VARCHAR	255			''	User text field 5
patient_data	Table	usertext6	VARCHAR	255			''	User text field 6
patient_data	Table	usertext7	VARCHAR	255			''	User text field 7
patient_data	Table	usertext8	VARCHAR	255			''	User text field 8
form_ros	Table	utis	VARCHAR	3	√		NULL
openemr_postcalendar_events	Table	uuid	BINARY	16	√		NULL	UUID of the record
procedure_report	Table	uuid	BINARY	16	√		NULL	Universally unique identifier for the procedure report.
prescriptions	Table	uuid	BINARY	16	√		NULL
history_data	Table	uuid	BINARY	16	√		NULL
procedure_providers	Table	uuid	BINARY	16	√		NULL	UUID of the record
questionnaire_response	Table	uuid	BINARY	16	√		NULL
procedure_order	Table	uuid	BINARY	16	√		NULL	UUID of the record
facility	Table	uuid	BINARY	16	√		NULL	UUID of the record
questionnaire_repository	Table	uuid	BINARY	16	√		NULL	Universally unique identifier for the questionnaire in the EMR system
documents	Table	uuid	BINARY	16	√		NULL	Binary of Unique User Identifier that is for both external reference to this entity and for future offline use.
lists	Table	uuid	BINARY	16	√		NULL	UUID of the record
procedure_result	Table	uuid	BINARY	16	√		NULL	UUID of the record
patient_data	Table	uuid	BINARY	16	√		NULL	UUID of the record
form_encounter	Table	uuid	BINARY	16	√		NULL
form_clinical_notes	Table	uuid	BINARY	16	√		NULL
insurance_companies	Table	uuid	BINARY	16	√		NULL
users	Table	uuid	BINARY	16	√		NULL	Universally unique identifier for the user.
drugs	Table	uuid	BINARY	16	√		NULL
form_vitals	Table	uuid	BINARY	16	√		NULL
immunizations	Table	uuid	BINARY	16	√		NULL
patient_history	Table	uuid	BINARY	16	√		NULL
insurance_data	Table	uuid	BINARY	16	√		NULL
users	Table	valedictory	VARCHAR	255	√		NULL	Valedictory or honorary title of the user.
layout_options	Table	validation	VARCHAR	100	√		NULL
history_data	Table	value_1	VARCHAR	255	√		NULL
history_data	Table	value_2	VARCHAR	255	√		NULL
form_reviewofs	Table	vascular_surgery	VARCHAR	5	√		NULL
lists	Table	verification	VARCHAR	36			''	Comes from the list_options.list_id=‘allergyintolerance-verification’ and represents the confirmation status of the allergy
eligibility_verification	Table	verification_id	BIGINT	19		√	null	Unique identifier for eligibility verification
benefit_eligibility	Table	verification_id	BIGINT	19			null	The eligibility verification record that these benefits are retrieved from
claims	Table	version	INT UNSIGNED	10			null	Claim version - Incremented in code to track changes in claims
questionnaire_response	Table	version	INT	10			1
questionnaire_repository	Table	version	INT	10			1	Version number of the questionnaire
form_eye_neuro	Table	VERTFUSAMPS	TEXT	65535	√		NULL
form_ros	Table	vertigo	VARCHAR	3	√		NULL
patient_data	Table	vfc	VARCHAR	255			''	VFC information
immunizations	Table	vis_date	DATE	10	√		NULL	Date of VIS Statement
patient_reminders	Table	voice_status	BOOLEAN	3			0	0 if not sent and 1 if sent
voids	Table	void_id	BIGINT	19		√	null
form_ros	Table	vomiting	VARCHAR	3	√		NULL
form_encounter	Table	voucher_number	VARCHAR	255			''	also called referral number
form_vitals	Table	waist_circ	DECIMAL	12	√		NULL	patient waist circumference stored in imperial in
form_ros	Table	weakness	VARCHAR	3	√		NULL
facility	Table	website	VARCHAR	255	√		NULL	Website of the facility
form_vitals	Table	weight	DECIMAL	12	√		NULL	patient weight stored in imperial lbs
form_ros	Table	weight_change	VARCHAR	3	√		NULL
form_reviewofs	Table	weight_loss	VARCHAR	5	√		NULL
facility	Table	weno_id	VARCHAR	10	√		NULL	WENO ID for the facility
users	Table	weno_prov_id	VARCHAR	15	√		NULL	WENO Provider ID for the user. EMPTY for exports
form_eye_postseg	Table	WETTYPE	VARCHAR	10			null
voids	Table	what_voided	VARCHAR	31			null	checkout,receipt and maybe other options later
form_ros	Table	wheezing	VARCHAR	3	√		NULL
form_eye_acuity	Table	WODVANEAR	VARCHAR	25	√		NULL
form_reviewofs	Table	wrist_problems	VARCHAR	5	√		NULL
insurance_companies	Table	x12_default_eligibility_id	INT	10	√		NULL
insurance_companies	Table	x12_default_partner_id	INT	10	√		NULL
billing	Table	x12_partner_id	INT	10	√		NULL	The X12 partner clearinghouse id. Empty On Export
claims	Table	x12_partner_id	INT	10			0	X12 Partner identifier - Identifier for the X12 partner. Empty in export
insurance_companies	Table	x12_receiver_id	VARCHAR	25	√		NULL
facility	Table	x12_sender_id	VARCHAR	25	√		NULL	X12 Sender ID of the facility. EMPTY IN Export
drug_sales	Table	xfer_inventory_id	INT	10			0
users	Table	zip	VARCHAR	20	√		NULL	ZIP code or postal code for the user. EMPTY for exports
users	Table	zip2	VARCHAR	20	√		NULL	Alternative ZIP code or postal code for the user. EMPTY for exports

Showing 1 to 2,524 of 2,524 entries