--VERSION=43
ALTER TABLE public.fich_err_ent ALTER tot_hon TYPE numeric(9,2);
ALTER TABLE public.fich_err_somm_fin ALTER tot_hon TYPE numeric(9,2);
--VERSION=44
ALTER TABLE preferences.securite ALTER active_process TYPE character varying(60000);
ALTER TABLE appointment.appointment ADD COLUMN is_deleted integer NOT NULL DEFAULT 0;
ALTER TABLE billingnb.service ADD COLUMN end_date bigint NOT NULL DEFAULT 4105141199000;
ALTER TABLE billingnb.service ALTER COLUMN category SET DEFAULT '0000';

update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0001');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0001'),'GP Visite au cabinet','0001',28,1238558400000,4105141199000);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0015');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0015'),'Examen prénatal complet','0015',38,1238558400004,4105141199004);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0016');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0016'),'Visites pré et ou postnatales','0016',28,1238558400008,4105141199008);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0019');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0019'),'Soins du bébé normal','0019',28,1238558400012,4105141199012);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0026');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0026'),'Examen d’une nouvelle affection pour la première fois','0026',46,1238558400016,4105141199016);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0027');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0027'),'Première visite comportant un examen spécifique','0027',31,1238558400020,4105141199020);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0028');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0028'),'Visite subséquente comportant un examen complet','0028',46,1238558400024,4105141199024);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0029');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0029'),'Visites au cabinet','0029',40,1238558400028,4105141199028);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0033');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0033'),'Consultation subséquente dans les 30 jours, pour la même maladie','0033',65,1238558400032,4105141199032);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0035');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0035'),'Première visite comportant un examen complet','0035',71,1238558400036,4105141199036);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0036');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0036'),'Première visite comportant un examen spécifique','0036',47,1238558400040,4105141199040);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0037');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0037'),'Visite subséquente comportant un réexamen complet','0037',47,1238558400044,4105141199044);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0038');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0038'),'Autres visites en cabinet','0038',44,1238558400048,4105141199048);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0041');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0041'),'Consultation majeure ou spécifique','0041',124,1238558400052,4105141199052);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0042');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0042'),'Consultation subséquente dans les 30 jours','0042',95,1238558400056,4105141199056);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0048');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0048'),'Première visite comportant un examen complet','0048',48,1238558400060,4105141199060);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0049');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0049'),'Première visite comportant un examen spécifique','0049',38,1238558400064,4105141199064);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0050');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0050'),'Autre visites en cabinet','0050',38,1238558400068,4105141199068);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0054');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0054'),'Consultation majeure ou spécifique','0054',66,1238558400072,4105141199072);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0056');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0056'),'Consultation subséquente dans les 30 jours','0056',35,1238558400076,4105141199076);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0064');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0064'),'Première visite avec examen ophtalmologique complet','0064',45,1238558400080,4105141199080);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0065');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0065'),'Première visite n’exigeant pas d’examen complet','0065',28,1238558400084,4105141199084);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0066');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0066'),'Autre visites en cabinet sans tests ou actes spéciaux','0066',29,1238558400088,4105141199088);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0071');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0071'),'Consultation subséquente dans les 30 jours','0071',46,1238558400092,4105141199092);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0076');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0076'),'Examen d’une nouvelle affection pour la première fois','0076',51,1238558400096,4105141199096);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0077');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0077'),'Première visite comportant un examen spécifique','0077',40,1238558400100,4105141199100);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0078');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0078'),'Autre visites en cabinet','0078',40,1238558400104,4105141199104);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0081');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0081'),'Consultation majeure ou spécifique','0081',78,1238558400108,4105141199108);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0083');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0083'),'Consultation subséquente dans les 30 jours','0083',48,1238558400112,4105141199112);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0085');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0085'),'Première visite comportant un examen complet','0085',66,1238558400116,4105141199116);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0086');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0086'),'Première visite comportant un examen spécifique','0086',50,1238558400120,4105141199120);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0087');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0087'),'Autre visites en cabinet','0087',45,1238558400124,4105141199124);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0089');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0089'),'Soins d’un bébé normal comportant un examen','0089',50,1238558400128,4105141199128);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0090');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0090'),'Visite subséquente, troubles de santé majeurs chroniques','0090',87,1238558400132,4105141199132);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0092');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0092'),'Soins du nouveau-né normal pendant les 10 premiers jours','0092',64,1238558400136,4105141199136);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0093');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0093'),'Consultation majeure ou spécifique','0093',142,1238558400140,4105141199140);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0094');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0094'),'Consultation subséquente dans les 30 jours','0094',88,1238558400144,4105141199144);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0100');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0100'),'Consultation majeure ou spécifique','0100',123,1238558400148,4105141199148);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0101');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0101'),'Consultation subséquente dans les 30 jours','0101',56,1238558400152,4105141199152);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0102');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0102'),'Première visite exigeant les antécédents complets et un examen détaillé','0102',46,1238558400156,4105141199156);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0103');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0103'),'Première visite n’exigeant pas d’examen complet','0103',34,1238558400160,4105141199160);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0104');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0104'),'Autre visites en cabinet','0104',33,1238558400164,4105141199164);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0107');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0107'),'Consultation majeure ou spécifique','0107',79,1238558400168,4105141199168);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0109');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0109'),'L Consultation subséquente dans les 30 jours','0109',48,1238558400172,4105141199172);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0119');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0119'),'Première visite comportant un examen dermatologique complet','0119',35,1238558400176,4105141199176);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0120');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0120'),'Première visite comportant un examen spécifique','0120',30,1238558400180,4105141199180);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0121');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0121'),'Autre visites en cabinet','0121',30,1238558400184,4105141199184);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0125');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0125'),'Consultation majeure ou spécifique','0125',72,1238558400188,4105141199188);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0126');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0126'),'Consultation subséquente dans les 30 jours','0126',58,1238558400192,4105141199192);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0134');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0134'),'Biopsie cutanée diagnostique','0134',33,1238558400196,4105141199196);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0156');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0156'),'Première visite comportant un examen complet','0156',75,1238558400200,4105141199200);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0157');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0157'),'Visite subséquente comportant un réexamen complet','0157',41,1238558400204,4105141199204);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0159');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0159'),'Autre visites en cabinet','0159',39,1238558400208,4105141199208);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0160');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0160'),'Visite subséquente pour réévaluation complète','0160',63,1238558400212,4105141199212);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0162');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0162'),'Consultation subséquente dans les 30 jours','0162',60,1238558400216,4105141199216);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0194');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0194'),'Entretien thérapeutique, par tranche de 15 minutes','0194',44,1238558400220,4105141199220);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0201');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0201'),'Évaluation de l’aptitude à subir une anesthésie','0201',32,1238558400224,4105141199224);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0202');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0202'),'Consultation majeure ou spécifique','0202',100,1238558400228,4105141199228);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0203');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0203'),'Première visite comportant un examen spécifique','0203',27,1238558400232,4105141199232);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0217');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0217'),'Consultation pré-anesthésique – spécialiste','0217',75,1238558400236,4105141199236);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0218');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0218'),'Consultation pré-anesthésique – non-spécialiste','0218',39,1238558400240,4105141199240);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0239');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0239'),'Counseling familial, par tranche de 15 minutes','0239',44,1238558400244,4105141199244);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0287');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0287'),'Consultation subséquente dans les 30 jours','0287',67,1238558400248,4105141199248);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0288');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0288'),'Première visite comportant un examen complet','0288',45,1238558400252,4105141199252);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0289');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0289'),'Première visite comportant un examen spécifique','0289',38,1238558400256,4105141199256);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0290');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0290'),'Autres visites en cabinet','0290',38,1238558400260,4105141199260);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0305');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0305'),'Consultation majeure ou spécifique','0305',58,1238558400264,4105141199264);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0306');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0306'),'Consultation subséquente dans les 30 jours','0306',31,1238558400268,4105141199268);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0307');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0307'),'Première visite, selon la complexité du cas et le temps en cause','0307',40,1238558400272,4105141199272);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0308');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0308'),'Autres visites en cabinet','0308',35,1238558400276,4105141199276);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0321');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0321'),'Consultation majeure ou spécifique','0321',182,1238558400280,4105141199280);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0322');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0322'),'onsultation subséquente dans les 30 jours','0322',77,1238558400284,4105141199284);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0324');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0324'),'Première visite comportant un examen complet','0324',111,1238558400288,4105141199288);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0325');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0325'),'Autres visites en cabinet','0325',40,1238558400292,4105141199292);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0331');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0331'),'Soins psychiatriques – évaluation et traitement, par quart d’heure.','0331',39,1238558400296,4105141199296);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0332');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0332'),'Psychothérapie, par quart d’heure','0332',39,1238558400300,4105141199300);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0340');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0340'),'Entrevue à des fins diagnostiques ou thérapeutiques, par quart d’heure','0340',39,1238558400304,4105141199304);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0341');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0341'),'Soins psychiatriques ou psychothérapie de groupe, par quart d’heure','0341',41,1238558400308,4105141199308);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0343');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0343'),'Consultation majeure ou spécifique','0343',64,1238558400312,4105141199312);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0345');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0345'),'Consultation subséquente dans les 30 jours','0345',41,1238558400316,4105141199316);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0346');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0346'),'Examen d’une nouvelle affection pour la première fois','0346',43,1238558400320,4105141199320);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0347');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0347'),'Première visite comportant un examen spécifique seulement','0347',37,1238558400324,4105141199324);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0349');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0349'),'Autres visites en cabinet','0349',37,1238558400328,4105141199328);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '0835');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '0835'),'Hystérectomie vaginale assistée par laparoscopie','0835',485,1238558400332,4105141199332);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '1084');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '1084'),'Consultation subséquente','1084',38,1238558400336,4105141199336);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '1456');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '1456'),'Hystérectomie vaginale','1456',374,1238558400340,4105141199340);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '1457');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '1457'),'Hystérectomie par voie abdominale ou vaginale avec réparation','1457',462,1238558400344,4105141199344);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '1458');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '1458'),'Hystérectomie sous-totale','1458',239,1238558400348,4105141199348);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '1459');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '1459'),'Hystérectomie sous-totale avec réparation','1459',319,1238558400352,4105141199352);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '1460');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '1460'),'Hystérectomie radicale (Wertheim)','1460',610,1238558400356,4105141199356);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '1499');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '1499'),'Autres visites en cabinet','1499',33,1238558400360,4105141199360);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '1652');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '1652'),'Aspiration d’humeur vitrée','1652',92,1238558400364,4105141199364);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '1817');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '1817'),'Hystérectomie avec stratification','1817',530,1238558400368,4105141199368);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2020');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2020'),'Soins de jour – premier patient (visite faite sur appel)','2020',27,1238558400372,4105141199372);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2021');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2021'),'Soins de jour – patient additionnel','2021',23,1238558400376,4105141199376);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2173');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2173'),'Soins à l’hôpital – première visite, évaluation majeure le jour de l’admission','2173',37,1238558400380,4105141199380);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2174');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2174'),'Soins à l’hôpital – soins subséquents – du 2e au 30e jour, par jour','2174',20,1238558400384,4105141199384);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2175');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2175'),'Soins à l’hôpital – date du congé','2175',31,1238558400388,4105141199388);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2176');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2176'),'Soins à l’hôpital – soins subséquents – après 30 jours, par jour','2176',14,1238558400392,4105141199392);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2255');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2255'),'Soins à l’hôpital – première visite, évaluation majeure le jour de l’admission','2255',68,1238558400396,4105141199396);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2256');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2256'),'Soins à l’hôpital – soins subséquents – du 2e au 30e jour, par jour','2256',20,1238558400400,4105141199400);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2257');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2257'),'Soins à l’hôpital – date du congé','2257',31,1238558400404,4105141199404);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2258');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2258'),'Soins à l’hôpital – soins subséquents – après 30 jours, par jour','2258',13,1238558400408,4105141199408);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2381');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2381'),'Soins à l’hôpital – première visite, évaluation majeure le jour de l’admission','2381',46,1238558400412,4105141199412);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2382');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2382'),'Soins à l’hôpital – soins subséquents – du 2e au 30e jour, par jour','2382',21,1238558400416,4105141199416);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2383');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2383'),'Soins à l’hôpital – date du congé','2383',31,1238558400420,4105141199420);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2384');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2384'),'Soins à l’hôpital – soins subséquents – après 30 jours, par jour','2384',14,1238558400424,4105141199424);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2401');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2401'),'Soins à l’hôpital – première visite, évaluation majeure le jour de l’admission','2401',80,1238558400428,4105141199428);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2402');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2402'),'Soins à l’hôpital – soins subséquents – du 2e au 30e jour, par jour','2402',24,1238558400432,4105141199432);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2404');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2404'),'Soins à l’hôpital – soins subséquents – après 30 jours, par jour','2404',15,1238558400436,4105141199436);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2411');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2411'),'Soins à l’hôpital – première visite, évaluation majeure le jour de l’admission','2411',46,1238558400440,4105141199440);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2412');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2412'),'Soins à l’hôpital – soins subséquents – du 2e au 30e jour, par jour','2412',21,1238558400444,4105141199444);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2413');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2413'),'Soins à l’hôpital – date du congé','2413',31,1238558400448,4105141199448);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2414');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2414'),'Soins à l’hôpital – soins subséquents – après 30 jours, par jour','2414',14,1238558400452,4105141199452);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2421');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2421'),'Soins à l’hôpital – première visite, évaluation majeure le jour de l’admission','2421',47,1238558400456,4105141199456);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2422');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2422'),'Soins à l’hôpital – soins subséquents – du 2e au 30e jour, par jour','2422',22,1238558400460,4105141199460);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2423');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2423'),'Soins à l’hôpital – date du congé','2423',31,1238558400464,4105141199464);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2424');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2424'),'Soins à l’hôpital – soins subséquents – après 30 jours, par jour','2424',14,1238558400468,4105141199468);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2431');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2431'),'Soins à l’hôpital – première visite, évaluation majeure le jour de l’admission','2431',47,1238558400472,4105141199472);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2432');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2432'),'Soins à l’hôpital – soins subséquents – du 2e au 30e jour, par jour','2432',22,1238558400476,4105141199476);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2433');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2433'),'Soins à l’hôpital – date du congé','2433',31,1238558400480,4105141199480);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2434');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2434'),'Soins à l’hôpital – soins subséquents – après 30 jours, par jour','2434',14,1238558400484,4105141199484);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2441');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2441'),'Soins à l’hôpital – première visite, évaluation majeure le jour de l’admission','2441',51,1238558400488,4105141199488);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2442');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2442'),'Soins à l’hôpital – soins subséquents – du 2e au 30e jour, par jour','2442',23,1238558400492,4105141199492);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2444');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2444'),'Soins à l’hôpital – soins subséquents – après 30 jours, par jour','2444',16,1238558400496,4105141199496);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2443');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2443'),'Soins à l’hôpital – date du congé','2443',31,1238558400500,4105141199500);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2451');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2451'),'Soins à l’hôpital – première visite, évaluation majeure le jour de l’admission','2451',103,1238558400504,4105141199504);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2453');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2453'),'Soins à l’hôpital – soins subséquents – du 2e au 30e jour, par jour','2453',25,1238558400508,4105141199508);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2455');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2455'),'Soins à l’hôpital – soins subséquents – après 30 jours, par jour','2455',16,1238558400512,4105141199512);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2461');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '1461'),'Soins à l’hôpital – première visite, évaluation majeure le jour de l’admission','2461',42,1238558400516,4105141199516);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2462');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2462'),'Soins à l’hôpital – soins subséquents – du 2e au 30e jour, par jour','2462',19,1238558400520,4105141199520);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2463');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2463'),'Soins à l’hôpital – date du congé','2463',31,1238558400524,4105141199524);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2464');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2464'),'Soins à l’hôpital – après 30 jours, par jour','2464',13,1238558400528,4105141199528);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2471');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2471'),'Soins à l’hôpital – première visite, évaluation majeure le jour de l’admission','2471',107,1238558400532,4105141199532);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2472');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2472'),'Soins à l’hôpital – soins subséquents – du 2e au 30e jour, par jour','2472',24,1238558400536,4105141199536);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2473');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2473'),'Soins à l’hôpital – date du congé','2473',31,1238558400540,4105141199540);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2474');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2474'),'Soins à l’hôpital – soins subséquents – après 30 jours, par jour','2474',15,1238558400544,4105141199544);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2481');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2481'),'Soins à l’hôpital – première visite, évaluation majeure le jour de l’admission','2481',44,1238558400548,4105141199548);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2482');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2482'),'Soins à l’hôpital – soins subséquents – du 2e au 30e jour, par jour','2482',20,1238558400552,4105141199552);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2483');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2483'),'Soins à l’hôpital – date du congé','2483',31,1238558400556,4105141199556);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2484');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2484'),'Soins à l’hôpital – soins subséquents – après 30 jours, par jour','2484',13,1238558400560,4105141199560);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2491');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2491'),'Soins à l’hôpital – première visite, évaluation majeure le jour de l’admission','2491',68,1238558400564,4105141199564);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2492');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2492'),'Soins à l’hôpital – soins subséquents - du 2e au 30e jour, par jour','2492',20,1238558400568,4105141199568);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2493');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2493'),'Soins à l’hôpital – date du congé','2493',31,1238558400572,4105141199572);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2494');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2494'),'Soins à l’hôpital – soins subséquents – après 30 jours, par jour','2494',16,1238558400576,4105141199576);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2501');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2501'),'Soins à l’hôpital – première visite, évaluation majeure le jour de l’admission','2501',68,1238558400580,4105141199580);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2502');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2502'),'Soins à l’hôpital – soins subséquents – du 2e au 30e jour, par jour','2502',21,1238558400584,4105141199584);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2503');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2503'),'Soins à l’hôpital – date du congé','2503',31,1238558400588,4105141199588);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2504');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2504'),'Soins à l’hôpital – soins subséquents – après 30 jours, par jour','2504',13,1238558400592,4105141199592);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2831');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2831'),'Soins de nuit et en fin de semaine – premier patient soigné (par un médecin qui n’assure pas le service prévu sur place) dans un hôpital où l’on assure le service sur place','2831',39,1238558400596,4105141199596);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2832');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2832'),'Soins de nuit et en fin de semaine – patient additionnel, tout hôpital','2832',28,1238558400600,4105141199600);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2837');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2837'),'Soins psychiatriques ou psychothérapie familiale, par quart d’heure','2837',41,1238558400604,4105141199604);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2854');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2854'),'Soins de nuit et en fin de semaine – premier patient soigné dans un hôpital sans services sur place','2854',91,1238558400608,4105141199608);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2925');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2925'),'Soins de jour – premier patient – visite spéciale provenant du cabinet sur place','2925',23,1238558400612,4105141199612);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2926');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2026'),'Soins de nuit et en fin de semaine – premier patient soigné dans un hôpital – médecin se déplaçant de son cabinet sur place','2926',39,1238558400616,4105141199616);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2927');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2927'),'Soins à l’hôpital – première visite, évaluation majeure le jour de l’admission','2927',68,1238558400620,4105141199620);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2928');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2928'),'Soins à l’hôpital – soins subséquents – du 2e au 30e jour, par jour','2928',21,1238558400624,4105141199624);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2929');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2929'),'Soins à l’hôpital – soins subséquents – après 30 jours, par jour','2929',13,1238558400628,4105141199628);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '2974');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '2974'),'Suspension sacro-sciatique du dôme vaginal, en supplément','2974',150,1238558400632,4105141199632);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '3206');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '3206'),'Mammographie de dépistage bilatérale - femme asymptomatique','3206',19,1238558400636,4105141199636);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '3311');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '3311'),'Rappel à l’hôpital, de nuit ou les fins de semaine','3311',27,1238558400640,4105141199640);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8101');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8101'),'MG Visite en cabinet pour les personnes âgées (réduction de l’âge du patient de 75+ à 70+)','8101',35,1238558400644,4105141199644);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8106');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8106'),'MG/IP Examen en vue d’un aiguillage','8106',28,1238558400648,4105141199648);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8112');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8112'),'Soins à l’hôpital – date du congé','8112',31,1238558400652,4105141199652);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8144');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8144'),'Soins à l’hôpital – date du congé','8144',31,1238558400656,4105141199656);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8214');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8214'),'Soins à l’hôpital – date du congé','8214',31,1238558400660,4105141199660);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8242');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8242'),'Première visite en cabinet comportant un examen complet','8242',64,1238558400664,4105141199664);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8243');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8243'),'Première visite en cabinet comportant un examen spécifique','8243',43,1238558400668,4105141199668);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8244');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8244'),'Visite subséquente comportant un réexamen complet','8244',43,1238558400672,4105141199672);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8245');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8245'),'Autre visites en cabinet','8245',37,1238558400676,4105141199676);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8246');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8246'),'Soins à l’hôpital – date du congé','8246',31,1238558400680,4105141199680);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8310');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8310'),'Consultation majeure ou spécifique','8310',119,1238558400684,4105141199684);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8311');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8311'),'Consultation subséquente dans les 30 jours','8311',64,1238558400688,4105141199688);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8312');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8312'),'Soins à l’hôpital – première visite, évaluation majeure le jour de l’admission','8312',77,1238558400692,4105141199692);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8313');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8313'),'Soins à l’hôpital – soins subséquents – du 2e au 30e jour, par jour','8313',23,1238558400696,4105141199696);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8314');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8314'),'Soins à l’hôpital – soins subséquents – après 30 jours, par jour','8314',14,1238558400700,4105141199700);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8315');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8315'),'Consultation majeure ou spécifique','8315',117,1238558400704,4105141199704);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8317');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8317'),'Soins à l’hôpital – première visite, évaluation majeure le jour de l’admission','8317',78,1238558400708,4105141199708);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8318');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8318'),'Soins à l’hôpital – soins subséquents – du 2e au 30e jour, par jour','8318',24,1238558400712,4105141199712);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8319');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8319'),'Soins à l’hôpital – soins subséquents – après 30 jours, par jour','8319',15,1238558400716,4105141199716);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8320');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8320'),'Soins à l’hôpital – première visite, évaluation majeure le jour de l’admission','8320',47,1238558400720,4105141199720);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8321');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8321'),'Soins à l’hôpital – soins subséquents – du 2e au 30e jour, par jour','8321',22,1238558400724,4105141199724);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8322');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8322'),'Soins à l’hôpital – soins subséquents – après 30 jours, par jour','8322',14,1238558400728,4105141199728);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8327');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8327'),'Soins à l’hôpital – date du congé','8327',31,1238558400732,4105141199732);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8343');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8343'),'Soins à l’hôpital – date du congé','8343',31,1238558400736,4105141199736);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8700');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8700'),'Hystérectomie totale par voie abdominale','8700',380,1238558400740,4105141199740);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8997');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8997'),'Deuxième appel','8997',139,1238558400744,4105141199744);
update billingnb.service set end_date=1238558399000 where id = (select id from billingnb.service where code = '8999');
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),(select category from billingnb.service where code = '8999'),'Service de garde autorisé','8999',139,1238558400748,4105141199748);



insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),'1000','Soins généraux de télémédecine – premier patient, premier quart d’heure','8717',40,1258693199000,4105141199759);
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),'1000','Soins généraux de télémédecine, par quart d’heure','8718',20,1258693199000,4105141199759);
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),'1000','Service de garde pour aide technique de télémédecine, par quart d’heure','8719',20,1258693199000,4105141199759);
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),'1000','MG Consult. à l''étage pour pt admis','8110',36,1258693199000,4105141199759);
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),'1000','Présence à l’accouchement (médecine générale)','8715',330,1258693199000,4105141199759);
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),'1000','Consult. (pt 70 + ayant path. mult.)','8901',15,1258693199000,4105141199759);

insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),'1000','Allocation de déplacement','8889',25,1258693199000,4105141199759);

insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),'1000','Clin. de Déplacement/télémed-1er pt/add','8898',0,1258693199000,4105141199759);
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),'1000','Consult-Déplacement/télémed 1er pt/add','8899',0,1258693199000,4105141199759);

insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),'1000','Consult. tél. (prison)','8883',10,1258693199000,4105141199759);
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),'1000','Consult. tél. (sage-femme)','8884',10,1258693199000,4105141199759);
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),'1000','Consult. à dist. (éq. interv. rapide SM)','8885',10,1258693199000,4105141199759);
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),'3000','Présence médicale durant le travail -jusqu’à l''accouchement','8715',330,1258693199000,4105141199759);
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),'3000','Quadrivalent HPV(avec visite)','8525',8,1258693199000,4105141199759);
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),'3000','Quadrivalent HPV (sans visite)','8575',13,1258693199000,4105141199759);
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),'3000','H1N1 influenza (avec visite)','8526',8,1258693199000,4105141199759);
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),'3000','H1N1 influenza (sans visite)','8576',13,1258693199000,4105141199759);
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),'1000','Consultation tél. (médecin)','8995',10,1258693199000,4105141199759);
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),'1000','Consultation tél. (infirmier(e))','8994',10,1258693199000,4105141199759);
insert into billingnb.service (id,category,description,code,base_unit,start_date,end_date) values ((SELECT nextval('billingnb.service_seq')),'1000','Consultation tél. (pharmacien)','8993',10,1258693199000,4105141199759);

update billingnb.service set description=upper(description);
