aurora_standard.bfcdmpro

Field Type Null Default Key Extra Comment
serv_code char(20) YES UNI
bill_descrip char(50) YES
charge_amt decimal(10,2) YES
d_rev_cd char(10) YES
cpt_mod char(10) YES
ndc varchar(20) YES
inactive varchar(10) YES

References

Local Column References
ndc
TableColumn
_1.charts_cpt_codeschcp_ndc
_1.configured_encounters_templates_cpt_codescetcc_ndc
_1.encounters_cpt_codesecp_ndc
_1.encounters_cpt_codes_templatesecpt_ndc
_1.immunizationsimz_ndc
_1188.charts_cpt_codeschcp_ndc
_1188.configured_encounters_templates_cpt_codescetcc_ndc
_1188.encounters_cpt_codesecp_ndc
_1188.encounters_cpt_codes_templatesecpt_ndc
_1188.immunizationsimz_ndc
_1218.charts_cpt_codeschcp_ndc
_1218.configured_encounters_templates_cpt_codescetcc_ndc
_1218.encounters_cpt_codesecp_ndc
_1218.encounters_cpt_codes_templatesecpt_ndc
_1218.immunizationsimz_ndc
_1548.charts_cpt_codeschcp_ndc
_1548.configured_encounters_templates_cpt_codescetcc_ndc
_1548.encounters_cpt_codesecp_ndc
_1548.encounters_cpt_codes_templatesecpt_ndc
_1548.immunizationsimz_ndc
_435.charts_cpt_codeschcp_ndc
_435.configured_encounters_templates_cpt_codescetcc_ndc
_435.encounters_cpt_codesecp_ndc
_435.encounters_cpt_codes_templatesecpt_ndc
_435.immunizationsimz_ndc
_436.charts_cpt_codeschcp_ndc
_436.configured_encounters_templates_cpt_codescetcc_ndc
_436.encounters_cpt_codesecp_ndc
_436.encounters_cpt_codes_templatesecpt_ndc
_436.immunizationsimz_ndc
_436_archive_testing.charts_cpt_codeschcp_ndc
_436_archive_testing.configured_encounters_templates_cpt_codescetcc_ndc
_436_archive_testing.encounters_cpt_codesecp_ndc
_436_archive_testing.encounters_cpt_codes_templatesecpt_ndc
_436_archive_testing.immunizationsimz_ndc
_437.charts_cpt_codeschcp_ndc
_437.configured_encounters_templates_cpt_codescetcc_ndc
_437.encounters_cpt_codesecp_ndc
_437.encounters_cpt_codes_templatesecpt_ndc
_437.immunizationsimz_ndc
_8.charts_cpt_codeschcp_ndc
_8.configured_encounters_templates_cpt_codescetcc_ndc
_8.encounters_cpt_codesecp_ndc
_8.encounters_cpt_codes_templatesecpt_ndc
_8.immunizationsimz_ndc
_81.charts_cpt_codeschcp_ndc
_81.configured_encounters_templates_cpt_codescetcc_ndc
_81.encounters_cpt_codesecp_ndc
_81.encounters_cpt_codes_templatesecpt_ndc
_81.immunizationsimz_ndc
_999.charts_cpt_codeschcp_ndc
_999.configured_encounters_templates_cpt_codescetcc_ndc
_999.encounters_cpt_codesecp_ndc
_999.encounters_cpt_codes_templatesecpt_ndc
_999.immunizationsimz_ndc
template_library.encounters_cpt_codes_templatesecpt_ndc
inactive
TableColumn
_1.patients_implantable_devicespid_inactive
_1188.patients_implantable_devicespid_inactive
_1218.patients_implantable_devicespid_inactive
_1548.patients_implantable_devicespid_inactive
_435.patients_implantable_devicespid_inactive
_436.patients_implantable_devicespid_inactive
_436_archive_testing.patients_implantable_devicespid_inactive
_437.patients_implantable_devicespid_inactive
_8.patients_implantable_devicespid_inactive
_81.patients_implantable_devicespid_inactive
_999.patients_implantable_devicespid_inactive
common.login_blockslb_inactive
serv_code
TableColumn
aurora_standard.chmpcatdrad_serv_code