aurora_standard.bdemplr

Field Type Null Default Key Extra Comment
co_no bigint(20) unsigned NO PRI auto_increment
co_name char(20) YES
address_1 char(30) YES
address_2 char(20) YES
city char(20) YES
state_init char(2) YES
zip_1 char(10) YES
area_cd char(10) YES
phone char(20) YES

References

Local Column References
phone
TableColumn
Azalea.employeesemp_phone
EFaxes.efax_accountsefaxacc_phone
_1.billing_providersbp_phone
_1.chartschrt_phone
_1.client_contactsclicon_primary_phone
_1.cpoe_responsescpoe_res_phone
_1.donorsdon_phone
_1.encountersenc_phone
_1.encountersenc_guarantor_phone
_1.examplesexa_phone
_1.hl7_accessionsacc_phone
_1.hl7_lab_locationshll_phone
_1.insurancesins_phone
_1.insurances_claims_centersicc_phone
_1.locationsloc_phone
_1.non_patientsnpat_phone
_1.ordersord_phone
_1.patient_next_of_kinpnk_phone
_1.patientspat_phone
_1.patientspat_guarantor_phone
_1.patients_demographics_snapshotspds_phone
_1.patients_demographics_snapshotspds_guarantor_phone
_1.physiciansphy_phone
_1.precertspre_phone
_1.precertspre_guarantor_phone
_1.radiology_ordersrad_phone
_1.radiology_resultsrad_res_phone
_1188.billing_providersbp_phone
_1188.chartschrt_phone
_1188.client_contactsclicon_primary_phone
_1188.cpoe_responsescpoe_res_phone
_1188.donorsdon_phone
_1188.encountersenc_phone
_1188.encountersenc_guarantor_phone
_1188.examplesexa_phone
_1188.hl7_accessionsacc_phone
_1188.hl7_lab_locationshll_phone
_1188.insurancesins_phone
_1188.insurances_claims_centersicc_phone
_1188.locationsloc_phone
_1188.non_patientsnpat_phone
_1188.ordersord_phone
_1188.patient_next_of_kinpnk_phone
_1188.patientspat_phone
_1188.patientspat_guarantor_phone
_1188.patients_demographics_snapshotspds_phone
_1188.patients_demographics_snapshotspds_guarantor_phone
_1188.physiciansphy_phone
_1188.precertspre_phone
_1188.precertspre_guarantor_phone
_1188.radiology_ordersrad_phone
_1188.radiology_resultsrad_res_phone
_1218.billing_providersbp_phone
_1218.chartschrt_phone
_1218.client_contactsclicon_primary_phone
_1218.cpoe_responsescpoe_res_phone
_1218.donorsdon_phone
_1218.encountersenc_phone
_1218.encountersenc_guarantor_phone
_1218.examplesexa_phone
_1218.hl7_accessionsacc_phone
_1218.hl7_lab_locationshll_phone
_1218.insurancesins_phone
_1218.insurances_claims_centersicc_phone
_1218.locationsloc_phone
_1218.non_patientsnpat_phone
_1218.ordersord_phone
_1218.patient_next_of_kinpnk_phone
_1218.patientspat_phone
_1218.patientspat_guarantor_phone
_1218.patients_demographics_snapshotspds_phone
_1218.patients_demographics_snapshotspds_guarantor_phone
_1218.physiciansphy_phone
_1218.precertspre_phone
_1218.precertspre_guarantor_phone
_1218.radiology_ordersrad_phone
_1218.radiology_resultsrad_res_phone
_1548.billing_providersbp_phone
_1548.chartschrt_phone
_1548.client_contactsclicon_primary_phone
_1548.cpoe_responsescpoe_res_phone
_1548.donorsdon_phone
_1548.encountersenc_phone
_1548.encountersenc_guarantor_phone
_1548.examplesexa_phone
_1548.hl7_accessionsacc_phone
_1548.hl7_lab_locationshll_phone
_1548.insurancesins_phone
_1548.insurances_claims_centersicc_phone
_1548.locationsloc_phone
_1548.non_patientsnpat_phone
_1548.ordersord_phone
_1548.patient_next_of_kinpnk_phone
_1548.patientspat_phone
_1548.patientspat_guarantor_phone
_1548.patients_demographics_snapshotspds_phone
_1548.patients_demographics_snapshotspds_guarantor_phone
_1548.physiciansphy_phone
_1548.precertspre_phone
_1548.precertspre_guarantor_phone
_1548.radiology_ordersrad_phone
_1548.radiology_resultsrad_res_phone
_435.billing_providersbp_phone
_435.chartschrt_phone
_435.client_contactsclicon_primary_phone
_435.cpoe_responsescpoe_res_phone
_435.donorsdon_phone
_435.encountersenc_phone
_435.encountersenc_guarantor_phone
_435.examplesexa_phone
_435.hl7_accessionsacc_phone
_435.hl7_lab_locationshll_phone
_435.insurancesins_phone
_435.insurances_claims_centersicc_phone
_435.locationsloc_phone
_435.non_patientsnpat_phone
_435.ordersord_phone
_435.patient_next_of_kinpnk_phone
_435.patientspat_phone
_435.patientspat_guarantor_phone
_435.patients_demographics_snapshotspds_phone
_435.patients_demographics_snapshotspds_guarantor_phone
_435.physiciansphy_phone
_435.precertspre_phone
_435.precertspre_guarantor_phone
_435.radiology_ordersrad_phone
_435.radiology_resultsrad_res_phone
_436.billing_providersbp_phone
_436.chartschrt_phone
_436.client_contactsclicon_primary_phone
_436.cpoe_responsescpoe_res_phone
_436.donorsdon_phone
_436.encountersenc_phone
_436.encountersenc_guarantor_phone
_436.examplesexa_phone
_436.hl7_accessionsacc_phone
_436.hl7_lab_locationshll_phone
_436.insurancesins_phone
_436.insurances_claims_centersicc_phone
_436.locationsloc_phone
_436.non_patientsnpat_phone
_436.ordersord_phone
_436.patient_next_of_kinpnk_phone
_436.patientspat_phone
_436.patientspat_guarantor_phone
_436.patients_demographics_snapshotspds_phone
_436.patients_demographics_snapshotspds_guarantor_phone
_436.physiciansphy_phone
_436.precertspre_phone
_436.precertspre_guarantor_phone
_436.radiology_ordersrad_phone
_436.radiology_resultsrad_res_phone
_436_archive_testing.billing_providersbp_phone
_436_archive_testing.chartschrt_phone
_436_archive_testing.client_contactsclicon_primary_phone
_436_archive_testing.cpoe_responsescpoe_res_phone
_436_archive_testing.donorsdon_phone
_436_archive_testing.encountersenc_phone
_436_archive_testing.encountersenc_guarantor_phone
_436_archive_testing.examplesexa_phone
_436_archive_testing.hl7_accessionsacc_phone
_436_archive_testing.hl7_lab_locationshll_phone
_436_archive_testing.insurancesins_phone
_436_archive_testing.insurances_claims_centersicc_phone
_436_archive_testing.locationsloc_phone
_436_archive_testing.non_patientsnpat_phone
_436_archive_testing.ordersord_phone
_436_archive_testing.patient_next_of_kinpnk_phone
_436_archive_testing.patientspat_phone
_436_archive_testing.patientspat_guarantor_phone
_436_archive_testing.patients_demographics_snapshotspds_phone
_436_archive_testing.patients_demographics_snapshotspds_guarantor_phone
_436_archive_testing.physiciansphy_phone
_436_archive_testing.precertspre_phone
_436_archive_testing.precertspre_guarantor_phone
_436_archive_testing.radiology_ordersrad_phone
_436_archive_testing.radiology_resultsrad_res_phone
_437.billing_providersbp_phone
_437.chartschrt_phone
_437.client_contactsclicon_primary_phone
_437.cpoe_responsescpoe_res_phone
_437.donorsdon_phone
_437.encountersenc_phone
_437.encountersenc_guarantor_phone
_437.examplesexa_phone
_437.hl7_accessionsacc_phone
_437.hl7_lab_locationshll_phone
_437.insurancesins_phone
_437.insurances_claims_centersicc_phone
_437.locationsloc_phone
_437.non_patientsnpat_phone
_437.ordersord_phone
_437.patient_next_of_kinpnk_phone
_437.patientspat_phone
_437.patientspat_guarantor_phone
_437.patients_demographics_snapshotspds_phone
_437.patients_demographics_snapshotspds_guarantor_phone
_437.physiciansphy_phone
_437.precertspre_phone
_437.precertspre_guarantor_phone
_437.radiology_ordersrad_phone
_437.radiology_resultsrad_res_phone
_8.billing_providersbp_phone
_8.chartschrt_phone
_8.client_contactsclicon_primary_phone
_8.cpoe_responsescpoe_res_phone
_8.donorsdon_phone
_8.encountersenc_phone
_8.encountersenc_guarantor_phone
_8.examplesexa_phone
_8.hl7_accessionsacc_phone
_8.hl7_lab_locationshll_phone
_8.insurancesins_phone
_8.insurances_claims_centersicc_phone
_8.locationsloc_phone
_8.non_patientsnpat_phone
_8.ordersord_phone
_8.patient_next_of_kinpnk_phone
_8.patientspat_phone
_8.patientspat_guarantor_phone
_8.patients_demographics_snapshotspds_phone
_8.patients_demographics_snapshotspds_guarantor_phone
_8.physiciansphy_phone
_8.precertspre_phone
_8.precertspre_guarantor_phone
_8.radiology_ordersrad_phone
_8.radiology_resultsrad_res_phone
_81.billing_providersbp_phone
_81.chartschrt_phone
_81.client_contactsclicon_primary_phone
_81.cpoe_responsescpoe_res_phone
_81.donorsdon_phone
_81.encountersenc_phone
_81.encountersenc_guarantor_phone
_81.examplesexa_phone
_81.hl7_accessionsacc_phone
_81.hl7_lab_locationshll_phone
_81.insurancesins_phone
_81.insurances_claims_centersicc_phone
_81.locationsloc_phone
_81.non_patientsnpat_phone
_81.ordersord_phone
_81.patient_next_of_kinpnk_phone
_81.patientspat_phone
_81.patientspat_guarantor_phone
_81.patients_demographics_snapshotspds_phone
_81.patients_demographics_snapshotspds_guarantor_phone
_81.physiciansphy_phone
_81.precertspre_phone
_81.precertspre_guarantor_phone
_81.radiology_ordersrad_phone
_81.radiology_resultsrad_res_phone
_999.billing_providersbp_phone
_999.chartschrt_phone
_999.client_contactsclicon_primary_phone
_999.cpoe_responsescpoe_res_phone
_999.donorsdon_phone
_999.encountersenc_phone
_999.encountersenc_guarantor_phone
_999.examplesexa_phone
_999.hl7_accessionsacc_phone
_999.hl7_lab_locationshll_phone
_999.insurancesins_phone
_999.insurances_claims_centersicc_phone
_999.locationsloc_phone
_999.non_patientsnpat_phone
_999.ordersord_phone
_999.patient_next_of_kinpnk_phone
_999.patientspat_phone
_999.patientspat_guarantor_phone
_999.patients_demographics_snapshotspds_phone
_999.patients_demographics_snapshotspds_guarantor_phone
_999.physiciansphy_phone
_999.precertspre_phone
_999.precertspre_guarantor_phone
_999.radiology_ordersrad_phone
_999.radiology_resultsrad_res_phone
aurora_standard.bdmpisp_phone
aurora_standard.bfinsrcprecert_phone
aurora_standard.bfrhcgu_phone
aurora_standard.bharp_phone
aurora_standard.bharg_phone
aurora_standard.bharge_phone
aurora_standard.bharem_phone
aurora_standard.bhguaremp_phone
aurora_standard.bhphybakhome_phone
aurora_standard.bhphybakoffice_phone
aurora_standard.bhphybakcellular_phone
aurora_standard.bhphybakpage_phone
aurora_standard.bhtguaremp_phone
aurora_standard.bmmpip_phone
aurora_standard.bmnkinn_phone
aurora_standard.bmnkinnw_phone
aurora_standard.bmnkinnc_phone
aurora_standard.bmpactp_phone
aurora_standard.bparp_phone
aurora_standard.bparg_phone
aurora_standard.bparge_phone
aurora_standard.bparem_phone
aurora_standard.bpar2p_phone
aurora_standard.bpar2g_phone
aurora_standard.bpar2ge_phone
aurora_standard.bpar2em_phone
aurora_standard.bpmpip_phone
aurora_standard.bpmpi2p_phone
aurora_standard.bsinsurspouse_phone
aurora_standard.bsinsurnextkin_phone
aurora_standard.bsinsurpatient_phone
aurora_standard.bsinsurpat_emp_phone
aurora_standard.bsinsurpat_cell_phone
aurora_standard.bsinsursp_cell_phone
aurora_standard.bsinsurnk_cell_phone
aurora_standard.bvguarwork_phone
aurora_standard.bvmpiwork_phone
aurora_standard.bvmpi2work_phone
aurora_standard.bwphyncoffice_phone
aurora_standard.c5insrcprecert_phone
aurora_standard.c5insrcdrprecert_phone
aurora_standard.c7insur2ins_phone
aurora_standard.c7insur3ins_phone
aurora_standard.c8mpip_phone
aurora_standard.c8phyhome_phone
aurora_standard.c8phyoffice_phone
aurora_standard.c8phycellular_phone
aurora_standard.c8phypage_phone
aurora_standard.cainsrcprecert_phone
aurora_standard.cainsrc2precert_phone
aurora_standard.campispouse_phone
aurora_standard.campisp_cell_phone
aurora_standard.campinextkin_phone
aurora_standard.campink_cell_phone
aurora_standard.campipatient_phone
aurora_standard.campipat_emp_phone
aurora_standard.campipat_cell_phone
aurora_standard.caphyoffice_phone
aurora_standard.caphynchm_phone
aurora_standard.caphyncwk_phone
aurora_standard.caphynccell_phone
aurora_standard.chlswbhdfac_phone
aurora_standard.chlswbhdagt_phone
aurora_standard.chlswbhdsfw_phone
aurora_standard.chltrnhdfac_phone
aurora_standard.chltrnhdagt_phone
aurora_standard.chltrnhdsfw_phone
aurora_standard.chmadmwcref_phone
aurora_standard.chmarcnbfg_phone
aurora_standard.chmarcnbfg_emp_phone
aurora_standard.chmarcnbfins1_phone
aurora_standard.chmarcnbfins2_phone
aurora_standard.chmarsipat_phone
aurora_standard.chmarsigu_phone
aurora_standard.chmarsipat_emp_phone
aurora_standard.chmarsisp_phone
aurora_standard.chmarstfac_phone
aurora_standard.chmarstifac_phone
aurora_standard.chmcampipat_phone
aurora_standard.chmcampigu_phone
aurora_standard.chmcampipat_emp_phone
aurora_standard.chmcampisp_phone
aurora_standard.chmcmheddebtor_phone
aurora_standard.chmcmhedpat_phone
aurora_standard.chmcostapat_phone
aurora_standard.chmemplrother_phone
aurora_standard.chmescptcontact_phone
aurora_standard.chmexmpipat_phone
aurora_standard.chmexmpigu_phone
aurora_standard.chmexmpipat_emp_phone
aurora_standard.chmexmpisp_phone
aurora_standard.chmguarrgu_emp_phone
aurora_standard.chmhistpp_phone
aurora_standard.chmhl7iccompany_phone
aurora_standard.chminsrcprecert_phone
aurora_standard.chmnvstbprov_phone
aurora_standard.chmnvstrprov_phone
aurora_standard.chmozpcddebtor_phone
aurora_standard.chmozpcdbank_phone
aurora_standard.chmpatmrspouse_phone
aurora_standard.chmpatmrnextkin_phone
aurora_standard.chmpatmrpatient_phone
aurora_standard.chmpatmrpat_emp_phone
aurora_standard.chmpatmrpat_cell_phone
aurora_standard.chmpatmrsp_cell_phone
aurora_standard.chmpatmrnk_cell_phone
aurora_standard.chmpatwcmom_phone
aurora_standard.chmpatwcdad_phone
aurora_standard.chmpdemop_phone
aurora_standard.chmpdemop_emp_phone
aurora_standard.chmpdemosp_phone
aurora_standard.chmpdemogu_phone
aurora_standard.chmpdemoins1_phone
aurora_standard.chmpdemoins2_phone
aurora_standard.chmpdemoins3_phone
aurora_standard.chmphynchome_phone
aurora_standard.chmphyncoffice_phone
aurora_standard.chmphynccellular_phone
aurora_standard.chmphyncpage_phone
aurora_standard.chmradexpat_phone
aurora_standard.chmradexpat_emp_phone
aurora_standard.chmradexgu_phone
aurora_standard.chmradexsp_phone
aurora_standard.chpcardccontact_phone
aurora_standard.chpcarddcontact_phone
aurora_standard.chpcempron_call_phone
aurora_standard.chpcntrceduc_phone
aurora_standard.chpemerdwork_phone
aurora_standard.chpemerdhome_phone
aurora_standard.chpemerdother_phone
aurora_standard.chpinsucprecert_phone
aurora_standard.chppersron_call_phone
aurora_standard.chppersrcell_phone
aurora_standard.chshotlrother_phone
aurora_standard.cuphynchome_phone
aurora_standard.cuphyncoffice_phone
aurora_standard.nbspousespouse_phone
aurora_standard.ohoemplrhome_phone
aurora_standard.stp1099ccontact_phone
aurora_standard.stp1099cvend_phone
aurora_standard.stppytorfax_phone
aurora_standard.stprepsdrep_phone
aurora_standard.stpvendrfax_phone
aurora_standard.stpvendragent_phone
aurora_standard.strcustrfax_phone
aurora_standard.styoctcccontact_phone
aurora_standard.styoctccgov_entity_contact_phone
aurora_standard.styuimmrcont_phone
aurora_standard.styw2mm1cont_phone
aurora_standard.vault_providershome_phone
aurora_standard.vault_providersoffice_phone
aurora_standard.vault_providerscell_phone
common.applicantsapp_phone
common.applicantsapp_cell_phone
common.applicantsapp_employer_1_phone
common.applicantsapp_employer_2_phone
common.applicantsapp_employer_3_phone
common.applicantsapp_employer_4_phone
common.applicantsapp_reference_1_phone
common.applicantsapp_reference_2_phone
common.applicantsapp_reference_3_phone
common.applicantsapp_reference_4_phone
common.clients_contract_dataccd_payer_phone
common.contact_importsci_phone
common.fax_accountsfxa_phone
common.lab_interfaces_performing_siteslips_phone
common.leadslea_phone
common.sfax_accountssfax_acc_phone
common.usersusr_cell_phone
rcmroi.dev__sf_usersmobile_phone
rcmroi.prod__sf_usersmobile_phone
rcmroi.test__sf_usersmobile_phone
city
TableColumn
Azalea.employeesemp_city
_1.billing_providersbp_city
_1.buildingsbld_city
_1.chartschrt_city
_1.client_contactsclicon_city
_1.encountersenc_city
_1.encountersenc_employer_city
_1.encountersenc_guarantor_city
_1.encountersenc_ins1_employer_city
_1.encountersenc_ins2_employer_city
_1.encountersenc_ins3_employer_city
_1.hl7_lab_locationshll_city
_1.insurancesins_city
_1.insurances_claims_centersicc_city
_1.insurances_repositoryirep_ins_employer_city
_1.locationsloc_city
_1.non_patientsnpat_city
_1.ordersord_city
_1.ordersord_ins1_employer_city
_1.ordersord_ins2_employer_city
_1.patient_next_of_kinpnk_city
_1.patientspat_city
_1.patientspat_employer_city
_1.patientspat_guarantor_city
_1.patientspat_ins1_employer_city
_1.patientspat_ins2_employer_city
_1.patientspat_ins3_employer_city
_1.patientspat_emergency_city
_1.patients_demographics_snapshotspds_city
_1.patients_demographics_snapshotspds_employer_city
_1.patients_demographics_snapshotspds_guarantor_city
_1.patients_demographics_snapshotspds_ins1_employer_city
_1.patients_demographics_snapshotspds_ins2_employer_city
_1.patients_demographics_snapshotspds_ins3_employer_city
_1.physiciansphy_city
_1.precertspre_city
_1.precertspre_employer_city
_1.precertspre_guarantor_city
_1.precertspre_ins1_employer_city
_1.precertspre_ins2_employer_city
_1.radiology_ordersrad_city
_1.radiology_ordersrad_ins1_employer_city
_1.radiology_ordersrad_ins2_employer_city
_1188.billing_providersbp_city
_1188.buildingsbld_city
_1188.chartschrt_city
_1188.client_contactsclicon_city
_1188.encountersenc_city
_1188.encountersenc_employer_city
_1188.encountersenc_guarantor_city
_1188.encountersenc_ins1_employer_city
_1188.encountersenc_ins2_employer_city
_1188.encountersenc_ins3_employer_city
_1188.hl7_lab_locationshll_city
_1188.insurancesins_city
_1188.insurances_claims_centersicc_city
_1188.insurances_repositoryirep_ins_employer_city
_1188.locationsloc_city
_1188.non_patientsnpat_city
_1188.ordersord_city
_1188.ordersord_ins1_employer_city
_1188.ordersord_ins2_employer_city
_1188.patient_next_of_kinpnk_city
_1188.patientspat_city
_1188.patientspat_employer_city
_1188.patientspat_guarantor_city
_1188.patientspat_ins1_employer_city
_1188.patientspat_ins2_employer_city
_1188.patientspat_ins3_employer_city
_1188.patientspat_emergency_city
_1188.patients_demographics_snapshotspds_city
_1188.patients_demographics_snapshotspds_employer_city
_1188.patients_demographics_snapshotspds_guarantor_city
_1188.patients_demographics_snapshotspds_ins1_employer_city
_1188.patients_demographics_snapshotspds_ins2_employer_city
_1188.patients_demographics_snapshotspds_ins3_employer_city
_1188.physiciansphy_city
_1188.precertspre_city
_1188.precertspre_employer_city
_1188.precertspre_guarantor_city
_1188.precertspre_ins1_employer_city
_1188.precertspre_ins2_employer_city
_1188.radiology_ordersrad_city
_1188.radiology_ordersrad_ins1_employer_city
_1188.radiology_ordersrad_ins2_employer_city
_1218.billing_providersbp_city
_1218.buildingsbld_city
_1218.chartschrt_city
_1218.client_contactsclicon_city
_1218.encountersenc_city
_1218.encountersenc_employer_city
_1218.encountersenc_guarantor_city
_1218.encountersenc_ins1_employer_city
_1218.encountersenc_ins2_employer_city
_1218.encountersenc_ins3_employer_city
_1218.hl7_lab_locationshll_city
_1218.insurancesins_city
_1218.insurances_claims_centersicc_city
_1218.insurances_repositoryirep_ins_employer_city
_1218.locationsloc_city
_1218.non_patientsnpat_city
_1218.ordersord_city
_1218.ordersord_ins1_employer_city
_1218.ordersord_ins2_employer_city
_1218.patient_next_of_kinpnk_city
_1218.patientspat_city
_1218.patientspat_employer_city
_1218.patientspat_guarantor_city
_1218.patientspat_ins1_employer_city
_1218.patientspat_ins2_employer_city
_1218.patientspat_ins3_employer_city
_1218.patientspat_emergency_city
_1218.patients_demographics_snapshotspds_city
_1218.patients_demographics_snapshotspds_employer_city
_1218.patients_demographics_snapshotspds_guarantor_city
_1218.patients_demographics_snapshotspds_ins1_employer_city
_1218.patients_demographics_snapshotspds_ins2_employer_city
_1218.patients_demographics_snapshotspds_ins3_employer_city
_1218.physiciansphy_city
_1218.precertspre_city
_1218.precertspre_employer_city
_1218.precertspre_guarantor_city
_1218.precertspre_ins1_employer_city
_1218.precertspre_ins2_employer_city
_1218.radiology_ordersrad_city
_1218.radiology_ordersrad_ins1_employer_city
_1218.radiology_ordersrad_ins2_employer_city
_1548.billing_providersbp_city
_1548.buildingsbld_city
_1548.chartschrt_city
_1548.client_contactsclicon_city
_1548.encountersenc_city
_1548.encountersenc_employer_city
_1548.encountersenc_guarantor_city
_1548.encountersenc_ins1_employer_city
_1548.encountersenc_ins2_employer_city
_1548.encountersenc_ins3_employer_city
_1548.hl7_lab_locationshll_city
_1548.insurancesins_city
_1548.insurances_claims_centersicc_city
_1548.insurances_repositoryirep_ins_employer_city
_1548.locationsloc_city
_1548.non_patientsnpat_city
_1548.ordersord_city
_1548.ordersord_ins1_employer_city
_1548.ordersord_ins2_employer_city
_1548.patient_next_of_kinpnk_city
_1548.patientspat_city
_1548.patientspat_employer_city
_1548.patientspat_guarantor_city
_1548.patientspat_ins1_employer_city
_1548.patientspat_ins2_employer_city
_1548.patientspat_ins3_employer_city
_1548.patientspat_emergency_city
_1548.patients_demographics_snapshotspds_city
_1548.patients_demographics_snapshotspds_employer_city
_1548.patients_demographics_snapshotspds_guarantor_city
_1548.patients_demographics_snapshotspds_ins1_employer_city
_1548.patients_demographics_snapshotspds_ins2_employer_city
_1548.patients_demographics_snapshotspds_ins3_employer_city
_1548.physiciansphy_city
_1548.precertspre_city
_1548.precertspre_employer_city
_1548.precertspre_guarantor_city
_1548.precertspre_ins1_employer_city
_1548.precertspre_ins2_employer_city
_1548.radiology_ordersrad_city
_1548.radiology_ordersrad_ins1_employer_city
_1548.radiology_ordersrad_ins2_employer_city
_435.billing_providersbp_city
_435.buildingsbld_city
_435.chartschrt_city
_435.client_contactsclicon_city
_435.encountersenc_city
_435.encountersenc_employer_city
_435.encountersenc_guarantor_city
_435.encountersenc_ins1_employer_city
_435.encountersenc_ins2_employer_city
_435.encountersenc_ins3_employer_city
_435.hl7_lab_locationshll_city
_435.insurancesins_city
_435.insurances_claims_centersicc_city
_435.insurances_repositoryirep_ins_employer_city
_435.locationsloc_city
_435.non_patientsnpat_city
_435.ordersord_city
_435.ordersord_ins1_employer_city
_435.ordersord_ins2_employer_city
_435.patient_next_of_kinpnk_city
_435.patientspat_city
_435.patientspat_employer_city
_435.patientspat_guarantor_city
_435.patientspat_ins1_employer_city
_435.patientspat_ins2_employer_city
_435.patientspat_ins3_employer_city
_435.patientspat_emergency_city
_435.patients_demographics_snapshotspds_city
_435.patients_demographics_snapshotspds_employer_city
_435.patients_demographics_snapshotspds_guarantor_city
_435.patients_demographics_snapshotspds_ins1_employer_city
_435.patients_demographics_snapshotspds_ins2_employer_city
_435.patients_demographics_snapshotspds_ins3_employer_city
_435.physiciansphy_city
_435.precertspre_city
_435.precertspre_employer_city
_435.precertspre_guarantor_city
_435.precertspre_ins1_employer_city
_435.precertspre_ins2_employer_city
_435.radiology_ordersrad_city
_435.radiology_ordersrad_ins1_employer_city
_435.radiology_ordersrad_ins2_employer_city
_436.billing_providersbp_city
_436.buildingsbld_city
_436.chartschrt_city
_436.client_contactsclicon_city
_436.encountersenc_city
_436.encountersenc_employer_city
_436.encountersenc_guarantor_city
_436.encountersenc_ins1_employer_city
_436.encountersenc_ins2_employer_city
_436.encountersenc_ins3_employer_city
_436.hl7_lab_locationshll_city
_436.insurancesins_city
_436.insurances_claims_centersicc_city
_436.insurances_repositoryirep_ins_employer_city
_436.locationsloc_city
_436.non_patientsnpat_city
_436.ordersord_city
_436.ordersord_ins1_employer_city
_436.ordersord_ins2_employer_city
_436.patient_next_of_kinpnk_city
_436.patientspat_city
_436.patientspat_employer_city
_436.patientspat_guarantor_city
_436.patientspat_ins1_employer_city
_436.patientspat_ins2_employer_city
_436.patientspat_ins3_employer_city
_436.patientspat_emergency_city
_436.patients_demographics_snapshotspds_city
_436.patients_demographics_snapshotspds_employer_city
_436.patients_demographics_snapshotspds_guarantor_city
_436.patients_demographics_snapshotspds_ins1_employer_city
_436.patients_demographics_snapshotspds_ins2_employer_city
_436.patients_demographics_snapshotspds_ins3_employer_city
_436.physiciansphy_city
_436.precertspre_city
_436.precertspre_employer_city
_436.precertspre_guarantor_city
_436.precertspre_ins1_employer_city
_436.precertspre_ins2_employer_city
_436.radiology_ordersrad_city
_436.radiology_ordersrad_ins1_employer_city
_436.radiology_ordersrad_ins2_employer_city
_436_archive_testing.billing_providersbp_city
_436_archive_testing.buildingsbld_city
_436_archive_testing.chartschrt_city
_436_archive_testing.client_contactsclicon_city
_436_archive_testing.encountersenc_city
_436_archive_testing.encountersenc_employer_city
_436_archive_testing.encountersenc_guarantor_city
_436_archive_testing.encountersenc_ins1_employer_city
_436_archive_testing.encountersenc_ins2_employer_city
_436_archive_testing.encountersenc_ins3_employer_city
_436_archive_testing.hl7_lab_locationshll_city
_436_archive_testing.insurancesins_city
_436_archive_testing.insurances_claims_centersicc_city
_436_archive_testing.insurances_repositoryirep_ins_employer_city
_436_archive_testing.locationsloc_city
_436_archive_testing.non_patientsnpat_city
_436_archive_testing.ordersord_city
_436_archive_testing.ordersord_ins1_employer_city
_436_archive_testing.ordersord_ins2_employer_city
_436_archive_testing.patient_next_of_kinpnk_city
_436_archive_testing.patientspat_city
_436_archive_testing.patientspat_employer_city
_436_archive_testing.patientspat_guarantor_city
_436_archive_testing.patientspat_ins1_employer_city
_436_archive_testing.patientspat_ins2_employer_city
_436_archive_testing.patientspat_ins3_employer_city
_436_archive_testing.patientspat_emergency_city
_436_archive_testing.patients_demographics_snapshotspds_city
_436_archive_testing.patients_demographics_snapshotspds_employer_city
_436_archive_testing.patients_demographics_snapshotspds_guarantor_city
_436_archive_testing.patients_demographics_snapshotspds_ins1_employer_city
_436_archive_testing.patients_demographics_snapshotspds_ins2_employer_city
_436_archive_testing.patients_demographics_snapshotspds_ins3_employer_city
_436_archive_testing.physiciansphy_city
_436_archive_testing.precertspre_city
_436_archive_testing.precertspre_employer_city
_436_archive_testing.precertspre_guarantor_city
_436_archive_testing.precertspre_ins1_employer_city
_436_archive_testing.precertspre_ins2_employer_city
_436_archive_testing.radiology_ordersrad_city
_436_archive_testing.radiology_ordersrad_ins1_employer_city
_436_archive_testing.radiology_ordersrad_ins2_employer_city
_437.billing_providersbp_city
_437.buildingsbld_city
_437.chartschrt_city
_437.client_contactsclicon_city
_437.encountersenc_city
_437.encountersenc_employer_city
_437.encountersenc_guarantor_city
_437.encountersenc_ins1_employer_city
_437.encountersenc_ins2_employer_city
_437.encountersenc_ins3_employer_city
_437.hl7_lab_locationshll_city
_437.insurancesins_city
_437.insurances_claims_centersicc_city
_437.insurances_repositoryirep_ins_employer_city
_437.locationsloc_city
_437.non_patientsnpat_city
_437.ordersord_city
_437.ordersord_ins1_employer_city
_437.ordersord_ins2_employer_city
_437.patient_next_of_kinpnk_city
_437.patientspat_city
_437.patientspat_employer_city
_437.patientspat_guarantor_city
_437.patientspat_ins1_employer_city
_437.patientspat_ins2_employer_city
_437.patientspat_ins3_employer_city
_437.patientspat_emergency_city
_437.patients_demographics_snapshotspds_city
_437.patients_demographics_snapshotspds_employer_city
_437.patients_demographics_snapshotspds_guarantor_city
_437.patients_demographics_snapshotspds_ins1_employer_city
_437.patients_demographics_snapshotspds_ins2_employer_city
_437.patients_demographics_snapshotspds_ins3_employer_city
_437.physiciansphy_city
_437.precertspre_city
_437.precertspre_employer_city
_437.precertspre_guarantor_city
_437.precertspre_ins1_employer_city
_437.precertspre_ins2_employer_city
_437.radiology_ordersrad_city
_437.radiology_ordersrad_ins1_employer_city
_437.radiology_ordersrad_ins2_employer_city
_8.billing_providersbp_city
_8.buildingsbld_city
_8.chartschrt_city
_8.client_contactsclicon_city
_8.encountersenc_city
_8.encountersenc_employer_city
_8.encountersenc_guarantor_city
_8.encountersenc_ins1_employer_city
_8.encountersenc_ins2_employer_city
_8.encountersenc_ins3_employer_city
_8.hl7_lab_locationshll_city
_8.insurancesins_city
_8.insurances_claims_centersicc_city
_8.insurances_repositoryirep_ins_employer_city
_8.locationsloc_city
_8.non_patientsnpat_city
_8.ordersord_city
_8.ordersord_ins1_employer_city
_8.ordersord_ins2_employer_city
_8.patient_next_of_kinpnk_city
_8.patientspat_city
_8.patientspat_employer_city
_8.patientspat_guarantor_city
_8.patientspat_ins1_employer_city
_8.patientspat_ins2_employer_city
_8.patientspat_ins3_employer_city
_8.patientspat_emergency_city
_8.patients_demographics_snapshotspds_city
_8.patients_demographics_snapshotspds_employer_city
_8.patients_demographics_snapshotspds_guarantor_city
_8.patients_demographics_snapshotspds_ins1_employer_city
_8.patients_demographics_snapshotspds_ins2_employer_city
_8.patients_demographics_snapshotspds_ins3_employer_city
_8.physiciansphy_city
_8.precertspre_city
_8.precertspre_employer_city
_8.precertspre_guarantor_city
_8.precertspre_ins1_employer_city
_8.precertspre_ins2_employer_city
_8.radiology_ordersrad_city
_8.radiology_ordersrad_ins1_employer_city
_8.radiology_ordersrad_ins2_employer_city
_81.billing_providersbp_city
_81.buildingsbld_city
_81.chartschrt_city
_81.client_contactsclicon_city
_81.encountersenc_city
_81.encountersenc_employer_city
_81.encountersenc_guarantor_city
_81.encountersenc_ins1_employer_city
_81.encountersenc_ins2_employer_city
_81.encountersenc_ins3_employer_city
_81.hl7_lab_locationshll_city
_81.insurancesins_city
_81.insurances_claims_centersicc_city
_81.insurances_repositoryirep_ins_employer_city
_81.locationsloc_city
_81.non_patientsnpat_city
_81.ordersord_city
_81.ordersord_ins1_employer_city
_81.ordersord_ins2_employer_city
_81.patient_next_of_kinpnk_city
_81.patientspat_city
_81.patientspat_employer_city
_81.patientspat_guarantor_city
_81.patientspat_ins1_employer_city
_81.patientspat_ins2_employer_city
_81.patientspat_ins3_employer_city
_81.patientspat_emergency_city
_81.patients_demographics_snapshotspds_city
_81.patients_demographics_snapshotspds_employer_city
_81.patients_demographics_snapshotspds_guarantor_city
_81.patients_demographics_snapshotspds_ins1_employer_city
_81.patients_demographics_snapshotspds_ins2_employer_city
_81.patients_demographics_snapshotspds_ins3_employer_city
_81.physiciansphy_city
_81.precertspre_city
_81.precertspre_employer_city
_81.precertspre_guarantor_city
_81.precertspre_ins1_employer_city
_81.precertspre_ins2_employer_city
_81.radiology_ordersrad_city
_81.radiology_ordersrad_ins1_employer_city
_81.radiology_ordersrad_ins2_employer_city
_999.billing_providersbp_city
_999.buildingsbld_city
_999.chartschrt_city
_999.client_contactsclicon_city
_999.encountersenc_city
_999.encountersenc_employer_city
_999.encountersenc_guarantor_city
_999.encountersenc_ins1_employer_city
_999.encountersenc_ins2_employer_city
_999.encountersenc_ins3_employer_city
_999.hl7_lab_locationshll_city
_999.insurancesins_city
_999.insurances_claims_centersicc_city
_999.insurances_repositoryirep_ins_employer_city
_999.locationsloc_city
_999.non_patientsnpat_city
_999.ordersord_city
_999.ordersord_ins1_employer_city
_999.ordersord_ins2_employer_city
_999.patient_next_of_kinpnk_city
_999.patientspat_city
_999.patientspat_employer_city
_999.patientspat_guarantor_city
_999.patientspat_ins1_employer_city
_999.patientspat_ins2_employer_city
_999.patientspat_ins3_employer_city
_999.patientspat_emergency_city
_999.patients_demographics_snapshotspds_city
_999.patients_demographics_snapshotspds_employer_city
_999.patients_demographics_snapshotspds_guarantor_city
_999.patients_demographics_snapshotspds_ins1_employer_city
_999.patients_demographics_snapshotspds_ins2_employer_city
_999.patients_demographics_snapshotspds_ins3_employer_city
_999.physiciansphy_city
_999.precertspre_city
_999.precertspre_employer_city
_999.precertspre_guarantor_city
_999.precertspre_ins1_employer_city
_999.precertspre_ins2_employer_city
_999.radiology_ordersrad_city
_999.radiology_ordersrad_ins1_employer_city
_999.radiology_ordersrad_ins2_employer_city
aurora_standard.abmmpip_city
aurora_standard.abmmpiemp_city
aurora_standard.abmmpii1_city
aurora_standard.abmmpii2_city
aurora_standard.abmmpii3_city
aurora_standard.abmmpigu_city
aurora_standard.abmmpigu_emp_city
aurora_standard.abmmpin1_city
aurora_standard.abmmpin2_city
aurora_standard.abmvisp_city
aurora_standard.abmvisgu_city
aurora_standard.abmvisi1_city
aurora_standard.abmvisi2_city
aurora_standard.abmvisi3_city
aurora_standard.anmpip_city
aurora_standard.apsmpip_city
aurora_standard.aseympip_city
aurora_standard.bdmpisp_city
aurora_standard.bdmpink_city
aurora_standard.bdmpipat_city
aurora_standard.bempip_city
aurora_standard.bfhosgu_city
aurora_standard.bfpasrgu_city
aurora_standard.bfrhcgu_city
aurora_standard.bharp_city
aurora_standard.bharg_city
aurora_standard.bharge_city
aurora_standard.bharco1_city
aurora_standard.bharco2_city
aurora_standard.bharco3_city
aurora_standard.bharco4_city
aurora_standard.bharco5_city
aurora_standard.bharco6_city
aurora_standard.bharem_city
aurora_standard.bmmpip_city
aurora_standard.bmmpigu_city
aurora_standard.bmnkinn_city
aurora_standard.bmpactp_city
aurora_standard.bmpactgu_city
aurora_standard.bparp_city
aurora_standard.bparg_city
aurora_standard.bparge_city
aurora_standard.bparco1_city
aurora_standard.bparco2_city
aurora_standard.bparco3_city
aurora_standard.bparco4_city
aurora_standard.bparco5_city
aurora_standard.bparco6_city
aurora_standard.bparem_city
aurora_standard.bpar2p_city
aurora_standard.bpar2g_city
aurora_standard.bpar2ge_city
aurora_standard.bpar2co1_city
aurora_standard.bpar2co2_city
aurora_standard.bpar2co3_city
aurora_standard.bpar2co4_city
aurora_standard.bpar2co5_city
aurora_standard.bpar2co6_city
aurora_standard.bpar2em_city
aurora_standard.bpmpip_city
aurora_standard.bpmpi2p_city
aurora_standard.bs2mpicontact1_city
aurora_standard.bs2mpip_city
aurora_standard.bsinsurspouse_city
aurora_standard.bsinsurnextkin_city
aurora_standard.bsinsurpatient_city
aurora_standard.bsmpicontact1_city
aurora_standard.bsmpip_city
aurora_standard.c7insur2ins_city
aurora_standard.c7insur3ins_city
aurora_standard.c7mpip_city
aurora_standard.c7mpip2_city
aurora_standard.c7mpiinsur_city
aurora_standard.c7mpigu_city
aurora_standard.c7mpigu2_city
aurora_standard.c8mpip_city
aurora_standard.campispouse_city
aurora_standard.campinextkin_city
aurora_standard.campipatient_city
aurora_standard.chhl7adtpatient_city
aurora_standard.chhl7in1ins_city
aurora_standard.chhl7in1ins_empl_city
aurora_standard.chlswbhdfac_city
aurora_standard.chlswbhdagt_city
aurora_standard.chlswbhdsfw_city
aurora_standard.chltrnhdfac_city
aurora_standard.chltrnhdagt_city
aurora_standard.chltrnhdsfw_city
aurora_standard.chmarcnbfg_city
aurora_standard.chmarcnbfins1_city
aurora_standard.chmarcnbfins2_city
aurora_standard.chmarsipat_city
aurora_standard.chmarsigu_city
aurora_standard.chmarsigu_emp_city
aurora_standard.chmarsipat_emp_city
aurora_standard.chmarsiins1_city
aurora_standard.chmarsiins1_empl_city
aurora_standard.chmarsiins2_city
aurora_standard.chmarsiins2_empl_city
aurora_standard.chmarsiins3_city
aurora_standard.chmarsiins3_empl_city
aurora_standard.chmarstfac_city
aurora_standard.chmarstifac_city
aurora_standard.chmarstpsins_city
aurora_standard.chmarstpsemp_city
aurora_standard.chmarstptins_city
aurora_standard.chmarstptemp_city
aurora_standard.chmazstdpat_city
aurora_standard.chmazstipat_city
aurora_standard.chmazstopat_city
aurora_standard.chmbatexpat_city
aurora_standard.chmcampipat_city
aurora_standard.chmcampigu_city
aurora_standard.chmcampigu_emp_city
aurora_standard.chmcampipat_emp_city
aurora_standard.chmcampiins1_city
aurora_standard.chmcampiins1_empl_city
aurora_standard.chmcampiins2_city
aurora_standard.chmcampiins2_empl_city
aurora_standard.chmcampiins3_city
aurora_standard.chmcampiins3_empl_city
aurora_standard.chmcmheddebtor_city
aurora_standard.chmcmhedpat_city
aurora_standard.chmexmpipat_city
aurora_standard.chmexmpigu_city
aurora_standard.chmexmpigu_emp_city
aurora_standard.chmexmpipat_emp_city
aurora_standard.chmexmpiins1_city
aurora_standard.chmexmpiins1_empl_city
aurora_standard.chmexmpiins2_city
aurora_standard.chmexmpiins2_empl_city
aurora_standard.chmexmpiins3_city
aurora_standard.chmexmpiins3_empl_city
aurora_standard.chmexvisins1_city
aurora_standard.chmexvisins2_city
aurora_standard.chmexvisins3_city
aurora_standard.chmhistpp_city
aurora_standard.chmibendsend_claims_city
aurora_standard.chmlastrpat_city
aurora_standard.chmmbc35facility_city
aurora_standard.chmmbc37plan_carrier_city
aurora_standard.chmnvstbprov_city
aurora_standard.chmnvstbpayto_city
aurora_standard.chmnvstrprov_city
aurora_standard.chmnvstrpayto_city
aurora_standard.chmokipdpat_city
aurora_standard.chmokopdpat_city
aurora_standard.chmozpcddebtor_city
aurora_standard.chmp340bpatient_city
aurora_standard.chmpatirsubscri_city
aurora_standard.chmpatmrspouse_city
aurora_standard.chmpatmrnextkin_city
aurora_standard.chmpatmrpatient_city
aurora_standard.chmpatwcschool_city
aurora_standard.chmpdemop_city
aurora_standard.chmpdemop_emp_city
aurora_standard.chmpdemosp_city
aurora_standard.chmpdemogu_city
aurora_standard.chmpdemogu_emp_city
aurora_standard.chmpdemoins1_city
aurora_standard.chmpdemoins1_empl_city
aurora_standard.chmpdemoins2_city
aurora_standard.chmpdemoins2_empl_city
aurora_standard.chmpdemoins3_city
aurora_standard.chmpdemoins3_empl_city
aurora_standard.chmpresspatient_city
aurora_standard.chmradexpat_city
aurora_standard.chmradexpat_emp_city
aurora_standard.chmradexgu_city
aurora_standard.chmradexgu_emp_city
aurora_standard.chmradexins1_city
aurora_standard.chmradexins1_empl_city
aurora_standard.chmradexins2_city
aurora_standard.chmradexins2_empl_city
aurora_standard.chmradexins3_city
aurora_standard.chmradexins3_empl_city
aurora_standard.chmtxstrpat_city
aurora_standard.chmub04rf_09_city
aurora_standard.chmub04rl_38_4_city
aurora_standard.chmub92rl_13_city
aurora_standard.chmub92rl_38_4_city
aurora_standard.chmub92rl_66_a_city
aurora_standard.chmub92rl_66_b_city
aurora_standard.chmub92rl_66_c_city
aurora_standard.chmutah4pat_city
aurora_standard.chpdepeddepend_city
aurora_standard.nbspousespouse_city
aurora_standard.stp1099ccompany_city
aurora_standard.stp1099cvend_city
aurora_standard.stprepsdrep_city
aurora_standard.stpvendragent_city
aurora_standard.styoctccemployer_city
aurora_standard.styoctccgov_entity_city
aurora_standard.styoemprempl_city
aurora_standard.tmpub04rf_09_city
aurora_standard.tmpub04rl_38_4_city
common.applicantsapp_city
common.applicantsapp_hs_city
common.applicantsapp_c1_city
common.applicantsapp_c2_city
common.applicantsapp_gs_city
common.applicantsapp_o1_city
common.applicantsapp_o2_city
common.applicantsapp_employer_1_city
common.applicantsapp_employer_2_city
common.applicantsapp_employer_3_city
common.applicantsapp_employer_4_city
common.clientscli_city
common.clientscli_billing_city
common.clientscli_mailing_city
common.clients_contract_dataccd_payer_city
common.contactscon_city
common.customerscus_city
common.customerscus_billing_city
common.lab_interfaceslif_cli_city
common.lab_interfaces_performing_siteslips_city
common.labslab_city
common.leadslea_city
common.zipmapzip_city
rcmroi.dev__sf_usersaddr_city
rcmroi.prod__sf_usersaddr_city
rcmroi.test__sf_usersaddr_city
zip_1
TableColumn
aurora_standard.bdmpisp_zip_1
aurora_standard.bdmpink_zip_1
aurora_standard.bdmpipat_zip_1
aurora_standard.bsinsurspouse_zip_1
aurora_standard.bsinsurnextkin_zip_1
aurora_standard.bsinsurpatient_zip_1
aurora_standard.campispouse_zip_1
aurora_standard.campinextkin_zip_1
aurora_standard.campipatient_zip_1
aurora_standard.chhl7adtpatient_zip_1
aurora_standard.chhl7in1ins_zip_1
aurora_standard.chhl7in1ins_empl_zip_1
aurora_standard.chmp340bpatient_zip_1
aurora_standard.chmpatirsubscri_zip_1
aurora_standard.chmpatmrspouse_zip_1
aurora_standard.chmpatmrnextkin_zip_1
aurora_standard.chmpatmrpatient_zip_1
aurora_standard.chmpresspatient_zip_1
aurora_standard.nbspousespouse_zip_1
state_init
TableColumn
aurora_standard.chhl7in1ins_state_init
co_no
TableColumn
aurora_standard.chmradexins1_co_no
aurora_standard.chmradexins2_co_no
aurora_standard.chmradexins3_co_no