aurora_standard.stoordre

Field	Type	Null	Key	Extra
doc_no	int(11)	YES	UNI
orig_doc_no	int(11)	YES
order_no	varchar(10)	YES	MUL
inv_doc_no	int(11)	YES
inv_no	varchar(10)	YES
po_no	varchar(24)	YES
pic_ticket_no	smallint(6)	YES
next_kit_group	smallint(6)	YES
ack_printed	varchar(1)	YES
order_type	varchar(3)	YES
like_type	varchar(3)	YES
order_status	varchar(3)	YES
hi_stage	varchar(3)	YES
lo_stage	varchar(3)	YES
bo_allowed	varchar(1)	YES
recur_unit	varchar(1)	YES
recur_every	smallint(6)	YES
recur_times	smallint(6)	YES
recur_through	date	YES
prev_recur	date	YES
next_recur	date	YES
num_releases	smallint(6)	YES
release_type	varchar(3)	YES
order_date	date	YES
to_ship_date	date	YES
alloc_date	date	YES
ship_date	date	YES
complete_date	date	YES
warehouse_code	varchar(10)	YES
department	varchar(3)	YES
sls_psn_code	varchar(6)	YES
cust_code	varchar(6)	YES	MUL
ship_to_code	varchar(6)	YES
bill_to_code	varchar(6)	YES
bus_name	varchar(30)	YES
contact	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
terms_code	varchar(6)	YES
terms_approval	varchar(6)	YES
pay_method	varchar(6)	YES
payment	varchar(1)	YES
card_no	varchar(20)	YES
exp_date	varchar(5)	YES
card_holder	varchar(20)	YES
check_no	varchar(8)	YES
trd_ds_code	varchar(6)	YES
trd_ds_type	varchar(1)	YES
trd_ds_rate	decimal(6,0)	YES
multi_shipto	varchar(1)	YES
tax_rate	decimal(6,0)	YES
staging_area	varchar(6)	YES
fob_point	varchar(15)	YES
ship_via	varchar(15)	YES
ship_weight	decimal(10,0)	YES
item_amount	decimal(12,0)	YES
discountable	decimal(12,0)	YES
trd_ds_amount	decimal(12,0)	YES
taxable	decimal(12,0)	YES
tax_amount	decimal(12,0)	YES
frght_amount	decimal(12,0)	YES
total_amount	decimal(12,0)	YES
create_date	date	YES
create_time	varchar(8)	YES
create_id	varchar(8)	YES
l_mod_date	date	YES
l_mod_time	varchar(8)	YES
l_mod_id	varchar(8)	YES
system_order	varchar(1)	YES
spr_no	varchar(7)	YES
cust_ord_date	date	YES
cust_po_date	date	YES
fact_ack_date	date	YES
fact_rec_date	date	YES
moto_rec_date	date	YES
sent_to_wwop	varchar(1)	YES
mtaxg_code	varchar(6)	YES
intl_order	varchar(1)	YES
intl_lic_no	varchar(30)	YES
currency_code	varchar(3)	YES
curr_rate_type	varchar(6)	YES
currency_rate	decimal(16,0)	YES
edi_sent	varchar(1)	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

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

order_status

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

payment

Table	Column
HSPI_CURES2015_B1.ipf_response	federal_payment
HSPI_Central_Hospital.ipf_response	federal_payment
HSPI_Dewitt.ipf_response	federal_payment
HSPI_Fulton.ipf_response	federal_payment
HSPI_Inferno.ipf_response	federal_payment
HSPI_MU2015_E1.ipf_response	federal_payment
HSPI_MU2015_G2.ipf_response	federal_payment
HSPI_MU2015_G9.ipf_response	federal_payment
HSPI_Sandbox.ipf_response	federal_payment
HSPI_Summit_General.ipf_response	federal_payment
HSPI_United_Physicians.ipf_response	federal_payment
MPI.ipf_response	federal_payment
_1.billing_codes	bil_patient_payment
_1.encounters_payments	epay_bil_id_payment
_1188.billing_codes	bil_patient_payment
_1188.encounters_payments	epay_bil_id_payment
_1218.billing_codes	bil_patient_payment
_1218.encounters_payments	epay_bil_id_payment
_1548.billing_codes	bil_patient_payment
_1548.encounters_payments	epay_bil_id_payment
_435.billing_codes	bil_patient_payment
_435.encounters_payments	epay_bil_id_payment
_436.billing_codes	bil_patient_payment
_436.encounters_payments	epay_bil_id_payment
_436_archive_testing.billing_codes	bil_patient_payment
_436_archive_testing.encounters_payments	epay_bil_id_payment
_437.billing_codes	bil_patient_payment
_437.encounters_payments	epay_bil_id_payment
_8.billing_codes	bil_patient_payment
_8.daily_close_calculations	dcc_found_unapplied_payment
_8.daily_close_calculations	dcc_bil_patient_payment
_8.encounters_payments	epay_bil_id_payment
_81.billing_codes	bil_patient_payment
_81.encounters_payments	epay_bil_id_payment
_999.billing_codes	bil_patient_payment
_999.encounters_payments	epay_bil_id_payment
aurora_standard.chmblogd	lab_payment
aurora_standard.chmcontc	timely_payment
aurora_standard.chmcontr	down_payment
aurora_standard.chmmbc50	source_of_payment
aurora_standard.chmplogd	lab_payment
aurora_standard.logdetld	lab_payment
aurora_standard.stxratid	principal_payment
common.billing_codes	bil_patient_payment

create_date

Table	Column
_1.configured_encounters	confenc_create_date
_1548.configured_encounters	confenc_create_date
_435.configured_encounters	confenc_create_date
_436.configured_encounters	confenc_create_date
_436_archive_testing.configured_encounters	confenc_create_date
_437.configured_encounters	confenc_create_date
_8.configured_encounters	confenc_create_date
_999.configured_encounters	confenc_create_date

exp_date

Table	Column
_1.patients_payment_methods	patpm_exp_date
_1188.patients_payment_methods	patpm_exp_date
_1218.patients_payment_methods	patpm_exp_date
_1548.patients_payment_methods	patpm_exp_date
_435.patients_payment_methods	patpm_exp_date
_436.patients_payment_methods	patpm_exp_date
_436_archive_testing.patients_payment_methods	patpm_exp_date
_437.patients_payment_methods	patpm_exp_date
_8.patients_payment_methods	patpm_exp_date
_81.patients_payment_methods	patpm_exp_date
_999.patients_payment_methods	patpm_exp_date
aurora_standard.bhphybak	dea_exp_date
aurora_standard.c8phy	dea_exp_date
aurora_standard.chmphync	dea_exp_date
aurora_standard.chpempid	license_exp_date
aurora_standard.chqcardd	cardiac_exp_date
aurora_standard.chqliabd	liab_pol_exp_date
aurora_standard.chqlicnd	lic_exp_date
aurora_standard.chqphync	brd_cert_exp_date
aurora_standard.vault_providers	dea_exp_date

order_type

Table	Column
_1.physician_order_delegations	phyod_order_type
_1188.physician_order_delegations	phyod_order_type
_1218.physician_order_delegations	phyod_order_type
_1548.physician_order_delegations	phyod_order_type
_435.physician_order_delegations	phyod_order_type
_436.physician_order_delegations	phyod_order_type
_436_archive_testing.physician_order_delegations	phyod_order_type
_437.physician_order_delegations	phyod_order_type
_8.physician_order_delegations	phyod_order_type
_81.physician_order_delegations	phyod_order_type
_999.physician_order_delegations	phyod_order_type

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

doc_no

Table	Column
aurora_standard.audpadjd	py_doc_no
aurora_standard.chmgltrc	ar_doc_no
aurora_standard.chmgltrc	rm_doc_no
aurora_standard.chmgltrc	ip_doc_no
aurora_standard.chmgltrc	op_doc_no
aurora_standard.chmgltrc	r3_doc_no
aurora_standard.chmgltrc	r4_doc_no
aurora_standard.chmgltrc	cr_doc_no
aurora_standard.chmgltrc	aj_doc_no
aurora_standard.chmgltrc	nr_doc_no
aurora_standard.chmgltrc	nc_doc_no
aurora_standard.chmgltrc	fc_doc_no
aurora_standard.chmpadjd	py_doc_no
aurora_standard.chmrefnd	check_doc_no
aurora_standard.discounts	inv_doc_no
aurora_standard.odhpaydd	py_doc_no
aurora_standard.odhpayid	py_doc_no
aurora_standard.odhpayod	py_doc_no
aurora_standard.odhpayre	py_doc_no
aurora_standard.stfcntrc	fa_doc_no
aurora_standard.stgcntrc	genjrn_doc_no
aurora_standard.stgcntrc	stdent_doc_no
aurora_standard.sticstvr	rec_doc_no
aurora_standard.stoinvce	inv_doc_no
aurora_standard.stoshipd	inv_doc_no
aurora_standard.stoshipd	po_doc_no
aurora_standard.stpactvd	inv_doc_no
aurora_standard.stpactvv	inv_doc_no
aurora_standard.stpcashd	inv_doc_no
aurora_standard.stpcntrc	ap_doc_no
aurora_standard.stpcntrc	cd_doc_no
aurora_standard.stpvoidr	chk_doc_no
aurora_standard.stractvd	inv_doc_no
aurora_standard.stractvv	inv_doc_no
aurora_standard.strcashd	inv_doc_no
aurora_standard.strcntrc	ar_doc_no
aurora_standard.strcntrc	cr_doc_no
aurora_standard.stucntrc	req_doc_no
aurora_standard.stucntrc	po_doc_no
aurora_standard.stucntrc	rec_doc_no
aurora_standard.stucntrc	inv_doc_no
aurora_standard.stucntrc	ret_doc_no
aurora_standard.stuinvcd	inv_doc_no
aurora_standard.stuinvcd	po_doc_no
aurora_standard.stuinvce	inv_doc_no
aurora_standard.stuinvce	po_doc_no
aurora_standard.stuordrd	order_doc_no
aurora_standard.stuordre	orig_doc_no
aurora_standard.stuordre	order_doc_no
aurora_standard.stuprche	inv_doc_no
aurora_standard.sturectd	rec_doc_no
aurora_standard.sturectd	po_doc_no
aurora_standard.sturecte	rec_doc_no
aurora_standard.sturecte	po_doc_no
aurora_standard.sturqstd	po_doc_no
aurora_standard.sturqstd	ref_doc_no
aurora_standard.sturtrnd	ret_doc_no
aurora_standard.sturtrnd	po_doc_no
aurora_standard.sturtrnd	rec_doc_no
aurora_standard.sturtrnd	inv_doc_no
aurora_standard.sturtrne	ret_doc_no
aurora_standard.stxmtaxd	inv_doc_no
aurora_standard.stxtaxld	inv_doc_no
aurora_standard.stycdedd	py_doc_no
aurora_standard.stycincd	py_doc_no
aurora_standard.stycntrc	py_doc_no
aurora_standard.stypayar	py_doc_no
aurora_standard.stypddrd	py_doc_no
aurora_standard.styvoide	pay_doc_no

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

order_no

Table	Column
aurora_standard.chmpintr	rx_order_no

department

Table	Column
aurora_standard.curs_temp	cash_department
aurora_standard.sticntrc	use_department
aurora_standard.stpcashd	dist_department
aurora_standard.stpcashd	disc_department
aurora_standard.stpcashe	cash_department
aurora_standard.stpcashe	oa_department
aurora_standard.stpinvce	disc_department
aurora_standard.stpinvce	ap_department
aurora_standard.stpinvce	cash_department
aurora_standard.stpopend	ap_department
aurora_standard.stpopend	cash_department
aurora_standard.stpvendr	cash_department
aurora_standard.stpvendr	exp_department
aurora_standard.strcashd	dist_department
aurora_standard.strcashd	disc_department
aurora_standard.strcashe	cash_department
aurora_standard.strcashe	oa_department
aurora_standard.strinvce	disc_department
aurora_standard.strinvce	tax_department
aurora_standard.strinvce	frght_department
aurora_standard.strinvce	misc_department
aurora_standard.strinvce	ar_department
aurora_standard.stropend	ar_department
aurora_standard.stucntrc	use_department
aurora_standard.styapckd	dist_department
aurora_standard.stydeddv	home_department
aurora_standard.stydeddv	gl_department
aurora_standard.styincdv	home_department
aurora_standard.styincdv	gl_department
aurora_standard.styobldv	home_department
aurora_standard.styobldv	gl_department
aurora_standard.styptodv	home_department
common.service_tickets	stc_department

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

po_no

Table	Column
aurora_standard.stoordrd	our_po_no
aurora_standard.stpinchd	old_po_no
aurora_standard.stpinchd	new_po_no
aurora_standard.stuabcd	part_po_no
aurora_standard.stuabcd	full_po_no

ship_date

Table	Column
aurora_standard.stoshipd	proj_ship_date
aurora_standard.stoshipd	actual_ship_date

inv_no

Table	Column
aurora_standard.stpinchd	old_inv_no
aurora_standard.stpinchd	new_inv_no
aurora_standard.strcntrc	last_inv_no

card_no

Table	Column
aurora_standard.stpvendr	credit_card_no
aurora_standard.styrtimd	rec_card_no
aurora_standard.styrtime	rec_card_no

order_date

Table	Column
aurora_standard.strcustr	last_order_date

currency_code

Table	Column
aurora_standard.stxdcrtr	from_currency_code
aurora_standard.stxdcrtr	to_currency_code
aurora_standard.stxpcrtr	from_currency_code
aurora_standard.stxpcrtr	to_currency_code

tax_rate

Table	Column
aurora_standard.stystwhr	fed_tax_rate

total_amount

Table	Column
common.rcm_stats_aging	rcmsa_total_amount