_1218.billing_providers

Field Type Null Default Key Extra Comment
bp_id int(11) NO PRI auto_increment
bp_cus_id int(11) NO
bp_cli_id int(11) NO
bp_federal_tax_id varchar(20) NO
bp_npi varchar(15) NO
bp_secondary_id_qualifier varchar(3) YES
bp_secondary_id varchar(50) YES
bp_name varchar(40) NO Name
bp_mnemonic varchar(40) NO Short name/code
bp_address1 varchar(40) NO
bp_address2 varchar(40) NO
bp_city varchar(30) NO
bp_state varchar(2) NO
bp_zip varchar(5) NO
bp_zip_plus4 varchar(4) 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
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

References

Local Column References
bp_id
TableColumn
_1.encountersenc_bp_id
_1.locationsloc_default_bp_id
_1.patients_statements_billing_providers_mappstbpm_bp_id
_1.physiciansphy_default_bp_id
_1188.encountersenc_bp_id
_1188.locationsloc_default_bp_id
_1188.patients_statements_billing_providers_mappstbpm_bp_id
_1188.physiciansphy_default_bp_id
_1218.encountersenc_bp_id
_1218.locationsloc_default_bp_id
_1218.patients_statements_billing_providers_mappstbpm_bp_id
_1218.physiciansphy_default_bp_id
_1548.encountersenc_bp_id
_1548.locationsloc_default_bp_id
_1548.patients_statements_billing_providers_mappstbpm_bp_id
_1548.physiciansphy_default_bp_id
_435.encountersenc_bp_id
_435.locationsloc_default_bp_id
_435.patients_statements_billing_providers_mappstbpm_bp_id
_435.physiciansphy_default_bp_id
_436.encountersenc_bp_id
_436.locationsloc_default_bp_id
_436.patients_statements_billing_providers_mappstbpm_bp_id
_436.physiciansphy_default_bp_id
_436_archive_testing.encountersenc_bp_id
_436_archive_testing.locationsloc_default_bp_id
_436_archive_testing.patients_statements_billing_providers_mappstbpm_bp_id
_436_archive_testing.physiciansphy_default_bp_id
_437.encountersenc_bp_id
_437.locationsloc_default_bp_id
_437.patients_statements_billing_providers_mappstbpm_bp_id
_437.physiciansphy_default_bp_id
_8.encountersenc_bp_id
_8.locationsloc_default_bp_id
_8.patients_statements_billing_providers_mappstbpm_bp_id
_8.physiciansphy_default_bp_id
_81.encountersenc_bp_id
_81.locationsloc_default_bp_id
_81.patients_statements_billing_providers_mappstbpm_bp_id
_81.physiciansphy_default_bp_id
_999.encountersenc_bp_id
_999.locationsloc_default_bp_id
_999.patients_statements_billing_providers_mappstbpm_bp_id
_999.physiciansphy_default_bp_id