USE [Vertragsverwaltung_20160404]
GO
/****** Object:  View [dbo].[AN_Bezeichnung]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[AN_Bezeichnung]
AS
SELECT DISTINCT dbo.TXP_LVer_IN_AU.Ticket_ID, dbo.shu_view_an_excelexport_lst.Kurzbeschreibung
FROM            dbo.shu_view_an_excelexport_lst INNER JOIN
                         dbo.TXP_LVer_IN_AU ON dbo.shu_view_an_excelexport_lst.FullId = dbo.TXP_LVer_IN_AU.Ticket_ID

GO
/****** Object:  View [dbo].[AN_Summe_Ticket_User]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[AN_Summe_Ticket_User]
AS
SELECT        dbo.AN_Bezeichnung.Ticket_ID, dbo.TXP_LVer_IN_AU.ForUserID, dbo.AN_Bezeichnung.Kurzbeschreibung, SUM(dbo.TXP_LVer_IN_AU.CalculatedValue) AS Expr1, 
                         LTRIM(STR(YEAR(dbo.TXP_LVer_IN_AU.ExecutedDateTime))) + '' + LTRIM(STR(MONTH(dbo.TXP_LVer_IN_AU.ExecutedDateTime))) AS jjmm, 
                         dbo.TXP_LVer_IN_AU.Statusdatum
FROM            dbo.TXP_LVer_IN_AU INNER JOIN
                         dbo.AN_Bezeichnung ON dbo.TXP_LVer_IN_AU.Ticket_ID = dbo.AN_Bezeichnung.Ticket_ID
GROUP BY dbo.AN_Bezeichnung.Ticket_ID, dbo.AN_Bezeichnung.Kurzbeschreibung, dbo.TXP_LVer_IN_AU.Statusdatum, dbo.TXP_LVer_IN_AU.ForUserID, 
                         LTRIM(STR(YEAR(dbo.TXP_LVer_IN_AU.ExecutedDateTime))) + '' + LTRIM(STR(MONTH(dbo.TXP_LVer_IN_AU.ExecutedDateTime)))

GO
/****** Object:  View [dbo].[TXP_IN_Geschlossen_Prepare]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[TXP_IN_Geschlossen_Prepare]
AS
SELECT DISTINCT ticketid, statusid
FROM         dbo.get_solved_in(CONVERT(datetime, '2013-01.01 00:00:00', 20), CONVERT(datetime, '2016-04-30 23:59:59', 20)) AS get_solved_in_1

GO
/****** Object:  View [dbo].[TXP_IN_Geschlossen]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[TXP_IN_Geschlossen]
AS
SELECT     dbo.TXP_Ticket_Data.TicketID, CONVERT(datetime, dbo.TXP_Ticket_Data.Status_Changedate, 20) AS Status_Changedate, dbo.TXP_Ticket_Data.TGNummer
FROM         dbo.TXP_IN_Geschlossen_Prepare INNER JOIN
                      dbo.TXP_Ticket_Data ON dbo.TXP_IN_Geschlossen_Prepare.statusid = dbo.TXP_Ticket_Data.Statusid

GO
/****** Object:  View [dbo].[TXP_IN_Offene_Langlaeufer]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[TXP_IN_Offene_Langlaeufer]
AS
SELECT     TOP (100) PERCENT dbo.TXP_Ticketdata_IN.TicketID, dbo.TXP_Ticketdata_IN.TGNummer, dbo.TXP_Ticketdata_IN.Erstellungsdateum, dbo.TXP_Ticketdata_IN.Status, 
                      ISNULL(dbo.TXP_Ticket_Data.Ausfuehrung_Durch, '') AS Expr1
FROM         dbo.TXP_Ticketdata_IN INNER JOIN
                      dbo.TXP_Ticket_Data ON dbo.TXP_Ticketdata_IN.TicketID = dbo.TXP_Ticket_Data.TicketID
WHERE     (dbo.TXP_Ticketdata_IN.TicketID LIKE 'in%') AND (dbo.TXP_Ticketdata_IN.TicketID NOT IN
                          (SELECT     TicketID
                            FROM          dbo.TXP_IN_Geschlossen)) AND (DATEDIFF(d, dbo.TXP_Ticketdata_IN.Erstellungsdateum, GETDATE()) >= 120) AND 
                      (dbo.TXP_Ticketdata_IN.Status <> 'Geschlossen') AND (dbo.TXP_Ticketdata_IN.Status <> 'Geschlossen "AutoClose"') AND (dbo.TXP_Ticketdata_IN.Status <> 'Solved') 
                      AND (dbo.TXP_Ticketdata_IN.Status <> 'Warten auf Schliessung')
GROUP BY dbo.TXP_Ticketdata_IN.TicketID, dbo.TXP_Ticketdata_IN.TGNummer, dbo.TXP_Ticketdata_IN.Erstellungsdateum, dbo.TXP_Ticketdata_IN.Status, 
                      dbo.TXP_Ticket_Data.Ausfuehrung_Durch
HAVING      (NOT (dbo.TXP_Ticketdata_IN.TGNummer IS NULL)) AND (dbo.TXP_Ticket_Data.Ausfuehrung_Durch <> 'Avaloq') AND 
                      (dbo.TXP_Ticket_Data.Ausfuehrung_Durch <> 'Andere')

GO
/****** Object:  View [dbo].[TXP_IN_Geschlossen_IN_Aufwand]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[TXP_IN_Geschlossen_IN_Aufwand]
AS
SELECT     TOP (100) PERCENT dbo.TXP_IN_Geschlossen.TGNummer, CONVERT(float, dbo.TXP_LVer_IN_AU.CalculatedValue) AS Aufwand, 
                      dbo.TXP_IN_Geschlossen.Status_Changedate, dbo.TXP_LVer_IN_AU.Ticket_ID
FROM         dbo.TXP_IN_Geschlossen INNER JOIN
                      dbo.TXP_LVer_IN_AU ON dbo.TXP_IN_Geschlossen.TicketID = dbo.TXP_LVer_IN_AU.Ticket_ID AND 
                      dbo.TXP_IN_Geschlossen.TGNummer = dbo.TXP_LVer_IN_AU.ForUserID

GO
/****** Object:  View [dbo].[TXP_IN_Geschlossen_Aufwand]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[TXP_IN_Geschlossen_Aufwand]
AS
SELECT     TOP (100) PERCENT dbo.TXP_IN_Geschlossen.TGNummer, CONVERT(float, SUM(dbo.TXP_LVer_IN_AU.CalculatedValue)) AS Aufwand, 
                      dbo.TXP_IN_Geschlossen.Status_Changedate
FROM         dbo.TXP_IN_Geschlossen INNER JOIN
                      dbo.TXP_LVer_IN_AU ON dbo.TXP_IN_Geschlossen.TicketID = dbo.TXP_LVer_IN_AU.Ticket_ID AND 
                      dbo.TXP_IN_Geschlossen.TGNummer = dbo.TXP_LVer_IN_AU.ForUserID
GROUP BY dbo.TXP_IN_Geschlossen.TGNummer, dbo.TXP_IN_Geschlossen.Status_Changedate
ORDER BY dbo.TXP_IN_Geschlossen.TGNummer

GO
/****** Object:  View [dbo].[View_Applikationslisten_Kontakte]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[View_Applikationslisten_Kontakte]
AS
SELECT DISTINCT 
                      TOP (100) PERCENT dbo.Applikation.Bezeichnung AS Applikation, dbo.Person.Name, dbo.Person.Vorname, SUBSTRING(dbo.Person.Telefon, LEN(dbo.Person.Telefon) 
                      - 4, 5) AS telefon, dbo.Person.EMail, dbo.Kontakttyp.Bezeichnung AS Kontakttyp, dbo.Kontakttyp.KontakttypNr, ISNULL(dbo.Applikation.ApplikationVerantwortungNr, 0) 
                      AS ITAufgabeNr, ISNULL(dbo.Applikation.RfcBoardNr, 0) AS RFCBoardNr, dbo.Applikation.ApplikationNr
FROM         dbo.Applikation LEFT OUTER JOIN
                      dbo.ApplikationKontakt INNER JOIN
                      dbo.Kontakttyp ON dbo.ApplikationKontakt.KontakttypNr = dbo.Kontakttyp.KontakttypNr INNER JOIN
                      dbo.Person ON dbo.ApplikationKontakt.PersonNr = dbo.Person.PersonNr ON dbo.Applikation.ApplikationNr = dbo.ApplikationKontakt.Applikationnr
WHERE     (dbo.Applikation.Aktiv = 1) AND (dbo.Person.Aktiv = 1) AND (dbo.ApplikationKontakt.Aktiv = 1) AND (dbo.Kontakttyp.KontakttypNr = 1 OR
                      dbo.Kontakttyp.KontakttypNr = 2)

GO
/****** Object:  View [dbo].[View_Applikationslisten_Team]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[View_Applikationslisten_Team]
AS
SELECT DISTINCT 
                      TOP (100) PERCENT dbo.Applikation.Bezeichnung AS Applikation, ISNULL(dbo.get_gremium(dbo.GremiumGruppierung.GremiumGruppierungNr), '') 
                      AS IT_Aufgaben_erbringt, dbo.GremiumBereich.Bereich AS Team, ISNULL(dbo.Applikation.ApplikationVerantwortungNr, 0) AS ITAufgabeNr, 
                      ISNULL(dbo.Applikation.RfcBoardNr, 0) AS RFCBoardNr, dbo.GremiumBereich.Aktiv, dbo.Applikation.ApplikationNr
FROM         dbo.Applikation LEFT OUTER JOIN
                      dbo.GremiumGruppierung ON dbo.Applikation.ApplikationVerantwortungNr = dbo.GremiumGruppierung.GremiumGruppierungNr LEFT OUTER JOIN
                      dbo.GremiumBereich ON dbo.Applikation.ApplikationTeamnr = dbo.GremiumBereich.GremiumBereichNr
WHERE     (dbo.Applikation.Aktiv = 1) AND (dbo.GremiumGruppierung.GremiumNr = 3 OR
                      dbo.GremiumGruppierung.GremiumNr IS NULL) AND (dbo.GremiumBereich.Aktiv = 1)
ORDER BY Applikation

GO
/****** Object:  View [dbo].[View_Applikationslisten]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[View_Applikationslisten]
AS
SELECT DISTINCT 
                      TOP (100) PERCENT dbo.Applikation.Bezeichnung AS Applikation, dbo.View_Applikationslisten_Kontakte.Name, dbo.View_Applikationslisten_Kontakte.Vorname, 
                      dbo.View_Applikationslisten_Kontakte.telefon, dbo.View_Applikationslisten_Kontakte.EMail, dbo.View_Applikationslisten_Kontakte.Kontakttyp, 
                      dbo.View_Applikationslisten_Kontakte.KontakttypNr, dbo.ApplikationKategorie.Bezeichnung AS Kategorie, 
                      ISNULL(dbo.get_gremium(dbo.GremiumGruppierung.GremiumGruppierungNr), '') AS IT_Aufgaben_erbringt, dbo.View_Applikationslisten_Team.Team, 
                      ISNULL(dbo.get_gremium(GremiumGruppierung_2.GremiumGruppierungNr), '') AS KeyUser_Aufgaben_erbringt, GremiumBereich_1.Beschreibung AS RFCBoard, 
                      dbo.ApplikationKategorie.ApplikationKategorieNr, ISNULL(dbo.Applikation.ApplikationVerantwortungNr, 0) AS ITAufgabeNr, ISNULL(dbo.Applikation.RfcBoardNr, 0) 
                      AS RFCBoardNr
FROM         dbo.ApplikationKategorie INNER JOIN
                      dbo.Applikation ON dbo.ApplikationKategorie.ApplikationKategorieNr = dbo.Applikation.ApplikationKategorieNr LEFT OUTER JOIN
                      dbo.View_Applikationslisten_Team ON dbo.Applikation.ApplikationNr = dbo.View_Applikationslisten_Team.ApplikationNr LEFT OUTER JOIN
                      dbo.View_Applikationslisten_Kontakte ON dbo.Applikation.ApplikationNr = dbo.View_Applikationslisten_Kontakte.ApplikationNr LEFT OUTER JOIN
                      dbo.GremiumGruppierung AS GremiumGruppierung_2 ON dbo.Applikation.FachlicheOe = GremiumGruppierung_2.GremiumGruppierungNr LEFT OUTER JOIN
                      dbo.GremiumGruppierung ON dbo.Applikation.ApplikationVerantwortungNr = dbo.GremiumGruppierung.GremiumGruppierungNr LEFT OUTER JOIN
                      dbo.GremiumBereich AS GremiumBereich_1 ON dbo.Applikation.RfcBoardNr = GremiumBereich_1.GremiumBereichNr
WHERE     (dbo.Applikation.Aktiv = 1) AND (dbo.GremiumGruppierung.GremiumNr = 3 OR
                      dbo.GremiumGruppierung.GremiumNr IS NULL) AND (dbo.Applikation.Strukturelement = 0)
ORDER BY Applikation, dbo.View_Applikationslisten_Kontakte.KontakttypNr

GO
/****** Object:  View [dbo].[Applview_ArchitekturObjekte]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[Applview_ArchitekturObjekte]
AS
SELECT     dbo.Applikation.ApplikationNr, dbo.Applikation.Bezeichnung, dbo.Applikation.Version, dbo.Applikation.Kurzbeschreibung, 
                      CASE WHEN imageno = 1 THEN dbo.ApplikationArchitektur.ArchitekturImage1 WHEN imageno = 2 THEN dbo.ApplikationArchitektur.ArchitekturImage2 WHEN
                       imageno = 3 THEN dbo.ApplikationArchitektur.ArchitekturImage3 WHEN imageno = 4 THEN dbo.ApplikationArchitektur.ArchitekturImage4 END AS ArchitekturImage,
                       dbo.ApplikationArchitekturObject.Guid, dbo.ApplikationArchitekturObject.Name AS Objekt, dbo.ApplikationArchitekturObject.Description, 
                      dbo.ApplikationArchitekturObject.ImageNo, 
                      CASE WHEN imageno = 1 THEN '0 - Übersicht' WHEN imageno = 2 THEN '1 - Produktion' WHEN imageno = 3 THEN '2 - Integration' WHEN imageno = 4 THEN
                       '3 - Entwicklung' END AS Gruppierung, dbo.get_applobject(dbo.ApplikationArchitekturObject.Guid, 1) AS applikationen, 
                      dbo.get_applobject(dbo.ApplikationArchitekturObject.Guid, 2) AS Datenbanken, dbo.get_applobject(dbo.ApplikationArchitekturObject.Guid, 3) 
                      AS Schnittstellen, dbo.get_applobject(dbo.ApplikationArchitekturObject.Guid, 4) AS VirtualServer
FROM         dbo.Applikation INNER JOIN
                      dbo.ApplikationArchitekturObject ON dbo.Applikation.ApplikationNr = dbo.ApplikationArchitekturObject.Applikationnr LEFT OUTER JOIN
                      dbo.ApplikationArchitektur ON dbo.Applikation.ApplikationNr = dbo.ApplikationArchitektur.Applikationnr

GO
/****** Object:  View [dbo].[ApplvIEW_sik_20101214]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[ApplvIEW_sik_20101214]
AS
SELECT     dbo.Applikation.ApplikationNr, dbo.Applikation.Bezeichnung, dbo.Applikation.Version, dbo.Applikation.Kurzbeschreibung, 
                      dbo.ApplikationKategorie.Bezeichnung AS Kategorie, GremiumGruppierung_1.Gruppierungsbegriff AS Marktbereich, 
                      GremiumBereich_1.Bereich AS RFCBoard, dbo.GremiumGruppierung.Gruppierungsbegriff AS Verantwortung, dbo.GremiumBereich.Bereich AS Team, 
                      dbo.Applikation.TicketXPertVerwendung, dbo.Applikation.TicketXPert_WPIAnzeigen, dbo.Applikation.TicketXPert_Preis, 
                      dbo.Applikation.TicketXPert_Preis_Einmalig, dbo.Applikation.TicketXPert_AMAnzeigen, dbo.Applikation.TicketXPert_ApplikationKritikalitaetTypNr, 
                      dbo.Applikation.TicketXPert_ApplikationSMLTypNr, dbo.Applikation.Aktiv, dbo.Applview_ArchitekturObjekte.ArchitekturImage, 
                      dbo.Applview_ArchitekturObjekte.Guid, dbo.Applview_ArchitekturObjekte.Objekt, dbo.Applview_ArchitekturObjekte.Description, 
                      dbo.Applview_ArchitekturObjekte.Server, dbo.Applview_ArchitekturObjekte.ServerBeschreibung, dbo.Applview_ArchitekturObjekte.Datenbank, 
                      dbo.Applview_ArchitekturObjekte.DatenbankBeschreibung, dbo.Applview_ArchitekturObjekte.Applikation, 
                      dbo.Applview_ArchitekturObjekte.ApplikationBeschreibung, dbo.Applview_ArchitekturObjekte.ImageNo, dbo.Applview_ArchitekturObjekte.Gruppierung, 
                      dbo.ApplikationSLMTyp.Bezeichnung AS SLM
FROM         dbo.Applview_ArchitekturObjekte INNER JOIN
                      dbo.Applikation ON dbo.Applview_ArchitekturObjekte.ApplikationNr = dbo.Applikation.ApplikationNr LEFT OUTER JOIN
                      dbo.ApplikationSLMTyp ON dbo.Applikation.TicketXPert_ApplikationSMLTypNr = dbo.ApplikationSLMTyp.ApplikationSLMTypNr LEFT OUTER JOIN
                      dbo.ApplikationKategorie ON dbo.Applikation.ApplikationKategorieNr = dbo.ApplikationKategorie.ApplikationKategorieNr LEFT OUTER JOIN
                      dbo.GremiumBereich ON dbo.Applikation.ApplikationTeamnr = dbo.GremiumBereich.GremiumBereichNr LEFT OUTER JOIN
                      dbo.GremiumGruppierung ON dbo.Applikation.ApplikationVerantwortungNr = dbo.GremiumGruppierung.GremiumGruppierungNr LEFT OUTER JOIN
                      dbo.GremiumBereich AS GremiumBereich_1 ON dbo.Applikation.RfcBoardNr = GremiumBereich_1.GremiumBereichNr LEFT OUTER JOIN
                      dbo.GremiumGruppierung AS GremiumGruppierung_1 ON dbo.Applikation.Marktbereichnr = GremiumGruppierung_1.GremiumGruppierungNr
WHERE     (GremiumGruppierung_1.GremiumNr = 4 OR
                      GremiumGruppierung_1.GremiumNr IS NULL) AND (GremiumBereich_1.GremiumGruppierungNr = 1 OR
                      GremiumBereich_1.GremiumGruppierungNr IS NULL) AND (dbo.GremiumGruppierung.GremiumNr = 3 OR
                      dbo.GremiumGruppierung.GremiumNr IS NULL) AND (dbo.GremiumBereich.GremiumGruppierungNr = 3 OR
                      dbo.GremiumBereich.GremiumGruppierungNr IS NULL)

GO
/****** Object:  View [dbo].[honoris_journal]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[honoris_journal]
AS
SELECT     JOURNAL_NR, MITARBEITER_NR, PROJEKT_NR, POSTYP_SCNR, SPESEN_NR, DATUM, FAK_NR, MWST_NR, LEISTUNG_NR, SPESENGRUPPE_NR, 
                      POSSTATUS_SCNR, ANZAHLEXT, ANZAHLINT, ANSATZEXT, ANSATZINT, TOTALEXT, BETRAGNETTOEXT, TOTALINT, ABRECHTYP_SCNR, IMPORTDATUM, 
                      BETRAGNETTOINT, TEXTEXT, TEXTEXT2, TEXTINT, TEXTINT2, MITSPEABRECH, ERFDATUM, PROFIRMANR, MITFIRMANR, FIBUJOURNAL_NR, KST, FAKSWITCH, 
                      FIBUDATUM, LOHNDATUM, ANSATZSTATUS_SCNR, PROSTRUKTUR_NR, MITSTRUKTUR_NR, VISSTATUS_SCNR, VISDATUM, VISMIT_NR, MITABTNR, PROABTNR, 
                      VST_NR, JOURNAL_ID, ROWVERSION, FW_ANZAHLEXT, FW_ANSATZEXT, FW_BETRAGNETTOEXT, FW_TOTALEXT, WAEHRUNG_NR, TAGESKURS, FW_ANZAHLINT, 
                      FW_ANSATZINT, FW_BETRAGNETTOINT, FW_TOTALINT, WAEHRUNG_NR_INT, TAGESKURS_INT, UR_FW_ANZAHLEXT, UR_FW_ANSATZEXT, 
                      UR_FW_BETRAGNETTOEXT, UR_FW_TOTALEXT, UR_WAEHRUNG_NR, UR_TAGESKURS, KSPUNENTGELD, PROVFAK_NR
FROM         HONO1.dbo.JOURNAL

GO
/****** Object:  View [dbo].[Honoris_Mitarbeiter]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[Honoris_Mitarbeiter]
AS
SELECT     MITARBEITER_NR, FIRMA_NR, MITARBEITER_ID, NAME, PERSONAL_NR, VORNAME, TITEL, ADR1, ADR2, ADR3, LAND_ID, PLZ, ORT, TELEFON1, TELEFON2, EMAIL, 
                      TELEFONINTERN, TELEFAX, ANREDE_NR, AHVNR, STDSATZ, STDSATZINTERN, PRODUKTIVPROZ, MUTMIT_NR, STDSATZMUTIEREN, INTEXT_SCNR, MONATAZ, 
                      STATISTIK, KST, GEBDATUM, PASSWORT, EINTRITTSDATUM, AUSTRITTSDATUM, ANZAUSTRITTE, SYSSPRACHE_NR, LV, DATENSPRACHE_NR, SYSTEMADMIN, 
                      USERGROUP_NR, LOHNSCHNITT, MITWECHSEL, MITZEITMUST, JOURNALZEITMUST, JOURNALZEITSAVE, TEXT1, TEXT2, TEXT3, TEXT4, TEXT5, TEXT6, TEXT7, 
                      TEXT8, TEXT9, TEXT10, DATUM1, DATUM2, DATUM3, DATUM4, DATUM5, DATUM6, NUMMER1, NUMMER2, NUMMER3, NUMMER4, NUMMER5, NUMMER6, 
                      NUMMER7, NUMMER8, NUMMER9, BOOL1, BOOL2, BOOL3, BOOL4, BOOL5, BOOL6, BOOL7, BOOL8, BOOL9, BOOL10, BOOL11, BOOL12, BOOL13, BOOL14, 
                      BOOL15, MITSTRUKTUR_NR, MITPROZUORD, ABT_UCNR, MITFIBU, WEBSETTINGS, WEBSETTINGS2, WEBSETTINGS3, ROWVERSION, MITLEISTZUORD, 
                      PROINERFLEIST, LEIINERFLEIST, TXTINERFLEIST, STDTAG, PROZENTAZ, FVB_BERECHTIGUNG, SPESENMUTIEREN, LISTBOX1, LISTBOX2, LISTBOX3, LISTBOX4, 
                      LISTBOX5, LISTBOX6, LISTBOX7, LISTBOX8, LISTBOX9, LISTBOX10, MITABTLEISTGRPZUORD
FROM         HONO1.dbo.MITARBEITER

GO
/****** Object:  View [dbo].[honoris_projekt]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[honoris_projekt]
AS
SELECT     PROJEKT_NR, KUNDE_NR, VESR_NR, FIRMA_NR, KNOTEN_NR, KURZNAME, BEZEICHNUNG, KOMMENTAR, PROBEGINN, PROENDE, MUTMIT_NR, GESPERRT, KST,
                       FAKVORSCHLAG, PREISFIND_SCNR, FAKSWITCH, INTEXT_SCNR, FAKDRUCKVARIANTE, PROTYP_NR, DIENSTTEXT, SPESENTEXT, LV, MITARBEITER_NR, TEXT1, 
                      TEXT2, TEXT3, TEXT4, TEXT5, TEXT6, TEXT7, TEXT8, TEXT9, TEXT10, DATUM1, DATUM2, DATUM3, DATUM4, DATUM5, DATUM6, NUMMER1, NUMMER2, NUMMER3, 
                      NUMMER4, NUMMER5, NUMMER6, NUMMER7, NUMMER8, NUMMER9, BOOL1, BOOL2, BOOL3, BOOL4, BOOL5, BOOL6, BOOL7, BOOL8, BOOL9, BOOL10, BOOL11, 
                      BOOL12, BOOL13, BOOL14, BOOL15, STDSATZ, FVMIT_NR, SORTINDEX, PROSTRUKTUR_NR, ABT_UCNR, PROGRUPPE_UCNR, FAKADRESSE_NR, 
                      FAKKONTAKT_NR, WAEHRUNG_NR, ROWVERSION, PROLEISTZUORD, RUNDWERTANZEXT, RUNDREGELANZEXT, WORDFAKPARAMETER, POSTADRESSE_NR, 
                      POSTKONTAKT_NR, MUTATIONSCODE, KSPAKTIV, FAKDRUCKPARAMETER, LISTBOX1, LISTBOX2, LISTBOX3, LISTBOX4, LISTBOX5, LISTBOX6, LISTBOX7, 
                      LISTBOX8, LISTBOX9, LISTBOX10, PROABTLEISTGRPZUORD
FROM         HONO1.dbo.PROJEKT

GO
/****** Object:  View [dbo].[Honoris_200]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


CREATE VIEW [dbo].[Honoris_200]
AS
SELECT        dbo.Honoris_JOURNAL.DATUM, dbo.Honoris_JOURNAL.ANZAHLINT, dbo.Honoris_mitarbeiter.NAME, dbo.Honoris_mitarbeiter.VORNAME, 
                         dbo.Honoris_PROJEKT.KURZNAME, dbo.Honoris_PROJEKT.BEZEICHNUNG, dbo.Honoris_mitarbeiter.MITARBEITER_ID, dbo.Honoris_JOURNAL.ERFDATUM, 
                         dbo.Honoris_PROJEKT.PROJEKT_NR
FROM            dbo.Honoris_JOURNAL INNER JOIN
                         dbo.Honoris_PROJEKT ON dbo.Honoris_JOURNAL.PROJEKT_NR = dbo.Honoris_PROJEKT.PROJEKT_NR INNER JOIN
                         dbo.Honoris_mitarbeiter ON dbo.Honoris_JOURNAL.MITARBEITER_NR = dbo.Honoris_mitarbeiter.MITARBEITER_NR
WHERE        (dbo.Honoris_PROJEKT.PROJEKT_NR >= 200) AND (dbo.Honoris_PROJEKT.PROJEKT_NR < 300)



GO
/****** Object:  View [dbo].[Honoris_300]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO



CREATE VIEW [dbo].[Honoris_300]
AS
SELECT        dbo.Honoris_JOURNAL.DATUM, dbo.Honoris_JOURNAL.ANZAHLINT, dbo.Honoris_mitarbeiter.NAME, dbo.Honoris_mitarbeiter.VORNAME, 
                         dbo.Honoris_PROJEKT.KURZNAME, dbo.Honoris_PROJEKT.BEZEICHNUNG, dbo.Honoris_mitarbeiter.MITARBEITER_ID, dbo.Honoris_JOURNAL.ERFDATUM, 
                         dbo.Honoris_PROJEKT.PROJEKT_NR
FROM            dbo.Honoris_JOURNAL INNER JOIN
                         dbo.Honoris_PROJEKT ON dbo.Honoris_JOURNAL.PROJEKT_NR = dbo.Honoris_PROJEKT.PROJEKT_NR INNER JOIN
                         dbo.Honoris_mitarbeiter ON dbo.Honoris_JOURNAL.MITARBEITER_NR = dbo.Honoris_mitarbeiter.MITARBEITER_NR
WHERE        (dbo.Honoris_PROJEKT.PROJEKT_NR >= 300) AND (dbo.Honoris_PROJEKT.PROJEKT_NR <= 399)




GO
/****** Object:  View [dbo].[Honoris_ne_300]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO



CREATE VIEW [dbo].[Honoris_ne_300]
AS
SELECT        dbo.Honoris_JOURNAL.DATUM, dbo.Honoris_JOURNAL.ANZAHLINT, dbo.Honoris_mitarbeiter.NAME, dbo.Honoris_mitarbeiter.VORNAME, 
                         dbo.Honoris_PROJEKT.KURZNAME, dbo.Honoris_PROJEKT.BEZEICHNUNG, dbo.Honoris_mitarbeiter.MITARBEITER_ID, dbo.Honoris_JOURNAL.ERFDATUM, 
                         dbo.Honoris_PROJEKT.PROJEKT_NR
FROM            dbo.Honoris_JOURNAL INNER JOIN
                         dbo.Honoris_PROJEKT ON dbo.Honoris_JOURNAL.PROJEKT_NR = dbo.Honoris_PROJEKT.PROJEKT_NR INNER JOIN
                         dbo.Honoris_mitarbeiter ON dbo.Honoris_JOURNAL.MITARBEITER_NR = dbo.Honoris_mitarbeiter.MITARBEITER_NR
WHERE        (dbo.Honoris_PROJEKT.PROJEKT_NR < 200) OR
                         (dbo.Honoris_PROJEKT.PROJEKT_NR > 399)




GO
/****** Object:  View [dbo].[ServerInventar]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[ServerInventar]
AS
SELECT        TOP (100) PERCENT dbo.Server_Inventar.ServerInventarNr, dbo.Server_Inventar.Bezeichnung AS Server, dbo.Server_Umgebung.Bezeichnung AS Umgebung, dbo.Server_Kategorie.Bezeichnung AS Kategorie, 
                         dbo.Server_OS.Bezeichnung AS OS, dbo.Server_OSLevel.Server_OSLevelNr AS OS_Level, dbo.Server_Inventar.Beschreibung AS Bemerkung, dbo.Server_Backup_Loesung.Bezeichnung AS Backup_Loesung, 
                         dbo.Server_Backup_Retention.Bezeichnung AS Backup_Retentioin, dbo.Server_DB.Bezeichnung AS DB, dbo.Server_Inventar.Server_DB_Bemerkung AS DB_Bemerkung, 
                         dbo.Server_DB_Backup_Loesung.Bezeichnung AS DB_Backup_Loesung, dbo.Server_DB_Backup_Retention.Bezeichnung AS DB_Backup_Retention, 
                         dbo.Server_Inventar.Server_DB_Backup_Bemerkung AS DB_Backup_Bemerkung, dbo.Server_Provider.Bezeichnung AS Provider, dbo.Server_Inventar.RZ_Betreiber_Standort AS Betrebier_Standort, 
                         dbo.Server_Inventar.Server_Stanmdort_Bemerkung
FROM            dbo.Server_Inventar INNER JOIN
                         dbo.Server_Umgebung ON dbo.Server_Inventar.Server_UmgebungNr = dbo.Server_Umgebung.Server_UmgebungNr INNER JOIN
                         dbo.Server_Kategorie ON dbo.Server_Inventar.Server_KategorieNr = dbo.Server_Kategorie.Server_KategorieNr LEFT OUTER JOIN
                         dbo.Server_OSLevel ON dbo.Server_Inventar.Server_OSLevelNr = dbo.Server_OSLevel.Server_OSLevelNr LEFT OUTER JOIN
                         dbo.Server_OS ON dbo.Server_Inventar.Server_OSNr = dbo.Server_OS.Server_OSNr LEFT OUTER JOIN
                         dbo.Server_Provider ON dbo.Server_Inventar.Server_ProviderNr = dbo.Server_Provider.Server_ProviderNr LEFT OUTER JOIN
                         dbo.Server_Backup_Retention ON dbo.Server_Inventar.Server_Backup_RetentionNr = dbo.Server_Backup_Retention.Server_Backup_RetentionNr LEFT OUTER JOIN
                         dbo.Server_Backup_Loesung ON dbo.Server_Inventar.Server_Backup_LoesungNr = dbo.Server_Backup_Loesung.Server_Backup_LoesungNr LEFT OUTER JOIN
                         dbo.Server_DB ON dbo.Server_Inventar.Server_DBNr = dbo.Server_DB.Server_DBNr LEFT OUTER JOIN
                         dbo.Server_DB_Backup_Retention ON dbo.Server_Inventar.Server_DB_Backup_RetentionNr = dbo.Server_DB_Backup_Retention.Server_DB_Backup_RetentionNr LEFT OUTER JOIN
                         dbo.Server_DB_Backup_Loesung ON dbo.Server_Inventar.Server_DB_Backup_LoesungNr = dbo.Server_DB_Backup_Loesung.Server_DB_Backup_LoesungNr
WHERE        (dbo.Server_Inventar.Aktiv = 1)
ORDER BY Server, dbo.Server_Inventar.ServerInventarNr


GO
/****** Object:  View [dbo].[ServerInventar1]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[ServerInventar1]
AS
SELECT     dbo.ServerInventar.ServerInventarNr, dbo.ServerInventar.Server, dbo.ServerInventar.Umgebung, dbo.ServerInventar.Kategorie, dbo.ServerInventar.OS, 
                      dbo.Server_OSLevel.Bezeichnung AS OS_Level, dbo.ServerInventar.Bemerkung, dbo.ServerInventar.Backup_Loesung, dbo.ServerInventar.Backup_Retentioin, 
                      dbo.ServerInventar.DB, dbo.ServerInventar.DB_Bemerkung, dbo.ServerInventar.DB_Backup_Loesung, dbo.ServerInventar.DB_Backup_Retention, 
                      dbo.ServerInventar.DB_Backup_Bemerkung, dbo.ServerInventar.Provider, dbo.ServerInventar.Betrebier_Standort, dbo.ServerInventar.Server_Stanmdort_Bemerkung, 
                      Server_Weiteres_Typ_1.Bezeichnung AS Weiteres_Typ_1, Server_Weiteres_Backup_Loesung_1.Bezeichnung AS Weiteres_Backup_Loesung_1, 
                      Server_Weiteres_Retention_1.Bezeichnung AS Weiteres_Retention_1, dbo.Server_Inventar.Server_Weiteres_Bemerkung1 AS Weiteres_Bemerkung_1, 
                      dbo.Server_Weiteres_Typ.Bezeichnung AS Weiteres_Server_Typ_2, dbo.Server_Weiteres_Backup_Loesung.Bezeichnung AS Weiteres_Backup_Loesung_2, 
                      dbo.Server_Weiteres_Retention.Bezeichnung AS Weiteres_Backup_2, dbo.Server_Inventar.Server_Weiteres_Bemerkung2 AS Weiteres_Bemerkung_2
FROM         dbo.ServerInventar INNER JOIN
                      dbo.Server_Inventar ON dbo.ServerInventar.ServerInventarNr = dbo.Server_Inventar.ServerInventarNr LEFT OUTER JOIN
                      dbo.Server_OSLevel ON dbo.Server_Inventar.Server_OSLevelNr = dbo.Server_OSLevel.Server_OSLevelNr LEFT OUTER JOIN
                      dbo.Server_Weiteres_Retention ON 
                      dbo.Server_Inventar.Server_Weiteres_RetentionNr2 = dbo.Server_Weiteres_Retention.Server_Weiteres_RetentionNr LEFT OUTER JOIN
                      dbo.Server_Weiteres_Backup_Loesung ON 
                      dbo.Server_Inventar.Server_Weiteres_Backup_LoesungNr1 = dbo.Server_Weiteres_Backup_Loesung.Server_Weiteres_Backup_LoesungNr LEFT OUTER JOIN
                      dbo.Server_Weiteres_Typ ON dbo.Server_Inventar.Server_Weiteres_TypNr2 = dbo.Server_Weiteres_Typ.Server_Weiteres_TypNr LEFT OUTER JOIN
                      dbo.Server_Weiteres_Retention AS Server_Weiteres_Retention_1 ON 
                      dbo.Server_Inventar.Server_Weiteres_RetentionNr1 = Server_Weiteres_Retention_1.Server_Weiteres_RetentionNr LEFT OUTER JOIN
                      dbo.Server_Weiteres_Backup_Loesung AS Server_Weiteres_Backup_Loesung_1 ON 
                      dbo.Server_Inventar.Server_Weiteres_Backup_LoesungNr1 = Server_Weiteres_Backup_Loesung_1.Server_Weiteres_Backup_LoesungNr LEFT OUTER JOIN
                      dbo.Server_Weiteres_Typ AS Server_Weiteres_Typ_1 ON dbo.Server_Inventar.Server_Weiteres_TypNr1 = Server_Weiteres_Typ_1.Server_Weiteres_TypNr

GO
/****** Object:  View [dbo].[View_Vertragselement]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[View_Vertragselement]
AS
SELECT     dbo.Vertragselement.Vertragselementnr, dbo.Vertragselement.VertragstypNr, dbo.Vertragselement.VertragspartnerNr, dbo.Vertragselement.ParentID, 
                      dbo.Vertragselement.Bezeichnung, dbo.Vertragselement.Beschreibung, dbo.Vertragselement.Version, 
                      dbo.Check_Date(dbo.Vertragselement.Versionsdatum) AS Versionsdatum, dbo.Vertragselement.Nummer, 
                      dbo.Check_Date(dbo.Vertragselement.Unterzeichnet_am) AS Unterzeichnet_am, dbo.Check_Date(dbo.Vertragselement.Vertragsbeginn) 
                      AS Vertragsbeginn, dbo.Check_Date(dbo.Vertragselement.Vertragsablauf) AS Vertragsablauf, dbo.Vertragselement.Befristet_Unbefristet, 
                      dbo.Check_Date(dbo.Vertragselement.Mindestvertragsdauer_bis) AS Mindestvertragsdauer_bis, dbo.Check_Date(dbo.Vertragselement.Gekuendigt_am) 
                      AS Gekuendigt_am, dbo.Check_Date(dbo.Vertragselement.Gekuendigt_per) AS Gekuendigt_per, dbo.Vertragselement.SecurityLevelNr, 
                      dbo.Vertragselement.Suchbegriffe, dbo.Vertragselement.ApplikationNr, dbo.Vertragselement.Lizenztypnr, dbo.Vertragselement.Lizenzdetails, 
                      dbo.Vertragselement.Erstellt_am, dbo.Vertragselement.Mutiert_am, dbo.Vertragselement.Mutierer, dbo.Vertragselement.Aktiv, 
                      Vertragselement_1.Bezeichnung AS Parent
FROM         dbo.Vertragselement LEFT OUTER JOIN
                      dbo.Vertragselement AS Vertragselement_1 ON dbo.Vertragselement.ParentID = Vertragselement_1.Vertragselementnr

GO
/****** Object:  View [dbo].[Vertragselemente_vollstaendig]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[Vertragselemente_vollstaendig]
AS
SELECT     dbo.View_Vertragselement.VertragspartnerNr, 
                      dbo.Vertragspartner.NameZ1 + ' ' + dbo.Vertragspartner.NameZ1 + ', ' + dbo.Vertragspartner.Ort AS Partner, dbo.Vertragspartner.Aktiv AS Partner_aktiv, 
                      dbo.Vertragstyp.Vertragstyp, dbo.View_Vertragselement.Vertragselementnr, dbo.View_Vertragselement.ParentID, 
                      dbo.Vertragselement.Bezeichnung AS Parent, dbo.View_Vertragselement.Bezeichnung, dbo.View_Vertragselement.Beschreibung, 
                      dbo.View_Vertragselement.Version, dbo.View_Vertragselement.Versionsdatum, dbo.View_Vertragselement.Nummer, 
                      dbo.View_Vertragselement.Unterzeichnet_am, dbo.View_Vertragselement.Vertragsbeginn, dbo.View_Vertragselement.Vertragsablauf, 
                      dbo.View_Vertragselement.Befristet_Unbefristet, dbo.View_Vertragselement.Mindestvertragsdauer_bis, dbo.View_Vertragselement.Gekuendigt_am, 
                      dbo.View_Vertragselement.Gekuendigt_per, dbo.View_Vertragselement.SecurityLevelNr, dbo.View_Vertragselement.Suchbegriffe, 
                      dbo.View_Vertragselement.ApplikationNr, dbo.View_Vertragselement.Erstellt_am, dbo.View_Vertragselement.Mutiert_am, 
                      dbo.mitarbeiter.name + ' ' + dbo.mitarbeiter.vorname + ', ' + dbo.mitarbeiter.tgnummer AS Mutierername, dbo.View_Vertragselement.Mutierer, 
                      dbo.View_Vertragselement.Aktiv
FROM         dbo.View_Vertragselement INNER JOIN
                      dbo.Vertragspartner ON dbo.View_Vertragselement.VertragspartnerNr = dbo.Vertragspartner.VertragspartnerNr INNER JOIN
                      dbo.Vertragstyp ON dbo.View_Vertragselement.VertragstypNr = dbo.Vertragstyp.Vertragstypnr LEFT OUTER JOIN
                      dbo.Vertragselement ON dbo.View_Vertragselement.ParentID = dbo.Vertragselement.Vertragselementnr LEFT OUTER JOIN
                      dbo.mitarbeiter ON dbo.View_Vertragselement.Mutierer = dbo.mitarbeiter.mitarbeiternr

GO
/****** Object:  View [dbo].[ServerInventar2]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[ServerInventar2]
AS
SELECT        dbo.ServerInventar1.*, dbo.Applikation.Bezeichnung AS Applikation, dbo.Server_Applikation.Aktiv AS Server_Applikation_Aktiv
FROM            dbo.Applikation INNER JOIN
                         dbo.Server_Applikation ON dbo.Applikation.ApplikationNr = dbo.Server_Applikation.Applikationnr RIGHT OUTER JOIN
                         dbo.ServerInventar1 ON dbo.Server_Applikation.ServerNr = dbo.ServerInventar1.ServerInventarNr


GO
/****** Object:  View [dbo].[TXP_AU_Geschlossen]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


CREATE VIEW [dbo].[TXP_AU_Geschlossen]
AS
SELECT        TOP (100) PERCENT TicketID, MAX(Status_Changedate) AS Status_Changedate, TGNummer
FROM            dbo.TXP_Ticket_Data
WHERE        (Status_Neu = 'Geschlossen') AND (TicketID LIKE 'au_%')
GROUP BY TicketID, TGNummer
HAVING        (NOT (TGNummer IS NULL))
ORDER BY TicketID



GO
/****** Object:  View [dbo].[TXP_AU_Offen_Prepare]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


CREATE VIEW [dbo].[TXP_AU_Offen_Prepare]
AS
SELECT DISTINCT TOP (100) PERCENT dbo.fnkt_get_last_statusID(TicketID) AS StatusID, TicketID
FROM            dbo.TXP_Ticket_Data
WHERE        (TicketID LIKE 'AU_%') AND (Status_Neu <> 'Geschlossen') AND (TicketID NOT IN
                             (SELECT        TicketID
                               FROM            dbo.TXP_AU_Geschlossen))
ORDER BY TicketID



GO
/****** Object:  View [dbo].[ApplView]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[ApplView]
AS
SELECT     dbo.Applikation.ApplikationNr, dbo.Applikation.Bezeichnung, dbo.Applikation.Version, dbo.Applikation.Kurzbeschreibung, 
                      dbo.ApplikationKategorie.Bezeichnung AS Kategorie, GremiumGruppierung_1.Gruppierungsbegriff AS Marktbereich, 
                      GremiumBereich_1.Bereich AS RFCBoard, dbo.GremiumGruppierung.Gruppierungsbegriff AS Verantwortung, dbo.GremiumBereich.Bereich AS Team, 
                      dbo.Applikation.TicketXPertVerwendung, dbo.Applikation.TicketXPert_WPIAnzeigen, dbo.Applikation.TicketXPert_Preis, 
                      dbo.Applikation.TicketXPert_Preis_Einmalig, dbo.Applikation.TicketXPert_AMAnzeigen, dbo.Applikation.TicketXPert_ApplikationKritikalitaetTypNr, 
                      dbo.Applikation.TicketXPert_ApplikationSMLTypNr, dbo.Applikation.Aktiv, dbo.Applview_ArchitekturObjekte.ArchitekturImage, 
                      dbo.Applview_ArchitekturObjekte.Guid, dbo.Applview_ArchitekturObjekte.Objekt, dbo.Applview_ArchitekturObjekte.Description, 
                      dbo.Applview_ArchitekturObjekte.ImageNo, dbo.Applview_ArchitekturObjekte.Gruppierung, dbo.ApplikationSLMTyp.Bezeichnung AS SLM, 
                      dbo.Applview_ArchitekturObjekte.applikationen, dbo.Applview_ArchitekturObjekte.Datenbanken, dbo.Applview_ArchitekturObjekte.VirtualServer, 
                      dbo.Applview_ArchitekturObjekte.Schnittstellen
FROM         dbo.Applview_ArchitekturObjekte RIGHT OUTER JOIN
                      dbo.Applikation ON dbo.Applview_ArchitekturObjekte.ApplikationNr = dbo.Applikation.ApplikationNr LEFT OUTER JOIN
                      dbo.ApplikationSLMTyp ON dbo.Applikation.TicketXPert_ApplikationSMLTypNr = dbo.ApplikationSLMTyp.ApplikationSLMTypNr LEFT OUTER JOIN
                      dbo.ApplikationKategorie ON dbo.Applikation.ApplikationKategorieNr = dbo.ApplikationKategorie.ApplikationKategorieNr LEFT OUTER JOIN
                      dbo.GremiumBereich ON dbo.Applikation.ApplikationTeamnr = dbo.GremiumBereich.GremiumBereichNr LEFT OUTER JOIN
                      dbo.GremiumGruppierung ON dbo.Applikation.ApplikationVerantwortungNr = dbo.GremiumGruppierung.GremiumGruppierungNr LEFT OUTER JOIN
                      dbo.GremiumBereich AS GremiumBereich_1 ON dbo.Applikation.RfcBoardNr = GremiumBereich_1.GremiumBereichNr LEFT OUTER JOIN
                      dbo.GremiumGruppierung AS GremiumGruppierung_1 ON dbo.Applikation.Marktbereichnr = GremiumGruppierung_1.GremiumGruppierungNr
WHERE     (GremiumGruppierung_1.GremiumNr = 4 OR
                      GremiumGruppierung_1.GremiumNr IS NULL) AND (GremiumBereich_1.GremiumGruppierungNr = 1 OR
                      GremiumBereich_1.GremiumGruppierungNr IS NULL) AND (dbo.GremiumGruppierung.GremiumNr = 3 OR
                      dbo.GremiumGruppierung.GremiumNr IS NULL) AND (dbo.GremiumBereich.GremiumGruppierungNr = 3 OR
                      dbo.GremiumBereich.GremiumGruppierungNr IS NULL)

GO
/****** Object:  View [dbo].[_migcheck20110603]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[_migcheck20110603]
AS
SELECT     TOP (100) PERCENT dbo.Applikation.ApplikationNr, dbo.Applikation.Bezeichnung AS Applikation, dbo.ApplikationKategorie.Bezeichnung AS Kategorie, 
                      GremiumGruppierung_1.Gruppierungsbegriff AS TechV, '' AS TechVNeu, dbo.GremiumGruppierung.Gruppierungsbegriff AS Marktbereich, 
                      '' AS BereichNeu, '' AS FachV, dbo.GremiumBereich.Bereich AS RFC
FROM         dbo.Applikation INNER JOIN
                      dbo.ApplikationKategorie ON dbo.Applikation.ApplikationKategorieNr = dbo.ApplikationKategorie.ApplikationKategorieNr INNER JOIN
                      dbo.GremiumGruppierung ON dbo.Applikation.Marktbereichnr = dbo.GremiumGruppierung.GremiumGruppierungNr INNER JOIN
                      dbo.GremiumGruppierung AS GremiumGruppierung_1 ON 
                      dbo.Applikation.ApplikationVerantwortungNr = GremiumGruppierung_1.GremiumGruppierungNr INNER JOIN
                      dbo.GremiumBereich ON dbo.Applikation.RfcBoardNr = dbo.GremiumBereich.GremiumBereichNr
WHERE     (dbo.GremiumGruppierung.GremiumNr = 4) AND (GremiumGruppierung_1.GremiumNr = 3) AND (dbo.GremiumBereich.GremiumGruppierungNr = 1) AND 
                      (dbo.Applikation.Aktiv = 1) AND (dbo.Applikation.NurLizenz = 0) AND (dbo.Applikation.Bezeichnung NOT IN
                          (SELECT     Applikation
                            FROM          dbo.__ApplMigData))
ORDER BY Applikation

GO
/****** Object:  View [dbo].[_SHU_View_Appl_Beschaffung_Incident]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[_SHU_View_Appl_Beschaffung_Incident]
AS
SELECT     TOP (100) PERCENT dbo.Applikation.Bezeichnung AS Applikation, dbo.ApplikationKategorie.Bezeichnung AS Klassifizierung, 
                      dbo.Person.Name + ' ' + dbo.Person.Vorname AS Keyuser, '' AS KeyUserStv, dbo.Applikation.TicketXPert_WPIAnzeigen AS WPIAnzeigen, 
                      dbo.Applikation.TicketXPert_Preis AS WPIPreis, dbo.Applikation.TicketXPert_AMAnzeigen AS AMAnzeigen, 
                      dbo.Applikation.TicketXPert_Preis_Einmalig AS PreisEinmalig, dbo.Applikation.TicketXPert_ApplikationKritikalitaetTypNr AS Kritisch, 
                      dbo.ApplikationSLMTyp.Bezeichnung AS SLM
FROM         dbo.Applikation INNER JOIN
                      dbo.ApplikationKategorie ON dbo.Applikation.ApplikationKategorieNr = dbo.ApplikationKategorie.ApplikationKategorieNr INNER JOIN
                      dbo.ApplikationKontakt ON dbo.Applikation.ApplikationNr = dbo.ApplikationKontakt.Applikationnr INNER JOIN
                      dbo.Person ON dbo.ApplikationKontakt.PersonNr = dbo.Person.PersonNr INNER JOIN
                      dbo.Kontakttyp ON dbo.ApplikationKontakt.KontakttypNr = dbo.Kontakttyp.KontakttypNr LEFT OUTER JOIN
                      dbo.ApplikationSLMTyp ON dbo.Applikation.TicketXPert_ApplikationSMLTypNr = dbo.ApplikationSLMTyp.ApplikationSLMTypNr
WHERE     (dbo.Kontakttyp.KontakttypNr = 1) AND (dbo.ApplikationKontakt.Aktiv = 1) AND (dbo.Applikation.Aktiv = 1)
ORDER BY Applikation

GO
/****** Object:  View [dbo].[Applview_ArchitekturObjekte_sik_20101214]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[Applview_ArchitekturObjekte_sik_20101214]
AS
SELECT     dbo.Applikation.ApplikationNr, dbo.Applikation.Bezeichnung, dbo.Applikation.Version, dbo.Applikation.Kurzbeschreibung, 
                      CASE WHEN imageno = 1 THEN dbo.ApplikationArchitektur.ArchitekturImage1 WHEN imageno = 2 THEN dbo.ApplikationArchitektur.ArchitekturImage2 WHEN
                       imageno = 3 THEN dbo.ApplikationArchitektur.ArchitekturImage3 WHEN imageno = 4 THEN dbo.ApplikationArchitektur.ArchitekturImage4 END AS ArchitekturImage,
                       dbo.ApplikationArchitekturObject.Guid, dbo.ApplikationArchitekturObject.Name AS Objekt, dbo.ApplikationArchitekturObject.Description, 
                      dbo.ApplikationArchitekturObjectVirt.Applikation AS Server, dbo.ApplikationArchitekturObjectVirt.Beschreibung AS ServerBeschreibung, 
                      dbo.ApplikationArchitekturObjectDB.Datenbank, dbo.ApplikationArchitekturObjectDB.Beschreibung AS DatenbankBeschreibung, 
                      dbo.ApplikationArchitekturObjectappl.Applikation, dbo.ApplikationArchitekturObjectappl.Beschreibung AS ApplikationBeschreibung, 
                      dbo.ApplikationArchitekturObject.ImageNo, 
                      CASE WHEN imageno = 1 THEN '0 - Übersicht' WHEN imageno = 2 THEN '1 - Produktion' WHEN imageno = 3 THEN '2 - Integration' WHEN imageno = 4 THEN
                       '3 - Entwicklung' END AS Gruppierung
FROM         dbo.Applikation INNER JOIN
                      dbo.ApplikationArchitekturObject ON dbo.Applikation.ApplikationNr = dbo.ApplikationArchitekturObject.Applikationnr LEFT OUTER JOIN
                      dbo.ApplikationArchitekturObjectDB ON dbo.ApplikationArchitekturObject.Guid = dbo.ApplikationArchitekturObjectDB.GUID LEFT OUTER JOIN
                      dbo.ApplikationArchitekturObjectVirt ON dbo.ApplikationArchitekturObject.Guid = dbo.ApplikationArchitekturObjectVirt.Guid LEFT OUTER JOIN
                      dbo.ApplikationArchitekturObjectappl ON dbo.ApplikationArchitekturObject.Guid = dbo.ApplikationArchitekturObjectappl.GUID LEFT OUTER JOIN
                      dbo.ApplikationArchitektur ON dbo.Applikation.ApplikationNr = dbo.ApplikationArchitektur.Applikationnr

GO
/****** Object:  View [dbo].[TXP_AU_IN]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


CREATE VIEW [dbo].[TXP_AU_IN]
AS
SELECT DISTINCT TicketID
FROM            dbo.TXP_Ticket_Data
WHERE        (TicketID LIKE 'au_%') OR
                         (TicketID LIKE 'IN_%')



GO
/****** Object:  View [dbo].[TXP_AU_Offen]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


CREATE VIEW [dbo].[TXP_AU_Offen]
AS
SELECT        TicketID, Statusdatum AS Status_Changedate, TGNummer
FROM            dbo.TXP_Ticketdata_AU
WHERE        (Status <> 'Geschlossen')



GO
/****** Object:  View [dbo].[TXP_IN_Offen]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


CREATE VIEW [dbo].[TXP_IN_Offen]
AS
SELECT        TOP (100) PERCENT TicketID, Statusdatum AS Status_Changedate, TGNummer
FROM            dbo.TXP_Ticketdata_IN
WHERE        (Status <> 'Geschlossen' AND Status <> 'Geschlossen "AutoClose"' AND Status <> 'Warten auf Schliessung' AND Status <> 'Solved')



GO
/****** Object:  View [dbo].[View_Applikation]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[View_Applikation]
AS
SELECT     TOP (100) PERCENT dbo.Applikation.Bezeichnung AS Applikation, dbo.get_x(dbo.Applikation.Strukturelement) AS Strukturelement, 
                      Applikation_1.Bezeichnung AS Parent, dbo.ApplikationKategorie.Bezeichnung AS Kategorie, dbo.Applikation.Aktiv, GremiumBereich_1.Bereich AS RFCBoard, 
                      dbo.get_gremium(GremiumGruppierung_1.GremiumGruppierungNr) AS IT_Aufgaben_erbringt, dbo.get_gremium(GremiumGruppierung_2.GremiumGruppierungNr) 
                      AS KeyUser_Aufgaben_erbringt, dbo.get_x(dbo.Applikation.NurLizenz) AS Nur_Lizenz, dbo.Applikation.PrioWiederanlauf, dbo.Applikation.Inaktivseit, 
                      dbo.get_x(dbo.Applikation.RAS) AS RAS, dbo.Applikation.Datenbankname, dbo.Applikation.Anzahl_Installationen, dbo.Applikation.ApplikationNr, dbo.Get_Type(1, 'TS', 
                      dbo.Applikation.ApplikationNr) AS TS, dbo.Get_Type(1, 'Filer', dbo.Applikation.ApplikationNr) AS Filer, dbo.Get_Type(1, 'FAT (paketiert)', dbo.Applikation.ApplikationNr) 
                      AS Fat_Paketiert, dbo.Get_Type(1, 'FAT Manuell', dbo.Applikation.ApplikationNr) AS FAT_Manuell, dbo.Get_Type(1, 'Web-Server', dbo.Applikation.ApplikationNr) 
                      AS Web, dbo.Get_Type(1, 'Standalone', dbo.Applikation.ApplikationNr) AS Standalone, dbo.Get_Type(1, 'externe URL', dbo.Applikation.ApplikationNr) AS Ext_URL, 
                      dbo.Get_Type(2, 'SPF', dbo.Applikation.ApplikationNr) AS SPF, dbo.Get_Type(2, 'IPF', dbo.Applikation.ApplikationNr) AS IPF, dbo.Get_Type(2, 'NL', 
                      dbo.Applikation.ApplikationNr) AS NL, dbo.Get_Type(2, 'HS', dbo.Applikation.ApplikationNr) AS HS, dbo.Get_Type(2, 'CC', dbo.Applikation.ApplikationNr) AS CC, 
                      dbo.Get_Type(2, 'Handel', dbo.Applikation.ApplikationNr) AS Handel, dbo.Get_Type(3, 'PK', dbo.Applikation.ApplikationNr) AS PK, dbo.Get_Type(3, 'FK', 
                      dbo.Applikation.ApplikationNr) AS FK, dbo.Get_Type(3, 'PBI', dbo.Applikation.ApplikationNr) AS PBI, dbo.Get_Type(3, 'Stab', dbo.Applikation.ApplikationNr) AS Stab, 
                      dbo.Get_Type(4, 'Key_User', dbo.Applikation.ApplikationNr) AS Key_User, dbo.Get_Type(4, 'Key_User_Stv', dbo.Applikation.ApplikationNr) AS Key_User_STV, 
                      dbo.Get_Type(4, 'Fachvertreter', dbo.Applikation.ApplikationNr) AS Fachvertreter
FROM         dbo.ApplikationKategorie RIGHT OUTER JOIN
                      dbo.Applikation LEFT OUTER JOIN
                      dbo.GremiumGruppierung AS GremiumGruppierung_1 ON 
                      dbo.Applikation.ApplikationVerantwortungNr = GremiumGruppierung_1.GremiumGruppierungNr LEFT OUTER JOIN
                      dbo.GremiumGruppierung ON dbo.Applikation.Marktbereichnr = dbo.GremiumGruppierung.GremiumGruppierungNr LEFT OUTER JOIN
                      dbo.GremiumGruppierung AS GremiumGruppierung_2 ON dbo.Applikation.FachlicheOe = GremiumGruppierung_2.GremiumGruppierungNr LEFT OUTER JOIN
                      dbo.GremiumBereich AS GremiumBereich_1 ON dbo.Applikation.RfcBoardNr = GremiumBereich_1.GremiumBereichNr LEFT OUTER JOIN
                      dbo.Applikation AS Applikation_1 ON dbo.Applikation.ParentID = Applikation_1.ApplikationNr ON 
                      dbo.ApplikationKategorie.ApplikationKategorieNr = dbo.Applikation.ApplikationKategorieNr
WHERE     (dbo.Applikation.Aktiv = 1)
ORDER BY Applikation

GO
/****** Object:  View [dbo].[View_Applikation_Datenbank]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[View_Applikation_Datenbank]
AS
SELECT     dbo.Applikation.Bezeichnung, dbo.ApplikationArchitekturObjectDB.Datenbank, 'Applikation / Datenbank' AS Titel, 
                      ISNULL(dbo.ApplikationKategorie.ApplikationKategorieNr, 0) AS Expr1, ISNULL(dbo.ApplikationKategorie.Bezeichnung, '') AS ApplikationKategorie
FROM         dbo.Applikation INNER JOIN
                      dbo.ApplikationArchitekturObject ON dbo.Applikation.ApplikationNr = dbo.ApplikationArchitekturObject.Applikationnr LEFT OUTER JOIN
                      dbo.ApplikationKategorie ON dbo.Applikation.ApplikationKategorieNr = dbo.ApplikationKategorie.ApplikationKategorieNr LEFT OUTER JOIN
                      dbo.ApplikationArchitekturObjectDB ON dbo.ApplikationArchitekturObject.Guid = dbo.ApplikationArchitekturObjectDB.GUID LEFT OUTER JOIN
                      dbo.ApplikationArchitekturObjectappl ON dbo.ApplikationArchitekturObject.Guid = dbo.ApplikationArchitekturObjectappl.GUID LEFT OUTER JOIN
                      dbo.ApplikationArchitekturObjectVirt ON dbo.ApplikationArchitekturObject.Guid = dbo.ApplikationArchitekturObjectVirt.Guid
WHERE     (NOT (dbo.ApplikationArchitekturObjectDB.Datenbank IS NULL)) AND (dbo.Applikation.Aktiv = 1)

GO
/****** Object:  View [dbo].[View_Applikation_Server]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[View_Applikation_Server]
AS
SELECT     dbo.Applikation.Bezeichnung, dbo.ApplikationArchitekturObjectVirt.Applikation AS Datenbank, 'Applikation - Server' AS Titel, 
                      ISNULL(dbo.ApplikationKategorie.ApplikationKategorieNr, 0) AS Expr1, ISNULL(dbo.ApplikationKategorie.Bezeichnung, '') AS ApplikationKategorie
FROM         dbo.Applikation INNER JOIN
                      dbo.ApplikationArchitekturObject ON dbo.Applikation.ApplikationNr = dbo.ApplikationArchitekturObject.Applikationnr LEFT OUTER JOIN
                      dbo.ApplikationKategorie ON dbo.Applikation.ApplikationKategorieNr = dbo.ApplikationKategorie.ApplikationKategorieNr LEFT OUTER JOIN
                      dbo.ApplikationArchitekturObjectDB ON dbo.ApplikationArchitekturObject.Guid = dbo.ApplikationArchitekturObjectDB.GUID LEFT OUTER JOIN
                      dbo.ApplikationArchitekturObjectappl ON dbo.ApplikationArchitekturObject.Guid = dbo.ApplikationArchitekturObjectappl.GUID LEFT OUTER JOIN
                      dbo.ApplikationArchitekturObjectVirt ON dbo.ApplikationArchitekturObject.Guid = dbo.ApplikationArchitekturObjectVirt.Guid
WHERE     (NOT (dbo.ApplikationArchitekturObjectVirt.Applikation IS NULL)) AND (dbo.Applikation.Aktiv = 1)

GO
/****** Object:  View [dbo].[View_Applikation_SST]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[View_Applikation_SST]
AS
SELECT     dbo.Applikation.Bezeichnung, dbo.ApplikationArchitekturObjectSST.SST AS Datenbank, 'Applikation /Schnittstellen' AS Titel, 
                      ISNULL(dbo.ApplikationKategorie.ApplikationKategorieNr, 0) AS Expr1, ISNULL(dbo.ApplikationKategorie.Bezeichnung, '') AS ApplikationKategorie
FROM         dbo.Applikation INNER JOIN
                      dbo.ApplikationArchitekturObject ON dbo.Applikation.ApplikationNr = dbo.ApplikationArchitekturObject.Applikationnr LEFT OUTER JOIN
                      dbo.ApplikationKategorie ON dbo.Applikation.ApplikationKategorieNr = dbo.ApplikationKategorie.ApplikationKategorieNr LEFT OUTER JOIN
                      dbo.ApplikationArchitekturObjectSST ON dbo.ApplikationArchitekturObject.Guid = dbo.ApplikationArchitekturObjectSST.Guid LEFT OUTER JOIN
                      dbo.ApplikationArchitekturObjectappl ON dbo.ApplikationArchitekturObject.Guid = dbo.ApplikationArchitekturObjectappl.GUID LEFT OUTER JOIN
                      dbo.ApplikationArchitekturObjectVirt ON dbo.ApplikationArchitekturObject.Guid = dbo.ApplikationArchitekturObjectVirt.Guid
WHERE     (dbo.Applikation.Aktiv = 1) AND (NOT (dbo.ApplikationArchitekturObjectSST.SST IS NULL))

GO
/****** Object:  View [dbo].[View_Applikationslisten_Original]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[View_Applikationslisten_Original]
AS
SELECT DISTINCT 
                      TOP (100) PERCENT dbo.Applikation.Bezeichnung AS Applikation, dbo.Person.Name, dbo.Person.Vorname, SUBSTRING(dbo.Person.Telefon, LEN(dbo.Person.Telefon) 
                      - 4, 5) AS telefon, dbo.Person.EMail, dbo.Kontakttyp.Bezeichnung AS Kontakttyp, dbo.Kontakttyp.KontakttypNr, dbo.ApplikationKategorie.Bezeichnung AS Kategorie, 
                      ISNULL(dbo.get_gremium(dbo.GremiumGruppierung.GremiumGruppierungNr), '') AS IT_Aufgaben_erbringt, dbo.GremiumBereich.Bereich AS Team, 
                      ISNULL(dbo.get_gremium(GremiumGruppierung_2.GremiumGruppierungNr), '') AS KeyUser_Aufgaben_erbringt, GremiumBereich_1.Beschreibung AS RFCBoard, 
                      dbo.ApplikationKategorie.ApplikationKategorieNr, ISNULL(dbo.Applikation.ApplikationVerantwortungNr, 0) AS ITAufgabeNr, ISNULL(dbo.Applikation.RfcBoardNr, 0) 
                      AS RFCBoardNr
FROM         dbo.ApplikationKategorie INNER JOIN
                      dbo.Applikation ON dbo.ApplikationKategorie.ApplikationKategorieNr = dbo.Applikation.ApplikationKategorieNr LEFT OUTER JOIN
                      dbo.ApplikationKontakt INNER JOIN
                      dbo.Kontakttyp ON dbo.ApplikationKontakt.KontakttypNr = dbo.Kontakttyp.KontakttypNr INNER JOIN
                      dbo.Person ON dbo.ApplikationKontakt.PersonNr = dbo.Person.PersonNr ON dbo.Applikation.ApplikationNr = dbo.ApplikationKontakt.Applikationnr LEFT OUTER JOIN
                      dbo.GremiumGruppierung AS GremiumGruppierung_2 ON dbo.Applikation.FachlicheOe = GremiumGruppierung_2.GremiumGruppierungNr LEFT OUTER JOIN
                      dbo.GremiumGruppierung ON dbo.Applikation.ApplikationVerantwortungNr = dbo.GremiumGruppierung.GremiumGruppierungNr LEFT OUTER JOIN
                      dbo.GremiumBereich ON dbo.Applikation.ApplikationTeamnr = dbo.GremiumBereich.GremiumBereichNr LEFT OUTER JOIN
                      dbo.GremiumBereich AS GremiumBereich_1 ON dbo.Applikation.RfcBoardNr = GremiumBereich_1.GremiumBereichNr
WHERE     (dbo.Applikation.Aktiv = 1) AND (dbo.Person.Aktiv = 1) AND (dbo.ApplikationKontakt.Aktiv = 1) AND (dbo.Kontakttyp.KontakttypNr = 1 OR
                      dbo.Kontakttyp.KontakttypNr = 2) AND (dbo.GremiumGruppierung.GremiumNr = 3)
ORDER BY Applikation, dbo.Kontakttyp.KontakttypNr

GO
/****** Object:  View [dbo].[View_IGAData]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[View_IGAData]
AS
SELECT     TOP (100) PERCENT dbo.GremiumGruppierung.Gruppierungsbegriff AS [Group], dbo.GremiumBereich.Bereich AS Gremium, 
                      dbo.GremiumBereich.Beschreibung, dbo.Person.Name, dbo.Person.Vorname, dbo.Kontakttyp.Bezeichnung AS Rollle, dbo.GremiumPerson.Leitung, 
                      dbo.GremiumPerson.Beschreibung AS PersonBeschreibung, dbo.Vertragspartner.NameZ1 + ' ' + dbo.Vertragspartner.NameZ2 AS Firma, 
                      dbo.GremiumGruppierung.Reihenfolge, dbo.GremiumBereich.Sortierung
FROM         dbo.GremiumBereich INNER JOIN
                      dbo.GremiumPerson ON dbo.GremiumBereich.GremiumBereichNr = dbo.GremiumPerson.GremiumBereichNr INNER JOIN
                      dbo.Person ON dbo.GremiumPerson.PersonNr = dbo.Person.PersonNr INNER JOIN
                      dbo.GremiumGruppierung ON dbo.GremiumBereich.GremiumGruppierungNr = dbo.GremiumGruppierung.GremiumGruppierungNr INNER JOIN
                      dbo.Gremium ON dbo.GremiumGruppierung.GremiumNr = dbo.Gremium.GremiumNr INNER JOIN
                      dbo.Vertragspartner ON dbo.Person.Vertragspartnernr = dbo.Vertragspartner.VertragspartnerNr LEFT OUTER JOIN
                      dbo.Kontakttyp ON dbo.GremiumPerson.RolleNr = dbo.Kontakttyp.KontakttypNr
WHERE     (dbo.GremiumBereich.Aktiv = 1) AND (dbo.GremiumPerson.Aktiv = 1) AND (dbo.Person.Aktiv = 1) AND (dbo.Gremium.GremiumNr = 6)
ORDER BY dbo.GremiumGruppierung.Reihenfolge, dbo.GremiumBereich.Sortierung, dbo.GremiumPerson.Leitung, dbo.Person.Name

GO
/****** Object:  View [dbo].[View_IKV_Berechtigungseinschraenkung]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[View_IKV_Berechtigungseinschraenkung]
AS
SELECT     TOP (100) PERCENT dbo.funktionsgruppe.bezeichnung, dbo.rolle.bezeichnung AS Rolle, dbo.SecurityObject.SecurityObject, dbo.Rolle_SecurityObject.readonly, 
                      dbo.Rolle_SecurityObject.invisible, dbo.mitarbeiter.tgnummer, dbo.mitarbeiter.name, dbo.mitarbeiter.vorname
FROM         dbo.funktionsgruppe_rolle INNER JOIN
                      dbo.funktionsgruppe ON dbo.funktionsgruppe_rolle.funktionsgruppenr = dbo.funktionsgruppe.funktionsgruppenr INNER JOIN
                      dbo.rolle ON dbo.funktionsgruppe_rolle.rollenr = dbo.rolle.rollenr INNER JOIN
                      dbo.Rolle_SecurityObject ON dbo.rolle.rollenr = dbo.Rolle_SecurityObject.rollenr INNER JOIN
                      dbo.SecurityObject ON dbo.Rolle_SecurityObject.securityobjectnr = dbo.SecurityObject.SecurityObjectNr INNER JOIN
                      dbo.mitarbeiter_funktionsgruppe ON dbo.funktionsgruppe.funktionsgruppenr = dbo.mitarbeiter_funktionsgruppe.funktionsgruppenr INNER JOIN
                      dbo.mitarbeiter ON dbo.mitarbeiter_funktionsgruppe.mitarbeiternr = dbo.mitarbeiter.mitarbeiternr
WHERE     (dbo.funktionsgruppe.aktiv = 1) AND (dbo.funktionsgruppe_rolle.aktiv = 1) AND (dbo.rolle.aktiv = 1) AND (dbo.SecurityObject.SecurityObject = 'TabIKV') AND 
                      (dbo.funktionsgruppe_rolle.aktiv = 1) AND (dbo.mitarbeiter.aktiv = 1) AND (dbo.Rolle_SecurityObject.aktiv = 1) AND (dbo.mitarbeiter_funktionsgruppe.aktiv = 1)

GO
/****** Object:  View [dbo].[View_ITSM_TXP_Appl]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[View_ITSM_TXP_Appl]
AS
SELECT     TOP (100) PERCENT dbo.Applikation.Bezeichnung AS Applikation, dbo.ApplikationKategorie.Bezeichnung AS Klassifizierung, 
                      dbo.get_keyuser_stv(dbo.Applikation.ApplikationNr, 1) AS KeyUser, dbo.get_keyuser_stv(dbo.Applikation.ApplikationNr, 2) AS KeyUserStv, 
                      CASE WHEN dbo.Applikation.TicketXPert_WPIAnzeigen = 1 THEN 'x' ELSE '' END AS WPIAnzeigen, 
                      CASE WHEN dbo.Applikation.TicketXPert_Preis = '#NV' THEN '' ELSE dbo.Applikation.TicketXPert_Preis END AS WPIPreis, 
                      CASE WHEN dbo.Applikation.TicketXPert_Preis_Einmalig = '#NV' THEN '' ELSE dbo.Applikation.TicketXPert_Preis_Einmalig END AS Preiseinmalig, 
                      CASE WHEN dbo.Applikation.TicketXPert_AMAnzeigen = 1 THEN 'x' ELSE '' END AS AMAnzeigen, '' AS Kritisch, dbo.ApplikationSLMTyp.Bezeichnung AS SLM, 
                      GremiumGruppierung_1.Gruppierungsbegriff AS Marktbereich, dbo.GremiumGruppierung.Gruppierungsbegriff AS Verantwortung, GremiumBereich_1.Bereich AS Team, 
                      dbo.GremiumBereich.Beschreibung AS RFCBoard, dbo.Applikation.ApplikationNr, dbo.ITSPProdukt.Bezeichnung AS ITSPProdukt, 
                      CASE WHEN dbo.applikation.erstloesungsquote IS NULL THEN 0 WHEN dbo.applikation.erstloesungsquote = 0 THEN 0 ELSE 1 END AS Erstloesungsquote
FROM         dbo.ITSPProdukt INNER JOIN
                      dbo.ApplikationSLMTyp INNER JOIN
                      dbo.ApplikationKategorie INNER JOIN
                      dbo.Applikation ON dbo.ApplikationKategorie.ApplikationKategorieNr = dbo.Applikation.ApplikationKategorieNr ON 
                      dbo.ApplikationSLMTyp.ApplikationSLMTypNr = dbo.Applikation.TicketXPert_ApplikationSMLTypNr INNER JOIN
                      dbo.GremiumBereich ON dbo.Applikation.RfcBoardNr = dbo.GremiumBereich.GremiumBereichNr ON 
                      dbo.ITSPProdukt.ITSPProduktNr = dbo.Applikation.TicketXPert_ITSPProduktnr LEFT OUTER JOIN
                      dbo.GremiumGruppierung AS GremiumGruppierung_1 ON dbo.Applikation.Marktbereichnr = GremiumGruppierung_1.GremiumGruppierungNr RIGHT OUTER JOIN
                      dbo.GremiumGruppierung ON dbo.Applikation.ApplikationVerantwortungNr = dbo.GremiumGruppierung.GremiumGruppierungNr LEFT OUTER JOIN
                      dbo.GremiumBereich AS GremiumBereich_1 ON dbo.Applikation.ApplikationTeamnr = GremiumBereich_1.GremiumBereichNr
WHERE     (dbo.Applikation.TicketXPertVerwendung = 1) AND (dbo.GremiumGruppierung.GremiumNr = 3 OR
                      dbo.GremiumGruppierung.GremiumNr IS NULL) AND (dbo.GremiumBereich.GremiumGruppierungNr = 1) AND (dbo.Applikation.Aktiv = 1)
ORDER BY Applikation

GO
/****** Object:  View [dbo].[VIEW1]    Script Date: 27.01.2017 08:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[VIEW1]
AS
SELECT     TOP 100 PERCENT dbo.GremiumBereich.Bereich AS RFC_Board, dbo.Person.Name, dbo.Person.Vorname, dbo.Kontakttyp.Bezeichnung AS Rollle, 
                      dbo.GremiumPerson.Leitung
FROM         dbo.GremiumBereich INNER JOIN
                      dbo.GremiumPerson ON dbo.GremiumBereich.GremiumBereichNr = dbo.GremiumPerson.GremiumBereichNr INNER JOIN
                      dbo.Person ON dbo.GremiumPerson.PersonNr = dbo.Person.PersonNr INNER JOIN
                      dbo.GremiumGruppierung ON dbo.GremiumBereich.GremiumGruppierungNr = dbo.GremiumGruppierung.GremiumGruppierungNr INNER JOIN
                      dbo.Gremium ON dbo.GremiumGruppierung.GremiumNr = dbo.Gremium.GremiumNr LEFT OUTER JOIN
                      dbo.Kontakttyp ON dbo.GremiumPerson.RolleNr = dbo.Kontakttyp.KontakttypNr
WHERE     (dbo.GremiumPerson.Aktiv = 1) AND (dbo.Person.Aktiv = 1) AND (dbo.Gremium.GremiumNr = 1)
ORDER BY dbo.GremiumBereich.Bereich, dbo.GremiumPerson.Leitung DESC, dbo.Person.Name

GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[41] 4[20] 2[8] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "Applikation"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 121
               Right = 322
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationKategorie"
            Begin Extent = 
               Top = 6
               Left = 360
               Bottom = 121
               Right = 550
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumGruppierung"
            Begin Extent = 
               Top = 6
               Left = 588
               Bottom = 121
               Right = 780
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumGruppierung_1"
            Begin Extent = 
               Top = 126
               Left = 38
               Bottom = 241
               Right = 230
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumBereich"
            Begin Extent = 
               Top = 126
               Left = 268
               Bottom = 241
               Right = 460
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 10
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin Colu' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'_migcheck20110603'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'mnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'_migcheck20110603'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'_migcheck20110603'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[58] 4[24] 2[3] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "Applikation"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 214
               Right = 310
            End
            DisplayFlags = 280
            TopColumn = 20
         End
         Begin Table = "ApplikationSLMTyp"
            Begin Extent = 
               Top = 257
               Left = 626
               Bottom = 365
               Right = 806
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationKategorie"
            Begin Extent = 
               Top = 6
               Left = 577
               Bottom = 114
               Right = 766
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationKontakt"
            Begin Extent = 
               Top = 114
               Left = 348
               Bottom = 222
               Right = 527
            End
            DisplayFlags = 280
            TopColumn = 4
         End
         Begin Table = "Person"
            Begin Extent = 
               Top = 112
               Left = 709
               Bottom = 220
               Right = 876
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Kontakttyp"
            Begin Extent = 
               Top = 216
               Left = 38
               Bottom = 324
               Right = 221
            End
            DisplayFlags = 280
            TopColumn = 1
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 11
         Width = 284
         W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'_SHU_View_Appl_Beschaffung_Incident'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'idth = 2520
         Width = 2430
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'_SHU_View_Appl_Beschaffung_Incident'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'_SHU_View_Appl_Beschaffung_Incident'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "shu_view_an_excelexport_lst"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 128
               Right = 354
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "TXP_LVer_IN_AU"
            Begin Extent = 
               Top = 6
               Left = 392
               Bottom = 128
               Right = 571
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'AN_Bezeichnung'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'AN_Bezeichnung'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "TXP_LVer_IN_AU"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 128
               Right = 233
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "AN_Bezeichnung"
            Begin Extent = 
               Top = 6
               Left = 271
               Bottom = 94
               Right = 463
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'AN_Summe_Ticket_User'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'AN_Summe_Ticket_User'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "Applview_ArchitekturObjekte"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 121
               Right = 204
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Applikation"
            Begin Extent = 
               Top = 6
               Left = 242
               Bottom = 121
               Right = 526
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationSLMTyp"
            Begin Extent = 
               Top = 1
               Left = 745
               Bottom = 116
               Right = 926
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationKategorie"
            Begin Extent = 
               Top = 126
               Left = 38
               Bottom = 241
               Right = 228
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumBereich"
            Begin Extent = 
               Top = 126
               Left = 266
               Bottom = 241
               Right = 458
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumGruppierung"
            Begin Extent = 
               Top = 126
               Left = 496
               Bottom = 241
               Right = 688
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumBereich_1"
            Begin Extent = 
               Top = 246
               Left = 38
               Bottom = 361
    ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'ApplView'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'           Right = 230
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumGruppierung_1"
            Begin Extent = 
               Top = 246
               Left = 268
               Bottom = 361
               Right = 460
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'ApplView'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'ApplView'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "Applikation"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 121
               Right = 322
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationArchitekturObject"
            Begin Extent = 
               Top = 6
               Left = 360
               Bottom = 121
               Right = 589
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationArchitektur"
            Begin Extent = 
               Top = 126
               Left = 38
               Bottom = 241
               Right = 208
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Applview_ArchitekturObjekte'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Applview_ArchitekturObjekte'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "Applikation"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 121
               Right = 322
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationArchitekturObject"
            Begin Extent = 
               Top = 6
               Left = 360
               Bottom = 121
               Right = 589
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationArchitekturObjectDB"
            Begin Extent = 
               Top = 6
               Left = 627
               Bottom = 121
               Right = 869
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationArchitekturObjectVirt"
            Begin Extent = 
               Top = 126
               Left = 38
               Bottom = 241
               Right = 283
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationArchitekturObjectappl"
            Begin Extent = 
               Top = 126
               Left = 321
               Bottom = 241
               Right = 571
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationArchitektur"
            Begin Extent = 
               Top = 126
               Left = 609
               Bottom = 241
               Right = 779
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
   ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Applview_ArchitekturObjekte_sik_20101214'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'   End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Applview_ArchitekturObjekte_sik_20101214'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Applview_ArchitekturObjekte_sik_20101214'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "Applview_ArchitekturObjekte"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 121
               Right = 235
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Applikation"
            Begin Extent = 
               Top = 6
               Left = 273
               Bottom = 121
               Right = 557
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationSLMTyp"
            Begin Extent = 
               Top = 6
               Left = 595
               Bottom = 121
               Right = 776
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationKategorie"
            Begin Extent = 
               Top = 126
               Left = 38
               Bottom = 241
               Right = 228
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumBereich"
            Begin Extent = 
               Top = 126
               Left = 266
               Bottom = 241
               Right = 458
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumGruppierung"
            Begin Extent = 
               Top = 126
               Left = 496
               Bottom = 241
               Right = 688
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumBereich_1"
            Begin Extent = 
               Top = 246
               Left = 38
               Bottom = 361
    ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'ApplvIEW_sik_20101214'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'           Right = 230
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumGruppierung_1"
            Begin Extent = 
               Top = 246
               Left = 268
               Bottom = 361
               Right = 460
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'ApplvIEW_sik_20101214'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'ApplvIEW_sik_20101214'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "JOURNAL (HONO1.dbo)"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 117
               Right = 251
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'honoris_journal'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'honoris_journal'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "MITARBEITER (HONO1.dbo)"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 117
               Right = 238
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Honoris_Mitarbeiter'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Honoris_Mitarbeiter'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "PROJEKT (HONO1.dbo)"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 117
               Right = 241
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'honoris_projekt'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'honoris_projekt'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[41] 4[42] 2[3] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "ServerInventar"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 114
               Right = 265
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Server_Inventar"
            Begin Extent = 
               Top = 114
               Left = 38
               Bottom = 222
               Right = 302
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Server_Weiteres_Retention"
            Begin Extent = 
               Top = 222
               Left = 38
               Bottom = 330
               Right = 263
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Server_Weiteres_Backup_Loesung"
            Begin Extent = 
               Top = 330
               Left = 38
               Bottom = 438
               Right = 296
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Server_Weiteres_Typ"
            Begin Extent = 
               Top = 438
               Left = 38
               Bottom = 546
               Right = 234
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Server_Weiteres_Retention_1"
            Begin Extent = 
               Top = 546
               Left = 38
               Bottom = 654
               Right = 263
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Server_Weiteres_Backup_Loesung_1"
            Begin Extent = 
               Top = 654
               Left =' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'ServerInventar1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N' 38
               Bottom = 762
               Right = 296
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Server_Weiteres_Typ_1"
            Begin Extent = 
               Top = 438
               Left = 272
               Bottom = 546
               Right = 468
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Server_OSLevel"
            Begin Extent = 
               Top = 201
               Left = 541
               Bottom = 309
               Right = 709
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 28
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 2685
         Table = 3465
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'ServerInventar1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'ServerInventar1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "TXP_IN_Geschlossen_Prepare"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 87
               Right = 190
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "TXP_Ticket_Data"
            Begin Extent = 
               Top = 6
               Left = 228
               Bottom = 117
               Right = 405
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'TXP_IN_Geschlossen'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'TXP_IN_Geschlossen'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "TXP_IN_Geschlossen"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 102
               Right = 231
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "TXP_LVer_IN_AU"
            Begin Extent = 
               Top = 6
               Left = 269
               Bottom = 117
               Right = 456
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'TXP_IN_Geschlossen_Aufwand'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'TXP_IN_Geschlossen_Aufwand'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "TXP_IN_Geschlossen"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 102
               Right = 215
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "TXP_LVer_IN_AU"
            Begin Extent = 
               Top = 6
               Left = 253
               Bottom = 117
               Right = 424
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'TXP_IN_Geschlossen_IN_Aufwand'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'TXP_IN_Geschlossen_IN_Aufwand'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "get_solved_in_1"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 87
               Right = 190
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'TXP_IN_Geschlossen_Prepare'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'TXP_IN_Geschlossen_Prepare'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "TXP_Ticketdata_IN"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 117
               Right = 223
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "TXP_Ticket_Data"
            Begin Extent = 
               Top = 6
               Left = 261
               Bottom = 117
               Right = 454
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'TXP_IN_Offene_Langlaeufer'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'TXP_IN_Offene_Langlaeufer'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "View_Vertragselement"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 121
               Right = 244
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Vertragspartner"
            Begin Extent = 
               Top = 6
               Left = 282
               Bottom = 121
               Right = 451
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Vertragstyp"
            Begin Extent = 
               Top = 6
               Left = 489
               Bottom = 121
               Right = 641
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Vertragselement"
            Begin Extent = 
               Top = 126
               Left = 38
               Bottom = 241
               Right = 244
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "mitarbeiter"
            Begin Extent = 
               Top = 126
               Left = 282
               Bottom = 241
               Right = 434
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
  ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Vertragselemente_vollstaendig'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'       Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Vertragselemente_vollstaendig'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Vertragselemente_vollstaendig'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[41] 4[36] 2[4] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "ApplikationKategorie"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 114
               Right = 227
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Applikation"
            Begin Extent = 
               Top = 6
               Left = 265
               Bottom = 114
               Right = 548
            End
            DisplayFlags = 280
            TopColumn = 44
         End
         Begin Table = "GremiumGruppierung_1"
            Begin Extent = 
               Top = 6
               Left = 586
               Bottom = 114
               Right = 777
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumGruppierung"
            Begin Extent = 
               Top = 114
               Left = 38
               Bottom = 222
               Right = 229
            End
            DisplayFlags = 280
            TopColumn = 1
         End
         Begin Table = "GremiumGruppierung_2"
            Begin Extent = 
               Top = 6
               Left = 815
               Bottom = 128
               Right = 1026
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumBereich_1"
            Begin Extent = 
               Top = 114
               Left = 267
               Bottom = 222
               Right = 458
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Applikation_1"
            Begin Extent = 
               Top = 114
               Left = 496
               Bottom = 222
         ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'      Right = 779
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 37
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 5565
         Alias = 1770
         Table = 2955
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "Applikation"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 121
               Right = 322
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationArchitekturObject"
            Begin Extent = 
               Top = 126
               Left = 38
               Bottom = 241
               Right = 267
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationKategorie"
            Begin Extent = 
               Top = 21
               Left = 545
               Bottom = 136
               Right = 735
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationArchitekturObjectDB"
            Begin Extent = 
               Top = 246
               Left = 38
               Bottom = 361
               Right = 280
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationArchitekturObjectappl"
            Begin Extent = 
               Top = 366
               Left = 38
               Bottom = 481
               Right = 288
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationArchitekturObjectVirt"
            Begin Extent = 
               Top = 486
               Left = 38
               Bottom = 601
               Right = 283
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
     ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikation_Datenbank'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N' End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 5265
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikation_Datenbank'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikation_Datenbank'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "Applikation"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 121
               Right = 322
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationArchitekturObject"
            Begin Extent = 
               Top = 127
               Left = 463
               Bottom = 242
               Right = 692
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationKategorie"
            Begin Extent = 
               Top = 12
               Left = 578
               Bottom = 127
               Right = 768
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationArchitekturObjectDB"
            Begin Extent = 
               Top = 246
               Left = 38
               Bottom = 361
               Right = 280
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationArchitekturObjectappl"
            Begin Extent = 
               Top = 366
               Left = 38
               Bottom = 481
               Right = 288
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationArchitekturObjectVirt"
            Begin Extent = 
               Top = 486
               Left = 38
               Bottom = 601
               Right = 283
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
    ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikation_Server'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'  End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 2475
         Width = 2730
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikation_Server'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikation_Server'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "Applikation"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 121
               Right = 322
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationArchitekturObject"
            Begin Extent = 
               Top = 207
               Left = 341
               Bottom = 322
               Right = 570
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationKategorie"
            Begin Extent = 
               Top = 6
               Left = 627
               Bottom = 121
               Right = 817
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationArchitekturObjectSST"
            Begin Extent = 
               Top = 6
               Left = 855
               Bottom = 121
               Right = 1098
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationArchitekturObjectappl"
            Begin Extent = 
               Top = 126
               Left = 38
               Bottom = 241
               Right = 288
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationArchitekturObjectVirt"
            Begin Extent = 
               Top = 175
               Left = 488
               Bottom = 290
               Right = 733
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
   ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikation_SST'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'   End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikation_SST'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikation_SST'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[42] 4[17] 2[25] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "ApplikationKategorie"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 114
               Right = 227
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Applikation"
            Begin Extent = 
               Top = 6
               Left = 265
               Bottom = 114
               Right = 548
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "View_Applikationslisten_Team"
            Begin Extent = 
               Top = 159
               Left = 290
               Bottom = 267
               Right = 477
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "View_Applikationslisten_Kontakte"
            Begin Extent = 
               Top = 6
               Left = 586
               Bottom = 114
               Right = 737
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumGruppierung_2"
            Begin Extent = 
               Top = 6
               Left = 775
               Bottom = 114
               Right = 966
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumGruppierung"
            Begin Extent = 
               Top = 186
               Left = 917
               Bottom = 294
               Right = 1108
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumBereich_1"
            Begin Extent = 
               Top = 206
               Left = 534
          ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikationslisten'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'     Bottom = 314
               Right = 725
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikationslisten'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikationslisten'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "Applikation"
            Begin Extent = 
               Top = 7
               Left = 154
               Bottom = 115
               Right = 437
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationKontakt"
            Begin Extent = 
               Top = 6
               Left = 586
               Bottom = 114
               Right = 765
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Kontakttyp"
            Begin Extent = 
               Top = 6
               Left = 803
               Bottom = 114
               Right = 986
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Person"
            Begin Extent = 
               Top = 178
               Left = 563
               Bottom = 286
               Right = 730
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 13' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikationslisten_Kontakte'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'50
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikationslisten_Kontakte'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikationslisten_Kontakte'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[29] 4[32] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "ApplikationKontakt"
            Begin Extent = 
               Top = 2
               Left = 19
               Bottom = 110
               Right = 198
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Kontakttyp"
            Begin Extent = 
               Top = 85
               Left = 257
               Bottom = 192
               Right = 440
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Person"
            Begin Extent = 
               Top = 99
               Left = 438
               Bottom = 207
               Right = 605
            End
            DisplayFlags = 280
            TopColumn = 8
         End
         Begin Table = "Applikation"
            Begin Extent = 
               Top = 6
               Left = 681
               Bottom = 114
               Right = 964
            End
            DisplayFlags = 280
            TopColumn = 32
         End
         Begin Table = "ApplikationKategorie"
            Begin Extent = 
               Top = 7
               Left = 1069
               Bottom = 115
               Right = 1258
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumGruppierung_2"
            Begin Extent = 
               Top = 114
               Left = 38
               Bottom = 222
               Right = 229
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumGruppierung"
            Begin Extent = 
               Top = 144
               Left = 1032
               Bottom = 252
               Right ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikationslisten_Original'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'= 1223
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumBereich"
            Begin Extent = 
               Top = 114
               Left = 496
               Bottom = 222
               Right = 687
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumBereich_1"
            Begin Extent = 
               Top = 114
               Left = 725
               Bottom = 222
               Right = 916
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 13
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 8205
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikationslisten_Original'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikationslisten_Original'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "Applikation"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 114
               Right = 321
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumGruppierung"
            Begin Extent = 
               Top = 6
               Left = 359
               Bottom = 114
               Right = 550
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumBereich"
            Begin Extent = 
               Top = 6
               Left = 588
               Bottom = 114
               Right = 779
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 2640
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikationslisten_Team'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Applikationslisten_Team'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "GremiumBereich"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 121
               Right = 230
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumPerson"
            Begin Extent = 
               Top = 6
               Left = 268
               Bottom = 121
               Right = 436
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Person"
            Begin Extent = 
               Top = 126
               Left = 38
               Bottom = 241
               Right = 206
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumGruppierung"
            Begin Extent = 
               Top = 126
               Left = 244
               Bottom = 241
               Right = 436
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Gremium"
            Begin Extent = 
               Top = 246
               Left = 38
               Bottom = 361
               Right = 190
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Vertragspartner"
            Begin Extent = 
               Top = 246
               Left = 228
               Bottom = 361
               Right = 397
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Kontakttyp"
            Begin Extent = 
               Top = 366
               Left = 38
               Bottom = 481
               Right = 222
            End' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_IGAData'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_IGAData'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_IGAData'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "funktionsgruppe_rolle"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 114
               Right = 228
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "funktionsgruppe"
            Begin Extent = 
               Top = 6
               Left = 266
               Bottom = 114
               Right = 464
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "rolle"
            Begin Extent = 
               Top = 6
               Left = 502
               Bottom = 114
               Right = 653
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Rolle_SecurityObject"
            Begin Extent = 
               Top = 129
               Left = 675
               Bottom = 237
               Right = 859
            End
            DisplayFlags = 280
            TopColumn = 4
         End
         Begin Table = "SecurityObject"
            Begin Extent = 
               Top = 137
               Left = 936
               Bottom = 245
               Right = 1140
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "mitarbeiter_funktionsgruppe"
            Begin Extent = 
               Top = 172
               Left = 79
               Bottom = 280
               Right = 305
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "mitarbeiter"
            Begin Extent = 
               Top = 6
               Left = 1155
               Bottom = 114
             ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_IKV_Berechtigungseinschraenkung'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'  Right = 1306
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 3075
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_IKV_Berechtigungseinschraenkung'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_IKV_Berechtigungseinschraenkung'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[33] 4[12] 2[40] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "ITSPProdukt"
            Begin Extent = 
               Top = 169
               Left = 809
               Bottom = 280
               Right = 961
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationSLMTyp"
            Begin Extent = 
               Top = 6
               Left = 268
               Bottom = 121
               Right = 449
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ApplikationKategorie"
            Begin Extent = 
               Top = 126
               Left = 38
               Bottom = 241
               Right = 228
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Applikation"
            Begin Extent = 
               Top = 246
               Left = 38
               Bottom = 361
               Right = 322
            End
            DisplayFlags = 280
            TopColumn = 48
         End
         Begin Table = "GremiumBereich"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 121
               Right = 230
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumGruppierung_1"
            Begin Extent = 
               Top = 85
               Left = 695
               Bottom = 200
               Right = 887
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumGruppierung"
            Begin Extent = 
               Top = 366
               Left = 38
               Bottom = 481
               ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_ITSM_TXP_Appl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'Right = 230
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "GremiumBereich_1"
            Begin Extent = 
               Top = 246
               Left = 38
               Bottom = 361
               Right = 230
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 18
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 3720
         Alias = 2955
         Table = 4530
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_ITSM_TXP_Appl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_ITSM_TXP_Appl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "Vertragselement"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 114
               Right = 243
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Vertragselement_1"
            Begin Extent = 
               Top = 6
               Left = 281
               Bottom = 114
               Right = 486
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 4200
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Vertragselement'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_Vertragselement'
GO