◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2024-04-14 09:11:23 记录内容:cyys_2017@123cyys_2017@123100368986100368986140072321400723414007236245.10001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2024-04-14 09:11:23 记录内容:'14007232','14007234','14007236' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2024-04-14 09:11:23 记录内容:2024-04-14 09:11:23 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2024-04-14 09:11:24 记录内容:2024-04-14 09:11:24 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________ 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 ('20240414011394','100368986','郭海潮','一般人员','自费',to_date('2024/04/14 09:11:23','yyyy/mm/dd hh24:mi:ss'),'245.1','245.1','GUO HAI CHAO ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________ 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('2024/4/9 17:52:54','yyyy/mm/dd hh24:mi:ss'),'8841','100368986','0','','0330','辛俊英','20240414011394','202404092169') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________ 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('2024/04/14 09:11:23','yyyy/mm/dd hh24:mi:ss'),'8841','20240414011394','1','C','H0201003','葡萄糖测定(各种酶法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','1','','0','辛俊英','0330','0','*葡萄糖测定','21700','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________ 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('2024/04/14 09:11:23','yyyy/mm/dd hh24:mi:ss'),'8841','20240414011394','2','C','H0201009','糖化血红蛋白测定(色谱法)','/','1','项','0411','70','70','0','1','M','025','190','1.0000','70.0000','2','','0','辛俊英','0330','0','*糖化血红蛋白测定','21752','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________ 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('2024/4/9 17:52:54','yyyy/mm/dd hh24:mi:ss'),'8842','100368986','0','','0330','辛俊英','20240414011394','202404092169') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________ 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('2024/04/14 09:11:23','yyyy/mm/dd hh24:mi:ss'),'8842','20240414011394','1','J','I0001053','一次性使用静脉血样采集针','0.7简易的','1','支','0330','0.47','0.47','0','1','L','031','170','1.0000','0.4700','3','','0','辛俊英','0330','0','一次性使用静脉血样采集针','I0001053','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________ 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('2024/04/14 09:11:23','yyyy/mm/dd hh24:mi:ss'),'8842','20240414011394','2','E','E0003043','静脉注射','/','1','次','0330','7','7','0','1','C','022','300','1.0000','7.0000','4','','0','辛俊英','0330','0','静脉注射','E0003043','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________ 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('2024/04/14 09:11:23','yyyy/mm/dd hh24:mi:ss'),'8842','20240414011394','3','J','I0013310','一次性使用真空采血管','2.7ml/碧迪','1','支','0330','1.63','1.63','0','1','C','022','300','1.0000','1.6300','5','','0','辛俊英','0330','0','一次性使用真空采血管','I0013310','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________ 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('2024/4/9 17:52:54','yyyy/mm/dd hh24:mi:ss'),'8843','100368986','0','','0330','辛俊英','20240414011394','202404092169') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________ 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('2024/04/14 09:11:23','yyyy/mm/dd hh24:mi:ss'),'8843','20240414011394','1','D','D0602049','彩色多普勒超声常规检查','/','1','项','0409','50','50','0','1','J','006','150','1.0000','50.0000','6','','0','辛俊英','0330','0','*产科彩色多普勒(胎儿大脑中动脉血流监测)','JC000710','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________ 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('2024/04/14 09:11:23','yyyy/mm/dd hh24:mi:ss'),'8843','20240414011394','2','D','D0607008','超声计算机图文报告','/','1','次','0409','10','10','0','1','J','006','150','1.0000','10.0000','7','','0','辛俊英','0330','0','*产科彩色多普勒超声常规检查','21202','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________ 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('2024/04/14 09:11:24','yyyy/mm/dd hh24:mi:ss'),'8843','20240414011394','3','D','D0602007','产科彩色多普勒超声常规检查','/','1','次','0409','100','100','0','1','J','006','150','1.0000','100.0000','7','','0','辛俊英','0330','0','*产科彩色多普勒超声常规检查','21202','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240414011394','1','微信','245.1','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007232' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007232' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007234' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007234' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007234' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007236' and presc_no = '0' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007236' and presc_no = '0' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007236' and presc_no = '0' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007232' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007232' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007234' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007234' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007234' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007236' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007236' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007236' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007232' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007232' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007234' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007234' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007234' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007236' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007236' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007236' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '4930371' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2404148791' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE exam_appoints SET costs='27.30',charges='27.30',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE exam_appoints SET costs='320',charges='320',BILLING_INDICATOR='1' WHERE EXAM_NO = '4930371' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE exam_appoints SET costs='152',charges='152',BILLING_INDICATOR='1' WHERE EXAM_NO = '2404148791' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100368986' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100368986' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100368986' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:11:25 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100368986') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2024-04-14 09:11:25 记录内容:2024-04-14 09:11:25 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2024-04-14 09:11:25 记录内容:1成功120240414011394 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2024-04-14 09:11:25 记录内容:2024-04-14 09:11:25 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2024-04-14 09:32:26 记录内容:cyys_2017@123cyys_2017@123Z00303855Z0030385514007675130.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2024-04-14 09:32:26 记录内容:'14007675' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2024-04-14 09:32:26 记录内容:2024-04-14 09:32:26 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2024-04-14 09:32:27 记录内容:2024-04-14 09:32:27 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________ 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 ('20240414011534','Z00303855','王楠','一般人员','自费',to_date('2024/04/14 09:32:26','yyyy/mm/dd hh24:mi:ss'),'130','130','WANG ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________ 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('2024/4/14 9:19:45','yyyy/mm/dd hh24:mi:ss'),'9410','Z00303855','0','','0330','郑晓丽','20240414011534','202404149060') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________ 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('2024/04/14 09:32:26','yyyy/mm/dd hh24:mi:ss'),'9410','20240414011534','1','D','D0602007','产科彩色多普勒超声常规检查','/','1','次','0409','100','100','0','1','J','006','150','1.0000','100.0000','1','','0','郑晓丽','0330','0','*产科多普勒常规检查+宫颈管功能测量','JC000893','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________ 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('2024/04/14 09:32:26','yyyy/mm/dd hh24:mi:ss'),'9410','20240414011534','2','D','D0602045','彩色多普勒超声常规检查','/','1','项','0409','20','20','0','1','J','006','150','1.0000','20.0000','1','','0','郑晓丽','0330','0','*产科多普勒常规检查+宫颈管功能测量','JC000893','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________ 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('2024/04/14 09:32:26','yyyy/mm/dd hh24:mi:ss'),'9410','20240414011534','3','D','D0607008','超声计算机图文报告','/','1','次','0409','10','10','0','1','J','006','150','1.0000','10.0000','1','','0','郑晓丽','0330','0','*产科多普勒常规检查+宫颈管功能测量','JC000893','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240414011534','1','微信','130','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007675' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007675' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007675' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007675' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007675' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007675' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007675' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007675' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007675' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '4930507' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________UPDATE exam_appoints SET costs='130',charges='130',BILLING_INDICATOR='1' WHERE EXAM_NO = '4930507' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'Z00303855' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'Z00303855' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'Z00303855' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:32:27 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'Z00303855') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2024-04-14 09:32:27 记录内容:2024-04-14 09:32:27 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2024-04-14 09:32:27 记录内容:1成功120240414011534 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2024-04-14 09:32:27 记录内容:2024-04-14 09:32:27 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2024-04-14 09:42:31 记录内容:cyys_2017@123cyys_2017@123105728091057280914007706140077091400771114007712203.62001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2024-04-14 09:42:31 记录内容:'14007706','14007709','14007711','14007712' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2024-04-14 09:42:32 记录内容:2024-04-14 09:42:32 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2024-04-14 09:42:32 记录内容:2024-04-14 09:42:32 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42: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 ('20240414011626','10572809','王美然','一般人员','自费',to_date('2024/04/14 09:42:32','yyyy/mm/dd hh24:mi:ss'),'203.62','203.62','WANG MEI RAN ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42: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('2024/4/14 8:21:43','yyyy/mm/dd hh24:mi:ss'),'9708','10572809','0','','0315','房霞','20240414011626','202404147386') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42: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('2024/04/14 09:42:32','yyyy/mm/dd hh24:mi:ss'),'9708','20240414011626','1','C','H0209042','血清游离三碘甲状原氨酸(FT3)测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','房霞','0315','0','*游离甲功三项','JY000142','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42: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('2024/04/14 09:42:32','yyyy/mm/dd hh24:mi:ss'),'9708','20240414011626','2','C','H0209039','血清游离甲状腺素(FT4)测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','房霞','0315','0','*游离甲功三项','JY000142','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42: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('2024/04/14 09:42:32','yyyy/mm/dd hh24:mi:ss'),'9708','20240414011626','3','C','H0209003','血清促甲状腺激素测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','房霞','0315','0','*游离甲功三项','JY000142','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42: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('2024/4/14 8:21:43','yyyy/mm/dd hh24:mi:ss'),'9709','10572809','0','','0315','房霞','20240414011626','202404147386') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42: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('2024/04/14 09:42:32','yyyy/mm/dd hh24:mi:ss'),'9709','20240414011626','1','C','H0204003','血清总胆红素测定(化学法或酶促法)','/','1','项','0411','5','5','0','1','M','025','190','1.0000','5.0000','2','','0','房霞','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42: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('2024/04/14 09:42:32','yyyy/mm/dd hh24:mi:ss'),'9709','20240414011626','2','C','H0204007','血清直接胆红素测定(化学法或酶促法)','/','1','项','0411','5','5','0','1','M','025','190','1.0000','5.0000','2','','0','房霞','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42: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('2024/04/14 09:42:32','yyyy/mm/dd hh24:mi:ss'),'9709','20240414011626','3','C','H0204025','血清丙氨酸氨基转移酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','2','','0','房霞','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42: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('2024/04/14 09:42:32','yyyy/mm/dd hh24:mi:ss'),'9709','20240414011626','4','C','H0204029','血清天门冬氨酸氨基转移酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','2','','0','房霞','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42: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('2024/04/14 09:42:32','yyyy/mm/dd hh24:mi:ss'),'9709','20240414011626','5','C','H0204033','血清γ-谷氨酰基转移酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','2','','0','房霞','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42: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('2024/04/14 09:42:32','yyyy/mm/dd hh24:mi:ss'),'9709','20240414011626','6','C','H0204038','血清碱性磷酸酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','2','','0','房霞','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42: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('2024/04/14 09:42:32','yyyy/mm/dd hh24:mi:ss'),'9709','20240414011626','7','C','H0204046','血清胆碱酯酶测定(速率法)','/','1','项','0411','15','15','0','1','M','025','190','1.0000','15.0000','2','','0','房霞','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42: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('2024/4/14 8:21:43','yyyy/mm/dd hh24:mi:ss'),'9710','10572809','0','','0315','房霞','20240414011626','202404147386') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42: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('2024/04/14 09:42:32','yyyy/mm/dd hh24:mi:ss'),'9710','20240414011626','1','C','H0000026','血细胞分析','/','11','项','0411','11','11','0','1','M','025','190','1.0000','1.0000','3','','0','房霞','0315','0','*血常规','21313','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42: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('2024/04/14 09:42:32','yyyy/mm/dd hh24:mi:ss'),'9710','20240414011626','2','C','H0000053','血细胞分析(流式细胞仪法每增一项指标)','/','13','项','0411','13','13','0','1','M','025','190','1.0000','1.0000','3','','0','房霞','0315','0','*血常规','21313','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42: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('2024/4/14 8:21:43','yyyy/mm/dd hh24:mi:ss'),'9711','10572809','0','','0315','房霞','20240414011626','202404147386') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42: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('2024/04/14 09:42:32','yyyy/mm/dd hh24:mi:ss'),'9711','20240414011626','1','E','E0003052','静脉采血','/','1','次','0329','7','7','0','1','C','022','300','1.0000','7.0000','4','','0','房霞','0315','0','*采血套餐三','15643','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42: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('2024/04/14 09:42:32','yyyy/mm/dd hh24:mi:ss'),'9711','20240414011626','2','E','I0001053','一次性使用静脉血样采集针','0.7简易的','1','支','0315','0.47','0.47','0','1','L','031','170','1.0000','0.4700','4','','0','房霞','0315','0','*采血套餐三','15643','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42: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('2024/04/14 09:42:32','yyyy/mm/dd hh24:mi:ss'),'9711','20240414011626','3','E','I0009141','一次性使用真空采血管','2ml/阳普','3','支','0315','3.15','3.15','0','1','L','031','170','1.0000','1.0500','4','','0','房霞','0315','0','*采血套餐三','15643','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240414011626','1','微信','203.62','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007706' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007706' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007706' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007709' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007709' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007709' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007709' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007709' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007709' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007709' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007711' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007711' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007712' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007712' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14007712' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007706' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007706' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007706' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007709' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007709' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007709' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007709' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007709' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007709' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007709' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007711' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007711' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007712' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007712' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14007712' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007706' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007706' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007706' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007709' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007709' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007709' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007709' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007709' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007709' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007709' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007711' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007711' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007712' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007712' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14007712' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2404149014' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2404149028' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2404149026' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE exam_appoints SET costs='10.62',charges='10.62',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE exam_appoints SET costs='120',charges='120',BILLING_INDICATOR='1' WHERE EXAM_NO = '2404149014' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE exam_appoints SET costs='24',charges='24',BILLING_INDICATOR='1' WHERE EXAM_NO = '2404149028' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE exam_appoints SET costs='49',charges='49',BILLING_INDICATOR='1' WHERE EXAM_NO = '2404149026' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10572809' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10572809' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10572809' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 09:42:33 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10572809') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2024-04-14 09:42:33 记录内容:2024-04-14 09:42:33 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2024-04-14 09:42:33 记录内容:1成功120240414011626 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2024-04-14 09:42:33 记录内容:2024-04-14 09:42:33 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2024-04-14 10:23:36 记录内容:cyys_2017@123cyys_2017@12310040756010040756014008439140084371400846314008465203.62001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2024-04-14 10:23:36 记录内容:'14008439','14008437','14008463','14008465' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2024-04-14 10:23:37 记录内容:2024-04-14 10:23:37 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2024-04-14 10:23:37 记录内容:2024-04-14 10:23:37 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ 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 ('20240414011933','100407560','郭慧敏','一般人员','自费',to_date('2024/04/14 10:23:37','yyyy/mm/dd hh24:mi:ss'),'203.62','203.62','GUO HUI MIN ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ 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('2024/4/13 23:39:08','yyyy/mm/dd hh24:mi:ss'),'939','100407560','0','','0315','房霞','20240414011933','202404136554') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ 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('2024/04/14 10:23:37','yyyy/mm/dd hh24:mi:ss'),'939','20240414011933','1','C','H0209042','血清游离三碘甲状原氨酸(FT3)测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','房霞','0315','0','*游离甲功三项','JY000142','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ 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('2024/04/14 10:23:37','yyyy/mm/dd hh24:mi:ss'),'939','20240414011933','2','C','H0209039','血清游离甲状腺素(FT4)测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','房霞','0315','0','*游离甲功三项','JY000142','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ 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('2024/04/14 10:23:37','yyyy/mm/dd hh24:mi:ss'),'939','20240414011933','3','C','H0209003','血清促甲状腺激素测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','房霞','0315','0','*游离甲功三项','JY000142','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ 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('2024/4/13 23:39:08','yyyy/mm/dd hh24:mi:ss'),'940','100407560','0','','0315','房霞','20240414011933','202404136554') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ 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('2024/04/14 10:23:37','yyyy/mm/dd hh24:mi:ss'),'940','20240414011933','1','C','H0204003','血清总胆红素测定(化学法或酶促法)','/','1','项','0411','5','5','0','1','M','025','190','1.0000','5.0000','2','','0','房霞','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ 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('2024/04/14 10:23:37','yyyy/mm/dd hh24:mi:ss'),'940','20240414011933','2','C','H0204007','血清直接胆红素测定(化学法或酶促法)','/','1','项','0411','5','5','0','1','M','025','190','1.0000','5.0000','2','','0','房霞','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ 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('2024/04/14 10:23:37','yyyy/mm/dd hh24:mi:ss'),'940','20240414011933','3','C','H0204025','血清丙氨酸氨基转移酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','2','','0','房霞','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ 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('2024/04/14 10:23:37','yyyy/mm/dd hh24:mi:ss'),'940','20240414011933','4','C','H0204029','血清天门冬氨酸氨基转移酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','2','','0','房霞','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ 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('2024/04/14 10:23:37','yyyy/mm/dd hh24:mi:ss'),'940','20240414011933','5','C','H0204033','血清γ-谷氨酰基转移酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','2','','0','房霞','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ 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('2024/04/14 10:23:37','yyyy/mm/dd hh24:mi:ss'),'940','20240414011933','6','C','H0204038','血清碱性磷酸酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','2','','0','房霞','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ 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('2024/04/14 10:23:37','yyyy/mm/dd hh24:mi:ss'),'940','20240414011933','7','C','H0204046','血清胆碱酯酶测定(速率法)','/','1','项','0411','15','15','0','1','M','025','190','1.0000','15.0000','2','','0','房霞','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ 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('2024/4/13 23:39:08','yyyy/mm/dd hh24:mi:ss'),'941','100407560','0','','0315','房霞','20240414011933','202404136554') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ 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('2024/04/14 10:23:37','yyyy/mm/dd hh24:mi:ss'),'941','20240414011933','1','C','H0000026','血细胞分析','/','11','项','0411','11','11','0','1','M','025','190','1.0000','1.0000','3','','0','房霞','0315','0','*血常规','21313','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ 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('2024/04/14 10:23:37','yyyy/mm/dd hh24:mi:ss'),'941','20240414011933','2','C','H0000053','血细胞分析(流式细胞仪法每增一项指标)','/','13','项','0411','13','13','0','1','M','025','190','1.0000','1.0000','3','','0','房霞','0315','0','*血常规','21313','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ 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('2024/4/13 23:39:08','yyyy/mm/dd hh24:mi:ss'),'942','100407560','0','','0315','房霞','20240414011933','202404136554') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ 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('2024/04/14 10:23:37','yyyy/mm/dd hh24:mi:ss'),'942','20240414011933','1','E','E0003052','静脉采血','/','1','次','0329','7','7','0','1','C','022','300','1.0000','7.0000','4','','0','房霞','0315','0','*采血套餐三','15643','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ 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('2024/04/14 10:23:37','yyyy/mm/dd hh24:mi:ss'),'942','20240414011933','2','E','I0001053','一次性使用静脉血样采集针','0.7简易的','1','支','0315','0.47','0.47','0','1','L','031','170','1.0000','0.4700','4','','0','房霞','0315','0','*采血套餐三','15643','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ 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('2024/04/14 10:23:37','yyyy/mm/dd hh24:mi:ss'),'942','20240414011933','3','E','I0009141','一次性使用真空采血管','2ml/阳普','3','支','0315','3.15','3.15','0','1','L','031','170','1.0000','1.0500','4','','0','房霞','0315','0','*采血套餐三','15643','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240414011933','1','微信','203.62','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14008437' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14008437' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14008437' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14008439' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14008439' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14008439' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14008439' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14008439' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14008439' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14008439' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14008463' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14008463' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14008465' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14008465' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14008465' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14008437' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14008437' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14008437' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14008439' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14008439' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14008439' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14008439' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14008439' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14008439' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14008439' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14008463' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14008463' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14008465' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14008465' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14008465' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14008437' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14008437' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14008437' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14008439' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14008439' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14008439' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14008439' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14008439' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14008439' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14008439' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14008463' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14008463' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14008465' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14008465' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14008465' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2404149334' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2404149332' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2404149333' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE exam_appoints SET costs='10.62',charges='10.62',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE exam_appoints SET costs='24',charges='24',BILLING_INDICATOR='1' WHERE EXAM_NO = '2404149334' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE exam_appoints SET costs='120',charges='120',BILLING_INDICATOR='1' WHERE EXAM_NO = '2404149332' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE exam_appoints SET costs='49',charges='49',BILLING_INDICATOR='1' WHERE EXAM_NO = '2404149333' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100407560' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100407560' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100407560' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 10:23:38 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100407560') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2024-04-14 10:23:38 记录内容:2024-04-14 10:23:38 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2024-04-14 10:23:38 记录内容:1成功120240414011933 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2024-04-14 10:23:38 记录内容:2024-04-14 10:23:38 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2024-04-14 13:38:06 记录内容:cyys_2017@123cyys_2017@1231004067491004067491400983214009841248.52001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2024-04-14 13:38:06 记录内容:'14009832','14009841' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2024-04-14 13:38:06 记录内容:2024-04-14 13:38:06 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2024-04-14 13:38:07 记录内容:2024-04-14 13:38:07 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________ 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 ('20240414012729','100406749','王泽杨','一般人员','自费',to_date('2024/04/14 13:38:06','yyyy/mm/dd hh24:mi:ss'),'248.52','248.52','WANG ZE YANG ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________ 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('2024/4/9 23:16:36','yyyy/mm/dd hh24:mi:ss'),'3426','100406749','0','','0371','富鹤','20240414012729','202404092566') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________ 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('2024/04/14 13:38:06','yyyy/mm/dd hh24:mi:ss'),'3426','20240414012729','1','C','H0209012','血清促卵泡刺激素测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','富鹤','0371','0','*性激素六项(生殖科)','JY001310','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________ 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('2024/04/14 13:38:06','yyyy/mm/dd hh24:mi:ss'),'3426','20240414012729','2','C','H0209015','血清促黄体生成素测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','富鹤','0371','0','*性激素六项(生殖科)','JY001310','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________ 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('2024/04/14 13:38:06','yyyy/mm/dd hh24:mi:ss'),'3426','20240414012729','3','C','H0209100','雌二醇测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','富鹤','0371','0','*性激素六项(生殖科)','JY001310','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________ 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('2024/04/14 13:38:06','yyyy/mm/dd hh24:mi:ss'),'3426','20240414012729','4','C','H0209103','孕酮测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','富鹤','0371','0','*性激素六项(生殖科)','JY001310','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________ 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('2024/04/14 13:38:06','yyyy/mm/dd hh24:mi:ss'),'3426','20240414012729','5','C','H0209006','血清泌乳素测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','富鹤','0371','0','*性激素六项(生殖科)','JY001310','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________ 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('2024/04/14 13:38:07','yyyy/mm/dd hh24:mi:ss'),'3426','20240414012729','6','C','H0209082','睾酮测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','富鹤','0371','0','*性激素六项(生殖科)','JY001310','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________ 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('2024/4/9 23:16:36','yyyy/mm/dd hh24:mi:ss'),'3427','100406749','0','','0371','富鹤','20240414012729','202404092566') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________ 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('2024/04/14 13:38:07','yyyy/mm/dd hh24:mi:ss'),'3427','20240414012729','1','E','E0003052','静脉采血','/','1','次','0371','7','7','0','1','C','022','300','1.0000','7.0000','2','','0','富鹤','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________ 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('2024/04/14 13:38:07','yyyy/mm/dd hh24:mi:ss'),'3427','20240414012729','2','E','I0001053','一次性使用静脉血样采集针','0.7简易的','1','支','0371','0.47','0.47','0','1','L','031','170','1.0000','0.4700','2','','0','富鹤','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________ 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('2024/04/14 13:38:07','yyyy/mm/dd hh24:mi:ss'),'3427','20240414012729','3','E','I0009141','一次性使用真空采血管','2ml/阳普','1','支','0371','1.05','1.05','0','1','L','031','170','1.0000','1.0500','2','','0','富鹤','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240414012729','1','微信','248.52','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14009832' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14009832' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14009832' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14009832' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14009832' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14009832' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14009841' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14009841' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14009841' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14009832' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14009832' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14009832' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14009832' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14009832' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14009832' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14009841' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14009841' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14009841' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14009832' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14009832' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14009832' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14009832' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14009832' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14009832' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14009841' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14009841' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14009841' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2404149932' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE exam_appoints SET costs='8.52',charges='8.52',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE exam_appoints SET costs='240',charges='240',BILLING_INDICATOR='1' WHERE EXAM_NO = '2404149932' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100406749' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100406749' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100406749' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 13:38:07 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100406749') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2024-04-14 13:38:07 记录内容:2024-04-14 13:38:07 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2024-04-14 13:38:07 记录内容:1成功120240414012729 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2024-04-14 13:38:07 记录内容:2024-04-14 13:38:07 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2024-04-14 14:29:19 记录内容:cyys_2017@123cyys_2017@123Z00406478Z0040647814010276130.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2024-04-14 14:29:19 记录内容:'14010276' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2024-04-14 14:29:19 记录内容:2024-04-14 14:29:19 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2024-04-14 14:29:19 记录内容:2024-04-14 14:29:19 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 14:29:20 记录内容:__________ 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 ('20240414012972','Z00406478','朱思雨','一般人员','自费',to_date('2024/04/14 14:29:19','yyyy/mm/dd hh24:mi:ss'),'130','130','ZHU SI YU ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 14:29:20 记录内容:__________ 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('2024/4/8 15:45:10','yyyy/mm/dd hh24:mi:ss'),'4306','Z00406478','0','','0330','辛俊英','20240414012972','202404089041') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 14:29:20 记录内容:__________ 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('2024/04/14 14:29:19','yyyy/mm/dd hh24:mi:ss'),'4306','20240414012972','1','D','D0602038','腔内彩色多普勒超声检查(经阴道)','/','1','次','0409','120','120','0','1','J','006','150','1.0000','120.0000','2','','0','辛俊英','0330','0','*阴式超声检查','JC000102','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 14:29:20 记录内容:__________ 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('2024/04/14 14:29:19','yyyy/mm/dd hh24:mi:ss'),'4306','20240414012972','2','D','D0607008','超声计算机图文报告','/','1','次','0409','10','10','0','1','J','006','150','1.0000','10.0000','2','','0','辛俊英','0330','0','*阴式超声检查','JC000102','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 14:29:20 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240414012972','1','微信','130','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 14:29:20 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14010276' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 14:29:20 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14010276' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 14:29:20 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14010276' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 14:29:20 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14010276' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 14:29:20 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14010276' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 14:29:20 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14010276' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 14:29:20 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'Z00406478' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 14:29:20 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'Z00406478' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 14:29:20 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'Z00406478' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 14:29:20 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'Z00406478') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2024-04-14 14:29:20 记录内容:2024-04-14 14:29:20 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2024-04-14 14:29:20 记录内容:1成功120240414012972 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2024-04-14 14:29:20 记录内容:2024-04-14 14:29:20 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2024-04-14 15:19:54 记录内容:cyys_2017@123cyys_2017@123100368986100368986140106131401061454.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2024-04-14 15:19:54 记录内容:'14010613','14010614' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2024-04-14 15:19:54 记录内容:2024-04-14 15:19:54 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2024-04-14 15:19:54 记录内容:2024-04-14 15:19:54 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19: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 ('20240414013268','100368986','郭海潮','一般人员','自费',to_date('2024/04/14 15:19:54','yyyy/mm/dd hh24:mi:ss'),'54','54','GUO HAI CHAO ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________ 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('2024/4/9 17:52:54','yyyy/mm/dd hh24:mi:ss'),'5046','100368986','0','','0330','辛俊英','20240414013268','202404092169') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________ 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('2024/04/14 15:19:54','yyyy/mm/dd hh24:mi:ss'),'5046','20240414013268','1','C','H0001049','尿液分析','/','1','次','0411','6','6','0','1','C','022','300','1.0000','6.0000','8','','0','辛俊英','0330','0','尿常规','JY001411','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________ 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('2024/4/9 17:52:54','yyyy/mm/dd hh24:mi:ss'),'5047','100368986','0','','0330','辛俊英','20240414013268','202404092169') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________ 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('2024/04/14 15:19:54','yyyy/mm/dd hh24:mi:ss'),'5047','20240414013268','1','E','D0911014','胎心监测','/','1','次','0330','3','3','0','1','B','016','900','1.0000','3.0000','9','','0','辛俊英','0330','0','胎心监测','11687','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________ 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('2024/04/14 15:19:54','yyyy/mm/dd hh24:mi:ss'),'5047','20240414013268','2','D','D0911069','胎心监护仪下胎心监测 ','/','1','次','0330','40','40','0','1','J','044','150','1.0000','40.0000','10','','0','辛俊英','0330','0','胎心监护仪下胎心监测 ','D0911069','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________ 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('2024/04/14 15:19:54','yyyy/mm/dd hh24:mi:ss'),'5047','20240414013268','3','E','D0911011','产前检查','/','1','次','0330','5','5','0','1','J','044','150','1.0000','5.0000','11','','0','辛俊英','0330','0','产前检查','11684','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240414013268','1','微信','54','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14010613' and presc_no = '0' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14010614' and presc_no = '0' and item_no = '9' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14010614' and presc_no = '0' and item_no = '10' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14010614' and presc_no = '0' and item_no = '11' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14010613' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14010614' and item_no = '9' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14010614' and item_no = '10' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14010614' and item_no = '11' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14010613' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14010614' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14010614' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14010614' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '4930371' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2404148791' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2404140176' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE exam_appoints SET costs='171.30',charges='171.30',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE exam_appoints SET costs='320',charges='320',BILLING_INDICATOR='1' WHERE EXAM_NO = '4930371' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE exam_appoints SET costs='152',charges='152',BILLING_INDICATOR='1' WHERE EXAM_NO = '2404148791' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE exam_appoints SET costs='6',charges='6',BILLING_INDICATOR='1' WHERE EXAM_NO = '2404140176' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100368986' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100368986' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100368986' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:19:55 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100368986') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2024-04-14 15:19:55 记录内容:2024-04-14 15:19:55 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2024-04-14 15:19:55 记录内容:1成功120240414013268 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2024-04-14 15:19:55 记录内容:2024-04-14 15:19:55 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2024-04-14 15:25:08 记录内容:cyys_2017@123cyys_2017@12310665732106657321401061759.11001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2024-04-14 15:25:08 记录内容:'14010617' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2024-04-14 15:25:08 记录内容:2024-04-14 15:25:08 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2024-04-14 15:25:08 记录内容:2024-04-14 15:25:08 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:25:09 记录内容:__________ 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 ('20240414013275','10665732','刘桂方','一般人员','自费',to_date('2024/04/14 15:25:08','yyyy/mm/dd hh24:mi:ss'),'59.11','59.11','LIU GUI FANG ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:25:09 记录内容:__________ 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('2024/04/14 15:25:08','yyyy/mm/dd hh24:mi:ss'),'5030','050101','10665732','刘桂方','','一般人员','自费','0','门诊处方','0','1','59.11','59.11','0312','LIG','李刚','LIG','20240414013275','1','202404144666','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:25:09 记录内容:__________ 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('2024-04-14 15:25:08', 'yyyy-mm-dd hh24:mi:ss'),'5030','1','20116064720','1片(10cm*14cm)*10','神农镇痛膏','湛江吉民','1片(10cm*14cm)*10','盒','1','59.11','59.11','1;片;外用;1/日','1','1','1','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:25:09 记录内容:__________ 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('2024/4/14 14:45:16','yyyy/mm/dd hh24:mi:ss'),'5133','10665732','1','门诊处方','0312','李刚','20240414013275','202404144545') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:25:09 记录内容:__________ 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('2024/04/14 15:25:08','yyyy/mm/dd hh24:mi:ss'),'5133','20240414013275','1','A','20116064720','神农镇痛膏','1片(10cm*14cm)*10湛江吉民','1','盒','050101','59.11','59.11','0','1','A','032','200','1.0000','59.1100','1','1;片;外用;1/日','0','李刚','0312','0','神农镇痛膏','20116064720','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:25:09 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240414013275','1','微信','59.11','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:25:09 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14010617' and presc_no = '5030' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:25:09 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14010617' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:25:09 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10665732' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:25:09 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10665732' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:25:09 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10665732' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 15:25:09 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10665732') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2024-04-14 15:25:09 记录内容:2024-04-14 15:25:09 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2024-04-14 15:25:09 记录内容:1成功120240414013275 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2024-04-14 15:25:09 记录内容:2024-04-14 15:25:09 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2024-04-14 16:32:16 记录内容:cyys_2017@123cyys_2017@12310572809105728091401107130.59001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2024-04-14 16:32:16 记录内容:'14011071' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2024-04-14 16:32:16 记录内容:2024-04-14 16:32:16 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2024-04-14 16:32:16 记录内容:2024-04-14 16:32:16 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 16:32:17 记录内容:__________ 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 ('20240414013498','10572809','王美然','一般人员','自费',to_date('2024/04/14 16:32:16','yyyy/mm/dd hh24:mi:ss'),'30.59','30.59','WANG MEI RAN ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 16:32:17 记录内容:__________ 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('2024/04/14 16:32:16','yyyy/mm/dd hh24:mi:ss'),'5813','050101','10572809','王美然','','一般人员','自费','0','门诊处方','0','1','30.59','30.59','0315','FX2','房霞','FX2','20240414013498','1','202404147386','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 16:32:17 记录内容:__________ 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('2024-04-14 16:32:16', 'yyyy-mm-dd hh24:mi:ss'),'5813','1','11005003390','10mg*50','[进]甲巯咪唑片','德国默克','10mg*50','盒','1','30.59','30.59','10;mg;口服;2/日','1','1','10','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 16:32:17 记录内容:__________ 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('2024/4/14 8:21:43','yyyy/mm/dd hh24:mi:ss'),'5819','10572809','1','门诊处方','0315','房霞','20240414013498','202404147386') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 16:32:17 记录内容:__________ 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('2024/04/14 16:32:16','yyyy/mm/dd hh24:mi:ss'),'5819','20240414013498','1','A','11005003390','[进]甲巯咪唑片','10mg*50德国默克','1','盒','050101','30.59','30.59','0','1','C','022','300','1.0000','30.5900','1','10;mg;口服;2/日','0','房霞','0315','0','[进]甲巯咪唑片','11005003390','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 16:32:17 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240414013498','1','微信','30.59','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 16:32:17 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14011071' and presc_no = '5813' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 16:32:17 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14011071' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 16:32:17 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 16:32:17 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2404149014' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 16:32:17 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2404149028' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 16:32:17 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2404149026' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 16:32:17 记录内容:__________UPDATE exam_appoints SET costs='10.62',charges='10.62',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 16:32:17 记录内容:__________UPDATE exam_appoints SET costs='120',charges='120',BILLING_INDICATOR='1' WHERE EXAM_NO = '2404149014' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 16:32:17 记录内容:__________UPDATE exam_appoints SET costs='24',charges='24',BILLING_INDICATOR='1' WHERE EXAM_NO = '2404149028' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 16:32:17 记录内容:__________UPDATE exam_appoints SET costs='49',charges='49',BILLING_INDICATOR='1' WHERE EXAM_NO = '2404149026' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 16:32:17 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10572809' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 16:32:17 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10572809' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 16:32:17 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10572809' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-04-14 16:32:17 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10572809') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2024-04-14 16:32:17 记录内容:2024-04-14 16:32:17 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2024-04-14 16:32:17 记录内容:1成功120240414013498 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2024-04-14 16:32:17 记录内容:2024-04-14 16:32:17 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆