Table: employee_type

Previous: email_template

Unanet Data Model

Next: employee_type_account

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	employee_type_key	decimal(15)
2.		employee_type_code	varchar(25)
3.		description	varchar(128)
4.		active	char(1)

Referenced from

Table	Column	Foreign Key Name
employee_type_account	employee_type_key	fk_employee_type_account1
employee_type_expense_type	employee_type_key	fk_employee_type_expense_type1
employee_type_pay_code	employee_type_key	fk_employee_type_pay_code1
person	employee_type_key	fk_person13

Check Constraints

Name	Definition
cc_employee_type_active	([active]='N' OR [active]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_employee_type	true	employee_type_key	Asc
idx_employee_type1	true	employee_type_code	Asc