1 #IfMissingColumn pnotes deleted
3 ADD `deleted` TINYINT DEFAULT '0' COMMENT 'flag indicates note is deleted';
6 #IfNotRow list_options list_id adjreason
7 INSERT INTO list_options VALUES ('lists' ,'adjreason' ,'Adjustment Reasons',1,0,0);
8 INSERT INTO list_options VALUES ('adjreason','Adm adjust' ,'Adm adjust' , 5,0,0);
9 INSERT INTO list_options VALUES ('adjreason','After hrs calls','After hrs calls',10,0,0);
10 INSERT INTO list_options VALUES ('adjreason','Bad check' ,'Bad check' ,15,0,0);
11 INSERT INTO list_options VALUES ('adjreason','Bad debt' ,'Bad debt' ,20,0,0);
12 INSERT INTO list_options VALUES ('adjreason','Coll w/o' ,'Coll w/o' ,25,0,0);
13 INSERT INTO list_options VALUES ('adjreason','Discount' ,'Discount' ,30,0,0);
14 INSERT INTO list_options VALUES ('adjreason','Hardship w/o' ,'Hardship w/o' ,35,0,0);
15 INSERT INTO list_options VALUES ('adjreason','Ins adjust' ,'Ins adjust' ,40,0,0);
16 INSERT INTO list_options VALUES ('adjreason','Ins bundling' ,'Ins bundling' ,45,0,0);
17 INSERT INTO list_options VALUES ('adjreason','Ins overpaid' ,'Ins overpaid' ,50,0,0);
18 INSERT INTO list_options VALUES ('adjreason','Ins refund' ,'Ins refund' ,55,0,0);
19 INSERT INTO list_options VALUES ('adjreason','Pt overpaid' ,'Pt overpaid' ,60,0,0);
20 INSERT INTO list_options VALUES ('adjreason','Pt refund' ,'Pt refund' ,65,0,0);
21 INSERT INTO list_options VALUES ('adjreason','Pt released' ,'Pt released' ,70,0,0);
22 INSERT INTO list_options VALUES ('adjreason','Sm debt w/o' ,'Sm debt w/o' ,75,0,0);
23 INSERT INTO list_options VALUES ('adjreason','To copay' ,'To copay' ,80,0,0);
24 INSERT INTO list_options VALUES ('adjreason','To ded\'ble' ,'To ded\'ble' ,85,0,0);
25 INSERT INTO list_options VALUES ('adjreason','Untimely filing','Untimely filing',90,0,0);