aurora_standard.stxpermr

Field Type Null Default Key Extra Comment
user_id varchar(8) YES UNI
lname varchar(20) YES
fname varchar(20) YES
minitial varchar(1) YES
company varchar(30) YES
dept varchar(15) YES
responsibility varchar(30) YES
phone varchar(15) YES
pattern varchar(8) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
fname
TableColumn
Azalea.employeesemp_fname
_1.billing_providersbp_fname
_1.chartschrt_fname
_1.client_contactsclicon_fname
_1.cpoe_responsescpoe_res_fname
_1.donorsdon_fname
_1.encountersenc_fname
_1.encounters_soap_templatesest_phy_fname
_1.hl7_accessionsacc_fname
_1.non_patientsnpat_fname
_1.ordersord_fname
_1.patient_next_of_kinpnk_fname
_1.patientspat_fname
_1.patientspat_birth_fname
_1.patients_demographics_snapshotspds_fname
_1.patients_namespn_fname
_1.patients_responsibility_estimatesprest_fname
_1.physiciansphy_fname
_1.precertspre_fname
_1.radiology_ordersrad_fname
_1.radiology_resultsrad_res_fname
_1188.billing_providersbp_fname
_1188.chartschrt_fname
_1188.client_contactsclicon_fname
_1188.cpoe_responsescpoe_res_fname
_1188.donorsdon_fname
_1188.encountersenc_fname
_1188.encounters_soap_templatesest_phy_fname
_1188.hl7_accessionsacc_fname
_1188.non_patientsnpat_fname
_1188.ordersord_fname
_1188.patient_next_of_kinpnk_fname
_1188.patientspat_fname
_1188.patientspat_birth_fname
_1188.patients_demographics_snapshotspds_fname
_1188.patients_namespn_fname
_1188.patients_responsibility_estimatesprest_fname
_1188.physiciansphy_fname
_1188.precertspre_fname
_1188.radiology_ordersrad_fname
_1188.radiology_resultsrad_res_fname
_1218.billing_providersbp_fname
_1218.chartschrt_fname
_1218.client_contactsclicon_fname
_1218.cpoe_responsescpoe_res_fname
_1218.donorsdon_fname
_1218.encountersenc_fname
_1218.encounters_soap_templatesest_phy_fname
_1218.hl7_accessionsacc_fname
_1218.non_patientsnpat_fname
_1218.ordersord_fname
_1218.patient_next_of_kinpnk_fname
_1218.patientspat_fname
_1218.patientspat_birth_fname
_1218.patients_demographics_snapshotspds_fname
_1218.patients_namespn_fname
_1218.patients_responsibility_estimatesprest_fname
_1218.physiciansphy_fname
_1218.precertspre_fname
_1218.radiology_ordersrad_fname
_1218.radiology_resultsrad_res_fname
_1548.billing_providersbp_fname
_1548.chartschrt_fname
_1548.client_contactsclicon_fname
_1548.cpoe_responsescpoe_res_fname
_1548.donorsdon_fname
_1548.encountersenc_fname
_1548.encounters_soap_templatesest_phy_fname
_1548.hl7_accessionsacc_fname
_1548.non_patientsnpat_fname
_1548.ordersord_fname
_1548.patient_next_of_kinpnk_fname
_1548.patientspat_fname
_1548.patientspat_birth_fname
_1548.patients_demographics_snapshotspds_fname
_1548.patients_namespn_fname
_1548.patients_responsibility_estimatesprest_fname
_1548.physiciansphy_fname
_1548.precertspre_fname
_1548.radiology_ordersrad_fname
_1548.radiology_resultsrad_res_fname
_435.billing_providersbp_fname
_435.chartschrt_fname
_435.client_contactsclicon_fname
_435.cpoe_responsescpoe_res_fname
_435.donorsdon_fname
_435.encountersenc_fname
_435.encounters_soap_templatesest_phy_fname
_435.hl7_accessionsacc_fname
_435.non_patientsnpat_fname
_435.ordersord_fname
_435.patient_next_of_kinpnk_fname
_435.patientspat_fname
_435.patientspat_birth_fname
_435.patients_demographics_snapshotspds_fname
_435.patients_namespn_fname
_435.patients_responsibility_estimatesprest_fname
_435.physiciansphy_fname
_435.precertspre_fname
_435.radiology_ordersrad_fname
_435.radiology_resultsrad_res_fname
_436.billing_providersbp_fname
_436.chartschrt_fname
_436.client_contactsclicon_fname
_436.cpoe_responsescpoe_res_fname
_436.donorsdon_fname
_436.encountersenc_fname
_436.encounters_soap_templatesest_phy_fname
_436.hl7_accessionsacc_fname
_436.non_patientsnpat_fname
_436.ordersord_fname
_436.patient_next_of_kinpnk_fname
_436.patientspat_fname
_436.patientspat_birth_fname
_436.patients_demographics_snapshotspds_fname
_436.patients_namespn_fname
_436.patients_responsibility_estimatesprest_fname
_436.physiciansphy_fname
_436.precertspre_fname
_436.radiology_ordersrad_fname
_436.radiology_resultsrad_res_fname
_436_archive_testing.billing_providersbp_fname
_436_archive_testing.chartschrt_fname
_436_archive_testing.client_contactsclicon_fname
_436_archive_testing.cpoe_responsescpoe_res_fname
_436_archive_testing.donorsdon_fname
_436_archive_testing.encountersenc_fname
_436_archive_testing.encounters_soap_templatesest_phy_fname
_436_archive_testing.hl7_accessionsacc_fname
_436_archive_testing.non_patientsnpat_fname
_436_archive_testing.ordersord_fname
_436_archive_testing.patient_next_of_kinpnk_fname
_436_archive_testing.patientspat_fname
_436_archive_testing.patientspat_birth_fname
_436_archive_testing.patients_demographics_snapshotspds_fname
_436_archive_testing.patients_responsibility_estimatesprest_fname
_436_archive_testing.physiciansphy_fname
_436_archive_testing.precertspre_fname
_436_archive_testing.radiology_ordersrad_fname
_436_archive_testing.radiology_resultsrad_res_fname
_437.billing_providersbp_fname
_437.chartschrt_fname
_437.client_contactsclicon_fname
_437.cpoe_responsescpoe_res_fname
_437.donorsdon_fname
_437.encountersenc_fname
_437.encounters_soap_templatesest_phy_fname
_437.hl7_accessionsacc_fname
_437.non_patientsnpat_fname
_437.ordersord_fname
_437.patient_next_of_kinpnk_fname
_437.patientspat_fname
_437.patientspat_birth_fname
_437.patients_demographics_snapshotspds_fname
_437.patients_namespn_fname
_437.patients_responsibility_estimatesprest_fname
_437.physiciansphy_fname
_437.precertspre_fname
_437.radiology_ordersrad_fname
_437.radiology_resultsrad_res_fname
_8.billing_providersbp_fname
_8.chartschrt_fname
_8.client_contactsclicon_fname
_8.cpoe_responsescpoe_res_fname
_8.donorsdon_fname
_8.encountersenc_fname
_8.encounters_soap_templatesest_phy_fname
_8.hl7_accessionsacc_fname
_8.non_patientsnpat_fname
_8.ordersord_fname
_8.patient_next_of_kinpnk_fname
_8.patientspat_fname
_8.patientspat_birth_fname
_8.patients_demographics_snapshotspds_fname
_8.patients_namespn_fname
_8.patients_responsibility_estimatesprest_fname
_8.physiciansphy_fname
_8.precertspre_fname
_8.radiology_ordersrad_fname
_8.radiology_resultsrad_res_fname
_81.billing_providersbp_fname
_81.chartschrt_fname
_81.client_contactsclicon_fname
_81.cpoe_responsescpoe_res_fname
_81.donorsdon_fname
_81.encountersenc_fname
_81.encounters_soap_templatesest_phy_fname
_81.hl7_accessionsacc_fname
_81.non_patientsnpat_fname
_81.ordersord_fname
_81.patient_next_of_kinpnk_fname
_81.patientspat_fname
_81.patientspat_birth_fname
_81.patients_demographics_snapshotspds_fname
_81.patients_namespn_fname
_81.patients_responsibility_estimatesprest_fname
_81.physiciansphy_fname
_81.precertspre_fname
_81.radiology_ordersrad_fname
_81.radiology_resultsrad_res_fname
_999.billing_providersbp_fname
_999.chartschrt_fname
_999.client_contactsclicon_fname
_999.cpoe_responsescpoe_res_fname
_999.donorsdon_fname
_999.encountersenc_fname
_999.encounters_soap_templatesest_phy_fname
_999.hl7_accessionsacc_fname
_999.non_patientsnpat_fname
_999.ordersord_fname
_999.patient_next_of_kinpnk_fname
_999.patientspat_fname
_999.patientspat_birth_fname
_999.patients_demographics_snapshotspds_fname
_999.patients_namespn_fname
_999.patients_responsibility_estimatesprest_fname
_999.physiciansphy_fname
_999.precertspre_fname
_999.radiology_ordersrad_fname
_999.radiology_resultsrad_res_fname
aurora_standard.abmmpigu_fname
aurora_standard.abmmpin1_fname
aurora_standard.abmmpin2_fname
aurora_standard.abmvisgu_fname
aurora_standard.bharg_fname
aurora_standard.bmnkinn_fname
aurora_standard.bparg_fname
aurora_standard.bpar2g_fname
aurora_standard.c7mpigu_fname
aurora_standard.chmarstphatt_fname
aurora_standard.chmarstphsur_fname
aurora_standard.chmarstphoth_fname
aurora_standard.chmarstphoth2_fname
aurora_standard.chmarstpoatt_fname
aurora_standard.chmarstposur_fname
aurora_standard.chmarstpooth_fname
aurora_standard.chmarstpooth2_fname
aurora_standard.chmhcahpdr_fname
aurora_standard.chmlastrpat_fname
aurora_standard.chmlastradm_phy_fname
aurora_standard.chmlastrrnd_phy_fname
aurora_standard.chmlastrref_phy_fname
aurora_standard.chmlastratt_phy_fname
aurora_standard.chmlastrop_phy_fname
aurora_standard.chmlastroth_phy_fname
aurora_standard.chmlastrsub_fname
aurora_standard.chmpdemop_fname
aurora_standard.chmpdemosp_fname
aurora_standard.chmpdemogu_fname
aurora_standard.chmpdemofam_phy_fname
aurora_standard.chmpdemoattend_phy_fname
aurora_standard.chmpdemoadmit_phy_fname
aurora_standard.chmpsvcdrend_fname
aurora_standard.chmpsvcdref_fname
aurora_standard.chmtxstrpat_fname
aurora_standard.chmtxstratt_phy_fname
aurora_standard.chmtxstrop_phy_fname
aurora_standard.chmtxstrcons_phy_fname
aurora_standard.styoctcccontact_fname
aurora_standard.styoctccgov_entity_contact_person_fname
aurora_standard.styoempddepend_fname
aurora_standard.styoemprempl_fname
common.applicantsapp_fname
common.contactscon_fname
common.dashboardmd_usersdmdu_fname
common.usersusr_fname
template_library.encounters_soap_templatesest_phy_fname
lname
TableColumn
Azalea.employeesemp_lname
_1.billing_providersbp_lname
_1.chartschrt_lname
_1.client_contactsclicon_lname
_1.cpoe_responsescpoe_res_lname
_1.donorsdon_lname
_1.encountersenc_lname
_1.encounters_soap_templatesest_phy_lname
_1.hl7_accessionsacc_lname
_1.non_patientsnpat_lname
_1.ordersord_lname
_1.patient_next_of_kinpnk_lname
_1.patientspat_lname
_1.patientspat_birth_lname
_1.patients_demographics_snapshotspds_lname
_1.patients_namespn_lname
_1.patients_responsibility_estimatesprest_lname
_1.physiciansphy_lname
_1.precertspre_lname
_1.radiology_ordersrad_lname
_1.radiology_resultsrad_res_lname
_1188.billing_providersbp_lname
_1188.chartschrt_lname
_1188.client_contactsclicon_lname
_1188.cpoe_responsescpoe_res_lname
_1188.donorsdon_lname
_1188.encountersenc_lname
_1188.encounters_soap_templatesest_phy_lname
_1188.hl7_accessionsacc_lname
_1188.non_patientsnpat_lname
_1188.ordersord_lname
_1188.patient_next_of_kinpnk_lname
_1188.patientspat_lname
_1188.patientspat_birth_lname
_1188.patients_demographics_snapshotspds_lname
_1188.patients_namespn_lname
_1188.patients_responsibility_estimatesprest_lname
_1188.physiciansphy_lname
_1188.precertspre_lname
_1188.radiology_ordersrad_lname
_1188.radiology_resultsrad_res_lname
_1218.billing_providersbp_lname
_1218.chartschrt_lname
_1218.client_contactsclicon_lname
_1218.cpoe_responsescpoe_res_lname
_1218.donorsdon_lname
_1218.encountersenc_lname
_1218.encounters_soap_templatesest_phy_lname
_1218.hl7_accessionsacc_lname
_1218.non_patientsnpat_lname
_1218.ordersord_lname
_1218.patient_next_of_kinpnk_lname
_1218.patientspat_lname
_1218.patientspat_birth_lname
_1218.patients_demographics_snapshotspds_lname
_1218.patients_namespn_lname
_1218.patients_responsibility_estimatesprest_lname
_1218.physiciansphy_lname
_1218.precertspre_lname
_1218.radiology_ordersrad_lname
_1218.radiology_resultsrad_res_lname
_1548.billing_providersbp_lname
_1548.chartschrt_lname
_1548.client_contactsclicon_lname
_1548.cpoe_responsescpoe_res_lname
_1548.donorsdon_lname
_1548.encountersenc_lname
_1548.encounters_soap_templatesest_phy_lname
_1548.hl7_accessionsacc_lname
_1548.non_patientsnpat_lname
_1548.ordersord_lname
_1548.patient_next_of_kinpnk_lname
_1548.patientspat_lname
_1548.patientspat_birth_lname
_1548.patients_demographics_snapshotspds_lname
_1548.patients_namespn_lname
_1548.patients_responsibility_estimatesprest_lname
_1548.physiciansphy_lname
_1548.precertspre_lname
_1548.radiology_ordersrad_lname
_1548.radiology_resultsrad_res_lname
_435.billing_providersbp_lname
_435.chartschrt_lname
_435.client_contactsclicon_lname
_435.cpoe_responsescpoe_res_lname
_435.donorsdon_lname
_435.encountersenc_lname
_435.encounters_soap_templatesest_phy_lname
_435.hl7_accessionsacc_lname
_435.non_patientsnpat_lname
_435.ordersord_lname
_435.patient_next_of_kinpnk_lname
_435.patientspat_lname
_435.patientspat_birth_lname
_435.patients_demographics_snapshotspds_lname
_435.patients_namespn_lname
_435.patients_responsibility_estimatesprest_lname
_435.physiciansphy_lname
_435.precertspre_lname
_435.radiology_ordersrad_lname
_435.radiology_resultsrad_res_lname
_436.billing_providersbp_lname
_436.chartschrt_lname
_436.client_contactsclicon_lname
_436.cpoe_responsescpoe_res_lname
_436.donorsdon_lname
_436.encountersenc_lname
_436.encounters_soap_templatesest_phy_lname
_436.hl7_accessionsacc_lname
_436.non_patientsnpat_lname
_436.ordersord_lname
_436.patient_next_of_kinpnk_lname
_436.patientspat_lname
_436.patientspat_birth_lname
_436.patients_demographics_snapshotspds_lname
_436.patients_namespn_lname
_436.patients_responsibility_estimatesprest_lname
_436.physiciansphy_lname
_436.precertspre_lname
_436.radiology_ordersrad_lname
_436.radiology_resultsrad_res_lname
_436_archive_testing.billing_providersbp_lname
_436_archive_testing.chartschrt_lname
_436_archive_testing.client_contactsclicon_lname
_436_archive_testing.cpoe_responsescpoe_res_lname
_436_archive_testing.donorsdon_lname
_436_archive_testing.encountersenc_lname
_436_archive_testing.encounters_soap_templatesest_phy_lname
_436_archive_testing.hl7_accessionsacc_lname
_436_archive_testing.non_patientsnpat_lname
_436_archive_testing.ordersord_lname
_436_archive_testing.patient_next_of_kinpnk_lname
_436_archive_testing.patientspat_lname
_436_archive_testing.patientspat_birth_lname
_436_archive_testing.patients_demographics_snapshotspds_lname
_436_archive_testing.patients_responsibility_estimatesprest_lname
_436_archive_testing.physiciansphy_lname
_436_archive_testing.precertspre_lname
_436_archive_testing.radiology_ordersrad_lname
_436_archive_testing.radiology_resultsrad_res_lname
_437.billing_providersbp_lname
_437.chartschrt_lname
_437.client_contactsclicon_lname
_437.cpoe_responsescpoe_res_lname
_437.donorsdon_lname
_437.encountersenc_lname
_437.encounters_soap_templatesest_phy_lname
_437.hl7_accessionsacc_lname
_437.non_patientsnpat_lname
_437.ordersord_lname
_437.patient_next_of_kinpnk_lname
_437.patientspat_lname
_437.patientspat_birth_lname
_437.patients_demographics_snapshotspds_lname
_437.patients_namespn_lname
_437.patients_responsibility_estimatesprest_lname
_437.physiciansphy_lname
_437.precertspre_lname
_437.radiology_ordersrad_lname
_437.radiology_resultsrad_res_lname
_8.billing_providersbp_lname
_8.chartschrt_lname
_8.client_contactsclicon_lname
_8.cpoe_responsescpoe_res_lname
_8.donorsdon_lname
_8.encountersenc_lname
_8.encounters_soap_templatesest_phy_lname
_8.hl7_accessionsacc_lname
_8.non_patientsnpat_lname
_8.ordersord_lname
_8.patient_next_of_kinpnk_lname
_8.patientspat_lname
_8.patientspat_birth_lname
_8.patients_demographics_snapshotspds_lname
_8.patients_namespn_lname
_8.patients_responsibility_estimatesprest_lname
_8.physiciansphy_lname
_8.precertspre_lname
_8.radiology_ordersrad_lname
_8.radiology_resultsrad_res_lname
_81.billing_providersbp_lname
_81.chartschrt_lname
_81.client_contactsclicon_lname
_81.cpoe_responsescpoe_res_lname
_81.donorsdon_lname
_81.encountersenc_lname
_81.encounters_soap_templatesest_phy_lname
_81.hl7_accessionsacc_lname
_81.non_patientsnpat_lname
_81.ordersord_lname
_81.patient_next_of_kinpnk_lname
_81.patientspat_lname
_81.patientspat_birth_lname
_81.patients_demographics_snapshotspds_lname
_81.patients_namespn_lname
_81.patients_responsibility_estimatesprest_lname
_81.physiciansphy_lname
_81.precertspre_lname
_81.radiology_ordersrad_lname
_81.radiology_resultsrad_res_lname
_999.billing_providersbp_lname
_999.chartschrt_lname
_999.client_contactsclicon_lname
_999.cpoe_responsescpoe_res_lname
_999.donorsdon_lname
_999.encountersenc_lname
_999.encounters_soap_templatesest_phy_lname
_999.hl7_accessionsacc_lname
_999.non_patientsnpat_lname
_999.ordersord_lname
_999.patient_next_of_kinpnk_lname
_999.patientspat_lname
_999.patientspat_birth_lname
_999.patients_demographics_snapshotspds_lname
_999.patients_namespn_lname
_999.patients_responsibility_estimatesprest_lname
_999.physiciansphy_lname
_999.precertspre_lname
_999.radiology_ordersrad_lname
_999.radiology_resultsrad_res_lname
aurora_standard.abmmpigu_lname
aurora_standard.abmmpin1_lname
aurora_standard.abmmpin2_lname
aurora_standard.abmvisgu_lname
aurora_standard.bharg_lname
aurora_standard.bmnkinn_lname
aurora_standard.bparg_lname
aurora_standard.bpar2g_lname
aurora_standard.c7mpigu_lname
aurora_standard.chmarstphatt_lname
aurora_standard.chmarstphsur_lname
aurora_standard.chmarstphoth_lname
aurora_standard.chmarstphoth2_lname
aurora_standard.chmarstpoatt_lname
aurora_standard.chmarstposur_lname
aurora_standard.chmarstpooth_lname
aurora_standard.chmarstpooth2_lname
aurora_standard.chmhcahpdr_lname
aurora_standard.chmlastrpat_lname
aurora_standard.chmlastradm_phy_lname
aurora_standard.chmlastrrnd_phy_lname
aurora_standard.chmlastrref_phy_lname
aurora_standard.chmlastratt_phy_lname
aurora_standard.chmlastrop_phy_lname
aurora_standard.chmlastroth_phy_lname
aurora_standard.chmlastrsub_lname
aurora_standard.chmlastroth_sub_lname
aurora_standard.chmpdemop_lname
aurora_standard.chmpdemosp_lname
aurora_standard.chmpdemogu_lname
aurora_standard.chmpdemofam_phy_lname
aurora_standard.chmpdemoattend_phy_lname
aurora_standard.chmpdemoadmit_phy_lname
aurora_standard.chmpsvcdrend_lname
aurora_standard.chmpsvcdref_lname
aurora_standard.chmtxstrpat_lname
aurora_standard.chmtxstratt_phy_lname
aurora_standard.chmtxstrop_phy_lname
aurora_standard.chmtxstrcons_phy_lname
aurora_standard.styoctcccontact_lname
aurora_standard.styoctccgov_entity_contact_person_lname
aurora_standard.styoempddepend_lname
aurora_standard.styoemprempl_lname
common.applicantsapp_lname
common.contactscon_lname
common.dashboardmd_usersdmdu_lname
common.usersusr_lname
template_library.encounters_soap_templatesest_phy_lname
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
user_id
TableColumn
HSPI_CURES2015_B1.patient_abstractscompleted_by_user_id
HSPI_Central_Hospital.patient_abstractscompleted_by_user_id
HSPI_Dewitt.patient_abstractscompleted_by_user_id
HSPI_Fulton.patient_abstractscompleted_by_user_id
HSPI_Inferno.patient_abstractscompleted_by_user_id
HSPI_MU2015_E1.patient_abstractscompleted_by_user_id
HSPI_MU2015_G2.patient_abstractscompleted_by_user_id
HSPI_MU2015_G9.patient_abstractscompleted_by_user_id
HSPI_Sandbox.patient_abstractscompleted_by_user_id
HSPI_Summit_General.patient_abstractscompleted_by_user_id
HSPI_United_Physicians.patient_abstractscompleted_by_user_id
MPI.patient_abstractscompleted_by_user_id
SSO.login_eventsspoofed_user_id
SSO.user_registrationinvited_by_user_id
company
TableColumn
_1.patients_implantable_devicespid_company
_1188.patients_implantable_devicespid_company
_1218.patients_implantable_devicespid_company
_1548.patients_implantable_devicespid_company
_435.patients_implantable_devicespid_company
_436.patients_implantable_devicespid_company
_436_archive_testing.patients_implantable_devicespid_company
_437.patients_implantable_devicespid_company
_8.patients_implantable_devicespid_company
_81.patients_implantable_devicespid_company
_999.patients_implantable_devicespid_company
aurora_standard.c7insurins_company
aurora_standard.c7insur2ins_company
aurora_standard.c7insur3ins_company
aurora_standard.c9insins_company
aurora_standard.cainsins_company
common.contactscon_company
common.faxesfax_company
dept
TableColumn
aurora_standard.TABLE 1424new_dept
aurora_standard.TABLE 1425new_dept
aurora_standard.axlscdmgl_ip_dept
aurora_standard.axlscdmgl_op_dept
aurora_standard.chmpchsdrev_loc_dept
aurora_standard.chmrefndcontr_dept
aurora_standard.chpcashrcash_dept
aurora_standard.chpcemprhome_dept
aurora_standard.chpcntrceduc_dept
aurora_standard.chpcntrccobra_cash_dept
aurora_standard.chpcntrccobra_bal_dept
aurora_standard.chpcntrccobra_fee_dept
aurora_standard.chpcobpdcash_dept
aurora_standard.chpcobpdbal_dept
aurora_standard.chpempcdempl_dept
aurora_standard.chtemplrdflt_dept
aurora_standard.chteshtvdflt_dept
aurora_standard.chtsfdpdshift_dept
aurora_standard.chtsupvcsupv_dept
aurora_standard.empldepthome_dept
aurora_standard.glxrefnew_dept
aurora_standard.glxrefold_dept
aurora_standard.ohofadtldepr_dept
aurora_standard.stfactvddepr_dept
aurora_standard.stfactvvdepr_dept
aurora_standard.stfasstrdepr_dept
aurora_standard.stfasstraccm_dept
aurora_standard.stgrowpdrod_beg_dept
aurora_standard.stgrowpdrod_end_dept
aurora_standard.stoinvcetd_ds_dept
aurora_standard.stoinvcest_tx_dept
aurora_standard.stoinvceco_tx_dept
aurora_standard.stoinvceci_tx_dept
aurora_standard.stoinvcefreight_dept
aurora_standard.stoinvceasset_dept
aurora_standard.stoordrdinv_dept
aurora_standard.stoordrdsls_dept
aurora_standard.stoordrdcog_dept
aurora_standard.stxcalixmedgenix_dept
aurora_standard.stxcalixcalifornia_dept
aurora_standard.stxfinsdfin_dept
aurora_standard.styaccrrliab_dept
aurora_standard.styaccrrexpense_dept
aurora_standard.stydedcrdflt_dept
aurora_standard.styemplrhome_dept
aurora_standard.styemplrdir_dept
aurora_standard.styempodbal_dept
aurora_standard.styinccrdflt_dept
aurora_standard.styinccracru_lia_dept
aurora_standard.styoblcrdflt_dept
aurora_standard.stypayodbal_dept
aurora_standard.stytypodbal_dept
common.test_codestco_x_lab_area_dept