aurora_standard.samcdmc

Field Type Null Default Key Extra Comment
dept char(3) YES
serv_code char(10) YES
bill_descrip char(40) YES
charge_amt decimal(10,2) YES
rev_cd char(4) YES
mc_cpt char(10) YES
md_cpt char(10) YES
modifier char(2) YES

References

Local Column References
modifier
TableColumn
_1.clients_fee_schedules_mapcfsm_modifier
_1.cptcpt_modifier
_1.cpt_analysis_codescac_modifier
_1188.clients_fee_schedules_mapcfsm_modifier
_1188.cptcpt_modifier
_1188.cpt_analysis_codescac_modifier
_1218.clients_fee_schedules_mapcfsm_modifier
_1218.cptcpt_modifier
_1218.cpt_analysis_codescac_modifier
_1548.clients_fee_schedules_mapcfsm_modifier
_1548.cptcpt_modifier
_1548.cpt_analysis_codescac_modifier
_435.clients_fee_schedules_mapcfsm_modifier
_435.cptcpt_modifier
_435.cpt_analysis_codescac_modifier
_436.clients_fee_schedules_mapcfsm_modifier
_436.cptcpt_modifier
_436.cpt_analysis_codescac_modifier
_436_archive_testing.clients_fee_schedules_mapcfsm_modifier
_436_archive_testing.cptcpt_modifier
_436_archive_testing.cpt_analysis_codescac_modifier
_437.clients_fee_schedules_mapcfsm_modifier
_437.cptcpt_modifier
_437.cpt_analysis_codescac_modifier
_8.clients_fee_schedules_mapcfsm_modifier
_8.cptcpt_modifier
_8.cpt_analysis_codescac_modifier
_81.clients_fee_schedules_mapcfsm_modifier
_81.cptcpt_modifier
_81.cpt_analysis_codescac_modifier
_999.clients_fee_schedules_mapcfsm_modifier
_999.cptcpt_modifier
_999.cpt_analysis_codescac_modifier
aurora_standard.chmachgdcpt_modifier
common.cqm_conditionscqc_target_att_modifier
common.cqm_conditionscqc_target2_att_modifier
template_library.cptcpt_modifier
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