_435.patients

Field	Type	Null	Default	Key	Extra	Comment
pat_id	int(11)	NO		PRI	auto_increment
pat_cus_id	int(11)	NO	0	MUL
pat_cli_id	int(11)	NO	0	MUL
pat_merged_into_pat_id	int(11)	YES				Merged Patient ID
pat_phy_id	int(11)	NO	0	MUL
pat_phy_id_referring	int(11)	NO	0	MUL
pat_phy_id_requested	int(11)	NO	0	MUL
pat_ref_to	tinyint(1)	NO	0
pat_ref_id	int(11)	NO	0
pat_loc_id	int(11)	YES		MUL		Indicates the patient's default location for encounters
pat_pid	varchar(20)	NO		MUL
pat_pid_ext	varchar(60)	NO		MUL
pat_usr_id_created	int(11)	NO	0	MUL
pat_usr_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
pat_usr_id_modified	int(11)	NO	0	MUL
pat_mrn	varchar(20)	NO
pat_xray_num	varchar(20)	NO
pat_ssn	varchar(11)	NO		MUL
pat_fname	varchar(40)	NO		MUL		First Name
pat_mname	varchar(40)	NO				Middle Name
pat_lname	varchar(40)	NO		MUL		Last Name
pat_suffix	varchar(10)	NO
pat_mother_maiden	varchar(20)	NO				Patient's Mother's Maiden name
pat_birth_fname	varchar(20)	NO				Patient's first name at birth if different now
pat_birth_mname	varchar(20)	NO				Patient's middle name at birth if different now
pat_birth_lname	varchar(20)	NO				Patient's last name at birth if different now
pat_credentials	varchar(20)	NO
pat_email	varchar(80)	NO
pat_email_refuse	int(1)	NO	0
pat_email_no_email	int(1)	NO	0
pat_bill_type	char(1)	NO	3
pat_dob	varchar(8)	NO		MUL
pat_birth_order	int(11)	NO	0			If part of multiple birth, indicates order patient was born in set. 0 if patient is single birth
pat_deceased_ts	varchar(12)	NO				12 digit date of death, empty if still alive
pat_sex	varchar(7)	NO
pat_birth_sex	varchar(8)	NO				http://hl7.org/fhir/us/core/ValueSet-birthsex.html
pat_seo_id	int(11)	NO	0	MUL		Sexual Orientation ID#
pat_seo_desc	varchar(40)	NO
pat_gi_id	int(11)	NO	0	MUL		GENDER IDENTITY ID#
pat_gi_desc	varchar(40)	NO
pat_race	varchar(50)	NO				No longer in use. Please see [customer].patients_races_map
pat_ethnicity	varchar(30)	NO
pat_eth_id	int(11)	NO	0			Ethnicity ID#
pat_lang_id	int(11)	NO	0
pat_pc_id	int(11)	NO	0	MUL
pat_maritial_status	varchar(30)	NO
pat_ctry_id	int(11)	YES				Patient Country ID
pat_address1	varchar(40)	NO
pat_address2	varchar(40)	NO
pat_city	varchar(30)	NO
pat_state	varchar(2)	NO
pat_zip	varchar(12)	YES
pat_zip_plus4	varchar(4)	NO
pat_fips_code	varchar(5)	NO				County code
pat_phone	varchar(20)	NO
pat_phone_work	varchar(20)	NO
pat_phone_other	varchar(20)	NO
pat_fax	varchar(20)	NO
pat_health_exchange	tinyint(1)	NO	0
pat_health_exchange_opt	tinyint(1)	NO	0
pat_contact_method	char(1)	NO	0
pat_apt_not_contact_method	int(11)	NO	0
pat_employer	varchar(40)	NO
pat_employer_occupation	varchar(30)	NO
pat_employer_status	varchar(30)	NO
pat_employer_ctry_id	int(11)	YES				Patient Employer Country ID
pat_employer_address1	varchar(40)	NO
pat_employer_address2	varchar(40)	NO				Employer address line 2
pat_employer_city	varchar(30)	NO
pat_employer_state	varchar(2)	NO
pat_employer_zip	varchar(12)	YES
pat_employer_zip_plus4	varchar(4)	NO
pat_guarantor_linked_pat_id	int(11)	NO	0	MUL
pat_guarantor_same_as_patient	tinyint(1)	NO	0
pat_guarantor	varchar(40)	NO
pat_guarantor_relation	varchar(20)	NO
pat_guarantor_ctry_id	int(11)	YES				Patient Guarantor Country ID
pat_guarantor_address1	varchar(40)	NO
pat_guarantor_address2	varchar(40)	NO
pat_guarantor_city	varchar(30)	NO
pat_guarantor_state	varchar(2)	NO
pat_guarantor_zip	varchar(12)	YES
pat_guarantor_zip_plus4	varchar(4)	NO
pat_guarantor_phone	varchar(20)	NO
pat_guarantor_phone_work	varchar(20)	NO
pat_guarantor_employer	varchar(40)	NO
pat_guarantor_dob	varchar(8)	NO
pat_guarantor_ssn	varchar(11)	NO
pat_ins1_linked_pat_id	int(11)	NO	0	MUL
pat_ins1_id	int(11)	NO	0	MUL
pat_ins1_irep_id	int(11)	NO	0	MUL		link to primary insurance repository record
pat_ins1_policy_num	varchar(40)	NO
pat_ins1_group_num	varchar(40)	NO
pat_ins1_copay	varchar(10)	NO
pat_ins1_start_date	varchar(8)	NO
pat_ins1_end_date	varchar(8)	NO
pat_ins1_insured_same_as_patient	tinyint(1)	NO	0
pat_ins1_insured	varchar(40)	NO
pat_ins1_insured_relation	varchar(20)	NO
pat_ins1_insured_dob	varchar(8)	NO
pat_ins1_insured_ssn	varchar(11)	NO
pat_ins1_insured_sex	varchar(7)	NO
pat_ins1_employer_name	varchar(40)	NO
pat_ins1_employer_ctry_id	int(11)	YES				Patient Primary Insurance Country ID
pat_ins1_employer_address	varchar(40)	NO
pat_ins1_employer_city	varchar(30)	NO
pat_ins1_employer_state	varchar(2)	NO
pat_ins1_employer_zip	varchar(12)	YES
pat_ins1_employer_zip_plus4	varchar(4)	NO
pat_ins1_msrc_id	int(11)	NO	0
pat_ins1_referral_num	varchar(40)	NO
pat_ins1_referral_start_date	varchar(8)	NO
pat_ins1_referral_end_date	varchar(8)	NO
pat_ins1_referral_num_visits	varchar(3)	NO
pat_ins1_verification_path	varchar(50)	NO
pat_ins1_vaccines	tinyint(1)	NO	0
pat_ins2_linked_pat_id	int(11)	NO	0	MUL
pat_ins2_id	int(11)	NO	0	MUL
pat_ins2_irep_id	int(11)	NO	0	MUL		link to primary insurance repository record
pat_ins2_policy_num	varchar(40)	NO
pat_ins2_group_num	varchar(40)	NO
pat_ins2_copay	varchar(10)	NO
pat_ins2_start_date	varchar(8)	NO
pat_ins2_end_date	varchar(8)	NO
pat_ins2_insured_same_as_patient	tinyint(1)	NO	0
pat_ins2_insured	varchar(40)	NO
pat_ins2_insured_relation	varchar(20)	NO
pat_ins2_insured_dob	varchar(8)	NO
pat_ins2_insured_ssn	varchar(11)	NO
pat_ins2_insured_sex	varchar(7)	NO
pat_ins2_employer_name	varchar(40)	NO
pat_ins2_employer_ctry_id	int(11)	YES				Patient Secondary Insurance Country ID
pat_ins2_employer_address	varchar(40)	NO
pat_ins2_employer_city	varchar(30)	NO
pat_ins2_employer_state	varchar(2)	NO
pat_ins2_employer_zip	varchar(12)	YES
pat_ins2_employer_zip_plus4	varchar(4)	NO
pat_ins2_msrc_id	int(11)	NO	0
pat_ins2_vaccines	tinyint(1)	NO	0
pat_ins3_linked_pat_id	int(11)	NO	0	MUL
pat_ins3_id	int(11)	NO	0	MUL
pat_ins3_irep_id	int(11)	NO	0	MUL		link to primary insurance repository record
pat_ins3_policy_num	varchar(40)	NO
pat_ins3_group_num	varchar(40)	NO
pat_ins3_copay	varchar(10)	NO
pat_ins3_start_date	varchar(8)	NO
pat_ins3_end_date	varchar(8)	NO
pat_ins3_insured_same_as_patient	tinyint(1)	NO	0
pat_ins3_insured	varchar(40)	NO
pat_ins3_insured_relation	varchar(20)	NO
pat_ins3_insured_dob	varchar(8)	NO
pat_ins3_insured_ssn	varchar(11)	NO
pat_ins3_insured_sex	varchar(7)	NO
pat_ins3_employer_name	varchar(40)	NO
pat_ins3_employer_ctry_id	int(11)	YES				Patient Tertiary Insurance Country ID
pat_ins3_employer_address	varchar(40)	NO
pat_ins3_employer_city	varchar(30)	NO
pat_ins3_employer_state	varchar(2)	NO
pat_ins3_employer_zip	varchar(12)	YES
pat_ins3_employer_zip_plus4	varchar(4)	NO
pat_ins3_msrc_id	int(11)	NO	0
pat_ins3_vaccines	tinyint(1)	NO	0
pat_incomplete	char(1)	NO	0	MUL
pat_notes	text	NO
pat_popup_notes	text	NO
pat_disabled	tinyint(1)	NO	0	MUL
pat_rcopia_id	varchar(24)	NO
pat_statement_disabled	tinyint(1)	NO	0
pat_statement_default	int(11)	NO	0			Indicates whether a patient can also receive paper statements when eStatements are turned on; 0 = Only eStatements, 1 = eStatements + Paper Statements
pat_psdr_id	int(11)	NO	0	MUL
pat_upa_id	int(11)	NO	0
pat_palg	tinyint(1)	NO	0
pat_pms	tinyint(1)	NO	0
pat_pip	tinyint(1)	NO	0
pat_med_rec	char(1)	NO	0
pat_sum_care	char(1)	NO	0
pat_emergency_name	varchar(80)	NO
pat_emergency_number	varchar(14)	NO
pat_pecr_id	int(11)	NO	0	MUL
pat_emergency_ctry_id	int(11)	YES				Patient Emergency Country ID
pat_emergency_address1	varchar(40)	NO
pat_emergency_address2	varchar(40)	NO
pat_emergency_city	varchar(30)	NO
pat_emergency_state	varchar(2)	NO
pat_emergency_zip	varchar(12)	YES
pat_emergency_zip_plus4	varchar(4)	NO
pat_pub_id	int(11)	NO	0
pat_min_due_amount	varchar(10)	NO
pat_preferred_name	varchar(20)	NO				Preferred name of patient
pat_relg_id	int(11)	NO	0			Patient Religion
pat_deceased_dt	datetime	YES				Deceased date time of patient
pat_citizenship_id	int(11)	NO	0			Citizenship ID#
pat_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
pat_created	timestamp	YES	CURRENT_TIMESTAMP

References

Local Column

References

pat_id

Table	Column
AzaleaStats.erx_debug	ed_pat_id
_1.appointment_recurrence	arec_pat_id
_1.appointments	apt_pat_id
_1.appointments_requests	aptreq_pat_id
_1.audits	aud_pat_id
_1.audits_archive	aud_pat_id
_1.audits_new	aud_pat_id
_1.audits_new_archive	aud_pat_id
_1.card_connect_profiles	cconp_pat_id
_1.charts	chrt_pat_id
_1.charts_care_plan	ccp_pat_id
_1.charts_cpt_codes	chcp_pat_id
_1.charts_diagnosis	cdx_pat_id
_1.charts_icd9_codes	cic_pat_id
_1.charts_medications	cm_pat_id
_1.charts_numbers	cnum_pat_id
_1.charts_procedures	cp_pat_id
_1.clinical_interventions_review_map	cirm_pat_id
_1.configured_encounters	confenc_pat_id
_1.cpoe_responses	cpoe_res_pat_id
_1.cqm_entries	cqme_pat_id
_1.cqm_errors	cqmer_pat_id
_1.documents	doc_pat_id
_1.encounter_soap_labels_values_groups	eslvg_pat_id
_1.encounters	enc_pat_id
_1.encounters	enc_guarantor_linked_pat_id
_1.encounters	enc_ins1_linked_pat_id
_1.encounters	enc_ins2_linked_pat_id
_1.encounters	enc_ins3_linked_pat_id
_1.encounters_cpt_codes	ecp_pat_id
_1.encounters_icd9_codes	eic_pat_id
_1.encounters_numbers	enum_pat_id
_1.encounters_patients_races_map	eprm_pat_id
_1.encounters_soap_labels_components	eslc_pat_id
_1.encounters_soap_labels_values	eslv_pat_id
_1.encounters_soap_labels_values_map	eslvm_pat_id
_1.encounters_soap_vitals	espv_pat_id
_1.encounters_stored_notes_patients_frequency	esnpf_pat_id
_1.encounters_ub04	enc_ub04_pat_id
_1.erx_webservice_transactions	ewt_pat_id
_1.hl7_accessions	acc_pat_id
_1.hl7_results	res_pat_id
_1.insurances_repository	irep_pat_id
_1.insurances_repository	irep_linked_pat_id
_1.insurances_verification	iv_pat_id
_1.ledger	led_pat_id
_1.orders	ord_pat_id
_1.orders_afps	oafp_pat_id
_1.orders_comments	orc_pat_id
_1.orders_icd9_codes	oic_pat_id
_1.orders_paps	opap_pat_id
_1.orders_paps_history	opaph_pat_id
_1.orders_standing	ost_pat_id
_1.orders_standing_dates	osd_pat_id
_1.orders_test_codes	otc_pat_id
_1.patient_access_restriction	patar_pat_id
_1.patient_amendments	pa_pat_id
_1.patient_configured_encounters	pce_pat_id
_1.patient_finance_records	pfr_pat_id
_1.patient_next_of_kin	pnk_pat_id
_1.patient_portal_requests	ppr_pat_id
_1.patients_additional_providers	pap_pat_id
_1.patients_allergies	palg_pat_id
_1.patients_authorization_numbers	pan_pat_id
_1.patients_classes_map	pcm_pat_id
_1.patients_configured_encounters_schedules	pces_pat_id
_1.patients_demographics_snapshots	pds_pat_id
_1.patients_demographics_snapshots	pds_guarantor_linked_pat_id
_1.patients_demographics_snapshots	pds_ins1_linked_pat_id
_1.patients_demographics_snapshots	pds_ins2_linked_pat_id
_1.patients_demographics_snapshots	pds_ins3_linked_pat_id
_1.patients_document_assembly	pda_pat_id
_1.patients_education_results	peres_pat_id
_1.patients_enrollments	pert_pat_id
_1.patients_erx_updates	peu_pat_id
_1.patients_ethnicities_map	pem_pat_id
_1.patients_handouts	phs_pat_id
_1.patients_health_concerns	phc_pat_id
_1.patients_health_observations	pho_pat_id
_1.patients_histories	ph_pat_id
_1.patients_icd9_problems	pip_pat_id
_1.patients_images	pi_pat_id
_1.patients_immunizations	pim_pat_id
_1.patients_implantable_devices	pid_pat_id
_1.patients_inventory	pinv_pat_id
_1.patients_medications	pms_pat_id
_1.patients_names	pn_pat_id
_1.patients_payment_methods	patpm_pat_id
_1.patients_payments_ledger_map	pplm_pat_id
_1.patients_payments_schedules	pps_pat_id
_1.patients_pids	ppid_pat_id
_1.patients_prescriptions	prx_pat_id
_1.patients_races_map	prm_pat_id
_1.patients_referrals	pref_pat_id
_1.patients_relatives_map	prm_pat_id
_1.patients_reminders	pr_pat_id
_1.patients_responsibility_estimates	prest_pat_id
_1.patients_smoking_status	pss_pat_id
_1.patients_social_answers	psa_pat_id
_1.patients_statements_map	pstm_pat_id
_1.patients_stored_messages	psm_pat_id
_1.patients_tasks	pt_pat_id
_1.patients_urls	pu_pat_id
_1.patients_vitals	pvs_pat_id
_1.poa	poa_pat_id
_1.portal_released_data	prd_pat_id
_1.portal_withheld_data	pwd_pat_id
_1.precerts	pre_pat_id
_1.precerts_comments	prc_pat_id
_1.precerts_cpt_codes	pcp_pat_id
_1.precerts_icd9_codes	pic_pat_id
_1.precerts_numbers	pnum_pat_id
_1.procedures_results	pres_pat_id
_1.radiology_order_notes	radnot_pat_id
_1.radiology_orders	rad_pat_id
_1.radiology_orders_icd9_codes	ric_pat_id
_1.radiology_orders_numbers	radnum_pat_id
_1.radiology_results	rad_res_pat_id
_1.radiology_results_test_codes_results	rrtcres_pat_id
_1.recall_list	rcl_pat_id
_1.requisition_numbers	req_pat_id
_1.stripe_customers_accounts	sca_pat_id
_1.structured_answers	sra_pat_id
_1.voided_payments	vp_pat_id
_1188.appointment_recurrence	arec_pat_id
_1188.appointments	apt_pat_id
_1188.appointments_requests	aptreq_pat_id
_1188.audits	aud_pat_id
_1188.audits_archive	aud_pat_id
_1188.audits_new	aud_pat_id
_1188.audits_new_archive	aud_pat_id
_1188.card_connect_profiles	cconp_pat_id
_1188.charts	chrt_pat_id
_1188.charts_care_plan	ccp_pat_id
_1188.charts_cpt_codes	chcp_pat_id
_1188.charts_diagnosis	cdx_pat_id
_1188.charts_icd9_codes	cic_pat_id
_1188.charts_medications	cm_pat_id
_1188.charts_numbers	cnum_pat_id
_1188.charts_procedures	cp_pat_id
_1188.clinical_interventions_review_map	cirm_pat_id
_1188.cpoe_responses	cpoe_res_pat_id
_1188.cqm_entries	cqme_pat_id
_1188.cqm_errors	cqmer_pat_id
_1188.documents	doc_pat_id
_1188.encounters	enc_pat_id
_1188.encounters	enc_guarantor_linked_pat_id
_1188.encounters	enc_ins1_linked_pat_id
_1188.encounters	enc_ins2_linked_pat_id
_1188.encounters	enc_ins3_linked_pat_id
_1188.encounters_cpt_codes	ecp_pat_id
_1188.encounters_icd9_codes	eic_pat_id
_1188.encounters_numbers	enum_pat_id
_1188.encounters_patients_races_map	eprm_pat_id
_1188.encounters_soap_labels_components	eslc_pat_id
_1188.encounters_soap_labels_values	eslv_pat_id
_1188.encounters_soap_vitals	espv_pat_id
_1188.encounters_stored_notes_patients_frequency	esnpf_pat_id
_1188.encounters_ub04	enc_ub04_pat_id
_1188.erx_webservice_transactions	ewt_pat_id
_1188.hl7_accessions	acc_pat_id
_1188.hl7_results	res_pat_id
_1188.insurances_repository	irep_pat_id
_1188.insurances_repository	irep_linked_pat_id
_1188.insurances_verification	iv_pat_id
_1188.ledger	led_pat_id
_1188.orders	ord_pat_id
_1188.orders_afps	oafp_pat_id
_1188.orders_comments	orc_pat_id
_1188.orders_icd9_codes	oic_pat_id
_1188.orders_paps	opap_pat_id
_1188.orders_paps_history	opaph_pat_id
_1188.orders_standing	ost_pat_id
_1188.orders_standing_dates	osd_pat_id
_1188.orders_test_codes	otc_pat_id
_1188.patient_access_restriction	patar_pat_id
_1188.patient_amendments	pa_pat_id
_1188.patient_configured_encounters	pce_pat_id
_1188.patient_finance_records	pfr_pat_id
_1188.patient_next_of_kin	pnk_pat_id
_1188.patient_portal_requests	ppr_pat_id
_1188.patients_additional_providers	pap_pat_id
_1188.patients_allergies	palg_pat_id
_1188.patients_authorization_numbers	pan_pat_id
_1188.patients_classes_map	pcm_pat_id
_1188.patients_configured_encounters_schedules	pces_pat_id
_1188.patients_demographics_snapshots	pds_pat_id
_1188.patients_demographics_snapshots	pds_guarantor_linked_pat_id
_1188.patients_demographics_snapshots	pds_ins1_linked_pat_id
_1188.patients_demographics_snapshots	pds_ins2_linked_pat_id
_1188.patients_demographics_snapshots	pds_ins3_linked_pat_id
_1188.patients_document_assembly	pda_pat_id
_1188.patients_education_results	peres_pat_id
_1188.patients_enrollments	pert_pat_id
_1188.patients_erx_updates	peu_pat_id
_1188.patients_ethnicities_map	pem_pat_id
_1188.patients_handouts	phs_pat_id
_1188.patients_health_concerns	phc_pat_id
_1188.patients_health_observations	pho_pat_id
_1188.patients_histories	ph_pat_id
_1188.patients_icd9_problems	pip_pat_id
_1188.patients_images	pi_pat_id
_1188.patients_immunizations	pim_pat_id
_1188.patients_implantable_devices	pid_pat_id
_1188.patients_inventory	pinv_pat_id
_1188.patients_medications	pms_pat_id
_1188.patients_names	pn_pat_id
_1188.patients_payment_methods	patpm_pat_id
_1188.patients_payments_ledger_map	pplm_pat_id
_1188.patients_payments_schedules	pps_pat_id
_1188.patients_pids	ppid_pat_id
_1188.patients_prescriptions	prx_pat_id
_1188.patients_races_map	prm_pat_id
_1188.patients_referrals	pref_pat_id
_1188.patients_relatives_map	prm_pat_id
_1188.patients_reminders	pr_pat_id
_1188.patients_responsibility_estimates	prest_pat_id
_1188.patients_smoking_status	pss_pat_id
_1188.patients_social_answers	psa_pat_id
_1188.patients_statements_map	pstm_pat_id
_1188.patients_stored_messages	psm_pat_id
_1188.patients_tasks	pt_pat_id
_1188.patients_urls	pu_pat_id
_1188.patients_vitals	pvs_pat_id
_1188.poa	poa_pat_id
_1188.portal_released_data	prd_pat_id
_1188.portal_withheld_data	pwd_pat_id
_1188.precerts	pre_pat_id
_1188.precerts_comments	prc_pat_id
_1188.precerts_cpt_codes	pcp_pat_id
_1188.precerts_icd9_codes	pic_pat_id
_1188.precerts_numbers	pnum_pat_id
_1188.procedures_results	pres_pat_id
_1188.radiology_order_notes	radnot_pat_id
_1188.radiology_orders	rad_pat_id
_1188.radiology_orders_icd9_codes	ric_pat_id
_1188.radiology_orders_numbers	radnum_pat_id
_1188.radiology_results	rad_res_pat_id
_1188.radiology_results_test_codes_results	rrtcres_pat_id
_1188.recall_list	rcl_pat_id
_1188.requisition_numbers	req_pat_id
_1188.stripe_customers_accounts	sca_pat_id
_1188.structured_answers	sra_pat_id
_1188.voided_payments	vp_pat_id
_1218.appointment_recurrence	arec_pat_id
_1218.appointments	apt_pat_id
_1218.appointments_requests	aptreq_pat_id
_1218.audits	aud_pat_id
_1218.audits_archive	aud_pat_id
_1218.audits_new	aud_pat_id
_1218.audits_new_archive	aud_pat_id
_1218.card_connect_profiles	cconp_pat_id
_1218.charts	chrt_pat_id
_1218.charts_care_plan	ccp_pat_id
_1218.charts_cpt_codes	chcp_pat_id
_1218.charts_diagnosis	cdx_pat_id
_1218.charts_icd9_codes	cic_pat_id
_1218.charts_medications	cm_pat_id
_1218.charts_numbers	cnum_pat_id
_1218.charts_procedures	cp_pat_id
_1218.clinical_interventions_review_map	cirm_pat_id
_1218.cpoe_responses	cpoe_res_pat_id
_1218.cqm_entries	cqme_pat_id
_1218.cqm_errors	cqmer_pat_id
_1218.documents	doc_pat_id
_1218.encounter_soap_labels_values_groups	eslvg_pat_id
_1218.encounters	enc_pat_id
_1218.encounters	enc_guarantor_linked_pat_id
_1218.encounters	enc_ins1_linked_pat_id
_1218.encounters	enc_ins2_linked_pat_id
_1218.encounters	enc_ins3_linked_pat_id
_1218.encounters_cpt_codes	ecp_pat_id
_1218.encounters_icd9_codes	eic_pat_id
_1218.encounters_numbers	enum_pat_id
_1218.encounters_patients_races_map	eprm_pat_id
_1218.encounters_soap_labels_components	eslc_pat_id
_1218.encounters_soap_labels_values	eslv_pat_id
_1218.encounters_soap_labels_values_map	eslvm_pat_id
_1218.encounters_soap_vitals	espv_pat_id
_1218.encounters_stored_notes_patients_frequency	esnpf_pat_id
_1218.encounters_ub04	enc_ub04_pat_id
_1218.erx_webservice_transactions	ewt_pat_id
_1218.hl7_accessions	acc_pat_id
_1218.hl7_results	res_pat_id
_1218.insurances_repository	irep_pat_id
_1218.insurances_repository	irep_linked_pat_id
_1218.insurances_verification	iv_pat_id
_1218.ledger	led_pat_id
_1218.orders	ord_pat_id
_1218.orders_afps	oafp_pat_id
_1218.orders_comments	orc_pat_id
_1218.orders_icd9_codes	oic_pat_id
_1218.orders_paps	opap_pat_id
_1218.orders_paps_history	opaph_pat_id
_1218.orders_standing	ost_pat_id
_1218.orders_standing_dates	osd_pat_id
_1218.orders_test_codes	otc_pat_id
_1218.patient_access_restriction	patar_pat_id
_1218.patient_amendments	pa_pat_id
_1218.patient_configured_encounters	pce_pat_id
_1218.patient_finance_records	pfr_pat_id
_1218.patient_next_of_kin	pnk_pat_id
_1218.patient_portal_requests	ppr_pat_id
_1218.patients_additional_providers	pap_pat_id
_1218.patients_allergies	palg_pat_id
_1218.patients_authorization_numbers	pan_pat_id
_1218.patients_classes_map	pcm_pat_id
_1218.patients_configured_encounters_schedules	pces_pat_id
_1218.patients_demographics_snapshots	pds_pat_id
_1218.patients_demographics_snapshots	pds_guarantor_linked_pat_id
_1218.patients_demographics_snapshots	pds_ins1_linked_pat_id
_1218.patients_demographics_snapshots	pds_ins2_linked_pat_id
_1218.patients_demographics_snapshots	pds_ins3_linked_pat_id
_1218.patients_document_assembly	pda_pat_id
_1218.patients_education_results	peres_pat_id
_1218.patients_enrollments	pert_pat_id
_1218.patients_erx_updates	peu_pat_id
_1218.patients_ethnicities_map	pem_pat_id
_1218.patients_handouts	phs_pat_id
_1218.patients_health_concerns	phc_pat_id
_1218.patients_health_observations	pho_pat_id
_1218.patients_histories	ph_pat_id
_1218.patients_icd9_problems	pip_pat_id
_1218.patients_images	pi_pat_id
_1218.patients_immunizations	pim_pat_id
_1218.patients_implantable_devices	pid_pat_id
_1218.patients_inventory	pinv_pat_id
_1218.patients_medications	pms_pat_id
_1218.patients_names	pn_pat_id
_1218.patients_payment_methods	patpm_pat_id
_1218.patients_payments_ledger_map	pplm_pat_id
_1218.patients_payments_schedules	pps_pat_id
_1218.patients_pids	ppid_pat_id
_1218.patients_prescriptions	prx_pat_id
_1218.patients_races_map	prm_pat_id
_1218.patients_referrals	pref_pat_id
_1218.patients_relatives_map	prm_pat_id
_1218.patients_reminders	pr_pat_id
_1218.patients_responsibility_estimates	prest_pat_id
_1218.patients_smoking_status	pss_pat_id
_1218.patients_social_answers	psa_pat_id
_1218.patients_statements_map	pstm_pat_id
_1218.patients_stored_messages	psm_pat_id
_1218.patients_tasks	pt_pat_id
_1218.patients_urls	pu_pat_id
_1218.patients_vitals	pvs_pat_id
_1218.poa	poa_pat_id
_1218.portal_released_data	prd_pat_id
_1218.portal_withheld_data	pwd_pat_id
_1218.precerts	pre_pat_id
_1218.precerts_comments	prc_pat_id
_1218.precerts_cpt_codes	pcp_pat_id
_1218.precerts_icd9_codes	pic_pat_id
_1218.precerts_numbers	pnum_pat_id
_1218.procedures_results	pres_pat_id
_1218.radiology_order_notes	radnot_pat_id
_1218.radiology_orders	rad_pat_id
_1218.radiology_orders_icd9_codes	ric_pat_id
_1218.radiology_orders_numbers	radnum_pat_id
_1218.radiology_results	rad_res_pat_id
_1218.radiology_results_test_codes_results	rrtcres_pat_id
_1218.recall_list	rcl_pat_id
_1218.requisition_numbers	req_pat_id
_1218.stripe_customers_accounts	sca_pat_id
_1218.structured_answers	sra_pat_id
_1218.voided_payments	vp_pat_id
_1548.appointment_recurrence	arec_pat_id
_1548.appointments	apt_pat_id
_1548.appointments_requests	aptreq_pat_id
_1548.audits	aud_pat_id
_1548.audits_archive	aud_pat_id
_1548.audits_new	aud_pat_id
_1548.audits_new_archive	aud_pat_id
_1548.card_connect_profiles	cconp_pat_id
_1548.charts	chrt_pat_id
_1548.charts_care_plan	ccp_pat_id
_1548.charts_cpt_codes	chcp_pat_id
_1548.charts_diagnosis	cdx_pat_id
_1548.charts_icd9_codes	cic_pat_id
_1548.charts_medications	cm_pat_id
_1548.charts_numbers	cnum_pat_id
_1548.charts_procedures	cp_pat_id
_1548.clinical_interventions_review_map	cirm_pat_id
_1548.configured_encounters	confenc_pat_id
_1548.cpoe_responses	cpoe_res_pat_id
_1548.cqm_entries	cqme_pat_id
_1548.cqm_errors	cqmer_pat_id
_1548.documents	doc_pat_id
_1548.encounter_soap_labels_values_groups	eslvg_pat_id
_1548.encounters	enc_pat_id
_1548.encounters	enc_guarantor_linked_pat_id
_1548.encounters	enc_ins1_linked_pat_id
_1548.encounters	enc_ins2_linked_pat_id
_1548.encounters	enc_ins3_linked_pat_id
_1548.encounters_cpt_codes	ecp_pat_id
_1548.encounters_icd9_codes	eic_pat_id
_1548.encounters_numbers	enum_pat_id
_1548.encounters_patients_races_map	eprm_pat_id
_1548.encounters_soap_labels_components	eslc_pat_id
_1548.encounters_soap_labels_values	eslv_pat_id
_1548.encounters_soap_labels_values_map	eslvm_pat_id
_1548.encounters_soap_vitals	espv_pat_id
_1548.encounters_stored_notes_patients_frequency	esnpf_pat_id
_1548.encounters_ub04	enc_ub04_pat_id
_1548.erx_webservice_transactions	ewt_pat_id
_1548.hl7_accessions	acc_pat_id
_1548.hl7_results	res_pat_id
_1548.insurances_repository	irep_pat_id
_1548.insurances_repository	irep_linked_pat_id
_1548.insurances_verification	iv_pat_id
_1548.ledger	led_pat_id
_1548.orders	ord_pat_id
_1548.orders_afps	oafp_pat_id
_1548.orders_comments	orc_pat_id
_1548.orders_icd9_codes	oic_pat_id
_1548.orders_paps	opap_pat_id
_1548.orders_paps_history	opaph_pat_id
_1548.orders_standing	ost_pat_id
_1548.orders_standing_dates	osd_pat_id
_1548.orders_test_codes	otc_pat_id
_1548.patient_access_restriction	patar_pat_id
_1548.patient_amendments	pa_pat_id
_1548.patient_configured_encounters	pce_pat_id
_1548.patient_finance_records	pfr_pat_id
_1548.patient_next_of_kin	pnk_pat_id
_1548.patient_portal_requests	ppr_pat_id
_1548.patients_additional_providers	pap_pat_id
_1548.patients_allergies	palg_pat_id
_1548.patients_authorization_numbers	pan_pat_id
_1548.patients_classes_map	pcm_pat_id
_1548.patients_configured_encounters_schedules	pces_pat_id
_1548.patients_demographics_snapshots	pds_pat_id
_1548.patients_demographics_snapshots	pds_guarantor_linked_pat_id
_1548.patients_demographics_snapshots	pds_ins1_linked_pat_id
_1548.patients_demographics_snapshots	pds_ins2_linked_pat_id
_1548.patients_demographics_snapshots	pds_ins3_linked_pat_id
_1548.patients_document_assembly	pda_pat_id
_1548.patients_education_results	peres_pat_id
_1548.patients_enrollments	pert_pat_id
_1548.patients_erx_updates	peu_pat_id
_1548.patients_ethnicities_map	pem_pat_id
_1548.patients_handouts	phs_pat_id
_1548.patients_health_concerns	phc_pat_id
_1548.patients_health_observations	pho_pat_id
_1548.patients_histories	ph_pat_id
_1548.patients_icd9_problems	pip_pat_id
_1548.patients_images	pi_pat_id
_1548.patients_immunizations	pim_pat_id
_1548.patients_implantable_devices	pid_pat_id
_1548.patients_inventory	pinv_pat_id
_1548.patients_medications	pms_pat_id
_1548.patients_names	pn_pat_id
_1548.patients_payment_methods	patpm_pat_id
_1548.patients_payments_ledger_map	pplm_pat_id
_1548.patients_payments_schedules	pps_pat_id
_1548.patients_pids	ppid_pat_id
_1548.patients_prescriptions	prx_pat_id
_1548.patients_races_map	prm_pat_id
_1548.patients_referrals	pref_pat_id
_1548.patients_relatives_map	prm_pat_id
_1548.patients_reminders	pr_pat_id
_1548.patients_responsibility_estimates	prest_pat_id
_1548.patients_smoking_status	pss_pat_id
_1548.patients_social_answers	psa_pat_id
_1548.patients_statements_map	pstm_pat_id
_1548.patients_stored_messages	psm_pat_id
_1548.patients_tasks	pt_pat_id
_1548.patients_urls	pu_pat_id
_1548.patients_vitals	pvs_pat_id
_1548.poa	poa_pat_id
_1548.portal_released_data	prd_pat_id
_1548.portal_withheld_data	pwd_pat_id
_1548.precerts	pre_pat_id
_1548.precerts_comments	prc_pat_id
_1548.precerts_cpt_codes	pcp_pat_id
_1548.precerts_icd9_codes	pic_pat_id
_1548.precerts_numbers	pnum_pat_id
_1548.procedures_results	pres_pat_id
_1548.radiology_order_notes	radnot_pat_id
_1548.radiology_orders	rad_pat_id
_1548.radiology_orders_icd9_codes	ric_pat_id
_1548.radiology_orders_numbers	radnum_pat_id
_1548.radiology_results	rad_res_pat_id
_1548.radiology_results_test_codes_results	rrtcres_pat_id
_1548.recall_list	rcl_pat_id
_1548.requisition_numbers	req_pat_id
_1548.stripe_customers_accounts	sca_pat_id
_1548.structured_answers	sra_pat_id
_1548.voided_payments	vp_pat_id
_435.appointment_recurrence	arec_pat_id
_435.appointments	apt_pat_id
_435.appointments_requests	aptreq_pat_id
_435.audits	aud_pat_id
_435.audits_archive	aud_pat_id
_435.audits_archive_2008	aud_pat_id
_435.audits_archive_2009	aud_pat_id
_435.audits_archive_2010	aud_pat_id
_435.audits_archive_2011	aud_pat_id
_435.audits_archive_2012	aud_pat_id
_435.audits_archive_2013	aud_pat_id
_435.audits_archive_2014	aud_pat_id
_435.audits_archive_2015	aud_pat_id
_435.audits_archive_2016	aud_pat_id
_435.audits_archive_2017	aud_pat_id
_435.audits_archive_2018	aud_pat_id
_435.audits_archive_2019	aud_pat_id
_435.audits_archive_2020	aud_pat_id
_435.audits_new	aud_pat_id
_435.audits_new_archive	aud_pat_id
_435.audits_new_trial	aud_pat_id
_435.card_connect_profiles	cconp_pat_id
_435.charts	chrt_pat_id
_435.charts_care_plan	ccp_pat_id
_435.charts_cpt_codes	chcp_pat_id
_435.charts_diagnosis	cdx_pat_id
_435.charts_icd9_codes	cic_pat_id
_435.charts_medications	cm_pat_id
_435.charts_numbers	cnum_pat_id
_435.charts_procedures	cp_pat_id
_435.clinical_interventions_review_map	cirm_pat_id
_435.configured_encounters	confenc_pat_id
_435.cpoe_responses	cpoe_res_pat_id
_435.cqm_entries	cqme_pat_id
_435.cqm_errors	cqmer_pat_id
_435.documents	doc_pat_id
_435.encounter_soap_labels_values_groups	eslvg_pat_id
_435.encounters	enc_pat_id
_435.encounters	enc_guarantor_linked_pat_id
_435.encounters	enc_ins1_linked_pat_id
_435.encounters	enc_ins2_linked_pat_id
_435.encounters	enc_ins3_linked_pat_id
_435.encounters_cpt_codes	ecp_pat_id
_435.encounters_icd9_codes	eic_pat_id
_435.encounters_numbers	enum_pat_id
_435.encounters_patients_races_map	eprm_pat_id
_435.encounters_soap_labels_components	eslc_pat_id
_435.encounters_soap_labels_values	eslv_pat_id
_435.encounters_soap_labels_values_map	eslvm_pat_id
_435.encounters_soap_vitals	espv_pat_id
_435.encounters_stored_notes_patients_frequency	esnpf_pat_id
_435.encounters_ub04	enc_ub04_pat_id
_435.erx_webservice_transactions	ewt_pat_id
_435.fitbit_tokens	ft_pat_id
_435.hl7_accessions	acc_pat_id
_435.hl7_results	res_pat_id
_435.insurances_repository	irep_pat_id
_435.insurances_repository	irep_linked_pat_id
_435.insurances_verification	iv_pat_id
_435.ledger	led_pat_id
_435.orders	ord_pat_id
_435.orders_afps	oafp_pat_id
_435.orders_comments	orc_pat_id
_435.orders_icd9_codes	oic_pat_id
_435.orders_paps	opap_pat_id
_435.orders_paps_history	opaph_pat_id
_435.orders_standing	ost_pat_id
_435.orders_standing_dates	osd_pat_id
_435.orders_test_codes	otc_pat_id
_435.patient_access_restriction	patar_pat_id
_435.patient_amendments	pa_pat_id
_435.patient_configured_encounters	pce_pat_id
_435.patient_finance_records	pfr_pat_id
_435.patient_next_of_kin	pnk_pat_id
_435.patient_portal_requests	ppr_pat_id
_435.patients_additional_providers	pap_pat_id
_435.patients_allergies	palg_pat_id
_435.patients_authorization_numbers	pan_pat_id
_435.patients_classes_map	pcm_pat_id
_435.patients_configured_encounters_schedules	pces_pat_id
_435.patients_demographics_snapshots	pds_pat_id
_435.patients_demographics_snapshots	pds_guarantor_linked_pat_id
_435.patients_demographics_snapshots	pds_ins1_linked_pat_id
_435.patients_demographics_snapshots	pds_ins2_linked_pat_id
_435.patients_demographics_snapshots	pds_ins3_linked_pat_id
_435.patients_document_assembly	pda_pat_id
_435.patients_education_results	peres_pat_id
_435.patients_enrollments	pert_pat_id
_435.patients_erx_updates	peu_pat_id
_435.patients_ethnicities_map	pem_pat_id
_435.patients_handouts	phs_pat_id
_435.patients_health_concerns	phc_pat_id
_435.patients_health_observations	pho_pat_id
_435.patients_histories	ph_pat_id
_435.patients_icd9_problems	pip_pat_id
_435.patients_images	pi_pat_id
_435.patients_immunizations	pim_pat_id
_435.patients_implantable_devices	pid_pat_id
_435.patients_inventory	pinv_pat_id
_435.patients_medications	pms_pat_id
_435.patients_names	pn_pat_id
_435.patients_payment_methods	patpm_pat_id
_435.patients_payments_ledger_map	pplm_pat_id
_435.patients_payments_schedules	pps_pat_id
_435.patients_pids	ppid_pat_id
_435.patients_prescriptions	prx_pat_id
_435.patients_races_map	prm_pat_id
_435.patients_referrals	pref_pat_id
_435.patients_relatives_map	prm_pat_id
_435.patients_reminders	pr_pat_id
_435.patients_responsibility_estimates	prest_pat_id
_435.patients_smoking_status	pss_pat_id
_435.patients_social_answers	psa_pat_id
_435.patients_statements_map	pstm_pat_id
_435.patients_stored_messages	psm_pat_id
_435.patients_tasks	pt_pat_id
_435.patients_urls	pu_pat_id
_435.patients_vitals	pvs_pat_id
_435.poa	poa_pat_id
_435.portal_released_data	prd_pat_id
_435.portal_withheld_data	pwd_pat_id
_435.precerts	pre_pat_id
_435.precerts_comments	prc_pat_id
_435.precerts_cpt_codes	pcp_pat_id
_435.precerts_icd9_codes	pic_pat_id
_435.precerts_numbers	pnum_pat_id
_435.procedures_results	pres_pat_id
_435.radiology_order_notes	radnot_pat_id
_435.radiology_orders	rad_pat_id
_435.radiology_orders_icd9_codes	ric_pat_id
_435.radiology_orders_numbers	radnum_pat_id
_435.radiology_results	rad_res_pat_id
_435.radiology_results_test_codes_results	rrtcres_pat_id
_435.recall_list	rcl_pat_id
_435.requisition_numbers	req_pat_id
_435.structured_answers	sra_pat_id
_435.voided_payments	vp_pat_id
_436.appointment_recurrence	arec_pat_id
_436.appointments	apt_pat_id
_436.appointments_requests	aptreq_pat_id
_436.audits	aud_pat_id
_436.audits_archive	aud_pat_id
_436.audits_new	aud_pat_id
_436.audits_new_archive	aud_pat_id
_436.card_connect_profiles	cconp_pat_id
_436.charts	chrt_pat_id
_436.charts_care_plan	ccp_pat_id
_436.charts_cpt_codes	chcp_pat_id
_436.charts_diagnosis	cdx_pat_id
_436.charts_icd9_codes	cic_pat_id
_436.charts_medications	cm_pat_id
_436.charts_numbers	cnum_pat_id
_436.charts_procedures	cp_pat_id
_436.clinical_interventions_review_map	cirm_pat_id
_436.configured_encounters	confenc_pat_id
_436.cpoe_responses	cpoe_res_pat_id
_436.cqm_entries	cqme_pat_id
_436.cqm_errors	cqmer_pat_id
_436.documents	doc_pat_id
_436.encounter_soap_labels_values_groups	eslvg_pat_id
_436.encounters	enc_pat_id
_436.encounters	enc_guarantor_linked_pat_id
_436.encounters	enc_ins1_linked_pat_id
_436.encounters	enc_ins2_linked_pat_id
_436.encounters	enc_ins3_linked_pat_id
_436.encounters_cpt_codes	ecp_pat_id
_436.encounters_icd9_codes	eic_pat_id
_436.encounters_numbers	enum_pat_id
_436.encounters_patients_races_map	eprm_pat_id
_436.encounters_soap_labels_components	eslc_pat_id
_436.encounters_soap_labels_values	eslv_pat_id
_436.encounters_soap_labels_values_map	eslvm_pat_id
_436.encounters_soap_vitals	espv_pat_id
_436.encounters_stored_notes_patients_frequency	esnpf_pat_id
_436.encounters_ub04	enc_ub04_pat_id
_436.erx_webservice_transactions	ewt_pat_id
_436.fitbit_tokens	ft_pat_id
_436.hl7_accessions	acc_pat_id
_436.hl7_results	res_pat_id
_436.insurances_repository	irep_pat_id
_436.insurances_repository	irep_linked_pat_id
_436.insurances_verification	iv_pat_id
_436.ledger	led_pat_id
_436.orders	ord_pat_id
_436.orders_afps	oafp_pat_id
_436.orders_comments	orc_pat_id
_436.orders_icd9_codes	oic_pat_id
_436.orders_paps	opap_pat_id
_436.orders_paps_history	opaph_pat_id
_436.orders_standing	ost_pat_id
_436.orders_standing_dates	osd_pat_id
_436.orders_test_codes	otc_pat_id
_436.patient_access_restriction	patar_pat_id
_436.patient_amendments	pa_pat_id
_436.patient_configured_encounters	pce_pat_id
_436.patient_finance_records	pfr_pat_id
_436.patient_next_of_kin	pnk_pat_id
_436.patient_portal_requests	ppr_pat_id
_436.patients_additional_providers	pap_pat_id
_436.patients_allergies	palg_pat_id
_436.patients_authorization_numbers	pan_pat_id
_436.patients_classes_map	pcm_pat_id
_436.patients_configured_encounters_schedules	pces_pat_id
_436.patients_demographics_snapshots	pds_pat_id
_436.patients_demographics_snapshots	pds_guarantor_linked_pat_id
_436.patients_demographics_snapshots	pds_ins1_linked_pat_id
_436.patients_demographics_snapshots	pds_ins2_linked_pat_id
_436.patients_demographics_snapshots	pds_ins3_linked_pat_id
_436.patients_document_assembly	pda_pat_id
_436.patients_education_results	peres_pat_id
_436.patients_enrollments	pert_pat_id
_436.patients_erx_updates	peu_pat_id
_436.patients_ethnicities_map	pem_pat_id
_436.patients_handouts	phs_pat_id
_436.patients_health_concerns	phc_pat_id
_436.patients_health_observations	pho_pat_id
_436.patients_histories	ph_pat_id
_436.patients_icd9_problems	pip_pat_id
_436.patients_images	pi_pat_id
_436.patients_immunizations	pim_pat_id
_436.patients_implantable_devices	pid_pat_id
_436.patients_inventory	pinv_pat_id
_436.patients_medications	pms_pat_id
_436.patients_names	pn_pat_id
_436.patients_payment_methods	patpm_pat_id
_436.patients_payments_ledger_map	pplm_pat_id
_436.patients_payments_schedules	pps_pat_id
_436.patients_pids	ppid_pat_id
_436.patients_prescriptions	prx_pat_id
_436.patients_races_map	prm_pat_id
_436.patients_referrals	pref_pat_id
_436.patients_relatives_map	prm_pat_id
_436.patients_reminders	pr_pat_id
_436.patients_responsibility_estimates	prest_pat_id
_436.patients_smoking_status	pss_pat_id
_436.patients_social_answers	psa_pat_id
_436.patients_statements_map	pstm_pat_id
_436.patients_stored_messages	psm_pat_id
_436.patients_tasks	pt_pat_id
_436.patients_urls	pu_pat_id
_436.patients_vitals	pvs_pat_id
_436.poa	poa_pat_id
_436.portal_released_data	prd_pat_id
_436.portal_withheld_data	pwd_pat_id
_436.precerts	pre_pat_id
_436.precerts_comments	prc_pat_id
_436.precerts_cpt_codes	pcp_pat_id
_436.precerts_icd9_codes	pic_pat_id
_436.precerts_numbers	pnum_pat_id
_436.procedures_results	pres_pat_id
_436.radiology_order_notes	radnot_pat_id
_436.radiology_orders	rad_pat_id
_436.radiology_orders_icd9_codes	ric_pat_id
_436.radiology_orders_numbers	radnum_pat_id
_436.radiology_results	rad_res_pat_id
_436.radiology_results_test_codes_results	rrtcres_pat_id
_436.recall_list	rcl_pat_id
_436.requisition_numbers	req_pat_id
_436.structured_answers	sra_pat_id
_436.voided_payments	vp_pat_id
_436_archive_testing.appointment_recurrence	arec_pat_id
_436_archive_testing.appointments	apt_pat_id
_436_archive_testing.appointments_requests	aptreq_pat_id
_436_archive_testing.audits	aud_pat_id
_436_archive_testing.audits_archive	aud_pat_id
_436_archive_testing.audits_archive_2008	aud_pat_id
_436_archive_testing.audits_archive_2009	aud_pat_id
_436_archive_testing.audits_archive_2010	aud_pat_id
_436_archive_testing.audits_archive_2011	aud_pat_id
_436_archive_testing.audits_archive_2012	aud_pat_id
_436_archive_testing.audits_archive_2013	aud_pat_id
_436_archive_testing.audits_archive_2014	aud_pat_id
_436_archive_testing.audits_archive_2015	aud_pat_id
_436_archive_testing.audits_archive_2016	aud_pat_id
_436_archive_testing.audits_archive_2017	aud_pat_id
_436_archive_testing.audits_archive_2018	aud_pat_id
_436_archive_testing.audits_archive_2019	aud_pat_id
_436_archive_testing.audits_archive_2020	aud_pat_id
_436_archive_testing.audits_archive_2021	aud_pat_id
_436_archive_testing.audits_new	aud_pat_id
_436_archive_testing.audits_new_archive	aud_pat_id
_436_archive_testing.card_connect_profiles	cconp_pat_id
_436_archive_testing.charts	chrt_pat_id
_436_archive_testing.charts_care_plan	ccp_pat_id
_436_archive_testing.charts_cpt_codes	chcp_pat_id
_436_archive_testing.charts_diagnosis	cdx_pat_id
_436_archive_testing.charts_icd9_codes	cic_pat_id
_436_archive_testing.charts_medications	cm_pat_id
_436_archive_testing.charts_numbers	cnum_pat_id
_436_archive_testing.charts_procedures	cp_pat_id
_436_archive_testing.clinical_interventions_review_map	cirm_pat_id
_436_archive_testing.configured_encounters	confenc_pat_id
_436_archive_testing.cpoe_responses	cpoe_res_pat_id
_436_archive_testing.cqm_entries	cqme_pat_id
_436_archive_testing.cqm_errors	cqmer_pat_id
_436_archive_testing.documents	doc_pat_id
_436_archive_testing.encounter_soap_labels_values_groups	eslvg_pat_id
_436_archive_testing.encounters	enc_pat_id
_436_archive_testing.encounters	enc_guarantor_linked_pat_id
_436_archive_testing.encounters	enc_ins1_linked_pat_id
_436_archive_testing.encounters	enc_ins2_linked_pat_id
_436_archive_testing.encounters	enc_ins3_linked_pat_id
_436_archive_testing.encounters_cpt_codes	ecp_pat_id
_436_archive_testing.encounters_icd9_codes	eic_pat_id
_436_archive_testing.encounters_numbers	enum_pat_id
_436_archive_testing.encounters_patients_races_map	eprm_pat_id
_436_archive_testing.encounters_soap_labels_components	eslc_pat_id
_436_archive_testing.encounters_soap_labels_values	eslv_pat_id
_436_archive_testing.encounters_soap_labels_values_map	eslvm_pat_id
_436_archive_testing.encounters_soap_vitals	espv_pat_id
_436_archive_testing.encounters_stored_notes_patients_frequency	esnpf_pat_id
_436_archive_testing.encounters_ub04	enc_ub04_pat_id
_436_archive_testing.erx_webservice_transactions	ewt_pat_id
_436_archive_testing.fitbit_tokens	ft_pat_id
_436_archive_testing.hl7_accessions	acc_pat_id
_436_archive_testing.hl7_results	res_pat_id
_436_archive_testing.insurances_repository	irep_pat_id
_436_archive_testing.insurances_repository	irep_linked_pat_id
_436_archive_testing.insurances_verification	iv_pat_id
_436_archive_testing.ledger	led_pat_id
_436_archive_testing.orders	ord_pat_id
_436_archive_testing.orders_afps	oafp_pat_id
_436_archive_testing.orders_comments	orc_pat_id
_436_archive_testing.orders_icd9_codes	oic_pat_id
_436_archive_testing.orders_paps	opap_pat_id
_436_archive_testing.orders_paps_history	opaph_pat_id
_436_archive_testing.orders_standing	ost_pat_id
_436_archive_testing.orders_standing_dates	osd_pat_id
_436_archive_testing.orders_test_codes	otc_pat_id
_436_archive_testing.patient_access_restriction	patar_pat_id
_436_archive_testing.patient_amendments	pa_pat_id
_436_archive_testing.patient_configured_encounters	pce_pat_id
_436_archive_testing.patient_finance_records	pfr_pat_id
_436_archive_testing.patient_next_of_kin	pnk_pat_id
_436_archive_testing.patient_portal_requests	ppr_pat_id
_436_archive_testing.patients_additional_providers	pap_pat_id
_436_archive_testing.patients_allergies	palg_pat_id
_436_archive_testing.patients_authorization_numbers	pan_pat_id
_436_archive_testing.patients_classes_map	pcm_pat_id
_436_archive_testing.patients_configured_encounters_schedules	pces_pat_id
_436_archive_testing.patients_demographics_snapshots	pds_pat_id
_436_archive_testing.patients_demographics_snapshots	pds_guarantor_linked_pat_id
_436_archive_testing.patients_demographics_snapshots	pds_ins1_linked_pat_id
_436_archive_testing.patients_demographics_snapshots	pds_ins2_linked_pat_id
_436_archive_testing.patients_demographics_snapshots	pds_ins3_linked_pat_id
_436_archive_testing.patients_document_assembly	pda_pat_id
_436_archive_testing.patients_education_results	peres_pat_id
_436_archive_testing.patients_enrollments	pert_pat_id
_436_archive_testing.patients_erx_updates	peu_pat_id
_436_archive_testing.patients_ethnicities_map	pem_pat_id
_436_archive_testing.patients_handouts	phs_pat_id
_436_archive_testing.patients_health_concerns	phc_pat_id
_436_archive_testing.patients_health_observations	pho_pat_id
_436_archive_testing.patients_histories	ph_pat_id
_436_archive_testing.patients_icd9_problems	pip_pat_id
_436_archive_testing.patients_images	pi_pat_id
_436_archive_testing.patients_immunizations	pim_pat_id
_436_archive_testing.patients_implantable_devices	pid_pat_id
_436_archive_testing.patients_inventory	pinv_pat_id
_436_archive_testing.patients_medications	pms_pat_id
_436_archive_testing.patients_payment_methods	patpm_pat_id
_436_archive_testing.patients_payments_ledger_map	pplm_pat_id
_436_archive_testing.patients_payments_schedules	pps_pat_id
_436_archive_testing.patients_pids	ppid_pat_id
_436_archive_testing.patients_prescriptions	prx_pat_id
_436_archive_testing.patients_races_map	prm_pat_id
_436_archive_testing.patients_referrals	pref_pat_id
_436_archive_testing.patients_relatives_map	prm_pat_id
_436_archive_testing.patients_reminders	pr_pat_id
_436_archive_testing.patients_responsibility_estimates	prest_pat_id
_436_archive_testing.patients_smoking_status	pss_pat_id
_436_archive_testing.patients_social_answers	psa_pat_id
_436_archive_testing.patients_statements_map	pstm_pat_id
_436_archive_testing.patients_stored_messages	psm_pat_id
_436_archive_testing.patients_tasks	pt_pat_id
_436_archive_testing.patients_urls	pu_pat_id
_436_archive_testing.patients_vitals	pvs_pat_id
_436_archive_testing.poa	poa_pat_id
_436_archive_testing.portal_released_data	prd_pat_id
_436_archive_testing.portal_withheld_data	pwd_pat_id
_436_archive_testing.precerts	pre_pat_id
_436_archive_testing.precerts_comments	prc_pat_id
_436_archive_testing.precerts_cpt_codes	pcp_pat_id
_436_archive_testing.precerts_icd9_codes	pic_pat_id
_436_archive_testing.precerts_numbers	pnum_pat_id
_436_archive_testing.procedures_results	pres_pat_id
_436_archive_testing.radiology_order_notes	radnot_pat_id
_436_archive_testing.radiology_orders	rad_pat_id
_436_archive_testing.radiology_orders_icd9_codes	ric_pat_id
_436_archive_testing.radiology_orders_numbers	radnum_pat_id
_436_archive_testing.radiology_results	rad_res_pat_id
_436_archive_testing.radiology_results_test_codes_results	rrtcres_pat_id
_436_archive_testing.recall_list	rcl_pat_id
_436_archive_testing.requisition_numbers	req_pat_id
_436_archive_testing.structured_answers	sra_pat_id
_436_archive_testing.voided_payments	vp_pat_id
_437.appointment_recurrence	arec_pat_id
_437.appointments	apt_pat_id
_437.appointments_requests	aptreq_pat_id
_437.audits	aud_pat_id
_437.audits_archive	aud_pat_id
_437.audits_new	aud_pat_id
_437.audits_new_archive	aud_pat_id
_437.charts	chrt_pat_id
_437.charts_care_plan	ccp_pat_id
_437.charts_cpt_codes	chcp_pat_id
_437.charts_diagnosis	cdx_pat_id
_437.charts_icd9_codes	cic_pat_id
_437.charts_medications	cm_pat_id
_437.charts_numbers	cnum_pat_id
_437.charts_procedures	cp_pat_id
_437.clinical_interventions_review_map	cirm_pat_id
_437.configured_encounters	confenc_pat_id
_437.cpoe_responses	cpoe_res_pat_id
_437.cqm_entries	cqme_pat_id
_437.cqm_errors	cqmer_pat_id
_437.documents	doc_pat_id
_437.encounter_soap_labels_values_groups	eslvg_pat_id
_437.encounters	enc_pat_id
_437.encounters	enc_guarantor_linked_pat_id
_437.encounters	enc_ins1_linked_pat_id
_437.encounters	enc_ins2_linked_pat_id
_437.encounters	enc_ins3_linked_pat_id
_437.encounters_cpt_codes	ecp_pat_id
_437.encounters_icd9_codes	eic_pat_id
_437.encounters_numbers	enum_pat_id
_437.encounters_patients_races_map	eprm_pat_id
_437.encounters_soap_labels_components	eslc_pat_id
_437.encounters_soap_labels_values	eslv_pat_id
_437.encounters_soap_labels_values_map	eslvm_pat_id
_437.encounters_soap_vitals	espv_pat_id
_437.encounters_stored_notes_patients_frequency	esnpf_pat_id
_437.encounters_ub04	enc_ub04_pat_id
_437.erx_webservice_transactions	ewt_pat_id
_437.fitbit_tokens	ft_pat_id
_437.hl7_accessions	acc_pat_id
_437.hl7_results	res_pat_id
_437.insurances_repository	irep_pat_id
_437.insurances_repository	irep_linked_pat_id
_437.insurances_verification	iv_pat_id
_437.ledger	led_pat_id
_437.orders	ord_pat_id
_437.orders_afps	oafp_pat_id
_437.orders_comments	orc_pat_id
_437.orders_icd9_codes	oic_pat_id
_437.orders_paps	opap_pat_id
_437.orders_paps_history	opaph_pat_id
_437.orders_standing	ost_pat_id
_437.orders_standing_dates	osd_pat_id
_437.orders_test_codes	otc_pat_id
_437.patient_access_restriction	patar_pat_id
_437.patient_amendments	pa_pat_id
_437.patient_configured_encounters	pce_pat_id
_437.patient_finance_records	pfr_pat_id
_437.patient_next_of_kin	pnk_pat_id
_437.patient_portal_requests	ppr_pat_id
_437.patients_additional_providers	pap_pat_id
_437.patients_allergies	palg_pat_id
_437.patients_authorization_numbers	pan_pat_id
_437.patients_classes_map	pcm_pat_id
_437.patients_configured_encounters_schedules	pces_pat_id
_437.patients_demographics_snapshots	pds_pat_id
_437.patients_demographics_snapshots	pds_guarantor_linked_pat_id
_437.patients_demographics_snapshots	pds_ins1_linked_pat_id
_437.patients_demographics_snapshots	pds_ins2_linked_pat_id
_437.patients_demographics_snapshots	pds_ins3_linked_pat_id
_437.patients_document_assembly	pda_pat_id
_437.patients_education_results	peres_pat_id
_437.patients_enrollments	pert_pat_id
_437.patients_erx_updates	peu_pat_id
_437.patients_ethnicities_map	pem_pat_id
_437.patients_handouts	phs_pat_id
_437.patients_health_concerns	phc_pat_id
_437.patients_health_observations	pho_pat_id
_437.patients_histories	ph_pat_id
_437.patients_icd9_problems	pip_pat_id
_437.patients_images	pi_pat_id
_437.patients_immunizations	pim_pat_id
_437.patients_implantable_devices	pid_pat_id
_437.patients_inventory	pinv_pat_id
_437.patients_medications	pms_pat_id
_437.patients_names	pn_pat_id
_437.patients_payment_methods	patpm_pat_id
_437.patients_payments_ledger_map	pplm_pat_id
_437.patients_payments_schedules	pps_pat_id
_437.patients_pids	ppid_pat_id
_437.patients_prescriptions	prx_pat_id
_437.patients_races_map	prm_pat_id
_437.patients_referrals	pref_pat_id
_437.patients_relatives_map	prm_pat_id
_437.patients_reminders	pr_pat_id
_437.patients_responsibility_estimates	prest_pat_id
_437.patients_smoking_status	pss_pat_id
_437.patients_social_answers	psa_pat_id
_437.patients_statements_map	pstm_pat_id
_437.patients_stored_messages	psm_pat_id
_437.patients_tasks	pt_pat_id
_437.patients_urls	pu_pat_id
_437.patients_vitals	pvs_pat_id
_437.poa	poa_pat_id
_437.portal_released_data	prd_pat_id
_437.portal_withheld_data	pwd_pat_id
_437.precerts	pre_pat_id
_437.precerts_comments	prc_pat_id
_437.precerts_cpt_codes	pcp_pat_id
_437.precerts_icd9_codes	pic_pat_id
_437.precerts_numbers	pnum_pat_id
_437.procedures_results	pres_pat_id
_437.radiology_order_notes	radnot_pat_id
_437.radiology_orders	rad_pat_id
_437.radiology_orders_icd9_codes	ric_pat_id
_437.radiology_orders_numbers	radnum_pat_id
_437.radiology_results	rad_res_pat_id
_437.radiology_results_test_codes_results	rrtcres_pat_id
_437.recall_list	rcl_pat_id
_437.requisition_numbers	req_pat_id
_437.structured_answers	sra_pat_id
_437.voided_payments	vp_pat_id
_8.appointment_recurrence	arec_pat_id
_8.appointments	apt_pat_id
_8.appointments_requests	aptreq_pat_id
_8.audits	aud_pat_id
_8.audits_archive	aud_pat_id
_8.audits_archive_2020	aud_pat_id
_8.audits_new	aud_pat_id
_8.audits_new_archive	aud_pat_id
_8.card_connect_profiles	cconp_pat_id
_8.charts	chrt_pat_id
_8.charts_care_plan	ccp_pat_id
_8.charts_cpt_codes	chcp_pat_id
_8.charts_diagnosis	cdx_pat_id
_8.charts_icd9_codes	cic_pat_id
_8.charts_medications	cm_pat_id
_8.charts_numbers	cnum_pat_id
_8.charts_procedures	cp_pat_id
_8.clinical_interventions_review_map	cirm_pat_id
_8.configured_encounters	confenc_pat_id
_8.cpoe_responses	cpoe_res_pat_id
_8.cqm_entries	cqme_pat_id
_8.cqm_errors	cqmer_pat_id
_8.daily_close_calculations	dcc_pat_id
_8.documents	doc_pat_id
_8.encounter_soap_labels_values_groups	eslvg_pat_id
_8.encounters	enc_pat_id
_8.encounters	enc_guarantor_linked_pat_id
_8.encounters	enc_ins1_linked_pat_id
_8.encounters	enc_ins2_linked_pat_id
_8.encounters	enc_ins3_linked_pat_id
_8.encounters_cpt_codes	ecp_pat_id
_8.encounters_icd9_codes	eic_pat_id
_8.encounters_numbers	enum_pat_id
_8.encounters_patients_races_map	eprm_pat_id
_8.encounters_soap_labels_components	eslc_pat_id
_8.encounters_soap_labels_values	eslv_pat_id
_8.encounters_soap_labels_values_map	eslvm_pat_id
_8.encounters_soap_vitals	espv_pat_id
_8.encounters_stored_notes_patients_frequency	esnpf_pat_id
_8.encounters_ub04	enc_ub04_pat_id
_8.erx_webservice_transactions	ewt_pat_id
_8.hl7_accessions	acc_pat_id
_8.hl7_results	res_pat_id
_8.insurances_repository	irep_pat_id
_8.insurances_repository	irep_linked_pat_id
_8.insurances_verification	iv_pat_id
_8.ledger	led_pat_id
_8.orders	ord_pat_id
_8.orders_afps	oafp_pat_id
_8.orders_comments	orc_pat_id
_8.orders_icd9_codes	oic_pat_id
_8.orders_paps	opap_pat_id
_8.orders_paps_history	opaph_pat_id
_8.orders_standing	ost_pat_id
_8.orders_standing_dates	osd_pat_id
_8.orders_test_codes	otc_pat_id
_8.patient_access_restriction	patar_pat_id
_8.patient_amendments	pa_pat_id
_8.patient_configured_encounters	pce_pat_id
_8.patient_finance_records	pfr_pat_id
_8.patient_next_of_kin	pnk_pat_id
_8.patient_portal_requests	ppr_pat_id
_8.patients_additional_providers	pap_pat_id
_8.patients_allergies	palg_pat_id
_8.patients_authorization_numbers	pan_pat_id
_8.patients_classes_map	pcm_pat_id
_8.patients_configured_encounters_schedules	pces_pat_id
_8.patients_demographics_snapshots	pds_pat_id
_8.patients_demographics_snapshots	pds_guarantor_linked_pat_id
_8.patients_demographics_snapshots	pds_ins1_linked_pat_id
_8.patients_demographics_snapshots	pds_ins2_linked_pat_id
_8.patients_demographics_snapshots	pds_ins3_linked_pat_id
_8.patients_document_assembly	pda_pat_id
_8.patients_education_results	peres_pat_id
_8.patients_enrollments	pert_pat_id
_8.patients_erx_updates	peu_pat_id
_8.patients_ethnicities_map	pem_pat_id
_8.patients_handouts	phs_pat_id
_8.patients_health_concerns	phc_pat_id
_8.patients_health_observations	pho_pat_id
_8.patients_histories	ph_pat_id
_8.patients_icd9_problems	pip_pat_id
_8.patients_images	pi_pat_id
_8.patients_immunizations	pim_pat_id
_8.patients_implantable_devices	pid_pat_id
_8.patients_inventory	pinv_pat_id
_8.patients_medications	pms_pat_id
_8.patients_names	pn_pat_id
_8.patients_payment_methods	patpm_pat_id
_8.patients_payments_ledger_map	pplm_pat_id
_8.patients_payments_schedules	pps_pat_id
_8.patients_pids	ppid_pat_id
_8.patients_prescriptions	prx_pat_id
_8.patients_races_map	prm_pat_id
_8.patients_referrals	pref_pat_id
_8.patients_relatives_map	prm_pat_id
_8.patients_reminders	pr_pat_id
_8.patients_responsibility_estimates	prest_pat_id
_8.patients_smoking_status	pss_pat_id
_8.patients_social_answers	psa_pat_id
_8.patients_statements_map	pstm_pat_id
_8.patients_stored_messages	psm_pat_id
_8.patients_tasks	pt_pat_id
_8.patients_urls	pu_pat_id
_8.patients_vitals	pvs_pat_id
_8.poa	poa_pat_id
_8.portal_released_data	prd_pat_id
_8.portal_withheld_data	pwd_pat_id
_8.precerts	pre_pat_id
_8.precerts_comments	prc_pat_id
_8.precerts_cpt_codes	pcp_pat_id
_8.precerts_icd9_codes	pic_pat_id
_8.precerts_numbers	pnum_pat_id
_8.procedures_results	pres_pat_id
_8.radiology_order_notes	radnot_pat_id
_8.radiology_orders	rad_pat_id
_8.radiology_orders_icd9_codes	ric_pat_id
_8.radiology_orders_numbers	radnum_pat_id
_8.radiology_results	rad_res_pat_id
_8.radiology_results_test_codes_results	rrtcres_pat_id
_8.recall_list	rcl_pat_id
_8.requisition_numbers	req_pat_id
_8.stripe_customers_accounts	sca_pat_id
_8.structured_answers	sra_pat_id
_8.voided_payments	vp_pat_id
_81.appointment_recurrence	arec_pat_id
_81.appointments	apt_pat_id
_81.appointments_requests	aptreq_pat_id
_81.audits	aud_pat_id
_81.audits_archive	aud_pat_id
_81.audits_new	aud_pat_id
_81.audits_new_archive	aud_pat_id
_81.card_connect_profiles	cconp_pat_id
_81.charts	chrt_pat_id
_81.charts_care_plan	ccp_pat_id
_81.charts_cpt_codes	chcp_pat_id
_81.charts_diagnosis	cdx_pat_id
_81.charts_icd9_codes	cic_pat_id
_81.charts_medications	cm_pat_id
_81.charts_numbers	cnum_pat_id
_81.charts_procedures	cp_pat_id
_81.clinical_interventions_review_map	cirm_pat_id
_81.cpoe_responses	cpoe_res_pat_id
_81.cqm_entries	cqme_pat_id
_81.cqm_errors	cqmer_pat_id
_81.documents	doc_pat_id
_81.encounters	enc_pat_id
_81.encounters	enc_guarantor_linked_pat_id
_81.encounters	enc_ins1_linked_pat_id
_81.encounters	enc_ins2_linked_pat_id
_81.encounters	enc_ins3_linked_pat_id
_81.encounters_cpt_codes	ecp_pat_id
_81.encounters_icd9_codes	eic_pat_id
_81.encounters_numbers	enum_pat_id
_81.encounters_patients_races_map	eprm_pat_id
_81.encounters_soap_labels_components	eslc_pat_id
_81.encounters_soap_labels_values	eslv_pat_id
_81.encounters_soap_vitals	espv_pat_id
_81.encounters_stored_notes_patients_frequency	esnpf_pat_id
_81.encounters_ub04	enc_ub04_pat_id
_81.erx_webservice_transactions	ewt_pat_id
_81.hl7_accessions	acc_pat_id
_81.hl7_results	res_pat_id
_81.insurances_repository	irep_pat_id
_81.insurances_repository	irep_linked_pat_id
_81.insurances_verification	iv_pat_id
_81.ledger	led_pat_id
_81.orders	ord_pat_id
_81.orders_afps	oafp_pat_id
_81.orders_comments	orc_pat_id
_81.orders_icd9_codes	oic_pat_id
_81.orders_paps	opap_pat_id
_81.orders_paps_history	opaph_pat_id
_81.orders_standing	ost_pat_id
_81.orders_standing_dates	osd_pat_id
_81.orders_test_codes	otc_pat_id
_81.patient_access_restriction	patar_pat_id
_81.patient_amendments	pa_pat_id
_81.patient_configured_encounters	pce_pat_id
_81.patient_finance_records	pfr_pat_id
_81.patient_next_of_kin	pnk_pat_id
_81.patient_portal_requests	ppr_pat_id
_81.patients_additional_providers	pap_pat_id
_81.patients_allergies	palg_pat_id
_81.patients_authorization_numbers	pan_pat_id
_81.patients_classes_map	pcm_pat_id
_81.patients_configured_encounters_schedules	pces_pat_id
_81.patients_demographics_snapshots	pds_pat_id
_81.patients_demographics_snapshots	pds_guarantor_linked_pat_id
_81.patients_demographics_snapshots	pds_ins1_linked_pat_id
_81.patients_demographics_snapshots	pds_ins2_linked_pat_id
_81.patients_demographics_snapshots	pds_ins3_linked_pat_id
_81.patients_document_assembly	pda_pat_id
_81.patients_education_results	peres_pat_id
_81.patients_enrollments	pert_pat_id
_81.patients_erx_updates	peu_pat_id
_81.patients_ethnicities_map	pem_pat_id
_81.patients_handouts	phs_pat_id
_81.patients_health_concerns	phc_pat_id
_81.patients_health_observations	pho_pat_id
_81.patients_histories	ph_pat_id
_81.patients_icd9_problems	pip_pat_id
_81.patients_images	pi_pat_id
_81.patients_immunizations	pim_pat_id
_81.patients_implantable_devices	pid_pat_id
_81.patients_inventory	pinv_pat_id
_81.patients_medications	pms_pat_id
_81.patients_names	pn_pat_id
_81.patients_payment_methods	patpm_pat_id
_81.patients_payments_ledger_map	pplm_pat_id
_81.patients_payments_schedules	pps_pat_id
_81.patients_pids	ppid_pat_id
_81.patients_prescriptions	prx_pat_id
_81.patients_races_map	prm_pat_id
_81.patients_referrals	pref_pat_id
_81.patients_relatives_map	prm_pat_id
_81.patients_reminders	pr_pat_id
_81.patients_responsibility_estimates	prest_pat_id
_81.patients_smoking_status	pss_pat_id
_81.patients_social_answers	psa_pat_id
_81.patients_statements_map	pstm_pat_id
_81.patients_stored_messages	psm_pat_id
_81.patients_tasks	pt_pat_id
_81.patients_urls	pu_pat_id
_81.patients_vitals	pvs_pat_id
_81.poa	poa_pat_id
_81.portal_released_data	prd_pat_id
_81.portal_withheld_data	pwd_pat_id
_81.precerts	pre_pat_id
_81.precerts_comments	prc_pat_id
_81.precerts_cpt_codes	pcp_pat_id
_81.precerts_icd9_codes	pic_pat_id
_81.precerts_numbers	pnum_pat_id
_81.procedures_results	pres_pat_id
_81.radiology_order_notes	radnot_pat_id
_81.radiology_orders	rad_pat_id
_81.radiology_orders_icd9_codes	ric_pat_id
_81.radiology_orders_numbers	radnum_pat_id
_81.radiology_results	rad_res_pat_id
_81.radiology_results_test_codes_results	rrtcres_pat_id
_81.recall_list	rcl_pat_id
_81.requisition_numbers	req_pat_id
_81.stripe_customers_accounts	sca_pat_id
_81.structured_answers	sra_pat_id
_81.voided_payments	vp_pat_id
_999.appointment_recurrence	arec_pat_id
_999.appointments	apt_pat_id
_999.appointments_requests	aptreq_pat_id
_999.audits	aud_pat_id
_999.audits_archive	aud_pat_id
_999.audits_new	aud_pat_id
_999.audits_new_archive	aud_pat_id
_999.card_connect_profiles	cconp_pat_id
_999.charts	chrt_pat_id
_999.charts_care_plan	ccp_pat_id
_999.charts_cpt_codes	chcp_pat_id
_999.charts_diagnosis	cdx_pat_id
_999.charts_icd9_codes	cic_pat_id
_999.charts_medications	cm_pat_id
_999.charts_numbers	cnum_pat_id
_999.charts_procedures	cp_pat_id
_999.clinical_interventions_review_map	cirm_pat_id
_999.configured_encounters	confenc_pat_id
_999.cpoe_responses	cpoe_res_pat_id
_999.cqm_entries	cqme_pat_id
_999.cqm_errors	cqmer_pat_id
_999.documents	doc_pat_id
_999.encounter_soap_labels_values_groups	eslvg_pat_id
_999.encounters	enc_pat_id
_999.encounters	enc_guarantor_linked_pat_id
_999.encounters	enc_ins1_linked_pat_id
_999.encounters	enc_ins2_linked_pat_id
_999.encounters	enc_ins3_linked_pat_id
_999.encounters_cpt_codes	ecp_pat_id
_999.encounters_icd9_codes	eic_pat_id
_999.encounters_numbers	enum_pat_id
_999.encounters_patients_races_map	eprm_pat_id
_999.encounters_soap_labels_components	eslc_pat_id
_999.encounters_soap_labels_values	eslv_pat_id
_999.encounters_soap_labels_values_map	eslvm_pat_id
_999.encounters_soap_vitals	espv_pat_id
_999.encounters_stored_notes_patients_frequency	esnpf_pat_id
_999.encounters_ub04	enc_ub04_pat_id
_999.erx_webservice_transactions	ewt_pat_id
_999.hl7_accessions	acc_pat_id
_999.hl7_results	res_pat_id
_999.insurances_repository	irep_pat_id
_999.insurances_repository	irep_linked_pat_id
_999.insurances_verification	iv_pat_id
_999.ledger	led_pat_id
_999.orders	ord_pat_id
_999.orders_afps	oafp_pat_id
_999.orders_comments	orc_pat_id
_999.orders_icd9_codes	oic_pat_id
_999.orders_paps	opap_pat_id
_999.orders_paps_history	opaph_pat_id
_999.orders_standing	ost_pat_id
_999.orders_standing_dates	osd_pat_id
_999.orders_test_codes	otc_pat_id
_999.patient_access_restriction	patar_pat_id
_999.patient_amendments	pa_pat_id
_999.patient_configured_encounters	pce_pat_id
_999.patient_finance_records	pfr_pat_id
_999.patient_next_of_kin	pnk_pat_id
_999.patient_portal_requests	ppr_pat_id
_999.patients_additional_providers	pap_pat_id
_999.patients_allergies	palg_pat_id
_999.patients_authorization_numbers	pan_pat_id
_999.patients_classes_map	pcm_pat_id
_999.patients_configured_encounters_schedules	pces_pat_id
_999.patients_demographics_snapshots	pds_pat_id
_999.patients_demographics_snapshots	pds_guarantor_linked_pat_id
_999.patients_demographics_snapshots	pds_ins1_linked_pat_id
_999.patients_demographics_snapshots	pds_ins2_linked_pat_id
_999.patients_demographics_snapshots	pds_ins3_linked_pat_id
_999.patients_document_assembly	pda_pat_id
_999.patients_education_results	peres_pat_id
_999.patients_enrollments	pert_pat_id
_999.patients_erx_updates	peu_pat_id
_999.patients_ethnicities_map	pem_pat_id
_999.patients_handouts	phs_pat_id
_999.patients_health_concerns	phc_pat_id
_999.patients_health_observations	pho_pat_id
_999.patients_histories	ph_pat_id
_999.patients_icd9_problems	pip_pat_id
_999.patients_images	pi_pat_id
_999.patients_immunizations	pim_pat_id
_999.patients_implantable_devices	pid_pat_id
_999.patients_inventory	pinv_pat_id
_999.patients_medications	pms_pat_id
_999.patients_names	pn_pat_id
_999.patients_payment_methods	patpm_pat_id
_999.patients_payments_ledger_map	pplm_pat_id
_999.patients_payments_schedules	pps_pat_id
_999.patients_pids	ppid_pat_id
_999.patients_prescriptions	prx_pat_id
_999.patients_races_map	prm_pat_id
_999.patients_referrals	pref_pat_id
_999.patients_relatives_map	prm_pat_id
_999.patients_reminders	pr_pat_id
_999.patients_responsibility_estimates	prest_pat_id
_999.patients_smoking_status	pss_pat_id
_999.patients_social_answers	psa_pat_id
_999.patients_statements_map	pstm_pat_id
_999.patients_stored_messages	psm_pat_id
_999.patients_tasks	pt_pat_id
_999.patients_urls	pu_pat_id
_999.patients_vitals	pvs_pat_id
_999.poa	poa_pat_id
_999.portal_released_data	prd_pat_id
_999.portal_withheld_data	pwd_pat_id
_999.precerts	pre_pat_id
_999.precerts_comments	prc_pat_id
_999.precerts_cpt_codes	pcp_pat_id
_999.precerts_icd9_codes	pic_pat_id
_999.precerts_numbers	pnum_pat_id
_999.procedures_results	pres_pat_id
_999.radiology_order_notes	radnot_pat_id
_999.radiology_orders	rad_pat_id
_999.radiology_orders_icd9_codes	ric_pat_id
_999.radiology_orders_numbers	radnum_pat_id
_999.radiology_results	rad_res_pat_id
_999.radiology_results_test_codes_results	rrtcres_pat_id
_999.recall_list	rcl_pat_id
_999.requisition_numbers	req_pat_id
_999.stripe_customers_accounts	sca_pat_id
_999.structured_answers	sra_pat_id
_999.voided_payments	vp_pat_id
aurora_standard.hl7pid	alt_pat_id
aurora_standard.hl7pidad	alt_pat_id
common.ahi_audits	aud_pat_id
common.users_portal_access	upa_pat_id

pat_sex

Table	Column
_1.clinical_alerts	ca_pat_sex
_1.clinical_interventions	ci_pat_sex
_1188.clinical_alerts	ca_pat_sex
_1188.clinical_interventions	ci_pat_sex
_1218.clinical_alerts	ca_pat_sex
_1218.clinical_interventions	ci_pat_sex
_1548.clinical_alerts	ca_pat_sex
_1548.clinical_interventions	ci_pat_sex
_435.clinical_alerts	ca_pat_sex
_435.clinical_interventions	ci_pat_sex
_436.clinical_alerts	ca_pat_sex
_436.clinical_interventions	ci_pat_sex
_436_archive_testing.clinical_alerts	ca_pat_sex
_436_archive_testing.clinical_interventions	ci_pat_sex
_437.clinical_alerts	ca_pat_sex
_437.clinical_interventions	ci_pat_sex
_8.clinical_alerts	ca_pat_sex
_8.clinical_interventions	ci_pat_sex
_81.clinical_alerts	ca_pat_sex
_81.clinical_interventions	ci_pat_sex
_999.clinical_alerts	ca_pat_sex
_999.clinical_interventions	ci_pat_sex

pat_pid

Table	Column
_1.patients_images	pi_pat_pid
_1188.patients_images	pi_pat_pid
_1218.patients_images	pi_pat_pid
_1548.patients_images	pi_pat_pid
_435.patients_images	pi_pat_pid
_436.patients_images	pi_pat_pid
_436_archive_testing.patients_images	pi_pat_pid
_437.patients_images	pi_pat_pid
_8.patients_images	pi_pat_pid
_81.patients_images	pi_pat_pid
_999.patients_images	pi_pat_pid