_81.physicians

Field	Type	Null	Default	Key	Extra	Comment
phy_id	int(11)	NO		PRI	auto_increment
phy_cus_id	int(11)	NO	0	MUL
phy_cli_id	int(11)	NO	0	MUL
phy_usr_id	int(11)	NO	0	MUL		Points to the linked user for this provider
phy_default_reviewing_phy_id	int(11)	NO	0	MUL		Points to providers default reviewing provider
phy_cfs_id	int(11)	NO
phy_spe_id	int(11)	YES	0
phy_mnemonic	varchar(40)	NO
phy_fname	varchar(40)	NO				First Name
phy_mname	varchar(40)	NO				Middle Name
phy_lname	varchar(40)	NO				Last Name
phy_suffix	varchar(10)	NO
phy_credentials	varchar(20)	NO
phy_npi	varchar(15)	NO
phy_verify_npi	varchar(15)	NO
phy_taxonomy	varchar(20)	NO
phy_medicare_id	varchar(20)	NO
phy_medicaid_id	varchar(20)	NO
phy_email	varchar(80)	NO
phy_address1	varchar(40)	NO
phy_address2	varchar(40)	NO
phy_city	varchar(30)	NO
phy_state	varchar(2)	NO
phy_zip	varchar(5)	NO
phy_zip_plus4	varchar(4)	NO
phy_phone	varchar(20)	NO
phy_fax	varchar(20)	NO
phy_license_num	varchar(20)	NO
phy_clia_num	varchar(20)	NO
phy_dea_num	varchar(16)	NO				Physician DEA number
phy_ssn_federal_tax_id	char(1)	NO
phy_ssn1	varchar(3)	NO
phy_ssn2	varchar(2)	NO
phy_ssn3	varchar(4)	NO
phy_federal_tax_id	varchar(20)	NO
phy_pay_to_provider	char(1)	NO	0
phy_default_to_referring	char(1)	NO	0
phy_referring_only	char(1)	NO	0
phy_show_schedule	char(1)	NO	0	MUL
phy_ub04_surgery_center	tinyint(1)	NO	0			Indicates encounters with this physician should default to ub04
phy_ub04_bill_type	varchar(4)	YES				Indicates encounters with this physician could default to this ub04 bill type
phy_disabled	char(1)	NO	0
phy_id_ext	int(11)	NO		MUL
phy_id_interface_ext	varchar(18)	NO		MUL		Used as an external id for interfaces and imports
phy_note	text	YES				Physician note
phy_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
phy_created	timestamp	YES	CURRENT_TIMESTAMP
phy_default_bp_id	int(11)	YES		MUL

References

Local Column

References

phy_id

Table	Column
_1.appointment_recurrence	arec_phy_id
_1.appointments	apt_phy_id
_1.appointments_requests	aptreq_phy_id
_1.audits	aud_phy_id
_1.audits_archive	aud_phy_id
_1.charts	chrt_phy_id
_1.charts_care_plan	ccp_phy_id
_1.charts_stored_notes	chsn_phy_id
_1.clinical_alerts	ca_phy_id
_1.configured_encounters_templates	cet_phy_id
_1.cpoe_responses	cpoe_res_supervising_phy_id
_1.cpt_quickpick	cptqp_phy_id
_1.dx_quickpick	dxqp_phy_id
_1.encounters	enc_phy_id
_1.encounters_soap_templates_care_plans	estcp_phy_id
_1.encounters_stored_notes	esn_phy_id
_1.encounters_ub04	enc_ub04_77_phy_id
_1.encounters_ub04	enc_ub04_78_phy_id
_1.encounters_ub04	enc_ub04_79_phy_id
_1.hl7_accessions	acc_ordering_phy_id
_1.hl7_accessions	acc_supervising_phy_id
_1.ledger	led_phy_id
_1.ledger_unapplied_payments	lup_phy_id
_1.orders	ord_phy_id
_1.orders_test_codes_stats	otcs_phy_id
_1.patient_education_providers_access	pepa_phy_id
_1.patient_history_fields	phf_phy_id
_1.patient_history_fields_physicians_map	phfpm_phy_id
_1.patients	pat_phy_id
_1.patients_additional_providers	pap_phy_id
_1.patients_demographics_snapshots	pds_phy_id
_1.patients_immunizations	pim_admin_phy_id
_1.patients_inventory	pinv_administered_phy_id
_1.patients_referrals	pref_from_phy_id
_1.patients_referrals	pref_to_phy_id
_1.patients_responsibility_estimates	prest_phy_id
_1.patients_statements	pst_phy_id
_1.physician_order_delegations	phyod_phy_id
_1.physicians_pins	pin_phy_id
_1.physicians_servicing_states	physs_phy_id
_1.precerts	pre_phy_id
_1.print_formats	ptf_phy_id
_1.printable_signatures	psig_phy_id
_1.provider_access	pacc_phy_id
_1.radiology_orders	rad_phy_id
_1.radiology_results	rad_res_interpreting_phy_id
_1.radiology_results	rad_res_ordering_phy_id
_1.recall_list	rcl_phy_id
_1.schedules	sch_phy_id
_1.schedules_events	sevnt_phy_id
_1.schedules_exceptions	sexc_phy_id
_1.schedules_markup	smu_phy_id
_1188.appointment_recurrence	arec_phy_id
_1188.appointments	apt_phy_id
_1188.appointments_requests	aptreq_phy_id
_1188.audits	aud_phy_id
_1188.audits_archive	aud_phy_id
_1188.charts	chrt_phy_id
_1188.charts_care_plan	ccp_phy_id
_1188.charts_stored_notes	chsn_phy_id
_1188.clinical_alerts	ca_phy_id
_1188.configured_encounters_templates	cet_phy_id
_1188.cpoe_responses	cpoe_res_supervising_phy_id
_1188.cpt_quickpick	cptqp_phy_id
_1188.dx_quickpick	dxqp_phy_id
_1188.encounters	enc_phy_id
_1188.encounters_soap_templates_care_plans	estcp_phy_id
_1188.encounters_stored_notes	esn_phy_id
_1188.encounters_ub04	enc_ub04_77_phy_id
_1188.encounters_ub04	enc_ub04_78_phy_id
_1188.encounters_ub04	enc_ub04_79_phy_id
_1188.hl7_accessions	acc_ordering_phy_id
_1188.hl7_accessions	acc_supervising_phy_id
_1188.ledger	led_phy_id
_1188.ledger_unapplied_payments	lup_phy_id
_1188.orders	ord_phy_id
_1188.orders_test_codes_stats	otcs_phy_id
_1188.patient_education_providers_access	pepa_phy_id
_1188.patient_history_fields	phf_phy_id
_1188.patient_history_fields_physicians_map	phfpm_phy_id
_1188.patients	pat_phy_id
_1188.patients_additional_providers	pap_phy_id
_1188.patients_demographics_snapshots	pds_phy_id
_1188.patients_immunizations	pim_admin_phy_id
_1188.patients_inventory	pinv_administered_phy_id
_1188.patients_referrals	pref_from_phy_id
_1188.patients_referrals	pref_to_phy_id
_1188.patients_responsibility_estimates	prest_phy_id
_1188.patients_statements	pst_phy_id
_1188.physician_order_delegations	phyod_phy_id
_1188.physicians_pins	pin_phy_id
_1188.physicians_servicing_states	physs_phy_id
_1188.precerts	pre_phy_id
_1188.print_formats	ptf_phy_id
_1188.printable_signatures	psig_phy_id
_1188.provider_access	pacc_phy_id
_1188.radiology_orders	rad_phy_id
_1188.radiology_results	rad_res_interpreting_phy_id
_1188.radiology_results	rad_res_ordering_phy_id
_1188.recall_list	rcl_phy_id
_1188.schedules	sch_phy_id
_1188.schedules_events	sevnt_phy_id
_1188.schedules_exceptions	sexc_phy_id
_1188.schedules_markup	smu_phy_id
_1218.appointment_recurrence	arec_phy_id
_1218.appointments	apt_phy_id
_1218.appointments_requests	aptreq_phy_id
_1218.audits	aud_phy_id
_1218.audits_archive	aud_phy_id
_1218.charts	chrt_phy_id
_1218.charts_care_plan	ccp_phy_id
_1218.charts_stored_notes	chsn_phy_id
_1218.clinical_alerts	ca_phy_id
_1218.configured_encounters_templates	cet_phy_id
_1218.cpoe_responses	cpoe_res_supervising_phy_id
_1218.cpt_quickpick	cptqp_phy_id
_1218.dx_quickpick	dxqp_phy_id
_1218.encounters	enc_phy_id
_1218.encounters_soap_templates_care_plans	estcp_phy_id
_1218.encounters_stored_notes	esn_phy_id
_1218.encounters_ub04	enc_ub04_77_phy_id
_1218.encounters_ub04	enc_ub04_78_phy_id
_1218.encounters_ub04	enc_ub04_79_phy_id
_1218.hl7_accessions	acc_ordering_phy_id
_1218.hl7_accessions	acc_supervising_phy_id
_1218.ledger	led_phy_id
_1218.ledger_unapplied_payments	lup_phy_id
_1218.orders	ord_phy_id
_1218.orders_test_codes_stats	otcs_phy_id
_1218.patient_education_providers_access	pepa_phy_id
_1218.patient_history_fields	phf_phy_id
_1218.patient_history_fields_physicians_map	phfpm_phy_id
_1218.patients	pat_phy_id
_1218.patients_additional_providers	pap_phy_id
_1218.patients_demographics_snapshots	pds_phy_id
_1218.patients_immunizations	pim_admin_phy_id
_1218.patients_inventory	pinv_administered_phy_id
_1218.patients_referrals	pref_from_phy_id
_1218.patients_referrals	pref_to_phy_id
_1218.patients_responsibility_estimates	prest_phy_id
_1218.patients_statements	pst_phy_id
_1218.physician_order_delegations	phyod_phy_id
_1218.physicians_pins	pin_phy_id
_1218.physicians_servicing_states	physs_phy_id
_1218.precerts	pre_phy_id
_1218.print_formats	ptf_phy_id
_1218.printable_signatures	psig_phy_id
_1218.provider_access	pacc_phy_id
_1218.radiology_orders	rad_phy_id
_1218.radiology_results	rad_res_interpreting_phy_id
_1218.radiology_results	rad_res_ordering_phy_id
_1218.recall_list	rcl_phy_id
_1218.schedules	sch_phy_id
_1218.schedules_events	sevnt_phy_id
_1218.schedules_exceptions	sexc_phy_id
_1218.schedules_markup	smu_phy_id
_1548.appointment_recurrence	arec_phy_id
_1548.appointments	apt_phy_id
_1548.appointments_requests	aptreq_phy_id
_1548.audits	aud_phy_id
_1548.audits_archive	aud_phy_id
_1548.charts	chrt_phy_id
_1548.charts_care_plan	ccp_phy_id
_1548.charts_stored_notes	chsn_phy_id
_1548.clinical_alerts	ca_phy_id
_1548.configured_encounters_templates	cet_phy_id
_1548.cpoe_responses	cpoe_res_supervising_phy_id
_1548.cpt_quickpick	cptqp_phy_id
_1548.dx_quickpick	dxqp_phy_id
_1548.encounters	enc_phy_id
_1548.encounters_soap_templates_care_plans	estcp_phy_id
_1548.encounters_stored_notes	esn_phy_id
_1548.encounters_ub04	enc_ub04_77_phy_id
_1548.encounters_ub04	enc_ub04_78_phy_id
_1548.encounters_ub04	enc_ub04_79_phy_id
_1548.hl7_accessions	acc_ordering_phy_id
_1548.hl7_accessions	acc_supervising_phy_id
_1548.ledger	led_phy_id
_1548.ledger_unapplied_payments	lup_phy_id
_1548.orders	ord_phy_id
_1548.orders_test_codes_stats	otcs_phy_id
_1548.patient_education_providers_access	pepa_phy_id
_1548.patient_history_fields	phf_phy_id
_1548.patient_history_fields_physicians_map	phfpm_phy_id
_1548.patients	pat_phy_id
_1548.patients_additional_providers	pap_phy_id
_1548.patients_demographics_snapshots	pds_phy_id
_1548.patients_immunizations	pim_admin_phy_id
_1548.patients_inventory	pinv_administered_phy_id
_1548.patients_referrals	pref_from_phy_id
_1548.patients_referrals	pref_to_phy_id
_1548.patients_responsibility_estimates	prest_phy_id
_1548.patients_statements	pst_phy_id
_1548.physician_order_delegations	phyod_phy_id
_1548.physicians_pins	pin_phy_id
_1548.physicians_servicing_states	physs_phy_id
_1548.precerts	pre_phy_id
_1548.print_formats	ptf_phy_id
_1548.printable_signatures	psig_phy_id
_1548.provider_access	pacc_phy_id
_1548.radiology_orders	rad_phy_id
_1548.radiology_results	rad_res_interpreting_phy_id
_1548.radiology_results	rad_res_ordering_phy_id
_1548.recall_list	rcl_phy_id
_1548.schedules	sch_phy_id
_1548.schedules_events	sevnt_phy_id
_1548.schedules_exceptions	sexc_phy_id
_1548.schedules_markup	smu_phy_id
_435.appointment_recurrence	arec_phy_id
_435.appointments	apt_phy_id
_435.appointments_requests	aptreq_phy_id
_435.audits	aud_phy_id
_435.audits_archive	aud_phy_id
_435.charts	chrt_phy_id
_435.charts_care_plan	ccp_phy_id
_435.charts_stored_notes	chsn_phy_id
_435.clinical_alerts	ca_phy_id
_435.configured_encounters_templates	cet_phy_id
_435.cpoe_responses	cpoe_res_supervising_phy_id
_435.cpt_quickpick	cptqp_phy_id
_435.dx_quickpick	dxqp_phy_id
_435.encounters	enc_phy_id
_435.encounters_soap_templates_care_plans	estcp_phy_id
_435.encounters_stored_notes	esn_phy_id
_435.encounters_ub04	enc_ub04_77_phy_id
_435.encounters_ub04	enc_ub04_78_phy_id
_435.encounters_ub04	enc_ub04_79_phy_id
_435.hl7_accessions	acc_supervising_phy_id
_435.hl7_accessions	acc_ordering_phy_id
_435.ledger	led_phy_id
_435.ledger_unapplied_payments	lup_phy_id
_435.orders	ord_phy_id
_435.orders_test_codes_stats	otcs_phy_id
_435.patient_education_providers_access	pepa_phy_id
_435.patient_history_fields	phf_phy_id
_435.patient_history_fields_physicians_map	phfpm_phy_id
_435.patients	pat_phy_id
_435.patients_additional_providers	pap_phy_id
_435.patients_demographics_snapshots	pds_phy_id
_435.patients_immunizations	pim_admin_phy_id
_435.patients_inventory	pinv_administered_phy_id
_435.patients_referrals	pref_from_phy_id
_435.patients_referrals	pref_to_phy_id
_435.patients_responsibility_estimates	prest_phy_id
_435.patients_statements	pst_phy_id
_435.physician_order_delegations	phyod_phy_id
_435.physicians_pins	pin_phy_id
_435.physicians_servicing_states	physs_phy_id
_435.precerts	pre_phy_id
_435.print_formats	ptf_phy_id
_435.printable_signatures	psig_phy_id
_435.provider_access	pacc_phy_id
_435.radiology_orders	rad_phy_id
_435.radiology_results	rad_res_interpreting_phy_id
_435.radiology_results	rad_res_ordering_phy_id
_435.recall_list	rcl_phy_id
_435.schedules	sch_phy_id
_435.schedules_events	sevnt_phy_id
_435.schedules_exceptions	sexc_phy_id
_435.schedules_markup	smu_phy_id
_436.appointment_recurrence	arec_phy_id
_436.appointments	apt_phy_id
_436.appointments_requests	aptreq_phy_id
_436.audits	aud_phy_id
_436.audits_archive	aud_phy_id
_436.charts	chrt_phy_id
_436.charts_care_plan	ccp_phy_id
_436.charts_stored_notes	chsn_phy_id
_436.clinical_alerts	ca_phy_id
_436.configured_encounters_templates	cet_phy_id
_436.cpoe_responses	cpoe_res_supervising_phy_id
_436.cpt_quickpick	cptqp_phy_id
_436.dx_quickpick	dxqp_phy_id
_436.encounters	enc_phy_id
_436.encounters_soap_templates_care_plans	estcp_phy_id
_436.encounters_stored_notes	esn_phy_id
_436.encounters_ub04	enc_ub04_77_phy_id
_436.encounters_ub04	enc_ub04_78_phy_id
_436.encounters_ub04	enc_ub04_79_phy_id
_436.hl7_accessions	acc_ordering_phy_id
_436.hl7_accessions	acc_supervising_phy_id
_436.ledger	led_phy_id
_436.ledger_unapplied_payments	lup_phy_id
_436.orders	ord_phy_id
_436.orders_test_codes_stats	otcs_phy_id
_436.patient_education_providers_access	pepa_phy_id
_436.patient_history_fields	phf_phy_id
_436.patient_history_fields_physicians_map	phfpm_phy_id
_436.patients	pat_phy_id
_436.patients_additional_providers	pap_phy_id
_436.patients_demographics_snapshots	pds_phy_id
_436.patients_immunizations	pim_admin_phy_id
_436.patients_inventory	pinv_administered_phy_id
_436.patients_referrals	pref_from_phy_id
_436.patients_referrals	pref_to_phy_id
_436.patients_responsibility_estimates	prest_phy_id
_436.patients_statements	pst_phy_id
_436.physician_order_delegations	phyod_phy_id
_436.physicians_pins	pin_phy_id
_436.physicians_servicing_states	physs_phy_id
_436.precerts	pre_phy_id
_436.print_formats	ptf_phy_id
_436.printable_signatures	psig_phy_id
_436.provider_access	pacc_phy_id
_436.radiology_orders	rad_phy_id
_436.radiology_results	rad_res_interpreting_phy_id
_436.radiology_results	rad_res_ordering_phy_id
_436.recall_list	rcl_phy_id
_436.schedules	sch_phy_id
_436.schedules_events	sevnt_phy_id
_436.schedules_exceptions	sexc_phy_id
_436.schedules_markup	smu_phy_id
_436_archive_testing.appointment_recurrence	arec_phy_id
_436_archive_testing.appointments	apt_phy_id
_436_archive_testing.appointments_requests	aptreq_phy_id
_436_archive_testing.audits	aud_phy_id
_436_archive_testing.audits_archive	aud_phy_id
_436_archive_testing.charts	chrt_phy_id
_436_archive_testing.charts_care_plan	ccp_phy_id
_436_archive_testing.charts_stored_notes	chsn_phy_id
_436_archive_testing.clinical_alerts	ca_phy_id
_436_archive_testing.configured_encounters_templates	cet_phy_id
_436_archive_testing.cpoe_responses	cpoe_res_supervising_phy_id
_436_archive_testing.cpt_quickpick	cptqp_phy_id
_436_archive_testing.dx_quickpick	dxqp_phy_id
_436_archive_testing.encounters	enc_phy_id
_436_archive_testing.encounters_soap_templates_care_plans	estcp_phy_id
_436_archive_testing.encounters_stored_notes	esn_phy_id
_436_archive_testing.encounters_ub04	enc_ub04_77_phy_id
_436_archive_testing.encounters_ub04	enc_ub04_78_phy_id
_436_archive_testing.encounters_ub04	enc_ub04_79_phy_id
_436_archive_testing.hl7_accessions	acc_ordering_phy_id
_436_archive_testing.hl7_accessions	acc_supervising_phy_id
_436_archive_testing.ledger	led_phy_id
_436_archive_testing.ledger_unapplied_payments	lup_phy_id
_436_archive_testing.orders	ord_phy_id
_436_archive_testing.orders_test_codes_stats	otcs_phy_id
_436_archive_testing.patient_education_providers_access	pepa_phy_id
_436_archive_testing.patient_history_fields	phf_phy_id
_436_archive_testing.patient_history_fields_physicians_map	phfpm_phy_id
_436_archive_testing.patients	pat_phy_id
_436_archive_testing.patients_additional_providers	pap_phy_id
_436_archive_testing.patients_demographics_snapshots	pds_phy_id
_436_archive_testing.patients_immunizations	pim_admin_phy_id
_436_archive_testing.patients_inventory	pinv_administered_phy_id
_436_archive_testing.patients_referrals	pref_from_phy_id
_436_archive_testing.patients_referrals	pref_to_phy_id
_436_archive_testing.patients_responsibility_estimates	prest_phy_id
_436_archive_testing.patients_statements	pst_phy_id
_436_archive_testing.physician_order_delegations	phyod_phy_id
_436_archive_testing.physicians_pins	pin_phy_id
_436_archive_testing.physicians_servicing_states	physs_phy_id
_436_archive_testing.precerts	pre_phy_id
_436_archive_testing.print_formats	ptf_phy_id
_436_archive_testing.printable_signatures	psig_phy_id
_436_archive_testing.provider_access	pacc_phy_id
_436_archive_testing.radiology_orders	rad_phy_id
_436_archive_testing.radiology_results	rad_res_interpreting_phy_id
_436_archive_testing.radiology_results	rad_res_ordering_phy_id
_436_archive_testing.recall_list	rcl_phy_id
_436_archive_testing.schedules	sch_phy_id
_436_archive_testing.schedules_events	sevnt_phy_id
_436_archive_testing.schedules_exceptions	sexc_phy_id
_436_archive_testing.schedules_markup	smu_phy_id
_437.appointment_recurrence	arec_phy_id
_437.appointments	apt_phy_id
_437.appointments_requests	aptreq_phy_id
_437.audits	aud_phy_id
_437.audits_archive	aud_phy_id
_437.charts	chrt_phy_id
_437.charts_care_plan	ccp_phy_id
_437.charts_stored_notes	chsn_phy_id
_437.clinical_alerts	ca_phy_id
_437.configured_encounters_templates	cet_phy_id
_437.cpoe_responses	cpoe_res_supervising_phy_id
_437.cpt_quickpick	cptqp_phy_id
_437.dx_quickpick	dxqp_phy_id
_437.encounters	enc_phy_id
_437.encounters_soap_templates_care_plans	estcp_phy_id
_437.encounters_stored_notes	esn_phy_id
_437.encounters_ub04	enc_ub04_77_phy_id
_437.encounters_ub04	enc_ub04_78_phy_id
_437.encounters_ub04	enc_ub04_79_phy_id
_437.hl7_accessions	acc_ordering_phy_id
_437.hl7_accessions	acc_supervising_phy_id
_437.ledger	led_phy_id
_437.ledger_unapplied_payments	lup_phy_id
_437.orders	ord_phy_id
_437.orders_test_codes_stats	otcs_phy_id
_437.patient_education_providers_access	pepa_phy_id
_437.patient_history_fields	phf_phy_id
_437.patient_history_fields_physicians_map	phfpm_phy_id
_437.patients	pat_phy_id
_437.patients_additional_providers	pap_phy_id
_437.patients_demographics_snapshots	pds_phy_id
_437.patients_immunizations	pim_admin_phy_id
_437.patients_inventory	pinv_administered_phy_id
_437.patients_referrals	pref_from_phy_id
_437.patients_referrals	pref_to_phy_id
_437.patients_responsibility_estimates	prest_phy_id
_437.patients_statements	pst_phy_id
_437.physician_order_delegations	phyod_phy_id
_437.physicians_pins	pin_phy_id
_437.physicians_servicing_states	physs_phy_id
_437.precerts	pre_phy_id
_437.print_formats	ptf_phy_id
_437.printable_signatures	psig_phy_id
_437.provider_access	pacc_phy_id
_437.radiology_orders	rad_phy_id
_437.radiology_results	rad_res_interpreting_phy_id
_437.radiology_results	rad_res_ordering_phy_id
_437.recall_list	rcl_phy_id
_437.schedules	sch_phy_id
_437.schedules_events	sevnt_phy_id
_437.schedules_exceptions	sexc_phy_id
_437.schedules_markup	smu_phy_id
_8.appointment_recurrence	arec_phy_id
_8.appointments	apt_phy_id
_8.appointments_requests	aptreq_phy_id
_8.audits	aud_phy_id
_8.audits_archive	aud_phy_id
_8.charts	chrt_phy_id
_8.charts_care_plan	ccp_phy_id
_8.charts_stored_notes	chsn_phy_id
_8.clinical_alerts	ca_phy_id
_8.configured_encounters_templates	cet_phy_id
_8.cpoe_responses	cpoe_res_supervising_phy_id
_8.cpt_quickpick	cptqp_phy_id
_8.daily_close_calculations	dcc_phy_id
_8.dx_quickpick	dxqp_phy_id
_8.encounters	enc_phy_id
_8.encounters_soap_templates_care_plans	estcp_phy_id
_8.encounters_stored_notes	esn_phy_id
_8.encounters_ub04	enc_ub04_77_phy_id
_8.encounters_ub04	enc_ub04_78_phy_id
_8.encounters_ub04	enc_ub04_79_phy_id
_8.hl7_accessions	acc_ordering_phy_id
_8.hl7_accessions	acc_supervising_phy_id
_8.ledger	led_phy_id
_8.ledger_unapplied_payments	lup_phy_id
_8.orders	ord_phy_id
_8.orders_test_codes_stats	otcs_phy_id
_8.patient_education_providers_access	pepa_phy_id
_8.patient_history_fields	phf_phy_id
_8.patient_history_fields_physicians_map	phfpm_phy_id
_8.patients	pat_phy_id
_8.patients_additional_providers	pap_phy_id
_8.patients_demographics_snapshots	pds_phy_id
_8.patients_immunizations	pim_admin_phy_id
_8.patients_inventory	pinv_administered_phy_id
_8.patients_referrals	pref_from_phy_id
_8.patients_referrals	pref_to_phy_id
_8.patients_responsibility_estimates	prest_phy_id
_8.patients_statements	pst_phy_id
_8.physician_order_delegations	phyod_phy_id
_8.physicians_pins	pin_phy_id
_8.physicians_servicing_states	physs_phy_id
_8.precerts	pre_phy_id
_8.print_formats	ptf_phy_id
_8.printable_signatures	psig_phy_id
_8.provider_access	pacc_phy_id
_8.radiology_orders	rad_phy_id
_8.radiology_results	rad_res_interpreting_phy_id
_8.radiology_results	rad_res_ordering_phy_id
_8.recall_list	rcl_phy_id
_8.schedules	sch_phy_id
_8.schedules_events	sevnt_phy_id
_8.schedules_exceptions	sexc_phy_id
_8.schedules_markup	smu_phy_id
_81.appointment_recurrence	arec_phy_id
_81.appointments	apt_phy_id
_81.appointments_requests	aptreq_phy_id
_81.audits	aud_phy_id
_81.audits_archive	aud_phy_id
_81.charts	chrt_phy_id
_81.charts_care_plan	ccp_phy_id
_81.charts_stored_notes	chsn_phy_id
_81.clinical_alerts	ca_phy_id
_81.configured_encounters_templates	cet_phy_id
_81.cpoe_responses	cpoe_res_supervising_phy_id
_81.cpt_quickpick	cptqp_phy_id
_81.dx_quickpick	dxqp_phy_id
_81.encounters	enc_phy_id
_81.encounters_soap_templates_care_plans	estcp_phy_id
_81.encounters_stored_notes	esn_phy_id
_81.encounters_ub04	enc_ub04_77_phy_id
_81.encounters_ub04	enc_ub04_78_phy_id
_81.encounters_ub04	enc_ub04_79_phy_id
_81.hl7_accessions	acc_ordering_phy_id
_81.hl7_accessions	acc_supervising_phy_id
_81.ledger	led_phy_id
_81.ledger_unapplied_payments	lup_phy_id
_81.orders	ord_phy_id
_81.orders_test_codes_stats	otcs_phy_id
_81.patient_education_providers_access	pepa_phy_id
_81.patient_history_fields	phf_phy_id
_81.patient_history_fields_physicians_map	phfpm_phy_id
_81.patients	pat_phy_id
_81.patients_additional_providers	pap_phy_id
_81.patients_demographics_snapshots	pds_phy_id
_81.patients_immunizations	pim_admin_phy_id
_81.patients_inventory	pinv_administered_phy_id
_81.patients_referrals	pref_from_phy_id
_81.patients_referrals	pref_to_phy_id
_81.patients_responsibility_estimates	prest_phy_id
_81.patients_statements	pst_phy_id
_81.physician_order_delegations	phyod_phy_id
_81.physicians_pins	pin_phy_id
_81.physicians_servicing_states	physs_phy_id
_81.precerts	pre_phy_id
_81.print_formats	ptf_phy_id
_81.printable_signatures	psig_phy_id
_81.provider_access	pacc_phy_id
_81.radiology_orders	rad_phy_id
_81.radiology_results	rad_res_interpreting_phy_id
_81.radiology_results	rad_res_ordering_phy_id
_81.recall_list	rcl_phy_id
_81.schedules	sch_phy_id
_81.schedules_events	sevnt_phy_id
_81.schedules_exceptions	sexc_phy_id
_81.schedules_markup	smu_phy_id
_999.appointment_recurrence	arec_phy_id
_999.appointments	apt_phy_id
_999.appointments_requests	aptreq_phy_id
_999.audits	aud_phy_id
_999.audits_archive	aud_phy_id
_999.charts	chrt_phy_id
_999.charts_care_plan	ccp_phy_id
_999.charts_stored_notes	chsn_phy_id
_999.clinical_alerts	ca_phy_id
_999.configured_encounters_templates	cet_phy_id
_999.cpoe_responses	cpoe_res_supervising_phy_id
_999.cpt_quickpick	cptqp_phy_id
_999.dx_quickpick	dxqp_phy_id
_999.encounters	enc_phy_id
_999.encounters_soap_templates_care_plans	estcp_phy_id
_999.encounters_stored_notes	esn_phy_id
_999.encounters_ub04	enc_ub04_77_phy_id
_999.encounters_ub04	enc_ub04_78_phy_id
_999.encounters_ub04	enc_ub04_79_phy_id
_999.hl7_accessions	acc_ordering_phy_id
_999.hl7_accessions	acc_supervising_phy_id
_999.ledger	led_phy_id
_999.ledger_unapplied_payments	lup_phy_id
_999.orders	ord_phy_id
_999.orders_test_codes_stats	otcs_phy_id
_999.patient_education_providers_access	pepa_phy_id
_999.patient_history_fields	phf_phy_id
_999.patient_history_fields_physicians_map	phfpm_phy_id
_999.patients	pat_phy_id
_999.patients_additional_providers	pap_phy_id
_999.patients_demographics_snapshots	pds_phy_id
_999.patients_immunizations	pim_admin_phy_id
_999.patients_inventory	pinv_administered_phy_id
_999.patients_referrals	pref_from_phy_id
_999.patients_referrals	pref_to_phy_id
_999.patients_responsibility_estimates	prest_phy_id
_999.patients_statements	pst_phy_id
_999.physician_order_delegations	phyod_phy_id
_999.physicians_pins	pin_phy_id
_999.physicians_servicing_states	physs_phy_id
_999.precerts	pre_phy_id
_999.print_formats	ptf_phy_id
_999.printable_signatures	psig_phy_id
_999.provider_access	pacc_phy_id
_999.radiology_orders	rad_phy_id
_999.radiology_results	rad_res_interpreting_phy_id
_999.radiology_results	rad_res_ordering_phy_id
_999.recall_list	rcl_phy_id
_999.schedules	sch_phy_id
_999.schedules_events	sevnt_phy_id
_999.schedules_exceptions	sexc_phy_id
_999.schedules_markup	smu_phy_id
aurora_standard.chmlastr	att_phy_id
aurora_standard.chmlastr	adm_phy_id
aurora_standard.chmlastr	op_phy_id
aurora_standard.chmlastr	ref_phy_id
aurora_standard.chmlastr	oth_phy_id
aurora_standard.chmlastr	rnd_phy_id
aurora_standard.chmtxstr	att_phy_id
aurora_standard.chmtxstr	adm_phy_id
aurora_standard.chmtxstr	op_phy_id
aurora_standard.chmtxstr	ref_phy_id
aurora_standard.chmtxstr	cons_phy_id
aurora_standard.chmtxstr	oth_phy_id
aurora_standard.chmutah3	att_phy_id
aurora_standard.chmutah3	sur_phy_id
aurora_standard.chmutah3	ren_phy_id
aurora_standard.chmutah3	ref_phy_id
aurora_standard.chmutah3	res_phy_id
aurora_standard.chmutah6	att_phy_id
aurora_standard.chmutah6	op_phy_id
aurora_standard.chmutah6	oth_phy_id
aurora_standard.chmutah6	ren_phy_id
aurora_standard.chmutah6	ref_phy_id
aurora_standard.chmutah6	res_phy_id
aurora_standard.chmutah7	att_phy_id
aurora_standard.chmutah7	oth_phy_id
aurora_standard.chmutaha	att_phy_id
aurora_standard.chmutaha	oth_phy_id
common.ahi_audits	aud_phy_id
common.clients_zuora_physicians_config	czp_phy_id
common.configurations	conf_phy_id
common.cqm_tracking	cqmt_phy_id

phy_fname

Table	Column
_1.encounters_soap_templates	est_phy_fname
_1188.encounters_soap_templates	est_phy_fname
_1218.encounters_soap_templates	est_phy_fname
_1548.encounters_soap_templates	est_phy_fname
_435.encounters_soap_templates	est_phy_fname
_436.encounters_soap_templates	est_phy_fname
_436_archive_testing.encounters_soap_templates	est_phy_fname
_437.encounters_soap_templates	est_phy_fname
_8.encounters_soap_templates	est_phy_fname
_81.encounters_soap_templates	est_phy_fname
_999.encounters_soap_templates	est_phy_fname
aurora_standard.chmlastr	adm_phy_fname
aurora_standard.chmlastr	rnd_phy_fname
aurora_standard.chmlastr	ref_phy_fname
aurora_standard.chmlastr	att_phy_fname
aurora_standard.chmlastr	op_phy_fname
aurora_standard.chmlastr	oth_phy_fname
aurora_standard.chmpdemo	fam_phy_fname
aurora_standard.chmpdemo	attend_phy_fname
aurora_standard.chmpdemo	admit_phy_fname
aurora_standard.chmtxstr	att_phy_fname
aurora_standard.chmtxstr	op_phy_fname
aurora_standard.chmtxstr	cons_phy_fname
template_library.encounters_soap_templates	est_phy_fname

phy_lname

Table	Column
_1.encounters_soap_templates	est_phy_lname
_1188.encounters_soap_templates	est_phy_lname
_1218.encounters_soap_templates	est_phy_lname
_1548.encounters_soap_templates	est_phy_lname
_435.encounters_soap_templates	est_phy_lname
_436.encounters_soap_templates	est_phy_lname
_436_archive_testing.encounters_soap_templates	est_phy_lname
_437.encounters_soap_templates	est_phy_lname
_8.encounters_soap_templates	est_phy_lname
_81.encounters_soap_templates	est_phy_lname
_999.encounters_soap_templates	est_phy_lname
aurora_standard.chmlastr	adm_phy_lname
aurora_standard.chmlastr	rnd_phy_lname
aurora_standard.chmlastr	ref_phy_lname
aurora_standard.chmlastr	att_phy_lname
aurora_standard.chmlastr	op_phy_lname
aurora_standard.chmlastr	oth_phy_lname
aurora_standard.chmpdemo	fam_phy_lname
aurora_standard.chmpdemo	attend_phy_lname
aurora_standard.chmpdemo	admit_phy_lname
aurora_standard.chmtxstr	att_phy_lname
aurora_standard.chmtxstr	op_phy_lname
aurora_standard.chmtxstr	cons_phy_lname
template_library.encounters_soap_templates	est_phy_lname

phy_npi

Table	Column
aurora_standard.chmarsi	fam_phy_npi
aurora_standard.chmarsi	attend_phy_npi
aurora_standard.chmarsi	admit_phy_npi
aurora_standard.chmazstd	att_phy_npi
aurora_standard.chmazstd	proc_phy_npi
aurora_standard.chmazstd	oth_phy_npi
aurora_standard.chmazsti	att_phy_npi
aurora_standard.chmazsti	proc_phy_npi
aurora_standard.chmazsti	oth_phy_npi
aurora_standard.chmazsto	att_phy_npi
aurora_standard.chmazsto	proc_phy_npi
aurora_standard.chmazsto	oth_phy_npi
aurora_standard.chmcampi	fam_phy_npi
aurora_standard.chmcampi	attend_phy_npi
aurora_standard.chmcampi	admit_phy_npi
aurora_standard.chmexmpi	fam_phy_npi
aurora_standard.chmexmpi	attend_phy_npi
aurora_standard.chmexmpi	admit_phy_npi
aurora_standard.chmexvis	attend_phy_npi
aurora_standard.chmexvis	admit_phy_npi
aurora_standard.chmlastr	att_phy_npi
aurora_standard.chmlastr	op_phy_npi
aurora_standard.chmlastr	oth_phy_npi
aurora_standard.chmlastr	rnd_phy_npi
aurora_standard.chmlastr	adm_phy_npi
aurora_standard.chmlastr	ref_phy_npi
aurora_standard.chmmhast	att_phy_npi
aurora_standard.chmpdemo	fam_phy_npi
aurora_standard.chmpdemo	attend_phy_npi
aurora_standard.chmpdemo	admit_phy_npi
aurora_standard.chmradex	fam_phy_npi
aurora_standard.chmradex	attend_phy_npi
aurora_standard.chmradex	admit_phy_npi

phy_mname

Table	Column
aurora_standard.chmpdemo	fam_phy_mname
aurora_standard.chmpdemo	attend_phy_mname
aurora_standard.chmpdemo	admit_phy_mname