July 18, 2011 at 1:21 pm
We currently have the stored procedure setup to allow to lookup of a supervisor as of a particular date easily. The problem with doing it this way, is that the cursor gets very large since it has to run the function for every record that is returned and this is causing the query to fail as our indexes grow. I have heard that converting it to a WITH CTE would be a better method and not put as much strain on the DB to get the same data. Can anyone that know PeopleSoft and understands CTE's help convert this procedure, or start me down the right path with CTE's, as I have never worked with them.
Here is the current Stored Procedure that gets referenced in a query such as SELECT dbo.Supervisor('012345','2005-06-15'), or in the where clause to join to a table to get the name of the supervisor:
USE [PSHRDEV]
GO
/****** Object: UserDefinedFunction [dbo].[Supervisor] Script Date: 07/18/2011 13:20:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
--Create New Function
ALTER FUNCTION [dbo].[Supervisor](@Emplid varchar(11), @AsOfDate datetime)
RETURNS varchar(11)
AS
BEGIN
Declare @Position_Nbr varchar(8)
Declare @Reports_To varchar(8)
Declare @Supervisor_ID varchar(11)
Declare @Count integer
-- First, get the employee's current position# from PS_JOB
Select @Position_Nbr = A.POSITION_NBR,
@Supervisor_ID = A.SUPERVISOR_ID
FROM PS_JOB A
WHERE EMPLID = @Emplid
AND JOB_INDICATOR = 'P'
AND A.EFFDT =
(SELECT MAX(EFFDT)
FROM PS_JOB
WHERE EMPLID = A.EMPLID
AND EMPL_RCD = A.EMPL_RCD
AND EFFDT <= @AsOfDate)
AND A.EFFSEQ =
(SELECT MAX(EFFSEQ)
FROM PS_JOB
WHERE EMPLID = A.EMPLID
AND EMPL_RCD = A.EMPL_RCD
AND EFFDT = A.EFFDT)
-- If the supervisor id is blank (only non-employees have supervisor_id)
-- Loop through looking for the first active incumbent above the employee
Set @Count = 0
While @Supervisor_ID = ' ' and @Count < 10
begin
-- Add 1 to our counter so we never have an endless loop
Select @Count = @Count + 1
-- Get the reports-to position for the position we were working with
-- first time through it will be the employee's position
-- all other interations it will be a manager's position
SELECT @Reports_To = P.REPORTS_TO
FROM PS_POSITION_DATA P
WHERE EFFDT =
(SELECT MAX(EFFDT)
FROM PS_POSITION_DATA
WHERE POSITION_NBR = P.POSITION_NBR
AND EFFDT <= @AsOfDate)
AND POSITION_NBR = @Position_Nbr
-- Set up cursor for incumbents of the supervisor position.
-- If there is more than one, the one effective dated / hired
-- latest will be returned first. Only row 1 will be used.
Declare Incumbents cursor for
SELECT B.EMPLID
FROM PS_JOB B, PS_EMPLOYMENT C
WHERE BEN_STATUS = 'A'
AND POSITION_NBR = @Reports_To
AND EFFDT =
(SELECT MAX(EFFDT)
FROM PS_JOB
WHERE EMPLID = B.EMPLID
AND EMPL_RCD = B.EMPL_RCD
AND EFFDT <= @AsOfDate)
AND EFFSEQ =
(SELECT MAX(EFFSEQ)
FROM PS_JOB
WHERE EMPLID = B.EMPLID
AND EMPL_RCD = B.EMPL_RCD
AND EFFDT = B.EFFDT)
AND B.EMPLID = C.EMPLID
AND B.EMPL_RCD = C.EMPL_RCD
ORDER BY B.EFFDT DESC, CASE WHEN C.REHIRE_DT IS NULL THEN C.HIRE_DT ELSE C.REHIRE_DT END DESC
-- Open the cursor, selecting the top row.
OPEN Incumbents
FETCH NEXT FROM Incumbents INTO @Supervisor_ID
CLOSE Incumbents
Deallocate Incumbents
Set @Position_Nbr = @Reports_To
End
RETURN @Supervisor_ID
END
July 18, 2011 at 3:56 pm
I've glanced at the code and it may be possible to improve it. But it would be really nice to see the schema of the tables involved, including any indexes on those tables. If you post the CREATE TABLE statements with your schema and include some INSERT statements to populate them with sample data, we could offer you coded and tested alternatives.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 19, 2011 at 11:44 am
The tables are very large, so I cut it down to only the data points needed to get to the results.
Here are the create table statements:
/****** Object: Table [dbo].[PS_POSITION_DATA] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PS_POSITION_DATA](
[POSITION_NBR] [char](8) NOT NULL,
[EFFDT] [dbo].[datetime] NOT NULL,
[REPORTS_TO] [char](8) NOT NULL,
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[PS_JOB] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PS_JOB](
[EMPLID] [char](11) NOT NULL,
[EMPL_RCD] [smallint] NOT NULL,
[EFFDT] [dbo].[datetime] NOT NULL,
[EFFSEQ] [smallint] NOT NULL,
[PER_ORG] [char](3) NOT NULL,
[DEPTID] [char](10) NOT NULL,
[JOBCODE] [char](6) NOT NULL,
[POSITION_NBR] [char](8) NOT NULL,
[SUPERVISOR_ID] [char](11) NOT NULL,
[JOB_INDICATOR] [char](1) NOT NULL,
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[PS_EMPLOYMENT] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PS_EMPLOYMENT](
[EMPLID] [char](11) NOT NULL,
[EMPL_RCD] [smallint] NOT NULL,
[PER_ORG] [char](3) NOT NULL,
[REHIRE_DT] [dbo].[datetime] NOT NULL,
[HIRE_DT] [dbo].[datetime] NOT NULL,
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
And here are some INSERT statements to populate the tables:
INSERT INTO PS_JOB VALUES ('021613','0','4/24/1972','0','EMP','60748','FC17 ','10103632','','P'
INSERT INTO PS_JOB VALUES ('021613','0','2/14/2011','0','EMP','60748','FC17 ','10103632','','P'
INSERT INTO PS_JOB VALUES ('024293','0','7/29/1974','0','EMP','70320','FB08 ','10103494','','P'
INSERT INTO PS_JOB VALUES ('024293','0','2/14/2011','0','EMP','70320','FB09 ','10103494','','P'
INSERT INTO PS_JOB VALUES ('025649','0','7/28/1975','0','EMP','60748','FC18 ','10103453','','P'
INSERT INTO PS_JOB VALUES ('025649','0','4/26/2011','0','EMP','60748','FC18 ','10103453','','P'
INSERT INTO PS_JOB VALUES ('027156','0','8/16/1976','0','EMP','60748','FB45 ','10104144','','P'
INSERT INTO PS_JOB VALUES ('027156','0','2/14/2011','0','EMP','60748','FC16 ','10104144','','P'
INSERT INTO PS_JOB VALUES ('027351','0','9/21/1976','0','EMP','50883','FA93 ','10103381','','P'
INSERT INTO PS_JOB VALUES ('027351','0','2/14/2011','0','EMP','50883','FG50 ','10103381','','P'
INSERT INTO PS_JOB VALUES ('027930','0','1/10/1977','0','EMP','70360','FB49 ','10103366','','P'
INSERT INTO PS_JOB VALUES ('027930','0','2/14/2011','0','EMP','70366','FF26 ','10103366','','P'
INSERT INTO PS_JOB VALUES ('028233','0','4/4/1977','0','EMP','70366','FB44 ','10103361','','P'
INSERT INTO PS_JOB VALUES ('028233','0','2/14/2011','0','EMP','70366','FB44 ','10103361','','P'
INSERT INTO PS_JOB VALUES ('029545','0','11/21/1977','0','EMP','70750','FC13 ','10103296','','P'
INSERT INTO PS_JOB VALUES ('029545','0','6/27/2011','0','EMP','70750','FC13 ','10103296','','P'
INSERT INTO PS_JOB VALUES ('030847','0','7/5/1978','0','EMP','70330','FB46 ','10103231','','P'
INSERT INTO PS_JOB VALUES ('030847','0','5/16/2011','0','EMP','70330','FI15 ','10103231','','P'
INSERT INTO PS_JOB VALUES ('031975','0','1/22/1979','0','EMP','70360','FB48 ','10103180','','P'
INSERT INTO PS_JOB VALUES ('031975','0','6/27/2011','0','EMP','70360','FB48 ','10103180','','P'
INSERT INTO PS_JOB VALUES ('038761','0','10/13/1980','0','EMP','70320','FB09 ','10103044','','P'
INSERT INTO PS_JOB VALUES ('038761','0','2/14/2011','0','EMP','70320','FB09 ','10103044','','P'
INSERT INTO PS_JOB VALUES ('042303','0','8/9/1982','0','EMP','70366','FB44 ','10102962','','P'
INSERT INTO PS_JOB VALUES ('042303','0','2/14/2011','0','EMP','70366','FB44 ','10102962','','P'
INSERT INTO PS_JOB VALUES ('042450','0','3/4/1974','0','EMP','60748','FC17 ','10102947','','P'
INSERT INTO PS_JOB VALUES ('042450','1','1/3/2011','0','EMP','60748','FC17 ','10102947','','P'
INSERT INTO PS_JOB VALUES ('045013','0','9/24/1984','0','EMP','60748','FC16 ','10102879','','P'
INSERT INTO PS_JOB VALUES ('045013','0','2/14/2011','0','EMP','60748','FC16 ','10102879','','P'
INSERT INTO PS_JOB VALUES ('046096','0','4/18/1985','0','EMP','70366','FB44 ','10102830','','P'
INSERT INTO PS_JOB VALUES ('046096','0','2/14/2011','0','EMP','70366','FJ27 ','10102830','','P'
INSERT INTO PS_JOB VALUES ('046294','0','5/20/1985','0','EMP','60748','FC16 ','10102819','','P'
INSERT INTO PS_JOB VALUES ('046294','0','2/14/2011','0','EMP','60748','FC16 ','10102819','','P'
INSERT INTO PS_JOB VALUES ('047514','0','4/14/1986','0','EMP','70360','FB47 ','10102756','','P'
INSERT INTO PS_JOB VALUES ('047514','0','6/27/2011','0','EMP','70360','FB48 ','10102756','','P'
INSERT INTO PS_JOB VALUES ('047836','0','6/9/1986','0','EMP','70360','AF17 ',' ','030199','P'
INSERT INTO PS_JOB VALUES ('047836','0','2/14/2011','0','EMP','70600','FI35 ','10103162','','P'
INSERT INTO PS_JOB VALUES ('048572','0','11/10/1986','0','EMP','70610','FC26 ','10102701','','P'
INSERT INTO PS_JOB VALUES ('048572','0','5/9/2011','1','EMP','70610','FC27 ','10102701','','P'
INSERT INTO PS_JOB VALUES ('048840','0','1/22/1987','0','EMP','70248','BK22 ','10102682','','P'
INSERT INTO PS_JOB VALUES ('048840','0','1/30/2006','0','EMP','70330','FB60 ','10105778','','P'
INSERT INTO PS_JOB VALUES ('048840','0','5/16/2011','0','EMP','70330','FB60 ','10105778','','P'
INSERT INTO PS_JOB VALUES ('052083','0','3/27/1989','0','EMP','70366','FB45 ','10102483','','P'
INSERT INTO PS_JOB VALUES ('052083','0','2/14/2011','0','EMP','70366','FG53 ','10102483','','P'
INSERT INTO PS_JOB VALUES ('053873','0','8/13/1990','0','EMP','70366','FB44 ','10102348','','P'
INSERT INTO PS_JOB VALUES ('053873','0','2/14/2011','0','EMP','70366','FB81 ','10102348','','P'
INSERT INTO PS_JOB VALUES ('053923','0','8/27/1990','0','EMP','70366','FB43 ','10102352','','P'
INSERT INTO PS_JOB VALUES ('053923','0','2/14/2011','0','EMP','70366','FB44 ','10102352','','P'
INSERT INTO PS_JOB VALUES ('059775','0','3/10/1997','0','EMP','70360','FB47 ','10101945','','P'
INSERT INTO PS_JOB VALUES ('059775','0','5/9/2005','0','EMP','22115','FB49 ','10103333','','P'
INSERT INTO PS_JOB VALUES ('059775','0','7/18/2011','0','EMP','22115','FB48 ','10103333','','P'
INSERT INTO PS_JOB VALUES ('063242','0','9/8/1997','0','EMP','70600','FC22 ','10101889','','P'
INSERT INTO PS_JOB VALUES ('063242','0','6/14/2010','0','EMP','70600','FK42 ','10100292','','P'
INSERT INTO PS_JOB VALUES ('063242','0','2/14/2011','0','EMP','70600','FK42 ','10100292','','P'
INSERT INTO PS_JOB VALUES ('063242','0','7/4/2011','0','EMP','70600','FK42 ','10100292','','P'
INSERT INTO PS_JOB VALUES ('063252','0','9/22/1997','0','EMP','60748','FC17 ','10101890','','P'
INSERT INTO PS_JOB VALUES ('063252','0','2/14/2011','0','EMP','60748','FC17 ','10101890','','P'
INSERT INTO PS_JOB VALUES ('063407','0','11/17/1997','0','EMP','60487','BJ80 ','10101841','','P'
INSERT INTO PS_JOB VALUES ('063407','0','4/9/2007','0','EMP','70600','FC23 ','10105038','','P'
INSERT INTO PS_JOB VALUES ('063407','0','2/14/2011','0','EMP','70600','FF33 ','10105038','','P'
INSERT INTO PS_JOB VALUES ('063989','0','8/3/1998','0','EMP','78185','AG42 ',' ','067226','P'
INSERT INTO PS_JOB VALUES ('063989','0','4/18/2005','0','EMP','70366','FB69 ','10104948','','P'
INSERT INTO PS_JOB VALUES ('063989','0','5/23/2011','0','EMP','70366','FB69 ','10104948','','P'
INSERT INTO PS_JOB VALUES ('064514','0','4/26/1999','0','EMP','22115','FB49 ','10101705','','P'
INSERT INTO PS_JOB VALUES ('064514','0','1/3/2006','0','EMP','70360','FC10 ','10103555','','P'
INSERT INTO PS_JOB VALUES ('064514','0','6/23/2011','0','EMP','70360','FL02 ','10108143','','P'
INSERT INTO PS_JOB VALUES ('067808','0','9/9/2002','0','EMP','50400','BF49 ','10100578','','P'
INSERT INTO PS_JOB VALUES ('067808','0','10/16/2006','0','EMP','70366','FB72 ','10103436','','P'
INSERT INTO PS_JOB VALUES ('067808','0','6/7/2010','0','EMP','70366','FB43 ','10106622','','P'
INSERT INTO PS_JOB VALUES ('067808','0','5/10/2011','0','EMP','70366','FB43 ','10106622','','P'
INSERT INTO PS_JOB VALUES ('067898','0','12/16/2002','0','EMP','70330','FB60 ','10100546','','P'
INSERT INTO PS_JOB VALUES ('067898','0','6/27/2011','0','EMP','36190','FB48 ','10100546','','P'
INSERT INTO PS_JOB VALUES ('068141','0','5/19/2003','0','EMP','13670','BC42 ','10103904','','P'
INSERT INTO PS_JOB VALUES ('068141','0','8/29/2005','0','EMP','60345','FA99 ','10100718','','P'
INSERT INTO PS_JOB VALUES ('068141','0','3/13/2006','0','EMP','70366','FB08 ','10106058','','P'
INSERT INTO PS_JOB VALUES ('068141','0','6/23/2008','0','EMP','60856','FG57 ','10105578','','P'
INSERT INTO PS_JOB VALUES ('068141','0','3/17/2010','0','EMP','70320','FB08 ','10106056','','P'
INSERT INTO PS_JOB VALUES ('068141','0','2/14/2011','0','EMP','70320','FB08 ','10106056','','P'
INSERT INTO PS_JOB VALUES ('068299','0','9/2/2003','0','EMP','70330','FB59 ','10100275','','P'
INSERT INTO PS_JOB VALUES ('068299','0','7/4/2011','0','EMP','70600','FF33 ','10100275','','P'
INSERT INTO PS_JOB VALUES ('069171','0','11/1/2004','0','EMP','70313','FC23 ','10104504','','P'
INSERT INTO PS_JOB VALUES ('069171','0','6/20/2011','1','EMP','70600','FL07 ','10104504','','P'
INSERT INTO PS_JOB VALUES ('069687','0','7/18/2005','0','EMP','70360','FB47 ','10104747','','P'
INSERT INTO PS_JOB VALUES ('069687','0','1/8/2007','0','EMP','36330','FB48 ','10106385','','P'
INSERT INTO PS_JOB VALUES ('069687','0','7/7/2008','0','EMP','70600','FB48 ','10100856','','P'
INSERT INTO PS_JOB VALUES ('069687','0','11/9/2009','0','EMP','22110','FB48 ','10107218','','P'
INSERT INTO PS_JOB VALUES ('069687','0','6/27/2011','0','EMP','70360','FB48 ','10107218','','P'
INSERT INTO PS_JOB VALUES ('069731','0','7/25/2005','0','EMP','70305','FB65 ','10105098','','P'
INSERT INTO PS_JOB VALUES ('069731','0','5/22/2006','0','EMP','70360','FB66 ','10105186','','P'
INSERT INTO PS_JOB VALUES ('069731','0','12/21/2007','0','EMP','70600','FG76 ','10106179','','P'
INSERT INTO PS_JOB VALUES ('069731','0','7/7/2008','0','EMP','22110','FB47 ','10107218','','P'
INSERT INTO PS_JOB VALUES ('069731','0','12/14/2009','0','EMP','70320','FB76 ','10107506','','P'
INSERT INTO PS_JOB VALUES ('069731','0','2/14/2011','0','EMP','70320','FB46 ','10107506','','P'
INSERT INTO PS_JOB VALUES ('069736','0','9/12/2005','0','EMP','70330','FB51 ','10104951','','P'
INSERT INTO PS_JOB VALUES ('069736','0','5/17/2011','0','EMP','70330','FB51 ','10104951','','P'
INSERT INTO PS_JOB VALUES ('069833','0','9/12/2005','0','EMP','70360','FB46 ','10105154','','P'
INSERT INTO PS_JOB VALUES ('069833','0','1/8/2007','0','EMP','36190','FB47 ','10104747','','P'
INSERT INTO PS_JOB VALUES ('069833','0','6/27/2011','0','EMP','70360','FB47 ','10104747','','P'
INSERT INTO PS_JOB VALUES ('070118','0','10/1/2005','0','CWR','36190','FB48 ','10105337','','P'
INSERT INTO PS_JOB VALUES ('070118','1','5/16/2011','0','EMP','36190','FB48 ','10105337','','P'
INSERT INTO PS_JOB VALUES ('070547','1','1/3/2006','0','EMP','70600','FA92 ','10103385','','P'
INSERT INTO PS_JOB VALUES ('070547','1','6/20/2011','0','EMP','70600','FL03 ','10103385','','P'
INSERT INTO PS_JOB VALUES ('070949','0','12/16/2005','0','CWR','70246','WW01 ',' ','023397','P'
INSERT INTO PS_JOB VALUES ('070949','0','7/10/2008','0','CWR','70246','WW01 ',' ','029545','P'
INSERT INTO PS_JOB VALUES ('071569','0','7/10/2006','0','EMP','22115','FB46 ','10101440','','P'
INSERT INTO PS_JOB VALUES ('071569','0','3/15/2010','0','EMP','40810','FB47 ','10107577','','P'
INSERT INTO PS_JOB VALUES ('071569','0','5/16/2011','0','EMP','40810','FB47 ','10107577','','P'
INSERT INTO PS_JOB VALUES ('071698','0','8/28/2006','0','EMP','70360','FB48 ','10100879','','P'
INSERT INTO PS_JOB VALUES ('071698','0','6/27/2011','0','EMP','70360','FB48 ','10100879','','P'
INSERT INTO PS_JOB VALUES ('071769','0','9/5/2006','0','EMP','58135','FD22 ','10100182','','P'
INSERT INTO PS_JOB VALUES ('071769','0','1/28/2009','0','EMP','70612','FB66 ','10106082','','P'
INSERT INTO PS_JOB VALUES ('071769','0','4/11/2011','0','EMP','70600','FB06 ','10107968','','P'
INSERT INTO PS_JOB VALUES ('071769','0','7/4/2011','0','EMP','70600','FB06 ','10107968','','P'
INSERT INTO PS_JOB VALUES ('072140','0','11/27/2006','0','EMP','70600','FF33 ','10103334','','P'
INSERT INTO PS_JOB VALUES ('072140','0','6/20/2011','1','EMP','70600','FL01 ','10103334','','P'
INSERT INTO PS_JOB VALUES ('072165','0','12/11/2006','0','EMP','70320','FB50 ','10106445','','P'
INSERT INTO PS_JOB VALUES ('072165','0','2/14/2011','0','EMP','70320','FB50 ','10106445','','P'
INSERT INTO PS_JOB VALUES ('072515','0','4/9/2007','0','EMP','70320','FH06 ','10102250','','P'
INSERT INTO PS_JOB VALUES ('072515','0','2/14/2011','0','EMP','70320','FH06 ','10102250','','P'
INSERT INTO PS_JOB VALUES ('072635','0','4/12/2007','0','EMP','70326','FA68 ','10100316','','P'
INSERT INTO PS_JOB VALUES ('072635','0','7/18/2011','0','EMP','70326','FK06 ','10100316','','P'
INSERT INTO PS_JOB VALUES ('073199','0','9/13/2007','0','EMP','70326','FI50 ','10106808','','P'
INSERT INTO PS_JOB VALUES ('073199','0','3/15/2010','0','EMP','22115','FI71 ','10107585','','P'
INSERT INTO PS_JOB VALUES ('073199','0','6/20/2011','1','EMP','22115','FB47 ','10107585','','P'
INSERT INTO PS_JOB VALUES ('073265','0','10/29/2007','0','EMP','70750','FB40 ','10106870','','P'
INSERT INTO PS_JOB VALUES ('073265','0','2/14/2011','0','EMP','70750','FB40 ','10106870','','P'
INSERT INTO PS_JOB VALUES ('073799','0','4/22/2008','0','EMP','70326','FA68 ','10104402','','P'
INSERT INTO PS_JOB VALUES ('073799','0','2/14/2011','0','EMP','70326','FA68 ','10104402','','P'
INSERT INTO PS_JOB VALUES ('073985','0','6/16/2008','0','EMP','70330','FB58 ','10103765','','P'
INSERT INTO PS_JOB VALUES ('073985','0','5/16/2011','0','EMP','70330','FB59 ','10103765','','P'
INSERT INTO PS_JOB VALUES ('074049','0','6/18/2008','0','EMP','70600','FG76 ','10106179','','P'
INSERT INTO PS_JOB VALUES ('074049','0','7/4/2011','0','EMP','70600','FG76 ','10106179','','P'
INSERT INTO PS_JOB VALUES ('074257','0','8/29/2008','0','EMP','33375','FB48 ','10107307','','P'
INSERT INTO PS_JOB VALUES ('074257','0','5/16/2011','0','EMP','33375','FB48 ','10107307','','P'
INSERT INTO PS_JOB VALUES ('074409','0','11/10/2008','0','EMP','60140','FB15 ','10106490','','P'
INSERT INTO PS_JOB VALUES ('074409','0','1/18/2010','0','EMP','70750','FG53 ','10103806','','P'
INSERT INTO PS_JOB VALUES ('074409','0','2/14/2011','0','EMP','70750','FG53 ','10103806','','P'
INSERT INTO PS_JOB VALUES ('074586','0','3/30/2009','0','EMP','70750','FB40 ','10103016','','P'
INSERT INTO PS_JOB VALUES ('074586','0','7/13/2011','0','EMP','70750','FB40 ','10103016','','P'
INSERT INTO PS_JOB VALUES ('074636','0','4/13/2009','0','EMP','70320','FG53 ','10106058','','P'
INSERT INTO PS_JOB VALUES ('074636','0','2/14/2011','0','EMP','70320','FG53 ','10106058','','P'
INSERT INTO PS_JOB VALUES ('075200','0','3/1/2010','0','EMP','70600','FK04 ','10107507','','P'
INSERT INTO PS_JOB VALUES ('075200','0','7/4/2011','0','EMP','70600','FK04 ','10107507','','P'
INSERT INTO PS_JOB VALUES ('075869','0','9/10/2010','0','EMP','70326','FA68 ','10100435','','P'
INSERT INTO PS_JOB VALUES ('075869','0','2/14/2011','0','EMP','70326','FA68 ','10100435','','P'
INSERT INTO PS_JOB VALUES ('075870','0','9/13/2010','0','EMP','70326','FA68 ','10106822','','P'
INSERT INTO PS_JOB VALUES ('075870','0','2/14/2011','0','EMP','70326','FA68 ','10106822','','P'
INSERT INTO PS_JOB VALUES ('075977','0','10/13/2010','0','EMP','70326','FA68 ','10104406','','P'
INSERT INTO PS_JOB VALUES ('075977','0','2/14/2011','0','EMP','70326','FA68 ','10104406','','P'
INSERT INTO PS_JOB VALUES ('075996','0','10/20/2010','0','CWR','70752','WW02 ',' ','029545','P'
INSERT INTO PS_JOB VALUES ('075998','0','10/20/2010','0','CWR','70752','WW03 ',' ','029545','P'
INSERT INTO PS_JOB VALUES ('075999','0','10/20/2010','0','CWR','70752','WW03 ',' ','029545','P'
INSERT INTO PS_JOB VALUES ('076491','0','5/23/2011','0','EMP','70600','FH45 ','10101889','','P'
INSERT INTO PS_JOB VALUES ('076491','0','7/4/2011','0','EMP','70600','FH45 ','10101889','','P'
INSERT INTO PS_JOB VALUES ('076585','0','6/6/2011','0','EMP','70326','FA68 ','10100605','','P'
INSERT INTO PS_POSITION_DATA VALUES ('10103436','1/1/1901','10103366'
INSERT INTO PS_POSITION_DATA VALUES ('10103436','10/8/2006','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10103436','7/6/2009','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10103436','5/16/2011','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10103453','3/28/2005','10103366'
INSERT INTO PS_POSITION_DATA VALUES ('10103494','1/1/1901','10102982'
INSERT INTO PS_POSITION_DATA VALUES ('10103494','3/28/2005','10103443'
INSERT INTO PS_POSITION_DATA VALUES ('10103494','6/23/2008','10106445'
INSERT INTO PS_POSITION_DATA VALUES ('10103555','1/1/1901','10100894'
INSERT INTO PS_POSITION_DATA VALUES ('10103555','12/7/2004','10104679'
INSERT INTO PS_POSITION_DATA VALUES ('10103632','1/1/1901','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10103632','3/28/2005','10103366'
INSERT INTO PS_POSITION_DATA VALUES ('10103765','1/1/1901','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10103765','3/28/2005','10104679'
INSERT INTO PS_POSITION_DATA VALUES ('10103765','9/12/2005','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10103765','7/6/2009','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10103765','5/16/2011','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10103806','1/1/1901','10103296'
INSERT INTO PS_POSITION_DATA VALUES ('10103904','1/1/1901','10103674'
INSERT INTO PS_POSITION_DATA VALUES ('10103904','1/31/2005','10102135'
INSERT INTO PS_POSITION_DATA VALUES ('10103904','3/14/2005','10102957'
INSERT INTO PS_POSITION_DATA VALUES ('10107218','6/3/2008','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10107218','7/6/2009','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10107218','5/16/2011','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10107218','6/27/2011','10108143'
INSERT INTO PS_POSITION_DATA VALUES ('10107307','8/28/2008','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10107307','7/6/2009','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10107307','5/16/2011','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10107506','11/17/2009','10106445'
INSERT INTO PS_POSITION_DATA VALUES ('10107507','11/19/2009','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10107507','7/4/2011','10104504'
INSERT INTO PS_POSITION_DATA VALUES ('10107577','2/16/2010','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10107577','5/16/2011','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10107585','3/10/2010','10103333'
INSERT INTO PS_POSITION_DATA VALUES ('10107585','3/29/2010','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10107585','5/16/2011','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10105778','10/1/2005','10104679'
INSERT INTO PS_POSITION_DATA VALUES ('10105778','1/26/2006','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10105778','7/6/2009','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10105778','5/16/2011','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10104504','8/5/2004','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10104406','1/1/1901','10103355'
INSERT INTO PS_POSITION_DATA VALUES ('10104406','6/11/2007','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10104406','10/15/2007','10106808'
INSERT INTO PS_POSITION_DATA VALUES ('10104406','12/7/2009','10100316'
INSERT INTO PS_POSITION_DATA VALUES ('10104402','1/1/1901','10103355'
INSERT INTO PS_POSITION_DATA VALUES ('10104402','6/11/2007','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10104402','10/15/2007','10106808'
INSERT INTO PS_POSITION_DATA VALUES ('10104402','12/7/2009','10100316'
INSERT INTO PS_POSITION_DATA VALUES ('10104144','1/1/1901','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10104144','3/28/2005','10103366'
INSERT INTO PS_POSITION_DATA VALUES ('10103385','1/1/1901','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10103385','12/7/2004','10104679'
INSERT INTO PS_POSITION_DATA VALUES ('10103381','1/1/1901','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10103381','12/7/2004','10104679'
INSERT INTO PS_POSITION_DATA VALUES ('10103366','1/1/1901','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10103366','3/14/2005','10104679'
INSERT INTO PS_POSITION_DATA VALUES ('10103361','1/1/1901','10102348'
INSERT INTO PS_POSITION_DATA VALUES ('10103333','1/1/1901','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10103333','7/6/2009','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10103333','5/16/2011','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10103231','3/28/2005','10104679'
INSERT INTO PS_POSITION_DATA VALUES ('10103231','9/12/2005','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10103231','7/6/2009','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10103231','5/16/2011','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10103180','1/1/1901','10103333'
INSERT INTO PS_POSITION_DATA VALUES ('10103180','4/11/2005','10101705'
INSERT INTO PS_POSITION_DATA VALUES ('10103180','1/3/2006','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10103180','7/6/2009','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10103180','5/16/2011','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10103180','6/27/2011','10108143'
INSERT INTO PS_POSITION_DATA VALUES ('10103162','1/1/1901','10103202'
INSERT INTO PS_POSITION_DATA VALUES ('10103162','11/8/2004','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10103162','3/26/2007','10103366'
INSERT INTO PS_POSITION_DATA VALUES ('10103162','8/14/2007','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10103044','1/1/1901','10102982'
INSERT INTO PS_POSITION_DATA VALUES ('10103044','3/28/2005','10103443'
INSERT INTO PS_POSITION_DATA VALUES ('10103044','6/23/2008','10106445'
INSERT INTO PS_POSITION_DATA VALUES ('10103016','1/1/1901','10103296'
INSERT INTO PS_POSITION_DATA VALUES ('10102962','1/1/1901','10102348'
INSERT INTO PS_POSITION_DATA VALUES ('10102947','1/1/1901','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10102947','3/28/2005','10103366'
INSERT INTO PS_POSITION_DATA VALUES ('10102879','1/1/1901','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10102879','3/28/2005','10103366'
INSERT INTO PS_POSITION_DATA VALUES ('10102830','4/11/2005','10102348'
INSERT INTO PS_POSITION_DATA VALUES ('10102819','1/1/1901','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10102819','3/28/2005','10103366'
INSERT INTO PS_POSITION_DATA VALUES ('10102756','1/1/1901','10103333'
INSERT INTO PS_POSITION_DATA VALUES ('10102756','4/11/2005','10101705'
INSERT INTO PS_POSITION_DATA VALUES ('10102756','1/3/2006','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10102756','7/6/2009','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10102756','5/16/2011','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10102756','6/27/2011','10108143'
INSERT INTO PS_POSITION_DATA VALUES ('10102701','1/1/1901','10103015'
INSERT INTO PS_POSITION_DATA VALUES ('10102701','4/10/2006','10101741'
INSERT INTO PS_POSITION_DATA VALUES ('10102701','12/10/2007','10103664'
INSERT INTO PS_POSITION_DATA VALUES ('10102701','4/27/2009','10103015'
INSERT INTO PS_POSITION_DATA VALUES ('10102701','6/8/2009','10100684'
INSERT INTO PS_POSITION_DATA VALUES ('10102701','12/7/2009','10103334'
INSERT INTO PS_POSITION_DATA VALUES ('10102701','4/19/2010','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10102682','1/1/1901','10100926'
INSERT INTO PS_POSITION_DATA VALUES ('10102682','4/25/2011','10100441'
INSERT INTO PS_POSITION_DATA VALUES ('10102250','1/1/1901','10102982'
INSERT INTO PS_POSITION_DATA VALUES ('10102250','3/11/2005','10104679'
INSERT INTO PS_POSITION_DATA VALUES ('10102250','12/11/2006','10106445'
INSERT INTO PS_POSITION_DATA VALUES ('10101705','1/1/1901','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10101440','1/1/1901','10101705'
INSERT INTO PS_POSITION_DATA VALUES ('10101440','5/9/2005','10103333'
INSERT INTO PS_POSITION_DATA VALUES ('10100879','1/1/1901','10103366'
INSERT INTO PS_POSITION_DATA VALUES ('10100879','3/28/2005','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10100879','4/11/2005','10101705'
INSERT INTO PS_POSITION_DATA VALUES ('10100879','1/3/2006','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10100879','7/6/2009','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10100879','5/16/2011','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10100879','6/27/2011','10108143'
INSERT INTO PS_POSITION_DATA VALUES ('10100856','1/1/1901','10103202'
INSERT INTO PS_POSITION_DATA VALUES ('10100856','11/8/2004','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10100718','1/1/1901','10102061'
INSERT INTO PS_POSITION_DATA VALUES ('10100718','4/17/2006','10102957'
INSERT INTO PS_POSITION_DATA VALUES ('10100718','4/2/2007','10102448'
INSERT INTO PS_POSITION_DATA VALUES ('10100605','1/1/1901','10103355'
INSERT INTO PS_POSITION_DATA VALUES ('10100605','6/11/2007','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10100605','10/15/2007','10106808'
INSERT INTO PS_POSITION_DATA VALUES ('10100605','12/14/2009','10100316'
INSERT INTO PS_POSITION_DATA VALUES ('10100578','1/1/1901','10103342'
INSERT INTO PS_POSITION_DATA VALUES ('10100578','12/21/2009','10106838'
INSERT INTO PS_POSITION_DATA VALUES ('10100546','1/1/1901','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10100546','3/28/2005','10104679'
INSERT INTO PS_POSITION_DATA VALUES ('10100546','9/12/2005','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10100546','1/3/2006','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10100546','7/6/2009','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10100546','5/16/2011','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10100546','6/27/2011','10108143'
INSERT INTO PS_POSITION_DATA VALUES ('10100435','1/1/1901','10103355'
INSERT INTO PS_POSITION_DATA VALUES ('10100435','6/11/2007','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10100435','10/15/2007','10106808'
INSERT INTO PS_POSITION_DATA VALUES ('10100435','12/7/2009','10100316'
INSERT INTO PS_POSITION_DATA VALUES ('10100316','1/1/1901','10103355'
INSERT INTO PS_POSITION_DATA VALUES ('10100316','6/11/2007','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10100316','10/15/2007','10106808'
INSERT INTO PS_POSITION_DATA VALUES ('10100316','12/7/2009','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10100316','6/6/2011','10106445'
INSERT INTO PS_POSITION_DATA VALUES ('10100292','1/1/1901','10102560'
INSERT INTO PS_POSITION_DATA VALUES ('10100292','10/17/2005','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10100292','7/4/2011','10104504'
INSERT INTO PS_POSITION_DATA VALUES ('10100275','1/1/1901','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10100275','4/2/2007','10104504'
INSERT INTO PS_POSITION_DATA VALUES ('10100275','4/19/2010','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10100275','7/4/2011','10104504'
INSERT INTO PS_POSITION_DATA VALUES ('10100182','1/1/1901','10103056'
INSERT INTO PS_POSITION_DATA VALUES ('10100182','6/20/2005','10102808'
INSERT INTO PS_POSITION_DATA VALUES ('10100182','7/11/2005','10103056'
INSERT INTO PS_POSITION_DATA VALUES ('10108143','6/16/2011','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10107968','7/4/2011','10104504'
INSERT INTO PS_POSITION_DATA VALUES ('10106870','8/20/2007','10103296'
INSERT INTO PS_POSITION_DATA VALUES ('10106822','6/27/2007','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10106822','10/15/2007','10106808'
INSERT INTO PS_POSITION_DATA VALUES ('10106822','12/7/2009','10100316'
INSERT INTO PS_POSITION_DATA VALUES ('10106808','6/19/2007','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10106808','12/7/2009','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10106622','3/9/2007','10102348'
INSERT INTO PS_POSITION_DATA VALUES ('10106490','12/18/2006','10106130'
INSERT INTO PS_POSITION_DATA VALUES ('10106445','11/20/2006','10104679'
INSERT INTO PS_POSITION_DATA VALUES ('10106385','10/5/2006','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10106385','11/30/2006','10100546'
INSERT INTO PS_POSITION_DATA VALUES ('10106179','3/28/2006','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10106179','7/4/2011','10104504'
INSERT INTO PS_POSITION_DATA VALUES ('10106082','2/11/2006','10103270'
INSERT INTO PS_POSITION_DATA VALUES ('10106082','10/30/2006','10106235'
INSERT INTO PS_POSITION_DATA VALUES ('10106082','4/20/2007','10104621'
INSERT INTO PS_POSITION_DATA VALUES ('10106082','1/2/2008','10106235'
INSERT INTO PS_POSITION_DATA VALUES ('10106082','4/21/2008','10103411'
INSERT INTO PS_POSITION_DATA VALUES ('10106082','12/10/2008','10101945'
INSERT INTO PS_POSITION_DATA VALUES ('10106082','1/27/2009','10103150'
INSERT INTO PS_POSITION_DATA VALUES ('10106082','6/8/2009','10103327'
INSERT INTO PS_POSITION_DATA VALUES ('10106082','5/3/2011','10107585'
INSERT INTO PS_POSITION_DATA VALUES ('10106058','1/25/2006','10103443'
INSERT INTO PS_POSITION_DATA VALUES ('10106058','6/23/2008','10106445'
INSERT INTO PS_POSITION_DATA VALUES ('10105578','10/1/2005','10105588'
INSERT INTO PS_POSITION_DATA VALUES ('10105578','3/14/2006','10105549'
INSERT INTO PS_POSITION_DATA VALUES ('10105578','10/15/2007','10105572'
INSERT INTO PS_POSITION_DATA VALUES ('10105578','5/10/2010','10106132'
INSERT INTO PS_POSITION_DATA VALUES ('10105337','10/1/2005','10105778'
INSERT INTO PS_POSITION_DATA VALUES ('10105337','1/16/2006','10100546'
INSERT INTO PS_POSITION_DATA VALUES ('10105337','4/5/2010','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10105337','5/16/2011','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10105186','9/14/2005','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10105186','12/10/2008','10101945'
INSERT INTO PS_POSITION_DATA VALUES ('10105186','5/7/2009','10100429'
INSERT INTO PS_POSITION_DATA VALUES ('10105186','6/15/2009','10101172'
INSERT INTO PS_POSITION_DATA VALUES ('10105154','7/29/2005','10101705'
INSERT INTO PS_POSITION_DATA VALUES ('10105154','1/3/2006','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10105098','6/7/2005','10103443'
INSERT INTO PS_POSITION_DATA VALUES ('10105038','5/6/2005','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10105038','4/2/2007','10103334'
INSERT INTO PS_POSITION_DATA VALUES ('10105038','4/19/2010','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10104951','3/16/2005','10104679'
INSERT INTO PS_POSITION_DATA VALUES ('10104948','3/11/2005','10103366'
INSERT INTO PS_POSITION_DATA VALUES ('10104747','4/14/2005','10101705'
INSERT INTO PS_POSITION_DATA VALUES ('10104747','1/3/2006','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10104747','7/6/2009','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10104747','5/17/2011','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10104747','6/27/2011','10108143'
INSERT INTO PS_POSITION_DATA VALUES ('10103334','1/1/1901','10103202'
INSERT INTO PS_POSITION_DATA VALUES ('10103334','11/8/2004','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10103296','1/1/1901','10102982'
INSERT INTO PS_POSITION_DATA VALUES ('10103296','9/6/2005','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10103296','12/11/2006','10106445'
INSERT INTO PS_POSITION_DATA VALUES ('10103296','4/30/2007','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10103296','7/6/2009','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10103296','5/16/2011','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10103296','6/27/2011','10108143'
INSERT INTO PS_POSITION_DATA VALUES ('10102483','1/1/1901','10102830'
INSERT INTO PS_POSITION_DATA VALUES ('10102483','4/11/2005','10102348'
INSERT INTO PS_POSITION_DATA VALUES ('10102348','1/1/1901','10103333'
INSERT INTO PS_POSITION_DATA VALUES ('10102348','3/28/2005','10103366'
INSERT INTO PS_POSITION_DATA VALUES ('10101945','1/1/1901','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10101945','4/11/2005','10101705'
INSERT INTO PS_POSITION_DATA VALUES ('10101945','1/3/2006','10103555'
INSERT INTO PS_POSITION_DATA VALUES ('10101945','7/6/2009','10104951'
INSERT INTO PS_POSITION_DATA VALUES ('10101945','5/16/2011','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10101945','6/27/2011','10108143'
INSERT INTO PS_POSITION_DATA VALUES ('10101890','1/1/1901','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10101890','3/28/2005','10103366'
INSERT INTO PS_POSITION_DATA VALUES ('10101889','1/1/1901','10103202'
INSERT INTO PS_POSITION_DATA VALUES ('10101889','11/8/2004','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10101889','4/2/2007','10104504'
INSERT INTO PS_POSITION_DATA VALUES ('10101889','4/19/2010','10103385'
INSERT INTO PS_POSITION_DATA VALUES ('10101889','7/4/2011','10104504'
INSERT INTO PS_POSITION_DATA VALUES ('10101841','1/1/1901','10102124'
INSERT INTO PS_POSITION_DATA VALUES ('10101841','5/9/2011','10106874'
INSERT INTO PS_POSITION_DATA VALUES ('10106056','1/19/2006','10103443'
INSERT INTO PS_POSITION_DATA VALUES ('10106056','6/23/2008','10106445'
INSERT INTO PS_EMPLOYMENT VALUES ('076585','0','EMP','6/6/2011','6/6/2011')
INSERT INTO PS_EMPLOYMENT VALUES ('076491','0','EMP','5/23/2011','5/23/2011')
INSERT INTO PS_EMPLOYMENT VALUES ('075999','0','CWR','10/20/2010','10/20/2010')
INSERT INTO PS_EMPLOYMENT VALUES ('075998','0','CWR','10/20/2010','10/20/2010')
INSERT INTO PS_EMPLOYMENT VALUES ('075996','0','CWR','10/20/2010','10/20/2010')
INSERT INTO PS_EMPLOYMENT VALUES ('075977','0','EMP','10/13/2010','10/13/2010')
INSERT INTO PS_EMPLOYMENT VALUES ('075870','0','EMP','9/13/2010','9/13/2010')
INSERT INTO PS_EMPLOYMENT VALUES ('075869','0','EMP','9/10/2010','9/10/2010')
INSERT INTO PS_EMPLOYMENT VALUES ('075225','0','EMP','3/6/2010','3/6/2010')
INSERT INTO PS_EMPLOYMENT VALUES ('075200','0','EMP','3/1/2010','3/1/2010')
INSERT INTO PS_EMPLOYMENT VALUES ('074636','0','EMP','4/13/2009','4/13/2009')
INSERT INTO PS_EMPLOYMENT VALUES ('074586','0','EMP','3/30/2009','3/30/2009')
INSERT INTO PS_EMPLOYMENT VALUES ('074409','0','EMP','11/10/2008','11/10/2008')
INSERT INTO PS_EMPLOYMENT VALUES ('074257','0','EMP','8/29/2008','8/29/2008')
INSERT INTO PS_EMPLOYMENT VALUES ('074049','0','EMP','6/18/2008','6/18/2008')
INSERT INTO PS_EMPLOYMENT VALUES ('073985','0','EMP','6/16/2008','6/16/2008')
INSERT INTO PS_EMPLOYMENT VALUES ('073799','0','EMP','4/22/2008','4/22/2008')
INSERT INTO PS_EMPLOYMENT VALUES ('073265','0','EMP','10/29/2007','10/29/2007')
INSERT INTO PS_EMPLOYMENT VALUES ('073199','0','EMP','9/13/2007','9/13/2007')
INSERT INTO PS_EMPLOYMENT VALUES ('072635','0','EMP','4/12/2007','4/12/2007')
INSERT INTO PS_EMPLOYMENT VALUES ('072515','0','EMP','4/9/2007','4/9/2007')
INSERT INTO PS_EMPLOYMENT VALUES ('072165','0','EMP','12/11/2006','12/11/2006')
INSERT INTO PS_EMPLOYMENT VALUES ('072140','0','EMP','11/27/2006','11/27/2006')
INSERT INTO PS_EMPLOYMENT VALUES ('071769','0','EMP','4/11/2011','9/5/2006')
INSERT INTO PS_EMPLOYMENT VALUES ('071698','0','EMP','8/28/2006','8/28/2006')
INSERT INTO PS_EMPLOYMENT VALUES ('071569','0','EMP','7/10/2006','7/10/2006')
INSERT INTO PS_EMPLOYMENT VALUES ('070949','0','CWR','7/9/2008','12/16/2005')
INSERT INTO PS_EMPLOYMENT VALUES ('070547','1','EMP','1/1/2006','1/1/2006')
INSERT INTO PS_EMPLOYMENT VALUES ('070118','1','EMP','1/1/2006','1/1/2006')
INSERT INTO PS_EMPLOYMENT VALUES ('069833','0','EMP','9/12/2005','9/12/2005')
INSERT INTO PS_EMPLOYMENT VALUES ('069736','0','EMP','9/12/2005','9/12/2005')
INSERT INTO PS_EMPLOYMENT VALUES ('069731','0','EMP','12/14/2009','7/25/2005')
INSERT INTO PS_EMPLOYMENT VALUES ('069687','0','EMP','7/18/2005','7/18/2005')
INSERT INTO PS_EMPLOYMENT VALUES ('069171','0','EMP','11/1/2004','11/1/2004')
INSERT INTO PS_EMPLOYMENT VALUES ('068299','0','EMP','9/2/2003','9/2/2003')
INSERT INTO PS_EMPLOYMENT VALUES ('068141','0','EMP','5/19/2003','5/19/2003')
INSERT INTO PS_EMPLOYMENT VALUES ('067898','0','EMP','12/16/2002','12/16/2002')
INSERT INTO PS_EMPLOYMENT VALUES ('067808','0','EMP','9/9/2002','9/9/2002')
INSERT INTO PS_EMPLOYMENT VALUES ('064514','0','EMP','6/23/2011','4/26/1999')
INSERT INTO PS_EMPLOYMENT VALUES ('063989','0','EMP','4/18/2005','8/3/1998')
INSERT INTO PS_EMPLOYMENT VALUES ('063407','0','EMP','11/17/1997','11/17/1997')
INSERT INTO PS_EMPLOYMENT VALUES ('063252','0','EMP','9/22/1997','9/22/1997')
INSERT INTO PS_EMPLOYMENT VALUES ('063242','0','EMP','9/8/1997','9/8/1997')
INSERT INTO PS_EMPLOYMENT VALUES ('059775','0','EMP','3/10/1997','3/10/1997')
INSERT INTO PS_EMPLOYMENT VALUES ('053923','0','EMP','8/27/1990','8/27/1990')
INSERT INTO PS_EMPLOYMENT VALUES ('053873','0','EMP','8/13/1990','8/13/1990')
INSERT INTO PS_EMPLOYMENT VALUES ('052083','0','EMP','3/27/1989','3/27/1989')
INSERT INTO PS_EMPLOYMENT VALUES ('048840','0','EMP','1/22/1987','1/22/1987')
INSERT INTO PS_EMPLOYMENT VALUES ('048572','0','EMP','11/10/1986','11/10/1986')
INSERT INTO PS_EMPLOYMENT VALUES ('047836','0','EMP','9/6/2007','6/9/1986')
INSERT INTO PS_EMPLOYMENT VALUES ('047514','0','EMP','4/14/1986','4/14/1986')
INSERT INTO PS_EMPLOYMENT VALUES ('046294','0','EMP','5/20/1985','5/20/1985')
INSERT INTO PS_EMPLOYMENT VALUES ('046096','0','EMP','4/18/1985','4/18/1985')
INSERT INTO PS_EMPLOYMENT VALUES ('045013','0','EMP','9/24/1984','9/24/1984')
INSERT INTO PS_EMPLOYMENT VALUES ('042450','1','EMP','2/6/2006','2/6/2006')
INSERT INTO PS_EMPLOYMENT VALUES ('042450','0','EMP','3/4/1974','3/4/1974')
INSERT INTO PS_EMPLOYMENT VALUES ('042303','0','EMP','8/9/1982','8/9/1982')
INSERT INTO PS_EMPLOYMENT VALUES ('038761','0','EMP','10/13/1980','10/13/1980')
INSERT INTO PS_EMPLOYMENT VALUES ('031975','0','EMP','1/22/1979','1/22/1979')
INSERT INTO PS_EMPLOYMENT VALUES ('030847','0','EMP','7/5/1978','7/5/1978')
INSERT INTO PS_EMPLOYMENT VALUES ('029545','0','EMP','11/21/1977','11/21/1977')
INSERT INTO PS_EMPLOYMENT VALUES ('028233','0','EMP','4/4/1977','4/4/1977')
INSERT INTO PS_EMPLOYMENT VALUES ('027930','0','EMP','1/10/1977','1/10/1977')
INSERT INTO PS_EMPLOYMENT VALUES ('027351','0','EMP','9/21/1976','9/21/1976')
INSERT INTO PS_EMPLOYMENT VALUES ('027156','0','EMP','8/16/1976','8/16/1976')
INSERT INTO PS_EMPLOYMENT VALUES ('025649','0','EMP','7/28/1975','7/28/1975')
INSERT INTO PS_EMPLOYMENT VALUES ('024293','0','EMP','7/29/1974','7/29/1974')
INSERT INTO PS_EMPLOYMENT VALUES ('021613','0','EMP','4/24/1972','4/24/1972')
Thanks in advance for any help you can provide.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply