Microsoft Access
maladam
3-WEEmployees.accdb| ID | EmployeeID | AbsentDate | AbsentReason |
|---|---|---|---|
| 1 | 1083 | 1/15/18 | Sick Day |
| 2 | 1090 | 1/15/18 | Jury Duty |
| 3 | 1025 | 2/5/18 | Sick Day |
| 4 | 1025 | 2/6/18 | Sick Day |
| 5 | 1025 | 2/7/18 | Sick Day |
| 6 | 1030 | 2/7/18 | Bereavement |
| 7 | 1030 | 2/12/18 | Bereavement |
| 8 | 1065 | 2/12/18 | Sick Day |
| 9 | 1073 | 2/12/18 | Sick Day |
| 10 | 1090 | 2/23/18 | Sick Day |
| 11 | 1073 | 2/26/18 | Sick Day |
| 12 | 1053 | 2/26/18 | Sick Day |
| 13 | 1095 | 2/26/18 | Sick Day |
| 14 | 1083 | 2/27/18 | Sick Day |
| 15 | 1045 | 3/2/18 | Bereavement |
| 16 | 1040 | 3/9/18 | Personal leave day |
| 17 | 1033 | 3/12/18 | Doctor appointment |
| 18 | 1095 | 3/12/18 | Sick Day |
| 19 | 1050 | 3/12/18 | Sick Day |
| 20 | 1023 | 3/13/18 | Bereavement |
| 21 | 1023 | 3/13/18 | Bereavement |
| 22 | 1060 | 3/14/18 | Sick Day |
| 23 | 1060 | 3/14/18 | Sick Day |
| 24 | 1023 | 3/19/18 | Personal leave day |
| 25 | 1000 | 3/23/18 | Sick Day |
| 26 | 1083 | 3/26/18 | Jury Duty |
| 27 | 1083 | 3/27/18 | Jury Duty |
| EmployeeID | PensionPlan | DentalPlan | HealthPlan | Dependents | LifeInsce | PensionDate | Vacation |
|---|---|---|---|---|---|---|---|
| 1000 | true | true | true | 0 | ¤ 100,000.00 | 7/22/09 | 4 weeks |
| 1003 | true | true | true | 2 | ¤ 200,000.00 | 8/15/09 | 3 weeks |
| 1005 | true | true | false | 0 | ¤ 150,000.00 | 9/1/09 | 3 weeks |
| 1013 | true | true | true | 3 | ¤ 200,000.00 | 3/1/10 | 3 weeks |
| 1015 | false | true | true | 2 | ¤ 185,000.00 | 6/1/10 | 4 weeks |
| 1020 | true | true | false | 5 | ¤ 200,000.00 | 8/1/10 | 3 weeks |
| 1023 | false | false | false | 0 | ¤ 100,000.00 | 11/1/10 | 3 weeks |
| 1025 | true | true | true | 6 | ¤ 200,000.00 | 1/1/10 | 4 weeks |
| 1030 | false | false | false | 0 | ¤ 75,000.00 | 2/1/11 | 2 weeks |
| 1033 | true | true | true | 3 | ¤ 125,000.00 | 2/1/11 | 3 weeks |
| 1040 | true | true | true | 4 | ¤ 200,000.00 | 4/1/13 | 3 weeks |
| 1043 | true | true | true | 5 | ¤ 200,000.00 | 9/1/13 | 3 weeks |
| 1045 | false | false | false | 0 | ¤ 50,000.00 | 2/1/14 | 2 weeks |
| 1050 | true | false | true | 2 | ¤ 125,000.00 | 3/1/14 | 2 weeks |
| 1053 | true | true | true | 1 | ¤ 85,000.00 | 5/1/15 | 3 weeks |
| 1060 | true | true | true | 3 | ¤ 175,000.00 | 7/1/15 | 3 weeks |
| 1063 | true | false | true | 2 | ¤ 100,000.00 | 3/15/15 | 2 weeks |
| 1065 | true | true | true | 1 | ¤ 150,000.00 | 3/15/16 | 2 weeks |
| 1073 | true | true | true | 6 | ¤ 200,000.00 | 12/31/17 | 2 weeks |
| 1080 | true | true | false | 2 | ¤ 150,000.00 | 2/15/18 | 1 week |
| 1083 | true | false | true | 1 | ¤ 75,000.00 | 7/1/18 | 1 week |
| 1085 | false | true | true | 2 | ¤ 125,000.00 | 3/15/18 | 1 week |
| 1090 | true | false | true | 2 | ¤ 150,000.00 | 12/1/18 | 1 week |
| 1093 | true | true | false | 3 | ¤ 185,000.00 | 12/31/18 | 1 week |
| 1095 | false | false | false | 1 | ¤ 200,000.00 | 12/31/18 | 1 week |
| EmployeeID | LastName | FirstName | BirthDate | AnnualSalary | HireDate | Department |
|---|---|---|---|---|---|---|
| 1000 | Vestering | Sam | 2/18/57 | ¤ 69,725.00 | 7/22/09 | North American Distribution |
| 1003 | Ruiz | Celesta | 3/12/75 | ¤ 41,875.00 | 8/5/09 | North American Distribution |
| 1005 | Deptulski | Roman | 3/12/48 | ¤ 72,750.00 | 8/15/09 | Overseas Distribution |
| 1013 | Chippewa | Gregg | 6/15/85 | ¤ 48,650.00 | 2/10/10 | European Distribution |
| 1015 | Brewer | Lyle | 10/15/59 | ¤ 45,651.00 | 5/17/10 | North American Distribution |
| 1020 | Doxtator | Angela | 5/22/63 | ¤ 45,558.00 | 8/3/10 | North American Distribution |
| 1023 | Bulinkski | Aleksy | 7/30/86 | ¤ 51,450.00 | 10/10/10 | European Distribution |
| 1025 | Biliski | Jorge | 6/18/70 | ¤ 44,892.00 | 12/1/10 | North American Distribution |
| 1030 | Hicks | Thom | 7/27/77 | ¤ 42,824.00 | 1/22/11 | Overseas Distribution |
| 1033 | Titov | Dina | 8/15/90 | ¤ 45,655.00 | 1/10/11 | North American Distribution |
| 1040 | Lafreniere | Guy | 9/14/72 | ¤ 45,395.00 | 3/10/12 | Overseas Distribution |
| 1043 | Morano | Enzo | 10/22/84 | ¤ 48,750.00 | 8/15/12 | North American Distribution |
| 1045 | Yiu | Terry | 6/18/61 | ¤ 42,238.00 | 1/31/13 | European Distribution |
| 1050 | Zakowski | Carl | 12/22/87 | ¤ 44,387.00 | 2/9/13 | European Distribution |
| 1053 | O'Connor | Shauna | 9/12/87 | ¤ 43,695.00 | 4/15/14 | North American Distribution |
| 1060 | McKnight | Donald | 1/6/64 | ¤ 42,126.00 | 6/22/14 | European Distribution |
| 1063 | McPhee | Charlotte | 4/16/78 | ¤ 43,695.00 | 2/6/15 | North American Distribution |
| 1065 | Liszniewski | Norm | 11/16/70 | ¤ 43,695.00 | 2/6/15 | North American Distribution |
| 1073 | Judd | Marsha | 4/29/82 | ¤ 44,771.00 | 11/30/16 | North American Distribution |
| 1080 | Couture | Leo | 1/8/78 | ¤ 43,659.00 | 1/27/17 | European Distribution |
| 1083 | Arnold | Drew | 1/27/69 | ¤ 43,659.00 | 6/22/17 | North American Distribution |
| 1085 | Armine | Yousef | 11/19/90 | ¤ 42,177.00 | 3/14/17 | European Distribution |
| 1090 | Quinte | Maria | 4/16/91 | ¤ 42,177.00 | 11/29/17 | Overseas Distribution |
| 1093 | Vaquez | Luis | 11/19/76 | ¤ 42,177.00 | 12/5/17 | North American Distribution |
| 1095 | Kilarney | Patrick | 2/27/85 | ¤ 42,177.00 | 12/12/17 | North American Distribution |
| EmployeeID | SupervisorFName | SupervisorLName | ProfDevDays | AnnualRevDate | SalaryIncDate |
|---|---|---|---|---|---|
| 1013 | Sam | Vestering | 5 | 2/10/17 | 9/1/17 |
| 1015 | Sam | Vestering | 4 | 5/17/17 | 8/1/17 |
| 1020 | Celesta | Ruiz | 8 | 8/3/18 | 10/1/18 |
| 1023 | Sam | Vestering | 6 | 10/15/18 | 11/15/18 |
| 1025 | Roman | Deptulski | 5 | 12/1/18 | 1/1/19 |
| 1030 | Roman | Deptulski | 10 | 1/22/18 | 7/22/18 |
| 1033 | Roman | Deptulski | 5 | 1/1/18 | 2/5/18 |
| 1040 | Celesta | Ruiz | 8 | 3/10/18 | 9/1/18 |
| 1043 | Roman | Deptulski | 6 | 8/15/18 | 2/1/18 |
| 1045 | Celesta | Ruiz | 6 | 1/1/18 | 2/5/18 |
| 1050 | Sam | Vestering | 5 | 2/9/18 | 4/1/17 |
| 1053 | Sam | Vestering | 8 | 4/15/17 | 6/15/17 |
| 1060 | Roman | Deptulski | 6 | 6/25/17 | 8/15/17 |
| 1063 | Celesta | Ruiz | 5 | 2/10/17 | 4/10/17 |
| 1065 | Sam | Vestering | 8 | 2/10/17 | 4/10/17 |
| 1073 | Roman | Deptulski | 5 | 11/30/17 | 1/1/18 |
| 1080 | Roman | Deptulski | 5 | 1/27/17 | 3/1/17 |
| 1083 | Celesta | Ruiz | 8 | 6/22/17 | 8/1/17 |
| 1085 | Celesta | Ruiz | 5 | 3/14/17 | 5/1/17 |
| 1090 | Sam | Vestering | 6 | 11/30/17 | 1/10/18 |
| 1093 | Sam | Vestering | 5 | 12/10/17 | 2/1/18 |
| 1095 | Celesta | Ruiz | 5 | 12/15/17 | 2/1/18 |
