aurora_standard.bgcdm

Field Type Null Default Key Extra Comment
serv_code char(20) YES
bill_descrip char(50) YES
charge_amt decimal(10,2) YES
rev_cd char(10) YES
cpt1 char(10) YES
mod1 char(3) YES
cpt2 char(10) YES
mod2 char(3) YES
dept char(3) YES
fac_no char(3) 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
dept
TableColumn
aurora_standard.TABLE 1424new_dept
aurora_standard.TABLE 1425new_dept
aurora_standard.axlscdmgl_ip_dept
aurora_standard.axlscdmgl_op_dept
aurora_standard.chmpchsdrev_loc_dept
aurora_standard.chmrefndcontr_dept
aurora_standard.chpcashrcash_dept
aurora_standard.chpcemprhome_dept
aurora_standard.chpcntrceduc_dept
aurora_standard.chpcntrccobra_cash_dept
aurora_standard.chpcntrccobra_bal_dept
aurora_standard.chpcntrccobra_fee_dept
aurora_standard.chpcobpdcash_dept
aurora_standard.chpcobpdbal_dept
aurora_standard.chpempcdempl_dept
aurora_standard.chtemplrdflt_dept
aurora_standard.chteshtvdflt_dept
aurora_standard.chtsfdpdshift_dept
aurora_standard.chtsupvcsupv_dept
aurora_standard.empldepthome_dept
aurora_standard.glxrefnew_dept
aurora_standard.glxrefold_dept
aurora_standard.ohofadtldepr_dept
aurora_standard.stfactvddepr_dept
aurora_standard.stfactvvdepr_dept
aurora_standard.stfasstrdepr_dept
aurora_standard.stfasstraccm_dept
aurora_standard.stgrowpdrod_beg_dept
aurora_standard.stgrowpdrod_end_dept
aurora_standard.stoinvcetd_ds_dept
aurora_standard.stoinvcest_tx_dept
aurora_standard.stoinvceco_tx_dept
aurora_standard.stoinvceci_tx_dept
aurora_standard.stoinvcefreight_dept
aurora_standard.stoinvceasset_dept
aurora_standard.stoordrdinv_dept
aurora_standard.stoordrdsls_dept
aurora_standard.stoordrdcog_dept
aurora_standard.stxcalixmedgenix_dept
aurora_standard.stxcalixcalifornia_dept
aurora_standard.stxfinsdfin_dept
aurora_standard.styaccrrliab_dept
aurora_standard.styaccrrexpense_dept
aurora_standard.stydedcrdflt_dept
aurora_standard.styemplrhome_dept
aurora_standard.styemplrdir_dept
aurora_standard.styempodbal_dept
aurora_standard.styinccrdflt_dept
aurora_standard.styinccracru_lia_dept
aurora_standard.styoblcrdflt_dept
aurora_standard.stypayodbal_dept
aurora_standard.stytypodbal_dept
common.test_codestco_x_lab_area_dept
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
serv_code
TableColumn
aurora_standard.chmpcatdrad_serv_code
fac_no
TableColumn
aurora_standard.chmpricaprev_fac_no
aurora_standard.chmpricacur_fac_no
aurora_standard.chpcashrcash_fac_no
aurora_standard.chpcobpdcash_fac_no
aurora_standard.chpcobpdbal_fac_no
aurora_standard.chscustddept_fac_no
aurora_standard.chshotlrdept_fac_no
aurora_standard.chtemplrdflt_fac_no
aurora_standard.curs_tempcash_fac_no
aurora_standard.curs_tempap_fac_no
aurora_standard.stgrowpdrod_beg_fac_no
aurora_standard.stgrowpdrod_end_fac_no
aurora_standard.stpcashddist_fac_no
aurora_standard.stpcashddisc_fac_no
aurora_standard.stpcashecash_fac_no
aurora_standard.stpcntrccash_fac_no
aurora_standard.stpcntrcdisc_fac_no
aurora_standard.stpinvcecash_fac_no
aurora_standard.stpopendap_fac_no
aurora_standard.stpopendcash_fac_no
aurora_standard.stucntrccash_fac_no
aurora_standard.stuinvcecash_fac_no
aurora_standard.stxfinsdfin_fac_no
aurora_standard.styaccrrliab_fac_no
aurora_standard.styaccrrexpense_fac_no
aurora_standard.styemplrcash_fac_no
aurora_standard.stypayfdcash_fac_no
aurora_standard.stypayodbal_fac_no
aurora_standard.stypayrecash_fac_no
aurora_standard.styrevsdcash_fac_no
aurora_standard.stytypercash_fac_no