HR.PER (People) - HR

Box Inc - Enterprise Data Catalog

Documentation	HR
Schema	HR
Name	PER
Title	People
Module	HR

Table holds people. Every person is only once.

Columns

		Key	Name	Data type	Null	Attributes	References	Description	Data Owner	Sensitive
	1		PER_ID	int				Table primary key	HR
Table primary key Data Owner: HR
	2		F_NAME (First name)	nvarchar(50)				Person first name	HR	Y
Person first name Data Owner: HR Sensitive: Y
	3		L_NAME (Last name)	nvarchar(50)				Person last name	HR	Y
Person last name Data Owner: HR Sensitive: Y
	4		EMAIL	nvarchar(50)				Business email	HR	Y
Business email Data Owner: HR Sensitive: Y
	5		PHONE	nvarchar(15)				Business phone number	HR	Y
Business phone number Data Owner: HR Sensitive: Y
	6		DOB	date				Date of birth	HR	Y
Date of birth Data Owner: HR Sensitive: Y
	7		EDU	nvarchar(50)				Education level as in ISCED 2011 (0-8)	HR	Y
Education level as in ISCED 2011 (0-8) Data Owner: HR Sensitive: Y

Relations

Foreign table		Primary table	Join	Title / Name / Description
HR.CURR_EMP (Current employees)		HR.PER (People)		User-defined relation
Name: User-defined relation
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

Unique keys

	Key name	Columns	Description
	PK_per	PER_ID

Used by

Name
HR.PER (People)
HR.EMP (Employees)
HR.CURR_EMP (Current employees)

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