Table: project

Columns
		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	project_key	decimal(15)
2.		customer_key	decimal(15)		customer	fk_project1
3.		owning_customer_key	decimal(15)		customer	fk_project6
4.		project_code	varchar(30)
5.		account_number	varchar(128)
6.		title	varchar(2000)
7.		purpose	varchar(2000)
8.		pay_code_key	decimal(15)		pay_code	fk_project5
9.		project_type_key	decimal(15)		project_type	fk_project3
10.		project_status_key	decimal(15)		project_status	fk_project4
11.		billing_type_key	decimal(15)		billing_type	fk_project7
12.		posting_group_key	decimal(15)		posting_group	fk_project11
13.		cost_struct_key	decimal(15)		cost_struct	fk_project8
14.		orig_start_date	datetime
15.		orig_end_date	datetime
16.		rev_start_date	datetime
17.		rev_end_date	datetime
18.		completed_date	datetime
19.		total_value	decimal(15,2)
20.		funded_value	decimal(15,2)
21.		hours_budget	decimal(15,2)
22.		hours_etc	decimal(15,2)
23.		hours_est_tot	decimal(15,2)
24.		exp_bill_budget	decimal(15,2)
25.		exp_cost_budget	decimal(15,2)
26.		exp_cost_burden_budget	decimal(15,2)
27.		exp_bill_etc	decimal(15,2)
28.		exp_cost_etc	decimal(15,2)
29.		exp_bill_est_tot	decimal(15,2)
30.		exp_cost_est_tot	decimal(15,2)
31.		labor_bill_budget	decimal(15,2)
32.		labor_cost_budget	decimal(15,2)
33.		labor_cost_burden_budget	decimal(15,2)
34.		labor_bill_etc	decimal(15,2)
35.		labor_cost_etc	decimal(15,2)
36.		labor_bill_est_tot	decimal(15,2)
37.		labor_cost_est_tot	decimal(15,2)
38.		assignment_flag	char(1)
39.		expense_assignment_flag	char(1)
40.		time_assignment_flag	char(1)	('Y')
41.		task_level_assignment	char(1)	('N')
42.		allow_self_plan	char(1)	('C')
43.		self_assign_plans	char(1)	('N')
44.		er_task_required	char(1)
45.		ts_task_required	char(1)
46.		future_charge	char(1)
47.		tito_required	char(1)	('N')
48.		created	datetime
49.		probability_percent	decimal(3)	((100))
50.		percent_complete	decimal(6,3)
51.		bill_rate_source	char(1)	('P')
52.		cost_rate_source	char(1)	('P')
53.		use_labor_category	char(1)	('O')
54.		enforce_wbs_dates	char(1)	('N')
55.		leave_balance	char(1)	('N')
56.		customer_approves_first	char(1)	('N')
57.		pct_complete_rule	char(1)	('H')
58.		project_color	varchar(16)	('green')
59.		proj_require_time_comments	char(1)
60.		location_required	char(1)	('N')
61.		location_key	decimal(15)		location	fk_project10
62.		limit_bill_to_funded	char(1)	('N')
63.		limit_rev_to_funded	char(1)	('N')
64.		user01	varchar(128)
65.		user02	varchar(128)
66.		user03	varchar(128)
67.		user04	varchar(128)
68.		user05	varchar(128)
69.		user06	varchar(128)
70.		user07	varchar(128)
71.		user08	varchar(128)
72.		user09	varchar(128)
73.		user10	varchar(128)
74.		ts_sub_po_required	char(1)	('N')
75.		exp_sub_po_required	char(1)	('N')
76.		item_assignment_flag	char(1)	('N')
77.		item_task_required	char(1)	('N')
78.		pm_approves_before_mgr	char(1)
79.		user11	varchar(128)
80.		user12	varchar(128)
81.		user13	varchar(128)
82.		user14	varchar(128)
83.		user15	varchar(128)
84.		user16	varchar(128)
85.		user17	varchar(128)
86.		user18	varchar(128)
87.		user19	varchar(128)
88.		user20	varchar(128)

Foreign Keys
Column	References		Foreign Key Name
Column	Table	Column	Foreign Key Name
billing_type_key	billing_type	billing_type_key	fk_project7
cost_struct_key	cost_struct	cost_struct_key	fk_project8
customer_key	customer	customer_key	fk_project1
owning_customer_key	customer	customer_key	fk_project6
location_key	location	location_key	fk_project10
pay_code_key	pay_code	pay_code_key	fk_project5
posting_group_key	posting_group	posting_group_key	fk_project11
project_status_key	project_status	project_status_key	fk_project4
project_type_key	project_type	project_type_key	fk_project3

Referenced from
Table	Column	Foreign Key Name
approval_history	project_key	fk_approval_history3
assignment_display	project_key	fk_assignment_display1
cost_plus_post_detail	project_key	fk_cost_plus_post_detail1
customer_assignment	project_key	fk_customer_assignment2
exp_cust_approval_status	project_key	fk_exp_cust_approval_status2
expense_data_allocation	project_key	fk_expense_data_allocation2
expense_history	project_key	fk_expense_history4
expense_plan	project_key	fk_expense_plan1
expense_pm_approval_status	project_key	fk_expense_pm_approval_status2
expense_project_allocation	project_key	fk_expense_project_allocation2
expense_project_budget	project_key	fk_expense_project_budget1
expense_task_budget	project_key	fk_expense_task_budget1
fee_cap_adjustment	project_key	fk_fee_cap_adjustment1
fin_document_approval	project_key	fk_fd_approval4
fin_document_det_proj_expense	project_key	fk_fin_doc_det_proj_expense1
fin_document_det_proj_item	project_key	fk_fin_doc_det_proj_item2
fin_document_det_proj_labor	project_key	fk_fin_doc_det_proj_labor2
fixed_price	project_key	fk_fixed_price1
funding_cap_adjustment	project_key	fk_funding_cap_adjustment1
general_ledger	project_key	fk_general_ledger4
holiday	project_key	fk_holiday1
invcd_project	project_key	fk_invcd_project2
invoice	project_key	fk_invoice1
journal_cost_plus_detail	project_key	fk_journal_cost_plus_detail3
journal_document_expense	project_key	fk_journal_document_expense3
journal_document_item	project_key	fk_journal_document_item3
journal_document_labor	project_key	fk_journal_document_labor3
journal_expense	project_key	fk_journal_expense3
journal_fee_cap_adjustment	project_key	fk_journal_fee_cap_adjust3
journal_fixed_price	project_key	fk_journal_fixed_price3
journal_funding_cap_adjustment	project_key	fk_journal_funding_cap_adj3
journal_onetime_charge	project_key	fk_journal_onetime_charge3
journal_prebilled_labor	project_key	fk_journal_prebilled_labor3
journal_time	project_key	fk_journal_time3
labor_category_assignment	project_key	fk_labor_category_assignment2
manager_approval_status	project_key	fk_manager_approval_status2
onetime_charge	project_key	fk_onetime_charge1
person	project_key	fk_person7
person_accrual	project_key	fk_person_accrual3
person_accrual_plan	project_key	fk_person_accrual_plan3
person_time_data	project_key	fk_person_time_data3
person_time_data_history	project_key	fk_person_time_data_history3
plan_set	project_key	fk_plan_set2
planned_time	project_key	fk_planned_time2
po_cust_approval_status	project_key	fk_po_cust_approval_status2
po_expense_assignment	project_key	fk_po_expense_assignment4
po_expense_line_descriptor	project_key	fk_po_expense_line_descr6
po_item_line_descriptor	project_key	fk_po_item_line_descr6
po_labor_assignment	project_key	fk_po_labor_assignment4
po_labor_line_descriptor	project_key	fk_po_labor_line_descr6
po_pm_approval_status	project_key	fk_po_pm_approval_status2
pr_cust_approval_status	project_key	fk_pr_cust_approval_status2
pr_expense_line_descriptor	project_key	fk_pr_expense_line_descr5
pr_item_line_descriptor	project_key	fk_pr_item_line_descr5
pr_labor_line_descriptor	project_key	fk_pr_labor_line_descr5
pr_pm_approval_status	project_key	fk_pr_pm_approval_status2
prebilled_labor	project_key	fk_prebilled_labor1
project_account	project_key	fk_project_account2
project_alert	project_key	fk_project_alert1
project_alert_prefs	project_key	fk_project_alert_prefs1
project_assignment	project_key	fk_project_assignment2
project_budget_history	project_key	fk_project_budget_history2
project_budget_snapshot	project_key	fk_project_budget_snapshot1
project_controller	project_key	fk_project_controller1
project_criteria_set	project_key	fk_project_criteria_set2
project_expense_type	project_key	fk_project_expense_type1
project_fee	project_key	fk_project_fee1
project_invoice	project_key	fk_project_invoice1
project_invoice_addl_fmt	project_key	fk_project_invoice_addl_fmt1
project_invoice_contributor	contr_project_key	fk_project_invoice_contr2
project_invoice_contributor	lead_project_key	fk_project_invoice_contr1
project_item	project_key	fk_project_item2
project_location	project_key	fk_project_location1
project_note	project_key	fk_project_note1
project_pay_code	project_key	fk_project_pay_code1
project_post_history	project_key	fk_project_post_history1
project_restrict_access	project_key	fk_project_restrict_access1
purchase_order	project_key	fk_purchase_order8
purchase_order_approval	project_key	fk_po_approval4
purchase_requisition	project_key	fk_purchase_request7
purchase_requisition_approval	project_key	fk_pr_approval4
resource_request	project_key	fk_resource_request3
shared_document	project_key	fk_shared_document5
task	project_key	fk_task2
task_alert	project_key	fk_task_alert1
task_assignment	project_key	fk_task_assignment2
task_budget_history	project_key	fk_task_budget_history2
task_budget_snapshot	project_key	fk_task_budget_snapshot1
time_cust_approval_status	project_key	fk_time_cust_approval_status2
vi_cust_approval_status	project_key	fk_vi_cust_approval_status2
vi_pm_approval_status	project_key	fk_vi_pm_approval_status2

Check Constraints
Name	Definition
cc_enforce_wbs_dates	([enforce_wbs_dates]='N' OR [enforce_wbs_dates]='Y')
cc_exp_sub_po_required	([exp_sub_po_required]='N' OR [exp_sub_po_required]='Y')
cc_item_assignment_flag	([item_assignment_flag]='N' OR [item_assignment_flag]='Y')
cc_item_task_required	([item_task_required]='N' OR [item_task_required]='Y')
cc_leave_balance	([leave_balance]='N' OR [leave_balance]='Y')
cc_limit_bill_to_funded	([limit_bill_to_funded]='N' OR [limit_bill_to_funded]='Y')
cc_limit_rev_to_funded	([limit_rev_to_funded]='N' OR [limit_rev_to_funded]='Y')
cc_pjt_assignment_flag	([assignment_flag]='N' OR [assignment_flag]='Y')
cc_pjt_bill_rate_source	([bill_rate_source]='L' OR [bill_rate_source]='P')
cc_pjt_cost_rate_source	([cost_rate_source]='L' OR [cost_rate_source]='P')
cc_pjt_cust_appr_first	([customer_approves_first]='N' OR [customer_approves_first]='Y')
cc_pjt_loc_reqd	([location_required]='N' OR [location_required]='Y')
cc_pjt_pct_complete_rule	([pct_complete_rule]='T' OR [pct_complete_rule]='L' OR [pct_complete_rule]='H')
cc_pjt_time_assignment_flag	([time_assignment_flag]='N' OR [time_assignment_flag]='Y')
cc_pjt_use_labor_category	([use_labor_category]='O' OR [use_labor_category]='N' OR [use_labor_category]='Y')
cc_pm_approves_before_mgr	([pm_approves_before_mgr]='N' OR [pm_approves_before_mgr]='Y')
cc_prj_er_task_required	(([er_task_required]='N' OR [er_task_required]='Y') AND [er_task_required] IS NOT NULL)
cc_prj_ts_task_required	(([ts_task_required]='N' OR [ts_task_required]='Y') AND [ts_task_required] IS NOT NULL)
cc_project_color	([project_color]='red' OR [project_color]='yellow' OR [project_color]='green')
cc_project_completed_date	([completed_date]>='1900-01-01' AND [completed_date]<='2099-12-31')
cc_project_orig_end_date	([orig_end_date]>='1900-01-01' AND [orig_end_date]<='2099-12-31')
cc_project_orig_start_date	([orig_start_date]>='1900-01-01' AND [orig_start_date]<='2099-12-31')
cc_project_rev_end_date	([rev_end_date]>='1900-01-01' AND [rev_end_date]<='2099-12-31')
cc_project_rev_start_date	([rev_start_date]>='1900-01-01' AND [rev_start_date]<='2099-12-31')
cc_project_task_level	([task_level_assignment]='Y' AND [er_task_required]='Y' AND [ts_task_required]='Y' OR [task_level_assignment]='N')
cc_project_tito_required	([tito_required]='U' OR [tito_required]='Y' OR [tito_required]='N')
cc_self_plan	([allow_self_plan]='O' OR [allow_self_plan]='C' OR [allow_self_plan]='A')
cc_ts_sub_po_required	([ts_sub_po_required]='N' OR [ts_sub_po_required]='Y')

Indices
Index Name	Unique	Column Name	Asc Or Desc
pk_project	true	project_key	Asc
idx_project1	true	customer_key	Asc
		project_code
idx_project2	false	project_status_key	Asc
idx_project3	false	assignment_flag	Asc

Dependent Views
View Name
assignment_view
expense_budget_view
journal_view
project_approval_view
project_open_access_view