OUTER JOIN Not Producing Non Existent Record with IS NULL

Question

OUTER JOIN Not Producing Non Existent Record with IS NULL

Viewing 15 posts - 16 through 30 (of 93 total)

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

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 1

serviceaellis (8/18/2015)
Please see attached.
The worksheet is the result that needs to be produced with the highlighted row.
in the Access file the two tables are:
1. PersonMembership - with all the membership info
2. v060ClubOfficersPresOrNot - will all the club info which ALL of these should show and show when there is/are membership(s) or not.
3. for the duration of current year and future years where the MemberTypeID =3 is a 4 year membership.
Working with ClubNo 5305 and 8004 as these are the data sets that can be used to verify the correct result.
When the end-user enters 2015 they should see:
1. ClubNo 5305 club info with 15 memberships
2. ClubNo 8004 club info with 0 memberships
When the end-user enters 2016 they should see:
1. ClubNo 5305 club info with 0 memberships
2. ClubNo 8004 club info with 0 memberships

Please run this and report back with the results:

SELECT * FROM dbo.v060ClubOfficersPresOrNot WHERE ClubID IN (5305,8004)

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 2

as a starter....does this get you the required results....??

DECLARE @yr AS int;

SET @yr = 2015;

WITH cteclub

AS (

SELECT DISTINCT

ClubID

, ClubNo

FROM v060ClubOfficersPresOrNot

)

,

ctebydate

AS (

SELECT

OrganizationId

, PersonId

, EndDate

, MembershipTypeId

FROM PersonMembership AS p

WHERE (YEAR(EndDate) >= @yr)

AND (MONTH(EndDate) = 6)

AND (DAY(EndDate) = 30)

)

SELECT

c.ClubID

, c.ClubNo

, cd.OrganizationId

, cd.PersonId

, cd.EndDate

, cd.MembershipTypeId

FROM cteclub AS c LEFT OUTER JOIN

ctebydate AS cd ON c.ClubID = cd.OrganizationId

--WHERE (c.ClubNo = 5305)

ORDER BY

c.ClubNo;

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 3

....had some time on my hands, so for the benefit of other posters and as a pointer to the OP...here's the data ready to be generated from SSMS

use tempdb;

CREATE TABLE v060ClubOfficersPresOrNot(

ClubID VARCHAR(11) NOT NULL

,ClubNo INTEGER NOT NULL

,SortName VARCHAR(11)

,ClubName VARCHAR(33)

,Contact VARCHAR(22)

,USFSA INTEGER

,StreetOne VARCHAR(22)

,StreetTwo VARCHAR(4)

,CareOf VARCHAR(16)

,City VARCHAR(11)

,State VARCHAR(4)

,PostalCode VARCHAR(5)

,OrgType VARCHAR(12)

,ClubRegion VARCHAR(17)

,ClubSection VARCHAR(10)

,Email VARCHAR(24)

,Phone VARCHAR(13)

,FirstName VARCHAR(10)

,FacilityName VARCHAR(25)

,PresClubSec VARCHAR(7)

,PresUSFSA VARCHAR(7)

,PresCareOf VARCHAR(16)

,PresAdd1 VARCHAR(22)

,PresAdd2 VARCHAR(4)

,PresCity VARCHAR(11)

,PresState VARCHAR(4)

,PresZip VARCHAR(5)

,PersonId VARCHAR(11)

,President VARCHAR(17)

,PresEmail VARCHAR(21)

,PresPhone VARCHAR(12)

,StatusId VARCHAR(4)

,URL VARCHAR(16)

,Certified VARCHAR(4)

,Code VARCHAR(4)

,FacilityLastUpdate VARCHAR(23)

,ByLawsUploadDate VARCHAR(4)

,BSProgram VARCHAR(3)

,ProgramStatusId VARCHAR(4)

,Status VARCHAR(6)

,IsActive BIT

);

INSERT INTO v060ClubOfficersPresOrNot(ClubID,ClubNo,SortName,ClubName,Contact,USFSA,StreetOne,StreetTwo,CareOf,City,State,PostalCode,OrgType,ClubRegion,ClubSection,Email,Phone,FirstName,FacilityName,PresClubSec,PresUSFSA,PresCareOf,PresAdd1,PresAdd2,PresCity,PresState,PresZip,PersonId,President,PresEmail,PresPhone,StatusId,URL,Certified,Code,FacilityLastUpdate,ByLawsUploadDate,BSProgram,ProgramStatusId,Status,IsActive) VALUES

('ORG00000201',1617,NULL,'Cedar Valley FSC','Abby Loeffelholz',554410,NULL,NULL,NULL,NULL,NULL,NULL,'Regular Club','Upper Great Lakes','Midwestern',NULL,NULL,'Abby',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'No',NULL,NULL,0)

,('ORG00000201',1617,NULL,'Cedar Valley FSC','Carrie Schaefer',1185225,NULL,NULL,NULL,NULL,NULL,NULL,'Regular Club','Upper Great Lakes','Midwestern',NULL,NULL,'Carrie',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'No',NULL,NULL,0)

,('ORG00000201',1617,NULL,'Cedar Valley FSC','Karen Bushanam',1097873,NULL,NULL,NULL,NULL,NULL,NULL,'Regular Club','Upper Great Lakes','Midwestern',NULL,NULL,'Karen',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'No',NULL,NULL,0)

,('ORG00000201',1617,NULL,'Cedar Valley FSC','Keith Loeffelholz',1508633,NULL,NULL,NULL,NULL,NULL,NULL,'Regular Club','Upper Great Lakes','Midwestern',NULL,NULL,'Keith',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'No',NULL,NULL,0)

,('ORG00000201',1617,NULL,'Cedar Valley FSC','Virginia Fienup',1453716,NULL,NULL,NULL,NULL,NULL,NULL,'Regular Club','Upper Great Lakes','Midwestern',NULL,NULL,'Virginia',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'No',NULL,NULL,0)

,('ORG00000380',22,'ADIRONDACKS','SC of the Adirondacks, Inc.','Jackie Germaine',8925101,'Ruger St',NULL,'MarkChristiansen','Plattsburg','NY','12901','Regular Club','North Atlantic','Eastern','christma@plattsburgh.edu',NULL,'Jackie','Stafford Arena','Eastern','8930130','MarkChristiansen','Ruger St',NULL,'Plattsburg','NY','12901','PER01341423','Jeanette Woodruff','jwoodruff@saranac.org',NULL,'3',NULL,'Yes','NA','2014-07-06 17:16:00.000',NULL,'Yes','3','Active',1)

,('ORG00000380',22,'ADIRONDACKS','SC of the Adirondacks, Inc.','Jeanette Woodruff',8930130,'Ruger St',NULL,'MarkChristiansen','Plattsburg','NY','12901','Regular Club','North Atlantic','Eastern','christma@plattsburgh.edu',NULL,'Jeanette','Stafford Arena','Eastern','8930130','MarkChristiansen','Ruger St',NULL,'Plattsburg','NY','12901','PER01341423','Jeanette Woodruff','jwoodruff@saranac.org',NULL,'3',NULL,'Yes','NA','2014-07-06 17:16:00.000',NULL,'Yes','3','Active',1)

,('ORG00000380',22,'ADIRONDACKS','SC of the Adirondacks, Inc.','Martha Breyette',8676581,'Ruger St',NULL,'MarkChristiansen','Plattsburg','NY','12901','Regular Club','North Atlantic','Eastern','christma@plattsburgh.edu',NULL,'Martha','Stafford Arena','Eastern','8930130','MarkChristiansen','Ruger St',NULL,'Plattsburg','NY','12901','PER01341423','Jeanette Woodruff','jwoodruff@saranac.org',NULL,'3',NULL,'Yes','NA','2014-07-06 17:16:00.000',NULL,'Yes','3','Active',1)

,('ORG00000380',22,'ADIRONDACKS','SC of the Adirondacks, Inc.','Robin Vanweort',1207724,'Ruger St',NULL,'MarkChristiansen','Plattsburg','NY','12901','Regular Club','North Atlantic','Eastern','christma@plattsburgh.edu',NULL,'Robin','Stafford Arena','Eastern','8930130','MarkChristiansen','Ruger St',NULL,'Plattsburg','NY','12901','PER01341423','Jeanette Woodruff','jwoodruff@saranac.org',NULL,'3',NULL,'Yes','NA','2014-07-06 17:16:00.000',NULL,'Yes','3','Active',1)

,('ORG00000380',22,'ADIRONDACKS','SC of the Adirondacks, Inc.','Susan Billow',8875466,'Ruger St',NULL,'MarkChristiansen','Plattsburg','NY','12901','Regular Club','North Atlantic','Eastern','christma@plattsburgh.edu',NULL,'Susan','Stafford Arena','Eastern','8930130','MarkChristiansen','Ruger St',NULL,'Plattsburg','NY','12901','PER01341423','Jeanette Woodruff','jwoodruff@saranac.org',NULL,'3',NULL,'Yes','NA','2014-07-06 17:16:00.000',NULL,'Yes','3','Active',1)

,('ORG00001430',8004,NULL,'Florida Interclub Skating Council','Charlotte Schermerhorn',553074,NULL,NULL,NULL,NULL,NULL,NULL,'Interclubs','South Atlantic','Eastern',NULL,NULL,'Charlotte',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'No',NULL,NULL,0)

,('ORG00001430',8004,NULL,'Florida Interclub Skating Council','David Thompson',403333,NULL,NULL,NULL,NULL,NULL,NULL,'Interclubs','South Atlantic','Eastern',NULL,NULL,'David',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'No',NULL,NULL,0)

,('ORG00001430',8004,NULL,'Florida Interclub Skating Council','Earl Roberts',538190,NULL,NULL,NULL,NULL,NULL,NULL,'Interclubs','South Atlantic','Eastern',NULL,NULL,'Earl',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'No',NULL,NULL,0)

,('ORG00001430',8004,NULL,'Florida Interclub Skating Council','Jacqueline Addis',551706,NULL,NULL,NULL,NULL,NULL,NULL,'Interclubs','South Atlantic','Eastern',NULL,NULL,'Jacqueline',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'No',NULL,NULL,0)

,('ORG00004619',5305,'Shoreline','Shoreline Skating Club','Mandy Curtin',1561794,'121 Donald Lynch Blvd.',NULL,NULL,'Marlborough','MA','01752','Regular Club','New England','Eastern',NULL,'(508)229-2700','Mandy','New England Sports Center','Eastern','1561794',NULL,'121 Donald Lynch Blvd.',NULL,'Marlborough','MA','01752','PER00334157','Mandy Curtin','mandycurtin64@msn.com','617-909-0578','3','www.scboston.org','Yes','NE','2014-07-02 13:44:00.000',NULL,'No',NULL,'Active',1);

CREATE TABLE PersonMembership(

Id INTEGER NOT NULL

,PersonId VARCHAR(11)

,OrganizationId VARCHAR(11)

,MembershipTypeId INTEGER

,StartDate DATETIME

,EndDate DATETIME

,InvoiceNumber VARCHAR(17)

,XfrRequestedToClubId VARCHAR(11)

,IsReleased BIT

,CreatedById VARCHAR(11)

,CreatedDate DATETIME

,ModifiedById VARCHAR(11)

,Timestamp INTEGER

,PaymentDate DATETIME

,EndYear INTEGER

);

INSERT INTO PersonMembership(Id,PersonId,OrganizationId,MembershipTypeId,StartDate,EndDate,InvoiceNumber,XfrRequestedToClubId,IsReleased,CreatedById,CreatedDate,ModifiedById,PaymentDate,EndYear) VALUES

(2909193,'PER00633872','ORG00000082',3,'2012-07-01 00:00:00.000','2016-06-30 00:00:00.000','Legacy',NULL,0,'PER01175838','2012-09-10 16:56:28.000','PER01175838','2012-09-10 00:00:00.000',2016)

,(3060675,'PER00542813','ORG00000110',3,'2013-07-01 00:00:00.000','2017-06-30 00:00:00.000','Legacy',NULL,0,'PER00438479','2013-08-01 21:30:40.000','PER00438479','2013-08-01 00:00:00.000',2017)

,(3182239,'PER01267404','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3182241,'PER00013240','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3182246,'PER00411411','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3182248,'PER00921838','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3182250,'PER00386805','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3193669,'PER01312875','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0012417',NULL,0,'PER00725095','2014-06-16 22:12:29.000','PER00725095','2014-06-17 00:00:00.000',2015)

,(3193671,'PER00916088','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0012417',NULL,0,'PER00725095','2014-06-16 22:12:29.000','PER00725095','2014-06-17 00:00:00.000',2015)

,(3193673,'PER01370651','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0012417',NULL,0,'PER00725095','2014-06-16 22:12:29.000','PER00725095','2014-06-17 00:00:00.000',2015)

,(3193678,'PER01411487','ORG00000007',4,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0012417',NULL,0,'PER00725095','2014-06-16 22:12:29.000','PER00725095','2014-06-17 00:00:00.000',2015)

,(3202236,'PER01084568','ORG00000007',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202238,'PER01113538','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202261,'PER01412578','ORG00000007',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202263,'PER01412580','ORG00000007',4,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3205076,'PER00817444','ORG00004619',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015112',NULL,0,'PER01084657','2014-06-25 13:54:02.000','PER01084657','2014-06-25 00:00:00.000',2015)

,(3205078,'PER00475635','ORG00004619',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015112',NULL,0,'PER01084657','2014-06-25 13:54:02.000','PER01084657','2014-06-25 00:00:00.000',2015)

,(3205112,'PER00020124','ORG00004619',1,'2014-06-25 00:00:00.000','2015-06-30 00:00:00.000','0015085',NULL,0,'PER00474964','2014-06-25 00:00:00.000','PER00087235','2014-06-25 00:00:00.000',2015)

,(3205703,'PER01336187','ORG00000198',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3205705,'PER01020941','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3205712,'PER01211276','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3205714,'PER01336186','ORG00000198',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3211353,'PER01083402','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211360,'PER00995406','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211362,'PER01000110','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211385,'PER00221140','ORG00000082',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211387,'PER00387198','ORG00000082',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211394,'PER00817215','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211396,'PER00916705','ORG00000082',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211753,'PER01413595','ORG00000007',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016527',NULL,0,'PER00725095','2014-06-29 15:52:32.000','PER00725095','2014-06-29 00:00:00.000',2015)

,(3217101,'PER01354697','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0017672',NULL,0,'PER00725095','2014-07-01 00:24:18.000','PER00725095','2014-07-01 00:00:00.000',2015)

,(3218580,'PER00445462','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0017980',NULL,0,'PER00725095','2014-07-01 17:22:17.000','PER00725095','2014-07-02 00:00:00.000',2015)

,(3221722,'PER01245918','ORG00000007',1,'2014-07-04 00:00:00.000','2015-06-30 00:00:00.000','0018530',NULL,0,'PER00725095','2014-07-04 16:15:11.000','PER00725095','2014-07-05 00:00:00.000',2015)

,(3224130,'PER01178669','ORG00000007',1,'2014-07-07 00:00:00.000','2015-06-30 00:00:00.000','0018879',NULL,0,'PER00725095','2014-07-07 15:56:50.000','PER00725095','2014-07-07 00:00:00.000',2015)

,(3234592,'PER01036946','ORG00000380',1,'2014-07-18 00:00:00.000','2015-06-30 00:00:00.000','0020446',NULL,0,'PER01085259','2014-07-18 16:25:30.000','PER01085259','2014-07-19 00:00:00.000',2015)

,(3238066,'PER01113539','ORG00000007',1,'2014-07-26 00:00:00.000','2015-06-30 00:00:00.000','0021294',NULL,0,'PER00725095','2014-07-26 09:32:30.000','PER00725095','2014-07-26 00:00:00.000',2015)

,(3238068,'PER01265348','ORG00000007',1,'2014-07-26 00:00:00.000','2015-06-30 00:00:00.000','0021294',NULL,0,'PER00725095','2014-07-26 09:32:30.000','PER00725095','2014-07-26 00:00:00.000',2015)

,(3246924,'PER00057958','ORG00000380',3,'2014-08-18 00:00:00.000','2018-06-30 00:00:00.000','0023624',NULL,0,'PER01085259','2014-08-18 06:00:21.000','PER01085259','2014-08-18 00:00:00.000',2018)

,(3251595,'PER00416989','ORG00000007',1,'2014-09-02 00:00:00.000','2015-06-30 00:00:00.000','0026641',NULL,0,'PER01337808','2014-09-02 20:21:19.000','PER01337808','2014-09-03 00:00:00.000',2015)

,(3256484,'PER01192227','ORG00000198',1,'2014-09-14 00:00:00.000','2015-06-30 00:00:00.000','0028545',NULL,0,'PER01336186','2014-09-14 19:02:14.000','PER01336186','2014-09-14 00:00:00.000',2015)

,(3257956,'PER01211260','ORG00000198',1,'2014-09-16 00:00:00.000','2015-06-30 00:00:00.000','0028799',NULL,0,'PER01336186','2014-09-16 20:21:28.000','PER01336186','2014-09-16 00:00:00.000',2015)

,(3265967,'PER00299004','ORG00000198',1,'2014-09-29 00:00:00.000','2015-06-30 00:00:00.000','0030019',NULL,0,'PER01336186','2014-09-29 19:55:27.000','PER01336186','2014-09-29 00:00:00.000',2015)

,(3265969,'PER00351336','ORG00000198',2,'2014-09-29 00:00:00.000','2015-06-30 00:00:00.000','0030019',NULL,0,'PER01336186','2014-09-29 19:55:27.000','PER01336186','2014-09-29 00:00:00.000',2015)

,(3265971,'PER01354268','ORG00000198',1,'2014-09-29 00:00:00.000','2015-06-30 00:00:00.000','0030019',NULL,0,'PER01336186','2014-09-29 19:55:28.000','PER01336186','2014-09-29 00:00:00.000',2015)

,(3273723,'PER00630039','ORG00000201',1,'2014-10-10 00:00:00.000','2015-06-30 00:00:00.000','0030959',NULL,0,'PER00404665','2014-10-10 21:17:37.000','PER00404665','2014-10-10 00:00:00.000',2015)

,(3283449,'PER01015507','ORG00000380',1,'2014-10-30 00:00:00.000','2015-06-30 00:00:00.000','0032860',NULL,0,'PER01085259','2014-10-30 18:38:58.000','PER01085259','2014-10-31 00:00:00.000',2015)

,(3283451,'PER01102735','ORG00000380',2,'2014-10-30 00:00:00.000','2015-06-30 00:00:00.000','0032860',NULL,0,'PER01085259','2014-10-30 18:38:58.000','PER01085259','2014-10-31 00:00:00.000',2015)

,(3288874,'PER01211252','ORG00000198',2,'2014-11-09 00:00:00.000','2015-06-30 00:00:00.000','0033546',NULL,0,'PER01336186','2014-11-09 15:04:32.000','PER01336186','2014-11-09 00:00:00.000',2015)

,(3340707,'PER01475950','ORG00000002',1,'2015-02-20 00:00:00.000','2015-06-30 00:00:00.000','0039978',NULL,0,'PER00390108','2015-02-20 14:56:24.000','PER00390108','2015-02-20 00:00:00.000',2015)

,(3354986,'PER01485407','ORG00000007',1,'2015-03-17 00:00:00.000','2015-06-30 00:00:00.000','0041352',NULL,0,'PER01337808','2015-03-17 22:53:47.000','PER01337808','2015-03-18 00:00:00.000',2015)

,(3376839,'PER00393342','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:53.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3376841,'PER00905088','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:53.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3376846,'PER01271452','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:55.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3376848,'PER01345955','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:55.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3396627,'PER00975212','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049272',NULL,0,'PER00390108','2015-06-21 13:56:08.000','PER00390108','2015-06-21 00:00:00.000',2016)

,(3398331,'PER00299031','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:29.000','PER01336186','2015-06-22 00:00:00.000',2016)

,(3398333,'PER00667750','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:30.000','PER01336186','2015-06-22 00:00:00.000',2016)

,(3398340,'PER01211229','ORG00000198',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:31.000','PER01336186','2015-06-22 00:00:00.000',2016)

,(3398342,'PER01294724','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:31.000','PER01336186','2015-06-22 00:00:00.000',2016)

,(3401239,'PER01393650','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:22.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401241,'PER01262431','ORG00000007',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:23.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3402909,'PER01113521','ORG00000198',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050662',NULL,0,'PER01336186','2015-06-25 18:52:56.000','PER01336186','2015-06-25 00:00:00.000',2016)

,(3402911,'PER01336188','ORG00000198',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050662',NULL,0,'PER01336186','2015-06-25 18:52:57.000','PER01336186','2015-06-25 00:00:00.000',2016)

,(3402913,'PER01503658','ORG00000198',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050662',NULL,0,'PER01336186','2015-06-25 18:52:57.000','PER01336186','2015-06-25 00:00:00.000',2016)

,(3406119,'PER01351795','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:36.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406121,'PER01083404','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:37.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406128,'PER00221103','ORG00000082',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:38.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406130,'PER00719479','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:38.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406153,'PER00719482','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:44.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406155,'PER00902843','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:45.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406160,'PER01100774','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:47.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406162,'PER01271704','ORG00000082',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:48.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406821,'PER01280875','ORG00000007',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:34.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406823,'PER00049758','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:35.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406830,'PER01212127','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:36.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406832,'PER01337750','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:37.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3418564,'PER01020943','ORG00000198',1,'2015-07-02 00:00:00.000','2016-06-30 00:00:00.000','0053752',NULL,0,'PER01336186','2015-07-02 20:51:18.000','PER01336186','2015-07-02 00:00:00.000',2016)

,(3418789,'PER01192227','ORG00000198',1,'2015-07-03 00:00:00.000','2016-06-30 00:00:00.000','0053787',NULL,0,'PER01336186','2015-07-03 09:31:29.000','PER01336186','2015-07-03 00:00:00.000',2016)

,(3420536,'PER01354268','ORG00000198',1,'2015-07-06 00:00:00.000','2016-06-30 00:00:00.000','0054107',NULL,0,'PER01336186','2015-07-06 17:28:47.000','PER01336186','2015-07-06 00:00:00.000',2016)

,(3427788,'PER01211260','ORG00000198',1,'2015-07-16 00:00:00.000','2016-06-30 00:00:00.000','0055400',NULL,0,'PER01336186','2015-07-16 10:21:15.000','PER01336186','2015-07-16 00:00:00.000',2016)

,(3427888,'PER01507653','ORG00000380',2,'2015-07-16 00:00:00.000','2016-06-30 00:00:00.000','0055424',NULL,0,'PER01341423','2015-07-16 13:05:43.000','PER01341423','2015-07-16 00:00:00.000',2016)

,(3431457,'PER00026045','ORG00000201',1,'2015-07-21 00:00:00.000','2016-06-30 00:00:00.000','0056033',NULL,0,'PER00404665','2015-07-21 21:40:22.000','PER00404665','2015-07-21 00:00:00.000',2016)

,(2690167,'PER00522397','ORG00000198',3,'2011-07-01 00:00:00.000','2015-06-30 00:00:00.000','Legacy',NULL,0,'PER00541106','2011-06-28 18:57:03.000','PER00541106','2011-06-28 00:00:00.000',2015)

,(2924418,'PER00216928','ORG00000198',3,'2012-07-01 00:00:00.000','2016-06-30 00:00:00.000','Legacy',NULL,0,'PER00294981','2012-10-04 20:28:55.000','PER00294981','2012-10-04 00:00:00.000',2016)

,(3045414,'PER00866631','ORG00000110',3,'2013-07-01 00:00:00.000','2017-06-30 00:00:00.000','Legacy',NULL,0,'PER00438479','2013-07-08 12:11:02.000','PER00438479','2013-07-08 00:00:00.000',2017)

,(3074108,'PER00302293','ORG00000198',3,'2013-07-01 00:00:00.000','2017-06-30 00:00:00.000','Legacy',NULL,0,'PER00294981','2013-09-11 20:35:24.000','PER00294981','2013-09-11 00:00:00.000',2017)

,(3074905,'PER00294036','ORG00000380',3,'2013-07-01 00:00:00.000','2017-06-30 00:00:00.000','Legacy',NULL,0,'PER01340061','2013-09-13 13:57:50.000','PER01340061','2013-08-30 00:00:00.000',2017)

,(3109540,'PER00443891','ORG00000110',3,'2013-07-01 00:00:00.000','2017-06-30 00:00:00.000','Legacy',NULL,0,'PER00438479','2013-11-21 17:22:32.000','PER00438479','2013-11-21 00:00:00.000',2017)

,(3182240,'PER01393641','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3182247,'PER00905088','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3182258,'PER01343886','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3186102,'PER01349493','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009874',NULL,0,'PER00390108','2014-06-07 12:31:45.000','PER00390108','2014-06-07 00:00:00.000',2015)

,(3193661,'PER00725095','ORG00000007',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0012417',NULL,0,'PER00725095','2014-06-16 22:12:29.000','PER00725095','2014-06-17 00:00:00.000',2015)

,(3193672,'PER01262431','ORG00000007',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0012417',NULL,0,'PER00725095','2014-06-16 22:12:29.000','PER00725095','2014-06-17 00:00:00.000',2015)

,(3200942,'PER00636310','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014190',NULL,0,'PER00636310','2014-06-23 10:41:54.000','PER00636310','2014-06-23 00:00:00.000',2015)

,(3202235,'PER00933393','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202246,'PER00385555','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202253,'PER01091241','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202260,'PER01337750','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3205079,'PER01271203','ORG00004619',1,'2014-06-25 00:00:00.000','2015-06-30 00:00:00.000','0011069',NULL,0,'PER00474964','2014-06-25 00:00:00.000',NULL,'2014-06-11 00:00:00.000',2015)

,(3205111,'PER00009323','ORG00004619',1,'2014-06-25 00:00:00.000','2015-06-30 00:00:00.000','0011069',NULL,0,'PER00474964','2014-06-25 00:00:00.000',NULL,'2014-06-11 00:00:00.000',2015)

,(3205697,'PER00589047','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3205704,'PER00789915','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3205711,'PER01211254','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3210945,'PER01211238','ORG00000198',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016369',NULL,0,'PER01336186','2014-06-29 08:48:12.000','PER01336186','2014-06-29 00:00:00.000',2015)

,(3211363,'PER01083404','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211370,'PER00460493','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211377,'PER00919727','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211388,'PER00540066','ORG00000082',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211395,'PER00902843','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211402,'PER01083406','ORG00000082',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211413,'PER01351795','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211738,'PER00824401','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016527',NULL,0,'PER00725095','2014-06-29 15:52:32.000','PER00725095','2014-06-29 00:00:00.000',2015)

,(3211745,'PER01336851','ORG00000007',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016527',NULL,0,'PER00725095','2014-06-29 15:52:32.000','PER00725095','2014-06-29 00:00:00.000',2015)

,(3211752,'PER01413594','ORG00000007',4,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016527',NULL,0,'PER00725095','2014-06-29 15:52:32.000','PER00725095','2014-06-29 00:00:00.000',2015)

,(3217100,'PER01393649','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0017672',NULL,0,'PER00725095','2014-07-01 00:24:18.000','PER00725095','2014-07-01 00:00:00.000',2015)

,(3218579,'PER00026271','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0017980',NULL,0,'PER00725095','2014-07-01 17:22:17.000','PER00725095','2014-07-02 00:00:00.000',2015)

,(3234598,'PER01336204','ORG00000380',1,'2014-07-18 00:00:00.000','2015-06-30 00:00:00.000','0020446',NULL,0,'PER01085259','2014-07-18 16:25:30.000','PER01085259','2014-07-19 00:00:00.000',2015)

,(3234609,'PER01002396','ORG00000380',4,'2014-07-18 00:00:00.000','2015-06-30 00:00:00.000','0020446',NULL,0,'PER01085259','2014-07-18 16:25:31.000','PER01085259','2014-07-19 00:00:00.000',2015)

,(3237642,'PER00026045','ORG00000201',1,'2014-07-24 00:00:00.000','2015-06-30 00:00:00.000','0021158',NULL,0,'PER00404665','2014-07-24 16:14:31.000','PER00404665','2014-07-24 00:00:00.000',2015)

,(3238067,'PER00985001','ORG00000007',1,'2014-07-26 00:00:00.000','2015-06-30 00:00:00.000','0021294',NULL,0,'PER00725095','2014-07-26 09:32:30.000','PER00725095','2014-07-26 00:00:00.000',2015)

,(3251596,'PER01336850','ORG00000007',1,'2014-09-02 00:00:00.000','2015-06-30 00:00:00.000','0026641',NULL,0,'PER01337808','2014-09-02 20:21:19.000','PER01337808','2014-09-03 00:00:00.000',2015)

,(2765587,'PER00530294','ORG00000110',3,'2011-07-01 00:00:00.000','2015-06-30 00:00:00.000','Legacy',NULL,0,'PER00052530','2011-11-05 00:35:47.000','PER00052530','2011-11-05 00:00:00.000',2015)

,(2915263,'PER00544985','ORG00000110',3,'2012-07-01 00:00:00.000','2016-06-30 00:00:00.000','Legacy',NULL,0,'PER00438479','2012-09-20 14:40:48.000','PER00438479','2012-09-20 00:00:00.000',2016)

,(3023841,'PER00639224','ORG00000007',3,'2013-07-01 00:00:00.000','2017-06-30 00:00:00.000','Legacy',NULL,0,'PER00725095','2013-06-22 14:30:14.000','PER00725095','2013-06-22 00:00:00.000',2017)

,(3182242,'PER00215030','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3182245,'PER00388729','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3182259,'PER01345955','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3182260,'PER01409723','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3186103,'PER00136419','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009874',NULL,0,'PER00390108','2014-06-07 12:31:45.000','PER00390108','2014-06-07 00:00:00.000',2015)

,(3186104,'PER01191035','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009874',NULL,0,'PER00390108','2014-06-07 12:31:45.000','PER00390108','2014-06-07 00:00:00.000',2015)

,(3193660,'PER01347641','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0012417',NULL,0,'PER00725095','2014-06-16 22:12:29.000','PER00725095','2014-06-17 00:00:00.000',2015)

,(3193674,'PER01384336','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0012417',NULL,0,'PER00725095','2014-06-16 22:12:29.000','PER00725095','2014-06-17 00:00:00.000',2015)

,(3193677,'PER01411486','ORG00000007',4,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0012417',NULL,0,'PER00725095','2014-06-16 22:12:29.000','PER00725095','2014-06-17 00:00:00.000',2015)

,(3202233,'PER00390287','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202234,'PER00856488','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202247,'PER00390002','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202248,'PER00398243','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202383,'PER01215381','ORG00000380',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014568',NULL,0,'PER01085259','2014-06-24 10:09:09.000','PER01085259','2014-06-24 00:00:00.000',2015)

,(3202384,'PER00501218','ORG00000380',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014568',NULL,0,'PER01085259','2014-06-24 10:09:09.000','PER01085259','2014-06-24 00:00:00.000',2015)

,(3205073,'PER00386833','ORG00004619',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015112',NULL,0,'PER01084657','2014-06-25 13:54:02.000','PER01084657','2014-06-25 00:00:00.000',2015)

,(3205074,'PER00399881','ORG00004619',1,'2014-07-01 00:00:00.000','2015-03-25 00:00:00.000','0015112','ORG00000213',1,'PER01084657','2014-06-25 13:54:02.000','PER00470923','2014-06-25 00:00:00.000',2015)

,(3205691,'PER00823500','ORG00000198',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3205692,'PER00299031','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3205709,'PER01192234','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3205710,'PER01211180','ORG00000198',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3211357,'PER01100785','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211358,'PER01262211','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211372,'PER00719476','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211375,'PER00818823','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211389,'PER00611322','ORG00000082',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211390,'PER00611323','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211407,'PER01262328','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211408,'PER01271705','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211740,'PER01265451','ORG00000007',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016527',NULL,0,'PER00725095','2014-06-29 15:52:32.000','PER00725095','2014-06-29 00:00:00.000',2015)

,(3211743,'PER00901921','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016527',NULL,0,'PER00725095','2014-06-29 15:52:32.000','PER00725095','2014-06-29 00:00:00.000',2015)

,(3211775,'PER00752132','ORG00000198',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016555',NULL,0,'PER01336186','2014-06-29 17:29:10.000','PER01336186','2014-06-29 00:00:00.000',2015)

,(3211776,'PER00753075','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016555',NULL,0,'PER01336186','2014-06-29 17:29:10.000','PER01336186','2014-06-29 00:00:00.000',2015)

,(3213330,'PER00147307','ORG00004619',1,'2014-06-30 00:00:00.000','2015-06-30 00:00:00.000',NULL,NULL,0,'PER00147307','2014-06-30 00:00:00.000',NULL,'2014-06-06 00:00:00.000',2015)

,(3234603,'PER00928222','ORG00000380',1,'2014-07-18 00:00:00.000','2015-06-30 00:00:00.000','0020446',NULL,0,'PER01085259','2014-07-18 16:25:31.000','PER01085259','2014-07-19 00:00:00.000',2015)

,(3234604,'PER01202400','ORG00000380',2,'2014-07-18 00:00:00.000','2015-06-30 00:00:00.000','0020446',NULL,0,'PER01085259','2014-07-18 16:25:31.000','PER01085259','2014-07-19 00:00:00.000',2015)

,(2915186,'PER01269548','ORG00000110',3,'2012-07-01 00:00:00.000','2016-06-30 00:00:00.000','Legacy',NULL,0,'PER00438479','2012-09-20 13:40:29.000','PER00438479','2012-09-20 00:00:00.000',2016)

,(3023850,'PER00880404','ORG00000007',3,'2013-07-01 00:00:00.000','2017-06-30 00:00:00.000','Legacy',NULL,0,'PER00725095','2013-06-22 14:30:15.000','PER00725095','2013-06-22 00:00:00.000',2017)

,(3097269,'PER00037227','ORG00000198',3,'2013-07-01 00:00:00.000','2017-06-30 00:00:00.000','Legacy',NULL,0,'PER00087235','2013-10-23 13:35:09.000','PER00087235','2013-10-04 00:00:00.000',2017)

,(3111375,'PER00351340','ORG00000198',3,'2013-07-01 00:00:00.000','2017-06-30 00:00:00.000','Legacy',NULL,0,'PER00294981','2013-11-26 20:42:33.000','PER00294981','2013-11-26 00:00:00.000',2017)

,(3182235,'PER01275350','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3182237,'PER00401935','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3182252,'PER00393342','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3182254,'PER01191033','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3193665,'PER00880401','ORG00000007',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0012417',NULL,0,'PER00725095','2014-06-16 22:12:29.000','PER00725095','2014-06-17 00:00:00.000',2015)

,(3193667,'PER00933394','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0012417',NULL,0,'PER00725095','2014-06-16 22:12:29.000','PER00725095','2014-06-17 00:00:00.000',2015)

,(3202240,'PER01262429','ORG00000007',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202242,'PER01280875','ORG00000007',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202255,'PER01202934','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202257,'PER01265452','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202259,'PER01323687','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3205080,'PER00034123','ORG00004619',1,'2014-06-25 00:00:00.000','2015-06-30 00:00:00.000','0014744',NULL,0,'PER00474964','2014-06-25 00:00:00.000',NULL,'2014-06-24 00:00:00.000',2015)

,(3205082,'PER00334157','ORG00004619',1,'2014-06-25 00:00:00.000','2015-06-30 00:00:00.000','0014744',NULL,0,'PER00474964','2014-06-25 00:00:00.000',NULL,'2014-06-24 00:00:00.000',2015)

,(3205114,'PER01269327','ORG00004619',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015141',NULL,0,'PER01084657','2014-06-25 14:06:21.000','PER01084657','2014-06-25 00:00:00.000',2015)

,(3205699,'PER01020943','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3205701,'PER01126338','ORG00000198',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3205716,'PER01349882','ORG00000198',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3211364,'PER01100779','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211366,'PER01178613','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211381,'PER01271706','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211383,'PER00078718','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211398,'PER00991339','ORG00000082',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211400,'PER01023885','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211415,'PER00611332','ORG00000082',3,'2014-07-01 00:00:00.000','2018-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:01.000','PER00398870','2014-06-29 00:00:00.000',2018)

,(3211417,'PER01412649','ORG00000082',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:01.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211749,'PER01350108','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016527',NULL,0,'PER00725095','2014-06-29 15:52:32.000','PER00725095','2014-06-29 00:00:00.000',2015)

,(3211751,'PER01220089','ORG00000007',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016527',NULL,0,'PER00725095','2014-06-29 15:52:32.000','PER00725095','2014-06-29 00:00:00.000',2015)

,(3213389,'PER01271204','ORG00004619',1,'2014-06-30 00:00:00.000','2015-06-30 00:00:00.000',NULL,NULL,0,'PER01271204','2014-06-30 00:00:00.000',NULL,'2014-06-04 00:00:00.000',2015)

,(3217099,'PER00818059','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0017672',NULL,0,'PER00725095','2014-07-01 00:24:18.000','PER00725095','2014-07-01 00:00:00.000',2015)

,(3228914,'PER00975212','ORG00000002',1,'2014-07-12 00:00:00.000','2015-06-30 00:00:00.000','0019685',NULL,0,'PER00390108','2014-07-12 12:04:58.000','PER00390108','2014-07-12 00:00:00.000',2015)

,(3234594,'PER01085259','ORG00000380',2,'2014-07-18 00:00:00.000','2015-06-30 00:00:00.000','0020446',NULL,0,'PER01085259','2014-07-18 16:25:30.000','PER01085259','2014-07-19 00:00:00.000',2015)

,(3234596,'PER01229891','ORG00000380',1,'2014-07-18 00:00:00.000','2015-06-30 00:00:00.000','0020446',NULL,0,'PER01085259','2014-07-18 16:25:30.000','PER01085259','2014-07-19 00:00:00.000',2015)

,(3245758,'PER00062290','ORG00000082',1,'2014-08-14 00:00:00.000','2015-04-13 00:00:00.000','0023245','ORG00001461',1,'PER00398870','2014-08-14 12:18:03.000','PER01179666','2014-08-14 00:00:00.000',2015)

,(3257958,'PER01288742','ORG00000198',1,'2014-09-16 00:00:00.000','2015-06-30 00:00:00.000','0028799',NULL,0,'PER01336186','2014-09-16 20:21:28.000','PER01336186','2014-09-16 00:00:00.000',2015)

,(3257960,'PER01211229','ORG00000198',2,'2014-09-16 00:00:00.000','2015-06-30 00:00:00.000','0028799',NULL,0,'PER01336186','2014-09-16 20:21:28.000','PER01336186','2014-09-16 00:00:00.000',2015)

,(2915187,'PER01271463','ORG00000110',3,'2012-07-01 00:00:00.000','2016-06-30 00:00:00.000','Legacy',NULL,0,'PER00438479','2012-09-20 13:40:29.000','PER00438479','2012-09-20 00:00:00.000',2016)

,(2920667,'PER01276867','ORG00000110',3,'2012-07-01 00:00:00.000','2016-06-30 00:00:00.000','Legacy',NULL,0,'PER00438479','2012-09-28 16:01:51.000','PER00438479','2012-09-28 00:00:00.000',2016)

,(3058345,'PER00061023','ORG00000110',3,'2013-07-01 00:00:00.000','2017-06-30 00:00:00.000','Legacy',NULL,0,'PER00438479','2013-07-28 20:12:58.000','PER00438479','2013-07-28 00:00:00.000',2017)

,(3097268,'PER00059260','ORG00000198',3,'2013-07-01 00:00:00.000','2017-06-30 00:00:00.000','Legacy',NULL,0,'PER00087235','2013-10-23 13:35:02.000','PER00087235','2013-10-04 00:00:00.000',2017)

,(3111376,'PER00304810','ORG00000198',3,'2013-07-01 00:00:00.000','2017-06-30 00:00:00.000','Legacy',NULL,0,'PER00294981','2013-11-26 20:42:33.000','PER00294981','2013-11-26 00:00:00.000',2017)

,(3182236,'PER00486289','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3182251,'PER00390108','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3182253,'PER01186285','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3193666,'PER01393650','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0012417',NULL,0,'PER00725095','2014-06-16 22:12:29.000','PER00725095','2014-06-17 00:00:00.000',2015)

,(3193668,'PER01264108','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0012417',NULL,0,'PER00725095','2014-06-16 22:12:29.000','PER00725095','2014-06-17 00:00:00.000',2015)

,(3200886,'PER00481840','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014184',NULL,0,'PER00481840','2014-06-23 10:26:27.000','PER00481840','2014-06-23 00:00:00.000',2015)

,(3202239,'PER01120784','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202241,'PER01262430','ORG00000007',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202256,'PER01208579','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202258,'PER01265453','ORG00000007',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3205113,'PER01271202','ORG00004619',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015141',NULL,0,'PER01084657','2014-06-25 14:06:21.000','PER01084657','2014-06-25 00:00:00.000',2015)

,(3205698,'PER00990813','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3205700,'PER01113521','ORG00000198',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3205715,'PER01336188','ORG00000198',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3205717,'PER01413067','ORG00000198',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3210946,'PER01413531','ORG00000198',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016369',NULL,0,'PER01336186','2014-06-29 08:48:12.000','PER01336186','2014-06-29 00:00:00.000',2015)

,(3211365,'PER01100784','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211367,'PER00278857','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211380,'PER01134162','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211382,'PER01279234','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211384,'PER00221103','ORG00000082',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211397,'PER00917371','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211399,'PER00991340','ORG00000082',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211414,'PER01412646','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:01.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211416,'PER01271704','ORG00000082',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:01.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211748,'PER00049758','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016527',NULL,0,'PER00725095','2014-06-29 15:52:32.000','PER00725095','2014-06-29 00:00:00.000',2015)

,(3211750,'PER01220087','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016527',NULL,0,'PER00725095','2014-06-29 15:52:32.000','PER00725095','2014-06-29 00:00:00.000',2015)

,(3228913,'PER00975213','ORG00000002',2,'2014-07-12 00:00:00.000','2015-06-30 00:00:00.000','0019685',NULL,0,'PER00390108','2014-07-12 12:04:58.000','PER00390108','2014-07-12 00:00:00.000',2015)

,(3229583,'PER01211236','ORG00000198',1,'2014-07-13 00:00:00.000','2015-06-30 00:00:00.000','0019767',NULL,0,'PER01336186','2014-07-13 15:12:08.000','PER01336186','2014-07-13 00:00:00.000',2015)

,(3234595,'PER00054959','ORG00000380',1,'2014-07-18 00:00:00.000','2015-06-30 00:00:00.000','0020446',NULL,0,'PER01085259','2014-07-18 16:25:30.000','PER01085259','2014-07-19 00:00:00.000',2015)

,(3234597,'PER01182376','ORG00000380',2,'2014-07-18 00:00:00.000','2015-06-30 00:00:00.000','0020446',NULL,0,'PER01085259','2014-07-18 16:25:30.000','PER01085259','2014-07-19 00:00:00.000',2015)

,(3257959,'PER01020985','ORG00000198',1,'2014-09-16 00:00:00.000','2015-06-30 00:00:00.000','0028799',NULL,0,'PER01336186','2014-09-16 20:21:28.000','PER01336186','2014-09-16 00:00:00.000',2015)

,(3265964,'PER01211185','ORG00000198',2,'2014-09-29 00:00:00.000','2015-06-30 00:00:00.000','0030019',NULL,0,'PER01336186','2014-09-29 19:55:27.000','PER01336186','2014-09-29 00:00:00.000',2015)

,(3265966,'PER01192233','ORG00000198',1,'2014-09-29 00:00:00.000','2015-06-30 00:00:00.000','0030019',NULL,0,'PER01336186','2014-09-29 19:55:27.000','PER01336186','2014-09-29 00:00:00.000',2015)

,(2918456,'PER00163729','ORG00000198',3,'2012-07-01 00:00:00.000','2016-06-30 00:00:00.000','Legacy',NULL,0,'PER00294981','2012-09-25 18:57:42.000','PER00294981','2012-09-25 00:00:00.000',2016)

,(3018764,'PER00088634','ORG00000198',3,'2013-07-01 00:00:00.000','2017-06-30 00:00:00.000','Legacy',NULL,0,'PER00294981','2013-06-17 12:26:58.000','PER00294981','2013-06-17 00:00:00.000',2017)

,(3182243,'PER00227411','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3182244,'PER00387068','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3182261,'PER01409726','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3191503,'PER01397894','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0011871',NULL,0,'PER00390108','2014-06-14 14:44:58.000','PER00390108','2014-06-14 00:00:00.000',2015)

,(3191504,'PER00742420','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0011871',NULL,0,'PER00390108','2014-06-14 14:44:58.000','PER00390108','2014-06-14 00:00:00.000',2015)

,(3193675,'PER01393651','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0012417',NULL,0,'PER00725095','2014-06-16 22:12:29.000','PER00725095','2014-06-17 00:00:00.000',2015)

,(3193676,'PER01411485','ORG00000007',4,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0012417',NULL,0,'PER00725095','2014-06-16 22:12:29.000','PER00725095','2014-06-17 00:00:00.000',2015)

,(3202231,'PER00391803','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202232,'PER01384338','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202249,'PER00487279','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202250,'PER00847707','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202382,'PER00389939','ORG00000380',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014568',NULL,0,'PER01085259','2014-06-24 10:09:09.000','PER01085259','2014-06-24 00:00:00.000',2015)

,(3205072,'PER01271200','ORG00004619',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015112',NULL,0,'PER01084657','2014-06-25 13:54:02.000','PER01084657','2014-06-25 00:00:00.000',2015)

,(3205075,'PER00818801','ORG00004619',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015112',NULL,0,'PER01084657','2014-06-25 13:54:02.000','PER01084657','2014-06-25 00:00:00.000',2015)

,(3205690,'PER00527274','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3205693,'PER00361035','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3205707,'PER01021011','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3205708,'PER01192229','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3211355,'PER00285935','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211356,'PER01023889','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211359,'PER00818828','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211373,'PER00719479','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211374,'PER00817213','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211391,'PER00611326','ORG00000082',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211392,'PER00611331','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211405,'PER01100778','ORG00000082',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211406,'PER01219941','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211409,'PER01279235','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211741,'PER00592897','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016527',NULL,0,'PER00725095','2014-06-29 15:52:32.000','PER00725095','2014-06-29 00:00:00.000',2015)

,(3211742,'PER01337945','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016527',NULL,0,'PER00725095','2014-06-29 15:52:32.000','PER00725095','2014-06-29 00:00:00.000',2015)

,(3211773,'PER00522497','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016555',NULL,0,'PER01336186','2014-06-29 17:29:10.000','PER01336186','2014-06-29 00:00:00.000',2015)

,(3211774,'PER01286038','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016555',NULL,0,'PER01336186','2014-06-29 17:29:10.000','PER01336186','2014-06-29 00:00:00.000',2015)

,(3227167,'PER00751552','ORG00000110',3,'2014-07-09 00:00:00.000','2018-06-30 00:00:00.000','0019305',NULL,0,'PER00438479','2014-07-09 21:19:48.000','PER00438479','2014-07-09 00:00:00.000',2018)

,(3227168,'PER00036337','ORG00000110',1,'2014-07-09 00:00:00.000','2015-06-30 00:00:00.000','0019305',NULL,0,'PER00438479','2014-07-09 21:19:48.000','PER00438479','2014-07-09 00:00:00.000',2015)

,(3234602,'PER00387953','ORG00000380',1,'2014-07-18 00:00:00.000','2015-06-30 00:00:00.000','0020446',NULL,0,'PER01085259','2014-07-18 16:25:30.000','PER01085259','2014-07-19 00:00:00.000',2015)

,(3234605,'PER01256020','ORG00000380',1,'2014-07-18 00:00:00.000','2015-06-30 00:00:00.000','0020446',NULL,0,'PER01085259','2014-07-18 16:25:31.000','PER01085259','2014-07-19 00:00:00.000',2015)

,(3234606,'PER01341423','ORG00000380',2,'2014-07-18 00:00:00.000','2015-06-30 00:00:00.000','0020446',NULL,0,'PER01085259','2014-07-18 16:25:31.000','PER01085259','2014-07-19 00:00:00.000',2015)

,(2768530,'PER00755781','ORG00000110',3,'2011-07-01 00:00:00.000','2015-06-30 00:00:00.000','Legacy',NULL,0,'PER00052530','2011-11-09 14:31:00.000','PER00052530','2011-11-09 00:00:00.000',2015)

,(2872539,'PER00725093','ORG00000007',3,'2012-07-01 00:00:00.000','2016-06-30 00:00:00.000','Legacy',NULL,0,'PER00206662','2012-06-30 14:24:27.000','PER00206662','2012-06-30 00:00:00.000',2016)

,(2915191,'PER00146544','ORG00000110',3,'2012-07-01 00:00:00.000','2016-06-30 00:00:00.000','Legacy',NULL,0,'PER00438479','2012-09-20 14:03:13.000','PER00438479','2012-09-20 00:00:00.000',2016)

,(3079182,'PER00443020','ORG00000198',3,'2013-07-01 00:00:00.000','2017-06-30 00:00:00.000','Legacy',NULL,0,'PER00294981','2013-09-22 19:12:01.000','PER00294981','2013-09-22 00:00:00.000',2017)

,(3182255,'PER01263116','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3182257,'PER01271452','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3186101,'PER00991276','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009874',NULL,0,'PER00390108','2014-06-07 12:31:45.000','PER00390108','2014-06-07 00:00:00.000',2015)

,(3193662,'PER01268838','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0012417',NULL,0,'PER00725095','2014-06-16 22:12:29.000','PER00725095','2014-06-17 00:00:00.000',2015)

,(3193664,'PER00880402','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0012417',NULL,0,'PER00725095','2014-06-16 22:12:29.000','PER00725095','2014-06-17 00:00:00.000',2015)

,(3200941,'PER00351349','ORG00000198',3,'2014-07-01 00:00:00.000','2018-06-30 00:00:00.000','0014190',NULL,0,'PER00636310','2014-06-23 10:41:54.000','PER00636310','2014-06-23 00:00:00.000',2018)

,(3202243,'PER01336849','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202245,'PER00086528','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202252,'PER01002047','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202254,'PER01178672','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3205694,'PER00525749','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3205696,'PER00589044','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3210944,'PER01211271','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016369',NULL,0,'PER01336186','2014-06-29 08:48:12.000','PER01336186','2014-06-29 00:00:00.000',2015)

,(3211369,'PER00398870','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211371,'PER00532128','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211376,'PER00915707','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211378,'PER01083405','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211401,'PER01083401','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211403,'PER01083408','ORG00000082',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211410,'PER01334473','ORG00000082',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211412,'PER01348191','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211737,'PER00385813','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016527',NULL,0,'PER00725095','2014-06-29 15:52:32.000','PER00725095','2014-06-29 00:00:00.000',2015)

,(3211739,'PER01178668','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016527',NULL,0,'PER00725095','2014-06-29 15:52:32.000','PER00725095','2014-06-29 00:00:00.000',2015)

,(3211744,'PER01336852','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016527',NULL,0,'PER00725095','2014-06-29 15:52:32.000','PER00725095','2014-06-29 00:00:00.000',2015)

,(3211746,'PER01337808','ORG00000007',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016527',NULL,0,'PER00725095','2014-06-29 15:52:32.000','PER00725095','2014-06-29 00:00:00.000',2015)

,(3228258,'PER00667773','ORG00000198',1,'2014-07-11 00:00:00.000','2015-06-30 00:00:00.000','0019550',NULL,0,'PER01336186','2014-07-11 08:39:28.000','PER01336186','2014-07-11 00:00:00.000',2015)

,(3234599,'PER00405477','ORG00000380',1,'2014-07-18 00:00:00.000','2015-06-30 00:00:00.000','0020446',NULL,0,'PER01085259','2014-07-18 16:25:30.000','PER01085259','2014-07-19 00:00:00.000',2015)

,(3234601,'PER01264441','ORG00000380',1,'2014-07-18 00:00:00.000','2015-06-30 00:00:00.000','0020446',NULL,0,'PER01085259','2014-07-18 16:25:30.000','PER01085259','2014-07-19 00:00:00.000',2015)

,(3234608,'PER01264448','ORG00000380',2,'2014-07-18 00:00:00.000','2015-06-30 00:00:00.000','0020446',NULL,0,'PER01085259','2014-07-18 16:25:31.000','PER01085259','2014-07-19 00:00:00.000',2015)

,(3234610,'PER00404696','ORG00000380',1,'2014-07-18 00:00:00.000','2015-06-30 00:00:00.000','0020446',NULL,0,'PER01085259','2014-07-18 16:25:31.000','PER01085259','2014-07-19 00:00:00.000',2015)

,(3235378,'PER01417472','ORG00000007',4,'2014-07-20 00:00:00.000','2015-06-30 00:00:00.000','0020614',NULL,0,'PER00725095','2014-07-20 17:10:02.000','PER00725095','2014-07-21 00:00:00.000',2015)

,(3237641,'PER01265222','ORG00000201',1,'2014-07-24 00:00:00.000','2015-02-05 00:00:00.000','0021158','ORG00001458',1,'PER00404665','2014-07-24 16:14:31.000','PER00938933','2014-07-24 00:00:00.000',2015)

,(3237643,'PER01099711','ORG00000201',1,'2014-07-24 00:00:00.000','2015-06-30 00:00:00.000','0021158',NULL,0,'PER00404665','2014-07-24 16:14:31.000','PER00404665','2014-07-24 00:00:00.000',2015)

,(3237684,'PER00510920','ORG00000007',1,'2014-07-24 00:00:00.000','2015-06-30 00:00:00.000','0021178',NULL,0,'PER00725095','2014-07-24 21:05:26.000','PER00725095','2014-07-25 00:00:00.000',2015)

,(3238350,'PER00951623','ORG00000380',1,'2014-07-27 00:00:00.000','2015-06-30 00:00:00.000','0021345',NULL,0,'PER01085259','2014-07-27 09:33:10.000','PER01085259','2014-07-27 00:00:00.000',2015)

,(2887323,'PER00495790','ORG00000380',3,'2012-07-01 00:00:00.000','2016-06-30 00:00:00.000','Legacy',NULL,0,'PER01085259','2012-07-15 16:32:19.000','PER01085259','2012-07-15 00:00:00.000',2016)

,(2896104,'PER00425848','ORG00000007',3,'2012-07-01 00:00:00.000','2016-06-30 00:00:00.000','Legacy',NULL,0,'PER00206662','2012-07-31 13:51:19.000','PER00206662','2012-07-31 00:00:00.000',2016)

,(3060674,'PER00079628','ORG00000110',3,'2013-07-01 00:00:00.000','2017-06-30 00:00:00.000','Legacy',NULL,0,'PER00438479','2013-08-01 21:30:40.000','PER00438479','2013-08-01 00:00:00.000',2017)

,(3182238,'PER00473231','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3182249,'PER00053501','ORG00000002',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3182256,'PER01268099','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0009006',NULL,0,'PER00390108','2014-06-02 10:43:28.000','PER00390108','2014-06-02 00:00:00.000',2015)

,(3193663,'PER01262433','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0012417',NULL,0,'PER00725095','2014-06-16 22:12:29.000','PER00725095','2014-06-17 00:00:00.000',2015)

,(3193670,'PER00978859','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0012417',NULL,0,'PER00725095','2014-06-16 22:12:29.000','PER00725095','2014-06-17 00:00:00.000',2015)

,(3202237,'PER01014981','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202244,'PER01337807','ORG00000007',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202251,'PER00908405','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3202262,'PER01412579','ORG00000007',4,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0014518',NULL,0,'PER00725095','2014-06-23 23:42:56.000','PER00725095','2014-06-24 00:00:00.000',2015)

,(3205077,'PER00392472','ORG00004619',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015112',NULL,0,'PER01084657','2014-06-25 13:54:02.000','PER01084657','2014-06-25 00:00:00.000',2015)

,(3205695,'PER01020994','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3205702,'PER01192235','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3205706,'PER01020964','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3205713,'PER01275974','ORG00000198',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0015285',NULL,0,'PER01336186','2014-06-25 20:19:37.000','PER01336186','2014-06-25 00:00:00.000',2015)

,(3210943,'PER01119809','ORG00000198',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016369',NULL,0,'PER01336186','2014-06-29 08:48:12.000','PER01336186','2014-06-29 00:00:00.000',2015)

,(3211354,'PER00028618','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211361,'PER01000109','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211368,'PER00337213','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211379,'PER01100781','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:56:59.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211386,'PER00336202','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211393,'PER00719482','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211404,'PER01100774','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211411,'PER01348190','ORG00000082',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:00.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211418,'PER01412650','ORG00000082',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016462',NULL,0,'PER00398870','2014-06-29 12:57:01.000','PER00398870','2014-06-29 00:00:00.000',2015)

,(3211518,'PER01342235','ORG00000002',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016482',NULL,0,'PER00390108','2014-06-29 13:59:09.000','PER00390108','2014-06-29 00:00:00.000',2015)

,(3211747,'PER01178671','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0016527',NULL,0,'PER00725095','2014-06-29 15:52:32.000','PER00725095','2014-06-29 00:00:00.000',2015)

,(3216223,'PER00079696','ORG00000110',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0017578',NULL,0,'PER00438479','2014-06-30 21:09:39.000','PER00438479','2014-06-30 00:00:00.000',2015)

,(3217102,'PER01354698','ORG00000007',2,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0017672',NULL,0,'PER00725095','2014-07-01 00:24:18.000','PER00725095','2014-07-01 00:00:00.000',2015)

,(3218581,'PER00071792','ORG00000007',1,'2014-07-01 00:00:00.000','2015-06-30 00:00:00.000','0017980',NULL,0,'PER00725095','2014-07-01 17:22:17.000','PER00725095','2014-07-02 00:00:00.000',2015)

,(3221889,'PER00018768','ORG00000007',1,'2014-07-05 00:00:00.000','2015-06-30 00:00:00.000','0018554',NULL,0,'PER00398243','2014-07-05 09:37:48.000','PER00398243','2014-07-05 00:00:00.000',2015)

,(3234593,'PER00726254','ORG00000380',1,'2014-07-18 00:00:00.000','2015-06-30 00:00:00.000','0020446',NULL,0,'PER01085259','2014-07-18 16:25:30.000','PER01085259','2014-07-19 00:00:00.000',2015)

,(3234600,'PER00800081','ORG00000380',2,'2014-07-18 00:00:00.000','2015-06-30 00:00:00.000','0020446',NULL,0,'PER01085259','2014-07-18 16:25:30.000','PER01085259','2014-07-19 00:00:00.000',2015)

,(3234607,'PER01182378','ORG00000380',2,'2014-07-18 00:00:00.000','2015-06-30 00:00:00.000','0020446',NULL,0,'PER01085259','2014-07-18 16:25:31.000','PER01085259','2014-07-19 00:00:00.000',2015)

,(3235379,'PER00756677','ORG00000110',3,'2014-07-20 00:00:00.000','2018-06-30 00:00:00.000','0020617',NULL,0,'PER00438479','2014-07-20 17:22:45.000','PER00438479','2014-07-20 00:00:00.000',2018)

,(3238351,'PER01264446','ORG00000380',2,'2014-07-27 00:00:00.000','2015-06-30 00:00:00.000','0021345',NULL,0,'PER01085259','2014-07-27 09:33:10.000','PER01085259','2014-07-27 00:00:00.000',2015)

,(3245603,'PER00912719','ORG00000380',1,'2014-08-13 00:00:00.000','2015-06-30 00:00:00.000','0023167',NULL,0,'PER01085259','2014-08-13 17:37:13.000','PER01085259','2014-08-14 00:00:00.000',2015)

,(3256483,'PER00667750','ORG00000198',1,'2014-09-14 00:00:00.000','2015-06-30 00:00:00.000','0028545',NULL,0,'PER01336186','2014-09-14 19:02:14.000','PER01336186','2014-09-14 00:00:00.000',2015)

,(3257955,'PER01211228','ORG00000198',1,'2014-09-16 00:00:00.000','2015-06-30 00:00:00.000','0028799',NULL,0,'PER01336186','2014-09-16 20:21:28.000','PER01336186','2014-09-16 00:00:00.000',2015)

,(3265961,'PER01172650','ORG00000198',1,'2014-09-29 00:00:00.000','2015-06-30 00:00:00.000','0030019',NULL,0,'PER01336186','2014-09-29 19:55:26.000','PER01336186','2014-09-29 00:00:00.000',2015)

,(3265968,'PER00163950','ORG00000198',1,'2014-09-29 00:00:00.000','2015-06-30 00:00:00.000','0030019',NULL,0,'PER01336186','2014-09-29 19:55:27.000','PER01336186','2014-09-29 00:00:00.000',2015)

,(3273706,'PER01280879','ORG00000201',1,'2014-10-10 00:00:00.000','2015-06-30 00:00:00.000','0030959',NULL,0,'PER00404665','2014-10-10 21:17:34.000','PER00404665','2014-10-10 00:00:00.000',2015)

,(3273717,'PER01091933','ORG00000201',1,'2014-10-10 00:00:00.000','2015-06-30 00:00:00.000','0030959',NULL,0,'PER00404665','2014-10-10 21:17:36.000','PER00404665','2014-10-10 00:00:00.000',2015)

,(3273724,'PER01433760','ORG00000201',2,'2014-10-10 00:00:00.000','2015-06-30 00:00:00.000','0030959',NULL,0,'PER00404665','2014-10-10 21:17:37.000','PER00404665','2014-10-10 00:00:00.000',2015)

,(3283452,'PER00294062','ORG00000380',1,'2014-10-30 00:00:00.000','2015-06-30 00:00:00.000','0032860',NULL,0,'PER01085259','2014-10-30 18:38:58.000','PER01085259','2014-10-31 00:00:00.000',2015)

,(3285906,'PER00065896','ORG00000198',3,'2014-11-05 00:00:00.000','2018-06-30 00:00:00.000','0033249',NULL,0,'PER00087235','2014-11-05 11:52:53.000',NULL,'2014-11-05 00:00:00.000',2018)

,(3288875,'PER01294725','ORG00000198',1,'2014-11-09 00:00:00.000','2015-06-30 00:00:00.000','0033546',NULL,0,'PER01336186','2014-11-09 15:04:34.000','PER01336186','2014-11-09 00:00:00.000',2015)

,(3299953,'PER00077787','ORG00000198',3,'2014-11-25 00:00:00.000','2018-06-30 00:00:00.000','0034862',NULL,0,'PER01336186','2014-11-25 12:46:23.000','PER01336186','2014-11-25 00:00:00.000',2018)

,(3376822,'PER01409723','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:49.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3376833,'PER01267404','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:51.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3376840,'PER00742420','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:53.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3376847,'PER01343886','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:55.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3380934,'PER01355442','ORG00000380',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0045470',NULL,0,'PER01085259','2015-06-06 05:45:03.000','PER01085259','2015-06-06 00:00:00.000',2016)

,(3392073,'PER00959986','ORG00000380',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0048246',NULL,0,'PER01341423','2015-06-17 14:55:42.000','PER01341423','2015-06-17 00:00:00.000',2016)

,(3392541,'PER01256021','ORG00000380',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0048313',NULL,0,'PER01341423','2015-06-17 18:43:20.000','PER01341423','2015-06-18 00:00:00.000',2016)

,(3392548,'PER01129760','ORG00000380',4,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0048313',NULL,0,'PER01341423','2015-06-17 18:43:21.000','PER01341423','2015-06-18 00:00:00.000',2016)

,(3396628,'PER00991276','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049272',NULL,0,'PER00390108','2015-06-21 13:56:08.000','PER00390108','2015-06-21 00:00:00.000',2016)

,(3398325,'PER01020941','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:28.000','PER01336186','2015-06-22 00:00:00.000',2016)

,(3398332,'PER00527274','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:29.000','PER01336186','2015-06-22 00:00:00.000',2016)

,(3398339,'PER00525749','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:31.000','PER01336186','2015-06-22 00:00:00.000',2016)

,(3401222,'PER01220087','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:18.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401233,'PER00398243','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:21.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401240,'PER01494303','ORG00000007',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:23.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401247,'PER00507276','ORG00000007',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:25.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3402912,'PER01413067','ORG00000198',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050662',NULL,0,'PER01336186','2015-06-25 18:52:57.000','PER01336186','2015-06-25 00:00:00.000',2016)

,(3406120,'PER01000110','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:36.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406127,'PER01412650','ORG00000082',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:37.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406138,'PER01083408','ORG00000082',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:40.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406145,'PER00221140','ORG00000082',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:42.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406152,'PER00611331','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:44.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406163,'PER01271705','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:48.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406813,'PER01113539','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:33.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406820,'PER01084568','ORG00000007',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:34.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406831,'PER00385555','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:37.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406838,'PER00390287','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:39.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406845,'PER01417472','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:41.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3237644,'PER00404665','ORG00000201',1,'2014-07-24 00:00:00.000','2015-06-30 00:00:00.000','0021158',NULL,0,'PER00404665','2014-07-24 16:14:31.000','PER00404665','2014-07-24 00:00:00.000',2015)

,(3237647,'PER01304940','ORG00000201',4,'2014-07-24 00:00:00.000','2015-06-30 00:00:00.000','0021158',NULL,0,'PER00404665','2014-07-24 16:14:31.000','PER00404665','2014-07-24 00:00:00.000',2015)

,(3244999,'PER00991772','ORG00000198',2,'2014-08-11 00:00:00.000','2015-06-30 00:00:00.000','0022905',NULL,0,'PER01336186','2014-08-11 17:27:49.000','PER01336186','2014-08-11 00:00:00.000',2015)

,(3265973,'PER00648096','ORG00000198',1,'2014-09-29 00:00:00.000','2015-06-30 00:00:00.000','0030019',NULL,0,'PER01336186','2014-09-29 19:55:28.000','PER01336186','2014-09-29 00:00:00.000',2015)

,(3273711,'PER00566478','ORG00000201',1,'2014-10-10 00:00:00.000','2015-06-30 00:00:00.000','0030959',NULL,0,'PER00404665','2014-10-10 21:17:35.000','PER00404665','2014-10-10 00:00:00.000',2015)

,(3273712,'PER01062102','ORG00000201',1,'2014-10-10 00:00:00.000','2015-06-30 00:00:00.000','0030959',NULL,0,'PER00404665','2014-10-10 21:17:35.000','PER00404665','2014-10-10 00:00:00.000',2015)

,(3279009,'PER01259468','ORG00000007',1,'2014-10-22 00:00:00.000','2015-06-30 00:00:00.000','0031988',NULL,0,'PER01337808','2014-10-22 19:46:23.000','PER01337808','2014-10-23 00:00:00.000',2015)

,(3283453,'PER00959986','ORG00000380',2,'2014-10-30 00:00:00.000','2015-06-30 00:00:00.000','0032860',NULL,0,'PER01085259','2014-10-30 18:38:58.000','PER01085259','2014-10-31 00:00:00.000',2015)

,(3283454,'PER01282102','ORG00000380',1,'2014-10-30 00:00:00.000','2015-06-30 00:00:00.000','0032860',NULL,0,'PER01085259','2014-10-30 18:38:58.000','PER01085259','2014-10-31 00:00:00.000',2015)

,(3291996,'PER01211261','ORG00000198',1,'2014-11-14 00:00:00.000','2015-06-30 00:00:00.000','0033970',NULL,0,'PER01336186','2014-11-14 18:07:02.000','PER01336186','2014-11-14 00:00:00.000',2015)

,(3297962,'PER01211239','ORG00000198',1,'2014-11-21 00:00:00.000','2015-06-30 00:00:00.000','0034530',NULL,0,'PER01336186','2014-11-21 08:45:34.000','PER01336186','2014-11-21 00:00:00.000',2015)

,(3305264,'PER01211209','ORG00000198',2,'2014-12-11 00:00:00.000','2015-06-30 00:00:00.000','0035856',NULL,0,'PER01336186','2014-12-11 09:58:20.000','PER01336186','2014-12-11 00:00:00.000',2015)

,(3354982,'PER01485405','ORG00000007',1,'2015-03-17 00:00:00.000','2015-06-30 00:00:00.000','0041352',NULL,0,'PER01337808','2015-03-17 22:53:46.000','PER01337808','2015-03-18 00:00:00.000',2015)

,(3354985,'PER01485406','ORG00000007',1,'2015-03-17 00:00:00.000','2015-06-30 00:00:00.000','0041352',NULL,0,'PER01337808','2015-03-17 22:53:47.000','PER01337808','2015-03-18 00:00:00.000',2015)

,(3365413,'PER01494304','ORG00000007',1,'2015-04-13 00:00:00.000','2015-06-30 00:00:00.000','0042470',NULL,0,'PER01337808','2015-04-13 23:05:17.000','PER01337808','2015-04-14 00:00:00.000',2015)

,(3376827,'PER01474851','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:50.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3376828,'PER00013240','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:50.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3376842,'PER01186285','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:54.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3376845,'PER01268099','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:54.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3380939,'PER01417329','ORG00000380',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0045470',NULL,0,'PER01085259','2015-06-06 05:45:03.000','PER01085259','2015-06-06 00:00:00.000',2016)

,(3380940,'PER01500766','ORG00000380',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0045470',NULL,0,'PER01085259','2015-06-06 05:45:04.000','PER01085259','2015-06-06 00:00:00.000',2016)

,(3398334,'PER00789896','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:30.000','PER01336186','2015-06-22 00:00:00.000',2016)

,(3398337,'PER01211238','ORG00000198',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:30.000','PER01336186','2015-06-22 00:00:00.000',2016)

,(3398338,'PER01413531','ORG00000198',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:31.000','PER01336186','2015-06-22 00:00:00.000',2016)

,(3401227,'PER01337808','ORG00000007',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:19.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401228,'PER00933394','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:19.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401242,'PER00916088','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:23.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401245,'PER00725095','ORG00000007',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:24.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401246,'PER00486934','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:25.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3406122,'PER01100778','ORG00000082',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:37.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406125,'PER01178613','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:37.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406126,'PER01334087','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:37.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406139,'PER01100781','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:40.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406140,'PER01219941','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:40.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406157,'PER00991339','ORG00000082',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:46.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406158,'PER01023885','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:46.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406825,'PER00243465','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:35.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406826,'PER01485405','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:35.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406843,'PER01384336','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:40.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3246935,'PER01334087','ORG00000082',4,'2014-08-18 00:00:00.000','2015-06-30 00:00:00.000','0023630',NULL,0,'PER00398870','2014-08-18 08:08:39.000','PER00398870','2014-08-18 00:00:00.000',2015)

,(3261316,'PER01018385','ORG00000198',1,'2014-09-21 00:00:00.000','2015-06-30 00:00:00.000','0029217',NULL,0,'PER01336186','2014-09-21 19:15:31.000','PER01336186','2014-09-21 00:00:00.000',2015)

,(3265960,'PER01211207','ORG00000198',1,'2014-09-29 00:00:00.000','2015-06-30 00:00:00.000','0030019',NULL,0,'PER01336186','2014-09-29 19:55:26.000','PER01336186','2014-09-29 00:00:00.000',2015)

,(3265962,'PER00789908','ORG00000198',1,'2014-09-29 00:00:00.000','2015-06-30 00:00:00.000','0030019',NULL,0,'PER01336186','2014-09-29 19:55:26.000','PER01336186','2014-09-29 00:00:00.000',2015)

,(3273705,'PER01351981','ORG00000201',2,'2014-10-10 00:00:00.000','2015-06-30 00:00:00.000','0030959',NULL,0,'PER00404665','2014-10-10 21:17:34.000','PER00404665','2014-10-10 00:00:00.000',2015)

,(3273707,'PER01280881','ORG00000201',2,'2014-10-10 00:00:00.000','2015-06-30 00:00:00.000','0030959',NULL,0,'PER00404665','2014-10-10 21:17:34.000','PER00404665','2014-10-10 00:00:00.000',2015)

,(3273709,'PER00915271','ORG00000201',2,'2014-10-10 00:00:00.000','2015-06-30 00:00:00.000','0030959',NULL,0,'PER00404665','2014-10-10 21:17:34.000','PER00404665','2014-10-10 00:00:00.000',2015)

,(3273714,'PER00651985','ORG00000201',1,'2014-10-10 00:00:00.000','2015-06-30 00:00:00.000','0030959',NULL,0,'PER00404665','2014-10-10 21:17:35.000','PER00404665','2014-10-10 00:00:00.000',2015)

,(3273716,'PER01351982','ORG00000201',2,'2014-10-10 00:00:00.000','2015-06-30 00:00:00.000','0030959',NULL,0,'PER00404665','2014-10-10 21:17:36.000','PER00404665','2014-10-10 00:00:00.000',2015)

,(3277619,'PER00811517','ORG00000110',3,'2014-10-20 00:00:00.000','2018-06-30 00:00:00.000','0031734',NULL,0,'PER00438479','2014-10-20 08:12:21.000','PER00438479','2014-10-20 00:00:00.000',2018)

,(3278017,'PER01208577','ORG00000007',1,'2014-10-20 00:00:00.000','2015-06-30 00:00:00.000','0031808',NULL,0,'PER01337808','2014-10-20 21:13:12.000','PER01337808','2014-10-21 00:00:00.000',2015)

,(3299952,'PER00569579','ORG00000198',3,'2014-11-25 00:00:00.000','2018-06-30 00:00:00.000','0034862',NULL,0,'PER01336186','2014-11-25 12:46:20.000','PER01336186','2014-11-25 00:00:00.000',2018)

,(3299954,'PER00722550','ORG00000198',3,'2014-11-25 00:00:00.000','2018-06-30 00:00:00.000','0034862',NULL,0,'PER01336186','2014-11-25 12:46:23.000','PER01336186','2014-11-25 00:00:00.000',2018)

,(3376823,'PER01275350','ORG00000002',1,'2015-07-01 00:00:00.000','2015-06-03 00:00:00.000','0044392','ORG00000539',1,'PER00390108','2015-06-01 11:45:50.000','PER00515967','2015-06-01 00:00:00.000',2015)

,(3376830,'PER00227411','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:51.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3376832,'PER00411411','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:51.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3380933,'PER01264448','ORG00000380',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0045470',NULL,0,'PER01085259','2015-06-06 05:45:03.000','PER01085259','2015-06-06 00:00:00.000',2016)

,(3380935,'PER00054959','ORG00000380',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0045470',NULL,0,'PER01085259','2015-06-06 05:45:03.000','PER01085259','2015-06-06 00:00:00.000',2016)

,(3392072,'PER01282102','ORG00000380',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0048246',NULL,0,'PER01341423','2015-06-17 14:55:42.000','PER01341423','2015-06-17 00:00:00.000',2016)

,(3392074,'PER00405477','ORG00000380',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0048246',NULL,0,'PER01341423','2015-06-17 14:55:42.000','PER01341423','2015-06-17 00:00:00.000',2016)

,(3392542,'PER00800081','ORG00000380',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0048313',NULL,0,'PER01341423','2015-06-17 18:43:20.000','PER01341423','2015-06-18 00:00:00.000',2016)

,(3401221,'PER01413595','ORG00000007',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:18.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401223,'PER01220089','ORG00000007',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:18.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401225,'PER00880401','ORG00000007',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:19.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401230,'PER01178672','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:20.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401232,'PER01262429','ORG00000007',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:20.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3402902,'PER00522443','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050662',NULL,0,'PER01336186','2015-06-25 18:52:54.000','PER01336186','2015-06-25 00:00:00.000',2016)

,(3402904,'PER00481840','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050662',NULL,0,'PER01336186','2015-06-25 18:52:55.000','PER01336186','2015-06-25 00:00:00.000',2016)

,(3406135,'PER00919727','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:39.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406137,'PER01083405','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:40.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406144,'PER00078718','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:41.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406146,'PER00278857','ORG00000082',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:42.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406169,'PER01504002','ORG00000082',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:51.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406814,'PER00901921','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:33.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406837,'PER00018768','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:38.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406839,'PER00531969','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:39.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406846,'PER01504094','ORG00000007',4,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:41.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3407716,'PER00079696','ORG00000110',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051845',NULL,0,'PER00438479','2015-06-29 14:08:14.000','PER00438479','2015-06-29 00:00:00.000',2016)

,(3412026,'PER00923423','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0052909',NULL,0,'PER01336186','2015-06-30 19:27:50.000','PER01336186','2015-06-30 00:00:00.000',2016)

,(3237645,'PER00647280','ORG00000201',2,'2014-07-24 00:00:00.000','2015-06-30 00:00:00.000','0021158',NULL,0,'PER00404665','2014-07-24 16:14:31.000','PER00404665','2014-07-24 00:00:00.000',2015)

,(3237646,'PER01201935','ORG00000201',2,'2014-07-24 00:00:00.000','2015-06-30 00:00:00.000','0021158',NULL,0,'PER00404665','2014-07-24 16:14:31.000','PER00404665','2014-07-24 00:00:00.000',2015)

,(3244998,'PER00569564','ORG00000198',1,'2014-08-11 00:00:00.000','2015-06-30 00:00:00.000','0022905',NULL,0,'PER01336186','2014-08-11 17:27:49.000','PER01336186','2014-08-11 00:00:00.000',2015)

,(3245602,'PER01355442','ORG00000380',4,'2014-08-13 00:00:00.000','2015-06-30 00:00:00.000','0023167',NULL,0,'PER01085259','2014-08-13 17:37:13.000','PER01085259','2014-08-14 00:00:00.000',2015)

,(3255629,'PER01018383','ORG00000198',1,'2014-09-11 00:00:00.000','2015-06-30 00:00:00.000','0028305',NULL,0,'PER01336186','2014-09-11 15:18:54.000','PER01336186','2014-09-11 00:00:00.000',2015)

,(3265957,'PER01211208','ORG00000198',1,'2014-09-29 00:00:00.000','2015-06-30 00:00:00.000','0030019',NULL,0,'PER01336186','2014-09-29 19:55:26.000','PER01336186','2014-09-29 00:00:00.000',2015)

,(3265958,'PER00923423','ORG00000198',1,'2014-09-29 00:00:00.000','2015-06-30 00:00:00.000','0030019',NULL,0,'PER01336186','2014-09-29 19:55:26.000','PER01336186','2014-09-29 00:00:00.000',2015)

,(3265972,'PER01353975','ORG00000198',1,'2014-09-29 00:00:00.000','2015-06-30 00:00:00.000','0030019',NULL,0,'PER01336186','2014-09-29 19:55:28.000','PER01336186','2014-09-29 00:00:00.000',2015)

,(3273710,'PER00280973','ORG00000201',2,'2014-10-10 00:00:00.000','2015-06-30 00:00:00.000','0030959',NULL,0,'PER00404665','2014-10-10 21:17:34.000','PER00404665','2014-10-10 00:00:00.000',2015)

,(3273713,'PER01280918','ORG00000201',2,'2014-10-10 00:00:00.000','2015-06-30 00:00:00.000','0030959',NULL,0,'PER00404665','2014-10-10 21:17:35.000','PER00404665','2014-10-10 00:00:00.000',2015)

,(3283455,'PER01026563','ORG00000380',4,'2014-10-30 00:00:00.000','2015-06-30 00:00:00.000','0032860',NULL,0,'PER01085259','2014-10-30 18:38:58.000','PER01085259','2014-10-31 00:00:00.000',2015)

,(3283456,'PER01256023','ORG00000380',4,'2014-10-30 00:00:00.000','2015-06-30 00:00:00.000','0032860',NULL,0,'PER01085259','2014-10-30 18:38:59.000','PER01085259','2014-10-31 00:00:00.000',2015)

,(3333459,'PER01417329','ORG00000380',2,'2015-02-05 00:00:00.000','2015-06-30 00:00:00.000','0039126',NULL,0,'PER01085259','2015-02-05 18:36:19.000','PER01085259','2015-02-06 00:00:00.000',2015)

,(3333460,'PER01015269','ORG00000380',4,'2015-02-05 00:00:00.000','2015-06-30 00:00:00.000','0039128',NULL,0,'PER01085259','2015-02-05 18:40:50.000','PER01085259','2015-02-06 00:00:00.000',2015)

,(3334677,'PER00878653','ORG00000007',1,'2015-02-08 00:00:00.000','2015-06-30 00:00:00.000','0039285',NULL,0,'PER01337808','2015-02-08 21:38:11.000','PER01337808','2015-02-09 00:00:00.000',2015)

,(3339275,'PER01405208','ORG00000002',1,'2015-02-18 00:00:00.000','2015-06-30 00:00:00.000','0039792',NULL,0,'PER00390108','2015-02-18 15:04:59.000','PER00390108','2015-02-18 00:00:00.000',2015)

,(3339276,'PER01474851','ORG00000002',1,'2015-02-18 00:00:00.000','2015-06-30 00:00:00.000','0039792',NULL,0,'PER00390108','2015-02-18 15:05:01.000','PER00390108','2015-02-18 00:00:00.000',2015)

,(3354983,'PER01343131','ORG00000007',1,'2015-03-17 00:00:00.000','2015-06-30 00:00:00.000','0041352',NULL,0,'PER01337808','2015-03-17 22:53:47.000','PER01337808','2015-03-18 00:00:00.000',2015)

,(3354984,'PER01343132','ORG00000007',2,'2015-03-17 00:00:00.000','2015-06-30 00:00:00.000','0041352',NULL,0,'PER01337808','2015-03-17 22:53:47.000','PER01337808','2015-03-18 00:00:00.000',2015)

,(3365411,'PER01254847','ORG00000007',1,'2015-04-13 00:00:00.000','2015-06-30 00:00:00.000','0042470',NULL,0,'PER01337808','2015-04-13 23:05:15.000','PER01337808','2015-04-14 00:00:00.000',2015)

,(3365412,'PER01494303','ORG00000007',2,'2015-04-13 00:00:00.000','2015-06-30 00:00:00.000','0042470',NULL,0,'PER01337808','2015-04-13 23:05:17.000','PER01337808','2015-04-14 00:00:00.000',2015)

,(3371414,'PER01029056','ORG00000007',1,'2015-05-03 00:00:00.000','2015-06-30 00:00:00.000','0043271',NULL,0,'PER01337808','2015-05-03 22:06:08.000','PER01337808','2015-05-04 00:00:00.000',2015)

,(3376825,'PER00486289','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:50.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3376826,'PER01393641','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:50.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3376829,'PER00053501','ORG00000002',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:51.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3376843,'PER01191033','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:54.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3376844,'PER01263116','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:54.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3380937,'PER01286179','ORG00000380',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0045470',NULL,0,'PER01085259','2015-06-06 05:45:03.000','PER01085259','2015-06-06 00:00:00.000',2016)

,(3380938,'PER01341423','ORG00000380',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0045470',NULL,0,'PER01085259','2015-06-06 05:45:03.000','PER01085259','2015-06-06 00:00:00.000',2016)

,(3398335,'PER01119809','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:30.000','PER01336186','2015-06-22 00:00:00.000',2016)

,(3398336,'PER01211228','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:30.000','PER01336186','2015-06-22 00:00:00.000',2016)

,(3401226,'PER01208579','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:19.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401229,'PER01265452','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:20.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401243,'PER01312875','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:24.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401244,'PER01413338','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:24.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3406123,'PER01100779','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:37.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406124,'PER01100784','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:37.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406141,'PER01271706','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:41.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406142,'PER01279235','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:41.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3256485,'PER01354265','ORG00000198',1,'2014-09-14 00:00:00.000','2015-06-30 00:00:00.000','0028545',NULL,0,'PER01336186','2014-09-14 19:02:14.000','PER01336186','2014-09-14 00:00:00.000',2015)

,(3257957,'PER01021030','ORG00000198',1,'2014-09-16 00:00:00.000','2015-06-30 00:00:00.000','0028799',NULL,0,'PER01336186','2014-09-16 20:21:28.000','PER01336186','2014-09-16 00:00:00.000',2015)

,(3265109,'PER00214715','ORG00000380',3,'2014-09-28 00:00:00.000','2018-06-30 00:00:00.000','0029828',NULL,0,'PER01085259','2014-09-28 13:21:11.000','PER01085259','2014-09-28 00:00:00.000',2018)

,(3265959,'PER01294697','ORG00000198',2,'2014-09-29 00:00:00.000','2015-06-30 00:00:00.000','0030019',NULL,0,'PER01336186','2014-09-29 19:55:26.000','PER01336186','2014-09-29 00:00:00.000',2015)

,(3265970,'PER00789896','ORG00000198',1,'2014-09-29 00:00:00.000','2015-06-30 00:00:00.000','0030019',NULL,0,'PER01336186','2014-09-29 19:55:28.000','PER01336186','2014-09-29 00:00:00.000',2015)

,(3273708,'PER00647282','ORG00000201',1,'2014-10-10 00:00:00.000','2015-06-30 00:00:00.000','0030959',NULL,0,'PER00404665','2014-10-10 21:17:34.000','PER00404665','2014-10-10 00:00:00.000',2015)

,(3273715,'PER00842058','ORG00000201',1,'2014-10-10 00:00:00.000','2015-06-30 00:00:00.000','0030959',NULL,0,'PER00404665','2014-10-10 21:17:35.000','PER00404665','2014-10-10 00:00:00.000',2015)

,(3273722,'PER01373934','ORG00000201',1,'2014-10-10 00:00:00.000','2015-06-30 00:00:00.000','0030959',NULL,0,'PER00404665','2014-10-10 21:17:37.000','PER00404665','2014-10-10 00:00:00.000',2015)

,(3283450,'PER00959962','ORG00000380',1,'2014-10-30 00:00:00.000','2015-06-30 00:00:00.000','0032860',NULL,0,'PER01085259','2014-10-30 18:38:58.000','PER01085259','2014-10-31 00:00:00.000',2015)

,(3298644,'PER01256021','ORG00000380',4,'2014-11-22 00:00:00.000','2015-06-30 00:00:00.000','0034644',NULL,0,'PER01085259','2014-11-22 13:39:12.000','PER01085259','2014-11-22 00:00:00.000',2015)

,(3331071,'PER00691905','ORG00000007',1,'2015-02-02 00:00:00.000','2015-06-30 00:00:00.000','0038931',NULL,0,'PER01337808','2015-02-02 22:45:07.000','PER01337808','2015-02-03 00:00:00.000',2015)

,(3376824,'PER00136419','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:50.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3376831,'PER00388729','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:51.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3376838,'PER00390108','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:52.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3378471,'PER00285935','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044930',NULL,0,'PER00611322','2015-06-03 15:37:24.000','PER00611322','2015-06-03 00:00:00.000',2016)

,(3380936,'PER00959962','ORG00000380',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0045470',NULL,0,'PER01085259','2015-06-06 05:45:03.000','PER01085259','2015-06-06 00:00:00.000',2016)

,(3383626,'PER01501278','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0046324',NULL,0,'PER00390108','2015-06-09 14:18:35.000','PER00390108','2015-06-09 00:00:00.000',2016)

,(3392075,'PER00501218','ORG00000380',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0048246',NULL,0,'PER01341423','2015-06-17 14:55:42.000','PER01341423','2015-06-17 00:00:00.000',2016)

,(3392543,'PER00928222','ORG00000380',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0048313',NULL,0,'PER01341423','2015-06-17 18:43:20.000','PER01341423','2015-06-18 00:00:00.000',2016)

,(3396626,'PER00975213','ORG00000002',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049272',NULL,0,'PER00390108','2015-06-21 13:56:08.000','PER00390108','2015-06-21 00:00:00.000',2016)

,(3398330,'PER01336186','ORG00000198',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:29.000','PER01336186','2015-06-22 00:00:00.000',2016)

,(3398341,'PER01294712','ORG00000198',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:31.000','PER01336186','2015-06-22 00:00:00.000',2016)

,(3401224,'PER00880402','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:19.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401231,'PER01265453','ORG00000007',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:20.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401238,'PER00978859','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:22.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3402903,'PER00055669','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050662',NULL,0,'PER01336186','2015-06-25 18:52:55.000','PER01336186','2015-06-25 00:00:00.000',2016)

,(3402910,'PER01211276','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050662',NULL,0,'PER01336186','2015-06-25 18:52:56.000','PER01336186','2015-06-25 00:00:00.000',2016)

,(3406118,'PER01334473','ORG00000082',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:36.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406129,'PER00540066','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:38.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406136,'PER01000109','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:39.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406143,'PER01348191','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:41.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406154,'PER00817215','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:45.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406161,'PER01262328','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:47.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406168,'PER01504000','ORG00000082',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:50.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406815,'PER01014981','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:33.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406822,'PER00487279','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:35.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406829,'PER00391803','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:36.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406840,'PER00942142','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:39.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406847,'PER01504105','ORG00000007',4,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:42.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3273703,'PER01096476','ORG00000201',1,'2014-10-10 00:00:00.000','2015-06-30 00:00:00.000','0030959',NULL,0,'PER00404665','2014-10-10 21:17:34.000','PER00404665','2014-10-10 00:00:00.000',2015)

,(3273718,'PER00053268','ORG00000201',1,'2014-10-10 00:00:00.000','2015-06-30 00:00:00.000','0030959',NULL,0,'PER00404665','2014-10-10 21:17:36.000','PER00404665','2014-10-10 00:00:00.000',2015)

,(3277564,'PER01435438','ORG00000007',1,'2014-10-19 00:00:00.000','2015-06-30 00:00:00.000','0031720',NULL,0,'PER01337808','2014-10-19 18:15:54.000','PER01337808','2014-10-20 00:00:00.000',2015)

,(3283448,'PER01089186','ORG00000380',1,'2014-10-30 00:00:00.000','2015-06-30 00:00:00.000','0032860',NULL,0,'PER01085259','2014-10-30 18:38:58.000','PER01085259','2014-10-31 00:00:00.000',2015)

,(3305187,'PER01451115','ORG00000007',3,'2014-12-10 00:00:00.000','2018-06-30 00:00:00.000','0035834',NULL,0,'PER00398243','2014-12-10 18:35:41.000','PER00398243','2014-12-11 00:00:00.000',2018)

,(3333465,'PER01111066','ORG00000380',4,'2015-02-05 00:00:00.000','2015-06-30 00:00:00.000','0039130',NULL,0,'PER01085259','2015-02-05 18:46:07.000','PER01085259','2015-02-06 00:00:00.000',2015)

,(3366289,'PER01384337','ORG00000007',1,'2015-04-18 00:00:00.000','2015-06-30 00:00:00.000','0042713',NULL,0,'PER01337808','2015-04-18 19:20:03.000','PER01337808','2015-04-19 00:00:00.000',2015)

,(3376834,'PER01409726','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:52.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3376836,'PER00386805','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:52.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3378472,'PER00392426','ORG00000082',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044930',NULL,0,'PER00611322','2015-06-03 15:37:24.000','PER00611322','2015-06-03 00:00:00.000',2016)

,(3380929,'PER00726254','ORG00000380',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0045470',NULL,0,'PER01085259','2015-06-06 05:45:02.000','PER01085259','2015-06-06 00:00:00.000',2016)

,(3380931,'PER01085259','ORG00000380',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0045470',NULL,0,'PER01085259','2015-06-06 05:45:02.000','PER01085259','2015-06-06 00:00:00.000',2016)

,(3382316,'PER01501116','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0045992',NULL,0,'PER00390108','2015-06-08 13:24:50.000','PER00390108','2015-06-08 00:00:00.000',2016)

,(3382318,'PER00401935','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0045992',NULL,0,'PER00390108','2015-06-08 13:24:50.000','PER00390108','2015-06-08 00:00:00.000',2016)

,(3392076,'PER01015269','ORG00000380',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0048246',NULL,0,'PER01341423','2015-06-17 14:55:42.000','PER01341423','2015-06-17 00:00:00.000',2016)

,(3392078,'PER01015266','ORG00000380',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0048246',NULL,0,'PER01341423','2015-06-17 14:55:43.000','PER01341423','2015-06-17 00:00:00.000',2016)

,(3392544,'PER01182376','ORG00000380',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0048313',NULL,0,'PER01341423','2015-06-17 18:43:20.000','PER01341423','2015-06-18 00:00:00.000',2016)

,(3392546,'PER01336204','ORG00000380',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0048313',NULL,0,'PER01341423','2015-06-17 18:43:21.000','PER01341423','2015-06-18 00:00:00.000',2016)

,(3398326,'PER01211180','ORG00000198',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:28.000','PER01336186','2015-06-22 00:00:00.000',2016)

,(3398328,'PER01192235','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:29.000','PER01336186','2015-06-22 00:00:00.000',2016)

,(3398343,'PER01354265','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:32.000','PER01336186','2015-06-22 00:00:00.000',2016)

,(3398345,'PER01359305','ORG00000198',3,'2015-07-01 00:00:00.000','2019-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:32.000','PER01336186','2015-06-22 00:00:00.000',2019)

,(3401219,'PER00856488','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:18.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401234,'PER01350108','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:21.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401236,'PER01411485','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:21.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3402906,'PER01020994','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050662',NULL,0,'PER01336186','2015-06-25 18:52:56.000','PER01336186','2015-06-25 00:00:00.000',2016)

,(3402908,'PER00589044','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050662',NULL,0,'PER01336186','2015-06-25 18:52:56.000','PER01336186','2015-06-25 00:00:00.000',2016)

,(3406114,'PER01083402','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:36.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406116,'PER01023889','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:36.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406131,'PER00817213','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:38.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406133,'PER00818828','ORG00000082',3,'2015-07-01 00:00:00.000','2019-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:39.000','PER00611322','2015-06-28 00:00:00.000',2019)

,(3406148,'PER00387198','ORG00000082',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:43.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406150,'PER00611322','ORG00000082',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:43.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406165,'PER01351797','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:49.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406167,'PER01412658','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:50.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406816,'PER01262430','ORG00000007',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:34.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406818,'PER01113538','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:34.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406833,'PER01427723','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:37.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406835,'PER01202934','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:38.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3261317,'PER01427723','ORG00000007',1,'2014-09-21 00:00:00.000','2015-06-30 00:00:00.000','0029219',NULL,0,'PER01337808','2014-09-21 19:23:34.000','PER01337808','2014-09-22 00:00:00.000',2015)

,(3265963,'PER01211187','ORG00000198',1,'2014-09-29 00:00:00.000','2015-06-30 00:00:00.000','0030019',NULL,0,'PER01336186','2014-09-29 19:55:26.000','PER01336186','2014-09-29 00:00:00.000',2015)

,(3265965,'PER01021023','ORG00000198',1,'2014-09-29 00:00:00.000','2015-06-30 00:00:00.000','0030019',NULL,0,'PER01336186','2014-09-29 19:55:27.000','PER01336186','2014-09-29 00:00:00.000',2015)

,(3273704,'PER01280871','ORG00000201',1,'2014-10-10 00:00:00.000','2015-06-30 00:00:00.000','0030959',NULL,0,'PER00404665','2014-10-10 21:17:34.000','PER00404665','2014-10-10 00:00:00.000',2015)

,(3273719,'PER00558085','ORG00000201',1,'2014-10-10 00:00:00.000','2015-06-30 00:00:00.000','0030959',NULL,0,'PER00404665','2014-10-10 21:17:36.000','PER00404665','2014-10-10 00:00:00.000',2015)

,(3277565,'PER01435439','ORG00000007',1,'2014-10-19 00:00:00.000','2015-06-30 00:00:00.000','0031720',NULL,0,'PER01337808','2014-10-19 18:15:57.000','PER01337808','2014-10-20 00:00:00.000',2015)

,(3283664,'PER00119734','ORG00000110',1,'2014-10-31 00:00:00.000','2015-06-30 00:00:00.000','0032885',NULL,0,'PER00438479','2014-10-31 11:16:06.000','PER00438479','2014-10-31 00:00:00.000',2015)

,(3305188,'PER01451116','ORG00000007',3,'2014-12-10 00:00:00.000','2018-06-30 00:00:00.000','0035834',NULL,0,'PER00398243','2014-12-10 18:35:44.000','PER00398243','2014-12-11 00:00:00.000',2018)

,(3333466,'PER01089185','ORG00000380',2,'2015-02-05 00:00:00.000','2015-06-30 00:00:00.000','0039130',NULL,0,'PER01085259','2015-02-05 18:46:07.000','PER01085259','2015-02-06 00:00:00.000',2015)

,(3376835,'PER01475950','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:52.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3376837,'PER00387068','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0044392',NULL,0,'PER00390108','2015-06-01 11:45:52.000','PER00087235','2015-06-01 00:00:00.000',2016)

,(3380930,'PER01015507','ORG00000380',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0045470',NULL,0,'PER01085259','2015-06-06 05:45:02.000','PER01085259','2015-06-06 00:00:00.000',2016)

,(3380932,'PER01256020','ORG00000380',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0045470',NULL,0,'PER01085259','2015-06-06 05:45:03.000','PER01085259','2015-06-06 00:00:00.000',2016)

,(3382317,'PER00921838','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0045992',NULL,0,'PER00390108','2015-06-08 13:24:50.000','PER00390108','2015-06-08 00:00:00.000',2016)

,(3382319,'PER01349493','ORG00000002',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0045992',NULL,0,'PER00390108','2015-06-08 13:24:50.000','PER00390108','2015-06-08 00:00:00.000',2016)

,(3392077,'PER01089188','ORG00000380',4,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0048246',NULL,0,'PER01341423','2015-06-17 14:55:43.000','PER01341423','2015-06-17 00:00:00.000',2016)

,(3392079,'PER01502521','ORG00000380',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0048246',NULL,0,'PER01341423','2015-06-17 14:55:43.000','PER01341423','2015-06-17 00:00:00.000',2016)

,(3392545,'PER01182378','ORG00000380',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0048313',NULL,0,'PER01341423','2015-06-17 18:43:20.000','PER01341423','2015-06-18 00:00:00.000',2016)

,(3392547,'PER00919089','ORG00000380',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0048313',NULL,0,'PER01341423','2015-06-17 18:43:21.000','PER01341423','2015-06-18 00:00:00.000',2016)

,(3398327,'PER00789915','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:28.000','PER01336186','2015-06-22 00:00:00.000',2016)

,(3398329,'PER01211271','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:29.000','PER01336186','2015-06-22 00:00:00.000',2016)

,(3398344,'PER01356709','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0049720',NULL,0,'PER01336186','2015-06-22 20:50:32.000','PER01336186','2015-06-22 00:00:00.000',2016)

,(3401220,'PER01178669','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:18.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401235,'PER01414104','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:21.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3401237,'PER01262433','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050325',NULL,0,'PER01337808','2015-06-24 20:24:22.000','PER01337808','2015-06-25 00:00:00.000',2016)

,(3402905,'PER00990813','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050662',NULL,0,'PER01336186','2015-06-25 18:52:56.000','PER01336186','2015-06-25 00:00:00.000',2016)

,(3402907,'PER01192234','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0050662',NULL,0,'PER01336186','2015-06-25 18:52:56.000','PER01336186','2015-06-25 00:00:00.000',2016)

,(3406115,'PER00028618','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:36.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406117,'PER01100785','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:36.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406132,'PER00818823','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:39.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406134,'PER00916705','ORG00000082',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:39.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406147,'PER00336202','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:42.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406149,'PER00398870','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:43.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406151,'PER00611326','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:44.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406164,'PER01348190','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:48.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406166,'PER01412649','ORG00000082',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:49.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406817,'PER01337807','ORG00000007',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:34.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406819,'PER01178671','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:34.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406834,'PER01254847','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:37.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406836,'PER01337945','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:38.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3412031,'PER01021011','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0052909',NULL,0,'PER01336186','2015-06-30 19:27:50.000','PER01336186','2015-06-30 00:00:00.000',2016)

,(3413267,'PER01354698','ORG00000007',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0053119',NULL,0,'PER01337808','2015-06-30 22:08:29.000','PER01337808','2015-07-01 00:00:00.000',2016)

,(3417077,'PER01020985','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0053531',NULL,0,'PER01336186','2015-07-01 20:15:46.000','PER01336186','2015-07-01 00:00:00.000',2016)

,(3421957,'PER00878653','ORG00000007',1,'2015-07-07 00:00:00.000','2016-06-30 00:00:00.000','0054324',NULL,0,'PER01337808','2015-07-07 21:37:35.000','PER01337808','2015-07-08 00:00:00.000',2016)

,(3422308,'PER01211185','ORG00000198',2,'2015-07-08 00:00:00.000','2016-06-30 00:00:00.000','0054412',NULL,0,'PER01336186','2015-07-08 13:54:33.000','PER01336186','2015-07-08 00:00:00.000',2016)

,(3422310,'PER01506182','ORG00000198',2,'2015-07-08 00:00:00.000','2016-06-30 00:00:00.000','0054412',NULL,0,'PER01336186','2015-07-08 13:54:34.000','PER01336186','2015-07-08 00:00:00.000',2016)

,(3427890,'PER01089186','ORG00000380',1,'2015-07-16 00:00:00.000','2016-06-30 00:00:00.000','0055424',NULL,0,'PER01341423','2015-07-16 13:05:44.000','PER01341423','2015-07-16 00:00:00.000',2016)

,(3412027,'PER01294697','ORG00000198',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0052909',NULL,0,'PER01336186','2015-06-30 19:27:50.000','PER01336186','2015-06-30 00:00:00.000',2016)

,(3413256,'PER01323687','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0053119',NULL,0,'PER01337808','2015-06-30 22:08:27.000','PER01337808','2015-07-01 00:00:00.000',2016)

,(3413263,'PER01504711','ORG00000007',4,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0053119',NULL,0,'PER01337808','2015-06-30 22:08:28.000','PER01337808','2015-07-01 00:00:00.000',2016)

,(3421948,'PER00510920','ORG00000007',1,'2015-07-07 00:00:00.000','2016-06-30 00:00:00.000','0054324',NULL,0,'PER01337808','2015-07-07 21:37:33.000','PER01337808','2015-07-08 00:00:00.000',2016)

,(3421955,'PER00787094','ORG00000007',1,'2015-07-07 00:00:00.000','2016-06-30 00:00:00.000','0054324',NULL,0,'PER01337808','2015-07-07 21:37:34.000','PER01337808','2015-07-08 00:00:00.000',2016)

,(3427889,'PER00387953','ORG00000380',1,'2015-07-16 00:00:00.000','2016-06-30 00:00:00.000','0055424',NULL,0,'PER01341423','2015-07-16 13:05:43.000','PER01341423','2015-07-16 00:00:00.000',2016)

,(3431458,'PER00404665','ORG00000201',1,'2015-07-21 00:00:00.000','2016-06-30 00:00:00.000','0056033',NULL,0,'PER00404665','2015-07-21 21:40:23.000','PER00404665','2015-07-21 00:00:00.000',2016)

,(3436888,'PER00449636','ORG00000198',1,'2015-07-31 00:00:00.000','2016-06-30 00:00:00.000','0057041',NULL,0,'PER01336186','2015-07-31 07:19:10.000','PER01336186','2015-07-31 00:00:00.000',2016)

,(3406156,'PER00915707','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:45.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406159,'PER01083401','ORG00000082',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051454',NULL,0,'PER00611322','2015-06-28 15:47:47.000','PER00611322','2015-06-28 00:00:00.000',2016)

,(3406824,'PER00086528','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:35.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406827,'PER00390002','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:36.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406828,'PER01485541','ORG00000007',4,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:36.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406841,'PER01336850','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:40.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3406842,'PER01347641','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:40.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3412022,'PER01126338','ORG00000198',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0052909',NULL,0,'PER01336186','2015-06-30 19:27:49.000','PER01336186','2015-06-30 00:00:00.000',2016)

,(3412025,'PER00753075','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0052909',NULL,0,'PER01336186','2015-06-30 19:27:49.000','PER01336186','2015-06-30 00:00:00.000',2016)

,(3413261,'PER01504705','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0053119',NULL,0,'PER01337808','2015-06-30 22:08:28.000','PER01337808','2015-07-01 00:00:00.000',2016)

,(3413262,'PER01504708','ORG00000007',4,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0053119',NULL,0,'PER01337808','2015-06-30 22:08:28.000','PER01337808','2015-07-01 00:00:00.000',2016)

,(3421949,'PER01264108','ORG00000007',1,'2015-07-07 00:00:00.000','2016-06-30 00:00:00.000','0054324',NULL,0,'PER01337808','2015-07-07 21:37:33.000','PER01337808','2015-07-08 00:00:00.000',2016)

,(3421950,'PER00026271','ORG00000007',1,'2015-07-07 00:00:00.000','2016-06-30 00:00:00.000','0054324',NULL,0,'PER01337808','2015-07-07 21:37:33.000','PER01337808','2015-07-08 00:00:00.000',2016)

,(3424640,'PER01029056','ORG00000007',1,'2015-07-10 00:00:00.000','2016-06-30 00:00:00.000','0054792',NULL,0,'PER01337808','2015-07-10 20:18:58.000','PER01337808','2015-07-11 00:00:00.000',2016)

,(3425293,'PER01178668','ORG00000007',1,'2015-07-12 00:00:00.000','2016-06-30 00:00:00.000','0054927',NULL,0,'PER01337808','2015-07-12 21:14:18.000','PER01337808','2015-07-13 00:00:00.000',2016)

,(3425294,'PER00459162','ORG00000007',1,'2015-07-12 00:00:00.000','2016-06-30 00:00:00.000','0054927',NULL,0,'PER01337808','2015-07-12 21:14:19.000','PER01337808','2015-07-13 00:00:00.000',2016)

,(3431459,'PER00647280','ORG00000201',2,'2015-07-21 00:00:00.000','2016-06-30 00:00:00.000','0056033',NULL,0,'PER00404665','2015-07-21 21:40:23.000','PER00404665','2015-07-21 00:00:00.000',2016)

,(3431460,'PER00647282','ORG00000201',1,'2015-07-21 00:00:00.000','2016-06-30 00:00:00.000','0056033',NULL,0,'PER00404665','2015-07-21 21:40:23.000','PER00404665','2015-07-21 00:00:00.000',2016)

,(3439065,'PER01102731','ORG00000380',4,'2015-08-06 00:00:00.000','2016-06-30 00:00:00.000','0058351',NULL,0,'PER01341423','2015-08-06 11:20:19.000','PER01341423','2015-08-06 00:00:00.000',2016)

,(3439066,'PER01435891','ORG00000380',4,'2015-08-06 00:00:00.000','2016-06-30 00:00:00.000','0058351',NULL,0,'PER01341423','2015-08-06 11:20:19.000','PER01341423','2015-08-06 00:00:00.000',2016)

,(3412030,'PER01018383','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0052909',NULL,0,'PER01336186','2015-06-30 19:27:50.000','PER01336186','2015-06-30 00:00:00.000',2016)

,(3412032,'PER01192229','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0052909',NULL,0,'PER01336186','2015-06-30 19:27:51.000','PER01336186','2015-06-30 00:00:00.000',2016)

,(3413268,'PER01413594','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0053119',NULL,0,'PER01337808','2015-06-30 22:08:30.000','PER01337808','2015-07-01 00:00:00.000',2016)

,(3418565,'PER01336187','ORG00000198',2,'2015-07-02 00:00:00.000','2016-06-30 00:00:00.000','0053752',NULL,0,'PER01336186','2015-07-02 20:51:19.000','PER01336186','2015-07-02 00:00:00.000',2016)

,(3421958,'PER01506094','ORG00000007',4,'2015-07-07 00:00:00.000','2016-06-30 00:00:00.000','0054324',NULL,0,'PER01337808','2015-07-07 21:37:35.000','PER01337808','2015-07-08 00:00:00.000',2016)

,(3422309,'PER01211187','ORG00000198',1,'2015-07-08 00:00:00.000','2016-06-30 00:00:00.000','0054412',NULL,0,'PER01336186','2015-07-08 13:54:34.000','PER01336186','2015-07-08 00:00:00.000',2016)

,(3406844,'PER01413463','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0051605',NULL,0,'PER01337808','2015-06-29 00:49:41.000','PER01337808','2015-06-29 00:00:00.000',2016)

,(3412023,'PER00752132','ORG00000198',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0052909',NULL,0,'PER01336186','2015-06-30 19:27:49.000','PER01336186','2015-06-30 00:00:00.000',2016)

,(3412024,'PER00667773','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0052909',NULL,0,'PER01336186','2015-06-30 19:27:49.000','PER01336186','2015-06-30 00:00:00.000',2016)

,(3413259,'PER01336849','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0053119',NULL,0,'PER01337808','2015-06-30 22:08:28.000','PER01337808','2015-07-01 00:00:00.000',2016)

,(3413260,'PER01504602','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0053119',NULL,0,'PER01337808','2015-06-30 22:08:28.000','PER01337808','2015-07-01 00:00:00.000',2016)

,(3421951,'PER01120784','ORG00000007',1,'2015-07-07 00:00:00.000','2016-06-30 00:00:00.000','0054324',NULL,0,'PER01337808','2015-07-07 21:37:33.000','PER01337808','2015-07-08 00:00:00.000',2016)

,(3421952,'PER00528460','ORG00000007',1,'2015-07-07 00:00:00.000','2016-06-30 00:00:00.000','0054324',NULL,0,'PER01337808','2015-07-07 21:37:34.000','PER01337808','2015-07-08 00:00:00.000',2016)

,(3425292,'PER01265451','ORG00000007',2,'2015-07-12 00:00:00.000','2016-06-30 00:00:00.000','0054927',NULL,0,'PER01337808','2015-07-12 21:14:18.000','PER01337808','2015-07-13 00:00:00.000',2016)

,(3431461,'PER01201935','ORG00000201',2,'2015-07-21 00:00:00.000','2016-06-30 00:00:00.000','0056033',NULL,0,'PER00404665','2015-07-21 21:40:23.000','PER00404665','2015-07-21 00:00:00.000',2016)

,(3431462,'PER00651985','ORG00000201',1,'2015-07-21 00:00:00.000','2016-06-30 00:00:00.000','0056033',NULL,0,'PER00404665','2015-07-21 21:40:24.000','PER00404665','2015-07-21 00:00:00.000',2016)

,(3439063,'PER01111066','ORG00000380',2,'2015-08-06 00:00:00.000','2016-06-30 00:00:00.000','0058351',NULL,0,'PER01341423','2015-08-06 11:20:18.000','PER01341423','2015-08-06 00:00:00.000',2016)

,(3439064,'PER00404696','ORG00000380',1,'2015-08-06 00:00:00.000','2016-06-30 00:00:00.000','0058351',NULL,0,'PER01341423','2015-08-06 11:20:18.000','PER01341423','2015-08-06 00:00:00.000',2016)

,(3441704,'PER01343132','ORG00000007',1,'2015-08-12 00:00:00.000','2016-06-30 00:00:00.000','0059112',NULL,0,'PER01337808','2015-08-12 08:17:40.000','PER01337808','2015-08-12 00:00:00.000',2016)

,(3443343,'PER00389046','ORG00000002',1,'2015-08-14 00:00:00.000','2016-06-30 00:00:00.000','0059416',NULL,0,'PER00390108','2015-08-14 13:50:13.000','PER00390108','2015-08-14 00:00:00.000',2016)

,(3412028,'PER00361035','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0052909',NULL,0,'PER01336186','2015-06-30 19:27:50.000','PER01336186','2015-06-30 00:00:00.000',2016)

,(3413257,'PER00908405','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0053119',NULL,0,'PER01337808','2015-06-30 22:08:28.000','PER01337808','2015-07-01 00:00:00.000',2016)

,(3413264,'PER00071792','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0053119',NULL,0,'PER01337808','2015-06-30 22:08:29.000','PER01337808','2015-07-01 00:00:00.000',2016)

,(3413266,'PER01354697','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0053119',NULL,0,'PER01337808','2015-06-30 22:08:29.000','PER01337808','2015-07-01 00:00:00.000',2016)

,(3421947,'PER01245918','ORG00000007',1,'2015-07-07 00:00:00.000','2016-06-30 00:00:00.000','0054324',NULL,0,'PER01337808','2015-07-07 21:37:33.000','PER01337808','2015-07-08 00:00:00.000',2016)

,(3421954,'PER00592897','ORG00000007',1,'2015-07-07 00:00:00.000','2016-06-30 00:00:00.000','0054324',NULL,0,'PER01337808','2015-07-07 21:37:34.000','PER01337808','2015-07-08 00:00:00.000',2016)

,(3421956,'PER00818059','ORG00000007',1,'2015-07-07 00:00:00.000','2016-06-30 00:00:00.000','0054324',NULL,0,'PER01337808','2015-07-07 21:37:34.000','PER01337808','2015-07-08 00:00:00.000',2016)

,(3422658,'PER01175288','ORG00000198',2,'2015-07-08 00:00:00.000','2016-06-30 00:00:00.000','0054468',NULL,0,'PER01336186','2015-07-08 18:57:03.000','PER01336186','2015-07-08 00:00:00.000',2016)

,(3423917,'PER00299050','ORG00000198',1,'2015-07-09 00:00:00.000','2016-06-30 00:00:00.000','0054642',NULL,0,'PER01336186','2015-07-09 18:31:05.000','PER01336186','2015-07-09 00:00:00.000',2016)

,(3423926,'PER00589047','ORG00000198',1,'2015-07-09 00:00:00.000','2016-06-30 00:00:00.000','0054645',NULL,0,'PER01336186','2015-07-09 18:41:01.000','PER01336186','2015-07-09 00:00:00.000',2016)

,(3425291,'PER01336852','ORG00000007',1,'2015-07-12 00:00:00.000','2016-06-30 00:00:00.000','0054927',NULL,0,'PER01337808','2015-07-12 21:14:18.000','PER01337808','2015-07-13 00:00:00.000',2016)

,(3409389,'PER00389939','ORG00000380',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0052248',NULL,0,'PER01341423','2015-06-30 05:31:47.000','PER01341423','2015-06-30 00:00:00.000',2016)

,(3412029,'PER00522497','ORG00000198',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0052909',NULL,0,'PER01336186','2015-06-30 19:27:50.000','PER01336186','2015-06-30 00:00:00.000',2016)

,(3413258,'PER01412578','ORG00000007',2,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0053119',NULL,0,'PER01337808','2015-06-30 22:08:28.000','PER01337808','2015-07-01 00:00:00.000',2016)

,(3413265,'PER01091241','ORG00000007',1,'2015-07-01 00:00:00.000','2016-06-30 00:00:00.000','0053119',NULL,0,'PER01337808','2015-06-30 22:08:29.000','PER01337808','2015-07-01 00:00:00.000',2016)

,(3418788,'PER01353975','ORG00000198',1,'2015-07-03 00:00:00.000','2016-06-30 00:00:00.000','0053787',NULL,0,'PER01336186','2015-07-03 09:31:28.000','PER01336186','2015-07-03 00:00:00.000',2016)

,(3421946,'PER01265348','ORG00000007',1,'2015-07-07 00:00:00.000','2016-06-30 00:00:00.000','0054324',NULL,0,'PER01337808','2015-07-07 21:37:32.000','PER01337808','2015-07-08 00:00:00.000',2016)

,(3421953,'PER01412580','ORG00000007',1,'2015-07-07 00:00:00.000','2016-06-30 00:00:00.000','0054324',NULL,0,'PER01337808','2015-07-07 21:37:34.000','PER01337808','2015-07-08 00:00:00.000',2016)

,(3423918,'PER01356710','ORG00000198',1,'2015-07-09 00:00:00.000','2016-06-30 00:00:00.000','0054642',NULL,0,'PER01336186','2015-07-09 18:31:06.000','PER01336186','2015-07-09 00:00:00.000',2016)

,(3425290,'PER01336851','ORG00000007',2,'2015-07-12 00:00:00.000','2016-06-30 00:00:00.000','0054927',NULL,0,'PER01337808','2015-07-12 21:14:17.000','PER01337808','2015-07-13 00:00:00.000',2016)

,(3427787,'PER01507860','ORG00000198',2,'2015-07-16 00:00:00.000','2016-06-30 00:00:00.000','0055400',NULL,0,'PER01336186','2015-07-16 10:21:14.000','PER01336186','2015-07-16 00:00:00.000',2016)

,(3427887,'PER01036946','ORG00000380',1,'2015-07-16 00:00:00.000','2016-06-30 00:00:00.000','0055424',NULL,0,'PER01341423','2015-07-16 13:05:42.000','PER01341423','2015-07-16 00:00:00.000',2016)

,(3431456,'PER01304940','ORG00000201',1,'2015-07-21 00:00:00.000','2016-06-30 00:00:00.000','0056033',NULL,0,'PER00404665','2015-07-21 21:40:22.000','PER00404665','2015-07-21 00:00:00.000',2016)

,(3439062,'PER01089185','ORG00000380',2,'2015-08-06 00:00:00.000','2016-06-30 00:00:00.000','0058351',NULL,0,'PER01341423','2015-08-06 11:20:17.000','PER01341423','2015-08-06 00:00:00.000',2016)

,(3443238,'PER00569564','ORG00000198',1,'2015-08-13 00:00:00.000','2016-06-30 00:00:00.000','0059330',NULL,0,'PER01336186','2015-08-13 18:03:57.000','PER01336186','2015-08-13 00:00:00.000',2016);

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

serviceaellis SSCommitted Points: 1865 More actions · Answer 4

ChrisM@Works,

The columns except the last four columns which are:

MembershipTypeIdEndDateInvoiceNumberPersonMembership_PersonId

serviceaellis SSCommitted Points: 1865 More actions · Answer 5

The RDP access to the SQL Server is not responding at the moment.

But from what I can gather from the formula,

it'll produce the 15 memberships ending on 6/30/2015 for ClubNo 5305?

serviceaellis SSCommitted Points: 1865 More actions · Answer 6

serviceaellis

SSCommitted

Points: 1865

August 19, 2015 at 8:32 am

#1821072

Ah, thank you

serviceaellis SSCommitted Points: 1865 More actions · Answer 7

The excel file was included in the .zip uploaded yesterday.

Here's the image with several columns hidden so it can be seen easier.

Without any modifications to the original formula I get all the rows except row 17, the highlighted row.

The only difference I see between the two Clubs 5305 and 8004 is that 8004 has no memberships in whereas 5305 has memberships in 2015.

The memberships in 2015, EndDate 6/30/2015 is expired and the "CURRENT" memberships are those with EndDate of 6/30/2016 and so on.

The report needs to show ALL Clubs rather they have a membership or not, current or not. Like 8004.

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 8

serviceaellis (8/19/2015)
ChrisM@Works,
The columns except the last four columns which are:
MembershipTypeIdEndDateInvoiceNumberPersonMembership_PersonId

Thanks. What about the content? What do the results tell you?

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

serviceaellis SSCommitted Points: 1865 More actions · Answer 9

Club information WITHOUT membership information.

Which should but then also include membership information IF it exists BUT still produce the Club information

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 10

serviceaellis (8/19/2015)
Club information WITHOUT membership information.
Which should but then also include membership information IF it exists BUT still produce the Club information

please use the "quote" button in your response so that we all know who you are responding to.

thanks

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

serviceaellis SSCommitted Points: 1865 More actions · Answer 11

ChrisM@Work (8/19/2015)
serviceaellis (8/19/2015)
ChrisM@Works,
The columns except the last four columns which are:
MembershipTypeIdEndDateInvoiceNumberPersonMembership_PersonId
Thanks. What about the content? What do the results tell you?

Sorry, I thought if you click Reply on the Post it replies to that specific one versus clicking on Add Reply which is a general Reply ...

The v060ClubOfficersPresOrNot is supposed to all have data on ALL Clubs and their info WITH President, if a President exist, if not still show the Club info without the President. Which it is.

PersonMembership is only if there's a membership so there should never be a record in that table with a missing EndDate.

Not all Clubs will have a membership.

So they want to see ALL Clubs and their President or Not (hence the View name "ClubOfficersPresOrNot" ) and whether they have a membership or not and how many. So would show 15 for 5305 in 2015 0 in 2016, etc ... and 8004 0 in 2015 and 0 in 2016.

You're an organization ("Club") but haven't purchased a membership or did last time but not this time.

Report needs to show your Organization with or without membership(s) and the end goal is how many your Club purchased memberships or not at any given time.

I can do the final grouping and the count once the details of the info sought is figured out.

ChrisM@home SSC-Insane Points: 24260 More actions · Answer 12

ChrisM@Work (8/19/2015)
serviceaellis (8/18/2015)
Please see attached.
The worksheet is the result that needs to be produced with the highlighted row.
in the Access file the two tables are:
1. PersonMembership - with all the membership info
2. v060ClubOfficersPresOrNot - will all the club info which ALL of these should show and show when there is/are membership(s) or not.
3. for the duration of current year and future years where the MemberTypeID =3 is a 4 year membership.
Working with ClubNo 5305 and 8004 as these are the data sets that can be used to verify the correct result.
When the end-user enters 2015 they should see:
1. ClubNo 5305 club info with 15 memberships
2. ClubNo 8004 club info with 0 memberships
When the end-user enters 2016 they should see:
1. ClubNo 5305 club info with 0 memberships
2. ClubNo 8004 club info with 0 memberships
Please run this and report back with the results:
SELECT * FROM dbo.v060ClubOfficersPresOrNot WHERE ClubID IN (5305,8004)

Let's try this again. Run this query:

SELECT ClubID FROM dbo.v060ClubOfficersPresOrNot WHERE ClubID IN (5305,8004)

Do you see both clubs in the result set? YES or NO

Are there two rows? YES or tell us the number.

Thanks.

[font="Arial"]^{Low-hanging fruit picker and defender of the moggies}[/font]

For better assistance in answering your questions, please read this[/url].

Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 13

ChrisM@home (8/19/2015)
ChrisM@Work (8/19/2015)
serviceaellis (8/18/2015)
Please see attached.
The worksheet is the result that needs to be produced with the highlighted row.
in the Access file the two tables are:
1. PersonMembership - with all the membership info
2. v060ClubOfficersPresOrNot - will all the club info which ALL of these should show and show when there is/are membership(s) or not.
3. for the duration of current year and future years where the MemberTypeID =3 is a 4 year membership.
Working with ClubNo 5305 and 8004 as these are the data sets that can be used to verify the correct result.
When the end-user enters 2015 they should see:
1. ClubNo 5305 club info with 15 memberships
2. ClubNo 8004 club info with 0 memberships
When the end-user enters 2016 they should see:
1. ClubNo 5305 club info with 0 memberships
2. ClubNo 8004 club info with 0 memberships
Please run this and report back with the results:
SELECT * FROM dbo.v060ClubOfficersPresOrNot WHERE ClubID IN (5305,8004)
Let's try this again. Run this query:
SELECT ClubID FROM dbo.v060ClubOfficersPresOrNot WHERE ClubID IN (5305,8004)
Do you see both clubs in the result set? YES or NO
Are there two rows? YES or tell us the number.
Thanks.

Chris....fyi..I posted consumable SSMS data above earlier

based on that then ;

SELECT ClubID, ClubNo FROM dbo.v060ClubOfficersPresOrNot WHERE ClubNo IN (5305,8004)

delivers this ;

+----------------------+

¦ ClubID ¦ ClubNo ¦

¦-------------+--------¦

¦ ORG00001430 ¦ 8004 ¦

¦ ORG00004619 ¦ 5305 ¦

+----------------------+

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

serviceaellis SSCommitted Points: 1865 More actions · Answer 14

ChrisM@home (8/19/2015)
Please run this and report back with the results:
SELECT * FROM dbo.v060ClubOfficersPresOrNot WHERE ClubID IN (5305,8004)
Let's try this again. Run this query:
SELECT ClubID FROM dbo.v060ClubOfficersPresOrNot WHERE ClubID IN (5305,8004)
Do you see both clubs in the result set? YES or NO
Are there two rows? YES or tell us the number.
Thanks.

What J Livingston SQL is showing is correct. Here's all the fields for 5305 and 8004.

NOTED: Club table shows Clubs and their President AND if no President the other positions.

Hence the View name Club Officers Pres or Not.

5305 has a president and shows the club and president info.

8004 has no president and shows the club and the 4 other positions. <-- This doesn't matter for the final step since it'll all be grouped then the count on memberships. The end goal. And that it links on ClubID to OrganizationID to the memberships table. As you can see in the .xlsx file uploaded.

ClubIDClubNoSortNameClubNameContactUSFSA#StreetOneStreetTwoCareOfCityStatePostalCodeOrgTypeClubRegionClubSectionEmailPhoneFirstNameFacilityNamePresClubSecPresUSFSA#PresCareOfPresAdd1PresAdd2PresCityPresStatePresZipPersonIdPresidentPresEmailPresPhoneStatusIdURLCertifiedCodeFacilityLastUpdateByLawsUploadDateBSProgramProgramStatusIdStatusIsActive

ORG000014308004Florida Interclub Skating CouncilCharlotte Schermerhorn553074InterclubsSouth AtlanticEasternCharlotteNo0

ORG000014308004Florida Interclub Skating CouncilDavid Thompson403333InterclubsSouth AtlanticEasternDavidNo0

ORG000014308004Florida Interclub Skating CouncilEarl Roberts538190InterclubsSouth AtlanticEasternEarlNo0

ORG000014308004Florida Interclub Skating CouncilJacqueline Addis551706InterclubsSouth AtlanticEasternJacquelineNo0

ORG000046195305ShorelineShoreline Skating ClubMandy Curtin1561794121 Donald Lynch Blvd.MarlboroughMA01752Regular ClubNew EnglandEastern(508)229-2700MandyNew England Sports CenterEastern1561794121 Donald Lynch Blvd.MarlboroughMA01752PER00334157Mandy Curtinmandycurtin64@msn.com617-909-05783http://www.scboston.orgYesNE7/2/2014 1:44:00 PMNoActive-1

The v060ClubOfficersPresOrNot is supposed to all have data on ALL Clubs and their info WITH President, if a President exist, if not still show the Club info without the President. Which it is.
PersonMembership is only if there's a membership so there should never be a record in that table with a missing EndDate.
Not all Clubs will have a membership.
So they want to see ALL Clubs and their President or Not (hence the View name "ClubOfficersPresOrNot" ) and whether they have a membership or not and how many. So would show 15 for 5305 in 2015 0 in 2016, etc ... and 8004 0 in 2015 and 0 in 2016.
You're an organization ("Club") but haven't purchased a membership or did last time but not this time.
Report needs to show your Organization with or without membership(s) and the end goal is how many your Club purchased memberships or not at any given time.
I can do the final grouping and the count once the details of the info sought is figured out.

serviceaellis SSCommitted Points: 1865 More actions · Answer 15

got on to the SQL Server.

ok, so another way to explain what I've been trying to state, think I'm saying the same thing though ...

need current and future years AND when there is no membership, including when they had it in the past.

current year = expired enddate of 6/30/2015. Future year (AKA: "Current" membership) are those with enddate 6/30/2016+4. Because if they have memberships that ended this year on 6/30/2015 are no longer considered "current". The clubs memberships are considered "Current" IF their enddate is in the future. In this case, 6/30/2016 + 4

Now 8004 doesn't have membership BUT does show and 5305 has a membership BUT does not for next year BUT still needs to show that, even though they have memberships ending this year, 2015, that they don't have a "current" membership which ends in 2016.

As you've noticed the enddate is 6/30/yyyy. So this year, 2015, are expired, and next year, which is deemed "current" is for 2016 +.

And ALL Clubs needs to show whether they were current and not current now or didn't have any like 8004.