HR.EMP (Employees) - HR - HR

Box Inc - Enterprise Data Catalog

Documentation	HR
Schema	HR
Name	EMP
Title	Employees
Module	HR

Table hods current and past employments. One person may have multiple employments.

Columns

		Key	Name	Data type	Null	Attributes	References	Description	Data Owner	Sensitive
	1		EMP_ID	int				Table primary key	HR/Admin
Table primary key Data Owner: HR/Admin
	2		EMP_NO	int				Employee unique number	HR/Admin
Employee unique number Data Owner: HR/Admin
	3		PER_ID	int			HR.PER (People)	Person	HR/Admin
Person References: HR.PER (People) Data Owner: HR/Admin
	4		DEPT_ID	int			HR.DEPT (Departments)	Department employee is assigned to	HR/Admin
Department employee is assigned to References: HR.DEPT (Departments) Data Owner: HR/Admin
	5		POS_TITLE	nvarchar(20)				Employee position tilte	VP HR	Y
Employee position tilte Data Owner: VP HR Sensitive: Y
	6		FROM	date				Employment start date	VP HR	Y
Employment start date Data Owner: VP HR Sensitive: Y
	7		TO	date				Employment end date or null	VP HR	Y
Employment end date or null Data Owner: VP HR Sensitive: Y
	8		SALARY	numeric(18, 0)				Current or last salary	HR/Payroll	Y
Current or last salary Data Owner: HR/Payroll Sensitive: Y

Relations

Foreign table		Primary table	Join	Title / Name / Description
HR.EMP (Employees)		HR.DEPT (Departments)	HR.EMP.DEPT_ID = HR.DEPT.DEPT_ID	FK_emp_dept
HR.EMP.DEPT_ID = HR.DEPT.DEPT_ID Name: FK_emp_dept
HR.EMP (Employees)		HR.PER (People)	HR.EMP.PER_ID = HR.PER.PER_ID	FK_emp_per
HR.EMP.PER_ID = HR.PER.PER_ID Name: FK_emp_per
Access control.CAR (Cards)		HR.EMP (Employees)	Access control.CAR.EMP_NO = HR.EMP.INF1	User-defined relation
Access control.CAR.EMP_NO = HR.EMP.INF1 Name: User-defined relation
CRM.dbo.contacts		HR.EMP (Employees)	CRM.dbo.contacts.EMP_NO = HR.EMP.employee_number	User-defined relation
CRM.dbo.contacts.EMP_NO = HR.EMP.employee_number Name: User-defined relation
HR.DEPT (Departments)		HR.EMP (Employees)	HR.DEPT.MAN_ID = HR.EMP.EMP_ID	FK_dept_emp
HR.DEPT.MAN_ID = HR.EMP.EMP_ID Name: FK_dept_emp
Products.dbo.products		HR.EMP (Employees)	Products.dbo.products.EMP_NO = HR.EMP.manager_no	Manager User-defined relation
Products.dbo.products.EMP_NO = HR.EMP.manager_no Title: Manager Name: User-defined relation
Procurement.pur.requisitions (Header)		HR.EMP (Employees)	Procurement.pur.requisitions.EMP_NO = HR.EMP.attribute3	User-defined relation
Procurement.pur.requisitions.EMP_NO = HR.EMP.attribute3 Name: User-defined relation
Time tracking.RES (Resources)		HR.EMP (Employees)	Time tracking.RES.EMP_NO = HR.EMP.EMPNO	User-defined relation
Time tracking.RES.EMP_NO = HR.EMP.EMPNO Name: User-defined relation

Unique keys

	Key name	Columns	Description
	PK_emp	EMP_ID

	UK_EMP	EMP_NO

Uses

Name
HR.EMP (Employees)
HR.DEPT (Departments)
HR.PER (People)

Used by

Name
HR.EMP (Employees)
HR.CURR_EMP (Current employees)
Access control.CAR (Cards)
CRM.dbo.contacts
HR.DEPT (Departments)
Procurement.pur.requisitions (Header)
Products.dbo.products (Manager)
Time tracking.RES (Resources)

Exported: 2019-02-04 23:17, Last imported: 2018-02-09 20:22