aurora_standard.chhl7adt

Field	Type	Null	Default	Key	Extra
chs_rowID	int(11)	NO		PRI	auto_increment
visit_no	varchar(255)	YES
mr_no	varchar(255)	YES
fac_no	varchar(255)	YES
ssn	varchar(255)	YES
last_name	varchar(255)	YES
first_name	varchar(255)	YES
mid_name	varchar(255)	YES
birth_date	varchar(255)	YES
sex	varchar(255)	YES
race_code	varchar(255)	YES
patient_add1	varchar(255)	YES
patient_add2	varchar(255)	YES
patient_city	varchar(255)	YES
patient_state	varchar(255)	YES
patient_zip_1	varchar(255)	YES
patient_class	varchar(255)	YES
curr_nurs	varchar(255)	YES
curr_room	varchar(255)	YES
curr_bed	varchar(255)	YES
attend_phy	varchar(255)	YES
other_cc_phy	varchar(255)	YES
pat_status	varchar(255)	YES
vip_code	varchar(255)	YES
admit_phy	varchar(255)	YES
pat_status1	varchar(255)	YES
visit_no1	varchar(255)	YES
fin_class	varchar(255)	YES
dischg_reason	varchar(255)	YES
admit_date_time	varchar(255)	YES
dischg_date_time	varchar(255)	YES
processed_at	datetime	YES
processed	varchar(255)	YES	N	MUL
error_message	varchar(255)	YES
created_at	datetime	YES
updated_at	datetime	YES
religion_code	varchar(255)	NO
interest	varchar(255)	NO

References

Local Column

References

ssn

Table	Column
Azalea.employees	emp_ssn
_1.charts	chrt_ssn
_1.cpoe_responses	cpoe_res_ssn
_1.encounters	enc_ssn
_1.encounters	enc_guarantor_ssn
_1.encounters	enc_ins1_insured_ssn
_1.encounters	enc_ins2_insured_ssn
_1.encounters	enc_ins3_insured_ssn
_1.examples	exa_ssn
_1.hl7_accessions	acc_ssn
_1.insurances_repository	irep_ins_insured_ssn
_1.non_patients	npat_ssn
_1.orders	ord_ssn
_1.patients	pat_ssn
_1.patients	pat_guarantor_ssn
_1.patients	pat_ins1_insured_ssn
_1.patients	pat_ins2_insured_ssn
_1.patients	pat_ins3_insured_ssn
_1.patients_demographics_snapshots	pds_ssn
_1.patients_demographics_snapshots	pds_guarantor_ssn
_1.patients_demographics_snapshots	pds_ins1_insured_ssn
_1.patients_demographics_snapshots	pds_ins2_insured_ssn
_1.patients_demographics_snapshots	pds_ins3_insured_ssn
_1.patients_responsibility_estimates	prest_ssn
_1.precerts	pre_ssn
_1.precerts	pre_guarantor_ssn
_1.precerts	pre_ins1_insured_ssn
_1.precerts	pre_ins2_insured_ssn
_1.radiology_orders	rad_ssn
_1.radiology_results	rad_res_ssn
_1188.charts	chrt_ssn
_1188.cpoe_responses	cpoe_res_ssn
_1188.encounters	enc_ssn
_1188.encounters	enc_guarantor_ssn
_1188.encounters	enc_ins1_insured_ssn
_1188.encounters	enc_ins2_insured_ssn
_1188.encounters	enc_ins3_insured_ssn
_1188.examples	exa_ssn
_1188.hl7_accessions	acc_ssn
_1188.insurances_repository	irep_ins_insured_ssn
_1188.non_patients	npat_ssn
_1188.orders	ord_ssn
_1188.patients	pat_ssn
_1188.patients	pat_guarantor_ssn
_1188.patients	pat_ins1_insured_ssn
_1188.patients	pat_ins2_insured_ssn
_1188.patients	pat_ins3_insured_ssn
_1188.patients_demographics_snapshots	pds_ssn
_1188.patients_demographics_snapshots	pds_guarantor_ssn
_1188.patients_demographics_snapshots	pds_ins1_insured_ssn
_1188.patients_demographics_snapshots	pds_ins2_insured_ssn
_1188.patients_demographics_snapshots	pds_ins3_insured_ssn
_1188.patients_responsibility_estimates	prest_ssn
_1188.precerts	pre_ssn
_1188.precerts	pre_guarantor_ssn
_1188.precerts	pre_ins1_insured_ssn
_1188.precerts	pre_ins2_insured_ssn
_1188.radiology_orders	rad_ssn
_1188.radiology_results	rad_res_ssn
_1218.charts	chrt_ssn
_1218.cpoe_responses	cpoe_res_ssn
_1218.encounters	enc_ssn
_1218.encounters	enc_guarantor_ssn
_1218.encounters	enc_ins1_insured_ssn
_1218.encounters	enc_ins2_insured_ssn
_1218.encounters	enc_ins3_insured_ssn
_1218.examples	exa_ssn
_1218.hl7_accessions	acc_ssn
_1218.insurances_repository	irep_ins_insured_ssn
_1218.non_patients	npat_ssn
_1218.orders	ord_ssn
_1218.patients	pat_ssn
_1218.patients	pat_guarantor_ssn
_1218.patients	pat_ins1_insured_ssn
_1218.patients	pat_ins2_insured_ssn
_1218.patients	pat_ins3_insured_ssn
_1218.patients_demographics_snapshots	pds_ssn
_1218.patients_demographics_snapshots	pds_guarantor_ssn
_1218.patients_demographics_snapshots	pds_ins1_insured_ssn
_1218.patients_demographics_snapshots	pds_ins2_insured_ssn
_1218.patients_demographics_snapshots	pds_ins3_insured_ssn
_1218.patients_responsibility_estimates	prest_ssn
_1218.precerts	pre_ssn
_1218.precerts	pre_guarantor_ssn
_1218.precerts	pre_ins1_insured_ssn
_1218.precerts	pre_ins2_insured_ssn
_1218.radiology_orders	rad_ssn
_1218.radiology_results	rad_res_ssn
_1548.charts	chrt_ssn
_1548.cpoe_responses	cpoe_res_ssn
_1548.encounters	enc_ssn
_1548.encounters	enc_guarantor_ssn
_1548.encounters	enc_ins1_insured_ssn
_1548.encounters	enc_ins2_insured_ssn
_1548.encounters	enc_ins3_insured_ssn
_1548.examples	exa_ssn
_1548.hl7_accessions	acc_ssn
_1548.insurances_repository	irep_ins_insured_ssn
_1548.non_patients	npat_ssn
_1548.orders	ord_ssn
_1548.patients	pat_ssn
_1548.patients	pat_guarantor_ssn
_1548.patients	pat_ins1_insured_ssn
_1548.patients	pat_ins2_insured_ssn
_1548.patients	pat_ins3_insured_ssn
_1548.patients_demographics_snapshots	pds_ssn
_1548.patients_demographics_snapshots	pds_guarantor_ssn
_1548.patients_demographics_snapshots	pds_ins1_insured_ssn
_1548.patients_demographics_snapshots	pds_ins2_insured_ssn
_1548.patients_demographics_snapshots	pds_ins3_insured_ssn
_1548.patients_responsibility_estimates	prest_ssn
_1548.precerts	pre_ssn
_1548.precerts	pre_guarantor_ssn
_1548.precerts	pre_ins1_insured_ssn
_1548.precerts	pre_ins2_insured_ssn
_1548.radiology_orders	rad_ssn
_1548.radiology_results	rad_res_ssn
_435.charts	chrt_ssn
_435.cpoe_responses	cpoe_res_ssn
_435.encounters	enc_ssn
_435.encounters	enc_guarantor_ssn
_435.encounters	enc_ins1_insured_ssn
_435.encounters	enc_ins2_insured_ssn
_435.encounters	enc_ins3_insured_ssn
_435.examples	exa_ssn
_435.hl7_accessions	acc_ssn
_435.insurances_repository	irep_ins_insured_ssn
_435.non_patients	npat_ssn
_435.orders	ord_ssn
_435.patients	pat_ssn
_435.patients	pat_guarantor_ssn
_435.patients	pat_ins1_insured_ssn
_435.patients	pat_ins2_insured_ssn
_435.patients	pat_ins3_insured_ssn
_435.patients_demographics_snapshots	pds_ssn
_435.patients_demographics_snapshots	pds_guarantor_ssn
_435.patients_demographics_snapshots	pds_ins1_insured_ssn
_435.patients_demographics_snapshots	pds_ins2_insured_ssn
_435.patients_demographics_snapshots	pds_ins3_insured_ssn
_435.patients_responsibility_estimates	prest_ssn
_435.precerts	pre_ssn
_435.precerts	pre_guarantor_ssn
_435.precerts	pre_ins1_insured_ssn
_435.precerts	pre_ins2_insured_ssn
_435.radiology_orders	rad_ssn
_435.radiology_results	rad_res_ssn
_436.charts	chrt_ssn
_436.cpoe_responses	cpoe_res_ssn
_436.encounters	enc_ssn
_436.encounters	enc_guarantor_ssn
_436.encounters	enc_ins1_insured_ssn
_436.encounters	enc_ins2_insured_ssn
_436.encounters	enc_ins3_insured_ssn
_436.examples	exa_ssn
_436.hl7_accessions	acc_ssn
_436.insurances_repository	irep_ins_insured_ssn
_436.non_patients	npat_ssn
_436.orders	ord_ssn
_436.patients	pat_ssn
_436.patients	pat_guarantor_ssn
_436.patients	pat_ins1_insured_ssn
_436.patients	pat_ins2_insured_ssn
_436.patients	pat_ins3_insured_ssn
_436.patients_demographics_snapshots	pds_ssn
_436.patients_demographics_snapshots	pds_guarantor_ssn
_436.patients_demographics_snapshots	pds_ins1_insured_ssn
_436.patients_demographics_snapshots	pds_ins2_insured_ssn
_436.patients_demographics_snapshots	pds_ins3_insured_ssn
_436.patients_responsibility_estimates	prest_ssn
_436.precerts	pre_ssn
_436.precerts	pre_guarantor_ssn
_436.precerts	pre_ins1_insured_ssn
_436.precerts	pre_ins2_insured_ssn
_436.radiology_orders	rad_ssn
_436.radiology_results	rad_res_ssn
_436_archive_testing.charts	chrt_ssn
_436_archive_testing.cpoe_responses	cpoe_res_ssn
_436_archive_testing.encounters	enc_ssn
_436_archive_testing.encounters	enc_guarantor_ssn
_436_archive_testing.encounters	enc_ins1_insured_ssn
_436_archive_testing.encounters	enc_ins2_insured_ssn
_436_archive_testing.encounters	enc_ins3_insured_ssn
_436_archive_testing.examples	exa_ssn
_436_archive_testing.hl7_accessions	acc_ssn
_436_archive_testing.insurances_repository	irep_ins_insured_ssn
_436_archive_testing.non_patients	npat_ssn
_436_archive_testing.orders	ord_ssn
_436_archive_testing.patients	pat_ssn
_436_archive_testing.patients	pat_guarantor_ssn
_436_archive_testing.patients	pat_ins1_insured_ssn
_436_archive_testing.patients	pat_ins2_insured_ssn
_436_archive_testing.patients	pat_ins3_insured_ssn
_436_archive_testing.patients_demographics_snapshots	pds_ssn
_436_archive_testing.patients_demographics_snapshots	pds_guarantor_ssn
_436_archive_testing.patients_demographics_snapshots	pds_ins1_insured_ssn
_436_archive_testing.patients_demographics_snapshots	pds_ins2_insured_ssn
_436_archive_testing.patients_demographics_snapshots	pds_ins3_insured_ssn
_436_archive_testing.patients_responsibility_estimates	prest_ssn
_436_archive_testing.precerts	pre_ssn
_436_archive_testing.precerts	pre_guarantor_ssn
_436_archive_testing.precerts	pre_ins1_insured_ssn
_436_archive_testing.precerts	pre_ins2_insured_ssn
_436_archive_testing.radiology_orders	rad_ssn
_436_archive_testing.radiology_results	rad_res_ssn
_437.charts	chrt_ssn
_437.cpoe_responses	cpoe_res_ssn
_437.encounters	enc_ssn
_437.encounters	enc_guarantor_ssn
_437.encounters	enc_ins1_insured_ssn
_437.encounters	enc_ins2_insured_ssn
_437.encounters	enc_ins3_insured_ssn
_437.examples	exa_ssn
_437.hl7_accessions	acc_ssn
_437.insurances_repository	irep_ins_insured_ssn
_437.non_patients	npat_ssn
_437.orders	ord_ssn
_437.patients	pat_ssn
_437.patients	pat_guarantor_ssn
_437.patients	pat_ins1_insured_ssn
_437.patients	pat_ins2_insured_ssn
_437.patients	pat_ins3_insured_ssn
_437.patients_demographics_snapshots	pds_ssn
_437.patients_demographics_snapshots	pds_guarantor_ssn
_437.patients_demographics_snapshots	pds_ins1_insured_ssn
_437.patients_demographics_snapshots	pds_ins2_insured_ssn
_437.patients_demographics_snapshots	pds_ins3_insured_ssn
_437.patients_responsibility_estimates	prest_ssn
_437.precerts	pre_ssn
_437.precerts	pre_guarantor_ssn
_437.precerts	pre_ins1_insured_ssn
_437.precerts	pre_ins2_insured_ssn
_437.radiology_orders	rad_ssn
_437.radiology_results	rad_res_ssn
_8.charts	chrt_ssn
_8.cpoe_responses	cpoe_res_ssn
_8.encounters	enc_ssn
_8.encounters	enc_guarantor_ssn
_8.encounters	enc_ins1_insured_ssn
_8.encounters	enc_ins2_insured_ssn
_8.encounters	enc_ins3_insured_ssn
_8.examples	exa_ssn
_8.hl7_accessions	acc_ssn
_8.insurances_repository	irep_ins_insured_ssn
_8.non_patients	npat_ssn
_8.orders	ord_ssn
_8.patients	pat_ssn
_8.patients	pat_guarantor_ssn
_8.patients	pat_ins1_insured_ssn
_8.patients	pat_ins2_insured_ssn
_8.patients	pat_ins3_insured_ssn
_8.patients_demographics_snapshots	pds_ssn
_8.patients_demographics_snapshots	pds_guarantor_ssn
_8.patients_demographics_snapshots	pds_ins1_insured_ssn
_8.patients_demographics_snapshots	pds_ins2_insured_ssn
_8.patients_demographics_snapshots	pds_ins3_insured_ssn
_8.patients_responsibility_estimates	prest_ssn
_8.precerts	pre_ssn
_8.precerts	pre_guarantor_ssn
_8.precerts	pre_ins1_insured_ssn
_8.precerts	pre_ins2_insured_ssn
_8.radiology_orders	rad_ssn
_8.radiology_results	rad_res_ssn
_81.charts	chrt_ssn
_81.cpoe_responses	cpoe_res_ssn
_81.encounters	enc_ssn
_81.encounters	enc_guarantor_ssn
_81.encounters	enc_ins1_insured_ssn
_81.encounters	enc_ins2_insured_ssn
_81.encounters	enc_ins3_insured_ssn
_81.examples	exa_ssn
_81.hl7_accessions	acc_ssn
_81.insurances_repository	irep_ins_insured_ssn
_81.non_patients	npat_ssn
_81.orders	ord_ssn
_81.patients	pat_ssn
_81.patients	pat_guarantor_ssn
_81.patients	pat_ins1_insured_ssn
_81.patients	pat_ins2_insured_ssn
_81.patients	pat_ins3_insured_ssn
_81.patients_demographics_snapshots	pds_ssn
_81.patients_demographics_snapshots	pds_guarantor_ssn
_81.patients_demographics_snapshots	pds_ins1_insured_ssn
_81.patients_demographics_snapshots	pds_ins2_insured_ssn
_81.patients_demographics_snapshots	pds_ins3_insured_ssn
_81.patients_responsibility_estimates	prest_ssn
_81.precerts	pre_ssn
_81.precerts	pre_guarantor_ssn
_81.precerts	pre_ins1_insured_ssn
_81.precerts	pre_ins2_insured_ssn
_81.radiology_orders	rad_ssn
_81.radiology_results	rad_res_ssn
_999.charts	chrt_ssn
_999.cpoe_responses	cpoe_res_ssn
_999.encounters	enc_ssn
_999.encounters	enc_guarantor_ssn
_999.encounters	enc_ins1_insured_ssn
_999.encounters	enc_ins2_insured_ssn
_999.encounters	enc_ins3_insured_ssn
_999.examples	exa_ssn
_999.hl7_accessions	acc_ssn
_999.insurances_repository	irep_ins_insured_ssn
_999.non_patients	npat_ssn
_999.orders	ord_ssn
_999.patients	pat_ssn
_999.patients	pat_guarantor_ssn
_999.patients	pat_ins1_insured_ssn
_999.patients	pat_ins2_insured_ssn
_999.patients	pat_ins3_insured_ssn
_999.patients_demographics_snapshots	pds_ssn
_999.patients_demographics_snapshots	pds_guarantor_ssn
_999.patients_demographics_snapshots	pds_ins1_insured_ssn
_999.patients_demographics_snapshots	pds_ins2_insured_ssn
_999.patients_demographics_snapshots	pds_ins3_insured_ssn
_999.patients_responsibility_estimates	prest_ssn
_999.precerts	pre_ssn
_999.precerts	pre_guarantor_ssn
_999.precerts	pre_ins1_insured_ssn
_999.precerts	pre_ins2_insured_ssn
_999.radiology_orders	rad_ssn
_999.radiology_results	rad_res_ssn
aurora_standard.abmmpi	gu_ssn
aurora_standard.abmvis	gu_ssn
aurora_standard.adupgu	guar_ssn
aurora_standard.aswguar	guar_ssn
aurora_standard.b2badd	p_ssn
aurora_standard.b2mrdr	p_ssn
aurora_standard.bdallvis	pat_ssn
aurora_standard.bdguar	guar_ssn
aurora_standard.bdmpi	p_ssn
aurora_standard.bdmpi	sp_ssn
aurora_standard.bdvis	pat_ssn
aurora_standard.bevis	p_ssn
aurora_standard.bevisbd	p_ssn
aurora_standard.bevisbd2	p_ssn
aurora_standard.bhar	p_ssn
aurora_standard.bhar	new_ssn
aurora_standard.bhar	g_ssn
aurora_standard.bhbadd	p_ssn
aurora_standard.bhguar	guar_ssn
aurora_standard.bhldgr	p_ssn
aurora_standard.bhldgr	guar_ssn
aurora_standard.bhmrdr	p_ssn
aurora_standard.bhppat	p_ssn
aurora_standard.bhtguar	guar_ssn
aurora_standard.bhtldgr	p_ssn
aurora_standard.bhtldgr	guar_ssn
aurora_standard.bhtmrdr	p_ssn
aurora_standard.bhtppat	p_ssn
aurora_standard.bmguar	guar_ssn
aurora_standard.bmmpi	p_ssn
aurora_standard.bmnkin	n_ssn
aurora_standard.bmpact	p_ssn
aurora_standard.bmpat	p_ssn
aurora_standard.bpar	p_ssn
aurora_standard.bpar	new_ssn
aurora_standard.bpar	g_ssn
aurora_standard.bpar2	p_ssn
aurora_standard.bpar2	new_ssn
aurora_standard.bpar2	g_ssn
aurora_standard.bpmpi	p_ssn
aurora_standard.bpmpi2	p_ssn
aurora_standard.bpmr	p_ssn
aurora_standard.bpmr2	p_ssn
aurora_standard.bsguar	guar_ssn
aurora_standard.bsinsur	spouse_ssn
aurora_standard.bsvis	pat_ssn
aurora_standard.bsvisbd	pat_ssn
aurora_standard.bvguar	gu_ssn
aurora_standard.bvmpi	p_ssn
aurora_standard.bvmpi2	p_ssn
aurora_standard.c7guarr	guar_ssn
aurora_standard.c7mpi	p_ssn
aurora_standard.c7mpi	gu_ssn
aurora_standard.c7vis	pat_ssn
aurora_standard.c8dtls	p_ssn
aurora_standard.c8guar	guar_ssn
aurora_standard.c8guar2	guar_ssn
aurora_standard.c9mpi	p_ssn
aurora_standard.c9vis	p_ssn
aurora_standard.cafc	pat_ssn
aurora_standard.caguarr	guar_ssn
aurora_standard.campi	spouse_ssn
aurora_standard.cavis	pat_ssn
aurora_standard.cavish	pat_ssn
aurora_standard.chhl7in2	ins_ssn
aurora_standard.chlmdssd	prev_ssn
aurora_standard.chltrnsd	prev_ssn
aurora_standard.chmarcnbf	g_ssn
aurora_standard.chmarcnbf	p_ssn
aurora_standard.chmarsi	pat_ssn
aurora_standard.chmarsi	gu_ssn
aurora_standard.chmarsi	sp_ssn
aurora_standard.chmazstd	pat_ssn
aurora_standard.chmazsti	pat_ssn
aurora_standard.chmazsto	pat_ssn
aurora_standard.chmcampi	pat_ssn
aurora_standard.chmcampi	gu_ssn
aurora_standard.chmcampi	sp_ssn
aurora_standard.chmcmhed	debtor_1_ssn
aurora_standard.chmcmhed	debtor_2_ssn
aurora_standard.chmcmhed	pat_ssn
aurora_standard.chmcssnd	new_ssn
aurora_standard.chmcssnd	old_ssn
aurora_standard.chmexmpi	pat_ssn
aurora_standard.chmexmpi	gu_ssn
aurora_standard.chmexmpi	sp_ssn
aurora_standard.chmexvis	pat_ssn
aurora_standard.chmguarr	guar_ssn
aurora_standard.chmhistp	p_ssn
aurora_standard.chmlastr	pat_ssn
aurora_standard.chmmhast	pat_ssn
aurora_standard.chmokipd	pat_ssn
aurora_standard.chmokopd	pat_ssn
aurora_standard.chmoperc	auto_ssn
aurora_standard.chmozpcd	debtor_1_ssn
aurora_standard.chmozpcd	debtor_2_ssn
aurora_standard.chmpatmr	spouse_ssn
aurora_standard.chmpatwc	mom_ssn
aurora_standard.chmpatwc	dad_ssn
aurora_standard.chmpdemo	p_ssn
aurora_standard.chmpdemo	sp_ssn
aurora_standard.chmpdemo	gu_ssn
aurora_standard.chmradex	pat_ssn
aurora_standard.chmradex	gu_ssn
aurora_standard.chmradex	sp_ssn
aurora_standard.chmtxstr	pat_ssn
aurora_standard.chpcobdd	dep_ssn
aurora_standard.chpdeped	depend_ssn
aurora_standard.chpempdd	person_ssn
aurora_standard.chxcntrc	id_is_ssn
aurora_standard.hl7gt1	guar_ssn
aurora_standard.hl7gt1ad	guar_ssn
aurora_standard.hl7in2	ins_ssn
aurora_standard.hl7in2ad	ins_ssn
aurora_standard.hl7pid	pat_ssn
aurora_standard.hl7pidad	pat_ssn
aurora_standard.kcvis	pat_ssn
aurora_standard.kcvisit	pat_ssn
aurora_standard.nbspouse	spouse_ssn
aurora_standard.ncexmpi	pat_ssn
aurora_standard.oddpaydd	empl_ssn
aurora_standard.oddpayid	empl_ssn
aurora_standard.oddpayod	empl_ssn
aurora_standard.oddpayre	empl_ssn
aurora_standard.odhpaydd	empl_ssn
aurora_standard.odhpayid	empl_ssn
aurora_standard.odhpayod	empl_ssn
aurora_standard.odhpayre	empl_ssn
aurora_standard.styoempd	depend_ssn
common.customers	cus_require_ssn

sex

Table	Column
HSPI_CURES2015_B1.patients	birth_sex
HSPI_Central_Hospital.patients	birth_sex
HSPI_Dewitt.patients	birth_sex
HSPI_Fulton.patients	birth_sex
HSPI_Inferno.patients	birth_sex
HSPI_MU2015_E1.patients	birth_sex
HSPI_MU2015_G2.patients	birth_sex
HSPI_MU2015_G9.patients	birth_sex
HSPI_Sandbox.patients	birth_sex
HSPI_Summit_General.patients	birth_sex
HSPI_United_Physicians.patients	birth_sex
MPI.patients	birth_sex
_1.charts	chrt_sex
_1.clinical_alerts	ca_pat_sex
_1.clinical_interventions	ci_pat_sex
_1.cpoe_responses	cpoe_res_sex
_1.encounters	enc_sex
_1.encounters	enc_ins1_insured_sex
_1.encounters	enc_ins2_insured_sex
_1.encounters	enc_ins3_insured_sex
_1.health_maintenance	hm_sex
_1.hl7_accessions	acc_sex
_1.insurances_repository	irep_ins_insured_sex
_1.non_patients	npat_sex
_1.orders	ord_sex
_1.patient_education	pe_sex
_1.patient_history_fields	phf_sex
_1.patients	pat_sex
_1.patients	pat_birth_sex
_1.patients	pat_ins1_insured_sex
_1.patients	pat_ins2_insured_sex
_1.patients	pat_ins3_insured_sex
_1.patients_demographics_snapshots	pds_sex
_1.patients_demographics_snapshots	pds_ins1_insured_sex
_1.patients_demographics_snapshots	pds_ins2_insured_sex
_1.patients_demographics_snapshots	pds_ins3_insured_sex
_1.patients_responsibility_estimates	prest_sex
_1.precerts	pre_sex
_1.precerts	pre_ins1_insured_sex
_1.precerts	pre_ins2_insured_sex
_1.radiology_orders	rad_sex
_1.radiology_results	rad_res_sex
_1188.charts	chrt_sex
_1188.clinical_alerts	ca_pat_sex
_1188.clinical_interventions	ci_pat_sex
_1188.cpoe_responses	cpoe_res_sex
_1188.encounters	enc_sex
_1188.encounters	enc_ins1_insured_sex
_1188.encounters	enc_ins2_insured_sex
_1188.encounters	enc_ins3_insured_sex
_1188.health_maintenance	hm_sex
_1188.hl7_accessions	acc_sex
_1188.insurances_repository	irep_ins_insured_sex
_1188.non_patients	npat_sex
_1188.orders	ord_sex
_1188.patient_education	pe_sex
_1188.patient_history_fields	phf_sex
_1188.patients	pat_sex
_1188.patients	pat_birth_sex
_1188.patients	pat_ins1_insured_sex
_1188.patients	pat_ins2_insured_sex
_1188.patients	pat_ins3_insured_sex
_1188.patients_demographics_snapshots	pds_sex
_1188.patients_demographics_snapshots	pds_ins1_insured_sex
_1188.patients_demographics_snapshots	pds_ins2_insured_sex
_1188.patients_demographics_snapshots	pds_ins3_insured_sex
_1188.patients_responsibility_estimates	prest_sex
_1188.precerts	pre_sex
_1188.precerts	pre_ins1_insured_sex
_1188.precerts	pre_ins2_insured_sex
_1188.radiology_orders	rad_sex
_1188.radiology_results	rad_res_sex
_1218.charts	chrt_sex
_1218.clinical_alerts	ca_pat_sex
_1218.clinical_interventions	ci_pat_sex
_1218.cpoe_responses	cpoe_res_sex
_1218.encounters	enc_sex
_1218.encounters	enc_ins1_insured_sex
_1218.encounters	enc_ins2_insured_sex
_1218.encounters	enc_ins3_insured_sex
_1218.health_maintenance	hm_sex
_1218.hl7_accessions	acc_sex
_1218.insurances_repository	irep_ins_insured_sex
_1218.non_patients	npat_sex
_1218.orders	ord_sex
_1218.patient_education	pe_sex
_1218.patient_history_fields	phf_sex
_1218.patients	pat_sex
_1218.patients	pat_birth_sex
_1218.patients	pat_ins1_insured_sex
_1218.patients	pat_ins2_insured_sex
_1218.patients	pat_ins3_insured_sex
_1218.patients_demographics_snapshots	pds_sex
_1218.patients_demographics_snapshots	pds_ins1_insured_sex
_1218.patients_demographics_snapshots	pds_ins2_insured_sex
_1218.patients_demographics_snapshots	pds_ins3_insured_sex
_1218.patients_responsibility_estimates	prest_sex
_1218.precerts	pre_sex
_1218.precerts	pre_ins1_insured_sex
_1218.precerts	pre_ins2_insured_sex
_1218.radiology_orders	rad_sex
_1218.radiology_results	rad_res_sex
_1548.charts	chrt_sex
_1548.clinical_alerts	ca_pat_sex
_1548.clinical_interventions	ci_pat_sex
_1548.cpoe_responses	cpoe_res_sex
_1548.encounters	enc_sex
_1548.encounters	enc_ins1_insured_sex
_1548.encounters	enc_ins2_insured_sex
_1548.encounters	enc_ins3_insured_sex
_1548.health_maintenance	hm_sex
_1548.hl7_accessions	acc_sex
_1548.insurances_repository	irep_ins_insured_sex
_1548.non_patients	npat_sex
_1548.orders	ord_sex
_1548.patient_education	pe_sex
_1548.patient_history_fields	phf_sex
_1548.patients	pat_sex
_1548.patients	pat_birth_sex
_1548.patients	pat_ins1_insured_sex
_1548.patients	pat_ins2_insured_sex
_1548.patients	pat_ins3_insured_sex
_1548.patients_demographics_snapshots	pds_sex
_1548.patients_demographics_snapshots	pds_ins1_insured_sex
_1548.patients_demographics_snapshots	pds_ins2_insured_sex
_1548.patients_demographics_snapshots	pds_ins3_insured_sex
_1548.patients_responsibility_estimates	prest_sex
_1548.precerts	pre_sex
_1548.precerts	pre_ins1_insured_sex
_1548.precerts	pre_ins2_insured_sex
_1548.radiology_orders	rad_sex
_1548.radiology_results	rad_res_sex
_435.charts	chrt_sex
_435.clinical_alerts	ca_pat_sex
_435.clinical_interventions	ci_pat_sex
_435.cpoe_responses	cpoe_res_sex
_435.encounters	enc_sex
_435.encounters	enc_ins1_insured_sex
_435.encounters	enc_ins2_insured_sex
_435.encounters	enc_ins3_insured_sex
_435.health_maintenance	hm_sex
_435.hl7_accessions	acc_sex
_435.insurances_repository	irep_ins_insured_sex
_435.non_patients	npat_sex
_435.orders	ord_sex
_435.patient_education	pe_sex
_435.patient_history_fields	phf_sex
_435.patients	pat_sex
_435.patients	pat_birth_sex
_435.patients	pat_ins1_insured_sex
_435.patients	pat_ins2_insured_sex
_435.patients	pat_ins3_insured_sex
_435.patients_demographics_snapshots	pds_sex
_435.patients_demographics_snapshots	pds_ins1_insured_sex
_435.patients_demographics_snapshots	pds_ins2_insured_sex
_435.patients_demographics_snapshots	pds_ins3_insured_sex
_435.patients_responsibility_estimates	prest_sex
_435.precerts	pre_sex
_435.precerts	pre_ins1_insured_sex
_435.precerts	pre_ins2_insured_sex
_435.radiology_orders	rad_sex
_435.radiology_results	rad_res_sex
_436.charts	chrt_sex
_436.clinical_alerts	ca_pat_sex
_436.clinical_interventions	ci_pat_sex
_436.cpoe_responses	cpoe_res_sex
_436.encounters	enc_sex
_436.encounters	enc_ins1_insured_sex
_436.encounters	enc_ins2_insured_sex
_436.encounters	enc_ins3_insured_sex
_436.health_maintenance	hm_sex
_436.hl7_accessions	acc_sex
_436.insurances_repository	irep_ins_insured_sex
_436.non_patients	npat_sex
_436.orders	ord_sex
_436.patient_education	pe_sex
_436.patient_history_fields	phf_sex
_436.patients	pat_sex
_436.patients	pat_birth_sex
_436.patients	pat_ins1_insured_sex
_436.patients	pat_ins2_insured_sex
_436.patients	pat_ins3_insured_sex
_436.patients_demographics_snapshots	pds_sex
_436.patients_demographics_snapshots	pds_ins1_insured_sex
_436.patients_demographics_snapshots	pds_ins2_insured_sex
_436.patients_demographics_snapshots	pds_ins3_insured_sex
_436.patients_responsibility_estimates	prest_sex
_436.precerts	pre_sex
_436.precerts	pre_ins1_insured_sex
_436.precerts	pre_ins2_insured_sex
_436.radiology_orders	rad_sex
_436.radiology_results	rad_res_sex
_436_archive_testing.charts	chrt_sex
_436_archive_testing.clinical_alerts	ca_pat_sex
_436_archive_testing.clinical_interventions	ci_pat_sex
_436_archive_testing.cpoe_responses	cpoe_res_sex
_436_archive_testing.encounters	enc_sex
_436_archive_testing.encounters	enc_ins1_insured_sex
_436_archive_testing.encounters	enc_ins2_insured_sex
_436_archive_testing.encounters	enc_ins3_insured_sex
_436_archive_testing.health_maintenance	hm_sex
_436_archive_testing.hl7_accessions	acc_sex
_436_archive_testing.insurances_repository	irep_ins_insured_sex
_436_archive_testing.non_patients	npat_sex
_436_archive_testing.orders	ord_sex
_436_archive_testing.patient_education	pe_sex
_436_archive_testing.patient_history_fields	phf_sex
_436_archive_testing.patients	pat_sex
_436_archive_testing.patients	pat_ins1_insured_sex
_436_archive_testing.patients	pat_ins2_insured_sex
_436_archive_testing.patients	pat_ins3_insured_sex
_436_archive_testing.patients_demographics_snapshots	pds_sex
_436_archive_testing.patients_demographics_snapshots	pds_ins1_insured_sex
_436_archive_testing.patients_demographics_snapshots	pds_ins2_insured_sex
_436_archive_testing.patients_demographics_snapshots	pds_ins3_insured_sex
_436_archive_testing.patients_responsibility_estimates	prest_sex
_436_archive_testing.precerts	pre_sex
_436_archive_testing.precerts	pre_ins1_insured_sex
_436_archive_testing.precerts	pre_ins2_insured_sex
_436_archive_testing.radiology_orders	rad_sex
_436_archive_testing.radiology_results	rad_res_sex
_437.charts	chrt_sex
_437.clinical_alerts	ca_pat_sex
_437.clinical_interventions	ci_pat_sex
_437.cpoe_responses	cpoe_res_sex
_437.encounters	enc_sex
_437.encounters	enc_ins1_insured_sex
_437.encounters	enc_ins2_insured_sex
_437.encounters	enc_ins3_insured_sex
_437.health_maintenance	hm_sex
_437.hl7_accessions	acc_sex
_437.insurances_repository	irep_ins_insured_sex
_437.non_patients	npat_sex
_437.orders	ord_sex
_437.patient_education	pe_sex
_437.patient_history_fields	phf_sex
_437.patients	pat_sex
_437.patients	pat_birth_sex
_437.patients	pat_ins1_insured_sex
_437.patients	pat_ins2_insured_sex
_437.patients	pat_ins3_insured_sex
_437.patients_demographics_snapshots	pds_sex
_437.patients_demographics_snapshots	pds_ins1_insured_sex
_437.patients_demographics_snapshots	pds_ins2_insured_sex
_437.patients_demographics_snapshots	pds_ins3_insured_sex
_437.patients_responsibility_estimates	prest_sex
_437.precerts	pre_sex
_437.precerts	pre_ins1_insured_sex
_437.precerts	pre_ins2_insured_sex
_437.radiology_orders	rad_sex
_437.radiology_results	rad_res_sex
_8.charts	chrt_sex
_8.clinical_alerts	ca_pat_sex
_8.clinical_interventions	ci_pat_sex
_8.cpoe_responses	cpoe_res_sex
_8.encounters	enc_sex
_8.encounters	enc_ins1_insured_sex
_8.encounters	enc_ins2_insured_sex
_8.encounters	enc_ins3_insured_sex
_8.health_maintenance	hm_sex
_8.hl7_accessions	acc_sex
_8.insurances_repository	irep_ins_insured_sex
_8.non_patients	npat_sex
_8.orders	ord_sex
_8.patient_education	pe_sex
_8.patient_history_fields	phf_sex
_8.patients	pat_sex
_8.patients	pat_birth_sex
_8.patients	pat_ins1_insured_sex
_8.patients	pat_ins2_insured_sex
_8.patients	pat_ins3_insured_sex
_8.patients_demographics_snapshots	pds_sex
_8.patients_demographics_snapshots	pds_ins1_insured_sex
_8.patients_demographics_snapshots	pds_ins2_insured_sex
_8.patients_demographics_snapshots	pds_ins3_insured_sex
_8.patients_responsibility_estimates	prest_sex
_8.precerts	pre_sex
_8.precerts	pre_ins1_insured_sex
_8.precerts	pre_ins2_insured_sex
_8.radiology_orders	rad_sex
_8.radiology_results	rad_res_sex
_81.charts	chrt_sex
_81.clinical_alerts	ca_pat_sex
_81.clinical_interventions	ci_pat_sex
_81.cpoe_responses	cpoe_res_sex
_81.encounters	enc_sex
_81.encounters	enc_ins1_insured_sex
_81.encounters	enc_ins2_insured_sex
_81.encounters	enc_ins3_insured_sex
_81.health_maintenance	hm_sex
_81.hl7_accessions	acc_sex
_81.insurances_repository	irep_ins_insured_sex
_81.non_patients	npat_sex
_81.orders	ord_sex
_81.patient_education	pe_sex
_81.patient_history_fields	phf_sex
_81.patients	pat_sex
_81.patients	pat_birth_sex
_81.patients	pat_ins1_insured_sex
_81.patients	pat_ins2_insured_sex
_81.patients	pat_ins3_insured_sex
_81.patients_demographics_snapshots	pds_sex
_81.patients_demographics_snapshots	pds_ins1_insured_sex
_81.patients_demographics_snapshots	pds_ins2_insured_sex
_81.patients_demographics_snapshots	pds_ins3_insured_sex
_81.patients_responsibility_estimates	prest_sex
_81.precerts	pre_sex
_81.precerts	pre_ins1_insured_sex
_81.precerts	pre_ins2_insured_sex
_81.radiology_orders	rad_sex
_81.radiology_results	rad_res_sex
_999.charts	chrt_sex
_999.clinical_alerts	ca_pat_sex
_999.clinical_interventions	ci_pat_sex
_999.cpoe_responses	cpoe_res_sex
_999.encounters	enc_sex
_999.encounters	enc_ins1_insured_sex
_999.encounters	enc_ins2_insured_sex
_999.encounters	enc_ins3_insured_sex
_999.health_maintenance	hm_sex
_999.hl7_accessions	acc_sex
_999.insurances_repository	irep_ins_insured_sex
_999.non_patients	npat_sex
_999.orders	ord_sex
_999.patient_education	pe_sex
_999.patient_history_fields	phf_sex
_999.patients	pat_sex
_999.patients	pat_birth_sex
_999.patients	pat_ins1_insured_sex
_999.patients	pat_ins2_insured_sex
_999.patients	pat_ins3_insured_sex
_999.patients_demographics_snapshots	pds_sex
_999.patients_demographics_snapshots	pds_ins1_insured_sex
_999.patients_demographics_snapshots	pds_ins2_insured_sex
_999.patients_demographics_snapshots	pds_ins3_insured_sex
_999.patients_responsibility_estimates	prest_sex
_999.precerts	pre_sex
_999.precerts	pre_ins1_insured_sex
_999.precerts	pre_ins2_insured_sex
_999.radiology_orders	rad_sex
_999.radiology_results	rad_res_sex
aurora_standard.abmmpi	i1_sex
aurora_standard.abmmpi	i2_sex
aurora_standard.abmmpi	i3_sex
aurora_standard.abmmpi	gu_sex
aurora_standard.abmvis	gu_sex
aurora_standard.abmvis	i1_sex
aurora_standard.abmvis	i2_sex
aurora_standard.abmvis	i3_sex
aurora_standard.bevis	pat_sex
aurora_standard.bevisbd	pat_sex
aurora_standard.bevisbd2	pat_sex
aurora_standard.bhar	p_sex
aurora_standard.bhar	g_sex
aurora_standard.bpar	p_sex
aurora_standard.bpar	g_sex
aurora_standard.bpar2	p_sex
aurora_standard.bpar2	g_sex
aurora_standard.bpmpi	p_sex
aurora_standard.bpmpi2	p_sex
aurora_standard.bpmr	p_sex
aurora_standard.bpmr2	p_sex
aurora_standard.c7mpi	p_sex
aurora_standard.c7mpi	gu_sex
aurora_standard.c8dtls	p_sex
aurora_standard.c9mpi	p_sex
aurora_standard.chhl7in1	ins_sex
aurora_standard.chmarbex	pat_sex
aurora_standard.chmarsi	pat_sex
aurora_standard.chmarsi	ins1_sex
aurora_standard.chmarsi	ins2_sex
aurora_standard.chmarsi	ins3_sex
aurora_standard.chmazstd	pat_sex
aurora_standard.chmazsti	pat_sex
aurora_standard.chmazsto	pat_sex
aurora_standard.chmbatex	pat_sex
aurora_standard.chmcampi	pat_sex
aurora_standard.chmcampi	ins1_sex
aurora_standard.chmcampi	ins2_sex
aurora_standard.chmcampi	ins3_sex
aurora_standard.chmcmhed	pat_sex
aurora_standard.chmexmpi	pat_sex
aurora_standard.chmexmpi	ins1_sex
aurora_standard.chmexmpi	ins2_sex
aurora_standard.chmexmpi	ins3_sex
aurora_standard.chmexvis	ins1_sex
aurora_standard.chmexvis	ins2_sex
aurora_standard.chmexvis	ins3_sex
aurora_standard.chmhcaph	pat_sex
aurora_standard.chmhcaps	pat_sex
aurora_standard.chmhistp	p_sex
aurora_standard.chmhstmr	pat_sex
aurora_standard.chmhstrm	pat_sex
aurora_standard.chmlastr	pat_sex
aurora_standard.chmmhast	pat_sex
aurora_standard.chmmrhdr	upd_sex
aurora_standard.chmnrcex	pat_sex
aurora_standard.chmokipd	pat_sex
aurora_standard.chmokopd	pat_sex
aurora_standard.chmpdemo	p_sex
aurora_standard.chmpdemo	ins1_sex
aurora_standard.chmpdemo	ins2_sex
aurora_standard.chmpdemo	ins3_sex
aurora_standard.chmradex	pat_sex
aurora_standard.chmradex	ins1_sex
aurora_standard.chmradex	ins2_sex
aurora_standard.chmradex	ins3_sex
aurora_standard.chmtxstr	pat_sex
aurora_standard.hl7gt1	guar_sex
aurora_standard.hl7gt1ad	guar_sex
aurora_standard.hl7in1	ins_sex
aurora_standard.hl7in1ad	ins_sex

error_message

Table	Column
_1.immunization_reported	imrp_error_message
_1188.immunization_reported	imrp_error_message
_1218.immunization_reported	imrp_error_message
_1548.immunization_reported	imrp_error_message
_435.immunization_reported	imrp_error_message
_436.immunization_reported	imrp_error_message
_436_archive_testing.immunization_reported	imrp_error_message
_437.immunization_reported	imrp_error_message
_8.immunization_reported	imrp_error_message
_81.immunization_reported	imrp_error_message
_999.immunization_reported	imrp_error_message
common.data_import_errors	die_error_message

visit_no

Table	Column
aurora_standard.anotesd	an_visit_no
aurora_standard.bdfiled	bd_visit_no
aurora_standard.chmarsi	pat_visit_no
aurora_standard.chmcampi	pat_visit_no
aurora_standard.chmcombr	to_visit_no
aurora_standard.chmexmpi	pat_visit_no
aurora_standard.chmokipd	pat_visit_no
aurora_standard.chmokopd	pat_visit_no
aurora_standard.chmraded	pat_visit_no
aurora_standard.chmradex	pat_visit_no
aurora_standard.chrcombr	to_visit_no
aurora_standard.ncexmpi	pat_visit_no

processed

Table	Column
aurora_standard.api_cbos_invoice_log	dt_api_processed
aurora_standard.api_cbos_je_log	dt_api_processed
aurora_standard.api_cbos_refund_log	dt_api_processed
aurora_standard.api_cbos_vendor_log	dt_api_processed
common.data_import_clients_meta_data	dicmd_csv_line_last_processed

mr_no

Table	Column
aurora_standard.bsinsur	snf_mr_no
aurora_standard.bsinsur	prev_mr_no
aurora_standard.chhcntrc	auto_snf_mr_no
aurora_standard.chhcntrc	auto_mr_no
aurora_standard.chmarbex	pat_mr_no
aurora_standard.chmarsi	pat_mr_no
aurora_standard.chmbatex	pat_mr_no
aurora_standard.chmcampi	pat_mr_no
aurora_standard.chmcntrc	auto_snf_mr_no
aurora_standard.chmcntrc	auto_mr_no
aurora_standard.chmexmpi	pat_mr_no
aurora_standard.chmhstmr	pat_mr_no
aurora_standard.chmhstrm	pat_mr_no
aurora_standard.chmlastr	mother_mr_no
aurora_standard.chmmhast	co_mr_no
aurora_standard.chmmrhdr	upd_mr_no
aurora_standard.chmnrcex	pat_mr_no
aurora_standard.chmokipd	pat_mr_no
aurora_standard.chmokopd	pat_mr_no
aurora_standard.chmpatmr	snf_mr_no
aurora_standard.chmpatmr	prev_mr_no
aurora_standard.chmraded	pat_mr_no
aurora_standard.chmradex	pat_mr_no
aurora_standard.chmreqsr	ofc_mr_no
aurora_standard.ncexmpi	pat_mr_no

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

mid_name

Table	Column
aurora_standard.c7insur2	p_mid_name
aurora_standard.c7insur3	p_mid_name
aurora_standard.chmstmtd	g_mid_name

fin_class

Table	Column
aurora_standard.chmarsi	cur_fin_class
aurora_standard.chmcampi	cur_fin_class
aurora_standard.chmerafc	new_fin_class
aurora_standard.chmexmpi	cur_fin_class
aurora_standard.hl7gt1	guar_fin_class

dischg_reason

Table	Column
aurora_standard.chmchpsd	chg_dischg_reason

pat_status

Table	Column
aurora_standard.chmgltcd	a_pat_status
aurora_standard.chmgltcd	b_pat_status
aurora_standard.chmprica	prev_pat_status
aurora_standard.chmprica	cur_pat_status

fac_no

Table	Column
aurora_standard.chmprica	prev_fac_no
aurora_standard.chmprica	cur_fac_no
aurora_standard.chpcashr	cash_fac_no
aurora_standard.chpcobpd	cash_fac_no
aurora_standard.chpcobpd	bal_fac_no
aurora_standard.chscustd	dept_fac_no
aurora_standard.chshotlr	dept_fac_no
aurora_standard.chtemplr	dflt_fac_no
aurora_standard.curs_temp	cash_fac_no
aurora_standard.curs_temp	ap_fac_no
aurora_standard.stgrowpd	rod_beg_fac_no
aurora_standard.stgrowpd	rod_end_fac_no
aurora_standard.stpcashd	dist_fac_no
aurora_standard.stpcashd	disc_fac_no
aurora_standard.stpcashe	cash_fac_no
aurora_standard.stpcntrc	cash_fac_no
aurora_standard.stpcntrc	disc_fac_no
aurora_standard.stpinvce	cash_fac_no
aurora_standard.stpopend	ap_fac_no
aurora_standard.stpopend	cash_fac_no
aurora_standard.stucntrc	cash_fac_no
aurora_standard.stuinvce	cash_fac_no
aurora_standard.stxfinsd	fin_fac_no
aurora_standard.styaccrr	liab_fac_no
aurora_standard.styaccrr	expense_fac_no
aurora_standard.styemplr	cash_fac_no
aurora_standard.stypayfd	cash_fac_no
aurora_standard.stypayod	bal_fac_no
aurora_standard.stypayre	cash_fac_no
aurora_standard.styrevsd	cash_fac_no
aurora_standard.stytyper	cash_fac_no

updated_at

Table	Column
aurora_standard.printouts	original_updated_at

interest

Table	Column
aurora_standard.strnoted	percent_interest
aurora_standard.stxratid	expense_interest

birth_date

Table	Column
aurora_standard.tmpmrrpt	edit_birth_date