aurora_standard.bfphync

Field Type Null Default Key Extra Comment
number varchar(6) YES
full_name varchar(50) YES
address_1 varchar(20) YES
work_no varchar(20) YES
license_no varchar(20) YES
upin_no varchar(20) YES
address_2 varchar(20) YES
ssn varchar(20) YES
city_st_zip varchar(40) YES
md_1500 varchar(20) YES
bc_no varchar(20) YES
mc_no varchar(20) YES
md_ub varchar(20) YES
taxonomy varchar(20) YES
npi_no int(10) YES
oth_no int(10) YES

References

Local Column References
number
TableColumn
API.partner_accountsphone_number
AzaleaStats.error_reportserr_source_line_number
EFaxes.efaxes_recipientsefr_number
HSPI_Bastrop.coveragesgroup_number
HSPI_Bastrop.coveragespolicy_number
HSPI_Bastrop.locationsclia_number
HSPI_Bastrop.phone_numbersphone_number
HSPI_CURES2015_B1.cbos_inventory_logdocument_number
HSPI_CURES2015_B1.coveragesgroup_number
HSPI_CURES2015_B1.coveragespolicy_number
HSPI_CURES2015_B1.locationsclia_number
HSPI_CURES2015_B1.phone_numbersphone_number
HSPI_Central_Hospital.cbos_inventory_logdocument_number
HSPI_Central_Hospital.coveragesgroup_number
HSPI_Central_Hospital.coveragespolicy_number
HSPI_Central_Hospital.locationsclia_number
HSPI_Central_Hospital.phone_numbersphone_number
HSPI_Dewitt.cbos_inventory_logdocument_number
HSPI_Dewitt.coveragesgroup_number
HSPI_Dewitt.coveragespolicy_number
HSPI_Dewitt.locationsclia_number
HSPI_Dewitt.phone_numbersphone_number
HSPI_Fulton.cbos_inventory_logdocument_number
HSPI_Fulton.coveragesgroup_number
HSPI_Fulton.coveragespolicy_number
HSPI_Fulton.locationsclia_number
HSPI_Fulton.phone_numbersphone_number
HSPI_Inferno.cbos_inventory_logdocument_number
HSPI_Inferno.coveragesgroup_number
HSPI_Inferno.coveragespolicy_number
HSPI_Inferno.locationsclia_number
HSPI_Inferno.phone_numbersphone_number
HSPI_MU2015_E1.cbos_inventory_logdocument_number
HSPI_MU2015_E1.coveragesgroup_number
HSPI_MU2015_E1.coveragespolicy_number
HSPI_MU2015_E1.locationsclia_number
HSPI_MU2015_E1.phone_numbersphone_number
HSPI_MU2015_G2.cbos_inventory_logdocument_number
HSPI_MU2015_G2.coveragesgroup_number
HSPI_MU2015_G2.coveragespolicy_number
HSPI_MU2015_G2.locationsclia_number
HSPI_MU2015_G2.phone_numbersphone_number
HSPI_MU2015_G9.cbos_inventory_logdocument_number
HSPI_MU2015_G9.coveragesgroup_number
HSPI_MU2015_G9.coveragespolicy_number
HSPI_MU2015_G9.locationsclia_number
HSPI_MU2015_G9.phone_numbersphone_number
HSPI_Ness.coveragesgroup_number
HSPI_Ness.coveragespolicy_number
HSPI_Ness.phone_numbersphone_number
HSPI_Sandbox.cbos_inventory_logdocument_number
HSPI_Sandbox.coveragesgroup_number
HSPI_Sandbox.coveragespolicy_number
HSPI_Sandbox.locationsclia_number
HSPI_Sandbox.phone_numbersphone_number
HSPI_Summit_General.cbos_inventory_logdocument_number
HSPI_Summit_General.coveragesgroup_number
HSPI_Summit_General.coveragespolicy_number
HSPI_Summit_General.locationsclia_number
HSPI_Summit_General.phone_numbersphone_number
HSPI_System.phone_numbersphone_number
HSPI_United_Physicians.cbos_inventory_logdocument_number
HSPI_United_Physicians.coveragesgroup_number
HSPI_United_Physicians.coveragespolicy_number
HSPI_United_Physicians.locationsclia_number
HSPI_United_Physicians.phone_numbersphone_number
MPI.cbos_inventory_logdocument_number
MPI.coveragesgroup_number
MPI.coveragespolicy_number
MPI.locationsclia_number
MPI.phone_numbersphone_number
SSO.developer_profilesphone_number
_1.client_contactsclicon_fax_number
_1.encounters_claims_supplemental_informationsecsi_control_number
_1.encounters_cpt_codesecp_prescription_number
_1.encounters_ub04enc_ub04_81_a_number
_1.encounters_ub04enc_ub04_81_b_number
_1.encounters_ub04enc_ub04_81_c_number
_1.encounters_ub04enc_ub04_81_d_number
_1.hl7_ordersord_group_number
_1.inventoryinv_lot_number
_1.inventoryinv_product_number
_1.patientspat_emergency_number
_1.patients_demographics_snapshotspds_emergency_number
_1.patients_historiesph_enc_version_number
_1.patients_inventorypinv_lot_number
_1.patients_inventorypinv_product_number
_1.patients_prescriptionsprx_order_number
_1188.client_contactsclicon_fax_number
_1188.encounters_claims_supplemental_informationsecsi_control_number
_1188.encounters_cpt_codesecp_prescription_number
_1188.encounters_ub04enc_ub04_81_a_number
_1188.encounters_ub04enc_ub04_81_b_number
_1188.encounters_ub04enc_ub04_81_c_number
_1188.encounters_ub04enc_ub04_81_d_number
_1188.hl7_ordersord_group_number
_1188.inventoryinv_lot_number
_1188.inventoryinv_product_number
_1188.patientspat_emergency_number
_1188.patients_demographics_snapshotspds_emergency_number
_1188.patients_historiesph_enc_version_number
_1188.patients_inventorypinv_lot_number
_1188.patients_inventorypinv_product_number
_1188.patients_prescriptionsprx_order_number
_1218.client_contactsclicon_fax_number
_1218.encounters_claims_supplemental_informationsecsi_control_number
_1218.encounters_cpt_codesecp_prescription_number
_1218.encounters_ub04enc_ub04_81_a_number
_1218.encounters_ub04enc_ub04_81_b_number
_1218.encounters_ub04enc_ub04_81_c_number
_1218.encounters_ub04enc_ub04_81_d_number
_1218.hl7_ordersord_group_number
_1218.inventoryinv_lot_number
_1218.inventoryinv_product_number
_1218.patientspat_emergency_number
_1218.patients_demographics_snapshotspds_emergency_number
_1218.patients_historiesph_enc_version_number
_1218.patients_inventorypinv_lot_number
_1218.patients_inventorypinv_product_number
_1218.patients_prescriptionsprx_order_number
_1548.client_contactsclicon_fax_number
_1548.encounters_claims_supplemental_informationsecsi_control_number
_1548.encounters_cpt_codesecp_prescription_number
_1548.encounters_ub04enc_ub04_81_a_number
_1548.encounters_ub04enc_ub04_81_b_number
_1548.encounters_ub04enc_ub04_81_c_number
_1548.encounters_ub04enc_ub04_81_d_number
_1548.hl7_ordersord_group_number
_1548.inventoryinv_lot_number
_1548.inventoryinv_product_number
_1548.patientspat_emergency_number
_1548.patients_demographics_snapshotspds_emergency_number
_1548.patients_historiesph_enc_version_number
_1548.patients_inventorypinv_lot_number
_1548.patients_inventorypinv_product_number
_1548.patients_prescriptionsprx_order_number
_435.client_contactsclicon_fax_number
_435.encounters_claims_supplemental_informationsecsi_control_number
_435.encounters_cpt_codesecp_prescription_number
_435.encounters_ub04enc_ub04_81_a_number
_435.encounters_ub04enc_ub04_81_b_number
_435.encounters_ub04enc_ub04_81_c_number
_435.encounters_ub04enc_ub04_81_d_number
_435.hl7_ordersord_group_number
_435.inventoryinv_lot_number
_435.inventoryinv_product_number
_435.patientspat_emergency_number
_435.patients_demographics_snapshotspds_emergency_number
_435.patients_historiesph_enc_version_number
_435.patients_inventorypinv_lot_number
_435.patients_inventorypinv_product_number
_435.patients_prescriptionsprx_order_number
_436.client_contactsclicon_fax_number
_436.encounters_claims_supplemental_informationsecsi_control_number
_436.encounters_cpt_codesecp_prescription_number
_436.encounters_ub04enc_ub04_81_a_number
_436.encounters_ub04enc_ub04_81_b_number
_436.encounters_ub04enc_ub04_81_c_number
_436.encounters_ub04enc_ub04_81_d_number
_436.hl7_ordersord_group_number
_436.inventoryinv_lot_number
_436.inventoryinv_product_number
_436.patientspat_emergency_number
_436.patients_demographics_snapshotspds_emergency_number
_436.patients_historiesph_enc_version_number
_436.patients_inventorypinv_lot_number
_436.patients_inventorypinv_product_number
_436.patients_prescriptionsprx_order_number
_436_archive_testing.client_contactsclicon_fax_number
_436_archive_testing.encounters_claims_supplemental_informationsecsi_control_number
_436_archive_testing.encounters_cpt_codesecp_prescription_number
_436_archive_testing.encounters_ub04enc_ub04_81_a_number
_436_archive_testing.encounters_ub04enc_ub04_81_b_number
_436_archive_testing.encounters_ub04enc_ub04_81_c_number
_436_archive_testing.encounters_ub04enc_ub04_81_d_number
_436_archive_testing.hl7_ordersord_group_number
_436_archive_testing.inventoryinv_lot_number
_436_archive_testing.inventoryinv_product_number
_436_archive_testing.patientspat_emergency_number
_436_archive_testing.patients_demographics_snapshotspds_emergency_number
_436_archive_testing.patients_historiesph_enc_version_number
_436_archive_testing.patients_inventorypinv_lot_number
_436_archive_testing.patients_inventorypinv_product_number
_436_archive_testing.patients_prescriptionsprx_order_number
_437.client_contactsclicon_fax_number
_437.encounters_claims_supplemental_informationsecsi_control_number
_437.encounters_cpt_codesecp_prescription_number
_437.encounters_ub04enc_ub04_81_a_number
_437.encounters_ub04enc_ub04_81_b_number
_437.encounters_ub04enc_ub04_81_c_number
_437.encounters_ub04enc_ub04_81_d_number
_437.hl7_ordersord_group_number
_437.inventoryinv_lot_number
_437.inventoryinv_product_number
_437.patientspat_emergency_number
_437.patients_demographics_snapshotspds_emergency_number
_437.patients_historiesph_enc_version_number
_437.patients_inventorypinv_lot_number
_437.patients_inventorypinv_product_number
_437.patients_prescriptionsprx_order_number
_8.client_contactsclicon_fax_number
_8.encounters_claims_supplemental_informationsecsi_control_number
_8.encounters_cpt_codesecp_prescription_number
_8.encounters_ub04enc_ub04_81_a_number
_8.encounters_ub04enc_ub04_81_b_number
_8.encounters_ub04enc_ub04_81_c_number
_8.encounters_ub04enc_ub04_81_d_number
_8.hl7_ordersord_group_number
_8.inventoryinv_lot_number
_8.inventoryinv_product_number
_8.patientspat_emergency_number
_8.patients_demographics_snapshotspds_emergency_number
_8.patients_historiesph_enc_version_number
_8.patients_inventorypinv_lot_number
_8.patients_inventorypinv_product_number
_8.patients_prescriptionsprx_order_number
_81.client_contactsclicon_fax_number
_81.encounters_claims_supplemental_informationsecsi_control_number
_81.encounters_cpt_codesecp_prescription_number
_81.encounters_ub04enc_ub04_81_a_number
_81.encounters_ub04enc_ub04_81_b_number
_81.encounters_ub04enc_ub04_81_c_number
_81.encounters_ub04enc_ub04_81_d_number
_81.hl7_ordersord_group_number
_81.inventoryinv_lot_number
_81.inventoryinv_product_number
_81.patientspat_emergency_number
_81.patients_demographics_snapshotspds_emergency_number
_81.patients_historiesph_enc_version_number
_81.patients_inventorypinv_lot_number
_81.patients_inventorypinv_product_number
_81.patients_prescriptionsprx_order_number
_999.client_contactsclicon_fax_number
_999.encounters_claims_supplemental_informationsecsi_control_number
_999.encounters_cpt_codesecp_prescription_number
_999.encounters_ub04enc_ub04_81_a_number
_999.encounters_ub04enc_ub04_81_b_number
_999.encounters_ub04enc_ub04_81_c_number
_999.encounters_ub04enc_ub04_81_d_number
_999.hl7_ordersord_group_number
_999.inventoryinv_lot_number
_999.inventoryinv_product_number
_999.patientspat_emergency_number
_999.patients_demographics_snapshotspds_emergency_number
_999.patients_historiesph_enc_version_number
_999.patients_inventorypinv_lot_number
_999.patients_inventorypinv_product_number
_999.patients_prescriptionsprx_order_number
aurora_standard.acptwrkcpt_number
aurora_standard.acptwrkdec_number
aurora_standard.addcdmdept_number
aurora_standard.b2baddmr_number
aurora_standard.bhbaddmr_number
aurora_standard.bhldgrmr_number
aurora_standard.bhphybakmr_number
aurora_standard.bhtldgrmr_number
aurora_standard.caadjgl_number
aurora_standard.cachrggl_number
aurora_standard.cachrg2gl_number
aurora_standard.cachrgcagl_number
aurora_standard.cachrgevogl_number
aurora_standard.canullchrggl_number
aurora_standard.capaygl_number
aurora_standard.caroomgl_number
aurora_standard.cgsinptrauto_number
aurora_standard.chcimmucjoin_number
aurora_standard.chcmanucjoin_number
aurora_standard.chcprovcjoin_number
aurora_standard.chcsericjoin_number
aurora_standard.chm15chdphys_number
aurora_standard.chm835pssvc_number
aurora_standard.chmbatexmc_number
aurora_standard.chmblogdseq_number
aurora_standard.chmmbc37policy_number
aurora_standard.chmmbc37ocna_number
aurora_standard.chmmbc50payor_number
aurora_standard.chmmbc51check_number
aurora_standard.chmmhbcrcheck_number
aurora_standard.chmmnecaorig_number
aurora_standard.chmpatmdmr_number
aurora_standard.chmphyncmr_number
aurora_standard.chmpressclient_number
aurora_standard.chpcobrdcobra_number
aurora_standard.chpemphdseq_number
aurora_standard.chplicedlicense_number
aurora_standard.chpparbacus_number
aurora_standard.chqcarddphy_number
aurora_standard.chqchekdphy_number
aurora_standard.chqchrtdphy_number
aurora_standard.chqcmeudphy_number
aurora_standard.chqletrdphy_number
aurora_standard.chqliabdphy_number
aurora_standard.chqlicndlicense_number
aurora_standard.chqlicndphy_number
aurora_standard.chqnpdbdphy_number
aurora_standard.chqphyncphy_number
aurora_standard.chqstafdphy_number
aurora_standard.chrdfileid_number
aurora_standard.chtclokdinc_number
aurora_standard.hhtclokdinc_number
aurora_standard.oeorderphy_number
aurora_standard.stfasstrpo_number
aurora_standard.stonwalldept_number
aurora_standard.stpapckvdocument_number
aurora_standard.stpapckvposting_number
aurora_standard.stpapckvcheck_number
aurora_standard.stpapckvaccount_number
aurora_standard.stxerorderr_number
aurora_standard.stxerorherr_number
aurora_standard.stxhelpdhlp_number
aurora_standard.stxmssgrmssg_number
aurora_standard.stycntrcein_number
aurora_standard.stycntrcstate_number
aurora_standard.stycntrcsuta_number
aurora_standard.stydeddvdocument_number
aurora_standard.stydeddvcheck_number
aurora_standard.stydeddvempl_acct_number
aurora_standard.styempidinc_number
aurora_standard.styincdvdocument_number
aurora_standard.styincdvcheck_number
aurora_standard.styobldvdocument_number
aurora_standard.styobldvcheck_number
aurora_standard.styoctccgov_entity_id_number
aurora_standard.styoctccform_1095c_number
aurora_standard.styoctccale_form_1095c_number
aurora_standard.stypddrdtrace_number
aurora_standard.styptodvdocument_number
aurora_standard.styrtimdinc_number
aurora_standard.stytimedinc_number
aurora_standard.stytypidinc_number
aurora_standard.stywtwoestate_number
aurora_standard.stywtwoelocal_number
aurora_standard.timetablinc_number
aurora_standard.timetabl_ininc_number
aurora_standard.tmpmrrptcontrol_number
aurora_standard.vault_relationshipsrelationship_code_number
common.appointments_clienttell_statusesacs_number
common.card_connect_merchant_accountsccma_hsn_number
common.card_connect_merchant_devices_mapccmdm_hsn_number
common.faxesfax_number
xlnt.buildsbamboo_build_number
xlnt.selenium_test_queuebuild_number
xlnt.selenium_test_resultsbuild_number
ssn
TableColumn
Azalea.employeesemp_ssn
_1.chartschrt_ssn
_1.cpoe_responsescpoe_res_ssn
_1.encountersenc_ssn
_1.encountersenc_guarantor_ssn
_1.encountersenc_ins1_insured_ssn
_1.encountersenc_ins2_insured_ssn
_1.encountersenc_ins3_insured_ssn
_1.examplesexa_ssn
_1.hl7_accessionsacc_ssn
_1.insurances_repositoryirep_ins_insured_ssn
_1.non_patientsnpat_ssn
_1.ordersord_ssn
_1.patientspat_ssn
_1.patientspat_guarantor_ssn
_1.patientspat_ins1_insured_ssn
_1.patientspat_ins2_insured_ssn
_1.patientspat_ins3_insured_ssn
_1.patients_demographics_snapshotspds_ssn
_1.patients_demographics_snapshotspds_guarantor_ssn
_1.patients_demographics_snapshotspds_ins1_insured_ssn
_1.patients_demographics_snapshotspds_ins2_insured_ssn
_1.patients_demographics_snapshotspds_ins3_insured_ssn
_1.patients_responsibility_estimatesprest_ssn
_1.precertspre_ssn
_1.precertspre_guarantor_ssn
_1.precertspre_ins1_insured_ssn
_1.precertspre_ins2_insured_ssn
_1.radiology_ordersrad_ssn
_1.radiology_resultsrad_res_ssn
_1188.chartschrt_ssn
_1188.cpoe_responsescpoe_res_ssn
_1188.encountersenc_ssn
_1188.encountersenc_guarantor_ssn
_1188.encountersenc_ins1_insured_ssn
_1188.encountersenc_ins2_insured_ssn
_1188.encountersenc_ins3_insured_ssn
_1188.examplesexa_ssn
_1188.hl7_accessionsacc_ssn
_1188.insurances_repositoryirep_ins_insured_ssn
_1188.non_patientsnpat_ssn
_1188.ordersord_ssn
_1188.patientspat_ssn
_1188.patientspat_guarantor_ssn
_1188.patientspat_ins1_insured_ssn
_1188.patientspat_ins2_insured_ssn
_1188.patientspat_ins3_insured_ssn
_1188.patients_demographics_snapshotspds_ssn
_1188.patients_demographics_snapshotspds_guarantor_ssn
_1188.patients_demographics_snapshotspds_ins1_insured_ssn
_1188.patients_demographics_snapshotspds_ins2_insured_ssn
_1188.patients_demographics_snapshotspds_ins3_insured_ssn
_1188.patients_responsibility_estimatesprest_ssn
_1188.precertspre_ssn
_1188.precertspre_guarantor_ssn
_1188.precertspre_ins1_insured_ssn
_1188.precertspre_ins2_insured_ssn
_1188.radiology_ordersrad_ssn
_1188.radiology_resultsrad_res_ssn
_1218.chartschrt_ssn
_1218.cpoe_responsescpoe_res_ssn
_1218.encountersenc_ssn
_1218.encountersenc_guarantor_ssn
_1218.encountersenc_ins1_insured_ssn
_1218.encountersenc_ins2_insured_ssn
_1218.encountersenc_ins3_insured_ssn
_1218.examplesexa_ssn
_1218.hl7_accessionsacc_ssn
_1218.insurances_repositoryirep_ins_insured_ssn
_1218.non_patientsnpat_ssn
_1218.ordersord_ssn
_1218.patientspat_ssn
_1218.patientspat_guarantor_ssn
_1218.patientspat_ins1_insured_ssn
_1218.patientspat_ins2_insured_ssn
_1218.patientspat_ins3_insured_ssn
_1218.patients_demographics_snapshotspds_ssn
_1218.patients_demographics_snapshotspds_guarantor_ssn
_1218.patients_demographics_snapshotspds_ins1_insured_ssn
_1218.patients_demographics_snapshotspds_ins2_insured_ssn
_1218.patients_demographics_snapshotspds_ins3_insured_ssn
_1218.patients_responsibility_estimatesprest_ssn
_1218.precertspre_ssn
_1218.precertspre_guarantor_ssn
_1218.precertspre_ins1_insured_ssn
_1218.precertspre_ins2_insured_ssn
_1218.radiology_ordersrad_ssn
_1218.radiology_resultsrad_res_ssn
_1548.chartschrt_ssn
_1548.cpoe_responsescpoe_res_ssn
_1548.encountersenc_ssn
_1548.encountersenc_guarantor_ssn
_1548.encountersenc_ins1_insured_ssn
_1548.encountersenc_ins2_insured_ssn
_1548.encountersenc_ins3_insured_ssn
_1548.examplesexa_ssn
_1548.hl7_accessionsacc_ssn
_1548.insurances_repositoryirep_ins_insured_ssn
_1548.non_patientsnpat_ssn
_1548.ordersord_ssn
_1548.patientspat_ssn
_1548.patientspat_guarantor_ssn
_1548.patientspat_ins1_insured_ssn
_1548.patientspat_ins2_insured_ssn
_1548.patientspat_ins3_insured_ssn
_1548.patients_demographics_snapshotspds_ssn
_1548.patients_demographics_snapshotspds_guarantor_ssn
_1548.patients_demographics_snapshotspds_ins1_insured_ssn
_1548.patients_demographics_snapshotspds_ins2_insured_ssn
_1548.patients_demographics_snapshotspds_ins3_insured_ssn
_1548.patients_responsibility_estimatesprest_ssn
_1548.precertspre_ssn
_1548.precertspre_guarantor_ssn
_1548.precertspre_ins1_insured_ssn
_1548.precertspre_ins2_insured_ssn
_1548.radiology_ordersrad_ssn
_1548.radiology_resultsrad_res_ssn
_435.chartschrt_ssn
_435.cpoe_responsescpoe_res_ssn
_435.encountersenc_ssn
_435.encountersenc_guarantor_ssn
_435.encountersenc_ins1_insured_ssn
_435.encountersenc_ins2_insured_ssn
_435.encountersenc_ins3_insured_ssn
_435.examplesexa_ssn
_435.hl7_accessionsacc_ssn
_435.insurances_repositoryirep_ins_insured_ssn
_435.non_patientsnpat_ssn
_435.ordersord_ssn
_435.patientspat_ssn
_435.patientspat_guarantor_ssn
_435.patientspat_ins1_insured_ssn
_435.patientspat_ins2_insured_ssn
_435.patientspat_ins3_insured_ssn
_435.patients_demographics_snapshotspds_ssn
_435.patients_demographics_snapshotspds_guarantor_ssn
_435.patients_demographics_snapshotspds_ins1_insured_ssn
_435.patients_demographics_snapshotspds_ins2_insured_ssn
_435.patients_demographics_snapshotspds_ins3_insured_ssn
_435.patients_responsibility_estimatesprest_ssn
_435.precertspre_ssn
_435.precertspre_guarantor_ssn
_435.precertspre_ins1_insured_ssn
_435.precertspre_ins2_insured_ssn
_435.radiology_ordersrad_ssn
_435.radiology_resultsrad_res_ssn
_436.chartschrt_ssn
_436.cpoe_responsescpoe_res_ssn
_436.encountersenc_ssn
_436.encountersenc_guarantor_ssn
_436.encountersenc_ins1_insured_ssn
_436.encountersenc_ins2_insured_ssn
_436.encountersenc_ins3_insured_ssn
_436.examplesexa_ssn
_436.hl7_accessionsacc_ssn
_436.insurances_repositoryirep_ins_insured_ssn
_436.non_patientsnpat_ssn
_436.ordersord_ssn
_436.patientspat_ssn
_436.patientspat_guarantor_ssn
_436.patientspat_ins1_insured_ssn
_436.patientspat_ins2_insured_ssn
_436.patientspat_ins3_insured_ssn
_436.patients_demographics_snapshotspds_ssn
_436.patients_demographics_snapshotspds_guarantor_ssn
_436.patients_demographics_snapshotspds_ins1_insured_ssn
_436.patients_demographics_snapshotspds_ins2_insured_ssn
_436.patients_demographics_snapshotspds_ins3_insured_ssn
_436.patients_responsibility_estimatesprest_ssn
_436.precertspre_ssn
_436.precertspre_guarantor_ssn
_436.precertspre_ins1_insured_ssn
_436.precertspre_ins2_insured_ssn
_436.radiology_ordersrad_ssn
_436.radiology_resultsrad_res_ssn
_436_archive_testing.chartschrt_ssn
_436_archive_testing.cpoe_responsescpoe_res_ssn
_436_archive_testing.encountersenc_ssn
_436_archive_testing.encountersenc_guarantor_ssn
_436_archive_testing.encountersenc_ins1_insured_ssn
_436_archive_testing.encountersenc_ins2_insured_ssn
_436_archive_testing.encountersenc_ins3_insured_ssn
_436_archive_testing.examplesexa_ssn
_436_archive_testing.hl7_accessionsacc_ssn
_436_archive_testing.insurances_repositoryirep_ins_insured_ssn
_436_archive_testing.non_patientsnpat_ssn
_436_archive_testing.ordersord_ssn
_436_archive_testing.patientspat_ssn
_436_archive_testing.patientspat_guarantor_ssn
_436_archive_testing.patientspat_ins1_insured_ssn
_436_archive_testing.patientspat_ins2_insured_ssn
_436_archive_testing.patientspat_ins3_insured_ssn
_436_archive_testing.patients_demographics_snapshotspds_ssn
_436_archive_testing.patients_demographics_snapshotspds_guarantor_ssn
_436_archive_testing.patients_demographics_snapshotspds_ins1_insured_ssn
_436_archive_testing.patients_demographics_snapshotspds_ins2_insured_ssn
_436_archive_testing.patients_demographics_snapshotspds_ins3_insured_ssn
_436_archive_testing.patients_responsibility_estimatesprest_ssn
_436_archive_testing.precertspre_ssn
_436_archive_testing.precertspre_guarantor_ssn
_436_archive_testing.precertspre_ins1_insured_ssn
_436_archive_testing.precertspre_ins2_insured_ssn
_436_archive_testing.radiology_ordersrad_ssn
_436_archive_testing.radiology_resultsrad_res_ssn
_437.chartschrt_ssn
_437.cpoe_responsescpoe_res_ssn
_437.encountersenc_ssn
_437.encountersenc_guarantor_ssn
_437.encountersenc_ins1_insured_ssn
_437.encountersenc_ins2_insured_ssn
_437.encountersenc_ins3_insured_ssn
_437.examplesexa_ssn
_437.hl7_accessionsacc_ssn
_437.insurances_repositoryirep_ins_insured_ssn
_437.non_patientsnpat_ssn
_437.ordersord_ssn
_437.patientspat_ssn
_437.patientspat_guarantor_ssn
_437.patientspat_ins1_insured_ssn
_437.patientspat_ins2_insured_ssn
_437.patientspat_ins3_insured_ssn
_437.patients_demographics_snapshotspds_ssn
_437.patients_demographics_snapshotspds_guarantor_ssn
_437.patients_demographics_snapshotspds_ins1_insured_ssn
_437.patients_demographics_snapshotspds_ins2_insured_ssn
_437.patients_demographics_snapshotspds_ins3_insured_ssn
_437.patients_responsibility_estimatesprest_ssn
_437.precertspre_ssn
_437.precertspre_guarantor_ssn
_437.precertspre_ins1_insured_ssn
_437.precertspre_ins2_insured_ssn
_437.radiology_ordersrad_ssn
_437.radiology_resultsrad_res_ssn
_8.chartschrt_ssn
_8.cpoe_responsescpoe_res_ssn
_8.encountersenc_ssn
_8.encountersenc_guarantor_ssn
_8.encountersenc_ins1_insured_ssn
_8.encountersenc_ins2_insured_ssn
_8.encountersenc_ins3_insured_ssn
_8.examplesexa_ssn
_8.hl7_accessionsacc_ssn
_8.insurances_repositoryirep_ins_insured_ssn
_8.non_patientsnpat_ssn
_8.ordersord_ssn
_8.patientspat_ssn
_8.patientspat_guarantor_ssn
_8.patientspat_ins1_insured_ssn
_8.patientspat_ins2_insured_ssn
_8.patientspat_ins3_insured_ssn
_8.patients_demographics_snapshotspds_ssn
_8.patients_demographics_snapshotspds_guarantor_ssn
_8.patients_demographics_snapshotspds_ins1_insured_ssn
_8.patients_demographics_snapshotspds_ins2_insured_ssn
_8.patients_demographics_snapshotspds_ins3_insured_ssn
_8.patients_responsibility_estimatesprest_ssn
_8.precertspre_ssn
_8.precertspre_guarantor_ssn
_8.precertspre_ins1_insured_ssn
_8.precertspre_ins2_insured_ssn
_8.radiology_ordersrad_ssn
_8.radiology_resultsrad_res_ssn
_81.chartschrt_ssn
_81.cpoe_responsescpoe_res_ssn
_81.encountersenc_ssn
_81.encountersenc_guarantor_ssn
_81.encountersenc_ins1_insured_ssn
_81.encountersenc_ins2_insured_ssn
_81.encountersenc_ins3_insured_ssn
_81.examplesexa_ssn
_81.hl7_accessionsacc_ssn
_81.insurances_repositoryirep_ins_insured_ssn
_81.non_patientsnpat_ssn
_81.ordersord_ssn
_81.patientspat_ssn
_81.patientspat_guarantor_ssn
_81.patientspat_ins1_insured_ssn
_81.patientspat_ins2_insured_ssn
_81.patientspat_ins3_insured_ssn
_81.patients_demographics_snapshotspds_ssn
_81.patients_demographics_snapshotspds_guarantor_ssn
_81.patients_demographics_snapshotspds_ins1_insured_ssn
_81.patients_demographics_snapshotspds_ins2_insured_ssn
_81.patients_demographics_snapshotspds_ins3_insured_ssn
_81.patients_responsibility_estimatesprest_ssn
_81.precertspre_ssn
_81.precertspre_guarantor_ssn
_81.precertspre_ins1_insured_ssn
_81.precertspre_ins2_insured_ssn
_81.radiology_ordersrad_ssn
_81.radiology_resultsrad_res_ssn
_999.chartschrt_ssn
_999.cpoe_responsescpoe_res_ssn
_999.encountersenc_ssn
_999.encountersenc_guarantor_ssn
_999.encountersenc_ins1_insured_ssn
_999.encountersenc_ins2_insured_ssn
_999.encountersenc_ins3_insured_ssn
_999.examplesexa_ssn
_999.hl7_accessionsacc_ssn
_999.insurances_repositoryirep_ins_insured_ssn
_999.non_patientsnpat_ssn
_999.ordersord_ssn
_999.patientspat_ssn
_999.patientspat_guarantor_ssn
_999.patientspat_ins1_insured_ssn
_999.patientspat_ins2_insured_ssn
_999.patientspat_ins3_insured_ssn
_999.patients_demographics_snapshotspds_ssn
_999.patients_demographics_snapshotspds_guarantor_ssn
_999.patients_demographics_snapshotspds_ins1_insured_ssn
_999.patients_demographics_snapshotspds_ins2_insured_ssn
_999.patients_demographics_snapshotspds_ins3_insured_ssn
_999.patients_responsibility_estimatesprest_ssn
_999.precertspre_ssn
_999.precertspre_guarantor_ssn
_999.precertspre_ins1_insured_ssn
_999.precertspre_ins2_insured_ssn
_999.radiology_ordersrad_ssn
_999.radiology_resultsrad_res_ssn
aurora_standard.abmmpigu_ssn
aurora_standard.abmvisgu_ssn
aurora_standard.adupguguar_ssn
aurora_standard.aswguarguar_ssn
aurora_standard.b2baddp_ssn
aurora_standard.b2mrdrp_ssn
aurora_standard.bdallvispat_ssn
aurora_standard.bdguarguar_ssn
aurora_standard.bdmpip_ssn
aurora_standard.bdmpisp_ssn
aurora_standard.bdvispat_ssn
aurora_standard.bevisp_ssn
aurora_standard.bevisbdp_ssn
aurora_standard.bevisbd2p_ssn
aurora_standard.bharp_ssn
aurora_standard.bharnew_ssn
aurora_standard.bharg_ssn
aurora_standard.bhbaddp_ssn
aurora_standard.bhguarguar_ssn
aurora_standard.bhldgrp_ssn
aurora_standard.bhldgrguar_ssn
aurora_standard.bhmrdrp_ssn
aurora_standard.bhppatp_ssn
aurora_standard.bhtguarguar_ssn
aurora_standard.bhtldgrp_ssn
aurora_standard.bhtldgrguar_ssn
aurora_standard.bhtmrdrp_ssn
aurora_standard.bhtppatp_ssn
aurora_standard.bmguarguar_ssn
aurora_standard.bmmpip_ssn
aurora_standard.bmnkinn_ssn
aurora_standard.bmpactp_ssn
aurora_standard.bmpatp_ssn
aurora_standard.bparp_ssn
aurora_standard.bparnew_ssn
aurora_standard.bparg_ssn
aurora_standard.bpar2p_ssn
aurora_standard.bpar2new_ssn
aurora_standard.bpar2g_ssn
aurora_standard.bpmpip_ssn
aurora_standard.bpmpi2p_ssn
aurora_standard.bpmrp_ssn
aurora_standard.bpmr2p_ssn
aurora_standard.bsguarguar_ssn
aurora_standard.bsinsurspouse_ssn
aurora_standard.bsvispat_ssn
aurora_standard.bsvisbdpat_ssn
aurora_standard.bvguargu_ssn
aurora_standard.bvmpip_ssn
aurora_standard.bvmpi2p_ssn
aurora_standard.c7guarrguar_ssn
aurora_standard.c7mpip_ssn
aurora_standard.c7mpigu_ssn
aurora_standard.c7vispat_ssn
aurora_standard.c8dtlsp_ssn
aurora_standard.c8guarguar_ssn
aurora_standard.c8guar2guar_ssn
aurora_standard.c9mpip_ssn
aurora_standard.c9visp_ssn
aurora_standard.cafcpat_ssn
aurora_standard.caguarrguar_ssn
aurora_standard.campispouse_ssn
aurora_standard.cavispat_ssn
aurora_standard.cavishpat_ssn
aurora_standard.chhl7in2ins_ssn
aurora_standard.chlmdssdprev_ssn
aurora_standard.chltrnsdprev_ssn
aurora_standard.chmarcnbfg_ssn
aurora_standard.chmarcnbfp_ssn
aurora_standard.chmarsipat_ssn
aurora_standard.chmarsigu_ssn
aurora_standard.chmarsisp_ssn
aurora_standard.chmazstdpat_ssn
aurora_standard.chmazstipat_ssn
aurora_standard.chmazstopat_ssn
aurora_standard.chmcampipat_ssn
aurora_standard.chmcampigu_ssn
aurora_standard.chmcampisp_ssn
aurora_standard.chmcmheddebtor_1_ssn
aurora_standard.chmcmheddebtor_2_ssn
aurora_standard.chmcmhedpat_ssn
aurora_standard.chmcssndnew_ssn
aurora_standard.chmcssndold_ssn
aurora_standard.chmexmpipat_ssn
aurora_standard.chmexmpigu_ssn
aurora_standard.chmexmpisp_ssn
aurora_standard.chmexvispat_ssn
aurora_standard.chmguarrguar_ssn
aurora_standard.chmhistpp_ssn
aurora_standard.chmlastrpat_ssn
aurora_standard.chmmhastpat_ssn
aurora_standard.chmokipdpat_ssn
aurora_standard.chmokopdpat_ssn
aurora_standard.chmopercauto_ssn
aurora_standard.chmozpcddebtor_1_ssn
aurora_standard.chmozpcddebtor_2_ssn
aurora_standard.chmpatmrspouse_ssn
aurora_standard.chmpatwcmom_ssn
aurora_standard.chmpatwcdad_ssn
aurora_standard.chmpdemop_ssn
aurora_standard.chmpdemosp_ssn
aurora_standard.chmpdemogu_ssn
aurora_standard.chmradexpat_ssn
aurora_standard.chmradexgu_ssn
aurora_standard.chmradexsp_ssn
aurora_standard.chmtxstrpat_ssn
aurora_standard.chpcobdddep_ssn
aurora_standard.chpdepeddepend_ssn
aurora_standard.chpempddperson_ssn
aurora_standard.chxcntrcid_is_ssn
aurora_standard.hl7gt1guar_ssn
aurora_standard.hl7gt1adguar_ssn
aurora_standard.hl7in2ins_ssn
aurora_standard.hl7in2adins_ssn
aurora_standard.hl7pidpat_ssn
aurora_standard.hl7pidadpat_ssn
aurora_standard.kcvispat_ssn
aurora_standard.kcvisitpat_ssn
aurora_standard.nbspousespouse_ssn
aurora_standard.ncexmpipat_ssn
aurora_standard.oddpayddempl_ssn
aurora_standard.oddpayidempl_ssn
aurora_standard.oddpayodempl_ssn
aurora_standard.oddpayreempl_ssn
aurora_standard.odhpayddempl_ssn
aurora_standard.odhpayidempl_ssn
aurora_standard.odhpayodempl_ssn
aurora_standard.odhpayreempl_ssn
aurora_standard.styoempddepend_ssn
common.customerscus_require_ssn
taxonomy
TableColumn
_1.locationsloc_taxonomy
_1.physiciansphy_taxonomy
_1188.locationsloc_taxonomy
_1188.physiciansphy_taxonomy
_1218.locationsloc_taxonomy
_1218.physiciansphy_taxonomy
_1548.locationsloc_taxonomy
_1548.physiciansphy_taxonomy
_435.locationsloc_taxonomy
_435.physiciansphy_taxonomy
_436.locationsloc_taxonomy
_436.physiciansphy_taxonomy
_436_archive_testing.locationsloc_taxonomy
_436_archive_testing.physiciansphy_taxonomy
_437.locationsloc_taxonomy
_437.physiciansphy_taxonomy
_8.locationsloc_taxonomy
_8.physiciansphy_taxonomy
_81.locationsloc_taxonomy
_81.physiciansphy_taxonomy
_999.locationsloc_taxonomy
_999.physiciansphy_taxonomy
aurora_standard.chmutah6att_taxonomy
aurora_standard.chmutah6op_taxonomy
aurora_standard.chmutah6oth_taxonomy
aurora_standard.chmutah6ren_taxonomy
aurora_standard.chmutah6ref_taxonomy
common.clientscli_taxonomy
oth_no
TableColumn
aurora_standard.chmpriccgl_oth_no
aurora_standard.glspricegl_oth_no
aurora_standard.stiinvtrgl_oth_no
aurora_standard.ttiinvtrgl_oth_no