RecursiveHierarchyCTE

Question

RecursiveHierarchyCTE

Viewing 13 posts - 16 through 27 (of 27 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Going through your code I found your function, dbo.fn_CSVToTableString. You obviously did NOT read the article I posted a link to for you. There are two major issues with this function.

First is that it uses a while loop to step through the string and parse it. This is not a scalable solution. Please look back to my previous post for the Tally Oh article reference and take the time to read it. Since the input parameter to your stored procedure is declared as an NVARCHAR(MAX) you would be MUCH better off using a CLR function to split the string. There is a CLR function included in the resources for that article if I remember correctly.

Second, the function is coded as multi-statement table valued function. These are also not scalable as the table returned by the function has to be populated before it returns. What you need is an inline table valued function. The code you have written can't be used in an inline tvf.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

I have an idea, since as I go through your code and finding things that just won't work, using the sample data you posted give us a set of tables that provides us with the expected results based on the various inputs you also provided for your stored procedure. This will give us something to test against so we can provide you with test code to meet your requirements.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Here is your script for creating and populating your tables. Notice the changes I made to the script (besides the fact that there is no USE database statement).

/****** Object: Table [dbo].[ActivityDimvw] Script Date: 2014-03-30 10:07:35 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

if object_id('dbo.ActivityDimvw') is not null

drop table dbo.ActivityDimvw;

CREATE TABLE [dbo].[ActivityDimvw](

[ActivityDimKey] [int] NOT NULL,

[ActualCost] [float] NULL,

[ActualDowntimeEndDate] [datetime] NULL,

[ActualDowntimeStartDate] [datetime] NULL,

[ActualEndDate] [datetime] NULL,

[ActualStartDate] [datetime] NULL,

[ActualWork] [float] NULL,

[Area] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Area_ActivityAreaId] [int] NULL,

[BaseManagedEntityId] [uniqueidentifier] NULL,

[ChildId] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ContactMethod] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[CreatedDate] [datetime] NULL,

[Description] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[DisplayName] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Documentation] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[EntityDimKey] [int] NULL,

[FirstAssignedDate] [datetime] NULL,

[FirstResponseDate] [datetime] NULL,

[Id] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[InsertedBatchId] [int] NOT NULL,

[IsDeleted] [int] NULL,

[IsDowntime] [bit] NULL,

[IsParent] [bit] NULL,

[Notes] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[PlannedCost] [float] NULL,

[PlannedWork] [float] NULL,

[Priority] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Priority_ActivityPriorityId] [int] NULL,

[RequiredBy] [datetime] NULL,

[ScheduledDowntimeEndDate] [datetime] NULL,

[ScheduledDowntimeStartDate] [datetime] NULL,

[ScheduledEndDate] [datetime] NULL,

[ScheduledStartDate] [datetime] NULL,

[SequenceId] [int] NULL,

[Skip] [bit] NULL,

[SourceId] [uniqueidentifier] NOT NULL,

[Stage] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Stage_ActivityStageId] [int] NULL,

[Status] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Status_ActivityStatusId] [int] NULL,

[Title] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[UpdatedBatchId] [int] NOT NULL

) ON [PRIMARY]

GO

/****** Object: Table [dbo].[RelationshipView] Script Date: 2014-03-30 10:07:35 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

if object_id('dbo.RelationshipView') is not null

drop table dbo.RelationshipView;

CREATE TABLE [dbo].[RelationshipView](

[ad_Id] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ad_SequenceId] [int] NULL,

[ad_Title] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[workitem_Id] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[TargetEntityId] [uniqueidentifier] NOT NULL,

[SourceEntityId] [uniqueidentifier] NOT NULL

) ON [PRIMARY]

GO

/****** Object: Table [dbo].[WorkItemContainsActivityFactvw] Script Date: 2014-03-30 10:07:35 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

if object_id('dbo.WorkItemContainsActivityFactvw') is not null

drop table dbo.WorkItemContainsActivityFactvw;

CREATE TABLE [dbo].[WorkItemContainsActivityFactvw](

[CreatedDate] [datetime] NULL,

[DateKey] [int] NOT NULL,

[DeletedDate] [datetime] NULL,

[InsertedBatchId] [int] NOT NULL,

[UpdatedBatchId] [int] NOT NULL,

[WorkItemContainsActivity_ActivityDimKey] [int] NOT NULL,

[WorkItemDimKey] [int] NOT NULL

) ON [PRIMARY]

GO

/****** Object: Table [dbo].[WorkItemDimvw] Script Date: 2014-03-30 10:07:35 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

if object_id('dbo.WorkItemDimvw') is not null

drop table dbo.WorkItemDimvw;

CREATE TABLE [dbo].[WorkItemDimvw](

[BaseManagedEntityId] [uniqueidentifier] NULL,

[CreatedDate] [datetime] NULL,

[EntityDimKey] [int] NULL,

[Id] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[InsertedBatchId] [int] NOT NULL,

[IsDeleted] [int] NULL,

[SourceId] [uniqueidentifier] NOT NULL,

[Title] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[UpdatedBatchId] [int] NOT NULL,

[WorkItemDimKey] [int] NOT NULL

) ON [PRIMARY]

GO

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (4475, NULL, NULL, NULL, NULL, NULL, NULL, N'Enum.c7287b3d9d764b53afb57042798e3d5a', 67, N'd42303ac-84f6-daf8-38ce-0fc7fbbcacae', N'7389', NULL, CAST(0x0000A2E300B68845 AS DateTime), N'Received policy and checklist for relevant IT Technician to file', N'MA43662', NULL, 312799, CAST(0x0000A2E300BA6AA3 AS DateTime), NULL, N'MA43662', 253667, 0, NULL, NULL, N'No Policy Needed

No Checklist Received', NULL, NULL, N'ActivityPriorityEnum.Medium', 3, NULL, NULL, NULL, NULL, NULL, 8, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', N'ActivityStageEnum.Initiate', 5, N'ActivityStatusEnum.Completed', 2, N'Policy and Checklist - P7 New Employee - Alita Steenekamp - Start Date 03 03 2014 (Takeover Desktop)', 271648)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (4478, NULL, NULL, NULL, NULL, NULL, NULL, N'Enum.c7287b3d9d764b53afb57042798e3d5a', 67, N'9813dae3-b3cd-8b9d-4bb9-2fe1c1f9acd7', N'7387', NULL, CAST(0x0000A2E300B68836 AS DateTime), N'IT Technician and user go through checklist together and user must sign it off.', N'MA43661', NULL, 312836, CAST(0x0000A2E300BA6AA3 AS DateTime), NULL, N'MA43661', 253667, 0, NULL, NULL, N'Done', NULL, NULL, N'ActivityPriorityEnum.Medium', 3, NULL, NULL, NULL, NULL, NULL, 7, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', N'ActivityStageEnum.Initiate', 5, N'ActivityStatusEnum.Completed', 2, N'IT check list - P7 New Employee - Alita Steenekamp - Start Date 03 03 2014 (Takeover Desktop)', 261199)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (4480, NULL, NULL, NULL, NULL, NULL, NULL, N'Enum.2a771d5a8e604a828d29ae23afee5e57', 74, N'ddd199d4-c783-48b6-4b09-457f0c2218ed', N'7371', NULL, CAST(0x0000A2E300B687EE AS DateTime), N'Create Active Directory Account / Email', N'MA43657', NULL, 312860, CAST(0x0000A2E300BA6AA3 AS DateTime), NULL, N'MA43657', 253667, 0, NULL, NULL, N'done', NULL, NULL, N'ActivityPriorityEnum.Medium', 3, NULL, NULL, NULL, NULL, NULL, 4, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', N'ActivityStageEnum.Initiate', 5, N'ActivityStatusEnum.Completed', 2, N'Create AD\Email - P7 New Employee - Alita Steenekamp - Start Date 03 03 2014 (Takeover Desktop)', 254367)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (4483, NULL, NULL, NULL, NULL, NULL, NULL, N'Enum.6c1efaf700b54ba4a19333b5b3bf77b0', 73, N'1b9cb0f9-61c1-849c-4b64-655ab355bf9f', N'5356', NULL, CAST(0x0000A2E300B68763 AS DateTime), N'Create Username and Password for user on relevant database', N'MA43651', NULL, 312904, CAST(0x0000A2E300BA6AA3 AS DateTime), NULL, N'MA43651', 253667, 0, NULL, NULL, N'Done

===

Date (UTC): 3/7/2014 9:50:57 AM User: VPN\cVerheijen

Done

[Completed]', NULL, NULL, N'ActivityPriorityEnum.Medium', 3, NULL, NULL, NULL, NULL, NULL, 0, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', N'ActivityStageEnum.Initiate', 5, N'ActivityStatusEnum.Completed', 2, N'Placement Partner Access - P7 New Employee - Alita Steenekamp - Start Date 03 03 2014 (Takeover Desktop)', 256606)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (4484, NULL, NULL, NULL, NULL, NULL, NULL, N'Enum.d6b236bc76674767beabd9e60b173dc9', 65, N'0dd54c79-a0e1-7cd8-f891-679b53576f89', N'7383', NULL, CAST(0x0000A2E300B6880E AS DateTime), NULL, N'MA43659', NULL, 312905, CAST(0x0000A2E300BA6AA3 AS DateTime), NULL, N'MA43659', 253667, 0, NULL, NULL, N'Done', NULL, NULL, N'ActivityPriorityEnum.Medium', 3, NULL, NULL, NULL, NULL, NULL, 6, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', N'ActivityStageEnum.Initiate', 5, N'ActivityStatusEnum.Completed', 2, N'Setup VOIP phone at branch - P7 New Employee - Alita Steenekamp - Start Date 03 03 2014 (Takeover Desktop)', 261199)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (4493, NULL, NULL, NULL, NULL, NULL, NULL, N'Enum.c7287b3d9d764b53afb57042798e3d5a', 67, N'dde389fd-2d86-4208-a163-9f4f0137a1a7', N'7391', NULL, CAST(0x0000A2E300B68863 AS DateTime), N'Update Pastel with relevant Assets', N'MA43663', NULL, 312970, CAST(0x0000A2E300BA6AA3 AS DateTime), NULL, N'MA43663', 253667, 0, NULL, NULL, N'Done', NULL, NULL, N'ActivityPriorityEnum.Medium', 3, NULL, NULL, NULL, NULL, NULL, 9, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', N'ActivityStageEnum.Initiate', 5, N'ActivityStatusEnum.Completed', 2, N'Update Pastel - P7 New Employee - Alita Steenekamp - Start Date 03 03 2014 (Takeover Desktop)', 271648)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5182, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'879c1960-e170-f734-5777-034deb61ab2c', N'4494', NULL, CAST(0x0000A2F400C74936 AS DateTime), N'TEST', N'PA49948', NULL, 353727, NULL, NULL, N'PA49948', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 6, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Give System Rights', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (4496, NULL, NULL, NULL, NULL, NULL, NULL, N'Enum.d5c2fc1d19034036ac618f18161cb5e0', 69, N'4ef1b10c-b820-0a37-acf2-b9a4371a841b', N'7369', NULL, CAST(0x0000A2E300B687D0 AS DateTime), N'Create user profile on EWS and TMS', N'MA43656', NULL, 313004, CAST(0x0000A2E300BA6AA3 AS DateTime), NULL, N'MA43656', 253667, 0, NULL, NULL, N'Done', NULL, NULL, N'ActivityPriorityEnum.Medium', 3, NULL, NULL, NULL, NULL, NULL, 3, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', N'ActivityStageEnum.Initiate', 5, N'ActivityStatusEnum.Completed', 2, N'User Profile on VOIP - P7 New Employee - Alita Steenekamp - Start Date 03 03 2014 (Takeover Desktop)', 271648)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (4497, NULL, NULL, NULL, NULL, NULL, NULL, N'Enum.c7287b3d9d764b53afb57042798e3d5a', 67, N'b9ad687f-e786-4672-6015-b9b69980a062', N'5352', NULL, CAST(0x0000A2E300B68737 AS DateTime), N'Create Access for New User', N'PA43649', NULL, 313005, CAST(0x0000A2E300BA6AA3 AS DateTime), NULL, N'PA43649', 253667, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', N'ActivityStageEnum.Initiate', 5, N'ActivityStatusEnum.Completed', 2, N'P7 ', 271648)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5213, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'3a8e7474-d1bf-de1b-fbf1-defe91b23c70', N'4498', NULL, CAST(0x0000A2F400C74949 AS DateTime), N'TEST', N'MA49950', NULL, 353890, NULL, NULL, N'MA49950', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Allocate CRM Rights', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5214, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'732febbd-9252-546f-af01-e193108f14d8', N'4438', NULL, CAST(0x0000A2F400C7489D AS DateTime), N'TEST', N'MA49934', NULL, 353894, NULL, NULL, N'MA49934', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'SharePoint Access', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5184, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'dccfdeda-a02f-2d0e-22e6-1ee110601f04', N'4413', NULL, CAST(0x0000A2F400C748FB AS DateTime), N'TEST', N'MA49943', NULL, 353742, NULL, NULL, N'MA49943', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Quote\Order new Printer', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (4498, NULL, NULL, NULL, NULL, NULL, NULL, N'Enum.d6b236bc76674767beabd9e60b173dc9', 65, N'98046992-6739-9257-28bf-c362405d3978', N'7363', NULL, CAST(0x0000A2E300B6878F AS DateTime), N'Install all software according to IT Check list onto desktop / laptop', N'MA43653', NULL, 313018, CAST(0x0000A2E300BA6AA3 AS DateTime), NULL, N'MA43653', 253667, 0, NULL, NULL, N'Done', NULL, NULL, N'ActivityPriorityEnum.Medium', 3, NULL, NULL, NULL, NULL, NULL, 2, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', N'ActivityStageEnum.Initiate', 5, N'ActivityStatusEnum.Completed', 2, N'Install Machine - P7 New Employee - Alita Steenekamp - Start Date 03 03 2014 (Takeover Desktop)', 264206)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (4503, NULL, NULL, NULL, NULL, NULL, NULL, N'Enum.d6b236bc76674767beabd9e60b173dc9', 65, N'776bbd69-a5cd-154d-7507-e78229f10f1f', N'7381', NULL, CAST(0x0000A2E300B68800 AS DateTime), N'Setup and configure new user''s workstation', N'MA43658', NULL, 313070, CAST(0x0000A2E300BA6AA3 AS DateTime), NULL, N'MA43658', 253667, 0, NULL, NULL, N'Done', NULL, NULL, N'ActivityPriorityEnum.Medium', 3, NULL, NULL, NULL, NULL, NULL, 5, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', N'ActivityStageEnum.Initiate', 5, N'ActivityStatusEnum.Completed', 2, N'User''s workstation - P7 New Employee - Alita Steenekamp - Start Date 03 03 2014 (Takeover Desktop)', 264206)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5185, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'7a0805b6-dfd1-6e8c-fc54-3086b40b5707', N'4505', NULL, CAST(0x0000A2F400C74962 AS DateTime), N'TEST', N'MA49953', NULL, 353747, NULL, NULL, N'MA49953', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Allocate SCSM Rights', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5186, NULL, NULL, NULL, NULL, NULL, NULL, N'ActivityAreaEnum.Infrastructure', 6, N'4493fc79-c094-df24-eb05-30f21dab7aaa', N'4396', NULL, CAST(0x0000A2F400C74992 AS DateTime), N'TEST', N'MA49957', NULL, 353749, NULL, NULL, N'MA49957', 266375, 0, NULL, NULL, NULL, NULL, NULL, N'ActivityPriorityEnum.Medium', 3, NULL, NULL, NULL, NULL, NULL, 1, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', N'ActivityStageEnum.Initiate', 5, N'ActivityStatusEnum.Ready', 9, N'Give access to VIP', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5187, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'03a38198-7bad-7c87-115a-3bb4c24f0d55', N'4507', NULL, CAST(0x0000A2F400C748CB AS DateTime), N'TEST', N'MA49938', NULL, 353760, NULL, NULL, N'MA49938', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 7, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Setup and configure new user''s workstation ', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5188, NULL, NULL, NULL, NULL, NULL, NULL, N'ActivityAreaEnum.Infrastructure', 6, N'c70a66ea-10ef-cf0f-b7f2-3d6f02b03959', N'4398', NULL, CAST(0x0000A2F400C749A2 AS DateTime), N'TEST', N'MA49958', NULL, 353763, NULL, NULL, N'MA49958', 266375, 0, NULL, NULL, NULL, NULL, NULL, N'ActivityPriorityEnum.Medium', 3, NULL, NULL, NULL, NULL, NULL, 2, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', N'ActivityStageEnum.Initiate', 5, N'ActivityStatusEnum.Ready', 9, N'Give access to Pencil Box', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5189, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'197d4488-496c-a15d-15db-4a0964a15ea1', N'4442', NULL, CAST(0x0000A2F400C748B6 AS DateTime), N'TEST', N'MA49936', NULL, 353772, NULL, NULL, N'MA49936', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Update mobility manager', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5191, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'066d9e18-73ca-910e-a502-50f4e022e348', N'4492', NULL, CAST(0x0000A2F400C748BF AS DateTime), NULL, N'RA49937', NULL, 353777, NULL, NULL, N'RA49937', 266375, 0, NULL, NULL, N'TEST', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', N'ActivityStageEnum.ValidateAndReview', 3, N'ActivityStatusEnum.Ready', 9, N'Allocate SAM Rights to BPA to Authorize P7 form', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5193, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'51151bdf-f0db-6fcd-fd33-5b845cdc0319', N'4411', NULL, CAST(0x0000A2F400C748F3 AS DateTime), N'TEST', N'MA49942', NULL, 353784, NULL, NULL, N'MA49942', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Quote\Order new Workstation + Cable Lock', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5194, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'593ee3e9-4f35-9ee6-5f16-5e42586dc536', N'4503', NULL, CAST(0x0000A2F400C7495B AS DateTime), N'TEST', N'MA49952', NULL, 353787, NULL, NULL, N'MA49952', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Allocate Alias Rights', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5195, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'9a2f615f-5d2d-82f1-07cd-67f5a50e7f1a', N'4501', NULL, CAST(0x0000A2F400C74955 AS DateTime), N'TEST', N'MA49951', NULL, 353793, NULL, NULL, N'MA49951', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Allocate AX Rights', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5196, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'38db0840-0a77-ad5f-3214-6b808244d7a7', N'4496', NULL, CAST(0x0000A2F400C74942 AS DateTime), N'TEST', N'MA49949', NULL, 353801, NULL, NULL, N'MA49949', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Allocate CAMS Rights', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5197, NULL, NULL, NULL, NULL, NULL, NULL, N'ActivityAreaEnum.Infrastructure', 6, N'1e77f5d8-e247-b98f-3557-7667b399fa07', N'4393', NULL, CAST(0x0000A2F400C74983 AS DateTime), N'TEST', N'MA49956', NULL, 353810, NULL, NULL, N'MA49956', 266375, 0, NULL, NULL, NULL, NULL, NULL, N'ActivityPriorityEnum.Medium', 3, NULL, NULL, NULL, NULL, NULL, 0, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', N'ActivityStageEnum.Initiate', 5, N'ActivityStatusEnum.Ready', 9, N'Give access to Pastel', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5198, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'2db66d5b-b86e-fa1b-df97-771dba9db337', N'4431', NULL, CAST(0x0000A2F400C7487B AS DateTime), N'TEST', N'PA49932', NULL, 353811, NULL, NULL, N'PA49932', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Install\Configure New Workstation', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5202, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'81f62900-87b2-8ca5-9eb8-92c82efd58e4', N'5202', NULL, CAST(0x0000A2F400C74922 AS DateTime), NULL, N'RA49946', NULL, 353836, NULL, NULL, N'RA49946', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Review and approve hardware quotes', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5207, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'e38577b1-6b93-8a38-f374-be2db22df0e5', N'4425', NULL, CAST(0x0000A2F400C7490C AS DateTime), N'TEST', N'MA49945', NULL, 353862, NULL, NULL, N'MA49945', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Quote\Order new Phone hand set', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5184, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'dccfdeda-a02f-2d0e-22e6-1ee110601f04', N'4413', NULL, CAST(0x0000A2F400C748FB AS DateTime), N'TEST', N'MA49943', NULL, 353742, NULL, NULL, N'MA49943', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Quote\Order new Printer', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5200, NULL, NULL, NULL, NULL, NULL, NULL, N'ActivityAreaEnum.Infrastructure', 6, N'ac2b7e48-958f-a5c8-517a-8b293803f9a5', N'4387', NULL, CAST(0x0000A2F400C74929 AS DateTime), N'TEST', N'MA49947', NULL, 353826, CAST(0x0000A2F400C9A124 AS DateTime), NULL, N'MA49947', 266375, 0, NULL, NULL, NULL, NULL, NULL, N'ActivityPriorityEnum.Medium', 3, NULL, NULL, NULL, NULL, NULL, 0, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', N'ActivityStageEnum.Initiate', 5, N'ActivityStatusEnum.Active', 5, N'Create AD\Email and Network Drivers', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5203, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'608337ee-853e-44e1-875b-99bdbb01d7e3', N'4511', NULL, CAST(0x0000A2F400C748DF AS DateTime), N'Review system access and all needed utilities are availible that the new user is able to work', N'RA49940', N'TEST', 353840, NULL, NULL, N'RA49940', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Review User', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5205, NULL, NULL, NULL, NULL, NULL, NULL, N'ActivityAreaEnum.Infrastructure', 6, N'8106c486-7ae4-a03a-6131-a183439507f6', N'4391', NULL, CAST(0x0000A2F400C74977 AS DateTime), N'TEST', N'PA49955: System Access', NULL, 353846, NULL, NULL, N'PA49955', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', N'ActivityStageEnum.Initiate', 5, N'ActivityStatusEnum.Ready', 9, N'System Access', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5206, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'fb6ad688-9a09-c313-9fa9-aa86ee3c17ab', N'4401', NULL, CAST(0x0000A2F400C748EB AS DateTime), N'TEST', N'PA49941: Quote\Order a new workstation ', NULL, 353851, CAST(0x0000A2F400C83C6A AS DateTime), NULL, N'PA49941', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Quote\Order a new workstation ', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5209, NULL, NULL, NULL, NULL, NULL, NULL, N'Enum.4e85a6952ec44d8ab30b7c31d8f37ca7', 63, N'3749b8c3-e141-e59b-d7be-be8e21ef6ed6', N'5957', NULL, CAST(0x0000A2F400C7496B AS DateTime), N'TEST', N'MA49954', NULL, 353865, NULL, NULL, N'MA49954', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', N'Enum.c875db4add10499893cc95b7b3776f06', 8, N'ActivityStatusEnum.Ready', 9, N'Allocate Intralink Rights', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5211, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'0f45a989-6459-7f6f-8a86-cdc50992d7f7', N'4509', NULL, CAST(0x0000A2F400C748D6 AS DateTime), N'Update Asset Register

Update Phone CodeList

Update Copire Code List

Update Cable Lock Code List

Update Mobility Manager', N'MA49939', N'TEST', 353877, NULL, NULL, N'MA49939', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Update Register', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5212, NULL, NULL, NULL, NULL, NULL, NULL, N'ActivityAreaEnum.Infrastructure', 6, N'24e9420f-1824-fd9b-a7c9-d9aa710ae498', N'4434', NULL, CAST(0x0000A2F400C74888 AS DateTime), N'TEST', N'MA49933', NULL, 353883, NULL, NULL, N'MA49933', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Install Machine', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (4474, NULL, NULL, NULL, NULL, NULL, NULL, N'Enum.1555428fed3a4dca9835c5e035ef0d4e', 66, N'53c40824-56e3-0416-548c-069975ab9d98', N'7361', NULL, CAST(0x0000A2E300B68773 AS DateTime), N'Get username and password for user from 3rd Parties

Career Junction

PNet', N'MA43652', NULL, 312786, CAST(0x0000A2E300BA6AA3 AS DateTime), NULL, N'MA43652', 253667, 0, NULL, NULL, N'HI

She is loaded under freight (only being paid by Supply Chain)

PNet has been requested

CJ

cpgdbnfcj@communicate.co.zaCPG-Freight Twocdf321cdf655Alita Steenekamp

Bev a call just needs to be loaded for PP access please

Corlien

===

Date (UTC): 3/7/2014 9:50:58 AM User: VPN\cVerheijen

Done

[Completed]', NULL, NULL, N'ActivityPriorityEnum.Medium', 3, NULL, NULL, NULL, NULL, NULL, 1, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', N'ActivityStageEnum.Initiate', 5, N'ActivityStatusEnum.Completed', 2, N'3rd Partiy Access - P7 New Employee - Alita Steenekamp - Start Date 03 03 2014 (Takeover Desktop)', 256606)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (4475, NULL, NULL, NULL, NULL, NULL, NULL, N'Enum.c7287b3d9d764b53afb57042798e3d5a', 67, N'd42303ac-84f6-daf8-38ce-0fc7fbbcacae', N'7389', NULL, CAST(0x0000A2E300B68845 AS DateTime), N'Received policy and checklist for relevant IT Technician to file', N'MA43662', NULL, 312799, CAST(0x0000A2E300BA6AA3 AS DateTime), NULL, N'MA43662', 253667, 0, NULL, NULL, N'No Policy Needed

No Checklist Received', NULL, NULL, N'ActivityPriorityEnum.Medium', 3, NULL, NULL, NULL, NULL, NULL, 8, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', N'ActivityStageEnum.Initiate', 5, N'ActivityStatusEnum.Completed', 2, N'Policy and Checklist - P7 New Employee - Alita Steenekamp - Start Date 03 03 2014 (Takeover Desktop)', 271648)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (4478, NULL, NULL, NULL, NULL, NULL, NULL, N'Enum.c7287b3d9d764b53afb57042798e3d5a', 67, N'9813dae3-b3cd-8b9d-4bb9-2fe1c1f9acd7', N'7387', NULL, CAST(0x0000A2E300B68836 AS DateTime), N'IT Technician and user go through checklist together and user must sign it off.', N'MA43661', NULL, 312836, CAST(0x0000A2E300BA6AA3 AS DateTime), NULL, N'MA43661', 253667, 0, NULL, NULL, N'Done', NULL, NULL, N'ActivityPriorityEnum.Medium', 3, NULL, NULL, NULL, NULL, NULL, 7, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', N'ActivityStageEnum.Initiate', 5, N'ActivityStatusEnum.Completed', 2, N'IT check list - P7 New Employee - Alita Steenekamp - Start Date 03 03 2014 (Takeover Desktop)', 261199)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5181, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'36ff6ab1-2114-b9f7-e0cb-0283b5bd44de', N'4416', NULL, CAST(0x0000A2F400C74903 AS DateTime), N'TEST', N'MA49944', NULL, 353726, NULL, NULL, N'MA49944', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Quote\Order new 3G card', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5182, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'879c1960-e170-f734-5777-034deb61ab2c', N'4494', NULL, CAST(0x0000A2F400C74936 AS DateTime), N'TEST', N'PA49948', NULL, 353727, NULL, NULL, N'PA49948', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 6, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Give System Rights', 0)

INSERT [dbo].[ActivityDimvw] ([ActivityDimKey], [ActualCost], [ActualDowntimeEndDate], [ActualDowntimeStartDate], [ActualEndDate], [ActualStartDate], [ActualWork], [Area], [Area_ActivityAreaId], [BaseManagedEntityId], [ChildId], [ContactMethod], [CreatedDate], [Description], [DisplayName], [Documentation], [EntityDimKey], [FirstAssignedDate], [FirstResponseDate], [Id], [InsertedBatchId], [IsDeleted], [IsDowntime], [IsParent], [Notes], [PlannedCost], [PlannedWork], [Priority], [Priority_ActivityPriorityId], [RequiredBy], [ScheduledDowntimeEndDate], [ScheduledDowntimeStartDate], [ScheduledEndDate], [ScheduledStartDate], [SequenceId], [Skip], [SourceId], [Stage], [Stage_ActivityStageId], [Status], [Status_ActivityStatusId], [Title], [UpdatedBatchId]) VALUES (5183, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'f89548a6-5aed-a12e-7c76-11f19eeaeaab', N'4440', NULL, CAST(0x0000A2F400C748AC AS DateTime), N'TEST', N'MA49935', NULL, 353734, NULL, NULL, N'MA49935', 266375, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 0, N'786faba5-2877-8cf4-d759-4b9d94ca9739', NULL, NULL, N'ActivityStatusEnum.Ready', 9, N'Update Registery', 0)