表结构(综合查询).doc

《表结构(综合查询).doc》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、统计系统代码表1．DDHC_WorkLoad收入数据表字段名称说明类型备注WorkLoad_ARPBL_DR帐单号DHC_PatientBillDesignativeReferenceAR_PatientBillWorkLoad_BillGrp_DR帐单大类ARC_BillGrpDesignativeReferenceWorkLoad_BillSub_DR帐单子类ARC_BillSubDesignativeReferenceWorkLoad_CasherI_DRSS_UserDesignativeReference？Wor

2、kLoad_CasherO_DRSS_UserDesignativeReference？WorkLoad_DisDateDateWorkLoad_DisFlagTextWorkLoad_FlagTextWorkLoad_FlagDate结算日期DateWorkLoad_FlagTimeTimeWorkLoad_HoldDep_DRCT_LocDesignativeReferenceWorkLoad_HoldDoc_DRCT_CareProvDesignativeReferenceWorkLoad_HoldFlagTextW

3、orkLoad_HoldFlagDateDateWorkLoad_ItemCat_DR医嘱子类ARC_ItemCatDesignativeReferenceWorkLoad_ItemOrd_DR医嘱项ARC_ItmMastDesignativeReferenceWorkLoad_OEORI_DR医嘱OE_OrdItemDesignativeReferenceWorkLoad_OrdDate医嘱日期DateWorkLoad_OrdStatusMultipleChoiceWorkLoad_OrdTimeWorkLoad_PAA

4、DM_DRPa_admDesignativeReferenceWorkLoad_PAPMI_DRPA_PatMasDesignativeReferenceWorkLoad_PatDep_DR下医嘱科室CT_LocDesignativeReferenceWorkLoad_PatDoc_DR病人医生CT_CareProvDesignativeReferenceWorkLoad_PatWard_DR病人病区CT_LocDesignativeReferenceWorkLoad_Quantity医嘱数量WorkLoad_RecDep

5、_DR执行科室CT_LocDesignativeReferenceWorkLoad_RecDoc_DR执行医生CT_CareProvDesignativeReferenceWorkLoad_ReceiptI_DRTextWorkLoad_ReceiptO_DRTextWorkLoad_ResDep_DR病人科室CT_LocDesignativeReferenceWorkLoad_ResDoc_DR下医嘱医生DesignativeReferenceCT_CareProvWorkLoad_RowidRowIDWorkLoad_

6、StatDate插入数据日期DateWorkLoad_StatTimeTimeWorkLoad_TarAC_dr会计分类DHC_TarAcctCateDesignativeReferenceWorkLoad_TarEC_Dr核算分类DHC_TarEMCCateDesignativeReferenceWorkLoad_TarIC_Dr住院分类DHC_TarInpatCateDesignativeReferenceWorkLoad_TarItem_DR收费项目DHC_TarItemDesignativeReferenceWor

7、kLoad_TarMC_Dr病案分类DHC_TarMRCateDesignativeReferenceWorkLoad_TarOut_Dr门诊分类DHC_TarOutpatCateDesignativeReferenceWorkLoad_TarSC_DrDHC_TarSubCateDesignativeReferenceWorkLoad_TotalPrice费用WorkLoad_Type病人类型MultipleChoiceWorkLoad_UnitPrice单价WorkLoad_UserDep_DRDesignativeR

8、eferenceWorkLoad_User_DRDesignativeReferenceDateMaster：^DHCWorkLoad({WorkLoad_Rowid})Index–ARPBL:^DHCWorkLoad(0,"DateARPBL",{WorkLoad_OrdDate},{WorkLoad