_81.encounters

Field	Type	Null	Default	Key	Extra	Comment
enc_id	int(11)	NO		PRI	auto_increment
enc_cus_id	int(11)	NO	0	MUL
enc_cli_id	int(11)	NO	0	MUL
enc_pat_id	int(11)	NO	0	MUL
enc_phy_id	int(11)	NO	0	MUL
enc_phy_id_referring	int(11)	NO	0	MUL
enc_phy_id_attending	int(11)	YES		MUL		stores the phy_id of the attending provider
enc_phy_id_referring_out	int(11)	NO	0
enc_phy_id_supervising	int(11)	NO		MUL		This is the rendering override provider, based on the EDI spec this provider overrides the rendering provider.
enc_phy_id_managing	int(11)	NO	0			This is the physician that supervised the rendering provider. The actual supervising provider as outlined in the EDI spec.
enc_phy_id_reviewing	int(11)	NO	0
enc_encounter_num	varchar(20)	NO		MUL
enc_emergency	tinyint(1)	NO	0
enc_ub04_id	int(11)	NO
enc_pid	varchar(20)	NO		MUL
enc_mrn	varchar(20)	NO		MUL
enc_ssn	varchar(11)	NO		MUL
enc_fname	varchar(40)	NO		MUL		First Name
enc_mname	varchar(40)	NO				Middle Name
enc_lname	varchar(40)	NO		MUL		Last Name
enc_suffix	varchar(10)	NO
enc_email	varchar(80)	NO
enc_bill_type	char(1)	NO
enc_dob	varchar(8)	NO		MUL
enc_age	varchar(3)	NO
enc_sex	varchar(7)	NO
enc_race	varchar(50)	NO
enc_ethnicity	varchar(30)	NO
enc_maritial_status	varchar(30)	NO
enc_address1	varchar(40)	NO
enc_address2	varchar(40)	NO
enc_city	varchar(30)	NO
enc_state	varchar(2)	NO
enc_zip	varchar(12)	NO
enc_zip_plus4	varchar(4)	NO
enc_ctry_id	int(11)	YES				Encounter Country ID
enc_phone	varchar(20)	NO
enc_phone_work	varchar(20)	NO
enc_phone_other	varchar(20)	NO
enc_fax	varchar(20)	NO
enc_employer	varchar(40)	NO
enc_employer_occupation	varchar(30)	NO
enc_employer_status	varchar(30)	NO
enc_employer_address1	varchar(40)	NO
enc_employer_address2	varchar(40)	NO				Employer address line 2
enc_employer_city	varchar(30)	NO
enc_employer_state	varchar(2)	NO
enc_employer_zip	varchar(12)	NO
enc_employer_zip_plus4	varchar(4)	NO
enc_employer_ctry_id	int(11)	YES				Encounter Employer Country ID
enc_guarantor_linked_pat_id	int(11)	NO		MUL
enc_guarantor	varchar(40)	NO
enc_guarantor_relation	varchar(20)	NO
enc_guarantor_address1	varchar(40)	NO
enc_guarantor_address2	varchar(40)	NO
enc_guarantor_city	varchar(30)	NO
enc_guarantor_state	varchar(2)	NO
enc_guarantor_zip	varchar(12)	NO
enc_guarantor_zip_plus4	varchar(4)	NO
enc_guarantor_ctry_id	int(11)	YES				Encounter Guarantor Country ID
enc_guarantor_phone	varchar(20)	NO
enc_guarantor_phone_work	varchar(20)	NO
enc_guarantor_employer	varchar(40)	NO
enc_guarantor_dob	varchar(8)	NO
enc_guarantor_ssn	varchar(11)	NO
enc_ins1_linked_pat_id	int(11)	NO
enc_ins1_id	int(11)	NO		MUL
enc_ins1_policy_num	varchar(40)	NO
enc_ins1_group_num	varchar(40)	NO
enc_ins1_start_date	varchar(8)	NO
enc_ins1_end_date	varchar(8)	NO
enc_ins1_insured	varchar(40)	NO
enc_ins1_insured_relation	varchar(20)	NO
enc_ins1_insured_dob	varchar(8)	NO
enc_ins1_insured_ssn	varchar(11)	NO
enc_ins1_insured_sex	varchar(7)	NO
enc_ins1_employer_name	varchar(40)	NO
enc_ins1_employer_address	varchar(40)	NO
enc_ins1_employer_city	varchar(30)	NO
enc_ins1_employer_state	varchar(2)	NO
enc_ins1_employer_zip	varchar(12)	NO
enc_ins1_employer_zip_plus4	varchar(4)	NO
enc_ins1_employer_ctry_id	int(11)	YES				Encounter Primary Insurance Employer Country ID
enc_ins1_pan_id	int(11)	NO	0	MUL		Patient authorization number ID#
enc_ins1_referral_num	varchar(40)	NO
enc_ins1_referral_start_date	varchar(8)	NO
enc_ins1_referral_end_date	varchar(8)	NO
enc_ins1_referral_num_visits	varchar(3)	NO
enc_ins1_medicaid_referral_num	varchar(12)	NO
enc_ins1_epsdt	char(1)	NO
enc_ins1_epsdt_yes_no	char(1)	NO
enc_ins1_epsdt_referral_code	varchar(2)	NO
enc_ins1_vaccines	char(1)	NO
enc_ins1_tpl_code	varchar(3)	YES				Primary Insurance's Third Party Liability Code
enc_ins1_tpl_status	varchar(2)	YES				Primary Insurance's Third Party Liability status
enc_ins2_linked_pat_id	int(11)	NO
enc_ins2_id	int(11)	NO		MUL
enc_ins2_policy_num	varchar(40)	NO
enc_ins2_group_num	varchar(40)	NO
enc_ins2_start_date	varchar(8)	NO
enc_ins2_end_date	varchar(8)	NO
enc_ins2_insured	varchar(40)	NO
enc_ins2_insured_relation	varchar(20)	NO
enc_ins2_insured_dob	varchar(8)	NO
enc_ins2_insured_ssn	varchar(11)	NO
enc_ins2_insured_sex	varchar(7)	NO
enc_ins2_employer_name	varchar(40)	NO
enc_ins2_employer_address	varchar(40)	NO
enc_ins2_employer_city	varchar(30)	NO
enc_ins2_employer_state	varchar(2)	NO
enc_ins2_employer_zip	varchar(12)	NO
enc_ins2_employer_zip_plus4	varchar(4)	NO
enc_ins2_employer_ctry_id	int(11)	YES				Encounter Secondary Insurance Employer Country ID
enc_ins2_pan_id	int(11)	YES		MUL		Secondary Insurance Authorization ID#
enc_ins2_vaccines	char(1)	NO
enc_ins2_tpl_code	varchar(3)	YES				Secondary Insurance's Third Party Liability Code
enc_ins2_tpl_status	varchar(2)	YES				Secondary Insurance's Third Party Liability status
enc_ins3_linked_pat_id	int(11)	NO
enc_ins3_id	int(11)	NO
enc_ins3_policy_num	varchar(40)	NO
enc_ins3_group_num	varchar(40)	NO
enc_ins3_start_date	varchar(8)	NO
enc_ins3_end_date	varchar(8)	NO
enc_ins3_insured	varchar(40)	NO
enc_ins3_insured_relation	varchar(20)	NO
enc_ins3_insured_dob	varchar(8)	NO
enc_ins3_insured_ssn	varchar(11)	NO
enc_ins3_insured_sex	varchar(7)	NO
enc_ins3_employer_name	varchar(40)	NO
enc_ins3_employer_address	varchar(40)	NO
enc_ins3_employer_city	varchar(30)	NO
enc_ins3_employer_state	varchar(2)	NO
enc_ins3_employer_zip	varchar(12)	NO
enc_ins3_employer_zip_plus4	varchar(4)	NO
enc_ins3_employer_ctry_id	int(11)	YES				Encounter Tertiary Insurance Employer Country ID
enc_ins3_pan_id	int(11)	YES		MUL		Tertiary Insurance Authorization ID#
enc_ins3_vaccines	varchar(45)	NO
enc_date_of_service	varchar(8)	NO		MUL
enc_action_dt	datetime	YES		MUL		Set datetime for when the next action should occur by
enc_balance	varchar(10)	NO		MUL
enc_next_payer	varchar(15)	NO		MUL
enc_visit_time	varchar(3)	NO
enc_loc_id	int(11)	NO
enc_cfs_id	int(11)	NO
enc_sfs_id	int(11)	NO	0	MUL		Sliding Fee Scale ID
enc_spl_id	int(11)	NO
enc_sty_id	int(11)	NO
enc_ess_id	int(11)	NO		MUL
enc_usr_id_created	int(11)	NO		MUL
enc_usr_modified	timestamp	YES				Timestamp for direct user modification
enc_usr_id_modified	int(11)	NO		MUL
enc_notes	text	NO
enc_employment_related	char(1)	NO	0
enc_auto_accident	char(1)	NO	0
enc_auto_accident_state	varchar(2)	NO
enc_other_accident	char(1)	NO	0
enc_current_type	char(1)	NO	0
enc_date_of_current	varchar(8)	NO
enc_first_type	char(1)	NO	0
enc_first_date	varchar(8)	NO
enc_local_use	varchar(60)	NO
enc_unable_to_work_from	varchar(8)	NO
enc_unable_to_work_to	varchar(8)	NO
enc_hospitalized_from	varchar(8)	NO
enc_hospitalized_to	varchar(8)	NO
enc_outside_lab	char(1)	NO	0
enc_outside_lab_charges	varchar(10)	NO
enc_initial_billing_date	date	YES		MUL		Date first claim was sent for encounter
enc_billing_date	varchar(8)	NO
enc_pv1_id	varchar(64)	NO		MUL
enc_accept_assignment	char(1)	NO
enc_assignment_benefits	tinyint(1)	NO	1
enc_medicaid_resub_code	varchar(20)	NO	1			Used for claims
enc_medicaid_resub_org_ref	varchar(20)	NO
enc_nucc_use	varchar(28)	NO				Reserved for nucc use
enc_claim_code	varchar(19)	NO				Reserved for nucc use
enc_split	int(11)	NO		MUL
enc_copied_from	int(11)	NO
enc_version_num	tinyint(3) unsigned	NO
enc_billing_only	char(1)	NO	0	MUL
enc_diag_cs_id	int(11)	NO	2	MUL
enc_household_members	tinyint(4)	NO	0			count of members (including self) in patient's household
enc_poverty_line_pct	decimal(5,4)	NO	0.0000			Poverty Line Percentage (Never > 999.9%)
enc_annual_income	int(11)	YES				annual income of patient in dollar amount
enc_drc_id	int(11)	NO	0	MUL		Delay reason code id
enc_pce_id	int(11)	YES		MUL
enc_pces_id	int(11)	YES		MUL
enc_created_from_mobile	char(1)	NO	0
enc_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
enc_created	timestamp	YES	CURRENT_TIMESTAMP
enc_bp_id	int(11)	YES		MUL

References

Local Column

References

enc_id

Table	Column
_1.appointments	apt_enc_id
_1.audits	aud_enc_id
_1.audits_archive	aud_enc_id
_1.audits_new	aud_enc_id
_1.audits_new_archive	aud_enc_id
_1.charts_care_plan	ccp_enc_id
_1.charts_classes_map	ccm_enc_id
_1.charts_diagnosis	cdx_enc_id
_1.charts_icd9_codes	cic_enc_id
_1.charts_procedures	cp_enc_id
_1.configured_encounters	confenc_enc_id
_1.cqm_entries	cqme_enc_id
_1.encounter_alert_rules_map	earm_enc_id
_1.encounter_soap_messaging_log	esml_enc_id
_1.encounters_claims_statuses	ecs_enc_id
_1.encounters_claims_supplemental_informations	ecsi_enc_id
_1.encounters_classes_map	ecm_enc_id
_1.encounters_comments_snapshots	ecss_enc_id
_1.encounters_cpt_codes	ecp_enc_id
_1.encounters_cpt_denials	ecd_enc_id
_1.encounters_details_snapshots	edss_enc_id
_1.encounters_dx_pointers	edp_enc_id
_1.encounters_ecp_snapshots	eecps_enc_id
_1.encounters_edi_errors	eee_enc_id
_1.encounters_eic_snapshots	eeics_enc_id
_1.encounters_forms	efrm_enc_id
_1.encounters_icd9_codes	eic_enc_id
_1.encounters_incomplete_reasons_map	eirm_enc_id
_1.encounters_numbers	enum_enc_id
_1.encounters_patients_races_map	eprm_enc_id
_1.encounters_payments_edi_logs	epel_enc_id
_1.encounters_payments_edi_logs_cpt_codes	epelcc_enc_id
_1.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_enc_id
_1.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_enc_id
_1.encounters_payments_override_formula	epof_enc_id
_1.encounters_signed	esig_enc_id
_1.encounters_soap	esp_enc_id
_1.encounters_soap_images	espi_enc_id
_1.encounters_soap_labels_components	eslc_enc_id
_1.encounters_soap_labels_values	eslv_enc_id
_1.encounters_soap_labels_values_map	eslvm_enc_id
_1.encounters_soap_messaging_logs	esml_enc_id
_1.encounters_soap_snapshots	esss_enc_id
_1.encounters_soap_templates	est_enc_id
_1.encounters_soap_vitals	espv_enc_id
_1.encounters_surveillance_records	esr_enc_id
_1.encounters_ub04	enc_ub04_enc_id
_1.encounters_ub04_snapshots	euss_enc_id
_1.hl7_results	res_enc_id
_1.insurances_contracted_pricing_log	icpl_enc_id
_1.ledger	led_enc_id
_1.orders	ord_enc_id
_1.patient_amendments	pa_enc_id
_1.patients_histories	ph_enc_id
_1.patients_images	pi_enc_id
_1.patients_immunizations	pim_enc_id
_1.patients_inventory	pinv_enc_id
_1.patients_prescriptions	prx_enc_id
_1.patients_referrals	pref_enc_id
_1.precerts_encounters_map	penm_enc_id
_1.problems_lists	pl_enc_id
_1.procedures_results	pres_enc_id
_1.radiology_orders	rad_enc_id
_1.recall_list	rcl_enc_id
_1.structured_answers	sra_enc_id
_1.voided_payments	vp_enc_id
_1188.appointments	apt_enc_id
_1188.audits	aud_enc_id
_1188.audits_archive	aud_enc_id
_1188.audits_new	aud_enc_id
_1188.audits_new_archive	aud_enc_id
_1188.charts_care_plan	ccp_enc_id
_1188.charts_classes_map	ccm_enc_id
_1188.charts_diagnosis	cdx_enc_id
_1188.charts_icd9_codes	cic_enc_id
_1188.charts_procedures	cp_enc_id
_1188.cqm_entries	cqme_enc_id
_1188.encounter_alert_rules_map	earm_enc_id
_1188.encounters_claims_statuses	ecs_enc_id
_1188.encounters_claims_supplemental_informations	ecsi_enc_id
_1188.encounters_classes_map	ecm_enc_id
_1188.encounters_comments_snapshots	ecss_enc_id
_1188.encounters_cpt_codes	ecp_enc_id
_1188.encounters_cpt_denials	ecd_enc_id
_1188.encounters_details_snapshots	edss_enc_id
_1188.encounters_dx_pointers	edp_enc_id
_1188.encounters_ecp_snapshots	eecps_enc_id
_1188.encounters_edi_errors	eee_enc_id
_1188.encounters_eic_snapshots	eeics_enc_id
_1188.encounters_forms	efrm_enc_id
_1188.encounters_icd9_codes	eic_enc_id
_1188.encounters_incomplete_reasons_map	eirm_enc_id
_1188.encounters_patients_races_map	eprm_enc_id
_1188.encounters_payments_edi_logs	epel_enc_id
_1188.encounters_payments_edi_logs_cpt_codes	epelcc_enc_id
_1188.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_enc_id
_1188.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_enc_id
_1188.encounters_payments_override_formula	epof_enc_id
_1188.encounters_signed	esig_enc_id
_1188.encounters_soap	esp_enc_id
_1188.encounters_soap_images	espi_enc_id
_1188.encounters_soap_labels_components	eslc_enc_id
_1188.encounters_soap_labels_values	eslv_enc_id
_1188.encounters_soap_snapshots	esss_enc_id
_1188.encounters_soap_templates	est_enc_id
_1188.encounters_soap_vitals	espv_enc_id
_1188.encounters_surveillance_records	esr_enc_id
_1188.encounters_ub04	enc_ub04_enc_id
_1188.encounters_ub04_snapshots	euss_enc_id
_1188.hl7_results	res_enc_id
_1188.insurances_contracted_pricing_log	icpl_enc_id
_1188.ledger	led_enc_id
_1188.orders	ord_enc_id
_1188.patient_amendments	pa_enc_id
_1188.patients_histories	ph_enc_id
_1188.patients_images	pi_enc_id
_1188.patients_immunizations	pim_enc_id
_1188.patients_inventory	pinv_enc_id
_1188.patients_prescriptions	prx_enc_id
_1188.patients_referrals	pref_enc_id
_1188.precerts_encounters_map	penm_enc_id
_1188.problems_lists	pl_enc_id
_1188.procedures_results	pres_enc_id
_1188.radiology_orders	rad_enc_id
_1188.recall_list	rcl_enc_id
_1188.structured_answers	sra_enc_id
_1188.voided_payments	vp_enc_id
_1218.appointments	apt_enc_id
_1218.audits	aud_enc_id
_1218.audits_archive	aud_enc_id
_1218.audits_new	aud_enc_id
_1218.audits_new_archive	aud_enc_id
_1218.charts_care_plan	ccp_enc_id
_1218.charts_classes_map	ccm_enc_id
_1218.charts_diagnosis	cdx_enc_id
_1218.charts_icd9_codes	cic_enc_id
_1218.charts_procedures	cp_enc_id
_1218.cqm_entries	cqme_enc_id
_1218.encounter_alert_rules_map	earm_enc_id
_1218.encounters_claims_statuses	ecs_enc_id
_1218.encounters_claims_supplemental_informations	ecsi_enc_id
_1218.encounters_classes_map	ecm_enc_id
_1218.encounters_comments_snapshots	ecss_enc_id
_1218.encounters_cpt_codes	ecp_enc_id
_1218.encounters_cpt_denials	ecd_enc_id
_1218.encounters_details_snapshots	edss_enc_id
_1218.encounters_dx_pointers	edp_enc_id
_1218.encounters_ecp_snapshots	eecps_enc_id
_1218.encounters_edi_errors	eee_enc_id
_1218.encounters_eic_snapshots	eeics_enc_id
_1218.encounters_forms	efrm_enc_id
_1218.encounters_icd9_codes	eic_enc_id
_1218.encounters_incomplete_reasons_map	eirm_enc_id
_1218.encounters_patients_races_map	eprm_enc_id
_1218.encounters_payments_edi_logs	epel_enc_id
_1218.encounters_payments_edi_logs_cpt_codes	epelcc_enc_id
_1218.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_enc_id
_1218.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_enc_id
_1218.encounters_payments_override_formula	epof_enc_id
_1218.encounters_signed	esig_enc_id
_1218.encounters_soap	esp_enc_id
_1218.encounters_soap_images	espi_enc_id
_1218.encounters_soap_labels_components	eslc_enc_id
_1218.encounters_soap_labels_values	eslv_enc_id
_1218.encounters_soap_labels_values_map	eslvm_enc_id
_1218.encounters_soap_snapshots	esss_enc_id
_1218.encounters_soap_templates	est_enc_id
_1218.encounters_soap_vitals	espv_enc_id
_1218.encounters_surveillance_records	esr_enc_id
_1218.encounters_ub04	enc_ub04_enc_id
_1218.encounters_ub04_snapshots	euss_enc_id
_1218.hl7_results	res_enc_id
_1218.insurances_contracted_pricing_log	icpl_enc_id
_1218.led_temporary_ledger_table_ANM	led_enc_id
_1218.ledger	led_enc_id
_1218.orders	ord_enc_id
_1218.patient_amendments	pa_enc_id
_1218.patients_histories	ph_enc_id
_1218.patients_images	pi_enc_id
_1218.patients_immunizations	pim_enc_id
_1218.patients_inventory	pinv_enc_id
_1218.patients_prescriptions	prx_enc_id
_1218.patients_referrals	pref_enc_id
_1218.precerts_encounters_map	penm_enc_id
_1218.problems_lists	pl_enc_id
_1218.procedures_results	pres_enc_id
_1218.radiology_orders	rad_enc_id
_1218.recall_list	rcl_enc_id
_1218.structured_answers	sra_enc_id
_1218.voided_payments	vp_enc_id
_1548.appointments	apt_enc_id
_1548.audits	aud_enc_id
_1548.audits_archive	aud_enc_id
_1548.audits_new	aud_enc_id
_1548.audits_new_archive	aud_enc_id
_1548.charts_care_plan	ccp_enc_id
_1548.charts_classes_map	ccm_enc_id
_1548.charts_diagnosis	cdx_enc_id
_1548.charts_icd9_codes	cic_enc_id
_1548.charts_procedures	cp_enc_id
_1548.configured_encounters	confenc_enc_id
_1548.cqm_entries	cqme_enc_id
_1548.encounter_alert_rules_map	earm_enc_id
_1548.encounter_soap_messaging_log	esml_enc_id
_1548.encounters_claims_statuses	ecs_enc_id
_1548.encounters_claims_supplemental_informations	ecsi_enc_id
_1548.encounters_classes_map	ecm_enc_id
_1548.encounters_comments_snapshots	ecss_enc_id
_1548.encounters_cpt_codes	ecp_enc_id
_1548.encounters_cpt_denials	ecd_enc_id
_1548.encounters_details_snapshots	edss_enc_id
_1548.encounters_dx_pointers	edp_enc_id
_1548.encounters_ecp_snapshots	eecps_enc_id
_1548.encounters_edi_errors	eee_enc_id
_1548.encounters_eic_snapshots	eeics_enc_id
_1548.encounters_forms	efrm_enc_id
_1548.encounters_icd9_codes	eic_enc_id
_1548.encounters_incomplete_reasons_map	eirm_enc_id
_1548.encounters_numbers	enum_enc_id
_1548.encounters_patients_races_map	eprm_enc_id
_1548.encounters_payments_edi_logs	epel_enc_id
_1548.encounters_payments_edi_logs_cpt_codes	epelcc_enc_id
_1548.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_enc_id
_1548.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_enc_id
_1548.encounters_payments_override_formula	epof_enc_id
_1548.encounters_signed	esig_enc_id
_1548.encounters_soap	esp_enc_id
_1548.encounters_soap_images	espi_enc_id
_1548.encounters_soap_labels_components	eslc_enc_id
_1548.encounters_soap_labels_values	eslv_enc_id
_1548.encounters_soap_labels_values_map	eslvm_enc_id
_1548.encounters_soap_messaging_logs	esml_enc_id
_1548.encounters_soap_snapshots	esss_enc_id
_1548.encounters_soap_templates	est_enc_id
_1548.encounters_soap_vitals	espv_enc_id
_1548.encounters_surveillance_records	esr_enc_id
_1548.encounters_ub04	enc_ub04_enc_id
_1548.encounters_ub04_snapshots	euss_enc_id
_1548.hl7_results	res_enc_id
_1548.insurances_contracted_pricing_log	icpl_enc_id
_1548.ledger	led_enc_id
_1548.orders	ord_enc_id
_1548.patient_amendments	pa_enc_id
_1548.patients_histories	ph_enc_id
_1548.patients_images	pi_enc_id
_1548.patients_immunizations	pim_enc_id
_1548.patients_inventory	pinv_enc_id
_1548.patients_prescriptions	prx_enc_id
_1548.patients_referrals	pref_enc_id
_1548.precerts_encounters_map	penm_enc_id
_1548.problems_lists	pl_enc_id
_1548.procedures_results	pres_enc_id
_1548.radiology_orders	rad_enc_id
_1548.recall_list	rcl_enc_id
_1548.structured_answers	sra_enc_id
_1548.voided_payments	vp_enc_id
_435.appointments	apt_enc_id
_435.audits	aud_enc_id
_435.audits_archive	aud_enc_id
_435.audits_archive_2008	aud_enc_id
_435.audits_archive_2009	aud_enc_id
_435.audits_archive_2010	aud_enc_id
_435.audits_archive_2011	aud_enc_id
_435.audits_archive_2012	aud_enc_id
_435.audits_archive_2013	aud_enc_id
_435.audits_archive_2014	aud_enc_id
_435.audits_archive_2015	aud_enc_id
_435.audits_archive_2016	aud_enc_id
_435.audits_archive_2017	aud_enc_id
_435.audits_archive_2018	aud_enc_id
_435.audits_archive_2019	aud_enc_id
_435.audits_archive_2020	aud_enc_id
_435.audits_new	aud_enc_id
_435.audits_new_archive	aud_enc_id
_435.audits_new_trial	aud_enc_id
_435.charts_care_plan	ccp_enc_id
_435.charts_classes_map	ccm_enc_id
_435.charts_diagnosis	cdx_enc_id
_435.charts_icd9_codes	cic_enc_id
_435.charts_procedures	cp_enc_id
_435.configured_encounters	confenc_enc_id
_435.cqm_entries	cqme_enc_id
_435.encounter_alert_rules_map	earm_enc_id
_435.encounter_soap_messaging_log	esml_enc_id
_435.encounters_claims_statuses	ecs_enc_id
_435.encounters_claims_supplemental_informations	ecsi_enc_id
_435.encounters_classes_map	ecm_enc_id
_435.encounters_comments_snapshots	ecss_enc_id
_435.encounters_cpt_codes	ecp_enc_id
_435.encounters_cpt_denials	ecd_enc_id
_435.encounters_details_snapshots	edss_enc_id
_435.encounters_dx_pointers	edp_enc_id
_435.encounters_ecp_snapshots	eecps_enc_id
_435.encounters_edi_errors	eee_enc_id
_435.encounters_eic_snapshots	eeics_enc_id
_435.encounters_forms	efrm_enc_id
_435.encounters_icd9_codes	eic_enc_id
_435.encounters_incomplete_reasons_map	eirm_enc_id
_435.encounters_patients_races_map	eprm_enc_id
_435.encounters_payments_edi_logs	epel_enc_id
_435.encounters_payments_edi_logs_cpt_codes	epelcc_enc_id
_435.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_enc_id
_435.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_enc_id
_435.encounters_payments_override_formula	epof_enc_id
_435.encounters_signed	esig_enc_id
_435.encounters_soap	esp_enc_id
_435.encounters_soap_images	espi_enc_id
_435.encounters_soap_labels_components	eslc_enc_id
_435.encounters_soap_labels_values	eslv_enc_id
_435.encounters_soap_labels_values_map	eslvm_enc_id
_435.encounters_soap_snapshots	esss_enc_id
_435.encounters_soap_templates	est_enc_id
_435.encounters_soap_vitals	espv_enc_id
_435.encounters_surveillance_records	esr_enc_id
_435.encounters_ub04	enc_ub04_enc_id
_435.encounters_ub04_snapshots	euss_enc_id
_435.hl7_results	res_enc_id
_435.insurances_contracted_pricing_log	icpl_enc_id
_435.ledger	led_enc_id
_435.orders	ord_enc_id
_435.patient_amendments	pa_enc_id
_435.patients_histories	ph_enc_id
_435.patients_images	pi_enc_id
_435.patients_immunizations	pim_enc_id
_435.patients_inventory	pinv_enc_id
_435.patients_prescriptions	prx_enc_id
_435.patients_referrals	pref_enc_id
_435.precerts_encounters_map	penm_enc_id
_435.problems_lists	pl_enc_id
_435.procedures_results	pres_enc_id
_435.radiology_orders	rad_enc_id
_435.recall_list	rcl_enc_id
_435.structured_answers	sra_enc_id
_435.voided_payments	vp_enc_id
_436.appointments	apt_enc_id
_436.audits	aud_enc_id
_436.audits_archive	aud_enc_id
_436.audits_new	aud_enc_id
_436.audits_new_archive	aud_enc_id
_436.charts_care_plan	ccp_enc_id
_436.charts_classes_map	ccm_enc_id
_436.charts_diagnosis	cdx_enc_id
_436.charts_icd9_codes	cic_enc_id
_436.charts_procedures	cp_enc_id
_436.configured_encounters	confenc_enc_id
_436.cqm_entries	cqme_enc_id
_436.encounter_alert_rules_map	earm_enc_id
_436.encounter_soap_messaging_log	esml_enc_id
_436.encounters_claims_statuses	ecs_enc_id
_436.encounters_claims_supplemental_informations	ecsi_enc_id
_436.encounters_classes_map	ecm_enc_id
_436.encounters_comments_snapshots	ecss_enc_id
_436.encounters_cpt_codes	ecp_enc_id
_436.encounters_cpt_denials	ecd_enc_id
_436.encounters_details_snapshots	edss_enc_id
_436.encounters_dx_pointers	edp_enc_id
_436.encounters_ecp_snapshots	eecps_enc_id
_436.encounters_edi_errors	eee_enc_id
_436.encounters_eic_snapshots	eeics_enc_id
_436.encounters_forms	efrm_enc_id
_436.encounters_icd9_codes	eic_enc_id
_436.encounters_incomplete_reasons_map	eirm_enc_id
_436.encounters_patients_races_map	eprm_enc_id
_436.encounters_payments_edi_logs	epel_enc_id
_436.encounters_payments_edi_logs_cpt_codes	epelcc_enc_id
_436.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_enc_id
_436.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_enc_id
_436.encounters_payments_override_formula	epof_enc_id
_436.encounters_signed	esig_enc_id
_436.encounters_soap	esp_enc_id
_436.encounters_soap_images	espi_enc_id
_436.encounters_soap_labels_components	eslc_enc_id
_436.encounters_soap_labels_values	eslv_enc_id
_436.encounters_soap_labels_values_map	eslvm_enc_id
_436.encounters_soap_snapshots	esss_enc_id
_436.encounters_soap_templates	est_enc_id
_436.encounters_soap_vitals	espv_enc_id
_436.encounters_surveillance_records	esr_enc_id
_436.encounters_ub04	enc_ub04_enc_id
_436.encounters_ub04_snapshots	euss_enc_id
_436.hl7_results	res_enc_id
_436.insurances_contracted_pricing_log	icpl_enc_id
_436.ledger	led_enc_id
_436.orders	ord_enc_id
_436.patient_amendments	pa_enc_id
_436.patients_histories	ph_enc_id
_436.patients_images	pi_enc_id
_436.patients_immunizations	pim_enc_id
_436.patients_inventory	pinv_enc_id
_436.patients_prescriptions	prx_enc_id
_436.patients_referrals	pref_enc_id
_436.precerts_encounters_map	penm_enc_id
_436.problems_lists	pl_enc_id
_436.procedures_results	pres_enc_id
_436.radiology_orders	rad_enc_id
_436.recall_list	rcl_enc_id
_436.structured_answers	sra_enc_id
_436.voided_payments	vp_enc_id
_436_archive_testing.appointments	apt_enc_id
_436_archive_testing.audits	aud_enc_id
_436_archive_testing.audits_archive	aud_enc_id
_436_archive_testing.audits_archive_2008	aud_enc_id
_436_archive_testing.audits_archive_2009	aud_enc_id
_436_archive_testing.audits_archive_2010	aud_enc_id
_436_archive_testing.audits_archive_2011	aud_enc_id
_436_archive_testing.audits_archive_2012	aud_enc_id
_436_archive_testing.audits_archive_2013	aud_enc_id
_436_archive_testing.audits_archive_2014	aud_enc_id
_436_archive_testing.audits_archive_2015	aud_enc_id
_436_archive_testing.audits_archive_2016	aud_enc_id
_436_archive_testing.audits_archive_2017	aud_enc_id
_436_archive_testing.audits_archive_2018	aud_enc_id
_436_archive_testing.audits_archive_2019	aud_enc_id
_436_archive_testing.audits_archive_2020	aud_enc_id
_436_archive_testing.audits_archive_2021	aud_enc_id
_436_archive_testing.audits_new	aud_enc_id
_436_archive_testing.audits_new_archive	aud_enc_id
_436_archive_testing.charts_care_plan	ccp_enc_id
_436_archive_testing.charts_classes_map	ccm_enc_id
_436_archive_testing.charts_diagnosis	cdx_enc_id
_436_archive_testing.charts_icd9_codes	cic_enc_id
_436_archive_testing.charts_procedures	cp_enc_id
_436_archive_testing.configured_encounters	confenc_enc_id
_436_archive_testing.cqm_entries	cqme_enc_id
_436_archive_testing.encounter_alert_rules_map	earm_enc_id
_436_archive_testing.encounter_soap_messaging_log	esml_enc_id
_436_archive_testing.encounters_claims_statuses	ecs_enc_id
_436_archive_testing.encounters_claims_supplemental_informations	ecsi_enc_id
_436_archive_testing.encounters_classes_map	ecm_enc_id
_436_archive_testing.encounters_comments_snapshots	ecss_enc_id
_436_archive_testing.encounters_cpt_codes	ecp_enc_id
_436_archive_testing.encounters_cpt_denials	ecd_enc_id
_436_archive_testing.encounters_details_snapshots	edss_enc_id
_436_archive_testing.encounters_dx_pointers	edp_enc_id
_436_archive_testing.encounters_ecp_snapshots	eecps_enc_id
_436_archive_testing.encounters_edi_errors	eee_enc_id
_436_archive_testing.encounters_eic_snapshots	eeics_enc_id
_436_archive_testing.encounters_forms	efrm_enc_id
_436_archive_testing.encounters_icd9_codes	eic_enc_id
_436_archive_testing.encounters_incomplete_reasons_map	eirm_enc_id
_436_archive_testing.encounters_patients_races_map	eprm_enc_id
_436_archive_testing.encounters_payments_edi_logs	epel_enc_id
_436_archive_testing.encounters_payments_edi_logs_cpt_codes	epelcc_enc_id
_436_archive_testing.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_enc_id
_436_archive_testing.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_enc_id
_436_archive_testing.encounters_payments_override_formula	epof_enc_id
_436_archive_testing.encounters_signed	esig_enc_id
_436_archive_testing.encounters_soap	esp_enc_id
_436_archive_testing.encounters_soap_images	espi_enc_id
_436_archive_testing.encounters_soap_labels_components	eslc_enc_id
_436_archive_testing.encounters_soap_labels_values	eslv_enc_id
_436_archive_testing.encounters_soap_labels_values_map	eslvm_enc_id
_436_archive_testing.encounters_soap_snapshots	esss_enc_id
_436_archive_testing.encounters_soap_templates	est_enc_id
_436_archive_testing.encounters_soap_vitals	espv_enc_id
_436_archive_testing.encounters_surveillance_records	esr_enc_id
_436_archive_testing.encounters_ub04	enc_ub04_enc_id
_436_archive_testing.encounters_ub04_snapshots	euss_enc_id
_436_archive_testing.hl7_results	res_enc_id
_436_archive_testing.insurances_contracted_pricing_log	icpl_enc_id
_436_archive_testing.ledger	led_enc_id
_436_archive_testing.orders	ord_enc_id
_436_archive_testing.patient_amendments	pa_enc_id
_436_archive_testing.patients_histories	ph_enc_id
_436_archive_testing.patients_images	pi_enc_id
_436_archive_testing.patients_immunizations	pim_enc_id
_436_archive_testing.patients_inventory	pinv_enc_id
_436_archive_testing.patients_prescriptions	prx_enc_id
_436_archive_testing.patients_referrals	pref_enc_id
_436_archive_testing.precerts_encounters_map	penm_enc_id
_436_archive_testing.problems_lists	pl_enc_id
_436_archive_testing.procedures_results	pres_enc_id
_436_archive_testing.radiology_orders	rad_enc_id
_436_archive_testing.recall_list	rcl_enc_id
_436_archive_testing.structured_answers	sra_enc_id
_436_archive_testing.voided_payments	vp_enc_id
_437.appointments	apt_enc_id
_437.audits	aud_enc_id
_437.audits_archive	aud_enc_id
_437.audits_new	aud_enc_id
_437.audits_new_archive	aud_enc_id
_437.charts_care_plan	ccp_enc_id
_437.charts_classes_map	ccm_enc_id
_437.charts_diagnosis	cdx_enc_id
_437.charts_icd9_codes	cic_enc_id
_437.charts_procedures	cp_enc_id
_437.configured_encounters	confenc_enc_id
_437.cqm_entries	cqme_enc_id
_437.encounter_alert_rules_map	earm_enc_id
_437.encounter_soap_messaging_log	esml_enc_id
_437.encounters_claims_statuses	ecs_enc_id
_437.encounters_claims_supplemental_informations	ecsi_enc_id
_437.encounters_classes_map	ecm_enc_id
_437.encounters_comments_snapshots	ecss_enc_id
_437.encounters_cpt_codes	ecp_enc_id
_437.encounters_cpt_denials	ecd_enc_id
_437.encounters_details_snapshots	edss_enc_id
_437.encounters_dx_pointers	edp_enc_id
_437.encounters_ecp_snapshots	eecps_enc_id
_437.encounters_edi_errors	eee_enc_id
_437.encounters_eic_snapshots	eeics_enc_id
_437.encounters_forms	efrm_enc_id
_437.encounters_icd9_codes	eic_enc_id
_437.encounters_incomplete_reasons_map	eirm_enc_id
_437.encounters_patients_races_map	eprm_enc_id
_437.encounters_payments_edi_logs	epel_enc_id
_437.encounters_payments_edi_logs_cpt_codes	epelcc_enc_id
_437.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_enc_id
_437.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_enc_id
_437.encounters_payments_override_formula	epof_enc_id
_437.encounters_signed	esig_enc_id
_437.encounters_soap	esp_enc_id
_437.encounters_soap_images	espi_enc_id
_437.encounters_soap_labels_components	eslc_enc_id
_437.encounters_soap_labels_values	eslv_enc_id
_437.encounters_soap_labels_values_map	eslvm_enc_id
_437.encounters_soap_snapshots	esss_enc_id
_437.encounters_soap_templates	est_enc_id
_437.encounters_soap_vitals	espv_enc_id
_437.encounters_surveillance_records	esr_enc_id
_437.encounters_ub04	enc_ub04_enc_id
_437.encounters_ub04_snapshots	euss_enc_id
_437.hl7_results	res_enc_id
_437.insurances_contracted_pricing_log	icpl_enc_id
_437.ledger	led_enc_id
_437.orders	ord_enc_id
_437.patient_amendments	pa_enc_id
_437.patients_histories	ph_enc_id
_437.patients_images	pi_enc_id
_437.patients_immunizations	pim_enc_id
_437.patients_inventory	pinv_enc_id
_437.patients_prescriptions	prx_enc_id
_437.patients_referrals	pref_enc_id
_437.precerts_encounters_map	penm_enc_id
_437.problems_lists	pl_enc_id
_437.procedures_results	pres_enc_id
_437.radiology_orders	rad_enc_id
_437.recall_list	rcl_enc_id
_437.structured_answers	sra_enc_id
_437.voided_payments	vp_enc_id
_8.appointments	apt_enc_id
_8.audits	aud_enc_id
_8.audits_archive	aud_enc_id
_8.audits_archive_2020	aud_enc_id
_8.audits_new	aud_enc_id
_8.audits_new_archive	aud_enc_id
_8.charts_care_plan	ccp_enc_id
_8.charts_classes_map	ccm_enc_id
_8.charts_diagnosis	cdx_enc_id
_8.charts_icd9_codes	cic_enc_id
_8.charts_procedures	cp_enc_id
_8.configured_encounters	confenc_enc_id
_8.cqm_entries	cqme_enc_id
_8.daily_close_calculations	dcc_enc_id
_8.encounter_alert_rules_map	earm_enc_id
_8.encounter_soap_messaging_log	esml_enc_id
_8.encounters_claims_statuses	ecs_enc_id
_8.encounters_claims_supplemental_informations	ecsi_enc_id
_8.encounters_classes_map	ecm_enc_id
_8.encounters_comments_snapshots	ecss_enc_id
_8.encounters_cpt_codes	ecp_enc_id
_8.encounters_cpt_denials	ecd_enc_id
_8.encounters_details_snapshots	edss_enc_id
_8.encounters_dx_pointers	edp_enc_id
_8.encounters_ecp_snapshots	eecps_enc_id
_8.encounters_edi_errors	eee_enc_id
_8.encounters_eic_snapshots	eeics_enc_id
_8.encounters_forms	efrm_enc_id
_8.encounters_icd9_codes	eic_enc_id
_8.encounters_incomplete_reasons_map	eirm_enc_id
_8.encounters_numbers	enum_enc_id
_8.encounters_patients_races_map	eprm_enc_id
_8.encounters_payments_edi_logs	epel_enc_id
_8.encounters_payments_edi_logs_cpt_codes	epelcc_enc_id
_8.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_enc_id
_8.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_enc_id
_8.encounters_payments_override_formula	epof_enc_id
_8.encounters_signed	esig_enc_id
_8.encounters_soap	esp_enc_id
_8.encounters_soap_images	espi_enc_id
_8.encounters_soap_labels_components	eslc_enc_id
_8.encounters_soap_labels_values	eslv_enc_id
_8.encounters_soap_labels_values_map	eslvm_enc_id
_8.encounters_soap_messaging_logs	esml_enc_id
_8.encounters_soap_snapshots	esss_enc_id
_8.encounters_soap_templates	est_enc_id
_8.encounters_soap_vitals	espv_enc_id
_8.encounters_surveillance_records	esr_enc_id
_8.encounters_ub04	enc_ub04_enc_id
_8.encounters_ub04_snapshots	euss_enc_id
_8.hl7_results	res_enc_id
_8.insurances_contracted_pricing_log	icpl_enc_id
_8.ledger	led_enc_id
_8.orders	ord_enc_id
_8.patient_amendments	pa_enc_id
_8.patients_histories	ph_enc_id
_8.patients_images	pi_enc_id
_8.patients_immunizations	pim_enc_id
_8.patients_inventory	pinv_enc_id
_8.patients_prescriptions	prx_enc_id
_8.patients_referrals	pref_enc_id
_8.precerts_encounters_map	penm_enc_id
_8.problems_lists	pl_enc_id
_8.procedures_results	pres_enc_id
_8.radiology_orders	rad_enc_id
_8.recall_list	rcl_enc_id
_8.structured_answers	sra_enc_id
_8.voided_payments	vp_enc_id
_81.appointments	apt_enc_id
_81.audits	aud_enc_id
_81.audits_archive	aud_enc_id
_81.audits_new	aud_enc_id
_81.audits_new_archive	aud_enc_id
_81.charts_care_plan	ccp_enc_id
_81.charts_classes_map	ccm_enc_id
_81.charts_diagnosis	cdx_enc_id
_81.charts_icd9_codes	cic_enc_id
_81.charts_procedures	cp_enc_id
_81.cqm_entries	cqme_enc_id
_81.encounter_alert_rules_map	earm_enc_id
_81.encounters_claims_statuses	ecs_enc_id
_81.encounters_claims_supplemental_informations	ecsi_enc_id
_81.encounters_classes_map	ecm_enc_id
_81.encounters_comments_snapshots	ecss_enc_id
_81.encounters_cpt_codes	ecp_enc_id
_81.encounters_cpt_denials	ecd_enc_id
_81.encounters_details_snapshots	edss_enc_id
_81.encounters_dx_pointers	edp_enc_id
_81.encounters_ecp_snapshots	eecps_enc_id
_81.encounters_edi_errors	eee_enc_id
_81.encounters_eic_snapshots	eeics_enc_id
_81.encounters_forms	efrm_enc_id
_81.encounters_icd9_codes	eic_enc_id
_81.encounters_incomplete_reasons_map	eirm_enc_id
_81.encounters_patients_races_map	eprm_enc_id
_81.encounters_payments_edi_logs	epel_enc_id
_81.encounters_payments_edi_logs_cpt_codes	epelcc_enc_id
_81.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_enc_id
_81.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_enc_id
_81.encounters_payments_override_formula	epof_enc_id
_81.encounters_signed	esig_enc_id
_81.encounters_soap	esp_enc_id
_81.encounters_soap_images	espi_enc_id
_81.encounters_soap_labels_components	eslc_enc_id
_81.encounters_soap_labels_values	eslv_enc_id
_81.encounters_soap_snapshots	esss_enc_id
_81.encounters_soap_templates	est_enc_id
_81.encounters_soap_vitals	espv_enc_id
_81.encounters_surveillance_records	esr_enc_id
_81.encounters_ub04	enc_ub04_enc_id
_81.encounters_ub04_snapshots	euss_enc_id
_81.hl7_results	res_enc_id
_81.insurances_contracted_pricing_log	icpl_enc_id
_81.ledger	led_enc_id
_81.orders	ord_enc_id
_81.patient_amendments	pa_enc_id
_81.patients_histories	ph_enc_id
_81.patients_images	pi_enc_id
_81.patients_immunizations	pim_enc_id
_81.patients_inventory	pinv_enc_id
_81.patients_prescriptions	prx_enc_id
_81.patients_referrals	pref_enc_id
_81.precerts_encounters_map	penm_enc_id
_81.problems_lists	pl_enc_id
_81.procedures_results	pres_enc_id
_81.radiology_orders	rad_enc_id
_81.recall_list	rcl_enc_id
_81.structured_answers	sra_enc_id
_81.voided_payments	vp_enc_id
_999.appointments	apt_enc_id
_999.audits	aud_enc_id
_999.audits_archive	aud_enc_id
_999.audits_new	aud_enc_id
_999.audits_new_archive	aud_enc_id
_999.charts_care_plan	ccp_enc_id
_999.charts_classes_map	ccm_enc_id
_999.charts_diagnosis	cdx_enc_id
_999.charts_icd9_codes	cic_enc_id
_999.charts_procedures	cp_enc_id
_999.configured_encounters	confenc_enc_id
_999.cqm_entries	cqme_enc_id
_999.encounter_alert_rules_map	earm_enc_id
_999.encounter_soap_messaging_log	esml_enc_id
_999.encounters_claims_statuses	ecs_enc_id
_999.encounters_claims_supplemental_informations	ecsi_enc_id
_999.encounters_classes_map	ecm_enc_id
_999.encounters_comments_snapshots	ecss_enc_id
_999.encounters_cpt_codes	ecp_enc_id
_999.encounters_cpt_denials	ecd_enc_id
_999.encounters_details_snapshots	edss_enc_id
_999.encounters_dx_pointers	edp_enc_id
_999.encounters_ecp_snapshots	eecps_enc_id
_999.encounters_edi_errors	eee_enc_id
_999.encounters_eic_snapshots	eeics_enc_id
_999.encounters_forms	efrm_enc_id
_999.encounters_icd9_codes	eic_enc_id
_999.encounters_incomplete_reasons_map	eirm_enc_id
_999.encounters_numbers	enum_enc_id
_999.encounters_patients_races_map	eprm_enc_id
_999.encounters_payments_edi_logs	epel_enc_id
_999.encounters_payments_edi_logs_cpt_codes	epelcc_enc_id
_999.encounters_payments_edi_logs_cpt_codes_adjust_codes	epelccac_enc_id
_999.encounters_payments_edi_logs_cpt_codes_remark_codes	epelccrc_enc_id
_999.encounters_payments_override_formula	epof_enc_id
_999.encounters_signed	esig_enc_id
_999.encounters_soap	esp_enc_id
_999.encounters_soap_images	espi_enc_id
_999.encounters_soap_labels_components	eslc_enc_id
_999.encounters_soap_labels_values	eslv_enc_id
_999.encounters_soap_labels_values_map	eslvm_enc_id
_999.encounters_soap_messaging_logs	esml_enc_id
_999.encounters_soap_snapshots	esss_enc_id
_999.encounters_soap_templates	est_enc_id
_999.encounters_soap_vitals	espv_enc_id
_999.encounters_surveillance_records	esr_enc_id
_999.encounters_ub04	enc_ub04_enc_id
_999.encounters_ub04_snapshots	euss_enc_id
_999.hl7_results	res_enc_id
_999.insurances_contracted_pricing_log	icpl_enc_id
_999.ledger	led_enc_id
_999.orders	ord_enc_id
_999.patient_amendments	pa_enc_id
_999.patients_histories	ph_enc_id
_999.patients_images	pi_enc_id
_999.patients_immunizations	pim_enc_id
_999.patients_inventory	pinv_enc_id
_999.patients_prescriptions	prx_enc_id
_999.patients_referrals	pref_enc_id
_999.precerts_encounters_map	penm_enc_id
_999.problems_lists	pl_enc_id
_999.procedures_results	pres_enc_id
_999.radiology_orders	rad_enc_id
_999.recall_list	rcl_enc_id
_999.structured_answers	sra_enc_id
_999.voided_payments	vp_enc_id
common.ahi_audits	aud_enc_id

enc_version_num

Table	Column
_1.encounters_signed	esig_enc_version_num
_1188.encounters_signed	esig_enc_version_num
_1218.encounters_signed	esig_enc_version_num
_1548.encounters_signed	esig_enc_version_num
_435.encounters_signed	esig_enc_version_num
_436.encounters_signed	esig_enc_version_num
_436_archive_testing.encounters_signed	esig_enc_version_num
_437.encounters_signed	esig_enc_version_num
_8.encounters_signed	esig_enc_version_num
_81.encounters_signed	esig_enc_version_num
_999.encounters_signed	esig_enc_version_num

enc_encounter_num

Table	Column
_8.daily_close_calculations	dcc_enc_encounter_num

enc_date_of_service

Table	Column
_8.daily_close_calculations	dcc_enc_date_of_service

enc_bill_type

Table	Column
_8.daily_close_calculations	dcc_enc_bill_type