Table: project_type

Previous: project_status

Unanet Data Model

Next: project_type_account

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	project_type_key	decimal(15)
2.		project_type	varchar(10)
3.		description	varchar(100)
4.		administrative	char(1)
5.		billable	char(1)
6.		active	char(1)	('Y')
7.		last_project_code_seq	decimal(15)	((0))
8.		start_with_project_code_seq	decimal(15)	((1))

Referenced from

Table	Column	Foreign Key Name
expense_data	project_type_key	fk_expense_data7
expense_data_allocation	project_type_key	fk_expense_data_allocation6
fin_document_det_proj_expense	project_type_key	fk_fin_doc_det_proj_expense4
fin_document_det_proj_item	project_type_key	fk_fin_doc_det_proj_item4
fin_document_det_proj_labor	project_type_key	fk_fin_doc_det_proj_labor4
person_time_data	project_type_key	fk_person_time_data4
person_time_data_history	project_type_key	fk_person_time_data_history4
project	project_type_key	fk_project3
project_type_account	project_type_key	fk_project_type_account1
project_type_exp_type_acct	project_type_key	fk_project_type_exp_type_acct1
task	project_type_key	fk_task3

Check Constraints

Name	Definition
cc_pjtt_active	([active]='N' OR [active]='Y')
cc_pjtt_administrative	([administrative]='N' OR [administrative]='Y')
cc_pjtt_billable	(([billable]='N' OR [billable]='Y') AND [billable] IS NOT NULL)

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_project_type	true	project_type_key	Asc
idx_project_type1	true	project_type	Asc