◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 08:55:33 记录内容:语句: 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 ('20200111010145','100108231','骆奇','一般人员','自费',to_date('2020/1/5 10:05:59','yyyy/mm/dd hh24:mi:ss'),'468.9','468.9','LUO QI ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 08:55:33 记录内容:语句: 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/11 08:55:33','yyyy/mm/dd hh24:mi:ss'),'6817','050101','100108231','骆奇','','一般人员','自费','0','门诊处方','0','1','468.90','468.90','0307','CYWAH','汪爱虎','CYWAH','20200111010145','2','202001115248','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 08:55:33 记录内容:语句: 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-11 08:55:33', 'yyyy-mm-dd hh24:mi:ss'),'6816','1','10206015390','0.4mg*20','阿普唑仑片','益民药业','0.4mg*20','盒','1','5.75','5.75','.4;mg;口服;3/日','1','1','0.4','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 08:55:33 记录内容:语句: 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-11 08:55:33', 'yyyy-mm-dd hh24:mi:ss'),'6817','1','10211004391','50mg*14','盐酸舍曲林片','辉瑞制药','50mg*14','盒','5','463.15','463.15','100;mg;口服;1/日','2','1','100','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 08:55:33 记录内容:语句: 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/5 10:05:59','yyyy/mm/dd hh24:mi:ss'),'6875','100108231','1','门诊处方','0307','汪爱虎','20200111010145','202001055248') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 08:55:33 记录内容:语句: 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/11 08:55:33','yyyy/mm/dd hh24:mi:ss'),'6875','20200111010145','1','A','10206015390','阿普唑仑片','0.4mg*20益民药业','1','盒','050101','5.75','5.75','0','1','A','032','200','1.0000','5.7500','1','.4;mg;口服;3/日','0','汪爱虎','0307','0','阿普唑仑片','10206015390','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 08:55:33 记录内容:语句: 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/11 08:55:33','yyyy/mm/dd hh24:mi:ss'),'6875','20200111010145','2','A','10211004391','盐酸舍曲林片','50mg*14辉瑞制药','5','盒','050101','463.15','463.15','0','1','A','032','200','1.0000','92.6300','1','100;mg;口服;1/日','0','汪爱虎','0307','0','盐酸舍曲林片','10211004391','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 08:55:33 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200111010145','1','微信','468.9','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 08:55:33 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7264835' and presc_no = '6816' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 08:55:33 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7264835' and presc_no = '6817' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 08:55:33 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7264835' and order_class = 'A' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 08:55:33 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7264835' and order_class = 'A' and order_no = '2' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 08:55:33 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100108231' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 08:55:33 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100108231' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 08:55:33 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100108231' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 08:55:33 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100108231') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句: 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 ('20200111010202','00258582','史巧艺','一般人员','异地医保',to_date('2020/1/11 8:48:39','yyyy/mm/dd hh24:mi:ss'),'236.9','236.9','SHI QIAO YI ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句: 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/11 8:48:39','yyyy/mm/dd hh24:mi:ss'),'7110','00258582','0','','0316','于昕','20200111010202','202001116740') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句: 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/11 09:07:05','yyyy/mm/dd hh24:mi:ss'),'7110','20200111010202','1','D','D0602038','腔内彩色多普勒超声检查(经阴道)','/','1','次','0409','120','120','0','1','J','006','150','1.0000','120.0000','1','','0','于昕','0316','0','*阴式超声检查','JC000102','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句: 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/11 09:07:05','yyyy/mm/dd hh24:mi:ss'),'7110','20200111010202','2','D','D0607008','超声计算机图文报告','/','1','次','0409','10','10','0','1','J','006','150','1.0000','10.0000','1','','0','于昕','0316','0','*阴式超声检查','JC000102','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句: 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/11 09:07:05','yyyy/mm/dd hh24:mi:ss'),'7110','20200111010202','3','D','D0602044','腔内彩色多普勒超声检查(加收)','/','1','次','0409','50','50','0','1','J','006','150','1.0000','50.0000','1','','0','于昕','0316','0','*阴式超声检查','JC000102','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句: 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/11 8:48:39','yyyy/mm/dd hh24:mi:ss'),'7111','00258582','0','','0316','于昕','20200111010202','202001116740') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句: 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/11 09:07:05','yyyy/mm/dd hh24:mi:ss'),'7111','20200111010202','1','J','0201290363','一次性阴道照明扩张器','YZYKQ-100*28沈阳康来福','1','个','0316','18.9','18.9','0','1','L','031','170','1.0000','18.9000','2','','0','于昕','0316','0','一次性阴道照明扩张器','0201290363','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句: 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/11 09:07:05','yyyy/mm/dd hh24:mi:ss'),'7111','20200111010202','2','D','D0911065','荧光检查(二合诊检查)','/','1','每个部位','0316','38','38','0','1','J','044','150','1.0000','38.0000','3','','0','于昕','0316','0','荧光检查(二合诊检查)','JC001095','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200111010202','1','微信','236.9','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7264949' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7264949' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7264949' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7264967' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7264967' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7264949' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7264949' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7264949' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7264967' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7264967' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7264949' and order_class = 'D' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7264949' and order_class = 'D' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7264949' and order_class = 'D' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7264967' and order_class = 'J' and order_no = '2' and order_sub_no = '1' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:06 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7264967' and order_class = 'D' and order_no = '3' and order_sub_no = '1' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:30 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:54 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:54 记录内容:语句:UPDATE exam_appoints SET costs='113.80',charges='113.80',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:54 记录内容:语句:UPDATE exam_appoints SET costs='180',charges='180',BILLING_INDICATOR='1' WHERE EXAM_NO = '3121813' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:54 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00258582' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:54 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '00258582' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:54 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00258582' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:07:54 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '00258582') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:06 记录内容:语句: 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 ('20200111010208','100112561','王雅倪','一般人员','自费',to_date('2020/1/10 23:37:38','yyyy/mm/dd hh24:mi:ss'),'210','210','WANG YA NI ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:06 记录内容:语句: 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/10 23:37:38','yyyy/mm/dd hh24:mi:ss'),'7211','100112561','0','','0304','马立英','20200111010208','202001105957') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:06 记录内容:语句: 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/11 09:11:06','yyyy/mm/dd hh24:mi:ss'),'7211','20200111010208','1','D','D0602003','腹部(肝胆胰脾)彩色多普勒超声常规检查','/','1','次','0409','100','100','0','1','J','006','150','1.0000','100.0000','1','','0','马立英','0304','0','*肝胆胰脾肾、腹腔淋巴结彩色超声常规检查','JC000018','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:06 记录内容:语句: 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/11 09:11:06','yyyy/mm/dd hh24:mi:ss'),'7211','20200111010208','2','D','D0602001','彩色多普勒超声常规检查','/','1','次','0409','100','100','0','1','J','006','150','1.0000','100.0000','1','','0','马立英','0304','0','*肝胆胰脾肾、腹腔淋巴结彩色超声常规检查','JC000018','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:06 记录内容:语句: 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/11 09:11:06','yyyy/mm/dd hh24:mi:ss'),'7211','20200111010208','3','D','D0607008','超声计算机图文报告','/','1','次','0409','10','10','0','1','J','006','150','1.0000','10.0000','1','','0','马立英','0304','0','*肝胆胰脾肾、腹腔淋巴结彩色超声常规检查','JC000018','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:06 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200111010208','1','微信','210','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:06 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265009' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:06 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265009' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:06 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265009' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:06 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265009' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:06 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265009' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:06 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265009' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:06 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265009' and order_class = 'D' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:06 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265009' and order_class = 'D' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:06 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265009' and order_class = 'D' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:39 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:39 记录内容:语句:UPDATE exam_appoints SET costs='210',charges='210',BILLING_INDICATOR='1' WHERE EXAM_NO = '3121797' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:39 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100112561' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:39 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100112561' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:39 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100112561' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:11:39 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100112561') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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 ('20200111010416','10003062','赵永霞','一般人员','异地医保',to_date('2020/1/11 9:48:08','yyyy/mm/dd hh24:mi:ss'),'240.05','240.05','ZHAO YONG XIA ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 9:48:08','yyyy/mm/dd hh24:mi:ss'),'8187','10003062','0','','0359','张英','20200111010416','202001117966') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:57','yyyy/mm/dd hh24:mi:ss'),'8187','20200111010416','1','C','H0000026','血细胞分析','/','11','项','0411','11','11','0','1','M','025','190','1.0000','1.0000','1','','0','张英','0359','0','*血常规','21313','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:57','yyyy/mm/dd hh24:mi:ss'),'8187','20200111010416','2','C','H0000053','血细胞分析(流式细胞仪法每增一项指标)','/','16','项','0411','16','16','0','1','M','025','190','1.0000','1.0000','1','','0','张英','0359','0','*血常规','21313','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 9:48:08','yyyy/mm/dd hh24:mi:ss'),'8188','10003062','0','','0359','张英','20200111010416','202001117966') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:57','yyyy/mm/dd hh24:mi:ss'),'8188','20200111010416','1','C','H0202003','血清总胆固醇测定(化学法或酶法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','2','','0','张英','0359','0','*血脂4','21577','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:57','yyyy/mm/dd hh24:mi:ss'),'8188','20200111010416','2','C','H0202007','血清甘油三酯测定(化学法或酶法)','/','1','项','0411','8','8','0','1','M','025','190','1.0000','8.0000','2','','0','张英','0359','0','*血脂4','21577','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:57','yyyy/mm/dd hh24:mi:ss'),'8188','20200111010416','3','C','H0202030','血清高密度脂蛋白胆固醇测定','/','1','项','0411','10','10','0','1','M','025','190','1.0000','10.0000','2','','0','张英','0359','0','*血脂4','21577','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:57','yyyy/mm/dd hh24:mi:ss'),'8188','20200111010416','4','C','H0202015','血清低密度脂蛋白胆固醇测定(其他方法)','/','1','项','0411','8','8','0','1','M','025','190','1.0000','8.0000','2','','0','张英','0359','0','*血脂4','21577','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:57','yyyy/mm/dd hh24:mi:ss'),'8188','20200111010416','5','C','H0201003','葡萄糖测定(各种酶法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','3','','0','张英','0359','0','*葡萄糖测定','21700','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:58','yyyy/mm/dd hh24:mi:ss'),'8188','20200111010416','6','C','H0203005','钠测定(火焰分光光亮度法或离子选择电极法)','/','1','项','0411','10','10','0','1','M','025','190','1.0000','10.0000','4','','0','张英','0359','0','*电解质3项','JY000014','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:58','yyyy/mm/dd hh24:mi:ss'),'8188','20200111010416','7','C','H0203002','钾测定(火焰分光光亮度法或离子选择电极法)','/','1','项','0411','10','10','0','1','M','025','190','1.0000','10.0000','4','','0','张英','0359','0','*电解质3项','JY000014','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:58','yyyy/mm/dd hh24:mi:ss'),'8188','20200111010416','8','C','H0203008','氯测定(离子选择电极法)','/','1','项','0411','10','10','0','1','M','025','190','1.0000','10.0000','4','','0','张英','0359','0','*电解质3项','JY000014','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:58','yyyy/mm/dd hh24:mi:ss'),'8188','20200111010416','9','C','H0204025','血清丙氨酸氨基转移酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','5','','0','张英','0359','0','*肝功3','21554','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:58','yyyy/mm/dd hh24:mi:ss'),'8188','20200111010416','10','C','H0204029','血清天门冬氨酸氨基转移酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','5','','0','张英','0359','0','*肝功3','21554','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:58','yyyy/mm/dd hh24:mi:ss'),'8188','20200111010416','11','C','H0204033','血清γ-谷氨酰基转移酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','5','','0','张英','0359','0','*肝功3','21554','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:58','yyyy/mm/dd hh24:mi:ss'),'8188','20200111010416','12','C','H0206004','尿素测定(酶促动力学法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','6','','0','张英','0359','0','*肾功3','21567','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:58','yyyy/mm/dd hh24:mi:ss'),'8188','20200111010416','13','C','H0206007','肌酐测定(酶促动力学法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','6','','0','张英','0359','0','*肾功3','21567','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:58','yyyy/mm/dd hh24:mi:ss'),'8188','20200111010416','14','C','H0206012','血清尿酸测定','/','1','项','0411','5','5','0','1','M','025','190','1.0000','5.0000','6','','0','张英','0359','0','*肾功3','21567','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 9:48:08','yyyy/mm/dd hh24:mi:ss'),'8189','10003062','0','','0359','张英','20200111010416','202001117966') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:58','yyyy/mm/dd hh24:mi:ss'),'8189','20200111010416','1','C','H0209003','血清促甲状腺激素测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','7','','0','张英','0359','0','*甲功三项','21379','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:58','yyyy/mm/dd hh24:mi:ss'),'8189','20200111010416','2','C','H0209033','血清三碘甲状原氨酸(T3)测定(化学发光法)','/','1','项','0411','30','30','0','1','M','025','190','1.0000','30.0000','7','','0','张英','0359','0','*甲功三项','21379','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:58','yyyy/mm/dd hh24:mi:ss'),'8189','20200111010416','3','C','H0209030','血清甲状腺素(T4)测定(化学发光法)','/','1','项','0411','30','30','0','1','M','025','190','1.0000','30.0000','7','','0','张英','0359','0','*甲功三项','21379','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 9:48:08','yyyy/mm/dd hh24:mi:ss'),'8190','10003062','0','','0359','张英','20200111010416','202001117966') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:58','yyyy/mm/dd hh24:mi:ss'),'8190','20200111010416','1','E','E0003006','静脉采血','/','1','次','0329','3','3','0','1','B','016','900','1.0000','3.0000','8','','0','张英','0359','0','*采血套餐三','15643','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:58','yyyy/mm/dd hh24:mi:ss'),'8190','20200111010416','2','E','I0000483','真空采血管','/','3','支','0359','6','6','0','1','L','031','170','1.0000','2.0000','8','','0','张英','0359','0','*采血套餐三','15643','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: 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/11 09:59:58','yyyy/mm/dd hh24:mi:ss'),'8190','20200111010416','3','E','I0000009','一次性使用静脉采血针(黑色)','/','1','支','0359','1.05','1.05','0','1','L','031','170','1.0000','1.0500','8','','0','张英','0359','0','*采血套餐三','15643','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200111010416','1','微信','240.05','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265583' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265583' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265586' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265586' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265586' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265586' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265586' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265586' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265586' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265586' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265586' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265586' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265586' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265586' and presc_no = '0' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265586' and presc_no = '0' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265586' and presc_no = '0' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265588' and presc_no = '0' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265588' and presc_no = '0' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265588' and presc_no = '0' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265611' and presc_no = '0' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265611' and presc_no = '0' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265611' and presc_no = '0' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265583' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265583' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265586' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265586' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265586' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265586' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265586' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265586' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265586' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265586' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265586' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265586' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265586' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265586' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265586' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265586' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265588' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265588' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265588' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265611' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265611' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7265611' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265583' and order_class = 'C' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265583' and order_class = 'C' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265586' and order_class = 'C' and order_no = '2' and order_sub_no = '1' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265586' and order_class = 'C' and order_no = '2' and order_sub_no = '1' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265586' and order_class = 'C' and order_no = '2' and order_sub_no = '1' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265586' and order_class = 'C' and order_no = '2' and order_sub_no = '1' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265586' and order_class = 'C' and order_no = '3' and order_sub_no = '1' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265586' and order_class = 'C' and order_no = '4' and order_sub_no = '1' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265586' and order_class = 'C' and order_no = '4' and order_sub_no = '1' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265586' and order_class = 'C' and order_no = '4' and order_sub_no = '1' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265586' and order_class = 'C' and order_no = '5' and order_sub_no = '1' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265586' and order_class = 'C' and order_no = '5' and order_sub_no = '1' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265586' and order_class = 'C' and order_no = '5' and order_sub_no = '1' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265586' and order_class = 'C' and order_no = '6' and order_sub_no = '1' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265586' and order_class = 'C' and order_no = '6' and order_sub_no = '1' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265586' and order_class = 'C' and order_no = '6' and order_sub_no = '1' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265588' and order_class = 'C' and order_no = '7' and order_sub_no = '1' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265588' and order_class = 'C' and order_no = '7' and order_sub_no = '1' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265588' and order_class = 'C' and order_no = '7' and order_sub_no = '1' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265611' and order_class = 'E' and order_no = '8' and order_sub_no = '1' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265611' and order_class = 'E' and order_no = '8' and order_sub_no = '1' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 09:59:58 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265611' and order_class = 'E' and order_no = '8' and order_sub_no = '1' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:00:24 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:00:49 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:01:18 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:01:50 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:01:50 记录内容:语句:UPDATE exam_appoints SET costs='10.05',charges='10.05',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:01:50 记录内容:语句:UPDATE exam_appoints SET costs='100',charges='100',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001116459' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:01:50 记录内容:语句:UPDATE exam_appoints SET costs='515',charges='515',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001116458' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:01:50 记录内容:语句:UPDATE exam_appoints SET costs='27',charges='27',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001116457' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:01:50 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10003062' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:01:51 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10003062' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:01:51 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10003062' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:01:51 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10003062') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:14:47 记录内容:语句: 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 ('20200111010527','00339088','王春平','一般人员','自费',to_date('2020/1/10 21:52:05','yyyy/mm/dd hh24:mi:ss'),'23.91','23.91','WANG CHUN PING ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:14:48 记录内容:语句: 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/11 10:14:47','yyyy/mm/dd hh24:mi:ss'),'8446','050101','00339088','王春平','WANG CHUN PING','一般人员','自费','0','门诊处方','0','1','23.91','23.91','0303','WXL','王晓莉','WXL','20200111010527','1','202001115863','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:14:48 记录内容:语句: 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-11 10:14:47', 'yyyy-mm-dd hh24:mi:ss'),'8446','1','10206020390','10mg*7','[进]酒石酸唑吡坦片*','赛诺菲','10mg*7','盒','1','23.91','23.91','10;mg;口服;睡前','1','1','10','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:14:48 记录内容:语句: 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/10 21:52:05','yyyy/mm/dd hh24:mi:ss'),'8526','00339088','1','门诊处方','0303','王晓莉','20200111010527','202001105863') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:14:48 记录内容:语句: 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/11 10:14:47','yyyy/mm/dd hh24:mi:ss'),'8526','20200111010527','1','A','10206020390','[进]酒石酸唑吡坦片*','10mg*7赛诺菲','1','盒','050101','23.91','23.91','0','1','A','032','200','1.0000','23.9100','1','10;mg;口服;睡前','0','王晓莉','0303','0','[进]酒石酸唑吡坦片*','10206020390','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:14:48 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200111010527','1','微信','23.91','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:14:48 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7265778' and presc_no = '8446' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:14:48 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7265778' and order_class = 'A' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:14:48 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00339088' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:14:48 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '00339088' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:14:48 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00339088' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-11 10:14:48 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '00339088') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆