Table: labor_category

Previous: journal_time

Unanet Data Model

Next: labor_category_account

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	labor_category_key	decimal(15)
2.		labor_category	varchar(50)
3.		description	varchar(2000)
4.		account_number	varchar(50)
5.		active	char(1)	('Y')

Referenced from

Table	Column	Foreign Key Name
labor_category_account	labor_category_key	fk_labor_category_account1
labor_category_assignment	labor_category_key	fk_labor_category_assignment1
labor_category_invc_fltr	labor_category_key	fk_labor_category_invc_fltr2
labor_category_rate	labor_category_key	fk_labor_category_rate1
person	labor_category_key	fk_person9
person_time_data	labor_category_key	fk_person_time_data8
person_time_data_history	labor_category_key	fk_person_time_data_history7
planned_time	labor_category_key	fk_planned_time4
project_assignment	labor_category_key	fk_project_assignment5
res_req_labor_category	labor_category_key	fk_res_req_labor_category2
task_assignment	labor_category_key	fk_task_assignment5

Check Constraints

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

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_labor_category	true	labor_category_key	Asc
idx_labor_category1	true	labor_category	Asc

Dependent Views

View Name
assignment_view