aurora_standard.stywthre

Field Type Null Default Key Extra Comment
contact varchar(20) YES
phone_area_code varchar(3) YES
phone_no varchar(8) YES
fax_area_code varchar(3) YES
fax_no varchar(8) YES
email varchar(18) YES
title varchar(20) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
title
TableColumn
Azalea.employeesemp_title
AzaleaStats.pull_requestspull_title
_1.billing_reports_queuebrq_title
_1.clinical_interventions_test_codes_mapcitcm_reporting_title
_1.daily_close_schedulesdcs_title
_1.encounters_formsefrm_title
_1.encounters_soap_templatesest_phy_title
_1.erx_notificationserx_nots_title
_1.formsfrm_title
_1.handoutshand_title
_1.notesnot_title
_1.orders_test_codes_mapotcm_reporting_title
_1.radiology_orders_test_codes_maprtcm_reporting_title
_1.radiology_results_test_codes_maprrtcm_reporting_title
_1.reports_queuerq_title
_1188.billing_reports_queuebrq_title
_1188.clinical_interventions_test_codes_mapcitcm_reporting_title
_1188.daily_close_schedulesdcs_title
_1188.encounters_formsefrm_title
_1188.encounters_soap_templatesest_phy_title
_1188.erx_notificationserx_nots_title
_1188.formsfrm_title
_1188.handoutshand_title
_1188.notesnot_title
_1188.orders_test_codes_mapotcm_reporting_title
_1188.radiology_orders_test_codes_maprtcm_reporting_title
_1188.radiology_results_test_codes_maprrtcm_reporting_title
_1188.reports_queuerq_title
_1218.billing_reports_queuebrq_title
_1218.clinical_interventions_test_codes_mapcitcm_reporting_title
_1218.daily_close_schedulesdcs_title
_1218.encounters_formsefrm_title
_1218.encounters_soap_templatesest_phy_title
_1218.erx_notificationserx_nots_title
_1218.formsfrm_title
_1218.handoutshand_title
_1218.notesnot_title
_1218.orders_test_codes_mapotcm_reporting_title
_1218.radiology_orders_test_codes_maprtcm_reporting_title
_1218.radiology_results_test_codes_maprrtcm_reporting_title
_1218.reports_queuerq_title
_1548.billing_reports_queuebrq_title
_1548.clinical_interventions_test_codes_mapcitcm_reporting_title
_1548.daily_close_schedulesdcs_title
_1548.encounters_formsefrm_title
_1548.encounters_soap_templatesest_phy_title
_1548.erx_notificationserx_nots_title
_1548.formsfrm_title
_1548.handoutshand_title
_1548.notesnot_title
_1548.orders_test_codes_mapotcm_reporting_title
_1548.radiology_orders_test_codes_maprtcm_reporting_title
_1548.radiology_results_test_codes_maprrtcm_reporting_title
_1548.reports_queuerq_title
_435.billing_reports_queuebrq_title
_435.clinical_interventions_test_codes_mapcitcm_reporting_title
_435.daily_close_schedulesdcs_title
_435.encounters_formsefrm_title
_435.encounters_soap_templatesest_phy_title
_435.erx_notificationserx_nots_title
_435.formsfrm_title
_435.handoutshand_title
_435.notesnot_title
_435.orders_test_codes_mapotcm_reporting_title
_435.radiology_orders_test_codes_maprtcm_reporting_title
_435.radiology_results_test_codes_maprrtcm_reporting_title
_435.reports_queuerq_title
_436.billing_reports_queuebrq_title
_436.clinical_interventions_test_codes_mapcitcm_reporting_title
_436.daily_close_schedulesdcs_title
_436.encounters_formsefrm_title
_436.encounters_soap_templatesest_phy_title
_436.erx_notificationserx_nots_title
_436.formsfrm_title
_436.handoutshand_title
_436.notesnot_title
_436.orders_test_codes_mapotcm_reporting_title
_436.radiology_orders_test_codes_maprtcm_reporting_title
_436.radiology_results_test_codes_maprrtcm_reporting_title
_436.reports_queuerq_title
_436_archive_testing.billing_reports_queuebrq_title
_436_archive_testing.clinical_interventions_test_codes_mapcitcm_reporting_title
_436_archive_testing.daily_close_schedulesdcs_title
_436_archive_testing.encounters_formsefrm_title
_436_archive_testing.encounters_soap_templatesest_phy_title
_436_archive_testing.erx_notificationserx_nots_title
_436_archive_testing.formsfrm_title
_436_archive_testing.handoutshand_title
_436_archive_testing.notesnot_title
_436_archive_testing.orders_test_codes_mapotcm_reporting_title
_436_archive_testing.radiology_orders_test_codes_maprtcm_reporting_title
_436_archive_testing.radiology_results_test_codes_maprrtcm_reporting_title
_436_archive_testing.reports_queuerq_title
_437.billing_reports_queuebrq_title
_437.clinical_interventions_test_codes_mapcitcm_reporting_title
_437.daily_close_schedulesdcs_title
_437.encounters_formsefrm_title
_437.encounters_soap_templatesest_phy_title
_437.erx_notificationserx_nots_title
_437.formsfrm_title
_437.handoutshand_title
_437.notesnot_title
_437.orders_test_codes_mapotcm_reporting_title
_437.radiology_orders_test_codes_maprtcm_reporting_title
_437.radiology_results_test_codes_maprrtcm_reporting_title
_437.reports_queuerq_title
_8.billing_reports_queuebrq_title
_8.clinical_interventions_test_codes_mapcitcm_reporting_title
_8.daily_close_schedulesdcs_title
_8.encounters_formsefrm_title
_8.encounters_soap_templatesest_phy_title
_8.erx_notificationserx_nots_title
_8.formsfrm_title
_8.handoutshand_title
_8.notesnot_title
_8.orders_test_codes_mapotcm_reporting_title
_8.radiology_orders_test_codes_maprtcm_reporting_title
_8.radiology_results_test_codes_maprrtcm_reporting_title
_8.reports_queuerq_title
_81.billing_reports_queuebrq_title
_81.clinical_interventions_test_codes_mapcitcm_reporting_title
_81.daily_close_schedulesdcs_title
_81.encounters_formsefrm_title
_81.encounters_soap_templatesest_phy_title
_81.erx_notificationserx_nots_title
_81.formsfrm_title
_81.handoutshand_title
_81.notesnot_title
_81.orders_test_codes_mapotcm_reporting_title
_81.radiology_orders_test_codes_maprtcm_reporting_title
_81.radiology_results_test_codes_maprrtcm_reporting_title
_81.reports_queuerq_title
_999.billing_reports_queuebrq_title
_999.clinical_interventions_test_codes_mapcitcm_reporting_title
_999.daily_close_schedulesdcs_title
_999.encounters_formsefrm_title
_999.encounters_soap_templatesest_phy_title
_999.erx_notificationserx_nots_title
_999.formsfrm_title
_999.handoutshand_title
_999.notesnot_title
_999.orders_test_codes_mapotcm_reporting_title
_999.radiology_orders_test_codes_maprtcm_reporting_title
_999.radiology_results_test_codes_maprrtcm_reporting_title
_999.reports_queuerq_title
ahiWiki.archivear_title
ahiWiki.categorycat_title
ahiWiki.iwlinksiwl_title
ahiWiki.jobjob_title
ahiWiki.langlinksll_title
ahiWiki.logginglog_title
ahiWiki.pagepage_title
ahiWiki.pagelinkspl_title
ahiWiki.protected_titlespt_title
ahiWiki.querycacheqc_title
ahiWiki.querycachetwoqcc_title
ahiWiki.recentchangesrc_title
ahiWiki.redirectrd_title
ahiWiki.searchindexsi_title
ahiWiki.templatelinkstl_title
ahiWiki.watchlistwl_title
aurora_standard.bsguarnm_title
aurora_standard.bvguarnm_title
aurora_standard.bvmpinm_title
aurora_standard.bvmpi2nm_title
aurora_standard.cgscliprclip_title
aurora_standard.chmapcccgrp_title
aurora_standard.chmdi10clong_title
aurora_standard.chmdiagelong_title
aurora_standard.chmdiagxlong_title
aurora_standard.chmhcahpdr_title
aurora_standard.chmpdemop_title
aurora_standard.chmpdemosp_title
aurora_standard.chmpdemogu_title
aurora_standard.chmpdemofam_phy_title
aurora_standard.chmpdemoattend_phy_title
aurora_standard.chmpdemoadmit_phy_title
aurora_standard.chmpr10clong_title
aurora_standard.chmpsvcdrend_title
aurora_standard.chmpsvcdref_title
aurora_standard.chpcemprjob_title
aurora_standard.chpcntrceduc_dir_title
aurora_standard.chtraindstu_title
aurora_standard.chxtechctech_title
aurora_standard.chytechctech_title
aurora_standard.hl7gt1job_title
aurora_standard.hl7in2job_title
aurora_standard.newicd10short_title
aurora_standard.newicd10long_title
aurora_standard.newicd9cshort_title
aurora_standard.newicd9clong_title
aurora_standard.ohoemplrjob_title
aurora_standard.stfnoteenote_title
aurora_standard.stfnoternote_title
aurora_standard.styemplrjob_title
aurora_standard.wrkicd9short_title
common.contactscon_title
common.cqm_infocit_title
common.leadslea_title
common.reports_queue_ordersrqo_title
common.test_codestco_reporting_title
common.usersusr_title
common.view_configs_optionsvwco_title
common.view_configs_optionsvwco_hide_title
template_library.encounters_soap_templatesest_phy_title
template_library.formsfrm_title
email
TableColumn
AzaleaStats.login_eventsloge_entered_email
Messaging.messages_contactsmc_email
_1.chartschrt_email
_1.client_contactsclicon_email
_1.encountersenc_email
_1.non_patientsnpat_email
_1.patientspat_email
_1.patientspat_email_no_email
_1.patients_demographics_snapshotspds_email
_1.patients_demographics_snapshotspds_email_no_email
_1.physiciansphy_email
_1.precertspre_email
_1188.chartschrt_email
_1188.client_contactsclicon_email
_1188.encountersenc_email
_1188.non_patientsnpat_email
_1188.patientspat_email
_1188.patientspat_email_no_email
_1188.patients_demographics_snapshotspds_email
_1188.patients_demographics_snapshotspds_email_no_email
_1188.physiciansphy_email
_1188.precertspre_email
_1218.chartschrt_email
_1218.client_contactsclicon_email
_1218.encountersenc_email
_1218.non_patientsnpat_email
_1218.patientspat_email
_1218.patientspat_email_no_email
_1218.patients_demographics_snapshotspds_email
_1218.patients_demographics_snapshotspds_email_no_email
_1218.physiciansphy_email
_1218.precertspre_email
_1548.chartschrt_email
_1548.client_contactsclicon_email
_1548.encountersenc_email
_1548.non_patientsnpat_email
_1548.patientspat_email
_1548.patientspat_email_no_email
_1548.patients_demographics_snapshotspds_email
_1548.patients_demographics_snapshotspds_email_no_email
_1548.physiciansphy_email
_1548.precertspre_email
_435.chartschrt_email
_435.client_contactsclicon_email
_435.encountersenc_email
_435.non_patientsnpat_email
_435.patientspat_email
_435.patientspat_email_no_email
_435.patients_demographics_snapshotspds_email
_435.patients_demographics_snapshotspds_email_no_email
_435.physiciansphy_email
_435.precertspre_email
_436.chartschrt_email
_436.client_contactsclicon_email
_436.encountersenc_email
_436.non_patientsnpat_email
_436.patientspat_email
_436.patientspat_email_no_email
_436.patients_demographics_snapshotspds_email
_436.patients_demographics_snapshotspds_email_no_email
_436.physiciansphy_email
_436.precertspre_email
_436_archive_testing.chartschrt_email
_436_archive_testing.client_contactsclicon_email
_436_archive_testing.encountersenc_email
_436_archive_testing.non_patientsnpat_email
_436_archive_testing.patientspat_email
_436_archive_testing.patientspat_email_no_email
_436_archive_testing.patients_demographics_snapshotspds_email
_436_archive_testing.patients_demographics_snapshotspds_email_no_email
_436_archive_testing.physiciansphy_email
_436_archive_testing.precertspre_email
_437.chartschrt_email
_437.client_contactsclicon_email
_437.encountersenc_email
_437.non_patientsnpat_email
_437.patientspat_email
_437.patientspat_email_no_email
_437.patients_demographics_snapshotspds_email
_437.patients_demographics_snapshotspds_email_no_email
_437.physiciansphy_email
_437.precertspre_email
_8.chartschrt_email
_8.client_contactsclicon_email
_8.encountersenc_email
_8.non_patientsnpat_email
_8.patientspat_email
_8.patientspat_email_no_email
_8.patients_demographics_snapshotspds_email
_8.patients_demographics_snapshotspds_email_no_email
_8.physiciansphy_email
_8.precertspre_email
_81.chartschrt_email
_81.client_contactsclicon_email
_81.encountersenc_email
_81.non_patientsnpat_email
_81.patientspat_email
_81.patientspat_email_no_email
_81.patients_demographics_snapshotspds_email
_81.patients_demographics_snapshotspds_email_no_email
_81.physiciansphy_email
_81.precertspre_email
_999.chartschrt_email
_999.client_contactsclicon_email
_999.encountersenc_email
_999.non_patientsnpat_email
_999.patientspat_email
_999.patientspat_email_no_email
_999.patients_demographics_snapshotspds_email
_999.patients_demographics_snapshotspds_email_no_email
_999.physiciansphy_email
_999.precertspre_email
ahiWiki.ipblocksipb_block_email
ahiWiki.useruser_email
aurora_standard.chmhl7iccompany_email
aurora_standard.chmhstmrpat_email
aurora_standard.stp1099ccontact_email
aurora_standard.stp1099cvend_email
aurora_standard.stprepsdrep_email
aurora_standard.stpvendrap_email
aurora_standard.stpvendragent_email
aurora_standard.styuimmrcont_email
aurora_standard.styw2mm1cont_email
common.applicantsapp_email
common.applicantsapp_employer_1_supervisor_email
common.applicantsapp_employer_2_supervisor_email
common.applicantsapp_employer_3_supervisor_email
common.applicantsapp_employer_4_supervisor_email
common.clientscli_email
common.clients_contract_dataccd_payer_email
common.contact_importsci_email
common.contactscon_email
common.customerscus_email
common.dashboardmd_usersdmdu_email
common.leadslea_email
common.login_blockslb_email
common.login_eventsloge_entered_email
common.sessionssession_email
common.telehealth_codesthc_invite_email
common.usersusr_email
sessions.sessionssession_email
contact
TableColumn
aurora_standard.bhphybaksuspend_contact
aurora_standard.chmadmidins_cert_contact
aurora_standard.chmhl7iccompany_contact
aurora_standard.chmphyncsuspend_contact
aurora_standard.stp1099cvend_contact
aurora_standard.stppucntpurch_contact
aurora_standard.visit_insurancesins_cert_contact
common.applicantsapp_employer_1_contact
common.applicantsapp_employer_2_contact
common.applicantsapp_employer_3_contact
common.applicantsapp_employer_4_contact
common.clientscli_contact
common.clients_contract_dataccd_payer_contact
common.customerscus_contact
common.leadslea_contact