Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Slowly Changing dimension inside a ForEach Loop container Expand / Collapse
Author
Message
Posted Thursday, August 21, 2014 5:16 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 10, 2014 3:07 PM
Points: 48, Visits: 148
Phil Parkin (8/20/2014)
Koen has already provided a link to an article which he wrote which demonstrates how to do this without using the SCD component. I think that you should invest your time in rewriting your package accordingly.


Phil, I tried that. It didn't work. Perhaps you are right and I didn't spend enough time on it but I will today!

Koen Verbeeck (8/21/2014)
At this point, it might be useful to show us some screenshots and maybe some table DDL so we can provide more specific assistance.


I will provide some screenshots and table DDL Koen as soon as I get to work.

Thank you guys so much!
Romina
Post #1605754
Posted Thursday, August 21, 2014 5:30 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 1:04 PM
Points: 420, Visits: 996

For example, for a particular employee there might be 141 records in this "huge dumping table" but when I perform the SCD, only 14 records make it to the DW after getting rid of duplicates and updating historical records.

I am interested in seeing some DDL and sample data. Does this 'dumping' table also contain all historical records? Are you loading a dimension table ultimately ? One idea refers back to what Phil and Koen mention when they state "set based" operations. Here I illustrate that in a simple image. This is what the SCD wizard generates. According to what I've read most of your records will be new. The image shows that those that are not can be loaded into separate staging tables. From there you perform execute sql tasks to take care of each of these tables. For example, the Historical output will mean that you , I assume . have something like a validFrom , ValidTo date fields in the destination dimension? If an attribute columns value has changed then change the validTo of the destination table record to the current datetime and insert the new record. All this is done in t-SQL. THis will be a lot faster because the whole tables can be loaded into the memory buffer, rather than only one row at a time with the SCD transform. With sample data and DDLs I can illustrate better.

If this is still a perfromance drag then you will have to bypass the whole SCD entirely. But for now these are not to bad to try.


  Post Attachments 
SCD auto generated data flow.png (0 views, 69.76 KB)
Post #1606077
Posted Thursday, August 21, 2014 5:55 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:18 PM
Points: 5,438, Visits: 7,606
To add to the recommendation to remove it, the SCD component in SSIS (at least in 05 and 08) is a piece of crap. The Inserts are fine. The Updates are Row by Row, as are Deletes, simply because the component has to be generic enough to handle all styles handled to it with the same code.

There are a number of tools in SSIS that are available so they exist, but they are not the best tool to use when you're working against a Database Engine. Sort, Aggregations, SCD, etc. are performance killers in SSIS. This is because they interrupt the flow/stream of data. They are typically there more for when you're using SSIS against non-native systems or simple datastores (DB2?), for example you need to sort a flat file to merge it to another flat file to output a third flatfile. Nowhere in there would you typically touch an engine.

Not all tools are created equal for all jobs.



- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1606079
Posted Friday, August 22, 2014 1:45 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 10, 2014 3:07 PM
Points: 48, Visits: 148
Hi folks,

I sincerely want to thank you first for taking the time to try to help me! Your help is much appreciated!

Ok, since my last post I have gone and spent some more time trying to work with the custom SCD as per Phil's advice. I am almost getting it to work but I have some more tweaking to do.

MMartin you also had some very good points. First I will show you my source and destination table DDLs.

USE [HR_DataMart]
GO

/****** Object: Table [dbo].[EmployeeMaster] Script Date: 8/22/2014 10:25:41 AM ******/

/* Description:
The data on this table comes from an SP run every week that extracts data from
a mainframe HR system into the table below in SQL. This table is used as 'dump'
table. No indexes, no primary keys and no data checking. At the moment the
record count on this table is 4,397,683.
*/

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[EmployeeMaster](
[ExtractDate] [datetime] NOT NULL,
[GroupID] [int] NULL,
[DivisionCode] [varchar](4) NULL,
[Division] [varchar](100) NULL,
[RegionCode] [varchar](50) NULL,
[Region] [varchar](100) NULL,
[MarketCode] [varchar](50) NULL,
[Market] [varchar](100) NULL,
[ParentHSPCode] [nchar](10) NULL,
[HRParentId] [int] NULL,
[HRParentName] [varchar](255) NULL,
[ORG] [varchar](8) NOT NULL,
[FacId] [int] NOT NULL,
[Facility] [varchar](48) NULL,
[FacilityAlphaValue] [varchar](3) NOT NULL,
[FacilityName] [varchar](255) NULL,
[WorkFacId] [int] NULL,
[WorkFacilityAlphaValue] [varchar](3) NULL,
[EmpMail Street Address] [varchar](24) NULL,
[EmpMail City] [varchar](16) NULL,
[EmpMail State] [char](2) NOT NULL,
[EmpMail Zip] [varchar](10) NOT NULL,
[FullName] [varchar](24) NULL,
[MaidenName] [char](20) NULL,
[LastName] [varchar](24) NULL,
[FirstName] [varchar](15) NULL,
[MiddleName] [varchar](15) NULL,
[PreferredName] [char](20) NULL,
[SSN] [char](11) NOT NULL,
[EeNum] [int] NULL,
[RequisitionNumber] [char](10) NULL,
[ApplicantID] [char](13) NULL,
[PositionControlNumber] [varchar](20) NULL,
[Status AIT] [char](1) NOT NULL,
[StatusF12Code] [char](1) NOT NULL,
[PerDiemInd] [char](1) NOT NULL,
[EthnicCode] [char](1) NOT NULL,
[BirthDate] [varchar](30) NULL,
[Original Hire Date] [varchar](30) NULL,
[CurrHireDate] [varchar](30) NULL,
[Transfer Date] [varchar](30) NULL,
[Transfer From Facility] [varchar](3) NULL,
[Reinstatement Date] [varchar](30) NULL,
[Acquisition Date] [varchar](30) NULL,
[JobCodeEffDate] [varchar](30) NULL,
[DeptEffDate] [varchar](30) NULL,
[TerminationDate] [varchar](30) NULL,
[TermCode] [char](2) NULL,
[TermReason] [varchar](100) NULL,
[TermStatus] [char](1) NULL,
[TermCategoryDesc] [varchar](30) NULL,
[RIF Date] [varchar](30) NULL,
[Term Security Date] [varchar](30) NULL,
[Gender] [char](1) NOT NULL,
[MaritalStatusCode] [char](1) NOT NULL,
[Job Code] [varchar](8) NULL,
[Jcode] [varchar](4) NULL,
[UnionJobCode] [varchar](1) NULL,
[EEOCode] [char](1) NULL,
[Title] [varchar](24) NULL,
[Job Class] [char](2) NULL,
[Job Class Desc] [varchar](100) NOT NULL,
[ManagerCode] [char](1) NOT NULL,
[BaseRate] [numeric](9, 4) NOT NULL,
[ScheduledHours] [varchar](30) NULL,
[Dept] [char](6) NOT NULL,
[HomeShift] [char](1) NULL,
[EELevelUnionInd] [char](1) NULL,
[UnionCode] [varchar](6) NULL,
[Local Code] [varchar](8) NULL,
[YearsOfExperience] [int] NULL,
[Tenure] [decimal](9, 2) NULL,
[AcquisitionTenure] [decimal](9, 2) NULL,
[Work Location Code] [char](3) NULL,
[Work Location Address] [varchar](50) NULL,
[Work Location City] [varchar](50) NULL,
[Work Location State] [varchar](2) NULL,
[Work Location Zip] [varchar](10) NULL,
[Work Location County] [varchar](20) NULL,
[SupervisorID] [int] NULL,
[SupervisorName] [varchar](50) NULL,
[DeptMgrID] [int] NULL,
[DeptMgrName] [varchar](50) NULL,
[ExecSalaryMgrID] [int] NULL,
[ExecSalaryMgrName] [varchar](50) NULL,
[WorkEmail] [varchar](50) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


I have made a local copy of this table into another database and added keys and indexes as required.

Now the destination table is very different and is more a fact table than a dimension table. The DDL for the fact or destination table is:


USE [HRDataMart_Dev]
GO

/****** Object: Table [dbo].[EmployeeFactMergeInsert$] Script Date: 8/22/2014 10:36:48 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[EmployeeFactMergeInsert$](
[EmployeeRecordID] [int] IDENTITY(1,1) NOT NULL,
[EmployeeContactID] [int] NOT NULL,
[FacilityKeyID] [int] NOT NULL,
[WorkLocationID] [int] NOT NULL,
[EmploymentStatusID] [int] NOT NULL,
[DepartmentKeyID] [int] NOT NULL,
[ManagerCode] [char](1) NOT NULL,
[JobRecordID] [int] NOT NULL,
[EmployeeNumber] [int] NULL,
[SupervisorNumber] [int] NULL,
[DeptManagerNumber] [int] NULL,
[ExecSalaryNumber] [int] NULL,
[OriginalHireDate] [datetime] NULL,
[CurrentHireDate] [datetime] NULL,
[DeptEffectiveDate] [datetime] NULL,
[JobCodeEffectiveDate] [datetime] NULL,
[RIFDate] [datetime] NULL,
[TerminationDate] [datetime] NULL,
[TerminationSecurityDate] [datetime] NULL,
[TerminationCode] [char](2) NULL,
[TransferDate] [datetime] NULL,
[TransferFacilityKeyID] [int] NULL,
[ReinstatementDate] [datetime] NULL,
[AcquisitionDate] [datetime] NULL,
[RequisitionNumber] [varchar](10) NULL,
[PositionControlNumber] [varchar](20) NULL,
[ApplicantID] [varchar](13) NULL,
[BaseRate] [numeric](9, 4) NULL,
[ScheduledHours] [varchar](30) NULL,
[EffectiveDate] [datetime] NULL,
[EndDate] [datetime] NULL,
[IsActive] [bit] NULL,
[ExtractDate] [datetime] NULL,
[MaintDate] [datetime] NULL,
CONSTRAINT [PK_EmployeeFactMergeInsert$] PRIMARY KEY CLUSTERED
(
[EmployeeRecordID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[EmployeeFactMergeInsert$] ADD CONSTRAINT [DF_EmployeeFactMergeInsert$_MaintDate] DEFAULT (getdate()) FOR [MaintDate]
GO

ALTER TABLE [dbo].[EmployeeFactMergeInsert$] WITH NOCHECK ADD CONSTRAINT [FK_EmployeeFactMergeInsert$_ContactDetails$] FOREIGN KEY([EmployeeContactID])
REFERENCES [dbo].[ContactDetails$] ([EmployeeContactID])
GO

ALTER TABLE [dbo].[EmployeeFactMergeInsert$] CHECK CONSTRAINT [FK_EmployeeFactMergeInsert$_ContactDetails$]
GO

ALTER TABLE [dbo].[EmployeeFactMergeInsert$] WITH NOCHECK ADD CONSTRAINT [FK_EmployeeFactMergeInsert$_Department$] FOREIGN KEY([DepartmentKeyID])
REFERENCES [dbo].[Department$] ([DepartmentKeyID])
GO

ALTER TABLE [dbo].[EmployeeFactMergeInsert$] CHECK CONSTRAINT [FK_EmployeeFactMergeInsert$_Department$]
GO

ALTER TABLE [dbo].[EmployeeFactMergeInsert$] WITH NOCHECK ADD CONSTRAINT [FK_EmployeeFactMergeInsert$_EmploymentStatus$] FOREIGN KEY([EmploymentStatusID])
REFERENCES [dbo].[EmploymentStatus$] ([EmploymentStatusID])
GO

ALTER TABLE [dbo].[EmployeeFactMergeInsert$] CHECK CONSTRAINT [FK_EmployeeFactMergeInsert$_EmploymentStatus$]
GO

ALTER TABLE [dbo].[EmployeeFactMergeInsert$] WITH NOCHECK ADD CONSTRAINT [FK_EmployeeFactMergeInsert$_Facility$] FOREIGN KEY([FacilityKeyID])
REFERENCES [dbo].[Facility$] ([FacilityKeyID])
GO

ALTER TABLE [dbo].[EmployeeFactMergeInsert$] CHECK CONSTRAINT [FK_EmployeeFactMergeInsert$_Facility$]
GO

ALTER TABLE [dbo].[EmployeeFactMergeInsert$] WITH NOCHECK ADD CONSTRAINT [FK_EmployeeFactMergeInsert$_Job_H$] FOREIGN KEY([JobRecordID])
REFERENCES [dbo].[Job_H$] ([JobRecordID])
GO

ALTER TABLE [dbo].[EmployeeFactMergeInsert$] CHECK CONSTRAINT [FK_EmployeeFactMergeInsert$_Job_H$]
GO

ALTER TABLE [dbo].[EmployeeFactMergeInsert$] WITH NOCHECK ADD CONSTRAINT [FK_EmployeeFactMergeInsert$_ManagerStatus$] FOREIGN KEY([ManagerCode])
REFERENCES [dbo].[ManagerStatus$] ([ManagerStatusCode])
GO

ALTER TABLE [dbo].[EmployeeFactMergeInsert$] CHECK CONSTRAINT [FK_EmployeeFactMergeInsert$_ManagerStatus$]
GO

ALTER TABLE [dbo].[EmployeeFactMergeInsert$] WITH NOCHECK ADD CONSTRAINT [FK_EmployeeFactMergeInsert$_TerminationCode$] FOREIGN KEY([TerminationCode])
REFERENCES [dbo].[TerminationCode$] ([TerminationCode])
GO

ALTER TABLE [dbo].[EmployeeFactMergeInsert$] CHECK CONSTRAINT [FK_EmployeeFactMergeInsert$_TerminationCode$]
GO

ALTER TABLE [dbo].[EmployeeFactMergeInsert$] WITH NOCHECK ADD CONSTRAINT [FK_EmployeeFactMergeInsert$_WorkLocation$] FOREIGN KEY([WorkLocationID])
REFERENCES [dbo].[WorkLocation$] ([WorkLocationID])
GO

ALTER TABLE [dbo].[EmployeeFactMergeInsert$] CHECK CONSTRAINT [FK_EmployeeFactMergeInsert$_WorkLocation$]
GO


MMartin, you are right. Most of my records are new. Especially those extracted the first time around. There are 59 weeks worth of data, for around 96,000 employee. Not all employee's data is available for all weeks. Similarly, an employee will have more than one record per extract date, especially if the employee has moved from facility to facility.

I am providing you below with some sample data including the CREATE TABLE statement so that you can play around with that.

Please bear in mind I am running SQL Server 2005 Standard Edition on a Windows Server 2003 SP2 Enterprise Edition machine (Intel Xeon 5160 @ 3.00GHz, 4GB RAM).


/*CREATE TABLE dbo.EmployeeMasterForum$Forum$
(
ExtractDate DATETIME NOT NULL,
FacID INT NULL,
Facility VARCHAR(50) NULL,
FacilityAlphaValue VARCHAR(3) NULL,
SSN VARCHAR(11) NULL,
EeNum INT NULL,
[Status AIT] CHAR(1) NULL,
StatusF12 CHAR(1) NULL,
PerDiemInd CHAR(1) NULL,
OriginalHireDate DATETIME NULL,
CurrentHireDate DATETIME NULL,
JobCodeEffectiveDate DATETIME NULL,
RIFDate DATETIME NULL,
TerminationDate DATETIME NULL,
TerminationSecurityDate DATETIME NULL,
ReinstatementDate DATETIME NULL,
AcquisitionDate DATETIME NULL,
DeptEffectiveDate DATETIME NULL,
TransferDate DATETIME NULL,
TransferFacilityID INT NULL,
TerminationCode CHAR(2) NULL,
[Job Code] VARCHAR(8) NULL,
UnionJobCode CHAR(1) NULL,
EEOCode CHAR(1) NULL,
Title VARCHAR(25) NULL,
[Job Class] CHAR(2) NULL,
ManagerCode CHAR(1) NULL,
BaseRate NUMERIC(9,4) NULL,
ScheduledHours INT NULL,
Dept INT NULL,
[Work Location Code] VARCHAR(3) NULL,
[Work Location Address] VARCHAR(255) NULL,
[Work Location City] VARCHAR(100) NULL,
[Work Location State] VARCHAR(2) NULL,
[Work Location Zip] INT NULL,
SupervisorNumber INT NULL,
DeptManagerNumber INT NULL,
ExecSalaryNumber INT NULL,
RequisitionNumber VARCHAR(10) NULL,
PositionControlNumber VARCHAR(20) NULL,
ApplicantID VARCHAR(13) NULL
);
GO
*/

INSERT INTO EmployeeMasterForum$
VALUES ('2013-7-11', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '1901-1-1', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, NULL, NULL, NULL, NULL, NULL, NULL) -- new record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-7-19', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '1901-1-1', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, NULL, NULL, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-8-2', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '1901-1-1', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, NULL, NULL, NULL, NULL, NULL, NULL)--unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-8-9', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '1901-1-1', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, NULL, NULL, NULL, NULL, NULL, NULL)--unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-8-16', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '1901-1-1', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, NULL, NULL, NULL, NULL, NULL, NULL)--unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-8-23', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '1901-1-1', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, NULL, NULL, NULL, NULL, NULL, NULL)--unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-8-30', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '1901-1-1', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, NULL, NULL, NULL, NULL, NULL, NULL)--unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-9-6', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '1901-1-1', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, NULL, NULL, NULL, NULL, NULL, NULL)--unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-9-13', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '1901-1-1', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, NULL, NULL, NULL, NULL, '8273-P7714-138', NULL) -- changing attribute: update PositionControlNumber field only
INSERT INTO EmployeeMasterForum$
VALUES ('2013-9-20', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '1901-1-1', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, NULL, NULL, NULL, NULL, '8273-P7714-138', NULL)--unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-9-26', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '1901-1-1', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, NULL, NULL, NULL, NULL, '8273-P7714-138', NULL)--unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-10-3', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '1901-1-1', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, NULL, NULL, NULL, NULL, '8273-P7714-138', NULL)--unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-10-8', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '1901-1-1', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, NULL, NULL, NULL, NULL, '8273-P7714-138', NULL)--unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-10-10', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '1901-1-1', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, NULL, NULL, NULL, NULL, '8273-P7714-138', NULL)--unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-10-17', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '1901-1-1', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, NULL, NULL, NULL, NULL, '8273-P7714-138', NULL)--unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-10-24', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --new record: changes in JobCodeEffectiveDate, DeptEffectiveDate, SupervisorNumber, DeptManagerNumber, ExecSalaryNumber
INSERT INTO EmployeeMasterForum$
VALUES ('2013-10-31', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-11-7', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-11-15', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-11-21', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-12-2', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-12-5', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-12-12', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-12-19', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2013-12-26', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-1-2', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'1901-1-1', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'ZZ', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-1-9', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --new record: changes in [Status AIT], TerminationDate and TerminationCode
INSERT INTO EmployeeMasterForum$
VALUES ('2014-1-16', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-1-30', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-2-6', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-2-13', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-2-20', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-2-27', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --new record: new FacID
INSERT INTO EmployeeMasterForum$
VALUES ('2014-2-27', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-3-6', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-3-6', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-3-13', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --new record: changes in [Status AIT], TerminationDate and TerminationCode
INSERT INTO EmployeeMasterForum$
VALUES ('2014-3-13', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 123, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) --new record: new FacID
INSERT INTO EmployeeMasterForum$
VALUES ('2014-3-13', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-3-20', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-3-20', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 123, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --new record: changes in [Work Location Code], [Work Location Address], [Work Location City], [Work Location State], [Work location Zip]
INSERT INTO EmployeeMasterForum$
VALUES ('2014-3-20', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-3-27', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-3-27', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 123, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --unchanged Record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-3-27', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-4-3', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-4-3', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 123, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --unchanged Record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-4-3', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-4-10', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-4-10', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 123, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --unchanged Record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-4-10', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-4-17', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-4-17', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 123, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --unchanged Record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-4-17', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-4-24', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-4-24', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 123, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --unchanged Record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-4-24', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-5-1', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-5-1', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 123, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --unchanged Record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-5-1', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-5-8', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-5-8', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 123, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --unchanged Record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-5-8', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-5-15', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-5-15', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 123, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --unchanged Record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-5-15', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-5-22', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-5-22', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 123, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --unchanged Record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-5-22', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-5-29', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-5-29', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 123, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --unchanged Record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-5-29', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-6-5', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-6-5', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 123, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --unchanged Record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-6-5', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-6-12', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-6-12', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 123, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --unchanged Record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-6-12', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-6-19', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-6-19', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 123, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --unchanged Record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-6-19', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-6-26', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-6-26', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 123, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --unchanged Record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-6-26', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-6-30', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-6-30', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 123, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --unchanged Record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-6-30', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-7-3', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-7-3', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 123, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --unchanged Record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-7-3', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-7-10', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-7-10', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'A', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'1901-1-1', '2014-7-7', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 123, 'ZZ', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --new record: change in TerminationSecurityDate
INSERT INTO EmployeeMasterForum$
VALUES ('2014-7-10', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-7-17', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-7-17', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-6-27', '2014-7-7', '2014-2-19', '1901-1-1','2014-2-19', '1901-1-1', 123, 'TA', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --new record: change in [Status AIT], TerminationDate, TransferDate, TerminationCode
INSERT INTO EmployeeMasterForum$
VALUES ('2014-7-17', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-7-24', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-7-24', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-6-27', '2014-7-7', '2014-2-19', '1901-1-1','2014-2-19', '1901-1-1', 123, 'TA', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-7-24', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-7-31', 123, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-2-18', '1901-1-1', '2014-2-19', '1901-1-1','2014-2-19', '2014-2-19', 555, 'TR', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, 21561, 46384, NULL, NULL, NULL, NULL)--unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-7-31', 456, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2014-2-19', '1901-1-1',
'2014-6-27', '2014-7-7', '2014-2-19', '1901-1-1','2014-2-19', '1901-1-1', 123, 'TA', 'P7800', 'N', 'A', 'Job Title2', '13', 'P', 555.555, 80, 67890, 'LAC', 'Location Address2',
'City2', 'St', 55556, NULL, NULL, NULL, NULL, NULL, NULL) --unchanged record
INSERT INTO EmployeeMasterForum$
VALUES ('2014-7-31', 555, 'Some Name', 'CCC', 'SSS-SS-SSS', 123456, 'T', 'F', 'N', '2010-6-23', '2010-6-23', '2013-1-3', '1901-1-1',
'2014-1-2', '1901-1-1', '1901-1-1', '1901-1-1', '2011-10-2', '1901-1-1', 0, 'TA', 'A1234', 'N', 'A', 'Job Title', '13', 'R', 55.555, 80, 12345, 'LOC', 'Location Address',
'City', 'ST', 55555, 21561, 46384, 240861, NULL, '8273-P7714-138', NULL) --unchanged record


After each of the INSERT statements I have included some comments as to the behaviour of either the SCD or the Custom SCD. From the 101 rows I have provided, only 9 should make it to the fact table.

The following fields are Type 1 attributes, the rest are Type 2:
PositionControlNumber
RequisitionNumber
ApplicantID

Once again, thank you all for your help.
Post #1606488
Posted Friday, August 22, 2014 1:48 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 10, 2014 3:07 PM
Points: 48, Visits: 148
Oh, and I should also mention, I was doing the SCD with the EeNum and the FacID as business keys.
Post #1606489
Posted Tuesday, September 2, 2014 7:26 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 10, 2014 3:07 PM
Points: 48, Visits: 148
Hi there,

Just thought of giving you a bit of an update.

I have then worked on the custom SCD and have also found out about a little tweak you can do to the way Windows Server 2003 handles memory, and that is to add the /3GB switch to the boot.ini file.

I have done this and things have improved slightly. I can now run around 21,000 records at a time ... woohoo!!! Yes, I know it's pretty sand, considering I have to do nearly 5 million records.

Now the package breaks after 2:45mins of running and it has the following error:

Description: component OLE DB Destination failed the pre-execute phase and returned error code 0x8007000E.

There are no more error messages so it's pretty obscure and I can't seem to find the reason why it would do this after running so well for that long.

Any ideas?
Post #1609619
Posted Tuesday, September 23, 2014 2:46 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 1:04 PM
Points: 420, Visits: 996
Hi, it does not appear the SCD component will do the job here. So this relates back to an earlier post on doing the updates, inserts programatically with execute t-sql tasks. I just illustrate the basic method to accomplish this with code using sets as your base and not row by row. This should be a lot faster. You will need to translate the example to fit your perticular columns/tables as appropriate. I represent a staging table and the destination table is where I move the rows from the staging to. Here new rows get inserted, existing rows get "deactivated" and a newer one inserted, and those not in the latest batch also get deactivated (meaning historical now, not current).

/* find those columns already existing, 
and deactivate them to indicate they are not the latest version of the record (employee here),
It will look something like ... */
update d
SET d.validTo=getdate()
from staging as s inner join Destination as D
on s.colm1=d.colm1 [and ...=... ] /* <-- I have a feeling this will be a long list, indexing can help*/

/* Next insert the latest version of these existing records */
Insert into Destination
SELECT s.*, getdate() as validFrom, Null as validTo
from Staging as S inner join Destination as D
on s.colm1=d.colm1 [and ...=... ] /* same as above */

/*Next insert only the new records, these employees (or employee date combo, however you do it)
did not exist before ... */
Insert into Destination
SELECT s.* , getdate() a validFrom, null as validTo
from Staging as s LEFT JOIN destination as D on
s.colm1=d.colm1 [and ...=... ] /* same as above */
WHERE d.colm1 is null [and d.colm2 is null. ... ..] /*Same columns as in the join , and implies do not exist yet in the destination,thus new inserts*/

/*
Here are those records in the destination table already that are not in the staging set of records, these maybe are left alone.
Or if need be you can do as just above but make the destination table the LEFT table instead of the right one.
This would be if you have a situaion where a employee is no longer with the company so you may do something like this to deactivate them..*/
Update D
SET d.validTo = getdate()
FROM destination as D LEFT JOIN Staging as s
On s.colm1=d.colm1 [and ...=... ] /* same as above */
WHERE S.colm1 is null [and S.colm2 is null. ... ..] /* implies are not in the staging set but
exist in the destination from a prior import */

So this gives you the basics. Have a good look and see if you can wrap your head around it. It is fairly straight forward and what the MERGE operator does in the background essentially. I think this will be able to meet the need you have here, and breaks it down so that you see exactly what is happening (emulates a type 2 SCD).

Post #1619029
Posted Tuesday, September 23, 2014 2:57 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 10, 2014 3:07 PM
Points: 48, Visits: 148
Hi MMartin1,

I will definitely work with the code and let you know of anything!

Thanks so much for doing this. I really appreciate it.

Cheers
Romina
Post #1619032
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse