aurora_standard.bpphy1

Field Type Null Default Key Extra Comment
phy_no char(6) NO
full_name char(50) YES
specialty char(10) YES
med_svc char(10) YES
active char(1) YES
md_no char(30) YES
fed_no char(30) YES
state_no char(30) YES

References

Local Column References
active
TableColumn
HSPI_Bastrop.charge_mastersis_active
HSPI_CURES2015_B1.charge_mastersis_active
HSPI_Central_Hospital.charge_mastersis_active
HSPI_Dewitt.charge_mastersis_active
HSPI_Fulton.charge_mastersis_active
HSPI_Inferno.charge_mastersis_active
HSPI_MU2015_E1.charge_mastersis_active
HSPI_MU2015_G2.charge_mastersis_active
HSPI_MU2015_G9.charge_mastersis_active
HSPI_Ness.charge_mastersis_active
HSPI_Sandbox.charge_mastersis_active
HSPI_Summit_General.charge_mastersis_active
HSPI_United_Physicians.charge_mastersis_active
Icd.icd10_snomed_mapi10snom_active
MPI.charge_mastersis_active
SSO.user_passwordsis_active
_1.encounter_soap_labels_values_groupseslvg_is_active
_1218.encounter_soap_labels_values_groupseslvg_is_active
_1548.encounter_soap_labels_values_groupseslvg_is_active
_435.encounter_soap_labels_values_groupseslvg_is_active
_436.encounter_soap_labels_values_groupseslvg_is_active
_436_archive_testing.encounter_soap_labels_values_groupseslvg_is_active
_437.encounter_soap_labels_values_groupseslvg_is_active
_8.encounter_soap_labels_values_groupseslvg_is_active
_999.encounter_soap_labels_values_groupseslvg_is_active
aurora_standard.apsarcur_active
aurora_standard.apsar0cur_active
aurora_standard.apsarbdcur_active
aurora_standard.apsarhistcur_active
aurora_standard.chmopercusr_active
aurora_standard.stuctlgdcontract_active
aurora_standard.stxautorauto_active
common.users_passwordsupwd_active
phy_no
TableColumn
aurora_standard.bsinsurfam_phy_no
aurora_standard.c7mpipri_phy_no
aurora_standard.campifam_phy_no
aurora_standard.chmabstradmit_phy_no
aurora_standard.chmabstrattend_phy_no
aurora_standard.chmarsifam_phy_no
aurora_standard.chmcampifam_phy_no
aurora_standard.chmexmpifam_phy_no
aurora_standard.chmpatmrfam_phy_no
aurora_standard.chmpdemofam_phy_no
aurora_standard.chmradexfam_phy_no
aurora_standard.chpwkmnrrefer_phy_no