shu
/
DPM2016
1
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
DPM2016/2018_Datenmigration_Definitiv/DPM_Update/Version 20180824_DH/tarife.sql

70 lines
51 KiB
Raw Permalink Blame History Escape

This file contains invisible Unicode characters!

This file contains invisible Unicode characters that may be processed differently from what appears below. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to reveal hidden characters.


INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9000, 13, N'9100', N'Anamnese / Befundaufnahme neuer Patient', N'', N'', 9, 9, 9, 9, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9001, 13, N'9101', N'Anamnese / Befundaufnahme Recall-Patient', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9002, 13, N'9102', N'Mundhygiene Instruktion, Information, Motivierung pro 5 Min.', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9003, 13, N'9103', N'Parodontalstatus pro 5 Min.', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9004, 13, N'9104', N'Hygiene- und Entzündungsstatus pro 5 Min.', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9005, 13, N'9105', N'Für weitere Indices freilassen', N'', N'', 0, 0, 0, 0, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9006, 13, N'9106', N'Für weitere Indices freilassen', N'', N'', 0, 0, 0, 0, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9007, 13, N'9110', N'Zahnmedizinische Ernährungsberatung pro 5 Min.', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9008, 13, N'9111', N'Raucherintervention pro 5 Min.', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9009, 13, N'9112', N'Instruktion Eltern / Kind pro 5 Min.', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9010, 13, N'9113', N'Erosionsberatung pro 5 Min.', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9011, 13, N'9114', N'Gruppenprophylaxe, Öffentlichkeitsarbeit ', N'', N'', 0, 0, 0, 0, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9012, 13, N'9115', N'Fotoaufnahme pro 5 Min.', N'', N'', 8, 8, 8, 8, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9013, 13, N'9116', N'Fotoausdruck pr Bild', N'', N'', 0, 0, 0, 0, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9014, 14, N'9200', N'Zahnsteinentfernung, Politur pro 5 Min.', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9015, 14, N'9201', N'Nicht chirurgische Parodontaltherapie pro 5 Min.', N'', N'', 7, 7, 7, 7, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9016, 14, N'9202', N'Parodontale Nachbehandlung pro 5 Min.', N'', N'', 6, 6, 6, 6, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9017, 14, N'9203', N'Präventive Behandlung / Honorierung nach Zeitaufwand pro 5 Min.', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9018, 14, N'9204', N'Bakteriologischer Test (exkl. Material und Labor) ', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9019, 14, N'9205', N'Speicheltest (exkl. Material und Labor) pro 5 Min.', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9020, 14, N'9206', N'Full Mouth Disinfection inkl. Material pro 5 Min.', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9021, 14, N'9207', N'Vitalitätstest 1-6 Zähne', N'', N'', 4, 4, 4, 4, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9022, 14, N'9208', N'Vitalitätstest pro 5 Min.', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9023, 14, N'9209', N'Desensibilisierung (exkl. Material) pro 5 Min.', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9024, 14, N'9210', N'Fluoridierung (exkl. Material) pro 5 Min.', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9025, 14, N'9211', N'Überschussentfernung / Flg. Politur /Rekonturieren pro 5 Min.', N'', N'', 7, 7, 7, 7, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9026, 14, N'9212', N'Provisorische Füllung pro Zahn', N'', N'', 7, 7, 7, 7, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9027, 14, N'9213', N'Krone provisorisch rezementieren pro Zahn', N'', N'', 10, 10, 10, 10, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9028, 14, N'9214', N'Kofferdam pro Quadrant', N'', N'', 7, 7, 7, 7, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9029, 14, N'9215', N'Fissurenversiegelung pro Zahn', N'', N'', 10, 10, 10, 10, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9030, 14, N'9216', N'Abformung des Kiefers pro Kiefer', N'', N'', 6, 6, 6, 6, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9031, 14, N'9217', N'Weitere Therapien', N'', N'', 0, 0, 0, 0, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9032, 14, N'9220', N'Home Bleaching inkl. Abdrücke (exkl. Schiene )', N'', N'', 0, 0, 0, 0, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9033, 14, N'9221', N'Powerbleaching (exkl. Material) pro 5 Min.', N'', N'', 12, 12, 12, 12, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9034, 14, N'9222', N'Powerbleaching (exkl. Material) Full mouth', N'', N'', 0, 0, 0, 0, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9035, 14, N'9223', N'Bleaching Nachkontrolle pro 5 Min.', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9036, 14, N'9224', N'Zahnschmuck pro Zahn (exkl. Material) pro Zahn', N'', N'', 0, 0, 0, 0, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9037, 14, N'9225', N'Prothesenpflege pro 5 Min,', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9038, 14, N'9226', N'Empfehlungen Komplementärmedizin pro 5 Min.', N'', N'', 0, 0, 0, 0, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
GO
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9039, 15, N'9300', N'Versäumte Sitzung pro 5 Min.', N'', N'', 4, 4, 4, 4, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9040, 15, N'9301', N'Praxis externe Behandlung pro 5 Min.', N'', N'', 6, 6, 6, 6, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9041, 15, N'9302', N'Praxis externe Behandlung, Weg pro 5 Min.', N'', N'', 6, 6, 6, 6, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9042, 15, N'9303', N'Überweisungsschreiben / Zeugnis / Bericht / KV pro 5 Min.', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9043, 15, N'9304', N'Telefonische Beratung / Auskünfte / interdisziplinäre Informationen pro 5 Min.', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9044, 15, N'9305', N'Konsultation mit Zahnarzt / Arzt pro 5 Min.', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9045, 15, N'9306', N'Vermehrter Zeitaufwand pro 5 Min.', N'', N'', 5, 5, 5, 5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9046, 16, N'9400', N'Diverses Material (Desensibiliserungsmittel, Zahnschmuck, Bleichmittel usw.)', N'', N'', 0, 0, 0, 0, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9047, 16, N'9401', N'Für weitere Indices freilassen', N'', N'', 0, 0, 0, 0, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9048, 17, N'9500', N'z. B. Zahnbürste ', N'', N'', 0, 0, 0, 0, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9049, 17, N'9501', N'Für weitere Indices freilassen', N'', N'', 0, 0, 0, 0, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9050, 18, N'9600', N'Röntgenaufnahme pro Bild', N'', N'', 3, 3, 3, 3, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9051, 18, N'9601', N'Röntgen: Interpretation pro Bild', N'', N'', 3, 3, 3, 3, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9052, 18, N'9602', N'Anästhesie ', N'', N'', 11, 11, 11, 11, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9053, 19, N'9700', N'PA-Behandlung pro 5 Min.', N'', N'', 3, 3, 3, 3, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9054, 19, N'9701', N'Mundhygieneinstruktion durch PA pro 5 Min.', N'', N'', 3, 3, 3, 3, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIF] ([Nrtarif], [Nrtarifgruppe], [SSO_Nummer], [Bezd], [Bezf], [Bezi], [Privattarif], [Suvatarif], [Minimaltarif], [Maximaltarif], [Mitlabor], [Frankenbetrag], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (9055, 19, N'9702', N'Versäumte Sitzung PA pro 5 Min.', N'', N'', 2.5, 2.5, 2.5, 2.5, 0, 0, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[TARIFE] ([Nrtarifgruppe], [Mandant], [Bezeichnung], [Grundlage], [Nummervon], [Nummerbis], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (6, 1, N'DH-Tarif', NULL, 9000, 9999, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[Tarifgrp] ([Nrtarifgruppe], [Tarifgruppe], [Tarifvon], [Tarifbis], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (13, N'Prävenntion', 9100, 9199, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[Tarifgrp] ([Nrtarifgruppe], [Tarifgruppe], [Tarifvon], [Tarifbis], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (14, N'Therapie', 9200, 9299, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[Tarifgrp] ([Nrtarifgruppe], [Tarifgruppe], [Tarifvon], [Tarifbis], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (15, N'Administration', 9300, 9300, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[Tarifgrp] ([Nrtarifgruppe], [Tarifgruppe], [Tarifvon], [Tarifbis], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (16, N'Material', 9400, 9499, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[Tarifgrp] ([Nrtarifgruppe], [Tarifgruppe], [Tarifvon], [Tarifbis], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (17, N'Hilfsmittel', 9500, 5599, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[Tarifgrp] ([Nrtarifgruppe], [Tarifgruppe], [Tarifvon], [Tarifbis], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (18, N'Delegierte Leistungen', 9600, 9699, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
INSERT [dbo].[Tarifgrp] ([Nrtarifgruppe], [Tarifgruppe], [Tarifvon], [Tarifbis], [erstellt_am], [mutiert_am], [mutierer], [aktiv]) VALUES (19, N'Leistungen PA', 9700, 9799, CAST(N'2018-05-05 00:00:00.000' AS DateTime), CAST(N'2018-05-05 00:00:00.000' AS DateTime), 1, 1)
Reference in new issue View Git Blame Copy Permalink