| SQL Id | SQL Text |
|---|
| 019b2bj8mnpcn |
SELECT "Tbl1005"."ID" "Col1088", "Tbl1005"."TIMES" "Col1089", "Tbl1005"."NAME" "Col1090", "Tbl1005"."FB" "Col1091", "Tbl1005"."MARRYCODE" "Col1092", "Tbl1005"."OCCUPATIONCODE" "Col1093", "Tbl1005"."DWNAME" "Col1094", "Tbl1005"."DWADDR" "Col1095", "Tbl1005"."DWTELE" "Col1096", "Tbl1005"."DWPOST" "Col1097", "Tbl1005"."HKADD" "Col1098", "Tbl1005"."HKPOST" "Col1099", "Tbl1005"."LXNAME" "Col1100", "Tbl1005"."RELATIVECODE" "Col1101", "Tbl1005"."LXTELE" "Col1102", "Tbl1005"."LXADDR" "Col1103", "Tbl1005"."RYDATE" "Col1104", "Tbl1005"."RYINFO" "Col1105", "Tbl1005"."SOURCE" "Col1106", "Tbl1005"."INKBCODE" "Col1107", "Tbl1005"."INKSCODE" "Col1108", "Tbl1005"."OUTKSCODE" "Col1109", "Tbl1005"."OUTKBCODE" "Col1110", "Tbl1005"."CYDATE" "Col1111", "Tbl1005"."DAYS" &
quot;Col1112", "Tbl1005"."MZICDCODE" "Col1113", "Tbl1005"."MZICDVER" "Col1114", "Tbl1005"."RYICDVER" "Col1115", "Tbl1005"."BLICDCODE" "Col1116", "Tbl1005"."BLOODCODE" "Col1117", "Tbl1005"."ZREMPCODE" "Col1118", "Tbl1005"."ZZEMPCODE" "Col1119", "Tbl1005"."ZYEMPCODE" "Col1120", "Tbl1005"."PHONE" "Col1121", "Tbl1005"."INSERTTIME" "Col1122" FROM "HYHIS"."VIEW_SF_OH_SICKINHOSPITAL_MTH" "Tbl1005" WHERE "Tbl1005"."CYDATE">:1 AND "Tbl1005"."CYDATE"<:2 |
| 028htzxdty0nh |
SELECT qc.ID,
qc.FILEID,
qc.INPATIENT_NO, --住院流水号
qc.NAME, --患者姓名
qc.DEPT_CODE, --科室编码
re.COURSE_DATE, --病程日期
re.COURSE_TIME, --病程时间
re.MEMO, --查房医师
re.COURSE_TYPE, --病程记录类型ID、
re.COURSE_NAME, --病历类型名称
qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名）
qc.CREATEDATE, --建立时间
qc.CREATEOPER_CODE, --建立人
qc.SAVEDATE, --签名日期
qc.SAVEOPER_CODE, --签名操作员
qc.SEALDATE, --封存日期
qc.SEALOPER_CODE, --封存人
qc.DELETEDATE, --删除日期
qc.DELETEOPER_CODE, --删除人
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名
INTERN_SAVEDATE, --实习生签名日期
INTERN_SAVEOPER_CODE, --实习生签名操作员
SUPER_SAVEDATE, --主治签名日期
SUPER_SAVEOPER_CODE, --上级签名操作员
SENIOR_SAVEDATE, --主任签名日期
SENIOR_SAVEOPER_CODE, --主任签名操作员
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名
re.EMR_NAME, --病历名称
re.SORTID --排序号
FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY020000142113'
AND RE.ID = QC.ID
AND STATE <> 3
ORDER BY RE.COURSE_DATE,
to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'),
RE.SORTID |
| 04jffc18tjxxh | SELECT distinct T.INPATIENT_NO as 住院流水号, T.PATIENT_NO as 住院号, T.NAME as 姓名, DECODE(T.SEX_CODE, 'M', '男', 'F', '女', 'U', '未知', '其他') as 性别, fun_get_age_new(T.birthday, T.IN_DATE) as 年龄, T.IN_DATE AS 入院日期, T.Out_Date AS 出院日期, T.house_doc_name AS 住院医师, T.charge_doc_name AS 主治医师, T.chief_doc_name AS 主任医师, T.Dept_Name as 所在科室 , (select new_data_name from com_shiftdata where com_shiftdata.clinic_no = T.Inpatient_No and com_shiftdata.shift_type='B' and rownum =1) as 入院科室, (select m.diag_name from met_cas_diagnose m where m.inpatient_no = T.Inpatient_No and m.diag_kind = '1' and rownum=1) as 出院诊断 from FIN_IPR_INMAININFO T WHERE (T.INPATIENT_NO like '%00723087' or T.PATIENT_NO like '%00723087') and T.INPATIENT_NO not in (select INPATIENT_NO from fin_ipr_babyinfo where inpatient_no like '%00723087' and cancel_flag = '1') and T.INPATIENT_NO not in (select INPATIENT_NO from fin_ipr_babyinfo where inpatient_no like '%00723087' and cancel_flag = '1') |
| 04xtrk7uyhknh | select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null |
| 0h6b2sajwb74n | select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| 0hfq79bujc3zj | BEGIN
LBACSYS.lbac_events.logon(dbms_standard.login_user);
END; |
| 0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
| 0kugqg48477gf | select distinct(-privilege#), nvl(option$, 0) from sysauth$ where grantee#=:1 and privilege#<0 |
| 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME') |
| 0xwby571mq3n2 | select name, password, datats#, tempts#, type#, defrole, resource$, ptime, exptime, ltime, astatus, lcount, decode(defschclass, NULL, 'DEFAULT_CONSUMER_GROUP', defschclass), spare1 from user$ where user#=:1 |
| 1c1wqh5p6dk7r |
SELECT qc.ID,
qc.FILEID,
qc.INPATIENT_NO, --住院流水号
qc.NAME, --患者姓名
qc.DEPT_CODE, --科室编码
re.COURSE_DATE, --病程日期
re.COURSE_TIME, --病程时间
re.MEMO, --查房医师
re.COURSE_TYPE, --病程记录类型ID、
re.COURSE_NAME, --病历类型名称
qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名）
qc.CREATEDATE, --建立时间
qc.CREATEOPER_CODE, --建立人
qc.SAVEDATE, --签名日期
qc.SAVEOPER_CODE, --签名操作员
qc.SEALDATE, --封存日期
qc.SEALOPER_CODE, --封存人
qc.DELETEDATE, --删除日期
qc.DELETEOPER_CODE, --删除人
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名
INTERN_SAVEDATE, --实习生签名日期
INTERN_SAVEOPER_CODE, --实习生签名操作员
SUPER_SAVEDATE, --主治签名日期
SUPER_SAVEOPER_CODE, --上级签名操作员
SENIOR_SAVEDATE, --主任签名日期
SENIOR_SAVEOPER_CODE, --主任签名操作员
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名
re.EMR_NAME, --病历名称
re.SORTID --排序号
FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY010000227731'
AND RE.ID = QC.ID
AND STATE <> 3
ORDER BY RE.COURSE_DATE,
to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'),
RE.SORTID |
| 1mxs8cp3ax62v |
SELECT control_value --控制参数值
FROM com_controlargument --控制参数表
WHERE control_code = 'EPR231'
|
| 210d6mfbwchjq | INSERT INTO EMR_COM_LOGO (ID, TYPE, EMRNAME, EMRTYPE, NODENAME, OLDVALUE, NEWVALUE, MEMO, OPER_CODE, OPER_DATE, FILEID, INDEX1, INDEX2, NODEFULLPATH) VALUES (SEQ_EMR_COM_LOGO.NEXTVAL, '2', :B1 , :B2 , :B3 , '', :B4 , '病历修改', :B5 , SYSDATE, :B6 , :B7 , :B8 , :B9 ) |
| 2h2r9w5mf998d |
SELECT qc.ID,
qc.FILEID,
qc.INPATIENT_NO, --住院流水号
qc.NAME, --患者姓名
qc.DEPT_CODE, --科室编码
re.COURSE_DATE, --病程日期
re.COURSE_TIME, --病程时间
re.MEMO, --查房医师
re.COURSE_TYPE, --病程记录类型ID、
re.COURSE_NAME, --病历类型名称
qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名）
qc.CREATEDATE, --建立时间
qc.CREATEOPER_CODE, --建立人
qc.SAVEDATE, --签名日期
qc.SAVEOPER_CODE, --签名操作员
qc.SEALDATE, --封存日期
qc.SEALOPER_CODE, --封存人
qc.DELETEDATE, --删除日期
qc.DELETEOPER_CODE, --删除人
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名
INTERN_SAVEDATE, --实习生签名日期
INTERN_SAVEOPER_CODE, --实习生签名操作员
SUPER_SAVEDATE, --主治签名日期
SUPER_SAVEOPER_CODE, --上级签名操作员
SENIOR_SAVEDATE, --主任签名日期
SENIOR_SAVEOPER_CODE, --主任签名操作员
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名
re.EMR_NAME, --病历名称
re.SORTID --排序号
FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY030000189906'
AND RE.ID = QC.ID
AND STATE <> 3
ORDER BY RE.COURSE_DATE,
to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'),
RE.SORTID |
| 2syvqzbxp4k9z | select u.name, o.name, a.interface_version#, o.obj# from association$ a, user$ u, obj$ o where a.obj# = :1 and a.property = :2 and a.statstype# = o.obj# and u.user# = o.owner# |
| 2xyb5d6xg9srh | select a.default_cpu_cost, a.default_io_cost from association$ a where a.obj# = :1 and a.property = :2 |
| 2ym6hhaq30r73 | select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3 |
| 30ux4wagk29hv |
select * from (
select
(case
when a.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类药品', '2', '乙类药品', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b where a.drug_code = b.his_code and b.pact_code = '12'), '自费')
---when a.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类项目', '2', '乙类项目', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b where a.drug_code = b.his_code and b.pact_code = '12'), '自费')
when a.si_confirm_flag = '1' then
case
---when a.si_confirm_type = '1' then '甲类项目'
---when a.si_confirm_type = '2' then '乙类项目'
when a.si_confirm_type = '1' then '甲类药品'
when a.si_confirm_type = '2' then '乙类药品'
else '自费'
end
end ) as grade,
(case
when a.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '5', '2', '6', '3', '7', '4', '2', '5', '3', '6', '4', '7', '1', '7') from fin_com_compare b where a.drug_code = b.his_code and b.pact_code = '12'), '7')
---when a.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类项目', '2', '乙类项目', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b whe
re a.drug_code = b.his_code and b.pact_code = '12'), '自费')
when a.si_confirm_flag = '1' then
case
---when a.si_confirm_type = '1' then '甲类项目'
---when a.si_confirm_type = '2' then '乙类项目'
when a.si_confirm_type = '1' then '5'
when a.si_confirm_type = '2' then '6'
else '7'
end
end ) as orderNo,
c.name,
h.gb_code as item_code,
a.drug_name as item_name,
a.specs, --规格
a.qty, --数量
a.current_unit, -- 当前单位
a.unit_price, -- 单价
0 as limit_price,
a.tot_cost, -- 计价金额
a.fee_date, --计费时间
d.empl_name, --操作员
a.si_confirm_flag,
a.si_confirm_type
from fin_ipb_medicinelist a , com_dictionary c, com_employee d , pha_com_baseinfo h
where a.fee_code = c.code
and a.drug_code = h.drug_code
and a.fee_opercode = d.empl_code
and c.type = 'MINFEE'
and a.inpatient_no = 'ZY080000188504'
union all
select
(case
when e.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类药品', '2', '乙类药品', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b where e.item_code = b
.his_code and b.pact_code = '12'), '自费')
----when e.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类项目', '2', '乙类项目', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b where e.item_code = b.his_code and b.pact_code = '12'), '自费')
when e.si_confirm_flag = '1' then
case
---when e.si_confirm_type = '1' then '甲类项目'
---when e.si_confirm_type = '2' then '乙类项目'
when e.si_confirm_type = '1' then '甲类药品'
when e.si_confirm_type = '2' then '乙类药品'
else '自费'
end
end ) as grade,
(case
when e.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '5', '2', '6', '3', '7', '4', '2', '5', '3', '6', '4', '7', '1', '7') from fin_com_compare b where e.item_code = b.his_code and b.pact_code = '12'), '7')
----when e.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类项目', '2', '乙类项目', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b where e.item_code = b.his_code and b.pact_code = '12'), '自费')
when e.si_confirm_flag = '1' then
case
---when e.si_confirm_type = '1' then '甲类项目'
---when e.si_confirm_type = '2' then '乙类项目'
when e.si_conf
irm_type = '1' then '5'
when e.si_confirm_type = '2' then '6'
else '7'
end
end ) as orderNo,
c.name, --最小费用
g.gb_code, --国家编码
e.item_name,
g.specs,
e.qty,
e.current_unit,
e.unit_price,
nvl((select i.limit_price
from fin_com_undruginfolocal i where e.item_code = i.item_code and e.pact_code = i.pact_code), 0) as limit_price,
e.tot_cost,
e.fee_date,
d.empl_name,
e.si_confirm_flag,
e.si_confirm_type
from fin_ipb_itemlist e, com_dictionary c, com_employee d, fin_com_undruginfo g
where e.item_code = g.item_code
and e.fee_code = c.code
and e.fee_opercode = d.empl_code
and c.type = 'MINFEE'
and e.inpatient_no = 'ZY080000188504'
) f
where
f.fee_date >= to_date('2013-1-7 16:45:43', 'yyyy-mm-dd hh24:mi:ss')
and f.fee_date <= to_date('2013-1-25 0:00:00', 'yyyy-mm-dd hh24:mi:ss')
and f.grade like '自费' and f.name like '%%'
order by f.orderNo, f.Grade, f.name, f.item_code
|
| 34vcs7graur16 |
SELECT drug_flag,
sys_class,
fee_code,
item_code,
item_name,
en_name,
pack_qty,
specs,
dose_code,
spell_code,
wb_code,
user_code,
cus_name,
cus_spell_code,
cus_wb_code,
cus_user_code,
unit_price,
child_price,
sp_price,
pack_unit,
min_unit,
now_store,
exe_dept,
gf_flag,
usage_code,
freq_code,
dose_unit,
shenxz,
shixz,
zf,
needbespeak,
base_dose,
CONFIRM_FLAG,
split_type,
LACK_FLAG,
special_check,
once_dose,
other_name,
other_spell,
default_sample,
unitflag
FROM view_cli_itemlist
where (dept_code = '6206'
OR dept_code = 'undrug') and item_code = '983'
|
| 36rddx9a7zpwu |
SELECT control_value --控制参数值
FROM com_controlargument --控制参数表
WHERE control_code = 'EPR201'
|
| 3smr6z8wr12mp |
SELECT qc.ID,
qc.FILEID,
qc.INPATIENT_NO, --住院流水号
qc.NAME, --患者姓名
qc.DEPT_CODE, --科室编码
re.COURSE_DATE, --病程日期
re.COURSE_TIME, --病程时间
re.MEMO, --查房医师
re.COURSE_TYPE, --病程记录类型ID、
re.COURSE_NAME, --病历类型名称
qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名）
qc.CREATEDATE, --建立时间
qc.CREATEOPER_CODE, --建立人
qc.SAVEDATE, --签名日期
qc.SAVEOPER_CODE, --签名操作员
qc.SEALDATE, --封存日期
qc.SEALOPER_CODE, --封存人
qc.DELETEDATE, --删除日期
qc.DELETEOPER_CODE, --删除人
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名
INTERN_SAVEDATE, --实习生签名日期
INTERN_SAVEOPER_CODE, --实习生签名操作员
SUPER_SAVEDATE, --主治签名日期
SUPER_SAVEOPER_CODE, --上级签名操作员
SENIOR_SAVEDATE, --主任签名日期
SENIOR_SAVEOPER_CODE, --主任签名操作员
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名
re.EMR_NAME, --病历名称
re.SORTID --排序号
FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY010000227302'
AND RE.ID = QC.ID
AND STATE <> 3
ORDER BY RE.COURSE_DATE,
to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'),
RE.SORTID |
| 3tzvassftmh7x |
SELECT qc.ID,
qc.FILEID,
qc.INPATIENT_NO, --住院流水号
qc.NAME, --患者姓名
qc.DEPT_CODE, --科室编码
re.COURSE_DATE, --病程日期
re.COURSE_TIME, --病程时间
re.MEMO, --查房医师
re.COURSE_TYPE, --病程记录类型ID、
re.COURSE_NAME, --病历类型名称
qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名）
qc.CREATEDATE, --建立时间
qc.CREATEOPER_CODE, --建立人
qc.SAVEDATE, --签名日期
qc.SAVEOPER_CODE, --签名操作员
qc.SEALDATE, --封存日期
qc.SEALOPER_CODE, --封存人
qc.DELETEDATE, --删除日期
qc.DELETEOPER_CODE, --删除人
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名
INTERN_SAVEDATE, --实习生签名日期
INTERN_SAVEOPER_CODE, --实习生签名操作员
SUPER_SAVEDATE, --主治签名日期
SUPER_SAVEOPER_CODE, --上级签名操作员
SENIOR_SAVEDATE, --主任签名日期
SENIOR_SAVEOPER_CODE, --主任签名操作员
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名
re.EMR_NAME, --病历名称
re.SORTID --排序号
FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY020000227081'
AND RE.ID = QC.ID
AND STATE <> 3
ORDER BY RE.COURSE_DATE,
to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'),
RE.SORTID |
| 3uy5ms8fdxhws |
SELECT clinic_code, --门诊号/发票号
card_no, --就诊卡号
reg_date, --挂号日期
noon_code, --午别
name, --姓名
idenno, --身份证号
sex_code, --性别
birthday, --出生日
paykind_code, --结算类别号
paykind_name, --结算类别名称
pact_code, --合同号
pact_name, --合同单位名称
mcard_no, --医疗证号
reglevl_code, --挂号级别
reglevl_name, --挂号级别名称
dept_code, --科室号
dept_name, --科室名称
seeno, --看诊序号
doct_code, --医师代号
doct_name, --医师姓名
ynbook, --是否预约
ynfr, --1初诊/2复诊
reg_fee, --挂号费
chck_fee, --检查费
diag_fee, --诊察费
oth_fee, --附加费
own_cost, --自费金额
pub_cost, --报销金额
pay_cost, --自付金额
valid_flag, --退号标志
oper_code, --操作员代码
ynsee, --是否看诊
oper_date, --退号时间
trans_type, --交易类型
balance_flag, --日结标志
balance_no, --日结序号
balance_opcd, --日结人
balance_date, --日结时间
rela_phone, --联系电话
address, --地址
ynregchrg, --是否收费
cancel_opcd, --作废人
cancel_date, --作废时间
card_type, --证件类型
begin_time, --开始时间
end_time, --结束时间
see_date, --看诊日期
triage_flag, --分诊标志
triage_opcd, --分诊人
triage_date, --分诊时间
invoice_no, --发票号
recipe_no, --处方号
append_flag, --加急标志
order_no,
schema_no,
in_source,
in_state, --R-留观登记 I-留观接诊 O-留观结束 N-非留观
in
_date, --开始留观日期
out_date, --留观结束日期
zg, --转归代号
(select bed_no
from com_bedinfo
where clinic_no = fin_opr_register.clinic_code) as bed_no, --留观床号
is_account,
see_dpcd, --看诊科室
see_docd, --看诊医生
Is_Emergency,
mark1,
ECO_COST,
work_home_id,
work_home_name
FROM fin_opr_register WHERE see_docd='001818'
AND see_date>=to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss')
AND see_date<=to_date('2013-1-25 20:27:33', 'yyyy-mm-dd HH24:mi:ss')
AND valid_flag='1'
AND ynsee='1'
order by ynbook desc
|
| 47v42kh87xkaa |
SELECT drug_flag,
sys_class,
fee_code,
item_code,
item_name,
en_name,
pack_qty,
specs,
dose_code,
spell_code,
wb_code,
user_code,
cus_name,
cus_spell_code,
cus_wb_code,
cus_user_code,
unit_price,
child_price,
sp_price,
pack_unit,
min_unit,
now_store,
exe_dept,
gf_flag,
usage_code,
freq_code,
dose_unit,
shenxz,
shixz,
zf,
needbespeak,
base_dose,
CONFIRM_FLAG,
split_type,
LACK_FLAG,
special_check,
once_dose,
other_name,
other_spell,
default_sample,
unitflag
FROM view_cli_itemlist
where (dept_code = '6206'
OR dept_code = 'undrug') and item_code = 'F00000009035'
|
| 4m7m0t6fjcs5x | update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1 |
| 4yppnn3m81nb9 | select
r.APPLY_no
from met_ord_recipedetail r
where r.recipe_no='4170674' and r.recipe_seq='2' |
| 582ky10xu220f |
select * from (
select
(case
when a.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类药品', '2', '乙类药品', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b where a.drug_code = b.his_code and b.pact_code = '27'), '自费')
---when a.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类项目', '2', '乙类项目', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b where a.drug_code = b.his_code and b.pact_code = '27'), '自费')
when a.si_confirm_flag = '1' then
case
---when a.si_confirm_type = '1' then '甲类项目'
---when a.si_confirm_type = '2' then '乙类项目'
when a.si_confirm_type = '1' then '甲类药品'
when a.si_confirm_type = '2' then '乙类药品'
else '自费'
end
end ) as grade,
(case
when a.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '5', '2', '6', '3', '7', '4', '2', '5', '3', '6', '4', '7', '1', '7') from fin_com_compare b where a.drug_code = b.his_code and b.pact_code = '27'), '7')
---when a.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类项目', '2', '乙类项目', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b whe
re a.drug_code = b.his_code and b.pact_code = '27'), '自费')
when a.si_confirm_flag = '1' then
case
---when a.si_confirm_type = '1' then '甲类项目'
---when a.si_confirm_type = '2' then '乙类项目'
when a.si_confirm_type = '1' then '5'
when a.si_confirm_type = '2' then '6'
else '7'
end
end ) as orderNo,
c.name,
h.gb_code as item_code,
a.drug_name as item_name,
a.specs, --规格
a.qty, --数量
a.current_unit, -- 当前单位
a.unit_price, -- 单价
0 as limit_price,
a.tot_cost, -- 计价金额
a.fee_date, --计费时间
d.empl_name, --操作员
a.si_confirm_flag,
a.si_confirm_type
from fin_ipb_medicinelist a , com_dictionary c, com_employee d , pha_com_baseinfo h
where a.fee_code = c.code
and a.drug_code = h.drug_code
and a.fee_opercode = d.empl_code
and c.type = 'MINFEE'
and a.inpatient_no = 'ZY010000227887'
union all
select
(case
when e.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类药品', '2', '乙类药品', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b where e.item_code = b
.his_code and b.pact_code = '27'), '自费')
----when e.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类项目', '2', '乙类项目', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b where e.item_code = b.his_code and b.pact_code = '27'), '自费')
when e.si_confirm_flag = '1' then
case
---when e.si_confirm_type = '1' then '甲类项目'
---when e.si_confirm_type = '2' then '乙类项目'
when e.si_confirm_type = '1' then '甲类药品'
when e.si_confirm_type = '2' then '乙类药品'
else '自费'
end
end ) as grade,
(case
when e.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '5', '2', '6', '3', '7', '4', '2', '5', '3', '6', '4', '7', '1', '7') from fin_com_compare b where e.item_code = b.his_code and b.pact_code = '27'), '7')
----when e.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类项目', '2', '乙类项目', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b where e.item_code = b.his_code and b.pact_code = '27'), '自费')
when e.si_confirm_flag = '1' then
case
---when e.si_confirm_type = '1' then '甲类项目'
---when e.si_confirm_type = '2' then '乙类项目'
when e.si_conf
irm_type = '1' then '5'
when e.si_confirm_type = '2' then '6'
else '7'
end
end ) as orderNo,
c.name, --最小费用
g.gb_code, --国家编码
e.item_name,
g.specs,
e.qty,
e.current_unit,
e.unit_price,
nvl((select i.limit_price
from fin_com_undruginfolocal i where e.item_code = i.item_code and e.pact_code = i.pact_code), 0) as limit_price,
e.tot_cost,
e.fee_date,
d.empl_name,
e.si_confirm_flag,
e.si_confirm_type
from fin_ipb_itemlist e, com_dictionary c, com_employee d, fin_com_undruginfo g
where e.item_code = g.item_code
and e.fee_code = c.code
and e.fee_opercode = d.empl_code
and c.type = 'MINFEE'
and e.inpatient_no = 'ZY010000227887'
) f
where
f.fee_date >= to_date('2013-1-21 16:17:34', 'yyyy-mm-dd hh24:mi:ss')
and f.fee_date <= to_date('2013-1-25 0:00:00', 'yyyy-mm-dd hh24:mi:ss')
and f.grade like '自费' and f.name like '%%'
order by f.orderNo, f.Grade, f.name, f.item_code
|
| 5aqn2f1rdhuum |
SELECT control_value --控制参数值
FROM com_controlargument --控制参数表
WHERE control_code = 'EPR444'
|
| 5f4rxd5rk1qfd | select hyhis.Interface_Patient_Mi.*, hyhis.Interface_Patient_Mi."ROWID" from hyhis.Interface_Patient_Mi |
| 5w1dmuc76qhw8 | SELECT "Tbl1005"."BAH" "Col1049", "Tbl1005"."XM" "Col1050", "Tbl1005"."XB" "Col1051", "Tbl1005"."CSRQ" "Col1052", "Tbl1005"."SFZHM" "Col1053", "Tbl1005"."PHONE" "Col1054", "Tbl1005"."JLYG" "Col1055", "Tbl1005"."JLSJ" "Col1056", "Tbl1005"."TJFL1" "Col1057" FROM "HYHIS"."VIEW_SF_MZ_MZBR" "Tbl1005" |
| 6r75f7k88qr4a | select pol#, db_labels, default_format from lbac$pol |
| 6vngrbb2p57jt | SELECT * FROM HYHIS.V_HIS_patientcheck where creation_date> sysdate-1/12 |
| 74k26h9umur73 |
SELECT empl_code,
(select b.empl_name from com_employee b where a.empl_code=b.empl_code),
(select c.dept_name from com_department c, com_employee b where a.empl_code=b.empl_code and b.dept_code=c.dept_code),
orderpermission,
emrpermission,
qcpermission,
orderbegindate,
orderenddate,
oper_code,
oper_date
FROM met_com_userpermisssion a
where
empl_code ='001523'
|
| 75ww7j0qz9v4b |
SELECT qc.ID,
qc.FILEID,
qc.INPATIENT_NO, --住院流水号
qc.NAME, --患者姓名
qc.DEPT_CODE, --科室编码
re.COURSE_DATE, --病程日期
re.COURSE_TIME, --病程时间
re.MEMO, --查房医师
re.COURSE_TYPE, --病程记录类型ID、
re.COURSE_NAME, --病历类型名称
qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名）
qc.CREATEDATE, --建立时间
qc.CREATEOPER_CODE, --建立人
qc.SAVEDATE, --签名日期
qc.SAVEOPER_CODE, --签名操作员
qc.SEALDATE, --封存日期
qc.SEALOPER_CODE, --封存人
qc.DELETEDATE, --删除日期
qc.DELETEOPER_CODE, --删除人
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名
INTERN_SAVEDATE, --实习生签名日期
INTERN_SAVEOPER_CODE, --实习生签名操作员
SUPER_SAVEDATE, --主治签名日期
SUPER_SAVEOPER_CODE, --上级签名操作员
SENIOR_SAVEDATE, --主任签名日期
SENIOR_SAVEOPER_CODE, --主任签名操作员
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名
re.EMR_NAME, --病历名称
re.SORTID --排序号
FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY050000150319'
AND RE.ID = QC.ID
AND STATE <> 3
ORDER BY RE.COURSE_DATE,
to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'),
RE.SORTID |
| 7bn1gchhc5ftw |
SELECT drug_flag,
sys_class,
fee_code,
item_code,
item_name,
en_name,
pack_qty,
specs,
dose_code,
spell_code,
wb_code,
user_code,
cus_name,
cus_spell_code,
cus_wb_code,
cus_user_code,
unit_price,
child_price,
sp_price,
pack_unit,
min_unit,
now_store,
exe_dept,
gf_flag,
usage_code,
freq_code,
dose_unit,
shenxz,
shixz,
zf,
needbespeak,
base_dose,
CONFIRM_FLAG,
split_type,
LACK_FLAG,
special_check,
once_dose,
other_name,
other_spell,
default_sample,
unitflag
FROM view_cli_itemlist
where (dept_code = '6206'
OR dept_code = 'undrug') and item_code = '3960'
|
| 7h35uxf5uhmm1 | select sysdate from dual |
| 7ng34ruy5awxq | select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj# |
| 85xf8t3cjdypf |
SELECT drug_flag,
sys_class,
fee_code,
item_code,
item_name,
en_name,
pack_qty,
specs,
dose_code,
spell_code,
wb_code,
user_code,
cus_name,
cus_spell_code,
cus_wb_code,
cus_user_code,
unit_price,
child_price,
sp_price,
pack_unit,
min_unit,
now_store,
exe_dept,
gf_flag,
usage_code,
freq_code,
dose_unit,
shenxz,
shixz,
zf,
needbespeak,
base_dose,
CONFIRM_FLAG,
split_type,
LACK_FLAG,
special_check,
once_dose,
other_name,
other_spell,
default_sample,
unitflag
FROM view_cli_itemlist
where (dept_code = '6206'
OR dept_code = 'undrug') and item_code = 'F00000007296'
|
| 89qyn4bbt03jq | SELECT /*+ USE_HASH(f a) */ SUM(NVL(F.BYTES - NVL(A.BYTES, 0), 0)/1024/1024), SUM(NVL(F.BYTES, 0)/1024/1024) FROM (SELECT DISTINCT TABLESPACE_NAME FROM USER_TABLES) U, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME) F, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) A WHERE A.TABLESPACE_NAME = U.TABLESPACE_NAME AND F.TABLESPACE_NAME = U.TABLESPACE_NAME |
| 8rmrujpk902h6 |
SELECT drug_flag,
sys_class,
fee_code,
item_code,
item_name,
en_name,
pack_qty,
specs,
dose_code,
spell_code,
wb_code,
user_code,
cus_name,
cus_spell_code,
cus_wb_code,
cus_user_code,
unit_price,
child_price,
sp_price,
pack_unit,
min_unit,
now_store,
exe_dept,
gf_flag,
usage_code,
freq_code,
dose_unit,
shenxz,
shixz,
zf,
needbespeak,
base_dose,
CONFIRM_FLAG,
split_type,
LACK_FLAG,
special_check,
once_dose,
other_name,
other_spell,
default_sample,
unitflag
FROM view_cli_itemlist
where (dept_code = '6206'
OR dept_code = 'undrug') and item_code = 'F00000008971'
|
| 979m6fy3hp8v1 | SELECT "Tbl1005"."ID" "Col1048", "Tbl1005"."DISTRICTCODE" "Col1049", "Tbl1005"."NATIONCODE" "Col1050", "Tbl1005"."SEXCODE" "Col1051", "Tbl1005"."COUNTRYCODE" "Col1052", "Tbl1005"."NAME" "Col1053", "Tbl1005"."BIRTHDAY" "Col1054", "Tbl1005"."IDCARD" "Col1055", "Tbl1005"."PHONE" "Col1056", "Tbl1005"."DEATH" "Col1057" FROM "HYHIS"."VIEW_SF_OH_SICKBASE" "Tbl1005" |
| 97qqqfspx1zy7 | SELECT distinct T.INPATIENT_NO as 住院流水号, T.PATIENT_NO as 住院号, T.NAME as 姓名, DECODE(T.SEX_CODE, 'M', '男', 'F', '女', 'U', '未知', '其他') as 性别, fun_get_age_new(T.birthday, T.IN_DATE) as 年龄, T.IN_DATE AS 入院日期, T.Out_Date AS 出院日期, T.house_doc_name AS 住院医师, T.charge_doc_name AS 主治医师, T.chief_doc_name AS 主任医师, T.Dept_Name as 所在科室 , (select new_data_name from com_shiftdata where com_shiftdata.clinic_no = T.Inpatient_No and com_shiftdata.shift_type='B' and rownum =1) as 入院科室, (select m.diag_name from met_cas_diagnose m where m.inpatient_no = T.Inpatient_No and m.diag_kind = '1' and rownum=1) as 出院诊断 from FIN_IPR_INMAININFO T WHERE (T.INPATIENT_NO like '%00123087' or T.PATIENT_NO like '%00123087') and T.INPATIENT_NO not in (select INPATIENT_NO from fin_ipr_babyinfo where inpatient_no like '%00123087' and cancel_flag = '1') and T.INPATIENT_NO not in (select INPATIENT_NO from fin_ipr_babyinfo where inpatient_no like '%00123087' and cancel_flag = '1') |
| 9b7n7jcdmy0td | select a.recipe_no, a.sequence_no from fin_ipb_itemlist a where a.mo_order = '14852660' and a.package_code = 'F00000007453' |
| 9c3njkxsd6yc5 |
SELECT qc.ID,
qc.FILEID,
qc.INPATIENT_NO, --住院流水号
qc.NAME, --患者姓名
qc.DEPT_CODE, --科室编码
re.COURSE_DATE, --病程日期
re.COURSE_TIME, --病程时间
re.MEMO, --查房医师
re.COURSE_TYPE, --病程记录类型ID、
re.COURSE_NAME, --病历类型名称
qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名）
qc.CREATEDATE, --建立时间
qc.CREATEOPER_CODE, --建立人
qc.SAVEDATE, --签名日期
qc.SAVEOPER_CODE, --签名操作员
qc.SEALDATE, --封存日期
qc.SEALOPER_CODE, --封存人
qc.DELETEDATE, --删除日期
qc.DELETEOPER_CODE, --删除人
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名
INTERN_SAVEDATE, --实习生签名日期
INTERN_SAVEOPER_CODE, --实习生签名操作员
SUPER_SAVEDATE, --主治签名日期
SUPER_SAVEOPER_CODE, --上级签名操作员
SENIOR_SAVEDATE, --主任签名日期
SENIOR_SAVEOPER_CODE, --主任签名操作员
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名
re.EMR_NAME, --病历名称
re.SORTID --排序号
FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY010000227621'
AND RE.ID = QC.ID
AND STATE <> 3
ORDER BY RE.COURSE_DATE,
to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'),
RE.SORTID |
| 9d41ughy3r7yr |
SELECT drug_flag,
sys_class,
fee_code,
item_code,
item_name,
en_name,
pack_qty,
specs,
dose_code,
spell_code,
wb_code,
user_code,
cus_name,
cus_spell_code,
cus_wb_code,
cus_user_code,
unit_price,
child_price,
sp_price,
pack_unit,
min_unit,
now_store,
exe_dept,
gf_flag,
usage_code,
freq_code,
dose_unit,
shenxz,
shixz,
zf,
needbespeak,
base_dose,
CONFIRM_FLAG,
split_type,
LACK_FLAG,
special_check,
once_dose,
other_name,
other_spell,
default_sample,
unitflag
FROM view_cli_itemlist
where (dept_code = '6206'
OR dept_code = 'undrug') and item_code = '992'
|
| 9h03z34zshb0f |
SELECT qc.ID,
qc.FILEID,
qc.INPATIENT_NO, --住院流水号
qc.NAME, --患者姓名
qc.DEPT_CODE, --科室编码
re.COURSE_DATE, --病程日期
re.COURSE_TIME, --病程时间
re.MEMO, --查房医师
re.COURSE_TYPE, --病程记录类型ID、
re.COURSE_NAME, --病历类型名称
qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名）
qc.CREATEDATE, --建立时间
qc.CREATEOPER_CODE, --建立人
qc.SAVEDATE, --签名日期
qc.SAVEOPER_CODE, --签名操作员
qc.SEALDATE, --封存日期
qc.SEALOPER_CODE, --封存人
qc.DELETEDATE, --删除日期
qc.DELETEOPER_CODE, --删除人
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名
INTERN_SAVEDATE, --实习生签名日期
INTERN_SAVEOPER_CODE, --实习生签名操作员
SUPER_SAVEDATE, --主治签名日期
SUPER_SAVEOPER_CODE, --上级签名操作员
SENIOR_SAVEDATE, --主任签名日期
SENIOR_SAVEOPER_CODE, --主任签名操作员
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名
re.EMR_NAME, --病历名称
re.SORTID --排序号
FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY010000228038'
AND RE.ID = QC.ID
AND STATE <> 3
ORDER BY RE.COURSE_DATE,
to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'),
RE.SORTID |
| 9jaxv5a180bvg |
select * from (
select
(case
when a.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类药品', '2', '乙类药品', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b where a.drug_code = b.his_code and b.pact_code = '20'), '自费')
---when a.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类项目', '2', '乙类项目', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b where a.drug_code = b.his_code and b.pact_code = '20'), '自费')
when a.si_confirm_flag = '1' then
case
---when a.si_confirm_type = '1' then '甲类项目'
---when a.si_confirm_type = '2' then '乙类项目'
when a.si_confirm_type = '1' then '甲类药品'
when a.si_confirm_type = '2' then '乙类药品'
else '自费'
end
end ) as grade,
(case
when a.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '5', '2', '6', '3', '7', '4', '2', '5', '3', '6', '4', '7', '1', '7') from fin_com_compare b where a.drug_code = b.his_code and b.pact_code = '20'), '7')
---when a.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类项目', '2', '乙类项目', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b whe
re a.drug_code = b.his_code and b.pact_code = '20'), '自费')
when a.si_confirm_flag = '1' then
case
---when a.si_confirm_type = '1' then '甲类项目'
---when a.si_confirm_type = '2' then '乙类项目'
when a.si_confirm_type = '1' then '5'
when a.si_confirm_type = '2' then '6'
else '7'
end
end ) as orderNo,
c.name,
h.gb_code as item_code,
a.drug_name as item_name,
a.specs, --规格
a.qty, --数量
a.current_unit, -- 当前单位
a.unit_price, -- 单价
0 as limit_price,
a.tot_cost, -- 计价金额
a.fee_date, --计费时间
d.empl_name, --操作员
a.si_confirm_flag,
a.si_confirm_type
from fin_ipb_medicinelist a , com_dictionary c, com_employee d , pha_com_baseinfo h
where a.fee_code = c.code
and a.drug_code = h.drug_code
and a.fee_opercode = d.empl_code
and c.type = 'MINFEE'
and a.inpatient_no = 'ZY030000187880'
union all
select
(case
when e.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类药品', '2', '乙类药品', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b where e.item_code = b
.his_code and b.pact_code = '20'), '自费')
----when e.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类项目', '2', '乙类项目', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b where e.item_code = b.his_code and b.pact_code = '20'), '自费')
when e.si_confirm_flag = '1' then
case
---when e.si_confirm_type = '1' then '甲类项目'
---when e.si_confirm_type = '2' then '乙类项目'
when e.si_confirm_type = '1' then '甲类药品'
when e.si_confirm_type = '2' then '乙类药品'
else '自费'
end
end ) as grade,
(case
when e.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '5', '2', '6', '3', '7', '4', '2', '5', '3', '6', '4', '7', '1', '7') from fin_com_compare b where e.item_code = b.his_code and b.pact_code = '20'), '7')
----when e.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类项目', '2', '乙类项目', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b where e.item_code = b.his_code and b.pact_code = '20'), '自费')
when e.si_confirm_flag = '1' then
case
---when e.si_confirm_type = '1' then '甲类项目'
---when e.si_confirm_type = '2' then '乙类项目'
when e.si_conf
irm_type = '1' then '5'
when e.si_confirm_type = '2' then '6'
else '7'
end
end ) as orderNo,
c.name, --最小费用
g.gb_code, --国家编码
e.item_name,
g.specs,
e.qty,
e.current_unit,
e.unit_price,
nvl((select i.limit_price
from fin_com_undruginfolocal i where e.item_code = i.item_code and e.pact_code = i.pact_code), 0) as limit_price,
e.tot_cost,
e.fee_date,
d.empl_name,
e.si_confirm_flag,
e.si_confirm_type
from fin_ipb_itemlist e, com_dictionary c, com_employee d, fin_com_undruginfo g
where e.item_code = g.item_code
and e.fee_code = c.code
and e.fee_opercode = d.empl_code
and c.type = 'MINFEE'
and e.inpatient_no = 'ZY030000187880'
) f
where
f.fee_date >= to_date('2013-1-22 11:46:17', 'yyyy-mm-dd hh24:mi:ss')
and f.fee_date <= to_date('2013-1-25 0:00:00', 'yyyy-mm-dd hh24:mi:ss')
and f.grade like '自费' and f.name like '%%'
order by f.orderNo, f.Grade, f.name, f.item_code
|
| 9pddx52tm3jjs |
SELECT qc.ID,
qc.FILEID,
qc.INPATIENT_NO, --住院流水号
qc.NAME, --患者姓名
qc.DEPT_CODE, --科室编码
re.COURSE_DATE, --病程日期
re.COURSE_TIME, --病程时间
re.MEMO, --查房医师
re.COURSE_TYPE, --病程记录类型ID、
re.COURSE_NAME, --病历类型名称
qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名）
qc.CREATEDATE, --建立时间
qc.CREATEOPER_CODE, --建立人
qc.SAVEDATE, --签名日期
qc.SAVEOPER_CODE, --签名操作员
qc.SEALDATE, --封存日期
qc.SEALOPER_CODE, --封存人
qc.DELETEDATE, --删除日期
qc.DELETEOPER_CODE, --删除人
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名
INTERN_SAVEDATE, --实习生签名日期
INTERN_SAVEOPER_CODE, --实习生签名操作员
SUPER_SAVEDATE, --主治签名日期
SUPER_SAVEOPER_CODE, --上级签名操作员
SENIOR_SAVEDATE, --主任签名日期
SENIOR_SAVEOPER_CODE, --主任签名操作员
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名
re.EMR_NAME, --病历名称
re.SORTID --排序号
FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY020000169571'
AND RE.ID = QC.ID
AND STATE <> 3
ORDER BY RE.COURSE_DATE,
to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'),
RE.SORTID |
| 9ptrsg5rz0qnb |
select distinct t.dept_code
from met_ipm_execundrug t, fin_ipr_inmaininfo f
where (t.exec_dpcd = 'all' or 'all' = 'all')
and t.exec_dpcd != t.dept_code
-- and t.dept_code = 'all'
and (t.exec_flag = '0' or
t.qty_tot > (select sum(nvl(m.confirm_number, 0))
from met_tec_inpatientconfirm m
where t.exec_sqn = m.exec_sqn
and t.mo_order = m.mo_order))
and t.VALID_FLAG = fun_get_valid
and t.inpatient_no = f.inpatient_no
and f.in_state = 'I'
|
| 9qdjr6atg7cf5 |
SELECT drug_flag,
sys_class,
fee_code,
item_code,
item_name,
en_name,
pack_qty,
specs,
dose_code,
spell_code,
wb_code,
user_code,
cus_name,
cus_spell_code,
cus_wb_code,
cus_user_code,
unit_price,
child_price,
sp_price,
pack_unit,
min_unit,
now_store,
exe_dept,
gf_flag,
usage_code,
freq_code,
dose_unit,
shenxz,
shixz,
zf,
needbespeak,
base_dose,
CONFIRM_FLAG,
split_type,
LACK_FLAG,
special_check,
once_dose,
other_name,
other_spell,
default_sample,
unitflag
FROM view_cli_itemlist
where (dept_code = '6206'
OR dept_code = 'undrug') and item_code = 'F00000009799'
|
| abu6jqqz40bh7 |
select HAPPEN_NO, SHIFT_TYPE, OLD_DATA_CODE, OLD_DATA_NAME, NEW_DATA_CODE, NEW_DATA_NAME, mark, SHIFT_CAUSE, OPER_CODE, OPER_Date from com_shiftdata
where clinic_no='ZY070000183801' order by oper_date |
| ansgd0s3pmf06 |
SELECT control_value --控制参数值
FROM com_controlargument --控制参数表
WHERE control_code = 'EPR234'
|
| azh44vdpcug2t |
SELECT drug_flag,
sys_class,
fee_code,
item_code,
item_name,
en_name,
pack_qty,
specs,
dose_code,
spell_code,
wb_code,
user_code,
cus_name,
cus_spell_code,
cus_wb_code,
cus_user_code,
unit_price,
child_price,
sp_price,
pack_unit,
min_unit,
now_store,
exe_dept,
gf_flag,
usage_code,
freq_code,
dose_unit,
shenxz,
shixz,
zf,
needbespeak,
base_dose,
CONFIRM_FLAG,
split_type,
LACK_FLAG,
special_check,
once_dose,
other_name,
other_spell,
default_sample,
unitflag
FROM view_cli_itemlist
where (dept_code = '6206'
OR dept_code = 'undrug') and item_code = 'F00000003127'
|
| b4ag9zjst5kwp |
SELECT qc.ID,
qc.FILEID,
qc.INPATIENT_NO, --住院流水号
qc.NAME, --患者姓名
qc.DEPT_CODE, --科室编码
re.COURSE_DATE, --病程日期
re.COURSE_TIME, --病程时间
re.MEMO, --查房医师
re.COURSE_TYPE, --病程记录类型ID、
re.COURSE_NAME, --病历类型名称
qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名）
qc.CREATEDATE, --建立时间
qc.CREATEOPER_CODE, --建立人
qc.SAVEDATE, --签名日期
qc.SAVEOPER_CODE, --签名操作员
qc.SEALDATE, --封存日期
qc.SEALOPER_CODE, --封存人
qc.DELETEDATE, --删除日期
qc.DELETEOPER_CODE, --删除人
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名
INTERN_SAVEDATE, --实习生签名日期
INTERN_SAVEOPER_CODE, --实习生签名操作员
SUPER_SAVEDATE, --主治签名日期
SUPER_SAVEOPER_CODE, --上级签名操作员
SENIOR_SAVEDATE, --主任签名日期
SENIOR_SAVEOPER_CODE, --主任签名操作员
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名
re.EMR_NAME, --病历名称
re.SORTID --排序号
FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY030000210729'
AND RE.ID = QC.ID
AND STATE <> 3
ORDER BY RE.COURSE_DATE,
to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'),
RE.SORTID |
| b506nt1b8agab |
SELECT drug_flag,
sys_class,
fee_code,
item_code,
item_name,
en_name,
pack_qty,
specs,
dose_code,
spell_code,
wb_code,
user_code,
cus_name,
cus_spell_code,
cus_wb_code,
cus_user_code,
unit_price,
child_price,
sp_price,
pack_unit,
min_unit,
now_store,
exe_dept,
gf_flag,
usage_code,
freq_code,
dose_unit,
shenxz,
shixz,
zf,
needbespeak,
base_dose,
CONFIRM_FLAG,
split_type,
LACK_FLAG,
special_check,
once_dose,
other_name,
other_spell,
default_sample,
unitflag
FROM view_cli_itemlist
where (dept_code = '6206'
OR dept_code = 'undrug') and item_code = 'F00000007295'
|
| brpvayyf0vz70 |
SELECT qc.ID,
qc.FILEID,
qc.INPATIENT_NO, --住院流水号
qc.NAME, --患者姓名
qc.DEPT_CODE, --科室编码
re.COURSE_DATE, --病程日期
re.COURSE_TIME, --病程时间
re.MEMO, --查房医师
re.COURSE_TYPE, --病程记录类型ID、
re.COURSE_NAME, --病历类型名称
qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名）
qc.CREATEDATE, --建立时间
qc.CREATEOPER_CODE, --建立人
qc.SAVEDATE, --签名日期
qc.SAVEOPER_CODE, --签名操作员
qc.SEALDATE, --封存日期
qc.SEALOPER_CODE, --封存人
qc.DELETEDATE, --删除日期
qc.DELETEOPER_CODE, --删除人
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名
INTERN_SAVEDATE, --实习生签名日期
INTERN_SAVEOPER_CODE, --实习生签名操作员
SUPER_SAVEDATE, --主治签名日期
SUPER_SAVEOPER_CODE, --上级签名操作员
SENIOR_SAVEDATE, --主任签名日期
SENIOR_SAVEOPER_CODE, --主任签名操作员
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名
re.EMR_NAME, --病历名称
re.SORTID --排序号
FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY040000131798'
AND RE.ID = QC.ID
AND STATE <> 3
ORDER BY RE.COURSE_DATE,
to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'),
RE.SORTID |
| bsu4js8s8m9hf |
SELECT drug_flag,
sys_class,
fee_code,
item_code,
item_name,
en_name,
pack_qty,
specs,
dose_code,
spell_code,
wb_code,
user_code,
cus_name,
cus_spell_code,
cus_wb_code,
cus_user_code,
unit_price,
child_price,
sp_price,
pack_unit,
min_unit,
now_store,
exe_dept,
gf_flag,
usage_code,
freq_code,
dose_unit,
shenxz,
shixz,
zf,
needbespeak,
base_dose,
CONFIRM_FLAG,
split_type,
LACK_FLAG,
special_check,
once_dose,
other_name,
other_spell,
default_sample,
unitflag
FROM view_cli_itemlist
where (dept_code = '6206'
OR dept_code = 'undrug') and item_code = '950'
|
| ctdzngdump3wa |
select * from (
select
(case
when a.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类药品', '2', '乙类药品', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b where a.drug_code = b.his_code and b.pact_code = '61'), '自费')
---when a.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类项目', '2', '乙类项目', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b where a.drug_code = b.his_code and b.pact_code = '61'), '自费')
when a.si_confirm_flag = '1' then
case
---when a.si_confirm_type = '1' then '甲类项目'
---when a.si_confirm_type = '2' then '乙类项目'
when a.si_confirm_type = '1' then '甲类药品'
when a.si_confirm_type = '2' then '乙类药品'
else '自费'
end
end ) as grade,
(case
when a.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '5', '2', '6', '3', '7', '4', '2', '5', '3', '6', '4', '7', '1', '7') from fin_com_compare b where a.drug_code = b.his_code and b.pact_code = '61'), '7')
---when a.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类项目', '2', '乙类项目', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b whe
re a.drug_code = b.his_code and b.pact_code = '61'), '自费')
when a.si_confirm_flag = '1' then
case
---when a.si_confirm_type = '1' then '甲类项目'
---when a.si_confirm_type = '2' then '乙类项目'
when a.si_confirm_type = '1' then '5'
when a.si_confirm_type = '2' then '6'
else '7'
end
end ) as orderNo,
c.name,
h.gb_code as item_code,
a.drug_name as item_name,
a.specs, --规格
a.qty, --数量
a.current_unit, -- 当前单位
a.unit_price, -- 单价
0 as limit_price,
a.tot_cost, -- 计价金额
a.fee_date, --计费时间
d.empl_name, --操作员
a.si_confirm_flag,
a.si_confirm_type
from fin_ipb_medicinelist a , com_dictionary c, com_employee d , pha_com_baseinfo h
where a.fee_code = c.code
and a.drug_code = h.drug_code
and a.fee_opercode = d.empl_code
and c.type = 'MINFEE'
and a.inpatient_no = 'ZY030000145527'
union all
select
(case
when e.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类药品', '2', '乙类药品', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b where e.item_code = b
.his_code and b.pact_code = '61'), '自费')
----when e.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类项目', '2', '乙类项目', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b where e.item_code = b.his_code and b.pact_code = '61'), '自费')
when e.si_confirm_flag = '1' then
case
---when e.si_confirm_type = '1' then '甲类项目'
---when e.si_confirm_type = '2' then '乙类项目'
when e.si_confirm_type = '1' then '甲类药品'
when e.si_confirm_type = '2' then '乙类药品'
else '自费'
end
end ) as grade,
(case
when e.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '5', '2', '6', '3', '7', '4', '2', '5', '3', '6', '4', '7', '1', '7') from fin_com_compare b where e.item_code = b.his_code and b.pact_code = '61'), '7')
----when e.si_confirm_flag = '0' then nvl((select decode(b.center_item_grade, '1', '甲类项目', '2', '乙类项目', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费') from fin_com_compare b where e.item_code = b.his_code and b.pact_code = '61'), '自费')
when e.si_confirm_flag = '1' then
case
---when e.si_confirm_type = '1' then '甲类项目'
---when e.si_confirm_type = '2' then '乙类项目'
when e.si_conf
irm_type = '1' then '5'
when e.si_confirm_type = '2' then '6'
else '7'
end
end ) as orderNo,
c.name, --最小费用
g.gb_code, --国家编码
e.item_name,
g.specs,
e.qty,
e.current_unit,
e.unit_price,
nvl((select i.limit_price
from fin_com_undruginfolocal i where e.item_code = i.item_code and e.pact_code = i.pact_code), 0) as limit_price,
e.tot_cost,
e.fee_date,
d.empl_name,
e.si_confirm_flag,
e.si_confirm_type
from fin_ipb_itemlist e, com_dictionary c, com_employee d, fin_com_undruginfo g
where e.item_code = g.item_code
and e.fee_code = c.code
and e.fee_opercode = d.empl_code
and c.type = 'MINFEE'
and e.inpatient_no = 'ZY030000145527'
) f
where
f.fee_date >= to_date('2013-1-16 10:32:14', 'yyyy-mm-dd hh24:mi:ss')
and f.fee_date <= to_date('2013-1-25 0:00:00', 'yyyy-mm-dd hh24:mi:ss')
and f.grade like '自费' and f.name like '%%'
order by f.orderNo, f.Grade, f.name, f.item_code
|
| d67z0b952pmj3 | insert into emr_courserecord t
(
t.data, --内容
t.id, --病程流水号
t.fileid, --病程文件号
t.inpatient_no, --患者流水号
t.name, --患者姓名
t.dept_code, --住院科室编码
t.memo, --查房医师姓名
t.course_type, --记录类型
t.course_name, --记录类型名称
t.doctor_name, --医师签名
t.oper_date, --操作时间
t.oper_code, --操作人员
t.course_date, --病程记录日期
t.course_time, --病程记录时间
t.emr_name, --病历名称
t.sortid, --排列顺序
t.IsStartNewPage
)
values(
:a,
'308334', --病程流水号
'0', --病程文件号
'ZY040000199102', --患者流水号
'沈能', --患者姓名
'0219', --住院科室编码
'', --查房医师姓名
'0001', --记录类型
'病程记录', --记录类型名称
'', --医师签名
sysdate,
'', --操作人员
to_Date('2013-01-23', 'yyyy-mm-dd'), --病程记录日期
'11:15', --病程记录时间
'病程记录', --病历名称
nvl((select max(sortid) + 1 from emr_courserecord y where y.fileid = '0'), 1), --排列顺序
'False'
) |
| d767j7nr3sukk |
SELECT qc.ID,
qc.FILEID,
qc.INPATIENT_NO, --住院流水号
qc.NAME, --患者姓名
qc.DEPT_CODE, --科室编码
re.COURSE_DATE, --病程日期
re.COURSE_TIME, --病程时间
re.MEMO, --查房医师
re.COURSE_TYPE, --病程记录类型ID、
re.COURSE_NAME, --病历类型名称
qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名）
qc.CREATEDATE, --建立时间
qc.CREATEOPER_CODE, --建立人
qc.SAVEDATE, --签名日期
qc.SAVEOPER_CODE, --签名操作员
qc.SEALDATE, --封存日期
qc.SEALOPER_CODE, --封存人
qc.DELETEDATE, --删除日期
qc.DELETEOPER_CODE, --删除人
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名
INTERN_SAVEDATE, --实习生签名日期
INTERN_SAVEOPER_CODE, --实习生签名操作员
SUPER_SAVEDATE, --主治签名日期
SUPER_SAVEOPER_CODE, --上级签名操作员
SENIOR_SAVEDATE, --主任签名日期
SENIOR_SAVEOPER_CODE, --主任签名操作员
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名
re.EMR_NAME, --病历名称
re.SORTID --排序号
FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY050000214029'
AND RE.ID = QC.ID
AND STATE <> 3
ORDER BY RE.COURSE_DATE,
to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'),
RE.SORTID |
| f0cd4708fxcmd | SELECT "Tbl1005"."ID" "Col1030", "Tbl1005"."TIMES" "Col1031", "Tbl1005"."SN" "Col1032", "Tbl1005"."DIAGNOSETYPE" "Col1033", "Tbl1005"."STATUSCODE" "Col1034", "Tbl1005"."ICDCODE" "Col1035", "Tbl1005"."ICDVER" "Col1036", "Tbl1005"."NAME" "Col1037", "Tbl1005"."ICDM" "Col1038" FROM "HYHIS"."VIEW_SF_OH_SICKDIAGNOSE" "Tbl1005" |
| f5w65za900wpa | SELECT a.EMPL_CODE, --0员工编码
a.EMPL_NAME, --1员工姓名
a.dept_code, --2医生站编码
a.dept_name, --3医生站名称
a.EMPL_TYPE, --4人员类型 D医生 N护士
a.manager_flag, --5管理员标志 1是 0否
a.nurse_dept_code, --6护士站编码
a.nurse_dept_name, --7护士站名称
a.spell_code, --8拼音码
a.wb_code, --9五笔
a.levl_code, --10职级代号
a.login_name, --11登录用户名
a.login_password, --12登录密码
a.levl_name --13职级名称
FROM VIEW_EMR_EMPLOYEE a
WHERE a.empl_type='D'
order by empl_code |
| fm2uhffc3vvu7 |
SELECT drug_flag,
sys_class,
fee_code,
item_code,
item_name,
en_name,
pack_qty,
specs,
dose_code,
spell_code,
wb_code,
user_code,
cus_name,
cus_spell_code,
cus_wb_code,
cus_user_code,
unit_price,
child_price,
sp_price,
pack_unit,
min_unit,
now_store,
exe_dept,
gf_flag,
usage_code,
freq_code,
dose_unit,
shenxz,
shixz,
zf,
needbespeak,
base_dose,
CONFIRM_FLAG,
split_type,
LACK_FLAG,
special_check,
once_dose,
other_name,
other_spell,
default_sample,
unitflag
FROM view_cli_itemlist
where (dept_code = '6206'
OR dept_code = 'undrug') and item_code = '955'
|
| fr5adcsknx0jc | insert into emr_courserecord t
(
t.data, --内容
t.id, --病程流水号
t.fileid, --病程文件号
t.inpatient_no, --患者流水号
t.name, --患者姓名
t.dept_code, --住院科室编码
t.memo, --查房医师姓名
t.course_type, --记录类型
t.course_name, --记录类型名称
t.doctor_name, --医师签名
t.oper_date, --操作时间
t.oper_code, --操作人员
t.course_date, --病程记录日期
t.course_time, --病程记录时间
t.emr_name, --病历名称
t.sortid, --排列顺序
t.IsStartNewPage
)
values(
:a,
'310319', --病程流水号
'0', --病程文件号
'ZY010000227676', --患者流水号
'杜李胜', --患者姓名
'0206', --住院科室编码
'胡志华', --查房医师姓名
'0003', --记录类型
'副主任医师查房', --记录类型名称
'', --医师签名
sysdate,
'', --操作人员
to_Date('2013-01-24', 'yyyy-mm-dd'), --病程记录日期
'09:39', --病程记录时间
'病程记录', --病历名称
nvl((select max(sortid) + 1 from emr_courserecord y where y.fileid = '0'), 1), --排列顺序
'False'
) |
| g01x8p1s2y9x7 |
SELECT qc.ID,
qc.FILEID,
qc.INPATIENT_NO, --住院流水号
qc.NAME, --患者姓名
qc.DEPT_CODE, --科室编码
re.COURSE_DATE, --病程日期
re.COURSE_TIME, --病程时间
re.MEMO, --查房医师
re.COURSE_TYPE, --病程记录类型ID、
re.COURSE_NAME, --病历类型名称
qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名）
qc.CREATEDATE, --建立时间
qc.CREATEOPER_CODE, --建立人
qc.SAVEDATE, --签名日期
qc.SAVEOPER_CODE, --签名操作员
qc.SEALDATE, --封存日期
qc.SEALOPER_CODE, --封存人
qc.DELETEDATE, --删除日期
qc.DELETEOPER_CODE, --删除人
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名
INTERN_SAVEDATE, --实习生签名日期
INTERN_SAVEOPER_CODE, --实习生签名操作员
SUPER_SAVEDATE, --主治签名日期
SUPER_SAVEOPER_CODE, --上级签名操作员
SENIOR_SAVEDATE, --主任签名日期
SENIOR_SAVEOPER_CODE, --主任签名操作员
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名
(SELECT EMPL_NAME
FROM COM_EMPLOYEE
WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名
(SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名
re.EMR_NAME, --病历名称
re.SORTID --排序号
FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY010000227676'
AND RE.ID = QC.ID
AND STATE <> 3
ORDER BY RE.COURSE_DATE,
to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'),
RE.SORTID |
| g1yx0c7rxnuvt | SELECT "Tbl1005"."ID" "Col1057", "Tbl1005"."TIMES" "Col1058", "Tbl1005"."SN" "Col1059", "Tbl1005"."ICD_ID" "Col1060", "Tbl1005"."DIAG_TJI" "Col1061", "Tbl1005"."DIAG_NAME" "Col1062", "Tbl1005"."STAT" "Col1063" FROM "HYHIS"."VIEW_SF_MZ_ZDDM" "Tbl1005" ORDER BY "Col1059" ASC |
| g37zzhdxz360u | Select sysdate from dual |
| gj50gqh7jrw3m | SELECT "Tbl1005"."ID" "Col1043", "Tbl1005"."TIMES" "Col1044", "Tbl1005"."SN" "Col1045", "Tbl1005"."OPERATIONCODE" "Col1046", "Tbl1005"."EMPID" "Col1047", "Tbl1005"."NAME" "Col1048", "Tbl1005"."OPDATE" "Col1049", "Tbl1005"."QIEKOU" "Col1050", "Tbl1005"."YUHE" "Col1051", "Tbl1005"."MAZUI" "Col1052" FROM "HYHIS"."VIEW_SF_OH_SICKOPERATION" "Tbl1005" |
| gvsd0rfmnpjgu |
SELECT drug_flag,
sys_class,
fee_code,
item_code,
item_name,
en_name,
pack_qty,
specs,
dose_code,
spell_code,
wb_code,
user_code,
cus_name,
cus_spell_code,
cus_wb_code,
cus_user_code,
unit_price,
child_price,
sp_price,
pack_unit,
min_unit,
now_store,
exe_dept,
gf_flag,
usage_code,
freq_code,
dose_unit,
shenxz,
shixz,
zf,
needbespeak,
base_dose,
CONFIRM_FLAG,
split_type,
LACK_FLAG,
special_check,
once_dose,
other_name,
other_spell,
default_sample,
unitflag
FROM view_cli_itemlist
where (dept_code = '6206'
OR dept_code = 'undrug') and item_code = 'F00000042408'
|