表结构(综合驳拈询).doc

统计系统代码表 DDHC_WorkLoad 收入数据表 字段名称说明类型备注WorkLoad_ARPBL_DR帐单号DHC_PatientBillDesignative ReferenceAR_PatientBillWorkLoad_BillGrp_DR帐单大类ARC_BillGrpDesignative ReferenceWorkLoad_BillSub_DR帐单子类ARC_BillSubDesignative ReferenceWorkLoad_CasherI_DRSS_UserDesignative Reference？WorkLoad_CasherO_DRSS_UserDesignative Reference？WorkLoad_DisDateDateWorkLoad_DisFlagTextWorkLoad_FlagTextWorkLoad_FlagDate结算日期DateWorkLoad_FlagTimeTimeWorkLoad_HoldDep_DRCT_LocDesignative ReferenceWorkLoad_HoldDoc_DRCT_CareProvDesignative ReferenceWorkLoad_HoldFlagTextWorkLoad_HoldFlagDateDateWorkLoad_ItemCat_DR医嘱子类ARC_ItemCatDesignative ReferenceWorkLoad_ItemOrd_DR医嘱项ARC_ItmMastDesignative ReferenceWorkLoad_OEORI_DR医嘱OE_OrdItemDesignative ReferenceWorkLoad_OrdDate医嘱日期DateWorkLoad_OrdStatusMultiple ChoiceWorkLoad_OrdTimeWorkLoad_PAADM_DRPa_admDesignative ReferenceWorkLoad_PAPMI_DRPA_PatMasDesignative ReferenceWorkLoad_PatDep_DR下医嘱科室CT_LocDesignative ReferenceWorkLoad_PatDoc_DR病人医生CT_CareProvDesignative ReferenceWorkLoad_PatWard_DR病人病区CT_LocDesignative ReferenceWorkLoad_Quantity医嘱数量WorkLoad_RecDep_DR执行科室CT_LocDesignative ReferenceWorkLoad_RecDoc_DR执行医生CT_CareProvDesignative ReferenceWorkLoad_ReceiptI_DRTextWorkLoad_ReceiptO_DRTextWorkLoad_ResDep_DR病人科室CT_LocDesignative ReferenceWorkLoad_ResDoc_DR下医嘱医生CT_CareProvDesignative ReferenceWorkLoad_RowidRow IDWorkLoad_StatDate插入数据日期DateWorkLoad_StatTimeTimeWorkLoad_TarAC_dr会计分类DHC_TarAcctCateDesignative ReferenceWorkLoad_TarEC_Dr核算分类DHC_TarEMCCateDesignative ReferenceWorkLoad_TarIC_Dr住院分类DHC_TarInpatCateDesignative ReferenceWorkLoad_TarItem_DR收费项目DHC_TarItemDesignative ReferenceWorkLoad_TarMC_Dr病案分类DHC_TarMRCateDesignative ReferenceWorkLoad_TarOut_Dr门诊分类DHC_TarOutpatCateDesignative ReferenceWorkLoad_TarSC_DrDHC_TarSubCateDesignative ReferenceWorkLoad_