aurora_standard.bvphync

Field Type Null Default Key Extra Comment
prov_id varchar(20) YES
first_name varchar(20) NO
last_name varchar(20) NO
npi char(20) YES
license_no char(20) YES
phone char(20) YES
address char(30) YES
new_no bigint(20) unsigned NO PRI auto_increment

References

Local Column References
address
TableColumn
API.request_logs_v2ip_address
_1.encountersenc_ins1_employer_address
_1.encountersenc_ins2_employer_address
_1.encountersenc_ins3_employer_address
_1.insurances_repositoryirep_ins_employer_address
_1.ordersord_ins1_employer_address
_1.ordersord_ins2_employer_address
_1.patientspat_ins1_employer_address
_1.patientspat_ins2_employer_address
_1.patientspat_ins3_employer_address
_1.patients_demographics_snapshotspds_ins1_employer_address
_1.patients_demographics_snapshotspds_ins2_employer_address
_1.patients_demographics_snapshotspds_ins3_employer_address
_1.precertspre_ins1_employer_address
_1.precertspre_ins2_employer_address
_1.radiology_ordersrad_ins1_employer_address
_1.radiology_ordersrad_ins2_employer_address
_1188.encountersenc_ins1_employer_address
_1188.encountersenc_ins2_employer_address
_1188.encountersenc_ins3_employer_address
_1188.insurances_repositoryirep_ins_employer_address
_1188.ordersord_ins1_employer_address
_1188.ordersord_ins2_employer_address
_1188.patientspat_ins1_employer_address
_1188.patientspat_ins2_employer_address
_1188.patientspat_ins3_employer_address
_1188.patients_demographics_snapshotspds_ins1_employer_address
_1188.patients_demographics_snapshotspds_ins2_employer_address
_1188.patients_demographics_snapshotspds_ins3_employer_address
_1188.precertspre_ins1_employer_address
_1188.precertspre_ins2_employer_address
_1188.radiology_ordersrad_ins1_employer_address
_1188.radiology_ordersrad_ins2_employer_address
_1218.encountersenc_ins1_employer_address
_1218.encountersenc_ins2_employer_address
_1218.encountersenc_ins3_employer_address
_1218.insurances_repositoryirep_ins_employer_address
_1218.ordersord_ins1_employer_address
_1218.ordersord_ins2_employer_address
_1218.patientspat_ins1_employer_address
_1218.patientspat_ins2_employer_address
_1218.patientspat_ins3_employer_address
_1218.patients_demographics_snapshotspds_ins1_employer_address
_1218.patients_demographics_snapshotspds_ins2_employer_address
_1218.patients_demographics_snapshotspds_ins3_employer_address
_1218.precertspre_ins1_employer_address
_1218.precertspre_ins2_employer_address
_1218.radiology_ordersrad_ins1_employer_address
_1218.radiology_ordersrad_ins2_employer_address
_1548.encountersenc_ins1_employer_address
_1548.encountersenc_ins2_employer_address
_1548.encountersenc_ins3_employer_address
_1548.insurances_repositoryirep_ins_employer_address
_1548.ordersord_ins1_employer_address
_1548.ordersord_ins2_employer_address
_1548.patientspat_ins1_employer_address
_1548.patientspat_ins2_employer_address
_1548.patientspat_ins3_employer_address
_1548.patients_demographics_snapshotspds_ins1_employer_address
_1548.patients_demographics_snapshotspds_ins2_employer_address
_1548.patients_demographics_snapshotspds_ins3_employer_address
_1548.precertspre_ins1_employer_address
_1548.precertspre_ins2_employer_address
_1548.radiology_ordersrad_ins1_employer_address
_1548.radiology_ordersrad_ins2_employer_address
_435.encountersenc_ins1_employer_address
_435.encountersenc_ins2_employer_address
_435.encountersenc_ins3_employer_address
_435.insurances_repositoryirep_ins_employer_address
_435.ordersord_ins1_employer_address
_435.ordersord_ins2_employer_address
_435.patientspat_ins1_employer_address
_435.patientspat_ins2_employer_address
_435.patientspat_ins3_employer_address
_435.patients_demographics_snapshotspds_ins1_employer_address
_435.patients_demographics_snapshotspds_ins2_employer_address
_435.patients_demographics_snapshotspds_ins3_employer_address
_435.precertspre_ins1_employer_address
_435.precertspre_ins2_employer_address
_435.radiology_ordersrad_ins1_employer_address
_435.radiology_ordersrad_ins2_employer_address
_436.encountersenc_ins1_employer_address
_436.encountersenc_ins2_employer_address
_436.encountersenc_ins3_employer_address
_436.insurances_repositoryirep_ins_employer_address
_436.ordersord_ins1_employer_address
_436.ordersord_ins2_employer_address
_436.patientspat_ins1_employer_address
_436.patientspat_ins2_employer_address
_436.patientspat_ins3_employer_address
_436.patients_demographics_snapshotspds_ins1_employer_address
_436.patients_demographics_snapshotspds_ins2_employer_address
_436.patients_demographics_snapshotspds_ins3_employer_address
_436.precertspre_ins1_employer_address
_436.precertspre_ins2_employer_address
_436.radiology_ordersrad_ins1_employer_address
_436.radiology_ordersrad_ins2_employer_address
_436_archive_testing.encountersenc_ins1_employer_address
_436_archive_testing.encountersenc_ins2_employer_address
_436_archive_testing.encountersenc_ins3_employer_address
_436_archive_testing.insurances_repositoryirep_ins_employer_address
_436_archive_testing.ordersord_ins1_employer_address
_436_archive_testing.ordersord_ins2_employer_address
_436_archive_testing.patientspat_ins1_employer_address
_436_archive_testing.patientspat_ins2_employer_address
_436_archive_testing.patientspat_ins3_employer_address
_436_archive_testing.patients_demographics_snapshotspds_ins1_employer_address
_436_archive_testing.patients_demographics_snapshotspds_ins2_employer_address
_436_archive_testing.patients_demographics_snapshotspds_ins3_employer_address
_436_archive_testing.precertspre_ins1_employer_address
_436_archive_testing.precertspre_ins2_employer_address
_436_archive_testing.radiology_ordersrad_ins1_employer_address
_436_archive_testing.radiology_ordersrad_ins2_employer_address
_437.encountersenc_ins1_employer_address
_437.encountersenc_ins2_employer_address
_437.encountersenc_ins3_employer_address
_437.insurances_repositoryirep_ins_employer_address
_437.ordersord_ins1_employer_address
_437.ordersord_ins2_employer_address
_437.patientspat_ins1_employer_address
_437.patientspat_ins2_employer_address
_437.patientspat_ins3_employer_address
_437.patients_demographics_snapshotspds_ins1_employer_address
_437.patients_demographics_snapshotspds_ins2_employer_address
_437.patients_demographics_snapshotspds_ins3_employer_address
_437.precertspre_ins1_employer_address
_437.precertspre_ins2_employer_address
_437.radiology_ordersrad_ins1_employer_address
_437.radiology_ordersrad_ins2_employer_address
_8.encountersenc_ins1_employer_address
_8.encountersenc_ins2_employer_address
_8.encountersenc_ins3_employer_address
_8.insurances_repositoryirep_ins_employer_address
_8.ordersord_ins1_employer_address
_8.ordersord_ins2_employer_address
_8.patientspat_ins1_employer_address
_8.patientspat_ins2_employer_address
_8.patientspat_ins3_employer_address
_8.patients_demographics_snapshotspds_ins1_employer_address
_8.patients_demographics_snapshotspds_ins2_employer_address
_8.patients_demographics_snapshotspds_ins3_employer_address
_8.precertspre_ins1_employer_address
_8.precertspre_ins2_employer_address
_8.radiology_ordersrad_ins1_employer_address
_8.radiology_ordersrad_ins2_employer_address
_81.encountersenc_ins1_employer_address
_81.encountersenc_ins2_employer_address
_81.encountersenc_ins3_employer_address
_81.insurances_repositoryirep_ins_employer_address
_81.ordersord_ins1_employer_address
_81.ordersord_ins2_employer_address
_81.patientspat_ins1_employer_address
_81.patientspat_ins2_employer_address
_81.patientspat_ins3_employer_address
_81.patients_demographics_snapshotspds_ins1_employer_address
_81.patients_demographics_snapshotspds_ins2_employer_address
_81.patients_demographics_snapshotspds_ins3_employer_address
_81.precertspre_ins1_employer_address
_81.precertspre_ins2_employer_address
_81.radiology_ordersrad_ins1_employer_address
_81.radiology_ordersrad_ins2_employer_address
_999.encountersenc_ins1_employer_address
_999.encountersenc_ins2_employer_address
_999.encountersenc_ins3_employer_address
_999.insurances_repositoryirep_ins_employer_address
_999.ordersord_ins1_employer_address
_999.ordersord_ins2_employer_address
_999.patientspat_ins1_employer_address
_999.patientspat_ins2_employer_address
_999.patientspat_ins3_employer_address
_999.patients_demographics_snapshotspds_ins1_employer_address
_999.patients_demographics_snapshotspds_ins2_employer_address
_999.patients_demographics_snapshotspds_ins3_employer_address
_999.precertspre_ins1_employer_address
_999.precertspre_ins2_employer_address
_999.radiology_ordersrad_ins1_employer_address
_999.radiology_ordersrad_ins2_employer_address
ahiWiki.ipblocksipb_address
aurora_standard.chmlpforip_address
aurora_standard.chmprnrrip_address
aurora_standard.chpemercstreet_address
aurora_standard.printing_locationsip_address
common.applicantsapp_address
common.applicantsapp_employer_1_address
common.applicantsapp_employer_2_address
common.applicantsapp_employer_3_address
common.applicantsapp_employer_4_address
common.applicantsapp_reference_1_address
common.applicantsapp_reference_2_address
common.applicantsapp_reference_3_address
common.applicantsapp_reference_4_address
common.users_permissionsupr_insurance_add_duplicate_address
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
npi
TableColumn
_1.billing_providersbp_npi
_1.erx_notificationserx_nots_provider_npi
_1.insurances_group_billingigb_use_individual_npi
_1.locationsloc_npi
_1.patients_prescriptionsprx_provider_npi
_1.patients_prescriptionsprx_pharmacy_npi
_1.physiciansphy_npi
_1.physiciansphy_verify_npi
_1188.billing_providersbp_npi
_1188.erx_notificationserx_nots_provider_npi
_1188.insurances_group_billingigb_use_individual_npi
_1188.locationsloc_npi
_1188.patients_prescriptionsprx_provider_npi
_1188.patients_prescriptionsprx_pharmacy_npi
_1188.physiciansphy_npi
_1188.physiciansphy_verify_npi
_1218.billing_providersbp_npi
_1218.erx_notificationserx_nots_provider_npi
_1218.insurances_group_billingigb_use_individual_npi
_1218.locationsloc_npi
_1218.patients_prescriptionsprx_provider_npi
_1218.patients_prescriptionsprx_pharmacy_npi
_1218.physiciansphy_npi
_1218.physiciansphy_verify_npi
_1548.billing_providersbp_npi
_1548.erx_notificationserx_nots_provider_npi
_1548.insurances_group_billingigb_use_individual_npi
_1548.locationsloc_npi
_1548.patients_prescriptionsprx_provider_npi
_1548.patients_prescriptionsprx_pharmacy_npi
_1548.physiciansphy_npi
_1548.physiciansphy_verify_npi
_435.billing_providersbp_npi
_435.erx_notificationserx_nots_provider_npi
_435.insurances_group_billingigb_use_individual_npi
_435.locationsloc_npi
_435.patients_prescriptionsprx_provider_npi
_435.patients_prescriptionsprx_pharmacy_npi
_435.physiciansphy_npi
_435.physiciansphy_verify_npi
_436.billing_providersbp_npi
_436.erx_notificationserx_nots_provider_npi
_436.insurances_group_billingigb_use_individual_npi
_436.locationsloc_npi
_436.patients_prescriptionsprx_provider_npi
_436.patients_prescriptionsprx_pharmacy_npi
_436.physiciansphy_npi
_436.physiciansphy_verify_npi
_436_archive_testing.billing_providersbp_npi
_436_archive_testing.erx_notificationserx_nots_provider_npi
_436_archive_testing.insurances_group_billingigb_use_individual_npi
_436_archive_testing.locationsloc_npi
_436_archive_testing.patients_prescriptionsprx_provider_npi
_436_archive_testing.patients_prescriptionsprx_pharmacy_npi
_436_archive_testing.physiciansphy_npi
_436_archive_testing.physiciansphy_verify_npi
_437.billing_providersbp_npi
_437.erx_notificationserx_nots_provider_npi
_437.insurances_group_billingigb_use_individual_npi
_437.locationsloc_npi
_437.patients_prescriptionsprx_provider_npi
_437.patients_prescriptionsprx_pharmacy_npi
_437.physiciansphy_npi
_437.physiciansphy_verify_npi
_8.billing_providersbp_npi
_8.erx_notificationserx_nots_provider_npi
_8.insurances_group_billingigb_use_individual_npi
_8.locationsloc_npi
_8.patients_prescriptionsprx_provider_npi
_8.patients_prescriptionsprx_pharmacy_npi
_8.physiciansphy_npi
_8.physiciansphy_verify_npi
_81.billing_providersbp_npi
_81.erx_notificationserx_nots_provider_npi
_81.insurances_group_billingigb_use_individual_npi
_81.locationsloc_npi
_81.patients_prescriptionsprx_provider_npi
_81.patients_prescriptionsprx_pharmacy_npi
_81.physiciansphy_npi
_81.physiciansphy_verify_npi
_999.billing_providersbp_npi
_999.erx_notificationserx_nots_provider_npi
_999.insurances_group_billingigb_use_individual_npi
_999.locationsloc_npi
_999.patients_prescriptionsprx_provider_npi
_999.patients_prescriptionsprx_pharmacy_npi
_999.physiciansphy_npi
_999.physiciansphy_verify_npi
aurora_standard.apsphymc_npi
aurora_standard.apsphymd_npi
aurora_standard.chm1500rn_17b_npi
aurora_standard.chm1500rn_32a_npi
aurora_standard.chm1500rn_33a_npi
aurora_standard.chm15chdn24j_npi
aurora_standard.chmarsifam_phy_npi
aurora_standard.chmarsiattend_phy_npi
aurora_standard.chmarsiadmit_phy_npi
aurora_standard.chmarstfacility_npi
aurora_standard.chmarstmedicaid_npi
aurora_standard.chmarstifacility_npi
aurora_standard.chmarstimedicaid_npi
aurora_standard.chmarstphatt_npi
aurora_standard.chmarstphsur_npi
aurora_standard.chmarstpoatt_npi
aurora_standard.chmarstposur_npi
aurora_standard.chmazstdatt_phy_npi
aurora_standard.chmazstdproc_phy_npi
aurora_standard.chmazstdoth_phy_npi
aurora_standard.chmazstiatt_phy_npi
aurora_standard.chmazstiproc_phy_npi
aurora_standard.chmazstioth_phy_npi
aurora_standard.chmazstoatt_phy_npi
aurora_standard.chmazstoproc_phy_npi
aurora_standard.chmazstooth_phy_npi
aurora_standard.chmcampifam_phy_npi
aurora_standard.chmcampiattend_phy_npi
aurora_standard.chmcampiadmit_phy_npi
aurora_standard.chmexmpifam_phy_npi
aurora_standard.chmexmpiattend_phy_npi
aurora_standard.chmexmpiadmit_phy_npi
aurora_standard.chmexvisattend_phy_npi
aurora_standard.chmexvisadmit_phy_npi
aurora_standard.chmhcahpclinic_npi
aurora_standard.chmhcahpdr_npi
aurora_standard.chmhid4afacility_npi
aurora_standard.chmhid4aatt_npi
aurora_standard.chmhid4asur_npi
aurora_standard.chmhid4aother1_qual_npi
aurora_standard.chmhid4aother2_qual_npi
aurora_standard.chmhid4bfacility_npi
aurora_standard.chmhid4cfacility_npi
aurora_standard.chmhid4dfac_npi
aurora_standard.chmhid4gfacility_npi
aurora_standard.chmlastratt_phy_npi
aurora_standard.chmlastrop_phy_npi
aurora_standard.chmlastroth_phy_npi
aurora_standard.chmlastrrnd_phy_npi
aurora_standard.chmlastradm_phy_npi
aurora_standard.chmlastrref_phy_npi
aurora_standard.chmmhastfac_npi
aurora_standard.chmmhastatt_phy_npi
aurora_standard.chmmhastsurg_npi
aurora_standard.chmnvstbatt_npi
aurora_standard.chmnvstbop_npi
aurora_standard.chmnvstboth_npi
aurora_standard.chmnvstbothb_npi
aurora_standard.chmnvstratt_npi
aurora_standard.chmnvstrop_npi
aurora_standard.chmnvstroth_npi
aurora_standard.chmnvstrothb_npi
aurora_standard.chmp340bprescriber_npi
aurora_standard.chmpdemofam_phy_npi
aurora_standard.chmpdemoattend_phy_npi
aurora_standard.chmpdemoadmit_phy_npi
aurora_standard.chmphynebox_17b_npi
aurora_standard.chmphynebox_24j_npi
aurora_standard.chmphynebox_33a_npi
aurora_standard.chmradedphy_npi
aurora_standard.chmradexfam_phy_npi
aurora_standard.chmradexattend_phy_npi
aurora_standard.chmradexadmit_phy_npi
aurora_standard.chmub04bf_56_npi
aurora_standard.chmub04bf_76_npi
aurora_standard.chmub04bf_77_npi
aurora_standard.chmub04bf_78_npi
aurora_standard.chmub04bf_79_npi
aurora_standard.tmpub04rf_56_npi
aurora_standard.tmpub04rf_76_npi
aurora_standard.tmpub04rf_77_npi
aurora_standard.tmpub04rf_78_npi
aurora_standard.tmpub04rf_79_npi
common.clientscli_npi
common.clientscli_verify_npi
common.reports_filters_options_maprfom_use_npi
last_name
TableColumn
aurora_standard.c7insur2p_last_name
aurora_standard.c7insur3p_last_name
aurora_standard.chm1500rpat_last_name
aurora_standard.chmcmhedpat_last_name
aurora_standard.chmstmtdg_last_name
first_name
TableColumn
aurora_standard.c7insur2p_first_name
aurora_standard.c7insur3p_first_name
aurora_standard.chm1500rpat_first_name
aurora_standard.chmcmhedpat_first_name
aurora_standard.chmstmtdg_first_name