aurora_standard.bsinsur

Field	Type	Null	Key	Extra
status	varchar(1)	YES	MUL
ssn	varchar(11)	YES	UNI
mr_no	varchar(20)	YES	UNI
last_name	varchar(20)	YES	MUL
first_name	varchar(20)	YES	MUL
mid_name	varchar(20)	YES
maiden_name	varchar(20)	YES
nick_name	varchar(20)	YES	MUL
birth_date	date	YES	MUL
sex	varchar(1)	YES
credit_info	varchar(30)	YES
fam_phy_no	smallint(6)	YES	MUL
interest	varchar(1)	YES
guar_no	int(11)	YES	MUL
spouse_name	varchar(20)	YES
spouse_add1	varchar(20)	YES
spouse_add2	varchar(20)	YES
spouse_city	varchar(20)	YES
spouse_state	varchar(2)	YES
spouse_zip_1	decimal(5,0)	YES
spouse_zip_2	decimal(4,0)	YES
spouse_phone	varchar(20)	YES
spouse_ssn	varchar(11)	YES	MUL
spouse_birthday	date	YES
spouse_birthplace	varchar(20)	YES
spouse_emp_no	int(11)	YES
nextkin_name	varchar(20)	YES
nextkin_rel	varchar(2)	YES
nextkin_add1	varchar(20)	YES
nextkin_add2	varchar(20)	YES
nextkin_city	varchar(20)	YES
nextkin_state	varchar(2)	YES
nextkin_zip_1	decimal(5,0)	YES
nextkin_zip_2	decimal(4,0)	YES
nextkin_phone	varchar(20)	YES
patient_add1	varchar(30)	YES
patient_add2	varchar(20)	YES
patient_county	varchar(20)	YES
patient_city	varchar(20)	YES
patient_state	varchar(2)	YES
patient_zip_1	decimal(5,0)	YES	MUL
patient_zip_2	decimal(4,0)	YES
patient_birthpl	varchar(30)	YES
patient_phone	varchar(20)	YES
patient_occup	varchar(20)	YES
patient_emp_no	int(11)	YES	MUL
retire_date	date	YES
retire_code	varchar(2)	YES
marital_status	varchar(1)	YES
blood_type	varchar(5)	YES
race_code	varchar(1)	YES
religion_code	varchar(2)	YES
allergy_info	varchar(76)	YES
drug_info	varchar(76)	YES
other_info_1	varchar(76)	YES
other_info_2	varchar(76)	YES
other_info_3	varchar(20)	YES
other_info_4	varchar(20)	YES
other_info_5	varchar(20)	YES
other_info_6	varchar(20)	YES	MUL
emerg_contact_1	varchar(20)	YES
emerg_con_phone_1	varchar(20)	YES
emerg_con_addr_1	varchar(30)	YES
emerg_contact_2	varchar(20)	YES
emerg_con_phone_2	varchar(20)	YES
emerg_con_addr_2	varchar(30)	YES
emerg_contact_3	varchar(20)	YES
emerg_con_phone_3	varchar(20)	YES
emerg_con_addr_3	varchar(30)	YES
emerg_contact_4	varchar(20)	YES
emerg_con_phone_4	varchar(20)	YES
emerg_con_addr_4	varchar(30)	YES
living_will	varchar(1)	YES
organ_donor	varchar(1)	YES
input_by	int(11)	YES
pre_adm_date	date	YES
prev_name	varchar(20)	YES
emerg_con_rel_1	varchar(2)	YES
emerg_con_rel_2	varchar(2)	YES
emerg_con_rel_3	varchar(2)	YES
emerg_con_rel_4	varchar(2)	YES
snf_mr_no	varchar(10)	YES
created_by	int(11)	YES
death_date	date	YES
nextkin_emp	int(11)	YES
pat_emp_phone	varchar(20)	YES
height	varchar(2)	YES
weight	varchar(3)	YES
smoker	varchar(1)	YES
diet	varchar(2)	YES
pat_e_mail	varchar(55)	YES
vip_code	varchar(3)	YES	MUL
py_emp_no	varchar(6)	YES
soundex	varchar(4)	YES	MUL
soundex_nm	varchar(20)	YES
pat_cell_phone	varchar(20)	YES
sp_cell_phone	varchar(20)	YES
nk_cell_phone	varchar(20)	YES
prev_mr_no	varchar(20)	YES	MUL
emr_no	bigint(20) unsigned	NO	PRI	auto_increment
spouse_first	varchar(20)	YES
spouse_mid	varchar(20)	YES
church	varchar(20)	YES
prim_language	varchar(10)	YES
english_lang	varchar(1)	YES
country_code	varchar(3)	YES
inf_disease	varchar(6)	YES
comm_needs	varchar(6)	YES
phys_needs	varchar(6)	YES
weight_kg	decimal(4,1)	YES
date_created	date	YES

References

Local Column

References

status

Table	Column
API.request_logs_v2	http_status
HSPI_Bastrop.appointments	appointment_status
HSPI_Bastrop.communications	communication_status
HSPI_Bastrop.encounters	encounter_status
HSPI_Bastrop.encounters	encounter_billing_status
HSPI_Bastrop.laboratory_orders	laboratory_order_status
HSPI_Bastrop.medication_requests	medication_request_status
HSPI_Bastrop.observations	observation_status
HSPI_Bastrop.problems	clinical_status
HSPI_Bastrop.problems	verification_status
HSPI_Bastrop.procedures	procedure_status
HSPI_CURES2015_B1.allergies	verification_status
HSPI_CURES2015_B1.appointments	appointment_status
HSPI_CURES2015_B1.communications	communication_status
HSPI_CURES2015_B1.encounters	encounter_status
HSPI_CURES2015_B1.encounters	encounter_billing_status
HSPI_CURES2015_B1.laboratory_orders	laboratory_order_status
HSPI_CURES2015_B1.medication_requests	medication_request_status
HSPI_CURES2015_B1.observations	observation_status
HSPI_CURES2015_B1.problems	clinical_status
HSPI_CURES2015_B1.problems	verification_status
HSPI_CURES2015_B1.procedures	procedure_status
HSPI_Central_Hospital.allergies	verification_status
HSPI_Central_Hospital.appointments	appointment_status
HSPI_Central_Hospital.communications	communication_status
HSPI_Central_Hospital.encounters	encounter_status
HSPI_Central_Hospital.encounters	encounter_billing_status
HSPI_Central_Hospital.laboratory_orders	laboratory_order_status
HSPI_Central_Hospital.medication_requests	medication_request_status
HSPI_Central_Hospital.observations	observation_status
HSPI_Central_Hospital.problems	clinical_status
HSPI_Central_Hospital.problems	verification_status
HSPI_Central_Hospital.procedures	procedure_status
HSPI_Dewitt.allergies	verification_status
HSPI_Dewitt.appointments	appointment_status
HSPI_Dewitt.communications	communication_status
HSPI_Dewitt.encounters	encounter_status
HSPI_Dewitt.encounters	encounter_billing_status
HSPI_Dewitt.laboratory_orders	laboratory_order_status
HSPI_Dewitt.medication_requests	medication_request_status
HSPI_Dewitt.observations	observation_status
HSPI_Dewitt.problems	clinical_status
HSPI_Dewitt.problems	verification_status
HSPI_Dewitt.procedures	procedure_status
HSPI_Fulton.allergies	verification_status
HSPI_Fulton.appointments	appointment_status
HSPI_Fulton.communications	communication_status
HSPI_Fulton.encounters	encounter_status
HSPI_Fulton.encounters	encounter_billing_status
HSPI_Fulton.laboratory_orders	laboratory_order_status
HSPI_Fulton.medication_requests	medication_request_status
HSPI_Fulton.observations	observation_status
HSPI_Fulton.problems	clinical_status
HSPI_Fulton.problems	verification_status
HSPI_Fulton.procedures	procedure_status
HSPI_Inferno.allergies	verification_status
HSPI_Inferno.appointments	appointment_status
HSPI_Inferno.communications	communication_status
HSPI_Inferno.encounters	encounter_status
HSPI_Inferno.encounters	encounter_billing_status
HSPI_Inferno.laboratory_orders	laboratory_order_status
HSPI_Inferno.medication_requests	medication_request_status
HSPI_Inferno.observations	observation_status
HSPI_Inferno.problems	clinical_status
HSPI_Inferno.problems	verification_status
HSPI_Inferno.procedures	procedure_status
HSPI_MU2015_E1.allergies	verification_status
HSPI_MU2015_E1.appointments	appointment_status
HSPI_MU2015_E1.communications	communication_status
HSPI_MU2015_E1.encounters	encounter_status
HSPI_MU2015_E1.encounters	encounter_billing_status
HSPI_MU2015_E1.laboratory_orders	laboratory_order_status
HSPI_MU2015_E1.medication_requests	medication_request_status
HSPI_MU2015_E1.observations	observation_status
HSPI_MU2015_E1.problems	clinical_status
HSPI_MU2015_E1.problems	verification_status
HSPI_MU2015_E1.procedures	procedure_status
HSPI_MU2015_G2.allergies	verification_status
HSPI_MU2015_G2.appointments	appointment_status
HSPI_MU2015_G2.communications	communication_status
HSPI_MU2015_G2.encounters	encounter_status
HSPI_MU2015_G2.encounters	encounter_billing_status
HSPI_MU2015_G2.laboratory_orders	laboratory_order_status
HSPI_MU2015_G2.medication_requests	medication_request_status
HSPI_MU2015_G2.observations	observation_status
HSPI_MU2015_G2.problems	clinical_status
HSPI_MU2015_G2.problems	verification_status
HSPI_MU2015_G2.procedures	procedure_status
HSPI_MU2015_G9.allergies	verification_status
HSPI_MU2015_G9.appointments	appointment_status
HSPI_MU2015_G9.communications	communication_status
HSPI_MU2015_G9.encounters	encounter_status
HSPI_MU2015_G9.encounters	encounter_billing_status
HSPI_MU2015_G9.laboratory_orders	laboratory_order_status
HSPI_MU2015_G9.medication_requests	medication_request_status
HSPI_MU2015_G9.observations	observation_status
HSPI_MU2015_G9.problems	clinical_status
HSPI_MU2015_G9.problems	verification_status
HSPI_MU2015_G9.procedures	procedure_status
HSPI_Ness.appointments	appointment_status
HSPI_Ness.encounters	encounter_status
HSPI_Ness.laboratory_orders	laboratory_order_status
HSPI_Ness.observations	observation_status
HSPI_Sandbox.allergies	verification_status
HSPI_Sandbox.appointments	appointment_status
HSPI_Sandbox.communications	communication_status
HSPI_Sandbox.encounters	encounter_status
HSPI_Sandbox.encounters	encounter_billing_status
HSPI_Sandbox.laboratory_orders	laboratory_order_status
HSPI_Sandbox.medication_requests	medication_request_status
HSPI_Sandbox.observations	observation_status
HSPI_Sandbox.problems	clinical_status
HSPI_Sandbox.problems	verification_status
HSPI_Sandbox.procedures	procedure_status
HSPI_Summit_General.allergies	verification_status
HSPI_Summit_General.appointments	appointment_status
HSPI_Summit_General.communications	communication_status
HSPI_Summit_General.encounters	encounter_status
HSPI_Summit_General.encounters	encounter_billing_status
HSPI_Summit_General.laboratory_orders	laboratory_order_status
HSPI_Summit_General.medication_requests	medication_request_status
HSPI_Summit_General.observations	observation_status
HSPI_Summit_General.problems	clinical_status
HSPI_Summit_General.problems	verification_status
HSPI_Summit_General.procedures	procedure_status
HSPI_System.web_hook_request_logs	http_status
HSPI_System.web_hook_triggers	http_status
HSPI_United_Physicians.allergies	verification_status
HSPI_United_Physicians.appointments	appointment_status
HSPI_United_Physicians.communications	communication_status
HSPI_United_Physicians.encounters	encounter_status
HSPI_United_Physicians.encounters	encounter_billing_status
HSPI_United_Physicians.laboratory_orders	laboratory_order_status
HSPI_United_Physicians.medication_requests	medication_request_status
HSPI_United_Physicians.observations	observation_status
HSPI_United_Physicians.problems	clinical_status
HSPI_United_Physicians.problems	verification_status
HSPI_United_Physicians.procedures	procedure_status
Loinc.loinc_codes	lc_status
MPI.allergies	verification_status
MPI.appointments	appointment_status
MPI.communications	communication_status
MPI.encounters	encounter_status
MPI.encounters	encounter_billing_status
MPI.laboratory_orders	laboratory_order_status
MPI.medication_requests	medication_request_status
MPI.observations	observation_status
MPI.problems	clinical_status
MPI.problems	verification_status
MPI.procedures	procedure_status
_1.appointment_reminders_configurations	arcon_status
_1.appointments_requests	aptreq_status
_1.billing_reports_queue	brq_status
_1.charts	chrt_status
_1.charts_care_plan	ccp_referral_status
_1.charts_icd9_codes	cic_status
_1.cpoe_responses	cpoe_res_status
_1.encounters	enc_maritial_status
_1.encounters	enc_employer_status
_1.encounters	enc_ins1_tpl_status
_1.encounters	enc_ins2_tpl_status
_1.encounters_claims_files	ecf_status
_1.encounters_payments	epay_status
_1.encounters_payments_edi_logs	epel_status
_1.encounters_soap	esp_pss_status
_1.encounters_ub04	enc_ub04_17_status
_1.erx_notifications	erx_nots_status
_1.hl7_accessions	acc_status
_1.hl7_orders	ord_status
_1.hl7_results	res_status
_1.immunization_reported	imrp_status
_1.insurances	ins_status
_1.orders	ord_status
_1.orders_templates	ordt_status
_1.patients	pat_maritial_status
_1.patients	pat_employer_status
_1.patients_allergies	palg_status
_1.patients_demographics_snapshots	pds_maritial_status
_1.patients_demographics_snapshots	pds_employer_status
_1.patients_document_assembly	pda_status
_1.patients_handouts	phs_status
_1.patients_handouts	phs_review_status
_1.patients_icd9_problems	pip_status
_1.patients_icd9_problems	pip_cog_status
_1.patients_icd9_problems	pip_func_status
_1.patients_referrals	pref_referral_status
_1.patients_reminders	pr_status
_1.patients_responsibility_estimates	prest_status
_1.patients_smoking_status	pss_status
_1.patients_statements	pst_status
_1.precerts	pre_maritial_status
_1.precerts	pre_employer_status
_1.problems_lists	pl_status
_1.radiology_orders	rad_status
_1.radiology_results	rad_res_status
_1.radiology_results_test_codes_results	rrtcres_status
_1.tasks	task_status
_1188.appointment_reminders_configurations	arcon_status
_1188.appointments_requests	aptreq_status
_1188.billing_reports_queue	brq_status
_1188.charts	chrt_status
_1188.charts_care_plan	ccp_referral_status
_1188.charts_icd9_codes	cic_status
_1188.cpoe_responses	cpoe_res_status
_1188.encounters	enc_maritial_status
_1188.encounters	enc_employer_status
_1188.encounters	enc_ins1_tpl_status
_1188.encounters	enc_ins2_tpl_status
_1188.encounters_claims_files	ecf_status
_1188.encounters_payments	epay_status
_1188.encounters_payments_edi_logs	epel_status
_1188.encounters_soap	esp_pss_status
_1188.encounters_ub04	enc_ub04_17_status
_1188.erx_notifications	erx_nots_status
_1188.hl7_accessions	acc_status
_1188.hl7_orders	ord_status
_1188.hl7_results	res_status
_1188.immunization_reported	imrp_status
_1188.insurances	ins_status
_1188.orders	ord_status
_1188.orders_templates	ordt_status
_1188.patients	pat_maritial_status
_1188.patients	pat_employer_status
_1188.patients_allergies	palg_status
_1188.patients_demographics_snapshots	pds_maritial_status
_1188.patients_demographics_snapshots	pds_employer_status
_1188.patients_document_assembly	pda_status
_1188.patients_handouts	phs_status
_1188.patients_handouts	phs_review_status
_1188.patients_icd9_problems	pip_status
_1188.patients_icd9_problems	pip_cog_status
_1188.patients_icd9_problems	pip_func_status
_1188.patients_referrals	pref_referral_status
_1188.patients_reminders	pr_status
_1188.patients_responsibility_estimates	prest_status
_1188.patients_smoking_status	pss_status
_1188.patients_statements	pst_status
_1188.precerts	pre_maritial_status
_1188.precerts	pre_employer_status
_1188.problems_lists	pl_status
_1188.radiology_orders	rad_status
_1188.radiology_results	rad_res_status
_1188.radiology_results_test_codes_results	rrtcres_status
_1188.tasks	task_status
_1218.appointment_reminders_configurations	arcon_status
_1218.appointments_requests	aptreq_status
_1218.billing_reports_queue	brq_status
_1218.charts	chrt_status
_1218.charts_care_plan	ccp_referral_status
_1218.charts_icd9_codes	cic_status
_1218.cpoe_responses	cpoe_res_status
_1218.encounters	enc_maritial_status
_1218.encounters	enc_employer_status
_1218.encounters	enc_ins1_tpl_status
_1218.encounters	enc_ins2_tpl_status
_1218.encounters_claims_files	ecf_status
_1218.encounters_payments	epay_status
_1218.encounters_payments_edi_logs	epel_status
_1218.encounters_soap	esp_pss_status
_1218.encounters_ub04	enc_ub04_17_status
_1218.erx_notifications	erx_nots_status
_1218.hl7_accessions	acc_status
_1218.hl7_orders	ord_status
_1218.hl7_results	res_status
_1218.immunization_reported	imrp_status
_1218.insurances	ins_status
_1218.orders	ord_status
_1218.orders_templates	ordt_status
_1218.patients	pat_maritial_status
_1218.patients	pat_employer_status
_1218.patients_allergies	palg_status
_1218.patients_demographics_snapshots	pds_maritial_status
_1218.patients_demographics_snapshots	pds_employer_status
_1218.patients_document_assembly	pda_status
_1218.patients_handouts	phs_status
_1218.patients_handouts	phs_review_status
_1218.patients_icd9_problems	pip_status
_1218.patients_icd9_problems	pip_cog_status
_1218.patients_icd9_problems	pip_func_status
_1218.patients_referrals	pref_referral_status
_1218.patients_reminders	pr_status
_1218.patients_responsibility_estimates	prest_status
_1218.patients_smoking_status	pss_status
_1218.patients_statements	pst_status
_1218.precerts	pre_maritial_status
_1218.precerts	pre_employer_status
_1218.problems_lists	pl_status
_1218.radiology_orders	rad_status
_1218.radiology_results	rad_res_status
_1218.radiology_results_test_codes_results	rrtcres_status
_1218.tasks	task_status
_1548.appointment_reminders_configurations	arcon_status
_1548.appointments_requests	aptreq_status
_1548.billing_reports_queue	brq_status
_1548.charts	chrt_status
_1548.charts_care_plan	ccp_referral_status
_1548.charts_icd9_codes	cic_status
_1548.cpoe_responses	cpoe_res_status
_1548.encounters	enc_maritial_status
_1548.encounters	enc_employer_status
_1548.encounters	enc_ins1_tpl_status
_1548.encounters	enc_ins2_tpl_status
_1548.encounters_claims_files	ecf_status
_1548.encounters_payments	epay_status
_1548.encounters_payments_edi_logs	epel_status
_1548.encounters_soap	esp_pss_status
_1548.encounters_ub04	enc_ub04_17_status
_1548.erx_notifications	erx_nots_status
_1548.hl7_accessions	acc_status
_1548.hl7_orders	ord_status
_1548.hl7_results	res_status
_1548.immunization_reported	imrp_status
_1548.insurances	ins_status
_1548.orders	ord_status
_1548.orders_templates	ordt_status
_1548.patients	pat_maritial_status
_1548.patients	pat_employer_status
_1548.patients_allergies	palg_status
_1548.patients_demographics_snapshots	pds_maritial_status
_1548.patients_demographics_snapshots	pds_employer_status
_1548.patients_document_assembly	pda_status
_1548.patients_handouts	phs_status
_1548.patients_handouts	phs_review_status
_1548.patients_icd9_problems	pip_status
_1548.patients_icd9_problems	pip_cog_status
_1548.patients_icd9_problems	pip_func_status
_1548.patients_referrals	pref_referral_status
_1548.patients_reminders	pr_status
_1548.patients_responsibility_estimates	prest_status
_1548.patients_smoking_status	pss_status
_1548.patients_statements	pst_status
_1548.precerts	pre_maritial_status
_1548.precerts	pre_employer_status
_1548.problems_lists	pl_status
_1548.radiology_orders	rad_status
_1548.radiology_results	rad_res_status
_1548.radiology_results_test_codes_results	rrtcres_status
_1548.tasks	task_status
_435.appointment_reminders_configurations	arcon_status
_435.appointments_requests	aptreq_status
_435.billing_reports_queue	brq_status
_435.charts	chrt_status
_435.charts_care_plan	ccp_referral_status
_435.charts_icd9_codes	cic_status
_435.cpoe_responses	cpoe_res_status
_435.encounters	enc_maritial_status
_435.encounters	enc_employer_status
_435.encounters	enc_ins1_tpl_status
_435.encounters	enc_ins2_tpl_status
_435.encounters_claims_files	ecf_status
_435.encounters_payments	epay_status
_435.encounters_payments_edi_logs	epel_status
_435.encounters_soap	esp_pss_status
_435.encounters_ub04	enc_ub04_17_status
_435.erx_notifications	erx_nots_status
_435.hl7_accessions	acc_status
_435.hl7_orders	ord_status
_435.hl7_results	res_status
_435.immunization_reported	imrp_status
_435.insurances	ins_status
_435.orders	ord_status
_435.orders_templates	ordt_status
_435.patients	pat_maritial_status
_435.patients	pat_employer_status
_435.patients_allergies	palg_status
_435.patients_demographics_snapshots	pds_maritial_status
_435.patients_demographics_snapshots	pds_employer_status
_435.patients_document_assembly	pda_status
_435.patients_handouts	phs_status
_435.patients_handouts	phs_review_status
_435.patients_icd9_problems	pip_status
_435.patients_icd9_problems	pip_cog_status
_435.patients_icd9_problems	pip_func_status
_435.patients_referrals	pref_referral_status
_435.patients_reminders	pr_status
_435.patients_responsibility_estimates	prest_status
_435.patients_smoking_status	pss_status
_435.patients_statements	pst_status
_435.precerts	pre_maritial_status
_435.precerts	pre_employer_status
_435.problems_lists	pl_status
_435.radiology_orders	rad_status
_435.radiology_results	rad_res_status
_435.radiology_results_test_codes_results	rrtcres_status
_435.tasks	task_status
_436.appointment_reminders_configurations	arcon_status
_436.appointments_requests	aptreq_status
_436.billing_reports_queue	brq_status
_436.charts	chrt_status
_436.charts_care_plan	ccp_referral_status
_436.charts_icd9_codes	cic_status
_436.cpoe_responses	cpoe_res_status
_436.encounters	enc_maritial_status
_436.encounters	enc_employer_status
_436.encounters	enc_ins1_tpl_status
_436.encounters	enc_ins2_tpl_status
_436.encounters_claims_files	ecf_status
_436.encounters_payments	epay_status
_436.encounters_payments_edi_logs	epel_status
_436.encounters_soap	esp_pss_status
_436.encounters_ub04	enc_ub04_17_status
_436.erx_notifications	erx_nots_status
_436.hl7_accessions	acc_status
_436.hl7_orders	ord_status
_436.hl7_results	res_status
_436.immunization_reported	imrp_status
_436.insurances	ins_status
_436.orders	ord_status
_436.orders_templates	ordt_status
_436.patients	pat_maritial_status
_436.patients	pat_employer_status
_436.patients_allergies	palg_status
_436.patients_demographics_snapshots	pds_maritial_status
_436.patients_demographics_snapshots	pds_employer_status
_436.patients_document_assembly	pda_status
_436.patients_handouts	phs_status
_436.patients_handouts	phs_review_status
_436.patients_icd9_problems	pip_status
_436.patients_icd9_problems	pip_cog_status
_436.patients_icd9_problems	pip_func_status
_436.patients_referrals	pref_referral_status
_436.patients_reminders	pr_status
_436.patients_responsibility_estimates	prest_status
_436.patients_smoking_status	pss_status
_436.patients_statements	pst_status
_436.precerts	pre_maritial_status
_436.precerts	pre_employer_status
_436.problems_lists	pl_status
_436.radiology_orders	rad_status
_436.radiology_results	rad_res_status
_436.radiology_results_test_codes_results	rrtcres_status
_436.tasks	task_status
_436_archive_testing.appointment_reminders_configurations	arcon_status
_436_archive_testing.appointments_requests	aptreq_status
_436_archive_testing.billing_reports_queue	brq_status
_436_archive_testing.charts	chrt_status
_436_archive_testing.charts_care_plan	ccp_referral_status
_436_archive_testing.charts_icd9_codes	cic_status
_436_archive_testing.cpoe_responses	cpoe_res_status
_436_archive_testing.encounters	enc_maritial_status
_436_archive_testing.encounters	enc_employer_status
_436_archive_testing.encounters	enc_ins1_tpl_status
_436_archive_testing.encounters	enc_ins2_tpl_status
_436_archive_testing.encounters_claims_files	ecf_status
_436_archive_testing.encounters_payments	epay_status
_436_archive_testing.encounters_payments_edi_logs	epel_status
_436_archive_testing.encounters_soap	esp_pss_status
_436_archive_testing.encounters_ub04	enc_ub04_17_status
_436_archive_testing.erx_notifications	erx_nots_status
_436_archive_testing.hl7_accessions	acc_status
_436_archive_testing.hl7_orders	ord_status
_436_archive_testing.hl7_results	res_status
_436_archive_testing.immunization_reported	imrp_status
_436_archive_testing.insurances	ins_status
_436_archive_testing.orders	ord_status
_436_archive_testing.orders_templates	ordt_status
_436_archive_testing.patients	pat_maritial_status
_436_archive_testing.patients	pat_employer_status
_436_archive_testing.patients_allergies	palg_status
_436_archive_testing.patients_demographics_snapshots	pds_maritial_status
_436_archive_testing.patients_demographics_snapshots	pds_employer_status
_436_archive_testing.patients_document_assembly	pda_status
_436_archive_testing.patients_handouts	phs_status
_436_archive_testing.patients_handouts	phs_review_status
_436_archive_testing.patients_icd9_problems	pip_status
_436_archive_testing.patients_icd9_problems	pip_cog_status
_436_archive_testing.patients_icd9_problems	pip_func_status
_436_archive_testing.patients_referrals	pref_referral_status
_436_archive_testing.patients_reminders	pr_status
_436_archive_testing.patients_responsibility_estimates	prest_status
_436_archive_testing.patients_smoking_status	pss_status
_436_archive_testing.patients_statements	pst_status
_436_archive_testing.precerts	pre_maritial_status
_436_archive_testing.precerts	pre_employer_status
_436_archive_testing.problems_lists	pl_status
_436_archive_testing.radiology_orders	rad_status
_436_archive_testing.radiology_results	rad_res_status
_436_archive_testing.radiology_results_test_codes_results	rrtcres_status
_436_archive_testing.tasks	task_status
_437.appointment_reminders_configurations	arcon_status
_437.appointments_requests	aptreq_status
_437.billing_reports_queue	brq_status
_437.charts	chrt_status
_437.charts_care_plan	ccp_referral_status
_437.charts_icd9_codes	cic_status
_437.cpoe_responses	cpoe_res_status
_437.encounters	enc_maritial_status
_437.encounters	enc_employer_status
_437.encounters	enc_ins1_tpl_status
_437.encounters	enc_ins2_tpl_status
_437.encounters_claims_files	ecf_status
_437.encounters_payments	epay_status
_437.encounters_payments_edi_logs	epel_status
_437.encounters_soap	esp_pss_status
_437.encounters_ub04	enc_ub04_17_status
_437.erx_notifications	erx_nots_status
_437.hl7_accessions	acc_status
_437.hl7_orders	ord_status
_437.hl7_results	res_status
_437.immunization_reported	imrp_status
_437.insurances	ins_status
_437.orders	ord_status
_437.orders_templates	ordt_status
_437.patients	pat_maritial_status
_437.patients	pat_employer_status
_437.patients_allergies	palg_status
_437.patients_demographics_snapshots	pds_maritial_status
_437.patients_demographics_snapshots	pds_employer_status
_437.patients_document_assembly	pda_status
_437.patients_handouts	phs_status
_437.patients_handouts	phs_review_status
_437.patients_icd9_problems	pip_status
_437.patients_icd9_problems	pip_cog_status
_437.patients_icd9_problems	pip_func_status
_437.patients_referrals	pref_referral_status
_437.patients_reminders	pr_status
_437.patients_responsibility_estimates	prest_status
_437.patients_smoking_status	pss_status
_437.patients_statements	pst_status
_437.precerts	pre_maritial_status
_437.precerts	pre_employer_status
_437.problems_lists	pl_status
_437.radiology_orders	rad_status
_437.radiology_results	rad_res_status
_437.radiology_results_test_codes_results	rrtcres_status
_437.tasks	task_status
_8.appointment_reminders_configurations	arcon_status
_8.appointments_requests	aptreq_status
_8.billing_reports_queue	brq_status
_8.charts	chrt_status
_8.charts_care_plan	ccp_referral_status
_8.charts_icd9_codes	cic_status
_8.cpoe_responses	cpoe_res_status
_8.encounters	enc_maritial_status
_8.encounters	enc_employer_status
_8.encounters	enc_ins1_tpl_status
_8.encounters	enc_ins2_tpl_status
_8.encounters_claims_files	ecf_status
_8.encounters_payments	epay_status
_8.encounters_payments_edi_logs	epel_status
_8.encounters_soap	esp_pss_status
_8.encounters_ub04	enc_ub04_17_status
_8.erx_notifications	erx_nots_status
_8.hl7_accessions	acc_status
_8.hl7_orders	ord_status
_8.hl7_results	res_status
_8.immunization_reported	imrp_status
_8.insurances	ins_status
_8.orders	ord_status
_8.orders_templates	ordt_status
_8.patients	pat_maritial_status
_8.patients	pat_employer_status
_8.patients_allergies	palg_status
_8.patients_demographics_snapshots	pds_maritial_status
_8.patients_demographics_snapshots	pds_employer_status
_8.patients_document_assembly	pda_status
_8.patients_handouts	phs_status
_8.patients_handouts	phs_review_status
_8.patients_icd9_problems	pip_status
_8.patients_icd9_problems	pip_cog_status
_8.patients_icd9_problems	pip_func_status
_8.patients_referrals	pref_referral_status
_8.patients_reminders	pr_status
_8.patients_responsibility_estimates	prest_status
_8.patients_smoking_status	pss_status
_8.patients_statements	pst_status
_8.precerts	pre_maritial_status
_8.precerts	pre_employer_status
_8.problems_lists	pl_status
_8.radiology_orders	rad_status
_8.radiology_results	rad_res_status
_8.radiology_results_test_codes_results	rrtcres_status
_8.tasks	task_status
_81.appointment_reminders_configurations	arcon_status
_81.appointments_requests	aptreq_status
_81.billing_reports_queue	brq_status
_81.charts	chrt_status
_81.charts_care_plan	ccp_referral_status
_81.charts_icd9_codes	cic_status
_81.cpoe_responses	cpoe_res_status
_81.encounters	enc_maritial_status
_81.encounters	enc_employer_status
_81.encounters	enc_ins1_tpl_status
_81.encounters	enc_ins2_tpl_status
_81.encounters_claims_files	ecf_status
_81.encounters_payments	epay_status
_81.encounters_payments_edi_logs	epel_status
_81.encounters_soap	esp_pss_status
_81.encounters_ub04	enc_ub04_17_status
_81.erx_notifications	erx_nots_status
_81.hl7_accessions	acc_status
_81.hl7_orders	ord_status
_81.hl7_results	res_status
_81.immunization_reported	imrp_status
_81.insurances	ins_status
_81.orders	ord_status
_81.orders_templates	ordt_status
_81.patients	pat_maritial_status
_81.patients	pat_employer_status
_81.patients_allergies	palg_status
_81.patients_demographics_snapshots	pds_maritial_status
_81.patients_demographics_snapshots	pds_employer_status
_81.patients_document_assembly	pda_status
_81.patients_handouts	phs_status
_81.patients_handouts	phs_review_status
_81.patients_icd9_problems	pip_status
_81.patients_icd9_problems	pip_cog_status
_81.patients_icd9_problems	pip_func_status
_81.patients_referrals	pref_referral_status
_81.patients_reminders	pr_status
_81.patients_responsibility_estimates	prest_status
_81.patients_smoking_status	pss_status
_81.patients_statements	pst_status
_81.precerts	pre_maritial_status
_81.precerts	pre_employer_status
_81.problems_lists	pl_status
_81.radiology_orders	rad_status
_81.radiology_results	rad_res_status
_81.radiology_results_test_codes_results	rrtcres_status
_81.tasks	task_status
_999.appointment_reminders_configurations	arcon_status
_999.appointments_requests	aptreq_status
_999.billing_reports_queue	brq_status
_999.charts	chrt_status
_999.charts_care_plan	ccp_referral_status
_999.charts_icd9_codes	cic_status
_999.cpoe_responses	cpoe_res_status
_999.encounters	enc_maritial_status
_999.encounters	enc_employer_status
_999.encounters	enc_ins1_tpl_status
_999.encounters	enc_ins2_tpl_status
_999.encounters_claims_files	ecf_status
_999.encounters_payments	epay_status
_999.encounters_payments_edi_logs	epel_status
_999.encounters_soap	esp_pss_status
_999.encounters_ub04	enc_ub04_17_status
_999.erx_notifications	erx_nots_status
_999.hl7_accessions	acc_status
_999.hl7_orders	ord_status
_999.hl7_results	res_status
_999.immunization_reported	imrp_status
_999.insurances	ins_status
_999.orders	ord_status
_999.orders_templates	ordt_status
_999.patients	pat_maritial_status
_999.patients	pat_employer_status
_999.patients_allergies	palg_status
_999.patients_demographics_snapshots	pds_maritial_status
_999.patients_demographics_snapshots	pds_employer_status
_999.patients_document_assembly	pda_status
_999.patients_handouts	phs_status
_999.patients_handouts	phs_review_status
_999.patients_icd9_problems	pip_status
_999.patients_icd9_problems	pip_cog_status
_999.patients_icd9_problems	pip_func_status
_999.patients_referrals	pref_referral_status
_999.patients_reminders	pr_status
_999.patients_responsibility_estimates	prest_status
_999.patients_smoking_status	pss_status
_999.patients_statements	pst_status
_999.precerts	pre_maritial_status
_999.precerts	pre_employer_status
_999.problems_lists	pl_status
_999.radiology_orders	rad_status
_999.radiology_results	rad_res_status
_999.radiology_results_test_codes_results	rrtcres_status
_999.tasks	task_status
ahiWiki.uploadstash	us_status
aurora_standard.abmmpi	emp_status
aurora_standard.abmvis	billing_status
aurora_standard.acampi	work_status
aurora_standard.activity_logs	exit_status
aurora_standard.adjpay	pat_status
aurora_standard.adshmd	pat_status
aurora_standard.adshpmt	pat_status
aurora_standard.adshpmt	claim_status
aurora_standard.adshrev	pat_status
aurora_standard.ainsrvw	pat_status
aurora_standard.amcbd	pat_status
aurora_standard.apsar	adm_status
aurora_standard.apsar0	adm_status
aurora_standard.apsarbd	adm_status
aurora_standard.apsarhist	adm_status
aurora_standard.audpadjd	pat_status
aurora_standard.audpadjd	bill_status
aurora_standard.audpchgd	pat_status
aurora_standard.audpchgd	bill_status
aurora_standard.audppayd	pat_status
aurora_standard.audppayd	bill_status
aurora_standard.audroomd	pat_status
aurora_standard.avtots	pat_status
aurora_standard.b2mrdr	p_status
aurora_standard.bhguar	emp_status
aurora_standard.bhmrdr	p_status
aurora_standard.bhtguar	emp_status
aurora_standard.bhtmrdr	p_status
aurora_standard.c7abs	abs_status
aurora_standard.cadrg	abs_status
aurora_standard.campi	marital_status
aurora_standard.catots	pat_status
aurora_standard.cgrreptr	rpt_status
aurora_standard.cgsclipr	clip_status
aurora_standard.cgxsselr	sel_status
aurora_standard.chhl7adt	pat_status
aurora_standard.chm1500d	bill_status
aurora_standard.chm1500r	bill_status
aurora_standard.chm15chd	bill_status
aurora_standard.chm835pd	claim_status
aurora_standard.chmabstr	abs_status
aurora_standard.chmabstr	release_status
aurora_standard.chmabstr	marital_status
aurora_standard.chmachgd	pat_status
aurora_standard.chmachgd	bill_status
aurora_standard.chmadmdd	pat_status
aurora_standard.chmadmtr	pat_status
aurora_standard.chmadmtr	bill_status
aurora_standard.chmadmwc	legal_status
aurora_standard.chmagesd	pat_status
aurora_standard.chmapcbr	apc_status
aurora_standard.chmapcgr	bill_status
aurora_standard.chmapcir	apc_status
aurora_standard.chmarbex	pat_status
aurora_standard.chmarbex	dis_status
aurora_standard.chmarchr	pat_status
aurora_standard.chmarsi	pat_status
aurora_standard.chmarsi	dis_status
aurora_standard.chmarstip	pat_status
aurora_standard.chmarstp	pat_status
aurora_standard.chmazstd	dis_status
aurora_standard.chmazsti	dis_status
aurora_standard.chmazsto	dis_status
aurora_standard.chmbadjd	pat_status
aurora_standard.chmbadjd	bill_status
aurora_standard.chmbadjr	batch_status
aurora_standard.chmbatex	dis_status
aurora_standard.chmbchgd	pat_status
aurora_standard.chmbchgd	bill_status
aurora_standard.chmbchgr	batch_status
aurora_standard.chmbillc	pat_status
aurora_standard.chmbille	action_status
aurora_standard.chmbitmd	pat_status
aurora_standard.chmbitmd	bill_status
aurora_standard.chmbitmr	batch_status
aurora_standard.chmblogd	bill_status
aurora_standard.chmblogr	batch_status
aurora_standard.chmbpayd	pat_status
aurora_standard.chmbpayd	bill_status
aurora_standard.chmbpayr	batch_status
aurora_standard.chmbremd	bill_status
aurora_standard.chmbremr	batch_status
aurora_standard.chmcampi	pat_status
aurora_standard.chmcampi	dis_status
aurora_standard.chmclaim	dis_status
aurora_standard.chmcompd	pat_status
aurora_standard.chmcox06	pat_status
aurora_standard.chmcptcd	bill_status
aurora_standard.chmdietd	cur_status
aurora_standard.chmedilr	fa_status
aurora_standard.chmexmpi	pat_status
aurora_standard.chmexmpi	dis_status
aurora_standard.chmexvis	pat_status
aurora_standard.chmexvis	dis_status
aurora_standard.chmgltcd	a_pat_status
aurora_standard.chmgltcd	b_pat_status
aurora_standard.chmhcahp	dis_status
aurora_standard.chmhcaph	pat_status
aurora_standard.chmhcaph	dis_status
aurora_standard.chmhcaps	pat_status
aurora_standard.chmhcaps	dis_status
aurora_standard.chmhidic	marital_status
aurora_standard.chmhipad	hipaa_status
aurora_standard.chmhistd	pat_status
aurora_standard.chmhstmr	dis_status
aurora_standard.chmhstrm	dis_status
aurora_standard.chmlastr	dis_status
aurora_standard.chmmashr	pt_status
aurora_standard.chmmbc55	medicare_status
aurora_standard.chmmhast	dis_status
aurora_standard.chmmhast	homeless_status
aurora_standard.chmmhbcr	medicare_status
aurora_standard.chmmichr	medicare_status
aurora_standard.chmmichr	discharge_status
aurora_standard.chmnbcgr	batch_status
aurora_standard.chmnbpyr	batch_status
aurora_standard.chmnrcex	dis_status
aurora_standard.chmnvstb	dis_status
aurora_standard.chmnvstr	dis_status
aurora_standard.chmokipd	dischg_status
aurora_standard.chmokopd	dischg_status
aurora_standard.chmpadjd	pat_status
aurora_standard.chmpadjd	bill_status
aurora_standard.chmpadmr	adm_status
aurora_standard.chmpatir	curr_status
aurora_standard.chmpatmr	marital_status
aurora_standard.chmpchgd	pat_status
aurora_standard.chmpchgd	bill_status
aurora_standard.chmpdemo	pat_status
aurora_standard.chmpdemo	dis_status
aurora_standard.chmphyne	pat_status
aurora_standard.chmplogd	bill_status
aurora_standard.chmpnotr	alert_status
aurora_standard.chmppayd	pat_status
aurora_standard.chmppayd	bill_status
aurora_standard.chmpread	bill_status
aurora_standard.chmpread	pa_status
aurora_standard.chmprebc	pat_status
aurora_standard.chmpress	pat_status
aurora_standard.chmprica	prev_pat_status
aurora_standard.chmprica	cur_pat_status
aurora_standard.chmpricx	pat_status
aurora_standard.chmradex	pat_status
aurora_standard.chmradex	dis_status
aurora_standard.chmrchgd	pat_status
aurora_standard.chmrchgd	bill_status
aurora_standard.chmrefnd	pat_status
aurora_standard.chmreqdf	pat_status
aurora_standard.chmroomd	pat_status
aurora_standard.chmtbtrr	batch_status
aurora_standard.chmtkl1d	pat_status
aurora_standard.chmtkl2d	pat_status
aurora_standard.chmtkl3d	pat_status
aurora_standard.chmtkl4d	pat_status
aurora_standard.chmtkl5d	pat_status
aurora_standard.chmtkl6d	pat_status
aurora_standard.chmtkl7d	pat_status
aurora_standard.chmtkl8d	pat_status
aurora_standard.chmtkl9d	pat_status
aurora_standard.chmtxstr	dis_status
aurora_standard.chmutah7	dischg_status
aurora_standard.chmutaha	dischg_status
aurora_standard.chmvisiv	pat_status
aurora_standard.chmvtotd	pat_status
aurora_standard.choordmd	order_status
aurora_standard.chpcempr	empl_status
aurora_standard.chpempir	policy_status
aurora_standard.chppersr	empl_status
aurora_standard.chpposcd	pos_status
aurora_standard.chpposdd	pos_status
aurora_standard.chrhhmpr	pt_status
aurora_standard.chrordrr	pt_status
aurora_standard.chtemplr	current_status
aurora_standard.chtstatd	empl_status
aurora_standard.chxexamd	pat_status
aurora_standard.chxexamr	pat_status
aurora_standard.chxleasd	pat_status
aurora_standard.chyrespr	pat_status
aurora_standard.cofybal	pat_status
aurora_standard.hhmadmtr	pat_status
aurora_standard.hhmadmtr	bill_status
aurora_standard.hl7in2	job_status
aurora_standard.hl7orc	order_status
aurora_standard.logdetld	pat_status
aurora_standard.ncexmpi	pat_status
aurora_standard.oebatchaud	pat_status
aurora_standard.oebatchaud	bill_status
aurora_standard.oeorder	order_status
aurora_standard.schapptmastr	appt_status
aurora_standard.schappttempr	appt_status
aurora_standard.stfactvd	act_status
aurora_standard.stfactvv	act_status
aurora_standard.stoordre	order_status
aurora_standard.stppytor	tax_status
aurora_standard.stuordre	po_status
aurora_standard.sturqste	request_status
aurora_standard.styemplr	empl_status
aurora_standard.stypacad	py_empl_status
aurora_standard.stypacad	per_empl_status
aurora_standard.stytyper	empl_status
aurora_standard.tmp04d	pat_status
common.clients_zuora_physicians_config	czp_employ_status
common.data_import_clients_meta_data	dicmd_status
common.dev_requests	dev_status
common.leads	lea_status
common.loinc_codes	lc_status
common.service_tickets	stc_status
common.sfaxes	sfax_status
common.support_threads	spt_status
common.vaccines	vac_status
common.vaccines_manufacturers	mvx_status
rcmroi.dev__ip_geocodes	master_status
rcmroi.dev__rcm_roi_results	master_status
rcmroi.dev__sf_tokens	master_status
rcmroi.dev__sf_users	master_status
rcmroi.dev__sobj_Account	master_status
rcmroi.dev__sobj_Contact	master_status
rcmroi.dev__sobj_Lead	master_status
rcmroi.dev__sobj_RCM_Analysis__c	master_status
rcmroi.dev__specialties	master_status
rcmroi.dev__zip_codes	master_status
rcmroi.prod__ip_geocodes	master_status
rcmroi.prod__rcm_roi_results	master_status
rcmroi.prod__sf_tokens	master_status
rcmroi.prod__sf_users	master_status
rcmroi.prod__sobj_Account	master_status
rcmroi.prod__sobj_Contact	master_status
rcmroi.prod__sobj_Lead	master_status
rcmroi.prod__sobj_RCM_Analysis__c	master_status
rcmroi.prod__specialties	master_status
rcmroi.prod__zip_codes	master_status
rcmroi.test__ip_geocodes	master_status
rcmroi.test__rcm_roi_results	master_status
rcmroi.test__sf_tokens	master_status
rcmroi.test__sf_users	master_status
rcmroi.test__sobj_Account	master_status
rcmroi.test__sobj_Contact	master_status
rcmroi.test__sobj_Lead	master_status
rcmroi.test__sobj_RCM_Analysis__c	master_status
rcmroi.test__specialties	master_status
rcmroi.test__zip_codes	master_status
template_library.encounters_soap_templates	est_status
template_library.orders_templates	ordt_status
xlnt.jira_issues	jira_status
xlnt.log	http_status

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.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

marital_status

Table	Column
_1.charts	chrt_marital_status
_1.clinical_interventions	ci_marital_status
_1188.charts	chrt_marital_status
_1188.clinical_interventions	ci_marital_status
_1218.charts	chrt_marital_status
_1218.clinical_interventions	ci_marital_status
_1548.charts	chrt_marital_status
_1548.clinical_interventions	ci_marital_status
_435.charts	chrt_marital_status
_435.clinical_interventions	ci_marital_status
_436.charts	chrt_marital_status
_436.clinical_interventions	ci_marital_status
_436_archive_testing.charts	chrt_marital_status
_436_archive_testing.clinical_interventions	ci_marital_status
_437.charts	chrt_marital_status
_437.clinical_interventions	ci_marital_status
_8.charts	chrt_marital_status
_8.clinical_interventions	ci_marital_status
_81.charts	chrt_marital_status
_81.clinical_interventions	ci_marital_status
_999.charts	chrt_marital_status
_999.clinical_interventions	ci_marital_status

created_by

Table	Column
_1.configured_encounters	confenc_created_by
_1.encounters_forms	efrm_created_by
_1.forms	frm_created_by
_1188.encounters_forms	efrm_created_by
_1188.forms	frm_created_by
_1218.encounters_forms	efrm_created_by
_1218.forms	frm_created_by
_1548.configured_encounters	confenc_created_by
_1548.encounters_forms	efrm_created_by
_1548.forms	frm_created_by
_435.configured_encounters	confenc_created_by
_435.encounters_forms	efrm_created_by
_435.forms	frm_created_by
_436.configured_encounters	confenc_created_by
_436.encounters_forms	efrm_created_by
_436.forms	frm_created_by
_436_archive_testing.configured_encounters	confenc_created_by
_436_archive_testing.encounters_forms	efrm_created_by
_436_archive_testing.forms	frm_created_by
_437.configured_encounters	confenc_created_by
_437.encounters_forms	efrm_created_by
_437.forms	frm_created_by
_8.configured_encounters	confenc_created_by
_8.encounters_forms	efrm_created_by
_8.forms	frm_created_by
_81.encounters_forms	efrm_created_by
_81.forms	frm_created_by
_999.configured_encounters	confenc_created_by
_999.encounters_forms	efrm_created_by
_999.forms	frm_created_by
aurora_standard.chmadmqr	vis_created_by
template_library.forms	frm_created_by

height

Table	Column
_1.encounters_soap_vitals	espv_height
_1.patients_vitals	pvs_height
_1188.encounters_soap_vitals	espv_height
_1188.patients_vitals	pvs_height
_1218.encounters_soap_vitals	espv_height
_1218.patients_vitals	pvs_height
_1548.encounters_soap_vitals	espv_height
_1548.patients_vitals	pvs_height
_435.encounters_soap_vitals	espv_height
_435.patients_vitals	pvs_height
_436.encounters_soap_vitals	espv_height
_436.patients_vitals	pvs_height
_436_archive_testing.encounters_soap_vitals	espv_height
_436_archive_testing.patients_vitals	pvs_height
_437.encounters_soap_vitals	espv_height
_437.patients_vitals	pvs_height
_8.encounters_soap_vitals	espv_height
_8.patients_vitals	pvs_height
_81.encounters_soap_vitals	espv_height
_81.patients_vitals	pvs_height
_999.encounters_soap_vitals	espv_height
_999.patients_vitals	pvs_height
ahiWiki.filearchive	fa_height
ahiWiki.image	img_height
ahiWiki.oldimage	oi_height
ahiWiki.uploadstash	us_image_height
aurora_standard.chxhistr	h_height

weight

Table	Column
_1.encounters_soap_vitals	espv_weight
_1.orders_afps	oafp_weight
_1.patients_vitals	pvs_weight
_1188.encounters_soap_vitals	espv_weight
_1188.orders_afps	oafp_weight
_1188.patients_vitals	pvs_weight
_1218.encounters_soap_vitals	espv_weight
_1218.orders_afps	oafp_weight
_1218.patients_vitals	pvs_weight
_1548.encounters_soap_vitals	espv_weight
_1548.orders_afps	oafp_weight
_1548.patients_vitals	pvs_weight
_435.encounters_soap_vitals	espv_weight
_435.orders_afps	oafp_weight
_435.patients_vitals	pvs_weight
_436.encounters_soap_vitals	espv_weight
_436.orders_afps	oafp_weight
_436.patients_vitals	pvs_weight
_436_archive_testing.encounters_soap_vitals	espv_weight
_436_archive_testing.orders_afps	oafp_weight
_436_archive_testing.patients_vitals	pvs_weight
_437.encounters_soap_vitals	espv_weight
_437.orders_afps	oafp_weight
_437.patients_vitals	pvs_weight
_8.encounters_soap_vitals	espv_weight
_8.orders_afps	oafp_weight
_8.patients_vitals	pvs_weight
_81.encounters_soap_vitals	espv_weight
_81.orders_afps	oafp_weight
_81.patients_vitals	pvs_weight
_999.encounters_soap_vitals	espv_weight
_999.orders_afps	oafp_weight
_999.patients_vitals	pvs_weight
aurora_standard.chmarsthi	b_weight
aurora_standard.chmdrgcc	rel_weight
aurora_standard.chxhistr	h_weight
aurora_standard.orders	ship_weight
aurora_standard.stoinvce	ship_weight
aurora_standard.stoordrd	ship_weight
aurora_standard.stoordre	ship_weight
aurora_standard.stoshipd	ship_weight
aurora_standard.stuordre	total_weight
aurora_standard.workdrg	rel_weight
common.encounters_statuses	ess_weight
common.precerts_statuses	pss_weight
common.precerts_statuses	ps_weight

guar_no

Table	Column
aurora_standard.anmpi	new_guar_no
aurora_standard.apsmpi	new_guar_no
aurora_standard.bs2mpi	new_guar_no
aurora_standard.bsmpi	new_guar_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

snf_mr_no

Table	Column
aurora_standard.chhcntrc	auto_snf_mr_no
aurora_standard.chmcntrc	auto_snf_mr_no

mr_no

Table	Column
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_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

retire_date

Table	Column
aurora_standard.chmmcqud	sp_retire_date

maiden_name

Table	Column
aurora_standard.hl7in2	mom_maiden_name

interest

Table	Column
aurora_standard.strnoted	percent_interest
aurora_standard.stxratid	expense_interest

birth_date

Table	Column
aurora_standard.tmpmrrpt	edit_birth_date

country_code

Table	Column
common.lab_interfaces_performing_sites	lips_country_code

date_created

Table	Column
common.service_tickets_comments	stcp_date_created