第1页 / 共134页
第2页 / 共134页
第3页 / 共134页
第4页 / 共134页
第5页 / 共134页
第6页 / 共134页
第7页 / 共134页
第8页 / 共134页
方正公司医院信息系统数据库表结构.doc
摘要：
目 录
PUBLIC
GH
MZ
RT
WH
YP
ZY
YZ
XT
ZD
PUBLIC
1 a_daily_report(公共日报表)
2 a_daily_report_data(日报数据表)
3 a_daily_report_receipt(日报发票表)
4 a_daily_report_receipt_flag(前台结帐发票标记)
5 a_daily_report_receipt_type(前台结帐发票类型)
6 a_employee_mi(职工主索引)
7 a_hospital (医院属性表)
GH
1 gh_base_request(门诊基础号表)
2 gh_base_request_segment(门诊号基础分配定义)
3 gh_config (门诊挂号定义表)
4 gh_deposit(现金流水账)
5 gh_detail_charge(费用明细)
6 gh_doctor_out(医生出诊)
7 gh_op_receipt(挂号员发票号定义表)
8 gh_receipt(发票)
9 gh_receipt_charge(发票账单明细)
10 gh_record(挂号记录)
11 gh_request() 挂号表
12 gh_zd_clinic_charge (号别字典费用项目明细)
13 gh_zd_clinic_type(号别字典)
14 gh_zd_request_charge/b(号类费用字典)
15gh_zd_request_type(号类字典)
16gh_zd_window_no(挂号窗口号字典)
17gh_zd_work_time(医生工作时间)
MZ
1 mz_bill_item(帐单码)
2 mz_charge_device (门诊收费设备)
3 mz_charge_pattern(门诊收费模板)
4 mz_charge_patern_define(门诊收费模板明细)
5 mz_config（门诊收费定义表）
6 mz_deposit/b(现金帐)
7 mz_detail_charge/b(门诊收费明细表)
8 mz_detail_charge_back（门诊退费明细表）
9 mz_dg_orders(门诊诊断处方模板)
10 mz_dg_orders_detail（门诊诊断处方模板明细）
11 mz_dg_record（门诊诊断处方记录表）
12 mz_dg_templates（门诊诊断体温记录表）
13 mz_dg_templates_ orders（门诊诊断体温记录表）
14 mz_op_receipt(收费员发票号定义表)
15 mz_order_generator(序号发生器表)
16 mz_order_put (处方分配定义)
17 mz_patient_mi /b(门诊病人主索引)
18 mz_receipt/b(发票表)
19 mz_receipt_charge/b(发票明细表)
20 mz_visit_table(门诊病人就诊记录表)
21 mz_zd_haoming(号名字典)—门诊[查号类型]
22 mz_zd_order_type(处方分配/类型定义)
RT(report)
1 rt_composit_report（复合报表表)
2 rt_report_data（报表数据）
3 rt_report_params（报表参数表）
4 rt_report_subsys（报表从属关系表）
WH
1 wh_dict_cover (字典维护界面表)
2 wh_dict_field(字典字段信息表)
3 wh_field_struc(库中表字段结构信息)
4 wh_index_struc(库中表索引结构信息)
5 wh_subsys_dict(子系统可维护字典表)
6 wh_table_struc(库中表列表)
7 wh_tag_sql(TAG_SQL对照表)
8 wh_temp_filter(临时过滤条件表过滤窗口用)
9 wh_trans_define_file(传输定义文件)
10 wh_trans_sql_params(传输SQL语句参数)
11 wh_trans_table_list(传输定义中表列表)
12 wh_trans_transed_record(传输日志)
YP
1 yp_base（药品库存明细表）
2 yp_class(药品/药性分类表)
3 yp_configures(药品系统管理配置表)
4 yp_convert_unit(药品单位转换率表)
5 yp_dict（药品属性表）
6 yp_dosage(药品剂型表)
7 yp_draw_pagetype(药单)
8 yp_drug_type（药品类型表）
9 yp_drugname（药品名称表）
10 yp_group_name(药品管理分组表)
11 yp_in_detl(药品入库明细表)
12 yp_in_out_type(药品入出库类型表)
13 yp_in_plan(药品入库计划表)
14 yp_infusion(药品大输液余量表)
15 yp_manufacture(药品生产厂商表)
16 yp_out_detl(药品科室出库明细表)
17 yp_out_patient(药品病人出库明细表)
18 yp_report(药品报表)
19 yp_reprice(药品调价记录表)
20 yp_reprice_stock(药品调价时库存表)
21 yp_supplyer(药品供应商表)
22 yp_unit(药品包装单位表)
23 yp_zd_reajlicense(药品调价字典)
ZY
1 a_patient_mi (zy_patient_mi住院病人主索引)
2 zy_actpatient(在院病人表)
3 zy_adt(转科记录表)
4 zy_adtward(病房定义表)
5 zy_audit_item(收费项目分类字典)
6 zy_bed_charge(床位收费字典)
7 zy_bed_mi(床位字典)
8 zy_bed_status (床位状态字典表)
9 zy_bed_type(床位类型字典表)
10 zy_bill_item (住院帐单码字典)
11 zy_charge_input_list(住院处收费模板内容表)
12 zy_charge_input_model(住院处收费模板定义表)
13 zy_configure(住院子系统系统参数表)
14 zy_deposit_file (病人交款记录表)
15 zy_detail_charge/b/c (病人细目帐)
16 zy_actpatient(出院病人表)
17 zy_patient_total_charge()—崭无用
18 zy_pay_unit（住院分摊单位字典）
19 zy_receipt(病人收据记录表)
20 zy_receipt_cancel(住院收据废票记录表)
21 zy_receipt_charge（病人收据费用记录表）
22 zy_receipt_no(住院收据号记录表)
23 zy_register(预约单记录表)
24 zy_responce_bill_percent(帐单分摊比例字典)
25 zy_responce_charge_percent(项目分摊比例字典)
26 zy_responce_total_percent(总费用分摊比例字典)
27 zy_detail_charge_order (医技录入项目)
YZ
1 yz_act_order(在院病人医嘱表)
2 yz_add_occ(嘱托医嘱—非收费医嘱)
3 yz_configure(医嘱配置表)
4 yz_exclusive(排斥组定义表)
5 yz_exclusive_order(组排斥医嘱)
6 yz_frequency(医嘱频率字典)
7 yz_frequency_time(医嘱频率时间表)
8 yz_op_time(手术时间表)
9 yz_order_charge ( 医嘱收费字典)
10 yz_order_item(医嘱字典)
11 yz_order_print(医嘱打印表)
12 yz_order_type(医嘱类型表)
13 yz_pattern(成组医嘱定义表)
14 yz_pattern_order(成组医嘱内容表)
15 yz_supply(给药方式字典)
16 yz_supply_charge(给药方式收费字典)
17 yz_supply_class (给药方式分类 )
18 yz_temperature(病人体温脉搏记录)
XT(system)
1 xt_func(系统功能定义表)
2 xt_group(系统用户组定义表)
3 xt_subsys(子系统定义表)
4 xt_user(系统用户定义表)
5 xt_user_group(用户组--功能定义表)
6 xt_user_interface(各系统界面表)
ZD(dict)
1 zd_academy_degree(学位代码表GB6864)
2 zd_admiss_status(入院状态字典--统计要用!)
3 zd_admiss_type(就诊类型字典)
4 zd_agent_type(单位性质代码表--自造)
5 zd_anaesthesia(麻醉方法字典)
6 zd_army_rank(军衔代码--GB/T_14946-94_A35)
7 zd_award_cause(奖惩原因代码表－－B/T_14946-94_A23)
8 zd_award_code(荣誉奖励处分代码表--GB8563+GB8560+GB85)
9 zd_award_punish(奖惩类别代码表--GB/T_14946-94_A20)
10 zd_blood_type(血型字典)
11 zd_cadre_dsource(干部来源细类――自造)
12 zd_cadre_source(干部来源代码表――GB/T_14946-94_A15)
13 zd_charge_class(项目分类字典)
14 zd_charge_flag_group(收费项目分组字典)
15 zd_charge_flag_type(费用标志与类型对应表)
16 zd_charge_group (收费项目分组字典)
17 zd_charge_item(收费项目字典――诊疗)
18 zd_charge_item_child(收费项目子字典)
19 zd_charge_percent_type(收费比例类型)
20zd_charge_type(费别类型)—门诊收费中[费别]
21zd_cheque_type(票据类型)--门诊收费中[付款类型]
22zd_classtatus_code(本人成份代码表--GB4764)
23 zd_cm3 ( 手术名称字典)
24 zd_contract_code(合同单位字典)
25 zd_contract_type(合同单位类别字典)
26 zd_country_code（国家名称字典――GB26599）
27 zd_cut_heal_grade(切口等级//愈合类别字典)
28 zd_deposit_status(交款状态字典)
29 zd_dept_code(门诊业务部门代码)
30 zd_detail_status(病人费用明细状态字典)
31 zd_diag_conform(诊断符合标志字典)
32 zd_dis_diag_status(出院转归字典)
33 zd_dis_diag_type(出院诊断类别)
34 zd_dischar_status(出院去向字典)
35 zd_dispose_reason(离职原因代码表--自造)
36 zd_district_code(地区码--GB2260)
37 zd_duration_code(用工期限代码表--自造)
38 zd_education_code(文化程度代码表--GB4658)
39 zd_emp_grade(行政级别代码表--GB12407)
40 zd_emp_inmark(职工在院标志代码表--自造)
41 zd_emp_position(行政职务代码表--GB12403)
42 zd_emp_title（技术职称代码表(GB8561)
43 zd_equip_name设备名称字典(WZB01-90)
44 zd_expert_treat (专家享受待遇代码表--自造)
45 zd_expert_type(专家类别代码表--自造)
46 zd_f_language(语种代码表--GB4880)
47 zd_family_by（家庭出身代码表――GB4765）
48 zd_finance_source(出国经费来源代码表--GB/T_14946_A28)
49 zd_fl_level(外语程度代码表--GB6865)
50zd_goabroad_cause(出国目的代码表--GB/10301_P92-91)
51zd_grade_detl (职位分类代码表--GB/T_14946-94_A6)
52 zd_hbsag( HBSAg类型字典)
53 zd_health_code(健康状况代码表--GB4767-84_P92-23)
54 zd_ic_card_type（购卡记录表）
55 zd_icd_code (疾病分类ICD－9--GB/T14396)
56 zd_identity_code(个人身份代码表--GB/T_14946_A1)
57 zd_ifcadre(干工标识代码表--自造)
58 zd_inout_type (流动类别代码表)
59 zd_insurance_code(保险公司字典)
60 zd_leave_reason(流动原因代码表--GB/T_14946-94_A16)
61 zd_marital_status (婚姻状态编码--GB4766)
62 zd_nation_code(民族码--GB3304-91_P92-4)
63 zd_occupation_code(职业码--GB6565-86_P92-98)
64 zd_oversea_code(港澳台侨胞代码表--GB/T_14946_A2)
65zd_pa_unusualtype政治面貌异常类别代码表--GB/T_149466-94_A)
66 zd_party_code(政治面貌代码表--GB4762-84_P92-17)
67 zd_patient_status(病人状态字典)
68 zd_pay_rank(享受待遇级别代码表)
69 zd_po_cause(任职原因代码表--GB/T_14946-94_A5)
70zd_po_changetype(职务变动类别代码表--GB/T_14946-94_A7)
71zd_po_currstatus(当前任职状态代码表--GB/T_14946-94_A8)
72 zd_po_discause(免职原因代码表--GB/T_14946-94_A10)
73 zd_po_disflag(免职标志代码表---自造)
74 zd_po_distype (免职方式代码表--GB/T_14946-94_A9)
75 zd_po_style(任职方式代码表--GB/T_14946_A4)
76zd_po_type(职务类别代码表--GB/T_14949-94)
77 zd_prof_code(专业代码表--P90-274)
78 zd_prof_type(专业类别代码表--医院内使用)
79 zd_profession_code (从事专业字典)
80 zd_quality_level(案质量等级字典)
81zd_rehired(返聘情况代码表--自造)
82zd_relative_cod(亲属关系字典--GB4761)
83zd_reside_type(户口性质代码表--GB/T_14946-94)
84zd_responce_group(病人身份组字典)
85zd_responce_type(病人身份字典)
86zd_retired_code(离退类别代码表--自造)
87zd_sa_changecause(工资变动原因代码表--GB/T_14946-94_A32)
88zd_salary_section(工资部门类别编码字典)
89zd_salary_type(工资类别代码表--GB/T_14946-94)
90zd_school_code(学校代码表--P90-148 )
91zd_sex_code(性别码--GB2261-80_P92-1)
92zd_single_desease(单病种字典)
93zd_single_operat(单术种字典)
94zd_sp_chkcure(特殊检查与治疗字典)
95zd_statist_formula(统计科目计算公式)
96zd_statistics_subj(医疗统计科目字典)
97zd_study_style(学习形式代码表--GB/T_14946-94_A3)
98zd_train_level(教育培训程度代码表--自造)
99zd_train_style(教育培训结果代码表--GB/T_140946-94_A27)
100zd_train_type(学习方式代码表--GB/T_14946-94_A25)
101zd_train_type(教育培训性质代码表--GB/T_14946-94_A24)
102zd_unit_code(部门编码字典)
103zd_unit_flag(部门分类字典)
104zd_vip_code(特殊病人分类码)
105zd_visit_type(访问类别码)
106zd_worker_title(工人技术等级代码表--GB/T_14946-94_A13)
中国医院信息系统—表结构(CHIS5.0)
第 0 页
内部资料
不得转借
中国医院信息系统
表结构(CHIS5.0)
中国医院信息系统—表结构(CHIS5.0)
第 1 页
摘要：
目录页号
本文档提供下列业务的描述：
1． PUBLIC（公共）--------------------------------------------2
2． GH（挂号）---------------------------------------------------2
3． MZ（门诊）---------------------------------------------------3
4． RT（报表）----------------------------------------------------3
5． WH（维护）-----------------------------------------------------4
6． YP（药品）----------------------------------------------------4
7． ZY（住院）----------------------------------------------------5
8． YZ（医嘱）----------------------------------------------------6
9． XT（系统）----------------------------------------------------6
10． ZD（字典）---------------------------------------------------7
摘要：......................................................................................................................................................... 1
目 录......................................................................................................................................................... 8
PUBLIC ...............................................................................................................................................8
GH....................................................................................................................................................... 8
MZ ....................................................................................................................................................... 9
RT........................................................................................................................................................ 9
WH.................................................................................................................................................... 10
YP......................................................................................................................................................10
ZY......................................................................................................................................................11
YZ......................................................................................................................................................12
XT......................................................................................................................................................12
ZD......................................................................................................................................................13
PUBLIC .....................................................................................................................................................16
1 a_daily_report(公共日报表)..........................................................................................................16
2 a_daily_report_data(日报数据表).................................................................................................16
3 a_daily_report_receipt(日报发票表).............................................................................................16
4 a_daily_report_receipt_flag(前台结帐发票标记)........................................................................ 17
5 a_daily_report_receipt_type(前台结帐发票类型)........................................................................17
6 a_employee_mi(职工主索引)....................................................................................................... 17
7 a_hospital (医院属性表)................................................................................................................18
GH............................................................................................................................................................. 18
1 gh_base_request(门诊基础号表).................................................................................................. 18
2 gh_base_request_segment(门诊号基础分配定义).......................................................................19
3 gh_config (门诊挂号定义表)........................................................................................................19
4 gh_deposit(现金流水账)................................................................................................................19
5 gh_detail_charge(费用明细)..........................................................................................................20
6 gh_doctor_out(医生出诊)..............................................................................................................20
7 gh_op_receipt(挂号员发票号定义表)..........................................................................................20
8 gh_receipt(发票)............................................................................................................................ 21
9 gh_receipt_charge(发票账单明细)............................................................................................... 21
中国医院信息系统—表结构(CHIS5.0)
第 2 页
10 gh_record(挂号记录)...................................................................................................................21
11 gh_request() 挂号表....................................................................................................................22
12 gh_zd_clinic_charge (号别字典费用项目明细)........................................................................ 23
13 gh_zd_clinic_type(号别字典)..................................................................................................... 23
14 gh_zd_request_charge/b(号类费用字典)....................................................................................24
gh_zd_request_type(号类字典)........................................................................................24
15
16
gh_zd_window_no(挂号窗口号字典)............................................................................. 24
gh_zd_work_time(医生工作时间)...................................................................................25
17
MZ ............................................................................................................................................................. 25
1 mz_bill_item(帐单码)....................................................................................................................25
2 mz_charge_device (门诊收费设备)..............................................................................................26
3 mz_charge_pattern(门诊收费模板).............................................................................................. 26
4 mz_charge_patern_define(门诊收费模板明细)........................................................................... 26
5 mz_config（门诊收费定义表）...................................................................................................27
6 mz_deposit/b(现金帐)....................................................................................................................27
7 mz_detail_charge/b(门诊收费明细表)......................................................................................... 28
8 mz_detail_charge_back（门诊退费明细表）..............................................................................30
9 mz_dg_orders(门诊诊断处方模板)..............................................................................................30
10 mz_dg_orders_detail（门诊诊断处方模板明细） ....................................................................31
11 mz_dg_record（门诊诊断处方记录表） ...................................................................................31
12 mz_dg_templates（门诊诊断体温记录表） ............................................................................. 31
13 mz_dg_templates_ orders（门诊诊断体温记录表）................................................................ 32
14 mz_op_receipt(收费员发票号定义表)....................................................................................... 32
15 mz_order_generator(序号发生器表).......................................................................................... 32
16 mz_order_put
(处方分配定义).................................................................................................33
17 mz_patient_mi /b(门诊病人主索引)...........................................................................................33
18 mz_receipt/b(发票表).................................................................................................................. 34
19 mz_receipt_charge/b(发票明细表)............................................................................................. 35
20 mz_visit_table(门诊病人就诊记录表)....................................................................................... 35
21 mz_zd_haoming(号名字典)—门诊[查号类型].........................................................................36
22 mz_zd_order_type(处方分配/类型定义)....................................................................................37
RT(report)..................................................................................................................................................37
1 rt_composit_report（复合报表表)................................................................................................37
2 rt_report_data（报表数据） .........................................................................................................38
3 rt_report_params（报表参数表）................................................................................................ 38
4 rt_report_subsys（报表从属关系表）.........................................................................................38
WH.............................................................................................................................................................39
1 wh_dict_cover (字典维护界面表)................................................................................................ 39
2 wh_dict_field(字典字段信息表)...................................................................................................39
3 wh_field_struc(库中表字段结构信息).........................................................................................39
4 wh_index_struc(库中表索引结构信息)....................................................................................... 40
5 wh_subsys_dict(子系统可维护字典表)....................................................................................... 40
6 wh_table_struc(库中表列表).........................................................................................................40
7 wh_tag_sql(TAG_SQL 对照表).................................................................................................... 40
中国医院信息系统—表结构(CHIS5.0)
第 3 页
8 wh_temp_filter(临时过滤条件表过滤窗口用)............................................................................ 41
9 wh_trans_define_file(传输定义文件)...........................................................................................41
10 wh_trans_sql_params(传输 SQL 语句参数).............................................................................. 41
11 wh_trans_table_list(传输定义中表列表)....................................................................................41
12 wh_trans_transed_record(传输日志).......................................................................................... 42
YP.............................................................................................................................................................. 42
1 yp_base（药品库存明细表）.......................................................................................................42
2 yp_class(药品/药性分类表).......................................................................................................... 43
3 yp_configures(药品系统管理配置表)..........................................................................................43
4 yp_convert_unit(药品单位转换率表)...........................................................................................43
5 yp_dict（药品属性表）................................................................................................................44
6 yp_dosage(药品剂型表)................................................................................................................45
7 yp_draw_pagetype(药单)...............................................................................................................45
8 yp_drug_type（药品类型表） ..................................................................................................... 45
9 yp_drugname（药品名称表）......................................................................................................46
10 yp_group_name(药品管理分组表).............................................................................................46
11 yp_in_detl(药品入库明细表)......................................................................................................46
12 yp_in_out_type(药品入出库类型表)..........................................................................................47
13 yp_in_plan(药品入库计划表).....................................................................................................47
14 yp_infusion(药品大输液余量表)................................................................................................48
15 yp_manufacture(药品生产厂商表).............................................................................................48
16 yp_out_detl(药品科室出库明细表)............................................................................................49
17 yp_out_patient(药品病人出库明细表).......................................................................................50
18 yp_report(药品报表)....................................................................................................................50
19 yp_reprice(药品调价记录表)......................................................................................................51
20 yp_reprice_stock(药品调价时库存表)....................................................................................... 51
21 yp_supplyer(药品供应商表)....................................................................................................... 52
22 yp_unit(药品包装单位表)...........................................................................................................52
23 yp_zd_reajlicense(药品调价字典)..............................................................................................52
ZY..............................................................................................................................................................53
1 a_patient_mi (zy_patient_mi 住院病人主索引)...........................................................................53
2 zy_actpatient(在院病人表)............................................................................................................54
3 zy_adt(转科记录表)...................................................................................................................... 55
4 zy_adtward(病房定义表).............................................................................................................. 55
5 zy_audit_item(收费项目分类字典)..............................................................................................56
6 zy_bed_charge(床位收费字典).....................................................................................................56
7 zy_bed_mi(床位字典)................................................................................................................... 56
8 zy_bed_status (床位状态字典表)................................................................................................. 57
9 zy_bed_type(床位类型字典表).....................................................................................................57
10 zy_bill_item (住院帐单码字典)..................................................................................................58
11 zy_charge_input_list(住院处收费模板内容表)......................................................................... 59
12 zy_charge_input_model(住院处收费模板定义表).................................................................... 59
13 zy_configure(住院子系统系统参数表)......................................................................................59
14 zy_deposit_file (病人交款记录表)............................................................................................. 59
中国医院信息系统—表结构(CHIS5.0)
第 4 页
15 zy_detail_charge/b/c (病人细目帐).............................................................................................60
16 zy_actpatient(出院病人表)..........................................................................................................61
17 zy_patient_total_charge()—崭无用.............................................................................................62
18 zy_pay_unit（住院分摊单位字典）..........................................................................................62
19 zy_receipt(病人收据记录表)...................................................................................................... 63
20 zy_receipt_cancel(住院收据废票记录表)..................................................................................63
21 zy_receipt_charge（病人收据费用记录表）............................................................................ 63
22 zy_receipt_no(住院收据号记录表)............................................................................................ 64
23 zy_register(预约单记录表)......................................................................................................... 64
24 zy_responce_bill_percent(帐单分摊比例字典)..........................................................................65
25 zy_responce_charge_percent(项目分摊比例字典).................................................................... 66
26 zy_responce_total_percent(总费用分摊比例字典)....................................................................66
27 zy_detail_charge_order (医技录入项目).................................................................................... 66
YZ..............................................................................................................................................................67
1 yz_act_order(在院病人医嘱表).................................................................................................... 67
2 yz_add_occ(嘱托医嘱—非收费医嘱)..........................................................................................68
3 yz_configure(医嘱配置表)............................................................................................................69
4 yz_exclusive(排斥组定义表)........................................................................................................ 70
5 yz_exclusive_order(组排斥医嘱)..................................................................................................70
6 yz_frequency(医嘱频率字典)....................................................................................................... 70
7 yz_frequency_time(医嘱频率时间表)..........................................................................................70
8 yz_op_time(手术时间表).............................................................................................................. 71
9 yz_order_charge ( 医嘱收费字典)............................................................................................... 71
10 yz_order_item(医嘱字典)............................................................................................................71
11 yz_order_print(医嘱打印表)....................................................................................................... 71
12 yz_order_type(医嘱类型表)........................................................................................................72
13 yz_pattern(成组医嘱定义表)...................................................................................................... 72
14 yz_pattern_order(成组医嘱内容表)............................................................................................72
15 yz_supply(给药方式字典)...........................................................................................................73
16 yz_supply_charge(给药方式收费字典)......................................................................................74
17 yz_supply_class (给药方式分类 )............................................................................................74
18 yz_temperature(病人体温脉搏记录)..........................................................................................74
XT(system) ................................................................................................................................................75
1 xt_func(系统功能定义表).............................................................................................................75
2 xt_group(系统用户组定义表).......................................................................................................76
3 xt_subsys(子系统定义表)............................................................................................................. 76
4 xt_user(系统用户定义表)............................................................................................................. 76
5 xt_user_group(用户组--功能定义表)........................................................................................... 77
6 xt_user_interface(各系统界面表)................................................................................................. 77
ZD(dict) ..................................................................................................................................................... 77
1 zd_academy_degree(学位代码表 GB6864)..................................................................................77
2 zd_admiss_status(入院状态字典--统计要用!) .............................................................................78
3 zd_admiss_type(就诊类型字典)................................................................................................... 79
4 zd_agent_type(单位性质代码表--自造).......................................................................................79
中国医院信息系统—表结构(CHIS5.0)
第 5 页
5 zd_anaesthesia(麻醉方法字典).....................................................................................................79
6 zd_army_rank(军衔代码--GB/T_14946-94_A35)........................................................................80
7 zd_award_cause(奖惩原因代码表－－B/T_14946-94_A23)......................................................81
8 zd_award_code(荣誉奖励处分代码表--GB8563+GB8560+GB85)............................................82
9 zd_award_punish(奖惩类别代码表--GB/T_14946-94_A20)...................................................... 85
10 zd_blood_type(血型字典)........................................................................................................... 85
11 zd_cadre_dsource(干部来源细类――自造)..............................................................................86
12 zd_cadre_source(干部来源代码表――GB/T_14946-94_A15)................................................ 86
13 zd_charge_class(项目分类字典).................................................................................................87
14 zd_charge_flag_group(收费项目分组字典)...............................................................................87
15 zd_charge_flag_type(费用标志与类型对应表)......................................................................... 88
16 zd_charge_group (收费项目分组字典)...................................................................................... 88
17 zd_charge_item(收费项目字典――诊疗)................................................................................. 88
18 zd_charge_item_child(收费项目子字典)................................................................................... 89
19 zd_charge_percent_type(收费比例类型)....................................................................................90
zd_charge_type(费别类型)—门诊收费中[费别]........................................................... 90
20
21
zd_cheque_type(票据类型)--门诊收费中[付款类型]....................................................90
22
zd_classtatus_code(本人成份代码表--GB4764).............................................................91
23 zd_cm3 ( 手术名称字典)........................................................................................................... 92
24 zd_contract_code(合同单位字典)...............................................................................................93
25 zd_contract_type(合同单位类别字典)....................................................................................... 93
26 zd_country_code（国家名称字典――GB26599）.................................................................. 94
27 zd_cut_heal_grade(切口等级//愈合类别字典).......................................................................... 94
28 zd_deposit_status(交款状态字典).............................................................................................. 95
29 zd_dept_code(门诊业务部门代码).............................................................................................95
30 zd_detail_status(病人费用明细状态字典).................................................................................96
31 zd_diag_conform(诊断符合标志字典).......................................................................................96
32 zd_dis_diag_status(出院转归字典)............................................................................................ 96
33 zd_dis_diag_type(出院诊断类别)...............................................................................................97
34 zd_dischar_status(出院去向字典).............................................................................................. 97
35 zd_dispose_reason(离职原因代码表--自造)..............................................................................98
36 zd_district_code(地区码--GB2260)............................................................................................ 98
37 zd_duration_code(用工期限代码表--自造)............................................................................... 99
38 zd_education_code(文化程度代码表--GB4658)........................................................................99
39 zd_emp_grade(行政级别代码表--GB12407)...........................................................................100
40 zd_emp_inmark(职工在院标志代码表--自造)........................................................................ 101
41 zd_emp_position(行政职务代码表--GB12403).......................................................................101
42 zd_emp_title（技术职称代码表(GB8561).............................................................................. 102
43 zd_equip_name 设备名称字典(WZB01-90)............................................................................ 102
44 zd_expert_treat (专家享受待遇代码表--自造)........................................................................ 103
45 zd_expert_type(专家类别代码表--自造)................................................................................. 103
46 zd_f_language(语种代码表--GB4880)..................................................................................... 103
47 zd_family_by（家庭出身代码表――GB4765）....................................................................104
48 zd_finance_source(出国经费来源代码表--GB/T_14946_A28)..............................................105
中国医院信息系统—表结构(CHIS5.0)
第 6 页
49 zd_fl_level(外语程度代码表--GB6865)...................................................................................105
50zd_goabroad_cause(出国目的代码表--GB/10301_P92-91)..................................................... 106
51zd_grade_detl (职位分类代码表--GB/T_14946-94_A6)..........................................................107
52 zd_hbsag( HBSAg 类型字典)................................................................................................... 107
53 zd_health_code(健康状况代码表--GB4767-84_P92-23)........................................................ 107
54 zd_ic_card_type（购卡记录表） ............................................................................................. 108
55 zd_icd_code (疾病分类 ICD－9--GB/T14396)........................................................................109
56 zd_identity_code(个人身份代码表--GB/T_14946_A1).......................................................... 109
57 zd_ifcadre(干工标识代码表--自造)......................................................................................... 110
58 zd_inout_type (流动类别代码表)............................................................................................. 110
59 zd_insurance_code(保险公司字典)...........................................................................................111
60 zd_leave_reason(流动原因代码表--GB/T_14946-94_A16).................................................... 111
61 zd_marital_status (婚姻状态编码--GB4766)............................................................................111
62 zd_nation_code(民族码--GB3304-91_P92-4).......................................................................... 112
63 zd_occupation_code(职业码--GB6565-86_P92-98).................................................................114
64 zd_oversea_code(港澳台侨胞代码表--GB/T_14946_A2)...................................................... 115
65zd_pa_unusualtype 政治面貌异常类别代码表--GB/T_149466-94_A) ...................................115
66 zd_party_code(政治面貌代码表--GB4762-84_P92-17).......................................................... 116
67 zd_patient_status(病人状态字典)............................................................................................. 116
68 zd_pay_rank(享受待遇级别代码表)........................................................................................ 117
69 zd_po_cause(任职原因代码表--GB/T_14946-94_A5)............................................................ 117
70zd_po_changetype(职务变动类别代码表--GB/T_14946-94_A7)............................................118
71zd_po_currstatus(当前任职状态代码表--GB/T_14946-94_A8).............................................118
72 zd_po_discause(免职原因代码表--GB/T_14946-94_A10)..................................................... 118
73 zd_po_disflag(免职标志代码表---自造).................................................................................. 119
74 zd_po_distype (免职方式代码表--GB/T_14946-94_A9)........................................................ 119
75 zd_po_style(任职方式代码表--GB/T_14946_A4)...................................................................119
76zd_po_type(职务类别代码表--GB/T_14949-94)......................................................................120
77 zd_prof_code(专业代码表--P90-274).......................................................................................120
78 zd_prof_type(专业类别代码表--医院内使用).........................................................................121
79 zd_profession_code (从事专业字典)........................................................................................121
80 zd_quality_level(案质量等级字典).......................................................................................... 122
81zd_rehired(返聘情况代码表--自造).......................................................................................... 122
82zd_relative_cod(亲属关系字典--GB4761)................................................................................122
83zd_reside_type(户口性质代码表--GB/T_14946-94)................................................................ 123
84zd_responce_group(病人身份组字典).......................................................................................123
85zd_responce_type(病人身份字典)............................................................................................. 124
86zd_retired_code(离退类别代码表--自造)................................................................................. 124
87zd_sa_changecause(工资变动原因代码表--GB/T_14946-94_A32)........................................ 125
88zd_salary_section(工资部门类别编码字典)............................................................................. 125
89zd_salary_type(工资类别代码表--GB/T_14946-94)................................................................ 126
90zd_school_code(学校代码表--P90-148 )...................................................................................126
91zd_sex_code(性别码--GB2261-80_P92-1)................................................................................127
92zd_single_desease(单病种字典)................................................................................................ 127
中国医院信息系统—表结构(CHIS5.0)
第 7 页
93zd_single_operat(单术种字典)...................................................................................................127
94zd_sp_chkcure(特殊检查与治疗字典)......................................................................................128
95zd_statist_formula(统计科目计算公式).................................................................................... 128
96zd_statistics_subj(医疗统计科目字典)......................................................................................129
97zd_study_style(学习形式代码表--GB/T_14946-94_A3)..........................................................129
98zd_train_level(教育培训程度代码表--自造)............................................................................ 130
99zd_train_style(教育培训结果代码表--GB/T_140946-94_A27)...............................................130
100zd_train_type(学习方式代码表--GB/T_14946-94_A25)........................................................130
101zd_train_type(教育培训性质代码表--GB/T_14946-94_A24)............................................... 131
102zd_unit_code(部门编码字典).................................................................................................. 131
103zd_unit_flag(部门分类字典)....................................................................................................132
104zd_vip_code(特殊病人分类码)................................................................................................132
105zd_visit_type(访问类别码)...................................................................................................... 132
106zd_worker_title(工人技术等级代码表--GB/T_14946-94_A13)............................................ 133
相关推荐
2023年江西萍乡中考道德与法治真题及答案.doc
2012年重庆南川中考生物真题及答案.doc
2013年江西师范大学地理学综合及文艺理论基础考研真题.doc
2020年四川甘孜小升初语文真题及答案I卷.doc
2020年注册岩土工程师专业基础考试真题及答案.doc
2023-2024学年福建省厦门市九年级上学期数学月考试题及答案.doc
2021-2022学年辽宁省沈阳市大东区九年级上学期语文期末试题及答案.doc
2022-2023学年北京东城区初三第一学期物理期末试卷及答案.doc
2018上半年江西教师资格初中地理学科知识与教学能力真题及答案.doc
2012年河北国家公务员申论考试真题及答案-省级.doc
2020-2021学年江苏省扬州市江都区邵樊片九年级上学期数学第一次质量检测试题及答案.doc
2022下半年黑龙江教师资格证中学综合素质真题及答案.doc
