ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
F_EMPLOYMENT
D_JOB
D_EMPLOYEEDETAILS
D_DEPARTMENT
2
3
employmentStartDate
employmentEndDate
uniqueID
JobFK
EmployeeDetailsFK
DepartmentFK
Key
JobCode
JobName
effectivestartdate
effectiveEndDate
KeyfirstnameFTE Value
effectivestartdate
effectiveEndDate
KeydepartmentidDepartmentname
effectivestartdate
effectiveEndDate
4
6/8/202212/30/9999722446766916680436306602242858751000000Engineer1/1/202212/30/9999630660Andrew11/1/202212/30/9999224301000997Quality Control1/1/202212/30/9999
5
6/8/202212/30/9999722446766916680436306602242980321000007Developer1/1/202212/30/9999414597James11/1/202212/30/9999234351000092Benefits1/1/202212/30/9999
6
6/8/202212/30/9999722446766916680436306602243080381000010Analyst1/1/202212/30/9999795622Ian11/1/202212/30/9999242511003005HR1/1/202212/30/9999
7
6/8/202212/30/9999722446766916668346306602242880431000139Manager1/1/202212/30/999987154Steve0.51/1/202210/23/2022251011000086IT1/1/202212/30/9999
8
6/8/202212/30/9999722446766916668346306602242968341000242PMO1/1/202212/30/9999674595Stephen0.510/24/202212/30/9999251751000828Production1/1/202212/30/9999
9
6/8/202212/30/9999722446766916668346306602243068221000264Business Analyst1/1/20224/24/202228888Jeremy11/1/202210/3/2022254971000306Manufacturing1/1/202212/30/9999
10
3/27/202212/30/9999722474726575880434145972242880371000264Business Analyst 24/25/202211/13/202244680Jeremiah110/4/202211/17/2022257851000607Maintenance1/1/202212/30/9999
11
3/27/202212/30/9999722474726575880434145972242968241000264Business Analyst 311/14/202212/30/9999359729Jerome11/1/202212/30/9999274521007899Engineering1/1/20222/26/2022
12
3/27/202212/30/9999722474726575880434145972243080341000274Accountant1/1/202212/30/9999565957Natalie0.81/1/202212/30/9999274561007899Product Engineering2/27/2022 23:00:0012/30/9999
13
3/27/202212/30/99997224747265758683441459722428366567Arjun11/1/202212/30/9999216021002842Assurance1/1/202212/30/9999
14
3/27/202212/30/99997224747265758683441459722429382088Mariya11/1/202212/30/9999232841001296Systems1/1/202212/30/9999
15
3/27/202212/30/99997224747265758683441459722430311227Sheena0.51/1/202212/30/9999250981002399Packaging1/1/202212/30/9999
16
9/25/202211/24/20227225022869614803479562222428113618Cameron0.51/1/202212/30/9999257821000175Dispatch1/1/202212/30/9999
17
9/25/202211/24/20227225022869614803479562222429100644Amy11/1/20227/16/2022276161008229Shipping1/1/202212/30/9999
18
9/25/202211/24/20227225022869614803479562222430381753Amy-Smith17/17/202212/30/9999242431001733Receiving1/1/20226/13/2022
19
9/25/202210/24/20227225022869614803479562222429611023Patrick0.51/1/202212/30/9999242441001733Receiving Goods6/14/20224/24/2022
20
9/25/202210/24/20217225022869614803479562222430510904Joe11/1/202212/30/9999216001002842Supply1/1/20223/13/2022
21
9/25/202210/24/20217225022869614803479562222428678246Josh11/1/202212/30/9999216011002842Supply Chain1/1/202212/30/9999
22
9/25/20221/24/20227225022869614803479562222428500106Lamar11/1/202212/30/9999232821001296Research1/1/20227/13/2022
23
9/25/20221/24/20227225022869614803479562222429232831001296Research and Development7/14/20224/24/2022
24
9/25/20221/24/20227225022869614803479562222430250961002399Testing1/1/20223/13/2022
25
9/25/202211/24/20227225022869614803479562222428250971002399Testing and Validation3/14/202212/30/9999
26
9/25/202211/24/20227225022869614803479562222429257801000175BI1/1/20228/13/2022
27
9/25/202211/24/20227225022869614803479562222430257811000175Bi and Analytics8/14/202212/30/9999
28
9/25/202211/29/20227225022869614803479562222428276141008229Data1/1/20229/13/2022
29
7/27/20221/26/20217225258246217803467459523433276151008229Data Lake9/14/202212/30/9999
30
7/27/20221/26/20217225258246217803467459523434224281000997Data Engineering1/1/202210/13/2022
31
7/27/20221/26/20217225258246217803467459523435224291000997
Data Engineering Development
10/14/20224/24/2022
32
7/27/20221/26/2021722525824621780348715423433234331000092Finance1/1/20223/13/2022
33
7/27/20221/26/2021722525824621780348715423434234341000092Finance and Accounting3/14/202212/30/9999
34
7/27/20221/26/2021722525824621780348715423435242491003005Warehouse1/1/20223/13/2022
35
7/27/20221/26/2022722525824621780348715423433242501003005Warehouse and Handling3/14/202212/30/9999
36
7/27/20221/26/2022722525824621780348715423434250991000086Customer Service1/1/20223/13/2022
37
7/27/20221/26/2022722525824621780348715423435251001000086Customer Care3/14/202212/30/9999
38
7/27/20221/26/20227225258246217803467459523433251731000828Payroll1/1/20223/13/2022
39
7/27/20221/26/20227225258246217803467459523434251741000828Payroll Analysts3/14/202212/30/9999
40
7/27/20221/26/20227225258246217803467459523435254951000306Accounts1/1/20223/13/2022
41
7/27/20221/26/2023722525824621780348715423433254961000306Accounting3/14/202212/30/9999
42
7/27/20221/26/2023722525824621780348715423434257831000607Client Relations1/1/20223/13/2022
43
7/27/20221/26/2023722525824621780348715423435257841000607Client Care3/14/202212/30/9999
44
7/27/20221/26/20237225258246217803467459523433274501007899International1/1/20229/13/2022
45
7/27/20221/26/20237225258246217803467459523434274511007899International Relations9/14/202212/30/9999
46
7/27/20221/26/20237225258246217803467459523435242451001733Expenses4/25/202212/30/9999
47
7/27/20221/26/2023722525824621780328715425780
48
7/27/20221/26/2023722525824621780328715425781
49
7/27/20221/26/2023722525824621780328715425782
50
7/27/20221/26/20237225258246217803267459525780
51
7/27/20221/26/20237225258246217803267459525781
52
7/27/20221/26/20237225258246217803267459525782
53
7/27/20221/26/20237225258246217803467459525783
54
7/27/20221/26/20237225258246217803467459525784
55
7/27/20221/26/20237225258246217803467459525785
56
7/27/20221/26/2023722525824621780348715425783
57
7/27/20221/26/2023722525824621780348715425784
58
7/27/20221/26/2023722525824621780348715425785
59
1/31/20227/30/20217225458226690803235972923282
60
1/31/20227/30/20217225458226690803235972923283
61
1/31/20227/30/20217225458226690803235972923284
62
1/31/20227/30/2021722545822669080324468023282
63
1/31/20227/30/2021722545822669080324468023283
64
1/31/20227/30/2021722545822669080324468023284
65
1/31/20227/30/2021722545822669080322888823282
66
1/31/20227/30/2021722545822669080322888823283
67
1/31/20227/30/2021722545822669080322888823284
68
1/31/20227/30/20237225458226690803835972923282
69
1/31/20227/30/20237225458226690803835972923283
70
1/31/20227/30/20237225458226690803835972923284
71
1/31/20227/30/2023722545822669080384468023282
72
1/31/20227/30/2023722545822669080384468023283
73
1/31/20227/30/2023722545822669080384468023284
74
1/31/20227/30/2023722545822669080382888823282
75
1/31/20227/30/2023722545822669080382888823283
76
1/31/20227/30/2023722545822669080382888823284
77
5/23/20226/22/20217225498469266803856595721600
78
5/23/20226/22/20217225498469266803856595721601
79
5/23/20226/22/20217225498469266803856595721602
80
5/23/20226/22/20217225498469266803256595721600
81
5/23/20226/22/20217225498469266803256595721601
82
5/23/20226/22/20217225498469266803256595721602
83
5/23/20226/22/20227225498469266803856595721600
84
5/23/20226/22/20227225498469266803856595721601
85
5/23/20226/22/20227225498469266803856595721602
86
6/2/202212/1/20207225499090942682436656724243
87
6/2/202212/1/20207225499090942682436656724244
88
6/2/202212/1/20207225499090942682436656724245
89
6/2/202212/1/20207225499090942682236656724243
90
6/2/202212/1/20207225499090942682236656724244
91
6/2/202212/1/20207225499090942682236656724245
92
6/2/202212/1/20207225499090942803736656724243
93
6/2/202212/1/20207225499090942803736656724244
94
6/2/202212/1/20207225499090942803736656724245
95
6/2/202212/1/20217225499090942682436656724243
96
6/2/202212/1/20217225499090942682436656724244
97
6/2/202212/1/20217225499090942682436656724245
98
6/2/202212/1/20217225499090942682236656724243
99
6/2/202212/1/20217225499090942682236656724244
100
6/2/202212/1/20217225499090942682236656724245