aurora_standard.bokcdm

Field Type Null Default Key Extra Comment
serv_code char(20) YES
bill_descrip char(50) YES
ub char(1) YES
rev_cd char(10) YES
cpt char(10) YES
mod1 char(2) YES
mod2 char(2) YES
cost_amt decimal(10,2) YES
w_date date YES
charge_amt decimal(10,2) YES

References

Local Column References
mod1
TableColumn
_1.charts_cpt_codeschcp_mod1
_1.charts_procedurescp_mod1
_1.configured_encounters_templates_cpt_codescetcc_mod1
_1.encounters_cpt_codesecp_mod1
_1.encounters_cpt_codes_templatesecpt_mod1
_1.patients_responsibility_estimates_servicesprests_mod1
_1.precerts_cpt_codespcp_mod1
_1188.charts_cpt_codeschcp_mod1
_1188.charts_procedurescp_mod1
_1188.configured_encounters_templates_cpt_codescetcc_mod1
_1188.encounters_cpt_codesecp_mod1
_1188.encounters_cpt_codes_templatesecpt_mod1
_1188.patients_responsibility_estimates_servicesprests_mod1
_1188.precerts_cpt_codespcp_mod1
_1218.charts_cpt_codeschcp_mod1
_1218.charts_procedurescp_mod1
_1218.configured_encounters_templates_cpt_codescetcc_mod1
_1218.encounters_cpt_codesecp_mod1
_1218.encounters_cpt_codes_templatesecpt_mod1
_1218.patients_responsibility_estimates_servicesprests_mod1
_1218.precerts_cpt_codespcp_mod1
_1548.charts_cpt_codeschcp_mod1
_1548.charts_procedurescp_mod1
_1548.configured_encounters_templates_cpt_codescetcc_mod1
_1548.encounters_cpt_codesecp_mod1
_1548.encounters_cpt_codes_templatesecpt_mod1
_1548.patients_responsibility_estimates_servicesprests_mod1
_1548.precerts_cpt_codespcp_mod1
_435.charts_cpt_codeschcp_mod1
_435.charts_procedurescp_mod1
_435.configured_encounters_templates_cpt_codescetcc_mod1
_435.encounters_cpt_codesecp_mod1
_435.encounters_cpt_codes_templatesecpt_mod1
_435.patients_responsibility_estimates_servicesprests_mod1
_435.precerts_cpt_codespcp_mod1
_436.charts_cpt_codeschcp_mod1
_436.charts_procedurescp_mod1
_436.configured_encounters_templates_cpt_codescetcc_mod1
_436.encounters_cpt_codesecp_mod1
_436.encounters_cpt_codes_templatesecpt_mod1
_436.patients_responsibility_estimates_servicesprests_mod1
_436.precerts_cpt_codespcp_mod1
_436_archive_testing.charts_cpt_codeschcp_mod1
_436_archive_testing.charts_procedurescp_mod1
_436_archive_testing.configured_encounters_templates_cpt_codescetcc_mod1
_436_archive_testing.encounters_cpt_codesecp_mod1
_436_archive_testing.encounters_cpt_codes_templatesecpt_mod1
_436_archive_testing.patients_responsibility_estimates_servicesprests_mod1
_436_archive_testing.precerts_cpt_codespcp_mod1
_437.charts_cpt_codeschcp_mod1
_437.charts_procedurescp_mod1
_437.configured_encounters_templates_cpt_codescetcc_mod1
_437.encounters_cpt_codesecp_mod1
_437.encounters_cpt_codes_templatesecpt_mod1
_437.patients_responsibility_estimates_servicesprests_mod1
_437.precerts_cpt_codespcp_mod1
_8.charts_cpt_codeschcp_mod1
_8.charts_procedurescp_mod1
_8.configured_encounters_templates_cpt_codescetcc_mod1
_8.encounters_cpt_codesecp_mod1
_8.encounters_cpt_codes_templatesecpt_mod1
_8.patients_responsibility_estimates_servicesprests_mod1
_8.precerts_cpt_codespcp_mod1
_81.charts_cpt_codeschcp_mod1
_81.charts_procedurescp_mod1
_81.configured_encounters_templates_cpt_codescetcc_mod1
_81.encounters_cpt_codesecp_mod1
_81.encounters_cpt_codes_templatesecpt_mod1
_81.patients_responsibility_estimates_servicesprests_mod1
_81.precerts_cpt_codespcp_mod1
_999.charts_cpt_codeschcp_mod1
_999.charts_procedurescp_mod1
_999.configured_encounters_templates_cpt_codescetcc_mod1
_999.encounters_cpt_codesecp_mod1
_999.encounters_cpt_codes_templatesecpt_mod1
_999.patients_responsibility_estimates_servicesprests_mod1
_999.precerts_cpt_codespcp_mod1
template_library.encounters_cpt_codes_templatesecpt_mod1
mod2
TableColumn
_1.charts_cpt_codeschcp_mod2
_1.charts_procedurescp_mod2
_1.configured_encounters_templates_cpt_codescetcc_mod2
_1.encounters_cpt_codesecp_mod2
_1.encounters_cpt_codes_templatesecpt_mod2
_1.patients_responsibility_estimates_servicesprests_mod2
_1.precerts_cpt_codespcp_mod2
_1188.charts_cpt_codeschcp_mod2
_1188.charts_procedurescp_mod2
_1188.configured_encounters_templates_cpt_codescetcc_mod2
_1188.encounters_cpt_codesecp_mod2
_1188.encounters_cpt_codes_templatesecpt_mod2
_1188.patients_responsibility_estimates_servicesprests_mod2
_1188.precerts_cpt_codespcp_mod2
_1218.charts_cpt_codeschcp_mod2
_1218.charts_procedurescp_mod2
_1218.configured_encounters_templates_cpt_codescetcc_mod2
_1218.encounters_cpt_codesecp_mod2
_1218.encounters_cpt_codes_templatesecpt_mod2
_1218.patients_responsibility_estimates_servicesprests_mod2
_1218.precerts_cpt_codespcp_mod2
_1548.charts_cpt_codeschcp_mod2
_1548.charts_procedurescp_mod2
_1548.configured_encounters_templates_cpt_codescetcc_mod2
_1548.encounters_cpt_codesecp_mod2
_1548.encounters_cpt_codes_templatesecpt_mod2
_1548.patients_responsibility_estimates_servicesprests_mod2
_1548.precerts_cpt_codespcp_mod2
_435.charts_cpt_codeschcp_mod2
_435.charts_procedurescp_mod2
_435.configured_encounters_templates_cpt_codescetcc_mod2
_435.encounters_cpt_codesecp_mod2
_435.encounters_cpt_codes_templatesecpt_mod2
_435.patients_responsibility_estimates_servicesprests_mod2
_435.precerts_cpt_codespcp_mod2
_436.charts_cpt_codeschcp_mod2
_436.charts_procedurescp_mod2
_436.configured_encounters_templates_cpt_codescetcc_mod2
_436.encounters_cpt_codesecp_mod2
_436.encounters_cpt_codes_templatesecpt_mod2
_436.patients_responsibility_estimates_servicesprests_mod2
_436.precerts_cpt_codespcp_mod2
_436_archive_testing.charts_cpt_codeschcp_mod2
_436_archive_testing.charts_procedurescp_mod2
_436_archive_testing.configured_encounters_templates_cpt_codescetcc_mod2
_436_archive_testing.encounters_cpt_codesecp_mod2
_436_archive_testing.encounters_cpt_codes_templatesecpt_mod2
_436_archive_testing.patients_responsibility_estimates_servicesprests_mod2
_436_archive_testing.precerts_cpt_codespcp_mod2
_437.charts_cpt_codeschcp_mod2
_437.charts_procedurescp_mod2
_437.configured_encounters_templates_cpt_codescetcc_mod2
_437.encounters_cpt_codesecp_mod2
_437.encounters_cpt_codes_templatesecpt_mod2
_437.patients_responsibility_estimates_servicesprests_mod2
_437.precerts_cpt_codespcp_mod2
_8.charts_cpt_codeschcp_mod2
_8.charts_procedurescp_mod2
_8.configured_encounters_templates_cpt_codescetcc_mod2
_8.encounters_cpt_codesecp_mod2
_8.encounters_cpt_codes_templatesecpt_mod2
_8.patients_responsibility_estimates_servicesprests_mod2
_8.precerts_cpt_codespcp_mod2
_81.charts_cpt_codeschcp_mod2
_81.charts_procedurescp_mod2
_81.configured_encounters_templates_cpt_codescetcc_mod2
_81.encounters_cpt_codesecp_mod2
_81.encounters_cpt_codes_templatesecpt_mod2
_81.patients_responsibility_estimates_servicesprests_mod2
_81.precerts_cpt_codespcp_mod2
_999.charts_cpt_codeschcp_mod2
_999.charts_procedurescp_mod2
_999.configured_encounters_templates_cpt_codescetcc_mod2
_999.encounters_cpt_codesecp_mod2
_999.encounters_cpt_codes_templatesecpt_mod2
_999.patients_responsibility_estimates_servicesprests_mod2
_999.precerts_cpt_codespcp_mod2
template_library.encounters_cpt_codes_templatesecpt_mod2
cpt
TableColumn
_1.orders_test_codes_mapotcm_cpt
_1188.orders_test_codes_mapotcm_cpt
_1218.orders_test_codes_mapotcm_cpt
_1548.orders_test_codes_mapotcm_cpt
_435.orders_test_codes_mapotcm_cpt
_436.orders_test_codes_mapotcm_cpt
_436_archive_testing.orders_test_codes_mapotcm_cpt
_437.orders_test_codes_mapotcm_cpt
_8.orders_test_codes_mapotcm_cpt
_81.orders_test_codes_mapotcm_cpt
_999.orders_test_codes_mapotcm_cpt
aurora_standard.apscdmmc_cpt
aurora_standard.apscdmmd_cpt
aurora_standard.apscdmci_cpt
aurora_standard.apscdmwc_cpt
aurora_standard.apscdmamc_cpt
aurora_standard.apscdmamd_cpt
aurora_standard.apscdmaci_cpt
aurora_standard.apscdmawc_cpt
aurora_standard.bfcdmmd_cpt
aurora_standard.bfrhccdmmd_cpt
aurora_standard.chmokopdprin_cpt
aurora_standard.chmsubccstart_cpt
aurora_standard.chmsubccend_cpt
aurora_standard.samcdmcmc_cpt
aurora_standard.samcdmcmd_cpt
aurora_standard.workcptwk_cpt
common.test_codestco_cpt
rev_cd
TableColumn
aurora_standard.bfcdminvd_rev_cd
aurora_standard.bfcdmprod_rev_cd
aurora_standard.bfcdmrhcd_rev_cd
aurora_standard.chmsubccstart_rev_cd
aurora_standard.chmsubccend_rev_cd
aurora_standard.hl7dg1drg_grp_rev_cd
ub
TableColumn
aurora_standard.bfphyncmd_ub
aurora_standard.bminsrcelect_ub
aurora_standard.chmbillcmedicare_ub
aurora_standard.chmbillcmedicaid_ub
aurora_standard.chmbillcchampus_ub
aurora_standard.chmbillcbcbs_ub
aurora_standard.chmbillcother_ub
aurora_standard.chmblogdsecond_ub
aurora_standard.chmbremdsecond_ub
aurora_standard.chmerafccreate_ub
aurora_standard.chminsrccontract_ub
aurora_standard.chmpaytcpay_ub
aurora_standard.stxautodchg_inc_ub
aurora_standard.stxautodchg_exc_ub
serv_code
TableColumn
aurora_standard.chmpcatdrad_serv_code