| Previous: skill_type | Unanet Data Model | Next: task_account |
| 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) | ||||
| 58. | time_assignment_flag | char(1) | ('P') | |||
| 59. | expense_assignment_flag | char(1) | ('P') | |||
| 60. | ts_sub_po_required | char(1) | ('P') | |||
| 61. | exp_sub_po_required | char(1) | ('P') | |||
| 62. | item_assignment_flag | char(1) | ('P') | |||
| 63. | user11 | varchar(128) | ||||
| 64. | user12 | varchar(128) | ||||
| 65. | user13 | varchar(128) | ||||
| 66. | user14 | varchar(128) | ||||
| 67. | user15 | varchar(128) | ||||
| 68. | user16 | varchar(128) | ||||
| 69. | user17 | varchar(128) | ||||
| 70. | user18 | varchar(128) | ||||
| 71. | user19 | varchar(128) | ||||
| 72. | user20 | varchar(128) | ||||
| 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 |
| Table | Column | Foreign Key Name |
| assignment_display | task_key | fk_assignment_display2 |
| cost_plus_post_detail | task_key | fk_cost_plus_post_detail2 |
| 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_det_proj_expense | task_key | fk_fin_doc_det_proj_expense2 |
| fin_document_det_proj_item | task_key | fk_fin_doc_det_proj_item3 |
| fin_document_det_proj_labor | task_key | fk_fin_doc_det_proj_labor3 |
| 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 |
| po_expense_assignment | task_key | fk_po_expense_assignment5 |
| po_expense_line_descriptor | task_key | fk_po_expense_line_descr7 |
| po_item_line_descriptor | task_key | fk_po_item_line_descr7 |
| po_labor_assignment | task_key | fk_po_labor_assignment5 |
| po_labor_line_descriptor | task_key | fk_po_labor_line_descr7 |
| pr_expense_line_descriptor | task_key | fk_pr_expense_line_descr6 |
| pr_item_line_descriptor | task_key | fk_pr_item_line_descr6 |
| pr_labor_line_descriptor | task_key | fk_pr_labor_line_descr6 |
| purchase_order | task_key | fk_purchase_order9 |
| purchase_requisition | task_key | fk_purchase_request8 |
| 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 |
| Name | Definition |
| cc_expense_assignment_flag | ([expense_assignment_flag]='Y' OR [expense_assignment_flag]='P' OR [expense_assignment_flag]='N') |
| 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_exp_sub_po_required | ([exp_sub_po_required]='Y' OR [exp_sub_po_required]='P' OR [exp_sub_po_required]='N') |
| cc_task_item_assignment_flag | ([item_assignment_flag]='Y' OR [item_assignment_flag]='P' OR [item_assignment_flag]='N') |
| 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') |
| cc_task_ts_sub_po_required | ([ts_sub_po_required]='Y' OR [ts_sub_po_required]='P' OR [ts_sub_po_required]='N') |
| cc_time_assignment_flag | ([time_assignment_flag]='Y' OR [time_assignment_flag]='P' OR [time_assignment_flag]='N') |
| 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 |
| View Name |
| assignment_view |
| expense_budget_view |
| journal_view |