Employees

The Entity Fields custom field is available for the Employees table.

Columns

Name	Type	Length	Precision	Scale	References	In	Description
accountnumber	VARCHAR2	4000					Account number
address	VARCHAR2	999					Address
approvallimit	NUMBER		20	2			Approval limit
approver_id	NUMBER		22	0	employee_id	Employees	Approver ID
billing_class_id	NUMBER		22	0	billing_class_id	Billing_classes	Billing class
birthdate	TIMESTAMP						Birth date
city	VARCHAR2	50					City
class_id	NUMBER		22	0	class_id	Classes	Class ID
comments	VARCHAR2	4000					Comments
country	VARCHAR2	50					Country
create_date	TIMESTAMP						Create date (GMT)
date_last_modified	TIMESTAMP						Date last modified
department_id	NUMBER		22	0	department_id	Departments	Department ID
email	VARCHAR2	254					Email
employee_extid	VARCHAR2	255					Employee external ID
employee_id	NUMBER		22	0			Employee ID
employee_type_id	NUMBER		22	0	employee_type_id	Employee_types	Employee type ID
firstname	VARCHAR2	32					First name
full_name	VARCHAR2	1800					Full name
gender	VARCHAR2	3					Gender
hireddate	TIMESTAMP						Hire date
initials	VARCHAR2	3					Initials
is_in_payroll	VARCHAR2	3
isinactive	VARCHAR2	3					Is inactive
issalesrep	VARCHAR2	3					Sales rep
issupportrep	VARCHAR2	3					Support rep
jobtitle	VARCHAR2	100					Job title
labor_cost	NUMBER		22	0			Labor Cost
last_modified_date	TIMESTAMP						Date last modified (GMT)
lastname	VARCHAR2	32					Last name
lastreviewdate	TIMESTAMP						Last review date
line1	VARCHAR2	150					Address line 1
line2	VARCHAR2	150					Address line 2
line3	VARCHAR2	150					Address line 3
location_id	NUMBER		22	0	location_id	Locations	Location ID
loginaccess	VARCHAR2	3					Login access
middlename	VARCHAR2	32					Middle name
name	VARCHAR2	83					Name
nextreviewdate	TIMESTAMP						Next review date
phone	VARCHAR2	100					Phone
releasedate	TIMESTAMP						Release date
salutation	VARCHAR2	30					Salutation
socialsecuritynumber	VARCHAR2	11					Social security number
state	VARCHAR2	50					State
status	VARCHAR2	100					Employee status
subsidiary_id	NUMBER		22	0	subsidiary_id	Subsidiaries	Subsidiary ID
supervisor_id	NUMBER		22	0	employee_id	Employees	Supervisor ID
work_calendar_id	NUMBER		22	0	work_calendar_id	Work_calendars	Work calendar ID
zipcode	VARCHAR2	36					Zip code

Primary key

PK Column Name
employee_id

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
employees_billing_classes_fk	billing_class_id	Billing_classes	billing_class_id	1
employees_classes_fk	class_id	Classes	class_id	1
employees_departments_fk	department_id	Departments	department_id	1
employees_employee_types_fk	employee_type_id	Employee_types	employee_type_id	1
employees_employees_fk	approver_id	Employees	employee_id	1
employees_employees_fk_2	supervisor_id	Employees	employee_id	1
employees_locations_fk	location_id	Locations	location_id	1
employees_subsidiaries_fk	subsidiary_id	Subsidiaries	subsidiary_id	1
employees_work_calendars_fk	work_calendar_id	Work_calendars	work_calendar_id	1

Foreign keys referencing this table

FK Name	PK Column Name	FK Table Name	FK Column Name	Key Seq
Employees_employees_fk	employee_id	Employees	approver_id	1
Employees_employees_fk_2	employee_id	Employees	supervisor_id	1
Project_revenue_rules_employees_fk_1	employee_id	Project_revenue_rules	created_by	1
Project_revenue_rules_employees_fk_2	employee_id	Project_revenue_rules	last_modified_by	1