You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
5611 lines
380 KiB
5611 lines
380 KiB
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
|