Table: task

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK task_key decimal(15)      
2.   project_key decimal(15)   project fk_task2
3.   task_id int      
4.   parent_task decimal(15)   task fk_task1
5.   task_name varchar(50)      
6.   orig_start_date datetime      
7.   orig_end_date datetime      
8.   rev_start_date datetime      
9.   rev_end_date datetime      
10.   funded_value decimal(15,2)      
11.   limit_bill_to_funded char(1) ('N')    
12.   limit_rev_to_funded char(1) ('N')    
13.   hours_budget decimal(15,2)      
14.   hours_etc decimal(15,2)      
15.   hours_est_tot decimal(15,2)      
16.   exp_bill_budget decimal(15,2)      
17.   exp_cost_budget decimal(15,2)      
18.   exp_cost_burden_budget decimal(15,2)      
19.   exp_bill_etc decimal(15,2)      
20.   exp_cost_etc decimal(15,2)      
21.   exp_bill_est_tot decimal(15,2)      
22.   exp_cost_est_tot decimal(15,2)      
23.   labor_bill_budget decimal(15,2)      
24.   labor_cost_budget decimal(15,2)      
25.   labor_cost_burden_budget decimal(15,2)      
26.   labor_bill_etc decimal(15,2)      
27.   labor_cost_etc decimal(15,2)      
28.   labor_bill_est_tot decimal(15,2)      
29.   labor_cost_est_tot decimal(15,2)      
30.   output varchar(50)      
31.   status varchar(50)      
32.   completed datetime      
33.   url varchar(128)      
34.   active char(1)      
35.   alertable char(1) ('N')    
36.   account_code varchar(64)      
37.   sequence int      
38.   task_number varchar(128)      
39.   indent_level int      
40.   left_visit decimal(15)      
41.   right_visit decimal(15)      
42.   duration decimal(5)      
43.   percent_complete decimal(6,3)      
44.   external_id decimal(15)      
45.   project_type_key decimal(15)   project_type fk_task3
46.   billing_type_key decimal(15)   billing_type fk_task4
47.   owning_customer_key decimal(15)   customer fk_task5
48.   user01 varchar(128)      
49.   user02 varchar(128)      
50.   user03 varchar(128)      
51.   user04 varchar(128)      
52.   user05 varchar(128)      
53.   user06 varchar(128)      
54.   user07 varchar(128)      
55.   user08 varchar(128)      
56.   user09 varchar(128)      
57.   user10 varchar(128)      
Foreign Keys
Column References Foreign Key Name
Table Column
billing_type_key billing_type billing_type_key fk_task4
owning_customer_key customer customer_key fk_task5
project_key project project_key fk_task2
project_type_key project_type project_type_key fk_task3
parent_task task task_key fk_task1
Referenced from
Table Column Foreign Key Name
assignment_display task_key fk_assignment_display2
expense_data_allocation task_key fk_expense_data_allocation3
expense_plan task_key fk_expense_plan2
expense_project_allocation task_key fk_expense_project_allocation3
expense_task_budget task_key fk_expense_task_budget2
fin_document_detail_project task_key fk_fin_doc_detail_project2
fixed_price task_key fk_fixed_price2
funding_cap_adjustment task_key fk_funding_cap_adjustment2
holiday task_key fk_holiday2
onetime_charge task_key fk_onetime_charge4
person task_key fk_person8
person_accrual task_key fk_person_accrual4
person_accrual_plan task_key fk_person_accrual_plan4
person_time_data task_key fk_person_time_data5
person_time_data_history task_key fk_person_time_data_history5
planned_time task_key fk_planned_time3
resource_request task_key fk_resource_request4
task parent_task fk_task1
task_account task_key fk_task_account1
task_alert task_key fk_task_alert2
task_assignment task_key fk_task_assignment6
task_budget_history task_key fk_task_budget_history3
task_budget_snapshot task_key fk_task_budget_snapshot2
task_depends predecessor_key fk_task_depends1
task_depends successor_key fk_task_depends2
Check Constraints
Name Definition
cc_task_active ([active]='N' OR [active]='Y')
cc_task_alertable ([alertable]='N' OR [alertable]='Y')
cc_task_completed ([completed]>='1900-01-01' AND [completed]<='2099-12-31')
cc_task_limit_bill_to_funded ([limit_bill_to_funded]='N' OR [limit_bill_to_funded]='Y')
cc_task_limit_rev_to_funded ([limit_rev_to_funded]='N' OR [limit_rev_to_funded]='Y')
cc_task_orig_end_date ([orig_end_date]>='1900-01-01' AND [orig_end_date]<='2099-12-31')
cc_task_orig_start_date ([orig_start_date]>='1900-01-01' AND [orig_start_date]<='2099-12-31')
cc_task_rev_end_date ([rev_end_date]>='1900-01-01' AND [rev_end_date]<='2099-12-31')
cc_task_rev_start_date ([rev_start_date]>='1900-01-01' AND [rev_start_date]<='2099-12-31')
Indices
Index Name Unique Column Name Asc Or Desc
pk_task true task_key Asc
idx_task1 false project_key Asc
idx_task2 false parent_task Asc
idx_task3 false project_type_key Asc
idx_task4 false billing_type_key Asc
idx_task5 false owning_customer_key Asc
Dependent Views
View Name
assignment_view
expense_budget_view
journal_view