rcmroi.dev__rcm_roi_results

Field	Type	Null	Default	Key	Extra
master_id	int(11)	NO		PRI	auto_increment
master_guid	varchar(36)	NO		UNI
master_opid	varchar(36)	NO
master_enabled	tinyint(1)	YES	1
master_status	varchar(1)	YES
master_created	datetime	YES	CURRENT_TIMESTAMP
master_modified	datetime	NO	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
master_expires	datetime	YES
practice_name	varchar(31)	YES
specialty	varchar(18)	YES
num_phys	double	YES
num_billing_staff	double	YES
monthly_claim_volume	double	YES
annual_gross_collections	double	YES
avg_billing_staff_salary	double	YES
avg_billing_staff_fica	double	YES
avg_billing_staff_healthcare	double	YES
overhead	double	YES
software_rcm_fees	double	YES
azalea_collections_improvement	double	YES
azalea_rcm_rate	double	YES
first_name	varchar(7)	YES
last_name	varchar(9)	YES
email	varchar(34)	YES
zip	double	YES
sobj_RCM_Analysis__c	varchar(18)	YES
sobj_Lead	varchar(18)	YES
sobj_Contact	varchar(18)	YES
sobj_Account	varchar(18)	YES
update_sf	tinyint(1)	YES

References

Local Column

References

zip

Table	Column
Azalea.employees	emp_zip
_1.billing_providers	bp_zip
_1.buildings	bld_zip
_1.charts	chrt_zip
_1.client_contacts	clicon_zip
_1.encounters	enc_zip
_1.encounters	enc_employer_zip
_1.encounters	enc_guarantor_zip
_1.encounters	enc_ins1_employer_zip
_1.encounters	enc_ins2_employer_zip
_1.encounters	enc_ins3_employer_zip
_1.hl7_lab_locations	hll_zip
_1.insurances	ins_zip
_1.insurances_claims_centers	icc_zip
_1.insurances_repository	irep_ins_employer_zip
_1.locations	loc_zip
_1.non_patients	npat_zip
_1.orders	ord_zip
_1.orders	ord_ins1_employer_zip
_1.orders	ord_ins2_employer_zip
_1.patient_next_of_kin	pnk_zip
_1.patients	pat_zip
_1.patients	pat_employer_zip
_1.patients	pat_guarantor_zip
_1.patients	pat_ins1_employer_zip
_1.patients	pat_ins2_employer_zip
_1.patients	pat_ins3_employer_zip
_1.patients	pat_emergency_zip
_1.patients_demographics_snapshots	pds_zip
_1.patients_demographics_snapshots	pds_employer_zip
_1.patients_demographics_snapshots	pds_guarantor_zip
_1.patients_demographics_snapshots	pds_ins1_employer_zip
_1.patients_demographics_snapshots	pds_ins2_employer_zip
_1.patients_demographics_snapshots	pds_ins3_employer_zip
_1.physicians	phy_zip
_1.precerts	pre_zip
_1.precerts	pre_employer_zip
_1.precerts	pre_guarantor_zip
_1.precerts	pre_ins1_employer_zip
_1.precerts	pre_ins2_employer_zip
_1.radiology_orders	rad_zip
_1.radiology_orders	rad_ins1_employer_zip
_1.radiology_orders	rad_ins2_employer_zip
_1188.billing_providers	bp_zip
_1188.buildings	bld_zip
_1188.charts	chrt_zip
_1188.client_contacts	clicon_zip
_1188.encounters	enc_zip
_1188.encounters	enc_employer_zip
_1188.encounters	enc_guarantor_zip
_1188.encounters	enc_ins1_employer_zip
_1188.encounters	enc_ins2_employer_zip
_1188.encounters	enc_ins3_employer_zip
_1188.hl7_lab_locations	hll_zip
_1188.insurances	ins_zip
_1188.insurances_claims_centers	icc_zip
_1188.insurances_repository	irep_ins_employer_zip
_1188.locations	loc_zip
_1188.non_patients	npat_zip
_1188.orders	ord_zip
_1188.orders	ord_ins1_employer_zip
_1188.orders	ord_ins2_employer_zip
_1188.patient_next_of_kin	pnk_zip
_1188.patients	pat_zip
_1188.patients	pat_employer_zip
_1188.patients	pat_guarantor_zip
_1188.patients	pat_ins1_employer_zip
_1188.patients	pat_ins2_employer_zip
_1188.patients	pat_ins3_employer_zip
_1188.patients	pat_emergency_zip
_1188.patients_demographics_snapshots	pds_zip
_1188.patients_demographics_snapshots	pds_employer_zip
_1188.patients_demographics_snapshots	pds_guarantor_zip
_1188.patients_demographics_snapshots	pds_ins1_employer_zip
_1188.patients_demographics_snapshots	pds_ins2_employer_zip
_1188.patients_demographics_snapshots	pds_ins3_employer_zip
_1188.physicians	phy_zip
_1188.precerts	pre_zip
_1188.precerts	pre_employer_zip
_1188.precerts	pre_guarantor_zip
_1188.precerts	pre_ins1_employer_zip
_1188.precerts	pre_ins2_employer_zip
_1188.radiology_orders	rad_zip
_1188.radiology_orders	rad_ins1_employer_zip
_1188.radiology_orders	rad_ins2_employer_zip
_1218.billing_providers	bp_zip
_1218.buildings	bld_zip
_1218.charts	chrt_zip
_1218.client_contacts	clicon_zip
_1218.encounters	enc_zip
_1218.encounters	enc_employer_zip
_1218.encounters	enc_guarantor_zip
_1218.encounters	enc_ins1_employer_zip
_1218.encounters	enc_ins2_employer_zip
_1218.encounters	enc_ins3_employer_zip
_1218.hl7_lab_locations	hll_zip
_1218.insurances	ins_zip
_1218.insurances_claims_centers	icc_zip
_1218.insurances_repository	irep_ins_employer_zip
_1218.locations	loc_zip
_1218.non_patients	npat_zip
_1218.orders	ord_zip
_1218.orders	ord_ins1_employer_zip
_1218.orders	ord_ins2_employer_zip
_1218.patient_next_of_kin	pnk_zip
_1218.patients	pat_zip
_1218.patients	pat_employer_zip
_1218.patients	pat_guarantor_zip
_1218.patients	pat_ins1_employer_zip
_1218.patients	pat_ins2_employer_zip
_1218.patients	pat_ins3_employer_zip
_1218.patients	pat_emergency_zip
_1218.patients_demographics_snapshots	pds_zip
_1218.patients_demographics_snapshots	pds_employer_zip
_1218.patients_demographics_snapshots	pds_guarantor_zip
_1218.patients_demographics_snapshots	pds_ins1_employer_zip
_1218.patients_demographics_snapshots	pds_ins2_employer_zip
_1218.patients_demographics_snapshots	pds_ins3_employer_zip
_1218.physicians	phy_zip
_1218.precerts	pre_zip
_1218.precerts	pre_employer_zip
_1218.precerts	pre_guarantor_zip
_1218.precerts	pre_ins1_employer_zip
_1218.precerts	pre_ins2_employer_zip
_1218.radiology_orders	rad_zip
_1218.radiology_orders	rad_ins1_employer_zip
_1218.radiology_orders	rad_ins2_employer_zip
_1548.billing_providers	bp_zip
_1548.buildings	bld_zip
_1548.charts	chrt_zip
_1548.client_contacts	clicon_zip
_1548.encounters	enc_zip
_1548.encounters	enc_employer_zip
_1548.encounters	enc_guarantor_zip
_1548.encounters	enc_ins1_employer_zip
_1548.encounters	enc_ins2_employer_zip
_1548.encounters	enc_ins3_employer_zip
_1548.hl7_lab_locations	hll_zip
_1548.insurances	ins_zip
_1548.insurances_claims_centers	icc_zip
_1548.insurances_repository	irep_ins_employer_zip
_1548.locations	loc_zip
_1548.non_patients	npat_zip
_1548.orders	ord_zip
_1548.orders	ord_ins1_employer_zip
_1548.orders	ord_ins2_employer_zip
_1548.patient_next_of_kin	pnk_zip
_1548.patients	pat_zip
_1548.patients	pat_employer_zip
_1548.patients	pat_guarantor_zip
_1548.patients	pat_ins1_employer_zip
_1548.patients	pat_ins2_employer_zip
_1548.patients	pat_ins3_employer_zip
_1548.patients	pat_emergency_zip
_1548.patients_demographics_snapshots	pds_zip
_1548.patients_demographics_snapshots	pds_employer_zip
_1548.patients_demographics_snapshots	pds_guarantor_zip
_1548.patients_demographics_snapshots	pds_ins1_employer_zip
_1548.patients_demographics_snapshots	pds_ins2_employer_zip
_1548.patients_demographics_snapshots	pds_ins3_employer_zip
_1548.physicians	phy_zip
_1548.precerts	pre_zip
_1548.precerts	pre_employer_zip
_1548.precerts	pre_guarantor_zip
_1548.precerts	pre_ins1_employer_zip
_1548.precerts	pre_ins2_employer_zip
_1548.radiology_orders	rad_zip
_1548.radiology_orders	rad_ins1_employer_zip
_1548.radiology_orders	rad_ins2_employer_zip
_435.billing_providers	bp_zip
_435.buildings	bld_zip
_435.charts	chrt_zip
_435.client_contacts	clicon_zip
_435.encounters	enc_zip
_435.encounters	enc_employer_zip
_435.encounters	enc_guarantor_zip
_435.encounters	enc_ins1_employer_zip
_435.encounters	enc_ins2_employer_zip
_435.encounters	enc_ins3_employer_zip
_435.hl7_lab_locations	hll_zip
_435.insurances	ins_zip
_435.insurances_claims_centers	icc_zip
_435.insurances_repository	irep_ins_employer_zip
_435.locations	loc_zip
_435.non_patients	npat_zip
_435.orders	ord_zip
_435.orders	ord_ins1_employer_zip
_435.orders	ord_ins2_employer_zip
_435.patient_next_of_kin	pnk_zip
_435.patients	pat_zip
_435.patients	pat_employer_zip
_435.patients	pat_guarantor_zip
_435.patients	pat_ins1_employer_zip
_435.patients	pat_ins2_employer_zip
_435.patients	pat_ins3_employer_zip
_435.patients	pat_emergency_zip
_435.patients_demographics_snapshots	pds_zip
_435.patients_demographics_snapshots	pds_employer_zip
_435.patients_demographics_snapshots	pds_guarantor_zip
_435.patients_demographics_snapshots	pds_ins1_employer_zip
_435.patients_demographics_snapshots	pds_ins2_employer_zip
_435.patients_demographics_snapshots	pds_ins3_employer_zip
_435.physicians	phy_zip
_435.precerts	pre_zip
_435.precerts	pre_employer_zip
_435.precerts	pre_guarantor_zip
_435.precerts	pre_ins1_employer_zip
_435.precerts	pre_ins2_employer_zip
_435.radiology_orders	rad_zip
_435.radiology_orders	rad_ins1_employer_zip
_435.radiology_orders	rad_ins2_employer_zip
_436.billing_providers	bp_zip
_436.buildings	bld_zip
_436.charts	chrt_zip
_436.client_contacts	clicon_zip
_436.encounters	enc_zip
_436.encounters	enc_employer_zip
_436.encounters	enc_guarantor_zip
_436.encounters	enc_ins1_employer_zip
_436.encounters	enc_ins2_employer_zip
_436.encounters	enc_ins3_employer_zip
_436.hl7_lab_locations	hll_zip
_436.insurances	ins_zip
_436.insurances_claims_centers	icc_zip
_436.insurances_repository	irep_ins_employer_zip
_436.locations	loc_zip
_436.non_patients	npat_zip
_436.orders	ord_zip
_436.orders	ord_ins1_employer_zip
_436.orders	ord_ins2_employer_zip
_436.patient_next_of_kin	pnk_zip
_436.patients	pat_zip
_436.patients	pat_employer_zip
_436.patients	pat_guarantor_zip
_436.patients	pat_ins1_employer_zip
_436.patients	pat_ins2_employer_zip
_436.patients	pat_ins3_employer_zip
_436.patients	pat_emergency_zip
_436.patients_demographics_snapshots	pds_zip
_436.patients_demographics_snapshots	pds_employer_zip
_436.patients_demographics_snapshots	pds_guarantor_zip
_436.patients_demographics_snapshots	pds_ins1_employer_zip
_436.patients_demographics_snapshots	pds_ins2_employer_zip
_436.patients_demographics_snapshots	pds_ins3_employer_zip
_436.physicians	phy_zip
_436.precerts	pre_zip
_436.precerts	pre_employer_zip
_436.precerts	pre_guarantor_zip
_436.precerts	pre_ins1_employer_zip
_436.precerts	pre_ins2_employer_zip
_436.radiology_orders	rad_zip
_436.radiology_orders	rad_ins1_employer_zip
_436.radiology_orders	rad_ins2_employer_zip
_436_archive_testing.billing_providers	bp_zip
_436_archive_testing.buildings	bld_zip
_436_archive_testing.charts	chrt_zip
_436_archive_testing.client_contacts	clicon_zip
_436_archive_testing.encounters	enc_zip
_436_archive_testing.encounters	enc_employer_zip
_436_archive_testing.encounters	enc_guarantor_zip
_436_archive_testing.encounters	enc_ins1_employer_zip
_436_archive_testing.encounters	enc_ins2_employer_zip
_436_archive_testing.encounters	enc_ins3_employer_zip
_436_archive_testing.hl7_lab_locations	hll_zip
_436_archive_testing.insurances	ins_zip
_436_archive_testing.insurances_claims_centers	icc_zip
_436_archive_testing.insurances_repository	irep_ins_employer_zip
_436_archive_testing.locations	loc_zip
_436_archive_testing.non_patients	npat_zip
_436_archive_testing.orders	ord_zip
_436_archive_testing.orders	ord_ins1_employer_zip
_436_archive_testing.orders	ord_ins2_employer_zip
_436_archive_testing.patient_next_of_kin	pnk_zip
_436_archive_testing.patients	pat_zip
_436_archive_testing.patients	pat_employer_zip
_436_archive_testing.patients	pat_guarantor_zip
_436_archive_testing.patients	pat_ins1_employer_zip
_436_archive_testing.patients	pat_ins2_employer_zip
_436_archive_testing.patients	pat_ins3_employer_zip
_436_archive_testing.patients	pat_emergency_zip
_436_archive_testing.patients_demographics_snapshots	pds_zip
_436_archive_testing.patients_demographics_snapshots	pds_employer_zip
_436_archive_testing.patients_demographics_snapshots	pds_guarantor_zip
_436_archive_testing.patients_demographics_snapshots	pds_ins1_employer_zip
_436_archive_testing.patients_demographics_snapshots	pds_ins2_employer_zip
_436_archive_testing.patients_demographics_snapshots	pds_ins3_employer_zip
_436_archive_testing.physicians	phy_zip
_436_archive_testing.precerts	pre_zip
_436_archive_testing.precerts	pre_employer_zip
_436_archive_testing.precerts	pre_guarantor_zip
_436_archive_testing.precerts	pre_ins1_employer_zip
_436_archive_testing.precerts	pre_ins2_employer_zip
_436_archive_testing.radiology_orders	rad_zip
_436_archive_testing.radiology_orders	rad_ins1_employer_zip
_436_archive_testing.radiology_orders	rad_ins2_employer_zip
_437.billing_providers	bp_zip
_437.buildings	bld_zip
_437.charts	chrt_zip
_437.client_contacts	clicon_zip
_437.encounters	enc_zip
_437.encounters	enc_employer_zip
_437.encounters	enc_guarantor_zip
_437.encounters	enc_ins1_employer_zip
_437.encounters	enc_ins2_employer_zip
_437.encounters	enc_ins3_employer_zip
_437.hl7_lab_locations	hll_zip
_437.insurances	ins_zip
_437.insurances_claims_centers	icc_zip
_437.insurances_repository	irep_ins_employer_zip
_437.locations	loc_zip
_437.non_patients	npat_zip
_437.orders	ord_zip
_437.orders	ord_ins1_employer_zip
_437.orders	ord_ins2_employer_zip
_437.patient_next_of_kin	pnk_zip
_437.patients	pat_zip
_437.patients	pat_employer_zip
_437.patients	pat_guarantor_zip
_437.patients	pat_ins1_employer_zip
_437.patients	pat_ins2_employer_zip
_437.patients	pat_ins3_employer_zip
_437.patients	pat_emergency_zip
_437.patients_demographics_snapshots	pds_zip
_437.patients_demographics_snapshots	pds_employer_zip
_437.patients_demographics_snapshots	pds_guarantor_zip
_437.patients_demographics_snapshots	pds_ins1_employer_zip
_437.patients_demographics_snapshots	pds_ins2_employer_zip
_437.patients_demographics_snapshots	pds_ins3_employer_zip
_437.physicians	phy_zip
_437.precerts	pre_zip
_437.precerts	pre_employer_zip
_437.precerts	pre_guarantor_zip
_437.precerts	pre_ins1_employer_zip
_437.precerts	pre_ins2_employer_zip
_437.radiology_orders	rad_zip
_437.radiology_orders	rad_ins1_employer_zip
_437.radiology_orders	rad_ins2_employer_zip
_8.billing_providers	bp_zip
_8.buildings	bld_zip
_8.charts	chrt_zip
_8.client_contacts	clicon_zip
_8.encounters	enc_zip
_8.encounters	enc_employer_zip
_8.encounters	enc_guarantor_zip
_8.encounters	enc_ins1_employer_zip
_8.encounters	enc_ins2_employer_zip
_8.encounters	enc_ins3_employer_zip
_8.hl7_lab_locations	hll_zip
_8.insurances	ins_zip
_8.insurances_claims_centers	icc_zip
_8.insurances_repository	irep_ins_employer_zip
_8.locations	loc_zip
_8.non_patients	npat_zip
_8.orders	ord_zip
_8.orders	ord_ins1_employer_zip
_8.orders	ord_ins2_employer_zip
_8.patient_next_of_kin	pnk_zip
_8.patients	pat_zip
_8.patients	pat_employer_zip
_8.patients	pat_guarantor_zip
_8.patients	pat_ins1_employer_zip
_8.patients	pat_ins2_employer_zip
_8.patients	pat_ins3_employer_zip
_8.patients	pat_emergency_zip
_8.patients_demographics_snapshots	pds_zip
_8.patients_demographics_snapshots	pds_employer_zip
_8.patients_demographics_snapshots	pds_guarantor_zip
_8.patients_demographics_snapshots	pds_ins1_employer_zip
_8.patients_demographics_snapshots	pds_ins2_employer_zip
_8.patients_demographics_snapshots	pds_ins3_employer_zip
_8.physicians	phy_zip
_8.precerts	pre_zip
_8.precerts	pre_employer_zip
_8.precerts	pre_guarantor_zip
_8.precerts	pre_ins1_employer_zip
_8.precerts	pre_ins2_employer_zip
_8.radiology_orders	rad_zip
_8.radiology_orders	rad_ins1_employer_zip
_8.radiology_orders	rad_ins2_employer_zip
_81.billing_providers	bp_zip
_81.buildings	bld_zip
_81.charts	chrt_zip
_81.client_contacts	clicon_zip
_81.encounters	enc_zip
_81.encounters	enc_employer_zip
_81.encounters	enc_guarantor_zip
_81.encounters	enc_ins1_employer_zip
_81.encounters	enc_ins2_employer_zip
_81.encounters	enc_ins3_employer_zip
_81.hl7_lab_locations	hll_zip
_81.insurances	ins_zip
_81.insurances_claims_centers	icc_zip
_81.insurances_repository	irep_ins_employer_zip
_81.locations	loc_zip
_81.non_patients	npat_zip
_81.orders	ord_zip
_81.orders	ord_ins1_employer_zip
_81.orders	ord_ins2_employer_zip
_81.patient_next_of_kin	pnk_zip
_81.patients	pat_zip
_81.patients	pat_employer_zip
_81.patients	pat_guarantor_zip
_81.patients	pat_ins1_employer_zip
_81.patients	pat_ins2_employer_zip
_81.patients	pat_ins3_employer_zip
_81.patients	pat_emergency_zip
_81.patients_demographics_snapshots	pds_zip
_81.patients_demographics_snapshots	pds_employer_zip
_81.patients_demographics_snapshots	pds_guarantor_zip
_81.patients_demographics_snapshots	pds_ins1_employer_zip
_81.patients_demographics_snapshots	pds_ins2_employer_zip
_81.patients_demographics_snapshots	pds_ins3_employer_zip
_81.physicians	phy_zip
_81.precerts	pre_zip
_81.precerts	pre_employer_zip
_81.precerts	pre_guarantor_zip
_81.precerts	pre_ins1_employer_zip
_81.precerts	pre_ins2_employer_zip
_81.radiology_orders	rad_zip
_81.radiology_orders	rad_ins1_employer_zip
_81.radiology_orders	rad_ins2_employer_zip
_999.billing_providers	bp_zip
_999.buildings	bld_zip
_999.charts	chrt_zip
_999.client_contacts	clicon_zip
_999.encounters	enc_zip
_999.encounters	enc_employer_zip
_999.encounters	enc_guarantor_zip
_999.encounters	enc_ins1_employer_zip
_999.encounters	enc_ins2_employer_zip
_999.encounters	enc_ins3_employer_zip
_999.hl7_lab_locations	hll_zip
_999.insurances	ins_zip
_999.insurances_claims_centers	icc_zip
_999.insurances_repository	irep_ins_employer_zip
_999.locations	loc_zip
_999.non_patients	npat_zip
_999.orders	ord_zip
_999.orders	ord_ins1_employer_zip
_999.orders	ord_ins2_employer_zip
_999.patient_next_of_kin	pnk_zip
_999.patients	pat_zip
_999.patients	pat_employer_zip
_999.patients	pat_guarantor_zip
_999.patients	pat_ins1_employer_zip
_999.patients	pat_ins2_employer_zip
_999.patients	pat_ins3_employer_zip
_999.patients	pat_emergency_zip
_999.patients_demographics_snapshots	pds_zip
_999.patients_demographics_snapshots	pds_employer_zip
_999.patients_demographics_snapshots	pds_guarantor_zip
_999.patients_demographics_snapshots	pds_ins1_employer_zip
_999.patients_demographics_snapshots	pds_ins2_employer_zip
_999.patients_demographics_snapshots	pds_ins3_employer_zip
_999.physicians	phy_zip
_999.precerts	pre_zip
_999.precerts	pre_employer_zip
_999.precerts	pre_guarantor_zip
_999.precerts	pre_ins1_employer_zip
_999.precerts	pre_ins2_employer_zip
_999.radiology_orders	rad_zip
_999.radiology_orders	rad_ins1_employer_zip
_999.radiology_orders	rad_ins2_employer_zip
aurora_standard.abmmpi	p_zip
aurora_standard.abmmpi	emp_zip
aurora_standard.abmmpi	i1_zip
aurora_standard.abmmpi	i2_zip
aurora_standard.abmmpi	i3_zip
aurora_standard.abmmpi	gu_zip
aurora_standard.abmmpi	gu_emp_zip
aurora_standard.abmmpi	n1_zip
aurora_standard.abmmpi	n2_zip
aurora_standard.abmvis	p_zip
aurora_standard.abmvis	gu_zip
aurora_standard.abmvis	i1_zip
aurora_standard.abmvis	i2_zip
aurora_standard.abmvis	i3_zip
aurora_standard.anmpi	p_zip
aurora_standard.apsmpi	p_zip
aurora_standard.bempi	p_zip
aurora_standard.bfphync	city_st_zip
aurora_standard.bhar	p_zip
aurora_standard.bhar	g_zip
aurora_standard.bhar	ge_zip
aurora_standard.bhar	co1_zip
aurora_standard.bhar	co2_zip
aurora_standard.bhar	co3_zip
aurora_standard.bhar	co4_zip
aurora_standard.bhar	co5_zip
aurora_standard.bhar	co6_zip
aurora_standard.bhar	em_zip
aurora_standard.bmmpi	p_zip
aurora_standard.bmmpi	gu_zip
aurora_standard.bmnkin	n_zip
aurora_standard.bmpact	p_zip
aurora_standard.bmpact	gu_zip
aurora_standard.bpar	p_zip
aurora_standard.bpar	g_zip
aurora_standard.bpar	ge_zip
aurora_standard.bpar	co1_zip
aurora_standard.bpar	co2_zip
aurora_standard.bpar	co3_zip
aurora_standard.bpar	co4_zip
aurora_standard.bpar	co5_zip
aurora_standard.bpar	co6_zip
aurora_standard.bpar	em_zip
aurora_standard.bpar2	p_zip
aurora_standard.bpar2	g_zip
aurora_standard.bpar2	ge_zip
aurora_standard.bpar2	co1_zip
aurora_standard.bpar2	co2_zip
aurora_standard.bpar2	co3_zip
aurora_standard.bpar2	co4_zip
aurora_standard.bpar2	co5_zip
aurora_standard.bpar2	co6_zip
aurora_standard.bpar2	em_zip
aurora_standard.bpmpi	p_zip
aurora_standard.bpmpi2	p_zip
aurora_standard.bs2mpi	contact1_zip
aurora_standard.bs2mpi	p_zip
aurora_standard.bsmpi	contact1_zip
aurora_standard.bsmpi	p_zip
aurora_standard.c7insur2	ins_zip
aurora_standard.c7insur3	ins_zip
aurora_standard.c7mpi	p_zip
aurora_standard.c7mpi	p2_zip
aurora_standard.c7mpi	insur_zip
aurora_standard.c7mpi	gu_zip
aurora_standard.c7mpi	gu2_zip
aurora_standard.c8mpi	p_zip
aurora_standard.c9mpi	p_zip
aurora_standard.c9mpi	nk_zip
aurora_standard.chlswbhd	fac_zip
aurora_standard.chlswbhd	agt_zip
aurora_standard.chlswbhd	sfw_zip
aurora_standard.chltrnhd	fac_zip
aurora_standard.chltrnhd	agt_zip
aurora_standard.chltrnhd	sfw_zip
aurora_standard.chmarcnbf	g_zip
aurora_standard.chmarcnbf	ins1_zip
aurora_standard.chmarcnbf	ins2_zip
aurora_standard.chmarsi	pat_zip
aurora_standard.chmarsi	gu_zip
aurora_standard.chmarsi	gu_emp_zip
aurora_standard.chmarsi	pat_emp_zip
aurora_standard.chmarsi	ins1_zip
aurora_standard.chmarsi	ins1_empl_zip
aurora_standard.chmarsi	ins2_zip
aurora_standard.chmarsi	ins2_empl_zip
aurora_standard.chmarsi	ins3_zip
aurora_standard.chmarsi	ins3_empl_zip
aurora_standard.chmarst	fac_zip
aurora_standard.chmarsti	fac_zip
aurora_standard.chmarstps	ins_zip
aurora_standard.chmarstps	emp_zip
aurora_standard.chmarstpt	ins_zip
aurora_standard.chmarstpt	emp_zip
aurora_standard.chmazstd	pat_zip
aurora_standard.chmazsti	pat_zip
aurora_standard.chmazsto	pat_zip
aurora_standard.chmcampi	pat_zip
aurora_standard.chmcampi	gu_zip
aurora_standard.chmcampi	gu_emp_zip
aurora_standard.chmcampi	pat_emp_zip
aurora_standard.chmcampi	ins1_zip
aurora_standard.chmcampi	ins1_empl_zip
aurora_standard.chmcampi	ins2_zip
aurora_standard.chmcampi	ins2_empl_zip
aurora_standard.chmcampi	ins3_zip
aurora_standard.chmcampi	ins3_empl_zip
aurora_standard.chmcmhed	debtor_zip
aurora_standard.chmcmhed	pat_zip
aurora_standard.chmexmpi	pat_zip
aurora_standard.chmexmpi	gu_zip
aurora_standard.chmexmpi	gu_emp_zip
aurora_standard.chmexmpi	pat_emp_zip
aurora_standard.chmexmpi	ins1_zip
aurora_standard.chmexmpi	ins1_empl_zip
aurora_standard.chmexmpi	ins2_zip
aurora_standard.chmexmpi	ins2_empl_zip
aurora_standard.chmexmpi	ins3_zip
aurora_standard.chmexmpi	ins3_empl_zip
aurora_standard.chmexvis	ins1_zip
aurora_standard.chmexvis	ins2_zip
aurora_standard.chmexvis	ins3_zip
aurora_standard.chmhistp	p_zip
aurora_standard.chmlastr	pat_zip
aurora_standard.chmlastr	pat_empl_zip
aurora_standard.chmmbc37	plan_carrier_zip
aurora_standard.chmmrhdr	upd_zip
aurora_standard.chmnvstb	prov_zip
aurora_standard.chmnvstb	payto_zip
aurora_standard.chmnvstr	prov_zip
aurora_standard.chmnvstr	payto_zip
aurora_standard.chmokipd	pat_zip
aurora_standard.chmokopd	pat_zip
aurora_standard.chmozpcd	debtor_zip
aurora_standard.chmpdemo	p_zip
aurora_standard.chmpdemo	p_emp_zip
aurora_standard.chmpdemo	sp_zip
aurora_standard.chmpdemo	gu_zip
aurora_standard.chmpdemo	gu_emp_zip
aurora_standard.chmpdemo	ins1_zip
aurora_standard.chmpdemo	ins1_empl_zip
aurora_standard.chmpdemo	ins2_zip
aurora_standard.chmpdemo	ins2_empl_zip
aurora_standard.chmpdemo	ins3_zip
aurora_standard.chmpdemo	ins3_empl_zip
aurora_standard.chmradex	pat_zip
aurora_standard.chmradex	pat_emp_zip
aurora_standard.chmradex	gu_zip
aurora_standard.chmradex	gu_emp_zip
aurora_standard.chmradex	ins1_zip
aurora_standard.chmradex	ins1_empl_zip
aurora_standard.chmradex	ins2_zip
aurora_standard.chmradex	ins2_empl_zip
aurora_standard.chmradex	ins3_zip
aurora_standard.chmradex	ins3_empl_zip
aurora_standard.chmtxstr	pat_zip
aurora_standard.chmtxstr	pat_empl_zip
aurora_standard.chmutah4	pat_zip
aurora_standard.chpdeped	depend_zip
aurora_standard.stp1099c	company_zip
aurora_standard.stp1099c	vend_zip
aurora_standard.stprepsd	rep_zip
aurora_standard.stpvendr	agent_zip
aurora_standard.styoctcc	employer_zip
aurora_standard.styoctcc	gov_entity_zip
aurora_standard.styoempr	empl_zip
common.applicants	app_zip
common.applicants	app_employer_1_zip
common.applicants	app_employer_2_zip
common.applicants	app_employer_3_zip
common.applicants	app_employer_4_zip
common.clients	cli_zip
common.clients	cli_billing_zip
common.clients	cli_mailing_zip
common.clients_contract_data	ccd_payer_zip
common.contacts	con_zip
common.customers	cus_zip
common.customers	cus_billing_zip
common.lab_interfaces	lif_cli_zip
common.lab_interfaces_performing_sites	lips_zip
common.labs	lab_zip
common.leads	lea_zip
rcmroi.dev__sf_users	addr_zip
rcmroi.prod__sf_users	addr_zip
rcmroi.test__sf_users	addr_zip

Table	Column
AzaleaStats.login_events	loge_entered_email
Messaging.messages_contacts	mc_email
_1.charts	chrt_email
_1.client_contacts	clicon_email
_1.encounters	enc_email
_1.non_patients	npat_email
_1.patients	pat_email
_1.patients	pat_email_no_email
_1.patients_demographics_snapshots	pds_email
_1.patients_demographics_snapshots	pds_email_no_email
_1.physicians	phy_email
_1.precerts	pre_email
_1188.charts	chrt_email
_1188.client_contacts	clicon_email
_1188.encounters	enc_email
_1188.non_patients	npat_email
_1188.patients	pat_email
_1188.patients	pat_email_no_email
_1188.patients_demographics_snapshots	pds_email
_1188.patients_demographics_snapshots	pds_email_no_email
_1188.physicians	phy_email
_1188.precerts	pre_email
_1218.charts	chrt_email
_1218.client_contacts	clicon_email
_1218.encounters	enc_email
_1218.non_patients	npat_email
_1218.patients	pat_email
_1218.patients	pat_email_no_email
_1218.patients_demographics_snapshots	pds_email
_1218.patients_demographics_snapshots	pds_email_no_email
_1218.physicians	phy_email
_1218.precerts	pre_email
_1548.charts	chrt_email
_1548.client_contacts	clicon_email
_1548.encounters	enc_email
_1548.non_patients	npat_email
_1548.patients	pat_email
_1548.patients	pat_email_no_email
_1548.patients_demographics_snapshots	pds_email
_1548.patients_demographics_snapshots	pds_email_no_email
_1548.physicians	phy_email
_1548.precerts	pre_email
_435.charts	chrt_email
_435.client_contacts	clicon_email
_435.encounters	enc_email
_435.non_patients	npat_email
_435.patients	pat_email
_435.patients	pat_email_no_email
_435.patients_demographics_snapshots	pds_email
_435.patients_demographics_snapshots	pds_email_no_email
_435.physicians	phy_email
_435.precerts	pre_email
_436.charts	chrt_email
_436.client_contacts	clicon_email
_436.encounters	enc_email
_436.non_patients	npat_email
_436.patients	pat_email
_436.patients	pat_email_no_email
_436.patients_demographics_snapshots	pds_email
_436.patients_demographics_snapshots	pds_email_no_email
_436.physicians	phy_email
_436.precerts	pre_email
_436_archive_testing.charts	chrt_email
_436_archive_testing.client_contacts	clicon_email
_436_archive_testing.encounters	enc_email
_436_archive_testing.non_patients	npat_email
_436_archive_testing.patients	pat_email
_436_archive_testing.patients	pat_email_no_email
_436_archive_testing.patients_demographics_snapshots	pds_email
_436_archive_testing.patients_demographics_snapshots	pds_email_no_email
_436_archive_testing.physicians	phy_email
_436_archive_testing.precerts	pre_email
_437.charts	chrt_email
_437.client_contacts	clicon_email
_437.encounters	enc_email
_437.non_patients	npat_email
_437.patients	pat_email
_437.patients	pat_email_no_email
_437.patients_demographics_snapshots	pds_email
_437.patients_demographics_snapshots	pds_email_no_email
_437.physicians	phy_email
_437.precerts	pre_email
_8.charts	chrt_email
_8.client_contacts	clicon_email
_8.encounters	enc_email
_8.non_patients	npat_email
_8.patients	pat_email
_8.patients	pat_email_no_email
_8.patients_demographics_snapshots	pds_email
_8.patients_demographics_snapshots	pds_email_no_email
_8.physicians	phy_email
_8.precerts	pre_email
_81.charts	chrt_email
_81.client_contacts	clicon_email
_81.encounters	enc_email
_81.non_patients	npat_email
_81.patients	pat_email
_81.patients	pat_email_no_email
_81.patients_demographics_snapshots	pds_email
_81.patients_demographics_snapshots	pds_email_no_email
_81.physicians	phy_email
_81.precerts	pre_email
_999.charts	chrt_email
_999.client_contacts	clicon_email
_999.encounters	enc_email
_999.non_patients	npat_email
_999.patients	pat_email
_999.patients	pat_email_no_email
_999.patients_demographics_snapshots	pds_email
_999.patients_demographics_snapshots	pds_email_no_email
_999.physicians	phy_email
_999.precerts	pre_email
ahiWiki.ipblocks	ipb_block_email
ahiWiki.user	user_email
aurora_standard.chmhl7ic	company_email
aurora_standard.chmhstmr	pat_email
aurora_standard.stp1099c	contact_email
aurora_standard.stp1099c	vend_email
aurora_standard.stprepsd	rep_email
aurora_standard.stpvendr	ap_email
aurora_standard.stpvendr	agent_email
aurora_standard.styuimmr	cont_email
aurora_standard.styw2mm1	cont_email
common.applicants	app_email
common.applicants	app_employer_1_supervisor_email
common.applicants	app_employer_2_supervisor_email
common.applicants	app_employer_3_supervisor_email
common.applicants	app_employer_4_supervisor_email
common.clients	cli_email
common.clients_contract_data	ccd_payer_email
common.contact_imports	ci_email
common.contacts	con_email
common.customers	cus_email
common.dashboardmd_users	dmdu_email
common.leads	lea_email
common.login_blocks	lb_email
common.login_events	loge_entered_email
common.sessions	session_email
common.telehealth_codes	thc_invite_email
common.users	usr_email
sessions.sessions	session_email

master_id

Table	Column
HSPI_Bastrop.charge_master_codes	charge_master_id
HSPI_CURES2015_B1.charge_master_codes	charge_master_id
HSPI_Central_Hospital.charge_master_codes	charge_master_id
HSPI_Dewitt.charge_master_codes	charge_master_id
HSPI_Fulton.charge_master_codes	charge_master_id
HSPI_Inferno.charge_master_codes	charge_master_id
HSPI_MU2015_E1.charge_master_codes	charge_master_id
HSPI_MU2015_G2.charge_master_codes	charge_master_id
HSPI_MU2015_G9.charge_master_codes	charge_master_id
HSPI_Ness.charge_master_codes	charge_master_id
HSPI_Sandbox.charge_master_codes	charge_master_id
HSPI_Summit_General.charge_master_codes	charge_master_id
HSPI_United_Physicians.charge_master_codes	charge_master_id
MPI.charge_master_codes	charge_master_id

practice_name

Table	Column
_1.erx_ans	erx_ans_practice_name
_1188.erx_ans	erx_ans_practice_name
_1218.erx_ans	erx_ans_practice_name
_1548.erx_ans	erx_ans_practice_name
_435.erx_ans	erx_ans_practice_name
_436.erx_ans	erx_ans_practice_name
_436_archive_testing.erx_ans	erx_ans_practice_name
_437.erx_ans	erx_ans_practice_name
_8.erx_ans	erx_ans_practice_name
_81.erx_ans	erx_ans_practice_name
_999.erx_ans	erx_ans_practice_name

last_name

Table	Column
aurora_standard.c7insur2	p_last_name
aurora_standard.c7insur3	p_last_name
aurora_standard.chm1500r	pat_last_name
aurora_standard.chmcmhed	pat_last_name
aurora_standard.chmstmtd	g_last_name

first_name

Table	Column
aurora_standard.c7insur2	p_first_name
aurora_standard.c7insur3	p_first_name
aurora_standard.chm1500r	pat_first_name
aurora_standard.chmcmhed	pat_first_name
aurora_standard.chmstmtd	g_first_name