_437.billing_providers

Field	Type	Null	Default	Key	Extra	Comment
bp_id	int(11)	NO		PRI	auto_increment
bp_federal_tax_id	varchar(20)	NO
bp_npi	varchar(15)	NO
bp_name	varchar(40)	NO				Name
bp_mnemonic	varchar(40)	NO				Short name/code
bp_address1	varchar(40)	YES
bp_address2	varchar(40)	YES
bp_city	varchar(30)	NO
bp_zip	varchar(5)	NO
bp_zip_plus4	varchar(4)	NO
bp_disabled	tinyint(1)	NO	0
bp_default	tinyint(1)	NO	0
bp_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
bp_created	timestamp	YES	CURRENT_TIMESTAMP
bp_cli_id	int(11)	NO
bp_cus_id	int(11)	NO
bp_state	varchar(2)	NO
bp_phone	varchar(20)	NO
bp_fname	varchar(20)	NO
bp_mname	varchar(20)	NO
bp_lname	varchar(20)	NO
bp_suffix	varchar(20)	NO
bp_entity	tinyint(1)	NO	0

References

Local Column

References

bp_id

Table	Column
_1.encounters	enc_bp_id
_1.locations	loc_default_bp_id
_1.patients_statements_billing_providers_map	pstbpm_bp_id
_1.physicians	phy_default_bp_id
_1188.encounters	enc_bp_id
_1188.locations	loc_default_bp_id
_1188.patients_statements_billing_providers_map	pstbpm_bp_id
_1188.physicians	phy_default_bp_id
_1218.encounters	enc_bp_id
_1218.locations	loc_default_bp_id
_1218.patients_statements_billing_providers_map	pstbpm_bp_id
_1218.physicians	phy_default_bp_id
_1548.encounters	enc_bp_id
_1548.locations	loc_default_bp_id
_1548.patients_statements_billing_providers_map	pstbpm_bp_id
_1548.physicians	phy_default_bp_id
_435.encounters	enc_bp_id
_435.locations	loc_default_bp_id
_435.patients_statements_billing_providers_map	pstbpm_bp_id
_435.physicians	phy_default_bp_id
_436.encounters	enc_bp_id
_436.locations	loc_default_bp_id
_436.patients_statements_billing_providers_map	pstbpm_bp_id
_436.physicians	phy_default_bp_id
_436_archive_testing.encounters	enc_bp_id
_436_archive_testing.locations	loc_default_bp_id
_436_archive_testing.patients_statements_billing_providers_map	pstbpm_bp_id
_436_archive_testing.physicians	phy_default_bp_id
_437.encounters	enc_bp_id
_437.locations	loc_default_bp_id
_437.patients_statements_billing_providers_map	pstbpm_bp_id
_437.physicians	phy_default_bp_id
_8.encounters	enc_bp_id
_8.locations	loc_default_bp_id
_8.patients_statements_billing_providers_map	pstbpm_bp_id
_8.physicians	phy_default_bp_id
_81.encounters	enc_bp_id
_81.locations	loc_default_bp_id
_81.patients_statements_billing_providers_map	pstbpm_bp_id
_81.physicians	phy_default_bp_id
_999.encounters	enc_bp_id
_999.locations	loc_default_bp_id
_999.patients_statements_billing_providers_map	pstbpm_bp_id
_999.physicians	phy_default_bp_id