Code: Select all
USE [hrb_prd_ar]
GO
/****** Object: View [dbo].[HRB_App_Index_Join] Script Date: 4/25/2022 12:33:24 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[HRB_App_Index_Join] (Request_ID, AppCode__c, ForeignKeyReferenceSGAppIndex_, OwnerName__c, CMDBInstanceID__c, SourceNotes__c, Application_Last_Modified_On__, Status__c, ShortDescription__c, ReconciliationIdentity__c, SerialNumber__c, NormalizationStatus__c, LastREJobrunId__c, Name__c, ApplicationType__c) AS SELECT T4593.C1, T4593.C536870913, T4593.C536870915, T4593.C301002900, T4593.C536870916, T4593.C536870917, T4593.C6, T4593.C7, T4593.C8, T4593.C536870920, T4593.C200000001, T4593.C530041601, T4593.C490001289, T4593.C200000020, T4593.C530009800 FROM T4593
GO
/****** Object: View [dbo].[HRB_AppCode_Index] Script Date: 4/25/2022 12:33:24 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[HRB_AppCode_Index] (Request_ID, AppCode, Submitter, ApplicationName, Create_Date, ForeignKeyReferenceSGAppIndex, Assigned_To, CMDBInstanceID, Last_Modified_By, SourceNotes, Modified_Date, Status, Short_Description, ReconciliationIdentity) AS SELECT T4589.C1, T4589.C536870913, T4589.C2, T4589.C536870914, T4589.C3, T4589.C536870915, T4589.C4, T4589.C536870916, T4589.C5, T4589.C536870917, T4589.C6, T4589.C7, T4589.C8, T4589.C536870920 FROM T4589
GO
/****** Object: View [dbo].[HRB_Depot_ServiceMagic] Script Date: 4/25/2022 12:33:24 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[HRB_Depot_ServiceMagic] (Request_ID, Submitter, Create_Date, Assigned_To, Last_Modified_By, Modified_Date, Status, Short_Description, TagNumber, ClassID, Location, StatusEmail, ShippedDate, LocationType, UserId, SerialNumber, OutboundTrackingNum, CIName) AS SELECT T4590.C1, T4590.C2, T4590.C3, T4590.C4, T4590.C5, T4590.C6, T4590.C7, T4590.C8, T4590.C100000061, T4590.C100000060, T4590.C100000063, T4590.C100000062, T4590.C100000069, T4590.C100000068, T4590.C100000065, T4590.C100000064, T4590.C100000067, T4590.C100000066 FROM T4590
GO
/****** Object: View [dbo].[HRB_SG_AppIndex] Script Date: 4/25/2022 12:33:24 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[HRB_SG_AppIndex] (Request_ID, SupportGroupName, Submitter, CIName, Create_Date, ApplicationREID, Assigned_To, SupportGroupID, Last_Modified_By, SupportGroupType, Modified_Date, CIClassID, Status, Short_Description, ApprovalGroupName, ApprovalGroupID, ApprovalGroupType, RelREID, RelDestinationREID, CostCenter, SerialNumber) AS SELECT T4544.C1, T4544.C536870913, T4544.C2, T4544.C536870914, T4544.C3, T4544.C536870915, T4544.C4, T4544.C536870916, T4544.C5, T4544.C536870917, T4544.C6, T4544.C536870918, T4544.C7, T4544.C8, T4544.C536870920, T4544.C536870921, T4544.C536870922, T4544.C1964000001, T4544.C1964000002, T4544.C1964000003, T4544.C10000000 FROM T4544
GO