aurora_standard.strshipr

Field	Type	Null	Key	Extra
cust_code	varchar(6)	YES	MUL
ship_to_code	varchar(6)	YES
bus_name	varchar(30)	YES
taxable	varchar(6)	YES
contact	varchar(20)	YES
phone	varchar(20)	YES
address1	varchar(30)	YES
address2	varchar(30)	YES
city	varchar(20)	YES
state	varchar(2)	YES
zip	varchar(10)	YES
country	varchar(20)	YES
sls_psn_code	varchar(6)	YES
trd_ds_code	varchar(6)	YES
st_tx_code	varchar(6)	YES
co_tx_code	varchar(6)	YES
ci_tx_code	varchar(6)	YES
comm_code	varchar(6)	YES
mtax_freight	varchar(6)	YES
mtax_misc	varchar(6)	YES
ship_via_cd	varchar(3)	YES
chs_rowID	bigint(20) unsigned	NO	PRI	auto_increment

References

Local Column

References

address1

Table	Column
Azalea.employees	emp_address1
_1.billing_providers	bp_address1
_1.buildings	bld_address1
_1.charts	chrt_address1
_1.client_contacts	clicon_address1
_1.encounters	enc_address1
_1.encounters	enc_employer_address1
_1.encounters	enc_guarantor_address1
_1.hl7_lab_locations	hll_address1
_1.insurances	ins_address1
_1.insurances_claims_centers	icc_address1
_1.locations	loc_address1
_1.non_patients	npat_address1
_1.orders	ord_address1
_1.patient_next_of_kin	pnk_address1
_1.patients	pat_address1
_1.patients	pat_employer_address1
_1.patients	pat_guarantor_address1
_1.patients	pat_emergency_address1
_1.patients_demographics_snapshots	pds_address1
_1.patients_demographics_snapshots	pds_employer_address1
_1.patients_demographics_snapshots	pds_guarantor_address1
_1.physicians	phy_address1
_1.precerts	pre_address1
_1.precerts	pre_employer_address1
_1.precerts	pre_guarantor_address1
_1.radiology_orders	rad_address1
_1188.billing_providers	bp_address1
_1188.buildings	bld_address1
_1188.charts	chrt_address1
_1188.client_contacts	clicon_address1
_1188.encounters	enc_address1
_1188.encounters	enc_employer_address1
_1188.encounters	enc_guarantor_address1
_1188.hl7_lab_locations	hll_address1
_1188.insurances	ins_address1
_1188.insurances_claims_centers	icc_address1
_1188.locations	loc_address1
_1188.non_patients	npat_address1
_1188.orders	ord_address1
_1188.patient_next_of_kin	pnk_address1
_1188.patients	pat_address1
_1188.patients	pat_employer_address1
_1188.patients	pat_guarantor_address1
_1188.patients	pat_emergency_address1
_1188.patients_demographics_snapshots	pds_address1
_1188.patients_demographics_snapshots	pds_employer_address1
_1188.patients_demographics_snapshots	pds_guarantor_address1
_1188.physicians	phy_address1
_1188.precerts	pre_address1
_1188.precerts	pre_employer_address1
_1188.precerts	pre_guarantor_address1
_1188.radiology_orders	rad_address1
_1218.billing_providers	bp_address1
_1218.buildings	bld_address1
_1218.charts	chrt_address1
_1218.client_contacts	clicon_address1
_1218.encounters	enc_address1
_1218.encounters	enc_employer_address1
_1218.encounters	enc_guarantor_address1
_1218.hl7_lab_locations	hll_address1
_1218.insurances	ins_address1
_1218.insurances_claims_centers	icc_address1
_1218.locations	loc_address1
_1218.non_patients	npat_address1
_1218.orders	ord_address1
_1218.patient_next_of_kin	pnk_address1
_1218.patients	pat_address1
_1218.patients	pat_employer_address1
_1218.patients	pat_guarantor_address1
_1218.patients	pat_emergency_address1
_1218.patients_demographics_snapshots	pds_address1
_1218.patients_demographics_snapshots	pds_employer_address1
_1218.patients_demographics_snapshots	pds_guarantor_address1
_1218.physicians	phy_address1
_1218.precerts	pre_address1
_1218.precerts	pre_employer_address1
_1218.precerts	pre_guarantor_address1
_1218.radiology_orders	rad_address1
_1548.billing_providers	bp_address1
_1548.buildings	bld_address1
_1548.charts	chrt_address1
_1548.client_contacts	clicon_address1
_1548.encounters	enc_address1
_1548.encounters	enc_employer_address1
_1548.encounters	enc_guarantor_address1
_1548.hl7_lab_locations	hll_address1
_1548.insurances	ins_address1
_1548.insurances_claims_centers	icc_address1
_1548.locations	loc_address1
_1548.non_patients	npat_address1
_1548.orders	ord_address1
_1548.patient_next_of_kin	pnk_address1
_1548.patients	pat_address1
_1548.patients	pat_employer_address1
_1548.patients	pat_guarantor_address1
_1548.patients	pat_emergency_address1
_1548.patients_demographics_snapshots	pds_address1
_1548.patients_demographics_snapshots	pds_employer_address1
_1548.patients_demographics_snapshots	pds_guarantor_address1
_1548.physicians	phy_address1
_1548.precerts	pre_address1
_1548.precerts	pre_employer_address1
_1548.precerts	pre_guarantor_address1
_1548.radiology_orders	rad_address1
_435.billing_providers	bp_address1
_435.buildings	bld_address1
_435.charts	chrt_address1
_435.client_contacts	clicon_address1
_435.encounters	enc_address1
_435.encounters	enc_employer_address1
_435.encounters	enc_guarantor_address1
_435.hl7_lab_locations	hll_address1
_435.insurances	ins_address1
_435.insurances_claims_centers	icc_address1
_435.locations	loc_address1
_435.non_patients	npat_address1
_435.orders	ord_address1
_435.patient_next_of_kin	pnk_address1
_435.patients	pat_address1
_435.patients	pat_employer_address1
_435.patients	pat_guarantor_address1
_435.patients	pat_emergency_address1
_435.patients_demographics_snapshots	pds_address1
_435.patients_demographics_snapshots	pds_employer_address1
_435.patients_demographics_snapshots	pds_guarantor_address1
_435.physicians	phy_address1
_435.precerts	pre_address1
_435.precerts	pre_employer_address1
_435.precerts	pre_guarantor_address1
_435.radiology_orders	rad_address1
_436.billing_providers	bp_address1
_436.buildings	bld_address1
_436.charts	chrt_address1
_436.client_contacts	clicon_address1
_436.encounters	enc_address1
_436.encounters	enc_employer_address1
_436.encounters	enc_guarantor_address1
_436.hl7_lab_locations	hll_address1
_436.insurances	ins_address1
_436.insurances_claims_centers	icc_address1
_436.locations	loc_address1
_436.non_patients	npat_address1
_436.orders	ord_address1
_436.patient_next_of_kin	pnk_address1
_436.patients	pat_address1
_436.patients	pat_employer_address1
_436.patients	pat_guarantor_address1
_436.patients	pat_emergency_address1
_436.patients_demographics_snapshots	pds_address1
_436.patients_demographics_snapshots	pds_employer_address1
_436.patients_demographics_snapshots	pds_guarantor_address1
_436.physicians	phy_address1
_436.precerts	pre_address1
_436.precerts	pre_employer_address1
_436.precerts	pre_guarantor_address1
_436.radiology_orders	rad_address1
_436_archive_testing.billing_providers	bp_address1
_436_archive_testing.buildings	bld_address1
_436_archive_testing.charts	chrt_address1
_436_archive_testing.client_contacts	clicon_address1
_436_archive_testing.encounters	enc_address1
_436_archive_testing.encounters	enc_employer_address1
_436_archive_testing.encounters	enc_guarantor_address1
_436_archive_testing.hl7_lab_locations	hll_address1
_436_archive_testing.insurances	ins_address1
_436_archive_testing.insurances_claims_centers	icc_address1
_436_archive_testing.locations	loc_address1
_436_archive_testing.non_patients	npat_address1
_436_archive_testing.orders	ord_address1
_436_archive_testing.patient_next_of_kin	pnk_address1
_436_archive_testing.patients	pat_address1
_436_archive_testing.patients	pat_employer_address1
_436_archive_testing.patients	pat_guarantor_address1
_436_archive_testing.patients	pat_emergency_address1
_436_archive_testing.patients_demographics_snapshots	pds_address1
_436_archive_testing.patients_demographics_snapshots	pds_employer_address1
_436_archive_testing.patients_demographics_snapshots	pds_guarantor_address1
_436_archive_testing.physicians	phy_address1
_436_archive_testing.precerts	pre_address1
_436_archive_testing.precerts	pre_employer_address1
_436_archive_testing.precerts	pre_guarantor_address1
_436_archive_testing.radiology_orders	rad_address1
_437.billing_providers	bp_address1
_437.buildings	bld_address1
_437.charts	chrt_address1
_437.client_contacts	clicon_address1
_437.encounters	enc_address1
_437.encounters	enc_employer_address1
_437.encounters	enc_guarantor_address1
_437.hl7_lab_locations	hll_address1
_437.insurances	ins_address1
_437.insurances_claims_centers	icc_address1
_437.locations	loc_address1
_437.non_patients	npat_address1
_437.orders	ord_address1
_437.patient_next_of_kin	pnk_address1
_437.patients	pat_address1
_437.patients	pat_employer_address1
_437.patients	pat_guarantor_address1
_437.patients	pat_emergency_address1
_437.patients_demographics_snapshots	pds_address1
_437.patients_demographics_snapshots	pds_employer_address1
_437.patients_demographics_snapshots	pds_guarantor_address1
_437.physicians	phy_address1
_437.precerts	pre_address1
_437.precerts	pre_employer_address1
_437.precerts	pre_guarantor_address1
_437.radiology_orders	rad_address1
_8.billing_providers	bp_address1
_8.buildings	bld_address1
_8.charts	chrt_address1
_8.client_contacts	clicon_address1
_8.encounters	enc_address1
_8.encounters	enc_employer_address1
_8.encounters	enc_guarantor_address1
_8.hl7_lab_locations	hll_address1
_8.insurances	ins_address1
_8.insurances_claims_centers	icc_address1
_8.locations	loc_address1
_8.non_patients	npat_address1
_8.orders	ord_address1
_8.patient_next_of_kin	pnk_address1
_8.patients	pat_address1
_8.patients	pat_employer_address1
_8.patients	pat_guarantor_address1
_8.patients	pat_emergency_address1
_8.patients_demographics_snapshots	pds_address1
_8.patients_demographics_snapshots	pds_employer_address1
_8.patients_demographics_snapshots	pds_guarantor_address1
_8.physicians	phy_address1
_8.precerts	pre_address1
_8.precerts	pre_employer_address1
_8.precerts	pre_guarantor_address1
_8.radiology_orders	rad_address1
_81.billing_providers	bp_address1
_81.buildings	bld_address1
_81.charts	chrt_address1
_81.client_contacts	clicon_address1
_81.encounters	enc_address1
_81.encounters	enc_employer_address1
_81.encounters	enc_guarantor_address1
_81.hl7_lab_locations	hll_address1
_81.insurances	ins_address1
_81.insurances_claims_centers	icc_address1
_81.locations	loc_address1
_81.non_patients	npat_address1
_81.orders	ord_address1
_81.patient_next_of_kin	pnk_address1
_81.patients	pat_address1
_81.patients	pat_employer_address1
_81.patients	pat_guarantor_address1
_81.patients	pat_emergency_address1
_81.patients_demographics_snapshots	pds_address1
_81.patients_demographics_snapshots	pds_employer_address1
_81.patients_demographics_snapshots	pds_guarantor_address1
_81.physicians	phy_address1
_81.precerts	pre_address1
_81.precerts	pre_employer_address1
_81.precerts	pre_guarantor_address1
_81.radiology_orders	rad_address1
_999.billing_providers	bp_address1
_999.buildings	bld_address1
_999.charts	chrt_address1
_999.client_contacts	clicon_address1
_999.encounters	enc_address1
_999.encounters	enc_employer_address1
_999.encounters	enc_guarantor_address1
_999.hl7_lab_locations	hll_address1
_999.insurances	ins_address1
_999.insurances_claims_centers	icc_address1
_999.locations	loc_address1
_999.non_patients	npat_address1
_999.orders	ord_address1
_999.patient_next_of_kin	pnk_address1
_999.patients	pat_address1
_999.patients	pat_employer_address1
_999.patients	pat_guarantor_address1
_999.patients	pat_emergency_address1
_999.patients_demographics_snapshots	pds_address1
_999.patients_demographics_snapshots	pds_employer_address1
_999.patients_demographics_snapshots	pds_guarantor_address1
_999.physicians	phy_address1
_999.precerts	pre_address1
_999.precerts	pre_employer_address1
_999.precerts	pre_guarantor_address1
_999.radiology_orders	rad_address1
common.clients	cli_address1
common.clients	cli_billing_address1
common.clients	cli_mailing_address1
common.clients_contract_data	ccd_payer_address1
common.contacts	con_address1
common.customers	cus_address1
common.customers	cus_billing_address1
common.lab_interfaces	lif_cli_address1
common.lab_interfaces_performing_sites	lips_address1
common.labs	lab_address1
common.leads	lea_address1

address2

Table	Column
Azalea.employees	emp_address2
_1.billing_providers	bp_address2
_1.buildings	bld_address2
_1.charts	chrt_address2
_1.client_contacts	clicon_address2
_1.encounters	enc_address2
_1.encounters	enc_employer_address2
_1.encounters	enc_guarantor_address2
_1.hl7_lab_locations	hll_address2
_1.insurances	ins_address2
_1.insurances_claims_centers	icc_address2
_1.locations	loc_address2
_1.non_patients	npat_address2
_1.orders	ord_address2
_1.patient_next_of_kin	pnk_address2
_1.patients	pat_address2
_1.patients	pat_employer_address2
_1.patients	pat_guarantor_address2
_1.patients	pat_emergency_address2
_1.patients_demographics_snapshots	pds_address2
_1.patients_demographics_snapshots	pds_guarantor_address2
_1.physicians	phy_address2
_1.precerts	pre_address2
_1.precerts	pre_guarantor_address2
_1.radiology_orders	rad_address2
_1188.billing_providers	bp_address2
_1188.buildings	bld_address2
_1188.charts	chrt_address2
_1188.client_contacts	clicon_address2
_1188.encounters	enc_address2
_1188.encounters	enc_employer_address2
_1188.encounters	enc_guarantor_address2
_1188.hl7_lab_locations	hll_address2
_1188.insurances	ins_address2
_1188.insurances_claims_centers	icc_address2
_1188.locations	loc_address2
_1188.non_patients	npat_address2
_1188.orders	ord_address2
_1188.patient_next_of_kin	pnk_address2
_1188.patients	pat_address2
_1188.patients	pat_employer_address2
_1188.patients	pat_guarantor_address2
_1188.patients	pat_emergency_address2
_1188.patients_demographics_snapshots	pds_address2
_1188.patients_demographics_snapshots	pds_guarantor_address2
_1188.physicians	phy_address2
_1188.precerts	pre_address2
_1188.precerts	pre_guarantor_address2
_1188.radiology_orders	rad_address2
_1218.billing_providers	bp_address2
_1218.buildings	bld_address2
_1218.charts	chrt_address2
_1218.client_contacts	clicon_address2
_1218.encounters	enc_address2
_1218.encounters	enc_employer_address2
_1218.encounters	enc_guarantor_address2
_1218.hl7_lab_locations	hll_address2
_1218.insurances	ins_address2
_1218.insurances_claims_centers	icc_address2
_1218.locations	loc_address2
_1218.non_patients	npat_address2
_1218.orders	ord_address2
_1218.patient_next_of_kin	pnk_address2
_1218.patients	pat_address2
_1218.patients	pat_employer_address2
_1218.patients	pat_guarantor_address2
_1218.patients	pat_emergency_address2
_1218.patients_demographics_snapshots	pds_address2
_1218.patients_demographics_snapshots	pds_guarantor_address2
_1218.physicians	phy_address2
_1218.precerts	pre_address2
_1218.precerts	pre_guarantor_address2
_1218.radiology_orders	rad_address2
_1548.billing_providers	bp_address2
_1548.buildings	bld_address2
_1548.charts	chrt_address2
_1548.client_contacts	clicon_address2
_1548.encounters	enc_address2
_1548.encounters	enc_employer_address2
_1548.encounters	enc_guarantor_address2
_1548.hl7_lab_locations	hll_address2
_1548.insurances	ins_address2
_1548.insurances_claims_centers	icc_address2
_1548.locations	loc_address2
_1548.non_patients	npat_address2
_1548.orders	ord_address2
_1548.patient_next_of_kin	pnk_address2
_1548.patients	pat_address2
_1548.patients	pat_employer_address2
_1548.patients	pat_guarantor_address2
_1548.patients	pat_emergency_address2
_1548.patients_demographics_snapshots	pds_address2
_1548.patients_demographics_snapshots	pds_guarantor_address2
_1548.physicians	phy_address2
_1548.precerts	pre_address2
_1548.precerts	pre_guarantor_address2
_1548.radiology_orders	rad_address2
_435.billing_providers	bp_address2
_435.buildings	bld_address2
_435.charts	chrt_address2
_435.client_contacts	clicon_address2
_435.encounters	enc_address2
_435.encounters	enc_employer_address2
_435.encounters	enc_guarantor_address2
_435.hl7_lab_locations	hll_address2
_435.insurances	ins_address2
_435.insurances_claims_centers	icc_address2
_435.locations	loc_address2
_435.non_patients	npat_address2
_435.orders	ord_address2
_435.patient_next_of_kin	pnk_address2
_435.patients	pat_address2
_435.patients	pat_employer_address2
_435.patients	pat_guarantor_address2
_435.patients	pat_emergency_address2
_435.patients_demographics_snapshots	pds_address2
_435.patients_demographics_snapshots	pds_guarantor_address2
_435.physicians	phy_address2
_435.precerts	pre_address2
_435.precerts	pre_guarantor_address2
_435.radiology_orders	rad_address2
_436.billing_providers	bp_address2
_436.buildings	bld_address2
_436.charts	chrt_address2
_436.client_contacts	clicon_address2
_436.encounters	enc_address2
_436.encounters	enc_employer_address2
_436.encounters	enc_guarantor_address2
_436.hl7_lab_locations	hll_address2
_436.insurances	ins_address2
_436.insurances_claims_centers	icc_address2
_436.locations	loc_address2
_436.non_patients	npat_address2
_436.orders	ord_address2
_436.patient_next_of_kin	pnk_address2
_436.patients	pat_address2
_436.patients	pat_employer_address2
_436.patients	pat_guarantor_address2
_436.patients	pat_emergency_address2
_436.patients_demographics_snapshots	pds_address2
_436.patients_demographics_snapshots	pds_guarantor_address2
_436.physicians	phy_address2
_436.precerts	pre_address2
_436.precerts	pre_guarantor_address2
_436.radiology_orders	rad_address2
_436_archive_testing.billing_providers	bp_address2
_436_archive_testing.buildings	bld_address2
_436_archive_testing.charts	chrt_address2
_436_archive_testing.client_contacts	clicon_address2
_436_archive_testing.encounters	enc_address2
_436_archive_testing.encounters	enc_employer_address2
_436_archive_testing.encounters	enc_guarantor_address2
_436_archive_testing.hl7_lab_locations	hll_address2
_436_archive_testing.insurances	ins_address2
_436_archive_testing.insurances_claims_centers	icc_address2
_436_archive_testing.locations	loc_address2
_436_archive_testing.non_patients	npat_address2
_436_archive_testing.orders	ord_address2
_436_archive_testing.patient_next_of_kin	pnk_address2
_436_archive_testing.patients	pat_address2
_436_archive_testing.patients	pat_employer_address2
_436_archive_testing.patients	pat_guarantor_address2
_436_archive_testing.patients	pat_emergency_address2
_436_archive_testing.patients_demographics_snapshots	pds_address2
_436_archive_testing.patients_demographics_snapshots	pds_guarantor_address2
_436_archive_testing.physicians	phy_address2
_436_archive_testing.precerts	pre_address2
_436_archive_testing.precerts	pre_guarantor_address2
_436_archive_testing.radiology_orders	rad_address2
_437.billing_providers	bp_address2
_437.buildings	bld_address2
_437.charts	chrt_address2
_437.client_contacts	clicon_address2
_437.encounters	enc_address2
_437.encounters	enc_employer_address2
_437.encounters	enc_guarantor_address2
_437.hl7_lab_locations	hll_address2
_437.insurances	ins_address2
_437.insurances_claims_centers	icc_address2
_437.locations	loc_address2
_437.non_patients	npat_address2
_437.orders	ord_address2
_437.patient_next_of_kin	pnk_address2
_437.patients	pat_address2
_437.patients	pat_employer_address2
_437.patients	pat_guarantor_address2
_437.patients	pat_emergency_address2
_437.patients_demographics_snapshots	pds_address2
_437.patients_demographics_snapshots	pds_guarantor_address2
_437.physicians	phy_address2
_437.precerts	pre_address2
_437.precerts	pre_guarantor_address2
_437.radiology_orders	rad_address2
_8.billing_providers	bp_address2
_8.buildings	bld_address2
_8.charts	chrt_address2
_8.client_contacts	clicon_address2
_8.encounters	enc_address2
_8.encounters	enc_employer_address2
_8.encounters	enc_guarantor_address2
_8.hl7_lab_locations	hll_address2
_8.insurances	ins_address2
_8.insurances_claims_centers	icc_address2
_8.locations	loc_address2
_8.non_patients	npat_address2
_8.orders	ord_address2
_8.patient_next_of_kin	pnk_address2
_8.patients	pat_address2
_8.patients	pat_employer_address2
_8.patients	pat_guarantor_address2
_8.patients	pat_emergency_address2
_8.patients_demographics_snapshots	pds_address2
_8.patients_demographics_snapshots	pds_guarantor_address2
_8.physicians	phy_address2
_8.precerts	pre_address2
_8.precerts	pre_guarantor_address2
_8.radiology_orders	rad_address2
_81.billing_providers	bp_address2
_81.buildings	bld_address2
_81.charts	chrt_address2
_81.client_contacts	clicon_address2
_81.encounters	enc_address2
_81.encounters	enc_employer_address2
_81.encounters	enc_guarantor_address2
_81.hl7_lab_locations	hll_address2
_81.insurances	ins_address2
_81.insurances_claims_centers	icc_address2
_81.locations	loc_address2
_81.non_patients	npat_address2
_81.orders	ord_address2
_81.patient_next_of_kin	pnk_address2
_81.patients	pat_address2
_81.patients	pat_employer_address2
_81.patients	pat_guarantor_address2
_81.patients	pat_emergency_address2
_81.patients_demographics_snapshots	pds_address2
_81.patients_demographics_snapshots	pds_guarantor_address2
_81.physicians	phy_address2
_81.precerts	pre_address2
_81.precerts	pre_guarantor_address2
_81.radiology_orders	rad_address2
_999.billing_providers	bp_address2
_999.buildings	bld_address2
_999.charts	chrt_address2
_999.client_contacts	clicon_address2
_999.encounters	enc_address2
_999.encounters	enc_employer_address2
_999.encounters	enc_guarantor_address2
_999.hl7_lab_locations	hll_address2
_999.insurances	ins_address2
_999.insurances_claims_centers	icc_address2
_999.locations	loc_address2
_999.non_patients	npat_address2
_999.orders	ord_address2
_999.patient_next_of_kin	pnk_address2
_999.patients	pat_address2
_999.patients	pat_employer_address2
_999.patients	pat_guarantor_address2
_999.patients	pat_emergency_address2
_999.patients_demographics_snapshots	pds_address2
_999.patients_demographics_snapshots	pds_guarantor_address2
_999.physicians	phy_address2
_999.precerts	pre_address2
_999.precerts	pre_guarantor_address2
_999.radiology_orders	rad_address2
common.clients	cli_address2
common.clients	cli_billing_address2
common.clients	cli_mailing_address2
common.clients_contract_data	ccd_payer_address2
common.contacts	con_address2
common.customers	cus_address2
common.customers	cus_billing_address2
common.lab_interfaces	lif_cli_address2
common.lab_interfaces_performing_sites	lips_address2
common.labs	lab_address2
common.leads	lea_address2

phone

Table	Column
Azalea.employees	emp_phone
EFaxes.efax_accounts	efaxacc_phone
_1.billing_providers	bp_phone
_1.charts	chrt_phone
_1.client_contacts	clicon_primary_phone
_1.cpoe_responses	cpoe_res_phone
_1.donors	don_phone
_1.encounters	enc_phone
_1.encounters	enc_guarantor_phone
_1.examples	exa_phone
_1.hl7_accessions	acc_phone
_1.hl7_lab_locations	hll_phone
_1.insurances	ins_phone
_1.insurances_claims_centers	icc_phone
_1.locations	loc_phone
_1.non_patients	npat_phone
_1.orders	ord_phone
_1.patient_next_of_kin	pnk_phone
_1.patients	pat_phone
_1.patients	pat_guarantor_phone
_1.patients_demographics_snapshots	pds_phone
_1.patients_demographics_snapshots	pds_guarantor_phone
_1.physicians	phy_phone
_1.precerts	pre_phone
_1.precerts	pre_guarantor_phone
_1.radiology_orders	rad_phone
_1.radiology_results	rad_res_phone
_1188.billing_providers	bp_phone
_1188.charts	chrt_phone
_1188.client_contacts	clicon_primary_phone
_1188.cpoe_responses	cpoe_res_phone
_1188.donors	don_phone
_1188.encounters	enc_phone
_1188.encounters	enc_guarantor_phone
_1188.examples	exa_phone
_1188.hl7_accessions	acc_phone
_1188.hl7_lab_locations	hll_phone
_1188.insurances	ins_phone
_1188.insurances_claims_centers	icc_phone
_1188.locations	loc_phone
_1188.non_patients	npat_phone
_1188.orders	ord_phone
_1188.patient_next_of_kin	pnk_phone
_1188.patients	pat_phone
_1188.patients	pat_guarantor_phone
_1188.patients_demographics_snapshots	pds_phone
_1188.patients_demographics_snapshots	pds_guarantor_phone
_1188.physicians	phy_phone
_1188.precerts	pre_phone
_1188.precerts	pre_guarantor_phone
_1188.radiology_orders	rad_phone
_1188.radiology_results	rad_res_phone
_1218.billing_providers	bp_phone
_1218.charts	chrt_phone
_1218.client_contacts	clicon_primary_phone
_1218.cpoe_responses	cpoe_res_phone
_1218.donors	don_phone
_1218.encounters	enc_phone
_1218.encounters	enc_guarantor_phone
_1218.examples	exa_phone
_1218.hl7_accessions	acc_phone
_1218.hl7_lab_locations	hll_phone
_1218.insurances	ins_phone
_1218.insurances_claims_centers	icc_phone
_1218.locations	loc_phone
_1218.non_patients	npat_phone
_1218.orders	ord_phone
_1218.patient_next_of_kin	pnk_phone
_1218.patients	pat_phone
_1218.patients	pat_guarantor_phone
_1218.patients_demographics_snapshots	pds_phone
_1218.patients_demographics_snapshots	pds_guarantor_phone
_1218.physicians	phy_phone
_1218.precerts	pre_phone
_1218.precerts	pre_guarantor_phone
_1218.radiology_orders	rad_phone
_1218.radiology_results	rad_res_phone
_1548.billing_providers	bp_phone
_1548.charts	chrt_phone
_1548.client_contacts	clicon_primary_phone
_1548.cpoe_responses	cpoe_res_phone
_1548.donors	don_phone
_1548.encounters	enc_phone
_1548.encounters	enc_guarantor_phone
_1548.examples	exa_phone
_1548.hl7_accessions	acc_phone
_1548.hl7_lab_locations	hll_phone
_1548.insurances	ins_phone
_1548.insurances_claims_centers	icc_phone
_1548.locations	loc_phone
_1548.non_patients	npat_phone
_1548.orders	ord_phone
_1548.patient_next_of_kin	pnk_phone
_1548.patients	pat_phone
_1548.patients	pat_guarantor_phone
_1548.patients_demographics_snapshots	pds_phone
_1548.patients_demographics_snapshots	pds_guarantor_phone
_1548.physicians	phy_phone
_1548.precerts	pre_phone
_1548.precerts	pre_guarantor_phone
_1548.radiology_orders	rad_phone
_1548.radiology_results	rad_res_phone
_435.billing_providers	bp_phone
_435.charts	chrt_phone
_435.client_contacts	clicon_primary_phone
_435.cpoe_responses	cpoe_res_phone
_435.donors	don_phone
_435.encounters	enc_phone
_435.encounters	enc_guarantor_phone
_435.examples	exa_phone
_435.hl7_accessions	acc_phone
_435.hl7_lab_locations	hll_phone
_435.insurances	ins_phone
_435.insurances_claims_centers	icc_phone
_435.locations	loc_phone
_435.non_patients	npat_phone
_435.orders	ord_phone
_435.patient_next_of_kin	pnk_phone
_435.patients	pat_phone
_435.patients	pat_guarantor_phone
_435.patients_demographics_snapshots	pds_phone
_435.patients_demographics_snapshots	pds_guarantor_phone
_435.physicians	phy_phone
_435.precerts	pre_phone
_435.precerts	pre_guarantor_phone
_435.radiology_orders	rad_phone
_435.radiology_results	rad_res_phone
_436.billing_providers	bp_phone
_436.charts	chrt_phone
_436.client_contacts	clicon_primary_phone
_436.cpoe_responses	cpoe_res_phone
_436.donors	don_phone
_436.encounters	enc_phone
_436.encounters	enc_guarantor_phone
_436.examples	exa_phone
_436.hl7_accessions	acc_phone
_436.hl7_lab_locations	hll_phone
_436.insurances	ins_phone
_436.insurances_claims_centers	icc_phone
_436.locations	loc_phone
_436.non_patients	npat_phone
_436.orders	ord_phone
_436.patient_next_of_kin	pnk_phone
_436.patients	pat_phone
_436.patients	pat_guarantor_phone
_436.patients_demographics_snapshots	pds_phone
_436.patients_demographics_snapshots	pds_guarantor_phone
_436.physicians	phy_phone
_436.precerts	pre_phone
_436.precerts	pre_guarantor_phone
_436.radiology_orders	rad_phone
_436.radiology_results	rad_res_phone
_436_archive_testing.billing_providers	bp_phone
_436_archive_testing.charts	chrt_phone
_436_archive_testing.client_contacts	clicon_primary_phone
_436_archive_testing.cpoe_responses	cpoe_res_phone
_436_archive_testing.donors	don_phone
_436_archive_testing.encounters	enc_phone
_436_archive_testing.encounters	enc_guarantor_phone
_436_archive_testing.examples	exa_phone
_436_archive_testing.hl7_accessions	acc_phone
_436_archive_testing.hl7_lab_locations	hll_phone
_436_archive_testing.insurances	ins_phone
_436_archive_testing.insurances_claims_centers	icc_phone
_436_archive_testing.locations	loc_phone
_436_archive_testing.non_patients	npat_phone
_436_archive_testing.orders	ord_phone
_436_archive_testing.patient_next_of_kin	pnk_phone
_436_archive_testing.patients	pat_phone
_436_archive_testing.patients	pat_guarantor_phone
_436_archive_testing.patients_demographics_snapshots	pds_phone
_436_archive_testing.patients_demographics_snapshots	pds_guarantor_phone
_436_archive_testing.physicians	phy_phone
_436_archive_testing.precerts	pre_phone
_436_archive_testing.precerts	pre_guarantor_phone
_436_archive_testing.radiology_orders	rad_phone
_436_archive_testing.radiology_results	rad_res_phone
_437.billing_providers	bp_phone
_437.charts	chrt_phone
_437.client_contacts	clicon_primary_phone
_437.cpoe_responses	cpoe_res_phone
_437.donors	don_phone
_437.encounters	enc_phone
_437.encounters	enc_guarantor_phone
_437.examples	exa_phone
_437.hl7_accessions	acc_phone
_437.hl7_lab_locations	hll_phone
_437.insurances	ins_phone
_437.insurances_claims_centers	icc_phone
_437.locations	loc_phone
_437.non_patients	npat_phone
_437.orders	ord_phone
_437.patient_next_of_kin	pnk_phone
_437.patients	pat_phone
_437.patients	pat_guarantor_phone
_437.patients_demographics_snapshots	pds_phone
_437.patients_demographics_snapshots	pds_guarantor_phone
_437.physicians	phy_phone
_437.precerts	pre_phone
_437.precerts	pre_guarantor_phone
_437.radiology_orders	rad_phone
_437.radiology_results	rad_res_phone
_8.billing_providers	bp_phone
_8.charts	chrt_phone
_8.client_contacts	clicon_primary_phone
_8.cpoe_responses	cpoe_res_phone
_8.donors	don_phone
_8.encounters	enc_phone
_8.encounters	enc_guarantor_phone
_8.examples	exa_phone
_8.hl7_accessions	acc_phone
_8.hl7_lab_locations	hll_phone
_8.insurances	ins_phone
_8.insurances_claims_centers	icc_phone
_8.locations	loc_phone
_8.non_patients	npat_phone
_8.orders	ord_phone
_8.patient_next_of_kin	pnk_phone
_8.patients	pat_phone
_8.patients	pat_guarantor_phone
_8.patients_demographics_snapshots	pds_phone
_8.patients_demographics_snapshots	pds_guarantor_phone
_8.physicians	phy_phone
_8.precerts	pre_phone
_8.precerts	pre_guarantor_phone
_8.radiology_orders	rad_phone
_8.radiology_results	rad_res_phone
_81.billing_providers	bp_phone
_81.charts	chrt_phone
_81.client_contacts	clicon_primary_phone
_81.cpoe_responses	cpoe_res_phone
_81.donors	don_phone
_81.encounters	enc_phone
_81.encounters	enc_guarantor_phone
_81.examples	exa_phone
_81.hl7_accessions	acc_phone
_81.hl7_lab_locations	hll_phone
_81.insurances	ins_phone
_81.insurances_claims_centers	icc_phone
_81.locations	loc_phone
_81.non_patients	npat_phone
_81.orders	ord_phone
_81.patient_next_of_kin	pnk_phone
_81.patients	pat_phone
_81.patients	pat_guarantor_phone
_81.patients_demographics_snapshots	pds_phone
_81.patients_demographics_snapshots	pds_guarantor_phone
_81.physicians	phy_phone
_81.precerts	pre_phone
_81.precerts	pre_guarantor_phone
_81.radiology_orders	rad_phone
_81.radiology_results	rad_res_phone
_999.billing_providers	bp_phone
_999.charts	chrt_phone
_999.client_contacts	clicon_primary_phone
_999.cpoe_responses	cpoe_res_phone
_999.donors	don_phone
_999.encounters	enc_phone
_999.encounters	enc_guarantor_phone
_999.examples	exa_phone
_999.hl7_accessions	acc_phone
_999.hl7_lab_locations	hll_phone
_999.insurances	ins_phone
_999.insurances_claims_centers	icc_phone
_999.locations	loc_phone
_999.non_patients	npat_phone
_999.orders	ord_phone
_999.patient_next_of_kin	pnk_phone
_999.patients	pat_phone
_999.patients	pat_guarantor_phone
_999.patients_demographics_snapshots	pds_phone
_999.patients_demographics_snapshots	pds_guarantor_phone
_999.physicians	phy_phone
_999.precerts	pre_phone
_999.precerts	pre_guarantor_phone
_999.radiology_orders	rad_phone
_999.radiology_results	rad_res_phone
aurora_standard.bdmpi	sp_phone
aurora_standard.bfinsrc	precert_phone
aurora_standard.bfrhc	gu_phone
aurora_standard.bhar	p_phone
aurora_standard.bhar	g_phone
aurora_standard.bhar	ge_phone
aurora_standard.bhar	em_phone
aurora_standard.bhguar	emp_phone
aurora_standard.bhphybak	home_phone
aurora_standard.bhphybak	office_phone
aurora_standard.bhphybak	cellular_phone
aurora_standard.bhphybak	page_phone
aurora_standard.bhtguar	emp_phone
aurora_standard.bmmpi	p_phone
aurora_standard.bmnkin	n_phone
aurora_standard.bmnkin	nw_phone
aurora_standard.bmnkin	nc_phone
aurora_standard.bmpact	p_phone
aurora_standard.bpar	p_phone
aurora_standard.bpar	g_phone
aurora_standard.bpar	ge_phone
aurora_standard.bpar	em_phone
aurora_standard.bpar2	p_phone
aurora_standard.bpar2	g_phone
aurora_standard.bpar2	ge_phone
aurora_standard.bpar2	em_phone
aurora_standard.bpmpi	p_phone
aurora_standard.bpmpi2	p_phone
aurora_standard.bsinsur	spouse_phone
aurora_standard.bsinsur	nextkin_phone
aurora_standard.bsinsur	patient_phone
aurora_standard.bsinsur	pat_emp_phone
aurora_standard.bsinsur	pat_cell_phone
aurora_standard.bsinsur	sp_cell_phone
aurora_standard.bsinsur	nk_cell_phone
aurora_standard.bvguar	work_phone
aurora_standard.bvmpi	work_phone
aurora_standard.bvmpi2	work_phone
aurora_standard.bwphync	office_phone
aurora_standard.c5insrc	precert_phone
aurora_standard.c5insrcdr	precert_phone
aurora_standard.c7insur2	ins_phone
aurora_standard.c7insur3	ins_phone
aurora_standard.c8mpi	p_phone
aurora_standard.c8phy	home_phone
aurora_standard.c8phy	office_phone
aurora_standard.c8phy	cellular_phone
aurora_standard.c8phy	page_phone
aurora_standard.cainsrc	precert_phone
aurora_standard.cainsrc2	precert_phone
aurora_standard.campi	spouse_phone
aurora_standard.campi	sp_cell_phone
aurora_standard.campi	nextkin_phone
aurora_standard.campi	nk_cell_phone
aurora_standard.campi	patient_phone
aurora_standard.campi	pat_emp_phone
aurora_standard.campi	pat_cell_phone
aurora_standard.caphy	office_phone
aurora_standard.caphync	hm_phone
aurora_standard.caphync	wk_phone
aurora_standard.caphync	cell_phone
aurora_standard.chlswbhd	fac_phone
aurora_standard.chlswbhd	agt_phone
aurora_standard.chlswbhd	sfw_phone
aurora_standard.chltrnhd	fac_phone
aurora_standard.chltrnhd	agt_phone
aurora_standard.chltrnhd	sfw_phone
aurora_standard.chmadmwc	ref_phone
aurora_standard.chmarcnbf	g_phone
aurora_standard.chmarcnbf	g_emp_phone
aurora_standard.chmarcnbf	ins1_phone
aurora_standard.chmarcnbf	ins2_phone
aurora_standard.chmarsi	pat_phone
aurora_standard.chmarsi	gu_phone
aurora_standard.chmarsi	pat_emp_phone
aurora_standard.chmarsi	sp_phone
aurora_standard.chmarst	fac_phone
aurora_standard.chmarsti	fac_phone
aurora_standard.chmcampi	pat_phone
aurora_standard.chmcampi	gu_phone
aurora_standard.chmcampi	pat_emp_phone
aurora_standard.chmcampi	sp_phone
aurora_standard.chmcmhed	debtor_phone
aurora_standard.chmcmhed	pat_phone
aurora_standard.chmcosta	pat_phone
aurora_standard.chmemplr	other_phone
aurora_standard.chmescpt	contact_phone
aurora_standard.chmexmpi	pat_phone
aurora_standard.chmexmpi	gu_phone
aurora_standard.chmexmpi	pat_emp_phone
aurora_standard.chmexmpi	sp_phone
aurora_standard.chmguarr	gu_emp_phone
aurora_standard.chmhistp	p_phone
aurora_standard.chmhl7ic	company_phone
aurora_standard.chminsrc	precert_phone
aurora_standard.chmnvstb	prov_phone
aurora_standard.chmnvstr	prov_phone
aurora_standard.chmozpcd	debtor_phone
aurora_standard.chmozpcd	bank_phone
aurora_standard.chmpatmr	spouse_phone
aurora_standard.chmpatmr	nextkin_phone
aurora_standard.chmpatmr	patient_phone
aurora_standard.chmpatmr	pat_emp_phone
aurora_standard.chmpatmr	pat_cell_phone
aurora_standard.chmpatmr	sp_cell_phone
aurora_standard.chmpatmr	nk_cell_phone
aurora_standard.chmpatwc	mom_phone
aurora_standard.chmpatwc	dad_phone
aurora_standard.chmpdemo	p_phone
aurora_standard.chmpdemo	p_emp_phone
aurora_standard.chmpdemo	sp_phone
aurora_standard.chmpdemo	gu_phone
aurora_standard.chmpdemo	ins1_phone
aurora_standard.chmpdemo	ins2_phone
aurora_standard.chmpdemo	ins3_phone
aurora_standard.chmphync	home_phone
aurora_standard.chmphync	office_phone
aurora_standard.chmphync	cellular_phone
aurora_standard.chmphync	page_phone
aurora_standard.chmradex	pat_phone
aurora_standard.chmradex	pat_emp_phone
aurora_standard.chmradex	gu_phone
aurora_standard.chmradex	sp_phone
aurora_standard.chpcardc	contact_phone
aurora_standard.chpcardd	contact_phone
aurora_standard.chpcempr	on_call_phone
aurora_standard.chpcntrc	educ_phone
aurora_standard.chpemerd	work_phone
aurora_standard.chpemerd	home_phone
aurora_standard.chpemerd	other_phone
aurora_standard.chpinsuc	precert_phone
aurora_standard.chppersr	on_call_phone
aurora_standard.chppersr	cell_phone
aurora_standard.chshotlr	other_phone
aurora_standard.cuphync	home_phone
aurora_standard.cuphync	office_phone
aurora_standard.nbspouse	spouse_phone
aurora_standard.ohoemplr	home_phone
aurora_standard.stp1099c	contact_phone
aurora_standard.stp1099c	vend_phone
aurora_standard.stppytor	fax_phone
aurora_standard.stprepsd	rep_phone
aurora_standard.stpvendr	fax_phone
aurora_standard.stpvendr	agent_phone
aurora_standard.strcustr	fax_phone
aurora_standard.styoctcc	contact_phone
aurora_standard.styuimmr	cont_phone
aurora_standard.styw2mm1	cont_phone
aurora_standard.vault_providers	home_phone
aurora_standard.vault_providers	office_phone
aurora_standard.vault_providers	cell_phone
common.applicants	app_phone
common.applicants	app_cell_phone
common.applicants	app_employer_1_phone
common.applicants	app_employer_2_phone
common.applicants	app_employer_3_phone
common.applicants	app_employer_4_phone
common.applicants	app_reference_1_phone
common.applicants	app_reference_2_phone
common.applicants	app_reference_3_phone
common.applicants	app_reference_4_phone
common.clients_contract_data	ccd_payer_phone
common.contact_imports	ci_phone
common.fax_accounts	fxa_phone
common.lab_interfaces_performing_sites	lips_phone
common.leads	lea_phone
common.sfax_accounts	sfax_acc_phone
common.users	usr_cell_phone
rcmroi.dev__sf_users	mobile_phone
rcmroi.prod__sf_users	mobile_phone
rcmroi.test__sf_users	mobile_phone

city

Table	Column
Azalea.employees	emp_city
_1.billing_providers	bp_city
_1.buildings	bld_city
_1.charts	chrt_city
_1.client_contacts	clicon_city
_1.encounters	enc_city
_1.encounters	enc_employer_city
_1.encounters	enc_guarantor_city
_1.encounters	enc_ins1_employer_city
_1.encounters	enc_ins2_employer_city
_1.encounters	enc_ins3_employer_city
_1.hl7_lab_locations	hll_city
_1.insurances	ins_city
_1.insurances_claims_centers	icc_city
_1.insurances_repository	irep_ins_employer_city
_1.locations	loc_city
_1.non_patients	npat_city
_1.orders	ord_city
_1.orders	ord_ins1_employer_city
_1.orders	ord_ins2_employer_city
_1.patient_next_of_kin	pnk_city
_1.patients	pat_city
_1.patients	pat_employer_city
_1.patients	pat_guarantor_city
_1.patients	pat_ins1_employer_city
_1.patients	pat_ins2_employer_city
_1.patients	pat_ins3_employer_city
_1.patients	pat_emergency_city
_1.patients_demographics_snapshots	pds_city
_1.patients_demographics_snapshots	pds_employer_city
_1.patients_demographics_snapshots	pds_guarantor_city
_1.patients_demographics_snapshots	pds_ins1_employer_city
_1.patients_demographics_snapshots	pds_ins2_employer_city
_1.patients_demographics_snapshots	pds_ins3_employer_city
_1.physicians	phy_city
_1.precerts	pre_city
_1.precerts	pre_employer_city
_1.precerts	pre_guarantor_city
_1.precerts	pre_ins1_employer_city
_1.precerts	pre_ins2_employer_city
_1.radiology_orders	rad_city
_1.radiology_orders	rad_ins1_employer_city
_1.radiology_orders	rad_ins2_employer_city
_1188.billing_providers	bp_city
_1188.buildings	bld_city
_1188.charts	chrt_city
_1188.client_contacts	clicon_city
_1188.encounters	enc_city
_1188.encounters	enc_employer_city
_1188.encounters	enc_guarantor_city
_1188.encounters	enc_ins1_employer_city
_1188.encounters	enc_ins2_employer_city
_1188.encounters	enc_ins3_employer_city
_1188.hl7_lab_locations	hll_city
_1188.insurances	ins_city
_1188.insurances_claims_centers	icc_city
_1188.insurances_repository	irep_ins_employer_city
_1188.locations	loc_city
_1188.non_patients	npat_city
_1188.orders	ord_city
_1188.orders	ord_ins1_employer_city
_1188.orders	ord_ins2_employer_city
_1188.patient_next_of_kin	pnk_city
_1188.patients	pat_city
_1188.patients	pat_employer_city
_1188.patients	pat_guarantor_city
_1188.patients	pat_ins1_employer_city
_1188.patients	pat_ins2_employer_city
_1188.patients	pat_ins3_employer_city
_1188.patients	pat_emergency_city
_1188.patients_demographics_snapshots	pds_city
_1188.patients_demographics_snapshots	pds_employer_city
_1188.patients_demographics_snapshots	pds_guarantor_city
_1188.patients_demographics_snapshots	pds_ins1_employer_city
_1188.patients_demographics_snapshots	pds_ins2_employer_city
_1188.patients_demographics_snapshots	pds_ins3_employer_city
_1188.physicians	phy_city
_1188.precerts	pre_city
_1188.precerts	pre_employer_city
_1188.precerts	pre_guarantor_city
_1188.precerts	pre_ins1_employer_city
_1188.precerts	pre_ins2_employer_city
_1188.radiology_orders	rad_city
_1188.radiology_orders	rad_ins1_employer_city
_1188.radiology_orders	rad_ins2_employer_city
_1218.billing_providers	bp_city
_1218.buildings	bld_city
_1218.charts	chrt_city
_1218.client_contacts	clicon_city
_1218.encounters	enc_city
_1218.encounters	enc_employer_city
_1218.encounters	enc_guarantor_city
_1218.encounters	enc_ins1_employer_city
_1218.encounters	enc_ins2_employer_city
_1218.encounters	enc_ins3_employer_city
_1218.hl7_lab_locations	hll_city
_1218.insurances	ins_city
_1218.insurances_claims_centers	icc_city
_1218.insurances_repository	irep_ins_employer_city
_1218.locations	loc_city
_1218.non_patients	npat_city
_1218.orders	ord_city
_1218.orders	ord_ins1_employer_city
_1218.orders	ord_ins2_employer_city
_1218.patient_next_of_kin	pnk_city
_1218.patients	pat_city
_1218.patients	pat_employer_city
_1218.patients	pat_guarantor_city
_1218.patients	pat_ins1_employer_city
_1218.patients	pat_ins2_employer_city
_1218.patients	pat_ins3_employer_city
_1218.patients	pat_emergency_city
_1218.patients_demographics_snapshots	pds_city
_1218.patients_demographics_snapshots	pds_employer_city
_1218.patients_demographics_snapshots	pds_guarantor_city
_1218.patients_demographics_snapshots	pds_ins1_employer_city
_1218.patients_demographics_snapshots	pds_ins2_employer_city
_1218.patients_demographics_snapshots	pds_ins3_employer_city
_1218.physicians	phy_city
_1218.precerts	pre_city
_1218.precerts	pre_employer_city
_1218.precerts	pre_guarantor_city
_1218.precerts	pre_ins1_employer_city
_1218.precerts	pre_ins2_employer_city
_1218.radiology_orders	rad_city
_1218.radiology_orders	rad_ins1_employer_city
_1218.radiology_orders	rad_ins2_employer_city
_1548.billing_providers	bp_city
_1548.buildings	bld_city
_1548.charts	chrt_city
_1548.client_contacts	clicon_city
_1548.encounters	enc_city
_1548.encounters	enc_employer_city
_1548.encounters	enc_guarantor_city
_1548.encounters	enc_ins1_employer_city
_1548.encounters	enc_ins2_employer_city
_1548.encounters	enc_ins3_employer_city
_1548.hl7_lab_locations	hll_city
_1548.insurances	ins_city
_1548.insurances_claims_centers	icc_city
_1548.insurances_repository	irep_ins_employer_city
_1548.locations	loc_city
_1548.non_patients	npat_city
_1548.orders	ord_city
_1548.orders	ord_ins1_employer_city
_1548.orders	ord_ins2_employer_city
_1548.patient_next_of_kin	pnk_city
_1548.patients	pat_city
_1548.patients	pat_employer_city
_1548.patients	pat_guarantor_city
_1548.patients	pat_ins1_employer_city
_1548.patients	pat_ins2_employer_city
_1548.patients	pat_ins3_employer_city
_1548.patients	pat_emergency_city
_1548.patients_demographics_snapshots	pds_city
_1548.patients_demographics_snapshots	pds_employer_city
_1548.patients_demographics_snapshots	pds_guarantor_city
_1548.patients_demographics_snapshots	pds_ins1_employer_city
_1548.patients_demographics_snapshots	pds_ins2_employer_city
_1548.patients_demographics_snapshots	pds_ins3_employer_city
_1548.physicians	phy_city
_1548.precerts	pre_city
_1548.precerts	pre_employer_city
_1548.precerts	pre_guarantor_city
_1548.precerts	pre_ins1_employer_city
_1548.precerts	pre_ins2_employer_city
_1548.radiology_orders	rad_city
_1548.radiology_orders	rad_ins1_employer_city
_1548.radiology_orders	rad_ins2_employer_city
_435.billing_providers	bp_city
_435.buildings	bld_city
_435.charts	chrt_city
_435.client_contacts	clicon_city
_435.encounters	enc_city
_435.encounters	enc_employer_city
_435.encounters	enc_guarantor_city
_435.encounters	enc_ins1_employer_city
_435.encounters	enc_ins2_employer_city
_435.encounters	enc_ins3_employer_city
_435.hl7_lab_locations	hll_city
_435.insurances	ins_city
_435.insurances_claims_centers	icc_city
_435.insurances_repository	irep_ins_employer_city
_435.locations	loc_city
_435.non_patients	npat_city
_435.orders	ord_city
_435.orders	ord_ins1_employer_city
_435.orders	ord_ins2_employer_city
_435.patient_next_of_kin	pnk_city
_435.patients	pat_city
_435.patients	pat_employer_city
_435.patients	pat_guarantor_city
_435.patients	pat_ins1_employer_city
_435.patients	pat_ins2_employer_city
_435.patients	pat_ins3_employer_city
_435.patients	pat_emergency_city
_435.patients_demographics_snapshots	pds_city
_435.patients_demographics_snapshots	pds_employer_city
_435.patients_demographics_snapshots	pds_guarantor_city
_435.patients_demographics_snapshots	pds_ins1_employer_city
_435.patients_demographics_snapshots	pds_ins2_employer_city
_435.patients_demographics_snapshots	pds_ins3_employer_city
_435.physicians	phy_city
_435.precerts	pre_city
_435.precerts	pre_employer_city
_435.precerts	pre_guarantor_city
_435.precerts	pre_ins1_employer_city
_435.precerts	pre_ins2_employer_city
_435.radiology_orders	rad_city
_435.radiology_orders	rad_ins1_employer_city
_435.radiology_orders	rad_ins2_employer_city
_436.billing_providers	bp_city
_436.buildings	bld_city
_436.charts	chrt_city
_436.client_contacts	clicon_city
_436.encounters	enc_city
_436.encounters	enc_employer_city
_436.encounters	enc_guarantor_city
_436.encounters	enc_ins1_employer_city
_436.encounters	enc_ins2_employer_city
_436.encounters	enc_ins3_employer_city
_436.hl7_lab_locations	hll_city
_436.insurances	ins_city
_436.insurances_claims_centers	icc_city
_436.insurances_repository	irep_ins_employer_city
_436.locations	loc_city
_436.non_patients	npat_city
_436.orders	ord_city
_436.orders	ord_ins1_employer_city
_436.orders	ord_ins2_employer_city
_436.patient_next_of_kin	pnk_city
_436.patients	pat_city
_436.patients	pat_employer_city
_436.patients	pat_guarantor_city
_436.patients	pat_ins1_employer_city
_436.patients	pat_ins2_employer_city
_436.patients	pat_ins3_employer_city
_436.patients	pat_emergency_city
_436.patients_demographics_snapshots	pds_city
_436.patients_demographics_snapshots	pds_employer_city
_436.patients_demographics_snapshots	pds_guarantor_city
_436.patients_demographics_snapshots	pds_ins1_employer_city
_436.patients_demographics_snapshots	pds_ins2_employer_city
_436.patients_demographics_snapshots	pds_ins3_employer_city
_436.physicians	phy_city
_436.precerts	pre_city
_436.precerts	pre_employer_city
_436.precerts	pre_guarantor_city
_436.precerts	pre_ins1_employer_city
_436.precerts	pre_ins2_employer_city
_436.radiology_orders	rad_city
_436.radiology_orders	rad_ins1_employer_city
_436.radiology_orders	rad_ins2_employer_city
_436_archive_testing.billing_providers	bp_city
_436_archive_testing.buildings	bld_city
_436_archive_testing.charts	chrt_city
_436_archive_testing.client_contacts	clicon_city
_436_archive_testing.encounters	enc_city
_436_archive_testing.encounters	enc_employer_city
_436_archive_testing.encounters	enc_guarantor_city
_436_archive_testing.encounters	enc_ins1_employer_city
_436_archive_testing.encounters	enc_ins2_employer_city
_436_archive_testing.encounters	enc_ins3_employer_city
_436_archive_testing.hl7_lab_locations	hll_city
_436_archive_testing.insurances	ins_city
_436_archive_testing.insurances_claims_centers	icc_city
_436_archive_testing.insurances_repository	irep_ins_employer_city
_436_archive_testing.locations	loc_city
_436_archive_testing.non_patients	npat_city
_436_archive_testing.orders	ord_city
_436_archive_testing.orders	ord_ins1_employer_city
_436_archive_testing.orders	ord_ins2_employer_city
_436_archive_testing.patient_next_of_kin	pnk_city
_436_archive_testing.patients	pat_city
_436_archive_testing.patients	pat_employer_city
_436_archive_testing.patients	pat_guarantor_city
_436_archive_testing.patients	pat_ins1_employer_city
_436_archive_testing.patients	pat_ins2_employer_city
_436_archive_testing.patients	pat_ins3_employer_city
_436_archive_testing.patients	pat_emergency_city
_436_archive_testing.patients_demographics_snapshots	pds_city
_436_archive_testing.patients_demographics_snapshots	pds_employer_city
_436_archive_testing.patients_demographics_snapshots	pds_guarantor_city
_436_archive_testing.patients_demographics_snapshots	pds_ins1_employer_city
_436_archive_testing.patients_demographics_snapshots	pds_ins2_employer_city
_436_archive_testing.patients_demographics_snapshots	pds_ins3_employer_city
_436_archive_testing.physicians	phy_city
_436_archive_testing.precerts	pre_city
_436_archive_testing.precerts	pre_employer_city
_436_archive_testing.precerts	pre_guarantor_city
_436_archive_testing.precerts	pre_ins1_employer_city
_436_archive_testing.precerts	pre_ins2_employer_city
_436_archive_testing.radiology_orders	rad_city
_436_archive_testing.radiology_orders	rad_ins1_employer_city
_436_archive_testing.radiology_orders	rad_ins2_employer_city
_437.billing_providers	bp_city
_437.buildings	bld_city
_437.charts	chrt_city
_437.client_contacts	clicon_city
_437.encounters	enc_city
_437.encounters	enc_employer_city
_437.encounters	enc_guarantor_city
_437.encounters	enc_ins1_employer_city
_437.encounters	enc_ins2_employer_city
_437.encounters	enc_ins3_employer_city
_437.hl7_lab_locations	hll_city
_437.insurances	ins_city
_437.insurances_claims_centers	icc_city
_437.insurances_repository	irep_ins_employer_city
_437.locations	loc_city
_437.non_patients	npat_city
_437.orders	ord_city
_437.orders	ord_ins1_employer_city
_437.orders	ord_ins2_employer_city
_437.patient_next_of_kin	pnk_city
_437.patients	pat_city
_437.patients	pat_employer_city
_437.patients	pat_guarantor_city
_437.patients	pat_ins1_employer_city
_437.patients	pat_ins2_employer_city
_437.patients	pat_ins3_employer_city
_437.patients	pat_emergency_city
_437.patients_demographics_snapshots	pds_city
_437.patients_demographics_snapshots	pds_employer_city
_437.patients_demographics_snapshots	pds_guarantor_city
_437.patients_demographics_snapshots	pds_ins1_employer_city
_437.patients_demographics_snapshots	pds_ins2_employer_city
_437.patients_demographics_snapshots	pds_ins3_employer_city
_437.physicians	phy_city
_437.precerts	pre_city
_437.precerts	pre_employer_city
_437.precerts	pre_guarantor_city
_437.precerts	pre_ins1_employer_city
_437.precerts	pre_ins2_employer_city
_437.radiology_orders	rad_city
_437.radiology_orders	rad_ins1_employer_city
_437.radiology_orders	rad_ins2_employer_city
_8.billing_providers	bp_city
_8.buildings	bld_city
_8.charts	chrt_city
_8.client_contacts	clicon_city
_8.encounters	enc_city
_8.encounters	enc_employer_city
_8.encounters	enc_guarantor_city
_8.encounters	enc_ins1_employer_city
_8.encounters	enc_ins2_employer_city
_8.encounters	enc_ins3_employer_city
_8.hl7_lab_locations	hll_city
_8.insurances	ins_city
_8.insurances_claims_centers	icc_city
_8.insurances_repository	irep_ins_employer_city
_8.locations	loc_city
_8.non_patients	npat_city
_8.orders	ord_city
_8.orders	ord_ins1_employer_city
_8.orders	ord_ins2_employer_city
_8.patient_next_of_kin	pnk_city
_8.patients	pat_city
_8.patients	pat_employer_city
_8.patients	pat_guarantor_city
_8.patients	pat_ins1_employer_city
_8.patients	pat_ins2_employer_city
_8.patients	pat_ins3_employer_city
_8.patients	pat_emergency_city
_8.patients_demographics_snapshots	pds_city
_8.patients_demographics_snapshots	pds_employer_city
_8.patients_demographics_snapshots	pds_guarantor_city
_8.patients_demographics_snapshots	pds_ins1_employer_city
_8.patients_demographics_snapshots	pds_ins2_employer_city
_8.patients_demographics_snapshots	pds_ins3_employer_city
_8.physicians	phy_city
_8.precerts	pre_city
_8.precerts	pre_employer_city
_8.precerts	pre_guarantor_city
_8.precerts	pre_ins1_employer_city
_8.precerts	pre_ins2_employer_city
_8.radiology_orders	rad_city
_8.radiology_orders	rad_ins1_employer_city
_8.radiology_orders	rad_ins2_employer_city
_81.billing_providers	bp_city
_81.buildings	bld_city
_81.charts	chrt_city
_81.client_contacts	clicon_city
_81.encounters	enc_city
_81.encounters	enc_employer_city
_81.encounters	enc_guarantor_city
_81.encounters	enc_ins1_employer_city
_81.encounters	enc_ins2_employer_city
_81.encounters	enc_ins3_employer_city
_81.hl7_lab_locations	hll_city
_81.insurances	ins_city
_81.insurances_claims_centers	icc_city
_81.insurances_repository	irep_ins_employer_city
_81.locations	loc_city
_81.non_patients	npat_city
_81.orders	ord_city
_81.orders	ord_ins1_employer_city
_81.orders	ord_ins2_employer_city
_81.patient_next_of_kin	pnk_city
_81.patients	pat_city
_81.patients	pat_employer_city
_81.patients	pat_guarantor_city
_81.patients	pat_ins1_employer_city
_81.patients	pat_ins2_employer_city
_81.patients	pat_ins3_employer_city
_81.patients	pat_emergency_city
_81.patients_demographics_snapshots	pds_city
_81.patients_demographics_snapshots	pds_employer_city
_81.patients_demographics_snapshots	pds_guarantor_city
_81.patients_demographics_snapshots	pds_ins1_employer_city
_81.patients_demographics_snapshots	pds_ins2_employer_city
_81.patients_demographics_snapshots	pds_ins3_employer_city
_81.physicians	phy_city
_81.precerts	pre_city
_81.precerts	pre_employer_city
_81.precerts	pre_guarantor_city
_81.precerts	pre_ins1_employer_city
_81.precerts	pre_ins2_employer_city
_81.radiology_orders	rad_city
_81.radiology_orders	rad_ins1_employer_city
_81.radiology_orders	rad_ins2_employer_city
_999.billing_providers	bp_city
_999.buildings	bld_city
_999.charts	chrt_city
_999.client_contacts	clicon_city
_999.encounters	enc_city
_999.encounters	enc_employer_city
_999.encounters	enc_guarantor_city
_999.encounters	enc_ins1_employer_city
_999.encounters	enc_ins2_employer_city
_999.encounters	enc_ins3_employer_city
_999.hl7_lab_locations	hll_city
_999.insurances	ins_city
_999.insurances_claims_centers	icc_city
_999.insurances_repository	irep_ins_employer_city
_999.locations	loc_city
_999.non_patients	npat_city
_999.orders	ord_city
_999.orders	ord_ins1_employer_city
_999.orders	ord_ins2_employer_city
_999.patient_next_of_kin	pnk_city
_999.patients	pat_city
_999.patients	pat_employer_city
_999.patients	pat_guarantor_city
_999.patients	pat_ins1_employer_city
_999.patients	pat_ins2_employer_city
_999.patients	pat_ins3_employer_city
_999.patients	pat_emergency_city
_999.patients_demographics_snapshots	pds_city
_999.patients_demographics_snapshots	pds_employer_city
_999.patients_demographics_snapshots	pds_guarantor_city
_999.patients_demographics_snapshots	pds_ins1_employer_city
_999.patients_demographics_snapshots	pds_ins2_employer_city
_999.patients_demographics_snapshots	pds_ins3_employer_city
_999.physicians	phy_city
_999.precerts	pre_city
_999.precerts	pre_employer_city
_999.precerts	pre_guarantor_city
_999.precerts	pre_ins1_employer_city
_999.precerts	pre_ins2_employer_city
_999.radiology_orders	rad_city
_999.radiology_orders	rad_ins1_employer_city
_999.radiology_orders	rad_ins2_employer_city
aurora_standard.abmmpi	p_city
aurora_standard.abmmpi	emp_city
aurora_standard.abmmpi	i1_city
aurora_standard.abmmpi	i2_city
aurora_standard.abmmpi	i3_city
aurora_standard.abmmpi	gu_city
aurora_standard.abmmpi	gu_emp_city
aurora_standard.abmmpi	n1_city
aurora_standard.abmmpi	n2_city
aurora_standard.abmvis	p_city
aurora_standard.abmvis	gu_city
aurora_standard.abmvis	i1_city
aurora_standard.abmvis	i2_city
aurora_standard.abmvis	i3_city
aurora_standard.anmpi	p_city
aurora_standard.apsmpi	p_city
aurora_standard.aseympi	p_city
aurora_standard.bdmpi	sp_city
aurora_standard.bdmpi	nk_city
aurora_standard.bdmpi	pat_city
aurora_standard.bempi	p_city
aurora_standard.bfhos	gu_city
aurora_standard.bfpasr	gu_city
aurora_standard.bfrhc	gu_city
aurora_standard.bhar	p_city
aurora_standard.bhar	g_city
aurora_standard.bhar	ge_city
aurora_standard.bhar	co1_city
aurora_standard.bhar	co2_city
aurora_standard.bhar	co3_city
aurora_standard.bhar	co4_city
aurora_standard.bhar	co5_city
aurora_standard.bhar	co6_city
aurora_standard.bhar	em_city
aurora_standard.bmmpi	p_city
aurora_standard.bmmpi	gu_city
aurora_standard.bmnkin	n_city
aurora_standard.bmpact	p_city
aurora_standard.bmpact	gu_city
aurora_standard.bpar	p_city
aurora_standard.bpar	g_city
aurora_standard.bpar	ge_city
aurora_standard.bpar	co1_city
aurora_standard.bpar	co2_city
aurora_standard.bpar	co3_city
aurora_standard.bpar	co4_city
aurora_standard.bpar	co5_city
aurora_standard.bpar	co6_city
aurora_standard.bpar	em_city
aurora_standard.bpar2	p_city
aurora_standard.bpar2	g_city
aurora_standard.bpar2	ge_city
aurora_standard.bpar2	co1_city
aurora_standard.bpar2	co2_city
aurora_standard.bpar2	co3_city
aurora_standard.bpar2	co4_city
aurora_standard.bpar2	co5_city
aurora_standard.bpar2	co6_city
aurora_standard.bpar2	em_city
aurora_standard.bpmpi	p_city
aurora_standard.bpmpi2	p_city
aurora_standard.bs2mpi	contact1_city
aurora_standard.bs2mpi	p_city
aurora_standard.bsinsur	spouse_city
aurora_standard.bsinsur	nextkin_city
aurora_standard.bsinsur	patient_city
aurora_standard.bsmpi	contact1_city
aurora_standard.bsmpi	p_city
aurora_standard.c7insur2	ins_city
aurora_standard.c7insur3	ins_city
aurora_standard.c7mpi	p_city
aurora_standard.c7mpi	p2_city
aurora_standard.c7mpi	insur_city
aurora_standard.c7mpi	gu_city
aurora_standard.c7mpi	gu2_city
aurora_standard.c8mpi	p_city
aurora_standard.campi	spouse_city
aurora_standard.campi	nextkin_city
aurora_standard.campi	patient_city
aurora_standard.chhl7adt	patient_city
aurora_standard.chhl7in1	ins_city
aurora_standard.chhl7in1	ins_empl_city
aurora_standard.chlswbhd	fac_city
aurora_standard.chlswbhd	agt_city
aurora_standard.chlswbhd	sfw_city
aurora_standard.chltrnhd	fac_city
aurora_standard.chltrnhd	agt_city
aurora_standard.chltrnhd	sfw_city
aurora_standard.chmarcnbf	g_city
aurora_standard.chmarcnbf	ins1_city
aurora_standard.chmarcnbf	ins2_city
aurora_standard.chmarsi	pat_city
aurora_standard.chmarsi	gu_city
aurora_standard.chmarsi	gu_emp_city
aurora_standard.chmarsi	pat_emp_city
aurora_standard.chmarsi	ins1_city
aurora_standard.chmarsi	ins1_empl_city
aurora_standard.chmarsi	ins2_city
aurora_standard.chmarsi	ins2_empl_city
aurora_standard.chmarsi	ins3_city
aurora_standard.chmarsi	ins3_empl_city
aurora_standard.chmarst	fac_city
aurora_standard.chmarsti	fac_city
aurora_standard.chmarstps	ins_city
aurora_standard.chmarstps	emp_city
aurora_standard.chmarstpt	ins_city
aurora_standard.chmarstpt	emp_city
aurora_standard.chmazstd	pat_city
aurora_standard.chmazsti	pat_city
aurora_standard.chmazsto	pat_city
aurora_standard.chmbatex	pat_city
aurora_standard.chmcampi	pat_city
aurora_standard.chmcampi	gu_city
aurora_standard.chmcampi	gu_emp_city
aurora_standard.chmcampi	pat_emp_city
aurora_standard.chmcampi	ins1_city
aurora_standard.chmcampi	ins1_empl_city
aurora_standard.chmcampi	ins2_city
aurora_standard.chmcampi	ins2_empl_city
aurora_standard.chmcampi	ins3_city
aurora_standard.chmcampi	ins3_empl_city
aurora_standard.chmcmhed	debtor_city
aurora_standard.chmcmhed	pat_city
aurora_standard.chmexmpi	pat_city
aurora_standard.chmexmpi	gu_city
aurora_standard.chmexmpi	gu_emp_city
aurora_standard.chmexmpi	pat_emp_city
aurora_standard.chmexmpi	ins1_city
aurora_standard.chmexmpi	ins1_empl_city
aurora_standard.chmexmpi	ins2_city
aurora_standard.chmexmpi	ins2_empl_city
aurora_standard.chmexmpi	ins3_city
aurora_standard.chmexmpi	ins3_empl_city
aurora_standard.chmexvis	ins1_city
aurora_standard.chmexvis	ins2_city
aurora_standard.chmexvis	ins3_city
aurora_standard.chmhistp	p_city
aurora_standard.chmibend	send_claims_city
aurora_standard.chmlastr	pat_city
aurora_standard.chmmbc35	facility_city
aurora_standard.chmmbc37	plan_carrier_city
aurora_standard.chmnvstb	prov_city
aurora_standard.chmnvstb	payto_city
aurora_standard.chmnvstr	prov_city
aurora_standard.chmnvstr	payto_city
aurora_standard.chmokipd	pat_city
aurora_standard.chmokopd	pat_city
aurora_standard.chmozpcd	debtor_city
aurora_standard.chmp340b	patient_city
aurora_standard.chmpatir	subscri_city
aurora_standard.chmpatmr	spouse_city
aurora_standard.chmpatmr	nextkin_city
aurora_standard.chmpatmr	patient_city
aurora_standard.chmpatwc	school_city
aurora_standard.chmpdemo	p_city
aurora_standard.chmpdemo	p_emp_city
aurora_standard.chmpdemo	sp_city
aurora_standard.chmpdemo	gu_city
aurora_standard.chmpdemo	gu_emp_city
aurora_standard.chmpdemo	ins1_city
aurora_standard.chmpdemo	ins1_empl_city
aurora_standard.chmpdemo	ins2_city
aurora_standard.chmpdemo	ins2_empl_city
aurora_standard.chmpdemo	ins3_city
aurora_standard.chmpdemo	ins3_empl_city
aurora_standard.chmpress	patient_city
aurora_standard.chmradex	pat_city
aurora_standard.chmradex	pat_emp_city
aurora_standard.chmradex	gu_city
aurora_standard.chmradex	gu_emp_city
aurora_standard.chmradex	ins1_city
aurora_standard.chmradex	ins1_empl_city
aurora_standard.chmradex	ins2_city
aurora_standard.chmradex	ins2_empl_city
aurora_standard.chmradex	ins3_city
aurora_standard.chmradex	ins3_empl_city
aurora_standard.chmtxstr	pat_city
aurora_standard.chmub04r	f_09_city
aurora_standard.chmub04r	l_38_4_city
aurora_standard.chmub92r	l_13_city
aurora_standard.chmub92r	l_38_4_city
aurora_standard.chmub92r	l_66_a_city
aurora_standard.chmub92r	l_66_b_city
aurora_standard.chmub92r	l_66_c_city
aurora_standard.chmutah4	pat_city
aurora_standard.chpdeped	depend_city
aurora_standard.nbspouse	spouse_city
aurora_standard.stp1099c	company_city
aurora_standard.stp1099c	vend_city
aurora_standard.stprepsd	rep_city
aurora_standard.stpvendr	agent_city
aurora_standard.styoctcc	employer_city
aurora_standard.styoctcc	gov_entity_city
aurora_standard.styoempr	empl_city
aurora_standard.tmpub04r	f_09_city
aurora_standard.tmpub04r	l_38_4_city
common.applicants	app_city
common.applicants	app_hs_city
common.applicants	app_c1_city
common.applicants	app_c2_city
common.applicants	app_gs_city
common.applicants	app_o1_city
common.applicants	app_o2_city
common.applicants	app_employer_1_city
common.applicants	app_employer_2_city
common.applicants	app_employer_3_city
common.applicants	app_employer_4_city
common.clients	cli_city
common.clients	cli_billing_city
common.clients	cli_mailing_city
common.clients_contract_data	ccd_payer_city
common.contacts	con_city
common.customers	cus_city
common.customers	cus_billing_city
common.lab_interfaces	lif_cli_city
common.lab_interfaces_performing_sites	lips_city
common.labs	lab_city
common.leads	lea_city
common.zipmap	zip_city
rcmroi.dev__sf_users	addr_city
rcmroi.prod__sf_users	addr_city
rcmroi.test__sf_users	addr_city

state

Table	Column
Azalea.employees	emp_state
AzaleaStats.pull_requests	pull_state
AzaleaStats.pull_requests_environments	pullenv_state
_1.appointments_requests	aptreq_state
_1.billing_providers	bp_state
_1.buildings	bld_state
_1.charts	chrt_state
_1.client_contacts	clicon_state
_1.encounters	enc_state
_1.encounters	enc_employer_state
_1.encounters	enc_guarantor_state
_1.encounters	enc_ins1_employer_state
_1.encounters	enc_ins2_employer_state
_1.encounters	enc_ins3_employer_state
_1.encounters	enc_auto_accident_state
_1.hl7_lab_locations	hll_state
_1.insurances	ins_state
_1.insurances_claims_centers	icc_state
_1.insurances_repository	irep_ins_employer_state
_1.locations	loc_state
_1.non_patients	npat_state
_1.orders	ord_state
_1.orders	ord_ins1_employer_state
_1.orders	ord_ins2_employer_state
_1.patient_next_of_kin	pnk_state
_1.patients	pat_state
_1.patients	pat_employer_state
_1.patients	pat_guarantor_state
_1.patients	pat_ins1_employer_state
_1.patients	pat_ins2_employer_state
_1.patients	pat_ins3_employer_state
_1.patients	pat_emergency_state
_1.patients_demographics_snapshots	pds_state
_1.patients_demographics_snapshots	pds_employer_state
_1.patients_demographics_snapshots	pds_guarantor_state
_1.patients_demographics_snapshots	pds_ins1_employer_state
_1.patients_demographics_snapshots	pds_ins2_employer_state
_1.patients_demographics_snapshots	pds_ins3_employer_state
_1.physicians	phy_state
_1.physicians_servicing_states	physs_state
_1.precerts	pre_state
_1.precerts	pre_employer_state
_1.precerts	pre_guarantor_state
_1.precerts	pre_ins1_employer_state
_1.precerts	pre_ins2_employer_state
_1.precerts	pre_auto_accident_state
_1.radiology_orders	rad_state
_1.radiology_orders	rad_ins1_employer_state
_1.radiology_orders	rad_ins2_employer_state
_1188.appointments_requests	aptreq_state
_1188.billing_providers	bp_state
_1188.buildings	bld_state
_1188.charts	chrt_state
_1188.client_contacts	clicon_state
_1188.encounters	enc_state
_1188.encounters	enc_employer_state
_1188.encounters	enc_guarantor_state
_1188.encounters	enc_ins1_employer_state
_1188.encounters	enc_ins2_employer_state
_1188.encounters	enc_ins3_employer_state
_1188.encounters	enc_auto_accident_state
_1188.hl7_lab_locations	hll_state
_1188.insurances	ins_state
_1188.insurances_claims_centers	icc_state
_1188.insurances_repository	irep_ins_employer_state
_1188.locations	loc_state
_1188.non_patients	npat_state
_1188.orders	ord_state
_1188.orders	ord_ins1_employer_state
_1188.orders	ord_ins2_employer_state
_1188.patient_next_of_kin	pnk_state
_1188.patients	pat_state
_1188.patients	pat_employer_state
_1188.patients	pat_guarantor_state
_1188.patients	pat_ins1_employer_state
_1188.patients	pat_ins2_employer_state
_1188.patients	pat_ins3_employer_state
_1188.patients	pat_emergency_state
_1188.patients_demographics_snapshots	pds_state
_1188.patients_demographics_snapshots	pds_employer_state
_1188.patients_demographics_snapshots	pds_guarantor_state
_1188.patients_demographics_snapshots	pds_ins1_employer_state
_1188.patients_demographics_snapshots	pds_ins2_employer_state
_1188.patients_demographics_snapshots	pds_ins3_employer_state
_1188.physicians	phy_state
_1188.physicians_servicing_states	physs_state
_1188.precerts	pre_state
_1188.precerts	pre_employer_state
_1188.precerts	pre_guarantor_state
_1188.precerts	pre_ins1_employer_state
_1188.precerts	pre_ins2_employer_state
_1188.precerts	pre_auto_accident_state
_1188.radiology_orders	rad_state
_1188.radiology_orders	rad_ins1_employer_state
_1188.radiology_orders	rad_ins2_employer_state
_1218.appointments_requests	aptreq_state
_1218.billing_providers	bp_state
_1218.buildings	bld_state
_1218.charts	chrt_state
_1218.client_contacts	clicon_state
_1218.encounters	enc_state
_1218.encounters	enc_employer_state
_1218.encounters	enc_guarantor_state
_1218.encounters	enc_ins1_employer_state
_1218.encounters	enc_ins2_employer_state
_1218.encounters	enc_ins3_employer_state
_1218.encounters	enc_auto_accident_state
_1218.hl7_lab_locations	hll_state
_1218.insurances	ins_state
_1218.insurances_claims_centers	icc_state
_1218.insurances_repository	irep_ins_employer_state
_1218.locations	loc_state
_1218.non_patients	npat_state
_1218.orders	ord_state
_1218.orders	ord_ins1_employer_state
_1218.orders	ord_ins2_employer_state
_1218.patient_next_of_kin	pnk_state
_1218.patients	pat_state
_1218.patients	pat_employer_state
_1218.patients	pat_guarantor_state
_1218.patients	pat_ins1_employer_state
_1218.patients	pat_ins2_employer_state
_1218.patients	pat_ins3_employer_state
_1218.patients	pat_emergency_state
_1218.patients_demographics_snapshots	pds_state
_1218.patients_demographics_snapshots	pds_employer_state
_1218.patients_demographics_snapshots	pds_guarantor_state
_1218.patients_demographics_snapshots	pds_ins1_employer_state
_1218.patients_demographics_snapshots	pds_ins2_employer_state
_1218.patients_demographics_snapshots	pds_ins3_employer_state
_1218.physicians	phy_state
_1218.physicians_servicing_states	physs_state
_1218.precerts	pre_state
_1218.precerts	pre_employer_state
_1218.precerts	pre_guarantor_state
_1218.precerts	pre_ins1_employer_state
_1218.precerts	pre_ins2_employer_state
_1218.precerts	pre_auto_accident_state
_1218.radiology_orders	rad_state
_1218.radiology_orders	rad_ins1_employer_state
_1218.radiology_orders	rad_ins2_employer_state
_1548.appointments_requests	aptreq_state
_1548.billing_providers	bp_state
_1548.buildings	bld_state
_1548.charts	chrt_state
_1548.client_contacts	clicon_state
_1548.encounters	enc_state
_1548.encounters	enc_employer_state
_1548.encounters	enc_guarantor_state
_1548.encounters	enc_ins1_employer_state
_1548.encounters	enc_ins2_employer_state
_1548.encounters	enc_ins3_employer_state
_1548.encounters	enc_auto_accident_state
_1548.hl7_lab_locations	hll_state
_1548.insurances	ins_state
_1548.insurances_claims_centers	icc_state
_1548.insurances_repository	irep_ins_employer_state
_1548.locations	loc_state
_1548.non_patients	npat_state
_1548.orders	ord_state
_1548.orders	ord_ins1_employer_state
_1548.orders	ord_ins2_employer_state
_1548.patient_next_of_kin	pnk_state
_1548.patients	pat_state
_1548.patients	pat_employer_state
_1548.patients	pat_guarantor_state
_1548.patients	pat_ins1_employer_state
_1548.patients	pat_ins2_employer_state
_1548.patients	pat_ins3_employer_state
_1548.patients	pat_emergency_state
_1548.patients_demographics_snapshots	pds_state
_1548.patients_demographics_snapshots	pds_employer_state
_1548.patients_demographics_snapshots	pds_guarantor_state
_1548.patients_demographics_snapshots	pds_ins1_employer_state
_1548.patients_demographics_snapshots	pds_ins2_employer_state
_1548.patients_demographics_snapshots	pds_ins3_employer_state
_1548.physicians	phy_state
_1548.physicians_servicing_states	physs_state
_1548.precerts	pre_state
_1548.precerts	pre_employer_state
_1548.precerts	pre_guarantor_state
_1548.precerts	pre_ins1_employer_state
_1548.precerts	pre_ins2_employer_state
_1548.precerts	pre_auto_accident_state
_1548.radiology_orders	rad_state
_1548.radiology_orders	rad_ins1_employer_state
_1548.radiology_orders	rad_ins2_employer_state
_435.appointments_requests	aptreq_state
_435.billing_providers	bp_state
_435.buildings	bld_state
_435.charts	chrt_state
_435.client_contacts	clicon_state
_435.encounters	enc_state
_435.encounters	enc_employer_state
_435.encounters	enc_guarantor_state
_435.encounters	enc_ins1_employer_state
_435.encounters	enc_ins2_employer_state
_435.encounters	enc_ins3_employer_state
_435.encounters	enc_auto_accident_state
_435.hl7_lab_locations	hll_state
_435.insurances	ins_state
_435.insurances_claims_centers	icc_state
_435.insurances_repository	irep_ins_employer_state
_435.locations	loc_state
_435.non_patients	npat_state
_435.orders	ord_state
_435.orders	ord_ins1_employer_state
_435.orders	ord_ins2_employer_state
_435.patient_next_of_kin	pnk_state
_435.patients	pat_state
_435.patients	pat_employer_state
_435.patients	pat_guarantor_state
_435.patients	pat_ins1_employer_state
_435.patients	pat_ins2_employer_state
_435.patients	pat_ins3_employer_state
_435.patients	pat_emergency_state
_435.patients_demographics_snapshots	pds_state
_435.patients_demographics_snapshots	pds_employer_state
_435.patients_demographics_snapshots	pds_guarantor_state
_435.patients_demographics_snapshots	pds_ins1_employer_state
_435.patients_demographics_snapshots	pds_ins2_employer_state
_435.patients_demographics_snapshots	pds_ins3_employer_state
_435.physicians	phy_state
_435.physicians_servicing_states	physs_state
_435.precerts	pre_state
_435.precerts	pre_employer_state
_435.precerts	pre_guarantor_state
_435.precerts	pre_ins1_employer_state
_435.precerts	pre_ins2_employer_state
_435.precerts	pre_auto_accident_state
_435.radiology_orders	rad_state
_435.radiology_orders	rad_ins1_employer_state
_435.radiology_orders	rad_ins2_employer_state
_436.appointments_requests	aptreq_state
_436.billing_providers	bp_state
_436.buildings	bld_state
_436.charts	chrt_state
_436.client_contacts	clicon_state
_436.encounters	enc_state
_436.encounters	enc_employer_state
_436.encounters	enc_guarantor_state
_436.encounters	enc_ins1_employer_state
_436.encounters	enc_ins2_employer_state
_436.encounters	enc_ins3_employer_state
_436.encounters	enc_auto_accident_state
_436.hl7_lab_locations	hll_state
_436.insurances	ins_state
_436.insurances_claims_centers	icc_state
_436.insurances_repository	irep_ins_employer_state
_436.locations	loc_state
_436.non_patients	npat_state
_436.orders	ord_state
_436.orders	ord_ins1_employer_state
_436.orders	ord_ins2_employer_state
_436.patient_next_of_kin	pnk_state
_436.patients	pat_state
_436.patients	pat_employer_state
_436.patients	pat_guarantor_state
_436.patients	pat_ins1_employer_state
_436.patients	pat_ins2_employer_state
_436.patients	pat_ins3_employer_state
_436.patients	pat_emergency_state
_436.patients_demographics_snapshots	pds_state
_436.patients_demographics_snapshots	pds_employer_state
_436.patients_demographics_snapshots	pds_guarantor_state
_436.patients_demographics_snapshots	pds_ins1_employer_state
_436.patients_demographics_snapshots	pds_ins2_employer_state
_436.patients_demographics_snapshots	pds_ins3_employer_state
_436.physicians	phy_state
_436.physicians_servicing_states	physs_state
_436.precerts	pre_state
_436.precerts	pre_employer_state
_436.precerts	pre_guarantor_state
_436.precerts	pre_ins1_employer_state
_436.precerts	pre_ins2_employer_state
_436.precerts	pre_auto_accident_state
_436.radiology_orders	rad_state
_436.radiology_orders	rad_ins1_employer_state
_436.radiology_orders	rad_ins2_employer_state
_436_archive_testing.appointments_requests	aptreq_state
_436_archive_testing.billing_providers	bp_state
_436_archive_testing.buildings	bld_state
_436_archive_testing.charts	chrt_state
_436_archive_testing.client_contacts	clicon_state
_436_archive_testing.encounters	enc_state
_436_archive_testing.encounters	enc_employer_state
_436_archive_testing.encounters	enc_guarantor_state
_436_archive_testing.encounters	enc_ins1_employer_state
_436_archive_testing.encounters	enc_ins2_employer_state
_436_archive_testing.encounters	enc_ins3_employer_state
_436_archive_testing.encounters	enc_auto_accident_state
_436_archive_testing.hl7_lab_locations	hll_state
_436_archive_testing.insurances	ins_state
_436_archive_testing.insurances_claims_centers	icc_state
_436_archive_testing.insurances_repository	irep_ins_employer_state
_436_archive_testing.locations	loc_state
_436_archive_testing.non_patients	npat_state
_436_archive_testing.orders	ord_state
_436_archive_testing.orders	ord_ins1_employer_state
_436_archive_testing.orders	ord_ins2_employer_state
_436_archive_testing.patient_next_of_kin	pnk_state
_436_archive_testing.patients	pat_state
_436_archive_testing.patients	pat_employer_state
_436_archive_testing.patients	pat_guarantor_state
_436_archive_testing.patients	pat_ins1_employer_state
_436_archive_testing.patients	pat_ins2_employer_state
_436_archive_testing.patients	pat_ins3_employer_state
_436_archive_testing.patients	pat_emergency_state
_436_archive_testing.patients_demographics_snapshots	pds_state
_436_archive_testing.patients_demographics_snapshots	pds_employer_state
_436_archive_testing.patients_demographics_snapshots	pds_guarantor_state
_436_archive_testing.patients_demographics_snapshots	pds_ins1_employer_state
_436_archive_testing.patients_demographics_snapshots	pds_ins2_employer_state
_436_archive_testing.patients_demographics_snapshots	pds_ins3_employer_state
_436_archive_testing.physicians	phy_state
_436_archive_testing.physicians_servicing_states	physs_state
_436_archive_testing.precerts	pre_state
_436_archive_testing.precerts	pre_employer_state
_436_archive_testing.precerts	pre_guarantor_state
_436_archive_testing.precerts	pre_ins1_employer_state
_436_archive_testing.precerts	pre_ins2_employer_state
_436_archive_testing.precerts	pre_auto_accident_state
_436_archive_testing.radiology_orders	rad_state
_436_archive_testing.radiology_orders	rad_ins1_employer_state
_436_archive_testing.radiology_orders	rad_ins2_employer_state
_437.appointments_requests	aptreq_state
_437.billing_providers	bp_state
_437.buildings	bld_state
_437.charts	chrt_state
_437.client_contacts	clicon_state
_437.encounters	enc_state
_437.encounters	enc_employer_state
_437.encounters	enc_guarantor_state
_437.encounters	enc_ins1_employer_state
_437.encounters	enc_ins2_employer_state
_437.encounters	enc_ins3_employer_state
_437.encounters	enc_auto_accident_state
_437.hl7_lab_locations	hll_state
_437.insurances	ins_state
_437.insurances_claims_centers	icc_state
_437.insurances_repository	irep_ins_employer_state
_437.locations	loc_state
_437.non_patients	npat_state
_437.orders	ord_state
_437.orders	ord_ins1_employer_state
_437.orders	ord_ins2_employer_state
_437.patient_next_of_kin	pnk_state
_437.patients	pat_state
_437.patients	pat_employer_state
_437.patients	pat_guarantor_state
_437.patients	pat_ins1_employer_state
_437.patients	pat_ins2_employer_state
_437.patients	pat_ins3_employer_state
_437.patients	pat_emergency_state
_437.patients_demographics_snapshots	pds_state
_437.patients_demographics_snapshots	pds_employer_state
_437.patients_demographics_snapshots	pds_guarantor_state
_437.patients_demographics_snapshots	pds_ins1_employer_state
_437.patients_demographics_snapshots	pds_ins2_employer_state
_437.patients_demographics_snapshots	pds_ins3_employer_state
_437.physicians	phy_state
_437.physicians_servicing_states	physs_state
_437.precerts	pre_state
_437.precerts	pre_employer_state
_437.precerts	pre_guarantor_state
_437.precerts	pre_ins1_employer_state
_437.precerts	pre_ins2_employer_state
_437.precerts	pre_auto_accident_state
_437.radiology_orders	rad_state
_437.radiology_orders	rad_ins1_employer_state
_437.radiology_orders	rad_ins2_employer_state
_8.appointments_requests	aptreq_state
_8.billing_providers	bp_state
_8.buildings	bld_state
_8.charts	chrt_state
_8.client_contacts	clicon_state
_8.encounters	enc_state
_8.encounters	enc_employer_state
_8.encounters	enc_guarantor_state
_8.encounters	enc_ins1_employer_state
_8.encounters	enc_ins2_employer_state
_8.encounters	enc_ins3_employer_state
_8.encounters	enc_auto_accident_state
_8.hl7_lab_locations	hll_state
_8.insurances	ins_state
_8.insurances_claims_centers	icc_state
_8.insurances_repository	irep_ins_employer_state
_8.locations	loc_state
_8.non_patients	npat_state
_8.orders	ord_state
_8.orders	ord_ins1_employer_state
_8.orders	ord_ins2_employer_state
_8.patient_next_of_kin	pnk_state
_8.patients	pat_state
_8.patients	pat_employer_state
_8.patients	pat_guarantor_state
_8.patients	pat_ins1_employer_state
_8.patients	pat_ins2_employer_state
_8.patients	pat_ins3_employer_state
_8.patients	pat_emergency_state
_8.patients_demographics_snapshots	pds_state
_8.patients_demographics_snapshots	pds_employer_state
_8.patients_demographics_snapshots	pds_guarantor_state
_8.patients_demographics_snapshots	pds_ins1_employer_state
_8.patients_demographics_snapshots	pds_ins2_employer_state
_8.patients_demographics_snapshots	pds_ins3_employer_state
_8.physicians	phy_state
_8.physicians_servicing_states	physs_state
_8.precerts	pre_state
_8.precerts	pre_employer_state
_8.precerts	pre_guarantor_state
_8.precerts	pre_ins1_employer_state
_8.precerts	pre_ins2_employer_state
_8.precerts	pre_auto_accident_state
_8.radiology_orders	rad_state
_8.radiology_orders	rad_ins1_employer_state
_8.radiology_orders	rad_ins2_employer_state
_81.appointments_requests	aptreq_state
_81.billing_providers	bp_state
_81.buildings	bld_state
_81.charts	chrt_state
_81.client_contacts	clicon_state
_81.encounters	enc_state
_81.encounters	enc_employer_state
_81.encounters	enc_guarantor_state
_81.encounters	enc_ins1_employer_state
_81.encounters	enc_ins2_employer_state
_81.encounters	enc_ins3_employer_state
_81.encounters	enc_auto_accident_state
_81.hl7_lab_locations	hll_state
_81.insurances	ins_state
_81.insurances_claims_centers	icc_state
_81.insurances_repository	irep_ins_employer_state
_81.locations	loc_state
_81.non_patients	npat_state
_81.orders	ord_state
_81.orders	ord_ins1_employer_state
_81.orders	ord_ins2_employer_state
_81.patient_next_of_kin	pnk_state
_81.patients	pat_state
_81.patients	pat_employer_state
_81.patients	pat_guarantor_state
_81.patients	pat_ins1_employer_state
_81.patients	pat_ins2_employer_state
_81.patients	pat_ins3_employer_state
_81.patients	pat_emergency_state
_81.patients_demographics_snapshots	pds_state
_81.patients_demographics_snapshots	pds_employer_state
_81.patients_demographics_snapshots	pds_guarantor_state
_81.patients_demographics_snapshots	pds_ins1_employer_state
_81.patients_demographics_snapshots	pds_ins2_employer_state
_81.patients_demographics_snapshots	pds_ins3_employer_state
_81.physicians	phy_state
_81.physicians_servicing_states	physs_state
_81.precerts	pre_state
_81.precerts	pre_employer_state
_81.precerts	pre_guarantor_state
_81.precerts	pre_ins1_employer_state
_81.precerts	pre_ins2_employer_state
_81.precerts	pre_auto_accident_state
_81.radiology_orders	rad_state
_81.radiology_orders	rad_ins1_employer_state
_81.radiology_orders	rad_ins2_employer_state
_999.appointments_requests	aptreq_state
_999.billing_providers	bp_state
_999.buildings	bld_state
_999.charts	chrt_state
_999.client_contacts	clicon_state
_999.encounters	enc_state
_999.encounters	enc_employer_state
_999.encounters	enc_guarantor_state
_999.encounters	enc_ins1_employer_state
_999.encounters	enc_ins2_employer_state
_999.encounters	enc_ins3_employer_state
_999.encounters	enc_auto_accident_state
_999.hl7_lab_locations	hll_state
_999.insurances	ins_state
_999.insurances_claims_centers	icc_state
_999.insurances_repository	irep_ins_employer_state
_999.locations	loc_state
_999.non_patients	npat_state
_999.orders	ord_state
_999.orders	ord_ins1_employer_state
_999.orders	ord_ins2_employer_state
_999.patient_next_of_kin	pnk_state
_999.patients	pat_state
_999.patients	pat_employer_state
_999.patients	pat_guarantor_state
_999.patients	pat_ins1_employer_state
_999.patients	pat_ins2_employer_state
_999.patients	pat_ins3_employer_state
_999.patients	pat_emergency_state
_999.patients_demographics_snapshots	pds_state
_999.patients_demographics_snapshots	pds_employer_state
_999.patients_demographics_snapshots	pds_guarantor_state
_999.patients_demographics_snapshots	pds_ins1_employer_state
_999.patients_demographics_snapshots	pds_ins2_employer_state
_999.patients_demographics_snapshots	pds_ins3_employer_state
_999.physicians	phy_state
_999.physicians_servicing_states	physs_state
_999.precerts	pre_state
_999.precerts	pre_employer_state
_999.precerts	pre_guarantor_state
_999.precerts	pre_ins1_employer_state
_999.precerts	pre_ins2_employer_state
_999.precerts	pre_auto_accident_state
_999.radiology_orders	rad_state
_999.radiology_orders	rad_ins1_employer_state
_999.radiology_orders	rad_ins2_employer_state
aurora_standard.afcsum2	in_state
aurora_standard.bdmpi	sp_state
aurora_standard.bsinsur	spouse_state
aurora_standard.bsinsur	nextkin_state
aurora_standard.bsinsur	patient_state
aurora_standard.campi	spouse_state
aurora_standard.campi	nextkin_state
aurora_standard.campi	patient_state
aurora_standard.chhl7adt	patient_state
aurora_standard.chhl7in1	ins_empl_state
aurora_standard.chltrand	oral_state
aurora_standard.chmarcnbf	g_state
aurora_standard.chmarst	fac_state
aurora_standard.chmarsti	fac_state
aurora_standard.chmarstps	ins_state
aurora_standard.chmarstps	emp_state
aurora_standard.chmarstpt	ins_state
aurora_standard.chmarstpt	emp_state
aurora_standard.chmcmhed	debtor_state
aurora_standard.chmcmhed	pat_state
aurora_standard.chmmbc35	facility_state
aurora_standard.chmmbc37	plan_carrier_state
aurora_standard.chmmbc55	accident_state
aurora_standard.chmmrhdr	upd_state
aurora_standard.chmozpcd	debtor_state
aurora_standard.chmp340b	patient_state
aurora_standard.chmpatir	subscri_state
aurora_standard.chmpatmr	spouse_state
aurora_standard.chmpatmr	nextkin_state
aurora_standard.chmpatmr	patient_state
aurora_standard.chmpress	patient_state
aurora_standard.chmub04r	l_38_4_state
aurora_standard.chmub92r	l_13_state
aurora_standard.chmub92r	l_38_4_state
aurora_standard.chmub92r	l_66_a_state
aurora_standard.chmub92r	l_66_b_state
aurora_standard.chmub92r	l_66_c_state
aurora_standard.chmutah4	pat_state
aurora_standard.chpdeped	depend_state
aurora_standard.chqlicnd	lic_state
aurora_standard.nbspouse	spouse_state
aurora_standard.ohoemadd	added_state
aurora_standard.stp1099c	company_state
aurora_standard.stp1099c	vend_state
aurora_standard.stp1099c	fed_state
aurora_standard.stprepsd	rep_state
aurora_standard.stpvendr	agent_state
aurora_standard.styoctcc	employer_state
aurora_standard.styoctcc	gov_entity_state
aurora_standard.styoempr	empl_state
aurora_standard.stytimod	work_state
aurora_standard.tmpub04r	l_38_4_state
aurora_standard.vend	city_state
common.applicants	app_state
common.applicants	app_hs_state
common.applicants	app_c1_state
common.applicants	app_c2_state
common.applicants	app_gs_state
common.applicants	app_o1_state
common.applicants	app_o2_state
common.applicants	app_employer_1_state
common.applicants	app_employer_2_state
common.applicants	app_employer_3_state
common.applicants	app_employer_4_state
common.clients	cli_state
common.clients	cli_billing_state
common.clients	cli_mailing_state
common.clients_contract_data	ccd_payer_state
common.contacts	con_state
common.customers	cus_state
common.customers	cus_billing_state
common.hl7_discharge_codes	hdc_state
common.lab_interfaces	lif_cli_state
common.lab_interfaces_performing_sites	lips_state
common.labs	lab_state
common.leads	lea_state
common.poverty_guidelines	povg_state
common.vaccine_funding_program_eligibility_codes	vfpe_state
common.zipmap	zip_state
rcmroi.dev__sf_users	addr_state
rcmroi.prod__sf_users	addr_state
rcmroi.test__sf_users	addr_state

zip

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

country

Table	Column
aurora_standard.abmmpi	p_country
aurora_standard.abmmpi	i1_country
aurora_standard.abmmpi	i2_country
aurora_standard.abmmpi	i3_country
aurora_standard.abmvis	i1_country
aurora_standard.abmvis	i2_country
aurora_standard.abmvis	i3_country
aurora_standard.bs2mpi	p_country
aurora_standard.bsmpi	p_country
aurora_standard.c7mpi	p_country
aurora_standard.c7mpi	p2_country
aurora_standard.c7mpi	insur_country
aurora_standard.c7mpi	gu_country
aurora_standard.c7mpi	gu2_country
aurora_standard.chmazstd	pat_country
aurora_standard.chmazsti	pat_country
aurora_standard.chmazsto	pat_country
aurora_standard.chmub04r	f_09_country
aurora_standard.stxmtaxr	mtax_country
aurora_standard.styoctcc	employer_country
aurora_standard.styoempr	empl_country
aurora_standard.tmpub04r	f_09_country
rcmroi.dev__sf_users	addr_country
rcmroi.prod__sf_users	addr_country
rcmroi.test__sf_users	addr_country

contact

Table	Column
aurora_standard.bhphybak	suspend_contact
aurora_standard.chmadmid	ins_cert_contact
aurora_standard.chmhl7ic	company_contact
aurora_standard.chmphync	suspend_contact
aurora_standard.stp1099c	vend_contact
aurora_standard.stppucnt	purch_contact
aurora_standard.styoctcc	gov_entity_contact_phone
aurora_standard.visit_insurances	ins_cert_contact
common.applicants	app_employer_1_contact
common.applicants	app_employer_2_contact
common.applicants	app_employer_3_contact
common.applicants	app_employer_4_contact
common.clients	cli_contact
common.clients_contract_data	ccd_payer_contact
common.customers	cus_contact
common.leads	lea_contact

comm_code

Table	Column
aurora_standard.chrdrugc	default_comm_code

taxable

Table	Column
aurora_standard.oddpayre	inc_taxable
aurora_standard.odhpayre	inc_taxable
aurora_standard.stpinvce	internet_taxable
aurora_standard.stpopend	internet_taxable
aurora_standard.stuinvce	internet_taxable
aurora_standard.stypayre	inc_taxable