aurora_standard.aseycmc

Field Type Null Default Key Extra Comment
serv_code char(10) YES
bill_descrip char(50) YES
rev_cd char(10) YES
ins_cd char(2) YES
cpt char(10) YES
charge_amt decimal(10,2) YES
gl_no char(10) YES

References

Local Column References
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
ins_cd
TableColumn
aurora_standard.chhl7in2non_cover_ins_cd
aurora_standard.hl7in2non_cover_ins_cd
aurora_standard.hl7in2adnon_cover_ins_cd
gl_no
TableColumn
aurora_standard.chmchfcdold_gl_no
aurora_standard.chmchfcdnew_gl_no
aurora_standard.financial_class_changesold_gl_no
aurora_standard.financial_class_changesnew_gl_no
serv_code
TableColumn
aurora_standard.chmpcatdrad_serv_code