◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20200108004467','10402749','郭思淼','一般人员','廊坊居民',to_date('2020/1/8 10:41:13','yyyy/mm/dd hh24:mi:ss'),'257.38','257.38','GUO SI ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO drug_presc_master_temp (presc_date,presc_no,dispensary,PATIENT_ID,NAME,NAME_PHONETIC,IDENTITY,CHARGE_TYPE,PRESC_TYPE,PRESC_ATTR,PRESC_SOURCE,REPETITION,COSTS,PAYMENTS,ORDERED_BY,PRESCRIBED_BY,ENTERED_BY,DOCTOR_USER,RCPT_NO,COUNT_PER_REPETITION,CLINIC_NO,IS_SEND,SEND_WIN_NO) VALUES (to_date('2020/01/08 11:01:28','yyyy/mm/dd hh24:mi:ss'),'7744','050101','10402749','郭思淼','GUO SI MIAO','一般人员','廊坊居民','0','门诊处方','0','1','218.66','218.66','0304','XSJ','徐苏晋','XSJ','20200108004467','5','202001087450','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2020-01-08 11:01:28', 'yyyy-mm-dd hh24:mi:ss'),'7744','1','11303030680','100ml(双层无菌)','0.9%氯化钠注射液100ml','石家庄四药','100ml(双层无菌)','袋','1','5.46','5.46','100;ml;静脉输液;1/日','1','1','100','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2020-01-08 11:01:28', 'yyyy-mm-dd hh24:mi:ss'),'7744','2','10102019170','1g','注射用头孢曲松钠','陕西顿斯','1g','支','1','55.2','55.2','1;g;静脉输液;1/日','1','2','1','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2020-01-08 11:01:28', 'yyyy-mm-dd hh24:mi:ss'),'7744','3','11303035680','250ml(双层无菌)','5%葡萄糖注射液250ml','石家庄四药','250ml(双层无菌)','袋','1','5.7','5.7','140;ml;静脉输液;1/日','2','1','140','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2020-01-08 11:01:28', 'yyyy-mm-dd hh24:mi:ss'),'7744','4','10108005131','0.5g','[进]注射用阿奇霉素','辉瑞制药','0.5g','支','1','102.59','102.59','.135;g;静脉输液;1/日','3','1','0.135','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2020-01-08 11:01:28', 'yyyy-mm-dd hh24:mi:ss'),'7744','5','11403053380','20ml:200万iu','重组人干扰素α2b喷雾剂','天津未名','20ml:200万iu','瓶','1','49.71','49.71','1;ml;口腔喷雾;4/日','4','1','1','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2020/1/8 10:41:13','yyyy/mm/dd hh24:mi:ss'),'7765','10402749','1','门诊处方','0304','徐苏晋','20200108004467','202001087450') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:01:28','yyyy/mm/dd hh24:mi:ss'),'7765','20200108004467','1','A','11303030680','0.9%氯化钠注射液100ml','100ml(双层无菌)石家庄四药','1','袋','050101','5.46','5.46','0','1','A','032','200','1.0000','5.4600','1','100;ml;静脉输液;1/日','0','徐苏晋','0304','0','0.9%氯化钠注射液100ml','11303030680','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:01:28','yyyy/mm/dd hh24:mi:ss'),'7765','20200108004467','2','A','10102019170','注射用头孢曲松钠','1g陕西顿斯','1','支','050101','55.2','55.2','0','1','A','032','200','1.0000','55.2000','2','1;g;静脉输液;1/日','0','徐苏晋','0304','0','注射用头孢曲松钠','10102019170','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:01:28','yyyy/mm/dd hh24:mi:ss'),'7765','20200108004467','3','A','11303035680','5%葡萄糖注射液250ml','250ml(双层无菌)石家庄四药','1','袋','050101','5.7','5.7','0','1','A','032','200','1.0000','5.7000','3','140;ml;静脉输液;1/日','0','徐苏晋','0304','0','5%葡萄糖注射液250ml','11303035680','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:01:28','yyyy/mm/dd hh24:mi:ss'),'7765','20200108004467','4','A','10108005131','[进]注射用阿奇霉素','0.5g辉瑞制药','1','支','050101','102.59','102.59','0','1','A','032','200','1.0000','102.5900','4','.135;g;静脉输液;1/日','0','徐苏晋','0304','0','[进]注射用阿奇霉素','10108005131','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:01:28','yyyy/mm/dd hh24:mi:ss'),'7765','20200108004467','5','A','11403053380','重组人干扰素α2b喷雾剂','20ml:200万iu天津未名','1','瓶','050101','49.71','49.71','0','1','A','032','200','1.0000','49.7100','5','1;ml;口腔喷雾;4/日','0','徐苏晋','0304','0','重组人干扰素α2b喷雾剂','11403053380','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2020/1/8 10:41:13','yyyy/mm/dd hh24:mi:ss'),'7766','10402749','0','','0304','徐苏晋','20200108004467','202001087450') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:01:28','yyyy/mm/dd hh24:mi:ss'),'7766','20200108004467','1','E','E0003020','小儿头皮静脉输液','/','1','','0304','6','6','0','1','1.0000','6.0000','1','','0','徐苏晋','0304','0','小儿头皮静脉输液','10130','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:01:28','yyyy/mm/dd hh24:mi:ss'),'7766','20200108004467','2','E','C0000010','门急诊留观诊查费','/','1','','0304','8','8','0','1','1.0000','8.0000','2','','0','徐苏晋','0304','0','门急诊留观诊查费','10012','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:01:28','yyyy/mm/dd hh24:mi:ss'),'7766','20200108004467','3','E','E0003013','静脉输液(连续输液第二组起)','/','1','','0304','2','2','0','1','1.0000','2.0000','3','','0','徐苏晋','0304','0','静脉输液(连续输液第二组起)','10121','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:01:29','yyyy/mm/dd hh24:mi:ss'),'7766','20200108004467','4','J','I0006980','一次性使用无菌溶药注射器','20ml/威高','1','支','0304','0.87','0.87','0','1','1.0000','0.8700','4','','0','徐苏晋','0304','0','一次性使用无菌溶药注射器','I0006980','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:01:29','yyyy/mm/dd hh24:mi:ss'),'7766','20200108004467','5','J','I0004285','一次性使用静脉输液针','0.55*17.5RW/威高','1','个','0304','0.21','0.21','0','1','1.0000','0.2100','5','','0','徐苏晋','0304','0','一次性使用静脉输液针','I0004285','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:01:29','yyyy/mm/dd hh24:mi:ss'),'7766','20200108004467','6','J','0201220002','一次性使用无菌注射器 带针','5ml威高','2','支','0304','1','1','0','1','1.0000','0.5000','6','','0','徐苏晋','0304','0','一次性使用无菌注射器 带针','0201220002','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:01:29','yyyy/mm/dd hh24:mi:ss'),'7766','20200108004467','7','J','I0007056','一次性使用输液器(精密过滤输液器 带针)','0.55# ZPQ/威高','1','支','0304','17.64','17.64','0','1','1.0000','17.6400','7','','0','徐苏晋','0304','0','一次性使用输液器(精密过滤输液器 带针)','I0007056','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:01:29','yyyy/mm/dd hh24:mi:ss'),'7766','20200108004467','8','Z','B0000025','门急诊输液观察座位费','/','1','','0304','3','3','0','1','1.0000','3.0000','8','','0','徐苏晋','0304','0','门急诊输液观察座位费','10061','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200108004467','1','微信','257.38','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254380' and presc_no = '7744' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254380' and presc_no = '7744' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254380' and presc_no = '7744' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254380' and presc_no = '7744' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254380' and presc_no = '7744' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254382' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254382' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254382' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254382' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254382' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254382' and presc_no = '0' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254382' and presc_no = '0' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254382' and presc_no = '0' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254382' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254382' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254382' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254382' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254382' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254382' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254382' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254382' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254380' and order_class = 'A' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254380' and order_class = 'A' and order_no = '1' and order_sub_no = '2' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254380' and order_class = 'A' and order_no = '2' and order_sub_no = '1' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254380' and order_class = 'A' and order_no = '3' and order_sub_no = '1' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254380' and order_class = 'A' and order_no = '4' and order_sub_no = '1' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254382' and order_class = 'E' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254382' and order_class = 'E' and order_no = '2' and order_sub_no = '1' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254382' and order_class = 'E' and order_no = '3' and order_sub_no = '1' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254382' and order_class = 'J' and order_no = '4' and order_sub_no = '1' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254382' and order_class = 'J' and order_no = '5' and order_sub_no = '1' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254382' and order_class = 'J' and order_no = '6' and order_sub_no = '1' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254382' and order_class = 'J' and order_no = '7' and order_sub_no = '1' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:01:29 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254382' and order_class = 'Z' and order_no = '8' and order_sub_no = '1' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:02:02 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:02:02 记录内容:语句:UPDATE exam_appoints SET costs='309.76',charges='309.76',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:02:02 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10402749' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:02:02 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10402749' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:02:02 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10402749' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:02:02 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10402749') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句: INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20200108004563','100112075','王淑惠','一般人员','自费',to_date('2020/1/7 17:50:02','yyyy/mm/dd hh24:mi:ss'),'175.05','175.05','WANG SHU HUI ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句: INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2020/1/7 17:50:02','yyyy/mm/dd hh24:mi:ss'),'8199','100112075','0','','0315','邢小燕','20200108004563','202001073945') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:22:08','yyyy/mm/dd hh24:mi:ss'),'8199','20200108004563','1','C','H0201009','糖化血红蛋白测定(色谱法)','/','1','','0411','70','70','0','1','1.0000','70.0000','1','','0','邢小燕','0315','0','*糖化血红蛋白测定','21752','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句: INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2020/1/7 17:50:02','yyyy/mm/dd hh24:mi:ss'),'8200','100112075','0','','0315','邢小燕','20200108004563','202001073945') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:22:08','yyyy/mm/dd hh24:mi:ss'),'8200','20200108004563','1','C','H0001049','尿液分析','/','1','','0411','8','8','0','1','1.0000','8.0000','2','','0','邢小燕','0315','0','*尿常规+尿沉渣定量','JY000120','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:22:08','yyyy/mm/dd hh24:mi:ss'),'8200','20200108004563','2','C','H0001050','尿沉渣定量(流式细胞计数法)','/','1','','0411','25','25','0','1','1.0000','25.0000','2','','0','邢小燕','0315','0','*尿常规+尿沉渣定量','JY000120','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句: INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2020/1/7 17:50:02','yyyy/mm/dd hh24:mi:ss'),'8201','100112075','0','','0315','邢小燕','20200108004563','202001073945') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:22:08','yyyy/mm/dd hh24:mi:ss'),'8201','20200108004563','1','C','H0206014','尿微量白蛋白测定(各种免疫学方法)','/','1','','0411','15','15','0','1','1.0000','15.0000','3','','0','邢小燕','0315','0','*尿微量白蛋白/肌酐比值','JY000575','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:22:08','yyyy/mm/dd hh24:mi:ss'),'8201','20200108004563','2','C','H0206007','肌酐测定(酶促动力学法)','/','1','','0411','6','6','0','1','1.0000','6.0000','3','','0','邢小燕','0315','0','*尿微量白蛋白/肌酐比值','JY000575','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句: INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2020/1/7 17:50:02','yyyy/mm/dd hh24:mi:ss'),'8202','100112075','0','','0315','邢小燕','20200108004563','202001073945') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:22:08','yyyy/mm/dd hh24:mi:ss'),'8202','20200108004563','1','E','D0902084','眼底照相','/','1','','020102','15','15','0','1','1.0000','15.0000','5','','0','邢小燕','0315','0','眼底照相','10760','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句: INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2020/1/7 17:50:02','yyyy/mm/dd hh24:mi:ss'),'8203','100112075','0','','0315','邢小燕','20200108004563','202001073945') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:22:08','yyyy/mm/dd hh24:mi:ss'),'8203','20200108004563','1','D','D0900027','感觉阈值测量','/','1','','020102','30','30','0','1','1.0000','30.0000','6','','0','邢小燕','0315','0','*感觉阈值测量','JC001004','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句: INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2020/1/7 17:50:02','yyyy/mm/dd hh24:mi:ss'),'8204','100112075','0','','0315','邢小燕','20200108004563','202001073945') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:22:08','yyyy/mm/dd hh24:mi:ss'),'8204','20200108004563','1','E','E0003006','静脉采血','/','1','','0329','3','3','0','1','1.0000','3.0000','7','','0','邢小燕','0315','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:22:08','yyyy/mm/dd hh24:mi:ss'),'8204','20200108004563','2','E','I0000483','真空采血管','/','1','','0315','2','2','0','1','1.0000','2.0000','7','','0','邢小燕','0315','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:22:08','yyyy/mm/dd hh24:mi:ss'),'8204','20200108004563','3','E','I0000009','一次性使用静脉采血针(黑色)','/','1','','0315','1.05','1.05','0','1','1.0000','1.0500','7','','0','邢小燕','0315','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200108004563','1','微信','175.05','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254576' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254578' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254578' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254580' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254580' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254585' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254588' and presc_no = '0' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254592' and presc_no = '0' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254592' and presc_no = '0' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254592' and presc_no = '0' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254576' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254578' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254578' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254580' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254580' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254585' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254588' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254592' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254592' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254592' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254576' and order_class = 'C' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254578' and order_class = 'C' and order_no = '2' and order_sub_no = '1' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254578' and order_class = 'C' and order_no = '2' and order_sub_no = '1' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254580' and order_class = 'C' and order_no = '3' and order_sub_no = '1' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254580' and order_class = 'C' and order_no = '3' and order_sub_no = '1' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254585' and order_class = 'E' and order_no = '5' and order_sub_no = '1' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254588' and order_class = 'D' and order_no = '6' and order_sub_no = '1' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254592' and order_class = 'E' and order_no = '7' and order_sub_no = '1' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254592' and order_class = 'E' and order_no = '7' and order_sub_no = '1' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:08 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254592' and order_class = 'E' and order_no = '7' and order_sub_no = '1' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:16 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:23 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:22:54 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:23:01 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:23:01 记录内容:语句:UPDATE exam_appoints SET costs='33',charges='33',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001080001' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:23:01 记录内容:语句:UPDATE exam_appoints SET costs='51.05',charges='51.05',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:23:01 记录内容:语句:UPDATE exam_appoints SET costs='21',charges='21',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001080003' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:23:01 记录内容:语句:UPDATE exam_appoints SET costs='70',charges='70',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001089999' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:23:01 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100112075' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:23:01 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100112075' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:23:01 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100112075' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:23:01 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100112075') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句: INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20200108004572','00074188','刘婧姣','一般人员','廊坊居民',to_date('2020/1/8 10:35:10','yyyy/mm/dd hh24:mi:ss'),'264.05','264.05','LIU ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句: INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2020/1/8 10:35:10','yyyy/mm/dd hh24:mi:ss'),'8248','00074188','0','','0330','辛俊英','20200108004572','202001087323') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:26:00','yyyy/mm/dd hh24:mi:ss'),'8248','20200108004572','1','D','D0602007','产科彩色多普勒超声常规检查','/','1','','0409','100','100','0','1','1.0000','100.0000','1','','0','辛俊英','0330','0','*产科彩色多普勒超声常规检查+生物物理相评分','JC000153','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:26:00','yyyy/mm/dd hh24:mi:ss'),'8248','20200108004572','2','D','D0607008','超声计算机图文报告','/','1','','0409','10','10','0','1','1.0000','10.0000','1','','0','辛俊英','0330','0','*产科彩色多普勒超声常规检查+生物物理相评分','JC000153','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:26:00','yyyy/mm/dd hh24:mi:ss'),'8248','20200108004572','3','D','D0601001','胎儿生物物理相评分','/','1','','0409','40','40','0','1','1.0000','40.0000','1','','0','辛俊英','0330','0','*产科彩色多普勒超声常规检查+生物物理相评分','JC000153','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句: INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2020/1/8 10:35:10','yyyy/mm/dd hh24:mi:ss'),'8249','00074188','0','','0330','辛俊英','20200108004572','202001087323') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:26:00','yyyy/mm/dd hh24:mi:ss'),'8249','20200108004572','1','C','H0000026','血细胞分析','/','11','','0411','11','11','0','1','1.0000','1.0000','2','','0','辛俊英','0330','0','*血常规','21313','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:26:00','yyyy/mm/dd hh24:mi:ss'),'8249','20200108004572','2','C','H0000053','血细胞分析(流式细胞仪法每增一项指标)','/','16','','0411','16','16','0','1','1.0000','1.0000','2','','0','辛俊英','0330','0','*血常规','21313','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句: INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2020/1/8 10:35:10','yyyy/mm/dd hh24:mi:ss'),'8250','00074188','0','','0330','辛俊英','20200108004572','202001087323') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:26:01','yyyy/mm/dd hh24:mi:ss'),'8250','20200108004572','1','C','H0001049','尿液分析','/','1','','0411','8','8','0','1','1.0000','8.0000','3','','0','辛俊英','0330','0','*尿常规+尿沉渣定量','JY000120','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:26:01','yyyy/mm/dd hh24:mi:ss'),'8250','20200108004572','2','C','H0001050','尿沉渣定量(流式细胞计数法)','/','1','','0411','25','25','0','1','1.0000','25.0000','3','','0','辛俊英','0330','0','*尿常规+尿沉渣定量','JY000120','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句: INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2020/1/8 10:35:10','yyyy/mm/dd hh24:mi:ss'),'8251','00074188','0','','0330','辛俊英','20200108004572','202001087323') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:26:01','yyyy/mm/dd hh24:mi:ss'),'8251','20200108004572','1','J','I0000483','真空采血管','/','1','支','0329','2','2','0','1','1.0000','2.0000','4','','0','辛俊英','0330','0','真空采血管','I0000483','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:26:01','yyyy/mm/dd hh24:mi:ss'),'8251','20200108004572','2','J','I0000009','一次性使用静脉采血针(黑色)','/','1','支','0329','1.05','1.05','0','1','1.0000','1.0500','5','','0','辛俊英','0330','0','一次性使用静脉采血针(黑色)','I0000009','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:26:01','yyyy/mm/dd hh24:mi:ss'),'8251','20200108004572','3','H','E0003006','静脉采血','/','1','','0329','3','3','0','1','1.0000','3.0000','6','','0','辛俊英','0330','0','静脉采血','10114','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句: INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2020/1/8 10:35:10','yyyy/mm/dd hh24:mi:ss'),'8252','00074188','0','','0330','辛俊英','20200108004572','202001087323') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:26:01','yyyy/mm/dd hh24:mi:ss'),'8252','20200108004572','1','E','D0911011','产前检查','/','1','','0330','5','5','0','1','1.0000','5.0000','7','','0','辛俊英','0330','0','产前检查','11684','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:26:01','yyyy/mm/dd hh24:mi:ss'),'8252','20200108004572','2','E','D0911014','胎心监测','/','1','','0330','3','3','0','1','1.0000','3.0000','8','','0','辛俊英','0330','0','胎心监测','11687','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:26:01','yyyy/mm/dd hh24:mi:ss'),'8252','20200108004572','3','D','D0911059','胎心监测(电子)','/','1','','0330','40','40','0','1','1.0000','40.0000','9','','0','辛俊英','0330','0','电子胎心监护','JC000989','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200108004572','1','微信','264.05','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254634' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254634' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254634' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254637' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254637' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254638' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254638' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254639' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254639' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254639' and presc_no = '0' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254641' and presc_no = '0' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254641' and presc_no = '0' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254641' and presc_no = '0' and item_no = '9' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254634' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254634' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254634' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254637' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254637' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254638' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254638' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254639' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254639' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254639' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254641' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254641' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7254641' and item_no = '9' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254634' and order_class = 'D' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254634' and order_class = 'D' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254634' and order_class = 'D' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254637' and order_class = 'C' and order_no = '2' and order_sub_no = '1' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254637' and order_class = 'C' and order_no = '2' and order_sub_no = '1' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254638' and order_class = 'C' and order_no = '3' and order_sub_no = '1' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254638' and order_class = 'C' and order_no = '3' and order_sub_no = '1' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254639' and order_class = 'J' and order_no = '4' and order_sub_no = '1' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254639' and order_class = 'J' and order_no = '5' and order_sub_no = '1' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254639' and order_class = 'H' and order_no = '6' and order_sub_no = '1' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254641' and order_class = 'E' and order_no = '7' and order_sub_no = '1' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254641' and order_class = 'E' and order_no = '8' and order_sub_no = '1' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:01 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254641' and order_class = 'D' and order_no = '9' and order_sub_no = '1' and item_no = '9' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:26 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:55 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:55 记录内容:语句:update clinic_master set registration_status='4' where visit_date=to_date('20200107','yyyy/mm/dd') and visit_no='5059' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:55 记录内容:语句: INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20200108004574','00074188','刘婧姣','一般人员','廊坊居民',to_date('2020/1/8 10:35:10','yyyy/mm/dd hh24:mi:ss'),'222.1','222.1','LIU ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:26:55 记录内容:语句: INSERT INTO drug_presc_master_temp (presc_date,presc_no,dispensary,PATIENT_ID,NAME,NAME_PHONETIC,IDENTITY,CHARGE_TYPE,PRESC_TYPE,PRESC_ATTR,PRESC_SOURCE,REPETITION,COSTS,PAYMENTS,ORDERED_BY,PRESCRIBED_BY,ENTERED_BY,DOCTOR_USER,RCPT_NO,COUNT_PER_REPETITION,CLINIC_NO,IS_SEND,SEND_WIN_NO) VALUES (to_date('2020/01/08 11:26:47','yyyy/mm/dd hh24:mi:ss'),'8235','050107','00074188','刘婧姣','LIU JING JIAO','一般人员','廊坊居民','0','门诊处方','0','1','222.10','222.10','0330','XINJY','辛俊英','XINJY','20200108004574','1','202001087323','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:19 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:19 记录内容:语句: INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2020-01-08 11:26:47', 'yyyy-mm-dd hh24:mi:ss'),'8235','1','11303052290','3g(每袋含钙500mg)*30','碳酸钙D3颗粒','康远制药','3g(每袋含钙500mg)*30','盒','2','222.1','222.1','3;g;口服;1/日','1','1','3','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:19 记录内容:语句: INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20200108004575','00074188','刘婧姣','一般人员','廊坊居民',to_date('2020/1/8 10:35:10','yyyy/mm/dd hh24:mi:ss'),'222.1','222.1','LIU ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:19 记录内容:语句: INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2020/1/8 10:35:10','yyyy/mm/dd hh24:mi:ss'),'8261','00074188','1','门诊处方','0330','辛俊英','20200108004574','202001087323') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句: INSERT INTO drug_presc_master_temp (presc_date,presc_no,dispensary,PATIENT_ID,NAME,NAME_PHONETIC,IDENTITY,CHARGE_TYPE,PRESC_TYPE,PRESC_ATTR,PRESC_SOURCE,REPETITION,COSTS,PAYMENTS,ORDERED_BY,PRESCRIBED_BY,ENTERED_BY,DOCTOR_USER,RCPT_NO,COUNT_PER_REPETITION,CLINIC_NO,IS_SEND,SEND_WIN_NO) VALUES (to_date('2020/01/08 11:27:03','yyyy/mm/dd hh24:mi:ss'),'8235','050107','00074188','刘婧姣','LIU JING JIAO','一般人员','廊坊居民','0','门诊处方','0','1','222.10','222.10','0330','XINJY','辛俊英','XINJY','20200108004575','1','202001087323','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:26:49','yyyy/mm/dd hh24:mi:ss'),'8261','20200108004574','1','A','11303052290','碳酸钙D3颗粒','3g(每袋含钙500mg)*30康远制药','2','盒','050107','222.1','222.1','0','1','A','032','200','1.0000','111.0500','1','3;g;口服;1/日','0','辛俊英','0330','0','碳酸钙D3颗粒','11303052290','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句: INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20200108004576','00074188','刘婧姣','一般人员','廊坊居民',to_date('2020/1/8 10:35:10','yyyy/mm/dd hh24:mi:ss'),'222.1','222.1','LIU ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句:update clinic_master set registration_status='4' where visit_date=to_date('20200107','yyyy/mm/dd') and visit_no='5061' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句: INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20200108004578','00074188','刘婧姣','一般人员','廊坊居民',to_date('2020/1/8 10:35:10','yyyy/mm/dd hh24:mi:ss'),'222.1','222.1','LIU ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句: INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20200108004601','00074188','刘婧姣','一般人员','廊坊居民',to_date('2020/1/8 10:35:10','yyyy/mm/dd hh24:mi:ss'),'222.1','222.1','LIU ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句:UPDATE exam_appoints SET costs='27',charges='27',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001080054' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句: INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2020-01-08 11:27:03', 'yyyy-mm-dd hh24:mi:ss'),'8235','1','11303052290','3g(每袋含钙500mg)*30','碳酸钙D3颗粒','康远制药','3g(每袋含钙500mg)*30','盒','2','222.1','222.1','3;g;口服;1/日','1','1','3','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200108004574','1','微信','222.1','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句: INSERT INTO drug_presc_master_temp (presc_date,presc_no,dispensary,PATIENT_ID,NAME,NAME_PHONETIC,IDENTITY,CHARGE_TYPE,PRESC_TYPE,PRESC_ATTR,PRESC_SOURCE,REPETITION,COSTS,PAYMENTS,ORDERED_BY,PRESCRIBED_BY,ENTERED_BY,DOCTOR_USER,RCPT_NO,COUNT_PER_REPETITION,CLINIC_NO,IS_SEND,SEND_WIN_NO) VALUES (to_date('2020/01/08 11:27:19','yyyy/mm/dd hh24:mi:ss'),'8235','050107','00074188','刘婧姣','LIU JING JIAO','一般人员','廊坊居民','0','门诊处方','0','1','222.10','222.10','0330','XINJY','辛俊英','XINJY','20200108004576','1','202001087323','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句: INSERT INTO drug_presc_master_temp (presc_date,presc_no,dispensary,PATIENT_ID,NAME,NAME_PHONETIC,IDENTITY,CHARGE_TYPE,PRESC_TYPE,PRESC_ATTR,PRESC_SOURCE,REPETITION,COSTS,PAYMENTS,ORDERED_BY,PRESCRIBED_BY,ENTERED_BY,DOCTOR_USER,RCPT_NO,COUNT_PER_REPETITION,CLINIC_NO,IS_SEND,SEND_WIN_NO) VALUES (to_date('2020/01/08 11:27:47','yyyy/mm/dd hh24:mi:ss'),'8235','050107','00074188','刘婧姣','LIU JING JIAO','一般人员','廊坊居民','0','门诊处方','0','1','222.10','222.10','0330','XINJY','辛俊英','XINJY','20200108004578','1','202001087323','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句: INSERT INTO drug_presc_master_temp (presc_date,presc_no,dispensary,PATIENT_ID,NAME,NAME_PHONETIC,IDENTITY,CHARGE_TYPE,PRESC_TYPE,PRESC_ATTR,PRESC_SOURCE,REPETITION,COSTS,PAYMENTS,ORDERED_BY,PRESCRIBED_BY,ENTERED_BY,DOCTOR_USER,RCPT_NO,COUNT_PER_REPETITION,CLINIC_NO,IS_SEND,SEND_WIN_NO) VALUES (to_date('2020/01/08 11:27:50','yyyy/mm/dd hh24:mi:ss'),'8235','050107','00074188','刘婧姣','LIU JING JIAO','一般人员','廊坊居民','0','门诊处方','0','1','222.10','222.10','0330','XINJY','辛俊英','XINJY','20200108004601','1','202001087323','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句:UPDATE exam_appoints SET costs='162.15',charges='162.15',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句: INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2020/1/8 10:35:10','yyyy/mm/dd hh24:mi:ss'),'8262','00074188','1','门诊处方','0330','辛俊英','20200108004575','202001087323') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句: INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2020-01-08 11:27:50', 'yyyy-mm-dd hh24:mi:ss'),'8235','1','11303052290','3g(每袋含钙500mg)*30','碳酸钙D3颗粒','康远制药','3g(每袋含钙500mg)*30','盒','2','222.1','222.1','3;g;口服;1/日','1','1','3','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254646' and presc_no = '8235' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句: INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2020-01-08 11:27:19', 'yyyy-mm-dd hh24:mi:ss'),'8235','1','11303052290','3g(每袋含钙500mg)*30','碳酸钙D3颗粒','康远制药','3g(每袋含钙500mg)*30','盒','2','222.1','222.1','3;g;口服;1/日','1','1','3','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句: INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2020-01-08 11:27:47', 'yyyy-mm-dd hh24:mi:ss'),'8235','1','11303052290','3g(每袋含钙500mg)*30','碳酸钙D3颗粒','康远制药','3g(每袋含钙500mg)*30','盒','2','222.1','222.1','3;g;口服;1/日','1','1','3','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句:UPDATE exam_appoints SET costs='33',charges='33',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001080056' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:27:03','yyyy/mm/dd hh24:mi:ss'),'8262','20200108004575','1','A','11303052290','碳酸钙D3颗粒','3g(每袋含钙500mg)*30康远制药','2','盒','050107','222.1','222.1','0','1','A','032','200','1.0000','111.0500','1','3;g;口服;1/日','0','辛俊英','0330','0','碳酸钙D3颗粒','11303052290','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句: INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2020/1/8 10:35:10','yyyy/mm/dd hh24:mi:ss'),'8272','00074188','1','门诊处方','0330','辛俊英','20200108004601','202001087323') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254646' and order_class = 'A' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句: INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2020/1/8 10:35:10','yyyy/mm/dd hh24:mi:ss'),'8267','00074188','1','门诊处方','0330','辛俊英','20200108004576','202001087323') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句: INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2020/1/8 10:35:10','yyyy/mm/dd hh24:mi:ss'),'8271','00074188','1','门诊处方','0330','辛俊英','20200108004578','202001087323') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句:UPDATE exam_appoints SET costs='150',charges='150',BILLING_INDICATOR='1' WHERE EXAM_NO = '3118466' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200108004575','1','微信','222.1','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:51 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:27:50','yyyy/mm/dd hh24:mi:ss'),'8272','20200108004601','1','A','11303052290','碳酸钙D3颗粒','3g(每袋含钙500mg)*30康远制药','2','盒','050107','222.1','222.1','0','1','A','032','200','1.0000','111.0500','1','3;g;口服;1/日','0','辛俊英','0330','0','碳酸钙D3颗粒','11303052290','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:59 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:59 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:27:19','yyyy/mm/dd hh24:mi:ss'),'8267','20200108004576','1','A','11303052290','碳酸钙D3颗粒','3g(每袋含钙500mg)*30康远制药','2','盒','050107','222.1','222.1','0','1','A','032','200','1.0000','111.0500','1','3;g;口服;1/日','0','辛俊英','0330','0','碳酸钙D3颗粒','11303052290','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:59 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 11:27:47','yyyy/mm/dd hh24:mi:ss'),'8271','20200108004578','1','A','11303052290','碳酸钙D3颗粒','3g(每袋含钙500mg)*30康远制药','2','盒','050107','222.1','222.1','0','1','A','032','200','1.0000','111.0500','1','3;g;口服;1/日','0','辛俊英','0330','0','碳酸钙D3颗粒','11303052290','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:59 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00074188' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:59 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254646' and presc_no = '8235' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:27:59 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200108004601','1','微信','222.1','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:28:33 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:28:33 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200108004576','1','微信','222.1','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:28:33 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200108004578','1','微信','222.1','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:28:33 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '00074188' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:28:33 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254646' and order_class = 'A' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:28:33 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254646' and presc_no = '8235' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:29:05 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:29:05 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254646' and presc_no = '8235' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:29:05 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7254646' and presc_no = '8235' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:29:05 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00074188' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:29:31 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:29:31 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254646' and order_class = 'A' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:29:58 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:29:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254646' and order_class = 'A' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:29:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7254646' and order_class = 'A' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:29:58 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '00074188') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:30:25 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:30:54 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:30:54 记录内容:语句:UPDATE exam_appoints SET costs='162.15',charges='162.15',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:31:17 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:31:49 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:32:23 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:32:30 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:32:30 记录内容:语句:UPDATE exam_appoints SET costs='27',charges='27',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001080054' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:33:03 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:33:36 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:34:04 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:34:24 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:34:25 记录内容:语句:UPDATE exam_appoints SET costs='33',charges='33',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001080056' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:34:57 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:35:27 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:35:27 记录内容:语句:UPDATE exam_appoints SET costs='162.15',charges='162.15',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:36:00 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:36:00 记录内容:语句:UPDATE exam_appoints SET costs='150',charges='150',BILLING_INDICATOR='1' WHERE EXAM_NO = '3118466' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:36:30 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:01 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:01 记录内容:语句:UPDATE exam_appoints SET costs='27',charges='27',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001080054' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:01 记录内容:语句:UPDATE exam_appoints SET costs='162.15',charges='162.15',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:02 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00074188' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:02 记录内容:语句:UPDATE exam_appoints SET costs='33',charges='33',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001080056' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:02 记录内容:语句:UPDATE exam_appoints SET costs='27',charges='27',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001080054' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:02 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '00074188' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:02 记录内容:语句:UPDATE exam_appoints SET costs='27',charges='27',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001080054' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:02 记录内容:语句:UPDATE exam_appoints SET costs='27',charges='27',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001080054' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:02 记录内容:语句:UPDATE exam_appoints SET costs='150',charges='150',BILLING_INDICATOR='1' WHERE EXAM_NO = '3118466' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:02 记录内容:语句:UPDATE exam_appoints SET costs='33',charges='33',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001080056' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:02 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00074188' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:02 记录内容:语句:UPDATE exam_appoints SET costs='33',charges='33',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001080056' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE exam_appoints SET costs='33',charges='33',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001080056' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00074188' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE exam_appoints SET costs='150',charges='150',BILLING_INDICATOR='1' WHERE EXAM_NO = '3118466' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '00074188') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE exam_appoints SET costs='150',charges='150',BILLING_INDICATOR='1' WHERE EXAM_NO = '3118466' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE exam_appoints SET costs='150',charges='150',BILLING_INDICATOR='1' WHERE EXAM_NO = '3118466' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '00074188' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00074188' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00074188' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '00074188' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00074188' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00074188' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '00074188' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00074188' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00074188' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '00074188') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '00074188') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '00074188') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '00074188' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00074188' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 11:37:03 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '00074188') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 13:45:18 记录内容:语句: INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20200108004844','00355577','孙靖怡','一般人员','自费',to_date('2020/1/8 13:33:50','yyyy/mm/dd hh24:mi:ss'),'120.09','120.09','SUN JING ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 13:45:18 记录内容:语句: INSERT INTO drug_presc_master_temp (presc_date,presc_no,dispensary,PATIENT_ID,NAME,NAME_PHONETIC,IDENTITY,CHARGE_TYPE,PRESC_TYPE,PRESC_ATTR,PRESC_SOURCE,REPETITION,COSTS,PAYMENTS,ORDERED_BY,PRESCRIBED_BY,ENTERED_BY,DOCTOR_USER,RCPT_NO,COUNT_PER_REPETITION,CLINIC_NO,IS_SEND,SEND_WIN_NO) VALUES (to_date('2020/01/08 13:45:18','yyyy/mm/dd hh24:mi:ss'),'9180','050101','00355577','孙靖怡','SUN JING YI','一般人员','自费','0','门诊处方','0','1','120.09','120.09','0304','XSJ','徐苏晋','XSJ','20200108004844','3','202001085674','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 13:45:18 记录内容:语句: INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2020-01-08 13:45:18', 'yyyy-mm-dd hh24:mi:ss'),'9180','1','10203060190','0.09g*12','氨酚麻美干混悬剂','浙江康德','0.09g*12','盒','1','41.17','41.17','.09;g;口服;3/日','1','1','0.09','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 13:45:18 记录内容:语句: INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2020-01-08 13:45:18', 'yyyy-mm-dd hh24:mi:ss'),'9180','2','20119003291','2g*9','小儿豉翘清热颗粒','江苏济川','2g*9','盒','1','34.5','34.5','2;g;口服;3/日','2','1','2','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 13:45:18 记录内容:语句: INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2020-01-08 13:45:18', 'yyyy-mm-dd hh24:mi:ss'),'9180','3','20103036320','10ml*12','蒲地蓝消炎口服液*','江苏济川','10ml*12','盒','1','44.42','44.42','5;ml;口服;3/日','3','1','5','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 13:45:18 记录内容:语句: INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2020/1/8 13:33:50','yyyy/mm/dd hh24:mi:ss'),'9211','00355577','1','门诊处方','0304','徐苏晋','20200108004844','202001085674') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 13:45:18 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 13:45:18','yyyy/mm/dd hh24:mi:ss'),'9211','20200108004844','1','A','10203060190','氨酚麻美干混悬剂','0.09g*12浙江康德','1','盒','050101','41.17','41.17','0','1','A','032','200','1.0000','41.1700','1','.09;g;口服;3/日','0','徐苏晋','0304','0','氨酚麻美干混悬剂','10203060190','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 13:45:18 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 13:45:18','yyyy/mm/dd hh24:mi:ss'),'9211','20200108004844','2','A','20119003291','小儿豉翘清热颗粒','2g*9江苏济川','1','盒','050101','34.5','34.5','0','1','D','033','600','1.0000','34.5000','2','2;g;口服;3/日','0','徐苏晋','0304','0','小儿豉翘清热颗粒','20119003291','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 13:45:18 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/08 13:45:18','yyyy/mm/dd hh24:mi:ss'),'9211','20200108004844','3','A','20103036320','蒲地蓝消炎口服液*','10ml*12江苏济川','1','盒','050101','44.42','44.42','0','1','D','033','600','1.0000','44.4200','3','5;ml;口服;3/日','0','徐苏晋','0304','0','蒲地蓝消炎口服液*','20103036320','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 13:45:18 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200108004844','1','微信','120.09','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 13:45:18 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7255196' and presc_no = '9180' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 13:45:18 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7255196' and presc_no = '9180' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 13:45:18 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7255196' and presc_no = '9180' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 13:45:18 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7255196' and order_class = 'A' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 13:45:18 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7255196' and order_class = 'A' and order_no = '2' and order_sub_no = '1' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 13:45:18 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7255196' and order_class = 'A' and order_no = '3' and order_sub_no = '1' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 13:45:18 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00355577' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 13:45:18 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '00355577' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 13:45:18 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00355577' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-08 13:45:18 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '00355577') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆