2医保欺诈数据说明.docx

序号数据项业务含义类型备注1PAPMI_RowIdID 号RowId2PAPMI_Name姓名,First nameString3PAPMI_DOB出生日期String4PAPMI_Name2Middle nameString5PAPMI_Name4Last name6PAPMI_Name3医保手册号String7PAPMI_Medicare病历号(住院)8PAPMIMedicareExpDate9PAPMI_MedicareCode传真传真10PAPMI_GovernCardNo门诊病历号11PAPMI_DVAnumbe身份证号12PAPMIAlias病人别名13PAPMIIPNo住院号14PAPMIOPNo门诊号15PAPMIEstAgeYear16PAPMIEstAgeMonth17PAPMIEstAgeTmStmp18PAPMISoundex19PAPMILangPrimDR母语20PAPMILangSecondDR第二母语21PAPMIPrefLanguageDR首选语言22PAPMIActive激活23PAPMIVIPFlagVIP 标志24PAPMIPatCategoryDR病人分类25PAPMIHomeClinicNo26PAPMIRemark备注27PAPMIDeceased死亡标志28PAPMIDeceasedDate死亡日期29PAPMIDeceasedTime死亡时间30PAPMIBlackList黑名单标志31PAPMIEstimatedDeathDate32PAPMIMotherDR母亲记录指针33PAPMIMother1DR34PAPMIRefDocDR家庭医生35PAPMIDentistDR牙医36PAPMIDentistClinicDR牙医诊所37PAPMITraceStatusDR38PAPMIMedicareSuffixDR39PAPMIAllergy过敏记录40PAPMIEPRDescription电子病历41PAPMIConcessionCardNo42PAPMIConcessionCardExpDate43PAPMISafetyNetCardNo44PAPMISafetyNetCardExpDate45PAPMIGovernCardNo46PAPMIDVAnumber47PAPMIInsuranceCardHolder48PAPMICardTypeDR49PAPMICHCPatient50PAPMICTHCADRCTHealthCareArea51PAPMIHealthFundNo52PAPMIHealthCardExpiryDate健康卡号失效日期53PAPMICountryOfBirthDR出生国54PAPMICityBirthDR出生城市55PAPMITitleDR头衔56PAPMICTRegionDR所在地区57PAPMICTProvinceDR所在省58PAPMICityAreaDR所在区59PAPMIEmail电子邮件60PAPMIMobPhone手机61PAPMISecondPhone第二联系电话62PAPMIAuxInsTypeDR63PAPMIPensionTypeDR64PAPMIIndigStatDR65PAPMIRequireAssistanceMeal需要辅食66PAPMIRequireAssistanceMenu需要辅食菜单2.2 药费明细表 dhc_workload序号字段名称说明类型备注1WorkLoad_ARPBL_DR帐单号 DHC_PatientBillDesignativeReference2WorkLoad_BillGrp_DR帐单大类 ARC_BillGrpDesignativeReference3WorkLoad_BillSub_DR帐单子类 ARC_BillSubDesignativeReference4WorkLoad_CasherI_DRSS_UserDesignativeReference5WorkLoad_CasherO_DRSS_UserDesignativeReference6WorkLoad_DisDateDate7WorkLoad_DisFlagText8WorkLoad_FlagText9WorkLoad_FlagDate结算日期Date10WorkLoad_FlagTimeTime11WorkLoad_HoldDep_DRCT_LocDesignativeReference12WorkLoad_HoldDoc_DRCT_CareProvDesignativeReference13WorkLoad_HoldFlagText14WorkLoad_HoldFlagDateDate15WorkLoad_ItemCat_DR医嘱子类DesignativeReference指向 ARC_ItemCat16WorkLoad_ItemOrd_DR医嘱项DesignativeReference指向 ARC_ItmMast17WorkLoad_OEORI_DR医嘱 OE_OrdItemDesignativeReference18WorkLoad_OrdDate医嘱日期Date19WorkLoad_OrdStatusMultipleChoice20WorkLoad_OrdTime21WorkLoad_PAADM_DRPa_admDesignativeReference指向 Pa_adm22WorkLoad_PAPMI_DRPA_PatMasDesignativeReference23WorkLoad_PatDep_DR下医嘱科室 CT_LocDesignativeReference24WorkLoad_PatDoc_DR病人医生 CT_CareProvDesignativeReference25WorkLoad_PatWard_DR病人病区 CT_LocDesignativeReference26WorkLoad_Quantity医嘱数量27WorkLoad_RecDep_DR执行科室 CT_LocDesignativeReference28WorkLoad_RecDoc_DR执行医生 CT_CareProvDesignativeReference29WorkLoad_ReceiptI_DRText30WorkLoad_ReceiptO_DRText31WorkLoad_ResDep_DR病人科室 CT_LocDesignativeReference32WorkLoad_ResDoc_DR下医嘱医生 CT_CareProvDesignativeReference33WorkLoad_RowidRow ID34WorkLoad_StatDate插入数据日期Date35WorkLoad_StatTimeTime36WorkLoad_TarAC_dr会计分类 DHC_TarAcctCateDesignativeReference37WorkLoad_TarEC_Dr核算分类 DHC_TarEMCCateDesignativeReference38WorkLoad_TarIC_Dr住院分类 DHC_TarInpatCateDesignativeReference39WorkLoad_TarItem_DR收费项目 DHC_TarItemDesignativeReference40WorkLoad_TarMC_Dr病案分类 DHC_TarMRCateDesignativeReference41WorkLoad_TarOut_Dr门诊分类DHC_TarOutpatCateDesignativeReference42WorkLoad_TarSC_DrDHC_TarSubCateDesignativeReference43WorkLoad_TotalPrice费用44WorkLoad_Type病人类型MultipleChoice45WorkLoad_UnitPrice单价46WorkLoad_UserDep_DRDesignativeReference47WorkLoad_User_DRDesignativeReference2.3 医嘱表ARC_ItmMast序号数据项业务含义类型备注1ARCIM_RowIdRow ID2ARCIM_Code代码Text3ARCIM_Desc描述Text4ARCIM_Abbrev缩写Compute5ARCIM_UOM_DR单位DR指向 CT_UOM6ARCIM_MinAmtMinimumAmountNumber7ARCIM_MaxAmtMaximumAmountNumber8ARCIM_ChgUnitFactCharge UnitFactorNumber9ARCIM_ItemCat_DR医嘱子类DR指向 ARC_ItemCat10ARCIM_ChgCostUnit CostNumber11ARCIM_ChgMinAmtMinimumAmountNumber12ARCIM_ChgMaxAmtMaximumAmountNumber13ARCIM_StdAmtStandardAmountNumber14ARCIM_TypeAAmtType A AmountNumber15ARCIM_TypeBAmtType B AmountNumber16ARCIM_ChgDispFlgPrice controlflagMul CI|Input,D|Display17ARCIM_ChgPostFlgCharge postingflagMul CO|Upon Order Entry,E|Upon execution18ARCIM_TimeDepFlgTimedependent flagY/N19ARCIM_P1ChgFactPeriod 1Charge FactorNumber20ARCIM_P1StdAddAmtPeriod 1StandardAdditionalAmountNumber21ARCIM_P1TypAAddAmtPeriod 1 TypeA AdditionalAmountNumber22ARCIM_P1TypBAddAmtPeriod 1 TypeB AdditionalAmountNumber23ARCIM_P2ChgFactPeriod 2charge factorNumber24ARCIM_P2StdAddAmtPeriod 2StandardAdditionalAmountNumber25ARCIM_P2TypAAddAmtPeriod 2 TypeA AdditionalAmountNumber26ARCIM_P2TypBAddAmtPeriod 2 TypeB AdditionalAmountNumber27ARCIM_P3ChgFactPeriod 3Charge FactorNumber28ARCIM_P3StdAddAmtPeriod 3StandardAdditionalAmountNumber29ARCIM_P3TypAAddAmtPeriod 3 TypeA AdditionalAmountNumber30ARCIM_P3TypBAddAmtPeriod 3 TypeB AdditionalAmountNumber31ARCIM_P4ChgFactPeriod 4charge flagNumber32ARCIM_P4StdAddAmtPeriod 4StandardAdditionalAmountNumber33ARCIM_P4TypAAddAmtPeriod 4 TypeA AdditionalAmountNumber34ARCIM_P4TypBAddAmtPeriod 4 TypeB AdditionalAmountNumber35ARCIM_ServCat_DR服务种类DR指向服务分类表 ARC_ServCat36ARCIM_ProfileFlgProfile FlagY/N37ARCIM_SubMasFlgAncillaryMaster FlagY/N38ARCIM_BillSub_DR账单子组DR指向 ARC_ServCAT39ARCIM_ServTax_DR服务税DR指向 ARC_ServTax40ARCIM_DoseTypeDose typeMul CO|One Dose,D|Daily Dose,U|Unit Dose41ARCIM_PHCDF_DR药物形态DR指向药物形态表 PHC_DrgForm42ARCIM_VersionVersionNumber43ARCIM_CurVers_DRCurrentVersionDR指向 ARC_ItmMast44ARCIM_CurVerFlgCurrentVersion FlagComputeS ARCIM_CurVerFlg=$CURVERat115(ARCIM_CurVers_DR,ARCIM_RowId)45ARCIM_EffDateEffective DateDate46ARCIM_EffTimeEffective TimeTime47ARCIM_EffDateTimeEffective Date/TimeComputesARCIM_EffDateTime=$p(ARCIM_EffDate,$c(1)_Z_$p(ARCIM_EffTime,$c(1)48ARCIM_SubscriptARCIMSubscriptNumber49ARCIM_GLPostToOrderDeptY/N50ARCIM_RvpFudNumber51ARCIM_RvpAnesNumber52ARCIM_RvpUnitStatMul CI|Interim,BR|By Report,RNE|Relativity Not Established53ARCIM_RvpUpdText54ARCIM_RvpInterimYearNumber55ARCIM_InsCoDescInsuranceCompanyDescriptionText56ARCIM_InsSubCat_DRDR指向 ARC_InsuranceSubcategory57ARCIM_EffDateToEffective DateToDate58ARCIM_Surcharge_DRDR指向 ARC_SurchargeCode59ARCIM_OintmentNumber60ARCIM_ServMaterial服务/材料Mul CS|Service,M|Material61ARCIM_HaemodalY/N62ARCIM_CAPDY/N63ARCIM_KidneyTranspY/N64ARCIM_BillBodyP_DR身体部位DR指向 ARC_BillBodyParts65ARCIM_OEMessageOrder EntryMessageText66ARCIM_IncSource_DR收入来源DR指向 ARC_IncomeSource67ARCIM_OrderOnItsOwn独立医嘱Y/N68ARCIM_VisibleInOrderListY/N69ARCIM_ManufacturedComputes ARCIM_Manufactured=$CO85at115(ARCIM_RowId70ARCIM_ChargePartialY/N71ARCIM_SnackFlagY/N72ARCIM_RiceType_DR饮食浓度DR指向 DTC_RiceType73ARCIM_UpdateDate最后更新日期Date74ARCIM_UpdateTime最后更新时间Time75ARCIM_UpdateUser最后更新人DR指向 SS_User76ARCIM_ConsultDeptDR指向 CT_Loc77ARCIM_SingleFeeY/N78ARCIM_Row_CalcComputes ARCIM_Row_Calc=ARCIM_Subscript_|_ARCIM_Version79ARCIM_Type_CalcComputes ARCIM_Type_Calc=ARCIM80ARCIM_MealType_DR饮食进餐时间DR指向 DTC_MealType81ARCIM_ServiceGroup_DR服务组DR指向 RBC_ServiceGroup82ARCIM_MinutesMinutesText83ARCIM_DaysDaysNumber84ARCIM_AllowOrderWOStockCheck无库存医嘱Y/N85ARCIM_BillDescription账单描述Mul CD|Description Only,P|Processing Notes Only,B|Description and Processing Notes86ARCIM_PriceCostOnOrdering定价和花费Mul CC|Inform Cost on Ordering,P|Inform Price and Cost on Ordering,N|No Value87ARCIM_BillingUOM_DR账单计量单位DR指向 CT_UOM88ARCIM_WordTemplateWord TemplateText89ARCIM_RMDuration_DRDR指向 PHC_Duration90ARCIM_RMFrequency_DRDR指向 PHC_Freq91ARCIM_DerivedFeeItemY/N92ARCIM_DerFeeRules_DR收费规定DR指向费用标准表 ARC_DerivedFeeRules93ARCIM_Generic_DR药物DR指向 PHC_Generic94ARCIM_GenericDescText95ARCIM_DefPriority_DR默认优先级DR指向 OEC_Priority96ARCIM_ShortDescCompute97ARCIM_RangeFrom范围从Text98ARCIM_RangeTo范围到Text99ARCIM_ResultGroupText100ARCIM_PayorICDGroup_DRPayor ICDGroupDR指向 MRC_PayorICDGroup101ARCIM_FileNotesText102ARCIM_RBNotesText103ARCIM_UseODBCforWordY/N104ARCIM_Questionnaire_DRDR指向 SS_UserDefWindow105ARCIM_DaysCheckDuplicateNumber106ARCIM_DoseCalcFormulaDose CalcFormulaMul CB|Boyd,G|Gehan and George,M|Mosteller,H|Haycock,D|Du Bois and DuBois,C|Calvert107ARCIM_QuesMandatoryY/N108ARCIM_ObservationGroup_DR观察组DR指向 MRC_ObservationGroup109ARCIM_AdminQuestionn_DRDR指向 SS_UserDefWindow110ARCIM_TestItemSequnceText111ARCIM_ProcessingNotesText112ARCIM_MaxPriceNumber113ARCIM_MinPriceNumber114ARCIM_ModifiersRequiredY/N115ARCIM_SensitiveY/N116ARCIM_PatientOrderFile1Text117ARCIM_PatientOrderFile2Text118ARCIM_PatientOrderFile3Text119ARCIM_SensitiveOrderY/N120ARCIM_DisplayCumulativeY/N121ARCIM_ResultDisplayGroupDRDR指向 OEC_ResultDisplayGroup122ARCIM_ChgOrderPerHourY/N123ARCIM_AuthorisingClinicianAuthorisingClinicianDR指向 CT_CareProv124ARCIM_HL7ResultTypeHL7ResultTypeMul CAT|Atomic,IM|Image,AI|Atomic and Image125ARCIM_DentalState_DRDR指向 OEC_DentalState126ARCIM_DeceasedPatientsOnlyY/N127ARCIM_MaxCumDoseNumber128ARCIM_NoOfCumDaysNumber129ARCIM_Text1Text130ARCIM_Text2Text131ARCIM_Text3Text132ARCIM_Text4Text133ARCIM_Text5Text134ARCIM_MaxQtyPerDayNumber135ARCIM_MaxQtyNumber136ARCIM_MinTimeText137ARCIM_ServiceCharge_DRDR指向 ARC_ServiceCharge138ARCIM_EnergyKjText139ARCIM_EnergyCalText140ARCIM_ProteinGText141ARCIM_TotalFatGText142ARCIM_SaturatedFatsGText143ARCIM_CarbohydratesGText144ARCIM_SugarsGText145ARCIM_SodiumMgText146ARCIM_DietryFibreGText147ARCIM_OtherGText148ARCIM_UserDefWindow_DRDR指向 SS_UserDefWindow149ARCIM_RestrictEMY/N150ARCIM_RestrictIPY/N151ARCIM_RestrictOPY/N152ARCIM_RestrictHPY/N153ARCIM_ServicePriority_DRDR指向 RBC_ServicePriority154ARCIM_PhoneOrderReviewTimeNumber155ARCIM_ExcludeFromGrpWarnY/N156ARCIM_PreRecoveryTimeMinNumber157ARCIM_PreRecoveryTimeTypeMul CB|Blank,PR|Pre,PO|Post158ARCIM_SequenceOrderMul CF|Always First,S|Always Second,L|Always Last,B|Blank2.4 医嘱子类 ARC_ItemCatt序号数据项业务含义类型备注1ARCIC_RowIdRowID2ARCIC_Code代码Text3ARCIC_Desc描述Text4ARCIC_ExecFlagMul CR|Required,N|Not Allowed5ARCIC_DoseTypeMul CO|One,D|Daily,U|Unit6ARCIC_ExecFreqY/N7ARCIC_ExecDoseY/N8ARCIC_OrderType医嘱类型Mul CR|Drug,D|Diet,I|IV,C|Consultation,N|Normal,T|Dental,L|LabTrak,X|RehabMedicine,P|Price,B|BloodBank,S|DietSupplement,H|Hardware,E|Diet Enteral Feed,A|Day Book,F|DFT,DTFDiet Thickened Fluid,BM|BulkMeal,PROS|Prosthetics9ARCIC_OrdCat_DR医嘱分类DR指向表 OEC_OrderCategory10ARCIC_ExecCateg_DR执行类型DR指向表 OEC_ExecCateg11ARCIC_TemplateTemplateText12ARCIC_CalcQtyFlag计算数量Y/N13ARCIC_NurseWorkBench在护士站显示Y/N14ARCIC_TextResultType_DR文本结果类型DR指向表 OEC_TextResultType15ARCIC_DicomResultY/N16ARCIC_OverridePriceY/N17ARCIC_AllowToEnterOneResultOnlyY/N18ARCIC_UseODBCforWordY/N19ARCIC_HL7ResultTypeMul CAT|Atomic,IM|Image,AI|Atomic&Image20ARCIC_BillingTypeMul CC|Collection,E|Executable,SR|SpecimenReception,I|NotRequired21ARCIC_Questionnaire_DRDR指向表 SS_UserDefWindow22ARCIC_OnlyShowVerResY/N23ARCIC_LaboratoryCodesText24ARCIC_RecieveSpecimensY/N25ARCIC_CounterTypeDrDR指向表 PAC_CounterType26ARCIC_RestrictedOrderY/N27ARCIC_SecSignForAdmY/N28ARCIC_WarningNonVerResultY/N29ARCIC_UserDefWindow_DRDR指向表 SS_UserDefWindow30ARCIC_PrescrExpDaysNumber31ARCIC_PrescrRepeatDaysNumber32ARCIC_IVExpiryNumber33ARCIC_PhoneOrderReviewTimeNumber2.5 核算分类 DHC_TarEMCCate序号数据项业务含义类型备注1TAREC_RowIdRowId2TAREC_Code代码Text3TAREC_Desc描述Text4TAREC_TARTEC_DR指向大类DR指向User.DHCTarEC2.6 患者费别 PAC_AdmReason序号数据项业务含义类型备注1REA_RowIdRowId2REA_Code代码Text3REA_Desc描述Text4REA_DateFrom生效日期Date5REA_DateTo截止日期Date6REA_NationalCodeText7REA_AgeFromNumber8REA_AgeToNumber9REA_InPatAdm_DRText10REA_AdmSourceText11REA_QualifStatusText12REA_CareTypeText13REA_EpisSubTypeText14REA_AgeTypeMul CM|Month,D|Days,Y|Year15REA_Age1FromNumber16REA_Age1ToNumber17REA_Age1TypeMul CM|Month,D|Days,Y|Year