aurora_standard.apscdm

Field Type Null Default Key Extra Comment
serv_code char(10) NO PRI
bill_descrip char(50) YES
dept char(3) YES
dept_desc char(10) YES
charge_amt decimal(10,2) YES
rev_cd char(10) YES
mc_cpt char(10) YES
md_cpt char(10) YES
ci_cpt char(10) YES
wc_cpt char(10) YES
ov_cd char(1) YES
os_cd varchar(1) YES
pro_fee varchar(1) YES
ref char(12) YES
grp char(1) YES
active_cd char(1) YES

References

Local Column References
grp
TableColumn
_1.cqm_statscqms_res_grp
_1188.cqm_statscqms_res_grp
_1218.cqm_statscqms_res_grp
_1548.cqm_statscqms_res_grp
_435.cqm_statscqms_res_grp
_436.cqm_statscqms_res_grp
_436_archive_testing.cqm_statscqms_res_grp
_437.cqm_statscqms_res_grp
_8.cqm_statscqms_res_grp
_81.cqm_statscqms_res_grp
_999.cqm_statscqms_res_grp
aurora_standard.apsphy2mc_grp
aurora_standard.bharco1_grp
aurora_standard.bharco2_grp
aurora_standard.bharco3_grp
aurora_standard.bharco4_grp
aurora_standard.bharco5_grp
aurora_standard.bharco6_grp
aurora_standard.bparco1_grp
aurora_standard.bparco2_grp
aurora_standard.bparco3_grp
aurora_standard.bparco4_grp
aurora_standard.bparco5_grp
aurora_standard.bparco6_grp
aurora_standard.bpar2co1_grp
aurora_standard.bpar2co2_grp
aurora_standard.bpar2co3_grp
aurora_standard.bpar2co4_grp
aurora_standard.bpar2co5_grp
aurora_standard.bpar2co6_grp
aurora_standard.chmagesdfc_grp
aurora_standard.chmagesdps_grp
aurora_standard.chmfcglctracking_grp
aurora_standard.chmlastrpri_ins_grp
aurora_standard.chmlastrsec_ins_grp
aurora_standard.chmlastrter_ins_grp
aurora_standard.chmopercusr_access_grp
aurora_standard.chmpatwcmom_ins_grp
aurora_standard.chmpatwcdad_ins_grp
aurora_standard.chmphynebox_33_grp
aurora_standard.chmtxstrpri_ins_grp
aurora_standard.chmtxstrsec_ins_grp
aurora_standard.chmtxstrter_ins_grp
aurora_standard.hl7dg1diag_rel_grp
aurora_standard.hl7dg1drg_grp_rev_cd
aurora_standard.stpvendract_grp
aurora_standard.strcustract_grp
ref
TableColumn
_1.encountersenc_medicaid_resub_org_ref
_1188.encountersenc_medicaid_resub_org_ref
_1218.encountersenc_medicaid_resub_org_ref
_1548.encountersenc_medicaid_resub_org_ref
_435.encountersenc_medicaid_resub_org_ref
_436.encountersenc_medicaid_resub_org_ref
_436_archive_testing.encountersenc_medicaid_resub_org_ref
_437.encountersenc_medicaid_resub_org_ref
_8.encountersenc_medicaid_resub_org_ref
_81.encountersenc_medicaid_resub_org_ref
_999.encountersenc_medicaid_resub_org_ref
aurora_standard.chlrestdlow_ref
aurora_standard.chlrestdhigh_ref
aurora_standard.chlrestdtext_ref
aurora_standard.chmmnecbbulletin_ref
aurora_standard.stfactvdbook_ref
aurora_standard.stfactvvbook_ref
aurora_standard.stpinvcerecurr_ref
aurora_standard.strinvcerecurr_ref
aurora_standard.sturectereceipt_ref
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.stxfinsdfin_dept_grp
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
serv_code
TableColumn
aurora_standard.chmpcatdrad_serv_code