dbo.employee
Documentation | Sample GDPR Database Documentation |
Schema | dbo |
Name | employee |
Personal Data Level | No Personal Data |
Company employees.
Columns
Key | Name | Data type | Null | Attributes | References | Description | Personal Data Level | ||
---|---|---|---|---|---|---|---|---|---|
1 | emp_id | int | Row ID | No Personal Data | |||||
Row ID Personal Data Level: No Personal Data |
|||||||||
2 | emp_no | int | Employee number | No Personal Data | |||||
Employee number Personal Data Level: No Personal Data |
|||||||||
3 | person_id | int | dbo.people | Person | No Personal Data | ||||
Person References: dbo.people Personal Data Level: No Personal Data |
|||||||||
4 | department_id | int | dbo.departments | Department person is employed in | No Personal Data | ||||
Department person is employed in References: dbo.departments Personal Data Level: No Personal Data |
|||||||||
5 | position_title | nvarchar(20) | Employee position title | No Personal Data | |||||
Employee position title Personal Data Level: No Personal Data |
|||||||||
6 | emp_from | date | Beginning of employment | No Personal Data | |||||
Beginning of employment Personal Data Level: No Personal Data |
|||||||||
7 | emp_to | date | End of employment | No Personal Data | |||||
End of employment Personal Data Level: No Personal Data |
|||||||||
8 | salary | numeric(18, 0) | Current salary | No Personal Data | |||||
Current salary Personal Data Level: No Personal Data |
Exported: 2018-12-04 20:05, Last imported: 2018-12-04 15:26